APPS.MSC_REL_PLAN_PUB dependencies on MSC_PO_RESCHEDULE_INTERFACE

Line 2029: /* DELETE MSC_PO_RESCHEDULE_INTERFACE

2025: EXECUTE IMMEDIATE lv_sql_stmt
2026: USING OUT arg_req_resched_id;
2027:
2028:
2029: /* DELETE MSC_PO_RESCHEDULE_INTERFACE
2030: WHERE sr_instance_id= arg_org_instance;
2031: */
2032: END IF;
2033:

Line 2144: DELETE MSC_PO_RESCHEDULE_INTERFACE

2140: DELETE MSC_PO_REQUISITIONS_INTERFACE
2141: WHERE sr_instance_id= arg_org_instance
2142: AND NVL(BATCH_ID, -1) = NVL(arg_po_batch_number, -1);
2143:
2144: DELETE MSC_PO_RESCHEDULE_INTERFACE
2145: WHERE sr_instance_id= arg_org_instance
2146: and batch_id = g_batch_id;
2147:
2148: END IF;

Line 2167: DELETE MSC_PO_RESCHEDULE_INTERFACE

2163: WHERE sr_instance_id= arg_org_instance
2164: AND NVL(BATCH_ID, -1) = NVL(arg_po_batch_number, -1);
2165:
2166:
2167: DELETE MSC_PO_RESCHEDULE_INTERFACE
2168: WHERE sr_instance_id= arg_org_instance
2169: and batch_id = g_batch_id;
2170: /*
2171: IF g_batch_id <> -1 THEN

Line 9198: INSERT INTO msc_po_reschedule_interface

9194: -- ------------------------------------------------------------------------
9195: -- Perform the po mass reschedule
9196: -- ------------------------------------------------------------------------
9197:
9198: INSERT INTO msc_po_reschedule_interface
9199: (process_id,
9200: quantity,
9201: need_by_date,
9202: line_id,

Line 9346: and transaction_id in (select source_line_id from msc_po_reschedule_interface);

9342: update msc_supplies
9343: set releasable = RELEASE_ATTEMPTED
9344: ,batch_id = g_batch_id
9345: where plan_id = arg_plan_id
9346: and transaction_id in (select source_line_id from msc_po_reschedule_interface);
9347: END IF;
9348: END IF;
9349:
9350: RETURN lv_resched_reqs;