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

Line 2111: FROM okl_stream_interfaces

2107: l_module VARCHAR2(255) := G_MODULE||'.'||l_api_name||'.'||p_transaction_number;
2108:
2109: CURSOR khr_id_csr (trx_number NUMBER) IS
2110: SELECT khr_id
2111: FROM okl_stream_interfaces
2112: WHERE transaction_number = trx_number;
2113:
2114: CURSOR start_date_csr (khr_id NUMBER) IS
2115: SELECT start_date

Line 2253: FROM okl_stream_interfaces

2249: l_module VARCHAR2(255) := G_MODULE||'.'||l_api_name||'.'||p_transaction_number;
2250:
2251: CURSOR khr_id_csr (trx_number NUMBER) IS
2252: SELECT khr_id
2253: FROM okl_stream_interfaces
2254: WHERE transaction_number = trx_number;
2255:
2256: CURSOR start_date_csr (khr_id NUMBER) IS
2257: SELECT start_date

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

2376: p_transaction_number IN NUMBER,
2377: p_sis_code IN VARCHAR2,
2378: x_return_status OUT NOCOPY VARCHAR2
2379: ) IS
2380: -- cursor to update transaction status in the OKL_STREAM_INTERFACES table
2381: CURSOR sif_data_csr (trx_number IN NUMBER) IS
2382: SELECT
2383: ID,ORP_CODE
2384: FROM Okl_Stream_Interfaces

Line 2384: FROM Okl_Stream_Interfaces

2380: -- cursor to update transaction status in the OKL_STREAM_INTERFACES table
2381: CURSOR sif_data_csr (trx_number IN NUMBER) IS
2382: SELECT
2383: ID,ORP_CODE
2384: FROM Okl_Stream_Interfaces
2385: WHERE okl_stream_interfaces.transaction_number = trx_number;
2386:
2387: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2388: lp_sifv_rec sifv_rec_type;

Line 2385: WHERE okl_stream_interfaces.transaction_number = trx_number;

2381: CURSOR sif_data_csr (trx_number IN NUMBER) IS
2382: SELECT
2383: ID,ORP_CODE
2384: FROM Okl_Stream_Interfaces
2385: WHERE okl_stream_interfaces.transaction_number = trx_number;
2386:
2387: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2388: lp_sifv_rec sifv_rec_type;
2389: lx_sifv_rec sifv_rec_type;

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

2434: p_srt_code IN VARCHAR2, -- inbound status
2435: p_log_file_name IN VARCHAR2,
2436: x_return_status OUT NOCOPY VARCHAR2
2437: ) IS
2438: -- cursor to update transaction status in the OKL_STREAM_INTERFACES table
2439: CURSOR sif_data_csr (trx_number IN NUMBER) IS
2440: SELECT
2441: ID,ORP_CODE
2442: FROM Okl_Stream_Interfaces

Line 2442: FROM Okl_Stream_Interfaces

2438: -- cursor to update transaction status in the OKL_STREAM_INTERFACES table
2439: CURSOR sif_data_csr (trx_number IN NUMBER) IS
2440: SELECT
2441: ID,ORP_CODE
2442: FROM Okl_Stream_Interfaces
2443: WHERE okl_stream_interfaces.transaction_number = trx_number;
2444:
2445: CURSOR sir_data_csr (trx_number IN NUMBER) IS
2446: SELECT

Line 2443: WHERE okl_stream_interfaces.transaction_number = trx_number;

2439: CURSOR sif_data_csr (trx_number IN NUMBER) IS
2440: SELECT
2441: ID,ORP_CODE
2442: FROM Okl_Stream_Interfaces
2443: WHERE okl_stream_interfaces.transaction_number = trx_number;
2444:
2445: CURSOR sir_data_csr (trx_number IN NUMBER) IS
2446: SELECT
2447: ID

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

2526: p_srt_code IN VARCHAR2, -- inbound status
2527: p_log_file_name IN VARCHAR2,
2528: x_return_status OUT NOCOPY VARCHAR2
2529: ) IS
2530: -- cursor to update transaction status in the OKL_STREAM_INTERFACES table
2531: CURSOR sif_data_csr (trx_number IN NUMBER) IS
2532: SELECT
2533: ID,ORP_CODE
2534: FROM Okl_Stream_Interfaces

Line 2534: FROM Okl_Stream_Interfaces

2530: -- cursor to update transaction status in the OKL_STREAM_INTERFACES table
2531: CURSOR sif_data_csr (trx_number IN NUMBER) IS
2532: SELECT
2533: ID,ORP_CODE
2534: FROM Okl_Stream_Interfaces
2535: WHERE okl_stream_interfaces.transaction_number = trx_number;
2536:
2537: CURSOR sir_data_csr (trx_number IN NUMBER) IS
2538: SELECT

Line 2535: WHERE okl_stream_interfaces.transaction_number = trx_number;

2531: CURSOR sif_data_csr (trx_number IN NUMBER) IS
2532: SELECT
2533: ID,ORP_CODE
2534: FROM Okl_Stream_Interfaces
2535: WHERE okl_stream_interfaces.transaction_number = trx_number;
2536:
2537: CURSOR sir_data_csr (trx_number IN NUMBER) IS
2538: SELECT
2539: ID

Line 2637: FROM Okl_Stream_Interfaces

2633:
2634: CURSOR sif_data_csr (trx_number IN NUMBER) IS
2635: SELECT
2636: SIS_CODE
2637: FROM Okl_Stream_Interfaces
2638: WHERE okl_stream_interfaces.transaction_number = trx_number;
2639: BEGIN
2640: x_ok_to_proceed := 'Y';
2641: FOR sif_data IN sif_data_csr(p_transaction_number)

Line 2638: WHERE okl_stream_interfaces.transaction_number = trx_number;

2634: CURSOR sif_data_csr (trx_number IN NUMBER) IS
2635: SELECT
2636: SIS_CODE
2637: FROM Okl_Stream_Interfaces
2638: WHERE okl_stream_interfaces.transaction_number = trx_number;
2639: BEGIN
2640: x_ok_to_proceed := 'Y';
2641: FOR sif_data IN sif_data_csr(p_transaction_number)
2642: LOOP

Line 2871: FROM okl_stream_interfaces

2867: -- smahapat added khr_id to cursor for bug 3145238
2868: CURSOR strm_interfaces_data_csr (p_trx_number NUMBER) IS
2869: SELECT
2870: ORP_CODE, KHR_ID
2871: FROM okl_stream_interfaces
2872: WHERE okl_stream_interfaces.transaction_number = p_trx_number;
2873:
2874: -- smahapat added for bug 3145238
2875: -- cursor to provide information for setting context

Line 2872: WHERE okl_stream_interfaces.transaction_number = p_trx_number;

2868: CURSOR strm_interfaces_data_csr (p_trx_number NUMBER) IS
2869: SELECT
2870: ORP_CODE, KHR_ID
2871: FROM okl_stream_interfaces
2872: WHERE okl_stream_interfaces.transaction_number = p_trx_number;
2873:
2874: -- smahapat added for bug 3145238
2875: -- cursor to provide information for setting context
2876: CURSOR l_hdr_csr(chrId NUMBER)