44: p_routing_list_name => p_routing_list_name ,
45: p_enable_flag => p_enable_flag
46: );
47: exception
48: when hr_api.cannot_find_prog_unit then
49: hr_api.cannot_find_prog_unit_error
50: (
51: p_module_name => 'CREATE_ROUTING_LIST'
52: ,p_hook_type => 'BP'
45: p_enable_flag => p_enable_flag
46: );
47: exception
48: when hr_api.cannot_find_prog_unit then
49: hr_api.cannot_find_prog_unit_error
50: (
51: p_module_name => 'CREATE_ROUTING_LIST'
52: ,p_hook_type => 'BP'
53: );
75: ,p_enable_flag => p_enable_flag
76: ,p_object_version_number => l_object_version_number
77: );
78: exception
79: when hr_api.cannot_find_prog_unit then
80: hr_api.cannot_find_prog_unit_error
81: (p_module_name => 'CREATE_ROUTING_LIST'
82: ,p_hook_type => 'AP'
83: );
76: ,p_object_version_number => l_object_version_number
77: );
78: exception
79: when hr_api.cannot_find_prog_unit then
80: hr_api.cannot_find_prog_unit_error
81: (p_module_name => 'CREATE_ROUTING_LIST'
82: ,p_hook_type => 'AP'
83: );
84: --
90: --
91: -- When in validation only mode raise the Validate_Enabled exception
92: --
93: if p_validate then
94: raise hr_api.validate_enabled;
95: end if;
96: --
97: -- Set all output arguments
98: --
102: hr_utility.set_location(' Leaving:'||l_proc, 70);
103: --
104: exception
105: --
106: when hr_api.validate_enabled then
107: --
108: -- As the Validate_Enabled exception has been raised
109: -- we must rollback to the savepoint
110: --
134: --
135: procedure update_routing_list
136: (p_validate in boolean default false
137: ,p_routing_list_id in number
138: ,p_routing_list_name in varchar2 default hr_api.g_varchar2
139: ,p_enable_flag in varchar2 default hr_api.g_varchar2
140: ,p_object_version_number in out nocopy number
141: ) is
142: --
135: procedure update_routing_list
136: (p_validate in boolean default false
137: ,p_routing_list_id in number
138: ,p_routing_list_name in varchar2 default hr_api.g_varchar2
139: ,p_enable_flag in varchar2 default hr_api.g_varchar2
140: ,p_object_version_number in out nocopy number
141: ) is
142: --
143: -- Declare cursors and local variables
170: ,p_enable_flag => p_enable_flag
171: ,p_object_version_number => p_object_version_number
172: );
173: exception
174: when hr_api.cannot_find_prog_unit then
175: hr_api.cannot_find_prog_unit_error
176: (p_module_name => 'UPDATE_ROUTING_LIST'
177: ,p_hook_type => 'BP'
178: );
171: ,p_object_version_number => p_object_version_number
172: );
173: exception
174: when hr_api.cannot_find_prog_unit then
175: hr_api.cannot_find_prog_unit_error
176: (p_module_name => 'UPDATE_ROUTING_LIST'
177: ,p_hook_type => 'BP'
178: );
179: --
200: ,p_enable_flag => p_enable_flag
201: ,p_object_version_number => l_object_version_number
202: );
203: exception
204: when hr_api.cannot_find_prog_unit then
205: hr_api.cannot_find_prog_unit_error
206: (p_module_name => 'UPDATE_ROUTING_LIST'
207: ,p_hook_type => 'AP'
208: );
201: ,p_object_version_number => l_object_version_number
202: );
203: exception
204: when hr_api.cannot_find_prog_unit then
205: hr_api.cannot_find_prog_unit_error
206: (p_module_name => 'UPDATE_ROUTING_LIST'
207: ,p_hook_type => 'AP'
208: );
209: --
215: --
216: -- When in validation only mode raise the Validate_Enabled exception
217: --
218: if p_validate then
219: raise hr_api.validate_enabled;
220: end if;
221: --
222: -- Set all output arguments
223: --
226: hr_utility.set_location(' Leaving:'||l_proc, 70);
227: --
228: exception
229: --
230: when hr_api.validate_enabled then
231: --
232: -- As the Validate_Enabled exception has been raised
233: -- we must rollback to the savepoint
234: --
293: p_routing_list_id => p_routing_list_id
294: ,p_object_version_number => p_object_version_number
295: );
296: exception
297: when hr_api.cannot_find_prog_unit then
298: hr_api.cannot_find_prog_unit_error
299: (p_module_name => 'DELETE_ROUTING_LIST'
300: ,p_hook_type => 'BP'
301: );
294: ,p_object_version_number => p_object_version_number
295: );
296: exception
297: when hr_api.cannot_find_prog_unit then
298: hr_api.cannot_find_prog_unit_error
299: (p_module_name => 'DELETE_ROUTING_LIST'
300: ,p_hook_type => 'BP'
301: );
302: --
329: p_routing_list_id => p_routing_list_id
330: ,p_object_version_number => l_object_version_number
331: );
332: exception
333: when hr_api.cannot_find_prog_unit then
334: hr_api.cannot_find_prog_unit_error
335: (p_module_name => 'DELETE_ROUTING_LIST'
336: ,p_hook_type => 'AP'
337: );
330: ,p_object_version_number => l_object_version_number
331: );
332: exception
333: when hr_api.cannot_find_prog_unit then
334: hr_api.cannot_find_prog_unit_error
335: (p_module_name => 'DELETE_ROUTING_LIST'
336: ,p_hook_type => 'AP'
337: );
338: --
344: --
345: -- When in validation only mode raise the Validate_Enabled exception
346: --
347: if p_validate then
348: raise hr_api.validate_enabled;
349: end if;
350: --
351: hr_utility.set_location(' Leaving:'||l_proc, 70);
352: --
351: hr_utility.set_location(' Leaving:'||l_proc, 70);
352: --
353: exception
354: --
355: when hr_api.validate_enabled then
356: --
357: -- As the Validate_Enabled exception has been raised
358: -- we must rollback to the savepoint
359: --