56: ,p_legislation_code => p_legislation_code
57: ,p_effective_date => trunc(p_effective_date)
58: );
59: exception
60: when hr_api.cannot_find_prog_unit then
61: hr_api.cannot_find_prog_unit_error
62: (
63: p_module_name => 'CREATE_EXT_CRIT_CMBN'
64: ,p_hook_type => 'BP'
57: ,p_effective_date => trunc(p_effective_date)
58: );
59: exception
60: when hr_api.cannot_find_prog_unit then
61: hr_api.cannot_find_prog_unit_error
62: (
63: p_module_name => 'CREATE_EXT_CRIT_CMBN'
64: ,p_hook_type => 'BP'
65: );
99: ,p_object_version_number => l_object_version_number
100: ,p_effective_date => trunc(p_effective_date)
101: );
102: exception
103: when hr_api.cannot_find_prog_unit then
104: hr_api.cannot_find_prog_unit_error
105: (p_module_name => 'CREATE_EXT_CRIT_CMBN'
106: ,p_hook_type => 'AP'
107: );
100: ,p_effective_date => trunc(p_effective_date)
101: );
102: exception
103: when hr_api.cannot_find_prog_unit then
104: hr_api.cannot_find_prog_unit_error
105: (p_module_name => 'CREATE_EXT_CRIT_CMBN'
106: ,p_hook_type => 'AP'
107: );
108: --
114: --
115: -- When in validation only mode raise the Validate_Enabled exception
116: --
117: if p_validate then
118: raise hr_api.validate_enabled;
119: end if;
120: --
121: -- Set all output arguments
122: --
126: hr_utility.set_location(' Leaving:'||l_proc, 70);
127: --
128: exception
129: --
130: when hr_api.validate_enabled then
131: --
132: -- As the Validate_Enabled exception has been raised
133: -- we must rollback to the savepoint
134: --
159: --
160: procedure update_EXT_CRIT_CMBN
161: (p_validate in boolean default false
162: ,p_ext_crit_cmbn_id in number
163: ,p_crit_typ_cd in varchar2 default hr_api.g_varchar2
164: ,p_oper_cd in varchar2 default hr_api.g_varchar2
165: ,p_val_1 in varchar2 default hr_api.g_varchar2
166: ,p_val_2 in varchar2 default hr_api.g_varchar2
167: ,p_ext_crit_val_id in number default hr_api.g_number
160: procedure update_EXT_CRIT_CMBN
161: (p_validate in boolean default false
162: ,p_ext_crit_cmbn_id in number
163: ,p_crit_typ_cd in varchar2 default hr_api.g_varchar2
164: ,p_oper_cd in varchar2 default hr_api.g_varchar2
165: ,p_val_1 in varchar2 default hr_api.g_varchar2
166: ,p_val_2 in varchar2 default hr_api.g_varchar2
167: ,p_ext_crit_val_id in number default hr_api.g_number
168: ,p_business_group_id in number default hr_api.g_number
161: (p_validate in boolean default false
162: ,p_ext_crit_cmbn_id in number
163: ,p_crit_typ_cd in varchar2 default hr_api.g_varchar2
164: ,p_oper_cd in varchar2 default hr_api.g_varchar2
165: ,p_val_1 in varchar2 default hr_api.g_varchar2
166: ,p_val_2 in varchar2 default hr_api.g_varchar2
167: ,p_ext_crit_val_id in number default hr_api.g_number
168: ,p_business_group_id in number default hr_api.g_number
169: ,p_legislation_code in varchar2 default hr_api.g_varchar2
162: ,p_ext_crit_cmbn_id in number
163: ,p_crit_typ_cd in varchar2 default hr_api.g_varchar2
164: ,p_oper_cd in varchar2 default hr_api.g_varchar2
165: ,p_val_1 in varchar2 default hr_api.g_varchar2
166: ,p_val_2 in varchar2 default hr_api.g_varchar2
167: ,p_ext_crit_val_id in number default hr_api.g_number
168: ,p_business_group_id in number default hr_api.g_number
169: ,p_legislation_code in varchar2 default hr_api.g_varchar2
170: ,p_object_version_number in out nocopy number
163: ,p_crit_typ_cd in varchar2 default hr_api.g_varchar2
164: ,p_oper_cd in varchar2 default hr_api.g_varchar2
165: ,p_val_1 in varchar2 default hr_api.g_varchar2
166: ,p_val_2 in varchar2 default hr_api.g_varchar2
167: ,p_ext_crit_val_id in number default hr_api.g_number
168: ,p_business_group_id in number default hr_api.g_number
169: ,p_legislation_code in varchar2 default hr_api.g_varchar2
170: ,p_object_version_number in out nocopy number
171: ,p_effective_date in date
164: ,p_oper_cd in varchar2 default hr_api.g_varchar2
165: ,p_val_1 in varchar2 default hr_api.g_varchar2
166: ,p_val_2 in varchar2 default hr_api.g_varchar2
167: ,p_ext_crit_val_id in number default hr_api.g_number
168: ,p_business_group_id in number default hr_api.g_number
169: ,p_legislation_code in varchar2 default hr_api.g_varchar2
170: ,p_object_version_number in out nocopy number
171: ,p_effective_date in date
172: ) is
165: ,p_val_1 in varchar2 default hr_api.g_varchar2
166: ,p_val_2 in varchar2 default hr_api.g_varchar2
167: ,p_ext_crit_val_id in number default hr_api.g_number
168: ,p_business_group_id in number default hr_api.g_number
169: ,p_legislation_code in varchar2 default hr_api.g_varchar2
170: ,p_object_version_number in out nocopy number
171: ,p_effective_date in date
172: ) is
173: --
207: ,p_object_version_number => p_object_version_number
208: ,p_effective_date => trunc(p_effective_date)
209: );
210: exception
211: when hr_api.cannot_find_prog_unit then
212: hr_api.cannot_find_prog_unit_error
213: (p_module_name => 'UPDATE_EXT_CRIT_CMBN'
214: ,p_hook_type => 'BP'
215: );
208: ,p_effective_date => trunc(p_effective_date)
209: );
210: exception
211: when hr_api.cannot_find_prog_unit then
212: hr_api.cannot_find_prog_unit_error
213: (p_module_name => 'UPDATE_EXT_CRIT_CMBN'
214: ,p_hook_type => 'BP'
215: );
216: --
249: ,p_object_version_number => l_object_version_number
250: ,p_effective_date => trunc(p_effective_date)
251: );
252: exception
253: when hr_api.cannot_find_prog_unit then
254: hr_api.cannot_find_prog_unit_error
255: (p_module_name => 'UPDATE_EXT_CRIT_CMBN'
256: ,p_hook_type => 'AP'
257: );
250: ,p_effective_date => trunc(p_effective_date)
251: );
252: exception
253: when hr_api.cannot_find_prog_unit then
254: hr_api.cannot_find_prog_unit_error
255: (p_module_name => 'UPDATE_EXT_CRIT_CMBN'
256: ,p_hook_type => 'AP'
257: );
258: --
264: --
265: -- When in validation only mode raise the Validate_Enabled exception
266: --
267: if p_validate then
268: raise hr_api.validate_enabled;
269: end if;
270: --
271: -- Set all output arguments
272: --
275: hr_utility.set_location(' Leaving:'||l_proc, 70);
276: --
277: exception
278: --
279: when hr_api.validate_enabled then
280: --
281: -- As the Validate_Enabled exception has been raised
282: -- we must rollback to the savepoint
283: --
342: ,p_object_version_number => p_object_version_number
343: ,p_effective_date => trunc(p_effective_date)
344: );
345: exception
346: when hr_api.cannot_find_prog_unit then
347: hr_api.cannot_find_prog_unit_error
348: (p_module_name => 'DELETE_EXT_CRIT_CMBN'
349: ,p_hook_type => 'BP'
350: );
343: ,p_effective_date => trunc(p_effective_date)
344: );
345: exception
346: when hr_api.cannot_find_prog_unit then
347: hr_api.cannot_find_prog_unit_error
348: (p_module_name => 'DELETE_EXT_CRIT_CMBN'
349: ,p_hook_type => 'BP'
350: );
351: --
372: ,p_object_version_number => l_object_version_number
373: ,p_effective_date => trunc(p_effective_date)
374: );
375: exception
376: when hr_api.cannot_find_prog_unit then
377: hr_api.cannot_find_prog_unit_error
378: (p_module_name => 'DELETE_EXT_CRIT_CMBN'
379: ,p_hook_type => 'AP'
380: );
373: ,p_effective_date => trunc(p_effective_date)
374: );
375: exception
376: when hr_api.cannot_find_prog_unit then
377: hr_api.cannot_find_prog_unit_error
378: (p_module_name => 'DELETE_EXT_CRIT_CMBN'
379: ,p_hook_type => 'AP'
380: );
381: --
387: --
388: -- When in validation only mode raise the Validate_Enabled exception
389: --
390: if p_validate then
391: raise hr_api.validate_enabled;
392: end if;
393: --
394: hr_utility.set_location(' Leaving:'||l_proc, 70);
395: --
394: hr_utility.set_location(' Leaving:'||l_proc, 70);
395: --
396: exception
397: --
398: when hr_api.validate_enabled then
399: --
400: -- As the Validate_Enabled exception has been raised
401: -- we must rollback to the savepoint
402: --