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 OKC_K_HEADERS_B

Line 166: FROM okc_k_headers_b CHR

162:
163: --cursor to check if contract is a re-lease contract
164: CURSOR l_chk_rel_khr_csr (p_chr_id IN NUMBER) IS
165: SELECT 'Y'
166: FROM okc_k_headers_b CHR
167: WHERE CHR.ID = p_chr_id
168: AND NVL (CHR.orig_system_source_code, 'XXXX') = 'OKL_RELEASE';
169:
170: l_rel_khr VARCHAR2 (1) DEFAULT 'N';

Line 178: FROM okc_k_headers_b CHR

174: /*
175: --cursor to check if contract has re-lease assets
176: CURSOR l_chk_rel_ast_csr (p_chr_id IN NUMBER) IS
177: SELECT 'Y'
178: FROM okc_k_headers_b CHR
179: WHERE NVL (CHR.orig_system_source_code, 'XXXX') <> 'OKL_RELEASE'
180: AND CHR.ID = p_chr_id
181: AND EXISTS (
182: SELECT '1'

Line 236: FROM okc_k_headers_b chrb

232: ) IS
233: --Cursor to check existence of contract
234: CURSOR l_chr_csr (p_chr_id IN NUMBER) IS
235: SELECT 'Y'
236: FROM okc_k_headers_b chrb
237: WHERE chrb.ID = p_chr_id AND chrb.scs_code = 'LEASE';
238:
239: l_exists VARCHAR2 (1) DEFAULT 'N';
240: BEGIN

Line 324: FROM okc_k_headers_b chrb, okl_k_headers khr

320:
321: CURSOR l_ptmpl_csr (p_chr_id IN NUMBER) IS
322: SELECT chrb.template_yn,
323: khr.template_type_code
324: FROM okc_k_headers_b chrb, okl_k_headers khr
325: WHERE chrb.ID = khr.ID AND chrb.ID = p_chr_id;
326:
327: l_template_type_code okl_k_headers.template_type_code%TYPE;
328: l_template_yn okc_k_headers_b.template_yn%TYPE;

Line 328: l_template_yn okc_k_headers_b.template_yn%TYPE;

324: FROM okc_k_headers_b chrb, okl_k_headers khr
325: WHERE chrb.ID = khr.ID AND chrb.ID = p_chr_id;
326:
327: l_template_type_code okl_k_headers.template_type_code%TYPE;
328: l_template_yn okc_k_headers_b.template_yn%TYPE;
329: l_pqcl_id okc_k_headers_b.qcl_id%TYPE;
330:
331: CURSOR l_ptmpl_qcl_csr (p_chr_id IN NUMBER) IS
332: SELECT chrb.qcl_id

Line 329: l_pqcl_id okc_k_headers_b.qcl_id%TYPE;

325: WHERE chrb.ID = khr.ID AND chrb.ID = p_chr_id;
326:
327: l_template_type_code okl_k_headers.template_type_code%TYPE;
328: l_template_yn okc_k_headers_b.template_yn%TYPE;
329: l_pqcl_id okc_k_headers_b.qcl_id%TYPE;
330:
331: CURSOR l_ptmpl_qcl_csr (p_chr_id IN NUMBER) IS
332: SELECT chrb.qcl_id
333: FROM okc_k_headers_b chrb

Line 333: FROM okc_k_headers_b chrb

329: l_pqcl_id okc_k_headers_b.qcl_id%TYPE;
330:
331: CURSOR l_ptmpl_qcl_csr (p_chr_id IN NUMBER) IS
332: SELECT chrb.qcl_id
333: FROM okc_k_headers_b chrb
334: WHERE chrb.ID = p_chr_id;
335:
336: /*
337: -- mvasudev, 08/30/2004

Line 1106: FROM okc_k_headers_b b

1102: CURSOR tmp_csr (chrid NUMBER) IS
1103: SELECT NVL (b.template_yn, 'N') template_yn,
1104: b.orig_system_source_code,
1105: b.orig_system_id1
1106: FROM okc_k_headers_b b
1107: WHERE b.ID = chrid;
1108:
1109: tmp_rec tmp_csr%ROWTYPE;
1110:

Line 1548: FROM okc_k_headers_b CHR, okl_k_headers khr

1544: --cursor to check for vendor program template
1545: CURSOR l_chk_template_csr (p_chr_id IN NUMBER) IS
1546: SELECT CHR.template_yn,
1547: khr.template_type_code
1548: FROM okc_k_headers_b CHR, okl_k_headers khr
1549: WHERE CHR.ID = p_chr_id AND CHR.ID = khr.ID;
1550:
1551: l_chk_template_rec l_chk_template_csr%ROWTYPE;
1552:

Line 2579: p_chr_id IN okc_k_headers_b.ID%TYPE,

2575: DEFAULT okl_api.g_false,
2576: x_return_status OUT NOCOPY VARCHAR2,
2577: x_msg_count OUT NOCOPY NUMBER,
2578: x_msg_data OUT NOCOPY VARCHAR2,
2579: p_chr_id IN okc_k_headers_b.ID%TYPE,
2580: x_termination_complete_yn OUT NOCOPY VARCHAR2
2581: ) IS
2582: l_api_name VARCHAR2 (35) := 'TERM_ORIGINAL_CONTRACT';
2583: l_proc_name VARCHAR2 (35) := 'TERM_ORIGINAL_CONTRACT';

Line 2584: ln_orig_system_source_code okc_k_headers_b.orig_system_source_code%TYPE;

2580: x_termination_complete_yn OUT NOCOPY VARCHAR2
2581: ) IS
2582: l_api_name VARCHAR2 (35) := 'TERM_ORIGINAL_CONTRACT';
2583: l_proc_name VARCHAR2 (35) := 'TERM_ORIGINAL_CONTRACT';
2584: ln_orig_system_source_code okc_k_headers_b.orig_system_source_code%TYPE;
2585: ln_orig_system_id1 okc_k_headers_b.orig_system_id1%TYPE;
2586: ln_orig_contract_number okc_k_headers_b.contract_number%TYPE;
2587:
2588: -- To get the orig system id for p_chr_id

Line 2585: ln_orig_system_id1 okc_k_headers_b.orig_system_id1%TYPE;

2581: ) IS
2582: l_api_name VARCHAR2 (35) := 'TERM_ORIGINAL_CONTRACT';
2583: l_proc_name VARCHAR2 (35) := 'TERM_ORIGINAL_CONTRACT';
2584: ln_orig_system_source_code okc_k_headers_b.orig_system_source_code%TYPE;
2585: ln_orig_system_id1 okc_k_headers_b.orig_system_id1%TYPE;
2586: ln_orig_contract_number okc_k_headers_b.contract_number%TYPE;
2587:
2588: -- To get the orig system id for p_chr_id
2589: CURSOR get_orig_sys_code (p_chr_id okc_k_headers_b.ID%TYPE) IS

Line 2586: ln_orig_contract_number okc_k_headers_b.contract_number%TYPE;

2582: l_api_name VARCHAR2 (35) := 'TERM_ORIGINAL_CONTRACT';
2583: l_proc_name VARCHAR2 (35) := 'TERM_ORIGINAL_CONTRACT';
2584: ln_orig_system_source_code okc_k_headers_b.orig_system_source_code%TYPE;
2585: ln_orig_system_id1 okc_k_headers_b.orig_system_id1%TYPE;
2586: ln_orig_contract_number okc_k_headers_b.contract_number%TYPE;
2587:
2588: -- To get the orig system id for p_chr_id
2589: CURSOR get_orig_sys_code (p_chr_id okc_k_headers_b.ID%TYPE) IS
2590: SELECT chr_new.orig_system_source_code,

Line 2589: CURSOR get_orig_sys_code (p_chr_id okc_k_headers_b.ID%TYPE) IS

2585: ln_orig_system_id1 okc_k_headers_b.orig_system_id1%TYPE;
2586: ln_orig_contract_number okc_k_headers_b.contract_number%TYPE;
2587:
2588: -- To get the orig system id for p_chr_id
2589: CURSOR get_orig_sys_code (p_chr_id okc_k_headers_b.ID%TYPE) IS
2590: SELECT chr_new.orig_system_source_code,
2591: chr_new.orig_system_id1,
2592: chr_old.contract_number
2593: FROM okc_k_headers_b chr_new, okc_k_headers_b chr_old

Line 2593: FROM okc_k_headers_b chr_new, okc_k_headers_b chr_old

2589: CURSOR get_orig_sys_code (p_chr_id okc_k_headers_b.ID%TYPE) IS
2590: SELECT chr_new.orig_system_source_code,
2591: chr_new.orig_system_id1,
2592: chr_old.contract_number
2593: FROM okc_k_headers_b chr_new, okc_k_headers_b chr_old
2594: WHERE chr_new.ID = p_chr_id AND chr_old.ID = chr_new.orig_system_id1;
2595:
2596: l_assn_tbl okl_am_create_quote_pvt.assn_tbl_type;
2597: l_assn_rec okl_am_create_quote_pvt.assn_rec_type;

Line 2660: okc_k_headers_b CHR,

2656: fab.asset_number asset_number,
2657: fab.current_units current_units
2658: FROM okc_k_lines_b fin_ast_cle,
2659: okc_k_lines_b fa_cle,
2660: okc_k_headers_b CHR,
2661: okc_line_styles_b fin_ast_lse,
2662: okc_line_styles_b fa_lse,
2663: okc_k_items cim,
2664: fa_additions_b fab

Line 2697: FROM okc_k_headers_b CHR

2693: chk_taa_term_rec chk_taa_term_csr%ROWTYPE;
2694:
2695: CURSOR chk_chr_term_csr (p_orig_chr_id IN NUMBER) IS
2696: SELECT CHR.sts_code
2697: FROM okc_k_headers_b CHR
2698: WHERE ID = p_orig_chr_id;
2699:
2700: chk_chr_term_rec chk_chr_term_csr%ROWTYPE;
2701:

Line 3517: FROM okc_k_headers_b CHR

3513:
3514: -- Sales Tax project changes END
3515: CURSOR l_chk_mass_rbk_csr (p_chr_id IN NUMBER) IS
3516: SELECT 'Y' what
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

Line 3572: CURSOR l_rq_fee_lns_bkg_csr (chrid IN okc_k_headers_b.ID%TYPE) IS

3568: that is booked for the first time. */
3569:
3570: -- nikshah -- Bug # 5484903 Fixed,
3571: -- Changed l_rq_fee_lns_bkg_csr SQL definition
3572: CURSOR l_rq_fee_lns_bkg_csr (chrid IN okc_k_headers_b.ID%TYPE) IS
3573: SELECT kle.qte_id
3574: FROM okc_k_headers_b khr, okc_k_lines_b cleb, okl_k_lines kle
3575: WHERE khr.ID = chrid
3576: AND cleb.dnz_chr_id = khr.ID

