APPS.MSC_REL_PLAN_PUB dependencies on MSC_PO_REQUISITIONS_INTERFACE

Line 1997: /* DELETE MSC_PO_REQUISITIONS_INTERFACE

1993:
1994: EXECUTE IMMEDIATE lv_sql_stmt
1995: USING IN po_group_by_name,
1996: OUT arg_req_load_id;
1997: /* DELETE MSC_PO_REQUISITIONS_INTERFACE
1998: WHERE sr_instance_id= arg_org_instance;
1999: */
2000: END;
2001: END IF;

Line 2140: DELETE MSC_PO_REQUISITIONS_INTERFACE

2136: WHERE sr_instance_id= arg_org_instance
2137: AND NVL(GROUP_ID,-1) = NVL(arg_wip_group_id, -1);
2138:
2139:
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

Line 2162: DELETE MSC_PO_REQUISITIONS_INTERFACE

2158: WHERE sr_instance_id= arg_org_instance
2159: AND NVL(GROUP_ID,-1) = NVL(arg_wip_group_id, -1);
2160:
2161:
2162: DELETE MSC_PO_REQUISITIONS_INTERFACE
2163: WHERE sr_instance_id= arg_org_instance
2164: AND NVL(BATCH_ID, -1) = NVL(arg_po_batch_number, -1);
2165:
2166:

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

8671: -- to find a value in the group code.
8672:
8673:
8674:
8675: INSERT INTO msc_po_requisitions_interface /*+ FIRST_ROWS */
8676: (
8677: /*line_type_id, Amount or Quantity based */
8678: last_updated_by,
8679: last_update_date,

Line 9146: update msc_po_requisitions_interface

9142: ELSE
9143: lv_loaded_reqs := 0;
9144: END IF;
9145:
9146: update msc_po_requisitions_interface
9147: set group_code = to_char(msc_po_requisitions_int_s.nextval)
9148: where group_code = '-100'
9149: and batch_id = arg_po_batch_number;
9150:

Line 9172: and transaction_id in (select source_line_id from msc_po_requisitions_interface

9168: update msc_supplies
9169: set releasable = RELEASE_ATTEMPTED
9170: ,batch_id = nvl(batch_id,g_batch_id)
9171: where plan_id = arg_plan_id
9172: and transaction_id in (select source_line_id from msc_po_requisitions_interface
9173: where batch_id = arg_po_batch_number);
9174: END IF;
9175:
9176: return lv_loaded_reqs;