APPS.MSC_PURGE_LID dependencies on MSC_JOB_REQUIREMENT_OPS

Line 993: DELETE_MSC_TABLE('MSC_JOB_REQUIREMENT_OPS', v_instance_id, -1);

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:
997: ELSE -- if not complete refresh

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 1215: DELETE FROM MSC_JOB_REQUIREMENT_OPS

1211: WHERE plan_id = -1 and
1212: sr_instance_id = v_instance_id and
1213: TRANSACTION_ID = lv_supplyId;
1214:
1215: DELETE FROM MSC_JOB_REQUIREMENT_OPS
1216: WHERE plan_id = -1 and
1217: sr_instance_id = v_instance_id and
1218: TRANSACTION_ID = lv_supplyId;
1219: