DBA Data[Home] [Help]

APPS.AME_CFV_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_cfv_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_cfv_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_cfv_shd.constraint_error

Line 115: When hr_api.unique_integrity_violated Then

111: -- A check constraint has been violated
112: --
113: ame_cfv_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_cfv_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_cfv_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_cfv_shd.upd_end_date

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

244: ,p_new_end_date => p_validation_start_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 429: when hr_api.cannot_find_prog_unit then

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

Line 431: hr_api.cannot_find_prog_unit_error

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

Line 494: If (p_rec.variable_value = hr_api.g_varchar2) then

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

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

494: If (p_rec.variable_value = hr_api.g_varchar2) then
495: p_rec.variable_value :=
496: ame_cfv_shd.g_old_rec.variable_value;
497: End If;
498: If (p_rec.description = hr_api.g_varchar2) then
499: p_rec.description :=
500: ame_cfv_shd.g_old_rec.description;
501: End If;
502: If (p_rec.security_group_id = hr_api.g_number) then

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

498: If (p_rec.description = hr_api.g_varchar2) then
499: p_rec.description :=
500: ame_cfv_shd.g_old_rec.description;
501: End If;
502: If (p_rec.security_group_id = hr_api.g_number) then
503: p_rec.security_group_id :=
504: ame_cfv_shd.g_old_rec.security_group_id;
505: End If;
506: --

Line 602: ,p_variable_value in varchar2 default hr_api.g_varchar2

598: (p_effective_date in date
599: ,p_datetrack_mode in varchar2
600: ,p_application_id in number
601: ,p_variable_name in varchar2
602: ,p_variable_value in varchar2 default hr_api.g_varchar2
603: ,p_security_group_id in number default hr_api.g_number
604: ,p_object_version_number in out nocopy number
605: ,p_start_date out nocopy date
606: ,p_end_date out nocopy date

Line 603: ,p_security_group_id in number default hr_api.g_number

599: ,p_datetrack_mode in varchar2
600: ,p_application_id in number
601: ,p_variable_name in varchar2
602: ,p_variable_value in varchar2 default hr_api.g_varchar2
603: ,p_security_group_id in number default hr_api.g_number
604: ,p_object_version_number in out nocopy number
605: ,p_start_date out nocopy date
606: ,p_end_date out nocopy date
607: ) is