DBA Data[Home] [Help]

APPS.BEN_PEN_LER dependencies on BENUTILS

Line 134: benutils.set_data_migrator_mode;

130: --
131: begin
132:
133: -- Bug 3320133
134: benutils.set_data_migrator_mode;
135: if hr_general.g_data_migrator_mode in ( 'Y','P') then
136: --
137: return;
138: --

Line 259: benutils.exec_rule(

255: l_col_old_val := to_char(p_old.EFFECTIVE_END_DATE, 'YYYY/MM/DD HH24:MI:SS');
256: l_col_new_val := to_char(p_new.EFFECTIVE_END_DATE, 'YYYY/MM/DD HH24:MI:SS');
257: end if;
258: --
259: benutils.exec_rule(
260: p_formula_id => l_per_info_chg_cs_ler_rl,
261: p_effective_date => l_session_date,
262: p_lf_evt_ocrd_dt => null,
263: p_business_group_id => nvl(p_new.business_group_id, p_old.business_group_id),

Line 294: l_changed := (benutils.column_changed(p_old.enrt_cvg_strt_dt

290: --
291:
292: --
293: if l_column = 'ENRT_CVG_STRT_DT' then
294: l_changed := (benutils.column_changed(p_old.enrt_cvg_strt_dt
295: ,p_new.enrt_cvg_strt_dt,l_new_val) AND
296: benutils.column_changed(p_new.enrt_cvg_strt_dt
297: ,p_old.enrt_cvg_strt_dt,l_old_val) AND
298: (l_changed));

Line 296: benutils.column_changed(p_new.enrt_cvg_strt_dt

292: --
293: if l_column = 'ENRT_CVG_STRT_DT' then
294: l_changed := (benutils.column_changed(p_old.enrt_cvg_strt_dt
295: ,p_new.enrt_cvg_strt_dt,l_new_val) AND
296: benutils.column_changed(p_new.enrt_cvg_strt_dt
297: ,p_old.enrt_cvg_strt_dt,l_old_val) AND
298: (l_changed));
299: hr_utility.set_location(' l_changed:',40);
300: end if;

Line 306: l_changed := (benutils.column_changed(p_old.enrt_cvg_thru_dt

302: if l_column = 'ENRT_CVG_THRU_DT' then
303: if p_new.enrt_cvg_thru_dt = hr_api.g_eot then
304: l_changed := FALSE;
305: end if;
306: l_changed := (benutils.column_changed(p_old.enrt_cvg_thru_dt
307: ,p_new.enrt_cvg_thru_dt,l_new_val) AND
308: benutils.column_changed(p_new.enrt_cvg_thru_dt
309: ,p_old.enrt_cvg_thru_dt,l_old_val) AND
310: (l_changed));

Line 308: benutils.column_changed(p_new.enrt_cvg_thru_dt

304: l_changed := FALSE;
305: end if;
306: l_changed := (benutils.column_changed(p_old.enrt_cvg_thru_dt
307: ,p_new.enrt_cvg_thru_dt,l_new_val) AND
308: benutils.column_changed(p_new.enrt_cvg_thru_dt
309: ,p_old.enrt_cvg_thru_dt,l_old_val) AND
310: (l_changed));
311: --
312: if l_lertrg_set(ler_row).ocrd_dt_det_cd is null then

Line 332: l_changed := (benutils.column_changed(p_old.bnft_amt

328: if l_column = 'BNFT_AMT' then
329: hr_utility.set_location('Old bnft_amt '||p_old.bnft_amt, 20);
330: hr_utility.set_location('New bnft_amt '||p_new.bnft_amt, 20);
331: hr_utility.set_location('lodt '||l_lf_evt_ocrd_date, 20);
332: l_changed := (benutils.column_changed(p_old.bnft_amt
333: ,p_new.bnft_amt,l_new_val) AND
334: benutils.column_changed(p_new.bnft_amt
335: ,p_old.bnft_amt,l_old_val) AND
336: (l_changed));

Line 334: benutils.column_changed(p_new.bnft_amt

330: hr_utility.set_location('New bnft_amt '||p_new.bnft_amt, 20);
331: hr_utility.set_location('lodt '||l_lf_evt_ocrd_date, 20);
332: l_changed := (benutils.column_changed(p_old.bnft_amt
333: ,p_new.bnft_amt,l_new_val) AND
334: benutils.column_changed(p_new.bnft_amt
335: ,p_old.bnft_amt,l_old_val) AND
336: (l_changed));
337: end if;
338: -- Checking the rule output and the rule override flag.