APPS.BEN_EXT_EVALUATE_INCLUSION dependencies on BEN_EXT_UTIL

Line 755: l_actl_dt_1 := trunc(ben_ext_util.calc_ext_date

751: --
752: -- Operator is 'between'
753: if p_oper_cd = 'BE' then
754: if p_crit_typ_cd = 'CAD' then
755: l_actl_dt_1 := trunc(ben_ext_util.calc_ext_date
756: (p_val1,
757: ben_ext_person.g_effective_date,
758: ben_ext_thread.g_ext_dfn_id)
759: );

Line 760: l_actl_dt_2 := trunc(ben_ext_util.calc_ext_date

756: (p_val1,
757: ben_ext_person.g_effective_date,
758: ben_ext_thread.g_ext_dfn_id)
759: );
760: l_actl_dt_2 := trunc(ben_ext_util.calc_ext_date
761: (p_val2,
762: ben_ext_person.g_effective_date,
763: ben_ext_thread.g_ext_dfn_id)
764: );

Line 771: l_eff_dt_1 := trunc(ben_ext_util.calc_ext_date

767: else
768: l_success := 'N';
769: end if;
770: elsif p_crit_typ_cd = 'CED' then
771: l_eff_dt_1 := trunc(ben_ext_util.calc_ext_date
772: (p_val1,
773: ben_ext_person.g_effective_date,
774: ben_ext_thread.g_ext_dfn_id)
775: );

Line 776: l_eff_dt_2 := trunc(ben_ext_util.calc_ext_date

772: (p_val1,
773: ben_ext_person.g_effective_date,
774: ben_ext_thread.g_ext_dfn_id)
775: );
776: l_eff_dt_2 := trunc(ben_ext_util.calc_ext_date
777: (p_val2,
778: ben_ext_person.g_effective_date,
779: ben_ext_thread.g_ext_dfn_id)
780: );

Line 797: l_actl_dt_1 := trunc(ben_ext_util.calc_ext_date

793: else
794: l_success := 'N';
795: end if;
796: elsif p_crit_typ_cd = 'CAD' then
797: l_actl_dt_1 := trunc(ben_ext_util.calc_ext_date
798: (p_val1,
799: ben_ext_person.g_effective_date,
800: ben_ext_thread.g_ext_dfn_id)
801: );

Line 808: l_eff_dt_1 := trunc(ben_ext_util.calc_ext_date

804: else
805: l_success := 'N';
806: end if;
807: elsif p_crit_typ_cd = 'CED' then
808: l_eff_dt_1 := trunc(ben_ext_util.calc_ext_date
809: (p_val1,
810: ben_ext_person.g_effective_date,
811: ben_ext_thread.g_ext_dfn_id)
812: );

Line 1553: ben_ext_person.g_pay_last_start_date := ben_ext_util.calc_ext_date

1549: g_payroll_last_dt_list2) ;
1550:
1551: ---intilise the gloabl variable
1552: if g_payroll_last_dt_list1.count > 0 and g_payroll_last_dt_list2.count > 0 then
1553: ben_ext_person.g_pay_last_start_date := ben_ext_util.calc_ext_date
1554: (p_ext_date_cd => g_payroll_last_dt_list1(1),
1555: p_abs_date => ben_extract.g_effective_date,
1556: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
1557:

Line 1558: ben_ext_person.g_pay_last_end_date := ben_ext_util.calc_ext_date

1554: (p_ext_date_cd => g_payroll_last_dt_list1(1),
1555: p_abs_date => ben_extract.g_effective_date,
1556: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
1557:
1558: ben_ext_person.g_pay_last_end_date := ben_ext_util.calc_ext_date
1559: (p_ext_date_cd => g_payroll_last_dt_list2(1),
1560: p_abs_date => ben_extract.g_effective_date,
1561: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
1562:

Line 2829: l_low_date := ben_ext_util.calc_ext_date

2825: end if;
2826: --
2827: for i in 1..g_enrt_cvg_strt_dt_list1.count
2828: loop
2829: l_low_date := ben_ext_util.calc_ext_date
2830: (p_ext_date_cd => g_enrt_cvg_strt_dt_list1(i),
2831: p_abs_date => p_effective_date,
2832: p_ext_dfn_id => ben_extract.g_ext_dfn_id,
2833: p_pl_id => p_pl_id);

Line 2834: l_high_date := ben_ext_util.calc_ext_date

2830: (p_ext_date_cd => g_enrt_cvg_strt_dt_list1(i),
2831: p_abs_date => p_effective_date,
2832: p_ext_dfn_id => ben_extract.g_ext_dfn_id,
2833: p_pl_id => p_pl_id);
2834: l_high_date := ben_ext_util.calc_ext_date
2835: (p_ext_date_cd => g_enrt_cvg_strt_dt_list2(i),
2836: p_abs_date => p_effective_date,
2837: p_ext_dfn_id => ben_extract.g_ext_dfn_id,
2838: p_pl_id => p_pl_id

Line 2896: l_low_date := ben_ext_util.calc_ext_date

2892: end if;
2893: --
2894: for i in 1..g_enrt_cvg_drng_perd_list1.count
2895: loop
2896: l_low_date := ben_ext_util.calc_ext_date
2897: (p_ext_date_cd => g_enrt_cvg_drng_perd_list1(i),
2898: p_abs_date => p_effective_date,
2899: p_ext_dfn_id => ben_extract.g_ext_dfn_id,
2900: p_pl_id => p_pl_id );

Line 2901: l_high_date := ben_ext_util.calc_ext_date

2897: (p_ext_date_cd => g_enrt_cvg_drng_perd_list1(i),
2898: p_abs_date => p_effective_date,
2899: p_ext_dfn_id => ben_extract.g_ext_dfn_id,
2900: p_pl_id => p_pl_id );
2901: l_high_date := ben_ext_util.calc_ext_date
2902: (p_ext_date_cd => g_enrt_cvg_drng_perd_list2(i),
2903: p_abs_date => p_effective_date,
2904: p_ext_dfn_id => ben_extract.g_ext_dfn_id,
2905: p_pl_id => p_pl_id );

Line 3174: l_low_date := ben_ext_util.calc_ext_date

3170: end if;
3171: --
3172: for i in 1..g_enrt_last_upd_dt_list1.count
3173: loop
3174: l_low_date := ben_ext_util.calc_ext_date
3175: (p_ext_date_cd => g_enrt_last_upd_dt_list1(i),
3176: p_abs_date => p_effective_date,
3177: p_ext_dfn_id => ben_extract.g_ext_dfn_id ,
3178: p_pl_id => p_pl_id );

Line 3180: l_high_date := ben_ext_util.calc_ext_date

3176: p_abs_date => p_effective_date,
3177: p_ext_dfn_id => ben_extract.g_ext_dfn_id ,
3178: p_pl_id => p_pl_id );
3179:
3180: l_high_date := ben_ext_util.calc_ext_date
3181: (p_ext_date_cd => g_enrt_last_upd_dt_list2(i),
3182: p_abs_date => p_effective_date,
3183: p_ext_dfn_id => ben_extract.g_ext_dfn_id ,
3184: p_pl_id => p_pl_id );

Line 3340: l_low_date := ben_ext_util.calc_ext_date

3336: end if;
3337: --
3338: for i in 1..g_enrt_ler_ocrd_dt_list1.count
3339: loop
3340: l_low_date := ben_ext_util.calc_ext_date
3341: (p_ext_date_cd => g_enrt_ler_ocrd_dt_list1(i),
3342: p_abs_date => p_effective_date,
3343: p_ext_dfn_id => ben_extract.g_ext_dfn_id ,
3344: p_pl_id => p_pl_id );

Line 3345: l_high_date := ben_ext_util.calc_ext_date

3341: (p_ext_date_cd => g_enrt_ler_ocrd_dt_list1(i),
3342: p_abs_date => p_effective_date,
3343: p_ext_dfn_id => ben_extract.g_ext_dfn_id ,
3344: p_pl_id => p_pl_id );
3345: l_high_date := ben_ext_util.calc_ext_date
3346: (p_ext_date_cd => g_enrt_ler_ocrd_dt_list2(i),
3347: p_abs_date => p_effective_date,
3348: p_ext_dfn_id => ben_extract.g_ext_dfn_id,
3349: p_pl_id => p_pl_id );

Line 3404: l_low_date := ben_ext_util.calc_ext_date

3400: end if;
3401: --
3402: for i in 1..g_enrt_ler_ntfn_dt_list1.count
3403: loop
3404: l_low_date := ben_ext_util.calc_ext_date
3405: (p_ext_date_cd => g_enrt_ler_ntfn_dt_list1(i),
3406: p_abs_date => p_effective_date,
3407: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
3408: l_high_date := ben_ext_util.calc_ext_date

Line 3408: l_high_date := ben_ext_util.calc_ext_date

3404: l_low_date := ben_ext_util.calc_ext_date
3405: (p_ext_date_cd => g_enrt_ler_ntfn_dt_list1(i),
3406: p_abs_date => p_effective_date,
3407: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
3408: l_high_date := ben_ext_util.calc_ext_date
3409: (p_ext_date_cd => g_enrt_ler_ntfn_dt_list2(i),
3410: p_abs_date => p_effective_date,
3411: p_ext_dfn_id => ben_extract.g_ext_dfn_id ,
3412: p_pl_id => p_pl_id );

Line 3796: l_low_date := ben_ext_util.calc_ext_date

3792: end if;
3793: --
3794: for i in 1..g_elct_enrt_strt_dt_list1.count
3795: loop
3796: l_low_date := ben_ext_util.calc_ext_date
3797: (p_ext_date_cd => g_elct_enrt_strt_dt_list1(i),
3798: p_abs_date => p_effective_date,
3799: p_ext_dfn_id => ben_extract.g_ext_dfn_id,
3800: p_pl_id => p_pl_id );

Line 3801: l_high_date := ben_ext_util.calc_ext_date

3797: (p_ext_date_cd => g_elct_enrt_strt_dt_list1(i),
3798: p_abs_date => p_effective_date,
3799: p_ext_dfn_id => ben_extract.g_ext_dfn_id,
3800: p_pl_id => p_pl_id );
3801: l_high_date := ben_ext_util.calc_ext_date
3802: (p_ext_date_cd => g_elct_enrt_strt_dt_list2(i),
3803: p_abs_date => p_effective_date,
3804: p_ext_dfn_id => ben_extract.g_ext_dfn_id ,
3805: p_pl_id => p_pl_id );

Line 3962: l_low_date := ben_ext_util.calc_ext_date

3958: end if;
3959: --
3960: for i in 1..g_elct_last_upd_dt_list1.count
3961: loop
3962: l_low_date := ben_ext_util.calc_ext_date
3963: (p_ext_date_cd => g_elct_last_upd_dt_list1(i),
3964: p_abs_date => p_effective_date,
3965: p_ext_dfn_id => ben_extract.g_ext_dfn_id,
3966: p_pl_id => p_pl_id );

Line 3967: l_high_date := ben_ext_util.calc_ext_date

3963: (p_ext_date_cd => g_elct_last_upd_dt_list1(i),
3964: p_abs_date => p_effective_date,
3965: p_ext_dfn_id => ben_extract.g_ext_dfn_id,
3966: p_pl_id => p_pl_id );
3967: l_high_date := ben_ext_util.calc_ext_date
3968: (p_ext_date_cd => g_elct_last_upd_dt_list2(i),
3969: p_abs_date => p_effective_date,
3970: p_ext_dfn_id => ben_extract.g_ext_dfn_id ,
3971: p_pl_id => p_pl_id );

Line 4179: l_low_date := ben_ext_util.calc_ext_date

4175: end if;
4176: --
4177: for i in 1..g_elct_ler_ocrd_dt_list1.count
4178: loop
4179: l_low_date := ben_ext_util.calc_ext_date
4180: (p_ext_date_cd => g_elct_ler_ocrd_dt_list1(i),
4181: p_abs_date => p_effective_date,
4182: p_ext_dfn_id => ben_extract.g_ext_dfn_id,
4183: p_pl_id => p_pl_id );

Line 4184: l_high_date := ben_ext_util.calc_ext_date

4180: (p_ext_date_cd => g_elct_ler_ocrd_dt_list1(i),
4181: p_abs_date => p_effective_date,
4182: p_ext_dfn_id => ben_extract.g_ext_dfn_id,
4183: p_pl_id => p_pl_id );
4184: l_high_date := ben_ext_util.calc_ext_date
4185: (p_ext_date_cd => g_elct_ler_ocrd_dt_list2(i),
4186: p_abs_date => p_effective_date,
4187: p_ext_dfn_id => ben_extract.g_ext_dfn_id,
4188: p_pl_id => p_pl_id );

Line 4244: l_low_date := ben_ext_util.calc_ext_date

4240: end if;
4241: --
4242: for i in 1..g_elct_ler_ntfn_dt_list1.count
4243: loop
4244: l_low_date := ben_ext_util.calc_ext_date
4245: (p_ext_date_cd => g_elct_ler_ntfn_dt_list1(i),
4246: p_abs_date => p_effective_date,
4247: p_ext_dfn_id => ben_extract.g_ext_dfn_id ,
4248: p_pl_id => p_pl_id );

Line 4249: l_high_date := ben_ext_util.calc_ext_date

4245: (p_ext_date_cd => g_elct_ler_ntfn_dt_list1(i),
4246: p_abs_date => p_effective_date,
4247: p_ext_dfn_id => ben_extract.g_ext_dfn_id ,
4248: p_pl_id => p_pl_id );
4249: l_high_date := ben_ext_util.calc_ext_date
4250: (p_ext_date_cd => g_elct_ler_ntfn_dt_list2(i),
4251: p_abs_date => p_effective_date,
4252: p_ext_dfn_id => ben_extract.g_ext_dfn_id ,
4253: p_pl_id => p_pl_id );

Line 4438: l_low_date := ben_ext_util.calc_ext_date

4434: l_low_date := ben_ext_thread.g_effective_start_date ;
4435: l_high_date := ben_ext_thread.g_effective_end_date ;
4436: hr_utility.set_location( ' param chg eff date ' || l_low_date || ' /' || l_high_date, 99 );
4437: else
4438: l_low_date := ben_ext_util.calc_ext_date
4439: (p_ext_date_cd => g_chg_eff_dt_list1(i),
4440: p_abs_date => p_effective_date,
4441: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
4442: l_high_date := ben_ext_util.calc_ext_date

Line 4442: l_high_date := ben_ext_util.calc_ext_date

4438: l_low_date := ben_ext_util.calc_ext_date
4439: (p_ext_date_cd => g_chg_eff_dt_list1(i),
4440: p_abs_date => p_effective_date,
4441: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
4442: l_high_date := ben_ext_util.calc_ext_date
4443: (p_ext_date_cd => g_chg_eff_dt_list2(i),
4444: p_abs_date => p_effective_date,
4445: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
4446: end if ;

Line 4508: l_low_date := ben_ext_util.calc_ext_date

4504: l_low_date := ben_ext_thread.g_actual_start_date ;
4505: l_high_date := ben_ext_thread.g_actual_end_date ;
4506: hr_utility.set_location( ' param chg act date ' || l_low_date || ' /' || l_high_date, 99 );
4507: else
4508: l_low_date := ben_ext_util.calc_ext_date
4509: (p_ext_date_cd => g_chg_actl_dt_list1(i),
4510: p_abs_date => p_effective_date,
4511: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
4512: l_high_date := ben_ext_util.calc_ext_date

Line 4512: l_high_date := ben_ext_util.calc_ext_date

4508: l_low_date := ben_ext_util.calc_ext_date
4509: (p_ext_date_cd => g_chg_actl_dt_list1(i),
4510: p_abs_date => p_effective_date,
4511: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
4512: l_high_date := ben_ext_util.calc_ext_date
4513: (p_ext_date_cd => g_chg_actl_dt_list2(i),
4514: p_abs_date => p_effective_date,
4515: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
4516: end if ;

Line 4670: l_low_date := ben_ext_util.calc_ext_date

4666: end if;
4667: --
4668: for i in 1..g_cm_last_upd_dt_list1.count
4669: loop
4670: l_low_date := ben_ext_util.calc_ext_date
4671: (p_ext_date_cd => g_cm_last_upd_dt_list1(i),
4672: p_abs_date => p_effective_date,
4673: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
4674: l_high_date := ben_ext_util.calc_ext_date

Line 4674: l_high_date := ben_ext_util.calc_ext_date

4670: l_low_date := ben_ext_util.calc_ext_date
4671: (p_ext_date_cd => g_cm_last_upd_dt_list1(i),
4672: p_abs_date => p_effective_date,
4673: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
4674: l_high_date := ben_ext_util.calc_ext_date
4675: (p_ext_date_cd => g_cm_last_upd_dt_list2(i),
4676: p_abs_date => p_effective_date,
4677: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
4678: if p_last_update_date between l_low_date and nvl(l_high_date,l_low_date) then

Line 4731: l_low_date := ben_ext_util.calc_ext_date

4727: end if;
4728: --
4729: for i in 1..g_cm_pr_last_upd_dt_list1.count
4730: loop
4731: l_low_date := ben_ext_util.calc_ext_date
4732: (p_ext_date_cd => g_cm_pr_last_upd_dt_list1(i),
4733: p_abs_date => p_effective_date,
4734: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
4735: l_high_date := ben_ext_util.calc_ext_date

Line 4735: l_high_date := ben_ext_util.calc_ext_date

4731: l_low_date := ben_ext_util.calc_ext_date
4732: (p_ext_date_cd => g_cm_pr_last_upd_dt_list1(i),
4733: p_abs_date => p_effective_date,
4734: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
4735: l_high_date := ben_ext_util.calc_ext_date
4736: (p_ext_date_cd => g_cm_pr_last_upd_dt_list2(i),
4737: p_abs_date => p_effective_date,
4738: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
4739: if p_pvdd_last_update_date between l_low_date and nvl(l_high_date,l_low_date) then

Line 4794: l_low_date := ben_ext_util.calc_ext_date

4790: --
4791: for i in 1..g_payroll_last_dt_list1.count
4792: loop
4793:
4794: l_low_date := ben_ext_util.calc_ext_date
4795: (p_ext_date_cd => g_payroll_last_dt_list1(i),
4796: p_abs_date => p_effective_date,
4797: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
4798:

Line 4799: l_high_date := ben_ext_util.calc_ext_date

4795: (p_ext_date_cd => g_payroll_last_dt_list1(i),
4796: p_abs_date => p_effective_date,
4797: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
4798:
4799: l_high_date := ben_ext_util.calc_ext_date
4800: (p_ext_date_cd => g_payroll_last_dt_list2(i),
4801: p_abs_date => p_effective_date,
4802: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
4803: if g_debug then

Line 4874: l_low_date := ben_ext_util.calc_ext_date

4870: end if;
4871: --
4872: for i in 1..g_prem_last_upd_dt_list1.count
4873: loop
4874: l_low_date := ben_ext_util.calc_ext_date
4875: (p_ext_date_cd => g_prem_last_upd_dt_list1(i),
4876: p_abs_date => p_effective_date,
4877: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
4878: l_high_date := ben_ext_util.calc_ext_date

Line 4878: l_high_date := ben_ext_util.calc_ext_date

4874: l_low_date := ben_ext_util.calc_ext_date
4875: (p_ext_date_cd => g_prem_last_upd_dt_list1(i),
4876: p_abs_date => p_effective_date,
4877: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
4878: l_high_date := ben_ext_util.calc_ext_date
4879: (p_ext_date_cd => g_prem_last_upd_dt_list2(i),
4880: p_abs_date => p_effective_date,
4881: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
4882: if g_debug then

Line 4956: l_low_date := ben_ext_util.calc_ext_date

4952: end if;
4953: --
4954: for i in 1..g_prem_month_year_dt_list1.count
4955: loop
4956: l_low_date := ben_ext_util.calc_ext_date
4957: (p_ext_date_cd => g_prem_month_year_dt_list1(i),
4958: p_abs_date => p_effective_date,
4959: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
4960: l_high_date := ben_ext_util.calc_ext_date

Line 4960: l_high_date := ben_ext_util.calc_ext_date

4956: l_low_date := ben_ext_util.calc_ext_date
4957: (p_ext_date_cd => g_prem_month_year_dt_list1(i),
4958: p_abs_date => p_effective_date,
4959: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
4960: l_high_date := ben_ext_util.calc_ext_date
4961: (p_ext_date_cd => g_prem_month_year_dt_list2(i),
4962: p_abs_date => p_effective_date,
4963: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
4964: ---converting to month no and year no

Line 5037: l_low_date := ben_ext_util.calc_ext_date

5033: end if;
5034: --
5035: for i in 1..g_cm_sent_dt_list1.count
5036: loop
5037: l_low_date := ben_ext_util.calc_ext_date
5038: (p_ext_date_cd => g_cm_sent_dt_list1(i),
5039: p_abs_date => p_effective_date,
5040: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
5041: l_high_date := ben_ext_util.calc_ext_date

Line 5041: l_high_date := ben_ext_util.calc_ext_date

5037: l_low_date := ben_ext_util.calc_ext_date
5038: (p_ext_date_cd => g_cm_sent_dt_list1(i),
5039: p_abs_date => p_effective_date,
5040: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
5041: l_high_date := ben_ext_util.calc_ext_date
5042: (p_ext_date_cd => g_cm_sent_dt_list2(i),
5043: p_abs_date => p_effective_date,
5044: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
5045: if p_sent_dt between l_low_date and nvl(l_high_date,l_low_date) then

Line 5098: l_low_date := ben_ext_util.calc_ext_date

5094: end if;
5095: --
5096: for i in 1..g_cm_to_be_sent_dt_list1.count
5097: loop
5098: l_low_date := ben_ext_util.calc_ext_date
5099: (p_ext_date_cd => g_cm_to_be_sent_dt_list1(i),
5100: p_abs_date => p_effective_date,
5101: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
5102: l_high_date := ben_ext_util.calc_ext_date

Line 5102: l_high_date := ben_ext_util.calc_ext_date

5098: l_low_date := ben_ext_util.calc_ext_date
5099: (p_ext_date_cd => g_cm_to_be_sent_dt_list1(i),
5100: p_abs_date => p_effective_date,
5101: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
5102: l_high_date := ben_ext_util.calc_ext_date
5103: (p_ext_date_cd => g_cm_to_be_sent_dt_list2(i),
5104: p_abs_date => p_effective_date,
5105: p_ext_dfn_id => ben_extract.g_ext_dfn_id);
5106: if p_to_be_sent_dt between l_low_date and nvl(l_high_date,l_low_date) then