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_ATU_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: ame_atu_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: ame_atu_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: ame_atu_shd.constraint_error

Line 119: When hr_api.unique_integrity_violated Then

115: -- A check constraint has been violated
116: --
117: ame_atu_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: ame_atu_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: ame_atu_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: ame_atu_shd.upd_end_date

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

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

Line 436: when hr_api.cannot_find_prog_unit then

432: );
433: --
434: exception
435: --
436: when hr_api.cannot_find_prog_unit then
437: --
438: hr_api.cannot_find_prog_unit_error
439: (p_module_name => 'AME_ATTRIBUTE_USAGES'
440: ,p_hook_type => 'AU');

Line 438: hr_api.cannot_find_prog_unit_error

434: exception
435: --
436: when hr_api.cannot_find_prog_unit then
437: --
438: hr_api.cannot_find_prog_unit_error
439: (p_module_name => 'AME_ATTRIBUTE_USAGES'
440: ,p_hook_type => 'AU');
441: --
442: end;

Line 501: If (p_rec.query_string = hr_api.g_varchar2) then

497: -- p_rec plsql record structure
498: -- to see if a system default is being used. If a system default
499: -- is being used then we must set to the 'current' argument value.
500: --
501: If (p_rec.query_string = hr_api.g_varchar2) then
502: p_rec.query_string :=
503: ame_atu_shd.g_old_rec.query_string;
504: End If;
505: If (p_rec.use_count = hr_api.g_number) then

Line 505: If (p_rec.use_count = hr_api.g_number) then

501: If (p_rec.query_string = hr_api.g_varchar2) then
502: p_rec.query_string :=
503: ame_atu_shd.g_old_rec.query_string;
504: End If;
505: If (p_rec.use_count = hr_api.g_number) then
506: p_rec.use_count :=
507: ame_atu_shd.g_old_rec.use_count;
508: End If;
509: If (p_rec.user_editable = hr_api.g_varchar2) then

Line 509: If (p_rec.user_editable = hr_api.g_varchar2) then

505: If (p_rec.use_count = hr_api.g_number) then
506: p_rec.use_count :=
507: ame_atu_shd.g_old_rec.use_count;
508: End If;
509: If (p_rec.user_editable = hr_api.g_varchar2) then
510: p_rec.user_editable :=
511: ame_atu_shd.g_old_rec.user_editable;
512: End If;
513: If (p_rec.is_static = hr_api.g_varchar2) then

Line 513: If (p_rec.is_static = hr_api.g_varchar2) then

509: If (p_rec.user_editable = hr_api.g_varchar2) then
510: p_rec.user_editable :=
511: ame_atu_shd.g_old_rec.user_editable;
512: End If;
513: If (p_rec.is_static = hr_api.g_varchar2) then
514: p_rec.is_static :=
515: ame_atu_shd.g_old_rec.is_static;
516: End If;
517: If (p_rec.security_group_id = hr_api.g_number) then

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

513: If (p_rec.is_static = hr_api.g_varchar2) then
514: p_rec.is_static :=
515: ame_atu_shd.g_old_rec.is_static;
516: End If;
517: If (p_rec.security_group_id = hr_api.g_number) then
518: p_rec.security_group_id :=
519: ame_atu_shd.g_old_rec.security_group_id;
520: End If;
521: If (p_rec.value_set_id = hr_api.g_number) then

Line 521: If (p_rec.value_set_id = hr_api.g_number) then

517: If (p_rec.security_group_id = hr_api.g_number) then
518: p_rec.security_group_id :=
519: ame_atu_shd.g_old_rec.security_group_id;
520: End If;
521: If (p_rec.value_set_id = hr_api.g_number) then
522: p_rec.value_set_id :=
523: ame_atu_shd.g_old_rec.value_set_id;
524: End If;
525: --

Line 622: ,p_use_count in number default hr_api.g_number

618: ,p_datetrack_mode in varchar2
619: ,p_attribute_id in number
620: ,p_application_id in number
621: ,p_object_version_number in out nocopy number
622: ,p_use_count in number default hr_api.g_number
623: ,p_query_string in varchar2 default hr_api.g_varchar2
624: ,p_user_editable in varchar2 default hr_api.g_varchar2
625: ,p_is_static in varchar2 default hr_api.g_varchar2
626: ,p_security_group_id in number default hr_api.g_number

Line 623: ,p_query_string in varchar2 default hr_api.g_varchar2

619: ,p_attribute_id in number
620: ,p_application_id in number
621: ,p_object_version_number in out nocopy number
622: ,p_use_count in number default hr_api.g_number
623: ,p_query_string in varchar2 default hr_api.g_varchar2
624: ,p_user_editable in varchar2 default hr_api.g_varchar2
625: ,p_is_static in varchar2 default hr_api.g_varchar2
626: ,p_security_group_id in number default hr_api.g_number
627: ,p_value_set_id in number default hr_api.g_number

Line 624: ,p_user_editable in varchar2 default hr_api.g_varchar2

620: ,p_application_id in number
621: ,p_object_version_number in out nocopy number
622: ,p_use_count in number default hr_api.g_number
623: ,p_query_string in varchar2 default hr_api.g_varchar2
624: ,p_user_editable in varchar2 default hr_api.g_varchar2
625: ,p_is_static in varchar2 default hr_api.g_varchar2
626: ,p_security_group_id in number default hr_api.g_number
627: ,p_value_set_id in number default hr_api.g_number
628: ,p_start_date out nocopy date

Line 625: ,p_is_static in varchar2 default hr_api.g_varchar2

621: ,p_object_version_number in out nocopy number
622: ,p_use_count in number default hr_api.g_number
623: ,p_query_string in varchar2 default hr_api.g_varchar2
624: ,p_user_editable in varchar2 default hr_api.g_varchar2
625: ,p_is_static in varchar2 default hr_api.g_varchar2
626: ,p_security_group_id in number default hr_api.g_number
627: ,p_value_set_id in number default hr_api.g_number
628: ,p_start_date out nocopy date
629: ,p_end_date out nocopy date

Line 626: ,p_security_group_id in number default hr_api.g_number

622: ,p_use_count in number default hr_api.g_number
623: ,p_query_string in varchar2 default hr_api.g_varchar2
624: ,p_user_editable in varchar2 default hr_api.g_varchar2
625: ,p_is_static in varchar2 default hr_api.g_varchar2
626: ,p_security_group_id in number default hr_api.g_number
627: ,p_value_set_id in number default hr_api.g_number
628: ,p_start_date out nocopy date
629: ,p_end_date out nocopy date
630: ) is

Line 627: ,p_value_set_id in number default hr_api.g_number

623: ,p_query_string in varchar2 default hr_api.g_varchar2
624: ,p_user_editable in varchar2 default hr_api.g_varchar2
625: ,p_is_static in varchar2 default hr_api.g_varchar2
626: ,p_security_group_id in number default hr_api.g_number
627: ,p_value_set_id in number default hr_api.g_number
628: ,p_start_date out nocopy date
629: ,p_end_date out nocopy date
630: ) is
631: --