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.PER_ABV_UPD dependencies on HR_API

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

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

Line 139: When hr_api.check_integrity_violated Then

135: End If;
136: --
137: hr_utility.set_location(' Leaving:'||l_proc, 15);
138: Exception
139: When hr_api.check_integrity_violated Then
140: -- A check constraint has been violated
141: --
142: per_abv_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

139: When hr_api.check_integrity_violated Then
140: -- A check constraint has been violated
141: --
142: per_abv_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When hr_api.unique_integrity_violated Then
145: -- Unique integrity has been violated
146: --
147: per_abv_shd.constraint_error

Line 144: When hr_api.unique_integrity_violated Then

140: -- A check constraint has been violated
141: --
142: per_abv_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When hr_api.unique_integrity_violated Then
145: -- Unique integrity has been violated
146: --
147: per_abv_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

144: When hr_api.unique_integrity_violated Then
145: -- Unique integrity has been violated
146: --
147: per_abv_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When Others Then
150: --
151: Raise;
152: End dt_update_dml;

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

261: l_dummy_version_number number;
262: --
263: Begin
264: hr_utility.set_location('Entering:'||l_proc, 5);
265: If (p_datetrack_mode <> hr_api.g_correction) then
266: --
267: -- Update the current effective end date
268: --
269: per_abv_shd.upd_effective_end_date

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

274: ,p_validation_end_date => p_validation_end_date
275: ,p_object_version_number => p_rec.object_version_number
276: );
277: --
278: If (p_datetrack_mode = hr_api.g_update_override) then
279: --
280: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
281: -- delete any future rows
282: --

Line 465: when hr_api.cannot_find_prog_unit then

461: );
462: --
463: exception
464: --
465: when hr_api.cannot_find_prog_unit then
466: --
467: hr_api.cannot_find_prog_unit_error
468: (p_module_name => 'PER_ASSIGNMENT_BUDGET_VALUES_F'
469: ,p_hook_type => 'AU');

Line 467: hr_api.cannot_find_prog_unit_error

463: exception
464: --
465: when hr_api.cannot_find_prog_unit then
466: --
467: hr_api.cannot_find_prog_unit_error
468: (p_module_name => 'PER_ASSIGNMENT_BUDGET_VALUES_F'
469: ,p_hook_type => 'AU');
470: --
471: end;

Line 530: If (p_rec.business_group_id = hr_api.g_number) then

526: -- p_rec plsql record structure
527: -- to see if a system default is being used. If a system default
528: -- is being used then we must set to the 'current' argument value.
529: --
530: If (p_rec.business_group_id = hr_api.g_number) then
531: p_rec.business_group_id :=
532: per_abv_shd.g_old_rec.business_group_id;
533: End If;
534: If (p_rec.assignment_id = hr_api.g_number) then

Line 534: If (p_rec.assignment_id = hr_api.g_number) then

530: If (p_rec.business_group_id = hr_api.g_number) then
531: p_rec.business_group_id :=
532: per_abv_shd.g_old_rec.business_group_id;
533: End If;
534: If (p_rec.assignment_id = hr_api.g_number) then
535: p_rec.assignment_id :=
536: per_abv_shd.g_old_rec.assignment_id;
537: End If;
538: If (p_rec.unit = hr_api.g_varchar2) then

Line 538: If (p_rec.unit = hr_api.g_varchar2) then

534: If (p_rec.assignment_id = hr_api.g_number) then
535: p_rec.assignment_id :=
536: per_abv_shd.g_old_rec.assignment_id;
537: End If;
538: If (p_rec.unit = hr_api.g_varchar2) then
539: p_rec.unit :=
540: per_abv_shd.g_old_rec.unit;
541: End If;
542: If (p_rec.value = hr_api.g_number) then

Line 542: If (p_rec.value = hr_api.g_number) then

538: If (p_rec.unit = hr_api.g_varchar2) then
539: p_rec.unit :=
540: per_abv_shd.g_old_rec.unit;
541: End If;
542: If (p_rec.value = hr_api.g_number) then
543: p_rec.value :=
544: per_abv_shd.g_old_rec.value;
545: End If;
546: If (p_rec.request_id = hr_api.g_number) then

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

542: If (p_rec.value = hr_api.g_number) then
543: p_rec.value :=
544: per_abv_shd.g_old_rec.value;
545: End If;
546: If (p_rec.request_id = hr_api.g_number) then
547: p_rec.request_id :=
548: per_abv_shd.g_old_rec.request_id;
549: End If;
550: If (p_rec.program_application_id = hr_api.g_number) then

Line 550: If (p_rec.program_application_id = hr_api.g_number) then

546: If (p_rec.request_id = hr_api.g_number) then
547: p_rec.request_id :=
548: per_abv_shd.g_old_rec.request_id;
549: End If;
550: If (p_rec.program_application_id = hr_api.g_number) then
551: p_rec.program_application_id :=
552: per_abv_shd.g_old_rec.program_application_id;
553: End If;
554: If (p_rec.program_id = hr_api.g_number) then

