DBA Data[Home] [Help]

APPS.BEN_PPS_LER dependencies on BENUTILS

Line 141: benutils.set_data_migrator_mode;

137: --
138: begin
139: --
140: -- Bug 3320133
141: benutils.set_data_migrator_mode;
142: -- End of Bug 3320133
143: if hr_general.g_data_migrator_mode in ( 'Y','P') then
144: --
145: -- We don't want triggers to fire

Line 283: benutils.exec_rule(

279: l_col_old_val := p_old.LEAVING_REASON;
280: l_col_new_val := p_new.LEAVING_REASON;
281: end if;
282: --
283: benutils.exec_rule(
284: p_formula_id => l_per_info_chg_cs_ler_rl,
285: p_effective_date => l_session_date,
286: p_lf_evt_ocrd_dt => null,
287: p_business_group_id => nvl(p_new.business_group_id, p_old.business_group_id),

Line 343: l_changed := (benutils.column_changed(p_old.FINAL_PROCESS_DATE

339:
340: --
341: -- Bug 1877018
342: if l_column = 'FINAL_PROCESS_DATE' then
343: l_changed := (benutils.column_changed(p_old.FINAL_PROCESS_DATE
344: ,p_new.FINAL_PROCESS_DATE,l_new_val) AND
345: benutils.column_changed(p_new.FINAL_PROCESS_DATE
346: ,p_old.FINAL_PROCESS_DATE,l_old_val) AND
347: (l_changed));

Line 345: benutils.column_changed(p_new.FINAL_PROCESS_DATE

341: -- Bug 1877018
342: if l_column = 'FINAL_PROCESS_DATE' then
343: l_changed := (benutils.column_changed(p_old.FINAL_PROCESS_DATE
344: ,p_new.FINAL_PROCESS_DATE,l_new_val) AND
345: benutils.column_changed(p_new.FINAL_PROCESS_DATE
346: ,p_old.FINAL_PROCESS_DATE,l_old_val) AND
347: (l_changed));
348: --
349: if l_ocrd_dt_cd is null then

Line 369: l_changed := (benutils.column_changed(p_old.date_start

365: hr_utility.set_location(' l_changed:',39);
366: end if;
367: --
368: if l_column = 'DATE_START' then
369: l_changed := (benutils.column_changed(p_old.date_start
370: ,p_new.date_start,l_new_val) AND
371: benutils.column_changed(p_new.date_start
372: ,p_old.date_start,l_old_val) AND
373: (l_changed));

Line 371: benutils.column_changed(p_new.date_start

367: --
368: if l_column = 'DATE_START' then
369: l_changed := (benutils.column_changed(p_old.date_start
370: ,p_new.date_start,l_new_val) AND
371: benutils.column_changed(p_new.date_start
372: ,p_old.date_start,l_old_val) AND
373: (l_changed));
374: hr_utility.set_location(' l_changed:',40);
375: --

Line 399: l_changed := (benutils.column_changed(p_old.actual_termination_date

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

Line 401: benutils.column_changed(p_new.actual_termination_date

397: --
398: if l_column = 'ACTUAL_TERMINATION_DATE' then
399: l_changed := (benutils.column_changed(p_old.actual_termination_date
400: ,p_new.actual_termination_date,l_new_val) AND
401: benutils.column_changed(p_new.actual_termination_date
402: ,p_old.actual_termination_date,l_old_val) AND
403: (l_changed));
404: --
405: if l_ocrd_dt_cd is null then

Line 421: l_changed := (benutils.column_changed(p_old.leaving_reason

417: end if;
418: end if;
419: --
420: if l_column = 'LEAVING_REASON' then
421: l_changed := (benutils.column_changed(p_old.leaving_reason
422: ,p_new.leaving_reason,l_new_val) AND
423: benutils.column_changed(p_new.leaving_reason
424: ,p_old.leaving_reason,l_old_val) AND
425: (l_changed));

Line 423: benutils.column_changed(p_new.leaving_reason

419: --
420: if l_column = 'LEAVING_REASON' then
421: l_changed := (benutils.column_changed(p_old.leaving_reason
422: ,p_new.leaving_reason,l_new_val) AND
423: benutils.column_changed(p_new.leaving_reason
424: ,p_old.leaving_reason,l_old_val) AND
425: (l_changed));
426: --
427: if l_ocrd_dt_cd is null then

Line 445: l_changed := (benutils.column_changed(p_old.adjusted_svc_date

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

Line 447: benutils.column_changed(p_new.adjusted_svc_date

443: --
444: if l_column = 'ADJUSTED_SVC_DATE' then
445: l_changed := (benutils.column_changed(p_old.adjusted_svc_date
446: ,p_new.adjusted_svc_date,l_new_val) AND
447: benutils.column_changed(p_new.adjusted_svc_date
448: ,p_old.adjusted_svc_date,l_old_val) AND
449: (l_changed));
450: end if;
451: --

Line 453: l_changed := (benutils.column_changed(p_old.attribute1

449: (l_changed));
450: end if;
451: --
452: if l_column = 'ATTRIBUTE1' then
453: l_changed := (benutils.column_changed(p_old.attribute1
454: ,p_new.attribute1,l_new_val) AND
455: benutils.column_changed(p_new.attribute1
456: ,p_old.attribute1,l_old_val) AND
457: (l_changed));

Line 455: benutils.column_changed(p_new.attribute1

451: --
452: if l_column = 'ATTRIBUTE1' then
453: l_changed := (benutils.column_changed(p_old.attribute1
454: ,p_new.attribute1,l_new_val) AND
455: benutils.column_changed(p_new.attribute1
456: ,p_old.attribute1,l_old_val) AND
457: (l_changed));
458: end if;
459: --

Line 461: l_changed := (benutils.column_changed(p_old.attribute2

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

Line 463: benutils.column_changed(p_new.attribute2

459: --
460: if l_column = 'ATTRIBUTE2' then
461: l_changed := (benutils.column_changed(p_old.attribute2
462: ,p_new.attribute2,l_new_val) AND
463: benutils.column_changed(p_new.attribute2
464: ,p_old.attribute2,l_old_val) AND
465: (l_changed));
466: end if;
467: --

Line 469: l_changed := (benutils.column_changed(p_old.attribute3

465: (l_changed));
466: end if;
467: --
468: if l_column = 'ATTRIBUTE3' then
469: l_changed := (benutils.column_changed(p_old.attribute3
470: ,p_new.attribute3,l_new_val) AND
471: benutils.column_changed(p_new.attribute3
472: ,p_old.attribute3,l_old_val) AND
473: (l_changed));

Line 471: benutils.column_changed(p_new.attribute3

467: --
468: if l_column = 'ATTRIBUTE3' then
469: l_changed := (benutils.column_changed(p_old.attribute3
470: ,p_new.attribute3,l_new_val) AND
471: benutils.column_changed(p_new.attribute3
472: ,p_old.attribute3,l_old_val) AND
473: (l_changed));
474: end if;
475: --

Line 477: l_changed := (benutils.column_changed(p_old.attribute4

473: (l_changed));
474: end if;
475: --
476: if l_column = 'ATTRIBUTE4' then
477: l_changed := (benutils.column_changed(p_old.attribute4
478: ,p_new.attribute4,l_new_val) AND
479: benutils.column_changed(p_new.attribute4
480: ,p_old.attribute4,l_old_val) AND
481: (l_changed));

Line 479: benutils.column_changed(p_new.attribute4

475: --
476: if l_column = 'ATTRIBUTE4' then
477: l_changed := (benutils.column_changed(p_old.attribute4
478: ,p_new.attribute4,l_new_val) AND
479: benutils.column_changed(p_new.attribute4
480: ,p_old.attribute4,l_old_val) AND
481: (l_changed));
482: end if;
483: --

Line 485: l_changed := (benutils.column_changed(p_old.attribute5

481: (l_changed));
482: end if;
483: --
484: if l_column = 'ATTRIBUTE5' then
485: l_changed := (benutils.column_changed(p_old.attribute5
486: ,p_new.attribute5,l_new_val) AND
487: benutils.column_changed(p_new.attribute5
488: ,p_old.attribute5,l_old_val) AND
489: (l_changed));

Line 487: benutils.column_changed(p_new.attribute5

483: --
484: if l_column = 'ATTRIBUTE5' then
485: l_changed := (benutils.column_changed(p_old.attribute5
486: ,p_new.attribute5,l_new_val) AND
487: benutils.column_changed(p_new.attribute5
488: ,p_old.attribute5,l_old_val) AND
489: (l_changed));
490: end if;
491: --