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 84: FROM okc_k_headers_b CHR

80:
81: --cursor to check if contract is a re-lease contract
82: CURSOR l_chk_rel_khr_csr (p_chr_id IN NUMBER) IS
83: SELECT 'Y'
84: FROM okc_k_headers_b CHR
85: WHERE CHR.ID = p_chr_id
86: AND NVL (CHR.orig_system_source_code, 'XXXX') = 'OKL_RELEASE';
87:
88: l_rel_khr VARCHAR2 (1) DEFAULT 'N';

Line 93: FROM okc_k_headers_b CHR

89:
90: --cursor to check if contract has re-lease assets
91: CURSOR l_chk_rel_ast_csr (p_chr_id IN NUMBER) IS
92: SELECT 'Y'
93: FROM okc_k_headers_b CHR
94: WHERE NVL (CHR.orig_system_source_code, 'XXXX') <> 'OKL_RELEASE'
95: AND CHR.ID = p_chr_id
96: AND EXISTS (
97: SELECT '1'

Line 142: FROM okc_k_headers_b chrb

138: ) IS
139: --Cursor to check existence of contract
140: CURSOR l_chr_csr (p_chr_id IN NUMBER) IS
141: SELECT 'Y'
142: FROM okc_k_headers_b chrb
143: WHERE chrb.ID = p_chr_id AND chrb.scs_code = 'LEASE';
144:
145: l_exists VARCHAR2 (1) DEFAULT 'N';
146: BEGIN

Line 230: FROM okc_k_headers_b chrb, okl_k_headers khr

226:
227: CURSOR l_ptmpl_csr (p_chr_id IN NUMBER) IS
228: SELECT chrb.template_yn,
229: khr.template_type_code
230: FROM okc_k_headers_b chrb, okl_k_headers khr
231: WHERE chrb.ID = khr.ID AND chrb.ID = p_chr_id;
232:
233: l_template_type_code okl_k_headers.template_type_code%TYPE;
234: l_template_yn okc_k_headers_b.template_yn%TYPE;

Line 234: l_template_yn okc_k_headers_b.template_yn%TYPE;

230: FROM okc_k_headers_b chrb, okl_k_headers khr
231: WHERE chrb.ID = khr.ID AND chrb.ID = p_chr_id;
232:
233: l_template_type_code okl_k_headers.template_type_code%TYPE;
234: l_template_yn okc_k_headers_b.template_yn%TYPE;
235: l_pqcl_id okc_k_headers_b.qcl_id%TYPE;
236:
237: CURSOR l_ptmpl_qcl_csr (p_chr_id IN NUMBER) IS
238: SELECT chrb.qcl_id

Line 235: l_pqcl_id okc_k_headers_b.qcl_id%TYPE;

231: WHERE chrb.ID = khr.ID AND chrb.ID = p_chr_id;
232:
233: l_template_type_code okl_k_headers.template_type_code%TYPE;
234: l_template_yn okc_k_headers_b.template_yn%TYPE;
235: l_pqcl_id okc_k_headers_b.qcl_id%TYPE;
236:
237: CURSOR l_ptmpl_qcl_csr (p_chr_id IN NUMBER) IS
238: SELECT chrb.qcl_id
239: FROM okc_k_headers_b chrb

Line 239: FROM okc_k_headers_b chrb

