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 2848: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

2844: -- Version : 1.0
2845: -- End of Commnets
2846: PROCEDURE validate_new_asset_number(x_return_status OUT NOCOPY VARCHAR2,
2847: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
2848: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
2849: ln_okl_txl_assets_v NUMBER := 0;
2850: ln_okx_assets_v NUMBER := 0;
2851: ln_okx_asset_lines_v NUMBER := 0;
2852: ln_okl_txd_assets_v NUMBER := 0;

Line 2898: CURSOR c_check_release_asset(p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE) is

2894: AND TXL.TAL_TYPE = 'ALI'
2895: AND TXL.TAS_ID = TAS.ID
2896: AND TAS.TSU_CODE = 'ENTERED'; --);
2897:
2898: CURSOR c_check_release_asset(p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE) is
2899: SELECT RULE_INFORMATION1
2900: FROM OKC_RULES_V
2901: WHERE DNZ_CHR_ID = p_dnz_chr_id
2902: AND RULE_INFORMATION_CATEGORY = 'LARLES';

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

3237: -- store SQL error message on message stack
3238: OKL_API.set_message(p_app_name => G_APP_NAME,
3239: p_msg_name => G_REQUIRED_VALUE,
3240: p_token1 => G_COL_NAME_TOKEN,
3241: p_token1_value => 'OKC_K_LINES_V.LSE_ID');
3242: -- halt validation as it is a required field
3243: RAISE G_EXCEPTION_STOP_VALIDATION;
3244: END IF;
3245: -- Enforce Foreign Key

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

3250: IF c_lse_id_validate%NOTFOUND THEN
3251: OKL_API.set_message(p_app_name => G_APP_NAME,
3252: p_msg_name => G_NO_MATCHING_RECORD,
3253: p_token1 => G_COL_NAME_TOKEN,
3254: p_token1_value => 'OKC_K_LINES_V.LSE_ID');
3255: -- halt validation as it has no parent record
3256: RAISE G_EXCEPTION_HALT_VALIDATION;
3257: END IF;
3258: CLOSE c_lse_id_validate;

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

3263: x_lse_type IS NULL) THEN
3264: OKL_API.set_message(p_app_name => G_APP_NAME,
3265: p_msg_name => G_NO_MATCHING_RECORD,
3266: p_token1 => G_COL_NAME_TOKEN,
3267: p_token1_value => 'OKC_K_LINES_V.LSE_ID');
3268: -- halt validation as it has no parent record
3269: RAISE G_EXCEPTION_HALT_VALIDATION;
3270: END IF;
3271: EXCEPTION

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

3298: -- Start of Commnets
3299: -- Badrinath Kuchibholta
3300: -- Procedure Name : validate_cle_lse_id
3301: -- Description : validation of the cle_id
3302: -- with OKC_k_LINES_V and Check if the line style is TLS
3303: -- Business Rules :
3304: -- Parameters :
3305: -- Version : 1.0
3306: -- End of Commnets

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

3308: PROCEDURE validate_cle_lse_id(p_clev_rec IN clev_rec_type,
3309: p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,
3310: x_lty_code OUT NOCOPY OKC_LINE_STYLES_V.LTY_CODE%TYPE,
3311: x_return_status OUT NOCOPY VARCHAR2) IS
3312: ln_cle_id OKC_K_LINES_V.ID%TYPE := 0;
3313: lv_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
3314: lv_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
3315:
3316: CURSOR c_cle_id_validate(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE) IS

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

3312: ln_cle_id OKC_K_LINES_V.ID%TYPE := 0;
3313: lv_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
3314: lv_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
3315:
3316: CURSOR c_cle_id_validate(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE) IS
3317: SELECT lse.lty_code
3318: FROM OKC_K_LINES_V cle,
3319: OKC_LINE_STYLES_V lse
3320: WHERE cle.id = p_cle_id

Line 3318: FROM OKC_K_LINES_V cle,

3314: lv_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
3315:
3316: CURSOR c_cle_id_validate(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE) IS
3317: SELECT lse.lty_code
3318: FROM OKC_K_LINES_V cle,
3319: OKC_LINE_STYLES_V lse
3320: WHERE cle.id = p_cle_id
3321: AND lse.id = cle.lse_id;
3322:

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

3328: p_clev_rec.cle_id IS NULL) THEN
3329: OKL_API.set_message(p_app_name => G_APP_NAME,
3330: p_msg_name => G_REQUIRED_VALUE,
3331: p_token1 => G_COL_NAME_TOKEN,
3332: p_token1_value => 'OKC_K_LINES_V.CLE_ID');
3333: -- halt validation as it is a required field
3334: RAISE G_EXCEPTION_STOP_VALIDATION;
3335: END IF;
3336: -- check the valid id is there

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

3338: IF c_cle_id_validate%NOTFOUND THEN
3339: OKL_API.set_message(p_app_name => G_APP_NAME,
3340: p_msg_name => G_NO_MATCHING_RECORD,
3341: p_token1 => G_COL_NAME_TOKEN,
3342: p_token1_value => 'OKC_K_LINES_V.CLE_ID');
3343: -- halt validation as it has no parent record
3344: RAISE G_EXCEPTION_HALT_VALIDATION;
3345: END IF;
3346: FETCH c_cle_id_validate into lv_lty_code;

Line 3401: -- Description : validation with OKC_K_LINES_V

3397: ----------------------------------------------------------------------------------------------------
3398: -- Start of Commnets
3399: -- Badrinath Kuchibholta
3400: -- Procedure Name : validate_dnz_chr_id
3401: -- Description : validation with OKC_K_LINES_V
3402: -- Business Rules :
3403: -- Parameters :
3404: -- Version : 1.0
3405: -- End of Commnets

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

3406:
3407: PROCEDURE validate_dnz_chr_id(p_clev_rec IN clev_rec_type,
3408: x_return_status OUT NOCOPY VARCHAR2) IS
3409: ln_dummy NUMBER := 0;
3410: CURSOR c_dnz_chr_id_validate(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
3411: SELECT 1
3412: --FROM DUAL
3413: --WHERE EXISTS (SELECT 1
3414: FROM OKC_K_HEADERS_B chrv

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

3422: -- store SQL error message on message stack
3423: OKL_API.set_message(p_app_name => G_APP_NAME,
3424: p_msg_name => G_REQUIRED_VALUE,
3425: p_token1 => G_COL_NAME_TOKEN,
3426: p_token1_value => 'OKC_K_LINES_V.DNZ_CHR_ID');
3427: -- halt validation as it is a required field
3428: RAISE G_EXCEPTION_STOP_VALIDATION;
3429: END IF;
3430: -- Enforce Foreign Key

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

3435: IF c_dnz_chr_id_validate%NOTFOUND THEN
3436: OKL_API.set_message(p_app_name => G_APP_NAME,
3437: p_msg_name => G_NO_MATCHING_RECORD,
3438: p_token1 => G_COL_NAME_TOKEN,
3439: p_token1_value => 'OKC_K_LINES_V.DNZ_CHR_ID');
3440: -- halt validation as it has no parent record
3441: RAISE G_EXCEPTION_HALT_VALIDATION;
3442: END IF;
3443: FETCH c_dnz_chr_id_validate into ln_dummy;

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

3445: IF (ln_dummy = 0) THEN
3446: OKL_API.set_message(p_app_name => G_APP_NAME,
3447: p_msg_name => G_NO_MATCHING_RECORD,
3448: p_token1 => G_COL_NAME_TOKEN,
3449: p_token1_value => 'OKC_K_LINES_V.DNZ_CHR_ID');
3450: -- halt validation as it has no parent record
3451: RAISE G_EXCEPTION_HALT_VALIDATION;
3452: END IF;
3453: EXCEPTION

Line 3816: -- Description : validation with OKC_K_LINES_V

3812: ----------------------------------------------------------------------------------------------------
3813: -- Start of Commnets
3814: -- Badrinath Kuchibholta
3815: -- Procedure Name : validate_sts_code
3816: -- Description : validation with OKC_K_LINES_V
3817: -- Business Rules :
3818: -- Parameters :
3819: -- Version : 1.0
3820: -- End of Commnets

Line 3825: lv_sts_code OKC_K_LINES_V.STS_CODE%TYPE;

3821:
3822: PROCEDURE validate_sts_code(p_clev_rec IN clev_rec_type,
3823: x_return_status OUT NOCOPY VARCHAR2) IS
3824:
3825: lv_sts_code OKC_K_LINES_V.STS_CODE%TYPE;
3826: lv_lty_code OKC_LINE_STYLES_V.lty_CODE%TYPE;
3827:
3828: CURSOR c_lty_code_validate(p_lse_id OKC_LINE_STYLES_B.ID%TYPE) IS
3829: SELECT lse.lty_code

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

3829: SELECT lse.lty_code
3830: FROM OKC_LINE_STYLES_V lse
3831: WHERE lse.id = p_lse_id;
3832:
3833: CURSOR c_sub_sub_line_sts_code(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
3834: p_cle_id OKC_K_LINES_V.ID%TYPE,
3835: p_lty_code OKC_LINE_STYLES_V.lty_CODE%TYPE) IS
3836: SELECT cle.sts_code
3837: FROM OKC_K_LINES_V cle

Line 3834: p_cle_id OKC_K_LINES_V.ID%TYPE,

3830: FROM OKC_LINE_STYLES_V lse
3831: WHERE lse.id = p_lse_id;
3832:
3833: CURSOR c_sub_sub_line_sts_code(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
3834: p_cle_id OKC_K_LINES_V.ID%TYPE,
3835: p_lty_code OKC_LINE_STYLES_V.lty_CODE%TYPE) IS
3836: SELECT cle.sts_code
3837: FROM OKC_K_LINES_V cle
3838: WHERE cle.id in (SELECT cle.cle_id

Line 3837: FROM OKC_K_LINES_V cle

3833: CURSOR c_sub_sub_line_sts_code(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
3834: p_cle_id OKC_K_LINES_V.ID%TYPE,
3835: p_lty_code OKC_LINE_STYLES_V.lty_CODE%TYPE) IS
3836: SELECT cle.sts_code
3837: FROM OKC_K_LINES_V cle
3838: WHERE cle.id in (SELECT cle.cle_id
3839: FROM OKC_K_LINES_V cle
3840: WHERE id in (SELECT cle.cle_id
3841: FROM OKC_LINE_STYLES_V lse,

Line 3839: FROM OKC_K_LINES_V cle

3835: p_lty_code OKC_LINE_STYLES_V.lty_CODE%TYPE) IS
3836: SELECT cle.sts_code
3837: FROM OKC_K_LINES_V cle
3838: WHERE cle.id in (SELECT cle.cle_id
3839: FROM OKC_K_LINES_V cle
3840: WHERE id in (SELECT cle.cle_id
3841: FROM OKC_LINE_STYLES_V lse,
3842: OKC_K_LINES_V cle
3843: WHERE dnz_chr_id = p_dnz_chr_id

Line 3842: OKC_K_LINES_V cle

3838: WHERE cle.id in (SELECT cle.cle_id
3839: FROM OKC_K_LINES_V cle
3840: WHERE id in (SELECT cle.cle_id
3841: FROM OKC_LINE_STYLES_V lse,
3842: OKC_K_LINES_V cle
3843: WHERE dnz_chr_id = p_dnz_chr_id
3844: AND cle.lse_id = lse.id
3845: AND cle.id = p_cle_id
3846: AND lse.lty_code = p_lty_code));

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

3844: AND cle.lse_id = lse.id
3845: AND cle.id = p_cle_id
3846: AND lse.lty_code = p_lty_code));
3847:
3848: CURSOR c_sub_line_sts_code(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
3849: p_cle_id OKC_K_LINES_V.ID%TYPE,
3850: p_lty_code OKC_LINE_STYLES_V.lty_CODE%TYPE) IS
3851: SELECT cle.sts_code
3852: FROM OKC_K_LINES_V cle

Line 3849: p_cle_id OKC_K_LINES_V.ID%TYPE,

3845: AND cle.id = p_cle_id
3846: AND lse.lty_code = p_lty_code));
3847:
3848: CURSOR c_sub_line_sts_code(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
3849: p_cle_id OKC_K_LINES_V.ID%TYPE,
3850: p_lty_code OKC_LINE_STYLES_V.lty_CODE%TYPE) IS
3851: SELECT cle.sts_code
3852: FROM OKC_K_LINES_V cle
3853: WHERE id in (SELECT cle.cle_id

Line 3852: FROM OKC_K_LINES_V cle

3848: CURSOR c_sub_line_sts_code(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
3849: p_cle_id OKC_K_LINES_V.ID%TYPE,
3850: p_lty_code OKC_LINE_STYLES_V.lty_CODE%TYPE) IS
3851: SELECT cle.sts_code
3852: FROM OKC_K_LINES_V cle
3853: WHERE id in (SELECT cle.cle_id
3854: FROM OKC_LINE_STYLES_V lse,
3855: OKC_K_LINES_V cle
3856: WHERE dnz_chr_id = p_dnz_chr_id

Line 3855: OKC_K_LINES_V cle

3851: SELECT cle.sts_code
3852: FROM OKC_K_LINES_V cle
3853: WHERE id in (SELECT cle.cle_id
3854: FROM OKC_LINE_STYLES_V lse,
3855: OKC_K_LINES_V cle
3856: WHERE dnz_chr_id = p_dnz_chr_id
3857: AND cle.lse_id = lse.id
3858: AND cle.id = p_cle_id
3859: AND lse.lty_code = p_lty_code);

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

3857: AND cle.lse_id = lse.id
3858: AND cle.id = p_cle_id
3859: AND lse.lty_code = p_lty_code);
3860:
3861: CURSOR c_top_line_sts_code(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
3862: p_cle_id OKC_K_LINES_V.ID%TYPE,
3863: p_chr_id OKC_K_LINES_V.CHR_ID%TYPE) IS
3864: SELECT cle.sts_code
3865: FROM OKC_K_LINES_V cle

Line 3862: p_cle_id OKC_K_LINES_V.ID%TYPE,

3858: AND cle.id = p_cle_id
3859: AND lse.lty_code = p_lty_code);
3860:
3861: CURSOR c_top_line_sts_code(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
3862: p_cle_id OKC_K_LINES_V.ID%TYPE,
3863: p_chr_id OKC_K_LINES_V.CHR_ID%TYPE) IS
3864: SELECT cle.sts_code
3865: FROM OKC_K_LINES_V cle
3866: WHERE cle.dnz_chr_id = p_dnz_chr_id

Line 3863: p_chr_id OKC_K_LINES_V.CHR_ID%TYPE) IS

3859: AND lse.lty_code = p_lty_code);
3860:
3861: CURSOR c_top_line_sts_code(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
3862: p_cle_id OKC_K_LINES_V.ID%TYPE,
3863: p_chr_id OKC_K_LINES_V.CHR_ID%TYPE) IS
3864: SELECT cle.sts_code
3865: FROM OKC_K_LINES_V cle
3866: WHERE cle.dnz_chr_id = p_dnz_chr_id
3867: AND cle.cle_id is null

Line 3865: FROM OKC_K_LINES_V cle

3861: CURSOR c_top_line_sts_code(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
3862: p_cle_id OKC_K_LINES_V.ID%TYPE,
3863: p_chr_id OKC_K_LINES_V.CHR_ID%TYPE) IS
3864: SELECT cle.sts_code
3865: FROM OKC_K_LINES_V cle
3866: WHERE cle.dnz_chr_id = p_dnz_chr_id
3867: AND cle.cle_id is null
3868: AND cle.id = p_cle_id
3869: AND cle.chr_id = p_chr_id;

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

3875: -- store SQL error message on message stack
3876: OKL_API.set_message(p_app_name => G_APP_NAME,
3877: p_msg_name => G_REQUIRED_VALUE,
3878: p_token1 => G_COL_NAME_TOKEN,
3879: p_token1_value => 'OKC_K_LINES_V.STS_CODE');
3880: -- halt validation as it is a required field
3881: RAISE G_EXCEPTION_STOP_VALIDATION;
3882: END IF;
3883: -- First Get the Lty _code we are going to validate

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

3901: IF c_sub_sub_line_sts_code%NOTFOUND THEN
3902: OKL_API.set_message(p_app_name => G_APP_NAME,
3903: p_msg_name => G_NO_MATCHING_RECORD,
3904: p_token1 => G_COL_NAME_TOKEN,
3905: p_token1_value => 'OKC_K_LINES_V.STS_CODE');
3906: -- halt validation as it is a required field
3907: RAISE G_EXCEPTION_HALT_VALIDATION;
3908: END IF;
3909: FETCH c_sub_sub_line_sts_code INTO lv_sts_code;

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

3917: IF c_sub_line_sts_code%NOTFOUND THEN
3918: OKL_API.set_message(p_app_name => G_APP_NAME,
3919: p_msg_name => G_NO_MATCHING_RECORD,
3920: p_token1 => G_COL_NAME_TOKEN,
3921: p_token1_value => 'OKC_K_LINES_V.STS_CODE');
3922: -- halt validation as it is a required field
3923: RAISE G_EXCEPTION_HALT_VALIDATION;
3924: END IF;
3925: FETCH c_sub_line_sts_code INTO lv_sts_code;

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

3931: IF c_top_line_sts_code%NOTFOUND THEN
3932: OKL_API.set_message(p_app_name => G_APP_NAME,
3933: p_msg_name => G_NO_MATCHING_RECORD,
3934: p_token1 => G_COL_NAME_TOKEN,
3935: p_token1_value => 'OKC_K_LINES_V.STS_CODE');
3936: -- halt validation as it is a required field
3937: RAISE G_EXCEPTION_HALT_VALIDATION;
3938: END IF;
3939: FETCH c_top_line_sts_code INTO lv_sts_code;

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

6388: l_cimv_rec cimv_rec_type;
6389: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
6390: i NUMBER := 0;
6391: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_AO_LNE_ITEM';
6392: ln_display_sequence OKC_K_LINES_V.DISPLAY_SEQUENCE%TYPE := 0;
6393: ln_num_of_items OKC_K_ITEMS.NUMBER_OF_ITEMS%TYPE := 0;
6394:
6395: CURSOR get_dis_seq_qty(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
6396: P_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

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

6391: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_AO_LNE_ITEM';
6392: ln_display_sequence OKC_K_LINES_V.DISPLAY_SEQUENCE%TYPE := 0;
6393: ln_num_of_items OKC_K_ITEMS.NUMBER_OF_ITEMS%TYPE := 0;
6394:
6395: CURSOR get_dis_seq_qty(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
6396: P_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
6397: SELECT cle.display_sequence,
6398: cim.number_of_items
6399: FROM okc_line_styles_b lse2,

Line 6396: P_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

6392: ln_display_sequence OKC_K_LINES_V.DISPLAY_SEQUENCE%TYPE := 0;
6393: ln_num_of_items OKC_K_ITEMS.NUMBER_OF_ITEMS%TYPE := 0;
6394:
6395: CURSOR get_dis_seq_qty(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
6396: P_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
6397: SELECT cle.display_sequence,
6398: cim.number_of_items
6399: FROM okc_line_styles_b lse2,
6400: okc_line_styles_b lse1,

Line 6601: ln_display_sequence OKC_K_LINES_V.DISPLAY_SEQUENCE%TYPE;

6597: l_cimv_rec cimv_rec_type;
6598: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
6599: i NUMBER;
6600: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_AO_LNE_ITEM';
6601: ln_display_sequence OKC_K_LINES_V.DISPLAY_SEQUENCE%TYPE;
6602: ln_num_of_items OKC_K_ITEMS.NUMBER_OF_ITEMS%TYPE;
6603:
6604: CURSOR get_dis_seq_qty(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
6605: P_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

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

6600: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_AO_LNE_ITEM';
6601: ln_display_sequence OKC_K_LINES_V.DISPLAY_SEQUENCE%TYPE;
6602: ln_num_of_items OKC_K_ITEMS.NUMBER_OF_ITEMS%TYPE;
6603:
6604: CURSOR get_dis_seq_qty(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
6605: P_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
6606: SELECT cle.display_sequence,
6607: cim.number_of_items
6608: FROM okc_line_styles_b lse2,

Line 6605: P_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

6601: ln_display_sequence OKC_K_LINES_V.DISPLAY_SEQUENCE%TYPE;
6602: ln_num_of_items OKC_K_ITEMS.NUMBER_OF_ITEMS%TYPE;
6603:
6604: CURSOR get_dis_seq_qty(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
6605: P_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
6606: SELECT cle.display_sequence,
6607: cim.number_of_items
6608: FROM okc_line_styles_b lse2,
6609: okc_line_styles_b lse1,

Line 6813: ln_fa_id OKC_K_LINES_V.ID%TYPE;

6809: l_clev_rec clev_rec_type;
6810: -- Variables for validation of line style
6811: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
6812: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
6813: ln_fa_id OKC_K_LINES_V.ID%TYPE;
6814:
6815: CURSOR get_fa_id(p_top_line OKC_K_LINES_V.ID%TYPE,
6816: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
6817: IS

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

6811: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
6812: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
6813: ln_fa_id OKC_K_LINES_V.ID%TYPE;
6814:
6815: CURSOR get_fa_id(p_top_line OKC_K_LINES_V.ID%TYPE,
6816: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
6817: IS
6818: SELECT cle.id
6819: FROM okc_subclass_top_line stl,

Line 6816: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)

6812: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
6813: ln_fa_id OKC_K_LINES_V.ID%TYPE;
6814:
6815: CURSOR get_fa_id(p_top_line OKC_K_LINES_V.ID%TYPE,
6816: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
6817: IS
6818: SELECT cle.id
6819: FROM okc_subclass_top_line stl,
6820: okc_line_styles_b lse2,

Line 7011: ln_fa_id OKC_K_LINES_V.ID%TYPE;

7007: l_clev_rec clev_rec_type;
7008: -- Variables for validation of line style
7009: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
7010: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
7011: ln_fa_id OKC_K_LINES_V.ID%TYPE;
7012:
7013: CURSOR get_fa_id(p_top_line OKC_K_LINES_V.ID%TYPE,
7014: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
7015: IS

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

7009: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
7010: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
7011: ln_fa_id OKC_K_LINES_V.ID%TYPE;
7012:
7013: CURSOR get_fa_id(p_top_line OKC_K_LINES_V.ID%TYPE,
7014: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
7015: IS
7016: SELECT cle.id
7017: FROM okc_subclass_top_line stl,

Line 7014: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)

7010: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
7011: ln_fa_id OKC_K_LINES_V.ID%TYPE;
7012:
7013: CURSOR get_fa_id(p_top_line OKC_K_LINES_V.ID%TYPE,
7014: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
7015: IS
7016: SELECT cle.id
7017: FROM okc_subclass_top_line stl,
7018: okc_line_styles_b lse2,

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

7246: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
7247: OKL_API.set_message(p_app_name => G_APP_NAME,
7248: p_msg_name => G_FETCHING_INFO,
7249: p_token1 => G_REC_NAME_TOKEN,
7250: p_token1_value => 'OKC_K_LINES_V Record');
7251: RAISE G_EXCEPTION_HALT_VALIDATION;
7252: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
7253: OKL_API.set_message(p_app_name => G_APP_NAME,
7254: p_msg_name => G_FETCHING_INFO,

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

7252: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
7253: OKL_API.set_message(p_app_name => G_APP_NAME,
7254: p_msg_name => G_FETCHING_INFO,
7255: p_token1 => G_REC_NAME_TOKEN,
7256: p_token1_value => 'OKC_K_LINES_V Record');
7257: RAISE G_EXCEPTION_HALT_VALIDATION;
7258: END IF;
7259: -- To Get the kle top Line Record
7260: x_return_status := get_rec_klev(p_clev_rec.id,

Line 8381: ln_fa_id OKC_K_LINES_V.ID%TYPE;

8377: l_klev_rec klev_rec_type := p_klev_rec;
8378: -- Variables for validation of line style
8379: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
8380: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
8381: ln_fa_id OKC_K_LINES_V.ID%TYPE;
8382:
8383: -- Temp variables for capital reduction and tradein amount
8384: tradein_amount OKL_K_LINES.TRADEIN_AMOUNT%TYPE;
8385: capital_reduction OKL_K_LINES.CAPITAL_REDUCTION%TYPE;

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

8383: -- Temp variables for capital reduction and tradein amount
8384: tradein_amount OKL_K_LINES.TRADEIN_AMOUNT%TYPE;
8385: capital_reduction OKL_K_LINES.CAPITAL_REDUCTION%TYPE;
8386:
8387: CURSOR get_fa_id(p_top_line OKC_K_LINES_V.ID%TYPE,
8388: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
8389: IS
8390: -- #4414408
8391: SELECT cle.id

Line 8388: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)

8384: tradein_amount OKL_K_LINES.TRADEIN_AMOUNT%TYPE;
8385: capital_reduction OKL_K_LINES.CAPITAL_REDUCTION%TYPE;
8386:
8387: CURSOR get_fa_id(p_top_line OKC_K_LINES_V.ID%TYPE,
8388: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
8389: IS
8390: -- #4414408
8391: SELECT cle.id
8392: -- FROM okc_subclass_top_line stl,

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

8630: l_clev_rec clev_rec_type := p_clev_rec;
8631: l_klev_rec klev_rec_type := p_klev_rec;
8632: lx_clev_rec clev_rec_type;
8633: lx_klev_rec klev_rec_type;
8634: CURSOR c_get_lse_id_sts(p_top_line_id OKC_K_LINES_V.ID%TYPE) IS
8635: SELECT lse.id,
8636: cle.sts_code
8637: FROM okc_subclass_top_line stl,
8638: okc_line_styles_b lse,

Line 8639: okc_k_lines_v cle

8635: SELECT lse.id,
8636: cle.sts_code
8637: FROM okc_subclass_top_line stl,
8638: okc_line_styles_b lse,
8639: okc_k_lines_v cle
8640: WHERE cle.id = p_top_line_id
8641: AND cle.lse_id = lse.id
8642: AND lse.lty_code = G_FIN_LINE_LTY_CODE
8643: AND lse.lse_parent_id is null

Line 8841: p_top_line_id IN OKC_K_LINES_V.ID%TYPE,

8837: x_msg_count OUT NOCOPY NUMBER,
8838: x_msg_data OUT NOCOPY VARCHAR2,
8839: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
8840: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
8841: p_top_line_id IN OKC_K_LINES_V.ID%TYPE,
8842: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
8843: x_fin_clev_rec OUT NOCOPY clev_rec_type,
8844: x_fin_klev_rec OUT NOCOPY klev_rec_type,
8845: x_oec OUT NOCOPY OKL_K_LINES_V.OEC%TYPE,

Line 8842: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,

8838: x_msg_data OUT NOCOPY VARCHAR2,
8839: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
8840: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
8841: p_top_line_id IN OKC_K_LINES_V.ID%TYPE,
8842: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
8843: x_fin_clev_rec OUT NOCOPY clev_rec_type,
8844: x_fin_klev_rec OUT NOCOPY klev_rec_type,
8845: x_oec OUT NOCOPY OKL_K_LINES_V.OEC%TYPE,
8846: p_validate_fin_line IN VARCHAR2 DEFAULT OKL_API.G_TRUE) IS

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

8845: x_oec OUT NOCOPY OKL_K_LINES_V.OEC%TYPE,
8846: p_validate_fin_line IN VARCHAR2 DEFAULT OKL_API.G_TRUE) IS
8847:
8848: ln_oec OKL_K_LINES_V.OEC%TYPE := 0;
8849: -- ln_top_line_id OKC_K_LINES_V.CLE_ID%TYPE := 0;
8850: l_update_clev_rec clev_rec_type;
8851: l_update_klev_rec klev_rec_type;
8852:
8853: -- #4414408 Top line ID is now passed to the API

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

8852:
8853: -- #4414408 Top line ID is now passed to the API
8854: /*
8855: -- To Find out the Top line ID
8856: CURSOR c_model_top_line(p_model_line_id OKC_K_LINES_V.ID%TYPE,
8857: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
8858: SELECT cle.cle_id
8859: FROM okc_subclass_top_line stl,
8860: okc_line_styles_b lse2,

Line 8857: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

8853: -- #4414408 Top line ID is now passed to the API
8854: /*
8855: -- To Find out the Top line ID
8856: CURSOR c_model_top_line(p_model_line_id OKC_K_LINES_V.ID%TYPE,
8857: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
8858: SELECT cle.cle_id
8859: FROM okc_subclass_top_line stl,
8860: okc_line_styles_b lse2,
8861: okc_line_styles_b lse1,

Line 8863: okc_k_lines_v cle

8859: FROM okc_subclass_top_line stl,
8860: okc_line_styles_b lse2,
8861: okc_line_styles_b lse1,
8862: okc_k_items_v cim,
8863: okc_k_lines_v cle
8864: WHERE cle.id = p_model_line_id
8865: AND cle.dnz_chr_id = p_dnz_chr_id
8866: AND cle.id = cim.cle_id
8867: AND cle.dnz_chr_id = cim.dnz_chr_id

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

8932: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8933: OKL_API.set_message(p_app_name => G_APP_NAME,
8934: p_msg_name => G_FETCHING_INFO,
8935: p_token1 => G_REC_NAME_TOKEN,
8936: p_token1_value => 'OKC_K_LINES_V Record');
8937: RAISE G_EXCEPTION_HALT_VALIDATION;
8938: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8939: OKL_API.set_message(p_app_name => G_APP_NAME,
8940: p_msg_name => G_FETCHING_INFO,

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

8938: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8939: OKL_API.set_message(p_app_name => G_APP_NAME,
8940: p_msg_name => G_FETCHING_INFO,
8941: p_token1 => G_REC_NAME_TOKEN,
8942: p_token1_value => 'OKC_K_LINES_V Record');
8943: RAISE G_EXCEPTION_HALT_VALIDATION;
8944: END IF;
8945: -- To Get the kle top Line Record
8946: x_return_status := get_rec_klev(p_top_line_id, -- 4414408

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

9044: x_msg_count OUT NOCOPY NUMBER,
9045: x_msg_data OUT NOCOPY VARCHAR2,
9046: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
9047: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
9048: p_top_line_id IN OKC_K_LINES_V.ID%TYPE, -- 4414408
9049: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
9050: x_fin_clev_rec OUT NOCOPY clev_rec_type,
9051: x_fin_klev_rec OUT NOCOPY klev_rec_type,
9052: x_cap_amt OUT NOCOPY OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE,

Line 9049: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,

9045: x_msg_data OUT NOCOPY VARCHAR2,
9046: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
9047: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
9048: p_top_line_id IN OKC_K_LINES_V.ID%TYPE, -- 4414408
9049: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
9050: x_fin_clev_rec OUT NOCOPY clev_rec_type,
9051: x_fin_klev_rec OUT NOCOPY klev_rec_type,
9052: x_cap_amt OUT NOCOPY OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE,
9053: p_validate_fin_line IN VARCHAR2 DEFAULT OKL_API.G_TRUE) IS

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

9052: x_cap_amt OUT NOCOPY OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE,
9053: p_validate_fin_line IN VARCHAR2 DEFAULT OKL_API.G_TRUE) IS
9054:
9055: ln_cap_amt OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
9056: -- ln_top_line_id OKC_K_LINES_V.CLE_ID%TYPE := 0;
9057: l_update_clev_rec clev_rec_type;
9058: l_update_klev_rec klev_rec_type;
9059: -- #4414408 Top line ID is a parameter passed to the API
9060: /*

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

9058: l_update_klev_rec klev_rec_type;
9059: -- #4414408 Top line ID is a parameter passed to the API
9060: /*
9061: -- To Find out the Top line ID
9062: CURSOR c_model_top_line(p_model_line_id OKC_K_LINES_V.ID%TYPE,
9063: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
9064: SELECT cle.cle_id
9065: FROM okc_subclass_top_line stl,
9066: okc_line_styles_b lse2,

Line 9063: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

9059: -- #4414408 Top line ID is a parameter passed to the API
9060: /*
9061: -- To Find out the Top line ID
9062: CURSOR c_model_top_line(p_model_line_id OKC_K_LINES_V.ID%TYPE,
9063: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
9064: SELECT cle.cle_id
9065: FROM okc_subclass_top_line stl,
9066: okc_line_styles_b lse2,
9067: okc_line_styles_b lse1,

Line 9069: okc_k_lines_v cle

9065: FROM okc_subclass_top_line stl,
9066: okc_line_styles_b lse2,
9067: okc_line_styles_b lse1,
9068: okc_k_items_v cim,
9069: okc_k_lines_v cle
9070: WHERE cle.id = p_model_line_id
9071: AND cle.dnz_chr_id = p_dnz_chr_id
9072: AND cle.id = cim.cle_id
9073: AND cle.dnz_chr_id = cim.dnz_chr_id

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

9139: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
9140: OKL_API.set_message(p_app_name => G_APP_NAME,
9141: p_msg_name => G_FETCHING_INFO,
9142: p_token1 => G_REC_NAME_TOKEN,
9143: p_token1_value => 'OKC_K_LINES_V Record');
9144: RAISE G_EXCEPTION_HALT_VALIDATION;
9145: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
9146: OKL_API.set_message(p_app_name => G_APP_NAME,
9147: p_msg_name => G_FETCHING_INFO,

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

9145: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
9146: OKL_API.set_message(p_app_name => G_APP_NAME,
9147: p_msg_name => G_FETCHING_INFO,
9148: p_token1 => G_REC_NAME_TOKEN,
9149: p_token1_value => 'OKC_K_LINES_V Record');
9150: RAISE G_EXCEPTION_HALT_VALIDATION;
9151: END IF;
9152: -- To Get the kle top Line Record
9153: x_return_status := get_rec_klev(p_top_line_id, -- 4414408

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

9249: x_msg_count OUT NOCOPY NUMBER,
9250: x_msg_data OUT NOCOPY VARCHAR2,
9251: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
9252: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
9253: p_top_line_id IN OKC_K_LINES_V.ID%TYPE, -- 4414408
9254: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
9255: x_fin_clev_rec OUT NOCOPY clev_rec_type,
9256: x_fin_klev_rec OUT NOCOPY klev_rec_type,
9257: x_res_value OUT NOCOPY OKL_K_LINES_V.RESIDUAL_VALUE%TYPE,

Line 9254: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,

9250: x_msg_data OUT NOCOPY VARCHAR2,
9251: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
9252: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
9253: p_top_line_id IN OKC_K_LINES_V.ID%TYPE, -- 4414408
9254: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
9255: x_fin_clev_rec OUT NOCOPY clev_rec_type,
9256: x_fin_klev_rec OUT NOCOPY klev_rec_type,
9257: x_res_value OUT NOCOPY OKL_K_LINES_V.RESIDUAL_VALUE%TYPE,
9258: p_validate_fin_line IN VARCHAR2 DEFAULT OKL_API.G_TRUE) IS

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

9257: x_res_value OUT NOCOPY OKL_K_LINES_V.RESIDUAL_VALUE%TYPE,
9258: p_validate_fin_line IN VARCHAR2 DEFAULT OKL_API.G_TRUE) IS
9259:
9260: ln_res_value OKL_K_LINES_V.RESIDUAL_VALUE%TYPE := 0;
9261: -- ln_top_line_id OKC_K_LINES_V.CLE_ID%TYPE := 0;
9262: l_update_clev_rec clev_rec_type;
9263: l_update_klev_rec klev_rec_type;
9264: -- 4414408
9265: /*

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

9263: l_update_klev_rec klev_rec_type;
9264: -- 4414408
9265: /*
9266: -- To Find out the Top line ID
9267: CURSOR c_model_top_line(p_model_line_id OKC_K_LINES_V.ID%TYPE,
9268: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
9269: SELECT cle.cle_id
9270: FROM okc_subclass_top_line stl,
9271: okc_line_styles_b lse2,

Line 9268: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

9264: -- 4414408
9265: /*
9266: -- To Find out the Top line ID
9267: CURSOR c_model_top_line(p_model_line_id OKC_K_LINES_V.ID%TYPE,
9268: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
9269: SELECT cle.cle_id
9270: FROM okc_subclass_top_line stl,
9271: okc_line_styles_b lse2,
9272: okc_line_styles_b lse1,

Line 9274: okc_k_lines_v cle

9270: FROM okc_subclass_top_line stl,
9271: okc_line_styles_b lse2,
9272: okc_line_styles_b lse1,
9273: okc_k_items_v cim,
9274: okc_k_lines_v cle
9275: WHERE cle.id = p_model_line_id
9276: AND cle.dnz_chr_id = p_dnz_chr_id
9277: AND cle.id = cim.cle_id
9278: AND cle.dnz_chr_id = cim.dnz_chr_id

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

9342: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
9343: OKL_API.set_message(p_app_name => G_APP_NAME,
9344: p_msg_name => G_FETCHING_INFO,
9345: p_token1 => G_REC_NAME_TOKEN,
9346: p_token1_value => 'OKC_K_LINES_V Record');
9347: RAISE G_EXCEPTION_HALT_VALIDATION;
9348: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
9349: OKL_API.set_message(p_app_name => G_APP_NAME,
9350: p_msg_name => G_FETCHING_INFO,

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

9348: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
9349: OKL_API.set_message(p_app_name => G_APP_NAME,
9350: p_msg_name => G_FETCHING_INFO,
9351: p_token1 => G_REC_NAME_TOKEN,
9352: p_token1_value => 'OKC_K_LINES_V Record');
9353: RAISE G_EXCEPTION_HALT_VALIDATION;
9354: END IF;
9355: -- To Get the kle top Line Record
9356: x_return_status := get_rec_klev(p_top_line_id, -- 4414408

Line 9462: p_top_line_id IN OKC_K_LINES_V.ID%TYPE,

9458: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
9459: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
9460: p_res_value IN OKL_K_LINES_V.RESIDUAL_VALUE%TYPE,
9461: p_oec IN OKL_K_LINES_V.OEC%TYPE,
9462: p_top_line_id IN OKC_K_LINES_V.ID%TYPE,
9463: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
9464: x_fin_clev_rec OUT NOCOPY clev_rec_type,
9465: x_fin_klev_rec OUT NOCOPY klev_rec_type,
9466: p_validate_fin_line IN VARCHAR2 DEFAULT OKL_API.G_TRUE) IS

Line 9463: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,

9459: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
9460: p_res_value IN OKL_K_LINES_V.RESIDUAL_VALUE%TYPE,
9461: p_oec IN OKL_K_LINES_V.OEC%TYPE,
9462: p_top_line_id IN OKC_K_LINES_V.ID%TYPE,
9463: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
9464: x_fin_clev_rec OUT NOCOPY clev_rec_type,
9465: x_fin_klev_rec OUT NOCOPY klev_rec_type,
9466: p_validate_fin_line IN VARCHAR2 DEFAULT OKL_API.G_TRUE) IS
9467:

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

9465: x_fin_klev_rec OUT NOCOPY klev_rec_type,
9466: p_validate_fin_line IN VARCHAR2 DEFAULT OKL_API.G_TRUE) IS
9467:
9468: ln_res_per OKL_K_LINES_V.RESIDUAL_PERCENTAGE%TYPE := 0;
9469: ln_top_line_id OKC_K_LINES_V.CLE_ID%TYPE := 0;
9470: l_update_clev_rec clev_rec_type;
9471: l_update_klev_rec klev_rec_type;
9472:
9473: BEGIN

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

9505: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
9506: OKL_API.set_message(p_app_name => G_APP_NAME,
9507: p_msg_name => G_FETCHING_INFO,
9508: p_token1 => G_REC_NAME_TOKEN,
9509: p_token1_value => 'OKC_K_LINES_V Record');
9510: RAISE G_EXCEPTION_HALT_VALIDATION;
9511: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
9512: OKL_API.set_message(p_app_name => G_APP_NAME,
9513: p_msg_name => G_FETCHING_INFO,

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

9511: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
9512: OKL_API.set_message(p_app_name => G_APP_NAME,
9513: p_msg_name => G_FETCHING_INFO,
9514: p_token1 => G_REC_NAME_TOKEN,
9515: p_token1_value => 'OKC_K_LINES_V Record');
9516: RAISE G_EXCEPTION_HALT_VALIDATION;
9517: END IF;
9518: -- To Get the kle top Line Record
9519: x_return_status := get_rec_klev(p_top_line_id,

Line 9771: ln_fa_id OKC_K_LINES_V.ID%TYPE;

9767: l_clev_rec clev_rec_type;
9768: -- Variables for validation of line style
9769: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
9770: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
9771: ln_fa_id OKC_K_LINES_V.ID%TYPE;
9772:
9773: CURSOR get_fa_id(p_top_line OKC_K_LINES_V.ID%TYPE,
9774: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
9775: IS

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

9769: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
9770: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
9771: ln_fa_id OKC_K_LINES_V.ID%TYPE;
9772:
9773: CURSOR get_fa_id(p_top_line OKC_K_LINES_V.ID%TYPE,
9774: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
9775: IS
9776: SELECT cle.id
9777: FROM okc_subclass_top_line stl,

Line 9774: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)

9770: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
9771: ln_fa_id OKC_K_LINES_V.ID%TYPE;
9772:
9773: CURSOR get_fa_id(p_top_line OKC_K_LINES_V.ID%TYPE,
9774: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
9775: IS
9776: SELECT cle.id
9777: FROM okc_subclass_top_line stl,
9778: okc_line_styles_b lse2,

Line 9780: okc_k_lines_v cle

9776: SELECT cle.id
9777: FROM okc_subclass_top_line stl,
9778: okc_line_styles_b lse2,
9779: okc_line_styles_b lse1,
9780: okc_k_lines_v cle
9781: WHERE cle.cle_id = p_top_line
9782: AND cle.dnz_chr_id = p_dnz_chr_id
9783: AND lse1.id = cle.lse_id
9784: AND lse1.lty_code = G_FA_LINE_LTY_CODE

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

10328: l_klev_rec klev_rec_type;
10329: l_clev_tbl clev_tbl_type;
10330: x_klev_rec klev_rec_type;
10331: ln_oec OKL_K_LINES_V.OEC%TYPE := 0;
10332: ln_add_cle_id OKC_K_LINES_V.CLE_ID%TYPE := 0;
10333: ln_add_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE := 0;
10334: ln_top_line_id OKC_K_LINES_V.CLE_ID%TYPE := 0;
10335: ln_klev_fin_oec OKL_K_LINES_V.OEC%TYPE := 0;
10336: ln_klev_fin_res OKL_K_LINES_V.RESIDUAL_VALUE%TYPE := 0;

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

10329: l_clev_tbl clev_tbl_type;
10330: x_klev_rec klev_rec_type;
10331: ln_oec OKL_K_LINES_V.OEC%TYPE := 0;
10332: ln_add_cle_id OKC_K_LINES_V.CLE_ID%TYPE := 0;
10333: ln_add_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE := 0;
10334: ln_top_line_id OKC_K_LINES_V.CLE_ID%TYPE := 0;
10335: ln_klev_fin_oec OKL_K_LINES_V.OEC%TYPE := 0;
10336: ln_klev_fin_res OKL_K_LINES_V.RESIDUAL_VALUE%TYPE := 0;
10337: ln_klev_fin_cap OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;

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

10330: x_klev_rec klev_rec_type;
10331: ln_oec OKL_K_LINES_V.OEC%TYPE := 0;
10332: ln_add_cle_id OKC_K_LINES_V.CLE_ID%TYPE := 0;
10333: ln_add_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE := 0;
10334: ln_top_line_id OKC_K_LINES_V.CLE_ID%TYPE := 0;
10335: ln_klev_fin_oec OKL_K_LINES_V.OEC%TYPE := 0;
10336: ln_klev_fin_res OKL_K_LINES_V.RESIDUAL_VALUE%TYPE := 0;
10337: ln_klev_fin_cap OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
10338:

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

10336: ln_klev_fin_res OKL_K_LINES_V.RESIDUAL_VALUE%TYPE := 0;
10337: ln_klev_fin_cap OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
10338:
10339: -- To Find out the Top line ID
10340: CURSOR c_model_top_line(p_model_line_id OKC_K_LINES_V.ID%TYPE,
10341: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
10342: -- #4414408
10343: SELECT cle.cle_id
10344: FROM okc_k_lines_b cle

Line 10341: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

10337: ln_klev_fin_cap OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
10338:
10339: -- To Find out the Top line ID
10340: CURSOR c_model_top_line(p_model_line_id OKC_K_LINES_V.ID%TYPE,
10341: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
10342: -- #4414408
10343: SELECT cle.cle_id
10344: FROM okc_k_lines_b cle
10345: WHERE cle.id = p_model_line_id

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

10613: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_ADD_LINE';
10614: l_klev_rec klev_rec_type;
10615: l_clev_tbl clev_tbl_type;
10616: x_klev_rec klev_rec_type;
10617: ln_add_cle_id OKC_K_LINES_V.CLE_ID%TYPE := 0;
10618: ln_add_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE := 0;
10619: ln_top_line_id OKC_K_LINES_V.CLE_ID%TYPE := 0;
10620: ln_klev_fin_oec OKL_K_LINES_V.OEC%TYPE := 0;
10621: ln_klev_fin_res OKL_K_LINES_V.RESIDUAL_VALUE%TYPE := 0;

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

10614: l_klev_rec klev_rec_type;
10615: l_clev_tbl clev_tbl_type;
10616: x_klev_rec klev_rec_type;
10617: ln_add_cle_id OKC_K_LINES_V.CLE_ID%TYPE := 0;
10618: ln_add_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE := 0;
10619: ln_top_line_id OKC_K_LINES_V.CLE_ID%TYPE := 0;
10620: ln_klev_fin_oec OKL_K_LINES_V.OEC%TYPE := 0;
10621: ln_klev_fin_res OKL_K_LINES_V.RESIDUAL_VALUE%TYPE := 0;
10622: ln_klev_fin_cap OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;

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

10615: l_clev_tbl clev_tbl_type;
10616: x_klev_rec klev_rec_type;
10617: ln_add_cle_id OKC_K_LINES_V.CLE_ID%TYPE := 0;
10618: ln_add_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE := 0;
10619: ln_top_line_id OKC_K_LINES_V.CLE_ID%TYPE := 0;
10620: ln_klev_fin_oec OKL_K_LINES_V.OEC%TYPE := 0;
10621: ln_klev_fin_res OKL_K_LINES_V.RESIDUAL_VALUE%TYPE := 0;
10622: ln_klev_fin_cap OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
10623:

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

10621: ln_klev_fin_res OKL_K_LINES_V.RESIDUAL_VALUE%TYPE := 0;
10622: ln_klev_fin_cap OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
10623:
10624: -- To Find out the Top line ID
10625: CURSOR c_model_top_line(p_model_line_id OKC_K_LINES_V.ID%TYPE,
10626: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
10627: -- #4414408
10628: SELECT cle.cle_id
10629: FROM okc_k_lines_b cle

Line 10626: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

10622: ln_klev_fin_cap OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
10623:
10624: -- To Find out the Top line ID
10625: CURSOR c_model_top_line(p_model_line_id OKC_K_LINES_V.ID%TYPE,
10626: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
10627: -- #4414408
10628: SELECT cle.cle_id
10629: FROM okc_k_lines_b cle
10630: WHERE cle.id = p_model_line_id

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

10859:
10860: i NUMBER := 0;
10861: j NUMBER := 0;
10862: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_ADDON_LN';
10863: ln_add_cle_id OKC_K_LINES_V.CLE_ID%TYPE := 0;
10864: ln_add_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE := 0;
10865: ln_top_line_id OKC_K_LINES_V.CLE_ID%TYPE := 0;
10866: l_clev_tbl clev_tbl_type;
10867: ln_klev_fin_oec OKL_K_LINES_V.OEC%TYPE := 0;

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

10860: i NUMBER := 0;
10861: j NUMBER := 0;
10862: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_ADDON_LN';
10863: ln_add_cle_id OKC_K_LINES_V.CLE_ID%TYPE := 0;
10864: ln_add_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE := 0;
10865: ln_top_line_id OKC_K_LINES_V.CLE_ID%TYPE := 0;
10866: l_clev_tbl clev_tbl_type;
10867: ln_klev_fin_oec OKL_K_LINES_V.OEC%TYPE := 0;
10868: ln_klev_fin_res OKL_K_LINES_V.RESIDUAL_VALUE%TYPE := 0;

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

10861: j NUMBER := 0;
10862: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_ADDON_LN';
10863: ln_add_cle_id OKC_K_LINES_V.CLE_ID%TYPE := 0;
10864: ln_add_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE := 0;
10865: ln_top_line_id OKC_K_LINES_V.CLE_ID%TYPE := 0;
10866: l_clev_tbl clev_tbl_type;
10867: ln_klev_fin_oec OKL_K_LINES_V.OEC%TYPE := 0;
10868: ln_klev_fin_res OKL_K_LINES_V.RESIDUAL_VALUE%TYPE := 0;
10869: ln_klev_fin_cap OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;

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

10868: ln_klev_fin_res OKL_K_LINES_V.RESIDUAL_VALUE%TYPE := 0;
10869: ln_klev_fin_cap OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
10870:
10871: -- To Find out the Top line ID
10872: CURSOR c_model_top_line(p_model_line_id OKC_K_LINES_V.ID%TYPE,
10873: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
10874: -- #4414408
10875: SELECT cle.cle_id
10876: FROM okc_k_lines_b cle

Line 10873: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

10869: ln_klev_fin_cap OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
10870:
10871: -- To Find out the Top line ID
10872: CURSOR c_model_top_line(p_model_line_id OKC_K_LINES_V.ID%TYPE,
10873: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
10874: -- #4414408
10875: SELECT cle.cle_id
10876: FROM okc_k_lines_b cle
10877: WHERE cle.id = p_model_line_id

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

11687: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
11688: OKL_API.set_message(p_app_name => G_APP_NAME,
11689: p_msg_name => G_FETCHING_INFO,
11690: p_token1 => G_REC_NAME_TOKEN,
11691: p_token1_value => 'OKC_K_LINES_V Record');
11692: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
11693: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
11694: OKL_API.set_message(p_app_name => G_APP_NAME,
11695: p_msg_name => G_FETCHING_INFO,

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

11693: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
11694: OKL_API.set_message(p_app_name => G_APP_NAME,
11695: p_msg_name => G_FETCHING_INFO,
11696: p_token1 => G_REC_NAME_TOKEN,
11697: p_token1_value => 'OKC_K_LINES_V Record');
11698: RAISE OKL_API.G_EXCEPTION_ERROR;
11699: END IF;
11700: x_return_status := get_rec_klev(p_id => p_cplv_rec.cle_id,
11701: x_klev_rec => l_klev_rec);

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

14949: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
14950: OKL_API.set_message(p_app_name => G_APP_NAME,
14951: p_msg_name => G_FETCHING_INFO,
14952: p_token1 => G_REC_NAME_TOKEN,
14953: p_token1_value => 'OKC_K_LINES_V Record');
14954: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
14955: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
14956: OKL_API.set_message(p_app_name => G_APP_NAME,
14957: p_msg_name => G_FETCHING_INFO,

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

14955: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
14956: OKL_API.set_message(p_app_name => G_APP_NAME,
14957: p_msg_name => G_FETCHING_INFO,
14958: p_token1 => G_REC_NAME_TOKEN,
14959: p_token1_value => 'OKC_K_LINES_V Record');
14960: RAISE Okc_Api.G_EXCEPTION_ERROR;
14961: END IF;
14962: x_return_status := get_rec_klev(l_lines_rec.id,
14963: lx_klev_rec);

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

15089: l_itiv_ib_tbl_out itiv_tbl_type;
15090: ln_klev_fin_oec OKL_K_LINES_V.OEC%TYPE := 0;
15091: ln_klev_fin_res OKL_K_LINES_V.RESIDUAL_VALUE%TYPE := 0;
15092: ln_klev_fin_cap OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
15093: ln_clev_model_price_unit OKC_K_LINES_V.PRICE_UNIT%TYPE := 0;
15094: ln_cimv_model_no_items OKC_K_ITEMS_V.NUMBER_OF_ITEMS%TYPE := 0;
15095: lv_object_id1_new OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE;
15096: lv_scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE := null;
15097: ln_dummy NUMBER := 0;

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

15126: IS
15127: SELECT CII.SERIAL_NUMBER IB_SERIAL_NUMBER,
15128: CII.INSTANCE_ID
15129: FROM
15130: OKC_K_HEADERS_V OKHV, OKC_K_LINES_V KLE_FA, OKC_LINE_STYLES_B LSE_FA, OKC_K_LINES_B KLE_IL,
15131: OKC_LINE_STYLES_B LSE_IL, OKC_K_LINES_B KLE_IB, OKC_LINE_STYLES_B LSE_IB, OKC_K_ITEMS ITE,
15132: CSI_ITEM_INSTANCES CII
15133: WHERE
15134: kle_fa.chr_id = okhv.id AND lse_fa.id = kle_fa.lse_id AND lse_fa.lty_code = 'FREE_FORM1'

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

15228: l_clev_fin_rec.dnz_chr_id = OKL_API.G_MISS_NUM) THEN
15229: OKL_API.set_message(p_app_name => G_APP_NAME,
15230: p_msg_name => G_REQUIRED_VALUE,
15231: p_token1 => G_COL_NAME_TOKEN,
15232: p_token1_value => 'OKC_K_LINES_V.DNZ_CHR_ID for All Lines');
15233: RAISE OKL_API.G_EXCEPTION_ERROR;
15234: END IF;
15235: --start:| 14-May-2008 cklee Bug 6405415 |
15236: IF l_klev_fin_rec.residual_percentage <> OKL_API.G_MISS_NUM and

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

15249: IF c_get_scs_code%NOTFOUND THEN
15250: OKL_API.set_message(p_app_name => G_APP_NAME,
15251: p_msg_name => G_NO_MATCHING_RECORD,
15252: p_token1 => G_COL_NAME_TOKEN,
15253: p_token1_value => 'OKC_K_LINES_V.DNZ_CHR_ID');
15254: RAISE G_EXCEPTION_HALT_VALIDATION;
15255: END IF;
15256: CLOSE c_get_scs_code;
15257:

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

16189: ln_addon_oec OKL_K_LINES_V.OEC%TYPE := 0;
16190: ln_klev_fin_oec OKL_K_LINES_V.OEC%TYPE := 0;
16191: ln_klev_fin_res OKL_K_LINES_V.RESIDUAL_VALUE%TYPE := 0;
16192: ln_klev_fin_cap OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
16193: ln_clev_model_price_unit OKC_K_LINES_V.PRICE_UNIT%TYPE := 0;
16194: ln_cimv_model_no_items OKC_K_ITEMS_V.NUMBER_OF_ITEMS%TYPE := 0;
16195: lv_object_id1_new OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE;
16196: lv_model_object_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE;
16197: lv_model_object_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE;

Line 16225: okc_k_lines_v cleb_tl

16221: okc_k_lines_b cle_ib,
16222: okc_line_styles_b lse_inst,
16223: okc_k_lines_b cle_inst,
16224: okc_line_styles_b lse_tl,
16225: okc_k_lines_v cleb_tl
16226: where cleb_tl.name = P_asset_number
16227: and cleb_tl.dnz_chr_id = p_dnz_chr_id
16228: and cleb_tl.lse_id = lse_tl.id
16229: and lse_tl.lty_code = G_FIN_LINE_LTY_CODE

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

16319: l_rel_ast_klev_ib_tbl klev_tbl_type;
16320: --End Bug# 3533936
16321:
16322: --Bug# 4161221: start
16323: CURSOR c_addon_line_id(p_model_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
16324: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
16325: SELECT cle.id
16326: FROM okc_k_lines_b cle,
16327: okc_line_styles_b lse

Line 16324: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

16320: --End Bug# 3533936
16321:
16322: --Bug# 4161221: start
16323: CURSOR c_addon_line_id(p_model_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
16324: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
16325: SELECT cle.id
16326: FROM okc_k_lines_b cle,
16327: okc_line_styles_b lse
16328: WHERE cle.dnz_chr_id = p_chr_id

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

16450: l_clev_fin_rec.dnz_chr_id = OKL_API.G_MISS_NUM) THEN
16451: OKL_API.set_message(p_app_name => G_APP_NAME,
16452: p_msg_name => G_REQUIRED_VALUE,
16453: p_token1 => G_COL_NAME_TOKEN,
16454: p_token1_value => 'OKC_K_LINES_V.DNZ_CHR_ID for All Lines');
16455: RAISE OKL_API.G_EXCEPTION_ERROR;
16456: END IF;
16457:
16458:

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

16717: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
16718: OKL_API.set_message(p_app_name => G_APP_NAME,
16719: p_msg_name => G_FETCHING_INFO,
16720: p_token1 => G_REC_NAME_TOKEN,
16721: p_token1_value => 'OKC_K_LINES_V Record');
16722: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
16723: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
16724: OKL_API.set_message(p_app_name => G_APP_NAME,
16725: p_msg_name => G_FETCHING_INFO,

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

16723: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
16724: OKL_API.set_message(p_app_name => G_APP_NAME,
16725: p_msg_name => G_FETCHING_INFO,
16726: p_token1 => G_REC_NAME_TOKEN,
16727: p_token1_value => 'OKC_K_LINES_V Record');
16728: RAISE OKL_API.G_EXCEPTION_ERROR;
16729: END IF;
16730: -- To Get the kle top Line Record
16731: x_return_status := get_rec_klev(l_clev_fin_rec.id,

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

16825: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
16826: OKL_API.set_message(p_app_name => G_APP_NAME,
16827: p_msg_name => G_FETCHING_INFO,
16828: p_token1 => G_REC_NAME_TOKEN,
16829: p_token1_value => 'OKC_K_LINES_V Record');
16830: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
16831: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
16832: OKL_API.set_message(p_app_name => G_APP_NAME,
16833: p_msg_name => G_FETCHING_INFO,

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

16831: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
16832: OKL_API.set_message(p_app_name => G_APP_NAME,
16833: p_msg_name => G_FETCHING_INFO,
16834: p_token1 => G_REC_NAME_TOKEN,
16835: p_token1_value => 'OKC_K_LINES_V Record');
16836: RAISE OKL_API.G_EXCEPTION_ERROR;
16837: END IF;
16838: -- To Get the kle Model Line Record
16839: x_return_status := get_rec_klev(l_clev_model_rec.id,

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

17180: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
17181: OKL_API.set_message(p_app_name => G_APP_NAME,
17182: p_msg_name => G_FETCHING_INFO,
17183: p_token1 => G_REC_NAME_TOKEN,
17184: p_token1_value => 'OKC_K_LINES_V Record');
17185: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
17186: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
17187: OKL_API.set_message(p_app_name => G_APP_NAME,
17188: p_msg_name => G_FETCHING_INFO,

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

17186: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
17187: OKL_API.set_message(p_app_name => G_APP_NAME,
17188: p_msg_name => G_FETCHING_INFO,
17189: p_token1 => G_REC_NAME_TOKEN,
17190: p_token1_value => 'OKC_K_LINES_V Record');
17191: RAISE OKL_API.G_EXCEPTION_ERROR;
17192: END IF;
17193: -- To Get the kle fa Line Record
17194: x_return_status := get_rec_klev(l_clev_fa_rec.id,

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

17392: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
17393: OKL_API.set_message(p_app_name => G_APP_NAME,
17394: p_msg_name => G_FETCHING_INFO,
17395: p_token1 => G_REC_NAME_TOKEN,
17396: p_token1_value => 'OKC_K_LINES_V Record');
17397: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
17398: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
17399: OKL_API.set_message(p_app_name => G_APP_NAME,
17400: p_msg_name => G_FETCHING_INFO,

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

17398: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
17399: OKL_API.set_message(p_app_name => G_APP_NAME,
17400: p_msg_name => G_FETCHING_INFO,
17401: p_token1 => G_REC_NAME_TOKEN,
17402: p_token1_value => 'OKC_K_LINES_V Record');
17403: RAISE OKL_API.G_EXCEPTION_ERROR;
17404: END IF;
17405: -- To Get the kle IB Line Record
17406: x_return_status := get_rec_klev(l_clev_ib_rec.id,

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

17622: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
17623: OKL_API.set_message(p_app_name => G_APP_NAME,
17624: p_msg_name => G_FETCHING_INFO,
17625: p_token1 => G_REC_NAME_TOKEN,
17626: p_token1_value => 'OKC_K_LINES_V Record');
17627: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
17628: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
17629: OKL_API.set_message(p_app_name => G_APP_NAME,
17630: p_msg_name => G_FETCHING_INFO,

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

17628: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
17629: OKL_API.set_message(p_app_name => G_APP_NAME,
17630: p_msg_name => G_FETCHING_INFO,
17631: p_token1 => G_REC_NAME_TOKEN,
17632: p_token1_value => 'OKC_K_LINES_V Record');
17633: RAISE OKL_API.G_EXCEPTION_ERROR;
17634: END IF;
17635: -- To Get the kle IB Line Record
17636: x_return_status := get_rec_klev(l_clev_ib_rec.cle_id,

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

17856: lb_update_oec_required BOOLEAN := FALSE;
17857: ln_item_id OKL_TXL_ITM_INSTS.INVENTORY_ITEM_ID%TYPE;
17858: -- end
17859: ln_final_current_units OKC_K_ITEMS_V.NUMBER_OF_ITEMS%TYPE;
17860: ln_model_line_id OKC_K_LINES_V.ID%TYPE := OKL_API.G_MISS_NUM;
17861: ln_fa_line_id OKC_K_LINES_V.ID%TYPE := OKL_API.G_MISS_NUM;
17862: r_clev_model_rec clev_rec_type;
17863: r_klev_model_rec klev_rec_type;
17864: r_cimv_model_rec cimv_rec_type;

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

17857: ln_item_id OKL_TXL_ITM_INSTS.INVENTORY_ITEM_ID%TYPE;
17858: -- end
17859: ln_final_current_units OKC_K_ITEMS_V.NUMBER_OF_ITEMS%TYPE;
17860: ln_model_line_id OKC_K_LINES_V.ID%TYPE := OKL_API.G_MISS_NUM;
17861: ln_fa_line_id OKC_K_LINES_V.ID%TYPE := OKL_API.G_MISS_NUM;
17862: r_clev_model_rec clev_rec_type;
17863: r_klev_model_rec klev_rec_type;
17864: r_cimv_model_rec cimv_rec_type;
17865: r_clev_addon_rec clev_rec_type;

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

17880: ln_klev_fin_oec OKL_K_LINES_V.OEC%TYPE := 0;
17881: ln_klev_fin_res OKL_K_LINES_V.RESIDUAL_VALUE%TYPE := 0;
17882: ln_klev_fin_cap OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
17883:
17884: CURSOR c_remain_inst_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
17885: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
17886: SELECT count(cle.id)
17887: FROM okc_subclass_top_line stl,
17888: okc_line_styles_b lse2,

Line 17885: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

17881: ln_klev_fin_res OKL_K_LINES_V.RESIDUAL_VALUE%TYPE := 0;
17882: ln_klev_fin_cap OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
17883:
17884: CURSOR c_remain_inst_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
17885: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
17886: SELECT count(cle.id)
17887: FROM okc_subclass_top_line stl,
17888: okc_line_styles_b lse2,
17889: okc_line_styles_b lse1,

Line 17890: okc_k_lines_v cle

17886: SELECT count(cle.id)
17887: FROM okc_subclass_top_line stl,
17888: okc_line_styles_b lse2,
17889: okc_line_styles_b lse1,
17890: okc_k_lines_v cle
17891: WHERE cle.cle_id = p_cle_id
17892: AND cle.dnz_chr_id = p_chr_id
17893: AND cle.lse_id = lse1.id
17894: AND lse1.lty_code = G_INST_LINE_LTY_CODE

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

17896: AND lse2.lty_code = G_FIN_LINE_LTY_CODE
17897: AND lse2.id = stl.lse_id
17898: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE);
17899:
17900: CURSOR c_model_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
17901: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
17902: SELECT cle.id
17903: FROM okc_subclass_top_line stl,
17904: okc_line_styles_b lse2,

Line 17901: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

17897: AND lse2.id = stl.lse_id
17898: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE);
17899:
17900: CURSOR c_model_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
17901: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
17902: SELECT cle.id
17903: FROM okc_subclass_top_line stl,
17904: okc_line_styles_b lse2,
17905: okc_line_styles_b lse1,

Line 17906: okc_k_lines_v cle

17902: SELECT cle.id
17903: FROM okc_subclass_top_line stl,
17904: okc_line_styles_b lse2,
17905: okc_line_styles_b lse1,
17906: okc_k_lines_v cle
17907: WHERE cle.cle_id = p_cle_id
17908: AND cle.dnz_chr_id = p_chr_id
17909: AND cle.lse_id = lse1.id
17910: AND lse1.lty_code = G_MODEL_LINE_LTY_CODE

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

17912: AND lse2.lty_code = G_FIN_LINE_LTY_CODE
17913: AND lse2.id = stl.lse_id
17914: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE);
17915:
17916: CURSOR c_fa_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
17917: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
17918: SELECT cle.id
17919: FROM okc_subclass_top_line stl,
17920: okc_line_styles_b lse2,

Line 17917: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

17913: AND lse2.id = stl.lse_id
17914: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE);
17915:
17916: CURSOR c_fa_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
17917: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
17918: SELECT cle.id
17919: FROM okc_subclass_top_line stl,
17920: okc_line_styles_b lse2,
17921: okc_line_styles_b lse1,

Line 17922: okc_k_lines_v cle

17918: SELECT cle.id
17919: FROM okc_subclass_top_line stl,
17920: okc_line_styles_b lse2,
17921: okc_line_styles_b lse1,
17922: okc_k_lines_v cle
17923: WHERE cle.cle_id = p_cle_id
17924: AND cle.dnz_chr_id = p_chr_id
17925: AND cle.lse_id = lse1.id
17926: AND lse1.lty_code = G_FA_LINE_LTY_CODE

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

17928: AND lse2.lty_code = G_FIN_LINE_LTY_CODE
17929: AND lse2.id = stl.lse_id
17930: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE);
17931:
17932: CURSOR c_addon_line_id(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
17933: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
17934: SELECT cle.id
17935: FROM okc_subclass_top_line stl,
17936: okc_line_styles_b lse3,

Line 17933: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

17929: AND lse2.id = stl.lse_id
17930: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE);
17931:
17932: CURSOR c_addon_line_id(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
17933: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
17934: SELECT cle.id
17935: FROM okc_subclass_top_line stl,
17936: okc_line_styles_b lse3,
17937: okc_line_styles_b lse2,

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

17959: AND lse2.lty_code = G_FIN_LINE_LTY_CODE
17960: AND lse2.id = stl.lse_id
17961: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE));
17962:
17963: CURSOR c_model_item(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
17964: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
17965: SELECT cim.number_of_items
17966: FROM okc_subclass_top_line stl,
17967: okc_line_styles_b lse2,

Line 17964: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

17960: AND lse2.id = stl.lse_id
17961: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE));
17962:
17963: CURSOR c_model_item(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
17964: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
17965: SELECT cim.number_of_items
17966: FROM okc_subclass_top_line stl,
17967: okc_line_styles_b lse2,
17968: okc_line_styles_b lse1,

Line 17970: okc_k_lines_v cle

17966: FROM okc_subclass_top_line stl,
17967: okc_line_styles_b lse2,
17968: okc_line_styles_b lse1,
17969: okc_k_items_v cim,
17970: okc_k_lines_v cle
17971: WHERE cle.cle_id = p_cle_id
17972: AND cle.dnz_chr_id = p_chr_id
17973: AND cle.id = cim.cle_id
17974: AND cim.dnz_chr_id = cle.dnz_chr_id

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

18030: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
18031: OKL_API.set_message(p_app_name => G_APP_NAME,
18032: p_msg_name => G_FETCHING_INFO,
18033: p_token1 => G_REC_NAME_TOKEN,
18034: p_token1_value => 'OKC_K_LINES_V Record');
18035: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
18036: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
18037: OKL_API.set_message(p_app_name => G_APP_NAME,
18038: p_msg_name => G_FETCHING_INFO,

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

18036: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
18037: OKL_API.set_message(p_app_name => G_APP_NAME,
18038: p_msg_name => G_FETCHING_INFO,
18039: p_token1 => G_REC_NAME_TOKEN,
18040: p_token1_value => 'OKC_K_LINES_V Record');
18041: RAISE OKL_API.G_EXCEPTION_ERROR;
18042: END IF;
18043: -- Now getting the inst line
18044: x_return_status := get_rec_clev(l_clev_ib_rec.cle_id,

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

18046: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
18047: OKL_API.set_message(p_app_name => G_APP_NAME,
18048: p_msg_name => G_FETCHING_INFO,
18049: p_token1 => G_REC_NAME_TOKEN,
18050: p_token1_value => 'OKC_K_LINES_V Record');
18051: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
18052: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
18053: OKL_API.set_message(p_app_name => G_APP_NAME,
18054: p_msg_name => G_FETCHING_INFO,

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

18052: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
18053: OKL_API.set_message(p_app_name => G_APP_NAME,
18054: p_msg_name => G_FETCHING_INFO,
18055: p_token1 => G_REC_NAME_TOKEN,
18056: p_token1_value => 'OKC_K_LINES_V Record');
18057: RAISE OKL_API.G_EXCEPTION_ERROR;
18058: END IF;
18059:
18060: -- Since a record is already created in TXL_ITM_INSTS, we need to update this

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

18071: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
18072: OKL_API.set_message(p_app_name => G_APP_NAME,
18073: p_msg_name => G_FETCHING_INFO,
18074: p_token1 => G_REC_NAME_TOKEN,
18075: p_token1_value => 'OKC_K_LINES_V Record');
18076: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
18077: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
18078: OKL_API.set_message(p_app_name => G_APP_NAME,
18079: p_msg_name => G_FETCHING_INFO,

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

18077: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
18078: OKL_API.set_message(p_app_name => G_APP_NAME,
18079: p_msg_name => G_FETCHING_INFO,
18080: p_token1 => G_REC_NAME_TOKEN,
18081: p_token1_value => 'OKC_K_LINES_V Record');
18082: RAISE OKL_API.G_EXCEPTION_ERROR;
18083: END IF;
18084: -- checking for mfg_serial_number_yn flag
18085: k := l_itiv_ib_tbl.FIRST;

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

18417: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
18418: OKL_API.set_message(p_app_name => G_APP_NAME,
18419: p_msg_name => G_FETCHING_INFO,
18420: p_token1 => G_REC_NAME_TOKEN,
18421: p_token1_value => 'OKC_K_LINES_V Record');
18422: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
18423: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
18424: OKL_API.set_message(p_app_name => G_APP_NAME,
18425: p_msg_name => G_FETCHING_INFO,

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

18423: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
18424: OKL_API.set_message(p_app_name => G_APP_NAME,
18425: p_msg_name => G_FETCHING_INFO,
18426: p_token1 => G_REC_NAME_TOKEN,
18427: p_token1_value => 'OKC_K_LINES_V Record');
18428: RAISE OKL_API.G_EXCEPTION_ERROR;
18429: END IF;
18430:
18431: -- To Get the kle Model Line Record

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

18503: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
18504: OKL_API.set_message(p_app_name => G_APP_NAME,
18505: p_msg_name => G_FETCHING_INFO,
18506: p_token1 => G_REC_NAME_TOKEN,
18507: p_token1_value => 'OKC_K_LINES_V Record');
18508: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
18509: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
18510: OKL_API.set_message(p_app_name => G_APP_NAME,
18511: p_msg_name => G_FETCHING_INFO,

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

18509: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
18510: OKL_API.set_message(p_app_name => G_APP_NAME,
18511: p_msg_name => G_FETCHING_INFO,
18512: p_token1 => G_REC_NAME_TOKEN,
18513: p_token1_value => 'OKC_K_LINES_V Record');
18514: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
18515: END IF;
18516: -- To Get the kle Model Line Record
18517: x_return_status := get_rec_klev(r_addon_line_id.id,

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

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

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

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

Line 18854: p_top_line_id IN OKC_K_LINES_V.ID%TYPE,

18850: x_msg_count OUT NOCOPY NUMBER,
18851: x_msg_data OUT NOCOPY VARCHAR2,
18852: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
18853: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
18854: p_top_line_id IN OKC_K_LINES_V.ID%TYPE,
18855: p_dnz_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
18856: p_itiv_ib_tbl IN itiv_tbl_type,
18857: x_clev_ib_tbl OUT NOCOPY clev_tbl_type,
18858: x_itiv_ib_tbl OUT NOCOPY itiv_tbl_type) IS

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

18870: l_klev_ib_rec_out klev_rec_type;
18871: l_cimv_ib_rec_out cimv_rec_type;
18872: l_trxv_ib_rec_out trxv_rec_type;
18873: ln_remain_inst NUMBER := 0;
18874: ln_model_line_id OKC_K_LINES_V.ID%TYPE := OKL_API.G_MISS_NUM;
18875: lv_object_id1_new OKL_TXL_ITM_INSTS.OBJECT_ID1_NEW%TYPE := OKL_API.G_MISS_CHAR;
18876: ln_fa_line_id OKC_K_LINES_V.ID%TYPE := OKL_API.G_MISS_NUM;
18877: r_clev_model_rec clev_rec_type;
18878: r_klev_model_rec klev_rec_type;

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

18872: l_trxv_ib_rec_out trxv_rec_type;
18873: ln_remain_inst NUMBER := 0;
18874: ln_model_line_id OKC_K_LINES_V.ID%TYPE := OKL_API.G_MISS_NUM;
18875: lv_object_id1_new OKL_TXL_ITM_INSTS.OBJECT_ID1_NEW%TYPE := OKL_API.G_MISS_CHAR;
18876: ln_fa_line_id OKC_K_LINES_V.ID%TYPE := OKL_API.G_MISS_NUM;
18877: r_clev_model_rec clev_rec_type;
18878: r_klev_model_rec klev_rec_type;
18879: r_cimv_model_rec cimv_rec_type;
18880: r_clev_fa_rec clev_rec_type;

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

18900: rx_klev_addon_rec klev_rec_type;
18901: rx_cimv_addon_rec cimv_rec_type;
18902: ln_model_item OKL_TXL_ITM_INSTS.INVENTORY_ITEM_ID%TYPE;
18903:
18904: CURSOR c_remain_inst_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
18905: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18906: SELECT count(cle.id)
18907: FROM okc_subclass_top_line stl,
18908: okc_line_styles_b lse2,

Line 18905: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

18901: rx_cimv_addon_rec cimv_rec_type;
18902: ln_model_item OKL_TXL_ITM_INSTS.INVENTORY_ITEM_ID%TYPE;
18903:
18904: CURSOR c_remain_inst_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
18905: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18906: SELECT count(cle.id)
18907: FROM okc_subclass_top_line stl,
18908: okc_line_styles_b lse2,
18909: okc_line_styles_b lse1,

Line 18910: okc_k_lines_v cle

18906: SELECT count(cle.id)
18907: FROM okc_subclass_top_line stl,
18908: okc_line_styles_b lse2,
18909: okc_line_styles_b lse1,
18910: okc_k_lines_v cle
18911: WHERE cle.cle_id = p_cle_id
18912: AND cle.dnz_chr_id = p_chr_id
18913: AND cle.lse_id = lse1.id
18914: AND lse1.lty_code = G_INST_LINE_LTY_CODE

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

18916: AND lse2.lty_code = G_FIN_LINE_LTY_CODE
18917: AND lse2.id = stl.lse_id
18918: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE);
18919:
18920: CURSOR c_model_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
18921: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18922: SELECT cle.id
18923: FROM okc_subclass_top_line stl,
18924: okc_line_styles_b lse2,

Line 18921: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

18917: AND lse2.id = stl.lse_id
18918: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE);
18919:
18920: CURSOR c_model_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
18921: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18922: SELECT cle.id
18923: FROM okc_subclass_top_line stl,
18924: okc_line_styles_b lse2,
18925: okc_line_styles_b lse1,

Line 18926: okc_k_lines_v cle

18922: SELECT cle.id
18923: FROM okc_subclass_top_line stl,
18924: okc_line_styles_b lse2,
18925: okc_line_styles_b lse1,
18926: okc_k_lines_v cle
18927: WHERE cle.cle_id = p_cle_id
18928: AND cle.dnz_chr_id = p_chr_id
18929: AND cle.lse_id = lse1.id
18930: AND lse1.lty_code = G_MODEL_LINE_LTY_CODE

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

18932: AND lse2.lty_code = G_FIN_LINE_LTY_CODE
18933: AND lse2.id = stl.lse_id
18934: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE);
18935:
18936: CURSOR c_model_item(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
18937: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18938: SELECT cim.object1_id1
18939: FROM okc_subclass_top_line stl,
18940: okc_line_styles_b lse2,

Line 18937: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

18933: AND lse2.id = stl.lse_id
18934: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE);
18935:
18936: CURSOR c_model_item(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
18937: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18938: SELECT cim.object1_id1
18939: FROM okc_subclass_top_line stl,
18940: okc_line_styles_b lse2,
18941: okc_line_styles_b lse1,

Line 18943: okc_k_lines_v cle

18939: FROM okc_subclass_top_line stl,
18940: okc_line_styles_b lse2,
18941: okc_line_styles_b lse1,
18942: okc_k_items cim,
18943: okc_k_lines_v cle
18944: WHERE cle.cle_id = p_cle_id
18945: AND cle.dnz_chr_id = p_chr_id
18946: AND cle.lse_id = lse1.id
18947: AND lse1.lty_code = G_MODEL_LINE_LTY_CODE

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

18952: AND cle.id = cim.cle_id
18953: AND cim.dnz_chr_id = cle.dnz_chr_id
18954: AND cim.jtot_object1_code = 'OKX_SYSITEM';
18955:
18956: CURSOR c_fa_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
18957: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18958: SELECT cle.id
18959: FROM okc_subclass_top_line stl,
18960: okc_line_styles_b lse2,

Line 18957: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

18953: AND cim.dnz_chr_id = cle.dnz_chr_id
18954: AND cim.jtot_object1_code = 'OKX_SYSITEM';
18955:
18956: CURSOR c_fa_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
18957: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18958: SELECT cle.id
18959: FROM okc_subclass_top_line stl,
18960: okc_line_styles_b lse2,
18961: okc_line_styles_b lse1,

Line 18962: okc_k_lines_v cle

18958: SELECT cle.id
18959: FROM okc_subclass_top_line stl,
18960: okc_line_styles_b lse2,
18961: okc_line_styles_b lse1,
18962: okc_k_lines_v cle
18963: WHERE cle.cle_id = p_cle_id
18964: AND cle.dnz_chr_id = p_chr_id
18965: AND cle.lse_id = lse1.id
18966: AND lse1.lty_code = G_FA_LINE_LTY_CODE

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

18968: AND lse2.lty_code = G_FIN_LINE_LTY_CODE
18969: AND lse2.id = stl.lse_id
18970: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE);
18971:
18972: CURSOR c_addon_line_id(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
18973: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18974: SELECT cle.id
18975: FROM okc_subclass_top_line stl,
18976: okc_line_styles_b lse3,

Line 18973: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

18969: AND lse2.id = stl.lse_id
18970: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE);
18971:
18972: CURSOR c_addon_line_id(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
18973: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18974: SELECT cle.id
18975: FROM okc_subclass_top_line stl,
18976: okc_line_styles_b lse3,
18977: okc_line_styles_b lse2,

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

19312: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
19313: OKL_API.set_message(p_app_name => G_APP_NAME,
19314: p_msg_name => G_FETCHING_INFO,
19315: p_token1 => G_REC_NAME_TOKEN,
19316: p_token1_value => 'OKC_K_LINES_V Record');
19317: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
19318: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
19319: OKL_API.set_message(p_app_name => G_APP_NAME,
19320: p_msg_name => G_FETCHING_INFO,

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

19318: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
19319: OKL_API.set_message(p_app_name => G_APP_NAME,
19320: p_msg_name => G_FETCHING_INFO,
19321: p_token1 => G_REC_NAME_TOKEN,
19322: p_token1_value => 'OKC_K_LINES_V Record');
19323: RAISE OKL_API.G_EXCEPTION_ERROR;
19324: END IF;
19325: -- To Get the kle Model Line Record
19326: x_return_status := get_rec_klev(ln_model_line_id,

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

19393: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
19394: OKL_API.set_message(p_app_name => G_APP_NAME,
19395: p_msg_name => G_FETCHING_INFO,
19396: p_token1 => G_REC_NAME_TOKEN,
19397: p_token1_value => 'OKC_K_LINES_V Record');
19398: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
19399: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
19400: OKL_API.set_message(p_app_name => G_APP_NAME,
19401: p_msg_name => G_FETCHING_INFO,

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

19399: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
19400: OKL_API.set_message(p_app_name => G_APP_NAME,
19401: p_msg_name => G_FETCHING_INFO,
19402: p_token1 => G_REC_NAME_TOKEN,
19403: p_token1_value => 'OKC_K_LINES_V Record');
19404: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
19405: END IF;
19406: -- To Get the kle Model Line Record
19407: x_return_status := get_rec_klev(r_addon_line_id.id,

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

19536: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
19537: OKL_API.set_message(p_app_name => G_APP_NAME,
19538: p_msg_name => G_FETCHING_INFO,
19539: p_token1 => G_REC_NAME_TOKEN,
19540: p_token1_value => 'OKC_K_LINES_V Record');
19541: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
19542: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
19543: OKL_API.set_message(p_app_name => G_APP_NAME,
19544: p_msg_name => G_FETCHING_INFO,

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

19542: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
19543: OKL_API.set_message(p_app_name => G_APP_NAME,
19544: p_msg_name => G_FETCHING_INFO,
19545: p_token1 => G_REC_NAME_TOKEN,
19546: p_token1_value => 'OKC_K_LINES_V Record');
19547: RAISE OKL_API.G_EXCEPTION_ERROR;
19548: END IF;
19549: -- To Get the kle fa Line Record
19550: x_return_status := get_rec_klev(ln_fa_line_id,

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

19774: l_clev_ib_tbl clev_tbl_type := p_clev_ib_tbl;
19775: l_clev_ib_rec clev_rec_type;
19776: l_clev_inst_rec clev_rec_type;
19777: ln_remain_inst NUMBER := 0;
19778: ln_model_line_id OKC_K_LINES_V.ID%TYPE := OKL_API.G_MISS_NUM;
19779: ln_fa_line_id OKC_K_LINES_V.ID%TYPE := OKL_API.G_MISS_NUM;
19780: r_clev_model_rec clev_rec_type;
19781: r_klev_model_rec klev_rec_type;
19782: r_cimv_model_rec cimv_rec_type;

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

19775: l_clev_ib_rec clev_rec_type;
19776: l_clev_inst_rec clev_rec_type;
19777: ln_remain_inst NUMBER := 0;
19778: ln_model_line_id OKC_K_LINES_V.ID%TYPE := OKL_API.G_MISS_NUM;
19779: ln_fa_line_id OKC_K_LINES_V.ID%TYPE := OKL_API.G_MISS_NUM;
19780: r_clev_model_rec clev_rec_type;
19781: r_klev_model_rec klev_rec_type;
19782: r_cimv_model_rec cimv_rec_type;
19783: r_clev_fa_rec clev_rec_type;

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

19804: l_itiv_rec itiv_rec_type;
19805: lx_itiv_rec itiv_rec_type;
19806: -- end
19807:
19808: CURSOR c_remain_inst_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
19809: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
19810: SELECT count(cle.id)
19811: FROM okc_line_styles_b lse2,
19812: okc_line_styles_b lse1,

Line 19809: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

19805: lx_itiv_rec itiv_rec_type;
19806: -- end
19807:
19808: CURSOR c_remain_inst_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
19809: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
19810: SELECT count(cle.id)
19811: FROM okc_line_styles_b lse2,
19812: okc_line_styles_b lse1,
19813: okc_k_lines_v cle

Line 19813: okc_k_lines_v cle

19809: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
19810: SELECT count(cle.id)
19811: FROM okc_line_styles_b lse2,
19812: okc_line_styles_b lse1,
19813: okc_k_lines_v cle
19814: WHERE cle.cle_id = p_cle_id
19815: AND cle.dnz_chr_id = p_chr_id
19816: AND cle.lse_id = lse1.id
19817: AND lse1.lty_code = G_INST_LINE_LTY_CODE

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

19817: AND lse1.lty_code = G_INST_LINE_LTY_CODE
19818: AND lse1.lse_parent_id = lse2.id
19819: AND lse2.lty_code = G_FIN_LINE_LTY_CODE;
19820:
19821: CURSOR c_model_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
19822: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
19823: SELECT cle.id
19824: FROM okc_subclass_top_line stl,
19825: okc_line_styles_b lse2,

Line 19822: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

19818: AND lse1.lse_parent_id = lse2.id
19819: AND lse2.lty_code = G_FIN_LINE_LTY_CODE;
19820:
19821: CURSOR c_model_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
19822: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
19823: SELECT cle.id
19824: FROM okc_subclass_top_line stl,
19825: okc_line_styles_b lse2,
19826: okc_line_styles_b lse1,

Line 19827: okc_k_lines_v cle

19823: SELECT cle.id
19824: FROM okc_subclass_top_line stl,
19825: okc_line_styles_b lse2,
19826: okc_line_styles_b lse1,
19827: okc_k_lines_v cle
19828: WHERE cle.cle_id = p_cle_id
19829: AND cle.dnz_chr_id = p_chr_id
19830: AND cle.lse_id = lse1.id
19831: AND lse1.lty_code = G_MODEL_LINE_LTY_CODE

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

19833: AND lse2.lty_code = G_FIN_LINE_LTY_CODE
19834: AND lse2.id = stl.lse_id
19835: AND stl.scs_code = 'LEASE';
19836:
19837: CURSOR c_fa_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
19838: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
19839: SELECT cle.id
19840: FROM okc_subclass_top_line stl,
19841: okc_line_styles_b lse2,

Line 19838: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

19834: AND lse2.id = stl.lse_id
19835: AND stl.scs_code = 'LEASE';
19836:
19837: CURSOR c_fa_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
19838: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
19839: SELECT cle.id
19840: FROM okc_subclass_top_line stl,
19841: okc_line_styles_b lse2,
19842: okc_line_styles_b lse1,

Line 19843: okc_k_lines_v cle

19839: SELECT cle.id
19840: FROM okc_subclass_top_line stl,
19841: okc_line_styles_b lse2,
19842: okc_line_styles_b lse1,
19843: okc_k_lines_v cle
19844: WHERE cle.cle_id = p_cle_id
19845: AND cle.dnz_chr_id = p_chr_id
19846: AND cle.lse_id = lse1.id
19847: AND lse1.lty_code = G_FA_LINE_LTY_CODE

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

19849: AND lse2.lty_code = G_FIN_LINE_LTY_CODE
19850: AND lse2.id = stl.lse_id
19851: AND stl.scs_code = 'LEASE';
19852:
19853: CURSOR c_addon_line_id(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
19854: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
19855: SELECT cle.id
19856: FROM okc_subclass_top_line stl,
19857: okc_line_styles_b lse3,

Line 19854: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

19850: AND lse2.id = stl.lse_id
19851: AND stl.scs_code = 'LEASE';
19852:
19853: CURSOR c_addon_line_id(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
19854: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
19855: SELECT cle.id
19856: FROM okc_subclass_top_line stl,
19857: okc_line_styles_b lse3,
19858: okc_line_styles_b lse2,

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

19942: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
19943: OKL_API.set_message(p_app_name => G_APP_NAME,
19944: p_msg_name => G_FETCHING_INFO,
19945: p_token1 => G_REC_NAME_TOKEN,
19946: p_token1_value => 'OKC_K_LINES_V Record');
19947: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
19948: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
19949: OKL_API.set_message(p_app_name => G_APP_NAME,
19950: p_msg_name => G_FETCHING_INFO,

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

19948: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
19949: OKL_API.set_message(p_app_name => G_APP_NAME,
19950: p_msg_name => G_FETCHING_INFO,
19951: p_token1 => G_REC_NAME_TOKEN,
19952: p_token1_value => 'OKC_K_LINES_V Record');
19953: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
19954: END IF;
19955: x_return_status := get_rec_clev(l_clev_ib_rec.cle_id,
19956: l_clev_inst_rec);

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

19957: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
19958: OKL_API.set_message(p_app_name => G_APP_NAME,
19959: p_msg_name => G_FETCHING_INFO,
19960: p_token1 => G_REC_NAME_TOKEN,
19961: p_token1_value => 'OKC_K_LINES_V Record');
19962: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
19963: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
19964: OKL_API.set_message(p_app_name => G_APP_NAME,
19965: p_msg_name => G_FETCHING_INFO,

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

19963: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
19964: OKL_API.set_message(p_app_name => G_APP_NAME,
19965: p_msg_name => G_FETCHING_INFO,
19966: p_token1 => G_REC_NAME_TOKEN,
19967: p_token1_value => 'OKC_K_LINES_V Record');
19968: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
19969: END IF;
19970:
19971: -- we should get the remaining inst line , so that we can update

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

19989: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
19990: OKL_API.set_message(p_app_name => G_APP_NAME,
19991: p_msg_name => G_FETCHING_INFO,
19992: p_token1 => G_REC_NAME_TOKEN,
19993: p_token1_value => 'OKC_K_LINES_V Record');
19994: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
19995: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
19996: OKL_API.set_message(p_app_name => G_APP_NAME,
19997: p_msg_name => G_FETCHING_INFO,

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

19995: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
19996: OKL_API.set_message(p_app_name => G_APP_NAME,
19997: p_msg_name => G_FETCHING_INFO,
19998: p_token1 => G_REC_NAME_TOKEN,
19999: p_token1_value => 'OKC_K_LINES_V Record');
20000: RAISE OKL_API.G_EXCEPTION_ERROR;
20001: END IF;
20002:
20003: l_itiv_rec.mfg_serial_number_yn := 'N';

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

20123: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
20124: OKL_API.set_message(p_app_name => G_APP_NAME,
20125: p_msg_name => G_FETCHING_INFO,
20126: p_token1 => G_REC_NAME_TOKEN,
20127: p_token1_value => 'OKC_K_LINES_V Record');
20128: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
20129: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
20130: OKL_API.set_message(p_app_name => G_APP_NAME,
20131: p_msg_name => G_FETCHING_INFO,

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

20129: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
20130: OKL_API.set_message(p_app_name => G_APP_NAME,
20131: p_msg_name => G_FETCHING_INFO,
20132: p_token1 => G_REC_NAME_TOKEN,
20133: p_token1_value => 'OKC_K_LINES_V Record');
20134: RAISE OKL_API.G_EXCEPTION_ERROR;
20135: END IF;
20136: -- To Get the kle Model Line Record
20137: x_return_status := get_rec_klev(ln_model_line_id,

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

20204: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
20205: OKL_API.set_message(p_app_name => G_APP_NAME,
20206: p_msg_name => G_FETCHING_INFO,
20207: p_token1 => G_REC_NAME_TOKEN,
20208: p_token1_value => 'OKC_K_LINES_V Record');
20209: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
20210: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
20211: OKL_API.set_message(p_app_name => G_APP_NAME,
20212: p_msg_name => G_FETCHING_INFO,

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

20210: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
20211: OKL_API.set_message(p_app_name => G_APP_NAME,
20212: p_msg_name => G_FETCHING_INFO,
20213: p_token1 => G_REC_NAME_TOKEN,
20214: p_token1_value => 'OKC_K_LINES_V Record');
20215: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
20216: END IF;
20217: -- To Get the kle Model Line Record
20218: x_return_status := get_rec_klev(r_addon_line_id.id,

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

20347: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
20348: OKL_API.set_message(p_app_name => G_APP_NAME,
20349: p_msg_name => G_FETCHING_INFO,
20350: p_token1 => G_REC_NAME_TOKEN,
20351: p_token1_value => 'OKC_K_LINES_V Record');
20352: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
20353: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
20354: OKL_API.set_message(p_app_name => G_APP_NAME,
20355: p_msg_name => G_FETCHING_INFO,

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

20353: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
20354: OKL_API.set_message(p_app_name => G_APP_NAME,
20355: p_msg_name => G_FETCHING_INFO,
20356: p_token1 => G_REC_NAME_TOKEN,
20357: p_token1_value => 'OKC_K_LINES_V Record');
20358: RAISE OKL_API.G_EXCEPTION_ERROR;
20359: END IF;
20360: -- To Get the kle fa Line Record
20361: x_return_status := get_rec_klev(ln_fa_line_id,