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_CONTRACT_REBOOK_PVT dependencies on OKL_TRX_CONTRACTS

Line 17: -- subtype tcnv_rec_type IS OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;

13:
14: --Bug# 4212626
15: G_INSURANCE_LSE_ID CONSTANT NUMBER := 47;
16:
17: -- subtype tcnv_rec_type IS OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
18: SUBTYPE stmv_rec_type IS OKL_STREAMS_PUB.stmv_rec_type;
19: SUBTYPE stmv_tbl_type IS OKL_STREAMS_PUB.stmv_tbl_type;
20: SUBTYPE selv_rec_type IS OKL_STREAMS_PUB.selv_rec_type;
21: SUBTYPE selv_tbl_type IS OKL_STREAMS_PUB.selv_tbl_type;

Line 3324: FROM okl_trx_contracts

3320: CURSOR txn_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
3321: SELECT trx_number,
3322: rbr_code,
3323: date_transaction_occurred
3324: FROM okl_trx_contracts
3325: WHERE khr_id = p_chr_id
3326: AND tcn_type = 'TRBK'
3327: AND tsu_code = 'ENTERED'
3328: AND representation_type = 'PRIMARY'; -- MGAAP 7263041

Line 3360: l_trx_date okl_trx_contracts.date_transaction_occurred%TYPE;

3356: l_cplv_rec cplv_rec_type;
3357: x_cplv_rec cplv_rec_type;
3358:
3359: l_cle_id OKC_K_LINES_B.ID%TYPE;
3360: l_trx_date okl_trx_contracts.date_transaction_occurred%TYPE;
3361:
3362: l_rgpv_rec rgpv_rec_type;
3363: x_rgpv_rec rgpv_rec_type;
3364: l_rulv_rec rulv_rec_type;

Line 7012: FROM OKL_TRX_CONTRACTS

7008: x_update_klev_tbl klev_tbl_type;
7009:
7010: CURSOR trx_csr(p_chr_id_new OKC_K_HEADERS_V.ID%TYPE) IS
7011: SELECT id
7012: FROM OKL_TRX_CONTRACTS
7013: WHERE khr_id_new = p_chr_id_new
7014: AND representation_type = 'PRIMARY'; -- MGAAP 7263041
7015:
7016: BEGIN

Line 7501: FROM okl_trx_contracts

7497: l_api_version CONSTANT NUMBER := 1;
7498:
7499: CURSOR txn_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
7500: SELECT date_transaction_occurred
7501: FROM okl_trx_contracts
7502: WHERE khr_id = p_chr_id
7503: AND tcn_type = 'TRBK'
7504: AND tsu_code = 'ENTERED'
7505: AND representation_type = 'PRIMARY'; -- MGAAP 7263041

Line 7788: okl_trx_contracts ktrx,

7784: cursor l_rbk_trx_csr(p_chr_id IN NUMBER) is
7785: SELECT ktrx.date_transaction_occurred,ktrx.id,
7786: khr.multi_gaap_yn, pdt.reporting_pdt_id -- MGAAP 7263041
7787: FROM okc_k_headers_b CHR,
7788: okl_trx_contracts ktrx,
7789: okl_k_headers khr,
7790: okl_products pdt
7791: WHERE ktrx.khr_id_new = chr.id
7792: AND ktrx.tsu_code = 'ENTERED'

Line 7806: lx_trx_number OKL_TRX_CONTRACTS.trx_number%TYPE := null; -- MGAAP 7263041

7802:
7803: l_rbk_trx_rec l_rbk_trx_csr%ROWTYPE;
7804: l_inv_accrual_rec OKL_GENERATE_ACCRUALS_PVT.adjust_accrual_rec_type;
7805: l_inv_stream_tbl OKL_GENERATE_ACCRUALS_PVT.stream_tbl_type;
7806: lx_trx_number OKL_TRX_CONTRACTS.trx_number%TYPE := null; -- MGAAP 7263041
7807: -- Bug# 4775555: End
7808:
7809: --Bug# 9191475
7810: lx_trxnum_tbl OKL_GENERATE_ACCRUALS_PVT.trxnum_tbl_type;

Line 8407: okl_trx_contracts ktrx

8403:
8404: CURSOR chk_rbk_csr(p_chr_id IN NUMBER) is
8405: SELECT '!',chr.orig_system_id1, ktrx.id
8406: FROM okc_k_headers_b chr,
8407: okl_trx_contracts ktrx
8408: WHERE ktrx.khr_id_new = chr.id
8409: AND ktrx.tsu_code = 'ENTERED'
8410: AND ktrx.rbr_code is NOT NULL
8411: AND ktrx.tcn_type = 'TRBK'

Line 8419: okl_trx_contracts ktrx

8415:
8416: CURSOR chk_mass_rbk_csr (p_chr_id IN NUMBER) IS
8417: SELECT '!', ktrx.id
8418: FROM okc_k_headers_b chr,
8419: okl_trx_contracts ktrx
8420: WHERE chr.id = p_chr_id
8421: AND ktrx.khr_id = chr.id
8422: AND ktrx.tsu_code = 'ENTERED'
8423: AND ktrx.rbr_code IS NOT NULL

Line 9554: lx_trx_number OKL_TRX_CONTRACTS.trx_number%TYPE;

9550:
9551: l_selv_count NUMBER;
9552:
9553: i NUMBER;
9554: lx_trx_number OKL_TRX_CONTRACTS.trx_number%TYPE;
9555: l_accrual_rec OKL_GENERATE_ACCRUALS_PVT.adjust_accrual_rec_type;
9556: l_stream_tbl OKL_GENERATE_ACCRUALS_PVT.stream_tbl_type;
9557: l_gl_date DATE;
9558:

Line 9924: --lx_trx_number OKL_TRX_CONTRACTS.trx_number%TYPE;

9920:
9921: l_selv_count NUMBER;
9922:
9923: i NUMBER;
9924: --lx_trx_number OKL_TRX_CONTRACTS.trx_number%TYPE;
9925: l_accrual_rec OKL_GENERATE_ACCRUALS_PVT.adjust_accrual_rec_type;
9926: l_stream_tbl OKL_GENERATE_ACCRUALS_PVT.stream_tbl_type;
9927: l_gl_date DATE;
9928:

Line 10709: okl_trx_contracts ktrx,

10705: --get the Online Rebook transaction in ENTERED status for Primary representation
10706: CURSOR chk_rbk_csr(p_chr_id IN NUMBER) is
10707: SELECT '!', ktrx.id
10708: FROM okc_k_headers_b chr,
10709: okl_trx_contracts ktrx,
10710: okc_k_headers_b cpy_chr
10711: WHERE ktrx.khr_id = chr.id
10712: AND ktrx.khr_id_new = cpy_chr.id
10713: AND ktrx.tsu_code = 'ENTERED'

Line 10729: okl_trx_contracts ktrx,

10725: --get the Online Rebook transaction in Entered status for secondary representation
10726: CURSOR chk_rbk_secondary_csr(p_chr_id IN NUMBER) is
10727: SELECT '!', ktrx.id
10728: FROM okc_k_headers_b chr,
10729: okl_trx_contracts ktrx,
10730: okc_k_headers_b cpy_chr
10731: WHERE ktrx.khr_id = chr.id
10732: AND ktrx.khr_id_new = cpy_chr.id
10733: AND ktrx.tsu_code = 'ENTERED'

Line 10745: okl_trx_contracts ktrx

10741: --Get the mass rebook transaction in Entered status for primary representation
10742: CURSOR chk_mass_rbk_csr (p_chr_id IN NUMBER) IS
10743: SELECT '!', ktrx.id
10744: FROM okc_k_headers_b chr,
10745: okl_trx_contracts ktrx
10746: WHERE chr.id = p_chr_id
10747: AND ktrx.khr_id = chr.id
10748: AND ktrx.tsu_code = 'ENTERED'
10749: AND ktrx.rbr_code IS NOT NULL --sechawla : added comment: identifies the actual online rebook process transaction.

Line 10765: okl_trx_contracts ktrx

10761: --get the Mass Rebook transaction in Entered status for secondary representation
10762: CURSOR chk_mass_rbk_secondary_csr (p_chr_id IN NUMBER) IS
10763: SELECT '!', ktrx.id
10764: FROM okc_k_headers_b chr,
10765: okl_trx_contracts ktrx
10766: WHERE chr.id = p_chr_id
10767: AND ktrx.khr_id = chr.id
10768: AND ktrx.tsu_code = 'ENTERED'
10769: AND ktrx.rbr_code IS NOT NULL