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

Line 630: FROM okl_trx_contracts trx, okl_trx_types_tl trx_type

626: l_failstatus VARCHAR2 (256);
627:
628: CURSOR l_rebooked_csr (chrid NUMBER) IS
629: SELECT date_transaction_occurred
630: FROM okl_trx_contracts trx, okl_trx_types_tl trx_type
631: WHERE trx.khr_id_old = chrid
632: AND trx.khr_id_new IS NOT NULL
633: AND trx.tsu_code = 'ENTERED'
634: AND trx.tcn_type = 'TRBK'

Line 2311: FROM okl_trx_contracts tcn, okl_trx_types_tl try

2307: SELECT tcn.ID,
2308: tcn.source_trx_id,
2309: tcn.date_transaction_occurred,
2310: tcn.qte_id
2311: FROM okl_trx_contracts tcn, okl_trx_types_tl try
2312: WHERE tcn.khr_id_old = p_orig_chr_id
2313: AND tcn.khr_id_new = p_new_chr_id
2314: AND tcn_type = 'MAE'
2315: AND tcn.tsu_code <> 'PROCESSED'

Line 2406: l_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;

2402: WHERE ID = p_qte_id;
2403:
2404: quote_num_rec quote_num_csr%ROWTYPE;
2405: i NUMBER;
2406: l_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;
2407: l_out_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;
2408: l_termination_complete VARCHAR2 (30);
2409:
2410: --Bug# 4061058

Line 2407: l_out_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;

2403:
2404: quote_num_rec quote_num_csr%ROWTYPE;
2405: i NUMBER;
2406: l_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;
2407: l_out_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;
2408: l_termination_complete VARCHAR2 (30);
2409:
2410: --Bug# 4061058
2411: CURSOR taa_request_csr (p_source_trx_id IN NUMBER) IS

Line 2413: FROM okl_trx_contracts

2409:
2410: --Bug# 4061058
2411: CURSOR taa_request_csr (p_source_trx_id IN NUMBER) IS
2412: SELECT complete_transfer_yn
2413: FROM okl_trx_contracts
2414: WHERE ID = p_source_trx_id;
2415:
2416: taa_request_rec taa_request_csr%ROWTYPE;
2417:

Line 2423: FROM okl_trx_contracts

2419: CURSOR termination_trx_csr (p_qte_id IN NUMBER, p_khr_id IN NUMBER) IS
2420: --Bug# 6504515
2421: --SELECT tsu_code
2422: SELECT tmt_status_code
2423: FROM okl_trx_contracts
2424: WHERE qte_id = p_qte_id
2425: AND khr_id = p_khr_id
2426: AND tcn_type IN ('ALT', 'TMT')
2427: --rkuttiya added for 12.1.1 Multi GAAP Project

Line 2765: 'Before OKL_TRX_CONTRACTS_PUB.update_trx_contracts'

2761: IF (is_debug_statement_on) THEN
2762: okl_debug_pub.log_debug
2763: (g_level_statement,
2764: l_module_name,
2765: 'Before OKL_TRX_CONTRACTS_PUB.update_trx_contracts'
2766: );
2767: okl_debug_pub.log_debug (g_level_statement,
2768: l_module_name,
2769: 'l_term_rec.id =>'

Line 2817: 'Before OKL_TRX_CONTRACTS_PUB.update_trx_contracts'

2813: IF (is_debug_statement_on) THEN
2814: okl_debug_pub.log_debug
2815: (g_level_statement,
2816: l_module_name,
2817: 'Before OKL_TRX_CONTRACTS_PUB.update_trx_contracts'
2818: );
2819: okl_debug_pub.log_debug (g_level_statement,
2820: l_module_name,
2821: 'l_tcnv_rec.id =>'

Line 2831: okl_trx_contracts_pub.update_trx_contracts

2827: || x_quot_rec.ID
2828: );
2829: END IF;
2830:
2831: okl_trx_contracts_pub.update_trx_contracts
2832: (p_api_version => p_api_version,
2833: p_init_msg_list => p_init_msg_list,
2834: x_return_status => x_return_status,
2835: x_msg_count => x_msg_count,

Line 3207: SUBTYPE tcnv_rec_type IS okl_trx_contracts_pvt.tcnv_rec_type;

3203: l_cimv_tbl okl_okc_migration_pvt.cimv_tbl_type;
3204: x_message VARCHAR2 (256);
3205:
3206: -- Sales Tax project changes START - BUG 4373029
3207: SUBTYPE tcnv_rec_type IS okl_trx_contracts_pvt.tcnv_rec_type;
3208:
3209: x_trxh_rec tcnv_rec_type;
3210:
3211: -- Sales Tax project changes END

Line 3218: FROM okl_trx_contracts ktrx

3214: FROM okc_k_headers_b CHR
3215: WHERE CHR.ID = p_chr_id
3216: AND EXISTS (
3217: SELECT '1'
3218: FROM okl_trx_contracts ktrx
3219: WHERE ktrx.khr_id = CHR.ID
3220: AND ktrx.tsu_code = 'ENTERED'
3221: AND ktrx.rbr_code IS NOT NULL
3222: AND ktrx.tcn_type = 'TRBK'

Line 3422: FROM okc_k_headers_b CHR, okl_trx_contracts ktrx

3418: */
3419: CURSOR l_rbk_trx_csr IS
3420: SELECT ktrx.khr_id,
3421: ktrx.date_transaction_occurred
3422: FROM okc_k_headers_b CHR, okl_trx_contracts ktrx
3423: WHERE ktrx.khr_id_new = CHR.ID
3424: AND ktrx.tsu_code = 'ENTERED'
3425: AND ktrx.rbr_code IS NOT NULL
3426: AND ktrx.tcn_type = 'TRBK'

Line 3449: l_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;

3445:
3446: l_product_status_code okl_products_v.product_status_code%TYPE;
3447: l_product_name okl_products_v.NAME%TYPE;
3448: -- 4577840 end
3449: l_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;
3450: -- 4895333;
3451: --Bug# 4631549
3452: l_mass_rebook_yn VARCHAR2 (1);
3453:

Line 4804: FROM okc_k_headers_b CHR, okl_trx_contracts ktrx

4800: SELECT '!',
4801: CHR.orig_system_id1,
4802: ktrx.date_transaction_occurred,
4803: ktrx.ID
4804: FROM okc_k_headers_b CHR, okl_trx_contracts ktrx
4805: WHERE ktrx.khr_id_new = CHR.ID
4806: AND ktrx.tsu_code = 'ENTERED'
4807: AND ktrx.rbr_code IS NOT NULL
4808: AND ktrx.tcn_type = 'TRBK'

Line 4819: FROM okc_k_headers_b CHR, okl_trx_contracts ktrx

4815: -- Bug 6157438
4816: --cursor to check if the contract is selected for Mass Rebook
4817: CURSOR l_chk_mass_rbk_csr (p_chr_id IN NUMBER) IS
4818: SELECT '!'
4819: FROM okc_k_headers_b CHR, okl_trx_contracts ktrx
4820: WHERE CHR.ID = p_chr_id
4821: AND ktrx.khr_id = CHR.ID
4822: AND ktrx.tsu_code = 'ENTERED'
4823: AND ktrx.rbr_code IS NOT NULL

Line 5212: FROM okl_trx_contracts tcn,

5208:
5209: --cursor to fetch quote number to check for re-leasing
5210: CURSOR get_term_qte_num (p_khr_id okc_k_headers_b.ID%TYPE) IS
5211: SELECT qte.quote_number
5212: FROM okl_trx_contracts tcn,
5213: okl_trx_types_tl try,
5214: okl_trx_quotes_b qte,
5215: okc_k_headers_b CHR
5216: WHERE tcn.khr_id_old = CHR.orig_system_id1

Line 5242: FROM okl_trx_contracts ktrx

5238: FROM okc_k_headers_b CHR
5239: WHERE CHR.ID = p_chr_id
5240: AND EXISTS (
5241: SELECT '1'
5242: FROM okl_trx_contracts ktrx
5243: WHERE ktrx.khr_id = CHR.ID
5244: AND ktrx.tsu_code = 'ENTERED'
5245: AND ktrx.rbr_code IS NOT NULL
5246: AND ktrx.tcn_type = 'TRBK'