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_HXT_GRP dependencies on RCV_TRANSACTIONS_INTERFACE_S

Line 1907: SELECT RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL

1903: l_api_name CONSTANT varchar2(30) := 'Derive_Common_RTI_Values';
1904: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;
1905: BEGIN
1906: -- interface_transaction_id
1907: SELECT RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL
1908: INTO p_rti_row.interface_transaction_id
1909: FROM dual;
1910:
1911: -- job_id

Line 2321: SELECT RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL

2317: IF l_correction_amount < 0 THEN
2318: -- for negative corrections, we correct the deliver first
2319:
2320: -- get the next rti id for the receive transaction
2321: SELECT RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL
2322: INTO l_rcv_rti_row.interface_transaction_id
2323: FROM dual;
2324:
2325: -- insert into rti table

Line 2332: SELECT RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL

2328: ELSE
2329: -- for positive corrections, we correct the receive first
2330:
2331: -- get the next rti id for the deliver transaction
2332: SELECT RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL
2333: INTO l_del_rti_row.interface_transaction_id
2334: FROM dual;
2335:
2336: -- insert into rti table

Line 2788: TYPE source_document_code_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.source_document_code%TYPE INDEX BY BINARY_INTEGER;

2784: TYPE lpn_group_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.lpn_group_id%TYPE INDEX BY BINARY_INTEGER;
2785: TYPE transaction_date_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.transaction_date%TYPE INDEX BY BINARY_INTEGER;
2786: TYPE processing_mode_code_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.processing_mode_code%TYPE INDEX BY BINARY_INTEGER;
2787: TYPE transaction_status_code_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.transaction_status_code%TYPE INDEX BY BINARY_INTEGER;
2788: TYPE source_document_code_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.source_document_code%TYPE INDEX BY BINARY_INTEGER;
2789: TYPE parent_transaction_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.parent_transaction_id%TYPE INDEX BY BINARY_INTEGER;
2790: TYPE po_header_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.po_header_id%TYPE INDEX BY BINARY_INTEGER;
2791: TYPE po_line_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.po_line_id%TYPE INDEX BY BINARY_INTEGER;
2792: TYPE po_line_location_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.po_line_location_id%TYPE INDEX BY BINARY_INTEGER;