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

Line 910: FUNCTION line_oec(p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,

906: -- Parameters :
907: -- Version : 1.0
908: -- End of Commnets
909:
910: FUNCTION line_oec(p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
911: --p_cle_id IN OKC_K_LINES_V.CLE_ID%TYPE DEFAULT Okl_Api.G_MISS_NUM)
912: p_cle_id IN OKC_K_LINES_V.CLE_ID%TYPE )
913: RETURN NUMBER IS
914: G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;

Line 911: --p_cle_id IN OKC_K_LINES_V.CLE_ID%TYPE DEFAULT Okl_Api.G_MISS_NUM)

907: -- Version : 1.0
908: -- End of Commnets
909:
910: FUNCTION line_oec(p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
911: --p_cle_id IN OKC_K_LINES_V.CLE_ID%TYPE DEFAULT Okl_Api.G_MISS_NUM)
912: p_cle_id IN OKC_K_LINES_V.CLE_ID%TYPE )
913: RETURN NUMBER IS
914: G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
915: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_FORMULA_PVT';

Line 912: p_cle_id IN OKC_K_LINES_V.CLE_ID%TYPE )

908: -- End of Commnets
909:
910: FUNCTION line_oec(p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
911: --p_cle_id IN OKC_K_LINES_V.CLE_ID%TYPE DEFAULT Okl_Api.G_MISS_NUM)
912: p_cle_id IN OKC_K_LINES_V.CLE_ID%TYPE )
913: RETURN NUMBER IS
914: G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
915: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_FORMULA_PVT';
916: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';

Line 940: CURSOR get_lty_code(p_cle_id IN OKC_K_LINES_V.ID%TYPE) IS

936: ln_addon_line_oec OKL_K_LINES_V.OEC%TYPE := 0;
937: ln_total_line_oec OKL_K_LINES_V.OEC%TYPE := 0;
938: l_capred_incl_terminated BOOLEAN := FALSE;
939: -- Cursor to get the lty_code
940: CURSOR get_lty_code(p_cle_id IN OKC_K_LINES_V.ID%TYPE) IS
941: SELECT lse.lty_code
942: FROM okc_k_lines_b cle,
943: okc_line_styles_b lse
944: WHERE cle.id = p_cle_id

Line 950: OKC_K_LINES_V cle,

