74: ,p_business_group_id => p_business_group_id
75: ,p_legislation_code => p_legislation_code
76: );
77: exception
78: when hr_api.cannot_find_prog_unit then
79: hr_api.cannot_find_prog_unit_error
80: (p_module_name => 'create_rate_factor_on_elmnt'
81: ,p_hook_type => 'BP'
82: );
75: ,p_legislation_code => p_legislation_code
76: );
77: exception
78: when hr_api.cannot_find_prog_unit then
79: hr_api.cannot_find_prog_unit_error
80: (p_module_name => 'create_rate_factor_on_elmnt'
81: ,p_hook_type => 'BP'
82: );
83: end;
145: ,p_rate_factor_on_elmnt_id => l_rate_factor_on_elmnt_id
146: ,p_object_version_number => l_object_version_number
147: );
148: exception
149: when hr_api.cannot_find_prog_unit then
150: hr_api.cannot_find_prog_unit_error
151: (p_module_name => 'create_rate_factor_on_elmnt'
152: ,p_hook_type => 'AP'
153: );
146: ,p_object_version_number => l_object_version_number
147: );
148: exception
149: when hr_api.cannot_find_prog_unit then
150: hr_api.cannot_find_prog_unit_error
151: (p_module_name => 'create_rate_factor_on_elmnt'
152: ,p_hook_type => 'AP'
153: );
154: end;
155: --
156: -- When in validation only mode raise the Validate_Enabled exception
157: --
158: if p_validate then
159: raise hr_api.validate_enabled;
160: end if;
161: --
162: -- Set all IN OUT and OUT parameters with out values
163: --
165: p_object_version_number := l_object_version_number;
166: --
167: hr_utility.set_location(' Leaving:'||l_proc, 70);
168: exception
169: when hr_api.validate_enabled then
170: --
171: -- As the Validate_Enabled exception has been raised
172: -- we must rollback to the savepoint
173: --
207: procedure update_rate_factor_on_elmnt
208: (p_validate in boolean default false
209: ,p_effective_date in date
210: ,p_rate_factor_on_elmnt_id in number
211: ,p_criteria_rate_element_id in number default hr_api.g_number
212: ,p_criteria_rate_factor_id in number default hr_api.g_number
213: ,p_rate_factor_val_record_tbl in varchar2 default hr_api.g_varchar2
214: ,p_rate_factor_val_record_col in varchar2 default hr_api.g_varchar2
215: ,p_business_group_id in number default hr_api.g_number
208: (p_validate in boolean default false
209: ,p_effective_date in date
210: ,p_rate_factor_on_elmnt_id in number
211: ,p_criteria_rate_element_id in number default hr_api.g_number
212: ,p_criteria_rate_factor_id in number default hr_api.g_number
213: ,p_rate_factor_val_record_tbl in varchar2 default hr_api.g_varchar2
214: ,p_rate_factor_val_record_col in varchar2 default hr_api.g_varchar2
215: ,p_business_group_id in number default hr_api.g_number
216: ,p_legislation_code in varchar2 default hr_api.g_varchar2
209: ,p_effective_date in date
210: ,p_rate_factor_on_elmnt_id in number
211: ,p_criteria_rate_element_id in number default hr_api.g_number
212: ,p_criteria_rate_factor_id in number default hr_api.g_number
213: ,p_rate_factor_val_record_tbl in varchar2 default hr_api.g_varchar2
214: ,p_rate_factor_val_record_col in varchar2 default hr_api.g_varchar2
215: ,p_business_group_id in number default hr_api.g_number
216: ,p_legislation_code in varchar2 default hr_api.g_varchar2
217: ,p_object_version_number in out nocopy number
210: ,p_rate_factor_on_elmnt_id in number
211: ,p_criteria_rate_element_id in number default hr_api.g_number
212: ,p_criteria_rate_factor_id in number default hr_api.g_number
213: ,p_rate_factor_val_record_tbl in varchar2 default hr_api.g_varchar2
214: ,p_rate_factor_val_record_col in varchar2 default hr_api.g_varchar2
215: ,p_business_group_id in number default hr_api.g_number
216: ,p_legislation_code in varchar2 default hr_api.g_varchar2
217: ,p_object_version_number in out nocopy number
218: )is
211: ,p_criteria_rate_element_id in number default hr_api.g_number
212: ,p_criteria_rate_factor_id in number default hr_api.g_number
213: ,p_rate_factor_val_record_tbl in varchar2 default hr_api.g_varchar2
214: ,p_rate_factor_val_record_col in varchar2 default hr_api.g_varchar2
215: ,p_business_group_id in number default hr_api.g_number
216: ,p_legislation_code in varchar2 default hr_api.g_varchar2
217: ,p_object_version_number in out nocopy number
218: )is
219: --
212: ,p_criteria_rate_factor_id in number default hr_api.g_number
213: ,p_rate_factor_val_record_tbl in varchar2 default hr_api.g_varchar2
214: ,p_rate_factor_val_record_col in varchar2 default hr_api.g_varchar2
215: ,p_business_group_id in number default hr_api.g_number
216: ,p_legislation_code in varchar2 default hr_api.g_varchar2
217: ,p_object_version_number in out nocopy number
218: )is
219: --
220: -- Declare cursors and local variables
269: ,p_rate_factor_on_elmnt_id => p_rate_factor_on_elmnt_id
270: ,p_object_version_number => l_object_version_number
271: );
272: exception
273: when hr_api.cannot_find_prog_unit then
274: hr_api.cannot_find_prog_unit_error
275: (p_module_name => 'update_rate_factor_on_elmnt'
276: ,p_hook_type => 'BP'
277: );
270: ,p_object_version_number => l_object_version_number
271: );
272: exception
273: when hr_api.cannot_find_prog_unit then
274: hr_api.cannot_find_prog_unit_error
275: (p_module_name => 'update_rate_factor_on_elmnt'
276: ,p_hook_type => 'BP'
277: );
278: end;
312: ,p_rate_factor_on_elmnt_id => p_rate_factor_on_elmnt_id
313: ,p_object_version_number => l_object_version_number
314: );
315: exception
316: when hr_api.cannot_find_prog_unit then
317: hr_api.cannot_find_prog_unit_error
318: (p_module_name => 'update_rate_factor_on_elmnt'
319: ,p_hook_type => 'AP'
320: );
313: ,p_object_version_number => l_object_version_number
314: );
315: exception
316: when hr_api.cannot_find_prog_unit then
317: hr_api.cannot_find_prog_unit_error
318: (p_module_name => 'update_rate_factor_on_elmnt'
319: ,p_hook_type => 'AP'
320: );
321: end;
322: --
323: -- When in validation only mode raise the Validate_Enabled exception
324: --
325: if p_validate then
326: raise hr_api.validate_enabled;
327: end if;
328: --
329: -- Set all IN OUT and OUT parameters with out values
330: --
331: p_object_version_number := l_object_version_number;
332: --
333: hr_utility.set_location(' Leaving:'||l_proc, 70);
334: exception
335: when hr_api.validate_enabled then
336: --
337: -- As the Validate_Enabled exception has been raised
338: -- we must rollback to the savepoint
339: --
401: ,p_rate_factor_on_elmnt_id => p_rate_factor_on_elmnt_id
402: ,p_object_version_number => p_object_version_number
403: );
404: exception
405: when hr_api.cannot_find_prog_unit then
406: hr_api.cannot_find_prog_unit_error
407: (p_module_name => 'delete_rate_factor_on_elmnt'
408: ,p_hook_type => 'BP'
409: );
402: ,p_object_version_number => p_object_version_number
403: );
404: exception
405: when hr_api.cannot_find_prog_unit then
406: hr_api.cannot_find_prog_unit_error
407: (p_module_name => 'delete_rate_factor_on_elmnt'
408: ,p_hook_type => 'BP'
409: );
410: end;
433: ,p_rate_factor_on_elmnt_id => p_rate_factor_on_elmnt_id
434: ,p_object_version_number => p_object_version_number
435: );
436: exception
437: when hr_api.cannot_find_prog_unit then
438: hr_api.cannot_find_prog_unit_error
439: (p_module_name => 'delete_rate_factor_on_elmnt'
440: ,p_hook_type => 'AP'
441: );
434: ,p_object_version_number => p_object_version_number
435: );
436: exception
437: when hr_api.cannot_find_prog_unit then
438: hr_api.cannot_find_prog_unit_error
439: (p_module_name => 'delete_rate_factor_on_elmnt'
440: ,p_hook_type => 'AP'
441: );
442: end;
443: --
444: -- When in validation only mode raise the Validate_Enabled exception
445: --
446: if p_validate then
447: raise hr_api.validate_enabled;
448: end if;
449: --
450: -- Set all IN OUT and OUT parameters with out values
451: --
451: --
452: --
453: hr_utility.set_location(' Leaving:'||l_proc, 70);
454: exception
455: when hr_api.validate_enabled then
456: --
457: -- As the Validate_Enabled exception has been raised
458: -- we must rollback to the savepoint
459: --