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 576: FUNCTION isContractActive(p_dnz_chr_id IN OKL_K_HEADERS_FULL_V.ID%TYPE DEFAULT OKL_API.G_MISS_NUM,

572: exists in TXL, the information should be retrieved from there. If it exists at
573: both places, it is error.
574: */
575:
576: FUNCTION isContractActive(p_dnz_chr_id IN OKL_K_HEADERS_FULL_V.ID%TYPE DEFAULT OKL_API.G_MISS_NUM,
577: p_deal_type IN OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
578: p_sts_code IN OKL_K_HEADERS_FULL_V.STS_CODE%TYPE)
579: RETURN BOOLEAN IS
580: l_active_status BOOLEAN := FALSE;

Line 577: p_deal_type IN OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,

573: both places, it is error.
574: */
575:
576: FUNCTION isContractActive(p_dnz_chr_id IN OKL_K_HEADERS_FULL_V.ID%TYPE DEFAULT OKL_API.G_MISS_NUM,
577: p_deal_type IN OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
578: p_sts_code IN OKL_K_HEADERS_FULL_V.STS_CODE%TYPE)
579: RETURN BOOLEAN IS
580: l_active_status BOOLEAN := FALSE;
581: l_inactive_status BOOLEAN := FALSE;

Line 578: p_sts_code IN OKL_K_HEADERS_FULL_V.STS_CODE%TYPE)

574: */
575:
576: FUNCTION isContractActive(p_dnz_chr_id IN OKL_K_HEADERS_FULL_V.ID%TYPE DEFAULT OKL_API.G_MISS_NUM,
577: p_deal_type IN OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
578: p_sts_code IN OKL_K_HEADERS_FULL_V.STS_CODE%TYPE)
579: RETURN BOOLEAN IS
580: l_active_status BOOLEAN := FALSE;
581: l_inactive_status BOOLEAN := FALSE;
582: l_release_asset_contract BOOLEAN := FALSE;

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

581: l_inactive_status BOOLEAN := FALSE;
582: l_release_asset_contract BOOLEAN := FALSE;
583: l_status_active BOOLEAN := FALSE;
584: l_return_value VARCHAR2(1) := '';
585: CURSOR c_check_assets_in_fa(p_dnz_chr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
586: SELECT 'x'
587: /* FROM dual
588: WHERE exists
589: (SELECT (1) */

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

602: --START:| 14-Mar-2006 cklee Fixed bug#4905107 |
603: -- AND sts.ste_code not in ('HOLD','EXPIRED','TERMINATED','CANCELLED');--);
604: --END:| 14-Mar-2006 cklee Fixed bug#4905107 |
605:
606: CURSOR c_check_info_in_ib(p_dnz_chr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
607: SELECT 'x'
608: /* FROM dual
609: WHERE exists
610: (SELECT (1) */

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

623: --START:| 14-Mar-2006 cklee Fixed bug#4905107 |
624: -- AND sts.ste_code not in ('HOLD','EXPIRED','TERMINATED','CANCELLED');--);
625: --END:| 14-Mar-2006 cklee Fixed bug#4905107 |
626:
627: CURSOR c_check_assets_in_txl(p_dnz_chr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
628: SELECT 'x'
629: /* FROM dual
630: WHERE exists
631: (SELECT (1) */

Line 745: lv_deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE;

741: AS
742: l_api_version CONSTANT NUMBER := 1;
743: l_api_name CONSTANT VARCHAR2(30) := 'VERSION_CONTRACT';
744: lv_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE;
745: lv_deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE;
746: i NUMBER := 0;
747: l_las_rec las_rec_type := p_las_rec;
748: l_active_contract BOOLEAN := FALSE;
749: l_info_exists BOOLEAN := FALSE;

Line 1112: -- FROM OKL_K_HEADERS_FULL_V chr,

1108: CURSOR c_get_sts_code(p_chr_id OKC_K_HEADERS_V.ID%TYPE)
1109: IS
1110: SELECT st.ste_code,
1111: khr.deal_type
1112: -- FROM OKL_K_HEADERS_FULL_V chr,
1113: FROM okc_k_headers_b chr,
1114: okl_k_headers khr,
1115: okc_statuses_b st
1116: WHERE khr.id = chr.id

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

1116: WHERE khr.id = chr.id
1117: and chr.id = p_chr_id
1118: and st.code = chr.sts_code;
1119:
1120: CURSOR c_check_assets_in_fa(p_dnz_chr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
1121: SELECT 'x'
1122: /*FROM dual
1123: WHERE exists
1124: (SELECT (1)*/