APPS.RCV_ROI_PREPROCESSOR dependencies on RCV_SHIPMENT_HEADERS

Line 924: UPDATE rcv_shipment_headers

920: *
921: * rsh.asn_status will remain as 'NEW_SHIP' until one line goes through. If all the
922: * lines have failed, the asn_status will remain as 'NEW_SHIP' and the rsh will be deleted.
923: **/
924: UPDATE rcv_shipment_headers
925: SET asn_status = null
926: WHERE (shipment_header_id = x_cascaded_table(n).shipment_header_id
927: OR shipment_num = (select shipment_num
928: from rcv_headers_interface

Line 989: UPDATE RCV_SHIPMENT_HEADERS

985: IF (g_asn_debug = 'Y') THEN
986: asn_debug.put_line('Generated Receipt Number:' || x_header_record.header_record.receipt_num);
987: END IF;
988:
989: UPDATE RCV_SHIPMENT_HEADERS
990: SET RECEIPT_NUM = x_header_record.header_record.receipt_num
991: WHERE SHIPMENT_HEADER_ID = x_header_record.header_record.receipt_header_id;
992:
993: END IF; --}

Line 1019: DELETE FROM rcv_shipment_headers

1015: /* Add a new variable l_transaction_type_old which will have the original value of RTI.transaction_type */
1016: AND x_cascaded_table(n).auto_transact_code in ('SHIP','RECEIVE','DELIVER')) THEN --{ asn case
1017: /* End bug 7684677 */
1018: -- delete rsh and rsl
1019: DELETE FROM rcv_shipment_headers
1020: WHERE shipment_header_id = l_ship_header_id;
1021:
1022: IF (g_asn_debug = 'Y') THEN
1023: asn_debug.put_line(sql%rowcount || ' RSH record deleted');

Line 1088: UPDATE rcv_shipment_headers

1084: asn_debug.put_line('l_transaction_type_old: ' || l_transaction_type_old);
1085: asn_debug.put_line('Auto transact code: ' || x_cascaded_table(n).auto_transact_code);
1086: END IF;
1087:
1088: UPDATE rcv_shipment_headers
1089: SET receipt_num = NULL
1090: WHERE shipment_header_id = x_header_record.header_record.receipt_header_id
1091: AND (asn_type = 'ASN' OR asn_type = 'ASBN')
1092: AND (receipt_num IS NOT NULL)

Line 1139: DELETE FROM rcv_shipment_headers

1135: * Bug 5024414: Only delete shipment headers where there is no running
1136: * or pending interface line under the interface header, so that we only
1137: * delete rsh after all rti lines have failed.
1138: * */
1139: DELETE FROM rcv_shipment_headers
1140: WHERE shipment_header_id = l_ship_header_id
1141: AND asn_status = 'NEW_SHIP'
1142: AND NOT EXISTS ( SELECT rti.interface_transaction_id
1143: FROM rcv_transactions_interface rti,

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

1160: n := 0;
1161:
1162: END LOOP; --} end loop of transaction rows in rti
1163:
1164: /* Forward port for Bug 4355172 vendor_site_id was not getting defaulted to rcv_shipment_headers.
1165: As a result skip_lot if setup against a supplier site will not work.
1166: since vendor_site_id is derived and populated into RTI get the same and update
1167: RSH */
1168: if (x_header_record.header_record.transaction_type <> 'CANCEL') and

Line 1183: update rcv_shipment_headers

1179: group by vendor_site_id;
1180: -- Update only if all shipments have same vendor site id
1181: if (x_site_id_count = 1) then
1182: Begin
1183: update rcv_shipment_headers
1184: set vendor_site_id=(select distinct vendor_site_id
1185: from rcv_transactions_interface
1186: where shipment_header_id=x_header_record.header_record.receipt_header_id
1187: and vendor_site_id is not null)