APPS.MSC_PURGE_LID dependencies on MSC_DESIGNATORS

Line 925: UPDATE MSC_DESIGNATORS

921: -- No deltion in LID
922:
923: ------------------DELETE Designator-----------------------------------------
924:
925: UPDATE MSC_DESIGNATORS
926: SET DISABLE_DATE= v_current_date,
927: LAST_UPDATE_DATE= v_current_date,
928: LAST_UPDATED_BY= v_current_user
929: WHERE SR_INSTANCE_ID= v_instance_id

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

1531: ---------------- SAFETY STOCK-------------
1532: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SAFETY_STOCKS', p_instance_id, NULL);
1533: COMMIT;
1534: ---------------- SCHEDULE DESIGNATOR -------------
1535: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_DESIGNATORS', p_instance_id, NULL);
1536: COMMIT;
1537: ---------------- SOURCING -------------
1538: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ASSIGNMENT_SETS', p_instance_id, NULL);
1539: COMMIT;