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: --
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),
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));
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;
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));
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;
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));
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;
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));
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;
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));
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: --
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));
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;
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));
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;
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));
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;