DBA Data[Home] [Help]

APPS.BEN_EXT_EVALUATE_INCLUSION dependencies on BEN_EXT_THREAD

Line 758: ben_ext_thread.g_ext_dfn_id)

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: );
760: l_actl_dt_2 := trunc(ben_ext_util.calc_ext_date
761: (p_val2,
762: ben_ext_person.g_effective_date,

Line 763: 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: );
765: if trunc(p_actl_dt) >= l_actl_dt_1 and trunc(p_actl_dt) <= l_actl_dt_2 then
766: l_success := 'Y';
767: else

Line 774: ben_ext_thread.g_ext_dfn_id)

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: );
776: l_eff_dt_2 := trunc(ben_ext_util.calc_ext_date
777: (p_val2,
778: ben_ext_person.g_effective_date,

Line 779: 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: );
781: if trunc(p_eff_dt) >= l_eff_dt_1 and trunc(p_eff_dt) <= l_eff_dt_2 then
782: l_success := 'Y';
783: else

Line 800: ben_ext_thread.g_ext_dfn_id)

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: );
802: if trunc(p_actl_dt) = l_actl_dt_1 then
803: l_success := 'Y';
804: else

Line 811: ben_ext_thread.g_ext_dfn_id)

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: );
813: if trunc(p_eff_dt) = l_eff_dt_1 then
814: l_success := 'Y';
815: else

Line 2336: ,p_param1_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))

2332: p_assignment_id => l_asg.assignment_id,
2333: p_business_group_id => l_asg.business_group_id
2334: --RChase pass extract definition id as input value
2335: ,p_param1 => 'EXT_DFN_ID'
2336: ,p_param1_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
2337: ,p_param2 => 'EXT_RSLT_ID'
2338: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
2339: ,p_param3 => 'EXT_PROCESS_BUSINESS_GROUP'
2340: ,p_param3_value => to_char(ben_extract.g_proc_business_group_id)

Line 2338: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))

2334: --RChase pass extract definition id as input value
2335: ,p_param1 => 'EXT_DFN_ID'
2336: ,p_param1_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
2337: ,p_param2 => 'EXT_RSLT_ID'
2338: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
2339: ,p_param3 => 'EXT_PROCESS_BUSINESS_GROUP'
2340: ,p_param3_value => to_char(ben_extract.g_proc_business_group_id)
2341: );
2342: if l_outputs(l_outputs.first).value = 'Y' then

Line 4433: if ben_ext_thread.g_effective_start_date is not null then

4429: --
4430: for i in 1..g_chg_eff_dt_list1.count
4431: loop
4432: --- if the concurrent manager param is passed in then use that
4433: if ben_ext_thread.g_effective_start_date is not null then
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

Line 4434: l_low_date := ben_ext_thread.g_effective_start_date ;

4430: for i in 1..g_chg_eff_dt_list1.count
4431: loop
4432: --- if the concurrent manager param is passed in then use that
4433: if ben_ext_thread.g_effective_start_date is not null then
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

Line 4435: l_high_date := ben_ext_thread.g_effective_end_date ;

4431: loop
4432: --- if the concurrent manager param is passed in then use that
4433: if ben_ext_thread.g_effective_start_date is not null then
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),

Line 4503: if ben_ext_thread.g_actual_start_date is not null then

4499: --
4500: for i in 1..g_chg_actl_dt_list1.count
4501: loop
4502: --- when the date passed from param use the param date
4503: if ben_ext_thread.g_actual_start_date is not null then
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

Line 4504: l_low_date := ben_ext_thread.g_actual_start_date ;

4500: for i in 1..g_chg_actl_dt_list1.count
4501: loop
4502: --- when the date passed from param use the param date
4503: if ben_ext_thread.g_actual_start_date is not null then
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

Line 4505: l_high_date := ben_ext_thread.g_actual_end_date ;

4501: loop
4502: --- when the date passed from param use the param date
4503: if ben_ext_thread.g_actual_start_date is not null then
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),

Line 5996: ,p_param1_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))

5992: (p_formula_id => g_subhead_rule_list(i)
5993: ,p_effective_date => p_effective_date
5994: ,p_business_group_id => p_business_group_id
5995: ,p_param1 => 'EXT_DFN_ID'
5996: ,p_param1_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
5997: ,p_param2 => 'EXT_RSLT_ID'
5998: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
5999: ,p_param3 => p_param_1
6000: ,p_param3_value => p_param_val_1

Line 5998: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))

5994: ,p_business_group_id => p_business_group_id
5995: ,p_param1 => 'EXT_DFN_ID'
5996: ,p_param1_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
5997: ,p_param2 => 'EXT_RSLT_ID'
5998: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
5999: ,p_param3 => p_param_1
6000: ,p_param3_value => p_param_val_1
6001: ,p_param4 => p_param_2
6002: ,p_param4_value => p_param_val_2

Line 6097: ,p_param1_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))

6093: ,p_effective_date => p_effective_date
6094: ,p_assignment_id => l_asg.assignment_id
6095: ,p_business_group_id => p_business_group_id
6096: ,p_param1 => 'EXT_DFN_ID'
6097: ,p_param1_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
6098: ,p_param2 => 'EXT_RSLT_ID'
6099: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
6100: ,p_param3 => 'EXT_PAY_INPUT_VALUE'
6101: ,p_param3_value => to_char(p_input_value_id)

Line 6099: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))

6095: ,p_business_group_id => p_business_group_id
6096: ,p_param1 => 'EXT_DFN_ID'
6097: ,p_param1_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
6098: ,p_param2 => 'EXT_RSLT_ID'
6099: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
6100: ,p_param3 => 'EXT_PAY_INPUT_VALUE'
6101: ,p_param3_value => to_char(p_input_value_id)
6102: ,p_param4 => 'EXT_PAY_PROCESSING_TYPE'
6103: ,p_param4_value => p_processing_type