54: ,p_legislation_code => p_legislation_code
55: ,p_effective_date => trunc(p_effective_date)
56: );
57: exception
58: when hr_api.cannot_find_prog_unit then
59: hr_api.cannot_find_prog_unit_error
60: (
61: p_module_name => 'CREATE_EXT_INCL_CHG'
62: ,p_hook_type => 'BP'
55: ,p_effective_date => trunc(p_effective_date)
56: );
57: exception
58: when hr_api.cannot_find_prog_unit then
59: hr_api.cannot_find_prog_unit_error
60: (
61: p_module_name => 'CREATE_EXT_INCL_CHG'
62: ,p_hook_type => 'BP'
63: );
95: ,p_object_version_number => l_object_version_number
96: ,p_effective_date => trunc(p_effective_date)
97: );
98: exception
99: when hr_api.cannot_find_prog_unit then
100: hr_api.cannot_find_prog_unit_error
101: (p_module_name => 'CREATE_EXT_INCL_CHG'
102: ,p_hook_type => 'AP'
103: );
96: ,p_effective_date => trunc(p_effective_date)
97: );
98: exception
99: when hr_api.cannot_find_prog_unit then
100: hr_api.cannot_find_prog_unit_error
101: (p_module_name => 'CREATE_EXT_INCL_CHG'
102: ,p_hook_type => 'AP'
103: );
104: --
110: --
111: -- When in validation only mode raise the Validate_Enabled exception
112: --
113: if p_validate then
114: raise hr_api.validate_enabled;
115: end if;
116: --
117: -- Set all output arguments
118: --
122: hr_utility.set_location(' Leaving:'||l_proc, 70);
123: --
124: exception
125: --
126: when hr_api.validate_enabled then
127: --
128: -- As the Validate_Enabled exception has been raised
129: -- we must rollback to the savepoint
130: --
152: --
153: procedure update_EXT_INCL_CHG
154: (p_validate in boolean default false
155: ,p_ext_incl_chg_id in number
156: ,p_chg_evt_cd in varchar2 default hr_api.g_varchar2
157: ,p_chg_evt_source in varchar2 default hr_api.g_varchar2
158: ,p_ext_rcd_in_file_id in number default hr_api.g_number
159: ,p_ext_data_elmt_in_rcd_id in number default hr_api.g_number
160: ,p_business_group_id in number default hr_api.g_number
153: procedure update_EXT_INCL_CHG
154: (p_validate in boolean default false
155: ,p_ext_incl_chg_id in number
156: ,p_chg_evt_cd in varchar2 default hr_api.g_varchar2
157: ,p_chg_evt_source in varchar2 default hr_api.g_varchar2
158: ,p_ext_rcd_in_file_id in number default hr_api.g_number
159: ,p_ext_data_elmt_in_rcd_id in number default hr_api.g_number
160: ,p_business_group_id in number default hr_api.g_number
161: ,p_legislation_code in varchar2 default hr_api.g_varchar2
154: (p_validate in boolean default false
155: ,p_ext_incl_chg_id in number
156: ,p_chg_evt_cd in varchar2 default hr_api.g_varchar2
157: ,p_chg_evt_source in varchar2 default hr_api.g_varchar2
158: ,p_ext_rcd_in_file_id in number default hr_api.g_number
159: ,p_ext_data_elmt_in_rcd_id in number default hr_api.g_number
160: ,p_business_group_id in number default hr_api.g_number
161: ,p_legislation_code in varchar2 default hr_api.g_varchar2
162: ,p_object_version_number in out nocopy number
155: ,p_ext_incl_chg_id in number
156: ,p_chg_evt_cd in varchar2 default hr_api.g_varchar2
157: ,p_chg_evt_source in varchar2 default hr_api.g_varchar2
158: ,p_ext_rcd_in_file_id in number default hr_api.g_number
159: ,p_ext_data_elmt_in_rcd_id in number default hr_api.g_number
160: ,p_business_group_id in number default hr_api.g_number
161: ,p_legislation_code in varchar2 default hr_api.g_varchar2
162: ,p_object_version_number in out nocopy number
163: ,p_effective_date in date
156: ,p_chg_evt_cd in varchar2 default hr_api.g_varchar2
157: ,p_chg_evt_source in varchar2 default hr_api.g_varchar2
158: ,p_ext_rcd_in_file_id in number default hr_api.g_number
159: ,p_ext_data_elmt_in_rcd_id in number default hr_api.g_number
160: ,p_business_group_id in number default hr_api.g_number
161: ,p_legislation_code in varchar2 default hr_api.g_varchar2
162: ,p_object_version_number in out nocopy number
163: ,p_effective_date in date
164: ) is
157: ,p_chg_evt_source in varchar2 default hr_api.g_varchar2
158: ,p_ext_rcd_in_file_id in number default hr_api.g_number
159: ,p_ext_data_elmt_in_rcd_id in number default hr_api.g_number
160: ,p_business_group_id in number default hr_api.g_number
161: ,p_legislation_code in varchar2 default hr_api.g_varchar2
162: ,p_object_version_number in out nocopy number
163: ,p_effective_date in date
164: ) is
165: --
198: ,p_object_version_number => p_object_version_number
199: ,p_effective_date => trunc(p_effective_date)
200: );
201: exception
202: when hr_api.cannot_find_prog_unit then
203: hr_api.cannot_find_prog_unit_error
204: (p_module_name => 'UPDATE_EXT_INCL_CHG'
205: ,p_hook_type => 'BP'
206: );
199: ,p_effective_date => trunc(p_effective_date)
200: );
201: exception
202: when hr_api.cannot_find_prog_unit then
203: hr_api.cannot_find_prog_unit_error
204: (p_module_name => 'UPDATE_EXT_INCL_CHG'
205: ,p_hook_type => 'BP'
206: );
207: --
238: ,p_object_version_number => l_object_version_number
239: ,p_effective_date => trunc(p_effective_date)
240: );
241: exception
242: when hr_api.cannot_find_prog_unit then
243: hr_api.cannot_find_prog_unit_error
244: (p_module_name => 'UPDATE_EXT_INCL_CHG'
245: ,p_hook_type => 'AP'
246: );
239: ,p_effective_date => trunc(p_effective_date)
240: );
241: exception
242: when hr_api.cannot_find_prog_unit then
243: hr_api.cannot_find_prog_unit_error
244: (p_module_name => 'UPDATE_EXT_INCL_CHG'
245: ,p_hook_type => 'AP'
246: );
247: --
253: --
254: -- When in validation only mode raise the Validate_Enabled exception
255: --
256: if p_validate then
257: raise hr_api.validate_enabled;
258: end if;
259: --
260: -- Set all output arguments
261: --
264: hr_utility.set_location(' Leaving:'||l_proc, 70);
265: --
266: exception
267: --
268: when hr_api.validate_enabled then
269: --
270: -- As the Validate_Enabled exception has been raised
271: -- we must rollback to the savepoint
272: --
329: ,p_object_version_number => p_object_version_number
330: ,p_effective_date => trunc(p_effective_date)
331: );
332: exception
333: when hr_api.cannot_find_prog_unit then
334: hr_api.cannot_find_prog_unit_error
335: (p_module_name => 'DELETE_EXT_INCL_CHG'
336: ,p_hook_type => 'BP'
337: );
330: ,p_effective_date => trunc(p_effective_date)
331: );
332: exception
333: when hr_api.cannot_find_prog_unit then
334: hr_api.cannot_find_prog_unit_error
335: (p_module_name => 'DELETE_EXT_INCL_CHG'
336: ,p_hook_type => 'BP'
337: );
338: --
359: ,p_object_version_number => l_object_version_number
360: ,p_effective_date => trunc(p_effective_date)
361: );
362: exception
363: when hr_api.cannot_find_prog_unit then
364: hr_api.cannot_find_prog_unit_error
365: (p_module_name => 'DELETE_EXT_INCL_CHG'
366: ,p_hook_type => 'AP'
367: );
360: ,p_effective_date => trunc(p_effective_date)
361: );
362: exception
363: when hr_api.cannot_find_prog_unit then
364: hr_api.cannot_find_prog_unit_error
365: (p_module_name => 'DELETE_EXT_INCL_CHG'
366: ,p_hook_type => 'AP'
367: );
368: --
374: --
375: -- When in validation only mode raise the Validate_Enabled exception
376: --
377: if p_validate then
378: raise hr_api.validate_enabled;
379: end if;
380: --
381: hr_utility.set_location(' Leaving:'||l_proc, 70);
382: --
381: hr_utility.set_location(' Leaving:'||l_proc, 70);
382: --
383: exception
384: --
385: when hr_api.validate_enabled then
386: --
387: -- As the Validate_Enabled exception has been raised
388: -- we must rollback to the savepoint
389: --