eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_AUD_UPD dependencies on HR_API

Line 97: When hr_api.check_integrity_violated Then

93: --
94: hr_utility.set_location(' Leaving:'||l_proc, 10);
95: --
96: Exception
97: When hr_api.check_integrity_violated Then
98: -- A check constraint has been violated
99: --
100: ben_aud_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

97: When hr_api.check_integrity_violated Then
98: -- A check constraint has been violated
99: --
100: ben_aud_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When hr_api.parent_integrity_violated Then
103: -- Parent integrity has been violated
104: --
105: ben_aud_shd.constraint_error

Line 102: When hr_api.parent_integrity_violated Then

98: -- A check constraint has been violated
99: --
100: ben_aud_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When hr_api.parent_integrity_violated Then
103: -- Parent integrity has been violated
104: --
105: ben_aud_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

102: When hr_api.parent_integrity_violated Then
103: -- Parent integrity has been violated
104: --
105: ben_aud_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When hr_api.unique_integrity_violated Then
108: -- Unique integrity has been violated
109: --
110: ben_aud_shd.constraint_error

Line 107: When hr_api.unique_integrity_violated Then

103: -- Parent integrity has been violated
104: --
105: ben_aud_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When hr_api.unique_integrity_violated Then
108: -- Unique integrity has been violated
109: --
110: ben_aud_shd.constraint_error
111: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 111: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

107: When hr_api.unique_integrity_violated Then
108: -- Unique integrity has been violated
109: --
110: ben_aud_shd.constraint_error
111: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
112: When Others Then
113: --
114: Raise;
115: End update_dml;

Line 278: when hr_api.cannot_find_prog_unit then

274: );
275: --
276: exception
277: --
278: when hr_api.cannot_find_prog_unit then
279: --
280: hr_api.cannot_find_prog_unit_error
281: (p_module_name => 'BEN_CWB_AUDIT'
282: ,p_hook_type => 'AU');

Line 280: hr_api.cannot_find_prog_unit_error

276: exception
277: --
278: when hr_api.cannot_find_prog_unit then
279: --
280: hr_api.cannot_find_prog_unit_error
281: (p_module_name => 'BEN_CWB_AUDIT'
282: ,p_hook_type => 'AU');
283: --
284: end;

Line 343: If (p_rec.group_per_in_ler_id = hr_api.g_number) then

339: -- p_rec plsql record structure
340: -- to see if a system default is being used. If a system default
341: -- is being used then we must set to the 'current' argument value.
342: --
343: If (p_rec.group_per_in_ler_id = hr_api.g_number) then
344: p_rec.group_per_in_ler_id :=
345: ben_aud_shd.g_old_rec.group_per_in_ler_id;
346: End If;
347: If (p_rec.group_pl_id = hr_api.g_number) then

Line 347: If (p_rec.group_pl_id = hr_api.g_number) then

343: If (p_rec.group_per_in_ler_id = hr_api.g_number) then
344: p_rec.group_per_in_ler_id :=
345: ben_aud_shd.g_old_rec.group_per_in_ler_id;
346: End If;
347: If (p_rec.group_pl_id = hr_api.g_number) then
348: p_rec.group_pl_id :=
349: ben_aud_shd.g_old_rec.group_pl_id;
350: End If;
351: If (p_rec.lf_evt_ocrd_dt = hr_api.g_date) then

Line 351: If (p_rec.lf_evt_ocrd_dt = hr_api.g_date) then

347: If (p_rec.group_pl_id = hr_api.g_number) then
348: p_rec.group_pl_id :=
349: ben_aud_shd.g_old_rec.group_pl_id;
350: End If;
351: If (p_rec.lf_evt_ocrd_dt = hr_api.g_date) then
352: p_rec.lf_evt_ocrd_dt :=
353: ben_aud_shd.g_old_rec.lf_evt_ocrd_dt;
354: End If;
355: If (p_rec.pl_id = hr_api.g_number) then

Line 355: If (p_rec.pl_id = hr_api.g_number) then

