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_SPLIT_CONTRACT_PVT dependencies on OKC_K_LINES_V

Line 474: FUNCTION get_rec_clev(p_id IN OKC_K_LINES_V.ID%TYPE,

470: END IF;
471: RETURN(x_return_status);
472: END get_rec_chrv;
473: ------------------------------------------------------------------------------------------------
474: FUNCTION get_rec_clev(p_id IN OKC_K_LINES_V.ID%TYPE,
475: x_clev_rec OUT NOCOPY clev_rec_type)
476: RETURN VARCHAR2 IS
477: CURSOR okc_clev_pk_csr (p_cle_id NUMBER) IS
478: SELECT ID,

Line 555: FROM Okc_K_Lines_V

551: PRICE_TYPE,
552: CURRENCY_CODE,
553: CURRENCY_CODE_RENEWED,
554: LAST_UPDATE_LOGIN
555: FROM Okc_K_Lines_V
556: WHERE okc_k_lines_v.id = p_cle_id;
557: l_okc_clev_pk okc_clev_pk_csr%ROWTYPE;
558: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
559: BEGIN

Line 556: WHERE okc_k_lines_v.id = p_cle_id;

552: CURRENCY_CODE,
553: CURRENCY_CODE_RENEWED,
554: LAST_UPDATE_LOGIN
555: FROM Okc_K_Lines_V
556: WHERE okc_k_lines_v.id = p_cle_id;
557: l_okc_clev_pk okc_clev_pk_csr%ROWTYPE;
558: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
559: BEGIN
560: -- Get current database values

Line 1141: -- Description : validation with OKC_K_LINES_V

1137: -------------------------------------------------------------------------------------------------
1138: -- Start of Commnets
1139: -- Badrinath Kuchibholta
1140: -- Procedure Name : validate_chr_cle_id
1141: -- Description : validation with OKC_K_LINES_V
1142: -- Business Rules :
1143: -- Parameters :
1144: -- Version : 1.0
1145: -- End of Commnets

Line 1147: PROCEDURE validate_chr_cle_id(p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,

1143: -- Parameters :
1144: -- Version : 1.0
1145: -- End of Commnets
1146:
1147: PROCEDURE validate_chr_cle_id(p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
1148: p_top_line_id IN OKC_K_LINES_V.ID%TYPE,
1149: x_return_status OUT NOCOPY VARCHAR2) IS
1150: ln_dummy NUMBER := 0;
1151: CURSOR c_chr_cle_id_validate(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,

Line 1148: p_top_line_id IN OKC_K_LINES_V.ID%TYPE,

1144: -- Version : 1.0
1145: -- End of Commnets
1146:
1147: PROCEDURE validate_chr_cle_id(p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
1148: p_top_line_id IN OKC_K_LINES_V.ID%TYPE,
1149: x_return_status OUT NOCOPY VARCHAR2) IS
1150: ln_dummy NUMBER := 0;
1151: CURSOR c_chr_cle_id_validate(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
1152: p_top_line_id OKC_K_LINES_V.ID%TYPE) IS

Line 1151: CURSOR c_chr_cle_id_validate(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,

1147: PROCEDURE validate_chr_cle_id(p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
1148: p_top_line_id IN OKC_K_LINES_V.ID%TYPE,
1149: x_return_status OUT NOCOPY VARCHAR2) IS
1150: ln_dummy NUMBER := 0;
1151: CURSOR c_chr_cle_id_validate(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
1152: p_top_line_id OKC_K_LINES_V.ID%TYPE) IS
1153: SELECT 1
1154: FROM DUAL
1155: WHERE EXISTS (SELECT 1

Line 1152: p_top_line_id OKC_K_LINES_V.ID%TYPE) IS

1148: p_top_line_id IN OKC_K_LINES_V.ID%TYPE,
1149: x_return_status OUT NOCOPY VARCHAR2) IS
1150: ln_dummy NUMBER := 0;
1151: CURSOR c_chr_cle_id_validate(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
1152: p_top_line_id OKC_K_LINES_V.ID%TYPE) IS
1153: SELECT 1
1154: FROM DUAL
1155: WHERE EXISTS (SELECT 1
1156: FROM OKC_SUBCLASS_TOP_LINE stl,

Line 1158: OKC_K_LINES_V cle

1154: FROM DUAL
1155: WHERE EXISTS (SELECT 1
1156: FROM OKC_SUBCLASS_TOP_LINE stl,
1157: OKC_LINE_STYLES_V lse,
1158: OKC_K_LINES_V cle
1159: WHERE cle.id = p_top_line_id
1160: AND cle.dnz_chr_id = p_dnz_chr_id
1161: AND cle.cle_id IS NULL
1162: AND cle.chr_id = cle.dnz_chr_id

Line 1247: -- Description : validation with OKC_K_LINES_V

1243: ----------------------------------------------------------------------------------------------------
1244: -- Start of Commnets
1245: -- Badrinath Kuchibholta
1246: -- Procedure Name : validate_chr_id
1247: -- Description : validation with OKC_K_LINES_V
1248: -- Business Rules :
1249: -- Parameters :
1250: -- Version : 1.0
1251: -- End of Commnets

Line 2111: okc_k_lines_v cle,

2107: CURSOR get_fee_service_lines(p_chr_id OKC_K_HEADERS_B.ID%TYPE)
2108: IS
2109: SELECT cle.id id
2110: FROM okl_k_lines_v kle,
2111: okc_k_lines_v cle,
2112: okc_line_styles_b lse
2113: WHERE cle.dnz_chr_id = p_chr_id
2114: AND cle.id = kle.id
2115: AND cle.lse_id = lse.id

Line 2121: okc_k_lines_v cle_sl,

2117: AND lse.lse_type = 'TLS'
2118: AND cle.cle_id IS NULL
2119: AND cle.id NOT IN (SELECT DISTINCT(cle_sl.cle_id) cle_id
2120: FROM okl_k_lines_v kle_sl,
2121: okc_k_lines_v cle_sl,
2122: okc_line_styles_b lse_sl
2123: WHERE cle_sl.dnz_chr_id = p_chr_id
2124: AND cle_sl.id = kle_sl.id
2125: AND cle_sl.lse_id = lse_sl.id

Line 2376: /*CURSOR get_amt(p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)

2372: AND lse.lse_type = G_TLS_TYPE);*/
2373: -- end rravikir commented for bug 3504415
2374:
2375: -- rravikir commented for bug
2376: /*CURSOR get_amt(p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
2377: IS
2378: SELECT nvl(kle.amount,0) amount,
2379: nvl(kle.initial_direct_cost,0) initial_direct_cost,
2380: cle.id id

Line 2382: okc_k_lines_v cle,

2378: SELECT nvl(kle.amount,0) amount,
2379: nvl(kle.initial_direct_cost,0) initial_direct_cost,
2380: cle.id id
2381: FROM okl_k_lines_v kle,
2382: okc_k_lines_v cle,
2383: okc_line_styles_b lse
2384: WHERE cle.dnz_chr_id = p_chr_id
2385: AND cle.id = kle.id
2386: AND cle.lse_id = lse.id

Line 2393: CURSOR get_amt(p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)

2389: AND cle.cle_id IS NULL;*/
2390: -- end rravikir commented for bug
2391:
2392: -- New Cursor for Bug 3608423
2393: CURSOR get_amt(p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
2394: IS
2395: SELECT DISTINCT(cle.id) id,
2396: NVL(kle.amount,0) amount,
2397: NVL(kle.initial_direct_cost,0) initial_direct_cost

Line 2399: okc_k_lines_v cle_sl,

2395: SELECT DISTINCT(cle.id) id,
2396: NVL(kle.amount,0) amount,
2397: NVL(kle.initial_direct_cost,0) initial_direct_cost
2398: FROM okl_k_lines_v kle_sl,
2399: okc_k_lines_v cle_sl,
2400: okc_line_styles_b lse_sl,
2401: okl_k_lines_v kle,
2402: okc_k_lines_v cle,
2403: okc_line_styles_b lse

Line 2402: okc_k_lines_v cle,

2398: FROM okl_k_lines_v kle_sl,
2399: okc_k_lines_v cle_sl,
2400: okc_line_styles_b lse_sl,
2401: okl_k_lines_v kle,
2402: okc_k_lines_v cle,
2403: okc_line_styles_b lse
2404: WHERE cle.dnz_chr_id = p_chr_id
2405: AND cle.id = kle.id
2406: AND cle.lse_id = lse.id

Line 2417: CURSOR get_cap_link_asset_amount(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE)

2413: AND lse_sl.lty_code IN (G_SRL_LINE_LTY_CODE,G_FEL_LINE_LTY_CODE);
2414: -- End New Cursor for Bug 3608423
2415:
2416: -- New Cursor to get the sum of capital amount of all capitalized link assets
2417: CURSOR get_cap_link_asset_amount(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE)
2418: IS
2419: SELECT SUM(kle.CAPITAL_AMOUNT)
2420: FROM okl_k_lines_v kle,
2421: okc_line_styles_b lse,

Line 2422: okc_k_lines_v cle

2418: IS
2419: SELECT SUM(kle.CAPITAL_AMOUNT)
2420: FROM okl_k_lines_v kle,
2421: okc_line_styles_b lse,
2422: okc_k_lines_v cle
2423: WHERE cle.cle_id = p_cle_id
2424: AND cle.id = kle.id
2425: AND cle.lse_id = lse.id
2426: AND lse.lty_code IN (G_SRL_LINE_LTY_CODE,G_FEL_LINE_LTY_CODE);

Line 2429: /*CURSOR get_sls_amt(p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)

2425: AND cle.lse_id = lse.id
2426: AND lse.lty_code IN (G_SRL_LINE_LTY_CODE,G_FEL_LINE_LTY_CODE);
2427: -- End New Cursor for Bug 3608423
2428:
2429: /*CURSOR get_sls_amt(p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
2430: IS
2431: SELECT sum(nvl(kle_sl.capital_amount,0)) amount,
2432: cle.id id,
2433: cle.orig_system_id1 orig_system_id1

Line 2435: okc_k_lines_v cle_sl,

2431: SELECT sum(nvl(kle_sl.capital_amount,0)) amount,
2432: cle.id id,
2433: cle.orig_system_id1 orig_system_id1
2434: FROM okl_k_lines_v kle_sl,
2435: okc_k_lines_v cle_sl,
2436: okc_line_styles_b lse_sl,
2437: okl_k_lines_v kle,
2438: okc_k_lines_v cle,
2439: okc_line_styles_b lse

Line 2438: okc_k_lines_v cle,

2434: FROM okl_k_lines_v kle_sl,
2435: okc_k_lines_v cle_sl,
2436: okc_line_styles_b lse_sl,
2437: okl_k_lines_v kle,
2438: okc_k_lines_v cle,
2439: okc_line_styles_b lse
2440: WHERE cle.dnz_chr_id = p_chr_id
2441: AND cle.id = kle.id
2442: AND cle.lse_id = lse.id

Line 2453: /*CURSOR get_rule_pymt(p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,

2449: AND lse_sl.lty_code in (G_SRL_LINE_LTY_CODE,G_FEL_LINE_LTY_CODE)
2450: group by cle.id,
2451: cle.orig_system_id1;*/
2452:
2453: /*CURSOR get_rule_pymt(p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
2454: p_cle_id OKC_K_LINES_V.ID%TYPE)
2455: IS
2456: SELECT rl.id,
2457: rl.rule_information6 payment_amount,

Line 2454: p_cle_id OKC_K_LINES_V.ID%TYPE)

2450: group by cle.id,
2451: cle.orig_system_id1;*/
2452:
2453: /*CURSOR get_rule_pymt(p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
2454: p_cle_id OKC_K_LINES_V.ID%TYPE)
2455: IS
2456: SELECT rl.id,
2457: rl.rule_information6 payment_amount,
2458: rl.rule_information2 rl_date

Line 2461: okc_k_lines_v cle,

2457: rl.rule_information6 payment_amount,
2458: rl.rule_information2 rl_date
2459: FROM okc_rule_groups_b rg,
2460: okc_rules_b rl,
2461: okc_k_lines_v cle,
2462: okc_line_styles_b lse
2463: WHERE cle.dnz_chr_id = p_chr_id
2464: AND cle.id = p_cle_id
2465: AND cle.lse_id = lse.id

Line 2476: FROM okc_k_lines_v cle_sl,

2472: AND rg.id = rl.rgp_id
2473: AND rg.rgd_code = 'LALEVL'
2474: AND rl.rule_information_category = 'LASLL'
2475: AND not exists (SELECT '1'
2476: FROM okc_k_lines_v cle_sl,
2477: okc_line_styles_b lse_sl
2478: WHERE cle_sl.dnz_chr_id = p_chr_id
2479: AND cle_sl.cle_id = cle.id
2480: AND cle_sl.lse_id = lse_sl.id

Line 2483: /*CURSOR get_sls_rule_pymt(p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,

2479: AND cle_sl.cle_id = cle.id
2480: AND cle_sl.lse_id = lse_sl.id
2481: AND lse_sl.lty_code in (G_SRL_LINE_LTY_CODE,G_FEL_LINE_LTY_CODE));*/
2482:
2483: /*CURSOR get_sls_rule_pymt(p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
2484: p_cle_id OKC_K_LINES_V.ID%TYPE)
2485: IS
2486: SELECT rl.id,
2487: rl.rule_information6 payment_amount

Line 2484: p_cle_id OKC_K_LINES_V.ID%TYPE)

2480: AND cle_sl.lse_id = lse_sl.id
2481: AND lse_sl.lty_code in (G_SRL_LINE_LTY_CODE,G_FEL_LINE_LTY_CODE));*/
2482:
2483: /*CURSOR get_sls_rule_pymt(p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
2484: p_cle_id OKC_K_LINES_V.ID%TYPE)
2485: IS
2486: SELECT rl.id,
2487: rl.rule_information6 payment_amount
2488: FROM okc_rule_groups_b rg,

Line 2490: okc_k_lines_v cle,

2486: SELECT rl.id,
2487: rl.rule_information6 payment_amount
2488: FROM okc_rule_groups_b rg,
2489: okc_rules_b rl,
2490: okc_k_lines_v cle,
2491: okc_line_styles_b lse
2492: WHERE cle.dnz_chr_id = p_chr_id
2493: AND cle.id = p_cle_id
2494: AND cle.lse_id = lse.id

Line 2505: FROM okc_k_lines_v cle_sl,

2501: AND rg.id = rl.rgp_id
2502: AND rg.rgd_code = 'LALEVL'
2503: AND rl.rule_information_category = 'LASLL'
2504: AND exists (SELECT '1'
2505: FROM okc_k_lines_v cle_sl,
2506: okc_line_styles_b lse_sl
2507: WHERE cle_sl.dnz_chr_id = p_chr_id
2508: AND cle_sl.cle_id = cle.id
2509: AND cle_sl.lse_id = lse_sl.id

Line 2513: CURSOR get_service_rule_info(p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,

2509: AND cle_sl.lse_id = lse_sl.id
2510: AND lse_sl.lty_code in (G_SRL_LINE_LTY_CODE,G_FEL_LINE_LTY_CODE));*/
2511:
2512: -- Get the rule that applies to service line
2513: CURSOR get_service_rule_info(p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
2514: p_cle_id OKC_K_LINES_V.ID%TYPE)
2515: IS
2516: SELECT rl.id,
2517: cle.currency_code

Line 2514: p_cle_id OKC_K_LINES_V.ID%TYPE)

2510: AND lse_sl.lty_code in (G_SRL_LINE_LTY_CODE,G_FEL_LINE_LTY_CODE));*/
2511:
2512: -- Get the rule that applies to service line
2513: CURSOR get_service_rule_info(p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
2514: p_cle_id OKC_K_LINES_V.ID%TYPE)
2515: IS
2516: SELECT rl.id,
2517: cle.currency_code
2518: FROM okc_rule_groups_b rg,

Line 2520: okc_k_lines_v cle,

2516: SELECT rl.id,
2517: cle.currency_code
2518: FROM okc_rule_groups_b rg,
2519: okc_rules_b rl,
2520: okc_k_lines_v cle,
2521: okc_line_styles_b lse
2522: WHERE cle.dnz_chr_id = p_chr_id
2523: AND cle.id = p_cle_id
2524: AND cle.lse_id = lse.id

Line 2549: CURSOR get_service_lines(p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)

2545: AND crl.RULE_INFORMATION_CATEGORY = p_rgp_cat
2546: AND crg.dnz_chr_id = p_chr_id
2547: AND NVL(crg.cle_id,-1) = p_cle_id;
2548:
2549: CURSOR get_service_lines(p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
2550: IS
2551: SELECT cle.id id,
2552: NVL(kle.amount,0) amount
2553: FROM okl_k_lines_v kle,

Line 2554: okc_k_lines_v cle,

2550: IS
2551: SELECT cle.id id,
2552: NVL(kle.amount,0) amount
2553: FROM okl_k_lines_v kle,
2554: okc_k_lines_v cle,
2555: okc_line_styles_b lse
2556: WHERE cle.dnz_chr_id = p_chr_id
2557: AND cle.id = kle.id
2558: AND cle.lse_id = lse.id

Line 2563: CURSOR get_old_service_lines(p_new_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,

2559: AND lse.lty_code = G_SER_LINE_LTY_CODE
2560: AND lse.lse_type = G_TLS_TYPE
2561: AND cle.cle_id IS NULL;
2562:
2563: CURSOR get_old_service_lines(p_new_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
2564: p_old_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
2565: p_new_cle_id OKL_K_LINES_V.ID%TYPE)
2566: IS
2567: SELECT cle.id id,

Line 2564: p_old_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,

2560: AND lse.lse_type = G_TLS_TYPE
2561: AND cle.cle_id IS NULL;
2562:
2563: CURSOR get_old_service_lines(p_new_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
2564: p_old_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
2565: p_new_cle_id OKL_K_LINES_V.ID%TYPE)
2566: IS
2567: SELECT cle.id id,
2568: NVL(kle.amount,0) amount

Line 2570: okc_k_lines_v cle,

2566: IS
2567: SELECT cle.id id,
2568: NVL(kle.amount,0) amount
2569: FROM okl_k_lines_v kle,
2570: okc_k_lines_v cle,
2571: okc_line_styles_b lse
2572: WHERE cle.dnz_chr_id = p_old_chr_id
2573: AND cle.id = kle.id
2574: AND cle.lse_id = lse.id

Line 2597: okc_k_lines_v cle,

2593: rl.rule_information8,
2594: cle.currency_code
2595: FROM okc_rule_groups_b rg,
2596: okc_rules_b rl,
2597: okc_k_lines_v cle,
2598: okc_line_styles_b lse
2599: WHERE cle.dnz_chr_id = p_chr_id
2600: AND cle.id = p_cle_id
2601: AND cle.lse_id = lse.id

Line 2625: lv_currency_code OKC_K_LINES_V.CURRENCY_CODE%TYPE;

2621: ln_service_line_id OKL_K_LINES_V.ID%TYPE;
2622: ln_rule_amount OKC_RULES_V.RULE_INFORMATION2%TYPE;
2623: ln_rule_id OKC_RULES_V.ID%TYPE;
2624: lv_num_periods OKC_RULES_V.RULE_INFORMATION1%TYPE;
2625: lv_currency_code OKC_K_LINES_V.CURRENCY_CODE%TYPE;
2626: ln_rule_info_3 OKC_RULES_V.RULE_INFORMATION3%TYPE;
2627: ln_rule_info_6 OKC_RULES_V.RULE_INFORMATION6%TYPE;
2628: ln_rule_info_2 OKC_RULES_V.RULE_INFORMATION2%TYPE;
2629: ln_rule_info_7 OKC_RULES_V.RULE_INFORMATION7%TYPE;

Line 3379: FROM OKC_K_LINES_V cle,

3375: CURSOR get_orig_fa(p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
3376: SELECT orig_system_id1 orig_cle_fa,
3377: txl.tas_id tas_id_fa,
3378: cle.id id
3379: FROM OKC_K_LINES_V cle,
3380: OKC_LINE_STYLES_V lse,
3381: OKL_TXL_ASSETS_B txl
3382: WHERE cle.dnz_chr_id = p_chr_id
3383: AND cle.lse_id = lse.id

Line 3392: FROM OKC_K_LINES_V cle,

3388: CURSOR get_orig_ib(p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
3389: SELECT orig_system_id1 orig_cle_ib,
3390: iti.tas_id tas_id_ib,
3391: cle.id id
3392: FROM OKC_K_LINES_V cle,
3393: OKC_LINE_STYLES_V lse,
3394: OKL_TXL_ITM_INSTS iti
3395: WHERE cle.dnz_chr_id = p_chr_id
3396: AND cle.lse_id = lse.id

Line 4137: OKC_K_LINES_V cle,

4133: CURSOR c_old_top_line_cnt(p_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE) IS
4134: SELECT COUNT(cle.id)
4135: FROM OKC_SUBCLASS_TOP_LINE stl,
4136: OKC_LINE_STYLES_V lse,
4137: OKC_K_LINES_V cle,
4138: OKC_K_HEADERS_V chrv
4139: WHERE chrv.contract_number = p_contract_number
4140: AND chrv.id = cle.dnz_chr_id
4141: AND cle.cle_id IS NULL