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_COPY_ASSET_PVT dependencies on OKL_K_LINES

Line 322: x_fa_line_id OUT NOCOPY OKL_K_LINES_V.ID%TYPE,

318: -- 3. Return Status
319: -- Version : 1.0
320: -- End of Commnets
321: PROCEDURE validate_from_cle_id(p_cle_id IN OKC_K_LINES_V.ID%TYPE,
322: x_fa_line_id OUT NOCOPY OKL_K_LINES_V.ID%TYPE,
323: x_ib_id_tbl OUT NOCOPY g_ib_id_tbl,
324: x_dnz_chr_id OUT NOCOPY OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
325: x_return_status OUT NOCOPY VARCHAR2)
326: IS

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

756: END IF;
757: RETURN(x_return_status);
758: END get_rec_clev;
759: -----------------------------------------------------------------------------------------------
760: FUNCTION get_rec_klev(p_id IN OKL_K_LINES_V.ID%TYPE,
761: x_klev_rec OUT NOCOPY klev_rec_type)
762: RETURN VARCHAR2 IS
763: CURSOR okl_k_lines_v_pk_csr (p_kle_id OKL_K_LINES_V.ID%TYPE) IS
764: SELECT ID,

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

759: -----------------------------------------------------------------------------------------------
760: FUNCTION get_rec_klev(p_id IN OKL_K_LINES_V.ID%TYPE,
761: x_klev_rec OUT NOCOPY klev_rec_type)
762: RETURN VARCHAR2 IS
763: CURSOR okl_k_lines_v_pk_csr (p_kle_id OKL_K_LINES_V.ID%TYPE) IS
764: SELECT ID,
765: OBJECT_VERSION_NUMBER,
766: KLE_ID,
767: STY_ID,

Line 891: FROM OKL_K_LINES_V

887: FUNDING_DATE,
888: STREAM_TYPE_SUBCLASS
889: --ramurt Bug#4552772
890: ,FEE_PURPOSE_CODE
891: FROM OKL_K_LINES_V
892: WHERE OKL_K_LINES_V.id = p_kle_id;
893: l_okl_k_lines_v_pk okl_k_lines_v_pk_csr%ROWTYPE;
894: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
895: BEGIN

Line 892: WHERE OKL_K_LINES_V.id = p_kle_id;

888: STREAM_TYPE_SUBCLASS
889: --ramurt Bug#4552772
890: ,FEE_PURPOSE_CODE
891: FROM OKL_K_LINES_V
892: WHERE OKL_K_LINES_V.id = p_kle_id;
893: l_okl_k_lines_v_pk okl_k_lines_v_pk_csr%ROWTYPE;
894: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
895: BEGIN
896: -- Get current database values

Line 893: l_okl_k_lines_v_pk okl_k_lines_v_pk_csr%ROWTYPE;

889: --ramurt Bug#4552772
890: ,FEE_PURPOSE_CODE
891: FROM OKL_K_LINES_V
892: WHERE OKL_K_LINES_V.id = p_kle_id;
893: l_okl_k_lines_v_pk okl_k_lines_v_pk_csr%ROWTYPE;
894: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
895: BEGIN
896: -- Get current database values
897: OPEN okl_k_lines_v_pk_csr (p_id);

Line 897: OPEN okl_k_lines_v_pk_csr (p_id);

893: l_okl_k_lines_v_pk okl_k_lines_v_pk_csr%ROWTYPE;
894: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
895: BEGIN
896: -- Get current database values
897: OPEN okl_k_lines_v_pk_csr (p_id);
898: FETCH okl_k_lines_v_pk_csr INTO
899: x_klev_rec.ID,
900: x_klev_rec.OBJECT_VERSION_NUMBER,
901: x_klev_rec.KLE_ID,

Line 898: FETCH okl_k_lines_v_pk_csr INTO

894: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
895: BEGIN
896: -- Get current database values
897: OPEN okl_k_lines_v_pk_csr (p_id);
898: FETCH okl_k_lines_v_pk_csr INTO
899: x_klev_rec.ID,
900: x_klev_rec.OBJECT_VERSION_NUMBER,
901: x_klev_rec.KLE_ID,
902: x_klev_rec.STY_ID,

Line 1026: IF okl_k_lines_v_pk_csr%NOTFOUND THEN

1022: x_klev_rec.FUNDING_DATE,
1023: x_klev_rec.STREAM_TYPE_SUBCLASS
1024: --ramurt Bug#4552772
1025: ,x_klev_rec.FEE_PURPOSE_CODE;
1026: IF okl_k_lines_v_pk_csr%NOTFOUND THEN
1027: x_return_status := OKL_API.G_RET_STS_ERROR;
1028: END IF;
1029: CLOSE okl_k_lines_v_pk_csr;
1030: RETURN(x_return_status);

Line 1029: CLOSE okl_k_lines_v_pk_csr;

1025: ,x_klev_rec.FEE_PURPOSE_CODE;
1026: IF okl_k_lines_v_pk_csr%NOTFOUND THEN
1027: x_return_status := OKL_API.G_RET_STS_ERROR;
1028: END IF;
1029: CLOSE okl_k_lines_v_pk_csr;
1030: RETURN(x_return_status);
1031: EXCEPTION
1032: WHEN OTHERS THEN
1033: -- store SQL error message on message stack for caller

Line 1043: IF okl_k_lines_v_pk_csr%ISOPEN THEN

1039: SQLERRM);
1040: -- notify caller of an UNEXPECTED error
1041: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1042: -- if the cursor is open
1043: IF okl_k_lines_v_pk_csr%ISOPEN THEN
1044: CLOSE okl_k_lines_v_pk_csr;
1045: END IF;
1046: RETURN(x_return_status);
1047: END get_rec_klev;

Line 1044: CLOSE okl_k_lines_v_pk_csr;

1040: -- notify caller of an UNEXPECTED error
1041: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1042: -- if the cursor is open
1043: IF okl_k_lines_v_pk_csr%ISOPEN THEN
1044: CLOSE okl_k_lines_v_pk_csr;
1045: END IF;
1046: RETURN(x_return_status);
1047: END get_rec_klev;
1048: -------------------------------------------------------------------------------------------------

Line 2299: CURSOR c_validate_supp(p_cle_id OKL_K_LINES_V.ID%TYPE)

2295: ladx_sidv_rec sidv_rec_type;
2296: i NUMBER :=0;
2297: ln_dummy NUMBER :=0;
2298: ln1_dummy NUMBER :=0;
2299: CURSOR c_validate_supp(p_cle_id OKL_K_LINES_V.ID%TYPE)
2300: IS
2301: SELECT 1
2302: FROM DUAL
2303: WHERE EXISTS (SELECT 1

Line 2307: CURSOR c_model_line_id(p_cle_id OKL_K_LINES_V.ID%TYPE)

2303: WHERE EXISTS (SELECT 1
2304: FROM OKL_SUPP_INVOICE_DTLS_V
2305: WHERE cle_id = p_cle_id);
2306:
2307: CURSOR c_model_line_id(p_cle_id OKL_K_LINES_V.ID%TYPE)
2308: IS
2309: SELECT cle_ml.id ml_cle_id,
2310: cle_fa.id fa_cle_id
2311: FROM OKC_K_LINES_V cle_fa,

Line 2323: CURSOR c_addon_line_id(p_cle_id OKL_K_LINES_V.ID%TYPE)

2319: AND cle_fa.dnz_chr_id = cle_ml.dnz_chr_id
2320: AND cle_fa.lse_id = lse_fa.id
2321: AND lse_fa.lty_code = G_FA_LINE_LTY_CODE;
2322:
2323: CURSOR c_addon_line_id(p_cle_id OKL_K_LINES_V.ID%TYPE)
2324: IS
2325: SELECT cle_ad.id ad_cle_id,
2326: cle_fa.id fa_cle_id
2327: FROM OKC_K_LINES_V cle_ad,

Line 2345: CURSOR c_new_addon_line_id(p_cle_id OKL_K_LINES_V.ID%TYPE,

2341: AND cle_ad.dnz_chr_id = cle_ml.dnz_chr_id
2342: AND cle_ad.lse_id = lse_ad.id
2343: AND lse_ad.lty_code = G_ADDON_LINE_LTY_CODE;
2344:
2345: CURSOR c_new_addon_line_id(p_cle_id OKL_K_LINES_V.ID%TYPE,
2346: p_orig_cle_id OKC_K_LINES_V.ORIG_SYSTEM_ID1%TYPE)
2347: IS
2348: SELECT cle_ad.id ad_cle_id,
2349: cle_fa.id fa_cle_id

Line 2760: CURSOR c_trans_line_dtl_exist(p_tal_id OKL_K_LINES_V.ID%TYPE)

2756: l_talv_rec talv_rec_type;
2757: l_txdv_tbl txdv_tbl_type;
2758: ln_dummy NUMBER :=0;
2759: i NUMBER :=0;
2760: CURSOR c_trans_line_dtl_exist(p_tal_id OKL_K_LINES_V.ID%TYPE)
2761: IS
2762: SELECT 1
2763: FROM DUAL
2764: WHERE EXISTS (SELECT '1'

Line 2768: CURSOR c_fa_line_id(p_cle_id OKL_K_LINES_V.ID%TYPE

2764: WHERE EXISTS (SELECT '1'
2765: FROM OKL_TXD_ASSETS_V
2766: WHERE tal_id = p_tal_id);
2767:
2768: CURSOR c_fa_line_id(p_cle_id OKL_K_LINES_V.ID%TYPE
2769: ,p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
2770: IS
2771: SELECT cle.id
2772: FROM OKC_K_LINES_V cle,

Line 3071: okl_k_lines fin_kle,

3067: fa_kle.year_built Year_of_Manufacture
3068: From okc_k_items mdl_cim,
3069: okc_k_lines_b mdl_cle,
3070: okc_line_styles_b mdl_lse,
3071: okl_k_lines fin_kle,
3072: okc_k_lines_tl fin_tl,
3073: okc_k_lines_b fin_cle,
3074: okc_line_styles_b fin_lse,
3075: okl_k_lines fa_kle,

Line 3075: okl_k_lines fa_kle,

3071: okl_k_lines fin_kle,
3072: okc_k_lines_tl fin_tl,
3073: okc_k_lines_b fin_cle,
3074: okc_line_styles_b fin_lse,
3075: okl_k_lines fa_kle,
3076: okc_k_lines_b fa_cle,
3077: okc_line_styles_b fa_lse
3078: where mdl_cim.cle_id = mdl_cle.id
3079: and mdl_cim.dnz_chr_id = mdl_cle.dnz_chr_id

Line 3107: CURSOR c_fa_line_id(p_cle_id OKL_K_LINES_V.ID%TYPE

3103: AND language = 'US';
3104:
3105: l_try_id NUMBER;
3106:
3107: CURSOR c_fa_line_id(p_cle_id OKL_K_LINES_V.ID%TYPE
3108: ,p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
3109: IS
3110: SELECT cle.id
3111: FROM OKC_K_LINES_V cle,

Line 3500: CURSOR c_ib_line_id(p_cle_id OKL_K_LINES_V.ID%TYPE

3496: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_HEADER_LINE_DETAILS';
3497: l_trxv_rec trxv_rec_type;
3498: l_itiv_rec itiv_rec_type;
3499:
3500: CURSOR c_ib_line_id(p_cle_id OKL_K_LINES_V.ID%TYPE
3501: ,p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
3502: IS
3503: SELECT cle.id
3504: FROM OKC_K_LINES_V cle,

Line 3913: okl_k_lines kle_fin

3909: cim_model.object1_id2
3910: from okc_k_items cim_model,
3911: okc_k_lines_b cleb_model,
3912: okc_line_styles_b lseb_model,
3913: okl_k_lines kle_fin
3914: where cim_model.cle_id = cleb_model.id
3915: and cleb_model.cle_id = p_cle_id
3916: and lseb_model.id = cleb_model.lse_id
3917: and lseb_model.lty_code = 'ITEM'

Line 4073: ln_oec OKL_K_LINES_V.OEC%TYPE;

4069: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_COPY_ASSETS';
4070: ln_txl_rec NUMBER := 0;
4071: ln_iti_rec NUMBER := 0;
4072: lv_deal_type OKL_K_HEADERS_V.DEAL_TYPE%TYPE;
4073: ln_oec OKL_K_LINES_V.OEC%TYPE;
4074: l_from_fa_kle_id OKL_K_LINES_V.ID%TYPE;
4075: l_from_ib_kle_id OKL_K_LINES_V.ID%TYPE;
4076: l_from_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE;
4077: ln_cle_id OKL_K_LINES_V.ID%TYPE;

Line 4074: l_from_fa_kle_id OKL_K_LINES_V.ID%TYPE;

4070: ln_txl_rec NUMBER := 0;
4071: ln_iti_rec NUMBER := 0;
4072: lv_deal_type OKL_K_HEADERS_V.DEAL_TYPE%TYPE;
4073: ln_oec OKL_K_LINES_V.OEC%TYPE;
4074: l_from_fa_kle_id OKL_K_LINES_V.ID%TYPE;
4075: l_from_ib_kle_id OKL_K_LINES_V.ID%TYPE;
4076: l_from_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE;
4077: ln_cle_id OKL_K_LINES_V.ID%TYPE;
4078: l_dummy NUMBER := 0;

Line 4075: l_from_ib_kle_id OKL_K_LINES_V.ID%TYPE;

4071: ln_iti_rec NUMBER := 0;
4072: lv_deal_type OKL_K_HEADERS_V.DEAL_TYPE%TYPE;
4073: ln_oec OKL_K_LINES_V.OEC%TYPE;
4074: l_from_fa_kle_id OKL_K_LINES_V.ID%TYPE;
4075: l_from_ib_kle_id OKL_K_LINES_V.ID%TYPE;
4076: l_from_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE;
4077: ln_cle_id OKL_K_LINES_V.ID%TYPE;
4078: l_dummy NUMBER := 0;
4079: l_txdv_tbl txdv_tbl_type;

Line 4077: ln_cle_id OKL_K_LINES_V.ID%TYPE;

4073: ln_oec OKL_K_LINES_V.OEC%TYPE;
4074: l_from_fa_kle_id OKL_K_LINES_V.ID%TYPE;
4075: l_from_ib_kle_id OKL_K_LINES_V.ID%TYPE;
4076: l_from_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE;
4077: ln_cle_id OKL_K_LINES_V.ID%TYPE;
4078: l_dummy NUMBER := 0;
4079: l_txdv_tbl txdv_tbl_type;
4080: l_talv_rec talv_rec_type;
4081: l_itiv_rec itiv_rec_type;

Line 4117: From OKL_K_LINES_FULL_V kle,

4113: Select khr.id,
4114: khr.authoring_org_id,
4115: khr.currency_code,
4116: khr.start_date
4117: From OKL_K_LINES_FULL_V kle,
4118: OKL_K_HEADERS_FULL_V KHR
4119: Where kle.id = cleId
4120: and KHR.ID = KLE.DNZ_CHR_ID;
4121:

Line 4131: CURSOR c_check_txl_rec(p_fa_kle_id OKL_K_LINES_V.ID%TYPE)

4127: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
4128: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
4129: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
4130:
4131: CURSOR c_check_txl_rec(p_fa_kle_id OKL_K_LINES_V.ID%TYPE)
4132: IS
4133: SELECT 1
4134: FROM DUAL
4135: WHERE EXISTS (SELECT '1'

Line 4139: CURSOR c_check_iti_rec(p_ib_kle_id OKL_K_LINES_V.ID%TYPE)

4135: WHERE EXISTS (SELECT '1'
4136: FROM OKL_TXL_ASSETS_V
4137: WHERE kle_Id = p_fa_kle_id);
4138:
4139: CURSOR c_check_iti_rec(p_ib_kle_id OKL_K_LINES_V.ID%TYPE)
4140: IS
4141: SELECT 1
4142: FROM DUAL
4143: WHERE EXISTS (SELECT '1'

Line 4175: CURSOR c_new_fa_line_id(p_cle_id OKL_K_LINES_V.ID%TYPE

4171: FROM OKX_INSTALL_ITEMS_V
4172: WHERE id1 = p_object1_id1
4173: AND id2 = p_object1_id2;
4174:
4175: CURSOR c_new_fa_line_id(p_cle_id OKL_K_LINES_V.ID%TYPE
4176: ,p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
4177: IS
4178: SELECT cle.id
4179: FROM OKC_K_LINES_V cle,

Line 4186: CURSOR c_year_manufactured(p_kle_id OKL_K_LINES_V.ID%TYPE)

4182: AND cle.dnz_chr_id = p_dnz_chr_id
4183: AND cle.lse_id = lse.id
4184: AND lse.lty_code = G_FA_LINE_LTY_CODE;
4185:
4186: CURSOR c_year_manufactured(p_kle_id OKL_K_LINES_V.ID%TYPE)
4187: IS
4188: SELECT kle.Year_Built
4189: FROM OKL_K_LINES_V kle
4190: WHERE kle.id = p_kle_id;

Line 4189: FROM OKL_K_LINES_V kle

4185:
4186: CURSOR c_year_manufactured(p_kle_id OKL_K_LINES_V.ID%TYPE)
4187: IS
4188: SELECT kle.Year_Built
4189: FROM OKL_K_LINES_V kle
4190: WHERE kle.id = p_kle_id;
4191:
4192: CURSOR c_new_ib_line_id(p_cle_id OKL_K_LINES_V.ID%TYPE
4193: ,p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)

Line 4192: CURSOR c_new_ib_line_id(p_cle_id OKL_K_LINES_V.ID%TYPE

4188: SELECT kle.Year_Built
4189: FROM OKL_K_LINES_V kle
4190: WHERE kle.id = p_kle_id;
4191:
4192: CURSOR c_new_ib_line_id(p_cle_id OKL_K_LINES_V.ID%TYPE
4193: ,p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
4194: IS
4195: SELECT cle.id,
4196: cle.dnz_chr_id

Line 4210: CURSOR c_new_model_item_info(p_cle_id OKL_K_LINES_V.ID%TYPE

4206: AND cle.lse_id = lse.id
4207: AND lse.lty_code = G_INST_LINE_LTY_CODE
4208: AND cle.dnz_chr_id = p_dnz_chr_id);
4209:
4210: CURSOR c_new_model_item_info(p_cle_id OKL_K_LINES_V.ID%TYPE
4211: ,p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
4212: IS
4213: SELECT cim.object1_id1,
4214: cim.object1_id2

Line 4270: CURSOR c_get_deal_type(p_top_line_id OKL_K_LINES_V.ID%TYPE,

4266: l_address varchar2(80);
4267: --End BUG# 3569441
4268:
4269:
4270: CURSOR c_get_deal_type(p_top_line_id OKL_K_LINES_V.ID%TYPE,
4271: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
4272: IS
4273: SELECT khrv.deal_type,
4274: klev.oec

Line 4279: okl_k_lines_v klev

4275: FROM okl_k_headers_v khrv,
4276: okc_subclass_top_line stl,
4277: okc_line_styles_b lse,
4278: okc_k_lines_v cle,
4279: okl_k_lines_v klev
4280: WHERE cle.cle_id is null
4281: AND cle.id = klev.id
4282: AND cle.chr_id = cle.dnz_chr_id
4283: AND cle.lse_id = lse.id

Line 4965: p_token1_value => 'OKL_K_LINES_V Record');

4961: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4962: OKL_API.set_message(p_app_name => G_APP_NAME,
4963: p_msg_name => G_FETCHING_INFO,
4964: p_token1 => G_REC_NAME_TOKEN,
4965: p_token1_value => 'OKL_K_LINES_V Record');
4966: RAISE G_EXCEPTION_HALT_VALIDATION;
4967: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4968: OKL_API.set_message(p_app_name => G_APP_NAME,
4969: p_msg_name => G_FETCHING_INFO,

Line 4971: p_token1_value => 'OKL_K_LINES_V Record');

4967: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4968: OKL_API.set_message(p_app_name => G_APP_NAME,
4969: p_msg_name => G_FETCHING_INFO,
4970: p_token1 => G_REC_NAME_TOKEN,
4971: p_token1_value => 'OKL_K_LINES_V Record');
4972: RAISE G_EXCEPTION_HALT_VALIDATION;
4973: END IF;
4974: IF l_klev_rec.id <> l_clev_rec.id THEN
4975: OKL_API.set_message(p_app_name => G_APP_NAME,

Line 5621: okl_k_lines fee_kle,

5617: select cov_ast_cim.object1_id1,
5618: cov_ast_cim.dnz_chr_id
5619: from okc_k_lines_b cov_ast_cleb,
5620: okc_line_styles_b cov_ast_lseb,
5621: okl_k_lines fee_kle,
5622: okc_k_items cov_ast_cim
5623: where fee_kle.id = cov_ast_cleb.cle_id
5624: and fee_kle.fee_type = 'CAPITALIZED'
5625: and cov_ast_lseb.id = cov_ast_cleb.lse_id