61: ,p_parent_entry_value_id => p_parent_entry_value_id
62: ,p_usage_flag => p_usage_flag
63: );
64: exception
65: when hr_api.cannot_find_prog_unit then
66: hr_api.cannot_find_prog_unit_error
67: (p_module_name => 'create_entry_value_b'
68: ,p_hook_type => 'BP'
69: );
62: ,p_usage_flag => p_usage_flag
63: );
64: exception
65: when hr_api.cannot_find_prog_unit then
66: hr_api.cannot_find_prog_unit_error
67: (p_module_name => 'create_entry_value_b'
68: ,p_hook_type => 'BP'
69: );
70: end;
106: ,p_cal_entry_value_id => l_cal_entry_value_id
107: ,p_object_version_number => l_object_version_number
108: );
109: exception
110: when hr_api.cannot_find_prog_unit then
111: hr_api.cannot_find_prog_unit_error
112: (p_module_name => 'create_entry_value_a'
113: ,p_hook_type => 'AP'
114: );
107: ,p_object_version_number => l_object_version_number
108: );
109: exception
110: when hr_api.cannot_find_prog_unit then
111: hr_api.cannot_find_prog_unit_error
112: (p_module_name => 'create_entry_value_a'
113: ,p_hook_type => 'AP'
114: );
115: end;
116: --
117: -- When in validation only mode raise the Validate_Enabled exception
118: --
119: if p_validate then
120: raise hr_api.validate_enabled;
121: end if;
122: --
123: -- Set all output arguments
124: --
126: p_object_version_number := l_object_version_number;
127: --
128: hr_utility.set_location(' Leaving:'||l_proc, 70);
129: exception
130: when hr_api.validate_enabled then
131: --
132: -- As the Validate_Enabled exception has been raised
133: -- we must rollback to the savepoint
134: --
158: (p_validate in boolean default false
159: ,p_effective_date in date
160: ,p_cal_entry_value_id in number
161: ,p_object_version_number in out nocopy number
162: ,p_override_name in varchar2 default hr_api.g_varchar2
163: ,p_override_type in varchar2 default hr_api.g_varchar2
164: ,p_parent_entry_value_id in number default hr_api.g_number
165: ,p_usage_flag in varchar2 default hr_api.g_varchar2
166: ) IS
159: ,p_effective_date in date
160: ,p_cal_entry_value_id in number
161: ,p_object_version_number in out nocopy number
162: ,p_override_name in varchar2 default hr_api.g_varchar2
163: ,p_override_type in varchar2 default hr_api.g_varchar2
164: ,p_parent_entry_value_id in number default hr_api.g_number
165: ,p_usage_flag in varchar2 default hr_api.g_varchar2
166: ) IS
167:
160: ,p_cal_entry_value_id in number
161: ,p_object_version_number in out nocopy number
162: ,p_override_name in varchar2 default hr_api.g_varchar2
163: ,p_override_type in varchar2 default hr_api.g_varchar2
164: ,p_parent_entry_value_id in number default hr_api.g_number
165: ,p_usage_flag in varchar2 default hr_api.g_varchar2
166: ) IS
167:
168: --
161: ,p_object_version_number in out nocopy number
162: ,p_override_name in varchar2 default hr_api.g_varchar2
163: ,p_override_type in varchar2 default hr_api.g_varchar2
164: ,p_parent_entry_value_id in number default hr_api.g_number
165: ,p_usage_flag in varchar2 default hr_api.g_varchar2
166: ) IS
167:
168: --
169: -- Declare cursors and local variables
200: ,p_parent_entry_value_id => p_parent_entry_value_id
201: ,p_usage_flag => p_usage_flag
202: );
203: exception
204: when hr_api.cannot_find_prog_unit then
205: hr_api.cannot_find_prog_unit_error
206: (p_module_name => 'update_entry_value_b'
207: ,p_hook_type => 'BP'
208: );
201: ,p_usage_flag => p_usage_flag
202: );
203: exception
204: when hr_api.cannot_find_prog_unit then
205: hr_api.cannot_find_prog_unit_error
206: (p_module_name => 'update_entry_value_b'
207: ,p_hook_type => 'BP'
208: );
209: end;
235: ,p_usage_flag => p_usage_flag
236: );
237:
238: exception
239: when hr_api.cannot_find_prog_unit then
240: hr_api.cannot_find_prog_unit_error
241: (p_module_name => 'update_entry_value_a'
242: ,p_hook_type => 'AP'
243: );
236: );
237:
238: exception
239: when hr_api.cannot_find_prog_unit then
240: hr_api.cannot_find_prog_unit_error
241: (p_module_name => 'update_entry_value_a'
242: ,p_hook_type => 'AP'
243: );
244: end;
245: --
246: -- When in validation only mode raise the Validate_Enabled exception
247: --
248: if p_validate then
249: raise hr_api.validate_enabled;
250: end if;
251: --
252: -- Set all output arguments
253: --
254: p_object_version_number := l_object_version_number;
255: --
256: hr_utility.set_location(' Leaving:'||l_proc, 70);
257: exception
258: when hr_api.validate_enabled then
259: --
260: -- As the Validate_Enabled exception has been raised
261: -- we must rollback to the savepoint
262: --
305: (p_cal_entry_value_id => p_cal_entry_value_id,
306: p_object_version_number => p_object_version_number
307: );
308: exception
309: when hr_api.cannot_find_prog_unit then
310: hr_api.cannot_find_prog_unit_error
311: (p_module_name => 'delete_entry_value_b',
312: p_hook_type => 'BP'
313: );
306: p_object_version_number => p_object_version_number
307: );
308: exception
309: when hr_api.cannot_find_prog_unit then
310: hr_api.cannot_find_prog_unit_error
311: (p_module_name => 'delete_entry_value_b',
312: p_hook_type => 'BP'
313: );
314: end;
332: (p_cal_entry_value_id => p_cal_entry_value_id
333: ,p_object_version_number => p_object_version_number
334: );
335: exception
336: when hr_api.cannot_find_prog_unit then
337: hr_api.cannot_find_prog_unit_error
338: (p_module_name => 'delete_entry_value_a',
339: p_hook_type => 'AP'
340: );
333: ,p_object_version_number => p_object_version_number
334: );
335: exception
336: when hr_api.cannot_find_prog_unit then
337: hr_api.cannot_find_prog_unit_error
338: (p_module_name => 'delete_entry_value_a',
339: p_hook_type => 'AP'
340: );
341: end;
342: --
343: -- When in validation only mode raise the Validate_Enabled exception
344: --
345: if p_validate then
346: raise hr_api.validate_enabled;
347: end if;
348: --
349: hr_utility.set_location(' Leaving:'||l_proc, 11);
350: exception
347: end if;
348: --
349: hr_utility.set_location(' Leaving:'||l_proc, 11);
350: exception
351: when hr_api.validate_enabled then
352: --
353: -- As the Validate_Enabled exception has been raised
354: -- we must rollback to the savepoint
355: --