351: If (p_rec.lf_evt_ocrd_dt = hr_api.g_date) then
352: p_rec.lf_evt_ocrd_dt :=
353: ben_aud_shd.g_old_rec.lf_evt_ocrd_dt;
354: End If;
355: If (p_rec.pl_id = hr_api.g_number) then
356: p_rec.pl_id :=
357: ben_aud_shd.g_old_rec.pl_id;
358: End If;
359: If (p_rec.group_oipl_id = hr_api.g_number) then

Line 359: If (p_rec.group_oipl_id = hr_api.g_number) then

355: If (p_rec.pl_id = hr_api.g_number) then
356: p_rec.pl_id :=
357: ben_aud_shd.g_old_rec.pl_id;
358: End If;
359: If (p_rec.group_oipl_id = hr_api.g_number) then
360: p_rec.group_oipl_id :=
361: ben_aud_shd.g_old_rec.group_oipl_id;
362: End If;
363: If (p_rec.audit_type_cd = hr_api.g_varchar2) then

Line 363: If (p_rec.audit_type_cd = hr_api.g_varchar2) then

359: If (p_rec.group_oipl_id = hr_api.g_number) then
360: p_rec.group_oipl_id :=
361: ben_aud_shd.g_old_rec.group_oipl_id;
362: End If;
363: If (p_rec.audit_type_cd = hr_api.g_varchar2) then
364: p_rec.audit_type_cd :=
365: ben_aud_shd.g_old_rec.audit_type_cd;
366: End If;
367: If (p_rec.old_val_varchar = hr_api.g_varchar2) then

Line 367: If (p_rec.old_val_varchar = hr_api.g_varchar2) then

363: If (p_rec.audit_type_cd = hr_api.g_varchar2) then
364: p_rec.audit_type_cd :=
365: ben_aud_shd.g_old_rec.audit_type_cd;
366: End If;
367: If (p_rec.old_val_varchar = hr_api.g_varchar2) then
368: p_rec.old_val_varchar :=
369: ben_aud_shd.g_old_rec.old_val_varchar;
370: End If;
371: If (p_rec.new_val_varchar = hr_api.g_varchar2) then

Line 371: If (p_rec.new_val_varchar = hr_api.g_varchar2) then

367: If (p_rec.old_val_varchar = hr_api.g_varchar2) then
368: p_rec.old_val_varchar :=
369: ben_aud_shd.g_old_rec.old_val_varchar;
370: End If;
371: If (p_rec.new_val_varchar = hr_api.g_varchar2) then
372: p_rec.new_val_varchar :=
373: ben_aud_shd.g_old_rec.new_val_varchar;
374: End If;
375: If (p_rec.old_val_number = hr_api.g_number) then

Line 375: If (p_rec.old_val_number = hr_api.g_number) then

371: If (p_rec.new_val_varchar = hr_api.g_varchar2) then
372: p_rec.new_val_varchar :=
373: ben_aud_shd.g_old_rec.new_val_varchar;
374: End If;
375: If (p_rec.old_val_number = hr_api.g_number) then
376: p_rec.old_val_number :=
377: ben_aud_shd.g_old_rec.old_val_number;
378: End If;
379: If (p_rec.new_val_number = hr_api.g_number) then

Line 379: If (p_rec.new_val_number = hr_api.g_number) then

375: If (p_rec.old_val_number = hr_api.g_number) then
376: p_rec.old_val_number :=
377: ben_aud_shd.g_old_rec.old_val_number;
378: End If;
379: If (p_rec.new_val_number = hr_api.g_number) then
380: p_rec.new_val_number :=
381: ben_aud_shd.g_old_rec.new_val_number;
382: End If;
383: If (p_rec.old_val_date = hr_api.g_date) then

Line 383: If (p_rec.old_val_date = hr_api.g_date) then

379: If (p_rec.new_val_number = hr_api.g_number) then
380: p_rec.new_val_number :=
381: ben_aud_shd.g_old_rec.new_val_number;
382: End If;
383: If (p_rec.old_val_date = hr_api.g_date) then
384: p_rec.old_val_date :=
385: ben_aud_shd.g_old_rec.old_val_date;
386: End If;
387: If (p_rec.new_val_date = hr_api.g_date) then

