DBA Data[Home] [Help]

APPS.AME_CONFIG_VAR_API dependencies on HR_API

Line 16: ,p_variable_value in varchar2 default hr_api.g_varchar2

12: procedure update_ame_config_variable
13: (p_validate in boolean default false
14: ,p_application_id in number
15: ,p_variable_name in varchar2
16: ,p_variable_value in varchar2 default hr_api.g_varchar2
17: ,p_object_version_number in out nocopy number
18: ,p_start_date out nocopy date
19: ,p_end_date out nocopy date
20: ) is

Line 58: when hr_api.cannot_find_prog_unit then

54: ,p_variable_value => p_variable_value
55: ,p_object_version_number => p_object_version_number
56: );
57: exception
58: when hr_api.cannot_find_prog_unit then
59: hr_api.cannot_find_prog_unit_error
60: (p_module_name => 'update_ame_config_variable'
61: ,p_hook_type => 'BP'
62: );

Line 59: hr_api.cannot_find_prog_unit_error

55: ,p_object_version_number => p_object_version_number
56: );
57: exception
58: when hr_api.cannot_find_prog_unit then
59: hr_api.cannot_find_prog_unit_error
60: (p_module_name => 'update_ame_config_variable'
61: ,p_hook_type => 'BP'
62: );
63: end;

Line 81: ,p_datetrack_mode => hr_api.g_update

77: ,p_end_date => l_end_date
78: );
79: else
80: ame_cfv_upd.upd(p_effective_date => sysdate
81: ,p_datetrack_mode => hr_api.g_update
82: ,p_application_id => p_application_id
83: ,p_variable_name => p_variable_name
84: ,p_variable_value => p_variable_value
85: ,p_security_group_id => null

Line 105: when hr_api.cannot_find_prog_unit then

101: ,p_start_date => l_start_date
102: ,p_end_date => l_end_date
103: );
104: exception
105: when hr_api.cannot_find_prog_unit then
106: hr_api.cannot_find_prog_unit_error
107: (p_module_name => 'update_ame_config_variable'
108: ,p_hook_type => 'AP'
109: );

Line 106: hr_api.cannot_find_prog_unit_error

102: ,p_end_date => l_end_date
103: );
104: exception
105: when hr_api.cannot_find_prog_unit then
106: hr_api.cannot_find_prog_unit_error
107: (p_module_name => 'update_ame_config_variable'
108: ,p_hook_type => 'AP'
109: );
110: end;

Line 115: raise hr_api.validate_enabled;

111: --
112: -- When in validation only mode raise the Validate_Enabled exception
113: --
114: if p_validate then
115: raise hr_api.validate_enabled;
116: end if;
117: --
118: -- Set all IN OUT and OUT parameters with out values.
119: --

Line 125: when hr_api.validate_enabled then

121: p_end_date := l_end_date;
122: --
123: hr_utility.set_location(' Leaving:'||l_proc, 70);
124: exception
125: when hr_api.validate_enabled then
126: --
127: -- As the Validate_Enabled exception has been raised
128: -- we must rollback to the savepoint
129: --

Line 199: when hr_api.cannot_find_prog_unit then

195: ,p_variable_name => p_variable_name
196: ,p_object_version_number => p_object_version_number
197: );
198: exception
199: when hr_api.cannot_find_prog_unit then
200: hr_api.cannot_find_prog_unit_error
201: (p_module_name => 'delete_ame_config_variable'
202: ,p_hook_type => 'BP'
203: );

Line 200: hr_api.cannot_find_prog_unit_error

196: ,p_object_version_number => p_object_version_number
197: );
198: exception
199: when hr_api.cannot_find_prog_unit then
200: hr_api.cannot_find_prog_unit_error
201: (p_module_name => 'delete_ame_config_variable'
202: ,p_hook_type => 'BP'
203: );
204: end;

Line 209: ,p_datetrack_mode => hr_api.g_delete

205: --
206: -- Process Logic
207: --
208: ame_cfv_del.del(p_effective_date => sysdate
209: ,p_datetrack_mode => hr_api.g_delete
210: ,p_application_id => p_application_id
211: ,p_variable_name => p_variable_name
212: ,p_object_version_number => p_object_version_number
213: ,p_start_date => l_start_date

Line 228: when hr_api.cannot_find_prog_unit then

224: ,p_start_date => l_start_date
225: ,p_end_date => l_end_date
226: );
227: exception
228: when hr_api.cannot_find_prog_unit then
229: hr_api.cannot_find_prog_unit_error
230: (p_module_name => 'delete_ame_config_variable'
231: ,p_hook_type => 'AP'
232: );

Line 229: hr_api.cannot_find_prog_unit_error

225: ,p_end_date => l_end_date
226: );
227: exception
228: when hr_api.cannot_find_prog_unit then
229: hr_api.cannot_find_prog_unit_error
230: (p_module_name => 'delete_ame_config_variable'
231: ,p_hook_type => 'AP'
232: );
233: end;

Line 238: raise hr_api.validate_enabled;

234: --
235: -- When in validation only mode raise the Validate_Enabled exception
236: --
237: if p_validate then
238: raise hr_api.validate_enabled;
239: end if;
240: --
241: -- Set all IN OUT and OUT parameters with out values.
242: --

Line 248: when hr_api.validate_enabled then

244: p_end_date := l_end_date;
245: --
246: hr_utility.set_location(' Leaving:'||l_proc, 70);
247: exception
248: when hr_api.validate_enabled then
249: --
250: -- As the Validate_Enabled exception has been raised
251: -- we must rollback to the savepoint
252: --