152: ,p_effective_date => trunc(p_effective_date));
153: --
154: exception
155: --
156: when hr_api.cannot_find_prog_unit then
157: --
158: hr_api.cannot_find_prog_unit_error
159: (p_module_name => 'CREATE_Participation_Elig'
160: ,p_hook_type => 'BP');
154: exception
155: --
156: when hr_api.cannot_find_prog_unit then
157: --
158: hr_api.cannot_find_prog_unit_error
159: (p_module_name => 'CREATE_Participation_Elig'
160: ,p_hook_type => 'BP');
161: --
162: -- End of API User Hook for the before hook of create_Participation_Elig
288: ,p_effective_date => trunc(p_effective_date));
289: --
290: exception
291: --
292: when hr_api.cannot_find_prog_unit then
293: --
294: hr_api.cannot_find_prog_unit_error
295: (p_module_name => 'CREATE_Participation_Elig'
296: ,p_hook_type => 'AP');
290: exception
291: --
292: when hr_api.cannot_find_prog_unit then
293: --
294: hr_api.cannot_find_prog_unit_error
295: (p_module_name => 'CREATE_Participation_Elig'
296: ,p_hook_type => 'AP');
297: --
298: -- End of API User Hook for the after hook of create_Participation_Elig
303: --
304: -- When in validation only mode raise the Validate_Enabled exception
305: --
306: if p_validate then
307: raise hr_api.validate_enabled;
308: end if;
309: --
310: -- Set all output arguments
311: --
317: hr_utility.set_location(' Leaving:'||l_proc, 70);
318: --
319: exception
320: --
321: when hr_api.validate_enabled then
322: --
323: -- As the Validate_Enabled exception has been raised
324: -- we must rollback to the savepoint
325: --
357: (p_validate in boolean default false
358: ,p_prtn_elig_id in number
359: ,p_effective_start_date out nocopy date
360: ,p_effective_end_date out nocopy date
361: ,p_business_group_id in number default hr_api.g_number
362: ,p_pgm_id in number default hr_api.g_number
363: ,p_pl_id in number default hr_api.g_number
364: ,p_oipl_id in number default hr_api.g_number
365: ,p_ptip_id in number default hr_api.g_number
358: ,p_prtn_elig_id in number
359: ,p_effective_start_date out nocopy date
360: ,p_effective_end_date out nocopy date
361: ,p_business_group_id in number default hr_api.g_number
362: ,p_pgm_id in number default hr_api.g_number
363: ,p_pl_id in number default hr_api.g_number
364: ,p_oipl_id in number default hr_api.g_number
365: ,p_ptip_id in number default hr_api.g_number
366: ,p_plip_id in number default hr_api.g_number
359: ,p_effective_start_date out nocopy date
360: ,p_effective_end_date out nocopy date
361: ,p_business_group_id in number default hr_api.g_number
362: ,p_pgm_id in number default hr_api.g_number
363: ,p_pl_id in number default hr_api.g_number
364: ,p_oipl_id in number default hr_api.g_number
365: ,p_ptip_id in number default hr_api.g_number
366: ,p_plip_id in number default hr_api.g_number
367: ,p_trk_scr_for_inelg_flag in varchar2 default hr_api.g_varchar2
360: ,p_effective_end_date out nocopy date
361: ,p_business_group_id in number default hr_api.g_number
362: ,p_pgm_id in number default hr_api.g_number
363: ,p_pl_id in number default hr_api.g_number
364: ,p_oipl_id in number default hr_api.g_number
365: ,p_ptip_id in number default hr_api.g_number
366: ,p_plip_id in number default hr_api.g_number
367: ,p_trk_scr_for_inelg_flag in varchar2 default hr_api.g_varchar2
368: ,p_prtn_eff_strt_dt_cd in varchar2 default hr_api.g_varchar2
361: ,p_business_group_id in number default hr_api.g_number
362: ,p_pgm_id in number default hr_api.g_number
363: ,p_pl_id in number default hr_api.g_number
364: ,p_oipl_id in number default hr_api.g_number
365: ,p_ptip_id in number default hr_api.g_number
366: ,p_plip_id in number default hr_api.g_number
367: ,p_trk_scr_for_inelg_flag in varchar2 default hr_api.g_varchar2
368: ,p_prtn_eff_strt_dt_cd in varchar2 default hr_api.g_varchar2
369: ,p_prtn_eff_end_dt_cd in varchar2 default hr_api.g_varchar2
362: ,p_pgm_id in number default hr_api.g_number
363: ,p_pl_id in number default hr_api.g_number
364: ,p_oipl_id in number default hr_api.g_number
365: ,p_ptip_id in number default hr_api.g_number
366: ,p_plip_id in number default hr_api.g_number
367: ,p_trk_scr_for_inelg_flag in varchar2 default hr_api.g_varchar2
368: ,p_prtn_eff_strt_dt_cd in varchar2 default hr_api.g_varchar2
369: ,p_prtn_eff_end_dt_cd in varchar2 default hr_api.g_varchar2
370: ,p_prtn_eff_strt_dt_rl in number default hr_api.g_number
363: ,p_pl_id in number default hr_api.g_number
364: ,p_oipl_id in number default hr_api.g_number
365: ,p_ptip_id in number default hr_api.g_number
366: ,p_plip_id in number default hr_api.g_number
367: ,p_trk_scr_for_inelg_flag in varchar2 default hr_api.g_varchar2
368: ,p_prtn_eff_strt_dt_cd in varchar2 default hr_api.g_varchar2
369: ,p_prtn_eff_end_dt_cd in varchar2 default hr_api.g_varchar2
370: ,p_prtn_eff_strt_dt_rl in number default hr_api.g_number
371: ,p_prtn_eff_end_dt_rl in number default hr_api.g_number
364: ,p_oipl_id in number default hr_api.g_number
365: ,p_ptip_id in number default hr_api.g_number
366: ,p_plip_id in number default hr_api.g_number
367: ,p_trk_scr_for_inelg_flag in varchar2 default hr_api.g_varchar2
368: ,p_prtn_eff_strt_dt_cd in varchar2 default hr_api.g_varchar2
369: ,p_prtn_eff_end_dt_cd in varchar2 default hr_api.g_varchar2
370: ,p_prtn_eff_strt_dt_rl in number default hr_api.g_number
371: ,p_prtn_eff_end_dt_rl in number default hr_api.g_number
372: ,p_wait_perd_dt_to_use_cd in varchar2 default hr_api.g_varchar2
365: ,p_ptip_id in number default hr_api.g_number
366: ,p_plip_id in number default hr_api.g_number
367: ,p_trk_scr_for_inelg_flag in varchar2 default hr_api.g_varchar2
368: ,p_prtn_eff_strt_dt_cd in varchar2 default hr_api.g_varchar2
369: ,p_prtn_eff_end_dt_cd in varchar2 default hr_api.g_varchar2
370: ,p_prtn_eff_strt_dt_rl in number default hr_api.g_number
371: ,p_prtn_eff_end_dt_rl in number default hr_api.g_number
372: ,p_wait_perd_dt_to_use_cd in varchar2 default hr_api.g_varchar2
373: ,p_wait_perd_dt_to_use_rl in number default hr_api.g_number
366: ,p_plip_id in number default hr_api.g_number
367: ,p_trk_scr_for_inelg_flag in varchar2 default hr_api.g_varchar2
368: ,p_prtn_eff_strt_dt_cd in varchar2 default hr_api.g_varchar2
369: ,p_prtn_eff_end_dt_cd in varchar2 default hr_api.g_varchar2
370: ,p_prtn_eff_strt_dt_rl in number default hr_api.g_number
371: ,p_prtn_eff_end_dt_rl in number default hr_api.g_number
372: ,p_wait_perd_dt_to_use_cd in varchar2 default hr_api.g_varchar2
373: ,p_wait_perd_dt_to_use_rl in number default hr_api.g_number
374: ,p_wait_perd_val in number default hr_api.g_number
367: ,p_trk_scr_for_inelg_flag in varchar2 default hr_api.g_varchar2
368: ,p_prtn_eff_strt_dt_cd in varchar2 default hr_api.g_varchar2
369: ,p_prtn_eff_end_dt_cd in varchar2 default hr_api.g_varchar2
370: ,p_prtn_eff_strt_dt_rl in number default hr_api.g_number
371: ,p_prtn_eff_end_dt_rl in number default hr_api.g_number
372: ,p_wait_perd_dt_to_use_cd in varchar2 default hr_api.g_varchar2
373: ,p_wait_perd_dt_to_use_rl in number default hr_api.g_number
374: ,p_wait_perd_val in number default hr_api.g_number
375: ,p_wait_perd_uom in varchar2 default hr_api.g_varchar2
368: ,p_prtn_eff_strt_dt_cd in varchar2 default hr_api.g_varchar2
369: ,p_prtn_eff_end_dt_cd in varchar2 default hr_api.g_varchar2
370: ,p_prtn_eff_strt_dt_rl in number default hr_api.g_number
371: ,p_prtn_eff_end_dt_rl in number default hr_api.g_number
372: ,p_wait_perd_dt_to_use_cd in varchar2 default hr_api.g_varchar2
373: ,p_wait_perd_dt_to_use_rl in number default hr_api.g_number
374: ,p_wait_perd_val in number default hr_api.g_number
375: ,p_wait_perd_uom in varchar2 default hr_api.g_varchar2
376: ,p_wait_perd_rl in number default hr_api.g_number
369: ,p_prtn_eff_end_dt_cd in varchar2 default hr_api.g_varchar2
370: ,p_prtn_eff_strt_dt_rl in number default hr_api.g_number
371: ,p_prtn_eff_end_dt_rl in number default hr_api.g_number
372: ,p_wait_perd_dt_to_use_cd in varchar2 default hr_api.g_varchar2
373: ,p_wait_perd_dt_to_use_rl in number default hr_api.g_number
374: ,p_wait_perd_val in number default hr_api.g_number
375: ,p_wait_perd_uom in varchar2 default hr_api.g_varchar2
376: ,p_wait_perd_rl in number default hr_api.g_number
377: ,p_mx_poe_det_dt_cd in varchar2 default hr_api.g_varchar2
370: ,p_prtn_eff_strt_dt_rl in number default hr_api.g_number
371: ,p_prtn_eff_end_dt_rl in number default hr_api.g_number
372: ,p_wait_perd_dt_to_use_cd in varchar2 default hr_api.g_varchar2
373: ,p_wait_perd_dt_to_use_rl in number default hr_api.g_number
374: ,p_wait_perd_val in number default hr_api.g_number
375: ,p_wait_perd_uom in varchar2 default hr_api.g_varchar2
376: ,p_wait_perd_rl in number default hr_api.g_number
377: ,p_mx_poe_det_dt_cd in varchar2 default hr_api.g_varchar2
378: ,p_mx_poe_det_dt_rl in number default hr_api.g_number
371: ,p_prtn_eff_end_dt_rl in number default hr_api.g_number
372: ,p_wait_perd_dt_to_use_cd in varchar2 default hr_api.g_varchar2
373: ,p_wait_perd_dt_to_use_rl in number default hr_api.g_number
374: ,p_wait_perd_val in number default hr_api.g_number
375: ,p_wait_perd_uom in varchar2 default hr_api.g_varchar2
376: ,p_wait_perd_rl in number default hr_api.g_number
377: ,p_mx_poe_det_dt_cd in varchar2 default hr_api.g_varchar2
378: ,p_mx_poe_det_dt_rl in number default hr_api.g_number
379: ,p_mx_poe_val in number default hr_api.g_number
372: ,p_wait_perd_dt_to_use_cd in varchar2 default hr_api.g_varchar2
373: ,p_wait_perd_dt_to_use_rl in number default hr_api.g_number
374: ,p_wait_perd_val in number default hr_api.g_number
375: ,p_wait_perd_uom in varchar2 default hr_api.g_varchar2
376: ,p_wait_perd_rl in number default hr_api.g_number
377: ,p_mx_poe_det_dt_cd in varchar2 default hr_api.g_varchar2
378: ,p_mx_poe_det_dt_rl in number default hr_api.g_number
379: ,p_mx_poe_val in number default hr_api.g_number
380: ,p_mx_poe_uom in varchar2 default hr_api.g_varchar2
373: ,p_wait_perd_dt_to_use_rl in number default hr_api.g_number
374: ,p_wait_perd_val in number default hr_api.g_number
375: ,p_wait_perd_uom in varchar2 default hr_api.g_varchar2
376: ,p_wait_perd_rl in number default hr_api.g_number
377: ,p_mx_poe_det_dt_cd in varchar2 default hr_api.g_varchar2
378: ,p_mx_poe_det_dt_rl in number default hr_api.g_number
379: ,p_mx_poe_val in number default hr_api.g_number
380: ,p_mx_poe_uom in varchar2 default hr_api.g_varchar2
381: ,p_mx_poe_rl in number default hr_api.g_number
374: ,p_wait_perd_val in number default hr_api.g_number
375: ,p_wait_perd_uom in varchar2 default hr_api.g_varchar2
376: ,p_wait_perd_rl in number default hr_api.g_number
377: ,p_mx_poe_det_dt_cd in varchar2 default hr_api.g_varchar2
378: ,p_mx_poe_det_dt_rl in number default hr_api.g_number
379: ,p_mx_poe_val in number default hr_api.g_number
380: ,p_mx_poe_uom in varchar2 default hr_api.g_varchar2
381: ,p_mx_poe_rl in number default hr_api.g_number
382: ,p_mx_poe_apls_cd in varchar2 default hr_api.g_varchar2
375: ,p_wait_perd_uom in varchar2 default hr_api.g_varchar2
376: ,p_wait_perd_rl in number default hr_api.g_number
377: ,p_mx_poe_det_dt_cd in varchar2 default hr_api.g_varchar2
378: ,p_mx_poe_det_dt_rl in number default hr_api.g_number
379: ,p_mx_poe_val in number default hr_api.g_number
380: ,p_mx_poe_uom in varchar2 default hr_api.g_varchar2
381: ,p_mx_poe_rl in number default hr_api.g_number
382: ,p_mx_poe_apls_cd in varchar2 default hr_api.g_varchar2
383: ,p_epa_attribute_category in varchar2 default hr_api.g_varchar2
376: ,p_wait_perd_rl in number default hr_api.g_number
377: ,p_mx_poe_det_dt_cd in varchar2 default hr_api.g_varchar2
378: ,p_mx_poe_det_dt_rl in number default hr_api.g_number
379: ,p_mx_poe_val in number default hr_api.g_number
380: ,p_mx_poe_uom in varchar2 default hr_api.g_varchar2
381: ,p_mx_poe_rl in number default hr_api.g_number
382: ,p_mx_poe_apls_cd in varchar2 default hr_api.g_varchar2
383: ,p_epa_attribute_category in varchar2 default hr_api.g_varchar2
384: ,p_epa_attribute1 in varchar2 default hr_api.g_varchar2
377: ,p_mx_poe_det_dt_cd in varchar2 default hr_api.g_varchar2
378: ,p_mx_poe_det_dt_rl in number default hr_api.g_number
379: ,p_mx_poe_val in number default hr_api.g_number
380: ,p_mx_poe_uom in varchar2 default hr_api.g_varchar2
381: ,p_mx_poe_rl in number default hr_api.g_number
382: ,p_mx_poe_apls_cd in varchar2 default hr_api.g_varchar2
383: ,p_epa_attribute_category in varchar2 default hr_api.g_varchar2
384: ,p_epa_attribute1 in varchar2 default hr_api.g_varchar2
385: ,p_epa_attribute2 in varchar2 default hr_api.g_varchar2
378: ,p_mx_poe_det_dt_rl in number default hr_api.g_number
379: ,p_mx_poe_val in number default hr_api.g_number
380: ,p_mx_poe_uom in varchar2 default hr_api.g_varchar2
381: ,p_mx_poe_rl in number default hr_api.g_number
382: ,p_mx_poe_apls_cd in varchar2 default hr_api.g_varchar2
383: ,p_epa_attribute_category in varchar2 default hr_api.g_varchar2
384: ,p_epa_attribute1 in varchar2 default hr_api.g_varchar2
385: ,p_epa_attribute2 in varchar2 default hr_api.g_varchar2
386: ,p_epa_attribute3 in varchar2 default hr_api.g_varchar2
379: ,p_mx_poe_val in number default hr_api.g_number
380: ,p_mx_poe_uom in varchar2 default hr_api.g_varchar2
381: ,p_mx_poe_rl in number default hr_api.g_number
382: ,p_mx_poe_apls_cd in varchar2 default hr_api.g_varchar2
383: ,p_epa_attribute_category in varchar2 default hr_api.g_varchar2
384: ,p_epa_attribute1 in varchar2 default hr_api.g_varchar2
385: ,p_epa_attribute2 in varchar2 default hr_api.g_varchar2
386: ,p_epa_attribute3 in varchar2 default hr_api.g_varchar2
387: ,p_epa_attribute4 in varchar2 default hr_api.g_varchar2
380: ,p_mx_poe_uom in varchar2 default hr_api.g_varchar2
381: ,p_mx_poe_rl in number default hr_api.g_number
382: ,p_mx_poe_apls_cd in varchar2 default hr_api.g_varchar2
383: ,p_epa_attribute_category in varchar2 default hr_api.g_varchar2
384: ,p_epa_attribute1 in varchar2 default hr_api.g_varchar2
385: ,p_epa_attribute2 in varchar2 default hr_api.g_varchar2
386: ,p_epa_attribute3 in varchar2 default hr_api.g_varchar2
387: ,p_epa_attribute4 in varchar2 default hr_api.g_varchar2
388: ,p_epa_attribute5 in varchar2 default hr_api.g_varchar2
381: ,p_mx_poe_rl in number default hr_api.g_number
382: ,p_mx_poe_apls_cd in varchar2 default hr_api.g_varchar2
383: ,p_epa_attribute_category in varchar2 default hr_api.g_varchar2
384: ,p_epa_attribute1 in varchar2 default hr_api.g_varchar2
385: ,p_epa_attribute2 in varchar2 default hr_api.g_varchar2
386: ,p_epa_attribute3 in varchar2 default hr_api.g_varchar2
387: ,p_epa_attribute4 in varchar2 default hr_api.g_varchar2
388: ,p_epa_attribute5 in varchar2 default hr_api.g_varchar2
389: ,p_epa_attribute6 in varchar2 default hr_api.g_varchar2
382: ,p_mx_poe_apls_cd in varchar2 default hr_api.g_varchar2
383: ,p_epa_attribute_category in varchar2 default hr_api.g_varchar2
384: ,p_epa_attribute1 in varchar2 default hr_api.g_varchar2
385: ,p_epa_attribute2 in varchar2 default hr_api.g_varchar2
386: ,p_epa_attribute3 in varchar2 default hr_api.g_varchar2
387: ,p_epa_attribute4 in varchar2 default hr_api.g_varchar2
388: ,p_epa_attribute5 in varchar2 default hr_api.g_varchar2
389: ,p_epa_attribute6 in varchar2 default hr_api.g_varchar2
390: ,p_epa_attribute7 in varchar2 default hr_api.g_varchar2
383: ,p_epa_attribute_category in varchar2 default hr_api.g_varchar2
384: ,p_epa_attribute1 in varchar2 default hr_api.g_varchar2
385: ,p_epa_attribute2 in varchar2 default hr_api.g_varchar2
386: ,p_epa_attribute3 in varchar2 default hr_api.g_varchar2
387: ,p_epa_attribute4 in varchar2 default hr_api.g_varchar2
388: ,p_epa_attribute5 in varchar2 default hr_api.g_varchar2
389: ,p_epa_attribute6 in varchar2 default hr_api.g_varchar2
390: ,p_epa_attribute7 in varchar2 default hr_api.g_varchar2
391: ,p_epa_attribute8 in varchar2 default hr_api.g_varchar2
384: ,p_epa_attribute1 in varchar2 default hr_api.g_varchar2
385: ,p_epa_attribute2 in varchar2 default hr_api.g_varchar2
386: ,p_epa_attribute3 in varchar2 default hr_api.g_varchar2
387: ,p_epa_attribute4 in varchar2 default hr_api.g_varchar2
388: ,p_epa_attribute5 in varchar2 default hr_api.g_varchar2
389: ,p_epa_attribute6 in varchar2 default hr_api.g_varchar2
390: ,p_epa_attribute7 in varchar2 default hr_api.g_varchar2
391: ,p_epa_attribute8 in varchar2 default hr_api.g_varchar2
392: ,p_epa_attribute9 in varchar2 default hr_api.g_varchar2
385: ,p_epa_attribute2 in varchar2 default hr_api.g_varchar2
386: ,p_epa_attribute3 in varchar2 default hr_api.g_varchar2
387: ,p_epa_attribute4 in varchar2 default hr_api.g_varchar2
388: ,p_epa_attribute5 in varchar2 default hr_api.g_varchar2
389: ,p_epa_attribute6 in varchar2 default hr_api.g_varchar2
390: ,p_epa_attribute7 in varchar2 default hr_api.g_varchar2
391: ,p_epa_attribute8 in varchar2 default hr_api.g_varchar2
392: ,p_epa_attribute9 in varchar2 default hr_api.g_varchar2
393: ,p_epa_attribute10 in varchar2 default hr_api.g_varchar2
386: ,p_epa_attribute3 in varchar2 default hr_api.g_varchar2
387: ,p_epa_attribute4 in varchar2 default hr_api.g_varchar2
388: ,p_epa_attribute5 in varchar2 default hr_api.g_varchar2
389: ,p_epa_attribute6 in varchar2 default hr_api.g_varchar2
390: ,p_epa_attribute7 in varchar2 default hr_api.g_varchar2
391: ,p_epa_attribute8 in varchar2 default hr_api.g_varchar2
392: ,p_epa_attribute9 in varchar2 default hr_api.g_varchar2
393: ,p_epa_attribute10 in varchar2 default hr_api.g_varchar2
394: ,p_epa_attribute11 in varchar2 default hr_api.g_varchar2
387: ,p_epa_attribute4 in varchar2 default hr_api.g_varchar2
388: ,p_epa_attribute5 in varchar2 default hr_api.g_varchar2
389: ,p_epa_attribute6 in varchar2 default hr_api.g_varchar2
390: ,p_epa_attribute7 in varchar2 default hr_api.g_varchar2
391: ,p_epa_attribute8 in varchar2 default hr_api.g_varchar2
392: ,p_epa_attribute9 in varchar2 default hr_api.g_varchar2
393: ,p_epa_attribute10 in varchar2 default hr_api.g_varchar2
394: ,p_epa_attribute11 in varchar2 default hr_api.g_varchar2
395: ,p_epa_attribute12 in varchar2 default hr_api.g_varchar2
388: ,p_epa_attribute5 in varchar2 default hr_api.g_varchar2
389: ,p_epa_attribute6 in varchar2 default hr_api.g_varchar2
390: ,p_epa_attribute7 in varchar2 default hr_api.g_varchar2
391: ,p_epa_attribute8 in varchar2 default hr_api.g_varchar2
392: ,p_epa_attribute9 in varchar2 default hr_api.g_varchar2
393: ,p_epa_attribute10 in varchar2 default hr_api.g_varchar2
394: ,p_epa_attribute11 in varchar2 default hr_api.g_varchar2
395: ,p_epa_attribute12 in varchar2 default hr_api.g_varchar2
396: ,p_epa_attribute13 in varchar2 default hr_api.g_varchar2
389: ,p_epa_attribute6 in varchar2 default hr_api.g_varchar2
390: ,p_epa_attribute7 in varchar2 default hr_api.g_varchar2
391: ,p_epa_attribute8 in varchar2 default hr_api.g_varchar2
392: ,p_epa_attribute9 in varchar2 default hr_api.g_varchar2
393: ,p_epa_attribute10 in varchar2 default hr_api.g_varchar2
394: ,p_epa_attribute11 in varchar2 default hr_api.g_varchar2
395: ,p_epa_attribute12 in varchar2 default hr_api.g_varchar2
396: ,p_epa_attribute13 in varchar2 default hr_api.g_varchar2
397: ,p_epa_attribute14 in varchar2 default hr_api.g_varchar2
390: ,p_epa_attribute7 in varchar2 default hr_api.g_varchar2
391: ,p_epa_attribute8 in varchar2 default hr_api.g_varchar2
392: ,p_epa_attribute9 in varchar2 default hr_api.g_varchar2
393: ,p_epa_attribute10 in varchar2 default hr_api.g_varchar2
394: ,p_epa_attribute11 in varchar2 default hr_api.g_varchar2
395: ,p_epa_attribute12 in varchar2 default hr_api.g_varchar2
396: ,p_epa_attribute13 in varchar2 default hr_api.g_varchar2
397: ,p_epa_attribute14 in varchar2 default hr_api.g_varchar2
398: ,p_epa_attribute15 in varchar2 default hr_api.g_varchar2
391: ,p_epa_attribute8 in varchar2 default hr_api.g_varchar2
392: ,p_epa_attribute9 in varchar2 default hr_api.g_varchar2
393: ,p_epa_attribute10 in varchar2 default hr_api.g_varchar2
394: ,p_epa_attribute11 in varchar2 default hr_api.g_varchar2
395: ,p_epa_attribute12 in varchar2 default hr_api.g_varchar2
396: ,p_epa_attribute13 in varchar2 default hr_api.g_varchar2
397: ,p_epa_attribute14 in varchar2 default hr_api.g_varchar2
398: ,p_epa_attribute15 in varchar2 default hr_api.g_varchar2
399: ,p_epa_attribute16 in varchar2 default hr_api.g_varchar2
392: ,p_epa_attribute9 in varchar2 default hr_api.g_varchar2
393: ,p_epa_attribute10 in varchar2 default hr_api.g_varchar2
394: ,p_epa_attribute11 in varchar2 default hr_api.g_varchar2
395: ,p_epa_attribute12 in varchar2 default hr_api.g_varchar2
396: ,p_epa_attribute13 in varchar2 default hr_api.g_varchar2
397: ,p_epa_attribute14 in varchar2 default hr_api.g_varchar2
398: ,p_epa_attribute15 in varchar2 default hr_api.g_varchar2
399: ,p_epa_attribute16 in varchar2 default hr_api.g_varchar2
400: ,p_epa_attribute17 in varchar2 default hr_api.g_varchar2
393: ,p_epa_attribute10 in varchar2 default hr_api.g_varchar2
394: ,p_epa_attribute11 in varchar2 default hr_api.g_varchar2
395: ,p_epa_attribute12 in varchar2 default hr_api.g_varchar2
396: ,p_epa_attribute13 in varchar2 default hr_api.g_varchar2
397: ,p_epa_attribute14 in varchar2 default hr_api.g_varchar2
398: ,p_epa_attribute15 in varchar2 default hr_api.g_varchar2
399: ,p_epa_attribute16 in varchar2 default hr_api.g_varchar2
400: ,p_epa_attribute17 in varchar2 default hr_api.g_varchar2
401: ,p_epa_attribute18 in varchar2 default hr_api.g_varchar2
394: ,p_epa_attribute11 in varchar2 default hr_api.g_varchar2
395: ,p_epa_attribute12 in varchar2 default hr_api.g_varchar2
396: ,p_epa_attribute13 in varchar2 default hr_api.g_varchar2
397: ,p_epa_attribute14 in varchar2 default hr_api.g_varchar2
398: ,p_epa_attribute15 in varchar2 default hr_api.g_varchar2
399: ,p_epa_attribute16 in varchar2 default hr_api.g_varchar2
400: ,p_epa_attribute17 in varchar2 default hr_api.g_varchar2
401: ,p_epa_attribute18 in varchar2 default hr_api.g_varchar2
402: ,p_epa_attribute19 in varchar2 default hr_api.g_varchar2
395: ,p_epa_attribute12 in varchar2 default hr_api.g_varchar2
396: ,p_epa_attribute13 in varchar2 default hr_api.g_varchar2
397: ,p_epa_attribute14 in varchar2 default hr_api.g_varchar2
398: ,p_epa_attribute15 in varchar2 default hr_api.g_varchar2
399: ,p_epa_attribute16 in varchar2 default hr_api.g_varchar2
400: ,p_epa_attribute17 in varchar2 default hr_api.g_varchar2
401: ,p_epa_attribute18 in varchar2 default hr_api.g_varchar2
402: ,p_epa_attribute19 in varchar2 default hr_api.g_varchar2
403: ,p_epa_attribute20 in varchar2 default hr_api.g_varchar2
396: ,p_epa_attribute13 in varchar2 default hr_api.g_varchar2
397: ,p_epa_attribute14 in varchar2 default hr_api.g_varchar2
398: ,p_epa_attribute15 in varchar2 default hr_api.g_varchar2
399: ,p_epa_attribute16 in varchar2 default hr_api.g_varchar2
400: ,p_epa_attribute17 in varchar2 default hr_api.g_varchar2
401: ,p_epa_attribute18 in varchar2 default hr_api.g_varchar2
402: ,p_epa_attribute19 in varchar2 default hr_api.g_varchar2
403: ,p_epa_attribute20 in varchar2 default hr_api.g_varchar2
404: ,p_epa_attribute21 in varchar2 default hr_api.g_varchar2
397: ,p_epa_attribute14 in varchar2 default hr_api.g_varchar2
398: ,p_epa_attribute15 in varchar2 default hr_api.g_varchar2
399: ,p_epa_attribute16 in varchar2 default hr_api.g_varchar2
400: ,p_epa_attribute17 in varchar2 default hr_api.g_varchar2
401: ,p_epa_attribute18 in varchar2 default hr_api.g_varchar2
402: ,p_epa_attribute19 in varchar2 default hr_api.g_varchar2
403: ,p_epa_attribute20 in varchar2 default hr_api.g_varchar2
404: ,p_epa_attribute21 in varchar2 default hr_api.g_varchar2
405: ,p_epa_attribute22 in varchar2 default hr_api.g_varchar2
398: ,p_epa_attribute15 in varchar2 default hr_api.g_varchar2
399: ,p_epa_attribute16 in varchar2 default hr_api.g_varchar2
400: ,p_epa_attribute17 in varchar2 default hr_api.g_varchar2
401: ,p_epa_attribute18 in varchar2 default hr_api.g_varchar2
402: ,p_epa_attribute19 in varchar2 default hr_api.g_varchar2
403: ,p_epa_attribute20 in varchar2 default hr_api.g_varchar2
404: ,p_epa_attribute21 in varchar2 default hr_api.g_varchar2
405: ,p_epa_attribute22 in varchar2 default hr_api.g_varchar2
406: ,p_epa_attribute23 in varchar2 default hr_api.g_varchar2
399: ,p_epa_attribute16 in varchar2 default hr_api.g_varchar2
400: ,p_epa_attribute17 in varchar2 default hr_api.g_varchar2
401: ,p_epa_attribute18 in varchar2 default hr_api.g_varchar2
402: ,p_epa_attribute19 in varchar2 default hr_api.g_varchar2
403: ,p_epa_attribute20 in varchar2 default hr_api.g_varchar2
404: ,p_epa_attribute21 in varchar2 default hr_api.g_varchar2
405: ,p_epa_attribute22 in varchar2 default hr_api.g_varchar2
406: ,p_epa_attribute23 in varchar2 default hr_api.g_varchar2
407: ,p_epa_attribute24 in varchar2 default hr_api.g_varchar2
400: ,p_epa_attribute17 in varchar2 default hr_api.g_varchar2
401: ,p_epa_attribute18 in varchar2 default hr_api.g_varchar2
402: ,p_epa_attribute19 in varchar2 default hr_api.g_varchar2
403: ,p_epa_attribute20 in varchar2 default hr_api.g_varchar2
404: ,p_epa_attribute21 in varchar2 default hr_api.g_varchar2
405: ,p_epa_attribute22 in varchar2 default hr_api.g_varchar2
406: ,p_epa_attribute23 in varchar2 default hr_api.g_varchar2
407: ,p_epa_attribute24 in varchar2 default hr_api.g_varchar2
408: ,p_epa_attribute25 in varchar2 default hr_api.g_varchar2
401: ,p_epa_attribute18 in varchar2 default hr_api.g_varchar2
402: ,p_epa_attribute19 in varchar2 default hr_api.g_varchar2
403: ,p_epa_attribute20 in varchar2 default hr_api.g_varchar2
404: ,p_epa_attribute21 in varchar2 default hr_api.g_varchar2
405: ,p_epa_attribute22 in varchar2 default hr_api.g_varchar2
406: ,p_epa_attribute23 in varchar2 default hr_api.g_varchar2
407: ,p_epa_attribute24 in varchar2 default hr_api.g_varchar2
408: ,p_epa_attribute25 in varchar2 default hr_api.g_varchar2
409: ,p_epa_attribute26 in varchar2 default hr_api.g_varchar2
402: ,p_epa_attribute19 in varchar2 default hr_api.g_varchar2
403: ,p_epa_attribute20 in varchar2 default hr_api.g_varchar2
404: ,p_epa_attribute21 in varchar2 default hr_api.g_varchar2
405: ,p_epa_attribute22 in varchar2 default hr_api.g_varchar2
406: ,p_epa_attribute23 in varchar2 default hr_api.g_varchar2
407: ,p_epa_attribute24 in varchar2 default hr_api.g_varchar2
408: ,p_epa_attribute25 in varchar2 default hr_api.g_varchar2
409: ,p_epa_attribute26 in varchar2 default hr_api.g_varchar2
410: ,p_epa_attribute27 in varchar2 default hr_api.g_varchar2
403: ,p_epa_attribute20 in varchar2 default hr_api.g_varchar2
404: ,p_epa_attribute21 in varchar2 default hr_api.g_varchar2
405: ,p_epa_attribute22 in varchar2 default hr_api.g_varchar2
406: ,p_epa_attribute23 in varchar2 default hr_api.g_varchar2
407: ,p_epa_attribute24 in varchar2 default hr_api.g_varchar2
408: ,p_epa_attribute25 in varchar2 default hr_api.g_varchar2
409: ,p_epa_attribute26 in varchar2 default hr_api.g_varchar2
410: ,p_epa_attribute27 in varchar2 default hr_api.g_varchar2
411: ,p_epa_attribute28 in varchar2 default hr_api.g_varchar2
404: ,p_epa_attribute21 in varchar2 default hr_api.g_varchar2
405: ,p_epa_attribute22 in varchar2 default hr_api.g_varchar2
406: ,p_epa_attribute23 in varchar2 default hr_api.g_varchar2
407: ,p_epa_attribute24 in varchar2 default hr_api.g_varchar2
408: ,p_epa_attribute25 in varchar2 default hr_api.g_varchar2
409: ,p_epa_attribute26 in varchar2 default hr_api.g_varchar2
410: ,p_epa_attribute27 in varchar2 default hr_api.g_varchar2
411: ,p_epa_attribute28 in varchar2 default hr_api.g_varchar2
412: ,p_epa_attribute29 in varchar2 default hr_api.g_varchar2
405: ,p_epa_attribute22 in varchar2 default hr_api.g_varchar2
406: ,p_epa_attribute23 in varchar2 default hr_api.g_varchar2
407: ,p_epa_attribute24 in varchar2 default hr_api.g_varchar2
408: ,p_epa_attribute25 in varchar2 default hr_api.g_varchar2
409: ,p_epa_attribute26 in varchar2 default hr_api.g_varchar2
410: ,p_epa_attribute27 in varchar2 default hr_api.g_varchar2
411: ,p_epa_attribute28 in varchar2 default hr_api.g_varchar2
412: ,p_epa_attribute29 in varchar2 default hr_api.g_varchar2
413: ,p_epa_attribute30 in varchar2 default hr_api.g_varchar2
406: ,p_epa_attribute23 in varchar2 default hr_api.g_varchar2
407: ,p_epa_attribute24 in varchar2 default hr_api.g_varchar2
408: ,p_epa_attribute25 in varchar2 default hr_api.g_varchar2
409: ,p_epa_attribute26 in varchar2 default hr_api.g_varchar2
410: ,p_epa_attribute27 in varchar2 default hr_api.g_varchar2
411: ,p_epa_attribute28 in varchar2 default hr_api.g_varchar2
412: ,p_epa_attribute29 in varchar2 default hr_api.g_varchar2
413: ,p_epa_attribute30 in varchar2 default hr_api.g_varchar2
414: ,p_object_version_number in out nocopy number
407: ,p_epa_attribute24 in varchar2 default hr_api.g_varchar2
408: ,p_epa_attribute25 in varchar2 default hr_api.g_varchar2
409: ,p_epa_attribute26 in varchar2 default hr_api.g_varchar2
410: ,p_epa_attribute27 in varchar2 default hr_api.g_varchar2
411: ,p_epa_attribute28 in varchar2 default hr_api.g_varchar2
412: ,p_epa_attribute29 in varchar2 default hr_api.g_varchar2
413: ,p_epa_attribute30 in varchar2 default hr_api.g_varchar2
414: ,p_object_version_number in out nocopy number
415: ,p_effective_date in date
408: ,p_epa_attribute25 in varchar2 default hr_api.g_varchar2
409: ,p_epa_attribute26 in varchar2 default hr_api.g_varchar2
410: ,p_epa_attribute27 in varchar2 default hr_api.g_varchar2
411: ,p_epa_attribute28 in varchar2 default hr_api.g_varchar2
412: ,p_epa_attribute29 in varchar2 default hr_api.g_varchar2
413: ,p_epa_attribute30 in varchar2 default hr_api.g_varchar2
414: ,p_object_version_number in out nocopy number
415: ,p_effective_date in date
416: ,p_datetrack_mode in varchar2) is
409: ,p_epa_attribute26 in varchar2 default hr_api.g_varchar2
410: ,p_epa_attribute27 in varchar2 default hr_api.g_varchar2
411: ,p_epa_attribute28 in varchar2 default hr_api.g_varchar2
412: ,p_epa_attribute29 in varchar2 default hr_api.g_varchar2
413: ,p_epa_attribute30 in varchar2 default hr_api.g_varchar2
414: ,p_object_version_number in out nocopy number
415: ,p_effective_date in date
416: ,p_datetrack_mode in varchar2) is
417: --
500: ,p_datetrack_mode => p_datetrack_mode);
501: --
502: exception
503: --
504: when hr_api.cannot_find_prog_unit then
505: --
506: hr_api.cannot_find_prog_unit_error
507: (p_module_name => 'UPDATE_Participation_Elig'
508: ,p_hook_type => 'BP');
502: exception
503: --
504: when hr_api.cannot_find_prog_unit then
505: --
506: hr_api.cannot_find_prog_unit_error
507: (p_module_name => 'UPDATE_Participation_Elig'
508: ,p_hook_type => 'BP');
509: --
510: -- End of API User Hook for the before hook of update_Participation_Elig
638: ,p_datetrack_mode => p_datetrack_mode);
639: --
640: exception
641: --
642: when hr_api.cannot_find_prog_unit then
643: --
644: hr_api.cannot_find_prog_unit_error
645: (p_module_name => 'UPDATE_Participation_Elig'
646: ,p_hook_type => 'AP');
640: exception
641: --
642: when hr_api.cannot_find_prog_unit then
643: --
644: hr_api.cannot_find_prog_unit_error
645: (p_module_name => 'UPDATE_Participation_Elig'
646: ,p_hook_type => 'AP');
647: --
648: -- End of API User Hook for the after hook of update_Participation_Elig
653: --
654: -- When in validation only mode raise the Validate_Enabled exception
655: --
656: if p_validate then
657: raise hr_api.validate_enabled;
658: end if;
659: --
660: -- Set all output arguments
661: --
666: hr_utility.set_location(' Leaving:'||l_proc, 70);
667: --
668: exception
669: --
670: when hr_api.validate_enabled then
671: --
672: -- As the Validate_Enabled exception has been raised
673: -- we must rollback to the savepoint
674: --
740: ,p_datetrack_mode => p_datetrack_mode);
741: --
742: exception
743: --
744: when hr_api.cannot_find_prog_unit then
745: --
746: hr_api.cannot_find_prog_unit_error
747: (p_module_name => 'DELETE_Participation_Elig'
748: ,p_hook_type => 'BP');
742: exception
743: --
744: when hr_api.cannot_find_prog_unit then
745: --
746: hr_api.cannot_find_prog_unit_error
747: (p_module_name => 'DELETE_Participation_Elig'
748: ,p_hook_type => 'BP');
749: --
750: -- End of API User Hook for the before hook of delete_Participation_Elig
772: ,p_datetrack_mode => p_datetrack_mode);
773: --
774: exception
775: --
776: when hr_api.cannot_find_prog_unit then
777: --
778: hr_api.cannot_find_prog_unit_error
779: (p_module_name => 'DELETE_Participation_Elig'
780: ,p_hook_type => 'AP');
774: exception
775: --
776: when hr_api.cannot_find_prog_unit then
777: --
778: hr_api.cannot_find_prog_unit_error
779: (p_module_name => 'DELETE_Participation_Elig'
780: ,p_hook_type => 'AP');
781: --
782: -- End of API User Hook for the after hook of delete_Participation_Elig
787: --
788: -- When in validation only mode raise the Validate_Enabled exception
789: --
790: if p_validate then
791: raise hr_api.validate_enabled;
792: end if;
793: --
794: hr_utility.set_location(' Leaving:'||l_proc, 70);
795: --
794: hr_utility.set_location(' Leaving:'||l_proc, 70);
795: --
796: exception
797: --
798: when hr_api.validate_enabled then
799: --
800: -- As the Validate_Enabled exception has been raised
801: -- we must rollback to the savepoint
802: --