114: ,p_business_group_id => p_business_group_id
115: ,p_code_Rate_id => l_code_Rate_id
116: );
117: exception
118: when hr_api.cannot_find_prog_unit then
119: hr_api.cannot_find_prog_unit_error
120: (p_module_name => 'CREATE_CONTRIBUTION_USAGE'
121: ,p_hook_type => 'BP'
122: );
115: ,p_code_Rate_id => l_code_Rate_id
116: );
117: exception
118: when hr_api.cannot_find_prog_unit then
119: hr_api.cannot_find_prog_unit_error
120: (p_module_name => 'CREATE_CONTRIBUTION_USAGE'
121: ,p_hook_type => 'BP'
122: );
123: end;
167: ,p_object_version_number => l_object_version_number
168: ,p_code_Rate_id => l_code_Rate_id
169: );
170: exception
171: when hr_api.cannot_find_prog_unit then
172: hr_api.cannot_find_prog_unit_error
173: (p_module_name => 'CREATE_CONTRIBUTION_USAGE'
174: ,p_hook_type => 'AP'
175: );
168: ,p_code_Rate_id => l_code_Rate_id
169: );
170: exception
171: when hr_api.cannot_find_prog_unit then
172: hr_api.cannot_find_prog_unit_error
173: (p_module_name => 'CREATE_CONTRIBUTION_USAGE'
174: ,p_hook_type => 'AP'
175: );
176: end;
177: --
178: -- When in validation only mode raise the Validate_Enabled exception
179: --
180: if p_validate then
181: raise hr_api.validate_enabled;
182: end if;
183: --
184: -- Set all output arguments
185: --
188: p_code_Rate_id := l_code_Rate_id;
189: --
190: hr_utility.set_location(' Leaving:'||l_proc, 70);
191: exception
192: when hr_api.validate_enabled then
193: --
194: -- As the Validate_Enabled exception has been raised
195: -- we must rollback to the savepoint
196: --
226: procedure update_contribution_usage
227: (p_validate IN boolean default false
228: ,p_effective_date IN date
229: ,p_contribution_usage_id IN number
230: ,p_date_to IN date default hr_api.g_date
231: ,p_contribution_code IN varchar2
232: ,p_contribution_type IN varchar2
233: ,p_retro_contribution_code IN varchar2 default hr_api.g_varchar2
234: ,p_object_version_number IN OUT nocopy number
229: ,p_contribution_usage_id IN number
230: ,p_date_to IN date default hr_api.g_date
231: ,p_contribution_code IN varchar2
232: ,p_contribution_type IN varchar2
233: ,p_retro_contribution_code IN varchar2 default hr_api.g_varchar2
234: ,p_object_version_number IN OUT nocopy number
235: ,p_code_rate_id IN varchar2
236: ) is
237: --
267: ,p_retro_contribution_code => p_retro_contribution_code
268: ,p_code_rate_id => p_code_rate_id
269: );
270: exception
271: when hr_api.cannot_find_prog_unit then
272: hr_api.cannot_find_prog_unit_error
273: (p_module_name => 'UPDATE_CONTRIBUTION_USAGE'
274: ,p_hook_type => 'BP'
275: );
268: ,p_code_rate_id => p_code_rate_id
269: );
270: exception
271: when hr_api.cannot_find_prog_unit then
272: hr_api.cannot_find_prog_unit_error
273: (p_module_name => 'UPDATE_CONTRIBUTION_USAGE'
274: ,p_hook_type => 'BP'
275: );
276: end;
304: ,p_retro_contribution_code => p_retro_contribution_code
305: ,p_code_rate_id => p_code_rate_id
306: );
307: exception
308: when hr_api.cannot_find_prog_unit then
309: hr_api.cannot_find_prog_unit_error
310: (p_module_name => 'UPDATE_CONTRIBUTION_USAGE'
311: ,p_hook_type => 'AP'
312: );
305: ,p_code_rate_id => p_code_rate_id
306: );
307: exception
308: when hr_api.cannot_find_prog_unit then
309: hr_api.cannot_find_prog_unit_error
310: (p_module_name => 'UPDATE_CONTRIBUTION_USAGE'
311: ,p_hook_type => 'AP'
312: );
313: end;
314: --
315: -- When in validation only mode raise the Validate_Enabled exception
316: --
317: if p_validate then
318: raise hr_api.validate_enabled;
319: end if;
320: --
321: -- Set all output arguments
322: p_object_version_number := l_object_version_number;
322: p_object_version_number := l_object_version_number;
323: --
324: hr_utility.set_location(' Leaving:'||l_proc, 70);
325: exception
326: when hr_api.validate_enabled then
327: --
328: -- As the Validate_Enabled exception has been raised
329: -- we must rollback to the savepoint
330: --
381: (p_contribution_usage_id => p_contribution_usage_id
382: ,p_object_version_number => p_object_version_number
383: );
384: exception
385: when hr_api.cannot_find_prog_unit then
386: hr_api.cannot_find_prog_unit_error
387: (p_module_name => 'DELETE_CONTRIBUTION_USAGE'
388: ,p_hook_type => 'BP'
389: );
382: ,p_object_version_number => p_object_version_number
383: );
384: exception
385: when hr_api.cannot_find_prog_unit then
386: hr_api.cannot_find_prog_unit_error
387: (p_module_name => 'DELETE_CONTRIBUTION_USAGE'
388: ,p_hook_type => 'BP'
389: );
390: end;
406: (p_contribution_usage_id => p_contribution_usage_id
407: ,p_object_version_number => p_object_version_number
408: );
409: exception
410: when hr_api.cannot_find_prog_unit then
411: hr_api.cannot_find_prog_unit_error
412: (p_module_name => 'DELETE_CONTRIBUTION_USAGE'
413: ,p_hook_type => 'AP'
414: );
407: ,p_object_version_number => p_object_version_number
408: );
409: exception
410: when hr_api.cannot_find_prog_unit then
411: hr_api.cannot_find_prog_unit_error
412: (p_module_name => 'DELETE_CONTRIBUTION_USAGE'
413: ,p_hook_type => 'AP'
414: );
415: end;
416: --
417: -- When in validation only mode raise the Validate_Enabled exception
418: --
419: if p_validate then
420: raise hr_api.validate_enabled;
421: end if;
422: --
423: -- Set all output arguments
424: --
424: --
425: --
426: hr_utility.set_location(' Leaving:'||l_proc, 170);
427: exception
428: when hr_api.validate_enabled then
429: --
430: -- As the Validate_Enabled exception has been raised
431: -- we must rollback to the savepoint
432: --