Line 387: If (p_rec.new_val_date = hr_api.g_date) then

383: If (p_rec.old_val_date = hr_api.g_date) then
384: p_rec.old_val_date :=
385: ben_aud_shd.g_old_rec.old_val_date;
386: End If;
387: If (p_rec.new_val_date = hr_api.g_date) then
388: p_rec.new_val_date :=
389: ben_aud_shd.g_old_rec.new_val_date;
390: End If;
391: If (p_rec.date_stamp = hr_api.g_date) then

Line 391: If (p_rec.date_stamp = hr_api.g_date) then

387: If (p_rec.new_val_date = hr_api.g_date) then
388: p_rec.new_val_date :=
389: ben_aud_shd.g_old_rec.new_val_date;
390: End If;
391: If (p_rec.date_stamp = hr_api.g_date) then
392: p_rec.date_stamp :=
393: ben_aud_shd.g_old_rec.date_stamp;
394: End If;
395: If (p_rec.change_made_by_person_id = hr_api.g_number) then

Line 395: If (p_rec.change_made_by_person_id = hr_api.g_number) then

391: If (p_rec.date_stamp = hr_api.g_date) then
392: p_rec.date_stamp :=
393: ben_aud_shd.g_old_rec.date_stamp;
394: End If;
395: If (p_rec.change_made_by_person_id = hr_api.g_number) then
396: p_rec.change_made_by_person_id :=
397: ben_aud_shd.g_old_rec.change_made_by_person_id;
398: End If;
399: If (p_rec.supporting_information = hr_api.g_varchar2) then

Line 399: If (p_rec.supporting_information = hr_api.g_varchar2) then

395: If (p_rec.change_made_by_person_id = hr_api.g_number) then
396: p_rec.change_made_by_person_id :=
397: ben_aud_shd.g_old_rec.change_made_by_person_id;
398: End If;
399: If (p_rec.supporting_information = hr_api.g_varchar2) then
400: p_rec.supporting_information :=
401: ben_aud_shd.g_old_rec.supporting_information;
402: End If;
403: If (p_rec.request_id = hr_api.g_number) then

Line 403: If (p_rec.request_id = hr_api.g_number) then

399: If (p_rec.supporting_information = hr_api.g_varchar2) then
400: p_rec.supporting_information :=
401: ben_aud_shd.g_old_rec.supporting_information;
402: End If;
403: If (p_rec.request_id = hr_api.g_number) then
404: p_rec.request_id :=
405: ben_aud_shd.g_old_rec.request_id;
406: End If;
407: --

Line 467: ,p_group_per_in_ler_id in number default hr_api.g_number

