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_ESW_UPD dependencies on HR_API

Line 70: If (p_datetrack_mode = hr_api.g_correction) then

66: --
67: Begin
68: hr_utility.set_location('Entering:'||l_proc, 5);
69: --
70: If (p_datetrack_mode = hr_api.g_correction) then
71: hr_utility.set_location(l_proc, 10);
72: --
73: -- Because we are updating a row we must get the next object
74: -- version number.

Line 114: When hr_api.check_integrity_violated Then

110: End If;
111: --
112: hr_utility.set_location(' Leaving:'||l_proc, 15);
113: Exception
114: When hr_api.check_integrity_violated Then
115: -- A check constraint has been violated
116: --
117: ben_esw_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

114: When hr_api.check_integrity_violated Then
115: -- A check constraint has been violated
116: --
117: ben_esw_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.unique_integrity_violated Then
120: -- Unique integrity has been violated
121: --
122: ben_esw_shd.constraint_error

Line 119: When hr_api.unique_integrity_violated Then

115: -- A check constraint has been violated
116: --
117: ben_esw_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.unique_integrity_violated Then
120: -- Unique integrity has been violated
121: --
122: ben_esw_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

119: When hr_api.unique_integrity_violated Then
120: -- Unique integrity has been violated
121: --
122: ben_esw_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When Others Then
125: --
126: Raise;
127: End dt_update_dml;

Line 240: If (p_datetrack_mode <> hr_api.g_correction) then

236: l_dummy_version_number number;
237: --
238: Begin
239: hr_utility.set_location('Entering:'||l_proc, 5);
240: If (p_datetrack_mode <> hr_api.g_correction) then
241: --
242: -- Update the current effective end date
243: --
244: ben_esw_shd.upd_effective_end_date

Line 253: If (p_datetrack_mode = hr_api.g_update_override) then

249: ,p_validation_end_date => p_validation_end_date
250: ,p_object_version_number => l_dummy_version_number
251: );
252: --
253: If (p_datetrack_mode = hr_api.g_update_override) then
254: --
255: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
256: -- delete any future rows
257: --

Line 447: when hr_api.cannot_find_prog_unit then

443: );
444: --
445: exception
446: --
447: when hr_api.cannot_find_prog_unit then
448: --
449: hr_api.cannot_find_prog_unit_error
450: (p_module_name => 'BEN_ELIG_SCRE_WTG_F'
451: ,p_hook_type => 'AU');

Line 449: hr_api.cannot_find_prog_unit_error

445: exception
446: --
447: when hr_api.cannot_find_prog_unit then
448: --
449: hr_api.cannot_find_prog_unit_error
450: (p_module_name => 'BEN_ELIG_SCRE_WTG_F'
451: ,p_hook_type => 'AU');
452: --
453: end;

Line 512: If (p_rec.elig_per_id = hr_api.g_number) then

508: -- p_rec plsql record structure
509: -- to see if a system default is being used. If a system default
510: -- is being used then we must set to the 'current' argument value.
511: --
512: If (p_rec.elig_per_id = hr_api.g_number) then
513: p_rec.elig_per_id :=
514: ben_esw_shd.g_old_rec.elig_per_id;
515: End If;
516: If (p_rec.elig_per_opt_id = hr_api.g_number) then

Line 516: If (p_rec.elig_per_opt_id = hr_api.g_number) then

512: If (p_rec.elig_per_id = hr_api.g_number) then
513: p_rec.elig_per_id :=
514: ben_esw_shd.g_old_rec.elig_per_id;
515: End If;
516: If (p_rec.elig_per_opt_id = hr_api.g_number) then
517: p_rec.elig_per_opt_id :=
518: ben_esw_shd.g_old_rec.elig_per_opt_id;
519: End If;
520: If (p_rec.elig_rslt_id = hr_api.g_number) then

Line 520: If (p_rec.elig_rslt_id = hr_api.g_number) then

516: If (p_rec.elig_per_opt_id = hr_api.g_number) then
517: p_rec.elig_per_opt_id :=
518: ben_esw_shd.g_old_rec.elig_per_opt_id;
519: End If;
520: If (p_rec.elig_rslt_id = hr_api.g_number) then
521: p_rec.elig_rslt_id :=
522: ben_esw_shd.g_old_rec.elig_rslt_id;
523: End If;
524: If (p_rec.per_in_ler_id = hr_api.g_number) then

Line 524: If (p_rec.per_in_ler_id = hr_api.g_number) then