Line 3574: FROM okc_k_headers_b khr, okc_k_lines_b cleb, okl_k_lines kle

3570: -- nikshah -- Bug # 5484903 Fixed,
3571: -- Changed l_rq_fee_lns_bkg_csr SQL definition
3572: CURSOR l_rq_fee_lns_bkg_csr (chrid IN okc_k_headers_b.ID%TYPE) IS
3573: SELECT kle.qte_id
3574: FROM okc_k_headers_b khr, okc_k_lines_b cleb, okl_k_lines kle
3575: WHERE khr.ID = chrid
3576: AND cleb.dnz_chr_id = khr.ID
3577: AND kle.ID = cleb.ID
3578: AND kle.fee_type = 'ROLLOVER'

Line 3598: CURSOR l_rq_fee_lns_rbk_csr (chrid IN okc_k_headers_b.ID%TYPE) IS

3594: to a re-book contract. */
3595:
3596: -- nikshah -- Bug # 5484903 Fixed
3597: -- Changed CURSOR l_rq_fee_lns_rbk_csr SQL definition
3598: CURSOR l_rq_fee_lns_rbk_csr (chrid IN okc_k_headers_b.ID%TYPE) IS
3599: SELECT kle.qte_id
3600: FROM okc_k_headers_b khr, okc_k_lines_b cleb, okl_k_lines kle
3601: WHERE khr.ID = chrid
3602: AND cleb.dnz_chr_id = khr.ID