946: -- Cursor to sum up oec for contract
947: CURSOR c_contract_oec_calc(p_dnz_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
948: SELECT SUM(kle.oec) oec
949: FROM OKL_K_LINES_V kle,
950: OKC_K_LINES_V cle,
951: OKC_K_HEADERS_V CHR
952: WHERE CHR.id = p_dnz_chr_id
953: AND CHR.id = cle.dnz_chr_id
954: AND cle.sts_code NOT IN ( 'ABANDONED', 'TERMINATED', 'EXPIRED', 'CANCELLED', 'HOLD')

Line 960: OKC_K_LINES_V cle,

956:
957: CURSOR c_contract_oec_calc_incl_term(p_dnz_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
958: SELECT SUM(kle.oec) oec
959: FROM OKL_K_LINES_V kle,
960: OKC_K_LINES_V cle,
961: OKC_K_HEADERS_V CHR
962: WHERE CHR.id = p_dnz_chr_id
963: AND CHR.id = cle.dnz_chr_id
964: AND cle.sts_code NOT IN ( 'ABANDONED', 'EXPIRED', 'CANCELLED', 'HOLD')

Line 967: CURSOR c_model_oec_calc(p_top_cle_id OKC_K_LINES_V.CLE_ID%TYPE,

963: AND CHR.id = cle.dnz_chr_id
964: AND cle.sts_code NOT IN ( 'ABANDONED', 'EXPIRED', 'CANCELLED', 'HOLD')
965: AND cle.id = kle.id;
966: -- Cursor to sum up oec for given model line
967: CURSOR c_model_oec_calc(p_top_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
968: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
969: SELECT SUM(cle.price_unit * cim.number_of_items) oec
970: FROM okc_subclass_top_line stl,
971: okc_line_styles_b lse2,

Line 968: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

964: AND cle.sts_code NOT IN ( 'ABANDONED', 'EXPIRED', 'CANCELLED', 'HOLD')
965: AND cle.id = kle.id;
966: -- Cursor to sum up oec for given model line
967: CURSOR c_model_oec_calc(p_top_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
968: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
969: SELECT SUM(cle.price_unit * cim.number_of_items) oec
970: FROM okc_subclass_top_line stl,
971: okc_line_styles_b lse2,
972: okc_line_styles_b lse1,

Line 974: okc_k_lines_v cle

970: FROM okc_subclass_top_line stl,
971: okc_line_styles_b lse2,
972: okc_line_styles_b lse1,
973: okc_k_items_v cim,
974: okc_k_lines_v cle
975: WHERE cle.cle_id = p_top_cle_id
976: AND cle.dnz_chr_id = p_dnz_chr_id
977: AND cle.id = cim.cle_id
978: AND cle.dnz_chr_id = cim.dnz_chr_id

Line 986: CURSOR c_addon_oec_calc(p_top_cle_id OKC_K_LINES_V.CLE_ID%TYPE,

982: AND lse2.lty_code = G_FIN_LINE_LTY_CODE
983: AND lse2.id = stl.lse_id
984: AND stl.scs_code IN (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE);
985: -- Cursor to sum up oec of addon line for a given top line
986: CURSOR c_addon_oec_calc(p_top_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
987: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
988: SELECT SUM(cle.price_unit* cim.number_of_items) oec
989: FROM okc_subclass_top_line stl,
990: okc_line_styles_b lse3,

Line 987: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

983: AND lse2.id = stl.lse_id
984: AND stl.scs_code IN (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE);
985: -- Cursor to sum up oec of addon line for a given top line
986: CURSOR c_addon_oec_calc(p_top_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
987: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
988: SELECT SUM(cle.price_unit* cim.number_of_items) oec
989: FROM okc_subclass_top_line stl,
990: okc_line_styles_b lse3,
991: okc_line_styles_b lse2,

Line 1063: -- Description : validation with OKC_K_LINES_V

1059: ----------------------------------------------------------------------------------------------------
1060: -- Start of Commnets
1061: -- Badrinath Kuchibholta
1062: -- Procedure Name : validate_dnz_chr_id
1063: -- Description : validation with OKC_K_LINES_V
1064: -- Business Rules :
1065: -- Parameters :
1066: -- Version : 1.0
1067: -- End of Commnets

Line 1069: PROCEDURE validate_dnz_chr_id(p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,

1065: -- Parameters :
1066: -- Version : 1.0
1067: -- End of Commnets
1068:
1069: PROCEDURE validate_dnz_chr_id(p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
1070: x_return_status OUT NOCOPY VARCHAR2) IS
1071: ln_dummy NUMBER := 0;
1072: CURSOR c_dnz_chr_id_validate(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
1073: SELECT 1

Line 1072: CURSOR c_dnz_chr_id_validate(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

1068:
1069: PROCEDURE validate_dnz_chr_id(p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
1070: x_return_status OUT NOCOPY VARCHAR2) IS
1071: ln_dummy NUMBER := 0;
1072: CURSOR c_dnz_chr_id_validate(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
1073: SELECT 1
1074: --FROM DUAL
1075: --WHERE EXISTS (SELECT 1
1076: FROM OKC_K_HEADERS_B CHR

Line 4306: FROM okc_k_lines_v l

4302:
4303: -- Get line name to use in the error messages
4304: CURSOR l_cle_csr (cp_cle_id NUMBER) IS
4305: SELECT l.name
4306: FROM okc_k_lines_v l
4307: WHERE l.id = cp_cle_id;
4308:
4309: -- Get header number to use in error messages
4310: CURSOR l_chr_csr (cp_chr_id NUMBER) IS

Line 10809: FROM okc_k_lines_v fin_ast_cle,

10805: ,p_book_class IN VARCHAR2
10806: ,p_book_type_code IN VARCHAR2) IS
10807: SELECT fab.asset_id,
10808: fab.book_type_code
10809: FROM okc_k_lines_v fin_ast_cle,
10810: okc_statuses_b stsb,
10811: fa_additions fad,
10812: fa_book_controls fbc,
10813: fa_books fab

Line 10839: FROM okc_k_lines_v fin_ast_cle,

10835: ,p_book_class IN VARCHAR2
10836: ,p_book_type_code IN VARCHAR2) IS
10837: SELECT fab.asset_id,
10838: fab.book_type_code
10839: FROM okc_k_lines_v fin_ast_cle,
10840: okc_statuses_b stsb,
10841: fa_additions fad,
10842: fa_book_controls fbc,
10843: fa_books fab

Line 11032: FROM okc_k_lines_v fin_ast_cle,

11028: ,p_book_class IN VARCHAR2
11029: ,p_book_type_code IN VARCHAR2) IS
11030: SELECT fab.asset_id,
11031: fab.book_type_code
11032: FROM okc_k_lines_v fin_ast_cle,
11033: okc_statuses_b stsb,
11034: fa_additions fad,
11035: fa_book_controls fbc,
11036: fa_books fab

Line 11062: FROM okc_k_lines_v fin_ast_cle,

11058: ,p_book_class IN VARCHAR2
11059: ,p_book_type_code IN VARCHAR2) IS
11060: SELECT fab.asset_id,
11061: fab.book_type_code
11062: FROM okc_k_lines_v fin_ast_cle,
11063: okc_statuses_b stsb,
11064: fa_additions fad,
11065: fa_book_controls fbc,
11066: fa_books fab

Line 13342: ,okc_k_lines_v line

13338: SELECT NVL(SUM(sele.amount),0)
13339: FROM okl_strm_elements sele
13340: ,okl_streams str
13341: ,okl_strm_type_v sty
13342: ,okc_k_lines_v line
13343: ,okc_statuses_b sts
13344: ,okc_line_styles_b style
13345: WHERE sele.stm_id = str.id
13346: AND str.sty_id = sty.id

Line 13448: ,okc_k_lines_v line

13444: SELECT NVL(SUM(sele.amount),0)
13445: FROM okl_strm_elements sele
13446: ,okl_streams str
13447: ,okl_strm_type_v sty
13448: ,okc_k_lines_v line
13449: -- ,okc_statuses_b sts
13450: ,okc_line_styles_b style
13451: WHERE sele.stm_id = str.id
13452: AND str.sty_id = sty.id

Line 14028: FROM okc_k_lines_v fin_ast_cle,

14024: ,p_book_class IN VARCHAR2 -- 7626121
14025: ,p_book_type_code IN VARCHAR2) IS
14026: SELECT fab.asset_id,
14027: fab.book_type_code
14028: FROM okc_k_lines_v fin_ast_cle,
14029: okc_statuses_b stsb,
14030: fa_additions fad,
14031: fa_book_controls fbc,
14032: fa_books fab

Line 14392: okc_k_lines_v cle

14388: FROM okc_subclass_top_line stl,
14389: okc_line_styles_b lse2,
14390: okc_line_styles_b lse1,
14391: okc_k_items_v cim,
14392: okc_k_lines_v cle
14393: WHERE cle.cle_id = p_line_id
14394: AND cle.dnz_chr_id = p_dnz_chr_id
14395: AND cle.id = cim.cle_id
14396: AND cle.dnz_chr_id = cim.dnz_chr_id