DBA Data[Home] [Help]

APPS.OKL_QA_DATA_INTEGRITY dependencies on OKL_LLA_UTIL_PVT

Line 4964: IF (TRUNC(Okl_Lla_Util_Pvt.calculate_end_date(l_strm_sll_start_date, l_strm_sll_periods*l_strm_sll.mpp,l_start_day, l_end_date ))) --Bug#5441811

4960:
4961: ELSE
4962: -- START: cklee/mvasudev,06-02-2005,Bug#4392051/okl. 4437938
4963: --IF (TRUNC(ADD_MONTHS(l_strm_sll_start_date, l_strm_sll_periods*l_strm_sll.mpp) - 1))
4964: IF (TRUNC(Okl_Lla_Util_Pvt.calculate_end_date(l_strm_sll_start_date, l_strm_sll_periods*l_strm_sll.mpp,l_start_day, l_end_date ))) --Bug#5441811
4965: --IF (TRUNC(Okl_Lla_Util_Pvt.calculate_end_date(l_strm_sll_start_date, l_strm_sll_periods*l_strm_sll.mpp,l_start_day)))
4966: -- END: cklee/mvasudev,06-02-2005,Bug#4392051/okl. 4437938
4967: > (TRUNC(l_end_date)) THEN
4968: Okl_Api.set_message(

Line 4965: --IF (TRUNC(Okl_Lla_Util_Pvt.calculate_end_date(l_strm_sll_start_date, l_strm_sll_periods*l_strm_sll.mpp,l_start_day)))

4961: ELSE
4962: -- START: cklee/mvasudev,06-02-2005,Bug#4392051/okl. 4437938
4963: --IF (TRUNC(ADD_MONTHS(l_strm_sll_start_date, l_strm_sll_periods*l_strm_sll.mpp) - 1))
4964: IF (TRUNC(Okl_Lla_Util_Pvt.calculate_end_date(l_strm_sll_start_date, l_strm_sll_periods*l_strm_sll.mpp,l_start_day, l_end_date ))) --Bug#5441811
4965: --IF (TRUNC(Okl_Lla_Util_Pvt.calculate_end_date(l_strm_sll_start_date, l_strm_sll_periods*l_strm_sll.mpp,l_start_day)))
4966: -- END: cklee/mvasudev,06-02-2005,Bug#4392051/okl. 4437938
4967: > (TRUNC(l_end_date)) THEN
4968: Okl_Api.set_message(
4969: G_APP_NAME,

Line 5056: l_pmnt_end_date := Okl_Lla_Util_Pvt.calculate_end_date(l_pmnt_end_date, TO_NUMBER(NVL(l_strm_sll_ext.periods,0)) * l_strm_sll_ext.mpp,l_start_day, l_end_date) + 1; --Bug#5441811

5052:
5053: ELSIF l_strm_sll_ext.periods IS NOT NULL THEN
5054: --vthiruva Bug#4392051..16-jun start..including l_start_day if l_sll_count > 1
5055: IF l_sll_count > 1 THEN
5056: l_pmnt_end_date := Okl_Lla_Util_Pvt.calculate_end_date(l_pmnt_end_date, TO_NUMBER(NVL(l_strm_sll_ext.periods,0)) * l_strm_sll_ext.mpp,l_start_day, l_end_date) + 1; --Bug#5441811
5057: --l_pmnt_end_date := Okl_Lla_Util_Pvt.calculate_end_date(l_pmnt_end_date, TO_NUMBER(NVL(l_strm_sll_ext.periods,0)) * l_strm_sll_ext.mpp,l_start_day) + 1;
5058: ELSE
5059: l_pmnt_end_date := Okl_Lla_Util_Pvt.calculate_end_date(l_pmnt_end_date, TO_NUMBER(NVL(l_strm_sll_ext.periods,0)) * l_strm_sll_ext.mpp) + 1;
5060: END IF;

Line 5057: --l_pmnt_end_date := Okl_Lla_Util_Pvt.calculate_end_date(l_pmnt_end_date, TO_NUMBER(NVL(l_strm_sll_ext.periods,0)) * l_strm_sll_ext.mpp,l_start_day) + 1;

5053: ELSIF l_strm_sll_ext.periods IS NOT NULL THEN
5054: --vthiruva Bug#4392051..16-jun start..including l_start_day if l_sll_count > 1
5055: IF l_sll_count > 1 THEN
5056: l_pmnt_end_date := Okl_Lla_Util_Pvt.calculate_end_date(l_pmnt_end_date, TO_NUMBER(NVL(l_strm_sll_ext.periods,0)) * l_strm_sll_ext.mpp,l_start_day, l_end_date) + 1; --Bug#5441811
5057: --l_pmnt_end_date := Okl_Lla_Util_Pvt.calculate_end_date(l_pmnt_end_date, TO_NUMBER(NVL(l_strm_sll_ext.periods,0)) * l_strm_sll_ext.mpp,l_start_day) + 1;
5058: ELSE
5059: l_pmnt_end_date := Okl_Lla_Util_Pvt.calculate_end_date(l_pmnt_end_date, TO_NUMBER(NVL(l_strm_sll_ext.periods,0)) * l_strm_sll_ext.mpp) + 1;
5060: END IF;
5061: --vthiruva 16-jun end..including l_start_day

Line 5059: l_pmnt_end_date := Okl_Lla_Util_Pvt.calculate_end_date(l_pmnt_end_date, TO_NUMBER(NVL(l_strm_sll_ext.periods,0)) * l_strm_sll_ext.mpp) + 1;

5055: IF l_sll_count > 1 THEN
5056: l_pmnt_end_date := Okl_Lla_Util_Pvt.calculate_end_date(l_pmnt_end_date, TO_NUMBER(NVL(l_strm_sll_ext.periods,0)) * l_strm_sll_ext.mpp,l_start_day, l_end_date) + 1; --Bug#5441811
5057: --l_pmnt_end_date := Okl_Lla_Util_Pvt.calculate_end_date(l_pmnt_end_date, TO_NUMBER(NVL(l_strm_sll_ext.periods,0)) * l_strm_sll_ext.mpp,l_start_day) + 1;
5058: ELSE
5059: l_pmnt_end_date := Okl_Lla_Util_Pvt.calculate_end_date(l_pmnt_end_date, TO_NUMBER(NVL(l_strm_sll_ext.periods,0)) * l_strm_sll_ext.mpp) + 1;
5060: END IF;
5061: --vthiruva 16-jun end..including l_start_day
5062: END IF;
5063:

Line 6830: l_release_contract_yn := okl_lla_util_pvt.check_release_contract(p_chr_id => p_chr_id);

6826: l_tax_owner := l_hdrrl_rec.RULE_INFORMATION1;
6827:
6828: --Bug# 4631549
6829: l_release_contract_yn := okl_api.g_false;
6830: l_release_contract_yn := okl_lla_util_pvt.check_release_contract(p_chr_id => p_chr_id);
6831:
6832: FOR l_lne IN l_lne_csr('FREE_FORM1', p_chr_id)
6833: LOOP
6834:

Line 8021: l_release_contract_yn := okl_lla_util_pvt.check_release_contract(p_chr_id => p_chr_id);

8017: CLOSE l_lne_csr;
8018:
8019: --Bug# 4631549
8020: l_release_contract_yn := okl_api.g_false;
8021: l_release_contract_yn := okl_lla_util_pvt.check_release_contract(p_chr_id => p_chr_id);
8022:
8023: FOR l_lne IN l_lne_csr('FREE_FORM1', p_chr_id)
8024: LOOP
8025: