APPS.POS_ASN_XML dependencies on RCV_HEADERS_INTERFACE

Line 26: from rcv_headers_interface

22: p_error_code := 0;
23:
24: select count(*)
25: into v_temp
26: from rcv_headers_interface
27: where
28: shipment_num = p_shipment_num and
29: vendor_id = p_vendor_id and
30: nvl(vendor_site_id, -9999) = nvl(p_vendor_site_id, -9999);

Line 967: update rcv_headers_interface

963: rcv_transactions_interface
964: where
965: header_interface_id = p_header_interface_id;
966:
967: update rcv_headers_interface
968: set vendor_id = p_vendor_id,
969: vendor_site_id = p_vendor_site_id,
970: ship_to_organization_id = p_ship_to_org_id
971: where header_interface_id = p_header_interface_id;

Line 1196: update rcv_headers_interface

1192: x_err_code NUMBER;
1193:
1194: BEGIN
1195:
1196: update rcv_headers_interface
1197: set bill_of_lading = p_bill_of_lading,
1198: packing_slip = p_packing_slip,
1199: waybill_airbill_num = p_waybill_airbill_num,
1200: location_id = p_location_id

Line 1276: SELECT Count(*) INTO h_count FROM rcv_headers_interface hdr WHERE creation_date >= SYSDATE -1;

1272: h_count NUMBER :=0;
1273: BEGIN
1274: p_error_code := 0;
1275: SELECT Count(*) INTO l_count FROM rcv_transactions_interface;
1276: SELECT Count(*) INTO h_count FROM rcv_headers_interface hdr WHERE creation_date >= SYSDATE -1;
1277: select interface_transaction_id
1278: into wms_interface_transaction_id
1279: from rcv_transactions_interface
1280: where item_num = item