DBA Data[Home] [Help]

APPS.BEN_ECD_LER dependencies on BENUTILS

Line 155: benutils.set_data_migrator_mode;

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

Line 309: benutils.exec_rule(

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

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

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

Line 358: benutils.column_changed(p_new.cvg_strt_dt

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

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

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

Line 385: benutils.column_changed(p_new.cvg_thru_dt

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

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

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

Line 409: benutils.column_changed(p_new.effective_start_date

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

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

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

Line 421: benutils.column_changed(p_new.effective_end_date

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

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

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

Line 445: benutils.column_changed(p_new.ovrdn_flag

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

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

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

Line 454: benutils.column_changed(p_new.ovrdn_thru_dt

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