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_POPULATE_PRCENG_RESULT_PUB dependencies on OKL_STREAM_INTERFACES

Line 1577: FROM okl_stream_interfaces

1573: lx_id NUMBER;
1574:
1575: CURSOR khr_id_csr (trx_number NUMBER) IS
1576: SELECT khr_id
1577: FROM okl_stream_interfaces
1578: WHERE transaction_number = trx_number;
1579:
1580: CURSOR start_date_csr (khr_id NUMBER) IS
1581: SELECT start_date

Line 1702: FROM okl_stream_interfaces

1698: lx_id NUMBER;
1699:
1700: CURSOR khr_id_csr (trx_number NUMBER) IS
1701: SELECT khr_id
1702: FROM okl_stream_interfaces
1703: WHERE transaction_number = trx_number;
1704:
1705: CURSOR start_date_csr (khr_id NUMBER) IS
1706: SELECT start_date

Line 1814: -- cursor to update transaction status in the OKL_STREAM_INTERFACES table

1810: p_transaction_number IN NUMBER,
1811: p_sis_code IN VARCHAR2,
1812: x_return_status OUT NOCOPY VARCHAR2
1813: ) IS
1814: -- cursor to update transaction status in the OKL_STREAM_INTERFACES table
1815: CURSOR sif_data_csr (trx_number IN NUMBER) IS
1816: SELECT
1817: ID,ORP_CODE
1818: FROM Okl_Stream_Interfaces

Line 1818: FROM Okl_Stream_Interfaces

1814: -- cursor to update transaction status in the OKL_STREAM_INTERFACES table
1815: CURSOR sif_data_csr (trx_number IN NUMBER) IS
1816: SELECT
1817: ID,ORP_CODE
1818: FROM Okl_Stream_Interfaces
1819: WHERE okl_stream_interfaces.transaction_number = trx_number;
1820:
1821: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1822: lp_sifv_rec sifv_rec_type;

Line 1819: WHERE okl_stream_interfaces.transaction_number = trx_number;

1815: CURSOR sif_data_csr (trx_number IN NUMBER) IS
1816: SELECT
1817: ID,ORP_CODE
1818: FROM Okl_Stream_Interfaces
1819: WHERE okl_stream_interfaces.transaction_number = trx_number;
1820:
1821: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1822: lp_sifv_rec sifv_rec_type;
1823: lx_sifv_rec sifv_rec_type;

Line 1872: -- cursor to update transaction status in the OKL_STREAM_INTERFACES table

1868: p_srt_code IN VARCHAR2, -- inbound status
1869: p_log_file_name IN VARCHAR2,
1870: x_return_status OUT NOCOPY VARCHAR2
1871: ) IS
1872: -- cursor to update transaction status in the OKL_STREAM_INTERFACES table
1873: CURSOR sif_data_csr (trx_number IN NUMBER) IS
1874: SELECT
1875: ID,ORP_CODE
1876: FROM Okl_Stream_Interfaces

Line 1876: FROM Okl_Stream_Interfaces

1872: -- cursor to update transaction status in the OKL_STREAM_INTERFACES table
1873: CURSOR sif_data_csr (trx_number IN NUMBER) IS
1874: SELECT
1875: ID,ORP_CODE
1876: FROM Okl_Stream_Interfaces
1877: WHERE okl_stream_interfaces.transaction_number = trx_number;
1878:
1879: CURSOR sir_data_csr (trx_number IN NUMBER) IS
1880: SELECT

Line 1877: WHERE okl_stream_interfaces.transaction_number = trx_number;

1873: CURSOR sif_data_csr (trx_number IN NUMBER) IS
1874: SELECT
1875: ID,ORP_CODE
1876: FROM Okl_Stream_Interfaces
1877: WHERE okl_stream_interfaces.transaction_number = trx_number;
1878:
1879: CURSOR sir_data_csr (trx_number IN NUMBER) IS
1880: SELECT
1881: ID

Line 1964: -- cursor to update transaction status in the OKL_STREAM_INTERFACES table

1960: p_srt_code IN VARCHAR2, -- inbound status
1961: p_log_file_name IN VARCHAR2,
1962: x_return_status OUT NOCOPY VARCHAR2
1963: ) IS
1964: -- cursor to update transaction status in the OKL_STREAM_INTERFACES table
1965: CURSOR sif_data_csr (trx_number IN NUMBER) IS
1966: SELECT
1967: ID,ORP_CODE
1968: FROM Okl_Stream_Interfaces

Line 1968: FROM Okl_Stream_Interfaces

1964: -- cursor to update transaction status in the OKL_STREAM_INTERFACES table
1965: CURSOR sif_data_csr (trx_number IN NUMBER) IS
1966: SELECT
1967: ID,ORP_CODE
1968: FROM Okl_Stream_Interfaces
1969: WHERE okl_stream_interfaces.transaction_number = trx_number;
1970:
1971: CURSOR sir_data_csr (trx_number IN NUMBER) IS
1972: SELECT

Line 1969: WHERE okl_stream_interfaces.transaction_number = trx_number;

1965: CURSOR sif_data_csr (trx_number IN NUMBER) IS
1966: SELECT
1967: ID,ORP_CODE
1968: FROM Okl_Stream_Interfaces
1969: WHERE okl_stream_interfaces.transaction_number = trx_number;
1970:
1971: CURSOR sir_data_csr (trx_number IN NUMBER) IS
1972: SELECT
1973: ID

Line 2071: FROM Okl_Stream_Interfaces

2067:
2068: CURSOR sif_data_csr (trx_number IN NUMBER) IS
2069: SELECT
2070: SIS_CODE
2071: FROM Okl_Stream_Interfaces
2072: WHERE okl_stream_interfaces.transaction_number = trx_number;
2073: BEGIN
2074: x_ok_to_proceed := 'Y';
2075: FOR sif_data IN sif_data_csr(p_transaction_number)

Line 2072: WHERE okl_stream_interfaces.transaction_number = trx_number;

2068: CURSOR sif_data_csr (trx_number IN NUMBER) IS
2069: SELECT
2070: SIS_CODE
2071: FROM Okl_Stream_Interfaces
2072: WHERE okl_stream_interfaces.transaction_number = trx_number;
2073: BEGIN
2074: x_ok_to_proceed := 'Y';
2075: FOR sif_data IN sif_data_csr(p_transaction_number)
2076: LOOP