DBA Data[Home] [Help]

APPS.BEN_ECD_LER dependencies on BENUTILS

Line 152: benutils.set_data_migrator_mode;

148: --
149: begin
150:
151: -- Bug 3320133
152: benutils.set_data_migrator_mode;
153: if hr_general.g_data_migrator_mode in ( 'Y','P') then
154: --
155: return;
156: --

Line 306: benutils.exec_rule(

302: l_col_new_val := to_char(p_new.OVRDN_THRU_DT, 'YYYY/MM/DD HH24:MI:SS');
303: end if;
304: --
305: --
306: benutils.exec_rule(
307: p_formula_id => l_per_info_chg_cs_ler_rl,
308: p_effective_date => l_session_date,
309: p_lf_evt_ocrd_dt => null,
310: p_business_group_id => nvl(p_new.business_group_id, p_old.business_group_id),

Line 353: l_changed := (benutils.column_changed(p_old.cvg_strt_dt

349: --
350:
351: --
352: if l_column = 'CVG_STRT_DT' then
353: l_changed := (benutils.column_changed(p_old.cvg_strt_dt
354: ,p_new.cvg_strt_dt,l_new_val) AND
355: benutils.column_changed(p_new.cvg_strt_dt
356: ,p_old.cvg_strt_dt,l_old_val) AND
357: (l_changed));

Line 355: benutils.column_changed(p_new.cvg_strt_dt

351: --
352: if l_column = 'CVG_STRT_DT' then
353: l_changed := (benutils.column_changed(p_old.cvg_strt_dt
354: ,p_new.cvg_strt_dt,l_new_val) AND
355: benutils.column_changed(p_new.cvg_strt_dt
356: ,p_old.cvg_strt_dt,l_old_val) AND
357: (l_changed));
358: hr_utility.set_location(' CVG_STRT_DT',40);
359: --

Line 380: l_changed := (benutils.column_changed(p_old.cvg_thru_dt

376: if l_column = 'CVG_THRU_DT' then
377: if p_new.cvg_thru_dt = hr_api.g_eot then
378: l_changed := FALSE;
379: end if;
380: l_changed := (benutils.column_changed(p_old.cvg_thru_dt
381: ,p_new.cvg_thru_dt,l_new_val) AND
382: benutils.column_changed(p_new.cvg_thru_dt
383: ,p_old.cvg_thru_dt,l_old_val) AND
384: (l_changed));

Line 382: benutils.column_changed(p_new.cvg_thru_dt

378: l_changed := FALSE;
379: end if;
380: l_changed := (benutils.column_changed(p_old.cvg_thru_dt
381: ,p_new.cvg_thru_dt,l_new_val) AND
382: benutils.column_changed(p_new.cvg_thru_dt
383: ,p_old.cvg_thru_dt,l_old_val) AND
384: (l_changed));
385: hr_utility.set_location(' CVG_THRU_DT',41);
386: hr_utility.set_location(' p_new.cvg_thru_dt:'||to_char(p_new.cvg_thru_dt),41);

Line 404: l_changed := (benutils.column_changed(p_old.effective_start_date

400: --
401: end if;
402: --
403: if l_column = 'EFFECTIVE_START_DATE' then
404: l_changed := (benutils.column_changed(p_old.effective_start_date
405: ,p_new.effective_start_date,l_new_val) AND
406: benutils.column_changed(p_new.effective_start_date
407: ,p_old.effective_start_date,l_old_val) AND
408: (l_changed));

Line 406: benutils.column_changed(p_new.effective_start_date

402: --
403: if l_column = 'EFFECTIVE_START_DATE' then
404: l_changed := (benutils.column_changed(p_old.effective_start_date
405: ,p_new.effective_start_date,l_new_val) AND
406: benutils.column_changed(p_new.effective_start_date
407: ,p_old.effective_start_date,l_old_val) AND
408: (l_changed));
409: hr_utility.set_location(' EFFECTIVE_START_DATE',42);
410: end if;

Line 416: l_changed := (benutils.column_changed(p_old.effective_end_date

412: if l_column = 'EFFECTIVE_END_DATE' then
413: if p_new.effective_end_date = hr_api.g_eot then
414: l_changed := FALSE;
415: end if;
416: l_changed := (benutils.column_changed(p_old.effective_end_date
417: ,p_new.effective_end_date,l_new_val) AND
418: benutils.column_changed(p_new.effective_end_date
419: ,p_old.effective_end_date,l_old_val) AND
420: (l_changed));

Line 418: benutils.column_changed(p_new.effective_end_date

414: l_changed := FALSE;
415: end if;
416: l_changed := (benutils.column_changed(p_old.effective_end_date
417: ,p_new.effective_end_date,l_new_val) AND
418: benutils.column_changed(p_new.effective_end_date
419: ,p_old.effective_end_date,l_old_val) AND
420: (l_changed));
421: hr_utility.set_location(' EFFECTIVE_END_DATE',43);
422: --

Line 440: l_changed := (benutils.column_changed(p_old.ovrdn_flag

436: --
437: end if;
438: --
439: if l_column = 'OVRDN_FLAG' then
440: l_changed := (benutils.column_changed(p_old.ovrdn_flag
441: ,p_new.ovrdn_flag,l_new_val) AND
442: benutils.column_changed(p_new.ovrdn_flag
443: ,p_old.ovrdn_flag,l_old_val) AND
444: (l_changed));

Line 442: benutils.column_changed(p_new.ovrdn_flag

438: --
439: if l_column = 'OVRDN_FLAG' then
440: l_changed := (benutils.column_changed(p_old.ovrdn_flag
441: ,p_new.ovrdn_flag,l_new_val) AND
442: benutils.column_changed(p_new.ovrdn_flag
443: ,p_old.ovrdn_flag,l_old_val) AND
444: (l_changed));
445: hr_utility.set_location(' OVRDN_FLAG ',44);
446: end if;

Line 449: l_changed := (benutils.column_changed(p_old.ovrdn_thru_dt

445: hr_utility.set_location(' OVRDN_FLAG ',44);
446: end if;
447: --
448: if l_column = 'OVRDN_THRU_DT' then
449: l_changed := (benutils.column_changed(p_old.ovrdn_thru_dt
450: ,p_new.ovrdn_thru_dt,l_new_val) AND
451: benutils.column_changed(p_new.ovrdn_thru_dt
452: ,p_old.ovrdn_thru_dt,l_old_val) AND
453: (l_changed));

Line 451: benutils.column_changed(p_new.ovrdn_thru_dt

447: --
448: if l_column = 'OVRDN_THRU_DT' then
449: l_changed := (benutils.column_changed(p_old.ovrdn_thru_dt
450: ,p_new.ovrdn_thru_dt,l_new_val) AND
451: benutils.column_changed(p_new.ovrdn_thru_dt
452: ,p_old.ovrdn_thru_dt,l_old_val) AND
453: (l_changed));
454: hr_utility.set_location(' OVRDN_THRU_DT ',45);
455: end if;