APPS.RCV_SHIPMENT_OBJECT_SV dependencies on RCV_SHIPMENT_HEADERS

Line 289: DELETE FROM rcv_shipment_headers

285:
286: -- If this is a test, then we have not inserted the header record
287:
288: IF NVL(x_header_record.header_record.test_flag, 'N') <> 'Y' THEN
289: DELETE FROM rcv_shipment_headers
290: WHERE shipment_header_id = x_header_record.header_record.receipt_header_id;
291: END IF;
292:
293: UPDATE rcv_headers_interface

Line 360: -- update the rcv_shipment_headers table

356: validation_flag = 'N',
357: receipt_header_id = x_header_record.header_record.receipt_header_id
358: WHERE header_interface_id = x_header_record.header_record.header_interface_id;
359:
360: -- update the rcv_shipment_headers table
361:
362: UPDATE rcv_shipment_headers
363: SET invoice_status_code = 'RCV_ASBN_NO_AUTO_INVOICE'
364: WHERE shipment_header_id = x_header_record.header_record.receipt_header_id;

Line 362: UPDATE rcv_shipment_headers

358: WHERE header_interface_id = x_header_record.header_record.header_interface_id;
359:
360: -- update the rcv_shipment_headers table
361:
362: UPDATE rcv_shipment_headers
363: SET invoice_status_code = 'RCV_ASBN_NO_AUTO_INVOICE'
364: WHERE shipment_header_id = x_header_record.header_record.receipt_header_id;
365: ELSE
366: UPDATE rcv_headers_interface