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 1939: SELECT RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL

1935: l_api_name CONSTANT varchar2(30) := 'Derive_Common_RTI_Values';
1936: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;
1937: BEGIN
1938: -- interface_transaction_id
1939: SELECT RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL
1940: INTO p_rti_row.interface_transaction_id
1941: FROM dual;
1942:
1943: -- job_id

Line 2351: SELECT RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL

2347: IF l_correction_amount < 0 THEN
2348: -- for negative corrections, we correct the deliver first
2349:
2350: -- get the next rti id for the receive transaction
2351: SELECT RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL
2352: INTO l_rcv_rti_row.interface_transaction_id
2353: FROM dual;
2354:
2355: -- insert into rti table

Line 2362: SELECT RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL

2358: ELSE
2359: -- for positive corrections, we correct the receive first
2360:
2361: -- get the next rti id for the deliver transaction
2362: SELECT RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL
2363: INTO l_del_rti_row.interface_transaction_id
2364: FROM dual;
2365:
2366: -- insert into rti table

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

2845: TYPE lpn_group_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.lpn_group_id%TYPE INDEX BY BINARY_INTEGER;
2846: TYPE transaction_date_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.transaction_date%TYPE INDEX BY BINARY_INTEGER;
2847: TYPE processing_mode_code_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.processing_mode_code%TYPE INDEX BY BINARY_INTEGER;
2848: TYPE transaction_status_code_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.transaction_status_code%TYPE INDEX BY BINARY_INTEGER;
2849: TYPE source_document_code_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.source_document_code%TYPE INDEX BY BINARY_INTEGER;
2850: TYPE parent_transaction_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.parent_transaction_id%TYPE INDEX BY BINARY_INTEGER;
2851: TYPE po_header_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.po_header_id%TYPE INDEX BY BINARY_INTEGER;
2852: TYPE po_line_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.po_line_id%TYPE INDEX BY BINARY_INTEGER;
2853: TYPE po_line_location_id_tbl IS TABLE OF RCV_TRANSACTIONS_INTERFACE.po_line_location_id%TYPE INDEX BY BINARY_INTEGER;