Line 3600: FROM okc_k_headers_b khr, okc_k_lines_b cleb, okl_k_lines kle

3596: -- nikshah -- Bug # 5484903 Fixed
3597: -- Changed CURSOR l_rq_fee_lns_rbk_csr SQL definition
3598: CURSOR l_rq_fee_lns_rbk_csr (chrid IN okc_k_headers_b.ID%TYPE) IS
3599: SELECT kle.qte_id
3600: FROM okc_k_headers_b khr, okc_k_lines_b cleb, okl_k_lines kle
3601: WHERE khr.ID = chrid
3602: AND cleb.dnz_chr_id = khr.ID
3603: AND kle.ID = cleb.ID
3604: AND kle.fee_type = 'ROLLOVER'

Line 3622: CURSOR l_chk_rbk_csr (chrid IN okc_k_headers_b.ID%TYPE) IS

3618:
3619: l_ro_fee_rbk_found BOOLEAN := FALSE;
3620:
3621: /* Cursor to check if the contract is rebooked contract. */
3622: CURSOR l_chk_rbk_csr (chrid IN okc_k_headers_b.ID%TYPE) IS
3623: SELECT '!'
3624: FROM okc_k_headers_b CHR
3625: WHERE CHR.ID = chrid AND CHR.orig_system_source_code = 'OKL_REBOOK';
3626:

Line 3624: FROM okc_k_headers_b CHR

3620:
3621: /* Cursor to check if the contract is rebooked contract. */
3622: CURSOR l_chk_rbk_csr (chrid IN okc_k_headers_b.ID%TYPE) IS
3623: SELECT '!'
3624: FROM okc_k_headers_b CHR
3625: WHERE CHR.ID = chrid AND CHR.orig_system_source_code = 'OKL_REBOOK';
3626:
3627: l_qte_id okl_k_lines.qte_id%TYPE;
3628: l_creditline_id okl_k_lines.qte_id%TYPE;

Line 3645: CURSOR l_k_std_csr (chrid okc_k_headers_b.ID%TYPE) IS

3641: (less than or equal to SYSDATE). */
3642:
3643: -- nikshah -- Bug # 5484903 Fixed,
3644: -- Changed CURSOR l_k_std_csr SQL definition
3645: CURSOR l_k_std_csr (chrid okc_k_headers_b.ID%TYPE) IS
3646: SELECT 1
3647: FROM okc_k_lines_v cleb, okl_k_lines kle, okc_k_headers_b khr
3648: WHERE khr.ID = chrid
3649: AND cleb.dnz_chr_id = khr.ID

Line 3647: FROM okc_k_lines_v cleb, okl_k_lines kle, okc_k_headers_b khr

3643: -- nikshah -- Bug # 5484903 Fixed,
3644: -- Changed CURSOR l_k_std_csr SQL definition
3645: CURSOR l_k_std_csr (chrid okc_k_headers_b.ID%TYPE) IS
3646: SELECT 1
3647: FROM okc_k_lines_v cleb, okl_k_lines kle, okc_k_headers_b khr
3648: WHERE khr.ID = chrid
3649: AND cleb.dnz_chr_id = khr.ID
3650: AND kle.ID = cleb.ID
3651: AND kle.fee_type = 'ROLLOVER'

Line 3668: CURSOR l_k_std__4rbk_csr (chrid okc_k_headers_b.ID%TYPE) IS

3664:
3665: /* Cursor for Re-book contract */
3666: -- nikshah -- Bug # 5484903 Fixed,
3667: -- Changed CURSOR l_k_std__4rbk_csr SQL definition
3668: CURSOR l_k_std__4rbk_csr (chrid okc_k_headers_b.ID%TYPE) IS
3669: SELECT 1
3670: FROM okc_k_lines_v cleb, okl_k_lines kle, okc_k_headers_b khr
3671: WHERE khr.ID = chrid
3672: AND cleb.dnz_chr_id = khr.ID

Line 3670: FROM okc_k_lines_v cleb, okl_k_lines kle, okc_k_headers_b khr

3666: -- nikshah -- Bug # 5484903 Fixed,
3667: -- Changed CURSOR l_k_std__4rbk_csr SQL definition
3668: CURSOR l_k_std__4rbk_csr (chrid okc_k_headers_b.ID%TYPE) IS
3669: SELECT 1
3670: FROM okc_k_lines_v cleb, okl_k_lines kle, okc_k_headers_b khr
3671: WHERE khr.ID = chrid
3672: AND cleb.dnz_chr_id = khr.ID
3673: AND kle.ID = cleb.ID
3674: AND kle.fee_type = 'ROLLOVER'

