[Home] [Help]
2477: EXECUTE IMMEDIATE lv_sql_stmt
2478: USING OUT arg_req_resched_id;
2479:
2480: /* IF fnd_profile.value('MSC_RETAIN_RELEASED_DATA') ='N' THEN
2481: DELETE MSC_PO_RESCHEDULE_INTERFACE
2482: WHERE sr_instance_id= arg_org_instance;
2483: END IF;
2484: */
2485: END IF;
2672: DELETE MSC_PO_REQUISITIONS_INTERFACE
2673: WHERE sr_instance_id= arg_org_instance
2674: AND NVL(BATCH_ID, -1) = NVL(arg_po_batch_number, -1);
2675:
2676: DELETE MSC_PO_RESCHEDULE_INTERFACE
2677: WHERE sr_instance_id= arg_org_instance
2678: and batch_id = g_batch_id;
2679: END IF;
2680:
2696: WHERE sr_instance_id= arg_org_instance
2697: AND NVL(BATCH_ID, -1) = NVL(arg_po_batch_number, -1);
2698:
2699:
2700: DELETE MSC_PO_RESCHEDULE_INTERFACE
2701: WHERE sr_instance_id= arg_org_instance
2702: and batch_id = g_batch_id;
2703: /*
2704: IF g_batch_id <> -1 THEN
10063: -- ------------------------------------------------------------------------
10064: -- Perform the po mass reschedule
10065: -- ------------------------------------------------------------------------
10066:
10067: INSERT INTO msc_po_reschedule_interface
10068: (process_id,
10069: quantity,
10070: need_by_date,
10071: line_id,
10211: update msc_supplies
10212: set releasable = RELEASE_ATTEMPTED
10213: ,batch_id = g_batch_id
10214: where plan_id = arg_plan_id
10215: and transaction_id in (select source_line_id from msc_po_reschedule_interface);
10216: END IF;
10217: END IF;
10218:
10219: RETURN lv_resched_reqs;
13545: NULL;
13546: end;
13547: -- Update PO_RESCHEDULE if there is any
13548: begin
13549: UPDATE MSC_PO_RESCHEDULE_INTERFACE
13550: SET
13551: need_by_date = trunc(need_by_date) + v_rp_time
13552: WHERE batch_id = g_batch_id;
13553: exception