52: ,p_business_group_id => p_business_group_id
53: ,p_legislation_code => p_legislation_code
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_ELMT_DECD'
60: ,p_hook_type => 'BP'
53: ,p_legislation_code => p_legislation_code
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_ELMT_DECD'
60: ,p_hook_type => 'BP'
61: );
91: ,p_legislation_code => p_legislation_code
92: ,p_object_version_number => l_object_version_number
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_ELMT_DECD'
98: ,p_hook_type => 'AP'
99: );
92: ,p_object_version_number => l_object_version_number
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_ELMT_DECD'
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: --
155: --
156: procedure update_EXT_ELMT_DECD
157: (p_validate in boolean default false
158: ,p_ext_data_elmt_decd_id in number
159: ,p_val in varchar2 default hr_api.g_varchar2
160: ,p_dcd_val in varchar2 default hr_api.g_varchar2
161: ,p_chg_evt_source in varchar2 default hr_api.g_varchar2
162: ,p_ext_data_elmt_id in number default hr_api.g_number
163: ,p_business_group_id in number default hr_api.g_number
156: procedure update_EXT_ELMT_DECD
157: (p_validate in boolean default false
158: ,p_ext_data_elmt_decd_id in number
159: ,p_val in varchar2 default hr_api.g_varchar2
160: ,p_dcd_val in varchar2 default hr_api.g_varchar2
161: ,p_chg_evt_source in varchar2 default hr_api.g_varchar2
162: ,p_ext_data_elmt_id in number default hr_api.g_number
163: ,p_business_group_id in number default hr_api.g_number
164: ,p_legislation_code in varchar2 default hr_api.g_varchar2
157: (p_validate in boolean default false
158: ,p_ext_data_elmt_decd_id in number
159: ,p_val in varchar2 default hr_api.g_varchar2
160: ,p_dcd_val in varchar2 default hr_api.g_varchar2
161: ,p_chg_evt_source in varchar2 default hr_api.g_varchar2
162: ,p_ext_data_elmt_id in number default hr_api.g_number
163: ,p_business_group_id in number default hr_api.g_number
164: ,p_legislation_code in varchar2 default hr_api.g_varchar2
165: ,p_object_version_number in out nocopy number
158: ,p_ext_data_elmt_decd_id in number
159: ,p_val in varchar2 default hr_api.g_varchar2
160: ,p_dcd_val in varchar2 default hr_api.g_varchar2
161: ,p_chg_evt_source in varchar2 default hr_api.g_varchar2
162: ,p_ext_data_elmt_id in number default hr_api.g_number
163: ,p_business_group_id in number default hr_api.g_number
164: ,p_legislation_code in varchar2 default hr_api.g_varchar2
165: ,p_object_version_number in out nocopy number
166: ) is
159: ,p_val in varchar2 default hr_api.g_varchar2
160: ,p_dcd_val in varchar2 default hr_api.g_varchar2
161: ,p_chg_evt_source in varchar2 default hr_api.g_varchar2
162: ,p_ext_data_elmt_id in number default hr_api.g_number
163: ,p_business_group_id in number default hr_api.g_number
164: ,p_legislation_code in varchar2 default hr_api.g_varchar2
165: ,p_object_version_number in out nocopy number
166: ) is
167: --
160: ,p_dcd_val in varchar2 default hr_api.g_varchar2
161: ,p_chg_evt_source in varchar2 default hr_api.g_varchar2
162: ,p_ext_data_elmt_id in number default hr_api.g_number
163: ,p_business_group_id in number default hr_api.g_number
164: ,p_legislation_code in varchar2 default hr_api.g_varchar2
165: ,p_object_version_number in out nocopy number
166: ) is
167: --
168: -- Declare cursors and local variables
199: ,p_legislation_code => p_legislation_code
200: ,p_object_version_number => p_object_version_number
201: );
202: exception
203: when hr_api.cannot_find_prog_unit then
204: hr_api.cannot_find_prog_unit_error
205: (p_module_name => 'UPDATE_EXT_ELMT_DECD'
206: ,p_hook_type => 'BP'
207: );
200: ,p_object_version_number => p_object_version_number
201: );
202: exception
203: when hr_api.cannot_find_prog_unit then
204: hr_api.cannot_find_prog_unit_error
205: (p_module_name => 'UPDATE_EXT_ELMT_DECD'
206: ,p_hook_type => 'BP'
207: );
208: --
237: ,p_legislation_code => p_legislation_code
238: ,p_object_version_number => l_object_version_number
239: );
240: exception
241: when hr_api.cannot_find_prog_unit then
242: hr_api.cannot_find_prog_unit_error
243: (p_module_name => 'UPDATE_EXT_ELMT_DECD'
244: ,p_hook_type => 'AP'
245: );
238: ,p_object_version_number => l_object_version_number
239: );
240: exception
241: when hr_api.cannot_find_prog_unit then
242: hr_api.cannot_find_prog_unit_error
243: (p_module_name => 'UPDATE_EXT_ELMT_DECD'
244: ,p_hook_type => 'AP'
245: );
246: --
252: --
253: -- When in validation only mode raise the Validate_Enabled exception
254: --
255: if p_validate then
256: raise hr_api.validate_enabled;
257: end if;
258: --
259: -- Set all output arguments
260: --
263: hr_utility.set_location(' Leaving:'||l_proc, 70);
264: --
265: exception
266: --
267: when hr_api.validate_enabled then
268: --
269: -- As the Validate_Enabled exception has been raised
270: -- we must rollback to the savepoint
271: --
332: ,p_legislation_code => p_legislation_code
333: ,p_object_version_number => p_object_version_number
334: );
335: exception
336: when hr_api.cannot_find_prog_unit then
337: hr_api.cannot_find_prog_unit_error
338: (p_module_name => 'DELETE_EXT_ELMT_DECD'
339: ,p_hook_type => 'BP'
340: );
333: ,p_object_version_number => p_object_version_number
334: );
335: exception
336: when hr_api.cannot_find_prog_unit then
337: hr_api.cannot_find_prog_unit_error
338: (p_module_name => 'DELETE_EXT_ELMT_DECD'
339: ,p_hook_type => 'BP'
340: );
341: --
360: ,p_legislation_code => p_legislation_code
361: ,p_object_version_number => l_object_version_number
362: );
363: exception
364: when hr_api.cannot_find_prog_unit then
365: hr_api.cannot_find_prog_unit_error
366: (p_module_name => 'DELETE_EXT_ELMT_DECD'
367: ,p_hook_type => 'AP'
368: );
361: ,p_object_version_number => l_object_version_number
362: );
363: exception
364: when hr_api.cannot_find_prog_unit then
365: hr_api.cannot_find_prog_unit_error
366: (p_module_name => 'DELETE_EXT_ELMT_DECD'
367: ,p_hook_type => 'AP'
368: );
369: --
375: --
376: -- When in validation only mode raise the Validate_Enabled exception
377: --
378: if p_validate then
379: raise hr_api.validate_enabled;
380: end if;
381: --
382: hr_utility.set_location(' Leaving:'||l_proc, 70);
383: --
382: hr_utility.set_location(' Leaving:'||l_proc, 70);
383: --
384: exception
385: --
386: when hr_api.validate_enabled then
387: --
388: -- As the Validate_Enabled exception has been raised
389: -- we must rollback to the savepoint
390: --