52: ,p_effective_date => trunc(p_effective_date)
53: ,p_excld_flag => p_excld_flag
54: );
55: exception
56: when hr_api.cannot_find_prog_unit then
57: hr_api.cannot_find_prog_unit_error
58: (
59: p_module_name => 'CREATE_EXT_CRIT_TYP'
60: ,p_hook_type => 'BP'
53: ,p_excld_flag => p_excld_flag
54: );
55: exception
56: when hr_api.cannot_find_prog_unit then
57: hr_api.cannot_find_prog_unit_error
58: (
59: p_module_name => 'CREATE_EXT_CRIT_TYP'
60: ,p_hook_type => 'BP'
61: );
91: ,p_effective_date => trunc(p_effective_date)
92: ,p_excld_flag => p_excld_flag
93: );
94: exception
95: when hr_api.cannot_find_prog_unit then
96: hr_api.cannot_find_prog_unit_error
97: (p_module_name => 'CREATE_EXT_CRIT_TYP'
98: ,p_hook_type => 'AP'
99: );
92: ,p_excld_flag => p_excld_flag
93: );
94: exception
95: when hr_api.cannot_find_prog_unit then
96: hr_api.cannot_find_prog_unit_error
97: (p_module_name => 'CREATE_EXT_CRIT_TYP'
98: ,p_hook_type => 'AP'
99: );
100: --
106: --
107: -- When in validation only mode raise the Validate_Enabled exception
108: --
109: if p_validate then
110: raise hr_api.validate_enabled;
111: end if;
112: --
113: -- Set all output arguments
114: --
118: hr_utility.set_location(' Leaving:'||l_proc, 70);
119: --
120: exception
121: --
122: when hr_api.validate_enabled then
123: --
124: -- As the Validate_Enabled exception has been raised
125: -- we must rollback to the savepoint
126: --
151: --
152: procedure update_EXT_CRIT_TYP
153: (p_validate in boolean default false
154: ,p_ext_crit_typ_id in number
155: ,p_crit_typ_cd in varchar2 default hr_api.g_varchar2
156: ,p_ext_crit_prfl_id in number default hr_api.g_number
157: ,p_business_group_id in number default hr_api.g_number
158: ,p_legislation_code in varchar2 default hr_api.g_varchar2
159: ,p_object_version_number in out nocopy number
152: procedure update_EXT_CRIT_TYP
153: (p_validate in boolean default false
154: ,p_ext_crit_typ_id in number
155: ,p_crit_typ_cd in varchar2 default hr_api.g_varchar2
156: ,p_ext_crit_prfl_id in number default hr_api.g_number
157: ,p_business_group_id in number default hr_api.g_number
158: ,p_legislation_code in varchar2 default hr_api.g_varchar2
159: ,p_object_version_number in out nocopy number
160: ,p_effective_date in date
153: (p_validate in boolean default false
154: ,p_ext_crit_typ_id in number
155: ,p_crit_typ_cd in varchar2 default hr_api.g_varchar2
156: ,p_ext_crit_prfl_id in number default hr_api.g_number
157: ,p_business_group_id in number default hr_api.g_number
158: ,p_legislation_code in varchar2 default hr_api.g_varchar2
159: ,p_object_version_number in out nocopy number
160: ,p_effective_date in date
161: ,p_excld_flag in varchar2 default hr_api.g_varchar2
154: ,p_ext_crit_typ_id in number
155: ,p_crit_typ_cd in varchar2 default hr_api.g_varchar2
156: ,p_ext_crit_prfl_id in number default hr_api.g_number
157: ,p_business_group_id in number default hr_api.g_number
158: ,p_legislation_code in varchar2 default hr_api.g_varchar2
159: ,p_object_version_number in out nocopy number
160: ,p_effective_date in date
161: ,p_excld_flag in varchar2 default hr_api.g_varchar2
162: ) is
157: ,p_business_group_id in number default hr_api.g_number
158: ,p_legislation_code in varchar2 default hr_api.g_varchar2
159: ,p_object_version_number in out nocopy number
160: ,p_effective_date in date
161: ,p_excld_flag in varchar2 default hr_api.g_varchar2
162: ) is
163: --
164: -- Declare cursors and local variables
165: --
195: ,p_effective_date => trunc(p_effective_date)
196: ,p_excld_flag => p_excld_flag
197: );
198: exception
199: when hr_api.cannot_find_prog_unit then
200: hr_api.cannot_find_prog_unit_error
201: (p_module_name => 'UPDATE_EXT_CRIT_TYP'
202: ,p_hook_type => 'BP'
203: );
196: ,p_excld_flag => p_excld_flag
197: );
198: exception
199: when hr_api.cannot_find_prog_unit then
200: hr_api.cannot_find_prog_unit_error
201: (p_module_name => 'UPDATE_EXT_CRIT_TYP'
202: ,p_hook_type => 'BP'
203: );
204: --
233: ,p_effective_date => trunc(p_effective_date)
234: ,p_excld_flag => p_excld_flag
235: );
236: exception
237: when hr_api.cannot_find_prog_unit then
238: hr_api.cannot_find_prog_unit_error
239: (p_module_name => 'UPDATE_EXT_CRIT_TYP'
240: ,p_hook_type => 'AP'
241: );
234: ,p_excld_flag => p_excld_flag
235: );
236: exception
237: when hr_api.cannot_find_prog_unit then
238: hr_api.cannot_find_prog_unit_error
239: (p_module_name => 'UPDATE_EXT_CRIT_TYP'
240: ,p_hook_type => 'AP'
241: );
242: --
248: --
249: -- When in validation only mode raise the Validate_Enabled exception
250: --
251: if p_validate then
252: raise hr_api.validate_enabled;
253: end if;
254: --
255: -- Set all output arguments
256: --
259: hr_utility.set_location(' Leaving:'||l_proc, 70);
260: --
261: exception
262: --
263: when hr_api.validate_enabled then
264: --
265: -- As the Validate_Enabled exception has been raised
266: -- we must rollback to the savepoint
267: --
326: ,p_object_version_number => p_object_version_number
327: ,p_effective_date => trunc(p_effective_date)
328: );
329: exception
330: when hr_api.cannot_find_prog_unit then
331: hr_api.cannot_find_prog_unit_error
332: (p_module_name => 'DELETE_EXT_CRIT_TYP'
333: ,p_hook_type => 'BP'
334: );
327: ,p_effective_date => trunc(p_effective_date)
328: );
329: exception
330: when hr_api.cannot_find_prog_unit then
331: hr_api.cannot_find_prog_unit_error
332: (p_module_name => 'DELETE_EXT_CRIT_TYP'
333: ,p_hook_type => 'BP'
334: );
335: --
356: ,p_object_version_number => l_object_version_number
357: ,p_effective_date => trunc(p_effective_date)
358: );
359: exception
360: when hr_api.cannot_find_prog_unit then
361: hr_api.cannot_find_prog_unit_error
362: (p_module_name => 'DELETE_EXT_CRIT_TYP'
363: ,p_hook_type => 'AP'
364: );
357: ,p_effective_date => trunc(p_effective_date)
358: );
359: exception
360: when hr_api.cannot_find_prog_unit then
361: hr_api.cannot_find_prog_unit_error
362: (p_module_name => 'DELETE_EXT_CRIT_TYP'
363: ,p_hook_type => 'AP'
364: );
365: --
371: --
372: -- When in validation only mode raise the Validate_Enabled exception
373: --
374: if p_validate then
375: raise hr_api.validate_enabled;
376: end if;
377: --
378: hr_utility.set_location(' Leaving:'||l_proc, 70);
379: --
378: hr_utility.set_location(' Leaving:'||l_proc, 70);
379: --
380: exception
381: --
382: when hr_api.validate_enabled then
383: --
384: -- As the Validate_Enabled exception has been raised
385: -- we must rollback to the savepoint
386: --