152: ,p_ext_post_prcs_rl => p_ext_post_prcs_rl
153: ,p_effective_date => trunc(p_effective_date)
154: );
155: exception
156: when hr_api.cannot_find_prog_unit then
157: hr_api.cannot_find_prog_unit_error
158: (
159: p_module_name => 'CREATE_EXT_DEFN'
160: ,p_hook_type => 'BP'
153: ,p_effective_date => trunc(p_effective_date)
154: );
155: exception
156: when hr_api.cannot_find_prog_unit then
157: hr_api.cannot_find_prog_unit_error
158: (
159: p_module_name => 'CREATE_EXT_DEFN'
160: ,p_hook_type => 'BP'
161: );
291: ,p_ext_post_prcs_rl => p_ext_post_prcs_rl
292: ,p_effective_date => trunc(p_effective_date)
293: );
294: exception
295: when hr_api.cannot_find_prog_unit then
296: hr_api.cannot_find_prog_unit_error
297: (p_module_name => 'CREATE_EXT_DEFN'
298: ,p_hook_type => 'AP'
299: );
292: ,p_effective_date => trunc(p_effective_date)
293: );
294: exception
295: when hr_api.cannot_find_prog_unit then
296: hr_api.cannot_find_prog_unit_error
297: (p_module_name => 'CREATE_EXT_DEFN'
298: ,p_hook_type => 'AP'
299: );
300: --
306: --
307: -- When in validation only mode raise the Validate_Enabled exception
308: --
309: if p_validate then
310: raise hr_api.validate_enabled;
311: end if;
312: --
313: -- Set all output arguments
314: --
318: hr_utility.set_location(' Leaving:'||l_proc, 70);
319: --
320: exception
321: --
322: when hr_api.validate_enabled then
323: --
324: -- As the Validate_Enabled exception has been raised
325: -- we must rollback to the savepoint
326: --
355: --
356: procedure update_EXT_DEFN
357: (p_validate in boolean default false
358: ,p_ext_dfn_id in number
359: ,p_name in varchar2 default hr_api.g_varchar2
360: ,p_xml_tag_name in varchar2 default hr_api.g_varchar2
361: ,p_xdo_template_id in number default hr_api.g_number
362: ,p_data_typ_cd in varchar2 default hr_api.g_varchar2
363: ,p_ext_typ_cd in varchar2 default hr_api.g_varchar2
356: procedure update_EXT_DEFN
357: (p_validate in boolean default false
358: ,p_ext_dfn_id in number
359: ,p_name in varchar2 default hr_api.g_varchar2
360: ,p_xml_tag_name in varchar2 default hr_api.g_varchar2
361: ,p_xdo_template_id in number default hr_api.g_number
362: ,p_data_typ_cd in varchar2 default hr_api.g_varchar2
363: ,p_ext_typ_cd in varchar2 default hr_api.g_varchar2
364: ,p_output_name in varchar2 default hr_api.g_varchar2
357: (p_validate in boolean default false
358: ,p_ext_dfn_id in number
359: ,p_name in varchar2 default hr_api.g_varchar2
360: ,p_xml_tag_name in varchar2 default hr_api.g_varchar2
361: ,p_xdo_template_id in number default hr_api.g_number
362: ,p_data_typ_cd in varchar2 default hr_api.g_varchar2
363: ,p_ext_typ_cd in varchar2 default hr_api.g_varchar2
364: ,p_output_name in varchar2 default hr_api.g_varchar2
365: ,p_output_type in varchar2 default hr_api.g_varchar2
358: ,p_ext_dfn_id in number
359: ,p_name in varchar2 default hr_api.g_varchar2
360: ,p_xml_tag_name in varchar2 default hr_api.g_varchar2
361: ,p_xdo_template_id in number default hr_api.g_number
362: ,p_data_typ_cd in varchar2 default hr_api.g_varchar2
363: ,p_ext_typ_cd in varchar2 default hr_api.g_varchar2
364: ,p_output_name in varchar2 default hr_api.g_varchar2
365: ,p_output_type in varchar2 default hr_api.g_varchar2
366: ,p_apnd_rqst_id_flag in varchar2 default hr_api.g_varchar2
359: ,p_name in varchar2 default hr_api.g_varchar2
360: ,p_xml_tag_name in varchar2 default hr_api.g_varchar2
361: ,p_xdo_template_id in number default hr_api.g_number
362: ,p_data_typ_cd in varchar2 default hr_api.g_varchar2
363: ,p_ext_typ_cd in varchar2 default hr_api.g_varchar2
364: ,p_output_name in varchar2 default hr_api.g_varchar2
365: ,p_output_type in varchar2 default hr_api.g_varchar2
366: ,p_apnd_rqst_id_flag in varchar2 default hr_api.g_varchar2
367: ,p_prmy_sort_cd in varchar2 default hr_api.g_varchar2
360: ,p_xml_tag_name in varchar2 default hr_api.g_varchar2
361: ,p_xdo_template_id in number default hr_api.g_number
362: ,p_data_typ_cd in varchar2 default hr_api.g_varchar2
363: ,p_ext_typ_cd in varchar2 default hr_api.g_varchar2
364: ,p_output_name in varchar2 default hr_api.g_varchar2
365: ,p_output_type in varchar2 default hr_api.g_varchar2
366: ,p_apnd_rqst_id_flag in varchar2 default hr_api.g_varchar2
367: ,p_prmy_sort_cd in varchar2 default hr_api.g_varchar2
368: ,p_scnd_sort_cd in varchar2 default hr_api.g_varchar2
361: ,p_xdo_template_id in number default hr_api.g_number
362: ,p_data_typ_cd in varchar2 default hr_api.g_varchar2
363: ,p_ext_typ_cd in varchar2 default hr_api.g_varchar2
364: ,p_output_name in varchar2 default hr_api.g_varchar2
365: ,p_output_type in varchar2 default hr_api.g_varchar2
366: ,p_apnd_rqst_id_flag in varchar2 default hr_api.g_varchar2
367: ,p_prmy_sort_cd in varchar2 default hr_api.g_varchar2
368: ,p_scnd_sort_cd in varchar2 default hr_api.g_varchar2
369: ,p_strt_dt in varchar2 default hr_api.g_varchar2
362: ,p_data_typ_cd in varchar2 default hr_api.g_varchar2
363: ,p_ext_typ_cd in varchar2 default hr_api.g_varchar2
364: ,p_output_name in varchar2 default hr_api.g_varchar2
365: ,p_output_type in varchar2 default hr_api.g_varchar2
366: ,p_apnd_rqst_id_flag in varchar2 default hr_api.g_varchar2
367: ,p_prmy_sort_cd in varchar2 default hr_api.g_varchar2
368: ,p_scnd_sort_cd in varchar2 default hr_api.g_varchar2
369: ,p_strt_dt in varchar2 default hr_api.g_varchar2
370: ,p_end_dt in varchar2 default hr_api.g_varchar2
363: ,p_ext_typ_cd in varchar2 default hr_api.g_varchar2
364: ,p_output_name in varchar2 default hr_api.g_varchar2
365: ,p_output_type in varchar2 default hr_api.g_varchar2
366: ,p_apnd_rqst_id_flag in varchar2 default hr_api.g_varchar2
367: ,p_prmy_sort_cd in varchar2 default hr_api.g_varchar2
368: ,p_scnd_sort_cd in varchar2 default hr_api.g_varchar2
369: ,p_strt_dt in varchar2 default hr_api.g_varchar2
370: ,p_end_dt in varchar2 default hr_api.g_varchar2
371: ,p_ext_crit_prfl_id in number default hr_api.g_number
364: ,p_output_name in varchar2 default hr_api.g_varchar2
365: ,p_output_type in varchar2 default hr_api.g_varchar2
366: ,p_apnd_rqst_id_flag in varchar2 default hr_api.g_varchar2
367: ,p_prmy_sort_cd in varchar2 default hr_api.g_varchar2
368: ,p_scnd_sort_cd in varchar2 default hr_api.g_varchar2
369: ,p_strt_dt in varchar2 default hr_api.g_varchar2
370: ,p_end_dt in varchar2 default hr_api.g_varchar2
371: ,p_ext_crit_prfl_id in number default hr_api.g_number
372: ,p_ext_file_id in number default hr_api.g_number
365: ,p_output_type in varchar2 default hr_api.g_varchar2
366: ,p_apnd_rqst_id_flag in varchar2 default hr_api.g_varchar2
367: ,p_prmy_sort_cd in varchar2 default hr_api.g_varchar2
368: ,p_scnd_sort_cd in varchar2 default hr_api.g_varchar2
369: ,p_strt_dt in varchar2 default hr_api.g_varchar2
370: ,p_end_dt in varchar2 default hr_api.g_varchar2
371: ,p_ext_crit_prfl_id in number default hr_api.g_number
372: ,p_ext_file_id in number default hr_api.g_number
373: ,p_business_group_id in number default hr_api.g_number
366: ,p_apnd_rqst_id_flag in varchar2 default hr_api.g_varchar2
367: ,p_prmy_sort_cd in varchar2 default hr_api.g_varchar2
368: ,p_scnd_sort_cd in varchar2 default hr_api.g_varchar2
369: ,p_strt_dt in varchar2 default hr_api.g_varchar2
370: ,p_end_dt in varchar2 default hr_api.g_varchar2
371: ,p_ext_crit_prfl_id in number default hr_api.g_number
372: ,p_ext_file_id in number default hr_api.g_number
373: ,p_business_group_id in number default hr_api.g_number
374: ,p_legislation_code in varchar2 default hr_api.g_varchar2
367: ,p_prmy_sort_cd in varchar2 default hr_api.g_varchar2
368: ,p_scnd_sort_cd in varchar2 default hr_api.g_varchar2
369: ,p_strt_dt in varchar2 default hr_api.g_varchar2
370: ,p_end_dt in varchar2 default hr_api.g_varchar2
371: ,p_ext_crit_prfl_id in number default hr_api.g_number
372: ,p_ext_file_id in number default hr_api.g_number
373: ,p_business_group_id in number default hr_api.g_number
374: ,p_legislation_code in varchar2 default hr_api.g_varchar2
375: ,p_xdf_attribute_category in varchar2 default hr_api.g_varchar2
368: ,p_scnd_sort_cd in varchar2 default hr_api.g_varchar2
369: ,p_strt_dt in varchar2 default hr_api.g_varchar2
370: ,p_end_dt in varchar2 default hr_api.g_varchar2
371: ,p_ext_crit_prfl_id in number default hr_api.g_number
372: ,p_ext_file_id in number default hr_api.g_number
373: ,p_business_group_id in number default hr_api.g_number
374: ,p_legislation_code in varchar2 default hr_api.g_varchar2
375: ,p_xdf_attribute_category in varchar2 default hr_api.g_varchar2
376: ,p_xdf_attribute1 in varchar2 default hr_api.g_varchar2
369: ,p_strt_dt in varchar2 default hr_api.g_varchar2
370: ,p_end_dt in varchar2 default hr_api.g_varchar2
371: ,p_ext_crit_prfl_id in number default hr_api.g_number
372: ,p_ext_file_id in number default hr_api.g_number
373: ,p_business_group_id in number default hr_api.g_number
374: ,p_legislation_code in varchar2 default hr_api.g_varchar2
375: ,p_xdf_attribute_category in varchar2 default hr_api.g_varchar2
376: ,p_xdf_attribute1 in varchar2 default hr_api.g_varchar2
377: ,p_xdf_attribute2 in varchar2 default hr_api.g_varchar2
370: ,p_end_dt in varchar2 default hr_api.g_varchar2
371: ,p_ext_crit_prfl_id in number default hr_api.g_number
372: ,p_ext_file_id in number default hr_api.g_number
373: ,p_business_group_id in number default hr_api.g_number
374: ,p_legislation_code in varchar2 default hr_api.g_varchar2
375: ,p_xdf_attribute_category in varchar2 default hr_api.g_varchar2
376: ,p_xdf_attribute1 in varchar2 default hr_api.g_varchar2
377: ,p_xdf_attribute2 in varchar2 default hr_api.g_varchar2
378: ,p_xdf_attribute3 in varchar2 default hr_api.g_varchar2
371: ,p_ext_crit_prfl_id in number default hr_api.g_number
372: ,p_ext_file_id in number default hr_api.g_number
373: ,p_business_group_id in number default hr_api.g_number
374: ,p_legislation_code in varchar2 default hr_api.g_varchar2
375: ,p_xdf_attribute_category in varchar2 default hr_api.g_varchar2
376: ,p_xdf_attribute1 in varchar2 default hr_api.g_varchar2
377: ,p_xdf_attribute2 in varchar2 default hr_api.g_varchar2
378: ,p_xdf_attribute3 in varchar2 default hr_api.g_varchar2
379: ,p_xdf_attribute4 in varchar2 default hr_api.g_varchar2
372: ,p_ext_file_id in number default hr_api.g_number
373: ,p_business_group_id in number default hr_api.g_number
374: ,p_legislation_code in varchar2 default hr_api.g_varchar2
375: ,p_xdf_attribute_category in varchar2 default hr_api.g_varchar2
376: ,p_xdf_attribute1 in varchar2 default hr_api.g_varchar2
377: ,p_xdf_attribute2 in varchar2 default hr_api.g_varchar2
378: ,p_xdf_attribute3 in varchar2 default hr_api.g_varchar2
379: ,p_xdf_attribute4 in varchar2 default hr_api.g_varchar2
380: ,p_xdf_attribute5 in varchar2 default hr_api.g_varchar2
373: ,p_business_group_id in number default hr_api.g_number
374: ,p_legislation_code in varchar2 default hr_api.g_varchar2
375: ,p_xdf_attribute_category in varchar2 default hr_api.g_varchar2
376: ,p_xdf_attribute1 in varchar2 default hr_api.g_varchar2
377: ,p_xdf_attribute2 in varchar2 default hr_api.g_varchar2
378: ,p_xdf_attribute3 in varchar2 default hr_api.g_varchar2
379: ,p_xdf_attribute4 in varchar2 default hr_api.g_varchar2
380: ,p_xdf_attribute5 in varchar2 default hr_api.g_varchar2
381: ,p_xdf_attribute6 in varchar2 default hr_api.g_varchar2
374: ,p_legislation_code in varchar2 default hr_api.g_varchar2
375: ,p_xdf_attribute_category in varchar2 default hr_api.g_varchar2
376: ,p_xdf_attribute1 in varchar2 default hr_api.g_varchar2
377: ,p_xdf_attribute2 in varchar2 default hr_api.g_varchar2
378: ,p_xdf_attribute3 in varchar2 default hr_api.g_varchar2
379: ,p_xdf_attribute4 in varchar2 default hr_api.g_varchar2
380: ,p_xdf_attribute5 in varchar2 default hr_api.g_varchar2
381: ,p_xdf_attribute6 in varchar2 default hr_api.g_varchar2
382: ,p_xdf_attribute7 in varchar2 default hr_api.g_varchar2
375: ,p_xdf_attribute_category in varchar2 default hr_api.g_varchar2
376: ,p_xdf_attribute1 in varchar2 default hr_api.g_varchar2
377: ,p_xdf_attribute2 in varchar2 default hr_api.g_varchar2
378: ,p_xdf_attribute3 in varchar2 default hr_api.g_varchar2
379: ,p_xdf_attribute4 in varchar2 default hr_api.g_varchar2
380: ,p_xdf_attribute5 in varchar2 default hr_api.g_varchar2
381: ,p_xdf_attribute6 in varchar2 default hr_api.g_varchar2
382: ,p_xdf_attribute7 in varchar2 default hr_api.g_varchar2
383: ,p_xdf_attribute8 in varchar2 default hr_api.g_varchar2
376: ,p_xdf_attribute1 in varchar2 default hr_api.g_varchar2
377: ,p_xdf_attribute2 in varchar2 default hr_api.g_varchar2
378: ,p_xdf_attribute3 in varchar2 default hr_api.g_varchar2
379: ,p_xdf_attribute4 in varchar2 default hr_api.g_varchar2
380: ,p_xdf_attribute5 in varchar2 default hr_api.g_varchar2
381: ,p_xdf_attribute6 in varchar2 default hr_api.g_varchar2
382: ,p_xdf_attribute7 in varchar2 default hr_api.g_varchar2
383: ,p_xdf_attribute8 in varchar2 default hr_api.g_varchar2
384: ,p_xdf_attribute9 in varchar2 default hr_api.g_varchar2
377: ,p_xdf_attribute2 in varchar2 default hr_api.g_varchar2
378: ,p_xdf_attribute3 in varchar2 default hr_api.g_varchar2
379: ,p_xdf_attribute4 in varchar2 default hr_api.g_varchar2
380: ,p_xdf_attribute5 in varchar2 default hr_api.g_varchar2
381: ,p_xdf_attribute6 in varchar2 default hr_api.g_varchar2
382: ,p_xdf_attribute7 in varchar2 default hr_api.g_varchar2
383: ,p_xdf_attribute8 in varchar2 default hr_api.g_varchar2
384: ,p_xdf_attribute9 in varchar2 default hr_api.g_varchar2
385: ,p_xdf_attribute10 in varchar2 default hr_api.g_varchar2
378: ,p_xdf_attribute3 in varchar2 default hr_api.g_varchar2
379: ,p_xdf_attribute4 in varchar2 default hr_api.g_varchar2
380: ,p_xdf_attribute5 in varchar2 default hr_api.g_varchar2
381: ,p_xdf_attribute6 in varchar2 default hr_api.g_varchar2
382: ,p_xdf_attribute7 in varchar2 default hr_api.g_varchar2
383: ,p_xdf_attribute8 in varchar2 default hr_api.g_varchar2
384: ,p_xdf_attribute9 in varchar2 default hr_api.g_varchar2
385: ,p_xdf_attribute10 in varchar2 default hr_api.g_varchar2
386: ,p_xdf_attribute11 in varchar2 default hr_api.g_varchar2
379: ,p_xdf_attribute4 in varchar2 default hr_api.g_varchar2
380: ,p_xdf_attribute5 in varchar2 default hr_api.g_varchar2
381: ,p_xdf_attribute6 in varchar2 default hr_api.g_varchar2
382: ,p_xdf_attribute7 in varchar2 default hr_api.g_varchar2
383: ,p_xdf_attribute8 in varchar2 default hr_api.g_varchar2
384: ,p_xdf_attribute9 in varchar2 default hr_api.g_varchar2
385: ,p_xdf_attribute10 in varchar2 default hr_api.g_varchar2
386: ,p_xdf_attribute11 in varchar2 default hr_api.g_varchar2
387: ,p_xdf_attribute12 in varchar2 default hr_api.g_varchar2
380: ,p_xdf_attribute5 in varchar2 default hr_api.g_varchar2
381: ,p_xdf_attribute6 in varchar2 default hr_api.g_varchar2
382: ,p_xdf_attribute7 in varchar2 default hr_api.g_varchar2
383: ,p_xdf_attribute8 in varchar2 default hr_api.g_varchar2
384: ,p_xdf_attribute9 in varchar2 default hr_api.g_varchar2
385: ,p_xdf_attribute10 in varchar2 default hr_api.g_varchar2
386: ,p_xdf_attribute11 in varchar2 default hr_api.g_varchar2
387: ,p_xdf_attribute12 in varchar2 default hr_api.g_varchar2
388: ,p_xdf_attribute13 in varchar2 default hr_api.g_varchar2
381: ,p_xdf_attribute6 in varchar2 default hr_api.g_varchar2
382: ,p_xdf_attribute7 in varchar2 default hr_api.g_varchar2
383: ,p_xdf_attribute8 in varchar2 default hr_api.g_varchar2
384: ,p_xdf_attribute9 in varchar2 default hr_api.g_varchar2
385: ,p_xdf_attribute10 in varchar2 default hr_api.g_varchar2
386: ,p_xdf_attribute11 in varchar2 default hr_api.g_varchar2
387: ,p_xdf_attribute12 in varchar2 default hr_api.g_varchar2
388: ,p_xdf_attribute13 in varchar2 default hr_api.g_varchar2
389: ,p_xdf_attribute14 in varchar2 default hr_api.g_varchar2
382: ,p_xdf_attribute7 in varchar2 default hr_api.g_varchar2
383: ,p_xdf_attribute8 in varchar2 default hr_api.g_varchar2
384: ,p_xdf_attribute9 in varchar2 default hr_api.g_varchar2
385: ,p_xdf_attribute10 in varchar2 default hr_api.g_varchar2
386: ,p_xdf_attribute11 in varchar2 default hr_api.g_varchar2
387: ,p_xdf_attribute12 in varchar2 default hr_api.g_varchar2
388: ,p_xdf_attribute13 in varchar2 default hr_api.g_varchar2
389: ,p_xdf_attribute14 in varchar2 default hr_api.g_varchar2
390: ,p_xdf_attribute15 in varchar2 default hr_api.g_varchar2
383: ,p_xdf_attribute8 in varchar2 default hr_api.g_varchar2
384: ,p_xdf_attribute9 in varchar2 default hr_api.g_varchar2
385: ,p_xdf_attribute10 in varchar2 default hr_api.g_varchar2
386: ,p_xdf_attribute11 in varchar2 default hr_api.g_varchar2
387: ,p_xdf_attribute12 in varchar2 default hr_api.g_varchar2
388: ,p_xdf_attribute13 in varchar2 default hr_api.g_varchar2
389: ,p_xdf_attribute14 in varchar2 default hr_api.g_varchar2
390: ,p_xdf_attribute15 in varchar2 default hr_api.g_varchar2
391: ,p_xdf_attribute16 in varchar2 default hr_api.g_varchar2
384: ,p_xdf_attribute9 in varchar2 default hr_api.g_varchar2
385: ,p_xdf_attribute10 in varchar2 default hr_api.g_varchar2
386: ,p_xdf_attribute11 in varchar2 default hr_api.g_varchar2
387: ,p_xdf_attribute12 in varchar2 default hr_api.g_varchar2
388: ,p_xdf_attribute13 in varchar2 default hr_api.g_varchar2
389: ,p_xdf_attribute14 in varchar2 default hr_api.g_varchar2
390: ,p_xdf_attribute15 in varchar2 default hr_api.g_varchar2
391: ,p_xdf_attribute16 in varchar2 default hr_api.g_varchar2
392: ,p_xdf_attribute17 in varchar2 default hr_api.g_varchar2
385: ,p_xdf_attribute10 in varchar2 default hr_api.g_varchar2
386: ,p_xdf_attribute11 in varchar2 default hr_api.g_varchar2
387: ,p_xdf_attribute12 in varchar2 default hr_api.g_varchar2
388: ,p_xdf_attribute13 in varchar2 default hr_api.g_varchar2
389: ,p_xdf_attribute14 in varchar2 default hr_api.g_varchar2
390: ,p_xdf_attribute15 in varchar2 default hr_api.g_varchar2
391: ,p_xdf_attribute16 in varchar2 default hr_api.g_varchar2
392: ,p_xdf_attribute17 in varchar2 default hr_api.g_varchar2
393: ,p_xdf_attribute18 in varchar2 default hr_api.g_varchar2
386: ,p_xdf_attribute11 in varchar2 default hr_api.g_varchar2
387: ,p_xdf_attribute12 in varchar2 default hr_api.g_varchar2
388: ,p_xdf_attribute13 in varchar2 default hr_api.g_varchar2
389: ,p_xdf_attribute14 in varchar2 default hr_api.g_varchar2
390: ,p_xdf_attribute15 in varchar2 default hr_api.g_varchar2
391: ,p_xdf_attribute16 in varchar2 default hr_api.g_varchar2
392: ,p_xdf_attribute17 in varchar2 default hr_api.g_varchar2
393: ,p_xdf_attribute18 in varchar2 default hr_api.g_varchar2
394: ,p_xdf_attribute19 in varchar2 default hr_api.g_varchar2
387: ,p_xdf_attribute12 in varchar2 default hr_api.g_varchar2
388: ,p_xdf_attribute13 in varchar2 default hr_api.g_varchar2
389: ,p_xdf_attribute14 in varchar2 default hr_api.g_varchar2
390: ,p_xdf_attribute15 in varchar2 default hr_api.g_varchar2
391: ,p_xdf_attribute16 in varchar2 default hr_api.g_varchar2
392: ,p_xdf_attribute17 in varchar2 default hr_api.g_varchar2
393: ,p_xdf_attribute18 in varchar2 default hr_api.g_varchar2
394: ,p_xdf_attribute19 in varchar2 default hr_api.g_varchar2
395: ,p_xdf_attribute20 in varchar2 default hr_api.g_varchar2
388: ,p_xdf_attribute13 in varchar2 default hr_api.g_varchar2
389: ,p_xdf_attribute14 in varchar2 default hr_api.g_varchar2
390: ,p_xdf_attribute15 in varchar2 default hr_api.g_varchar2
391: ,p_xdf_attribute16 in varchar2 default hr_api.g_varchar2
392: ,p_xdf_attribute17 in varchar2 default hr_api.g_varchar2
393: ,p_xdf_attribute18 in varchar2 default hr_api.g_varchar2
394: ,p_xdf_attribute19 in varchar2 default hr_api.g_varchar2
395: ,p_xdf_attribute20 in varchar2 default hr_api.g_varchar2
396: ,p_xdf_attribute21 in varchar2 default hr_api.g_varchar2
389: ,p_xdf_attribute14 in varchar2 default hr_api.g_varchar2
390: ,p_xdf_attribute15 in varchar2 default hr_api.g_varchar2
391: ,p_xdf_attribute16 in varchar2 default hr_api.g_varchar2
392: ,p_xdf_attribute17 in varchar2 default hr_api.g_varchar2
393: ,p_xdf_attribute18 in varchar2 default hr_api.g_varchar2
394: ,p_xdf_attribute19 in varchar2 default hr_api.g_varchar2
395: ,p_xdf_attribute20 in varchar2 default hr_api.g_varchar2
396: ,p_xdf_attribute21 in varchar2 default hr_api.g_varchar2
397: ,p_xdf_attribute22 in varchar2 default hr_api.g_varchar2
390: ,p_xdf_attribute15 in varchar2 default hr_api.g_varchar2
391: ,p_xdf_attribute16 in varchar2 default hr_api.g_varchar2
392: ,p_xdf_attribute17 in varchar2 default hr_api.g_varchar2
393: ,p_xdf_attribute18 in varchar2 default hr_api.g_varchar2
394: ,p_xdf_attribute19 in varchar2 default hr_api.g_varchar2
395: ,p_xdf_attribute20 in varchar2 default hr_api.g_varchar2
396: ,p_xdf_attribute21 in varchar2 default hr_api.g_varchar2
397: ,p_xdf_attribute22 in varchar2 default hr_api.g_varchar2
398: ,p_xdf_attribute23 in varchar2 default hr_api.g_varchar2
391: ,p_xdf_attribute16 in varchar2 default hr_api.g_varchar2
392: ,p_xdf_attribute17 in varchar2 default hr_api.g_varchar2
393: ,p_xdf_attribute18 in varchar2 default hr_api.g_varchar2
394: ,p_xdf_attribute19 in varchar2 default hr_api.g_varchar2
395: ,p_xdf_attribute20 in varchar2 default hr_api.g_varchar2
396: ,p_xdf_attribute21 in varchar2 default hr_api.g_varchar2
397: ,p_xdf_attribute22 in varchar2 default hr_api.g_varchar2
398: ,p_xdf_attribute23 in varchar2 default hr_api.g_varchar2
399: ,p_xdf_attribute24 in varchar2 default hr_api.g_varchar2
392: ,p_xdf_attribute17 in varchar2 default hr_api.g_varchar2
393: ,p_xdf_attribute18 in varchar2 default hr_api.g_varchar2
394: ,p_xdf_attribute19 in varchar2 default hr_api.g_varchar2
395: ,p_xdf_attribute20 in varchar2 default hr_api.g_varchar2
396: ,p_xdf_attribute21 in varchar2 default hr_api.g_varchar2
397: ,p_xdf_attribute22 in varchar2 default hr_api.g_varchar2
398: ,p_xdf_attribute23 in varchar2 default hr_api.g_varchar2
399: ,p_xdf_attribute24 in varchar2 default hr_api.g_varchar2
400: ,p_xdf_attribute25 in varchar2 default hr_api.g_varchar2
393: ,p_xdf_attribute18 in varchar2 default hr_api.g_varchar2
394: ,p_xdf_attribute19 in varchar2 default hr_api.g_varchar2
395: ,p_xdf_attribute20 in varchar2 default hr_api.g_varchar2
396: ,p_xdf_attribute21 in varchar2 default hr_api.g_varchar2
397: ,p_xdf_attribute22 in varchar2 default hr_api.g_varchar2
398: ,p_xdf_attribute23 in varchar2 default hr_api.g_varchar2
399: ,p_xdf_attribute24 in varchar2 default hr_api.g_varchar2
400: ,p_xdf_attribute25 in varchar2 default hr_api.g_varchar2
401: ,p_xdf_attribute26 in varchar2 default hr_api.g_varchar2
394: ,p_xdf_attribute19 in varchar2 default hr_api.g_varchar2
395: ,p_xdf_attribute20 in varchar2 default hr_api.g_varchar2
396: ,p_xdf_attribute21 in varchar2 default hr_api.g_varchar2
397: ,p_xdf_attribute22 in varchar2 default hr_api.g_varchar2
398: ,p_xdf_attribute23 in varchar2 default hr_api.g_varchar2
399: ,p_xdf_attribute24 in varchar2 default hr_api.g_varchar2
400: ,p_xdf_attribute25 in varchar2 default hr_api.g_varchar2
401: ,p_xdf_attribute26 in varchar2 default hr_api.g_varchar2
402: ,p_xdf_attribute27 in varchar2 default hr_api.g_varchar2
395: ,p_xdf_attribute20 in varchar2 default hr_api.g_varchar2
396: ,p_xdf_attribute21 in varchar2 default hr_api.g_varchar2
397: ,p_xdf_attribute22 in varchar2 default hr_api.g_varchar2
398: ,p_xdf_attribute23 in varchar2 default hr_api.g_varchar2
399: ,p_xdf_attribute24 in varchar2 default hr_api.g_varchar2
400: ,p_xdf_attribute25 in varchar2 default hr_api.g_varchar2
401: ,p_xdf_attribute26 in varchar2 default hr_api.g_varchar2
402: ,p_xdf_attribute27 in varchar2 default hr_api.g_varchar2
403: ,p_xdf_attribute28 in varchar2 default hr_api.g_varchar2
396: ,p_xdf_attribute21 in varchar2 default hr_api.g_varchar2
397: ,p_xdf_attribute22 in varchar2 default hr_api.g_varchar2
398: ,p_xdf_attribute23 in varchar2 default hr_api.g_varchar2
399: ,p_xdf_attribute24 in varchar2 default hr_api.g_varchar2
400: ,p_xdf_attribute25 in varchar2 default hr_api.g_varchar2
401: ,p_xdf_attribute26 in varchar2 default hr_api.g_varchar2
402: ,p_xdf_attribute27 in varchar2 default hr_api.g_varchar2
403: ,p_xdf_attribute28 in varchar2 default hr_api.g_varchar2
404: ,p_xdf_attribute29 in varchar2 default hr_api.g_varchar2
397: ,p_xdf_attribute22 in varchar2 default hr_api.g_varchar2
398: ,p_xdf_attribute23 in varchar2 default hr_api.g_varchar2
399: ,p_xdf_attribute24 in varchar2 default hr_api.g_varchar2
400: ,p_xdf_attribute25 in varchar2 default hr_api.g_varchar2
401: ,p_xdf_attribute26 in varchar2 default hr_api.g_varchar2
402: ,p_xdf_attribute27 in varchar2 default hr_api.g_varchar2
403: ,p_xdf_attribute28 in varchar2 default hr_api.g_varchar2
404: ,p_xdf_attribute29 in varchar2 default hr_api.g_varchar2
405: ,p_xdf_attribute30 in varchar2 default hr_api.g_varchar2
398: ,p_xdf_attribute23 in varchar2 default hr_api.g_varchar2
399: ,p_xdf_attribute24 in varchar2 default hr_api.g_varchar2
400: ,p_xdf_attribute25 in varchar2 default hr_api.g_varchar2
401: ,p_xdf_attribute26 in varchar2 default hr_api.g_varchar2
402: ,p_xdf_attribute27 in varchar2 default hr_api.g_varchar2
403: ,p_xdf_attribute28 in varchar2 default hr_api.g_varchar2
404: ,p_xdf_attribute29 in varchar2 default hr_api.g_varchar2
405: ,p_xdf_attribute30 in varchar2 default hr_api.g_varchar2
406: ,p_object_version_number in out nocopy number
399: ,p_xdf_attribute24 in varchar2 default hr_api.g_varchar2
400: ,p_xdf_attribute25 in varchar2 default hr_api.g_varchar2
401: ,p_xdf_attribute26 in varchar2 default hr_api.g_varchar2
402: ,p_xdf_attribute27 in varchar2 default hr_api.g_varchar2
403: ,p_xdf_attribute28 in varchar2 default hr_api.g_varchar2
404: ,p_xdf_attribute29 in varchar2 default hr_api.g_varchar2
405: ,p_xdf_attribute30 in varchar2 default hr_api.g_varchar2
406: ,p_object_version_number in out nocopy number
407: ,p_drctry_name in varchar2 default hr_api.g_varchar2
400: ,p_xdf_attribute25 in varchar2 default hr_api.g_varchar2
401: ,p_xdf_attribute26 in varchar2 default hr_api.g_varchar2
402: ,p_xdf_attribute27 in varchar2 default hr_api.g_varchar2
403: ,p_xdf_attribute28 in varchar2 default hr_api.g_varchar2
404: ,p_xdf_attribute29 in varchar2 default hr_api.g_varchar2
405: ,p_xdf_attribute30 in varchar2 default hr_api.g_varchar2
406: ,p_object_version_number in out nocopy number
407: ,p_drctry_name in varchar2 default hr_api.g_varchar2
408: ,p_kickoff_wrt_prc_flag in varchar2 default hr_api.g_varchar2
401: ,p_xdf_attribute26 in varchar2 default hr_api.g_varchar2
402: ,p_xdf_attribute27 in varchar2 default hr_api.g_varchar2
403: ,p_xdf_attribute28 in varchar2 default hr_api.g_varchar2
404: ,p_xdf_attribute29 in varchar2 default hr_api.g_varchar2
405: ,p_xdf_attribute30 in varchar2 default hr_api.g_varchar2
406: ,p_object_version_number in out nocopy number
407: ,p_drctry_name in varchar2 default hr_api.g_varchar2
408: ,p_kickoff_wrt_prc_flag in varchar2 default hr_api.g_varchar2
409: ,p_upd_cm_sent_dt_flag in varchar2 default hr_api.g_varchar2
403: ,p_xdf_attribute28 in varchar2 default hr_api.g_varchar2
404: ,p_xdf_attribute29 in varchar2 default hr_api.g_varchar2
405: ,p_xdf_attribute30 in varchar2 default hr_api.g_varchar2
406: ,p_object_version_number in out nocopy number
407: ,p_drctry_name in varchar2 default hr_api.g_varchar2
408: ,p_kickoff_wrt_prc_flag in varchar2 default hr_api.g_varchar2
409: ,p_upd_cm_sent_dt_flag in varchar2 default hr_api.g_varchar2
410: ,p_spcl_hndl_flag in varchar2 default hr_api.g_varchar2
411: ,p_ext_global_flag in varchar2 default hr_api.g_varchar2
404: ,p_xdf_attribute29 in varchar2 default hr_api.g_varchar2
405: ,p_xdf_attribute30 in varchar2 default hr_api.g_varchar2
406: ,p_object_version_number in out nocopy number
407: ,p_drctry_name in varchar2 default hr_api.g_varchar2
408: ,p_kickoff_wrt_prc_flag in varchar2 default hr_api.g_varchar2
409: ,p_upd_cm_sent_dt_flag in varchar2 default hr_api.g_varchar2
410: ,p_spcl_hndl_flag in varchar2 default hr_api.g_varchar2
411: ,p_ext_global_flag in varchar2 default hr_api.g_varchar2
412: ,p_cm_display_flag in varchar2 default hr_api.g_varchar2
405: ,p_xdf_attribute30 in varchar2 default hr_api.g_varchar2
406: ,p_object_version_number in out nocopy number
407: ,p_drctry_name in varchar2 default hr_api.g_varchar2
408: ,p_kickoff_wrt_prc_flag in varchar2 default hr_api.g_varchar2
409: ,p_upd_cm_sent_dt_flag in varchar2 default hr_api.g_varchar2
410: ,p_spcl_hndl_flag in varchar2 default hr_api.g_varchar2
411: ,p_ext_global_flag in varchar2 default hr_api.g_varchar2
412: ,p_cm_display_flag in varchar2 default hr_api.g_varchar2
413: ,p_use_eff_dt_for_chgs_flag in varchar2 default hr_api.g_varchar2
406: ,p_object_version_number in out nocopy number
407: ,p_drctry_name in varchar2 default hr_api.g_varchar2
408: ,p_kickoff_wrt_prc_flag in varchar2 default hr_api.g_varchar2
409: ,p_upd_cm_sent_dt_flag in varchar2 default hr_api.g_varchar2
410: ,p_spcl_hndl_flag in varchar2 default hr_api.g_varchar2
411: ,p_ext_global_flag in varchar2 default hr_api.g_varchar2
412: ,p_cm_display_flag in varchar2 default hr_api.g_varchar2
413: ,p_use_eff_dt_for_chgs_flag in varchar2 default hr_api.g_varchar2
414: ,p_ext_post_prcs_rl in number default hr_api.g_number
407: ,p_drctry_name in varchar2 default hr_api.g_varchar2
408: ,p_kickoff_wrt_prc_flag in varchar2 default hr_api.g_varchar2
409: ,p_upd_cm_sent_dt_flag in varchar2 default hr_api.g_varchar2
410: ,p_spcl_hndl_flag in varchar2 default hr_api.g_varchar2
411: ,p_ext_global_flag in varchar2 default hr_api.g_varchar2
412: ,p_cm_display_flag in varchar2 default hr_api.g_varchar2
413: ,p_use_eff_dt_for_chgs_flag in varchar2 default hr_api.g_varchar2
414: ,p_ext_post_prcs_rl in number default hr_api.g_number
415: ,p_effective_date in date
408: ,p_kickoff_wrt_prc_flag in varchar2 default hr_api.g_varchar2
409: ,p_upd_cm_sent_dt_flag in varchar2 default hr_api.g_varchar2
410: ,p_spcl_hndl_flag in varchar2 default hr_api.g_varchar2
411: ,p_ext_global_flag in varchar2 default hr_api.g_varchar2
412: ,p_cm_display_flag in varchar2 default hr_api.g_varchar2
413: ,p_use_eff_dt_for_chgs_flag in varchar2 default hr_api.g_varchar2
414: ,p_ext_post_prcs_rl in number default hr_api.g_number
415: ,p_effective_date in date
416: ) is
409: ,p_upd_cm_sent_dt_flag in varchar2 default hr_api.g_varchar2
410: ,p_spcl_hndl_flag in varchar2 default hr_api.g_varchar2
411: ,p_ext_global_flag in varchar2 default hr_api.g_varchar2
412: ,p_cm_display_flag in varchar2 default hr_api.g_varchar2
413: ,p_use_eff_dt_for_chgs_flag in varchar2 default hr_api.g_varchar2
414: ,p_ext_post_prcs_rl in number default hr_api.g_number
415: ,p_effective_date in date
416: ) is
417: --
410: ,p_spcl_hndl_flag in varchar2 default hr_api.g_varchar2
411: ,p_ext_global_flag in varchar2 default hr_api.g_varchar2
412: ,p_cm_display_flag in varchar2 default hr_api.g_varchar2
413: ,p_use_eff_dt_for_chgs_flag in varchar2 default hr_api.g_varchar2
414: ,p_ext_post_prcs_rl in number default hr_api.g_number
415: ,p_effective_date in date
416: ) is
417: --
418: -- Declare cursors and local variables
499: ,p_ext_post_prcs_rl => p_ext_post_prcs_rl
500: ,p_effective_date => trunc(p_effective_date)
501: );
502: exception
503: when hr_api.cannot_find_prog_unit then
504: hr_api.cannot_find_prog_unit_error
505: (p_module_name => 'UPDATE_EXT_DEFN'
506: ,p_hook_type => 'BP'
507: );
500: ,p_effective_date => trunc(p_effective_date)
501: );
502: exception
503: when hr_api.cannot_find_prog_unit then
504: hr_api.cannot_find_prog_unit_error
505: (p_module_name => 'UPDATE_EXT_DEFN'
506: ,p_hook_type => 'BP'
507: );
508: --
637: ,p_ext_post_prcs_rl => p_ext_post_prcs_rl
638: ,p_effective_date => trunc(p_effective_date)
639: );
640: exception
641: when hr_api.cannot_find_prog_unit then
642: hr_api.cannot_find_prog_unit_error
643: (p_module_name => 'UPDATE_EXT_DEFN'
644: ,p_hook_type => 'AP'
645: );
638: ,p_effective_date => trunc(p_effective_date)
639: );
640: exception
641: when hr_api.cannot_find_prog_unit then
642: hr_api.cannot_find_prog_unit_error
643: (p_module_name => 'UPDATE_EXT_DEFN'
644: ,p_hook_type => 'AP'
645: );
646: --
652: --
653: -- When in validation only mode raise the Validate_Enabled exception
654: --
655: if p_validate then
656: raise hr_api.validate_enabled;
657: end if;
658: --
659: -- Set all output arguments
660: --
663: hr_utility.set_location(' Leaving:'||l_proc, 70);
664: --
665: exception
666: --
667: when hr_api.validate_enabled then
668: --
669: -- As the Validate_Enabled exception has been raised
670: -- we must rollback to the savepoint
671: --
732: ,p_object_version_number => p_object_version_number
733: ,p_effective_date => trunc(p_effective_date)
734: );
735: exception
736: when hr_api.cannot_find_prog_unit then
737: hr_api.cannot_find_prog_unit_error
738: (p_module_name => 'DELETE_EXT_DEFN'
739: ,p_hook_type => 'BP'
740: );
733: ,p_effective_date => trunc(p_effective_date)
734: );
735: exception
736: when hr_api.cannot_find_prog_unit then
737: hr_api.cannot_find_prog_unit_error
738: (p_module_name => 'DELETE_EXT_DEFN'
739: ,p_hook_type => 'BP'
740: );
741: --
760: ,p_object_version_number => l_object_version_number
761: ,p_effective_date => trunc(p_effective_date)
762: );
763: exception
764: when hr_api.cannot_find_prog_unit then
765: hr_api.cannot_find_prog_unit_error
766: (p_module_name => 'DELETE_EXT_DEFN'
767: ,p_hook_type => 'AP'
768: );
761: ,p_effective_date => trunc(p_effective_date)
762: );
763: exception
764: when hr_api.cannot_find_prog_unit then
765: hr_api.cannot_find_prog_unit_error
766: (p_module_name => 'DELETE_EXT_DEFN'
767: ,p_hook_type => 'AP'
768: );
769: --
775: --
776: -- When in validation only mode raise the Validate_Enabled exception
777: --
778: if p_validate then
779: raise hr_api.validate_enabled;
780: end if;
781: --
782: hr_utility.set_location(' Leaving:'||l_proc, 70);
783: --
782: hr_utility.set_location(' Leaving:'||l_proc, 70);
783: --
784: exception
785: --
786: when hr_api.validate_enabled then
787: --
788: -- As the Validate_Enabled exception has been raised
789: -- we must rollback to the savepoint
790: --