EAM Asset Number activity association creation API

API used for to maintain asset in proper manner during work order generation.
After generating work order for an asset . Users will follow the asset activities for an asset as per insertion of data.


create table XX_ASSET_ACT_ASC_TBL(activity_name varchar2(40),asset_number varchar2(30),serial_number varchar2(30),organition_id number,activity_id number,
inventory_item_id number,department_id number,error_flag varchar2(1),error_msg varchar2(1000))

declare
l_last_service_tbl eam_pm_last_service_pub.pm_last_service_tbl;
l_return_status VARCHAR2(240) ;
l_msg_count NUMBER ;
l_msg_data VARCHAR2(240);
cursor c1 is select rowid,e.* from XX_ASSET_ACT_ASC_TBL e where error_flag is null;
begin
–open c1 ;
–loop
–fetch c1 into CUR ;
–exit when c1%NOTFOUND ;
— l_last_service_tbl(1).meter_id := 2 ;
— l_last_service_tbl(1).LAST_SERVICE_READING := NULL ;
— l_last_service_tbl(1).PREV_SERVICE_READING := NULL ;
— l_last_service_tbl(1).WIP_ENTITY_ID := NULL ;
for r1 in c1 loop
eam_item_activities_pub.insert_item_activities (
p_api_version                 => 1,
x_return_status               => l_return_status ,
x_msg_count                   => l_msg_count ,
x_msg_data                    => l_msg_data ,
p_tmpl_flag                   => ‘N’ ,
p_asset_activity_id           => r1.ACTIVITY_ID,—112373,–CUR.Asset_Activity_ID,
P_Inventory_Item_ID           => r1.INVENTORY_ITEM_ID,–109585,–asset group inventory_item_id –CUR.Inventory_Item_ID ,
p_Organization_ID             => r1.ORGANITION_ID,–104,–CUR.Organization_ID ,
P_Owningdepartment_ID         => r1.DEPARTMENT_ID,–1,–CUR.Owning_Dep_ID ,
p_start_date_active           => sysdate,–CUR.start_date_active,
p_end_date_active             => null,–CUR.end_date_active,
p_Priority_Code               => null,–CUR.Priority_Code,
p_Activity_cause_code         => null,–CUR.Activity_cause_code,
p_Activity_Type_Code          => null,–.Activity_Type_Code,
p_Shutdown_Type_Code          => null,–CUR.Shutdown_Type_Code,
p_Class_Code                  => null,–CUR.WIP_Class_Code,
p_Activity_Source_Code        => null,–CUR.Activity_Source_Code,
p_Serial_Number               => r1.SERIAL_NUMBER,–‘5017’,–CUR.Serial_Number,
p_Tagging_Required_Flag       => null,–CUR.Tagging_Required_Flag,
p_pm_last_service_tbl         => l_last_service_tbl
) ;
dbms_output.put_line(l_return_status);
dbms_output.put_line(l_msg_count);
dbms_output.put_line(l_msg_data);
for i in 1..nvl(l_msg_count,0) loop
dbms_output.put_line(Fnd_Msg_Pub.Get(i, Fnd_Api.G_FALSE ));
end loop;
end loop;
commit;
end ;
/
  • September 24, 2018 | 16 views