235: l_pqcl_id okc_k_headers_b.qcl_id%TYPE;
236:
237: CURSOR l_ptmpl_qcl_csr (p_chr_id IN NUMBER) IS
238: SELECT chrb.qcl_id
239: FROM okc_k_headers_b chrb
240: WHERE chrb.ID = p_chr_id;
241:
242: /*
243: -- mvasudev, 08/30/2004

Line 825: FROM okc_statuses_v a, okc_k_headers_b b, okl_k_headers c

821: l_failstatus VARCHAR2 (256);
822:
823: CURSOR tmp_csr (chrid NUMBER) IS
824: SELECT NVL (b.template_yn, 'N') template_yn
825: FROM okc_statuses_v a, okc_k_headers_b b, okl_k_headers c
826: WHERE a.code = b.sts_code AND b.ID = c.ID AND b.ID = chrid;
827:
828: tmp_rec tmp_csr%ROWTYPE;
829:

Line 1246: FROM okc_k_headers_b CHR, okl_k_headers khr

1242: --cursor to check for vendor program template
1243: CURSOR l_chk_template_csr (p_chr_id IN NUMBER) IS
1244: SELECT CHR.template_yn,
1245: khr.template_type_code
1246: FROM okc_k_headers_b CHR, okl_k_headers khr
1247: WHERE CHR.ID = p_chr_id AND CHR.ID = khr.ID;
1248:
1249: l_chk_template_rec l_chk_template_csr%ROWTYPE;
1250:

Line 2276: p_chr_id IN okc_k_headers_b.ID%TYPE,

2272: DEFAULT okl_api.g_false,
2273: x_return_status OUT NOCOPY VARCHAR2,
2274: x_msg_count OUT NOCOPY NUMBER,
2275: x_msg_data OUT NOCOPY VARCHAR2,
2276: p_chr_id IN okc_k_headers_b.ID%TYPE,
2277: x_termination_complete_yn OUT NOCOPY VARCHAR2
2278: ) IS
2279: l_api_name VARCHAR2 (35) := 'TERM_ORIGINAL_CONTRACT';
2280: l_proc_name VARCHAR2 (35) := 'TERM_ORIGINAL_CONTRACT';

Line 2281: ln_orig_system_source_code okc_k_headers_b.orig_system_source_code%TYPE;

2277: x_termination_complete_yn OUT NOCOPY VARCHAR2
2278: ) IS
2279: l_api_name VARCHAR2 (35) := 'TERM_ORIGINAL_CONTRACT';
2280: l_proc_name VARCHAR2 (35) := 'TERM_ORIGINAL_CONTRACT';
2281: ln_orig_system_source_code okc_k_headers_b.orig_system_source_code%TYPE;
2282: ln_orig_system_id1 okc_k_headers_b.orig_system_id1%TYPE;
2283: ln_orig_contract_number okc_k_headers_b.contract_number%TYPE;
2284:
2285: -- To get the orig system id for p_chr_id

Line 2282: ln_orig_system_id1 okc_k_headers_b.orig_system_id1%TYPE;

2278: ) IS
2279: l_api_name VARCHAR2 (35) := 'TERM_ORIGINAL_CONTRACT';
2280: l_proc_name VARCHAR2 (35) := 'TERM_ORIGINAL_CONTRACT';
2281: ln_orig_system_source_code okc_k_headers_b.orig_system_source_code%TYPE;
2282: ln_orig_system_id1 okc_k_headers_b.orig_system_id1%TYPE;
2283: ln_orig_contract_number okc_k_headers_b.contract_number%TYPE;
2284:
2285: -- To get the orig system id for p_chr_id
2286: CURSOR get_orig_sys_code (p_chr_id okc_k_headers_b.ID%TYPE) IS

Line 2283: ln_orig_contract_number okc_k_headers_b.contract_number%TYPE;

2279: l_api_name VARCHAR2 (35) := 'TERM_ORIGINAL_CONTRACT';
2280: l_proc_name VARCHAR2 (35) := 'TERM_ORIGINAL_CONTRACT';
2281: ln_orig_system_source_code okc_k_headers_b.orig_system_source_code%TYPE;
2282: ln_orig_system_id1 okc_k_headers_b.orig_system_id1%TYPE;
2283: ln_orig_contract_number okc_k_headers_b.contract_number%TYPE;
2284:
2285: -- To get the orig system id for p_chr_id
2286: CURSOR get_orig_sys_code (p_chr_id okc_k_headers_b.ID%TYPE) IS
2287: SELECT chr_new.orig_system_source_code,

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

2282: ln_orig_system_id1 okc_k_headers_b.orig_system_id1%TYPE;
2283: ln_orig_contract_number okc_k_headers_b.contract_number%TYPE;
2284:
2285: -- To get the orig system id for p_chr_id
2286: CURSOR get_orig_sys_code (p_chr_id okc_k_headers_b.ID%TYPE) IS
2287: SELECT chr_new.orig_system_source_code,
2288: chr_new.orig_system_id1,
2289: chr_old.contract_number
2290: FROM okc_k_headers_b chr_new, okc_k_headers_b chr_old

Line 2290: FROM okc_k_headers_b chr_new, okc_k_headers_b chr_old

2286: CURSOR get_orig_sys_code (p_chr_id okc_k_headers_b.ID%TYPE) IS
2287: SELECT chr_new.orig_system_source_code,
2288: chr_new.orig_system_id1,
2289: chr_old.contract_number
2290: FROM okc_k_headers_b chr_new, okc_k_headers_b chr_old
2291: WHERE chr_new.ID = p_chr_id AND chr_old.ID = chr_new.orig_system_id1;
2292:
2293: l_assn_tbl okl_am_create_quote_pvt.assn_tbl_type;
2294: l_assn_rec okl_am_create_quote_pvt.assn_rec_type;

Line 2357: okc_k_headers_b CHR,

2353: fab.asset_number asset_number,
2354: fab.current_units current_units
2355: FROM okc_k_lines_b fin_ast_cle,
2356: okc_k_lines_b fa_cle,
2357: okc_k_headers_b CHR,
2358: okc_line_styles_b fin_ast_lse,
2359: okc_line_styles_b fa_lse,
2360: okc_k_items cim,
2361: fa_additions_b fab

Line 2394: FROM okc_k_headers_b CHR

2390: chk_taa_term_rec chk_taa_term_csr%ROWTYPE;
2391:
2392: CURSOR chk_chr_term_csr (p_orig_chr_id IN NUMBER) IS
2393: SELECT CHR.sts_code
2394: FROM okc_k_headers_b CHR
2395: WHERE ID = p_orig_chr_id;
2396:
2397: chk_chr_term_rec chk_chr_term_csr%ROWTYPE;
2398:

Line 3214: FROM okc_k_headers_b CHR

3210:
3211: -- Sales Tax project changes END
3212: CURSOR l_chk_mass_rbk_csr (p_chr_id IN NUMBER) IS
3213: SELECT 'Y' what
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

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

3265: that is booked for the first time. */
3266:
3267: -- nikshah -- Bug # 5484903 Fixed,
3268: -- Changed l_rq_fee_lns_bkg_csr SQL definition
3269: CURSOR l_rq_fee_lns_bkg_csr (chrid IN okc_k_headers_b.ID%TYPE) IS
3270: SELECT kle.qte_id
3271: FROM okc_k_headers_b khr, okc_k_lines_b cleb, okl_k_lines kle
3272: WHERE khr.ID = chrid
3273: AND cleb.dnz_chr_id = khr.ID

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

