53: ,p_ext_crit_bg_id => p_ext_crit_bg_id
54: ,p_legislation_code => p_legislation_code
55: );
56: exception
57: when hr_api.cannot_find_prog_unit then
58: hr_api.cannot_find_prog_unit_error
59: (
60: p_module_name => 'CREATE_EXT_CRIT_VAL'
61: ,p_hook_type => 'BP'
54: ,p_legislation_code => p_legislation_code
55: );
56: exception
57: when hr_api.cannot_find_prog_unit then
58: hr_api.cannot_find_prog_unit_error
59: (
60: p_module_name => 'CREATE_EXT_CRIT_VAL'
61: ,p_hook_type => 'BP'
62: );
93: ,p_legislation_code => p_legislation_code
94: ,p_object_version_number => l_object_version_number
95: );
96: exception
97: when hr_api.cannot_find_prog_unit then
98: hr_api.cannot_find_prog_unit_error
99: (p_module_name => 'CREATE_EXT_CRIT_VAL'
100: ,p_hook_type => 'AP'
101: );
94: ,p_object_version_number => l_object_version_number
95: );
96: exception
97: when hr_api.cannot_find_prog_unit then
98: hr_api.cannot_find_prog_unit_error
99: (p_module_name => 'CREATE_EXT_CRIT_VAL'
100: ,p_hook_type => 'AP'
101: );
102: --
108: --
109: -- When in validation only mode raise the Validate_Enabled exception
110: --
111: if p_validate then
112: raise hr_api.validate_enabled;
113: end if;
114: --
115: -- Set all output arguments
116: --
120: hr_utility.set_location(' Leaving:'||l_proc, 70);
121: --
122: exception
123: --
124: when hr_api.validate_enabled then
125: --
126: -- As the Validate_Enabled exception has been raised
127: -- we must rollback to the savepoint
128: --
157: --
158: procedure update_EXT_CRIT_VAL
159: (p_validate in boolean default false
160: ,p_ext_crit_val_id in number
161: ,p_val_1 in varchar2 default hr_api.g_varchar2
162: ,p_val_2 in varchar2 default hr_api.g_varchar2
163: ,p_ext_crit_typ_id in number default hr_api.g_number
164: ,p_business_group_id in number default hr_api.g_number
165: ,p_ext_crit_bg_id in number default hr_api.g_number
158: procedure update_EXT_CRIT_VAL
159: (p_validate in boolean default false
160: ,p_ext_crit_val_id in number
161: ,p_val_1 in varchar2 default hr_api.g_varchar2
162: ,p_val_2 in varchar2 default hr_api.g_varchar2
163: ,p_ext_crit_typ_id in number default hr_api.g_number
164: ,p_business_group_id in number default hr_api.g_number
165: ,p_ext_crit_bg_id in number default hr_api.g_number
166: ,p_legislation_code in varchar2 default hr_api.g_varchar2
159: (p_validate in boolean default false
160: ,p_ext_crit_val_id in number
161: ,p_val_1 in varchar2 default hr_api.g_varchar2
162: ,p_val_2 in varchar2 default hr_api.g_varchar2
163: ,p_ext_crit_typ_id in number default hr_api.g_number
164: ,p_business_group_id in number default hr_api.g_number
165: ,p_ext_crit_bg_id in number default hr_api.g_number
166: ,p_legislation_code in varchar2 default hr_api.g_varchar2
167: ,p_effective_date in date
160: ,p_ext_crit_val_id in number
161: ,p_val_1 in varchar2 default hr_api.g_varchar2
162: ,p_val_2 in varchar2 default hr_api.g_varchar2
163: ,p_ext_crit_typ_id in number default hr_api.g_number
164: ,p_business_group_id in number default hr_api.g_number
165: ,p_ext_crit_bg_id in number default hr_api.g_number
166: ,p_legislation_code in varchar2 default hr_api.g_varchar2
167: ,p_effective_date in date
168: ,p_object_version_number in out nocopy number
161: ,p_val_1 in varchar2 default hr_api.g_varchar2
162: ,p_val_2 in varchar2 default hr_api.g_varchar2
163: ,p_ext_crit_typ_id in number default hr_api.g_number
164: ,p_business_group_id in number default hr_api.g_number
165: ,p_ext_crit_bg_id in number default hr_api.g_number
166: ,p_legislation_code in varchar2 default hr_api.g_varchar2
167: ,p_effective_date in date
168: ,p_object_version_number in out nocopy number
169: ) is
162: ,p_val_2 in varchar2 default hr_api.g_varchar2
163: ,p_ext_crit_typ_id in number default hr_api.g_number
164: ,p_business_group_id in number default hr_api.g_number
165: ,p_ext_crit_bg_id in number default hr_api.g_number
166: ,p_legislation_code in varchar2 default hr_api.g_varchar2
167: ,p_effective_date in date
168: ,p_object_version_number in out nocopy number
169: ) is
170: --
202: ,p_legislation_code => p_legislation_code
203: ,p_object_version_number => p_object_version_number
204: );
205: exception
206: when hr_api.cannot_find_prog_unit then
207: hr_api.cannot_find_prog_unit_error
208: (p_module_name => 'UPDATE_EXT_CRIT_VAL'
209: ,p_hook_type => 'BP'
210: );
203: ,p_object_version_number => p_object_version_number
204: );
205: exception
206: when hr_api.cannot_find_prog_unit then
207: hr_api.cannot_find_prog_unit_error
208: (p_module_name => 'UPDATE_EXT_CRIT_VAL'
209: ,p_hook_type => 'BP'
210: );
211: --
241: ,p_legislation_code => p_legislation_code
242: ,p_object_version_number => l_object_version_number
243: );
244: exception
245: when hr_api.cannot_find_prog_unit then
246: hr_api.cannot_find_prog_unit_error
247: (p_module_name => 'UPDATE_EXT_CRIT_VAL'
248: ,p_hook_type => 'AP'
249: );
242: ,p_object_version_number => l_object_version_number
243: );
244: exception
245: when hr_api.cannot_find_prog_unit then
246: hr_api.cannot_find_prog_unit_error
247: (p_module_name => 'UPDATE_EXT_CRIT_VAL'
248: ,p_hook_type => 'AP'
249: );
250: --
256: --
257: -- When in validation only mode raise the Validate_Enabled exception
258: --
259: if p_validate then
260: raise hr_api.validate_enabled;
261: end if;
262: --
263: -- Set all output arguments
264: --
267: hr_utility.set_location(' Leaving:'||l_proc, 70);
268: --
269: exception
270: --
271: when hr_api.validate_enabled then
272: --
273: -- As the Validate_Enabled exception has been raised
274: -- we must rollback to the savepoint
275: --
336: ,p_legislation_code => p_legislation_code
337: ,p_object_version_number => p_object_version_number
338: );
339: exception
340: when hr_api.cannot_find_prog_unit then
341: hr_api.cannot_find_prog_unit_error
342: (p_module_name => 'DELETE_EXT_CRIT_VAL'
343: ,p_hook_type => 'BP'
344: );
337: ,p_object_version_number => p_object_version_number
338: );
339: exception
340: when hr_api.cannot_find_prog_unit then
341: hr_api.cannot_find_prog_unit_error
342: (p_module_name => 'DELETE_EXT_CRIT_VAL'
343: ,p_hook_type => 'BP'
344: );
345: --
364: ,p_legislation_code => p_legislation_code
365: ,p_object_version_number => l_object_version_number
366: );
367: exception
368: when hr_api.cannot_find_prog_unit then
369: hr_api.cannot_find_prog_unit_error
370: (p_module_name => 'DELETE_EXT_CRIT_VAL'
371: ,p_hook_type => 'AP'
372: );
365: ,p_object_version_number => l_object_version_number
366: );
367: exception
368: when hr_api.cannot_find_prog_unit then
369: hr_api.cannot_find_prog_unit_error
370: (p_module_name => 'DELETE_EXT_CRIT_VAL'
371: ,p_hook_type => 'AP'
372: );
373: --
379: --
380: -- When in validation only mode raise the Validate_Enabled exception
381: --
382: if p_validate then
383: raise hr_api.validate_enabled;
384: end if;
385: --
386: hr_utility.set_location(' Leaving:'||l_proc, 70);
387: --
386: hr_utility.set_location(' Leaving:'||l_proc, 70);
387: --
388: exception
389: --
390: when hr_api.validate_enabled then
391: --
392: -- As the Validate_Enabled exception has been raised
393: -- we must rollback to the savepoint
394: --