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.AME_ATY_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 110: When hr_api.check_integrity_violated Then

106: End If;
107: --
108: hr_utility.set_location(' Leaving:'||l_proc, 15);
109: Exception
110: When hr_api.check_integrity_violated Then
111: -- A check constraint has been violated
112: --
113: ame_aty_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

110: When hr_api.check_integrity_violated Then
111: -- A check constraint has been violated
112: --
113: ame_aty_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.unique_integrity_violated Then
116: -- Unique integrity has been violated
117: --
118: ame_aty_shd.constraint_error

Line 115: When hr_api.unique_integrity_violated Then

111: -- A check constraint has been violated
112: --
113: ame_aty_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.unique_integrity_violated Then
116: -- Unique integrity has been violated
117: --
118: ame_aty_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

115: When hr_api.unique_integrity_violated Then
116: -- Unique integrity has been violated
117: --
118: ame_aty_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When Others Then
121: --
122: Raise;
123: End dt_update_dml;

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

232: l_dummy_version_number number;
233: --
234: Begin
235: hr_utility.set_location('Entering:'||l_proc, 5);
236: If (p_datetrack_mode <> hr_api.g_correction) then
237: --
238: -- Update the current effective end date
239: --
240: ame_aty_shd.upd_end_date

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

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

Line 431: when hr_api.cannot_find_prog_unit then

427: );
428: --
429: exception
430: --
431: when hr_api.cannot_find_prog_unit then
432: --
433: hr_api.cannot_find_prog_unit_error
434: (p_module_name => 'AME_ACTION_TYPES'
435: ,p_hook_type => 'AU');

Line 433: hr_api.cannot_find_prog_unit_error

429: exception
430: --
431: when hr_api.cannot_find_prog_unit then
432: --
433: hr_api.cannot_find_prog_unit_error
434: (p_module_name => 'AME_ACTION_TYPES'
435: ,p_hook_type => 'AU');
436: --
437: end;

Line 496: If (p_rec.name = hr_api.g_varchar2) then

492: -- p_rec plsql record structure
493: -- to see if a system default is being used. If a system default
494: -- is being used then we must set to the 'current' argument value.
495: --
496: If (p_rec.name = hr_api.g_varchar2) then
497: p_rec.name :=
498: ame_aty_shd.g_old_rec.name;
499: End If;
500: If (p_rec.procedure_name = hr_api.g_varchar2) then

Line 500: If (p_rec.procedure_name = hr_api.g_varchar2) then

496: If (p_rec.name = hr_api.g_varchar2) then
497: p_rec.name :=
498: ame_aty_shd.g_old_rec.name;
499: End If;
500: If (p_rec.procedure_name = hr_api.g_varchar2) then
501: p_rec.procedure_name :=
502: ame_aty_shd.g_old_rec.procedure_name;
503: End If;
504: If (p_rec.description = hr_api.g_varchar2) then

Line 504: If (p_rec.description = hr_api.g_varchar2) then

500: If (p_rec.procedure_name = hr_api.g_varchar2) then
501: p_rec.procedure_name :=
502: ame_aty_shd.g_old_rec.procedure_name;
503: End If;
504: If (p_rec.description = hr_api.g_varchar2) then
505: p_rec.description :=
506: ame_aty_shd.g_old_rec.description;
507: End If;
508: If (p_rec.security_group_id = hr_api.g_number) then

Line 508: If (p_rec.security_group_id = hr_api.g_number) then

504: If (p_rec.description = hr_api.g_varchar2) then
505: p_rec.description :=
506: ame_aty_shd.g_old_rec.description;
507: End If;
508: If (p_rec.security_group_id = hr_api.g_number) then
509: p_rec.security_group_id :=
510: ame_aty_shd.g_old_rec.security_group_id;
511: End If;
512: If (p_rec.dynamic_description = hr_api.g_varchar2) then

Line 512: If (p_rec.dynamic_description = hr_api.g_varchar2) then

508: If (p_rec.security_group_id = hr_api.g_number) then
509: p_rec.security_group_id :=
510: ame_aty_shd.g_old_rec.security_group_id;
511: End If;
512: If (p_rec.dynamic_description = hr_api.g_varchar2) then
513: p_rec.dynamic_description :=
514: ame_aty_shd.g_old_rec.dynamic_description;
515: End If;
516: If (p_rec.description_query = hr_api.g_varchar2) then

