63: ,p_business_group_id => p_business_group_id
64: ,p_legislation_code => p_legislation_code
65: );
66: exception
67: when hr_api.cannot_find_prog_unit then
68: hr_api.cannot_find_prog_unit_error
69: (p_module_name => 'create_run_type_org_method'
70: ,p_hook_type => 'BP'
71: );
64: ,p_legislation_code => p_legislation_code
65: );
66: exception
67: when hr_api.cannot_find_prog_unit then
68: hr_api.cannot_find_prog_unit_error
69: (p_module_name => 'create_run_type_org_method'
70: ,p_hook_type => 'BP'
71: );
72: end;
114: ,p_effective_start_date => l_effective_start_date
115: ,p_effective_end_date => l_effective_end_date
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_run_type_org_method'
121: ,p_hook_type => 'AP'
122: );
115: ,p_effective_end_date => l_effective_end_date
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_run_type_org_method'
121: ,p_hook_type => 'AP'
122: );
123: end;
125: --
126: -- When in validation only mode raise the Validate_Enabled exception
127: --
128: if p_validate then
129: raise hr_api.validate_enabled;
130: end if;
131: --
132: -- Set all output arguments
133: --
137: p_effective_end_date := l_effective_end_date;
138: --
139: hr_utility.set_location(' Leaving:'||l_proc, 70);
140: exception
141: when hr_api.validate_enabled then
142: --
143: -- As the Validate_Enabled exception has been raised
144: -- we must rollback to the savepoint
145: --
180: ,p_effective_date in date
181: ,p_datetrack_update_mode in varchar2
182: ,p_run_type_org_method_id in number
183: ,p_object_version_number in out nocopy number
184: ,p_priority in number default hr_api.g_number
185: ,p_percentage in number default hr_api.g_number
186: ,p_amount in number default hr_api.g_number
187: ,p_business_group_id in number default hr_api.g_number
188: ,p_legislation_code in varchar2 default hr_api.g_varchar2
181: ,p_datetrack_update_mode in varchar2
182: ,p_run_type_org_method_id in number
183: ,p_object_version_number in out nocopy number
184: ,p_priority in number default hr_api.g_number
185: ,p_percentage in number default hr_api.g_number
186: ,p_amount in number default hr_api.g_number
187: ,p_business_group_id in number default hr_api.g_number
188: ,p_legislation_code in varchar2 default hr_api.g_varchar2
189: ,p_effective_start_date out nocopy date
182: ,p_run_type_org_method_id in number
183: ,p_object_version_number in out nocopy number
184: ,p_priority in number default hr_api.g_number
185: ,p_percentage in number default hr_api.g_number
186: ,p_amount in number default hr_api.g_number
187: ,p_business_group_id in number default hr_api.g_number
188: ,p_legislation_code in varchar2 default hr_api.g_varchar2
189: ,p_effective_start_date out nocopy date
190: ,p_effective_end_date out nocopy date
183: ,p_object_version_number in out nocopy number
184: ,p_priority in number default hr_api.g_number
185: ,p_percentage in number default hr_api.g_number
186: ,p_amount in number default hr_api.g_number
187: ,p_business_group_id in number default hr_api.g_number
188: ,p_legislation_code in varchar2 default hr_api.g_varchar2
189: ,p_effective_start_date out nocopy date
190: ,p_effective_end_date out nocopy date
191: ) is
184: ,p_priority in number default hr_api.g_number
185: ,p_percentage in number default hr_api.g_number
186: ,p_amount in number default hr_api.g_number
187: ,p_business_group_id in number default hr_api.g_number
188: ,p_legislation_code in varchar2 default hr_api.g_varchar2
189: ,p_effective_start_date out nocopy date
190: ,p_effective_end_date out nocopy date
191: ) is
192: --
232: ,p_business_group_id => p_business_group_id
233: ,p_legislation_code => p_legislation_code
234: );
235: exception
236: when hr_api.cannot_find_prog_unit then
237: hr_api.cannot_find_prog_unit_error
238: (p_module_name => 'update_run_type_org_method'
239: ,p_hook_type => 'BP'
240: );
233: ,p_legislation_code => p_legislation_code
234: );
235: exception
236: when hr_api.cannot_find_prog_unit then
237: hr_api.cannot_find_prog_unit_error
238: (p_module_name => 'update_run_type_org_method'
239: ,p_hook_type => 'BP'
240: );
241: end;
279: ,p_effective_start_date => l_effective_start_date
280: ,p_effective_end_date => l_effective_end_date
281: );
282: exception
283: when hr_api.cannot_find_prog_unit then
284: hr_api.cannot_find_prog_unit_error
285: (p_module_name => 'update_run_type_org_method'
286: ,p_hook_type => 'AP'
287: );
280: ,p_effective_end_date => l_effective_end_date
281: );
282: exception
283: when hr_api.cannot_find_prog_unit then
284: hr_api.cannot_find_prog_unit_error
285: (p_module_name => 'update_run_type_org_method'
286: ,p_hook_type => 'AP'
287: );
288: end;
290: --
291: -- When in validation only mode raise the Validate_Enabled exception
292: --
293: if p_validate then
294: raise hr_api.validate_enabled;
295: end if;
296: --
297: -- Set all output arguments
298: --
301: p_effective_end_date := l_effective_end_date;
302: --
303: hr_utility.set_location(' Leaving:'||l_proc, 70);
304: exception
305: when hr_api.validate_enabled then
306: --
307: -- As the Validate_Enabled exception has been raised
308: -- we must rollback to the savepoint
309: --
388: ,p_business_group_id => p_business_group_id
389: ,p_legislation_code => p_legislation_code
390: );
391: exception
392: when hr_api.cannot_find_prog_unit then
393: hr_api.cannot_find_prog_unit_error
394: (p_module_name => 'delete_run_type_org_method'
395: ,p_hook_type => 'BP'
396: );
389: ,p_legislation_code => p_legislation_code
390: );
391: exception
392: when hr_api.cannot_find_prog_unit then
393: hr_api.cannot_find_prog_unit_error
394: (p_module_name => 'delete_run_type_org_method'
395: ,p_hook_type => 'BP'
396: );
397: end;
429: ,p_effective_start_date => l_effective_start_date
430: ,p_effective_end_date => l_effective_end_date
431: );
432: exception
433: when hr_api.cannot_find_prog_unit then
434: hr_api.cannot_find_prog_unit_error
435: (p_module_name => 'delete_run_type_org_method'
436: ,p_hook_type => 'AP'
437: );
430: ,p_effective_end_date => l_effective_end_date
431: );
432: exception
433: when hr_api.cannot_find_prog_unit then
434: hr_api.cannot_find_prog_unit_error
435: (p_module_name => 'delete_run_type_org_method'
436: ,p_hook_type => 'AP'
437: );
438: end;
440: --
441: -- When in validation only mode raise the Validate_Enabled exception
442: --
443: if p_validate then
444: raise hr_api.validate_enabled;
445: end if;
446: --
447: -- Set all output arguments
448: --
451: p_effective_end_date := l_effective_end_date;
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: --