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 3150: ben_ext_util.get_ext_dates

3146: IF p_data_typ_cd = 'F' THEN
3147: --
3148: init_detail_globals;
3149: --
3150: ben_ext_util.get_ext_dates
3151: (p_ext_dfn_id => p_ext_dfn_id,
3152: p_data_typ_cd => p_data_typ_cd,
3153: p_effective_date => p_effective_date,
3154: p_person_ext_dt => l_person_ext_dt, --out

Line 3227: ben_ext_util.get_chg_dates

3223: ELSIF p_data_typ_cd = 'C' THEN
3224: --
3225: g_trans_num := 1;
3226: --
3227: ben_ext_util.get_chg_dates
3228: (p_ext_dfn_id => ben_extract.g_ext_dfn_id, --in
3229: p_effective_date => g_effective_date, --in
3230: p_chg_actl_strt_dt => l_chg_actl_strt_dt, --out
3231: p_chg_actl_end_dt => l_chg_actl_end_dt, --out

Line 3291: ben_ext_util.get_ext_dates

3287: EXIT WHEN c_changes_only_extract%NOTFOUND;
3288: --
3289: --g_extract_date := g_chg_eff_dt;
3290: --
3291: ben_ext_util.get_ext_dates
3292: (p_ext_dfn_id => p_ext_dfn_id,
3293: p_data_typ_cd => p_data_typ_cd,
3294: p_effective_date => g_effective_date,
3295: p_person_ext_dt => l_person_ext_dt, --out

Line 3556: ben_ext_util.entries_affected

3552: g_pay_adv_eff_to_dt,99) ;
3553:
3554: l_eff_event_ecount := 0 ;
3555: l_eff_event_scount := 0 ;
3556: ben_ext_util.entries_affected
3557: (p_assignment_id => l_pay_Assignment_id
3558: ,p_event_group_id => i.event_group_id
3559: ,p_mode => NULL -- 'DATE_PROCESSED' -- 'DATE_EARNED' --
3560: ,p_start_date => (g_pay_adv_eff_from_dt-1)

Line 3621: ben_ext_util.entries_affected

3617: l_eff_event_ecount := l_pay_detail_tot_tab.count ;
3618: l_pay_detail_tab.delete ;
3619: hr_utility.set_location('adv actual date mode '||g_pay_adv_act_from_dt||' / ' ||
3620: g_pay_adv_act_to_dt,99) ;
3621: ben_ext_util.entries_affected
3622: (p_assignment_id => l_pay_Assignment_id
3623: ,p_event_group_id => i.event_group_id
3624: ,p_mode => NULL -- 'DATE_PROCESSED' -- 'DATE_EARNED' --
3625: ,p_start_date => trunc(g_pay_adv_act_from_dt)

Line 3751: ben_ext_util.entries_affected

3747:
3748: hr_utility.set_location('pay actual dt mode '||trunc(l_chg_actl_strt_dt)||' / '||
3749: (trunc(l_chg_actl_end_dt)+0.99999) , 66 );
3750:
3751: ben_ext_util.entries_affected
3752: (p_assignment_id => l_pay_Assignment_id
3753: ,p_event_group_id => i.event_group_id
3754: ,p_mode => NULL -- 'DATE_PROCESSED' -- 'DATE_EARNED' --
3755: ,p_start_date => trunc(l_chg_actl_strt_dt)

Line 3772: ben_ext_util.entries_affected

3768: -- then used for reporting so the functionality remains the same
3769: -- we are passing -1 to make sure the from date data is included
3770: hr_utility.set_location(' pay effectivedt mode ' ||(l_chg_eff_strt_dt-1) || ' / ' ||
3771: l_chg_eff_end_dt , 66 ) ;
3772: ben_ext_util.entries_affected
3773: (p_assignment_id => l_pay_Assignment_id
3774: ,p_event_group_id => i.event_group_id
3775: ,p_mode => NULL -- 'DATE_PROCESSED' -- 'DATE_EARNED' --
3776: ,p_start_date => (l_chg_eff_strt_dt-1)

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

3791: g_err_name := 'BEN_94629_NO_ASG_ACTION_ID' ;
3792: g_elmt_name:= null ;
3793: raise detail_restart_error ;
3794: else
3795: hr_utility.set_location( 'unknow exception raised in ben_ext_util.entries_affected.',-9999);
3796: raise; -- to re-raise the exception
3797: end if ;
3798: End ;
3799:

Line 3890: ben_ext_util.get_ext_dates

3886: hr_utility.set_location(' pay chg index '||g_chg_pay_evt_index,99) ;
3887: hr_utility.set_location('date and end date '||g_person_id||'-'||g_chg_eff_dt||'/'||
3888: g_chg_next_event_date,99) ;
3889: g_chg_evt_source := 'PAY' ;
3890: ben_ext_util.get_ext_dates
3891: (p_ext_dfn_id => p_ext_dfn_id,
3892: p_data_typ_cd => p_data_typ_cd,
3893: p_effective_date => g_effective_date,
3894: p_person_ext_dt => l_person_ext_dt, --out

Line 4012: ben_ext_util.get_cm_dates

4008: g_cm_flag := 'Y';
4009: --
4010: g_trans_num := 1;
4011: --
4012: ben_ext_util.get_cm_dates
4013: (p_ext_dfn_id => ben_extract.g_ext_dfn_id, --in
4014: p_effective_date => g_effective_date, --in
4015: p_to_be_sent_strt_dt => l_to_be_sent_strt_dt, --out
4016: p_to_be_sent_end_dt => l_to_be_sent_end_dt); --out

Line 4119: ben_ext_util.get_ext_dates

4115: g_detail_extracted:=false;
4116: --
4117: --g_extract_date := g_cm_eff_dt;
4118: --
4119: ben_ext_util.get_ext_dates
4120: (p_ext_dfn_id => p_ext_dfn_id,
4121: p_data_typ_cd => p_data_typ_cd,
4122: p_effective_date => g_effective_date,
4123: p_person_ext_dt => l_person_ext_dt, --out

Line 4244: ben_ext_util.get_ext_dates

4240: Loop
4241: g_CWB_EFFECTIVE_DATE := l_cwb.effective_date ;
4242: g_CWB_LE_DT := l_cwb.LF_EVT_OCRD_DT ;
4243: hr_utility.set_location('cwb person ' || l_cwb.person_id , 99 ) ;
4244: ben_ext_util.get_ext_dates
4245: (p_ext_dfn_id => p_ext_dfn_id,
4246: p_data_typ_cd => p_data_typ_cd,
4247: p_effective_date => g_effective_date,
4248: p_person_ext_dt => l_person_ext_dt, --out

Line 5543: ben_ext_util.write_err

5539: end if;
5540: --
5541: if g_business_group_id is not null then
5542: --
5543: ben_ext_util.write_err
5544: (p_err_num => p_err_num,
5545: p_err_name => p_err_name, --error form will take care of it,
5546: p_typ_cd => p_typ_cd,
5547: p_person_id => g_person_id,