Line 3699: FROM okc_k_headers_b CHR

3695: --Bug# 3948361: start
3696: --cursor to check if contract is a re-lease contract
3697: CURSOR l_chk_rel_khr_csr (p_chr_id IN NUMBER) IS
3698: SELECT '!'
3699: FROM okc_k_headers_b CHR
3700: WHERE CHR.ID = p_chr_id
3701: AND NVL (CHR.orig_system_source_code, 'XXXX') = 'OKL_RELEASE';
3702:
3703: l_rel_khr VARCHAR2 (1);

Line 3713: FROM okc_k_headers_b CHR, okl_k_headers khr

3709: --cursor to check for vendor program template
3710: CURSOR l_chk_template_csr (p_chr_id IN NUMBER) IS
3711: SELECT CHR.template_yn,
3712: khr.template_type_code
3713: FROM okc_k_headers_b CHR, okl_k_headers khr
3714: WHERE CHR.ID = p_chr_id AND CHR.ID = khr.ID;
3715:
3716: l_chk_template_rec l_chk_template_csr%ROWTYPE;
3717:

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 3743: FROM okl_products_v pdt, okl_k_headers_v khr, okc_k_headers_b CHR

3739: --ramurt Bug#4622438
3740: CURSOR chk_product_status (p_chr_id IN NUMBER) IS
3741: SELECT pdt.NAME,
3742: pdt.product_status_code
3743: FROM okl_products_v pdt, okl_k_headers_v khr, okc_k_headers_b CHR
3744: WHERE 1 = 1
3745: AND khr.ID = p_chr_id
3746: AND pdt_id = pdt.ID
3747: AND khr.ID = CHR.ID;

Line 4985: FROM okc_k_headers_b chrb, okc_statuses_v stsv

4981: CURSOR l_chr_csr (p_chr_id IN NUMBER) IS
4982: SELECT chrb.qcl_id,
4983: stsv.ste_code,
4984: stsv.meaning
4985: FROM okc_k_headers_b chrb, okc_statuses_v stsv
4986: WHERE chrb.ID = p_chr_id
4987: AND chrb.sts_code = stsv.code
4988: AND chrb.scs_code = 'LEASE';
4989:

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 5744: CURSOR sts_code_csr (p_khr_id okc_k_headers_b.ID%TYPE) IS

5740: := 'APPROVE_ACTIVATE_CONTRACT';
5741: l_api_version CONSTANT NUMBER := 1.0;
5742:
5743: --cursor to fetch the contract status
5744: CURSOR sts_code_csr (p_khr_id okc_k_headers_b.ID%TYPE) IS
5745: SELECT sts_code
5746: FROM okc_k_headers_b
5747: WHERE ID = p_khr_id;
5748:

Line 5746: FROM okc_k_headers_b

5742:
5743: --cursor to fetch the contract status
5744: CURSOR sts_code_csr (p_khr_id okc_k_headers_b.ID%TYPE) IS
5745: SELECT sts_code
5746: FROM okc_k_headers_b
5747: WHERE ID = p_khr_id;
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

Line 5750: CURSOR get_term_qte_num (p_khr_id okc_k_headers_b.ID%TYPE) IS

5746: FROM okc_k_headers_b
5747: WHERE ID = p_khr_id;
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,

Line 5755: okc_k_headers_b CHR

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
5757: AND tcn.khr_id_new = CHR.ID
5758: AND tcn_type = 'MAE'
5759: AND tcn.tsu_code <> 'PROCESSED'

Line 5770: l_sts_code okc_k_headers_b.sts_code%TYPE;

5766: AND tcn.qte_id = qte.ID
5767: AND CHR.ID = p_khr_id;
5768:
5769: l_rem_amt NUMBER;
5770: l_sts_code okc_k_headers_b.sts_code%TYPE;
5771: l_qte_num okl_trx_quotes_b.quote_number%TYPE;
5772: l_approval_path VARCHAR2 (30);
5773: contract_activation_failed EXCEPTION;
5774:

Line 5778: FROM okc_k_headers_b CHR

5774:
5775: -- Bug# 5038395
5776: CURSOR l_chk_mass_rbk_csr (p_chr_id IN NUMBER) IS
5777: SELECT 'Y' mass_rbk_yn
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