49: ,p_solution_category => p_solution_category
50: ,p_updateable => p_updateable
51: );
52: exception
53: when hr_api.cannot_find_prog_unit then
54: hr_api.cannot_find_prog_unit_error
55: (p_module_name => 'CREATE_SOLUTION_TYPE_b'
56: ,p_hook_type => 'BP'
57: );
50: ,p_updateable => p_updateable
51: );
52: exception
53: when hr_api.cannot_find_prog_unit then
54: hr_api.cannot_find_prog_unit_error
55: (p_module_name => 'CREATE_SOLUTION_TYPE_b'
56: ,p_hook_type => 'BP'
57: );
58: end;
76: ,p_updateable => p_updateable
77: ,p_object_version_number => p_object_version_number
78: );
79: exception
80: when hr_api.cannot_find_prog_unit then
81: hr_api.cannot_find_prog_unit_error
82: (p_module_name => 'CREATE_SOLUTION_TYPE_a'
83: ,p_hook_type => 'AP'
84: );
77: ,p_object_version_number => p_object_version_number
78: );
79: exception
80: when hr_api.cannot_find_prog_unit then
81: hr_api.cannot_find_prog_unit_error
82: (p_module_name => 'CREATE_SOLUTION_TYPE_a'
83: ,p_hook_type => 'AP'
84: );
85: end;
86: --
87: -- When in validation only mode raise the Validate_Enabled exception
88: --
89: if p_validate then
90: raise hr_api.validate_enabled;
91: end if;
92: --
93: -- Set all output arguments
94: --
95: p_object_version_number := l_object_version_number;
96: --
97: hr_utility.set_location(' Leaving:'||l_proc, 70);
98: exception
99: when hr_api.validate_enabled then
100: --
101: -- As the Validate_Enabled exception has been raised
102: -- we must rollback to the savepoint
103: --
128: procedure update_solution_type
129: (p_validate in boolean default false
130: ,p_effective_date in date
131: ,p_solution_type_name in varchar2
132: ,p_solution_category in varchar2 default hr_api.g_varchar2
133: ,p_updateable in varchar2 default hr_api.g_varchar2
134: ,p_object_version_number in out nocopy number
135: ) is
136: --
129: (p_validate in boolean default false
130: ,p_effective_date in date
131: ,p_solution_type_name in varchar2
132: ,p_solution_category in varchar2 default hr_api.g_varchar2
133: ,p_updateable in varchar2 default hr_api.g_varchar2
134: ,p_object_version_number in out nocopy number
135: ) is
136: --
137: -- Declare cursors and local variables
163: ,p_solution_category => p_solution_category
164: ,p_updateable => p_updateable
165: );
166: exception
167: when hr_api.cannot_find_prog_unit then
168: hr_api.cannot_find_prog_unit_error
169: (p_module_name => 'UPDATE_SOLUTION_TYPE_b'
170: ,p_hook_type => 'BP'
171: );
164: ,p_updateable => p_updateable
165: );
166: exception
167: when hr_api.cannot_find_prog_unit then
168: hr_api.cannot_find_prog_unit_error
169: (p_module_name => 'UPDATE_SOLUTION_TYPE_b'
170: ,p_hook_type => 'BP'
171: );
172: end;
190: ,p_solution_category => p_solution_category
191: ,p_updateable => p_updateable
192: );
193: exception
194: when hr_api.cannot_find_prog_unit then
195: hr_api.cannot_find_prog_unit_error
196: (p_module_name => 'UPDATE_SOLUTION_TYPE_a'
197: ,p_hook_type => 'AP'
198: );
191: ,p_updateable => p_updateable
192: );
193: exception
194: when hr_api.cannot_find_prog_unit then
195: hr_api.cannot_find_prog_unit_error
196: (p_module_name => 'UPDATE_SOLUTION_TYPE_a'
197: ,p_hook_type => 'AP'
198: );
199: end;
200: --
201: -- When in validation only mode raise the Validate_Enabled exception
202: --
203: if p_validate then
204: raise hr_api.validate_enabled;
205: end if;
206: --
207: --
208: -- Set all output arguments
210: p_object_version_number := l_object_version_number;
211: --
212: hr_utility.set_location(' Leaving:'||l_proc, 70);
213: exception
214: when hr_api.validate_enabled then
215: --
216: -- As the Validate_Enabled exception has been raised
217: -- we must rollback to the savepoint
218: --
259: (p_solution_type_name => p_solution_type_name
260: ,p_object_version_number => p_object_version_number
261: );
262: exception
263: when hr_api.cannot_find_prog_unit then
264: hr_api.cannot_find_prog_unit_error
265: (p_module_name => 'DELETE_SOLUTION_TYPE_b'
266: ,p_hook_type => 'BP'
267: );
260: ,p_object_version_number => p_object_version_number
261: );
262: exception
263: when hr_api.cannot_find_prog_unit then
264: hr_api.cannot_find_prog_unit_error
265: (p_module_name => 'DELETE_SOLUTION_TYPE_b'
266: ,p_hook_type => 'BP'
267: );
268: end;
277: (p_solution_type_name => p_solution_type_name
278: ,p_object_version_number => p_object_version_number
279: );
280: exception
281: when hr_api.cannot_find_prog_unit then
282: hr_api.cannot_find_prog_unit_error
283: (p_module_name => 'DELETE_SOLUTION_TYPE_a'
284: ,p_hook_type => 'AP'
285: );
278: ,p_object_version_number => p_object_version_number
279: );
280: exception
281: when hr_api.cannot_find_prog_unit then
282: hr_api.cannot_find_prog_unit_error
283: (p_module_name => 'DELETE_SOLUTION_TYPE_a'
284: ,p_hook_type => 'AP'
285: );
286: end;
287: --
288: -- When in validation only mode raise the Validate_Enabled exception
289: --
290: if p_validate then
291: raise hr_api.validate_enabled;
292: end if;
293: --
294: hr_utility.set_location(' Leaving:'||l_proc, 70);
295: exception
292: end if;
293: --
294: hr_utility.set_location(' Leaving:'||l_proc, 70);
295: exception
296: when hr_api.validate_enabled then
297: --
298: -- As the Validate_Enabled exception has been raised
299: -- we must rollback to the savepoint
300: --