165: --
166: BEGIN
167: --
168: -- Bug 3320133
169: benutils.set_data_migrator_mode;
170: -- End of Bug 3320133
171:
172: -- Not to be called when Data Migrator is in progress
173: --
336: l_col_old_val := TO_CHAR(p_old.elig_cvrd_dpnt_id);
337: l_col_new_val := TO_CHAR(p_new.elig_cvrd_dpnt_id);
338: END IF;
339: --
340: benutils.exec_rule(
341: p_formula_id => l_per_info_chg_cs_ler_rl,
342: p_effective_date => l_session_date,
343: p_lf_evt_ocrd_dt => NULL,
344: p_business_group_id => l_rec_business_group_id,
404: --
405: IF l_column = 'ELIG_STRT_DT' THEN
406: l_changed :=
407: (
408: benutils.column_changed(
409: p_old.elig_strt_dt,
410: p_new.elig_strt_dt,
411: l_new_val)
412: AND benutils.column_changed(
408: benutils.column_changed(
409: p_old.elig_strt_dt,
410: p_new.elig_strt_dt,
411: l_new_val)
412: AND benutils.column_changed(
413: p_new.elig_strt_dt,
414: p_old.elig_strt_dt,
415: l_old_val)
416: AND (l_changed));
417: hr_utility.set_location(' l_changed:', 40);
418: ELSIF l_column = 'ELIG_THRU_DT' THEN
419: l_changed :=
420: (
421: benutils.column_changed(
422: p_old.elig_thru_dt,
423: p_new.elig_thru_dt,
424: l_new_val)
425: AND benutils.column_changed(
421: benutils.column_changed(
422: p_old.elig_thru_dt,
423: p_new.elig_thru_dt,
424: l_new_val)
425: AND benutils.column_changed(
426: p_new.elig_thru_dt,
427: p_old.elig_thru_dt,
428: l_old_val)
429: AND (l_changed));
443: --
444: ELSIF l_column = 'DPNT_INELIG_FLAG' THEN
445: l_changed :=
446: (
447: benutils.column_changed(
448: p_old.dpnt_inelig_flag,
449: p_new.dpnt_inelig_flag,
450: l_new_val)
451: AND benutils.column_changed(
447: benutils.column_changed(
448: p_old.dpnt_inelig_flag,
449: p_new.dpnt_inelig_flag,
450: l_new_val)
451: AND benutils.column_changed(
452: p_new.dpnt_inelig_flag,
453: p_old.dpnt_inelig_flag,
454: l_old_val)
455: AND (l_changed));
469: --
470: ELSIF l_column = 'OVRDN_THRU_DT' THEN
471: l_changed :=
472: (
473: benutils.column_changed(
474: p_old.ovrdn_thru_dt,
475: p_new.ovrdn_thru_dt,
476: l_new_val)
477: AND benutils.column_changed(
473: benutils.column_changed(
474: p_old.ovrdn_thru_dt,
475: p_new.ovrdn_thru_dt,
476: l_new_val)
477: AND benutils.column_changed(
478: p_new.ovrdn_thru_dt,
479: p_old.ovrdn_thru_dt,
480: l_old_val)
481: AND (l_changed));
502: 20);
503: hr_utility.set_location('lodt ' || l_lf_evt_ocrd_date, 20);
504: l_changed :=
505: (
506: benutils.column_changed(
507: p_old.ovrdn_flag,
508: p_new.ovrdn_flag,
509: l_new_val)
510: AND benutils.column_changed(
506: benutils.column_changed(
507: p_old.ovrdn_flag,
508: p_new.ovrdn_flag,
509: l_new_val)
510: AND benutils.column_changed(
511: p_new.ovrdn_flag,
512: p_old.ovrdn_flag,
513: l_old_val)
514: AND (l_changed));