DBA Data[Home] [Help]

APPS.BEN_PRV_LER dependencies on BENUTILS

Line 159: benutils.set_data_migrator_mode;

155: --
156: --
157: begin
158: -- Bug 3320133
159: benutils.set_data_migrator_mode;
160: if hr_general.g_data_migrator_mode in ( 'Y','P') then
161: --
162: return;
163: --

Line 333: benutils.exec_rule(

329: l_col_old_val := p_old.PRTT_RT_VAL_STAT_CD;
330: l_col_new_val := p_new.PRTT_RT_VAL_STAT_CD;
331: end if;
332: --
333: benutils.exec_rule(
334: p_formula_id => l_per_info_chg_cs_ler_rl,
335: p_effective_date => l_session_date,
336: p_lf_evt_ocrd_dt => null,
337: p_business_group_id => nvl(p_new.business_group_id, p_old.business_group_id),

Line 388: l_changed := (benutils.column_changed(p_old.cmcd_rt_val

384: --
385:
386: --
387: if l_column = 'CMCD_RT_VAL' then
388: l_changed := (benutils.column_changed(p_old.cmcd_rt_val
389: ,p_new.cmcd_rt_val,l_new_val) AND
390: benutils.column_changed(p_new.cmcd_rt_val
391: ,p_old.cmcd_rt_val,l_old_val) AND
392: (l_changed));

Line 390: benutils.column_changed(p_new.cmcd_rt_val

386: --
387: if l_column = 'CMCD_RT_VAL' then
388: l_changed := (benutils.column_changed(p_old.cmcd_rt_val
389: ,p_new.cmcd_rt_val,l_new_val) AND
390: benutils.column_changed(p_new.cmcd_rt_val
391: ,p_old.cmcd_rt_val,l_old_val) AND
392: (l_changed));
393: hr_utility.set_location(' l_changed:',60);
394: end if;

Line 397: l_changed := (benutils.column_changed(p_old.ann_rt_val

393: hr_utility.set_location(' l_changed:',60);
394: end if;
395: --
396: if l_column = 'ANN_RT_VAL' then
397: l_changed := (benutils.column_changed(p_old.ann_rt_val
398: ,p_new.ann_rt_val,l_new_val) AND
399: benutils.column_changed(p_new.ann_rt_val
400: ,p_old.ann_rt_val,l_old_val) AND
401: (l_changed));

Line 399: benutils.column_changed(p_new.ann_rt_val

395: --
396: if l_column = 'ANN_RT_VAL' then
397: l_changed := (benutils.column_changed(p_old.ann_rt_val
398: ,p_new.ann_rt_val,l_new_val) AND
399: benutils.column_changed(p_new.ann_rt_val
400: ,p_old.ann_rt_val,l_old_val) AND
401: (l_changed));
402: hr_utility.set_location(' l_changed:',70);
403: end if;

Line 409: l_changed := (benutils.column_changed(p_old.rt_val

405: if l_column = 'RT_VAL' then
406: hr_utility.set_location('Old rt_val '||p_old.rt_val, 20);
407: hr_utility.set_location('New rt val '||p_new.rt_val, 20);
408: hr_utility.set_location('lodt '||l_lf_evt_ocrd_date, 20);
409: l_changed := (benutils.column_changed(p_old.rt_val
410: ,p_new.rt_val,l_new_val) AND
411: benutils.column_changed(p_new.rt_val
412: ,p_old.rt_val,l_old_val) AND
413: (l_changed));

Line 411: benutils.column_changed(p_new.rt_val

407: hr_utility.set_location('New rt val '||p_new.rt_val, 20);
408: hr_utility.set_location('lodt '||l_lf_evt_ocrd_date, 20);
409: l_changed := (benutils.column_changed(p_old.rt_val
410: ,p_new.rt_val,l_new_val) AND
411: benutils.column_changed(p_new.rt_val
412: ,p_old.rt_val,l_old_val) AND
413: (l_changed));
414: hr_utility.set_location(' l_changed:',80);
415: end if;

Line 418: l_changed := (benutils.column_changed(p_old.rt_strt_dt

414: hr_utility.set_location(' l_changed:',80);
415: end if;
416: --
417: if l_column = 'RT_STRT_DT' then
418: l_changed := (benutils.column_changed(p_old.rt_strt_dt
419: ,p_new.rt_strt_dt,l_new_val) AND
420: benutils.column_changed(p_new.rt_strt_dt
421: ,p_old.rt_strt_dt,l_old_val) AND
422: (l_changed));

Line 420: benutils.column_changed(p_new.rt_strt_dt

416: --
417: if l_column = 'RT_STRT_DT' then
418: l_changed := (benutils.column_changed(p_old.rt_strt_dt
419: ,p_new.rt_strt_dt,l_new_val) AND
420: benutils.column_changed(p_new.rt_strt_dt
421: ,p_old.rt_strt_dt,l_old_val) AND
422: (l_changed));
423: hr_utility.set_location(' l_changed:',90);
424: end if;

Line 427: l_changed := (benutils.column_changed(p_old.rt_end_dt

423: hr_utility.set_location(' l_changed:',90);
424: end if;
425: --
426: if l_column = 'RT_END_DT' then
427: l_changed := (benutils.column_changed(p_old.rt_end_dt
428: ,p_new.rt_end_dt,l_new_val) AND
429: benutils.column_changed(p_new.rt_end_dt
430: ,p_old.rt_end_dt,l_old_val) AND
431: (l_changed));

Line 429: benutils.column_changed(p_new.rt_end_dt

425: --
426: if l_column = 'RT_END_DT' then
427: l_changed := (benutils.column_changed(p_old.rt_end_dt
428: ,p_new.rt_end_dt,l_new_val) AND
429: benutils.column_changed(p_new.rt_end_dt
430: ,p_old.rt_end_dt,l_old_val) AND
431: (l_changed));
432: hr_utility.set_location(' l_changed:',100);
433: --

Line 450: l_changed := (benutils.column_changed(p_old.rt_ovridn_flag

446: end if;
447: end if;
448: --
449: if l_column = 'RT_OVRIDN_FLAG' then
450: l_changed := (benutils.column_changed(p_old.rt_ovridn_flag
451: ,p_new.rt_ovridn_flag,l_new_val) AND
452: benutils.column_changed(p_new.rt_ovridn_flag
453: ,p_old.rt_ovridn_flag,l_old_val) AND
454: (l_changed));

Line 452: benutils.column_changed(p_new.rt_ovridn_flag

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

Line 459: l_changed := (benutils.column_changed(p_old.elctns_made_dt

455: hr_utility.set_location(' l_changed:',110);
456: end if;
457: --
458: if l_column = 'ELCTNS_MADE_DT' then
459: l_changed := (benutils.column_changed(p_old.elctns_made_dt
460: ,p_new.elctns_made_dt,l_new_val) AND
461: benutils.column_changed(p_new.elctns_made_dt
462: ,p_old.elctns_made_dt,l_old_val) AND
463: (l_changed));

Line 461: benutils.column_changed(p_new.elctns_made_dt

457: --
458: if l_column = 'ELCTNS_MADE_DT' then
459: l_changed := (benutils.column_changed(p_old.elctns_made_dt
460: ,p_new.elctns_made_dt,l_new_val) AND
461: benutils.column_changed(p_new.elctns_made_dt
462: ,p_old.elctns_made_dt,l_old_val) AND
463: (l_changed));
464: hr_utility.set_location(' l_changed:',120);
465: end if;

Line 468: l_changed := (benutils.column_changed(p_old.rt_ovridn_thru_dt

464: hr_utility.set_location(' l_changed:',120);
465: end if;
466: --
467: if l_column = 'RT_OVRIDN_THRU_DT' then
468: l_changed := (benutils.column_changed(p_old.rt_ovridn_thru_dt
469: ,p_new.rt_ovridn_thru_dt,l_new_val) AND
470: benutils.column_changed(p_new.rt_ovridn_thru_dt
471: ,p_old.rt_ovridn_thru_dt,l_old_val) AND
472: (l_changed));

Line 470: benutils.column_changed(p_new.rt_ovridn_thru_dt

466: --
467: if l_column = 'RT_OVRIDN_THRU_DT' then
468: l_changed := (benutils.column_changed(p_old.rt_ovridn_thru_dt
469: ,p_new.rt_ovridn_thru_dt,l_new_val) AND
470: benutils.column_changed(p_new.rt_ovridn_thru_dt
471: ,p_old.rt_ovridn_thru_dt,l_old_val) AND
472: (l_changed));
473: hr_utility.set_location(' l_changed:',130);
474: end if;