51: ,p_effective_date => trunc(p_effective_date));
52: --
53: exception
54: --
55: when hr_api.cannot_find_prog_unit then
56: hr_api.cannot_find_prog_unit_error
57: (p_module_name => 'CREATE_batch_parameter'
58: ,p_hook_type => 'BP');
59: --
52: --
53: exception
54: --
55: when hr_api.cannot_find_prog_unit then
56: hr_api.cannot_find_prog_unit_error
57: (p_module_name => 'CREATE_batch_parameter'
58: ,p_hook_type => 'BP');
59: --
60: -- End of API User Hook for the before hook of create_batch_parameter
86: ,p_effective_date => trunc(p_effective_date));
87: --
88: exception
89: --
90: when hr_api.cannot_find_prog_unit then
91: --
92: hr_api.cannot_find_prog_unit_error
93: (p_module_name => 'CREATE_batch_parameter'
94: ,p_hook_type => 'AP');
88: exception
89: --
90: when hr_api.cannot_find_prog_unit then
91: --
92: hr_api.cannot_find_prog_unit_error
93: (p_module_name => 'CREATE_batch_parameter'
94: ,p_hook_type => 'AP');
95: --
96: -- End of API User Hook for the after hook of create_batch_parameter
101: --
102: -- When in validation only mode raise the Validate_Enabled exception
103: --
104: if p_validate then
105: raise hr_api.validate_enabled;
106: end if;
107: --
108: -- Set all output arguments
109: --
113: hr_utility.set_location(' Leaving:'||l_proc, 70);
114: --
115: exception
116: --
117: when hr_api.validate_enabled then
118: --
119: -- As the Validate_Enabled exception has been raised
120: -- we must rollback to the savepoint
121: --
143: --
144: procedure update_batch_parameter
145: (p_validate in boolean default false
146: ,p_batch_parameter_id in number
147: ,p_batch_exe_cd in varchar2 default hr_api.g_varchar2
148: ,p_thread_cnt_num in number default hr_api.g_number
149: ,p_max_err_num in number default hr_api.g_number
150: ,p_chunk_size in number default hr_api.g_number
151: ,p_business_group_id in number default hr_api.g_number
144: procedure update_batch_parameter
145: (p_validate in boolean default false
146: ,p_batch_parameter_id in number
147: ,p_batch_exe_cd in varchar2 default hr_api.g_varchar2
148: ,p_thread_cnt_num in number default hr_api.g_number
149: ,p_max_err_num in number default hr_api.g_number
150: ,p_chunk_size in number default hr_api.g_number
151: ,p_business_group_id in number default hr_api.g_number
152: ,p_object_version_number in out nocopy number
145: (p_validate in boolean default false
146: ,p_batch_parameter_id in number
147: ,p_batch_exe_cd in varchar2 default hr_api.g_varchar2
148: ,p_thread_cnt_num in number default hr_api.g_number
149: ,p_max_err_num in number default hr_api.g_number
150: ,p_chunk_size in number default hr_api.g_number
151: ,p_business_group_id in number default hr_api.g_number
152: ,p_object_version_number in out nocopy number
153: ,p_effective_date in date) is
146: ,p_batch_parameter_id in number
147: ,p_batch_exe_cd in varchar2 default hr_api.g_varchar2
148: ,p_thread_cnt_num in number default hr_api.g_number
149: ,p_max_err_num in number default hr_api.g_number
150: ,p_chunk_size in number default hr_api.g_number
151: ,p_business_group_id in number default hr_api.g_number
152: ,p_object_version_number in out nocopy number
153: ,p_effective_date in date) is
154: --
147: ,p_batch_exe_cd in varchar2 default hr_api.g_varchar2
148: ,p_thread_cnt_num in number default hr_api.g_number
149: ,p_max_err_num in number default hr_api.g_number
150: ,p_chunk_size in number default hr_api.g_number
151: ,p_business_group_id in number default hr_api.g_number
152: ,p_object_version_number in out nocopy number
153: ,p_effective_date in date) is
154: --
155: -- Declare cursors and local variables
186: ,p_effective_date => trunc(p_effective_date));
187: --
188: exception
189: --
190: when hr_api.cannot_find_prog_unit then
191: hr_api.cannot_find_prog_unit_error
192: (p_module_name => 'UPDATE_batch_parameter'
193: ,p_hook_type => 'BP');
194: --
187: --
188: exception
189: --
190: when hr_api.cannot_find_prog_unit then
191: hr_api.cannot_find_prog_unit_error
192: (p_module_name => 'UPDATE_batch_parameter'
193: ,p_hook_type => 'BP');
194: --
195: -- End of API User Hook for the before hook of update_batch_parameter
221: ,p_effective_date => trunc(p_effective_date));
222: --
223: exception
224: --
225: when hr_api.cannot_find_prog_unit then
226: hr_api.cannot_find_prog_unit_error
227: (p_module_name => 'UPDATE_batch_parameter'
228: ,p_hook_type => 'AP');
229: --
222: --
223: exception
224: --
225: when hr_api.cannot_find_prog_unit then
226: hr_api.cannot_find_prog_unit_error
227: (p_module_name => 'UPDATE_batch_parameter'
228: ,p_hook_type => 'AP');
229: --
230: -- End of API User Hook for the after hook of update_batch_parameter
235: --
236: -- When in validation only mode raise the Validate_Enabled exception
237: --
238: if p_validate then
239: raise hr_api.validate_enabled;
240: end if;
241: --
242: -- Set all output arguments
243: --
246: hr_utility.set_location(' Leaving:'||l_proc, 70);
247: --
248: exception
249: --
250: when hr_api.validate_enabled then
251: --
252: -- As the Validate_Enabled exception has been raised
253: -- we must rollback to the savepoint
254: --
308: ,p_effective_date => trunc(p_effective_date));
309: --
310: exception
311: --
312: when hr_api.cannot_find_prog_unit then
313: --
314: hr_api.cannot_find_prog_unit_error
315: (p_module_name => 'DELETE_batch_parameter'
316: ,p_hook_type => 'BP');
310: exception
311: --
312: when hr_api.cannot_find_prog_unit then
313: --
314: hr_api.cannot_find_prog_unit_error
315: (p_module_name => 'DELETE_batch_parameter'
316: ,p_hook_type => 'BP');
317: --
318: -- End of API User Hook for the before hook of delete_batch_parameter
334: ,p_effective_date => trunc(p_effective_date));
335: --
336: exception
337: --
338: when hr_api.cannot_find_prog_unit then
339: --
340: hr_api.cannot_find_prog_unit_error
341: (p_module_name => 'DELETE_batch_parameter'
342: ,p_hook_type => 'AP');
336: exception
337: --
338: when hr_api.cannot_find_prog_unit then
339: --
340: hr_api.cannot_find_prog_unit_error
341: (p_module_name => 'DELETE_batch_parameter'
342: ,p_hook_type => 'AP');
343: --
344: -- End of API User Hook for the after hook of delete_batch_parameter
349: --
350: -- When in validation only mode raise the Validate_Enabled exception
351: --
352: if p_validate then
353: raise hr_api.validate_enabled;
354: end if;
355: --
356: hr_utility.set_location(' Leaving:'||l_proc, 70);
357: --
356: hr_utility.set_location(' Leaving:'||l_proc, 70);
357: --
358: exception
359: --
360: when hr_api.validate_enabled then
361: --
362: -- As the Validate_Enabled exception has been raised
363: -- we must rollback to the savepoint
364: --