62: ,p_override_user_id => p_override_user_id
63: ,p_effective_date => trunc(p_effective_date)
64: );
65: exception
66: when hr_api.cannot_find_prog_unit then
67: hr_api.cannot_find_prog_unit_error
68: (
69: p_module_name => 'CREATE_ROUTING_CATEGORY'
70: ,p_hook_type => 'BP'
63: ,p_effective_date => trunc(p_effective_date)
64: );
65: exception
66: when hr_api.cannot_find_prog_unit then
67: hr_api.cannot_find_prog_unit_error
68: (
69: p_module_name => 'CREATE_ROUTING_CATEGORY'
70: ,p_hook_type => 'BP'
71: );
111: ,p_object_version_number => l_object_version_number
112: ,p_effective_date => trunc(p_effective_date)
113: );
114: exception
115: when hr_api.cannot_find_prog_unit then
116: hr_api.cannot_find_prog_unit_error
117: (p_module_name => 'CREATE_ROUTING_CATEGORY'
118: ,p_hook_type => 'AP'
119: );
112: ,p_effective_date => trunc(p_effective_date)
113: );
114: exception
115: when hr_api.cannot_find_prog_unit then
116: hr_api.cannot_find_prog_unit_error
117: (p_module_name => 'CREATE_ROUTING_CATEGORY'
118: ,p_hook_type => 'AP'
119: );
120: --
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: --
170: --
171: procedure update_ROUTING_CATEGORY
172: (p_validate in boolean default false
173: ,p_routing_category_id in number
174: ,p_transaction_category_id in number default hr_api.g_number
175: ,p_enable_flag in varchar2 default hr_api.g_varchar2
176: ,p_default_flag in varchar2 default hr_api.g_varchar2
177: ,p_delete_flag in varchar2 default hr_api.g_varchar2
178: ,p_routing_list_id in number default hr_api.g_number
171: procedure update_ROUTING_CATEGORY
172: (p_validate in boolean default false
173: ,p_routing_category_id in number
174: ,p_transaction_category_id in number default hr_api.g_number
175: ,p_enable_flag in varchar2 default hr_api.g_varchar2
176: ,p_default_flag in varchar2 default hr_api.g_varchar2
177: ,p_delete_flag in varchar2 default hr_api.g_varchar2
178: ,p_routing_list_id in number default hr_api.g_number
179: ,p_position_structure_id in number default hr_api.g_number
172: (p_validate in boolean default false
173: ,p_routing_category_id in number
174: ,p_transaction_category_id in number default hr_api.g_number
175: ,p_enable_flag in varchar2 default hr_api.g_varchar2
176: ,p_default_flag in varchar2 default hr_api.g_varchar2
177: ,p_delete_flag in varchar2 default hr_api.g_varchar2
178: ,p_routing_list_id in number default hr_api.g_number
179: ,p_position_structure_id in number default hr_api.g_number
180: ,p_override_position_id in number default hr_api.g_number
173: ,p_routing_category_id in number
174: ,p_transaction_category_id in number default hr_api.g_number
175: ,p_enable_flag in varchar2 default hr_api.g_varchar2
176: ,p_default_flag in varchar2 default hr_api.g_varchar2
177: ,p_delete_flag in varchar2 default hr_api.g_varchar2
178: ,p_routing_list_id in number default hr_api.g_number
179: ,p_position_structure_id in number default hr_api.g_number
180: ,p_override_position_id in number default hr_api.g_number
181: ,p_override_assignment_id in number default hr_api.g_number
174: ,p_transaction_category_id in number default hr_api.g_number
175: ,p_enable_flag in varchar2 default hr_api.g_varchar2
176: ,p_default_flag in varchar2 default hr_api.g_varchar2
177: ,p_delete_flag in varchar2 default hr_api.g_varchar2
178: ,p_routing_list_id in number default hr_api.g_number
179: ,p_position_structure_id in number default hr_api.g_number
180: ,p_override_position_id in number default hr_api.g_number
181: ,p_override_assignment_id in number default hr_api.g_number
182: ,p_override_role_id in number default hr_api.g_number
175: ,p_enable_flag in varchar2 default hr_api.g_varchar2
176: ,p_default_flag in varchar2 default hr_api.g_varchar2
177: ,p_delete_flag in varchar2 default hr_api.g_varchar2
178: ,p_routing_list_id in number default hr_api.g_number
179: ,p_position_structure_id in number default hr_api.g_number
180: ,p_override_position_id in number default hr_api.g_number
181: ,p_override_assignment_id in number default hr_api.g_number
182: ,p_override_role_id in number default hr_api.g_number
183: ,p_override_user_id in number default hr_api.g_number
176: ,p_default_flag in varchar2 default hr_api.g_varchar2
177: ,p_delete_flag in varchar2 default hr_api.g_varchar2
178: ,p_routing_list_id in number default hr_api.g_number
179: ,p_position_structure_id in number default hr_api.g_number
180: ,p_override_position_id in number default hr_api.g_number
181: ,p_override_assignment_id in number default hr_api.g_number
182: ,p_override_role_id in number default hr_api.g_number
183: ,p_override_user_id in number default hr_api.g_number
184: ,p_object_version_number in out nocopy number
177: ,p_delete_flag in varchar2 default hr_api.g_varchar2
178: ,p_routing_list_id in number default hr_api.g_number
179: ,p_position_structure_id in number default hr_api.g_number
180: ,p_override_position_id in number default hr_api.g_number
181: ,p_override_assignment_id in number default hr_api.g_number
182: ,p_override_role_id in number default hr_api.g_number
183: ,p_override_user_id in number default hr_api.g_number
184: ,p_object_version_number in out nocopy number
185: ,p_effective_date in date
178: ,p_routing_list_id in number default hr_api.g_number
179: ,p_position_structure_id in number default hr_api.g_number
180: ,p_override_position_id in number default hr_api.g_number
181: ,p_override_assignment_id in number default hr_api.g_number
182: ,p_override_role_id in number default hr_api.g_number
183: ,p_override_user_id in number default hr_api.g_number
184: ,p_object_version_number in out nocopy number
185: ,p_effective_date in date
186:
179: ,p_position_structure_id in number default hr_api.g_number
180: ,p_override_position_id in number default hr_api.g_number
181: ,p_override_assignment_id in number default hr_api.g_number
182: ,p_override_role_id in number default hr_api.g_number
183: ,p_override_user_id in number default hr_api.g_number
184: ,p_object_version_number in out nocopy number
185: ,p_effective_date in date
186:
187: ) is
226: ,p_effective_date => trunc(p_effective_date)
227:
228: );
229: exception
230: when hr_api.cannot_find_prog_unit then
231: hr_api.cannot_find_prog_unit_error
232: (p_module_name => 'UPDATE_ROUTING_CATEGORY'
233: ,p_hook_type => 'BP'
234: );
227:
228: );
229: exception
230: when hr_api.cannot_find_prog_unit then
231: hr_api.cannot_find_prog_unit_error
232: (p_module_name => 'UPDATE_ROUTING_CATEGORY'
233: ,p_hook_type => 'BP'
234: );
235: --
276: ,p_effective_date => trunc(p_effective_date)
277:
278: );
279: exception
280: when hr_api.cannot_find_prog_unit then
281: hr_api.cannot_find_prog_unit_error
282: (p_module_name => 'UPDATE_ROUTING_CATEGORY'
283: ,p_hook_type => 'AP'
284: );
277:
278: );
279: exception
280: when hr_api.cannot_find_prog_unit then
281: hr_api.cannot_find_prog_unit_error
282: (p_module_name => 'UPDATE_ROUTING_CATEGORY'
283: ,p_hook_type => 'AP'
284: );
285: --
291: --
292: -- When in validation only mode raise the Validate_Enabled exception
293: --
294: if p_validate then
295: raise hr_api.validate_enabled;
296: end if;
297: --
298: -- Set all output arguments
299: --
302: hr_utility.set_location(' Leaving:'||l_proc, 70);
303: --
304: exception
305: --
306: when hr_api.validate_enabled then
307: --
308: -- As the Validate_Enabled exception has been raised
309: -- we must rollback to the savepoint
310: --
368: ,p_effective_date => trunc(p_effective_date)
369:
370: );
371: exception
372: when hr_api.cannot_find_prog_unit then
373: hr_api.cannot_find_prog_unit_error
374: (p_module_name => 'DELETE_ROUTING_CATEGORY'
375: ,p_hook_type => 'BP'
376: );
369:
370: );
371: exception
372: when hr_api.cannot_find_prog_unit then
373: hr_api.cannot_find_prog_unit_error
374: (p_module_name => 'DELETE_ROUTING_CATEGORY'
375: ,p_hook_type => 'BP'
376: );
377: --
398: ,p_effective_date => trunc(p_effective_date)
399:
400: );
401: exception
402: when hr_api.cannot_find_prog_unit then
403: hr_api.cannot_find_prog_unit_error
404: (p_module_name => 'DELETE_ROUTING_CATEGORY'
405: ,p_hook_type => 'AP'
406: );
399:
400: );
401: exception
402: when hr_api.cannot_find_prog_unit then
403: hr_api.cannot_find_prog_unit_error
404: (p_module_name => 'DELETE_ROUTING_CATEGORY'
405: ,p_hook_type => 'AP'
406: );
407: --
413: --
414: -- When in validation only mode raise the Validate_Enabled exception
415: --
416: if p_validate then
417: raise hr_api.validate_enabled;
418: end if;
419: --
420: hr_utility.set_location(' Leaving:'||l_proc, 70);
421: --
420: hr_utility.set_location(' Leaving:'||l_proc, 70);
421: --
422: exception
423: --
424: when hr_api.validate_enabled then
425: --
426: -- As the Validate_Enabled exception has been raised
427: -- we must rollback to the savepoint
428: --