3267: -- nikshah -- Bug # 5484903 Fixed,
3268: -- Changed l_rq_fee_lns_bkg_csr SQL definition
3269: CURSOR l_rq_fee_lns_bkg_csr (chrid IN okc_k_headers_b.ID%TYPE) IS
3270: SELECT kle.qte_id
3271: FROM okc_k_headers_b khr, okc_k_lines_b cleb, okl_k_lines kle
3272: WHERE khr.ID = chrid
3273: AND cleb.dnz_chr_id = khr.ID
3274: AND kle.ID = cleb.ID
3275: AND kle.fee_type = 'ROLLOVER'

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

3291: to a re-book contract. */
3292:
3293: -- nikshah -- Bug # 5484903 Fixed
3294: -- Changed CURSOR l_rq_fee_lns_rbk_csr SQL definition
3295: CURSOR l_rq_fee_lns_rbk_csr (chrid IN okc_k_headers_b.ID%TYPE) IS
3296: SELECT kle.qte_id
3297: FROM okc_k_headers_b khr, okc_k_lines_b cleb, okl_k_lines kle
3298: WHERE khr.ID = chrid
3299: AND cleb.dnz_chr_id = khr.ID

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

3293: -- nikshah -- Bug # 5484903 Fixed
3294: -- Changed CURSOR l_rq_fee_lns_rbk_csr SQL definition
3295: CURSOR l_rq_fee_lns_rbk_csr (chrid IN okc_k_headers_b.ID%TYPE) IS
3296: SELECT kle.qte_id
3297: FROM okc_k_headers_b khr, okc_k_lines_b cleb, okl_k_lines kle
3298: WHERE khr.ID = chrid
3299: AND cleb.dnz_chr_id = khr.ID
3300: AND kle.ID = cleb.ID
3301: AND kle.fee_type = 'ROLLOVER'

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

3315:
3316: l_ro_fee_rbk_found BOOLEAN := FALSE;
3317:
3318: /* Cursor to check if the contract is rebooked contract. */
3319: CURSOR l_chk_rbk_csr (chrid IN okc_k_headers_b.ID%TYPE) IS
3320: SELECT '!'
3321: FROM okc_k_headers_b CHR
3322: WHERE CHR.ID = chrid AND CHR.orig_system_source_code = 'OKL_REBOOK';
3323:

Line 3321: FROM okc_k_headers_b CHR

3317:
3318: /* Cursor to check if the contract is rebooked contract. */
3319: CURSOR l_chk_rbk_csr (chrid IN okc_k_headers_b.ID%TYPE) IS
3320: SELECT '!'
3321: FROM okc_k_headers_b CHR
3322: WHERE CHR.ID = chrid AND CHR.orig_system_source_code = 'OKL_REBOOK';
3323:
3324: l_qte_id okl_k_lines.qte_id%TYPE;
3325: l_creditline_id okl_k_lines.qte_id%TYPE;

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

3338: (less than or equal to SYSDATE). */
3339:
3340: -- nikshah -- Bug # 5484903 Fixed,
3341: -- Changed CURSOR l_k_std_csr SQL definition
3342: CURSOR l_k_std_csr (chrid okc_k_headers_b.ID%TYPE) IS
3343: SELECT 1
3344: FROM okc_k_lines_v cleb, okl_k_lines kle, okc_k_headers_b khr
3345: WHERE khr.ID = chrid
3346: AND cleb.dnz_chr_id = khr.ID

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

3340: -- nikshah -- Bug # 5484903 Fixed,
3341: -- Changed CURSOR l_k_std_csr SQL definition
3342: CURSOR l_k_std_csr (chrid okc_k_headers_b.ID%TYPE) IS
3343: SELECT 1
3344: FROM okc_k_lines_v cleb, okl_k_lines kle, okc_k_headers_b khr
3345: WHERE khr.ID = chrid
3346: AND cleb.dnz_chr_id = khr.ID
3347: AND kle.ID = cleb.ID
3348: AND kle.fee_type = 'ROLLOVER'

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

3361:
3362: /* Cursor for Re-book contract */
3363: -- nikshah -- Bug # 5484903 Fixed,
3364: -- Changed CURSOR l_k_std__4rbk_csr SQL definition
3365: CURSOR l_k_std__4rbk_csr (chrid okc_k_headers_b.ID%TYPE) IS
3366: SELECT 1
3367: FROM okc_k_lines_v cleb, okl_k_lines kle, okc_k_headers_b khr
3368: WHERE khr.ID = chrid
3369: AND cleb.dnz_chr_id = khr.ID

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

3363: -- nikshah -- Bug # 5484903 Fixed,
3364: -- Changed CURSOR l_k_std__4rbk_csr SQL definition
3365: CURSOR l_k_std__4rbk_csr (chrid okc_k_headers_b.ID%TYPE) IS
3366: SELECT 1
3367: FROM okc_k_lines_v cleb, okl_k_lines kle, okc_k_headers_b khr
3368: WHERE khr.ID = chrid
3369: AND cleb.dnz_chr_id = khr.ID
3370: AND kle.ID = cleb.ID
3371: AND kle.fee_type = 'ROLLOVER'

Line 3396: FROM okc_k_headers_b CHR

3392: --Bug# 3948361: start
3393: --cursor to check if contract is a re-lease contract
3394: CURSOR l_chk_rel_khr_csr (p_chr_id IN NUMBER) IS
3395: SELECT '!'
3396: FROM okc_k_headers_b CHR
3397: WHERE CHR.ID = p_chr_id
3398: AND NVL (CHR.orig_system_source_code, 'XXXX') = 'OKL_RELEASE';
3399:
3400: l_rel_khr VARCHAR2 (1);

Line 3410: FROM okc_k_headers_b CHR, okl_k_headers khr

3406: --cursor to check for vendor program template
3407: CURSOR l_chk_template_csr (p_chr_id IN NUMBER) IS
3408: SELECT CHR.template_yn,
3409: khr.template_type_code
3410: FROM okc_k_headers_b CHR, okl_k_headers khr
3411: WHERE CHR.ID = p_chr_id AND CHR.ID = khr.ID;
3412:
3413: l_chk_template_rec l_chk_template_csr%ROWTYPE;
3414:

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

3436: --ramurt Bug#4622438
3437: CURSOR chk_product_status (p_chr_id IN NUMBER) IS
3438: SELECT pdt.NAME,
3439: pdt.product_status_code
3440: FROM okl_products_v pdt, okl_k_headers_v khr, okc_k_headers_b CHR
3441: WHERE 1 = 1
3442: AND khr.ID = p_chr_id
3443: AND pdt_id = pdt.ID
3444: AND khr.ID = CHR.ID;

Line 4517: FROM okc_k_headers_b chrb, okc_statuses_v stsv

4513: CURSOR l_chr_csr (p_chr_id IN NUMBER) IS
4514: SELECT chrb.qcl_id,
4515: stsv.ste_code,
4516: stsv.meaning
4517: FROM okc_k_headers_b chrb, okc_statuses_v stsv
4518: WHERE chrb.ID = p_chr_id
4519: AND chrb.sts_code = stsv.code
4520: AND chrb.scs_code = 'LEASE';
4521:

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

5200: := 'APPROVE_ACTIVATE_CONTRACT';
5201: l_api_version CONSTANT NUMBER := 1.0;
5202:
5203: --cursor to fetch the contract status
5204: CURSOR sts_code_csr (p_khr_id okc_k_headers_b.ID%TYPE) IS
5205: SELECT sts_code
5206: FROM okc_k_headers_b
5207: WHERE ID = p_khr_id;
5208:

Line 5206: FROM okc_k_headers_b

5202:
5203: --cursor to fetch the contract status
5204: CURSOR sts_code_csr (p_khr_id okc_k_headers_b.ID%TYPE) IS
5205: SELECT sts_code
5206: FROM okc_k_headers_b
5207: WHERE ID = p_khr_id;
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

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

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

Line 5215: okc_k_headers_b CHR

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
5217: AND tcn.khr_id_new = CHR.ID
5218: AND tcn_type = 'MAE'
5219: AND tcn.tsu_code <> 'PROCESSED'

Line 5230: l_sts_code okc_k_headers_b.sts_code%TYPE;

5226: AND tcn.qte_id = qte.ID
5227: AND CHR.ID = p_khr_id;
5228:
5229: l_rem_amt NUMBER;
5230: l_sts_code okc_k_headers_b.sts_code%TYPE;
5231: l_qte_num okl_trx_quotes_b.quote_number%TYPE;
5232: l_approval_path VARCHAR2 (30);
5233: contract_activation_failed EXCEPTION;
5234:

Line 5238: FROM okc_k_headers_b CHR

5234:
5235: -- Bug# 5038395
5236: CURSOR l_chk_mass_rbk_csr (p_chr_id IN NUMBER) IS
5237: SELECT 'Y' mass_rbk_yn
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