APPS.MSC_PURGE_LID dependencies on MSC_RESOURCE_REQUIREMENTS

Line 768: DELETE_MSC_TABLE( 'MSC_RESOURCE_REQUIREMENTS', v_instance_id, -1);

764:
765: DELETE_MSC_TABLE( 'MSC_RESOURCE_SHIFTS', v_instance_id, NULL);
766: DELETE_MSC_TABLE( 'MSC_RESOURCE_CHANGES', v_instance_id, NULL);
767: DELETE_MSC_TABLE( 'MSC_SIMULATION_SETS', v_instance_id, NULL);
768: DELETE_MSC_TABLE( 'MSC_RESOURCE_REQUIREMENTS', v_instance_id, -1);
769:
770:
771: --------------- DELETE PROJECT/TASK----------------------------------
772: DELETE_MSC_TABLE( 'MSC_PROJECTS', v_instance_id, -1);

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 1195: DELETE FROM MSC_RESOURCE_REQUIREMENTS

1191: LOOP
1192: FETCH C11 INTO lv_supplyId ;
1193: EXIT WHEN C11%NOTFOUND;
1194:
1195: DELETE FROM MSC_RESOURCE_REQUIREMENTS
1196: WHERE plan_id = -1 and
1197: sr_instance_id = v_instance_id and
1198: SUPPLY_ID = lv_supplyId ;
1199:

Line 1609: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RESOURCE_REQUIREMENTS', p_instance_id, NULL);

1605: ---------------- SUPPLY -------------
1606: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIES', p_instance_id, NULL);
1607: COMMIT;
1608: ---------------- RESOURCE REQUIREMENT -------------
1609: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RESOURCE_REQUIREMENTS', p_instance_id, NULL);
1610: COMMIT;
1611: ---------------- TRADING PARTNER -------------
1612: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_TRADING_PARTNERS', p_instance_id, NULL);
1613: COMMIT;