APPS.MSC_PURGE_LID dependencies on MSC_JOB_OPERATIONS

Line 992: DELETE_MSC_TABLE('MSC_JOB_OPERATIONS', v_instance_id, -1);

988:
989: -------- Delete OSFM tables ---------------------------
990:
991: DELETE_MSC_TABLE('MSC_JOB_OPERATION_NETWORKS', v_instance_id, -1);
992: DELETE_MSC_TABLE('MSC_JOB_OPERATIONS', v_instance_id, -1);
993: DELETE_MSC_TABLE('MSC_JOB_REQUIREMENT_OPS', v_instance_id, -1);
994: DELETE_MSC_TABLE('MSC_JOB_OP_RESOURCES', v_instance_id, -1);
995:
996:

Line 1187: msc_st_util.log_message('Delete from MSC_RESOURCE_REQUIREMENTS,MSC_JOB_OPERATIONS,MSC_JOB_OP_RESOURCES,MSC_JOB_REQUIREMENT_OPS for delted supply Id');

1183: lv_total := 0;
1184: v_sql_stmt := 05;
1185:
1186: IF V_DEBUG THEN
1187: msc_st_util.log_message('Delete from MSC_RESOURCE_REQUIREMENTS,MSC_JOB_OPERATIONS,MSC_JOB_OP_RESOURCES,MSC_JOB_REQUIREMENT_OPS for delted supply Id');
1188: END IF;
1189:
1190: OPEN C11(v_instance_id);
1191: LOOP

Line 1200: DELETE FROM MSC_JOB_OPERATIONS

1196: WHERE plan_id = -1 and
1197: sr_instance_id = v_instance_id and
1198: SUPPLY_ID = lv_supplyId ;
1199:
1200: DELETE FROM MSC_JOB_OPERATIONS
1201: WHERE plan_id = -1 and
1202: sr_instance_id = v_instance_id and
1203: TRANSACTION_ID = lv_supplyId;
1204: