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_QA_DATA_INTEGRITY dependencies on OKL_LLA_UTIL_PVT

Line 1829: l_pymnt_end_date := Okl_Lla_Util_Pvt.calculate_end_date(p_start_date => l_pymnt_start_date,

1825: l_factor := 6;
1826: ELSIF(l_frequency = 'A') THEN
1827: l_factor := 12;
1828: END IF;
1829: l_pymnt_end_date := Okl_Lla_Util_Pvt.calculate_end_date(p_start_date => l_pymnt_start_date,
1830: p_months => l_factor * NVL(l_variable_periods,0),
1831: p_start_day => l_start_day);
1832: END IF;
1833:

Line 4595: l_chk_rebook_chr := OKL_LLA_UTIL_PVT.check_rebook_contract(p_chr_id => p_chr_id);

4591: BEGIN
4592: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
4593:
4594: --Bug# 16098797
4595: l_chk_rebook_chr := OKL_LLA_UTIL_PVT.check_rebook_contract(p_chr_id => p_chr_id);
4596: l_chk_new_chr := OKL_LLA_UTIL_PVT.check_new_contract(p_chr_id => p_chr_id);
4597:
4598: FOR serial_rec IN serial_csr (p_chr_id)
4599: LOOP

Line 4596: l_chk_new_chr := OKL_LLA_UTIL_PVT.check_new_contract(p_chr_id => p_chr_id);

4592: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
4593:
4594: --Bug# 16098797
4595: l_chk_rebook_chr := OKL_LLA_UTIL_PVT.check_rebook_contract(p_chr_id => p_chr_id);
4596: l_chk_new_chr := OKL_LLA_UTIL_PVT.check_new_contract(p_chr_id => p_chr_id);
4597:
4598: FOR serial_rec IN serial_csr (p_chr_id)
4599: LOOP
4600: IF (serial_rec.serial_number_control_code <> 1) THEN -- serialized item

Line 5351: 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

5347:
5348: ELSE
5349: -- START: cklee/mvasudev,06-02-2005,Bug#4392051/okl. 4437938
5350: --IF (TRUNC(ADD_MONTHS(l_strm_sll_start_date, l_strm_sll_periods*l_strm_sll.mpp) - 1))
5351: 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
5352: --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)))
5353: -- END: cklee/mvasudev,06-02-2005,Bug#4392051/okl. 4437938
5354: > (TRUNC(l_end_date)) THEN
5355: Okl_Api.set_message(

Line 5352: --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)))

5348: ELSE
5349: -- START: cklee/mvasudev,06-02-2005,Bug#4392051/okl. 4437938
5350: --IF (TRUNC(ADD_MONTHS(l_strm_sll_start_date, l_strm_sll_periods*l_strm_sll.mpp) - 1))
5351: 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
5352: --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)))
5353: -- END: cklee/mvasudev,06-02-2005,Bug#4392051/okl. 4437938
5354: > (TRUNC(l_end_date)) THEN
5355: Okl_Api.set_message(
5356: G_APP_NAME,

Line 5443: 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

5439:
5440: ELSIF l_strm_sll_ext.periods IS NOT NULL THEN
5441: --vthiruva Bug#4392051..16-jun start..including l_start_day if l_sll_count > 1
5442: IF l_sll_count > 1 THEN
5443: 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
5444: --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;
5445: ELSE
5446: 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;
5447: END IF;

Line 5444: --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;

5440: ELSIF l_strm_sll_ext.periods IS NOT NULL THEN
5441: --vthiruva Bug#4392051..16-jun start..including l_start_day if l_sll_count > 1
5442: IF l_sll_count > 1 THEN
5443: 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
5444: --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;
5445: ELSE
5446: 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;
5447: END IF;
5448: --vthiruva 16-jun end..including l_start_day

Line 5446: 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;

5442: IF l_sll_count > 1 THEN
5443: 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
5444: --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;
5445: ELSE
5446: 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;
5447: END IF;
5448: --vthiruva 16-jun end..including l_start_day
5449: END IF;
5450:

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

7213: l_tax_owner := l_hdrrl_rec.RULE_INFORMATION1;
7214:
7215: --Bug# 4631549
7216: l_release_contract_yn := okl_api.g_false;
7217: l_release_contract_yn := okl_lla_util_pvt.check_release_contract(p_chr_id => p_chr_id);
7218:
7219: FOR l_lne IN l_lne_csr('FREE_FORM1', p_chr_id)
7220: LOOP
7221:

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

8434: CLOSE l_lne_csr;
8435:
8436: --Bug# 4631549
8437: l_release_contract_yn := okl_api.g_false;
8438: l_release_contract_yn := okl_lla_util_pvt.check_release_contract(p_chr_id => p_chr_id);
8439:
8440: FOR l_lne IN l_lne_csr('FREE_FORM1', p_chr_id)
8441: LOOP
8442:

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

14251: l_oec NUMBER;
14252: BEGIN
14253: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
14254: l_release_contract_yn := okl_api.g_false;
14255: l_release_contract_yn := okl_lla_util_pvt.check_release_contract(p_chr_id => p_chr_id);
14256:
14257: FOR l_lne IN l_lne_csr('FREE_FORM1', p_chr_id)
14258: LOOP
14259: IF l_release_contract_yn = OKL_API.G_TRUE