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 OKL_K_LINES_V

Line 663: FUNCTION get_rec_klev(p_id IN OKL_K_LINES_V.ID%TYPE,

659: END IF;
660: RETURN(x_return_status);
661: END get_rec_clev;
662: -----------------------------------------------------------------------------------------------
663: FUNCTION get_rec_klev(p_id IN OKL_K_LINES_V.ID%TYPE,
664: x_klev_rec OUT NOCOPY klev_rec_type)
665: RETURN VARCHAR2 IS
666: CURSOR okl_k_lines_v_pk_csr (p_kle_id OKL_K_LINES_V.ID%TYPE) IS
667: SELECT ID,

Line 666: CURSOR okl_k_lines_v_pk_csr (p_kle_id OKL_K_LINES_V.ID%TYPE) IS

662: -----------------------------------------------------------------------------------------------
663: FUNCTION get_rec_klev(p_id IN OKL_K_LINES_V.ID%TYPE,
664: x_klev_rec OUT NOCOPY klev_rec_type)
665: RETURN VARCHAR2 IS
666: CURSOR okl_k_lines_v_pk_csr (p_kle_id OKL_K_LINES_V.ID%TYPE) IS
667: SELECT ID,
668: OBJECT_VERSION_NUMBER,
669: KLE_ID,
670: STY_ID,

Line 763: FROM OKL_K_LINES_V

759: CREDIT_NATURE,
760: CAPITALIZED_INTEREST,
761: CAPITAL_REDUCTION_PERCENT,
762: FEE_TYPE
763: FROM OKL_K_LINES_V
764: WHERE OKL_K_LINES_V.id = p_kle_id;
765: l_okl_k_lines_v_pk okl_k_lines_v_pk_csr%ROWTYPE;
766: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
767: BEGIN

Line 764: WHERE OKL_K_LINES_V.id = p_kle_id;

760: CAPITALIZED_INTEREST,
761: CAPITAL_REDUCTION_PERCENT,
762: FEE_TYPE
763: FROM OKL_K_LINES_V
764: WHERE OKL_K_LINES_V.id = p_kle_id;
765: l_okl_k_lines_v_pk okl_k_lines_v_pk_csr%ROWTYPE;
766: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
767: BEGIN
768: -- Get current database values

Line 765: l_okl_k_lines_v_pk okl_k_lines_v_pk_csr%ROWTYPE;

761: CAPITAL_REDUCTION_PERCENT,
762: FEE_TYPE
763: FROM OKL_K_LINES_V
764: WHERE OKL_K_LINES_V.id = p_kle_id;
765: l_okl_k_lines_v_pk okl_k_lines_v_pk_csr%ROWTYPE;
766: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
767: BEGIN
768: -- Get current database values
769: OPEN okl_k_lines_v_pk_csr (p_id);

Line 769: OPEN okl_k_lines_v_pk_csr (p_id);

765: l_okl_k_lines_v_pk okl_k_lines_v_pk_csr%ROWTYPE;
766: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
767: BEGIN
768: -- Get current database values
769: OPEN okl_k_lines_v_pk_csr (p_id);
770: FETCH okl_k_lines_v_pk_csr INTO
771: x_klev_rec.ID,
772: x_klev_rec.OBJECT_VERSION_NUMBER,
773: x_klev_rec.KLE_ID,

Line 770: FETCH okl_k_lines_v_pk_csr INTO

766: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
767: BEGIN
768: -- Get current database values
769: OPEN okl_k_lines_v_pk_csr (p_id);
770: FETCH okl_k_lines_v_pk_csr INTO
771: x_klev_rec.ID,
772: x_klev_rec.OBJECT_VERSION_NUMBER,
773: x_klev_rec.KLE_ID,
774: x_klev_rec.STY_ID,

Line 867: IF okl_k_lines_v_pk_csr%NOTFOUND THEN

863: x_klev_rec.CREDIT_NATURE,
864: x_klev_rec.CAPITALIZED_INTEREST,
865: x_klev_rec.CAPITAL_REDUCTION_PERCENT,
866: x_klev_rec.FEE_TYPE;
867: IF okl_k_lines_v_pk_csr%NOTFOUND THEN
868: x_return_status := OKL_API.G_RET_STS_ERROR;
869: END IF;
870: CLOSE okl_k_lines_v_pk_csr;
871: RETURN(x_return_status);

Line 870: CLOSE okl_k_lines_v_pk_csr;

866: x_klev_rec.FEE_TYPE;
867: IF okl_k_lines_v_pk_csr%NOTFOUND THEN
868: x_return_status := OKL_API.G_RET_STS_ERROR;
869: END IF;
870: CLOSE okl_k_lines_v_pk_csr;
871: RETURN(x_return_status);
872: EXCEPTION
873: WHEN OTHERS THEN
874: -- store SQL error message on message stack for caller

Line 884: IF okl_k_lines_v_pk_csr%ISOPEN THEN

880: SQLERRM);
881: -- notify caller of an UNEXPECTED error
882: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
883: -- if the cursor is open
884: IF okl_k_lines_v_pk_csr%ISOPEN THEN
885: CLOSE okl_k_lines_v_pk_csr;
886: END IF;
887: RETURN(x_return_status);
888: END get_rec_klev;

Line 885: CLOSE okl_k_lines_v_pk_csr;

881: -- notify caller of an UNEXPECTED error
882: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
883: -- if the cursor is open
884: IF okl_k_lines_v_pk_csr%ISOPEN THEN
885: CLOSE okl_k_lines_v_pk_csr;
886: END IF;
887: RETURN(x_return_status);
888: END get_rec_klev;
889: -------------------------------------------------------------------------------------------------

Line 2110: FROM okl_k_lines_v kle,

2106:
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

Line 2120: FROM okl_k_lines_v kle_sl,

2116: AND lse.lty_code IN (G_FEE_LINE_LTY_CODE, G_SER_LINE_LTY_CODE)
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

Line 2224: ln_calc_amt OKL_K_LINES_V.AMOUNT%TYPE := 0;

2220: ln_dummy NUMBER := 0;
2221: i NUMBER := 0;
2222: j NUMBER := 0;
2223: k NUMBER := 0;
2224: ln_calc_amt OKL_K_LINES_V.AMOUNT%TYPE := 0;
2225: ln_old_cap_amt OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
2226: ln_new_cap_amt OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
2227: ln_new_service_amt OKL_K_LINES_V.AMOUNT%TYPE := 0;
2228: ln_old_service_amt OKL_K_LINES_V.AMOUNT%TYPE := 0;

Line 2225: ln_old_cap_amt OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;

2221: i NUMBER := 0;
2222: j NUMBER := 0;
2223: k NUMBER := 0;
2224: ln_calc_amt OKL_K_LINES_V.AMOUNT%TYPE := 0;
2225: ln_old_cap_amt OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
2226: ln_new_cap_amt OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
2227: ln_new_service_amt OKL_K_LINES_V.AMOUNT%TYPE := 0;
2228: ln_old_service_amt OKL_K_LINES_V.AMOUNT%TYPE := 0;
2229: ln_new_init_cost OKL_K_LINES_V.INITIAL_DIRECT_COST%TYPE := 0;

Line 2226: ln_new_cap_amt OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;

2222: j NUMBER := 0;
2223: k NUMBER := 0;
2224: ln_calc_amt OKL_K_LINES_V.AMOUNT%TYPE := 0;
2225: ln_old_cap_amt OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
2226: ln_new_cap_amt OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
2227: ln_new_service_amt OKL_K_LINES_V.AMOUNT%TYPE := 0;
2228: ln_old_service_amt OKL_K_LINES_V.AMOUNT%TYPE := 0;
2229: ln_new_init_cost OKL_K_LINES_V.INITIAL_DIRECT_COST%TYPE := 0;
2230: ln_period NUMBER :=0;

Line 2227: ln_new_service_amt OKL_K_LINES_V.AMOUNT%TYPE := 0;

2223: k NUMBER := 0;
2224: ln_calc_amt OKL_K_LINES_V.AMOUNT%TYPE := 0;
2225: ln_old_cap_amt OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
2226: ln_new_cap_amt OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
2227: ln_new_service_amt OKL_K_LINES_V.AMOUNT%TYPE := 0;
2228: ln_old_service_amt OKL_K_LINES_V.AMOUNT%TYPE := 0;
2229: ln_new_init_cost OKL_K_LINES_V.INITIAL_DIRECT_COST%TYPE := 0;
2230: ln_period NUMBER :=0;
2231: ln_payment_amount NUMBER :=0;

Line 2228: ln_old_service_amt OKL_K_LINES_V.AMOUNT%TYPE := 0;

2224: ln_calc_amt OKL_K_LINES_V.AMOUNT%TYPE := 0;
2225: ln_old_cap_amt OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
2226: ln_new_cap_amt OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
2227: ln_new_service_amt OKL_K_LINES_V.AMOUNT%TYPE := 0;
2228: ln_old_service_amt OKL_K_LINES_V.AMOUNT%TYPE := 0;
2229: ln_new_init_cost OKL_K_LINES_V.INITIAL_DIRECT_COST%TYPE := 0;
2230: ln_period NUMBER :=0;
2231: ln_payment_amount NUMBER :=0;
2232: ln_sls_payment_amount NUMBER :=0;

Line 2229: ln_new_init_cost OKL_K_LINES_V.INITIAL_DIRECT_COST%TYPE := 0;

2225: ln_old_cap_amt OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
2226: ln_new_cap_amt OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
2227: ln_new_service_amt OKL_K_LINES_V.AMOUNT%TYPE := 0;
2228: ln_old_service_amt OKL_K_LINES_V.AMOUNT%TYPE := 0;
2229: ln_new_init_cost OKL_K_LINES_V.INITIAL_DIRECT_COST%TYPE := 0;
2230: ln_period NUMBER :=0;
2231: ln_payment_amount NUMBER :=0;
2232: ln_sls_payment_amount NUMBER :=0;
2233: l_clev_rec clev_rec_type;

Line 2381: FROM okl_k_lines_v kle,

2377: IS
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

Line 2398: FROM okl_k_lines_v kle_sl,

2394: IS
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,

Line 2401: okl_k_lines_v kle,

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
2404: WHERE cle.dnz_chr_id = p_chr_id
2405: AND cle.id = kle.id

Line 2420: FROM okl_k_lines_v kle,

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,
2422: okc_k_lines_v cle
2423: WHERE cle.cle_id = p_cle_id
2424: AND cle.id = kle.id

Line 2434: FROM okl_k_lines_v kle_sl,

2430: IS
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,

Line 2437: okl_k_lines_v kle,

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
2440: WHERE cle.dnz_chr_id = p_chr_id
2441: AND cle.id = kle.id

Line 2553: FROM okl_k_lines_v kle,

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,
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

Line 2565: p_new_cle_id OKL_K_LINES_V.ID%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
2569: FROM okl_k_lines_v kle,

Line 2569: FROM okl_k_lines_v kle,

2565: p_new_cle_id OKL_K_LINES_V.ID%TYPE)
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

Line 2620: ln_old_line_id OKL_K_LINES_V.ID%TYPE;

2616: and crl.RULE_INFORMATION_CATEGORY = p_rgp_cat
2617: and crg.dnz_chr_id = p_chr_id
2618: and nvl(crg.cle_id,-1) = p_cle_id; */
2619:
2620: ln_old_line_id OKL_K_LINES_V.ID%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;

Line 2621: ln_service_line_id OKL_K_LINES_V.ID%TYPE;

2617: and crg.dnz_chr_id = p_chr_id
2618: and nvl(crg.cle_id,-1) = p_cle_id; */
2619:
2620: ln_old_line_id OKL_K_LINES_V.ID%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;