64: ,p_hide_flag => p_hide_flag
65: ,p_effective_date => trunc(p_effective_date)
66: );
67: exception
68: when hr_api.cannot_find_prog_unit then
69: hr_api.cannot_find_prog_unit_error
70: (
71: p_module_name => 'CREATE_EXT_ELMT_IN_RCD'
72: ,p_hook_type => 'BP'
65: ,p_effective_date => trunc(p_effective_date)
66: );
67: exception
68: when hr_api.cannot_find_prog_unit then
69: hr_api.cannot_find_prog_unit_error
70: (
71: p_module_name => 'CREATE_EXT_ELMT_IN_RCD'
72: ,p_hook_type => 'BP'
73: );
115: ,p_hide_flag => p_hide_flag
116: ,p_effective_date => trunc(p_effective_date)
117: );
118: exception
119: when hr_api.cannot_find_prog_unit then
120: hr_api.cannot_find_prog_unit_error
121: (p_module_name => 'CREATE_EXT_ELMT_IN_RCD'
122: ,p_hook_type => 'AP'
123: );
116: ,p_effective_date => trunc(p_effective_date)
117: );
118: exception
119: when hr_api.cannot_find_prog_unit then
120: hr_api.cannot_find_prog_unit_error
121: (p_module_name => 'CREATE_EXT_ELMT_IN_RCD'
122: ,p_hook_type => 'AP'
123: );
124: --
130: --
131: -- When in validation only mode raise the Validate_Enabled exception
132: --
133: if p_validate then
134: raise hr_api.validate_enabled;
135: end if;
136: --
137: -- Set all output arguments
138: --
142: hr_utility.set_location(' Leaving:'||l_proc, 70);
143: --
144: exception
145: --
146: when hr_api.validate_enabled then
147: --
148: -- As the Validate_Enabled exception has been raised
149: -- we must rollback to the savepoint
150: --
172: --
173: procedure update_EXT_ELMT_IN_RCD
174: (p_validate in boolean default false
175: ,p_ext_data_elmt_in_rcd_id in number
176: ,p_seq_num in number default hr_api.g_number
177: ,p_strt_pos in number default hr_api.g_number
178: ,p_dlmtr_val in varchar2 default hr_api.g_varchar2
179: ,p_rqd_flag in varchar2 default hr_api.g_varchar2
180: ,p_sprs_cd in varchar2 default hr_api.g_varchar2
173: procedure update_EXT_ELMT_IN_RCD
174: (p_validate in boolean default false
175: ,p_ext_data_elmt_in_rcd_id in number
176: ,p_seq_num in number default hr_api.g_number
177: ,p_strt_pos in number default hr_api.g_number
178: ,p_dlmtr_val in varchar2 default hr_api.g_varchar2
179: ,p_rqd_flag in varchar2 default hr_api.g_varchar2
180: ,p_sprs_cd in varchar2 default hr_api.g_varchar2
181: ,p_any_or_all_cd in varchar2 default hr_api.g_varchar2
174: (p_validate in boolean default false
175: ,p_ext_data_elmt_in_rcd_id in number
176: ,p_seq_num in number default hr_api.g_number
177: ,p_strt_pos in number default hr_api.g_number
178: ,p_dlmtr_val in varchar2 default hr_api.g_varchar2
179: ,p_rqd_flag in varchar2 default hr_api.g_varchar2
180: ,p_sprs_cd in varchar2 default hr_api.g_varchar2
181: ,p_any_or_all_cd in varchar2 default hr_api.g_varchar2
182: ,p_ext_data_elmt_id in number default hr_api.g_number
175: ,p_ext_data_elmt_in_rcd_id in number
176: ,p_seq_num in number default hr_api.g_number
177: ,p_strt_pos in number default hr_api.g_number
178: ,p_dlmtr_val in varchar2 default hr_api.g_varchar2
179: ,p_rqd_flag in varchar2 default hr_api.g_varchar2
180: ,p_sprs_cd in varchar2 default hr_api.g_varchar2
181: ,p_any_or_all_cd in varchar2 default hr_api.g_varchar2
182: ,p_ext_data_elmt_id in number default hr_api.g_number
183: ,p_ext_rcd_id in number default hr_api.g_number
176: ,p_seq_num in number default hr_api.g_number
177: ,p_strt_pos in number default hr_api.g_number
178: ,p_dlmtr_val in varchar2 default hr_api.g_varchar2
179: ,p_rqd_flag in varchar2 default hr_api.g_varchar2
180: ,p_sprs_cd in varchar2 default hr_api.g_varchar2
181: ,p_any_or_all_cd in varchar2 default hr_api.g_varchar2
182: ,p_ext_data_elmt_id in number default hr_api.g_number
183: ,p_ext_rcd_id in number default hr_api.g_number
184: ,p_business_group_id in number default hr_api.g_number
177: ,p_strt_pos in number default hr_api.g_number
178: ,p_dlmtr_val in varchar2 default hr_api.g_varchar2
179: ,p_rqd_flag in varchar2 default hr_api.g_varchar2
180: ,p_sprs_cd in varchar2 default hr_api.g_varchar2
181: ,p_any_or_all_cd in varchar2 default hr_api.g_varchar2
182: ,p_ext_data_elmt_id in number default hr_api.g_number
183: ,p_ext_rcd_id in number default hr_api.g_number
184: ,p_business_group_id in number default hr_api.g_number
185: ,p_legislation_code in varchar2 default hr_api.g_varchar2
178: ,p_dlmtr_val in varchar2 default hr_api.g_varchar2
179: ,p_rqd_flag in varchar2 default hr_api.g_varchar2
180: ,p_sprs_cd in varchar2 default hr_api.g_varchar2
181: ,p_any_or_all_cd in varchar2 default hr_api.g_varchar2
182: ,p_ext_data_elmt_id in number default hr_api.g_number
183: ,p_ext_rcd_id in number default hr_api.g_number
184: ,p_business_group_id in number default hr_api.g_number
185: ,p_legislation_code in varchar2 default hr_api.g_varchar2
186: ,p_object_version_number in out nocopy number
179: ,p_rqd_flag in varchar2 default hr_api.g_varchar2
180: ,p_sprs_cd in varchar2 default hr_api.g_varchar2
181: ,p_any_or_all_cd in varchar2 default hr_api.g_varchar2
182: ,p_ext_data_elmt_id in number default hr_api.g_number
183: ,p_ext_rcd_id in number default hr_api.g_number
184: ,p_business_group_id in number default hr_api.g_number
185: ,p_legislation_code in varchar2 default hr_api.g_varchar2
186: ,p_object_version_number in out nocopy number
187: ,p_hide_flag in varchar2 default hr_api.g_varchar2
180: ,p_sprs_cd in varchar2 default hr_api.g_varchar2
181: ,p_any_or_all_cd in varchar2 default hr_api.g_varchar2
182: ,p_ext_data_elmt_id in number default hr_api.g_number
183: ,p_ext_rcd_id in number default hr_api.g_number
184: ,p_business_group_id in number default hr_api.g_number
185: ,p_legislation_code in varchar2 default hr_api.g_varchar2
186: ,p_object_version_number in out nocopy number
187: ,p_hide_flag in varchar2 default hr_api.g_varchar2
188: ,p_effective_date in date
181: ,p_any_or_all_cd in varchar2 default hr_api.g_varchar2
182: ,p_ext_data_elmt_id in number default hr_api.g_number
183: ,p_ext_rcd_id in number default hr_api.g_number
184: ,p_business_group_id in number default hr_api.g_number
185: ,p_legislation_code in varchar2 default hr_api.g_varchar2
186: ,p_object_version_number in out nocopy number
187: ,p_hide_flag in varchar2 default hr_api.g_varchar2
188: ,p_effective_date in date
189: ) is
183: ,p_ext_rcd_id in number default hr_api.g_number
184: ,p_business_group_id in number default hr_api.g_number
185: ,p_legislation_code in varchar2 default hr_api.g_varchar2
186: ,p_object_version_number in out nocopy number
187: ,p_hide_flag in varchar2 default hr_api.g_varchar2
188: ,p_effective_date in date
189: ) is
190: --
191: -- Declare cursors and local variables
228: ,p_hide_flag => p_hide_flag
229: ,p_effective_date => trunc(p_effective_date)
230: );
231: exception
232: when hr_api.cannot_find_prog_unit then
233: hr_api.cannot_find_prog_unit_error
234: (p_module_name => 'UPDATE_EXT_ELMT_IN_RCD'
235: ,p_hook_type => 'BP'
236: );
229: ,p_effective_date => trunc(p_effective_date)
230: );
231: exception
232: when hr_api.cannot_find_prog_unit then
233: hr_api.cannot_find_prog_unit_error
234: (p_module_name => 'UPDATE_EXT_ELMT_IN_RCD'
235: ,p_hook_type => 'BP'
236: );
237: --
278: ,p_hide_flag => p_hide_flag
279: ,p_effective_date => trunc(p_effective_date)
280: );
281: exception
282: when hr_api.cannot_find_prog_unit then
283: hr_api.cannot_find_prog_unit_error
284: (p_module_name => 'UPDATE_EXT_ELMT_IN_RCD'
285: ,p_hook_type => 'AP'
286: );
279: ,p_effective_date => trunc(p_effective_date)
280: );
281: exception
282: when hr_api.cannot_find_prog_unit then
283: hr_api.cannot_find_prog_unit_error
284: (p_module_name => 'UPDATE_EXT_ELMT_IN_RCD'
285: ,p_hook_type => 'AP'
286: );
287: --
293: --
294: -- When in validation only mode raise the Validate_Enabled exception
295: --
296: if p_validate then
297: raise hr_api.validate_enabled;
298: end if;
299: --
300: -- Set all output arguments
301: --
304: hr_utility.set_location(' Leaving:'||l_proc, 70);
305: --
306: exception
307: --
308: when hr_api.validate_enabled then
309: --
310: -- As the Validate_Enabled exception has been raised
311: -- we must rollback to the savepoint
312: --
369: ,p_object_version_number => p_object_version_number
370: ,p_effective_date => trunc(p_effective_date)
371: );
372: exception
373: when hr_api.cannot_find_prog_unit then
374: hr_api.cannot_find_prog_unit_error
375: (p_module_name => 'DELETE_EXT_ELMT_IN_RCD'
376: ,p_hook_type => 'BP'
377: );
370: ,p_effective_date => trunc(p_effective_date)
371: );
372: exception
373: when hr_api.cannot_find_prog_unit then
374: hr_api.cannot_find_prog_unit_error
375: (p_module_name => 'DELETE_EXT_ELMT_IN_RCD'
376: ,p_hook_type => 'BP'
377: );
378: --
399: ,p_object_version_number => l_object_version_number
400: ,p_effective_date => trunc(p_effective_date)
401: );
402: exception
403: when hr_api.cannot_find_prog_unit then
404: hr_api.cannot_find_prog_unit_error
405: (p_module_name => 'DELETE_EXT_ELMT_IN_RCD'
406: ,p_hook_type => 'AP'
407: );
400: ,p_effective_date => trunc(p_effective_date)
401: );
402: exception
403: when hr_api.cannot_find_prog_unit then
404: hr_api.cannot_find_prog_unit_error
405: (p_module_name => 'DELETE_EXT_ELMT_IN_RCD'
406: ,p_hook_type => 'AP'
407: );
408: --
414: --
415: -- When in validation only mode raise the Validate_Enabled exception
416: --
417: if p_validate then
418: raise hr_api.validate_enabled;
419: end if;
420: --
421: hr_utility.set_location(' Leaving:'||l_proc, 70);
422: --
421: hr_utility.set_location(' Leaving:'||l_proc, 70);
422: --
423: exception
424: --
425: when hr_api.validate_enabled then
426: --
427: -- As the Validate_Enabled exception has been raised
428: -- we must rollback to the savepoint
429: --