34:
35: IF (p_supplier_response_flag = SYS_YES) THEN
36:
37: v_sql_stmt:=
38: ' insert into MSC_ST_SUPPLIES'
39: ||' ( INVENTORY_ITEM_ID,'
40: ||' ORGANIZATION_ID,'
41: ||' DISPOSITION_ID,'
42: ||' SUPPLIER_ID,'
105:
106: COMMIT;
107:
108: EXCEPTION WHEN OTHERS THEN
109: LOG_MESSAGE('Error while populating msc_st_supplies from MRP_AP_SUPPLIER_RESPONSE_V');
110: LOG_MESSAGE(SQLERRM);
111: p_return_status := FALSE;
112: END;
113:
143: mss.END_ORDER_SHIPMENT_NUMBER,
144: mss.ACCEPTANCE_REQUIRED_FLAG,
145: mss.NEED_BY_DATE,
146: mss.ACK_REFERENCE_NUMBER
147: from msc_st_supplies mss,
148: msc_tp_id_lid mtil,
149: msc_tp_site_id_lid mtsil,
150: msc_item_id_lid miil
151: where mss.order_type = G_MRP_PO_ACK
186: a_need_by_date dates :=dates();
187: a_acceptance_required_flag acceptance_required_flags := acceptance_required_flags();
188: a_ack_reference_number ack_reference_numbers := ack_reference_numbers();
189:
190: prev_po_number msc_st_supplies.end_order_number%TYPE;
191: prev_release_number msc_st_supplies.END_ORDER_RELEASE_NUMBER%TYPE;
192: prev_po_line_number msc_st_supplies.END_ORDER_LINE_NUMBER%TYPE;
193: prev_po_shipment_number msc_st_supplies.END_ORDER_SHIPMENT_NUMBER%TYPE;
194: prev_ack_reference msc_st_supplies.ACK_REFERENCE_NUMBER%TYPE;
187: a_acceptance_required_flag acceptance_required_flags := acceptance_required_flags();
188: a_ack_reference_number ack_reference_numbers := ack_reference_numbers();
189:
190: prev_po_number msc_st_supplies.end_order_number%TYPE;
191: prev_release_number msc_st_supplies.END_ORDER_RELEASE_NUMBER%TYPE;
192: prev_po_line_number msc_st_supplies.END_ORDER_LINE_NUMBER%TYPE;
193: prev_po_shipment_number msc_st_supplies.END_ORDER_SHIPMENT_NUMBER%TYPE;
194: prev_ack_reference msc_st_supplies.ACK_REFERENCE_NUMBER%TYPE;
195:
188: a_ack_reference_number ack_reference_numbers := ack_reference_numbers();
189:
190: prev_po_number msc_st_supplies.end_order_number%TYPE;
191: prev_release_number msc_st_supplies.END_ORDER_RELEASE_NUMBER%TYPE;
192: prev_po_line_number msc_st_supplies.END_ORDER_LINE_NUMBER%TYPE;
193: prev_po_shipment_number msc_st_supplies.END_ORDER_SHIPMENT_NUMBER%TYPE;
194: prev_ack_reference msc_st_supplies.ACK_REFERENCE_NUMBER%TYPE;
195:
196: curr_po_number msc_st_supplies.end_order_number%TYPE;
189:
190: prev_po_number msc_st_supplies.end_order_number%TYPE;
191: prev_release_number msc_st_supplies.END_ORDER_RELEASE_NUMBER%TYPE;
192: prev_po_line_number msc_st_supplies.END_ORDER_LINE_NUMBER%TYPE;
193: prev_po_shipment_number msc_st_supplies.END_ORDER_SHIPMENT_NUMBER%TYPE;
194: prev_ack_reference msc_st_supplies.ACK_REFERENCE_NUMBER%TYPE;
195:
196: curr_po_number msc_st_supplies.end_order_number%TYPE;
197: curr_release_number msc_st_supplies.END_ORDER_RELEASE_NUMBER%TYPE;
190: prev_po_number msc_st_supplies.end_order_number%TYPE;
191: prev_release_number msc_st_supplies.END_ORDER_RELEASE_NUMBER%TYPE;
192: prev_po_line_number msc_st_supplies.END_ORDER_LINE_NUMBER%TYPE;
193: prev_po_shipment_number msc_st_supplies.END_ORDER_SHIPMENT_NUMBER%TYPE;
194: prev_ack_reference msc_st_supplies.ACK_REFERENCE_NUMBER%TYPE;
195:
196: curr_po_number msc_st_supplies.end_order_number%TYPE;
197: curr_release_number msc_st_supplies.END_ORDER_RELEASE_NUMBER%TYPE;
198: curr_po_line_number msc_st_supplies.END_ORDER_LINE_NUMBER%TYPE;
192: prev_po_line_number msc_st_supplies.END_ORDER_LINE_NUMBER%TYPE;
193: prev_po_shipment_number msc_st_supplies.END_ORDER_SHIPMENT_NUMBER%TYPE;
194: prev_ack_reference msc_st_supplies.ACK_REFERENCE_NUMBER%TYPE;
195:
196: curr_po_number msc_st_supplies.end_order_number%TYPE;
197: curr_release_number msc_st_supplies.END_ORDER_RELEASE_NUMBER%TYPE;
198: curr_po_line_number msc_st_supplies.END_ORDER_LINE_NUMBER%TYPE;
199: curr_po_shipment_number msc_st_supplies.END_ORDER_SHIPMENT_NUMBER%TYPE;
200: curr_ack_reference msc_st_supplies.ACK_REFERENCE_NUMBER%TYPE;
193: prev_po_shipment_number msc_st_supplies.END_ORDER_SHIPMENT_NUMBER%TYPE;
194: prev_ack_reference msc_st_supplies.ACK_REFERENCE_NUMBER%TYPE;
195:
196: curr_po_number msc_st_supplies.end_order_number%TYPE;
197: curr_release_number msc_st_supplies.END_ORDER_RELEASE_NUMBER%TYPE;
198: curr_po_line_number msc_st_supplies.END_ORDER_LINE_NUMBER%TYPE;
199: curr_po_shipment_number msc_st_supplies.END_ORDER_SHIPMENT_NUMBER%TYPE;
200: curr_ack_reference msc_st_supplies.ACK_REFERENCE_NUMBER%TYPE;
201:
194: prev_ack_reference msc_st_supplies.ACK_REFERENCE_NUMBER%TYPE;
195:
196: curr_po_number msc_st_supplies.end_order_number%TYPE;
197: curr_release_number msc_st_supplies.END_ORDER_RELEASE_NUMBER%TYPE;
198: curr_po_line_number msc_st_supplies.END_ORDER_LINE_NUMBER%TYPE;
199: curr_po_shipment_number msc_st_supplies.END_ORDER_SHIPMENT_NUMBER%TYPE;
200: curr_ack_reference msc_st_supplies.ACK_REFERENCE_NUMBER%TYPE;
201:
202: order_line_number VARCHAR2(40);
195:
196: curr_po_number msc_st_supplies.end_order_number%TYPE;
197: curr_release_number msc_st_supplies.END_ORDER_RELEASE_NUMBER%TYPE;
198: curr_po_line_number msc_st_supplies.END_ORDER_LINE_NUMBER%TYPE;
199: curr_po_shipment_number msc_st_supplies.END_ORDER_SHIPMENT_NUMBER%TYPE;
200: curr_ack_reference msc_st_supplies.ACK_REFERENCE_NUMBER%TYPE;
201:
202: order_line_number VARCHAR2(40);
203: lv_temp_supply_tbl VARCHAR2(40);
196: curr_po_number msc_st_supplies.end_order_number%TYPE;
197: curr_release_number msc_st_supplies.END_ORDER_RELEASE_NUMBER%TYPE;
198: curr_po_line_number msc_st_supplies.END_ORDER_LINE_NUMBER%TYPE;
199: curr_po_shipment_number msc_st_supplies.END_ORDER_SHIPMENT_NUMBER%TYPE;
200: curr_ack_reference msc_st_supplies.ACK_REFERENCE_NUMBER%TYPE;
201:
202: order_line_number VARCHAR2(40);
203: lv_temp_supply_tbl VARCHAR2(40);
204:
227: lv_sql_stmt VARCHAR2(5000);
228:
229: BEGIN
230: --======================================================================
231: -- For the records collected from msc_st_supplies
232: -- delete the corresponding previous "PO Acknowledgment" records for the
233: -- following key
234: --
235: -- sr_instance_id,