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)
250: AND plan_id = lv_plan_id;
251: LOG_MESSAGE('Deleted Supplies : ' || SQL%ROWCOUNT);
252:
648: ,sup.TOP_TRANSACTION_ID
649: ,sup.UNBUCKETED_NEW_SCHED_DATE
650: ,sup.IMPLEMENT_SHIP_METHOD
651: ,sup.ACTUAL_START_DATE
652: FROM MSC_STORE_SUPPLIES sup
653: WHERE sup.PLAN_ID = lv_plan_id;
654: LOG_MESSAGE('Inserted Supplies : ' || SQL%ROWCOUNT);
655:
656: EXCEPTION