63: ,p_business_group_id => p_business_group_id);
64: --
65: exception
66: --
67: when hr_api.cannot_find_prog_unit then
68: --
69: hr_api.cannot_find_prog_unit_error
70: (p_module_name => 'CREATE_batch_proc_info'
71: ,p_hook_type => 'BP');
65: exception
66: --
67: when hr_api.cannot_find_prog_unit then
68: --
69: hr_api.cannot_find_prog_unit_error
70: (p_module_name => 'CREATE_batch_proc_info'
71: ,p_hook_type => 'BP');
72: --
73: -- End of API User Hook for the before hook of create_batch_proc_info
111: ,p_object_version_number => l_object_version_number);
112: --
113: exception
114: --
115: when hr_api.cannot_find_prog_unit then
116: --
117: hr_api.cannot_find_prog_unit_error
118: (p_module_name => 'CREATE_batch_proc_info'
119: ,p_hook_type => 'AP');
113: exception
114: --
115: when hr_api.cannot_find_prog_unit then
116: --
117: hr_api.cannot_find_prog_unit_error
118: (p_module_name => 'CREATE_batch_proc_info'
119: ,p_hook_type => 'AP');
120: --
121: -- End of API User Hook for the after hook of create_batch_proc_info
126: --
127: -- When in validation only mode raise the Validate_Enabled exception
128: --
129: if p_validate then
130: raise hr_api.validate_enabled;
131: end if;
132: --
133: -- Set all output arguments
134: --
138: hr_utility.set_location(' Leaving:'||l_proc, 70);
139: --
140: exception
141: --
142: when hr_api.validate_enabled then
143: --
144: -- As the Validate_Enabled exception has been raised
145: -- we must rollback to the savepoint
146: --
171: --
172: procedure update_batch_proc_info
173: (p_validate in boolean default false
174: ,p_batch_proc_id in number
175: ,p_benefit_action_id in number default hr_api.g_number
176: ,p_strt_dt in date default hr_api.g_date
177: ,p_end_dt in date default hr_api.g_date
178: ,p_strt_tm in varchar2 default hr_api.g_varchar2
179: ,p_end_tm in varchar2 default hr_api.g_varchar2
172: procedure update_batch_proc_info
173: (p_validate in boolean default false
174: ,p_batch_proc_id in number
175: ,p_benefit_action_id in number default hr_api.g_number
176: ,p_strt_dt in date default hr_api.g_date
177: ,p_end_dt in date default hr_api.g_date
178: ,p_strt_tm in varchar2 default hr_api.g_varchar2
179: ,p_end_tm in varchar2 default hr_api.g_varchar2
180: ,p_elpsd_tm in varchar2 default hr_api.g_varchar2
173: (p_validate in boolean default false
174: ,p_batch_proc_id in number
175: ,p_benefit_action_id in number default hr_api.g_number
176: ,p_strt_dt in date default hr_api.g_date
177: ,p_end_dt in date default hr_api.g_date
178: ,p_strt_tm in varchar2 default hr_api.g_varchar2
179: ,p_end_tm in varchar2 default hr_api.g_varchar2
180: ,p_elpsd_tm in varchar2 default hr_api.g_varchar2
181: ,p_per_slctd in number default hr_api.g_number
174: ,p_batch_proc_id in number
175: ,p_benefit_action_id in number default hr_api.g_number
176: ,p_strt_dt in date default hr_api.g_date
177: ,p_end_dt in date default hr_api.g_date
178: ,p_strt_tm in varchar2 default hr_api.g_varchar2
179: ,p_end_tm in varchar2 default hr_api.g_varchar2
180: ,p_elpsd_tm in varchar2 default hr_api.g_varchar2
181: ,p_per_slctd in number default hr_api.g_number
182: ,p_per_proc in number default hr_api.g_number
175: ,p_benefit_action_id in number default hr_api.g_number
176: ,p_strt_dt in date default hr_api.g_date
177: ,p_end_dt in date default hr_api.g_date
178: ,p_strt_tm in varchar2 default hr_api.g_varchar2
179: ,p_end_tm in varchar2 default hr_api.g_varchar2
180: ,p_elpsd_tm in varchar2 default hr_api.g_varchar2
181: ,p_per_slctd in number default hr_api.g_number
182: ,p_per_proc in number default hr_api.g_number
183: ,p_per_unproc in number default hr_api.g_number
176: ,p_strt_dt in date default hr_api.g_date
177: ,p_end_dt in date default hr_api.g_date
178: ,p_strt_tm in varchar2 default hr_api.g_varchar2
179: ,p_end_tm in varchar2 default hr_api.g_varchar2
180: ,p_elpsd_tm in varchar2 default hr_api.g_varchar2
181: ,p_per_slctd in number default hr_api.g_number
182: ,p_per_proc in number default hr_api.g_number
183: ,p_per_unproc in number default hr_api.g_number
184: ,p_per_proc_succ in number default hr_api.g_number
177: ,p_end_dt in date default hr_api.g_date
178: ,p_strt_tm in varchar2 default hr_api.g_varchar2
179: ,p_end_tm in varchar2 default hr_api.g_varchar2
180: ,p_elpsd_tm in varchar2 default hr_api.g_varchar2
181: ,p_per_slctd in number default hr_api.g_number
182: ,p_per_proc in number default hr_api.g_number
183: ,p_per_unproc in number default hr_api.g_number
184: ,p_per_proc_succ in number default hr_api.g_number
185: ,p_per_err in number default hr_api.g_number
178: ,p_strt_tm in varchar2 default hr_api.g_varchar2
179: ,p_end_tm in varchar2 default hr_api.g_varchar2
180: ,p_elpsd_tm in varchar2 default hr_api.g_varchar2
181: ,p_per_slctd in number default hr_api.g_number
182: ,p_per_proc in number default hr_api.g_number
183: ,p_per_unproc in number default hr_api.g_number
184: ,p_per_proc_succ in number default hr_api.g_number
185: ,p_per_err in number default hr_api.g_number
186: ,p_business_group_id in number default hr_api.g_number
179: ,p_end_tm in varchar2 default hr_api.g_varchar2
180: ,p_elpsd_tm in varchar2 default hr_api.g_varchar2
181: ,p_per_slctd in number default hr_api.g_number
182: ,p_per_proc in number default hr_api.g_number
183: ,p_per_unproc in number default hr_api.g_number
184: ,p_per_proc_succ in number default hr_api.g_number
185: ,p_per_err in number default hr_api.g_number
186: ,p_business_group_id in number default hr_api.g_number
187: ,p_object_version_number in out nocopy number) is
180: ,p_elpsd_tm in varchar2 default hr_api.g_varchar2
181: ,p_per_slctd in number default hr_api.g_number
182: ,p_per_proc in number default hr_api.g_number
183: ,p_per_unproc in number default hr_api.g_number
184: ,p_per_proc_succ in number default hr_api.g_number
185: ,p_per_err in number default hr_api.g_number
186: ,p_business_group_id in number default hr_api.g_number
187: ,p_object_version_number in out nocopy number) is
188: --
181: ,p_per_slctd in number default hr_api.g_number
182: ,p_per_proc in number default hr_api.g_number
183: ,p_per_unproc in number default hr_api.g_number
184: ,p_per_proc_succ in number default hr_api.g_number
185: ,p_per_err in number default hr_api.g_number
186: ,p_business_group_id in number default hr_api.g_number
187: ,p_object_version_number in out nocopy number) is
188: --
189: -- Declare cursors and local variables
182: ,p_per_proc in number default hr_api.g_number
183: ,p_per_unproc in number default hr_api.g_number
184: ,p_per_proc_succ in number default hr_api.g_number
185: ,p_per_err in number default hr_api.g_number
186: ,p_business_group_id in number default hr_api.g_number
187: ,p_object_version_number in out nocopy number) is
188: --
189: -- Declare cursors and local variables
190: --
226: ,p_object_version_number => p_object_version_number);
227: --
228: exception
229: --
230: when hr_api.cannot_find_prog_unit then
231: hr_api.cannot_find_prog_unit_error
232: (p_module_name => 'UPDATE_batch_proc_info'
233: ,p_hook_type => 'BP');
234: --
227: --
228: exception
229: --
230: when hr_api.cannot_find_prog_unit then
231: hr_api.cannot_find_prog_unit_error
232: (p_module_name => 'UPDATE_batch_proc_info'
233: ,p_hook_type => 'BP');
234: --
235: -- End of API User Hook for the before hook of update_batch_proc_info
273: ,p_object_version_number => l_object_version_number);
274: --
275: exception
276: --
277: when hr_api.cannot_find_prog_unit then
278: --
279: hr_api.cannot_find_prog_unit_error
280: (p_module_name => 'UPDATE_batch_proc_info'
281: ,p_hook_type => 'AP');
275: exception
276: --
277: when hr_api.cannot_find_prog_unit then
278: --
279: hr_api.cannot_find_prog_unit_error
280: (p_module_name => 'UPDATE_batch_proc_info'
281: ,p_hook_type => 'AP');
282: --
283: -- End of API User Hook for the after hook of update_batch_proc_info
288: --
289: -- When in validation only mode raise the Validate_Enabled exception
290: --
291: if p_validate then
292: raise hr_api.validate_enabled;
293: end if;
294: --
295: -- Set all output arguments
296: --
299: hr_utility.set_location(' Leaving:'||l_proc, 70);
300: --
301: exception
302: --
303: when hr_api.validate_enabled then
304: --
305: -- As the Validate_Enabled exception has been raised
306: -- we must rollback to the savepoint
307: --
359: ,p_object_version_number => p_object_version_number);
360: --
361: exception
362: --
363: when hr_api.cannot_find_prog_unit then
364: --
365: hr_api.cannot_find_prog_unit_error
366: (p_module_name => 'DELETE_batch_proc_info'
367: ,p_hook_type => 'BP');
361: exception
362: --
363: when hr_api.cannot_find_prog_unit then
364: --
365: hr_api.cannot_find_prog_unit_error
366: (p_module_name => 'DELETE_batch_proc_info'
367: ,p_hook_type => 'BP');
368: --
369: -- End of API User Hook for the before hook of delete_batch_proc_info
383: ,p_object_version_number => l_object_version_number);
384: --
385: exception
386: --
387: when hr_api.cannot_find_prog_unit then
388: --
389: hr_api.cannot_find_prog_unit_error
390: (p_module_name => 'DELETE_batch_proc_info'
391: ,p_hook_type => 'AP');
385: exception
386: --
387: when hr_api.cannot_find_prog_unit then
388: --
389: hr_api.cannot_find_prog_unit_error
390: (p_module_name => 'DELETE_batch_proc_info'
391: ,p_hook_type => 'AP');
392: --
393: -- End of API User Hook for the after hook of delete_batch_proc_info
398: --
399: -- When in validation only mode raise the Validate_Enabled exception
400: --
401: if p_validate then
402: raise hr_api.validate_enabled;
403: end if;
404: --
405: hr_utility.set_location(' Leaving:'||l_proc, 70);
406: --
405: hr_utility.set_location(' Leaving:'||l_proc, 70);
406: --
407: exception
408: --
409: when hr_api.validate_enabled then
410: --
411: -- As the Validate_Enabled exception has been raised
412: -- we must rollback to the savepoint
413: --