50: ,p_legislation_code => p_legislation_code
51: ,p_ext_data_elmt_in_rcd_id => p_ext_data_elmt_in_rcd_id
52: );
53: exception
54: when hr_api.cannot_find_prog_unit then
55: hr_api.cannot_find_prog_unit_error
56: (
57: p_module_name => 'CREATE_EXT_INCL_DATA_ELMT'
58: ,p_hook_type => 'BP'
51: ,p_ext_data_elmt_in_rcd_id => p_ext_data_elmt_in_rcd_id
52: );
53: exception
54: when hr_api.cannot_find_prog_unit then
55: hr_api.cannot_find_prog_unit_error
56: (
57: p_module_name => 'CREATE_EXT_INCL_DATA_ELMT'
58: ,p_hook_type => 'BP'
59: );
87: ,p_object_version_number => l_object_version_number
88: ,p_ext_data_elmt_in_rcd_id => p_ext_data_elmt_in_rcd_id
89: );
90: exception
91: when hr_api.cannot_find_prog_unit then
92: hr_api.cannot_find_prog_unit_error
93: (p_module_name => 'CREATE_EXT_INCL_DATA_ELMT'
94: ,p_hook_type => 'AP'
95: );
88: ,p_ext_data_elmt_in_rcd_id => p_ext_data_elmt_in_rcd_id
89: );
90: exception
91: when hr_api.cannot_find_prog_unit then
92: hr_api.cannot_find_prog_unit_error
93: (p_module_name => 'CREATE_EXT_INCL_DATA_ELMT'
94: ,p_hook_type => 'AP'
95: );
96: --
102: --
103: -- When in validation only mode raise the Validate_Enabled exception
104: --
105: if p_validate then
106: raise hr_api.validate_enabled;
107: end if;
108: --
109: -- Set all output arguments
110: --
114: hr_utility.set_location(' Leaving:'||l_proc, 70);
115: --
116: exception
117: --
118: when hr_api.validate_enabled then
119: --
120: -- As the Validate_Enabled exception has been raised
121: -- we must rollback to the savepoint
122: --
146: --
147: procedure update_EXT_INCL_DATA_ELMT
148: (p_validate in boolean default false
149: ,p_ext_incl_data_elmt_id in number
150: ,p_ext_rcd_in_file_id in number default hr_api.g_number
151: ,p_ext_data_elmt_id in number default hr_api.g_number
152: ,p_business_group_id in number default hr_api.g_number
153: ,p_legislation_code in varchar2 default hr_api.g_varchar2
154: ,p_object_version_number in out nocopy number
147: procedure update_EXT_INCL_DATA_ELMT
148: (p_validate in boolean default false
149: ,p_ext_incl_data_elmt_id in number
150: ,p_ext_rcd_in_file_id in number default hr_api.g_number
151: ,p_ext_data_elmt_id in number default hr_api.g_number
152: ,p_business_group_id in number default hr_api.g_number
153: ,p_legislation_code in varchar2 default hr_api.g_varchar2
154: ,p_object_version_number in out nocopy number
155: ,p_ext_data_elmt_in_rcd_id in number default hr_api.g_number
148: (p_validate in boolean default false
149: ,p_ext_incl_data_elmt_id in number
150: ,p_ext_rcd_in_file_id in number default hr_api.g_number
151: ,p_ext_data_elmt_id in number default hr_api.g_number
152: ,p_business_group_id in number default hr_api.g_number
153: ,p_legislation_code in varchar2 default hr_api.g_varchar2
154: ,p_object_version_number in out nocopy number
155: ,p_ext_data_elmt_in_rcd_id in number default hr_api.g_number
156: ) is
149: ,p_ext_incl_data_elmt_id in number
150: ,p_ext_rcd_in_file_id in number default hr_api.g_number
151: ,p_ext_data_elmt_id in number default hr_api.g_number
152: ,p_business_group_id in number default hr_api.g_number
153: ,p_legislation_code in varchar2 default hr_api.g_varchar2
154: ,p_object_version_number in out nocopy number
155: ,p_ext_data_elmt_in_rcd_id in number default hr_api.g_number
156: ) is
157: --
151: ,p_ext_data_elmt_id in number default hr_api.g_number
152: ,p_business_group_id in number default hr_api.g_number
153: ,p_legislation_code in varchar2 default hr_api.g_varchar2
154: ,p_object_version_number in out nocopy number
155: ,p_ext_data_elmt_in_rcd_id in number default hr_api.g_number
156: ) is
157: --
158: -- Declare cursors and local variables
159: --
188: ,p_object_version_number => p_object_version_number
189: ,p_ext_data_elmt_in_rcd_id => p_ext_data_elmt_in_rcd_id
190: );
191: exception
192: when hr_api.cannot_find_prog_unit then
193: hr_api.cannot_find_prog_unit_error
194: (p_module_name => 'UPDATE_EXT_INCL_DATA_ELMT'
195: ,p_hook_type => 'BP'
196: );
189: ,p_ext_data_elmt_in_rcd_id => p_ext_data_elmt_in_rcd_id
190: );
191: exception
192: when hr_api.cannot_find_prog_unit then
193: hr_api.cannot_find_prog_unit_error
194: (p_module_name => 'UPDATE_EXT_INCL_DATA_ELMT'
195: ,p_hook_type => 'BP'
196: );
197: --
224: ,p_object_version_number => l_object_version_number
225: ,p_ext_data_elmt_in_rcd_id => p_ext_data_elmt_in_rcd_id
226: );
227: exception
228: when hr_api.cannot_find_prog_unit then
229: hr_api.cannot_find_prog_unit_error
230: (p_module_name => 'UPDATE_EXT_INCL_DATA_ELMT'
231: ,p_hook_type => 'AP'
232: );
225: ,p_ext_data_elmt_in_rcd_id => p_ext_data_elmt_in_rcd_id
226: );
227: exception
228: when hr_api.cannot_find_prog_unit then
229: hr_api.cannot_find_prog_unit_error
230: (p_module_name => 'UPDATE_EXT_INCL_DATA_ELMT'
231: ,p_hook_type => 'AP'
232: );
233: --
239: --
240: -- When in validation only mode raise the Validate_Enabled exception
241: --
242: if p_validate then
243: raise hr_api.validate_enabled;
244: end if;
245: --
246: -- Set all output arguments
247: --
250: hr_utility.set_location(' Leaving:'||l_proc, 70);
251: --
252: exception
253: --
254: when hr_api.validate_enabled then
255: --
256: -- As the Validate_Enabled exception has been raised
257: -- we must rollback to the savepoint
258: --
313: ,p_legislation_code => p_legislation_code
314: ,p_object_version_number => p_object_version_number
315: );
316: exception
317: when hr_api.cannot_find_prog_unit then
318: hr_api.cannot_find_prog_unit_error
319: (p_module_name => 'DELETE_EXT_INCL_DATA_ELMT'
320: ,p_hook_type => 'BP'
321: );
314: ,p_object_version_number => p_object_version_number
315: );
316: exception
317: when hr_api.cannot_find_prog_unit then
318: hr_api.cannot_find_prog_unit_error
319: (p_module_name => 'DELETE_EXT_INCL_DATA_ELMT'
320: ,p_hook_type => 'BP'
321: );
322: --
341: ,p_legislation_code => p_legislation_code
342: ,p_object_version_number => l_object_version_number
343: );
344: exception
345: when hr_api.cannot_find_prog_unit then
346: hr_api.cannot_find_prog_unit_error
347: (p_module_name => 'DELETE_EXT_INCL_DATA_ELMT'
348: ,p_hook_type => 'AP'
349: );
342: ,p_object_version_number => l_object_version_number
343: );
344: exception
345: when hr_api.cannot_find_prog_unit then
346: hr_api.cannot_find_prog_unit_error
347: (p_module_name => 'DELETE_EXT_INCL_DATA_ELMT'
348: ,p_hook_type => 'AP'
349: );
350: --
356: --
357: -- When in validation only mode raise the Validate_Enabled exception
358: --
359: if p_validate then
360: raise hr_api.validate_enabled;
361: end if;
362: --
363: hr_utility.set_location(' Leaving:'||l_proc, 70);
364: --
363: hr_utility.set_location(' Leaving:'||l_proc, 70);
364: --
365: exception
366: --
367: when hr_api.validate_enabled then
368: --
369: -- As the Validate_Enabled exception has been raised
370: -- we must rollback to the savepoint
371: --