APPS.MSC_RESTORE_FIRM_PO dependencies on MSC_RESOURCE_REQUIREMENTS

Line 33: DELETE FROM MSC_RESOURCE_REQUIREMENTS

29:
30: BEGIN
31:
32: BEGIN
33: DELETE FROM MSC_RESOURCE_REQUIREMENTS
34: WHERE (PLAN_ID, TRANSACTION_ID, SR_INSTANCE_ID) IN
35: (SELECT PLAN_ID, TRANSACTION_ID, SR_INSTANCE_ID
36: FROM MSC_STORE_RESOURCE_REQS
37: WHERE plan_id = lv_plan_id)

Line 41: INSERT INTO MSC_RESOURCE_REQUIREMENTS(

37: WHERE plan_id = lv_plan_id)
38: AND plan_id = lv_plan_id;
39: LOG_MESSAGE('Deleted Resource Requirements : ' || SQL%ROWCOUNT);
40:
41: INSERT INTO MSC_RESOURCE_REQUIREMENTS(
42: TRANSACTION_ID
43: ,PLAN_ID
44: ,SUPPLY_ID
45: ,ORGANIZATION_ID