APPS.MSC_REL_PLAN_PUB dependencies on MSC_PO_REQUISITIONS_INTERFACE

Line 2449: DELETE MSC_PO_REQUISITIONS_INTERFACE

2445: EXECUTE IMMEDIATE lv_sql_stmt
2446: USING IN po_group_by_name,
2447: OUT arg_req_load_id;
2448: IF fnd_profile.value('MSC_RETAIN_RELEASED_DATA') ='N' THEN
2449: DELETE MSC_PO_REQUISITIONS_INTERFACE
2450: WHERE sr_instance_id= arg_org_instance;
2451: END IF;
2452: END;
2453: END IF;

Line 2672: DELETE MSC_PO_REQUISITIONS_INTERFACE

2668: WHERE sr_instance_id= arg_org_instance
2669: AND NVL(GROUP_ID,-1) = NVL(arg_wip_group_id, -1);
2670:
2671:
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

Line 2695: DELETE MSC_PO_REQUISITIONS_INTERFACE

2691: WHERE sr_instance_id= arg_org_instance
2692: AND NVL(GROUP_ID,-1) = NVL(arg_wip_group_id, -1);
2693:
2694:
2695: DELETE MSC_PO_REQUISITIONS_INTERFACE
2696: WHERE sr_instance_id= arg_org_instance
2697: AND NVL(BATCH_ID, -1) = NVL(arg_po_batch_number, -1);
2698:
2699:

Line 9518: INSERT INTO msc_po_requisitions_interface /*+ FIRST_ROWS */

9514: -- to find a value in the group code.
9515:
9516:
9517:
9518: INSERT INTO msc_po_requisitions_interface /*+ FIRST_ROWS */
9519: (
9520: /*line_type_id, Amount or Quantity based */
9521: last_updated_by,
9522: last_update_date,

Line 10015: update msc_po_requisitions_interface

10011: ELSE
10012: lv_loaded_reqs := 0;
10013: END IF;
10014:
10015: update msc_po_requisitions_interface
10016: set group_code = to_char(msc_po_requisitions_int_s.nextval)
10017: where group_code = '-100'
10018: and batch_id = arg_po_batch_number;
10019:

Line 10041: and transaction_id in (select source_line_id from msc_po_requisitions_interface

10037: update msc_supplies
10038: set releasable = RELEASE_ATTEMPTED
10039: ,batch_id = nvl(batch_id,g_batch_id)
10040: where plan_id = arg_plan_id
10041: and transaction_id in (select source_line_id from msc_po_requisitions_interface
10042: where batch_id = arg_po_batch_number);
10043: END IF;
10044:
10045: return lv_loaded_reqs;

Line 13538: UPDATE MSC_PO_REQUISITIONS_INTERFACE

13534: IS
13535: BEGIN
13536: -- Update PO Interface tables
13537: begin
13538: UPDATE MSC_PO_REQUISITIONS_INTERFACE
13539: SET
13540: need_by_date = trunc(need_by_date) + v_rp_time
13541: WHERE batch_id = p_arg_batch_id;
13542: exception