45: ,P_DESCRIPTION => P_DESCRIPTION);
46:
47:
48: exception
49: when hr_api.cannot_find_prog_unit then
50: hr_api.cannot_find_prog_unit_error
51: (p_module_name => 'CREATE_LEVEL_NUMBERS'
52: ,p_hook_type => 'BP'
53: );
46:
47:
48: exception
49: when hr_api.cannot_find_prog_unit then
50: hr_api.cannot_find_prog_unit_error
51: (p_module_name => 'CREATE_LEVEL_NUMBERS'
52: ,p_hook_type => 'BP'
53: );
54: end;
78: ,P_LEVEL_NUMBER_ID => l_LEVEL_NUMBER_ID
79: ,p_object_version_number => l_object_version_number);
80:
81: exception
82: when hr_api.cannot_find_prog_unit then
83: hr_api.cannot_find_prog_unit_error
84: (p_module_name => 'CREATE_LEVEL_NUMBERS'
85: ,p_hook_type => 'AP'
86: );
79: ,p_object_version_number => l_object_version_number);
80:
81: exception
82: when hr_api.cannot_find_prog_unit then
83: hr_api.cannot_find_prog_unit_error
84: (p_module_name => 'CREATE_LEVEL_NUMBERS'
85: ,p_hook_type => 'AP'
86: );
87: end;
88: --
89: -- When in validation only mode raise the Validate_Enabled exception
90: --
91: if p_validate then
92: raise hr_api.validate_enabled;
93: end if;
94: --
95: -- Set all output arguments
96: --
99:
100: --
101: hr_utility.set_location(' Leaving:'||l_proc, 70);
102: exception
103: when hr_api.validate_enabled then
104: --
105: -- As the Validate_Enabled exception has been raised
106: -- we must rollback to the savepoint
107: --
133:
134: procedure Update_LEVEL_NUMBERS
135: (p_validate in boolean default false
136: ,p_effective_date in date
137: ,p_LEVEL_NUMBER In Varchar2 Default hr_api.g_Varchar2
138: ,P_DESCRIPTION In Varchar2 Default hr_api.g_Varchar2
139: ,P_LEVEL_NUMBER_ID In Number
140: ,p_object_version_number IN out nocopy number) Is
141:
134: procedure Update_LEVEL_NUMBERS
135: (p_validate in boolean default false
136: ,p_effective_date in date
137: ,p_LEVEL_NUMBER In Varchar2 Default hr_api.g_Varchar2
138: ,P_DESCRIPTION In Varchar2 Default hr_api.g_Varchar2
139: ,P_LEVEL_NUMBER_ID In Number
140: ,p_object_version_number IN out nocopy number) Is
141:
142: l_proc varchar2(72) := g_package||'Update_LEVEL_NUMBERS';
167: ,p_object_version_number => l_object_version_number);
168:
169:
170: exception
171: when hr_api.cannot_find_prog_unit then
172: hr_api.cannot_find_prog_unit_error
173: (p_module_name => 'UPDATE_LEVEL_NUMBERS'
174: ,p_hook_type => 'BP'
175: );
168:
169:
170: exception
171: when hr_api.cannot_find_prog_unit then
172: hr_api.cannot_find_prog_unit_error
173: (p_module_name => 'UPDATE_LEVEL_NUMBERS'
174: ,p_hook_type => 'BP'
175: );
176: end;
196: ,P_LEVEL_NUMBER_ID => p_LEVEL_NUMBER_ID
197: ,p_object_version_number => l_object_version_number);
198:
199: exception
200: when hr_api.cannot_find_prog_unit then
201: hr_api.cannot_find_prog_unit_error
202: (p_module_name => 'UPDATE_LEVEL_NUMBERS'
203: ,p_hook_type => 'AP'
204: );
197: ,p_object_version_number => l_object_version_number);
198:
199: exception
200: when hr_api.cannot_find_prog_unit then
201: hr_api.cannot_find_prog_unit_error
202: (p_module_name => 'UPDATE_LEVEL_NUMBERS'
203: ,p_hook_type => 'AP'
204: );
205: end;
206: --
207: -- When in validation only mode raise the Validate_Enabled exception
208: --
209: if p_validate then
210: raise hr_api.validate_enabled;
211: end if;
212: --
213: -- Set all output arguments
214: --
217:
218: --
219: hr_utility.set_location(' Leaving:'||l_proc, 70);
220: exception
221: when hr_api.validate_enabled then
222: --
223: -- As the Validate_Enabled exception has been raised
224: -- we must rollback to the savepoint
225: --
272: PQH_DE_LEVEL_NUMBERS_BK3.Delete_LEVEL_NUMBERS_b
273: (p_LEVEL_NUMBER_Id => p_LEVEL_NUMBER_Id
274: ,p_object_version_number => p_object_version_number);
275: exception
276: when hr_api.cannot_find_prog_unit then
277: hr_api.cannot_find_prog_unit_error
278: (p_module_name => 'delete_LEVEL_NUMBERS'
279: ,p_hook_type => 'BP');
280: end;
273: (p_LEVEL_NUMBER_Id => p_LEVEL_NUMBER_Id
274: ,p_object_version_number => p_object_version_number);
275: exception
276: when hr_api.cannot_find_prog_unit then
277: hr_api.cannot_find_prog_unit_error
278: (p_module_name => 'delete_LEVEL_NUMBERS'
279: ,p_hook_type => 'BP');
280: end;
281: --
294: (p_LEVEL_NUMBER_Id => p_LEVEL_NUMBER_Id
295: ,p_object_version_number => p_object_version_number);
296:
297: exception
298: when hr_api.cannot_find_prog_unit then
299: hr_api.cannot_find_prog_unit_error
300: (p_module_name => 'DELETE_LEVEL_NUMBERS'
301: ,p_hook_type => 'AP');
302: end;
295: ,p_object_version_number => p_object_version_number);
296:
297: exception
298: when hr_api.cannot_find_prog_unit then
299: hr_api.cannot_find_prog_unit_error
300: (p_module_name => 'DELETE_LEVEL_NUMBERS'
301: ,p_hook_type => 'AP');
302: end;
303: --
303: --
304: -- When in validation only mode raise the Validate_Enabled exception
305: --
306: if p_validate then
307: raise hr_api.validate_enabled;
308: end if;
309: --
310: -- Set all output arguments
311: --
310: -- Set all output arguments
311: --
312: hr_utility.set_location(' Leaving:'||l_proc, 70);
313: exception
314: when hr_api.validate_enabled then
315: --
316: -- As the Validate_Enabled exception has been raised
317: -- we must rollback to the savepoint
318: --