eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RCV_HEADERS_INTERFACE_SV dependencies on RCV_SHIPMENT_HEADERS

Line 347: SELECT rcv_shipment_headers_s.NEXTVAL

343: /* generate the shipment_header_id */
344: /* shipment_header_id - receipt_header_id is the same */
345: IF p_header_record.header_record.receipt_header_id IS NULL
346: AND p_header_record.header_record.transaction_type <> 'CANCEL' THEN -- added for support of cancel
347: SELECT rcv_shipment_headers_s.NEXTVAL
348: INTO p_header_record.header_record.receipt_header_id
349: FROM SYS.DUAL;
350:
351: IF (g_asn_debug = 'Y') THEN

Line 706: FROM rcv_shipment_headers

702: IF p_header_record.header_record.receipt_num IS NOT NULL
703: AND p_header_record.header_record.transaction_type <> 'CANCEL' THEN -- added for support of cancel
704: SELECT COUNT(*)
705: INTO x_count
706: FROM rcv_shipment_headers
707: WHERE rcv_shipment_headers.receipt_num = p_header_record.header_record.receipt_num
708: AND ship_to_org_id = p_header_record.header_record.ship_to_organization_id;
709:
710: IF x_count > 0 THEN

Line 707: WHERE rcv_shipment_headers.receipt_num = p_header_record.header_record.receipt_num

703: AND p_header_record.header_record.transaction_type <> 'CANCEL' THEN -- added for support of cancel
704: SELECT COUNT(*)
705: INTO x_count
706: FROM rcv_shipment_headers
707: WHERE rcv_shipment_headers.receipt_num = p_header_record.header_record.receipt_num
708: AND ship_to_org_id = p_header_record.header_record.ship_to_organization_id;
709:
710: IF x_count > 0 THEN
711: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;

Line 1358: * RCV_SHIPMENT_HEADERS table */

1354: p_header_record.header_record.asn_type := NULL;
1355: END IF;
1356:
1357: /* Bug - 1086088 - Ship_to_org_id needs to get populated in the
1358: * RCV_SHIPMENT_HEADERS table */
1359: INSERT INTO rcv_shipment_headers
1360: (shipment_header_id,
1361: last_update_date,
1362: last_updated_by,

Line 1359: INSERT INTO rcv_shipment_headers

1355: END IF;
1356:
1357: /* Bug - 1086088 - Ship_to_org_id needs to get populated in the
1358: * RCV_SHIPMENT_HEADERS table */
1359: INSERT INTO rcv_shipment_headers
1360: (shipment_header_id,
1361: last_update_date,
1362: last_updated_by,
1363: creation_date,

Line 1647: FROM rcv_shipment_headers

1643:
1644: LOOP
1645: SELECT COUNT(*)
1646: INTO l_count
1647: FROM rcv_shipment_headers
1648: WHERE receipt_num = p_header_record.header_record.receipt_num
1649: AND ship_to_org_id = p_header_record.header_record.ship_to_organization_id;
1650:
1651: IF l_count = 0 THEN