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 OKC_K_LINES_V

Line 313: -- Description : validation with OKC_K_LINES_V

309: -------------------------------------------------------------------------------------------------
310: -- Start of Commnets
311: -- Badrinath Kuchibholta
312: -- Procedure Name : Validate_from _cle_id
313: -- Description : validation with OKC_K_LINES_V
314: -- Business Rules : The Line should be a top Line
315: -- Parameters : 1.P_cle_id should be the top line
316: -- 2.x_fa_line_id the Fixed asset line Id
317: -- as the same will be the okl_txl_tables

Line 321: PROCEDURE validate_from_cle_id(p_cle_id IN OKC_K_LINES_V.ID%TYPE,

317: -- as the same will be the okl_txl_tables
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)

Line 324: x_dnz_chr_id OUT NOCOPY OKC_K_LINES_V.DNZ_CHR_ID%TYPE,

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
327: ln_cle_id OKC_K_LINES_V.CLE_ID%TYPE;
328: ln_chr_id OKC_K_LINES_V.CHR_ID%TYPE;

Line 327: ln_cle_id OKC_K_LINES_V.CLE_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
327: ln_cle_id OKC_K_LINES_V.CLE_ID%TYPE;
328: ln_chr_id OKC_K_LINES_V.CHR_ID%TYPE;
329: lv_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
330: lv_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
331:

Line 328: ln_chr_id OKC_K_LINES_V.CHR_ID%TYPE;

324: x_dnz_chr_id OUT NOCOPY OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
325: x_return_status OUT NOCOPY VARCHAR2)
326: IS
327: ln_cle_id OKC_K_LINES_V.CLE_ID%TYPE;
328: ln_chr_id OKC_K_LINES_V.CHR_ID%TYPE;
329: lv_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
330: lv_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
331:
332: i NUMBER := 0;

Line 333: CURSOR c_cle_id_validate(p_cle_id OKC_K_LINES_V.ID%TYPE)

329: lv_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
330: lv_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
331:
332: i NUMBER := 0;
333: CURSOR c_cle_id_validate(p_cle_id OKC_K_LINES_V.ID%TYPE)
334: IS
335: SELECT cle.cle_id
336: ,cle.chr_id
337: ,lse.lty_code

Line 344: CURSOR c_get_fa_line_id(p_cle_id OKC_K_LINES_V.ID%TYPE)

340: okc_line_styles_v lse
341: WHERE cle.lse_id = lse.id
342: AND cle.id = p_cle_id;
343:
344: CURSOR c_get_fa_line_id(p_cle_id OKC_K_LINES_V.ID%TYPE)
345: IS
346: SELECT cle.id,
347: cle.dnz_chr_id
348: FROM okc_line_styles_b lse,

Line 349: okc_k_lines_v cle

345: IS
346: SELECT cle.id,
347: cle.dnz_chr_id
348: FROM okc_line_styles_b lse,
349: okc_k_lines_v cle
350: WHERE cle.cle_id = p_cle_id
351: AND lse.id = cle.lse_id
352: AND lse.lty_code = G_FA_LINE_LTY_CODE;
353:

Line 354: CURSOR c_get_ib_line_id(p_cle_id OKC_K_LINES_V.ID%TYPE)

350: WHERE cle.cle_id = p_cle_id
351: AND lse.id = cle.lse_id
352: AND lse.lty_code = G_FA_LINE_LTY_CODE;
353:
354: CURSOR c_get_ib_line_id(p_cle_id OKC_K_LINES_V.ID%TYPE)
355: IS
356: SELECT cle_ib.id,
357: cle_ib.dnz_chr_id
358: FROM okc_line_styles_b lse_ib,

Line 507: FUNCTION validate_items_ids(p_cle_id IN OKC_K_LINES_V.ID%TYPE,

503: -- Parameters : 1.P_cle_id should be the Fixed asset line or ib line
504: -- Function will return the Return Status
505: -- Version : 1.0
506: -- End of Commnets
507: FUNCTION validate_items_ids(p_cle_id IN OKC_K_LINES_V.ID%TYPE,
508: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
509: x_object1_id1 OUT NOCOPY OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,
510: x_object1_id2 OUT NOCOPY OKC_K_ITEMS_V.OBJECT1_ID2%TYPE)
511: RETURN VARCHAR2 IS

Line 508: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,

504: -- Function will return the Return Status
505: -- Version : 1.0
506: -- End of Commnets
507: FUNCTION validate_items_ids(p_cle_id IN OKC_K_LINES_V.ID%TYPE,
508: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
509: x_object1_id1 OUT NOCOPY OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,
510: x_object1_id2 OUT NOCOPY OKC_K_ITEMS_V.OBJECT1_ID2%TYPE)
511: RETURN VARCHAR2 IS
512: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;

Line 513: CURSOR c_validate_items_ids(p_cle_id IN OKC_K_LINES_V.ID%TYPE,

509: x_object1_id1 OUT NOCOPY OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,
510: x_object1_id2 OUT NOCOPY OKC_K_ITEMS_V.OBJECT1_ID2%TYPE)
511: RETURN VARCHAR2 IS
512: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
513: CURSOR c_validate_items_ids(p_cle_id IN OKC_K_LINES_V.ID%TYPE,
514: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
515: IS
516: SELECT object1_id1,
517: object1_id2

Line 514: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE)

510: x_object1_id2 OUT NOCOPY OKC_K_ITEMS_V.OBJECT1_ID2%TYPE)
511: RETURN VARCHAR2 IS
512: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
513: CURSOR c_validate_items_ids(p_cle_id IN OKC_K_LINES_V.ID%TYPE,
514: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
515: IS
516: SELECT object1_id1,
517: object1_id2
518: FROM okc_k_items_v cim

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

567: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
568: RETURN x_return_status;
569: END validate_items_ids;
570: ---------------------------------------------------------------------------------------------------------------
571: FUNCTION get_rec_clev(p_id IN OKC_K_LINES_V.ID%TYPE,
572: x_clev_rec OUT NOCOPY clev_rec_type)
573: RETURN VARCHAR2 IS
574: CURSOR okc_clev_pk_csr (p_cle_id NUMBER) IS
575: SELECT ID,

Line 652: FROM Okc_K_Lines_V

648: PRICE_TYPE,
649: CURRENCY_CODE,
650: CURRENCY_CODE_RENEWED,
651: LAST_UPDATE_LOGIN
652: FROM Okc_K_Lines_V
653: WHERE okc_k_lines_v.id = p_cle_id;
654: l_okc_clev_pk okc_clev_pk_csr%ROWTYPE;
655: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
656: BEGIN

Line 653: WHERE okc_k_lines_v.id = p_cle_id;

649: CURRENCY_CODE,
650: CURRENCY_CODE_RENEWED,
651: LAST_UPDATE_LOGIN
652: FROM Okc_K_Lines_V
653: WHERE okc_k_lines_v.id = p_cle_id;
654: l_okc_clev_pk okc_clev_pk_csr%ROWTYPE;
655: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
656: BEGIN
657: -- Get current database values

Line 2286: p_cle_id IN OKC_K_LINES_V.ID%TYPE,

2282: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2283: x_return_status OUT NOCOPY VARCHAR2,
2284: x_msg_count OUT NOCOPY NUMBER,
2285: x_msg_data OUT NOCOPY VARCHAR2,
2286: p_cle_id IN OKC_K_LINES_V.ID%TYPE,
2287: p_fin_cle_id IN OKC_K_LINES_V.ID%TYPE) IS
2288:
2289: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_SID';
2290: ln_cle_id OKL_SUPP_INVOICE_DTLS.CLE_ID%TYPE;

Line 2287: p_fin_cle_id IN OKC_K_LINES_V.ID%TYPE) IS

2283: x_return_status OUT NOCOPY VARCHAR2,
2284: x_msg_count OUT NOCOPY NUMBER,
2285: x_msg_data OUT NOCOPY VARCHAR2,
2286: p_cle_id IN OKC_K_LINES_V.ID%TYPE,
2287: p_fin_cle_id IN OKC_K_LINES_V.ID%TYPE) IS
2288:
2289: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_SID';
2290: ln_cle_id OKL_SUPP_INVOICE_DTLS.CLE_ID%TYPE;
2291: ln_fa_cle_id OKL_SUPP_INVOICE_DTLS.FA_CLE_ID%TYPE;

Line 2311: FROM OKC_K_LINES_V cle_fa,

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,
2312: OKC_LINE_STYLES_V lse_fa,
2313: OKC_K_LINES_V cle_ml,
2314: OKC_LINE_STYLES_V lse_ml
2315: WHERE cle_ml.cle_id = p_cle_id

Line 2313: OKC_K_LINES_V cle_ml,

2309: SELECT cle_ml.id ml_cle_id,
2310: cle_fa.id fa_cle_id
2311: FROM OKC_K_LINES_V cle_fa,
2312: OKC_LINE_STYLES_V lse_fa,
2313: OKC_K_LINES_V cle_ml,
2314: OKC_LINE_STYLES_V lse_ml
2315: WHERE cle_ml.cle_id = p_cle_id
2316: AND cle_ml.lse_id = lse_ml.id
2317: AND lse_ml.lty_code = G_MODEL_LINE_LTY_CODE

Line 2327: FROM OKC_K_LINES_V cle_ad,

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,
2328: OKC_LINE_STYLES_V lse_ad,
2329: OKC_K_LINES_V cle_fa,
2330: OKC_LINE_STYLES_V lse_fa,
2331: OKC_K_LINES_V cle_ml,

Line 2329: OKC_K_LINES_V cle_fa,

2325: SELECT cle_ad.id ad_cle_id,
2326: cle_fa.id fa_cle_id
2327: FROM OKC_K_LINES_V cle_ad,
2328: OKC_LINE_STYLES_V lse_ad,
2329: OKC_K_LINES_V cle_fa,
2330: OKC_LINE_STYLES_V lse_fa,
2331: OKC_K_LINES_V cle_ml,
2332: OKC_LINE_STYLES_V lse_ml
2333: WHERE cle_ml.cle_id = p_cle_id

Line 2331: OKC_K_LINES_V cle_ml,

2327: FROM OKC_K_LINES_V cle_ad,
2328: OKC_LINE_STYLES_V lse_ad,
2329: OKC_K_LINES_V cle_fa,
2330: OKC_LINE_STYLES_V lse_fa,
2331: OKC_K_LINES_V cle_ml,
2332: OKC_LINE_STYLES_V lse_ml
2333: WHERE cle_ml.cle_id = p_cle_id
2334: AND cle_ml.lse_id = lse_ml.id
2335: AND lse_ml.lty_code = G_MODEL_LINE_LTY_CODE

Line 2346: p_orig_cle_id OKC_K_LINES_V.ORIG_SYSTEM_ID1%TYPE)

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
2350: FROM OKC_K_LINES_V cle_ad,

Line 2350: FROM OKC_K_LINES_V cle_ad,

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
2350: FROM OKC_K_LINES_V cle_ad,
2351: OKC_LINE_STYLES_V lse_ad,
2352: OKC_K_LINES_V cle_fa,
2353: OKC_LINE_STYLES_V lse_fa,
2354: OKC_K_LINES_V cle_ml,

Line 2352: OKC_K_LINES_V cle_fa,

2348: SELECT cle_ad.id ad_cle_id,
2349: cle_fa.id fa_cle_id
2350: FROM OKC_K_LINES_V cle_ad,
2351: OKC_LINE_STYLES_V lse_ad,
2352: OKC_K_LINES_V cle_fa,
2353: OKC_LINE_STYLES_V lse_fa,
2354: OKC_K_LINES_V cle_ml,
2355: OKC_LINE_STYLES_V lse_ml
2356: WHERE cle_ml.cle_id = p_cle_id

Line 2354: OKC_K_LINES_V cle_ml,

2350: FROM OKC_K_LINES_V cle_ad,
2351: OKC_LINE_STYLES_V lse_ad,
2352: OKC_K_LINES_V cle_fa,
2353: OKC_LINE_STYLES_V lse_fa,
2354: OKC_K_LINES_V cle_ml,
2355: OKC_LINE_STYLES_V lse_ml
2356: WHERE cle_ml.cle_id = p_cle_id
2357: AND cle_ml.lse_id = lse_ml.id
2358: AND lse_ml.lty_code = G_MODEL_LINE_LTY_CODE

Line 2747: p_cle_id IN OKC_K_LINES_V.ID%TYPE,

2743: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2744: x_return_status OUT NOCOPY VARCHAR2,
2745: x_msg_count OUT NOCOPY NUMBER,
2746: x_msg_data OUT NOCOPY VARCHAR2,
2747: p_cle_id IN OKC_K_LINES_V.ID%TYPE,
2748: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
2749: p_fin_cle_id IN OKC_K_LINES_V.ID%TYPE,
2750: p_trans_type IN OKL_TRX_ASSETS.TAS_TYPE%TYPE,
2751: x_trxv_rec OUT NOCOPY trxv_rec_type,

Line 2748: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,

2744: x_return_status OUT NOCOPY VARCHAR2,
2745: x_msg_count OUT NOCOPY NUMBER,
2746: x_msg_data OUT NOCOPY VARCHAR2,
2747: p_cle_id IN OKC_K_LINES_V.ID%TYPE,
2748: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
2749: p_fin_cle_id IN OKC_K_LINES_V.ID%TYPE,
2750: p_trans_type IN OKL_TRX_ASSETS.TAS_TYPE%TYPE,
2751: x_trxv_rec OUT NOCOPY trxv_rec_type,
2752: x_talv_rec OUT NOCOPY talv_rec_type,

Line 2749: p_fin_cle_id IN OKC_K_LINES_V.ID%TYPE,

2745: x_msg_count OUT NOCOPY NUMBER,
2746: x_msg_data OUT NOCOPY VARCHAR2,
2747: p_cle_id IN OKC_K_LINES_V.ID%TYPE,
2748: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
2749: p_fin_cle_id IN OKC_K_LINES_V.ID%TYPE,
2750: p_trans_type IN OKL_TRX_ASSETS.TAS_TYPE%TYPE,
2751: x_trxv_rec OUT NOCOPY trxv_rec_type,
2752: x_talv_rec OUT NOCOPY talv_rec_type,
2753: x_txdv_tbl OUT NOCOPY txdv_tbl_type) IS

Line 2769: ,p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)

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,
2773: OKC_LINE_STYLES_V lse

Line 2772: FROM OKC_K_LINES_V cle,

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,
2773: OKC_LINE_STYLES_V lse
2774: WHERE cle.cle_id = p_cle_id
2775: AND cle.dnz_chr_id = p_dnz_chr_id
2776: AND cle.lse_id = lse.id

Line 3045: p_cle_id IN OKC_K_LINES_V.ID%TYPE,

3041: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
3042: x_return_status OUT NOCOPY VARCHAR2,
3043: x_msg_count OUT NOCOPY NUMBER,
3044: x_msg_data OUT NOCOPY VARCHAR2,
3045: p_cle_id IN OKC_K_LINES_V.ID%TYPE,
3046: p_from_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
3047: p_to_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
3048: p_fin_cle_id IN OKC_K_LINES_V.ID%TYPE,
3049: p_trans_type IN OKL_TRX_ASSETS.TAS_TYPE%TYPE,

Line 3046: p_from_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,

3042: x_return_status OUT NOCOPY VARCHAR2,
3043: x_msg_count OUT NOCOPY NUMBER,
3044: x_msg_data OUT NOCOPY VARCHAR2,
3045: p_cle_id IN OKC_K_LINES_V.ID%TYPE,
3046: p_from_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
3047: p_to_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
3048: p_fin_cle_id IN OKC_K_LINES_V.ID%TYPE,
3049: p_trans_type IN OKL_TRX_ASSETS.TAS_TYPE%TYPE,
3050: x_trxv_rec OUT NOCOPY trxv_rec_type,

Line 3047: p_to_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,

3043: x_msg_count OUT NOCOPY NUMBER,
3044: x_msg_data OUT NOCOPY VARCHAR2,
3045: p_cle_id IN OKC_K_LINES_V.ID%TYPE,
3046: p_from_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
3047: p_to_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
3048: p_fin_cle_id IN OKC_K_LINES_V.ID%TYPE,
3049: p_trans_type IN OKL_TRX_ASSETS.TAS_TYPE%TYPE,
3050: x_trxv_rec OUT NOCOPY trxv_rec_type,
3051: x_talv_rec OUT NOCOPY talv_rec_type,

Line 3048: p_fin_cle_id IN OKC_K_LINES_V.ID%TYPE,

3044: x_msg_data OUT NOCOPY VARCHAR2,
3045: p_cle_id IN OKC_K_LINES_V.ID%TYPE,
3046: p_from_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
3047: p_to_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
3048: p_fin_cle_id IN OKC_K_LINES_V.ID%TYPE,
3049: p_trans_type IN OKL_TRX_ASSETS.TAS_TYPE%TYPE,
3050: x_trxv_rec OUT NOCOPY trxv_rec_type,
3051: x_talv_rec OUT NOCOPY talv_rec_type,
3052: x_txdv_tbl OUT NOCOPY txdv_tbl_type) IS

Line 3108: ,p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)

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,
3112: OKC_LINE_STYLES_V lse

Line 3111: FROM OKC_K_LINES_V cle,

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,
3112: OKC_LINE_STYLES_V lse
3113: WHERE cle.cle_id = p_cle_id
3114: AND cle.dnz_chr_id = p_dnz_chr_id
3115: AND cle.lse_id = lse.id

Line 3487: p_cle_id IN OKC_K_LINES_V.ID%TYPE,

3483: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
3484: x_return_status OUT NOCOPY VARCHAR2,
3485: x_msg_count OUT NOCOPY NUMBER,
3486: x_msg_data OUT NOCOPY VARCHAR2,
3487: p_cle_id IN OKC_K_LINES_V.ID%TYPE,
3488: p_new_cle_id IN OKC_K_LINES_V.ID%TYPE,
3489: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
3490: p_trans_type IN OKL_TRX_ASSETS.TAS_TYPE%TYPE,
3491: p_asset_number IN OKL_TXL_ASSETS_B.ASSET_NUMBER%TYPE,

Line 3488: p_new_cle_id IN OKC_K_LINES_V.ID%TYPE,

3484: x_return_status OUT NOCOPY VARCHAR2,
3485: x_msg_count OUT NOCOPY NUMBER,
3486: x_msg_data OUT NOCOPY VARCHAR2,
3487: p_cle_id IN OKC_K_LINES_V.ID%TYPE,
3488: p_new_cle_id IN OKC_K_LINES_V.ID%TYPE,
3489: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
3490: p_trans_type IN OKL_TRX_ASSETS.TAS_TYPE%TYPE,
3491: p_asset_number IN OKL_TXL_ASSETS_B.ASSET_NUMBER%TYPE,
3492: p_fin_cle_id IN OKC_K_LINES_V.ID%TYPE,

Line 3489: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,

3485: x_msg_count OUT NOCOPY NUMBER,
3486: x_msg_data OUT NOCOPY VARCHAR2,
3487: p_cle_id IN OKC_K_LINES_V.ID%TYPE,
3488: p_new_cle_id IN OKC_K_LINES_V.ID%TYPE,
3489: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
3490: p_trans_type IN OKL_TRX_ASSETS.TAS_TYPE%TYPE,
3491: p_asset_number IN OKL_TXL_ASSETS_B.ASSET_NUMBER%TYPE,
3492: p_fin_cle_id IN OKC_K_LINES_V.ID%TYPE,
3493: x_trxv_rec OUT NOCOPY trxv_rec_type,

Line 3492: p_fin_cle_id IN OKC_K_LINES_V.ID%TYPE,

3488: p_new_cle_id IN OKC_K_LINES_V.ID%TYPE,
3489: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
3490: p_trans_type IN OKL_TRX_ASSETS.TAS_TYPE%TYPE,
3491: p_asset_number IN OKL_TXL_ASSETS_B.ASSET_NUMBER%TYPE,
3492: p_fin_cle_id IN OKC_K_LINES_V.ID%TYPE,
3493: x_trxv_rec OUT NOCOPY trxv_rec_type,
3494: x_itiv_rec OUT NOCOPY itiv_rec_type)
3495: IS
3496: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_HEADER_LINE_DETAILS';

Line 3501: ,p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)

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,
3505: OKC_LINE_STYLES_V lse

Line 3504: FROM OKC_K_LINES_V cle,

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,
3505: OKC_LINE_STYLES_V lse
3506: WHERE cle.dnz_chr_id = p_dnz_chr_id
3507: AND cle.lse_id = lse.id
3508: AND lse.lty_code = G_IB_LINE_LTY_CODE

Line 3510: FROM OKC_K_LINES_V cle,

3506: WHERE cle.dnz_chr_id = p_dnz_chr_id
3507: AND cle.lse_id = lse.id
3508: AND lse.lty_code = G_IB_LINE_LTY_CODE
3509: AND cle.cle_id in (SELECT cle.id
3510: FROM OKC_K_LINES_V cle,
3511: OKC_LINE_STYLES_V lse
3512: WHERE cle.cle_id = p_cle_id
3513: AND cle.lse_id = lse.id
3514: AND lse.lty_code = G_INST_LINE_LTY_CODE

Line 4076: l_from_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE;

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;
4080: l_talv_rec talv_rec_type;

Line 4176: ,p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)

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,
4180: OKC_LINE_STYLES_V lse

Line 4179: FROM OKC_K_LINES_V cle,

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,
4180: OKC_LINE_STYLES_V lse
4181: WHERE cle.cle_id = p_cle_id
4182: AND cle.dnz_chr_id = p_dnz_chr_id
4183: AND cle.lse_id = lse.id

Line 4193: ,p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)

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
4197: FROM OKC_K_LINES_V cle,

Line 4197: FROM OKC_K_LINES_V cle,

4193: ,p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
4194: IS
4195: SELECT cle.id,
4196: cle.dnz_chr_id
4197: FROM OKC_K_LINES_V cle,
4198: OKC_LINE_STYLES_V lse
4199: WHERE cle.dnz_chr_id = p_dnz_chr_id
4200: AND cle.lse_id = lse.id
4201: AND lse.lty_code = G_IB_LINE_LTY_CODE

Line 4203: FROM OKC_K_LINES_V cle,

4199: WHERE cle.dnz_chr_id = p_dnz_chr_id
4200: AND cle.lse_id = lse.id
4201: AND lse.lty_code = G_IB_LINE_LTY_CODE
4202: AND cle.cle_id in (SELECT cle.id
4203: FROM OKC_K_LINES_V cle,
4204: OKC_LINE_STYLES_V lse
4205: WHERE cle.cle_id = p_cle_id
4206: AND cle.lse_id = lse.id
4207: AND lse.lty_code = G_INST_LINE_LTY_CODE

Line 4211: ,p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)

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
4215: FROM OKC_LINE_STYLES_V lse,

Line 4217: OKC_K_LINES_V cle

4213: SELECT cim.object1_id1,
4214: cim.object1_id2
4215: FROM OKC_LINE_STYLES_V lse,
4216: OKC_K_ITEMS_V cim,
4217: OKC_K_LINES_V cle
4218: WHERE cle.dnz_chr_id = p_dnz_chr_id
4219: AND cle.cle_id = p_cle_id
4220: AND cle.id = cim.cle_id
4221: AND cle.dnz_chr_id = cim.dnz_chr_id

Line 4271: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)

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
4275: FROM okl_k_headers_v khrv,

Line 4278: okc_k_lines_v cle,

4274: klev.oec
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

Line 4949: p_token1_value => 'OKC_K_LINES_V Record');

4945: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4946: OKL_API.set_message(p_app_name => G_APP_NAME,
4947: p_msg_name => G_FETCHING_INFO,
4948: p_token1 => G_REC_NAME_TOKEN,
4949: p_token1_value => 'OKC_K_LINES_V Record');
4950: RAISE G_EXCEPTION_HALT_VALIDATION;
4951: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4952: OKL_API.set_message(p_app_name => G_APP_NAME,
4953: p_msg_name => G_FETCHING_INFO,

Line 4955: p_token1_value => 'OKC_K_LINES_V Record');

4951: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4952: OKL_API.set_message(p_app_name => G_APP_NAME,
4953: p_msg_name => G_FETCHING_INFO,
4954: p_token1 => G_REC_NAME_TOKEN,
4955: p_token1_value => 'OKC_K_LINES_V Record');
4956: RAISE G_EXCEPTION_HALT_VALIDATION;
4957: END IF;
4958: -- To Get the kle top Line Record
4959: x_return_status := get_rec_klev(x_cle_id,

Line 5809: CURSOR srv_link_csr (p_srv_top_line_id OKC_K_LINES_V.ID%TYPE) IS

5805: --
5806: -- returns linked service top line
5807: -- and its sub-lines
5808: --
5809: CURSOR srv_link_csr (p_srv_top_line_id OKC_K_LINES_V.ID%TYPE) IS
5810: SELECT rel.id,
5811: rel.cle_id,
5812: rel.chr_id,
5813: rel.rty_code,

Line 5839: p_line_id OKC_K_LINES_V.ID%TYPE) IS

5835: AND rel.cle_id = line.id
5836: AND line.cle_id = p_srv_top_line_id;
5837:
5838: CURSOR copy_line_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
5839: p_line_id OKC_K_LINES_V.ID%TYPE) IS
5840: SELECT id
5841: FROM okc_k_lines_b
5842: WHERE orig_system_id1 = p_line_id
5843: AND dnz_chr_id = p_chr_id;

Line 5849: l_to_line_id OKC_K_LINES_V.ID%TYPE;

5845: copy_service_failed EXCEPTION;
5846: l_lty_code OKC_LINE_STYLES_B.LTY_CODE%TYPE;
5847: l_from_chr_id OKC_K_HEADERS_B.ID%TYPE;
5848: l_h_link_exist VARCHAR2(1) := 'N';
5849: l_to_line_id OKC_K_LINES_V.ID%TYPE;
5850:
5851: l_crjv_rec OKC_K_REL_OBJS_PUB.crjv_rec_type;
5852: x_crjv_rec OKC_K_REL_OBJS_PUB.crjv_rec_type;
5853: