APPS.BEN_EXT_PERSON dependencies on BEN_EXT_UTIL

Line 74: l_from_date := ben_ext_util.calc_ext_date

70:
71: hr_utility.set_location('oper cd '||i.oper_cd, 5);
72: hr_utility.set_location('crit_typ_cd cd '||i.crit_typ_cd, 5);
73:
74: l_from_date := ben_ext_util.calc_ext_date
75: (p_ext_date_cd => i.val_1,
76: p_abs_date => p_effective_date,
77: p_ext_dfn_id => p_ext_dfn_id);
78: if i.oper_cd = 'EQ' then

Line 82: l_to_date := ben_ext_util.calc_ext_date

78: if i.oper_cd = 'EQ' then
79: l_to_date := l_from_date ;
80: else
81:
82: l_to_date := ben_ext_util.calc_ext_date
83: (p_ext_date_cd => i.val_2,
84: p_abs_date => p_effective_date,
85: p_ext_dfn_id => p_ext_dfn_id);
86:

Line 3184: ben_ext_util.get_ext_dates

3180: IF p_data_typ_cd = 'F' THEN
3181: --
3182: init_detail_globals;
3183: --
3184: ben_ext_util.get_ext_dates
3185: (p_ext_dfn_id => p_ext_dfn_id,
3186: p_data_typ_cd => p_data_typ_cd,
3187: p_effective_date => p_effective_date,
3188: p_person_ext_dt => l_person_ext_dt, --out

Line 3261: ben_ext_util.get_chg_dates

3257: ELSIF p_data_typ_cd = 'C' THEN
3258: --
3259: g_trans_num := 1;
3260: --
3261: ben_ext_util.get_chg_dates
3262: (p_ext_dfn_id => ben_extract.g_ext_dfn_id, --in
3263: p_effective_date => g_effective_date, --in
3264: p_chg_actl_strt_dt => l_chg_actl_strt_dt, --out
3265: p_chg_actl_end_dt => l_chg_actl_end_dt, --out

Line 3325: ben_ext_util.get_ext_dates

3321: EXIT WHEN c_changes_only_extract%NOTFOUND;
3322: --
3323: --g_extract_date := g_chg_eff_dt;
3324: --
3325: ben_ext_util.get_ext_dates
3326: (p_ext_dfn_id => p_ext_dfn_id,
3327: p_data_typ_cd => p_data_typ_cd,
3328: p_effective_date => g_effective_date,
3329: p_person_ext_dt => l_person_ext_dt, --out

Line 3590: ben_ext_util.entries_affected

3586: g_pay_adv_eff_to_dt,99) ;
3587:
3588: l_eff_event_ecount := 0 ;
3589: l_eff_event_scount := 0 ;
3590: ben_ext_util.entries_affected
3591: (p_assignment_id => l_pay_Assignment_id
3592: ,p_event_group_id => i.event_group_id
3593: ,p_mode => NULL -- 'DATE_PROCESSED' -- 'DATE_EARNED' --
3594: ,p_start_date => (g_pay_adv_eff_from_dt-1)

Line 3655: ben_ext_util.entries_affected

3651: l_eff_event_ecount := l_pay_detail_tot_tab.count ;
3652: l_pay_detail_tab.delete ;
3653: hr_utility.set_location('adv actual date mode '||g_pay_adv_act_from_dt||' / ' ||
3654: g_pay_adv_act_to_dt,99) ;
3655: ben_ext_util.entries_affected
3656: (p_assignment_id => l_pay_Assignment_id
3657: ,p_event_group_id => i.event_group_id
3658: ,p_mode => NULL -- 'DATE_PROCESSED' -- 'DATE_EARNED' --
3659: ,p_start_date => trunc(g_pay_adv_act_from_dt)

Line 3785: ben_ext_util.entries_affected

3781:
3782: hr_utility.set_location('pay actual dt mode '||trunc(l_chg_actl_strt_dt)||' / '||
3783: (trunc(l_chg_actl_end_dt)+0.99999) , 66 );
3784:
3785: ben_ext_util.entries_affected
3786: (p_assignment_id => l_pay_Assignment_id
3787: ,p_event_group_id => i.event_group_id
3788: ,p_mode => NULL -- 'DATE_PROCESSED' -- 'DATE_EARNED' --
3789: ,p_start_date => trunc(l_chg_actl_strt_dt)

Line 3806: ben_ext_util.entries_affected

3802: -- then used for reporting so the functionality remains the same
3803: -- we are passing -1 to make sure the from date data is included
3804: hr_utility.set_location(' pay effectivedt mode ' ||(l_chg_eff_strt_dt-1) || ' / ' ||
3805: l_chg_eff_end_dt , 66 ) ;
3806: ben_ext_util.entries_affected
3807: (p_assignment_id => l_pay_Assignment_id
3808: ,p_event_group_id => i.event_group_id
3809: ,p_mode => NULL -- 'DATE_PROCESSED' -- 'DATE_EARNED' --
3810: ,p_start_date => (l_chg_eff_strt_dt-1)

Line 3829: hr_utility.set_location( 'unknow exception raised in ben_ext_util.entries_affected.',-9999);

3825: g_err_name := 'BEN_94629_NO_ASG_ACTION_ID' ;
3826: g_elmt_name:= null ;
3827: raise detail_restart_error ;
3828: else
3829: hr_utility.set_location( 'unknow exception raised in ben_ext_util.entries_affected.',-9999);
3830: raise; -- to re-raise the exception
3831: end if ;
3832: End ;
3833:

Line 3924: ben_ext_util.get_ext_dates

3920: hr_utility.set_location(' pay chg index '||g_chg_pay_evt_index,99) ;
3921: hr_utility.set_location('date and end date '||g_person_id||'-'||g_chg_eff_dt||'/'||
3922: g_chg_next_event_date,99) ;
3923: g_chg_evt_source := 'PAY' ;
3924: ben_ext_util.get_ext_dates
3925: (p_ext_dfn_id => p_ext_dfn_id,
3926: p_data_typ_cd => p_data_typ_cd,
3927: p_effective_date => g_effective_date,
3928: p_person_ext_dt => l_person_ext_dt, --out

Line 4046: ben_ext_util.get_cm_dates

4042: g_cm_flag := 'Y';
4043: --
4044: g_trans_num := 1;
4045: --
4046: ben_ext_util.get_cm_dates
4047: (p_ext_dfn_id => ben_extract.g_ext_dfn_id, --in
4048: p_effective_date => g_effective_date, --in
4049: p_to_be_sent_strt_dt => l_to_be_sent_strt_dt, --out
4050: p_to_be_sent_end_dt => l_to_be_sent_end_dt); --out

Line 4154: ben_ext_util.get_ext_dates

4150: g_detail_extracted:=false;
4151: --
4152: --g_extract_date := g_cm_eff_dt;
4153: --
4154: ben_ext_util.get_ext_dates
4155: (p_ext_dfn_id => p_ext_dfn_id,
4156: p_data_typ_cd => p_data_typ_cd,
4157: p_effective_date => g_effective_date,
4158: p_person_ext_dt => l_person_ext_dt, --out

Line 4279: ben_ext_util.get_ext_dates

4275: Loop
4276: g_CWB_EFFECTIVE_DATE := l_cwb.effective_date ;
4277: g_CWB_LE_DT := l_cwb.LF_EVT_OCRD_DT ;
4278: hr_utility.set_location('cwb person ' || l_cwb.person_id , 99 ) ;
4279: ben_ext_util.get_ext_dates
4280: (p_ext_dfn_id => p_ext_dfn_id,
4281: p_data_typ_cd => p_data_typ_cd,
4282: p_effective_date => g_effective_date,
4283: p_person_ext_dt => l_person_ext_dt, --out

Line 5580: ben_ext_util.write_err

5576: end if;
5577: --
5578: if g_business_group_id is not null then
5579: --
5580: ben_ext_util.write_err
5581: (p_err_num => p_err_num,
5582: p_err_name => p_err_name, --error form will take care of it,
5583: p_typ_cd => p_typ_cd,
5584: p_person_id => g_person_id,