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

Line 338: FROM OKC_K_LINES_V cle

334: WHERE chrv.id = p_dnz_chr_id;
335:
336: CURSOR c_get_sls_sts_code(p_cle_id OKC_K_LINES_B.CLE_ID%TYPE) IS
337: SELECT cle.sts_code
338: FROM OKC_K_LINES_V cle
339: WHERE cle.id = p_cle_id;
340: BEGIN
341: -- Both p_dnz_chr_id and p_cle_id are not to be given
342: IF (p_dnz_chr_id IS NOT NULL OR

Line 351: p_token1_value => 'OKC_K_LINES_V.DNZ_CHR_ID and CLE_ID');

347: -- Notify Error
348: OKL_API.set_message(p_app_name => G_APP_NAME,
349: p_msg_name => G_REQUIRED_VALUE,
350: p_token1 => G_COL_NAME_TOKEN,
351: p_token1_value => 'OKC_K_LINES_V.DNZ_CHR_ID and CLE_ID');
352: RAISE G_EXCEPTION_STOP_VALIDATION;
353: END IF;
354: -- Getting the TOP Line STS CODE
355: IF (p_dnz_chr_id IS NOT NULL OR

Line 450: FROM OKC_K_LINES_V cle

446: WHERE chrv.id = p_dnz_chr_id;
447:
448: CURSOR c_get_sls_end_date(p_cle_id OKC_K_LINES_B.CLE_ID%TYPE) IS
449: SELECT cle.end_date
450: FROM OKC_K_LINES_V cle
451: WHERE cle.id = p_cle_id;
452: BEGIN
453: -- Both p_dnz_chr_id and p_cle_id are not to be given
454: IF (p_dnz_chr_id IS NOT NULL OR

Line 463: p_token1_value => 'OKC_K_LINES_V.DNZ_CHR_ID and CLE_ID');

459: -- Notify Error
460: OKL_API.set_message(p_app_name => G_APP_NAME,
461: p_msg_name => G_REQUIRED_VALUE,
462: p_token1 => G_COL_NAME_TOKEN,
463: p_token1_value => 'OKC_K_LINES_V.DNZ_CHR_ID and CLE_ID');
464: RAISE G_EXCEPTION_STOP_VALIDATION;
465: END IF;
466: -- Getting the TOP Line STS CODE
467: IF (p_dnz_chr_id IS NOT NULL OR

Line 551: FROM OKC_K_LINES_V cle

547: WHERE chrv.id = p_dnz_chr_id;
548:
549: CURSOR c_get_sls_start_date(p_cle_id OKC_K_LINES_B.CLE_ID%TYPE) IS
550: SELECT cle.start_date
551: FROM OKC_K_LINES_V cle
552: WHERE cle.id = p_cle_id;
553:
554: CURSOR c_get_trx_date_trans_occ(p_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
555: SELECT date_transaction_occurred

Line 574: p_token1_value => 'OKC_K_LINES_V.DNZ_CHR_ID and CLE_ID');

570: -- Notify Error
571: OKL_API.set_message(p_app_name => G_APP_NAME,
572: p_msg_name => G_REQUIRED_VALUE,
573: p_token1 => G_COL_NAME_TOKEN,
574: p_token1_value => 'OKC_K_LINES_V.DNZ_CHR_ID and CLE_ID');
575: RAISE G_EXCEPTION_STOP_VALIDATION;
576: END IF;
577: -- Getting the TOP Line STS CODE
578: IF (p_dnz_chr_id IS NOT NULL OR

Line 665: FROM OKC_K_LINES_V cle

661: WHERE chrv.id = p_dnz_chr_id;
662:
663: CURSOR c_get_sls_currency_code(p_cle_id OKC_K_LINES_B.CLE_ID%TYPE) IS
664: SELECT cle.currency_code
665: FROM OKC_K_LINES_V cle
666: WHERE cle.id = p_cle_id;
667: BEGIN
668: -- Both p_dnz_chr_id and p_cle_id are not to be given
669: IF (p_dnz_chr_id IS NOT NULL OR

Line 678: p_token1_value => 'OKC_K_LINES_V.DNZ_CHR_ID and CLE_ID');

674: -- Notify Error
675: OKL_API.set_message(p_app_name => G_APP_NAME,
676: p_msg_name => G_REQUIRED_VALUE,
677: p_token1 => G_COL_NAME_TOKEN,
678: p_token1_value => 'OKC_K_LINES_V.DNZ_CHR_ID and CLE_ID');
679: RAISE G_EXCEPTION_STOP_VALIDATION;
680: END IF;
681: -- Getting the TOP Line STS CODE
682: IF (p_dnz_chr_id IS NOT NULL OR

Line 785: FROM OKC_K_LINES_V cle

781: SELECT cle.sts_code,
782: cle.end_date,
783: cle.currency_code,
784: cle.start_date
785: FROM OKC_K_LINES_V cle
786: WHERE cle.id = p_cle_id;
787:
788: CURSOR c_get_trx_date_trans_occ(p_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
789: SELECT date_transaction_occurred

Line 808: p_token1_value => 'OKC_K_LINES_V.DNZ_CHR_ID and CLE_ID');

804: -- Notify Error
805: OKL_API.set_message(p_app_name => G_APP_NAME,
806: p_msg_name => G_REQUIRED_VALUE,
807: p_token1 => G_COL_NAME_TOKEN,
808: p_token1_value => 'OKC_K_LINES_V.DNZ_CHR_ID and CLE_ID');
809: RAISE G_EXCEPTION_STOP_VALIDATION;
810: END IF;
811: -- Getting the TOP Line STS CODE
812: IF (p_dnz_chr_id IS NOT NULL OR

Line 1501: FROM okc_k_lines_v cle,

1497:
1498: /*FROM okc_k_items_v cim
1499: WHERE cim.dnz_chr_id = p_dnz_chr_id
1500: AND cim.cle_id in (SELECT cle.id
1501: FROM okc_k_lines_v cle,
1502: okc_line_styles_v lse
1503: WHERE cle.lse_id = lse.id
1504: AND lse.lty_code = 'ITEM'
1505: AND cle.dnz_chr_id = cim.dnz_chr_id

Line 1507: FROM okc_k_lines_v cle1

1503: WHERE cle.lse_id = lse.id
1504: AND lse.lty_code = 'ITEM'
1505: AND cle.dnz_chr_id = cim.dnz_chr_id
1506: AND cle.cle_id in (SELECT cle1.cle_id
1507: FROM okc_k_lines_v cle1
1508: WHERE cle1.id = p_cle_id
1509: AND cle1.dnz_chr_id = cim.dnz_chr_id));*/
1510: l_okc_cimv_pk okc_cimv_pk_csr%ROWTYPE;
1511: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;

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

1981: END IF;
1982: RETURN(x_return_status);
1983: END get_try_id;
1984: ------------------------------------------------------------------------------------------------------
1985: FUNCTION get_rec_clev(p_id IN OKC_K_LINES_V.ID%TYPE,
1986: x_clev_rec OUT NOCOPY clev_rec_type)
1987: RETURN VARCHAR2 IS
1988: CURSOR okc_clev_pk_csr (p_cle_id NUMBER) IS
1989: SELECT ID,

Line 2066: FROM Okc_K_Lines_V

2062: PRICE_TYPE,
2063: CURRENCY_CODE,
2064: CURRENCY_CODE_RENEWED,
2065: LAST_UPDATE_LOGIN
2066: FROM Okc_K_Lines_V
2067: WHERE okc_k_lines_v.id = p_cle_id;
2068: l_okc_clev_pk okc_clev_pk_csr%ROWTYPE;
2069: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
2070: BEGIN

Line 2067: WHERE okc_k_lines_v.id = p_cle_id;

2063: CURRENCY_CODE,
2064: CURRENCY_CODE_RENEWED,
2065: LAST_UPDATE_LOGIN
2066: FROM Okc_K_Lines_V
2067: WHERE okc_k_lines_v.id = p_cle_id;
2068: l_okc_clev_pk okc_clev_pk_csr%ROWTYPE;
2069: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
2070: BEGIN
2071: -- Get current database values

Line 2868: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

2864: -- Version : 1.0
2865: -- End of Commnets
2866: PROCEDURE validate_new_asset_number(x_return_status OUT NOCOPY VARCHAR2,
2867: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
2868: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
2869: ln_okl_txl_assets_v NUMBER := 0;
2870: ln_okx_assets_v NUMBER := 0;
2871: ln_okx_asset_lines_v NUMBER := 0;
2872: ln_okl_txd_assets_v NUMBER := 0;

Line 2921: /*CURSOR c_check_release_asset(p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE) is

2917:
2918: --Bug# 15992711 : The re-leased flag is no longer checked at contract header
2919: -- but needs to be validated at contract line
2920: -- Cursor modified to include validation at asset line level
2921: /*CURSOR c_check_release_asset(p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE) is
2922: SELECT RULE_INFORMATION1
2923: FROM OKC_RULES_V
2924: WHERE DNZ_CHR_ID = p_dnz_chr_id
2925: AND RULE_INFORMATION_CATEGORY = 'LARLES';*/

Line 3282: p_token1_value => 'OKC_K_LINES_V.LSE_ID');

3278: -- store SQL error message on message stack
3279: OKL_API.set_message(p_app_name => G_APP_NAME,
3280: p_msg_name => G_REQUIRED_VALUE,
3281: p_token1 => G_COL_NAME_TOKEN,
3282: p_token1_value => 'OKC_K_LINES_V.LSE_ID');
3283: -- halt validation as it is a required field
3284: RAISE G_EXCEPTION_STOP_VALIDATION;
3285: END IF;
3286: -- Enforce Foreign Key

Line 3295: p_token1_value => 'OKC_K_LINES_V.LSE_ID');

3291: IF c_lse_id_validate%NOTFOUND THEN
3292: OKL_API.set_message(p_app_name => G_APP_NAME,
3293: p_msg_name => G_NO_MATCHING_RECORD,
3294: p_token1 => G_COL_NAME_TOKEN,
3295: p_token1_value => 'OKC_K_LINES_V.LSE_ID');
3296: -- halt validation as it has no parent record
3297: RAISE G_EXCEPTION_HALT_VALIDATION;
3298: END IF;
3299: CLOSE c_lse_id_validate;

Line 3308: p_token1_value => 'OKC_K_LINES_V.LSE_ID');

3304: x_lse_type IS NULL) THEN
3305: OKL_API.set_message(p_app_name => G_APP_NAME,
3306: p_msg_name => G_NO_MATCHING_RECORD,
3307: p_token1 => G_COL_NAME_TOKEN,
3308: p_token1_value => 'OKC_K_LINES_V.LSE_ID');
3309: -- halt validation as it has no parent record
3310: RAISE G_EXCEPTION_HALT_VALIDATION;
3311: END IF;
3312: EXCEPTION

Line 3343: -- with OKC_k_LINES_V and Check if the line style is TLS

3339: -- Start of Commnets
3340: -- Badrinath Kuchibholta
3341: -- Procedure Name : validate_cle_lse_id
3342: -- Description : validation of the cle_id
3343: -- with OKC_k_LINES_V and Check if the line style is TLS
3344: -- Business Rules :
3345: -- Parameters :
3346: -- Version : 1.0
3347: -- End of Commnets

Line 3353: ln_cle_id OKC_K_LINES_V.ID%TYPE := 0;

3349: PROCEDURE validate_cle_lse_id(p_clev_rec IN clev_rec_type,
3350: p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,
3351: x_lty_code OUT NOCOPY OKC_LINE_STYLES_V.LTY_CODE%TYPE,
3352: x_return_status OUT NOCOPY VARCHAR2) IS
3353: ln_cle_id OKC_K_LINES_V.ID%TYPE := 0;
3354: lv_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
3355: lv_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
3356:
3357: CURSOR c_cle_id_validate(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE) IS

Line 3357: CURSOR c_cle_id_validate(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE) IS

3353: ln_cle_id OKC_K_LINES_V.ID%TYPE := 0;
3354: lv_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
3355: lv_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
3356:
3357: CURSOR c_cle_id_validate(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE) IS
3358: SELECT lse.lty_code
3359: FROM OKC_K_LINES_V cle,
3360: OKC_LINE_STYLES_V lse
3361: WHERE cle.id = p_cle_id

Line 3359: FROM OKC_K_LINES_V cle,

3355: lv_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
3356:
3357: CURSOR c_cle_id_validate(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE) IS
3358: SELECT lse.lty_code
3359: FROM OKC_K_LINES_V cle,
3360: OKC_LINE_STYLES_V lse
3361: WHERE cle.id = p_cle_id
3362: AND lse.id = cle.lse_id;
3363:

Line 3373: p_token1_value => 'OKC_K_LINES_V.CLE_ID');

3369: p_clev_rec.cle_id IS NULL) THEN
3370: OKL_API.set_message(p_app_name => G_APP_NAME,
3371: p_msg_name => G_REQUIRED_VALUE,
3372: p_token1 => G_COL_NAME_TOKEN,
3373: p_token1_value => 'OKC_K_LINES_V.CLE_ID');
3374: -- halt validation as it is a required field
3375: RAISE G_EXCEPTION_STOP_VALIDATION;
3376: END IF;
3377: -- check the valid id is there

Line 3383: p_token1_value => 'OKC_K_LINES_V.CLE_ID');

3379: IF c_cle_id_validate%NOTFOUND THEN
3380: OKL_API.set_message(p_app_name => G_APP_NAME,
3381: p_msg_name => G_NO_MATCHING_RECORD,
3382: p_token1 => G_COL_NAME_TOKEN,
3383: p_token1_value => 'OKC_K_LINES_V.CLE_ID');
3384: -- halt validation as it has no parent record
3385: RAISE G_EXCEPTION_HALT_VALIDATION;
3386: END IF;
3387: FETCH c_cle_id_validate into lv_lty_code;

Line 3442: -- Description : validation with OKC_K_LINES_V

3438: ----------------------------------------------------------------------------------------------------
3439: -- Start of Commnets
3440: -- Badrinath Kuchibholta
3441: -- Procedure Name : validate_dnz_chr_id
3442: -- Description : validation with OKC_K_LINES_V
3443: -- Business Rules :
3444: -- Parameters :
3445: -- Version : 1.0
3446: -- End of Commnets

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

3447:
3448: PROCEDURE validate_dnz_chr_id(p_clev_rec IN clev_rec_type,
3449: x_return_status OUT NOCOPY VARCHAR2) IS
3450: ln_dummy NUMBER := 0;
3451: CURSOR c_dnz_chr_id_validate(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
3452: SELECT 1
3453: --FROM DUAL
3454: --WHERE EXISTS (SELECT 1
3455: FROM OKC_K_HEADERS_B chrv

Line 3467: p_token1_value => 'OKC_K_LINES_V.DNZ_CHR_ID');

3463: -- store SQL error message on message stack
3464: OKL_API.set_message(p_app_name => G_APP_NAME,
3465: p_msg_name => G_REQUIRED_VALUE,
3466: p_token1 => G_COL_NAME_TOKEN,
3467: p_token1_value => 'OKC_K_LINES_V.DNZ_CHR_ID');
3468: -- halt validation as it is a required field
3469: RAISE G_EXCEPTION_STOP_VALIDATION;
3470: END IF;
3471: -- Enforce Foreign Key

Line 3480: p_token1_value => 'OKC_K_LINES_V.DNZ_CHR_ID');

3476: IF c_dnz_chr_id_validate%NOTFOUND THEN
3477: OKL_API.set_message(p_app_name => G_APP_NAME,
3478: p_msg_name => G_NO_MATCHING_RECORD,
3479: p_token1 => G_COL_NAME_TOKEN,
3480: p_token1_value => 'OKC_K_LINES_V.DNZ_CHR_ID');
3481: -- halt validation as it has no parent record
3482: RAISE G_EXCEPTION_HALT_VALIDATION;
3483: END IF;
3484: FETCH c_dnz_chr_id_validate into ln_dummy;

Line 3490: p_token1_value => 'OKC_K_LINES_V.DNZ_CHR_ID');

3486: IF (ln_dummy = 0) THEN
3487: OKL_API.set_message(p_app_name => G_APP_NAME,
3488: p_msg_name => G_NO_MATCHING_RECORD,
3489: p_token1 => G_COL_NAME_TOKEN,
3490: p_token1_value => 'OKC_K_LINES_V.DNZ_CHR_ID');
3491: -- halt validation as it has no parent record
3492: RAISE G_EXCEPTION_HALT_VALIDATION;
3493: END IF;
3494: EXCEPTION

Line 3857: -- Description : validation with OKC_K_LINES_V

3853: ----------------------------------------------------------------------------------------------------
3854: -- Start of Commnets
3855: -- Badrinath Kuchibholta
3856: -- Procedure Name : validate_sts_code
3857: -- Description : validation with OKC_K_LINES_V
3858: -- Business Rules :
3859: -- Parameters :
3860: -- Version : 1.0
3861: -- End of Commnets

Line 3866: lv_sts_code OKC_K_LINES_V.STS_CODE%TYPE;

3862:
3863: PROCEDURE validate_sts_code(p_clev_rec IN clev_rec_type,
3864: x_return_status OUT NOCOPY VARCHAR2) IS
3865:
3866: lv_sts_code OKC_K_LINES_V.STS_CODE%TYPE;
3867: lv_lty_code OKC_LINE_STYLES_V.lty_CODE%TYPE;
3868:
3869: CURSOR c_lty_code_validate(p_lse_id OKC_LINE_STYLES_B.ID%TYPE) IS
3870: SELECT lse.lty_code

Line 3874: CURSOR c_sub_sub_line_sts_code(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,

3870: SELECT lse.lty_code
3871: FROM OKC_LINE_STYLES_V lse
3872: WHERE lse.id = p_lse_id;
3873:
3874: CURSOR c_sub_sub_line_sts_code(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
3875: p_cle_id OKC_K_LINES_V.ID%TYPE,
3876: p_lty_code OKC_LINE_STYLES_V.lty_CODE%TYPE) IS
3877: SELECT cle.sts_code
3878: FROM OKC_K_LINES_V cle

Line 3875: p_cle_id OKC_K_LINES_V.ID%TYPE,

3871: FROM OKC_LINE_STYLES_V lse
3872: WHERE lse.id = p_lse_id;
3873:
3874: CURSOR c_sub_sub_line_sts_code(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
3875: p_cle_id OKC_K_LINES_V.ID%TYPE,
3876: p_lty_code OKC_LINE_STYLES_V.lty_CODE%TYPE) IS
3877: SELECT cle.sts_code
3878: FROM OKC_K_LINES_V cle
3879: WHERE cle.id in (SELECT cle.cle_id

Line 3878: FROM OKC_K_LINES_V cle

3874: CURSOR c_sub_sub_line_sts_code(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
3875: p_cle_id OKC_K_LINES_V.ID%TYPE,
3876: p_lty_code OKC_LINE_STYLES_V.lty_CODE%TYPE) IS
3877: SELECT cle.sts_code
3878: FROM OKC_K_LINES_V cle
3879: WHERE cle.id in (SELECT cle.cle_id
3880: FROM OKC_K_LINES_V cle
3881: WHERE id in (SELECT cle.cle_id
3882: FROM OKC_LINE_STYLES_V lse,

Line 3880: FROM OKC_K_LINES_V cle

3876: p_lty_code OKC_LINE_STYLES_V.lty_CODE%TYPE) IS
3877: SELECT cle.sts_code
3878: FROM OKC_K_LINES_V cle
3879: WHERE cle.id in (SELECT cle.cle_id
3880: FROM OKC_K_LINES_V cle
3881: WHERE id in (SELECT cle.cle_id
3882: FROM OKC_LINE_STYLES_V lse,
3883: OKC_K_LINES_V cle
3884: WHERE dnz_chr_id = p_dnz_chr_id

Line 3883: OKC_K_LINES_V cle

3879: WHERE cle.id in (SELECT cle.cle_id
3880: FROM OKC_K_LINES_V cle
3881: WHERE id in (SELECT cle.cle_id
3882: FROM OKC_LINE_STYLES_V lse,
3883: OKC_K_LINES_V cle
3884: WHERE dnz_chr_id = p_dnz_chr_id
3885: AND cle.lse_id = lse.id
3886: AND cle.id = p_cle_id
3887: AND lse.lty_code = p_lty_code));

Line 3889: CURSOR c_sub_line_sts_code(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,

3885: AND cle.lse_id = lse.id
3886: AND cle.id = p_cle_id
3887: AND lse.lty_code = p_lty_code));
3888:
3889: CURSOR c_sub_line_sts_code(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
3890: p_cle_id OKC_K_LINES_V.ID%TYPE,
3891: p_lty_code OKC_LINE_STYLES_V.lty_CODE%TYPE) IS
3892: SELECT cle.sts_code
3893: FROM OKC_K_LINES_V cle

Line 3890: p_cle_id OKC_K_LINES_V.ID%TYPE,

3886: AND cle.id = p_cle_id
3887: AND lse.lty_code = p_lty_code));
3888:
3889: CURSOR c_sub_line_sts_code(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
3890: p_cle_id OKC_K_LINES_V.ID%TYPE,
3891: p_lty_code OKC_LINE_STYLES_V.lty_CODE%TYPE) IS
3892: SELECT cle.sts_code
3893: FROM OKC_K_LINES_V cle
3894: WHERE id in (SELECT cle.cle_id

Line 3893: FROM OKC_K_LINES_V cle

3889: CURSOR c_sub_line_sts_code(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
3890: p_cle_id OKC_K_LINES_V.ID%TYPE,
3891: p_lty_code OKC_LINE_STYLES_V.lty_CODE%TYPE) IS
3892: SELECT cle.sts_code
3893: FROM OKC_K_LINES_V cle
3894: WHERE id in (SELECT cle.cle_id
3895: FROM OKC_LINE_STYLES_V lse,
3896: OKC_K_LINES_V cle
3897: WHERE dnz_chr_id = p_dnz_chr_id

Line 3896: OKC_K_LINES_V cle

3892: SELECT cle.sts_code
3893: FROM OKC_K_LINES_V cle
3894: WHERE id in (SELECT cle.cle_id
3895: FROM OKC_LINE_STYLES_V lse,
3896: OKC_K_LINES_V cle
3897: WHERE dnz_chr_id = p_dnz_chr_id
3898: AND cle.lse_id = lse.id
3899: AND cle.id = p_cle_id
3900: AND lse.lty_code = p_lty_code);

Line 3902: CURSOR c_top_line_sts_code(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,

3898: AND cle.lse_id = lse.id
3899: AND cle.id = p_cle_id
3900: AND lse.lty_code = p_lty_code);
3901:
3902: CURSOR c_top_line_sts_code(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
3903: p_cle_id OKC_K_LINES_V.ID%TYPE,
3904: p_chr_id OKC_K_LINES_V.CHR_ID%TYPE) IS
3905: SELECT cle.sts_code
3906: FROM OKC_K_LINES_V cle

Line 3903: p_cle_id OKC_K_LINES_V.ID%TYPE,

3899: AND cle.id = p_cle_id
3900: AND lse.lty_code = p_lty_code);
3901:
3902: CURSOR c_top_line_sts_code(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
3903: p_cle_id OKC_K_LINES_V.ID%TYPE,
3904: p_chr_id OKC_K_LINES_V.CHR_ID%TYPE) IS
3905: SELECT cle.sts_code
3906: FROM OKC_K_LINES_V cle
3907: WHERE cle.dnz_chr_id = p_dnz_chr_id

Line 3904: p_chr_id OKC_K_LINES_V.CHR_ID%TYPE) IS

3900: AND lse.lty_code = p_lty_code);
3901:
3902: CURSOR c_top_line_sts_code(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
3903: p_cle_id OKC_K_LINES_V.ID%TYPE,
3904: p_chr_id OKC_K_LINES_V.CHR_ID%TYPE) IS
3905: SELECT cle.sts_code
3906: FROM OKC_K_LINES_V cle
3907: WHERE cle.dnz_chr_id = p_dnz_chr_id
3908: AND cle.cle_id is null

Line 3906: FROM OKC_K_LINES_V cle

3902: CURSOR c_top_line_sts_code(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
3903: p_cle_id OKC_K_LINES_V.ID%TYPE,
3904: p_chr_id OKC_K_LINES_V.CHR_ID%TYPE) IS
3905: SELECT cle.sts_code
3906: FROM OKC_K_LINES_V cle
3907: WHERE cle.dnz_chr_id = p_dnz_chr_id
3908: AND cle.cle_id is null
3909: AND cle.id = p_cle_id
3910: AND cle.chr_id = p_chr_id;

Line 3920: p_token1_value => 'OKC_K_LINES_V.STS_CODE');

3916: -- store SQL error message on message stack
3917: OKL_API.set_message(p_app_name => G_APP_NAME,
3918: p_msg_name => G_REQUIRED_VALUE,
3919: p_token1 => G_COL_NAME_TOKEN,
3920: p_token1_value => 'OKC_K_LINES_V.STS_CODE');
3921: -- halt validation as it is a required field
3922: RAISE G_EXCEPTION_STOP_VALIDATION;
3923: END IF;
3924: -- First Get the Lty _code we are going to validate

Line 3946: p_token1_value => 'OKC_K_LINES_V.STS_CODE');

3942: IF c_sub_sub_line_sts_code%NOTFOUND THEN
3943: OKL_API.set_message(p_app_name => G_APP_NAME,
3944: p_msg_name => G_NO_MATCHING_RECORD,
3945: p_token1 => G_COL_NAME_TOKEN,
3946: p_token1_value => 'OKC_K_LINES_V.STS_CODE');
3947: -- halt validation as it is a required field
3948: RAISE G_EXCEPTION_HALT_VALIDATION;
3949: END IF;
3950: FETCH c_sub_sub_line_sts_code INTO lv_sts_code;

Line 3962: p_token1_value => 'OKC_K_LINES_V.STS_CODE');

3958: IF c_sub_line_sts_code%NOTFOUND THEN
3959: OKL_API.set_message(p_app_name => G_APP_NAME,
3960: p_msg_name => G_NO_MATCHING_RECORD,
3961: p_token1 => G_COL_NAME_TOKEN,
3962: p_token1_value => 'OKC_K_LINES_V.STS_CODE');
3963: -- halt validation as it is a required field
3964: RAISE G_EXCEPTION_HALT_VALIDATION;
3965: END IF;
3966: FETCH c_sub_line_sts_code INTO lv_sts_code;

Line 3976: p_token1_value => 'OKC_K_LINES_V.STS_CODE');

3972: IF c_top_line_sts_code%NOTFOUND THEN
3973: OKL_API.set_message(p_app_name => G_APP_NAME,
3974: p_msg_name => G_NO_MATCHING_RECORD,
3975: p_token1 => G_COL_NAME_TOKEN,
3976: p_token1_value => 'OKC_K_LINES_V.STS_CODE');
3977: -- halt validation as it is a required field
3978: RAISE G_EXCEPTION_HALT_VALIDATION;
3979: END IF;
3980: FETCH c_top_line_sts_code INTO lv_sts_code;

Line 6433: ln_display_sequence OKC_K_LINES_V.DISPLAY_SEQUENCE%TYPE := 0;

6429: l_cimv_rec cimv_rec_type;
6430: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
6431: i NUMBER := 0;
6432: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_AO_LNE_ITEM';
6433: ln_display_sequence OKC_K_LINES_V.DISPLAY_SEQUENCE%TYPE := 0;
6434: ln_num_of_items OKC_K_ITEMS.NUMBER_OF_ITEMS%TYPE := 0;
6435:
6436: CURSOR get_dis_seq_qty(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
6437: P_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

Line 6436: CURSOR get_dis_seq_qty(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,

6432: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_AO_LNE_ITEM';
6433: ln_display_sequence OKC_K_LINES_V.DISPLAY_SEQUENCE%TYPE := 0;
6434: ln_num_of_items OKC_K_ITEMS.NUMBER_OF_ITEMS%TYPE := 0;
6435:
6436: CURSOR get_dis_seq_qty(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
6437: P_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
6438: SELECT cle.display_sequence,
6439: cim.number_of_items
6440: FROM okc_line_styles_b lse2,

Line 6437: P_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

6433: ln_display_sequence OKC_K_LINES_V.DISPLAY_SEQUENCE%TYPE := 0;
6434: ln_num_of_items OKC_K_ITEMS.NUMBER_OF_ITEMS%TYPE := 0;
6435:
6436: CURSOR get_dis_seq_qty(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
6437: P_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
6438: SELECT cle.display_sequence,
6439: cim.number_of_items
6440: FROM okc_line_styles_b lse2,
6441: okc_line_styles_b lse1,

Line 6642: ln_display_sequence OKC_K_LINES_V.DISPLAY_SEQUENCE%TYPE;

6638: l_cimv_rec cimv_rec_type;
6639: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
6640: i NUMBER;
6641: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_AO_LNE_ITEM';
6642: ln_display_sequence OKC_K_LINES_V.DISPLAY_SEQUENCE%TYPE;
6643: ln_num_of_items OKC_K_ITEMS.NUMBER_OF_ITEMS%TYPE;
6644:
6645: CURSOR get_dis_seq_qty(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
6646: P_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

Line 6645: CURSOR get_dis_seq_qty(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,

6641: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_AO_LNE_ITEM';
6642: ln_display_sequence OKC_K_LINES_V.DISPLAY_SEQUENCE%TYPE;
6643: ln_num_of_items OKC_K_ITEMS.NUMBER_OF_ITEMS%TYPE;
6644:
6645: CURSOR get_dis_seq_qty(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
6646: P_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
6647: SELECT cle.display_sequence,
6648: cim.number_of_items
6649: FROM okc_line_styles_b lse2,

Line 6646: P_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

6642: ln_display_sequence OKC_K_LINES_V.DISPLAY_SEQUENCE%TYPE;
6643: ln_num_of_items OKC_K_ITEMS.NUMBER_OF_ITEMS%TYPE;
6644:
6645: CURSOR get_dis_seq_qty(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
6646: P_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
6647: SELECT cle.display_sequence,
6648: cim.number_of_items
6649: FROM okc_line_styles_b lse2,
6650: okc_line_styles_b lse1,

Line 6854: ln_fa_id OKC_K_LINES_V.ID%TYPE;

6850: l_clev_rec clev_rec_type;
6851: -- Variables for validation of line style
6852: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
6853: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
6854: ln_fa_id OKC_K_LINES_V.ID%TYPE;
6855:
6856: CURSOR get_fa_id(p_top_line OKC_K_LINES_V.ID%TYPE,
6857: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
6858: IS

Line 6856: CURSOR get_fa_id(p_top_line OKC_K_LINES_V.ID%TYPE,

6852: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
6853: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
6854: ln_fa_id OKC_K_LINES_V.ID%TYPE;
6855:
6856: CURSOR get_fa_id(p_top_line OKC_K_LINES_V.ID%TYPE,
6857: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
6858: IS
6859: SELECT cle.id
6860: FROM okc_subclass_top_line stl,

Line 6857: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)

6853: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
6854: ln_fa_id OKC_K_LINES_V.ID%TYPE;
6855:
6856: CURSOR get_fa_id(p_top_line OKC_K_LINES_V.ID%TYPE,
6857: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
6858: IS
6859: SELECT cle.id
6860: FROM okc_subclass_top_line stl,
6861: okc_line_styles_b lse2,

Line 7052: ln_fa_id OKC_K_LINES_V.ID%TYPE;

7048: l_clev_rec clev_rec_type;
7049: -- Variables for validation of line style
7050: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
7051: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
7052: ln_fa_id OKC_K_LINES_V.ID%TYPE;
7053:
7054: CURSOR get_fa_id(p_top_line OKC_K_LINES_V.ID%TYPE,
7055: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
7056: IS

Line 7054: CURSOR get_fa_id(p_top_line OKC_K_LINES_V.ID%TYPE,

7050: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
7051: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
7052: ln_fa_id OKC_K_LINES_V.ID%TYPE;
7053:
7054: CURSOR get_fa_id(p_top_line OKC_K_LINES_V.ID%TYPE,
7055: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
7056: IS
7057: SELECT cle.id
7058: FROM okc_subclass_top_line stl,

Line 7055: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)

7051: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
7052: ln_fa_id OKC_K_LINES_V.ID%TYPE;
7053:
7054: CURSOR get_fa_id(p_top_line OKC_K_LINES_V.ID%TYPE,
7055: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
7056: IS
7057: SELECT cle.id
7058: FROM okc_subclass_top_line stl,
7059: okc_line_styles_b lse2,

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

7287: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
7288: OKL_API.set_message(p_app_name => G_APP_NAME,
7289: p_msg_name => G_FETCHING_INFO,
7290: p_token1 => G_REC_NAME_TOKEN,
7291: p_token1_value => 'OKC_K_LINES_V Record');
7292: RAISE G_EXCEPTION_HALT_VALIDATION;
7293: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
7294: OKL_API.set_message(p_app_name => G_APP_NAME,
7295: p_msg_name => G_FETCHING_INFO,

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

7293: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
7294: OKL_API.set_message(p_app_name => G_APP_NAME,
7295: p_msg_name => G_FETCHING_INFO,
7296: p_token1 => G_REC_NAME_TOKEN,
7297: p_token1_value => 'OKC_K_LINES_V Record');
7298: RAISE G_EXCEPTION_HALT_VALIDATION;
7299: END IF;
7300: -- To Get the kle top Line Record
7301: x_return_status := get_rec_klev(p_clev_rec.id,

Line 8422: ln_fa_id OKC_K_LINES_V.ID%TYPE;

8418: l_klev_rec klev_rec_type := p_klev_rec;
8419: -- Variables for validation of line style
8420: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
8421: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
8422: ln_fa_id OKC_K_LINES_V.ID%TYPE;
8423:
8424: -- Temp variables for capital reduction and tradein amount
8425: tradein_amount OKL_K_LINES.TRADEIN_AMOUNT%TYPE;
8426: capital_reduction OKL_K_LINES.CAPITAL_REDUCTION%TYPE;

Line 8428: CURSOR get_fa_id(p_top_line OKC_K_LINES_V.ID%TYPE,

8424: -- Temp variables for capital reduction and tradein amount
8425: tradein_amount OKL_K_LINES.TRADEIN_AMOUNT%TYPE;
8426: capital_reduction OKL_K_LINES.CAPITAL_REDUCTION%TYPE;
8427:
8428: CURSOR get_fa_id(p_top_line OKC_K_LINES_V.ID%TYPE,
8429: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
8430: IS
8431: -- #4414408
8432: SELECT cle.id

Line 8429: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)

8425: tradein_amount OKL_K_LINES.TRADEIN_AMOUNT%TYPE;
8426: capital_reduction OKL_K_LINES.CAPITAL_REDUCTION%TYPE;
8427:
8428: CURSOR get_fa_id(p_top_line OKC_K_LINES_V.ID%TYPE,
8429: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
8430: IS
8431: -- #4414408
8432: SELECT cle.id
8433: -- FROM okc_subclass_top_line stl,

Line 8675: CURSOR c_get_lse_id_sts(p_top_line_id OKC_K_LINES_V.ID%TYPE) IS

8671: l_clev_rec clev_rec_type := p_clev_rec;
8672: l_klev_rec klev_rec_type := p_klev_rec;
8673: lx_clev_rec clev_rec_type;
8674: lx_klev_rec klev_rec_type;
8675: CURSOR c_get_lse_id_sts(p_top_line_id OKC_K_LINES_V.ID%TYPE) IS
8676: SELECT lse.id,
8677: cle.sts_code
8678: FROM okc_subclass_top_line stl,
8679: okc_line_styles_b lse,

Line 8680: okc_k_lines_v cle

8676: SELECT lse.id,
8677: cle.sts_code
8678: FROM okc_subclass_top_line stl,
8679: okc_line_styles_b lse,
8680: okc_k_lines_v cle
8681: WHERE cle.id = p_top_line_id
8682: AND cle.lse_id = lse.id
8683: AND lse.lty_code = G_FIN_LINE_LTY_CODE
8684: AND lse.lse_parent_id is null

Line 8926: p_top_line_id IN OKC_K_LINES_V.ID%TYPE,

8922: x_msg_count OUT NOCOPY NUMBER,
8923: x_msg_data OUT NOCOPY VARCHAR2,
8924: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
8925: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
8926: p_top_line_id IN OKC_K_LINES_V.ID%TYPE,
8927: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
8928: x_fin_clev_rec OUT NOCOPY clev_rec_type,
8929: x_fin_klev_rec OUT NOCOPY klev_rec_type,
8930: x_oec OUT NOCOPY OKL_K_LINES_V.OEC%TYPE,

Line 8927: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,

8923: x_msg_data OUT NOCOPY VARCHAR2,
8924: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
8925: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
8926: p_top_line_id IN OKC_K_LINES_V.ID%TYPE,
8927: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
8928: x_fin_clev_rec OUT NOCOPY clev_rec_type,
8929: x_fin_klev_rec OUT NOCOPY klev_rec_type,
8930: x_oec OUT NOCOPY OKL_K_LINES_V.OEC%TYPE,
8931: p_validate_fin_line IN VARCHAR2 DEFAULT OKL_API.G_TRUE) IS

Line 8934: -- ln_top_line_id OKC_K_LINES_V.CLE_ID%TYPE := 0;

8930: x_oec OUT NOCOPY OKL_K_LINES_V.OEC%TYPE,
8931: p_validate_fin_line IN VARCHAR2 DEFAULT OKL_API.G_TRUE) IS
8932:
8933: ln_oec OKL_K_LINES_V.OEC%TYPE := 0;
8934: -- ln_top_line_id OKC_K_LINES_V.CLE_ID%TYPE := 0;
8935: l_update_clev_rec clev_rec_type;
8936: l_update_klev_rec klev_rec_type;
8937:
8938: -- #4414408 Top line ID is now passed to the API

Line 8941: CURSOR c_model_top_line(p_model_line_id OKC_K_LINES_V.ID%TYPE,

8937:
8938: -- #4414408 Top line ID is now passed to the API
8939: /*
8940: -- To Find out the Top line ID
8941: CURSOR c_model_top_line(p_model_line_id OKC_K_LINES_V.ID%TYPE,
8942: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
8943: SELECT cle.cle_id
8944: FROM okc_subclass_top_line stl,
8945: okc_line_styles_b lse2,

Line 8942: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

8938: -- #4414408 Top line ID is now passed to the API
8939: /*
8940: -- To Find out the Top line ID
8941: CURSOR c_model_top_line(p_model_line_id OKC_K_LINES_V.ID%TYPE,
8942: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
8943: SELECT cle.cle_id
8944: FROM okc_subclass_top_line stl,
8945: okc_line_styles_b lse2,
8946: okc_line_styles_b lse1,

Line 8948: okc_k_lines_v cle

8944: FROM okc_subclass_top_line stl,
8945: okc_line_styles_b lse2,
8946: okc_line_styles_b lse1,
8947: okc_k_items_v cim,
8948: okc_k_lines_v cle
8949: WHERE cle.id = p_model_line_id
8950: AND cle.dnz_chr_id = p_dnz_chr_id
8951: AND cle.id = cim.cle_id
8952: AND cle.dnz_chr_id = cim.dnz_chr_id

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

9017: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
9018: OKL_API.set_message(p_app_name => G_APP_NAME,
9019: p_msg_name => G_FETCHING_INFO,
9020: p_token1 => G_REC_NAME_TOKEN,
9021: p_token1_value => 'OKC_K_LINES_V Record');
9022: RAISE G_EXCEPTION_HALT_VALIDATION;
9023: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
9024: OKL_API.set_message(p_app_name => G_APP_NAME,
9025: p_msg_name => G_FETCHING_INFO,

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

9023: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
9024: OKL_API.set_message(p_app_name => G_APP_NAME,
9025: p_msg_name => G_FETCHING_INFO,
9026: p_token1 => G_REC_NAME_TOKEN,
9027: p_token1_value => 'OKC_K_LINES_V Record');
9028: RAISE G_EXCEPTION_HALT_VALIDATION;
9029: END IF;
9030: -- To Get the kle top Line Record
9031: x_return_status := get_rec_klev(p_top_line_id, -- 4414408

Line 9133: p_top_line_id IN OKC_K_LINES_V.ID%TYPE, -- 4414408

9129: x_msg_count OUT NOCOPY NUMBER,
9130: x_msg_data OUT NOCOPY VARCHAR2,
9131: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
9132: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
9133: p_top_line_id IN OKC_K_LINES_V.ID%TYPE, -- 4414408
9134: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
9135: x_fin_clev_rec OUT NOCOPY clev_rec_type,
9136: x_fin_klev_rec OUT NOCOPY klev_rec_type,
9137: x_cap_amt OUT NOCOPY OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE,

Line 9134: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,

9130: x_msg_data OUT NOCOPY VARCHAR2,
9131: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
9132: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
9133: p_top_line_id IN OKC_K_LINES_V.ID%TYPE, -- 4414408
9134: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
9135: x_fin_clev_rec OUT NOCOPY clev_rec_type,
9136: x_fin_klev_rec OUT NOCOPY klev_rec_type,
9137: x_cap_amt OUT NOCOPY OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE,
9138: p_validate_fin_line IN VARCHAR2 DEFAULT OKL_API.G_TRUE) IS

Line 9141: -- ln_top_line_id OKC_K_LINES_V.CLE_ID%TYPE := 0;

9137: x_cap_amt OUT NOCOPY OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE,
9138: p_validate_fin_line IN VARCHAR2 DEFAULT OKL_API.G_TRUE) IS
9139:
9140: ln_cap_amt OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
9141: -- ln_top_line_id OKC_K_LINES_V.CLE_ID%TYPE := 0;
9142: l_update_clev_rec clev_rec_type;
9143: l_update_klev_rec klev_rec_type;
9144: -- #4414408 Top line ID is a parameter passed to the API
9145: /*

Line 9147: CURSOR c_model_top_line(p_model_line_id OKC_K_LINES_V.ID%TYPE,

9143: l_update_klev_rec klev_rec_type;
9144: -- #4414408 Top line ID is a parameter passed to the API
9145: /*
9146: -- To Find out the Top line ID
9147: CURSOR c_model_top_line(p_model_line_id OKC_K_LINES_V.ID%TYPE,
9148: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
9149: SELECT cle.cle_id
9150: FROM okc_subclass_top_line stl,
9151: okc_line_styles_b lse2,

Line 9148: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

9144: -- #4414408 Top line ID is a parameter passed to the API
9145: /*
9146: -- To Find out the Top line ID
9147: CURSOR c_model_top_line(p_model_line_id OKC_K_LINES_V.ID%TYPE,
9148: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
9149: SELECT cle.cle_id
9150: FROM okc_subclass_top_line stl,
9151: okc_line_styles_b lse2,
9152: okc_line_styles_b lse1,

Line 9154: okc_k_lines_v cle

9150: FROM okc_subclass_top_line stl,
9151: okc_line_styles_b lse2,
9152: okc_line_styles_b lse1,
9153: okc_k_items_v cim,
9154: okc_k_lines_v cle
9155: WHERE cle.id = p_model_line_id
9156: AND cle.dnz_chr_id = p_dnz_chr_id
9157: AND cle.id = cim.cle_id
9158: AND cle.dnz_chr_id = cim.dnz_chr_id

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

9224: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
9225: OKL_API.set_message(p_app_name => G_APP_NAME,
9226: p_msg_name => G_FETCHING_INFO,
9227: p_token1 => G_REC_NAME_TOKEN,
9228: p_token1_value => 'OKC_K_LINES_V Record');
9229: RAISE G_EXCEPTION_HALT_VALIDATION;
9230: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
9231: OKL_API.set_message(p_app_name => G_APP_NAME,
9232: p_msg_name => G_FETCHING_INFO,

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

9230: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
9231: OKL_API.set_message(p_app_name => G_APP_NAME,
9232: p_msg_name => G_FETCHING_INFO,
9233: p_token1 => G_REC_NAME_TOKEN,
9234: p_token1_value => 'OKC_K_LINES_V Record');
9235: RAISE G_EXCEPTION_HALT_VALIDATION;
9236: END IF;
9237: -- To Get the kle top Line Record
9238: x_return_status := get_rec_klev(p_top_line_id, -- 4414408

Line 9338: p_top_line_id IN OKC_K_LINES_V.ID%TYPE, -- 4414408

9334: x_msg_count OUT NOCOPY NUMBER,
9335: x_msg_data OUT NOCOPY VARCHAR2,
9336: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
9337: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
9338: p_top_line_id IN OKC_K_LINES_V.ID%TYPE, -- 4414408
9339: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
9340: x_fin_clev_rec OUT NOCOPY clev_rec_type,
9341: x_fin_klev_rec OUT NOCOPY klev_rec_type,
9342: x_res_value OUT NOCOPY OKL_K_LINES_V.RESIDUAL_VALUE%TYPE,

Line 9339: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,

9335: x_msg_data OUT NOCOPY VARCHAR2,
9336: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
9337: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
9338: p_top_line_id IN OKC_K_LINES_V.ID%TYPE, -- 4414408
9339: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
9340: x_fin_clev_rec OUT NOCOPY clev_rec_type,
9341: x_fin_klev_rec OUT NOCOPY klev_rec_type,
9342: x_res_value OUT NOCOPY OKL_K_LINES_V.RESIDUAL_VALUE%TYPE,
9343: p_validate_fin_line IN VARCHAR2 DEFAULT OKL_API.G_TRUE) IS

Line 9346: -- ln_top_line_id OKC_K_LINES_V.CLE_ID%TYPE := 0;

9342: x_res_value OUT NOCOPY OKL_K_LINES_V.RESIDUAL_VALUE%TYPE,
9343: p_validate_fin_line IN VARCHAR2 DEFAULT OKL_API.G_TRUE) IS
9344:
9345: ln_res_value OKL_K_LINES_V.RESIDUAL_VALUE%TYPE := 0;
9346: -- ln_top_line_id OKC_K_LINES_V.CLE_ID%TYPE := 0;
9347: l_update_clev_rec clev_rec_type;
9348: l_update_klev_rec klev_rec_type;
9349: -- 4414408
9350: /*

Line 9352: CURSOR c_model_top_line(p_model_line_id OKC_K_LINES_V.ID%TYPE,

9348: l_update_klev_rec klev_rec_type;
9349: -- 4414408
9350: /*
9351: -- To Find out the Top line ID
9352: CURSOR c_model_top_line(p_model_line_id OKC_K_LINES_V.ID%TYPE,
9353: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
9354: SELECT cle.cle_id
9355: FROM okc_subclass_top_line stl,
9356: okc_line_styles_b lse2,

Line 9353: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

9349: -- 4414408
9350: /*
9351: -- To Find out the Top line ID
9352: CURSOR c_model_top_line(p_model_line_id OKC_K_LINES_V.ID%TYPE,
9353: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
9354: SELECT cle.cle_id
9355: FROM okc_subclass_top_line stl,
9356: okc_line_styles_b lse2,
9357: okc_line_styles_b lse1,

Line 9359: okc_k_lines_v cle

9355: FROM okc_subclass_top_line stl,
9356: okc_line_styles_b lse2,
9357: okc_line_styles_b lse1,
9358: okc_k_items_v cim,
9359: okc_k_lines_v cle
9360: WHERE cle.id = p_model_line_id
9361: AND cle.dnz_chr_id = p_dnz_chr_id
9362: AND cle.id = cim.cle_id
9363: AND cle.dnz_chr_id = cim.dnz_chr_id

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

9427: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
9428: OKL_API.set_message(p_app_name => G_APP_NAME,
9429: p_msg_name => G_FETCHING_INFO,
9430: p_token1 => G_REC_NAME_TOKEN,
9431: p_token1_value => 'OKC_K_LINES_V Record');
9432: RAISE G_EXCEPTION_HALT_VALIDATION;
9433: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
9434: OKL_API.set_message(p_app_name => G_APP_NAME,
9435: p_msg_name => G_FETCHING_INFO,

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

9433: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
9434: OKL_API.set_message(p_app_name => G_APP_NAME,
9435: p_msg_name => G_FETCHING_INFO,
9436: p_token1 => G_REC_NAME_TOKEN,
9437: p_token1_value => 'OKC_K_LINES_V Record');
9438: RAISE G_EXCEPTION_HALT_VALIDATION;
9439: END IF;
9440: -- To Get the kle top Line Record
9441: x_return_status := get_rec_klev(p_top_line_id, -- 4414408

Line 9547: p_top_line_id IN OKC_K_LINES_V.ID%TYPE,

9543: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
9544: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
9545: p_res_value IN OKL_K_LINES_V.RESIDUAL_VALUE%TYPE,
9546: p_oec IN OKL_K_LINES_V.OEC%TYPE,
9547: p_top_line_id IN OKC_K_LINES_V.ID%TYPE,
9548: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
9549: x_fin_clev_rec OUT NOCOPY clev_rec_type,
9550: x_fin_klev_rec OUT NOCOPY klev_rec_type,
9551: p_validate_fin_line IN VARCHAR2 DEFAULT OKL_API.G_TRUE) IS

Line 9548: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,

9544: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
9545: p_res_value IN OKL_K_LINES_V.RESIDUAL_VALUE%TYPE,
9546: p_oec IN OKL_K_LINES_V.OEC%TYPE,
9547: p_top_line_id IN OKC_K_LINES_V.ID%TYPE,
9548: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
9549: x_fin_clev_rec OUT NOCOPY clev_rec_type,
9550: x_fin_klev_rec OUT NOCOPY klev_rec_type,
9551: p_validate_fin_line IN VARCHAR2 DEFAULT OKL_API.G_TRUE) IS
9552:

Line 9554: ln_top_line_id OKC_K_LINES_V.CLE_ID%TYPE := 0;

9550: x_fin_klev_rec OUT NOCOPY klev_rec_type,
9551: p_validate_fin_line IN VARCHAR2 DEFAULT OKL_API.G_TRUE) IS
9552:
9553: ln_res_per OKL_K_LINES_V.RESIDUAL_PERCENTAGE%TYPE := 0;
9554: ln_top_line_id OKC_K_LINES_V.CLE_ID%TYPE := 0;
9555: l_update_clev_rec clev_rec_type;
9556: l_update_klev_rec klev_rec_type;
9557:
9558: BEGIN

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

9590: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
9591: OKL_API.set_message(p_app_name => G_APP_NAME,
9592: p_msg_name => G_FETCHING_INFO,
9593: p_token1 => G_REC_NAME_TOKEN,
9594: p_token1_value => 'OKC_K_LINES_V Record');
9595: RAISE G_EXCEPTION_HALT_VALIDATION;
9596: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
9597: OKL_API.set_message(p_app_name => G_APP_NAME,
9598: p_msg_name => G_FETCHING_INFO,

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

9596: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
9597: OKL_API.set_message(p_app_name => G_APP_NAME,
9598: p_msg_name => G_FETCHING_INFO,
9599: p_token1 => G_REC_NAME_TOKEN,
9600: p_token1_value => 'OKC_K_LINES_V Record');
9601: RAISE G_EXCEPTION_HALT_VALIDATION;
9602: END IF;
9603: -- To Get the kle top Line Record
9604: x_return_status := get_rec_klev(p_top_line_id,

Line 9856: ln_fa_id OKC_K_LINES_V.ID%TYPE;

9852: l_clev_rec clev_rec_type;
9853: -- Variables for validation of line style
9854: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
9855: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
9856: ln_fa_id OKC_K_LINES_V.ID%TYPE;
9857:
9858: CURSOR get_fa_id(p_top_line OKC_K_LINES_V.ID%TYPE,
9859: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
9860: IS

Line 9858: CURSOR get_fa_id(p_top_line OKC_K_LINES_V.ID%TYPE,

9854: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
9855: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
9856: ln_fa_id OKC_K_LINES_V.ID%TYPE;
9857:
9858: CURSOR get_fa_id(p_top_line OKC_K_LINES_V.ID%TYPE,
9859: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
9860: IS
9861: SELECT cle.id
9862: FROM okc_subclass_top_line stl,

Line 9859: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)

9855: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
9856: ln_fa_id OKC_K_LINES_V.ID%TYPE;
9857:
9858: CURSOR get_fa_id(p_top_line OKC_K_LINES_V.ID%TYPE,
9859: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
9860: IS
9861: SELECT cle.id
9862: FROM okc_subclass_top_line stl,
9863: okc_line_styles_b lse2,

Line 9865: okc_k_lines_v cle

9861: SELECT cle.id
9862: FROM okc_subclass_top_line stl,
9863: okc_line_styles_b lse2,
9864: okc_line_styles_b lse1,
9865: okc_k_lines_v cle
9866: WHERE cle.cle_id = p_top_line
9867: AND cle.dnz_chr_id = p_dnz_chr_id
9868: AND lse1.id = cle.lse_id
9869: AND lse1.lty_code = G_FA_LINE_LTY_CODE

Line 10417: ln_add_cle_id OKC_K_LINES_V.CLE_ID%TYPE := 0;

10413: l_klev_rec klev_rec_type;
10414: l_clev_tbl clev_tbl_type;
10415: x_klev_rec klev_rec_type;
10416: ln_oec OKL_K_LINES_V.OEC%TYPE := 0;
10417: ln_add_cle_id OKC_K_LINES_V.CLE_ID%TYPE := 0;
10418: ln_add_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE := 0;
10419: ln_top_line_id OKC_K_LINES_V.CLE_ID%TYPE := 0;
10420: ln_klev_fin_oec OKL_K_LINES_V.OEC%TYPE := 0;
10421: ln_klev_fin_res OKL_K_LINES_V.RESIDUAL_VALUE%TYPE := 0;

Line 10418: ln_add_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE := 0;

10414: l_clev_tbl clev_tbl_type;
10415: x_klev_rec klev_rec_type;
10416: ln_oec OKL_K_LINES_V.OEC%TYPE := 0;
10417: ln_add_cle_id OKC_K_LINES_V.CLE_ID%TYPE := 0;
10418: ln_add_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE := 0;
10419: ln_top_line_id OKC_K_LINES_V.CLE_ID%TYPE := 0;
10420: ln_klev_fin_oec OKL_K_LINES_V.OEC%TYPE := 0;
10421: ln_klev_fin_res OKL_K_LINES_V.RESIDUAL_VALUE%TYPE := 0;
10422: ln_klev_fin_cap OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;

Line 10419: ln_top_line_id OKC_K_LINES_V.CLE_ID%TYPE := 0;

10415: x_klev_rec klev_rec_type;
10416: ln_oec OKL_K_LINES_V.OEC%TYPE := 0;
10417: ln_add_cle_id OKC_K_LINES_V.CLE_ID%TYPE := 0;
10418: ln_add_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE := 0;
10419: ln_top_line_id OKC_K_LINES_V.CLE_ID%TYPE := 0;
10420: ln_klev_fin_oec OKL_K_LINES_V.OEC%TYPE := 0;
10421: ln_klev_fin_res OKL_K_LINES_V.RESIDUAL_VALUE%TYPE := 0;
10422: ln_klev_fin_cap OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
10423:

Line 10425: CURSOR c_model_top_line(p_model_line_id OKC_K_LINES_V.ID%TYPE,

10421: ln_klev_fin_res OKL_K_LINES_V.RESIDUAL_VALUE%TYPE := 0;
10422: ln_klev_fin_cap OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
10423:
10424: -- To Find out the Top line ID
10425: CURSOR c_model_top_line(p_model_line_id OKC_K_LINES_V.ID%TYPE,
10426: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
10427: -- #4414408
10428: SELECT cle.cle_id
10429: FROM okc_k_lines_b cle

Line 10426: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

10422: ln_klev_fin_cap OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
10423:
10424: -- To Find out the Top line ID
10425: CURSOR c_model_top_line(p_model_line_id OKC_K_LINES_V.ID%TYPE,
10426: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
10427: -- #4414408
10428: SELECT cle.cle_id
10429: FROM okc_k_lines_b cle
10430: WHERE cle.id = p_model_line_id

Line 10702: ln_add_cle_id OKC_K_LINES_V.CLE_ID%TYPE := 0;

10698: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_ADD_LINE';
10699: l_klev_rec klev_rec_type;
10700: l_clev_tbl clev_tbl_type;
10701: x_klev_rec klev_rec_type;
10702: ln_add_cle_id OKC_K_LINES_V.CLE_ID%TYPE := 0;
10703: ln_add_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE := 0;
10704: ln_top_line_id OKC_K_LINES_V.CLE_ID%TYPE := 0;
10705: ln_klev_fin_oec OKL_K_LINES_V.OEC%TYPE := 0;
10706: ln_klev_fin_res OKL_K_LINES_V.RESIDUAL_VALUE%TYPE := 0;

Line 10703: ln_add_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE := 0;

10699: l_klev_rec klev_rec_type;
10700: l_clev_tbl clev_tbl_type;
10701: x_klev_rec klev_rec_type;
10702: ln_add_cle_id OKC_K_LINES_V.CLE_ID%TYPE := 0;
10703: ln_add_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE := 0;
10704: ln_top_line_id OKC_K_LINES_V.CLE_ID%TYPE := 0;
10705: ln_klev_fin_oec OKL_K_LINES_V.OEC%TYPE := 0;
10706: ln_klev_fin_res OKL_K_LINES_V.RESIDUAL_VALUE%TYPE := 0;
10707: ln_klev_fin_cap OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;

Line 10704: ln_top_line_id OKC_K_LINES_V.CLE_ID%TYPE := 0;

10700: l_clev_tbl clev_tbl_type;
10701: x_klev_rec klev_rec_type;
10702: ln_add_cle_id OKC_K_LINES_V.CLE_ID%TYPE := 0;
10703: ln_add_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE := 0;
10704: ln_top_line_id OKC_K_LINES_V.CLE_ID%TYPE := 0;
10705: ln_klev_fin_oec OKL_K_LINES_V.OEC%TYPE := 0;
10706: ln_klev_fin_res OKL_K_LINES_V.RESIDUAL_VALUE%TYPE := 0;
10707: ln_klev_fin_cap OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
10708:

Line 10710: CURSOR c_model_top_line(p_model_line_id OKC_K_LINES_V.ID%TYPE,

10706: ln_klev_fin_res OKL_K_LINES_V.RESIDUAL_VALUE%TYPE := 0;
10707: ln_klev_fin_cap OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
10708:
10709: -- To Find out the Top line ID
10710: CURSOR c_model_top_line(p_model_line_id OKC_K_LINES_V.ID%TYPE,
10711: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
10712: -- #4414408
10713: SELECT cle.cle_id
10714: FROM okc_k_lines_b cle

Line 10711: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

10707: ln_klev_fin_cap OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
10708:
10709: -- To Find out the Top line ID
10710: CURSOR c_model_top_line(p_model_line_id OKC_K_LINES_V.ID%TYPE,
10711: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
10712: -- #4414408
10713: SELECT cle.cle_id
10714: FROM okc_k_lines_b cle
10715: WHERE cle.id = p_model_line_id

Line 10948: ln_add_cle_id OKC_K_LINES_V.CLE_ID%TYPE := 0;

10944:
10945: i NUMBER := 0;
10946: j NUMBER := 0;
10947: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_ADDON_LN';
10948: ln_add_cle_id OKC_K_LINES_V.CLE_ID%TYPE := 0;
10949: ln_add_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE := 0;
10950: ln_top_line_id OKC_K_LINES_V.CLE_ID%TYPE := 0;
10951: l_clev_tbl clev_tbl_type;
10952: ln_klev_fin_oec OKL_K_LINES_V.OEC%TYPE := 0;

Line 10949: ln_add_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE := 0;

10945: i NUMBER := 0;
10946: j NUMBER := 0;
10947: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_ADDON_LN';
10948: ln_add_cle_id OKC_K_LINES_V.CLE_ID%TYPE := 0;
10949: ln_add_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE := 0;
10950: ln_top_line_id OKC_K_LINES_V.CLE_ID%TYPE := 0;
10951: l_clev_tbl clev_tbl_type;
10952: ln_klev_fin_oec OKL_K_LINES_V.OEC%TYPE := 0;
10953: ln_klev_fin_res OKL_K_LINES_V.RESIDUAL_VALUE%TYPE := 0;

Line 10950: ln_top_line_id OKC_K_LINES_V.CLE_ID%TYPE := 0;

10946: j NUMBER := 0;
10947: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_ADDON_LN';
10948: ln_add_cle_id OKC_K_LINES_V.CLE_ID%TYPE := 0;
10949: ln_add_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE := 0;
10950: ln_top_line_id OKC_K_LINES_V.CLE_ID%TYPE := 0;
10951: l_clev_tbl clev_tbl_type;
10952: ln_klev_fin_oec OKL_K_LINES_V.OEC%TYPE := 0;
10953: ln_klev_fin_res OKL_K_LINES_V.RESIDUAL_VALUE%TYPE := 0;
10954: ln_klev_fin_cap OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;

Line 10957: CURSOR c_model_top_line(p_model_line_id OKC_K_LINES_V.ID%TYPE,

10953: ln_klev_fin_res OKL_K_LINES_V.RESIDUAL_VALUE%TYPE := 0;
10954: ln_klev_fin_cap OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
10955:
10956: -- To Find out the Top line ID
10957: CURSOR c_model_top_line(p_model_line_id OKC_K_LINES_V.ID%TYPE,
10958: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
10959: -- #4414408
10960: SELECT cle.cle_id
10961: FROM okc_k_lines_b cle

Line 10958: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

10954: ln_klev_fin_cap OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
10955:
10956: -- To Find out the Top line ID
10957: CURSOR c_model_top_line(p_model_line_id OKC_K_LINES_V.ID%TYPE,
10958: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
10959: -- #4414408
10960: SELECT cle.cle_id
10961: FROM okc_k_lines_b cle
10962: WHERE cle.id = p_model_line_id

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

11772: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
11773: OKL_API.set_message(p_app_name => G_APP_NAME,
11774: p_msg_name => G_FETCHING_INFO,
11775: p_token1 => G_REC_NAME_TOKEN,
11776: p_token1_value => 'OKC_K_LINES_V Record');
11777: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
11778: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
11779: OKL_API.set_message(p_app_name => G_APP_NAME,
11780: p_msg_name => G_FETCHING_INFO,

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

11778: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
11779: OKL_API.set_message(p_app_name => G_APP_NAME,
11780: p_msg_name => G_FETCHING_INFO,
11781: p_token1 => G_REC_NAME_TOKEN,
11782: p_token1_value => 'OKC_K_LINES_V Record');
11783: RAISE OKL_API.G_EXCEPTION_ERROR;
11784: END IF;
11785: x_return_status := get_rec_klev(p_id => p_cplv_rec.cle_id,
11786: x_klev_rec => l_klev_rec);

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

15058: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
15059: OKL_API.set_message(p_app_name => G_APP_NAME,
15060: p_msg_name => G_FETCHING_INFO,
15061: p_token1 => G_REC_NAME_TOKEN,
15062: p_token1_value => 'OKC_K_LINES_V Record');
15063: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
15064: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
15065: OKL_API.set_message(p_app_name => G_APP_NAME,
15066: p_msg_name => G_FETCHING_INFO,

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

15064: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
15065: OKL_API.set_message(p_app_name => G_APP_NAME,
15066: p_msg_name => G_FETCHING_INFO,
15067: p_token1 => G_REC_NAME_TOKEN,
15068: p_token1_value => 'OKC_K_LINES_V Record');
15069: RAISE Okc_Api.G_EXCEPTION_ERROR;
15070: END IF;
15071: x_return_status := get_rec_klev(l_lines_rec.id,
15072: lx_klev_rec);

Line 15202: ln_clev_model_price_unit OKC_K_LINES_V.PRICE_UNIT%TYPE := 0;

15198: l_itiv_ib_tbl_out itiv_tbl_type;
15199: ln_klev_fin_oec OKL_K_LINES_V.OEC%TYPE := 0;
15200: ln_klev_fin_res OKL_K_LINES_V.RESIDUAL_VALUE%TYPE := 0;
15201: ln_klev_fin_cap OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
15202: ln_clev_model_price_unit OKC_K_LINES_V.PRICE_UNIT%TYPE := 0;
15203: ln_cimv_model_no_items OKC_K_ITEMS_V.NUMBER_OF_ITEMS%TYPE := 0;
15204: lv_object_id1_new OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE;
15205: lv_scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE := null;
15206: ln_dummy NUMBER := 0;

Line 15239: OKC_K_HEADERS_V OKHV, OKC_K_LINES_V KLE_FA, OKC_LINE_STYLES_B LSE_FA, OKC_K_LINES_B KLE_IL,

15235: IS
15236: SELECT CII.SERIAL_NUMBER IB_SERIAL_NUMBER,
15237: CII.INSTANCE_ID
15238: FROM
15239: OKC_K_HEADERS_V OKHV, OKC_K_LINES_V KLE_FA, OKC_LINE_STYLES_B LSE_FA, OKC_K_LINES_B KLE_IL,
15240: OKC_LINE_STYLES_B LSE_IL, OKC_K_LINES_B KLE_IB, OKC_LINE_STYLES_B LSE_IB, OKC_K_ITEMS ITE,
15241: CSI_ITEM_INSTANCES CII
15242: WHERE
15243: kle_fa.chr_id = okhv.id AND lse_fa.id = kle_fa.lse_id AND lse_fa.lty_code = 'FREE_FORM1'

Line 15363: p_token1_value => 'OKC_K_LINES_V.DNZ_CHR_ID for All Lines');

15359: l_clev_fin_rec.dnz_chr_id = OKL_API.G_MISS_NUM) THEN
15360: OKL_API.set_message(p_app_name => G_APP_NAME,
15361: p_msg_name => G_REQUIRED_VALUE,
15362: p_token1 => G_COL_NAME_TOKEN,
15363: p_token1_value => 'OKC_K_LINES_V.DNZ_CHR_ID for All Lines');
15364: RAISE OKL_API.G_EXCEPTION_ERROR;
15365: END IF;
15366: --start:| 14-May-2008 cklee Bug 6405415 |
15367: IF l_klev_fin_rec.residual_percentage <> OKL_API.G_MISS_NUM and

Line 15384: p_token1_value => 'OKC_K_LINES_V.DNZ_CHR_ID');

15380: IF c_get_scs_code%NOTFOUND THEN
15381: OKL_API.set_message(p_app_name => G_APP_NAME,
15382: p_msg_name => G_NO_MATCHING_RECORD,
15383: p_token1 => G_COL_NAME_TOKEN,
15384: p_token1_value => 'OKC_K_LINES_V.DNZ_CHR_ID');
15385: RAISE G_EXCEPTION_HALT_VALIDATION;
15386: END IF;
15387: CLOSE c_get_scs_code;
15388:

Line 16331: ln_clev_model_price_unit OKC_K_LINES_V.PRICE_UNIT%TYPE := 0;

16327: ln_addon_oec OKL_K_LINES_V.OEC%TYPE := 0;
16328: ln_klev_fin_oec OKL_K_LINES_V.OEC%TYPE := 0;
16329: ln_klev_fin_res OKL_K_LINES_V.RESIDUAL_VALUE%TYPE := 0;
16330: ln_klev_fin_cap OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
16331: ln_clev_model_price_unit OKC_K_LINES_V.PRICE_UNIT%TYPE := 0;
16332: ln_cimv_model_no_items OKC_K_ITEMS_V.NUMBER_OF_ITEMS%TYPE := 0;
16333: lv_object_id1_new OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE;
16334: lv_model_object_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE;
16335: lv_model_object_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE;

Line 16363: okc_k_lines_v cleb_tl

16359: okc_k_lines_b cle_ib,
16360: okc_line_styles_b lse_inst,
16361: okc_k_lines_b cle_inst,
16362: okc_line_styles_b lse_tl,
16363: okc_k_lines_v cleb_tl
16364: where cleb_tl.name = P_asset_number
16365: and cleb_tl.dnz_chr_id = p_dnz_chr_id
16366: and cleb_tl.lse_id = lse_tl.id
16367: and lse_tl.lty_code = G_FIN_LINE_LTY_CODE

Line 16485: CURSOR c_addon_line_id(p_model_cle_id OKC_K_LINES_V.CLE_ID%TYPE,

16481: l_rel_ast_klev_ib_tbl klev_tbl_type;
16482: --End Bug# 3533936
16483:
16484: --Bug# 4161221: start
16485: CURSOR c_addon_line_id(p_model_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
16486: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
16487: SELECT cle.id
16488: FROM okc_k_lines_b cle,
16489: okc_line_styles_b lse

Line 16486: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

16482: --End Bug# 3533936
16483:
16484: --Bug# 4161221: start
16485: CURSOR c_addon_line_id(p_model_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
16486: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
16487: SELECT cle.id
16488: FROM okc_k_lines_b cle,
16489: okc_line_styles_b lse
16490: WHERE cle.dnz_chr_id = p_chr_id

Line 16636: p_token1_value => 'OKC_K_LINES_V.DNZ_CHR_ID for All Lines');

16632: l_clev_fin_rec.dnz_chr_id = OKL_API.G_MISS_NUM) THEN
16633: OKL_API.set_message(p_app_name => G_APP_NAME,
16634: p_msg_name => G_REQUIRED_VALUE,
16635: p_token1 => G_COL_NAME_TOKEN,
16636: p_token1_value => 'OKC_K_LINES_V.DNZ_CHR_ID for All Lines');
16637: RAISE OKL_API.G_EXCEPTION_ERROR;
16638: END IF;
16639:
16640:

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

16912: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
16913: OKL_API.set_message(p_app_name => G_APP_NAME,
16914: p_msg_name => G_FETCHING_INFO,
16915: p_token1 => G_REC_NAME_TOKEN,
16916: p_token1_value => 'OKC_K_LINES_V Record');
16917: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
16918: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
16919: OKL_API.set_message(p_app_name => G_APP_NAME,
16920: p_msg_name => G_FETCHING_INFO,

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

16918: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
16919: OKL_API.set_message(p_app_name => G_APP_NAME,
16920: p_msg_name => G_FETCHING_INFO,
16921: p_token1 => G_REC_NAME_TOKEN,
16922: p_token1_value => 'OKC_K_LINES_V Record');
16923: RAISE OKL_API.G_EXCEPTION_ERROR;
16924: END IF;
16925: -- To Get the kle top Line Record
16926: x_return_status := get_rec_klev(l_clev_fin_rec.id,

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

17020: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
17021: OKL_API.set_message(p_app_name => G_APP_NAME,
17022: p_msg_name => G_FETCHING_INFO,
17023: p_token1 => G_REC_NAME_TOKEN,
17024: p_token1_value => 'OKC_K_LINES_V Record');
17025: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
17026: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
17027: OKL_API.set_message(p_app_name => G_APP_NAME,
17028: p_msg_name => G_FETCHING_INFO,

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

17026: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
17027: OKL_API.set_message(p_app_name => G_APP_NAME,
17028: p_msg_name => G_FETCHING_INFO,
17029: p_token1 => G_REC_NAME_TOKEN,
17030: p_token1_value => 'OKC_K_LINES_V Record');
17031: RAISE OKL_API.G_EXCEPTION_ERROR;
17032: END IF;
17033: -- To Get the kle Model Line Record
17034: x_return_status := get_rec_klev(l_clev_model_rec.id,

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

17375: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
17376: OKL_API.set_message(p_app_name => G_APP_NAME,
17377: p_msg_name => G_FETCHING_INFO,
17378: p_token1 => G_REC_NAME_TOKEN,
17379: p_token1_value => 'OKC_K_LINES_V Record');
17380: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
17381: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
17382: OKL_API.set_message(p_app_name => G_APP_NAME,
17383: p_msg_name => G_FETCHING_INFO,

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

17381: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
17382: OKL_API.set_message(p_app_name => G_APP_NAME,
17383: p_msg_name => G_FETCHING_INFO,
17384: p_token1 => G_REC_NAME_TOKEN,
17385: p_token1_value => 'OKC_K_LINES_V Record');
17386: RAISE OKL_API.G_EXCEPTION_ERROR;
17387: END IF;
17388: -- To Get the kle fa Line Record
17389: x_return_status := get_rec_klev(l_clev_fa_rec.id,

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

17599: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
17600: OKL_API.set_message(p_app_name => G_APP_NAME,
17601: p_msg_name => G_FETCHING_INFO,
17602: p_token1 => G_REC_NAME_TOKEN,
17603: p_token1_value => 'OKC_K_LINES_V Record');
17604: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
17605: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
17606: OKL_API.set_message(p_app_name => G_APP_NAME,
17607: p_msg_name => G_FETCHING_INFO,

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

17605: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
17606: OKL_API.set_message(p_app_name => G_APP_NAME,
17607: p_msg_name => G_FETCHING_INFO,
17608: p_token1 => G_REC_NAME_TOKEN,
17609: p_token1_value => 'OKC_K_LINES_V Record');
17610: RAISE OKL_API.G_EXCEPTION_ERROR;
17611: END IF;
17612: -- To Get the kle IB Line Record
17613: x_return_status := get_rec_klev(l_clev_ib_rec.id,

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

17829: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
17830: OKL_API.set_message(p_app_name => G_APP_NAME,
17831: p_msg_name => G_FETCHING_INFO,
17832: p_token1 => G_REC_NAME_TOKEN,
17833: p_token1_value => 'OKC_K_LINES_V Record');
17834: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
17835: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
17836: OKL_API.set_message(p_app_name => G_APP_NAME,
17837: p_msg_name => G_FETCHING_INFO,

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

17835: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
17836: OKL_API.set_message(p_app_name => G_APP_NAME,
17837: p_msg_name => G_FETCHING_INFO,
17838: p_token1 => G_REC_NAME_TOKEN,
17839: p_token1_value => 'OKC_K_LINES_V Record');
17840: RAISE OKL_API.G_EXCEPTION_ERROR;
17841: END IF;
17842: -- To Get the kle IB Line Record
17843: x_return_status := get_rec_klev(l_clev_ib_rec.cle_id,

Line 18067: ln_model_line_id OKC_K_LINES_V.ID%TYPE := OKL_API.G_MISS_NUM;

18063: lb_update_oec_required BOOLEAN := FALSE;
18064: ln_item_id OKL_TXL_ITM_INSTS.INVENTORY_ITEM_ID%TYPE;
18065: -- end
18066: ln_final_current_units OKC_K_ITEMS_V.NUMBER_OF_ITEMS%TYPE;
18067: ln_model_line_id OKC_K_LINES_V.ID%TYPE := OKL_API.G_MISS_NUM;
18068: ln_fa_line_id OKC_K_LINES_V.ID%TYPE := OKL_API.G_MISS_NUM;
18069: r_clev_model_rec clev_rec_type;
18070: r_klev_model_rec klev_rec_type;
18071: r_cimv_model_rec cimv_rec_type;

Line 18068: ln_fa_line_id OKC_K_LINES_V.ID%TYPE := OKL_API.G_MISS_NUM;

18064: ln_item_id OKL_TXL_ITM_INSTS.INVENTORY_ITEM_ID%TYPE;
18065: -- end
18066: ln_final_current_units OKC_K_ITEMS_V.NUMBER_OF_ITEMS%TYPE;
18067: ln_model_line_id OKC_K_LINES_V.ID%TYPE := OKL_API.G_MISS_NUM;
18068: ln_fa_line_id OKC_K_LINES_V.ID%TYPE := OKL_API.G_MISS_NUM;
18069: r_clev_model_rec clev_rec_type;
18070: r_klev_model_rec klev_rec_type;
18071: r_cimv_model_rec cimv_rec_type;
18072: r_clev_addon_rec clev_rec_type;

Line 18091: CURSOR c_remain_inst_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,

18087: ln_klev_fin_oec OKL_K_LINES_V.OEC%TYPE := 0;
18088: ln_klev_fin_res OKL_K_LINES_V.RESIDUAL_VALUE%TYPE := 0;
18089: ln_klev_fin_cap OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
18090:
18091: CURSOR c_remain_inst_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
18092: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18093: SELECT count(cle.id)
18094: FROM okc_subclass_top_line stl,
18095: okc_line_styles_b lse2,

Line 18092: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

18088: ln_klev_fin_res OKL_K_LINES_V.RESIDUAL_VALUE%TYPE := 0;
18089: ln_klev_fin_cap OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
18090:
18091: CURSOR c_remain_inst_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
18092: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18093: SELECT count(cle.id)
18094: FROM okc_subclass_top_line stl,
18095: okc_line_styles_b lse2,
18096: okc_line_styles_b lse1,

Line 18097: okc_k_lines_v cle

18093: SELECT count(cle.id)
18094: FROM okc_subclass_top_line stl,
18095: okc_line_styles_b lse2,
18096: okc_line_styles_b lse1,
18097: okc_k_lines_v cle
18098: WHERE cle.cle_id = p_cle_id
18099: AND cle.dnz_chr_id = p_chr_id
18100: AND cle.lse_id = lse1.id
18101: AND lse1.lty_code = G_INST_LINE_LTY_CODE

Line 18107: CURSOR c_model_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,

18103: AND lse2.lty_code = G_FIN_LINE_LTY_CODE
18104: AND lse2.id = stl.lse_id
18105: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE);
18106:
18107: CURSOR c_model_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
18108: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18109: SELECT cle.id
18110: FROM okc_subclass_top_line stl,
18111: okc_line_styles_b lse2,

Line 18108: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

18104: AND lse2.id = stl.lse_id
18105: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE);
18106:
18107: CURSOR c_model_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
18108: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18109: SELECT cle.id
18110: FROM okc_subclass_top_line stl,
18111: okc_line_styles_b lse2,
18112: okc_line_styles_b lse1,

Line 18113: okc_k_lines_v cle

18109: SELECT cle.id
18110: FROM okc_subclass_top_line stl,
18111: okc_line_styles_b lse2,
18112: okc_line_styles_b lse1,
18113: okc_k_lines_v cle
18114: WHERE cle.cle_id = p_cle_id
18115: AND cle.dnz_chr_id = p_chr_id
18116: AND cle.lse_id = lse1.id
18117: AND lse1.lty_code = G_MODEL_LINE_LTY_CODE

Line 18123: CURSOR c_fa_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,

18119: AND lse2.lty_code = G_FIN_LINE_LTY_CODE
18120: AND lse2.id = stl.lse_id
18121: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE);
18122:
18123: CURSOR c_fa_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
18124: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18125: SELECT cle.id
18126: FROM okc_subclass_top_line stl,
18127: okc_line_styles_b lse2,

Line 18124: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

18120: AND lse2.id = stl.lse_id
18121: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE);
18122:
18123: CURSOR c_fa_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
18124: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18125: SELECT cle.id
18126: FROM okc_subclass_top_line stl,
18127: okc_line_styles_b lse2,
18128: okc_line_styles_b lse1,

Line 18129: okc_k_lines_v cle

18125: SELECT cle.id
18126: FROM okc_subclass_top_line stl,
18127: okc_line_styles_b lse2,
18128: okc_line_styles_b lse1,
18129: okc_k_lines_v cle
18130: WHERE cle.cle_id = p_cle_id
18131: AND cle.dnz_chr_id = p_chr_id
18132: AND cle.lse_id = lse1.id
18133: AND lse1.lty_code = G_FA_LINE_LTY_CODE

Line 18139: CURSOR c_addon_line_id(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,

18135: AND lse2.lty_code = G_FIN_LINE_LTY_CODE
18136: AND lse2.id = stl.lse_id
18137: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE);
18138:
18139: CURSOR c_addon_line_id(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
18140: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18141: SELECT cle.id
18142: FROM okc_subclass_top_line stl,
18143: okc_line_styles_b lse3,

Line 18140: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

18136: AND lse2.id = stl.lse_id
18137: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE);
18138:
18139: CURSOR c_addon_line_id(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
18140: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18141: SELECT cle.id
18142: FROM okc_subclass_top_line stl,
18143: okc_line_styles_b lse3,
18144: okc_line_styles_b lse2,

Line 18170: CURSOR c_model_item(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,

18166: AND lse2.lty_code = G_FIN_LINE_LTY_CODE
18167: AND lse2.id = stl.lse_id
18168: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE));
18169:
18170: CURSOR c_model_item(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
18171: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18172: SELECT cim.number_of_items
18173: FROM okc_subclass_top_line stl,
18174: okc_line_styles_b lse2,

Line 18171: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

18167: AND lse2.id = stl.lse_id
18168: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE));
18169:
18170: CURSOR c_model_item(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
18171: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18172: SELECT cim.number_of_items
18173: FROM okc_subclass_top_line stl,
18174: okc_line_styles_b lse2,
18175: okc_line_styles_b lse1,

Line 18177: okc_k_lines_v cle

18173: FROM okc_subclass_top_line stl,
18174: okc_line_styles_b lse2,
18175: okc_line_styles_b lse1,
18176: okc_k_items_v cim,
18177: okc_k_lines_v cle
18178: WHERE cle.cle_id = p_cle_id
18179: AND cle.dnz_chr_id = p_chr_id
18180: AND cle.id = cim.cle_id
18181: AND cim.dnz_chr_id = cle.dnz_chr_id

Line 18201: CURSOR l_chk_rel_ast_csr (p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE

18197: WHERE rul.dnz_chr_id = p_chr_id
18198: AND rul.rule_information_category = 'LARLES'
18199: AND NVL(rule_information1,'N') = 'Y';*/
18200:
18201: CURSOR l_chk_rel_ast_csr (p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE
18202: ,p_asset_num IN OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
18203: SELECT NVL(kle_top.re_lease_yn,'N') release_flag
18204: FROM okl_txl_assets_b txlb,
18205: okc_line_styles_b lseb,

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

18255: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
18256: OKL_API.set_message(p_app_name => G_APP_NAME,
18257: p_msg_name => G_FETCHING_INFO,
18258: p_token1 => G_REC_NAME_TOKEN,
18259: p_token1_value => 'OKC_K_LINES_V Record');
18260: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
18261: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
18262: OKL_API.set_message(p_app_name => G_APP_NAME,
18263: p_msg_name => G_FETCHING_INFO,

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

18261: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
18262: OKL_API.set_message(p_app_name => G_APP_NAME,
18263: p_msg_name => G_FETCHING_INFO,
18264: p_token1 => G_REC_NAME_TOKEN,
18265: p_token1_value => 'OKC_K_LINES_V Record');
18266: RAISE OKL_API.G_EXCEPTION_ERROR;
18267: END IF;
18268: -- Now getting the inst line
18269: x_return_status := get_rec_clev(l_clev_ib_rec.cle_id,

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

18271: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
18272: OKL_API.set_message(p_app_name => G_APP_NAME,
18273: p_msg_name => G_FETCHING_INFO,
18274: p_token1 => G_REC_NAME_TOKEN,
18275: p_token1_value => 'OKC_K_LINES_V Record');
18276: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
18277: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
18278: OKL_API.set_message(p_app_name => G_APP_NAME,
18279: p_msg_name => G_FETCHING_INFO,

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

18277: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
18278: OKL_API.set_message(p_app_name => G_APP_NAME,
18279: p_msg_name => G_FETCHING_INFO,
18280: p_token1 => G_REC_NAME_TOKEN,
18281: p_token1_value => 'OKC_K_LINES_V Record');
18282: RAISE OKL_API.G_EXCEPTION_ERROR;
18283: END IF;
18284:
18285: -- Since a record is already created in TXL_ITM_INSTS, we need to update this

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

18296: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
18297: OKL_API.set_message(p_app_name => G_APP_NAME,
18298: p_msg_name => G_FETCHING_INFO,
18299: p_token1 => G_REC_NAME_TOKEN,
18300: p_token1_value => 'OKC_K_LINES_V Record');
18301: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
18302: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
18303: OKL_API.set_message(p_app_name => G_APP_NAME,
18304: p_msg_name => G_FETCHING_INFO,

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

18302: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
18303: OKL_API.set_message(p_app_name => G_APP_NAME,
18304: p_msg_name => G_FETCHING_INFO,
18305: p_token1 => G_REC_NAME_TOKEN,
18306: p_token1_value => 'OKC_K_LINES_V Record');
18307: RAISE OKL_API.G_EXCEPTION_ERROR;
18308: END IF;
18309: -- checking for mfg_serial_number_yn flag
18310: k := l_itiv_ib_tbl.FIRST;

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

18648: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
18649: OKL_API.set_message(p_app_name => G_APP_NAME,
18650: p_msg_name => G_FETCHING_INFO,
18651: p_token1 => G_REC_NAME_TOKEN,
18652: p_token1_value => 'OKC_K_LINES_V Record');
18653: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
18654: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
18655: OKL_API.set_message(p_app_name => G_APP_NAME,
18656: p_msg_name => G_FETCHING_INFO,

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

18654: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
18655: OKL_API.set_message(p_app_name => G_APP_NAME,
18656: p_msg_name => G_FETCHING_INFO,
18657: p_token1 => G_REC_NAME_TOKEN,
18658: p_token1_value => 'OKC_K_LINES_V Record');
18659: RAISE OKL_API.G_EXCEPTION_ERROR;
18660: END IF;
18661:
18662: -- To Get the kle Model Line Record

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

18734: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
18735: OKL_API.set_message(p_app_name => G_APP_NAME,
18736: p_msg_name => G_FETCHING_INFO,
18737: p_token1 => G_REC_NAME_TOKEN,
18738: p_token1_value => 'OKC_K_LINES_V Record');
18739: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
18740: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
18741: OKL_API.set_message(p_app_name => G_APP_NAME,
18742: p_msg_name => G_FETCHING_INFO,

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

18740: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
18741: OKL_API.set_message(p_app_name => G_APP_NAME,
18742: p_msg_name => G_FETCHING_INFO,
18743: p_token1 => G_REC_NAME_TOKEN,
18744: p_token1_value => 'OKC_K_LINES_V Record');
18745: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
18746: END IF;
18747: -- To Get the kle Model Line Record
18748: x_return_status := get_rec_klev(r_addon_line_id.id,

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

18881: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
18882: OKL_API.set_message(p_app_name => G_APP_NAME,
18883: p_msg_name => G_FETCHING_INFO,
18884: p_token1 => G_REC_NAME_TOKEN,
18885: p_token1_value => 'OKC_K_LINES_V Record');
18886: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
18887: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
18888: OKL_API.set_message(p_app_name => G_APP_NAME,
18889: p_msg_name => G_FETCHING_INFO,

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

18887: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
18888: OKL_API.set_message(p_app_name => G_APP_NAME,
18889: p_msg_name => G_FETCHING_INFO,
18890: p_token1 => G_REC_NAME_TOKEN,
18891: p_token1_value => 'OKC_K_LINES_V Record');
18892: RAISE OKL_API.G_EXCEPTION_ERROR;
18893: END IF;
18894:
18895: -- To Get the kle fa Line Record

Line 19085: p_top_line_id IN OKC_K_LINES_V.ID%TYPE,

19081: x_msg_count OUT NOCOPY NUMBER,
19082: x_msg_data OUT NOCOPY VARCHAR2,
19083: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
19084: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
19085: p_top_line_id IN OKC_K_LINES_V.ID%TYPE,
19086: p_dnz_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
19087: p_itiv_ib_tbl IN itiv_tbl_type,
19088: x_clev_ib_tbl OUT NOCOPY clev_tbl_type,
19089: x_itiv_ib_tbl OUT NOCOPY itiv_tbl_type) IS

Line 19105: ln_model_line_id OKC_K_LINES_V.ID%TYPE := OKL_API.G_MISS_NUM;

19101: l_klev_ib_rec_out klev_rec_type;
19102: l_cimv_ib_rec_out cimv_rec_type;
19103: l_trxv_ib_rec_out trxv_rec_type;
19104: ln_remain_inst NUMBER := 0;
19105: ln_model_line_id OKC_K_LINES_V.ID%TYPE := OKL_API.G_MISS_NUM;
19106: lv_object_id1_new OKL_TXL_ITM_INSTS.OBJECT_ID1_NEW%TYPE := OKL_API.G_MISS_CHAR;
19107: ln_fa_line_id OKC_K_LINES_V.ID%TYPE := OKL_API.G_MISS_NUM;
19108: r_clev_model_rec clev_rec_type;
19109: r_klev_model_rec klev_rec_type;

Line 19107: ln_fa_line_id OKC_K_LINES_V.ID%TYPE := OKL_API.G_MISS_NUM;

19103: l_trxv_ib_rec_out trxv_rec_type;
19104: ln_remain_inst NUMBER := 0;
19105: ln_model_line_id OKC_K_LINES_V.ID%TYPE := OKL_API.G_MISS_NUM;
19106: lv_object_id1_new OKL_TXL_ITM_INSTS.OBJECT_ID1_NEW%TYPE := OKL_API.G_MISS_CHAR;
19107: ln_fa_line_id OKC_K_LINES_V.ID%TYPE := OKL_API.G_MISS_NUM;
19108: r_clev_model_rec clev_rec_type;
19109: r_klev_model_rec klev_rec_type;
19110: r_cimv_model_rec cimv_rec_type;
19111: r_clev_fa_rec clev_rec_type;

Line 19135: CURSOR c_remain_inst_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,

19131: rx_klev_addon_rec klev_rec_type;
19132: rx_cimv_addon_rec cimv_rec_type;
19133: ln_model_item OKL_TXL_ITM_INSTS.INVENTORY_ITEM_ID%TYPE;
19134:
19135: CURSOR c_remain_inst_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
19136: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
19137: SELECT count(cle.id)
19138: FROM okc_subclass_top_line stl,
19139: okc_line_styles_b lse2,

Line 19136: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

19132: rx_cimv_addon_rec cimv_rec_type;
19133: ln_model_item OKL_TXL_ITM_INSTS.INVENTORY_ITEM_ID%TYPE;
19134:
19135: CURSOR c_remain_inst_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
19136: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
19137: SELECT count(cle.id)
19138: FROM okc_subclass_top_line stl,
19139: okc_line_styles_b lse2,
19140: okc_line_styles_b lse1,

Line 19141: okc_k_lines_v cle

19137: SELECT count(cle.id)
19138: FROM okc_subclass_top_line stl,
19139: okc_line_styles_b lse2,
19140: okc_line_styles_b lse1,
19141: okc_k_lines_v cle
19142: WHERE cle.cle_id = p_cle_id
19143: AND cle.dnz_chr_id = p_chr_id
19144: AND cle.lse_id = lse1.id
19145: AND lse1.lty_code = G_INST_LINE_LTY_CODE

Line 19151: CURSOR c_model_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,

19147: AND lse2.lty_code = G_FIN_LINE_LTY_CODE
19148: AND lse2.id = stl.lse_id
19149: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE);
19150:
19151: CURSOR c_model_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
19152: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
19153: SELECT cle.id
19154: FROM okc_subclass_top_line stl,
19155: okc_line_styles_b lse2,

Line 19152: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

19148: AND lse2.id = stl.lse_id
19149: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE);
19150:
19151: CURSOR c_model_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
19152: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
19153: SELECT cle.id
19154: FROM okc_subclass_top_line stl,
19155: okc_line_styles_b lse2,
19156: okc_line_styles_b lse1,

Line 19157: okc_k_lines_v cle

19153: SELECT cle.id
19154: FROM okc_subclass_top_line stl,
19155: okc_line_styles_b lse2,
19156: okc_line_styles_b lse1,
19157: okc_k_lines_v cle
19158: WHERE cle.cle_id = p_cle_id
19159: AND cle.dnz_chr_id = p_chr_id
19160: AND cle.lse_id = lse1.id
19161: AND lse1.lty_code = G_MODEL_LINE_LTY_CODE

Line 19167: CURSOR c_model_item(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,

19163: AND lse2.lty_code = G_FIN_LINE_LTY_CODE
19164: AND lse2.id = stl.lse_id
19165: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE);
19166:
19167: CURSOR c_model_item(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
19168: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
19169: SELECT cim.object1_id1
19170: FROM okc_subclass_top_line stl,
19171: okc_line_styles_b lse2,

Line 19168: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

19164: AND lse2.id = stl.lse_id
19165: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE);
19166:
19167: CURSOR c_model_item(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
19168: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
19169: SELECT cim.object1_id1
19170: FROM okc_subclass_top_line stl,
19171: okc_line_styles_b lse2,
19172: okc_line_styles_b lse1,

Line 19174: okc_k_lines_v cle

19170: FROM okc_subclass_top_line stl,
19171: okc_line_styles_b lse2,
19172: okc_line_styles_b lse1,
19173: okc_k_items cim,
19174: okc_k_lines_v cle
19175: WHERE cle.cle_id = p_cle_id
19176: AND cle.dnz_chr_id = p_chr_id
19177: AND cle.lse_id = lse1.id
19178: AND lse1.lty_code = G_MODEL_LINE_LTY_CODE

Line 19187: CURSOR c_fa_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,

19183: AND cle.id = cim.cle_id
19184: AND cim.dnz_chr_id = cle.dnz_chr_id
19185: AND cim.jtot_object1_code = 'OKX_SYSITEM';
19186:
19187: CURSOR c_fa_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
19188: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
19189: SELECT cle.id
19190: FROM okc_subclass_top_line stl,
19191: okc_line_styles_b lse2,

Line 19188: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

19184: AND cim.dnz_chr_id = cle.dnz_chr_id
19185: AND cim.jtot_object1_code = 'OKX_SYSITEM';
19186:
19187: CURSOR c_fa_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
19188: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
19189: SELECT cle.id
19190: FROM okc_subclass_top_line stl,
19191: okc_line_styles_b lse2,
19192: okc_line_styles_b lse1,

Line 19193: okc_k_lines_v cle

19189: SELECT cle.id
19190: FROM okc_subclass_top_line stl,
19191: okc_line_styles_b lse2,
19192: okc_line_styles_b lse1,
19193: okc_k_lines_v cle
19194: WHERE cle.cle_id = p_cle_id
19195: AND cle.dnz_chr_id = p_chr_id
19196: AND cle.lse_id = lse1.id
19197: AND lse1.lty_code = G_FA_LINE_LTY_CODE

Line 19203: CURSOR c_addon_line_id(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,

19199: AND lse2.lty_code = G_FIN_LINE_LTY_CODE
19200: AND lse2.id = stl.lse_id
19201: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE);
19202:
19203: CURSOR c_addon_line_id(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
19204: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
19205: SELECT cle.id
19206: FROM okc_subclass_top_line stl,
19207: okc_line_styles_b lse3,

Line 19204: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

19200: AND lse2.id = stl.lse_id
19201: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE);
19202:
19203: CURSOR c_addon_line_id(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
19204: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
19205: SELECT cle.id
19206: FROM okc_subclass_top_line stl,
19207: okc_line_styles_b lse3,
19208: okc_line_styles_b lse2,

Line 19245: CURSOR l_chk_rel_ast_csr (p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE

19241: WHERE rul.dnz_chr_id = p_chr_id
19242: AND rul.rule_information_category = 'LARLES'
19243: AND NVL(rule_information1,'N') = 'Y';*/
19244:
19245: CURSOR l_chk_rel_ast_csr (p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE
19246: ,p_asset_num IN OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
19247: SELECT NVL(kle_top.re_lease_yn,'N') release_flag
19248: FROM okl_txl_assets_b txlb,
19249: okc_line_styles_b lseb,

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

19567: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
19568: OKL_API.set_message(p_app_name => G_APP_NAME,
19569: p_msg_name => G_FETCHING_INFO,
19570: p_token1 => G_REC_NAME_TOKEN,
19571: p_token1_value => 'OKC_K_LINES_V Record');
19572: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
19573: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
19574: OKL_API.set_message(p_app_name => G_APP_NAME,
19575: p_msg_name => G_FETCHING_INFO,

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

19573: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
19574: OKL_API.set_message(p_app_name => G_APP_NAME,
19575: p_msg_name => G_FETCHING_INFO,
19576: p_token1 => G_REC_NAME_TOKEN,
19577: p_token1_value => 'OKC_K_LINES_V Record');
19578: RAISE OKL_API.G_EXCEPTION_ERROR;
19579: END IF;
19580: -- To Get the kle Model Line Record
19581: x_return_status := get_rec_klev(ln_model_line_id,

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

19648: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
19649: OKL_API.set_message(p_app_name => G_APP_NAME,
19650: p_msg_name => G_FETCHING_INFO,
19651: p_token1 => G_REC_NAME_TOKEN,
19652: p_token1_value => 'OKC_K_LINES_V Record');
19653: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
19654: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
19655: OKL_API.set_message(p_app_name => G_APP_NAME,
19656: p_msg_name => G_FETCHING_INFO,

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

19654: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
19655: OKL_API.set_message(p_app_name => G_APP_NAME,
19656: p_msg_name => G_FETCHING_INFO,
19657: p_token1 => G_REC_NAME_TOKEN,
19658: p_token1_value => 'OKC_K_LINES_V Record');
19659: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
19660: END IF;
19661: -- To Get the kle Model Line Record
19662: x_return_status := get_rec_klev(r_addon_line_id.id,

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

19791: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
19792: OKL_API.set_message(p_app_name => G_APP_NAME,
19793: p_msg_name => G_FETCHING_INFO,
19794: p_token1 => G_REC_NAME_TOKEN,
19795: p_token1_value => 'OKC_K_LINES_V Record');
19796: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
19797: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
19798: OKL_API.set_message(p_app_name => G_APP_NAME,
19799: p_msg_name => G_FETCHING_INFO,

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

19797: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
19798: OKL_API.set_message(p_app_name => G_APP_NAME,
19799: p_msg_name => G_FETCHING_INFO,
19800: p_token1 => G_REC_NAME_TOKEN,
19801: p_token1_value => 'OKC_K_LINES_V Record');
19802: RAISE OKL_API.G_EXCEPTION_ERROR;
19803: END IF;
19804: -- To Get the kle fa Line Record
19805: x_return_status := get_rec_klev(ln_fa_line_id,

Line 20034: ln_model_line_id OKC_K_LINES_V.ID%TYPE := OKL_API.G_MISS_NUM;

20030: l_clev_ib_tbl clev_tbl_type := p_clev_ib_tbl;
20031: l_clev_ib_rec clev_rec_type;
20032: l_clev_inst_rec clev_rec_type;
20033: ln_remain_inst NUMBER := 0;
20034: ln_model_line_id OKC_K_LINES_V.ID%TYPE := OKL_API.G_MISS_NUM;
20035: ln_fa_line_id OKC_K_LINES_V.ID%TYPE := OKL_API.G_MISS_NUM;
20036: r_clev_model_rec clev_rec_type;
20037: r_klev_model_rec klev_rec_type;
20038: r_cimv_model_rec cimv_rec_type;

Line 20035: ln_fa_line_id OKC_K_LINES_V.ID%TYPE := OKL_API.G_MISS_NUM;

20031: l_clev_ib_rec clev_rec_type;
20032: l_clev_inst_rec clev_rec_type;
20033: ln_remain_inst NUMBER := 0;
20034: ln_model_line_id OKC_K_LINES_V.ID%TYPE := OKL_API.G_MISS_NUM;
20035: ln_fa_line_id OKC_K_LINES_V.ID%TYPE := OKL_API.G_MISS_NUM;
20036: r_clev_model_rec clev_rec_type;
20037: r_klev_model_rec klev_rec_type;
20038: r_cimv_model_rec cimv_rec_type;
20039: r_clev_fa_rec clev_rec_type;

Line 20064: CURSOR c_remain_inst_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,

20060: l_itiv_rec itiv_rec_type;
20061: lx_itiv_rec itiv_rec_type;
20062: -- end
20063:
20064: CURSOR c_remain_inst_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
20065: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
20066: SELECT count(cle.id)
20067: FROM okc_line_styles_b lse2,
20068: okc_line_styles_b lse1,

Line 20065: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

20061: lx_itiv_rec itiv_rec_type;
20062: -- end
20063:
20064: CURSOR c_remain_inst_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
20065: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
20066: SELECT count(cle.id)
20067: FROM okc_line_styles_b lse2,
20068: okc_line_styles_b lse1,
20069: okc_k_lines_v cle

Line 20069: okc_k_lines_v cle

20065: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
20066: SELECT count(cle.id)
20067: FROM okc_line_styles_b lse2,
20068: okc_line_styles_b lse1,
20069: okc_k_lines_v cle
20070: WHERE cle.cle_id = p_cle_id
20071: AND cle.dnz_chr_id = p_chr_id
20072: AND cle.lse_id = lse1.id
20073: AND lse1.lty_code = G_INST_LINE_LTY_CODE

Line 20077: CURSOR c_model_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,

20073: AND lse1.lty_code = G_INST_LINE_LTY_CODE
20074: AND lse1.lse_parent_id = lse2.id
20075: AND lse2.lty_code = G_FIN_LINE_LTY_CODE;
20076:
20077: CURSOR c_model_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
20078: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
20079: SELECT cle.id
20080: FROM okc_subclass_top_line stl,
20081: okc_line_styles_b lse2,

Line 20078: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

20074: AND lse1.lse_parent_id = lse2.id
20075: AND lse2.lty_code = G_FIN_LINE_LTY_CODE;
20076:
20077: CURSOR c_model_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
20078: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
20079: SELECT cle.id
20080: FROM okc_subclass_top_line stl,
20081: okc_line_styles_b lse2,
20082: okc_line_styles_b lse1,

Line 20083: okc_k_lines_v cle

20079: SELECT cle.id
20080: FROM okc_subclass_top_line stl,
20081: okc_line_styles_b lse2,
20082: okc_line_styles_b lse1,
20083: okc_k_lines_v cle
20084: WHERE cle.cle_id = p_cle_id
20085: AND cle.dnz_chr_id = p_chr_id
20086: AND cle.lse_id = lse1.id
20087: AND lse1.lty_code = G_MODEL_LINE_LTY_CODE

Line 20093: CURSOR c_fa_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,

20089: AND lse2.lty_code = G_FIN_LINE_LTY_CODE
20090: AND lse2.id = stl.lse_id
20091: AND stl.scs_code = 'LEASE';
20092:
20093: CURSOR c_fa_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
20094: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
20095: SELECT cle.id
20096: FROM okc_subclass_top_line stl,
20097: okc_line_styles_b lse2,

Line 20094: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

20090: AND lse2.id = stl.lse_id
20091: AND stl.scs_code = 'LEASE';
20092:
20093: CURSOR c_fa_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
20094: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
20095: SELECT cle.id
20096: FROM okc_subclass_top_line stl,
20097: okc_line_styles_b lse2,
20098: okc_line_styles_b lse1,

Line 20099: okc_k_lines_v cle

20095: SELECT cle.id
20096: FROM okc_subclass_top_line stl,
20097: okc_line_styles_b lse2,
20098: okc_line_styles_b lse1,
20099: okc_k_lines_v cle
20100: WHERE cle.cle_id = p_cle_id
20101: AND cle.dnz_chr_id = p_chr_id
20102: AND cle.lse_id = lse1.id
20103: AND lse1.lty_code = G_FA_LINE_LTY_CODE

Line 20109: CURSOR c_addon_line_id(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,

20105: AND lse2.lty_code = G_FIN_LINE_LTY_CODE
20106: AND lse2.id = stl.lse_id
20107: AND stl.scs_code = 'LEASE';
20108:
20109: CURSOR c_addon_line_id(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
20110: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
20111: SELECT cle.id
20112: FROM okc_subclass_top_line stl,
20113: okc_line_styles_b lse3,

Line 20110: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

20106: AND lse2.id = stl.lse_id
20107: AND stl.scs_code = 'LEASE';
20108:
20109: CURSOR c_addon_line_id(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
20110: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
20111: SELECT cle.id
20112: FROM okc_subclass_top_line stl,
20113: okc_line_styles_b lse3,
20114: okc_line_styles_b lse2,

Line 20151: CURSOR l_chk_rel_ast_csr (p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE

20147: WHERE rul.dnz_chr_id = p_chr_id
20148: AND rul.rule_information_category = 'LARLES'
20149: AND NVL(rule_information1,'N') = 'Y';
20150: */
20151: CURSOR l_chk_rel_ast_csr (p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE
20152: ,p_asset_number IN OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
20153: SELECT NVL(kle_top.re_lease_yn,'N') release_flag
20154: FROM okl_txl_assets_b txlb,
20155: okc_line_styles_b lseb,

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

20217: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
20218: OKL_API.set_message(p_app_name => G_APP_NAME,
20219: p_msg_name => G_FETCHING_INFO,
20220: p_token1 => G_REC_NAME_TOKEN,
20221: p_token1_value => 'OKC_K_LINES_V Record');
20222: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
20223: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
20224: OKL_API.set_message(p_app_name => G_APP_NAME,
20225: p_msg_name => G_FETCHING_INFO,

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

20223: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
20224: OKL_API.set_message(p_app_name => G_APP_NAME,
20225: p_msg_name => G_FETCHING_INFO,
20226: p_token1 => G_REC_NAME_TOKEN,
20227: p_token1_value => 'OKC_K_LINES_V Record');
20228: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
20229: END IF;
20230: x_return_status := get_rec_clev(l_clev_ib_rec.cle_id,
20231: l_clev_inst_rec);

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

20232: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
20233: OKL_API.set_message(p_app_name => G_APP_NAME,
20234: p_msg_name => G_FETCHING_INFO,
20235: p_token1 => G_REC_NAME_TOKEN,
20236: p_token1_value => 'OKC_K_LINES_V Record');
20237: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
20238: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
20239: OKL_API.set_message(p_app_name => G_APP_NAME,
20240: p_msg_name => G_FETCHING_INFO,

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

20238: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
20239: OKL_API.set_message(p_app_name => G_APP_NAME,
20240: p_msg_name => G_FETCHING_INFO,
20241: p_token1 => G_REC_NAME_TOKEN,
20242: p_token1_value => 'OKC_K_LINES_V Record');
20243: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
20244: END IF;
20245:
20246: -- we should get the remaining inst line , so that we can update

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

20264: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
20265: OKL_API.set_message(p_app_name => G_APP_NAME,
20266: p_msg_name => G_FETCHING_INFO,
20267: p_token1 => G_REC_NAME_TOKEN,
20268: p_token1_value => 'OKC_K_LINES_V Record');
20269: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
20270: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
20271: OKL_API.set_message(p_app_name => G_APP_NAME,
20272: p_msg_name => G_FETCHING_INFO,

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

20270: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
20271: OKL_API.set_message(p_app_name => G_APP_NAME,
20272: p_msg_name => G_FETCHING_INFO,
20273: p_token1 => G_REC_NAME_TOKEN,
20274: p_token1_value => 'OKC_K_LINES_V Record');
20275: RAISE OKL_API.G_EXCEPTION_ERROR;
20276: END IF;
20277:
20278: l_itiv_rec.mfg_serial_number_yn := 'N';

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

20404: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
20405: OKL_API.set_message(p_app_name => G_APP_NAME,
20406: p_msg_name => G_FETCHING_INFO,
20407: p_token1 => G_REC_NAME_TOKEN,
20408: p_token1_value => 'OKC_K_LINES_V Record');
20409: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
20410: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
20411: OKL_API.set_message(p_app_name => G_APP_NAME,
20412: p_msg_name => G_FETCHING_INFO,

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

20410: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
20411: OKL_API.set_message(p_app_name => G_APP_NAME,
20412: p_msg_name => G_FETCHING_INFO,
20413: p_token1 => G_REC_NAME_TOKEN,
20414: p_token1_value => 'OKC_K_LINES_V Record');
20415: RAISE OKL_API.G_EXCEPTION_ERROR;
20416: END IF;
20417: -- To Get the kle Model Line Record
20418: x_return_status := get_rec_klev(ln_model_line_id,

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

20485: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
20486: OKL_API.set_message(p_app_name => G_APP_NAME,
20487: p_msg_name => G_FETCHING_INFO,
20488: p_token1 => G_REC_NAME_TOKEN,
20489: p_token1_value => 'OKC_K_LINES_V Record');
20490: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
20491: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
20492: OKL_API.set_message(p_app_name => G_APP_NAME,
20493: p_msg_name => G_FETCHING_INFO,

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

20491: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
20492: OKL_API.set_message(p_app_name => G_APP_NAME,
20493: p_msg_name => G_FETCHING_INFO,
20494: p_token1 => G_REC_NAME_TOKEN,
20495: p_token1_value => 'OKC_K_LINES_V Record');
20496: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
20497: END IF;
20498: -- To Get the kle Model Line Record
20499: x_return_status := get_rec_klev(r_addon_line_id.id,

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

20628: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
20629: OKL_API.set_message(p_app_name => G_APP_NAME,
20630: p_msg_name => G_FETCHING_INFO,
20631: p_token1 => G_REC_NAME_TOKEN,
20632: p_token1_value => 'OKC_K_LINES_V Record');
20633: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
20634: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
20635: OKL_API.set_message(p_app_name => G_APP_NAME,
20636: p_msg_name => G_FETCHING_INFO,

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

20634: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
20635: OKL_API.set_message(p_app_name => G_APP_NAME,
20636: p_msg_name => G_FETCHING_INFO,
20637: p_token1 => G_REC_NAME_TOKEN,
20638: p_token1_value => 'OKC_K_LINES_V Record');
20639: RAISE OKL_API.G_EXCEPTION_ERROR;
20640: END IF;
20641: -- To Get the kle fa Line Record
20642: x_return_status := get_rec_klev(ln_fa_line_id,