APPS.RCV_ROI_PREPROCESSOR dependencies on RCV_SHIPMENT_HEADERS

Line 778: UPDATE rcv_shipment_headers

774: *
775: * rsh.asn_status will remain as 'NEW_SHIP' until one line goes through. If all the
776: * lines have failed, the asn_status will remain as 'NEW_SHIP' and the rsh will be deleted.
777: **/
778: UPDATE rcv_shipment_headers
779: SET asn_status = null
780: WHERE (shipment_header_id = x_cascaded_table(n).shipment_header_id
781: OR shipment_num = (select shipment_num
782: from rcv_headers_interface

Line 843: UPDATE RCV_SHIPMENT_HEADERS

839: IF (g_asn_debug = 'Y') THEN
840: asn_debug.put_line('Generated Receipt Number:' || x_header_record.header_record.receipt_num);
841: END IF;
842:
843: UPDATE RCV_SHIPMENT_HEADERS
844: SET RECEIPT_NUM = x_header_record.header_record.receipt_num
845: WHERE SHIPMENT_HEADER_ID = x_header_record.header_record.receipt_header_id;
846:
847: END IF; --}

Line 870: DELETE FROM rcv_shipment_headers

866: IF ( x_fail_if_one_line_fails
867: AND x_cascaded_table(n).transaction_type = 'SHIP'
868: AND x_cascaded_table(n).auto_transact_code = 'SHIP') THEN --{ asn case
869: -- delete rsh and rsl
870: DELETE FROM rcv_shipment_headers
871: WHERE shipment_header_id = l_ship_header_id;
872:
873: IF (g_asn_debug = 'Y') THEN
874: asn_debug.put_line(sql%rowcount || ' RSH record deleted');

Line 950: DELETE FROM rcv_shipment_headers

946: * Bug 5024414: Only delete shipment headers where there is no running
947: * or pending interface line under the interface header, so that we only
948: * delete rsh after all rti lines have failed.
949: * */
950: DELETE FROM rcv_shipment_headers
951: WHERE shipment_header_id = l_ship_header_id
952: AND asn_status = 'NEW_SHIP'
953: AND NOT EXISTS ( SELECT rti.interface_transaction_id
954: FROM rcv_transactions_interface rti,

Line 1022: /* Forward port for Bug 4355172 vendor_site_id was not getting defaulted to rcv_shipment_headers.

1018: /* Bug 4881909 End */
1019:
1020: END LOOP; --} end loop of transaction rows in rti
1021:
1022: /* Forward port for Bug 4355172 vendor_site_id was not getting defaulted to rcv_shipment_headers.
1023: As a result skip_lot if setup against a supplier site will not work.
1024: since vendor_site_id is derived and populated into RTI get the same and update
1025: RSH */
1026: if (x_header_record.header_record.transaction_type <> 'CANCEL') and

Line 1041: update rcv_shipment_headers

1037: group by vendor_site_id;
1038: -- Update only if all shipments have same vendor site id
1039: if (x_site_id_count = 1) then
1040: Begin
1041: update rcv_shipment_headers
1042: set vendor_site_id=(select distinct vendor_site_id
1043: from rcv_transactions_interface
1044: where shipment_header_id=x_header_record.header_record.receipt_header_id
1045: and vendor_site_id is not null)