eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_EXT_DEFN_API dependencies on HR_API

Line 156: when hr_api.cannot_find_prog_unit then

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'

Line 157: hr_api.cannot_find_prog_unit_error

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: );

Line 295: when hr_api.cannot_find_prog_unit then

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: );

Line 296: hr_api.cannot_find_prog_unit_error

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: --

Line 310: raise hr_api.validate_enabled;

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: --

Line 322: when hr_api.validate_enabled then

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: --

Line 359: ,p_name in varchar2 default hr_api.g_varchar2

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

Line 360: ,p_xml_tag_name 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

Line 361: ,p_xdo_template_id in number default hr_api.g_number

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

Line 362: ,p_data_typ_cd 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

Line 363: ,p_ext_typ_cd 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

Line 364: ,p_output_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
368: ,p_scnd_sort_cd in varchar2 default hr_api.g_varchar2

Line 365: ,p_output_type 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

Line 366: ,p_apnd_rqst_id_flag 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

Line 367: ,p_prmy_sort_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
371: ,p_ext_crit_prfl_id in number default hr_api.g_number

Line 368: ,p_scnd_sort_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
372: ,p_ext_file_id in number default hr_api.g_number

Line 369: ,p_strt_dt 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
373: ,p_business_group_id in number default hr_api.g_number

Line 370: ,p_end_dt 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
374: ,p_legislation_code in varchar2 default hr_api.g_varchar2

Line 371: ,p_ext_crit_prfl_id in number default hr_api.g_number

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

Line 372: ,p_ext_file_id in number default hr_api.g_number

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

Line 373: ,p_business_group_id in number default hr_api.g_number

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

Line 374: ,p_legislation_code 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

Line 375: ,p_xdf_attribute_category 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

Line 376: ,p_xdf_attribute1 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

Line 377: ,p_xdf_attribute2 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

Line 378: ,p_xdf_attribute3 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

Line 379: ,p_xdf_attribute4 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

Line 380: ,p_xdf_attribute5 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

Line 381: ,p_xdf_attribute6 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

Line 382: ,p_xdf_attribute7 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

Line 383: ,p_xdf_attribute8 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

Line 384: ,p_xdf_attribute9 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

Line 385: ,p_xdf_attribute10 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

Line 386: ,p_xdf_attribute11 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

Line 387: ,p_xdf_attribute12 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

Line 388: ,p_xdf_attribute13 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

Line 389: ,p_xdf_attribute14 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

Line 390: ,p_xdf_attribute15 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

Line 391: ,p_xdf_attribute16 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

Line 392: ,p_xdf_attribute17 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

Line 393: ,p_xdf_attribute18 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

Line 394: ,p_xdf_attribute19 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

Line 395: ,p_xdf_attribute20 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

Line 396: ,p_xdf_attribute21 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

Line 397: ,p_xdf_attribute22 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

Line 398: ,p_xdf_attribute23 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

Line 399: ,p_xdf_attribute24 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

Line 400: ,p_xdf_attribute25 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

Line 401: ,p_xdf_attribute26 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

Line 402: ,p_xdf_attribute27 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

Line 403: ,p_xdf_attribute28 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
407: ,p_drctry_name in varchar2 default hr_api.g_varchar2

Line 404: ,p_xdf_attribute29 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

Line 405: ,p_xdf_attribute30 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

Line 407: ,p_drctry_name 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

Line 408: ,p_kickoff_wrt_prc_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

Line 409: ,p_upd_cm_sent_dt_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

Line 410: ,p_spcl_hndl_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

Line 411: ,p_ext_global_flag in varchar2 default hr_api.g_varchar2

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

Line 412: ,p_cm_display_flag 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
416: ) is

Line 413: ,p_use_eff_dt_for_chgs_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
417: --

Line 414: ,p_ext_post_prcs_rl in number default hr_api.g_number

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

Line 503: when hr_api.cannot_find_prog_unit then

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: );

Line 504: hr_api.cannot_find_prog_unit_error

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: --

Line 641: when hr_api.cannot_find_prog_unit then

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: );

Line 642: hr_api.cannot_find_prog_unit_error

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: --

Line 656: raise hr_api.validate_enabled;

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: --

Line 667: when hr_api.validate_enabled then

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: --

Line 736: when hr_api.cannot_find_prog_unit then

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: );

Line 737: hr_api.cannot_find_prog_unit_error

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: --

Line 764: when hr_api.cannot_find_prog_unit then

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: );

Line 765: hr_api.cannot_find_prog_unit_error

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: --

Line 779: raise hr_api.validate_enabled;

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: --

Line 786: when hr_api.validate_enabled then

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: --