APPS.MSC_PURGE_LID dependencies on MSC_DESIGNATORS

Line 912: UPDATE MSC_DESIGNATORS

908: -- No deltion in LID
909:
910: ------------------DELETE Designator-----------------------------------------
911:
912: UPDATE MSC_DESIGNATORS
913: SET DISABLE_DATE= v_current_date,
914: LAST_UPDATE_DATE= v_current_date,
915: LAST_UPDATED_BY= v_current_user
916: WHERE SR_INSTANCE_ID= v_instance_id

Line 1577: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_DESIGNATORS', p_instance_id, NULL);

1573: ---------------- SAFETY STOCK-------------
1574: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SAFETY_STOCKS', p_instance_id, NULL);
1575: COMMIT;
1576: ---------------- SCHEDULE DESIGNATOR -------------
1577: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_DESIGNATORS', p_instance_id, NULL);
1578: COMMIT;
1579: ---------------- SOURCING -------------
1580: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ASSIGNMENT_SETS', p_instance_id, NULL);
1581: COMMIT;