DBA Data[Home] [Help]

APPS.AME_MAN_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 108: When hr_api.check_integrity_violated Then

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

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

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

Line 113: When hr_api.unique_integrity_violated Then

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

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

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

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

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

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

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

Line 412: when hr_api.cannot_find_prog_unit then

408: );
409: --
410: exception
411: --
412: when hr_api.cannot_find_prog_unit then
413: --
414: hr_api.cannot_find_prog_unit_error
415: (p_module_name => 'AME_MANDATORY_ATTRIBUTES'
416: ,p_hook_type => 'AU');

Line 414: hr_api.cannot_find_prog_unit_error

410: exception
411: --
412: when hr_api.cannot_find_prog_unit then
413: --
414: hr_api.cannot_find_prog_unit_error
415: (p_module_name => 'AME_MANDATORY_ATTRIBUTES'
416: ,p_hook_type => 'AU');
417: --
418: end;

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

473: -- p_rec plsql record structure
474: -- to see if a system default is being used. If a system default
475: -- is being used then we must set to the 'current' argument value.
476: --
477: If (p_rec.security_group_id = hr_api.g_number) then
478: p_rec.security_group_id :=
479: ame_man_shd.g_old_rec.security_group_id;
480: End If;
481: --

Line 578: ,p_security_group_id in number default hr_api.g_number

574: ,p_datetrack_mode in varchar2
575: ,p_attribute_id in number
576: ,p_action_type_id in number
577: ,p_object_version_number in out nocopy number
578: ,p_security_group_id in number default hr_api.g_number
579: ,p_start_date out nocopy date
580: ,p_end_date out nocopy date
581: ) is
582: --