DBA Data[Home] [Help]

APPS.MSC_RESTORE_FIRM_PO dependencies on MSC_SUPPLIES

Line 245: DELETE FROM MSC_SUPPLIES

241:
242: COMMIT;
243:
244: BEGIN
245: DELETE FROM MSC_SUPPLIES
246: WHERE (PLAN_ID, TRANSACTION_ID, SR_INSTANCE_ID) IN
247: (SELECT PLAN_ID, TRANSACTION_ID, SR_INSTANCE_ID
248: FROM MSC_STORE_SUPPLIES
249: WHERE plan_id = lv_plan_id)

Line 253: INSERT INTO MSC_SUPPLIES(

249: WHERE plan_id = lv_plan_id)
250: AND plan_id = lv_plan_id;
251: LOG_MESSAGE('Deleted Supplies : ' || SQL%ROWCOUNT);
252:
253: INSERT INTO MSC_SUPPLIES(
254: PLAN_ID
255: ,TRANSACTION_ID
256: ,ORGANIZATION_ID
257: ,SR_INSTANCE_ID