eam_pmdef_pub.update_pm_def not able to update multiple activity
CREATE OR REPLACE PROCEDURE APPS.abc_EAM__PM_UPDATEPMS (
ERRBUF OUT VARCHAR2,
RETCODE OUT VARCHAR2
)
IS
CURSOR c1(p_sch_id number)
IS
SELECT pm.PM_SCHEDULE_ID,cii.instance_number "ASSET_NUMBER",
pm.NAME,cii.inventory_item_id, pm.RESCHEDULING_POINT,
decode(pm.type_code,10,'Rule Based',20,'List Based') r_type
FROM APPS.EAM_PM_SCHEDULINGS PM,csi_item_instances cii,mtl_system_items_vl msik
WHERE pm.maintenance_object_id = cii.instance_id
AND msik.organization_id = cii.last_vld_organization_id
AND msik.inventory_item_id = cii.inventory_item_id
AND nvl(cii.active_start_date, sysdate - 1) <= sysdate