463: -- ----------------------------------------------------------------------------
464: Procedure upd
465: (p_cwb_audit_id in number
466: ,p_object_version_number in out nocopy number
467: ,p_group_per_in_ler_id in number default hr_api.g_number
468: ,p_group_pl_id in number default hr_api.g_number
469: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
470: ,p_pl_id in number default hr_api.g_number
471: ,p_audit_type_cd in varchar2 default hr_api.g_varchar2

Line 468: ,p_group_pl_id in number default hr_api.g_number

464: Procedure upd
465: (p_cwb_audit_id in number
466: ,p_object_version_number in out nocopy number
467: ,p_group_per_in_ler_id in number default hr_api.g_number
468: ,p_group_pl_id in number default hr_api.g_number
469: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
470: ,p_pl_id in number default hr_api.g_number
471: ,p_audit_type_cd in varchar2 default hr_api.g_varchar2
472: ,p_group_oipl_id in number default hr_api.g_number

Line 469: ,p_lf_evt_ocrd_dt in date default hr_api.g_date

465: (p_cwb_audit_id in number
466: ,p_object_version_number in out nocopy number
467: ,p_group_per_in_ler_id in number default hr_api.g_number
468: ,p_group_pl_id in number default hr_api.g_number
469: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
470: ,p_pl_id in number default hr_api.g_number
471: ,p_audit_type_cd in varchar2 default hr_api.g_varchar2
472: ,p_group_oipl_id in number default hr_api.g_number
473: ,p_old_val_varchar in varchar2 default hr_api.g_varchar2

Line 470: ,p_pl_id in number default hr_api.g_number

466: ,p_object_version_number in out nocopy number
467: ,p_group_per_in_ler_id in number default hr_api.g_number
468: ,p_group_pl_id in number default hr_api.g_number
469: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
470: ,p_pl_id in number default hr_api.g_number
471: ,p_audit_type_cd in varchar2 default hr_api.g_varchar2
472: ,p_group_oipl_id in number default hr_api.g_number
473: ,p_old_val_varchar in varchar2 default hr_api.g_varchar2
474: ,p_new_val_varchar in varchar2 default hr_api.g_varchar2

Line 471: ,p_audit_type_cd in varchar2 default hr_api.g_varchar2

467: ,p_group_per_in_ler_id in number default hr_api.g_number
468: ,p_group_pl_id in number default hr_api.g_number
469: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
470: ,p_pl_id in number default hr_api.g_number
471: ,p_audit_type_cd in varchar2 default hr_api.g_varchar2
472: ,p_group_oipl_id in number default hr_api.g_number
473: ,p_old_val_varchar in varchar2 default hr_api.g_varchar2
474: ,p_new_val_varchar in varchar2 default hr_api.g_varchar2
475: ,p_old_val_number in number default hr_api.g_number

Line 472: ,p_group_oipl_id in number default hr_api.g_number

468: ,p_group_pl_id in number default hr_api.g_number
469: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
470: ,p_pl_id in number default hr_api.g_number
471: ,p_audit_type_cd in varchar2 default hr_api.g_varchar2
472: ,p_group_oipl_id in number default hr_api.g_number
473: ,p_old_val_varchar in varchar2 default hr_api.g_varchar2
474: ,p_new_val_varchar in varchar2 default hr_api.g_varchar2
475: ,p_old_val_number in number default hr_api.g_number
476: ,p_new_val_number in number default hr_api.g_number

Line 473: ,p_old_val_varchar in varchar2 default hr_api.g_varchar2

469: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
470: ,p_pl_id in number default hr_api.g_number
471: ,p_audit_type_cd in varchar2 default hr_api.g_varchar2
472: ,p_group_oipl_id in number default hr_api.g_number
473: ,p_old_val_varchar in varchar2 default hr_api.g_varchar2
474: ,p_new_val_varchar in varchar2 default hr_api.g_varchar2
475: ,p_old_val_number in number default hr_api.g_number
476: ,p_new_val_number in number default hr_api.g_number
477: ,p_old_val_date in date default hr_api.g_date

Line 474: ,p_new_val_varchar in varchar2 default hr_api.g_varchar2

470: ,p_pl_id in number default hr_api.g_number
471: ,p_audit_type_cd in varchar2 default hr_api.g_varchar2
472: ,p_group_oipl_id in number default hr_api.g_number
473: ,p_old_val_varchar in varchar2 default hr_api.g_varchar2
474: ,p_new_val_varchar in varchar2 default hr_api.g_varchar2
475: ,p_old_val_number in number default hr_api.g_number
476: ,p_new_val_number in number default hr_api.g_number
477: ,p_old_val_date in date default hr_api.g_date
478: ,p_new_val_date in date default hr_api.g_date

Line 475: ,p_old_val_number in number default hr_api.g_number

471: ,p_audit_type_cd in varchar2 default hr_api.g_varchar2
472: ,p_group_oipl_id in number default hr_api.g_number
473: ,p_old_val_varchar in varchar2 default hr_api.g_varchar2
474: ,p_new_val_varchar in varchar2 default hr_api.g_varchar2
475: ,p_old_val_number in number default hr_api.g_number
476: ,p_new_val_number in number default hr_api.g_number
477: ,p_old_val_date in date default hr_api.g_date
478: ,p_new_val_date in date default hr_api.g_date
479: ,p_date_stamp in date default hr_api.g_date

Line 476: ,p_new_val_number in number default hr_api.g_number

472: ,p_group_oipl_id in number default hr_api.g_number
473: ,p_old_val_varchar in varchar2 default hr_api.g_varchar2
474: ,p_new_val_varchar in varchar2 default hr_api.g_varchar2
475: ,p_old_val_number in number default hr_api.g_number
476: ,p_new_val_number in number default hr_api.g_number
477: ,p_old_val_date in date default hr_api.g_date
478: ,p_new_val_date in date default hr_api.g_date
479: ,p_date_stamp in date default hr_api.g_date
480: ,p_change_made_by_person_id in number default hr_api.g_number

Line 477: ,p_old_val_date in date default hr_api.g_date

473: ,p_old_val_varchar in varchar2 default hr_api.g_varchar2
474: ,p_new_val_varchar in varchar2 default hr_api.g_varchar2
475: ,p_old_val_number in number default hr_api.g_number
476: ,p_new_val_number in number default hr_api.g_number
477: ,p_old_val_date in date default hr_api.g_date
478: ,p_new_val_date in date default hr_api.g_date
479: ,p_date_stamp in date default hr_api.g_date
480: ,p_change_made_by_person_id in number default hr_api.g_number
481: ,p_supporting_information in varchar2 default hr_api.g_varchar2

Line 478: ,p_new_val_date in date default hr_api.g_date

474: ,p_new_val_varchar in varchar2 default hr_api.g_varchar2
475: ,p_old_val_number in number default hr_api.g_number
476: ,p_new_val_number in number default hr_api.g_number
477: ,p_old_val_date in date default hr_api.g_date
478: ,p_new_val_date in date default hr_api.g_date
479: ,p_date_stamp in date default hr_api.g_date
480: ,p_change_made_by_person_id in number default hr_api.g_number
481: ,p_supporting_information in varchar2 default hr_api.g_varchar2
482: ,p_request_id in number default hr_api.g_number

Line 479: ,p_date_stamp in date default hr_api.g_date

475: ,p_old_val_number in number default hr_api.g_number
476: ,p_new_val_number in number default hr_api.g_number
477: ,p_old_val_date in date default hr_api.g_date
478: ,p_new_val_date in date default hr_api.g_date
479: ,p_date_stamp in date default hr_api.g_date
480: ,p_change_made_by_person_id in number default hr_api.g_number
481: ,p_supporting_information in varchar2 default hr_api.g_varchar2
482: ,p_request_id in number default hr_api.g_number
483: ) is

Line 480: ,p_change_made_by_person_id in number default hr_api.g_number

476: ,p_new_val_number in number default hr_api.g_number
477: ,p_old_val_date in date default hr_api.g_date
478: ,p_new_val_date in date default hr_api.g_date
479: ,p_date_stamp in date default hr_api.g_date
480: ,p_change_made_by_person_id in number default hr_api.g_number
481: ,p_supporting_information in varchar2 default hr_api.g_varchar2
482: ,p_request_id in number default hr_api.g_number
483: ) is
484: --

Line 481: ,p_supporting_information in varchar2 default hr_api.g_varchar2

477: ,p_old_val_date in date default hr_api.g_date
478: ,p_new_val_date in date default hr_api.g_date
479: ,p_date_stamp in date default hr_api.g_date
480: ,p_change_made_by_person_id in number default hr_api.g_number
481: ,p_supporting_information in varchar2 default hr_api.g_varchar2
482: ,p_request_id in number default hr_api.g_number
483: ) is
484: --
485: l_rec ben_aud_shd.g_rec_type;

Line 482: ,p_request_id in number default hr_api.g_number

478: ,p_new_val_date in date default hr_api.g_date
479: ,p_date_stamp in date default hr_api.g_date
480: ,p_change_made_by_person_id in number default hr_api.g_number
481: ,p_supporting_information in varchar2 default hr_api.g_varchar2
482: ,p_request_id in number default hr_api.g_number
483: ) is
484: --
485: l_rec ben_aud_shd.g_rec_type;
486: l_proc varchar2(72) := g_package||'upd';