Line 554: If (p_rec.program_id = hr_api.g_number) then

550: If (p_rec.program_application_id = hr_api.g_number) then
551: p_rec.program_application_id :=
552: per_abv_shd.g_old_rec.program_application_id;
553: End If;
554: If (p_rec.program_id = hr_api.g_number) then
555: p_rec.program_id :=
556: per_abv_shd.g_old_rec.program_id;
557: End If;
558: If (p_rec.program_update_date = hr_api.g_date) then

Line 558: If (p_rec.program_update_date = hr_api.g_date) then

554: If (p_rec.program_id = hr_api.g_number) then
555: p_rec.program_id :=
556: per_abv_shd.g_old_rec.program_id;
557: End If;
558: If (p_rec.program_update_date = hr_api.g_date) then
559: p_rec.program_update_date :=
560: per_abv_shd.g_old_rec.program_update_date;
561: End If;
562: --

Line 651: ,p_unit in varchar2 default hr_api.g_varchar2

647: (p_effective_date in date
648: ,p_datetrack_mode in varchar2
649: ,p_assignment_budget_value_id in number
650: ,p_object_version_number in out nocopy number
651: ,p_unit in varchar2 default hr_api.g_varchar2
652: ,p_value in number default hr_api.g_number
653: ,p_request_id in number default hr_api.g_number
654: ,p_program_application_id in number default hr_api.g_number
655: ,p_program_id in number default hr_api.g_number

Line 652: ,p_value in number default hr_api.g_number

648: ,p_datetrack_mode in varchar2
649: ,p_assignment_budget_value_id in number
650: ,p_object_version_number in out nocopy number
651: ,p_unit in varchar2 default hr_api.g_varchar2
652: ,p_value in number default hr_api.g_number
653: ,p_request_id in number default hr_api.g_number
654: ,p_program_application_id in number default hr_api.g_number
655: ,p_program_id in number default hr_api.g_number
656: ,p_program_update_date in date default hr_api.g_date

Line 653: ,p_request_id in number default hr_api.g_number

649: ,p_assignment_budget_value_id in number
650: ,p_object_version_number in out nocopy number
651: ,p_unit in varchar2 default hr_api.g_varchar2
652: ,p_value in number default hr_api.g_number
653: ,p_request_id in number default hr_api.g_number
654: ,p_program_application_id in number default hr_api.g_number
655: ,p_program_id in number default hr_api.g_number
656: ,p_program_update_date in date default hr_api.g_date
657: ,p_effective_start_date out nocopy date

Line 654: ,p_program_application_id in number default hr_api.g_number

650: ,p_object_version_number in out nocopy number
651: ,p_unit in varchar2 default hr_api.g_varchar2
652: ,p_value in number default hr_api.g_number
653: ,p_request_id in number default hr_api.g_number
654: ,p_program_application_id in number default hr_api.g_number
655: ,p_program_id in number default hr_api.g_number
656: ,p_program_update_date in date default hr_api.g_date
657: ,p_effective_start_date out nocopy date
658: ,p_effective_end_date out nocopy date

Line 655: ,p_program_id in number default hr_api.g_number

651: ,p_unit in varchar2 default hr_api.g_varchar2
652: ,p_value in number default hr_api.g_number
653: ,p_request_id in number default hr_api.g_number
654: ,p_program_application_id in number default hr_api.g_number
655: ,p_program_id in number default hr_api.g_number
656: ,p_program_update_date in date default hr_api.g_date
657: ,p_effective_start_date out nocopy date
658: ,p_effective_end_date out nocopy date
659: ) is

Line 656: ,p_program_update_date in date default hr_api.g_date

652: ,p_value in number default hr_api.g_number
653: ,p_request_id in number default hr_api.g_number
654: ,p_program_application_id in number default hr_api.g_number
655: ,p_program_id in number default hr_api.g_number
656: ,p_program_update_date in date default hr_api.g_date
657: ,p_effective_start_date out nocopy date
658: ,p_effective_end_date out nocopy date
659: ) is
660: --

Line 663: l_assignment_id number := hr_api.g_number;

659: ) is
660: --
661: l_rec per_abv_shd.g_rec_type;
662: l_proc varchar2(72) := g_package||'upd';
663: l_assignment_id number := hr_api.g_number;
664: l_business_group_id number := hr_api.g_number;
665: --
666: Begin
667: hr_utility.set_location('Entering:'||l_proc, 5);

Line 664: l_business_group_id number := hr_api.g_number;

660: --
661: l_rec per_abv_shd.g_rec_type;
662: l_proc varchar2(72) := g_package||'upd';
663: l_assignment_id number := hr_api.g_number;
664: l_business_group_id number := hr_api.g_number;
665: --
666: Begin
667: hr_utility.set_location('Entering:'||l_proc, 5);
668: --