DBA Data[Home] [Help]

APPS.AME_ITC_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 101: When hr_api.check_integrity_violated Then

97: End If;
98: --
99: hr_utility.set_location(' Leaving:'||l_proc, 15);
100: Exception
101: When hr_api.check_integrity_violated Then
102: -- A check constraint has been violated
103: --
104: ame_itc_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

101: When hr_api.check_integrity_violated Then
102: -- A check constraint has been violated
103: --
104: ame_itc_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.unique_integrity_violated Then
107: -- Unique integrity has been violated
108: --
109: ame_itc_shd.constraint_error

Line 106: When hr_api.unique_integrity_violated Then

102: -- A check constraint has been violated
103: --
104: ame_itc_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.unique_integrity_violated Then
107: -- Unique integrity has been violated
108: --
109: ame_itc_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

106: When hr_api.unique_integrity_violated Then
107: -- Unique integrity has been violated
108: --
109: ame_itc_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: --
113: Raise;
114: End dt_update_dml;

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

223: l_dummy_version_number number;
224: --
225: Begin
226: hr_utility.set_location('Entering:'||l_proc, 5);
227: If (p_datetrack_mode <> hr_api.g_correction) then
228: --
229: -- Update the current effective end date
230: --
231: ame_itc_shd.upd_effective_end_date

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

236: ,p_validation_end_date => p_validation_end_date
237: ,p_object_version_number => l_dummy_version_number
238: );
239: --
240: If (p_datetrack_mode = hr_api.g_update_override) then
241: --
242: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
243: -- delete any future rows
244: --

Line 389: when hr_api.cannot_find_prog_unit then

385: );
386: --
387: exception
388: --
389: when hr_api.cannot_find_prog_unit then
390: --
391: hr_api.cannot_find_prog_unit_error
392: (p_module_name => 'AME_ITEM_CLASSES'
393: ,p_hook_type => 'AU');

Line 391: hr_api.cannot_find_prog_unit_error

387: exception
388: --
389: when hr_api.cannot_find_prog_unit then
390: --
391: hr_api.cannot_find_prog_unit_error
392: (p_module_name => 'AME_ITEM_CLASSES'
393: ,p_hook_type => 'AU');
394: --
395: end;

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

450: -- p_rec plsql record structure
451: -- to see if a system default is being used. If a system default
452: -- is being used then we must set to the 'current' argument value.
453: --
454: If (p_rec.name = hr_api.g_varchar2) then
455: p_rec.name :=
456: ame_itc_shd.g_old_rec.name;
457: End If;
458: --

Line 553: ,p_name in varchar2 default hr_api.g_varchar2

549: (p_effective_date in date
550: ,p_datetrack_mode in varchar2
551: ,p_item_class_id in number
552: ,p_object_version_number in out nocopy number
553: ,p_name in varchar2 default hr_api.g_varchar2
554: ,p_start_date out nocopy date
555: ,p_end_date out nocopy date
556: ) is
557: --