520: If (p_rec.elig_rslt_id = hr_api.g_number) then
521: p_rec.elig_rslt_id :=
522: ben_esw_shd.g_old_rec.elig_rslt_id;
523: End If;
524: If (p_rec.per_in_ler_id = hr_api.g_number) then
525: p_rec.per_in_ler_id :=
526: ben_esw_shd.g_old_rec.per_in_ler_id;
527: End If;
528: If (p_rec.eligy_prfl_id = hr_api.g_number) then

Line 528: If (p_rec.eligy_prfl_id = hr_api.g_number) then

524: If (p_rec.per_in_ler_id = hr_api.g_number) then
525: p_rec.per_in_ler_id :=
526: ben_esw_shd.g_old_rec.per_in_ler_id;
527: End If;
528: If (p_rec.eligy_prfl_id = hr_api.g_number) then
529: p_rec.eligy_prfl_id :=
530: ben_esw_shd.g_old_rec.eligy_prfl_id;
531: End If;
532: If (p_rec.crit_tab_short_name = hr_api.g_varchar2) then

Line 532: If (p_rec.crit_tab_short_name = hr_api.g_varchar2) then

528: If (p_rec.eligy_prfl_id = hr_api.g_number) then
529: p_rec.eligy_prfl_id :=
530: ben_esw_shd.g_old_rec.eligy_prfl_id;
531: End If;
532: If (p_rec.crit_tab_short_name = hr_api.g_varchar2) then
533: p_rec.crit_tab_short_name :=
534: ben_esw_shd.g_old_rec.crit_tab_short_name;
535: End If;
536: If (p_rec.crit_tab_pk_id = hr_api.g_number) then

Line 536: If (p_rec.crit_tab_pk_id = hr_api.g_number) then

532: If (p_rec.crit_tab_short_name = hr_api.g_varchar2) then
533: p_rec.crit_tab_short_name :=
534: ben_esw_shd.g_old_rec.crit_tab_short_name;
535: End If;
536: If (p_rec.crit_tab_pk_id = hr_api.g_number) then
537: p_rec.crit_tab_pk_id :=
538: ben_esw_shd.g_old_rec.crit_tab_pk_id;
539: End If;
540: If (p_rec.computed_score = hr_api.g_number) then

Line 540: If (p_rec.computed_score = hr_api.g_number) then

536: If (p_rec.crit_tab_pk_id = hr_api.g_number) then
537: p_rec.crit_tab_pk_id :=
538: ben_esw_shd.g_old_rec.crit_tab_pk_id;
539: End If;
540: If (p_rec.computed_score = hr_api.g_number) then
541: p_rec.computed_score :=
542: ben_esw_shd.g_old_rec.computed_score;
543: End If;
544: If (p_rec.benefit_action_id = hr_api.g_number) then

Line 544: If (p_rec.benefit_action_id = hr_api.g_number) then

540: If (p_rec.computed_score = hr_api.g_number) then
541: p_rec.computed_score :=
542: ben_esw_shd.g_old_rec.computed_score;
543: End If;
544: If (p_rec.benefit_action_id = hr_api.g_number) then
545: p_rec.benefit_action_id :=
546: ben_esw_shd.g_old_rec.benefit_action_id;
547: End If;
548: --

Line 643: ,p_elig_per_id in number default hr_api.g_number

