DBA Data[Home] [Help]

APPS.AME_ACU_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 107: When hr_api.check_integrity_violated Then

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

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

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

Line 112: When hr_api.unique_integrity_violated Then

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

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

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

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

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

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

241: ,p_new_end_date => p_validation_start_date
242: ,p_object_version_number => l_dummy_version_number
243: );
244: --
245: If (p_datetrack_mode = hr_api.g_update_override) then
246: --
247: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
248: -- delete any future rows
249: --

Line 405: when hr_api.cannot_find_prog_unit then

401: );
402: --
403: exception
404: --
405: when hr_api.cannot_find_prog_unit then
406: --
407: hr_api.cannot_find_prog_unit_error
408: (p_module_name => 'AME_ACTION_USAGES'
409: ,p_hook_type => 'AU');

Line 407: hr_api.cannot_find_prog_unit_error

403: exception
404: --
405: when hr_api.cannot_find_prog_unit then
406: --
407: hr_api.cannot_find_prog_unit_error
408: (p_module_name => 'AME_ACTION_USAGES'
409: ,p_hook_type => 'AU');
410: --
411: end;

Line 465: If (p_rec.start_date = hr_api.g_date) then

461: ) is
462: --
463: Begin
464: --
465: If (p_rec.start_date = hr_api.g_date) then
466: p_rec.start_date := ame_acu_shd.g_old_rec.start_date;
467: End If;
468: If (p_rec.end_date = hr_api.g_date) then
469: p_rec.end_date := ame_acu_shd.g_old_rec.end_date;

Line 468: If (p_rec.end_date = hr_api.g_date) then

464: --
465: If (p_rec.start_date = hr_api.g_date) then
466: p_rec.start_date := ame_acu_shd.g_old_rec.start_date;
467: End If;
468: If (p_rec.end_date = hr_api.g_date) then
469: p_rec.end_date := ame_acu_shd.g_old_rec.end_date;
470: End If;
471: --
472: End convert_defs;

Line 497: p_rec.start_date := hr_api.g_date;

493: --
494: -- set the start and end dates if not set
495: --
496: if p_rec.start_date is null then
497: p_rec.start_date := hr_api.g_date;
498: end if;
499: if p_rec.end_date is null then
500: p_rec.end_date := hr_api.g_date;
501: end if;

Line 500: p_rec.end_date := hr_api.g_date;

496: if p_rec.start_date is null then
497: p_rec.start_date := hr_api.g_date;
498: end if;
499: if p_rec.end_date is null then
500: p_rec.end_date := hr_api.g_date;
501: end if;
502: --
503: -- We must lock the row which we need to update.
504: --