Line 516: If (p_rec.description_query = hr_api.g_varchar2) then

512: If (p_rec.dynamic_description = hr_api.g_varchar2) then
513: p_rec.dynamic_description :=
514: ame_aty_shd.g_old_rec.dynamic_description;
515: End If;
516: If (p_rec.description_query = hr_api.g_varchar2) then
517: p_rec.description_query :=
518: ame_aty_shd.g_old_rec.description_query;
519: End If;
520: --

Line 615: ,p_name in varchar2 default hr_api.g_varchar2

611: (p_effective_date in date
612: ,p_datetrack_mode in varchar2
613: ,p_action_type_id in number
614: ,p_object_version_number in out nocopy number
615: ,p_name in varchar2 default hr_api.g_varchar2
616: ,p_procedure_name in varchar2 default hr_api.g_varchar2
617: ,p_description in varchar2 default hr_api.g_varchar2
618: ,p_dynamic_description in varchar2 default hr_api.g_varchar2
619: ,p_security_group_id in number default hr_api.g_number

Line 616: ,p_procedure_name in varchar2 default hr_api.g_varchar2

612: ,p_datetrack_mode in varchar2
613: ,p_action_type_id in number
614: ,p_object_version_number in out nocopy number
615: ,p_name in varchar2 default hr_api.g_varchar2
616: ,p_procedure_name in varchar2 default hr_api.g_varchar2
617: ,p_description in varchar2 default hr_api.g_varchar2
618: ,p_dynamic_description in varchar2 default hr_api.g_varchar2
619: ,p_security_group_id in number default hr_api.g_number
620: ,p_description_query in varchar2 default hr_api.g_varchar2

Line 617: ,p_description in varchar2 default hr_api.g_varchar2

613: ,p_action_type_id in number
614: ,p_object_version_number in out nocopy number
615: ,p_name in varchar2 default hr_api.g_varchar2
616: ,p_procedure_name in varchar2 default hr_api.g_varchar2
617: ,p_description in varchar2 default hr_api.g_varchar2
618: ,p_dynamic_description in varchar2 default hr_api.g_varchar2
619: ,p_security_group_id in number default hr_api.g_number
620: ,p_description_query in varchar2 default hr_api.g_varchar2
621: ,p_start_date out nocopy date

Line 618: ,p_dynamic_description in varchar2 default hr_api.g_varchar2

614: ,p_object_version_number in out nocopy number
615: ,p_name in varchar2 default hr_api.g_varchar2
616: ,p_procedure_name in varchar2 default hr_api.g_varchar2
617: ,p_description in varchar2 default hr_api.g_varchar2
618: ,p_dynamic_description in varchar2 default hr_api.g_varchar2
619: ,p_security_group_id in number default hr_api.g_number
620: ,p_description_query in varchar2 default hr_api.g_varchar2
621: ,p_start_date out nocopy date
622: ,p_end_date out nocopy date

Line 619: ,p_security_group_id in number default hr_api.g_number

615: ,p_name in varchar2 default hr_api.g_varchar2
616: ,p_procedure_name in varchar2 default hr_api.g_varchar2
617: ,p_description in varchar2 default hr_api.g_varchar2
618: ,p_dynamic_description in varchar2 default hr_api.g_varchar2
619: ,p_security_group_id in number default hr_api.g_number
620: ,p_description_query in varchar2 default hr_api.g_varchar2
621: ,p_start_date out nocopy date
622: ,p_end_date out nocopy date
623: ) is

Line 620: ,p_description_query in varchar2 default hr_api.g_varchar2

616: ,p_procedure_name in varchar2 default hr_api.g_varchar2
617: ,p_description in varchar2 default hr_api.g_varchar2
618: ,p_dynamic_description in varchar2 default hr_api.g_varchar2
619: ,p_security_group_id in number default hr_api.g_number
620: ,p_description_query in varchar2 default hr_api.g_varchar2
621: ,p_start_date out nocopy date
622: ,p_end_date out nocopy date
623: ) is
624: --