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.OKL_VAR_INT_REAMORT_PVT dependencies on OKL_STREAM_INTERFACES

Line 1522: l_trans_status OKL_STREAM_INTERFACES.SIS_CODE%TYPE;

1518: l_level_date_start DATE;
1519: l_stub_level_date_start DATE;
1520:
1521: l_super_trump_request_id NUMBER;
1522: l_trans_status OKL_STREAM_INTERFACES.SIS_CODE%TYPE;
1523:
1524: l_request_id NUMBER;
1525: l_program_application_id NUMBER;
1526: l_program_id NUMBER;

Line 1551: OKL_STREAM_INTERFACES SIFB,

1547: IS
1548: SELECT SRLB.REAMORT_BALANCE
1549: FROM OKL_SIF_RET_LEVELS SRLB,
1550: OKL_SIF_RETS SIRB,
1551: OKL_STREAM_INTERFACES SIFB,
1552: OKL_SIF_LINES SILB
1553: WHERE SIFB.TRANSACTION_NUMBER = p_trx_number
1554: AND SIRB.TRANSACTION_NUMBER = SIFB.TRANSACTION_NUMBER
1555: AND SIRB.INDEX_NUMBER = 0

Line 1642: FROM okl_stream_interfaces

1638: CURSOR c_get_child_esg_trx_number( p_contract_id IN NUMBER
1639: ,p_trx_number IN NUMBER )
1640: IS
1641: SELECT max(transaction_number) max_transaction_number
1642: FROM okl_stream_interfaces
1643: WHERE khr_id = p_contract_id
1644: AND to_number(transaction_number) > p_trx_number
1645: AND orp_code = 'AUTH';
1646: