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.

[Home] [Help]

APPS.OKL_CONTRACT_BOOK_PVT dependencies on OKL_TRX_CONTRACTS

Line 724: FROM okl_trx_contracts trx, okl_trx_types_tl trx_type

720: l_failstatus VARCHAR2 (256);
721:
722: CURSOR l_rebooked_csr (chrid NUMBER) IS
723: SELECT date_transaction_occurred
724: FROM okl_trx_contracts trx, okl_trx_types_tl trx_type
725: WHERE trx.khr_id_old = chrid
726: AND trx.khr_id_new IS NOT NULL
727: AND trx.tsu_code = 'ENTERED'
728: AND trx.tcn_type = 'TRBK'

Line 2614: FROM okl_trx_contracts tcn, okl_trx_types_tl try

2610: SELECT tcn.ID,
2611: tcn.source_trx_id,
2612: tcn.date_transaction_occurred,
2613: tcn.qte_id
2614: FROM okl_trx_contracts tcn, okl_trx_types_tl try
2615: WHERE tcn.khr_id_old = p_orig_chr_id
2616: AND tcn.khr_id_new = p_new_chr_id
2617: AND tcn_type = 'MAE'
2618: AND tcn.tsu_code <> 'PROCESSED'

Line 2709: l_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;

2705: WHERE ID = p_qte_id;
2706:
2707: quote_num_rec quote_num_csr%ROWTYPE;
2708: i NUMBER;
2709: l_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;
2710: l_out_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;
2711: l_termination_complete VARCHAR2 (30);
2712:
2713: --Bug# 4061058

Line 2710: l_out_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;

2706:
2707: quote_num_rec quote_num_csr%ROWTYPE;
2708: i NUMBER;
2709: l_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;
2710: l_out_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;
2711: l_termination_complete VARCHAR2 (30);
2712:
2713: --Bug# 4061058
2714: CURSOR taa_request_csr (p_source_trx_id IN NUMBER) IS

Line 2716: FROM okl_trx_contracts

2712:
2713: --Bug# 4061058
2714: CURSOR taa_request_csr (p_source_trx_id IN NUMBER) IS
2715: SELECT complete_transfer_yn
2716: FROM okl_trx_contracts
2717: WHERE ID = p_source_trx_id;
2718:
2719: taa_request_rec taa_request_csr%ROWTYPE;
2720:

Line 2726: FROM okl_trx_contracts

2722: CURSOR termination_trx_csr (p_qte_id IN NUMBER, p_khr_id IN NUMBER) IS
2723: --Bug# 6504515
2724: --SELECT tsu_code
2725: SELECT tmt_status_code
2726: FROM okl_trx_contracts
2727: WHERE qte_id = p_qte_id
2728: AND khr_id = p_khr_id
2729: AND tcn_type IN ('ALT', 'TMT')
2730: --rkuttiya added for 12.1.1 Multi GAAP Project

Line 3068: 'Before OKL_TRX_CONTRACTS_PUB.update_trx_contracts'

3064: IF (is_debug_statement_on) THEN
3065: okl_debug_pub.log_debug
3066: (g_level_statement,
3067: l_module_name,
3068: 'Before OKL_TRX_CONTRACTS_PUB.update_trx_contracts'
3069: );
3070: okl_debug_pub.log_debug (g_level_statement,
3071: l_module_name,
3072: 'l_term_rec.id =>'

Line 3120: 'Before OKL_TRX_CONTRACTS_PUB.update_trx_contracts'

3116: IF (is_debug_statement_on) THEN
3117: okl_debug_pub.log_debug
3118: (g_level_statement,
3119: l_module_name,
3120: 'Before OKL_TRX_CONTRACTS_PUB.update_trx_contracts'
3121: );
3122: okl_debug_pub.log_debug (g_level_statement,
3123: l_module_name,
3124: 'l_tcnv_rec.id =>'

Line 3134: okl_trx_contracts_pub.update_trx_contracts

3130: || x_quot_rec.ID
3131: );
3132: END IF;
3133:
3134: okl_trx_contracts_pub.update_trx_contracts
3135: (p_api_version => p_api_version,
3136: p_init_msg_list => p_init_msg_list,
3137: x_return_status => x_return_status,
3138: x_msg_count => x_msg_count,

Line 3510: SUBTYPE tcnv_rec_type IS okl_trx_contracts_pvt.tcnv_rec_type;

3506: l_cimv_tbl okl_okc_migration_pvt.cimv_tbl_type;
3507: x_message VARCHAR2 (256);
3508:
3509: -- Sales Tax project changes START - BUG 4373029
3510: SUBTYPE tcnv_rec_type IS okl_trx_contracts_pvt.tcnv_rec_type;
3511:
3512: x_trxh_rec tcnv_rec_type;
3513:
3514: -- Sales Tax project changes END

Line 3521: FROM okl_trx_contracts ktrx

3517: FROM okc_k_headers_b CHR
3518: WHERE CHR.ID = p_chr_id
3519: AND EXISTS (
3520: SELECT '1'
3521: FROM okl_trx_contracts ktrx
3522: WHERE ktrx.khr_id = CHR.ID
3523: AND ktrx.tsu_code = 'ENTERED'
3524: AND ktrx.rbr_code IS NOT NULL
3525: AND ktrx.tcn_type = 'TRBK'

Line 3725: FROM okc_k_headers_b CHR, okl_trx_contracts ktrx

3721: */
3722: CURSOR l_rbk_trx_csr IS
3723: SELECT ktrx.khr_id,
3724: ktrx.date_transaction_occurred
3725: FROM okc_k_headers_b CHR, okl_trx_contracts ktrx
3726: WHERE ktrx.khr_id_new = CHR.ID
3727: AND ktrx.tsu_code = 'ENTERED'
3728: AND ktrx.rbr_code IS NOT NULL
3729: AND ktrx.tcn_type = 'TRBK'

Line 3752: l_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;

3748:
3749: l_product_status_code okl_products_v.product_status_code%TYPE;
3750: l_product_name okl_products_v.NAME%TYPE;
3751: -- 4577840 end
3752: l_tcnv_rec okl_trx_contracts_pvt.tcnv_rec_type;
3753: -- 4895333;
3754: --Bug# 4631549
3755: l_mass_rebook_yn VARCHAR2 (1);
3756:

Line 5272: FROM okc_k_headers_b CHR, okl_trx_contracts ktrx

5268: SELECT '!',
5269: CHR.orig_system_id1,
5270: ktrx.date_transaction_occurred,
5271: ktrx.ID
5272: FROM okc_k_headers_b CHR, okl_trx_contracts ktrx
5273: WHERE ktrx.khr_id_new = CHR.ID
5274: AND ktrx.tsu_code = 'ENTERED'
5275: AND ktrx.rbr_code IS NOT NULL
5276: AND ktrx.tcn_type = 'TRBK'

Line 5287: FROM okc_k_headers_b CHR, okl_trx_contracts ktrx

5283: -- Bug 6157438
5284: --cursor to check if the contract is selected for Mass Rebook
5285: CURSOR l_chk_mass_rbk_csr (p_chr_id IN NUMBER) IS
5286: SELECT '!'
5287: FROM okc_k_headers_b CHR, okl_trx_contracts ktrx
5288: WHERE CHR.ID = p_chr_id
5289: AND ktrx.khr_id = CHR.ID
5290: AND ktrx.tsu_code = 'ENTERED'
5291: AND ktrx.rbr_code IS NOT NULL

Line 5752: FROM okl_trx_contracts tcn,

5748:
5749: --cursor to fetch quote number to check for re-leasing
5750: CURSOR get_term_qte_num (p_khr_id okc_k_headers_b.ID%TYPE) IS
5751: SELECT qte.quote_number
5752: FROM okl_trx_contracts tcn,
5753: okl_trx_types_tl try,
5754: okl_trx_quotes_b qte,
5755: okc_k_headers_b CHR
5756: WHERE tcn.khr_id_old = CHR.orig_system_id1

Line 5782: FROM okl_trx_contracts ktrx

5778: FROM okc_k_headers_b CHR
5779: WHERE CHR.ID = p_chr_id
5780: AND EXISTS (
5781: SELECT '1'
5782: FROM okl_trx_contracts ktrx
5783: WHERE ktrx.khr_id = CHR.ID
5784: AND ktrx.tsu_code = 'ENTERED'
5785: AND ktrx.rbr_code IS NOT NULL
5786: AND ktrx.tcn_type = 'TRBK'