APPS.OKL_LA_ASSET_PVT dependencies on OKL_K_HEADERS_FULL_V

Line 496: FUNCTION isReleaseAssetContract(p_dnz_chr_id IN OKL_K_HEADERS_FULL_V.ID%TYPE DEFAULT OKL_API.G_MISS_NUM)

492: end validate_asset_rec;
493:
494: -----------------------------------------------------------------------------------------------------------
495:
496: FUNCTION isReleaseAssetContract(p_dnz_chr_id IN OKL_K_HEADERS_FULL_V.ID%TYPE DEFAULT OKL_API.G_MISS_NUM)
497: RETURN BOOLEAN IS
498: l_status_active BOOLEAN := FALSE;
499: l_return_value VARCHAR2(1) := '';
500: --cursor to check if contract has re-lease assets

Line 549: FUNCTION isContractActive(p_dnz_chr_id IN OKL_K_HEADERS_FULL_V.ID%TYPE DEFAULT OKL_API.G_MISS_NUM,

545: exists in TXL, the information should be retrieved from there. If it exists at
546: both places, it is error.
547: */
548:
549: FUNCTION isContractActive(p_dnz_chr_id IN OKL_K_HEADERS_FULL_V.ID%TYPE DEFAULT OKL_API.G_MISS_NUM,
550: p_deal_type IN OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
551: p_sts_code IN OKL_K_HEADERS_FULL_V.STS_CODE%TYPE)
552: RETURN BOOLEAN IS
553: l_active_status BOOLEAN := FALSE;

Line 550: p_deal_type IN OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,

546: both places, it is error.
547: */
548:
549: FUNCTION isContractActive(p_dnz_chr_id IN OKL_K_HEADERS_FULL_V.ID%TYPE DEFAULT OKL_API.G_MISS_NUM,
550: p_deal_type IN OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
551: p_sts_code IN OKL_K_HEADERS_FULL_V.STS_CODE%TYPE)
552: RETURN BOOLEAN IS
553: l_active_status BOOLEAN := FALSE;
554: l_inactive_status BOOLEAN := FALSE;

Line 551: p_sts_code IN OKL_K_HEADERS_FULL_V.STS_CODE%TYPE)

547: */
548:
549: FUNCTION isContractActive(p_dnz_chr_id IN OKL_K_HEADERS_FULL_V.ID%TYPE DEFAULT OKL_API.G_MISS_NUM,
550: p_deal_type IN OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
551: p_sts_code IN OKL_K_HEADERS_FULL_V.STS_CODE%TYPE)
552: RETURN BOOLEAN IS
553: l_active_status BOOLEAN := FALSE;
554: l_inactive_status BOOLEAN := FALSE;
555: l_release_asset_contract BOOLEAN := FALSE;

Line 558: CURSOR c_check_assets_in_fa(p_dnz_chr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS

554: l_inactive_status BOOLEAN := FALSE;
555: l_release_asset_contract BOOLEAN := FALSE;
556: l_status_active BOOLEAN := FALSE;
557: l_return_value VARCHAR2(1) := '';
558: CURSOR c_check_assets_in_fa(p_dnz_chr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
559: SELECT 'x'
560: /* FROM dual
561: WHERE exists
562: (SELECT (1) */

Line 579: CURSOR c_check_info_in_ib(p_dnz_chr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS

575: --START:| 14-Mar-2006 cklee Fixed bug#4905107 |
576: -- AND sts.ste_code not in ('HOLD','EXPIRED','TERMINATED','CANCELLED');--);
577: --END:| 14-Mar-2006 cklee Fixed bug#4905107 |
578:
579: CURSOR c_check_info_in_ib(p_dnz_chr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
580: SELECT 'x'
581: /* FROM dual
582: WHERE exists
583: (SELECT (1) */

Line 600: CURSOR c_check_assets_in_txl(p_dnz_chr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS

596: --START:| 14-Mar-2006 cklee Fixed bug#4905107 |
597: -- AND sts.ste_code not in ('HOLD','EXPIRED','TERMINATED','CANCELLED');--);
598: --END:| 14-Mar-2006 cklee Fixed bug#4905107 |
599:
600: CURSOR c_check_assets_in_txl(p_dnz_chr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
601: SELECT 'x'
602: /* FROM dual
603: WHERE exists
604: (SELECT (1) */

Line 717: lv_deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE;

713: AS
714: l_api_version CONSTANT NUMBER := 1;
715: l_api_name CONSTANT VARCHAR2(30) := 'VERSION_CONTRACT';
716: lv_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE;
717: lv_deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE;
718: i NUMBER := 0;
719: l_las_rec las_rec_type := p_las_rec;
720: l_active_contract BOOLEAN := FALSE;
721: l_info_exists BOOLEAN := FALSE;

Line 1084: -- FROM OKL_K_HEADERS_FULL_V chr,

1080: CURSOR c_get_sts_code(p_chr_id OKC_K_HEADERS_V.ID%TYPE)
1081: IS
1082: SELECT st.ste_code,
1083: khr.deal_type
1084: -- FROM OKL_K_HEADERS_FULL_V chr,
1085: FROM okc_k_headers_b chr,
1086: okl_k_headers khr,
1087: okc_statuses_b st
1088: WHERE khr.id = chr.id

Line 1092: CURSOR c_check_assets_in_fa(p_dnz_chr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS

1088: WHERE khr.id = chr.id
1089: and chr.id = p_chr_id
1090: and st.code = chr.sts_code;
1091:
1092: CURSOR c_check_assets_in_fa(p_dnz_chr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
1093: SELECT 'x'
1094: /*FROM dual
1095: WHERE exists
1096: (SELECT (1)*/