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 1055: FUNCTION line_oec(p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,

1051: -- Parameters :
1052: -- Version : 1.0
1053: -- End of Commnets
1054:
1055: FUNCTION line_oec(p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
1056: --p_cle_id IN OKC_K_LINES_V.CLE_ID%TYPE DEFAULT Okl_Api.G_MISS_NUM)
1057: p_cle_id IN OKC_K_LINES_V.CLE_ID%TYPE )
1058: RETURN NUMBER IS
1059: G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;

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

1052: -- Version : 1.0
1053: -- End of Commnets
1054:
1055: FUNCTION line_oec(p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
1056: --p_cle_id IN OKC_K_LINES_V.CLE_ID%TYPE DEFAULT Okl_Api.G_MISS_NUM)
1057: p_cle_id IN OKC_K_LINES_V.CLE_ID%TYPE )
1058: RETURN NUMBER IS
1059: G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
1060: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_FORMULA_PVT';

Line 1057: p_cle_id IN OKC_K_LINES_V.CLE_ID%TYPE )

1053: -- End of Commnets
1054:
1055: FUNCTION line_oec(p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
1056: --p_cle_id IN OKC_K_LINES_V.CLE_ID%TYPE DEFAULT Okl_Api.G_MISS_NUM)
1057: p_cle_id IN OKC_K_LINES_V.CLE_ID%TYPE )
1058: RETURN NUMBER IS
1059: G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
1060: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_FORMULA_PVT';
1061: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';

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

1081: ln_addon_line_oec OKL_K_LINES_V.OEC%TYPE := 0;
1082: ln_total_line_oec OKL_K_LINES_V.OEC%TYPE := 0;
1083: l_capred_incl_terminated BOOLEAN := FALSE;
1084: -- Cursor to get the lty_code
1085: CURSOR get_lty_code(p_cle_id IN OKC_K_LINES_V.ID%TYPE) IS
1086: SELECT lse.lty_code
1087: FROM okc_k_lines_b cle,
1088: okc_line_styles_b lse
1089: WHERE cle.id = p_cle_id

Line 1095: OKC_K_LINES_V cle,

1091: -- Cursor to sum up oec for contract
1092: CURSOR c_contract_oec_calc(p_dnz_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1093: SELECT SUM(kle.oec) oec
1094: FROM OKL_K_LINES_V kle,
1095: OKC_K_LINES_V cle,
1096: OKC_K_HEADERS_V CHR
1097: WHERE CHR.id = p_dnz_chr_id
1098: AND CHR.id = cle.dnz_chr_id
1099: AND cle.sts_code NOT IN ( 'ABANDONED', 'TERMINATED', 'EXPIRED', 'CANCELLED', 'HOLD')

Line 1105: OKC_K_LINES_V cle,

1101:
1102: CURSOR c_contract_oec_calc_incl_term(p_dnz_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1103: SELECT SUM(kle.oec) oec
1104: FROM OKL_K_LINES_V kle,
1105: OKC_K_LINES_V cle,
1106: OKC_K_HEADERS_V CHR
1107: WHERE CHR.id = p_dnz_chr_id
1108: AND CHR.id = cle.dnz_chr_id
1109: AND cle.sts_code NOT IN ( 'ABANDONED', 'EXPIRED', 'CANCELLED', 'HOLD')

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

1108: AND CHR.id = cle.dnz_chr_id
1109: AND cle.sts_code NOT IN ( 'ABANDONED', 'EXPIRED', 'CANCELLED', 'HOLD')
1110: AND cle.id = kle.id;
1111: -- Cursor to sum up oec for given model line
1112: CURSOR c_model_oec_calc(p_top_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
1113: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
1114: SELECT SUM(cle.price_unit * cim.number_of_items) oec
1115: FROM okc_subclass_top_line stl,
1116: okc_line_styles_b lse2,

Line 1113: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

1109: AND cle.sts_code NOT IN ( 'ABANDONED', 'EXPIRED', 'CANCELLED', 'HOLD')
1110: AND cle.id = kle.id;
1111: -- Cursor to sum up oec for given model line
1112: CURSOR c_model_oec_calc(p_top_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
1113: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
1114: SELECT SUM(cle.price_unit * cim.number_of_items) oec
1115: FROM okc_subclass_top_line stl,
1116: okc_line_styles_b lse2,
1117: okc_line_styles_b lse1,

Line 1119: okc_k_lines_v cle

1115: FROM okc_subclass_top_line stl,
1116: okc_line_styles_b lse2,
1117: okc_line_styles_b lse1,
1118: okc_k_items_v cim,
1119: okc_k_lines_v cle
1120: WHERE cle.cle_id = p_top_cle_id
1121: AND cle.dnz_chr_id = p_dnz_chr_id
1122: AND cle.id = cim.cle_id
1123: AND cle.dnz_chr_id = cim.dnz_chr_id

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

1127: AND lse2.lty_code = G_FIN_LINE_LTY_CODE
1128: AND lse2.id = stl.lse_id
1129: AND stl.scs_code IN (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE);
1130: -- Cursor to sum up oec of addon line for a given top line
1131: CURSOR c_addon_oec_calc(p_top_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
1132: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
1133: SELECT SUM(cle.price_unit* cim.number_of_items) oec
1134: FROM okc_subclass_top_line stl,
1135: okc_line_styles_b lse3,

Line 1132: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

1128: AND lse2.id = stl.lse_id
1129: AND stl.scs_code IN (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE);
1130: -- Cursor to sum up oec of addon line for a given top line
1131: CURSOR c_addon_oec_calc(p_top_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
1132: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
1133: SELECT SUM(cle.price_unit* cim.number_of_items) oec
1134: FROM okc_subclass_top_line stl,
1135: okc_line_styles_b lse3,
1136: okc_line_styles_b lse2,

Line 1209: OKC_K_LINES_V cle,

1205: CURSOR c_nr_con_oec_calc_incl_term(p_dnz_chr_id OKC_K_HEADERS_V.ID%TYPE,
1206: p_line_type VARCHAR2) IS
1207: SELECT SUM(kle.oec) oec
1208: FROM OKL_K_LINES_V kle,
1209: OKC_K_LINES_V cle,
1210: OKC_K_HEADERS_V CHR
1211: WHERE CHR.id = p_dnz_chr_id
1212: AND CHR.id = cle.dnz_chr_id
1213: AND cle.sts_code NOT IN ( 'ABANDONED', 'EXPIRED', 'CANCELLED', 'HOLD')

Line 1222: OKC_K_LINES_V cle,

1218: CURSOR c_nr_contract_oec_calc(p_dnz_chr_id OKC_K_HEADERS_V.ID%TYPE,
1219: p_line_type VARCHAR2) IS
1220: SELECT SUM(kle.oec) oec
1221: FROM OKL_K_LINES_V kle,
1222: OKC_K_LINES_V cle,
1223: OKC_K_HEADERS_V CHR
1224: WHERE CHR.id = p_dnz_chr_id
1225: AND CHR.id = cle.dnz_chr_id
1226: AND cle.sts_code NOT IN ( 'ABANDONED', 'TERMINATED', 'EXPIRED', 'CANCELLED', 'HOLD')

Line 1231: CURSOR c_nr_model_oec_calc(p_top_cle_id OKC_K_LINES_V.CLE_ID%TYPE,

1227: AND cle.id = kle.id
1228: AND NVL(kle.re_lease_yn,'N') = DECODE(p_line_type,'NEW','N','RELEASE','Y');
1229:
1230: /*
1231: CURSOR c_nr_model_oec_calc(p_top_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
1232: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
1233: p_line_type VARCHAR2) IS
1234: SELECT SUM(cle.price_unit * cim.number_of_items) oec
1235: FROM okc_subclass_top_line stl,

Line 1232: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,

1228: AND NVL(kle.re_lease_yn,'N') = DECODE(p_line_type,'NEW','N','RELEASE','Y');
1229:
1230: /*
1231: CURSOR c_nr_model_oec_calc(p_top_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
1232: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
1233: p_line_type VARCHAR2) IS
1234: SELECT SUM(cle.price_unit * cim.number_of_items) oec
1235: FROM okc_subclass_top_line stl,
1236: okc_line_styles_b lse2,

Line 1239: okc_k_lines_v cle

1235: FROM okc_subclass_top_line stl,
1236: okc_line_styles_b lse2,
1237: okc_line_styles_b lse1,
1238: okc_k_items_v cim,
1239: okc_k_lines_v cle
1240: WHERE cle.cle_id = p_top_cle_id
1241: AND cle.dnz_chr_id = p_dnz_chr_id
1242: AND cle.id = cim.cle_id
1243: AND cle.dnz_chr_id = cim.dnz_chr_id

Line 1260: -- Description : validation with OKC_K_LINES_V

1256: ----------------------------------------------------------------------------------------------------
1257: -- Start of Commnets
1258: -- Badrinath Kuchibholta
1259: -- Procedure Name : validate_dnz_chr_id
1260: -- Description : validation with OKC_K_LINES_V
1261: -- Business Rules :
1262: -- Parameters :
1263: -- Version : 1.0
1264: -- End of Commnets

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

1262: -- Parameters :
1263: -- Version : 1.0
1264: -- End of Commnets
1265:
1266: PROCEDURE validate_dnz_chr_id(p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
1267: x_return_status OUT NOCOPY VARCHAR2) IS
1268: ln_dummy NUMBER := 0;
1269: CURSOR c_dnz_chr_id_validate(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
1270: SELECT 1

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

1265:
1266: PROCEDURE validate_dnz_chr_id(p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
1267: x_return_status OUT NOCOPY VARCHAR2) IS
1268: ln_dummy NUMBER := 0;
1269: CURSOR c_dnz_chr_id_validate(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
1270: SELECT 1
1271: --FROM DUAL
1272: --WHERE EXISTS (SELECT 1
1273: FROM OKC_K_HEADERS_B CHR

Line 4890: FROM okc_k_lines_v l

4886:
4887: -- Get line name to use in the error messages
4888: CURSOR l_cle_csr (cp_cle_id NUMBER) IS
4889: SELECT l.name
4890: FROM okc_k_lines_v l
4891: WHERE l.id = cp_cle_id;
4892:
4893: -- Get header number to use in error messages
4894: CURSOR l_chr_csr (cp_chr_id NUMBER) IS

Line 11760: FROM okc_k_lines_v fin_ast_cle,

11756: ,p_book_class IN VARCHAR2
11757: ,p_book_type_code IN VARCHAR2) IS
11758: SELECT fab.asset_id,
11759: fab.book_type_code
11760: FROM okc_k_lines_v fin_ast_cle,
11761: okc_statuses_b stsb,
11762: fa_additions fad,
11763: fa_book_controls fbc,
11764: fa_books fab

Line 11790: FROM okc_k_lines_v fin_ast_cle,

11786: ,p_book_class IN VARCHAR2
11787: ,p_book_type_code IN VARCHAR2) IS
11788: SELECT fab.asset_id,
11789: fab.book_type_code
11790: FROM okc_k_lines_v fin_ast_cle,
11791: okc_statuses_b stsb,
11792: fa_additions fad,
11793: fa_book_controls fbc,
11794: fa_books fab

Line 11824: FROM okc_k_lines_v fin_ast_cle,

11820: ,p_book_type_code IN VARCHAR2
11821: ,p_line_type IN VARCHAR2) IS
11822: SELECT fab.asset_id,
11823: fab.book_type_code
11824: FROM okc_k_lines_v fin_ast_cle,
11825: okc_statuses_b stsb,
11826: fa_additions fad,
11827: fa_book_controls fbc,
11828: fa_books fab,

Line 11857: FROM okc_k_lines_v fin_ast_cle,

11853: ,p_book_type_code IN VARCHAR2
11854: ,p_line_type IN VARCHAR2) IS
11855: SELECT fab.asset_id,
11856: fab.book_type_code
11857: FROM okc_k_lines_v fin_ast_cle,
11858: okc_statuses_b stsb,
11859: fa_additions fad,
11860: fa_book_controls fbc,
11861: fa_books fab,

Line 12120: FROM okc_k_lines_v fin_ast_cle,

12116: ,p_book_class IN VARCHAR2
12117: ,p_book_type_code IN VARCHAR2) IS
12118: SELECT fab.asset_id,
12119: fab.book_type_code
12120: FROM okc_k_lines_v fin_ast_cle,
12121: okc_statuses_b stsb,
12122: fa_additions fad,
12123: fa_book_controls fbc,
12124: fa_books fab

Line 12150: FROM okc_k_lines_v fin_ast_cle,

12146: ,p_book_class IN VARCHAR2
12147: ,p_book_type_code IN VARCHAR2) IS
12148: SELECT fab.asset_id,
12149: fab.book_type_code
12150: FROM okc_k_lines_v fin_ast_cle,
12151: okc_statuses_b stsb,
12152: fa_additions fad,
12153: fa_book_controls fbc,
12154: fa_books fab

Line 14574: ,okc_k_lines_v line

14570: SELECT NVL(SUM(sele.amount),0)
14571: FROM okl_strm_elements sele
14572: ,okl_streams str
14573: ,okl_strm_type_v sty
14574: ,okc_k_lines_v line
14575: ,okc_statuses_b sts
14576: ,okc_line_styles_b style
14577: WHERE sele.stm_id = str.id
14578: AND str.sty_id = sty.id

Line 14680: ,okc_k_lines_v line

14676: SELECT NVL(SUM(sele.amount),0)
14677: FROM okl_strm_elements sele
14678: ,okl_streams str
14679: ,okl_strm_type_v sty
14680: ,okc_k_lines_v line
14681: -- ,okc_statuses_b sts
14682: ,okc_line_styles_b style
14683: WHERE sele.stm_id = str.id
14684: AND str.sty_id = sty.id

Line 15260: FROM okc_k_lines_v fin_ast_cle,

15256: ,p_book_class IN VARCHAR2 -- 7626121
15257: ,p_book_type_code IN VARCHAR2) IS
15258: SELECT fab.asset_id,
15259: fab.book_type_code
15260: FROM okc_k_lines_v fin_ast_cle,
15261: okc_statuses_b stsb,
15262: fa_additions fad,
15263: fa_book_controls fbc,
15264: fa_books fab

Line 15624: okc_k_lines_v cle

15620: FROM okc_subclass_top_line stl,
15621: okc_line_styles_b lse2,
15622: okc_line_styles_b lse1,
15623: okc_k_items_v cim,
15624: okc_k_lines_v cle
15625: WHERE cle.cle_id = p_line_id
15626: AND cle.dnz_chr_id = p_dnz_chr_id
15627: AND cle.id = cim.cle_id
15628: AND cle.dnz_chr_id = cim.dnz_chr_id