639: (p_effective_date in date
640: ,p_datetrack_mode in varchar2
641: ,p_elig_scre_wtg_id in number
642: ,p_object_version_number in out nocopy number
643: ,p_elig_per_id in number default hr_api.g_number
644: ,p_elig_per_opt_id in number default hr_api.g_number
645: ,p_elig_rslt_id in number default hr_api.g_number
646: ,p_per_in_ler_id in number default hr_api.g_number
647: ,p_eligy_prfl_id in number default hr_api.g_number

Line 644: ,p_elig_per_opt_id in number default hr_api.g_number

640: ,p_datetrack_mode in varchar2
641: ,p_elig_scre_wtg_id in number
642: ,p_object_version_number in out nocopy number
643: ,p_elig_per_id in number default hr_api.g_number
644: ,p_elig_per_opt_id in number default hr_api.g_number
645: ,p_elig_rslt_id in number default hr_api.g_number
646: ,p_per_in_ler_id in number default hr_api.g_number
647: ,p_eligy_prfl_id in number default hr_api.g_number
648: ,p_crit_tab_short_name in varchar2 default hr_api.g_varchar2

Line 645: ,p_elig_rslt_id in number default hr_api.g_number

641: ,p_elig_scre_wtg_id in number
642: ,p_object_version_number in out nocopy number
643: ,p_elig_per_id in number default hr_api.g_number
644: ,p_elig_per_opt_id in number default hr_api.g_number
645: ,p_elig_rslt_id in number default hr_api.g_number
646: ,p_per_in_ler_id in number default hr_api.g_number
647: ,p_eligy_prfl_id in number default hr_api.g_number
648: ,p_crit_tab_short_name in varchar2 default hr_api.g_varchar2
649: ,p_crit_tab_pk_id in number default hr_api.g_number

Line 646: ,p_per_in_ler_id in number default hr_api.g_number

642: ,p_object_version_number in out nocopy number
643: ,p_elig_per_id in number default hr_api.g_number
644: ,p_elig_per_opt_id in number default hr_api.g_number
645: ,p_elig_rslt_id in number default hr_api.g_number
646: ,p_per_in_ler_id in number default hr_api.g_number
647: ,p_eligy_prfl_id in number default hr_api.g_number
648: ,p_crit_tab_short_name in varchar2 default hr_api.g_varchar2
649: ,p_crit_tab_pk_id in number default hr_api.g_number
650: ,p_computed_score in number default hr_api.g_number

Line 647: ,p_eligy_prfl_id in number default hr_api.g_number

643: ,p_elig_per_id in number default hr_api.g_number
644: ,p_elig_per_opt_id in number default hr_api.g_number
645: ,p_elig_rslt_id in number default hr_api.g_number
646: ,p_per_in_ler_id in number default hr_api.g_number
647: ,p_eligy_prfl_id in number default hr_api.g_number
648: ,p_crit_tab_short_name in varchar2 default hr_api.g_varchar2
649: ,p_crit_tab_pk_id in number default hr_api.g_number
650: ,p_computed_score in number default hr_api.g_number
651: ,p_benefit_action_id in number default hr_api.g_number

Line 648: ,p_crit_tab_short_name in varchar2 default hr_api.g_varchar2

644: ,p_elig_per_opt_id in number default hr_api.g_number
645: ,p_elig_rslt_id in number default hr_api.g_number
646: ,p_per_in_ler_id in number default hr_api.g_number
647: ,p_eligy_prfl_id in number default hr_api.g_number
648: ,p_crit_tab_short_name in varchar2 default hr_api.g_varchar2
649: ,p_crit_tab_pk_id in number default hr_api.g_number
650: ,p_computed_score in number default hr_api.g_number
651: ,p_benefit_action_id in number default hr_api.g_number
652: ,p_effective_start_date out nocopy date

Line 649: ,p_crit_tab_pk_id in number default hr_api.g_number

645: ,p_elig_rslt_id in number default hr_api.g_number
646: ,p_per_in_ler_id in number default hr_api.g_number
647: ,p_eligy_prfl_id in number default hr_api.g_number
648: ,p_crit_tab_short_name in varchar2 default hr_api.g_varchar2
649: ,p_crit_tab_pk_id in number default hr_api.g_number
650: ,p_computed_score in number default hr_api.g_number
651: ,p_benefit_action_id in number default hr_api.g_number
652: ,p_effective_start_date out nocopy date
653: ,p_effective_end_date out nocopy date

Line 650: ,p_computed_score in number default hr_api.g_number

646: ,p_per_in_ler_id in number default hr_api.g_number
647: ,p_eligy_prfl_id in number default hr_api.g_number
648: ,p_crit_tab_short_name in varchar2 default hr_api.g_varchar2
649: ,p_crit_tab_pk_id in number default hr_api.g_number
650: ,p_computed_score in number default hr_api.g_number
651: ,p_benefit_action_id in number default hr_api.g_number
652: ,p_effective_start_date out nocopy date
653: ,p_effective_end_date out nocopy date
654: ) is

Line 651: ,p_benefit_action_id in number default hr_api.g_number

647: ,p_eligy_prfl_id in number default hr_api.g_number
648: ,p_crit_tab_short_name in varchar2 default hr_api.g_varchar2
649: ,p_crit_tab_pk_id in number default hr_api.g_number
650: ,p_computed_score in number default hr_api.g_number
651: ,p_benefit_action_id in number default hr_api.g_number
652: ,p_effective_start_date out nocopy date
653: ,p_effective_end_date out nocopy date
654: ) is
655: --