161: ,p_effective_date => trunc(p_effective_date));
162: --
163: exception
164: --
165: when hr_api.cannot_find_prog_unit then
166: --
167: hr_api.cannot_find_prog_unit_error
168: (p_module_name => 'CREATE_ELIG_TO_PRTE_REASON'
169: ,p_hook_type => 'BP');
163: exception
164: --
165: when hr_api.cannot_find_prog_unit then
166: --
167: hr_api.cannot_find_prog_unit_error
168: (p_module_name => 'CREATE_ELIG_TO_PRTE_REASON'
169: ,p_hook_type => 'BP');
170: --
171: -- End of API User Hook for the before hook of create_ELIG_TO_PRTE_REASON
307: ,p_effective_date => trunc(p_effective_date));
308: --
309: exception
310: --
311: when hr_api.cannot_find_prog_unit then
312: --
313: hr_api.cannot_find_prog_unit_error
314: (p_module_name => 'CREATE_ELIG_TO_PRTE_REASON'
315: ,p_hook_type => 'AP');
309: exception
310: --
311: when hr_api.cannot_find_prog_unit then
312: --
313: hr_api.cannot_find_prog_unit_error
314: (p_module_name => 'CREATE_ELIG_TO_PRTE_REASON'
315: ,p_hook_type => 'AP');
316: --
317: -- End of API User Hook for the after hook of create_ELIG_TO_PRTE_REASON
322: --
323: -- When in validation only mode raise the Validate_Enabled exception
324: --
325: if p_validate then
326: raise hr_api.validate_enabled;
327: end if;
328: --
329: -- Set all output arguments
330: --
336: hr_utility.set_location(' Leaving:'||l_proc, 70);
337: --
338: exception
339: --
340: when hr_api.validate_enabled then
341: --
342: -- As the Validate_Enabled exception has been raised
343: -- we must rollback to the savepoint
344: --
375: (p_validate in boolean default false
376: ,p_elig_to_prte_rsn_id in number
377: ,p_effective_start_date out nocopy date
378: ,p_effective_end_date out nocopy date
379: ,p_business_group_id in number default hr_api.g_number
380: ,p_ler_id in number default hr_api.g_number
381: ,p_oipl_id in number default hr_api.g_number
382: ,p_pgm_id in number default hr_api.g_number
383: ,p_pl_id in number default hr_api.g_number
376: ,p_elig_to_prte_rsn_id in number
377: ,p_effective_start_date out nocopy date
378: ,p_effective_end_date out nocopy date
379: ,p_business_group_id in number default hr_api.g_number
380: ,p_ler_id in number default hr_api.g_number
381: ,p_oipl_id in number default hr_api.g_number
382: ,p_pgm_id in number default hr_api.g_number
383: ,p_pl_id in number default hr_api.g_number
384: ,p_ptip_id in number default hr_api.g_number
377: ,p_effective_start_date out nocopy date
378: ,p_effective_end_date out nocopy date
379: ,p_business_group_id in number default hr_api.g_number
380: ,p_ler_id in number default hr_api.g_number
381: ,p_oipl_id in number default hr_api.g_number
382: ,p_pgm_id in number default hr_api.g_number
383: ,p_pl_id in number default hr_api.g_number
384: ,p_ptip_id in number default hr_api.g_number
385: ,p_plip_id in number default hr_api.g_number
378: ,p_effective_end_date out nocopy date
379: ,p_business_group_id in number default hr_api.g_number
380: ,p_ler_id in number default hr_api.g_number
381: ,p_oipl_id in number default hr_api.g_number
382: ,p_pgm_id in number default hr_api.g_number
383: ,p_pl_id in number default hr_api.g_number
384: ,p_ptip_id in number default hr_api.g_number
385: ,p_plip_id in number default hr_api.g_number
386: ,p_ignr_prtn_ovrid_flag in varchar2 default hr_api.g_varchar2
379: ,p_business_group_id in number default hr_api.g_number
380: ,p_ler_id in number default hr_api.g_number
381: ,p_oipl_id in number default hr_api.g_number
382: ,p_pgm_id in number default hr_api.g_number
383: ,p_pl_id in number default hr_api.g_number
384: ,p_ptip_id in number default hr_api.g_number
385: ,p_plip_id in number default hr_api.g_number
386: ,p_ignr_prtn_ovrid_flag in varchar2 default hr_api.g_varchar2
387: ,p_elig_inelig_cd in varchar2 default hr_api.g_varchar2
380: ,p_ler_id in number default hr_api.g_number
381: ,p_oipl_id in number default hr_api.g_number
382: ,p_pgm_id in number default hr_api.g_number
383: ,p_pl_id in number default hr_api.g_number
384: ,p_ptip_id in number default hr_api.g_number
385: ,p_plip_id in number default hr_api.g_number
386: ,p_ignr_prtn_ovrid_flag in varchar2 default hr_api.g_varchar2
387: ,p_elig_inelig_cd in varchar2 default hr_api.g_varchar2
388: ,p_prtn_eff_strt_dt_cd in varchar2 default hr_api.g_varchar2
381: ,p_oipl_id in number default hr_api.g_number
382: ,p_pgm_id in number default hr_api.g_number
383: ,p_pl_id in number default hr_api.g_number
384: ,p_ptip_id in number default hr_api.g_number
385: ,p_plip_id in number default hr_api.g_number
386: ,p_ignr_prtn_ovrid_flag in varchar2 default hr_api.g_varchar2
387: ,p_elig_inelig_cd in varchar2 default hr_api.g_varchar2
388: ,p_prtn_eff_strt_dt_cd in varchar2 default hr_api.g_varchar2
389: ,p_prtn_eff_strt_dt_rl in number default hr_api.g_number
382: ,p_pgm_id in number default hr_api.g_number
383: ,p_pl_id in number default hr_api.g_number
384: ,p_ptip_id in number default hr_api.g_number
385: ,p_plip_id in number default hr_api.g_number
386: ,p_ignr_prtn_ovrid_flag in varchar2 default hr_api.g_varchar2
387: ,p_elig_inelig_cd in varchar2 default hr_api.g_varchar2
388: ,p_prtn_eff_strt_dt_cd in varchar2 default hr_api.g_varchar2
389: ,p_prtn_eff_strt_dt_rl in number default hr_api.g_number
390: ,p_prtn_eff_end_dt_cd in varchar2 default hr_api.g_varchar2
383: ,p_pl_id in number default hr_api.g_number
384: ,p_ptip_id in number default hr_api.g_number
385: ,p_plip_id in number default hr_api.g_number
386: ,p_ignr_prtn_ovrid_flag in varchar2 default hr_api.g_varchar2
387: ,p_elig_inelig_cd in varchar2 default hr_api.g_varchar2
388: ,p_prtn_eff_strt_dt_cd in varchar2 default hr_api.g_varchar2
389: ,p_prtn_eff_strt_dt_rl in number default hr_api.g_number
390: ,p_prtn_eff_end_dt_cd in varchar2 default hr_api.g_varchar2
391: ,p_prtn_eff_end_dt_rl in number default hr_api.g_number
384: ,p_ptip_id in number default hr_api.g_number
385: ,p_plip_id in number default hr_api.g_number
386: ,p_ignr_prtn_ovrid_flag in varchar2 default hr_api.g_varchar2
387: ,p_elig_inelig_cd in varchar2 default hr_api.g_varchar2
388: ,p_prtn_eff_strt_dt_cd in varchar2 default hr_api.g_varchar2
389: ,p_prtn_eff_strt_dt_rl in number default hr_api.g_number
390: ,p_prtn_eff_end_dt_cd in varchar2 default hr_api.g_varchar2
391: ,p_prtn_eff_end_dt_rl in number default hr_api.g_number
392: ,p_wait_perd_dt_to_use_cd in varchar2 default hr_api.g_varchar2
385: ,p_plip_id in number default hr_api.g_number
386: ,p_ignr_prtn_ovrid_flag in varchar2 default hr_api.g_varchar2
387: ,p_elig_inelig_cd in varchar2 default hr_api.g_varchar2
388: ,p_prtn_eff_strt_dt_cd in varchar2 default hr_api.g_varchar2
389: ,p_prtn_eff_strt_dt_rl in number default hr_api.g_number
390: ,p_prtn_eff_end_dt_cd in varchar2 default hr_api.g_varchar2
391: ,p_prtn_eff_end_dt_rl in number default hr_api.g_number
392: ,p_wait_perd_dt_to_use_cd in varchar2 default hr_api.g_varchar2
393: ,p_wait_perd_dt_to_use_rl in number default hr_api.g_number
386: ,p_ignr_prtn_ovrid_flag in varchar2 default hr_api.g_varchar2
387: ,p_elig_inelig_cd in varchar2 default hr_api.g_varchar2
388: ,p_prtn_eff_strt_dt_cd in varchar2 default hr_api.g_varchar2
389: ,p_prtn_eff_strt_dt_rl in number default hr_api.g_number
390: ,p_prtn_eff_end_dt_cd in varchar2 default hr_api.g_varchar2
391: ,p_prtn_eff_end_dt_rl in number default hr_api.g_number
392: ,p_wait_perd_dt_to_use_cd in varchar2 default hr_api.g_varchar2
393: ,p_wait_perd_dt_to_use_rl in number default hr_api.g_number
394: ,p_wait_perd_val in number default hr_api.g_number
387: ,p_elig_inelig_cd in varchar2 default hr_api.g_varchar2
388: ,p_prtn_eff_strt_dt_cd in varchar2 default hr_api.g_varchar2
389: ,p_prtn_eff_strt_dt_rl in number default hr_api.g_number
390: ,p_prtn_eff_end_dt_cd in varchar2 default hr_api.g_varchar2
391: ,p_prtn_eff_end_dt_rl in number default hr_api.g_number
392: ,p_wait_perd_dt_to_use_cd in varchar2 default hr_api.g_varchar2
393: ,p_wait_perd_dt_to_use_rl in number default hr_api.g_number
394: ,p_wait_perd_val in number default hr_api.g_number
395: ,p_wait_perd_uom in varchar2 default hr_api.g_varchar2
388: ,p_prtn_eff_strt_dt_cd in varchar2 default hr_api.g_varchar2
389: ,p_prtn_eff_strt_dt_rl in number default hr_api.g_number
390: ,p_prtn_eff_end_dt_cd in varchar2 default hr_api.g_varchar2
391: ,p_prtn_eff_end_dt_rl in number default hr_api.g_number
392: ,p_wait_perd_dt_to_use_cd in varchar2 default hr_api.g_varchar2
393: ,p_wait_perd_dt_to_use_rl in number default hr_api.g_number
394: ,p_wait_perd_val in number default hr_api.g_number
395: ,p_wait_perd_uom in varchar2 default hr_api.g_varchar2
396: ,p_wait_perd_rl in number default hr_api.g_number
389: ,p_prtn_eff_strt_dt_rl in number default hr_api.g_number
390: ,p_prtn_eff_end_dt_cd in varchar2 default hr_api.g_varchar2
391: ,p_prtn_eff_end_dt_rl in number default hr_api.g_number
392: ,p_wait_perd_dt_to_use_cd in varchar2 default hr_api.g_varchar2
393: ,p_wait_perd_dt_to_use_rl in number default hr_api.g_number
394: ,p_wait_perd_val in number default hr_api.g_number
395: ,p_wait_perd_uom in varchar2 default hr_api.g_varchar2
396: ,p_wait_perd_rl in number default hr_api.g_number
397: ,p_mx_poe_det_dt_cd in varchar2 default hr_api.g_varchar2
390: ,p_prtn_eff_end_dt_cd in varchar2 default hr_api.g_varchar2
391: ,p_prtn_eff_end_dt_rl in number default hr_api.g_number
392: ,p_wait_perd_dt_to_use_cd in varchar2 default hr_api.g_varchar2
393: ,p_wait_perd_dt_to_use_rl in number default hr_api.g_number
394: ,p_wait_perd_val in number default hr_api.g_number
395: ,p_wait_perd_uom in varchar2 default hr_api.g_varchar2
396: ,p_wait_perd_rl in number default hr_api.g_number
397: ,p_mx_poe_det_dt_cd in varchar2 default hr_api.g_varchar2
398: ,p_mx_poe_det_dt_rl in number default hr_api.g_number
391: ,p_prtn_eff_end_dt_rl in number default hr_api.g_number
392: ,p_wait_perd_dt_to_use_cd in varchar2 default hr_api.g_varchar2
393: ,p_wait_perd_dt_to_use_rl in number default hr_api.g_number
394: ,p_wait_perd_val in number default hr_api.g_number
395: ,p_wait_perd_uom in varchar2 default hr_api.g_varchar2
396: ,p_wait_perd_rl in number default hr_api.g_number
397: ,p_mx_poe_det_dt_cd in varchar2 default hr_api.g_varchar2
398: ,p_mx_poe_det_dt_rl in number default hr_api.g_number
399: ,p_mx_poe_val in number default hr_api.g_number
392: ,p_wait_perd_dt_to_use_cd in varchar2 default hr_api.g_varchar2
393: ,p_wait_perd_dt_to_use_rl in number default hr_api.g_number
394: ,p_wait_perd_val in number default hr_api.g_number
395: ,p_wait_perd_uom in varchar2 default hr_api.g_varchar2
396: ,p_wait_perd_rl in number default hr_api.g_number
397: ,p_mx_poe_det_dt_cd in varchar2 default hr_api.g_varchar2
398: ,p_mx_poe_det_dt_rl in number default hr_api.g_number
399: ,p_mx_poe_val in number default hr_api.g_number
400: ,p_mx_poe_uom in varchar2 default hr_api.g_varchar2
393: ,p_wait_perd_dt_to_use_rl in number default hr_api.g_number
394: ,p_wait_perd_val in number default hr_api.g_number
395: ,p_wait_perd_uom in varchar2 default hr_api.g_varchar2
396: ,p_wait_perd_rl in number default hr_api.g_number
397: ,p_mx_poe_det_dt_cd in varchar2 default hr_api.g_varchar2
398: ,p_mx_poe_det_dt_rl in number default hr_api.g_number
399: ,p_mx_poe_val in number default hr_api.g_number
400: ,p_mx_poe_uom in varchar2 default hr_api.g_varchar2
401: ,p_mx_poe_rl in number default hr_api.g_number
394: ,p_wait_perd_val in number default hr_api.g_number
395: ,p_wait_perd_uom in varchar2 default hr_api.g_varchar2
396: ,p_wait_perd_rl in number default hr_api.g_number
397: ,p_mx_poe_det_dt_cd in varchar2 default hr_api.g_varchar2
398: ,p_mx_poe_det_dt_rl in number default hr_api.g_number
399: ,p_mx_poe_val in number default hr_api.g_number
400: ,p_mx_poe_uom in varchar2 default hr_api.g_varchar2
401: ,p_mx_poe_rl in number default hr_api.g_number
402: ,p_mx_poe_apls_cd in varchar2 default hr_api.g_varchar2
395: ,p_wait_perd_uom in varchar2 default hr_api.g_varchar2
396: ,p_wait_perd_rl in number default hr_api.g_number
397: ,p_mx_poe_det_dt_cd in varchar2 default hr_api.g_varchar2
398: ,p_mx_poe_det_dt_rl in number default hr_api.g_number
399: ,p_mx_poe_val in number default hr_api.g_number
400: ,p_mx_poe_uom in varchar2 default hr_api.g_varchar2
401: ,p_mx_poe_rl in number default hr_api.g_number
402: ,p_mx_poe_apls_cd in varchar2 default hr_api.g_varchar2
403: ,p_prtn_ovridbl_flag in varchar2 default hr_api.g_varchar2
396: ,p_wait_perd_rl in number default hr_api.g_number
397: ,p_mx_poe_det_dt_cd in varchar2 default hr_api.g_varchar2
398: ,p_mx_poe_det_dt_rl in number default hr_api.g_number
399: ,p_mx_poe_val in number default hr_api.g_number
400: ,p_mx_poe_uom in varchar2 default hr_api.g_varchar2
401: ,p_mx_poe_rl in number default hr_api.g_number
402: ,p_mx_poe_apls_cd in varchar2 default hr_api.g_varchar2
403: ,p_prtn_ovridbl_flag in varchar2 default hr_api.g_varchar2
404: ,p_vrfy_fmly_mmbr_cd in varchar2 default hr_api.g_varchar2
397: ,p_mx_poe_det_dt_cd in varchar2 default hr_api.g_varchar2
398: ,p_mx_poe_det_dt_rl in number default hr_api.g_number
399: ,p_mx_poe_val in number default hr_api.g_number
400: ,p_mx_poe_uom in varchar2 default hr_api.g_varchar2
401: ,p_mx_poe_rl in number default hr_api.g_number
402: ,p_mx_poe_apls_cd in varchar2 default hr_api.g_varchar2
403: ,p_prtn_ovridbl_flag in varchar2 default hr_api.g_varchar2
404: ,p_vrfy_fmly_mmbr_cd in varchar2 default hr_api.g_varchar2
405: ,p_vrfy_fmly_mmbr_rl in number default hr_api.g_number
398: ,p_mx_poe_det_dt_rl in number default hr_api.g_number
399: ,p_mx_poe_val in number default hr_api.g_number
400: ,p_mx_poe_uom in varchar2 default hr_api.g_varchar2
401: ,p_mx_poe_rl in number default hr_api.g_number
402: ,p_mx_poe_apls_cd in varchar2 default hr_api.g_varchar2
403: ,p_prtn_ovridbl_flag in varchar2 default hr_api.g_varchar2
404: ,p_vrfy_fmly_mmbr_cd in varchar2 default hr_api.g_varchar2
405: ,p_vrfy_fmly_mmbr_rl in number default hr_api.g_number
406: ,p_peo_attribute_category in varchar2 default hr_api.g_varchar2
399: ,p_mx_poe_val in number default hr_api.g_number
400: ,p_mx_poe_uom in varchar2 default hr_api.g_varchar2
401: ,p_mx_poe_rl in number default hr_api.g_number
402: ,p_mx_poe_apls_cd in varchar2 default hr_api.g_varchar2
403: ,p_prtn_ovridbl_flag in varchar2 default hr_api.g_varchar2
404: ,p_vrfy_fmly_mmbr_cd in varchar2 default hr_api.g_varchar2
405: ,p_vrfy_fmly_mmbr_rl in number default hr_api.g_number
406: ,p_peo_attribute_category in varchar2 default hr_api.g_varchar2
407: ,p_peo_attribute1 in varchar2 default hr_api.g_varchar2
400: ,p_mx_poe_uom in varchar2 default hr_api.g_varchar2
401: ,p_mx_poe_rl in number default hr_api.g_number
402: ,p_mx_poe_apls_cd in varchar2 default hr_api.g_varchar2
403: ,p_prtn_ovridbl_flag in varchar2 default hr_api.g_varchar2
404: ,p_vrfy_fmly_mmbr_cd in varchar2 default hr_api.g_varchar2
405: ,p_vrfy_fmly_mmbr_rl in number default hr_api.g_number
406: ,p_peo_attribute_category in varchar2 default hr_api.g_varchar2
407: ,p_peo_attribute1 in varchar2 default hr_api.g_varchar2
408: ,p_peo_attribute2 in varchar2 default hr_api.g_varchar2
401: ,p_mx_poe_rl in number default hr_api.g_number
402: ,p_mx_poe_apls_cd in varchar2 default hr_api.g_varchar2
403: ,p_prtn_ovridbl_flag in varchar2 default hr_api.g_varchar2
404: ,p_vrfy_fmly_mmbr_cd in varchar2 default hr_api.g_varchar2
405: ,p_vrfy_fmly_mmbr_rl in number default hr_api.g_number
406: ,p_peo_attribute_category in varchar2 default hr_api.g_varchar2
407: ,p_peo_attribute1 in varchar2 default hr_api.g_varchar2
408: ,p_peo_attribute2 in varchar2 default hr_api.g_varchar2
409: ,p_peo_attribute3 in varchar2 default hr_api.g_varchar2
402: ,p_mx_poe_apls_cd in varchar2 default hr_api.g_varchar2
403: ,p_prtn_ovridbl_flag in varchar2 default hr_api.g_varchar2
404: ,p_vrfy_fmly_mmbr_cd in varchar2 default hr_api.g_varchar2
405: ,p_vrfy_fmly_mmbr_rl in number default hr_api.g_number
406: ,p_peo_attribute_category in varchar2 default hr_api.g_varchar2
407: ,p_peo_attribute1 in varchar2 default hr_api.g_varchar2
408: ,p_peo_attribute2 in varchar2 default hr_api.g_varchar2
409: ,p_peo_attribute3 in varchar2 default hr_api.g_varchar2
410: ,p_peo_attribute4 in varchar2 default hr_api.g_varchar2
403: ,p_prtn_ovridbl_flag in varchar2 default hr_api.g_varchar2
404: ,p_vrfy_fmly_mmbr_cd in varchar2 default hr_api.g_varchar2
405: ,p_vrfy_fmly_mmbr_rl in number default hr_api.g_number
406: ,p_peo_attribute_category in varchar2 default hr_api.g_varchar2
407: ,p_peo_attribute1 in varchar2 default hr_api.g_varchar2
408: ,p_peo_attribute2 in varchar2 default hr_api.g_varchar2
409: ,p_peo_attribute3 in varchar2 default hr_api.g_varchar2
410: ,p_peo_attribute4 in varchar2 default hr_api.g_varchar2
411: ,p_peo_attribute5 in varchar2 default hr_api.g_varchar2
404: ,p_vrfy_fmly_mmbr_cd in varchar2 default hr_api.g_varchar2
405: ,p_vrfy_fmly_mmbr_rl in number default hr_api.g_number
406: ,p_peo_attribute_category in varchar2 default hr_api.g_varchar2
407: ,p_peo_attribute1 in varchar2 default hr_api.g_varchar2
408: ,p_peo_attribute2 in varchar2 default hr_api.g_varchar2
409: ,p_peo_attribute3 in varchar2 default hr_api.g_varchar2
410: ,p_peo_attribute4 in varchar2 default hr_api.g_varchar2
411: ,p_peo_attribute5 in varchar2 default hr_api.g_varchar2
412: ,p_peo_attribute6 in varchar2 default hr_api.g_varchar2
405: ,p_vrfy_fmly_mmbr_rl in number default hr_api.g_number
406: ,p_peo_attribute_category in varchar2 default hr_api.g_varchar2
407: ,p_peo_attribute1 in varchar2 default hr_api.g_varchar2
408: ,p_peo_attribute2 in varchar2 default hr_api.g_varchar2
409: ,p_peo_attribute3 in varchar2 default hr_api.g_varchar2
410: ,p_peo_attribute4 in varchar2 default hr_api.g_varchar2
411: ,p_peo_attribute5 in varchar2 default hr_api.g_varchar2
412: ,p_peo_attribute6 in varchar2 default hr_api.g_varchar2
413: ,p_peo_attribute7 in varchar2 default hr_api.g_varchar2
406: ,p_peo_attribute_category in varchar2 default hr_api.g_varchar2
407: ,p_peo_attribute1 in varchar2 default hr_api.g_varchar2
408: ,p_peo_attribute2 in varchar2 default hr_api.g_varchar2
409: ,p_peo_attribute3 in varchar2 default hr_api.g_varchar2
410: ,p_peo_attribute4 in varchar2 default hr_api.g_varchar2
411: ,p_peo_attribute5 in varchar2 default hr_api.g_varchar2
412: ,p_peo_attribute6 in varchar2 default hr_api.g_varchar2
413: ,p_peo_attribute7 in varchar2 default hr_api.g_varchar2
414: ,p_peo_attribute8 in varchar2 default hr_api.g_varchar2
407: ,p_peo_attribute1 in varchar2 default hr_api.g_varchar2
408: ,p_peo_attribute2 in varchar2 default hr_api.g_varchar2
409: ,p_peo_attribute3 in varchar2 default hr_api.g_varchar2
410: ,p_peo_attribute4 in varchar2 default hr_api.g_varchar2
411: ,p_peo_attribute5 in varchar2 default hr_api.g_varchar2
412: ,p_peo_attribute6 in varchar2 default hr_api.g_varchar2
413: ,p_peo_attribute7 in varchar2 default hr_api.g_varchar2
414: ,p_peo_attribute8 in varchar2 default hr_api.g_varchar2
415: ,p_peo_attribute9 in varchar2 default hr_api.g_varchar2
408: ,p_peo_attribute2 in varchar2 default hr_api.g_varchar2
409: ,p_peo_attribute3 in varchar2 default hr_api.g_varchar2
410: ,p_peo_attribute4 in varchar2 default hr_api.g_varchar2
411: ,p_peo_attribute5 in varchar2 default hr_api.g_varchar2
412: ,p_peo_attribute6 in varchar2 default hr_api.g_varchar2
413: ,p_peo_attribute7 in varchar2 default hr_api.g_varchar2
414: ,p_peo_attribute8 in varchar2 default hr_api.g_varchar2
415: ,p_peo_attribute9 in varchar2 default hr_api.g_varchar2
416: ,p_peo_attribute10 in varchar2 default hr_api.g_varchar2
409: ,p_peo_attribute3 in varchar2 default hr_api.g_varchar2
410: ,p_peo_attribute4 in varchar2 default hr_api.g_varchar2
411: ,p_peo_attribute5 in varchar2 default hr_api.g_varchar2
412: ,p_peo_attribute6 in varchar2 default hr_api.g_varchar2
413: ,p_peo_attribute7 in varchar2 default hr_api.g_varchar2
414: ,p_peo_attribute8 in varchar2 default hr_api.g_varchar2
415: ,p_peo_attribute9 in varchar2 default hr_api.g_varchar2
416: ,p_peo_attribute10 in varchar2 default hr_api.g_varchar2
417: ,p_peo_attribute11 in varchar2 default hr_api.g_varchar2
410: ,p_peo_attribute4 in varchar2 default hr_api.g_varchar2
411: ,p_peo_attribute5 in varchar2 default hr_api.g_varchar2
412: ,p_peo_attribute6 in varchar2 default hr_api.g_varchar2
413: ,p_peo_attribute7 in varchar2 default hr_api.g_varchar2
414: ,p_peo_attribute8 in varchar2 default hr_api.g_varchar2
415: ,p_peo_attribute9 in varchar2 default hr_api.g_varchar2
416: ,p_peo_attribute10 in varchar2 default hr_api.g_varchar2
417: ,p_peo_attribute11 in varchar2 default hr_api.g_varchar2
418: ,p_peo_attribute12 in varchar2 default hr_api.g_varchar2
411: ,p_peo_attribute5 in varchar2 default hr_api.g_varchar2
412: ,p_peo_attribute6 in varchar2 default hr_api.g_varchar2
413: ,p_peo_attribute7 in varchar2 default hr_api.g_varchar2
414: ,p_peo_attribute8 in varchar2 default hr_api.g_varchar2
415: ,p_peo_attribute9 in varchar2 default hr_api.g_varchar2
416: ,p_peo_attribute10 in varchar2 default hr_api.g_varchar2
417: ,p_peo_attribute11 in varchar2 default hr_api.g_varchar2
418: ,p_peo_attribute12 in varchar2 default hr_api.g_varchar2
419: ,p_peo_attribute13 in varchar2 default hr_api.g_varchar2
412: ,p_peo_attribute6 in varchar2 default hr_api.g_varchar2
413: ,p_peo_attribute7 in varchar2 default hr_api.g_varchar2
414: ,p_peo_attribute8 in varchar2 default hr_api.g_varchar2
415: ,p_peo_attribute9 in varchar2 default hr_api.g_varchar2
416: ,p_peo_attribute10 in varchar2 default hr_api.g_varchar2
417: ,p_peo_attribute11 in varchar2 default hr_api.g_varchar2
418: ,p_peo_attribute12 in varchar2 default hr_api.g_varchar2
419: ,p_peo_attribute13 in varchar2 default hr_api.g_varchar2
420: ,p_peo_attribute14 in varchar2 default hr_api.g_varchar2
413: ,p_peo_attribute7 in varchar2 default hr_api.g_varchar2
414: ,p_peo_attribute8 in varchar2 default hr_api.g_varchar2
415: ,p_peo_attribute9 in varchar2 default hr_api.g_varchar2
416: ,p_peo_attribute10 in varchar2 default hr_api.g_varchar2
417: ,p_peo_attribute11 in varchar2 default hr_api.g_varchar2
418: ,p_peo_attribute12 in varchar2 default hr_api.g_varchar2
419: ,p_peo_attribute13 in varchar2 default hr_api.g_varchar2
420: ,p_peo_attribute14 in varchar2 default hr_api.g_varchar2
421: ,p_peo_attribute15 in varchar2 default hr_api.g_varchar2
414: ,p_peo_attribute8 in varchar2 default hr_api.g_varchar2
415: ,p_peo_attribute9 in varchar2 default hr_api.g_varchar2
416: ,p_peo_attribute10 in varchar2 default hr_api.g_varchar2
417: ,p_peo_attribute11 in varchar2 default hr_api.g_varchar2
418: ,p_peo_attribute12 in varchar2 default hr_api.g_varchar2
419: ,p_peo_attribute13 in varchar2 default hr_api.g_varchar2
420: ,p_peo_attribute14 in varchar2 default hr_api.g_varchar2
421: ,p_peo_attribute15 in varchar2 default hr_api.g_varchar2
422: ,p_peo_attribute16 in varchar2 default hr_api.g_varchar2
415: ,p_peo_attribute9 in varchar2 default hr_api.g_varchar2
416: ,p_peo_attribute10 in varchar2 default hr_api.g_varchar2
417: ,p_peo_attribute11 in varchar2 default hr_api.g_varchar2
418: ,p_peo_attribute12 in varchar2 default hr_api.g_varchar2
419: ,p_peo_attribute13 in varchar2 default hr_api.g_varchar2
420: ,p_peo_attribute14 in varchar2 default hr_api.g_varchar2
421: ,p_peo_attribute15 in varchar2 default hr_api.g_varchar2
422: ,p_peo_attribute16 in varchar2 default hr_api.g_varchar2
423: ,p_peo_attribute17 in varchar2 default hr_api.g_varchar2
416: ,p_peo_attribute10 in varchar2 default hr_api.g_varchar2
417: ,p_peo_attribute11 in varchar2 default hr_api.g_varchar2
418: ,p_peo_attribute12 in varchar2 default hr_api.g_varchar2
419: ,p_peo_attribute13 in varchar2 default hr_api.g_varchar2
420: ,p_peo_attribute14 in varchar2 default hr_api.g_varchar2
421: ,p_peo_attribute15 in varchar2 default hr_api.g_varchar2
422: ,p_peo_attribute16 in varchar2 default hr_api.g_varchar2
423: ,p_peo_attribute17 in varchar2 default hr_api.g_varchar2
424: ,p_peo_attribute18 in varchar2 default hr_api.g_varchar2
417: ,p_peo_attribute11 in varchar2 default hr_api.g_varchar2
418: ,p_peo_attribute12 in varchar2 default hr_api.g_varchar2
419: ,p_peo_attribute13 in varchar2 default hr_api.g_varchar2
420: ,p_peo_attribute14 in varchar2 default hr_api.g_varchar2
421: ,p_peo_attribute15 in varchar2 default hr_api.g_varchar2
422: ,p_peo_attribute16 in varchar2 default hr_api.g_varchar2
423: ,p_peo_attribute17 in varchar2 default hr_api.g_varchar2
424: ,p_peo_attribute18 in varchar2 default hr_api.g_varchar2
425: ,p_peo_attribute19 in varchar2 default hr_api.g_varchar2
418: ,p_peo_attribute12 in varchar2 default hr_api.g_varchar2
419: ,p_peo_attribute13 in varchar2 default hr_api.g_varchar2
420: ,p_peo_attribute14 in varchar2 default hr_api.g_varchar2
421: ,p_peo_attribute15 in varchar2 default hr_api.g_varchar2
422: ,p_peo_attribute16 in varchar2 default hr_api.g_varchar2
423: ,p_peo_attribute17 in varchar2 default hr_api.g_varchar2
424: ,p_peo_attribute18 in varchar2 default hr_api.g_varchar2
425: ,p_peo_attribute19 in varchar2 default hr_api.g_varchar2
426: ,p_peo_attribute20 in varchar2 default hr_api.g_varchar2
419: ,p_peo_attribute13 in varchar2 default hr_api.g_varchar2
420: ,p_peo_attribute14 in varchar2 default hr_api.g_varchar2
421: ,p_peo_attribute15 in varchar2 default hr_api.g_varchar2
422: ,p_peo_attribute16 in varchar2 default hr_api.g_varchar2
423: ,p_peo_attribute17 in varchar2 default hr_api.g_varchar2
424: ,p_peo_attribute18 in varchar2 default hr_api.g_varchar2
425: ,p_peo_attribute19 in varchar2 default hr_api.g_varchar2
426: ,p_peo_attribute20 in varchar2 default hr_api.g_varchar2
427: ,p_peo_attribute21 in varchar2 default hr_api.g_varchar2
420: ,p_peo_attribute14 in varchar2 default hr_api.g_varchar2
421: ,p_peo_attribute15 in varchar2 default hr_api.g_varchar2
422: ,p_peo_attribute16 in varchar2 default hr_api.g_varchar2
423: ,p_peo_attribute17 in varchar2 default hr_api.g_varchar2
424: ,p_peo_attribute18 in varchar2 default hr_api.g_varchar2
425: ,p_peo_attribute19 in varchar2 default hr_api.g_varchar2
426: ,p_peo_attribute20 in varchar2 default hr_api.g_varchar2
427: ,p_peo_attribute21 in varchar2 default hr_api.g_varchar2
428: ,p_peo_attribute22 in varchar2 default hr_api.g_varchar2
421: ,p_peo_attribute15 in varchar2 default hr_api.g_varchar2
422: ,p_peo_attribute16 in varchar2 default hr_api.g_varchar2
423: ,p_peo_attribute17 in varchar2 default hr_api.g_varchar2
424: ,p_peo_attribute18 in varchar2 default hr_api.g_varchar2
425: ,p_peo_attribute19 in varchar2 default hr_api.g_varchar2
426: ,p_peo_attribute20 in varchar2 default hr_api.g_varchar2
427: ,p_peo_attribute21 in varchar2 default hr_api.g_varchar2
428: ,p_peo_attribute22 in varchar2 default hr_api.g_varchar2
429: ,p_peo_attribute23 in varchar2 default hr_api.g_varchar2
422: ,p_peo_attribute16 in varchar2 default hr_api.g_varchar2
423: ,p_peo_attribute17 in varchar2 default hr_api.g_varchar2
424: ,p_peo_attribute18 in varchar2 default hr_api.g_varchar2
425: ,p_peo_attribute19 in varchar2 default hr_api.g_varchar2
426: ,p_peo_attribute20 in varchar2 default hr_api.g_varchar2
427: ,p_peo_attribute21 in varchar2 default hr_api.g_varchar2
428: ,p_peo_attribute22 in varchar2 default hr_api.g_varchar2
429: ,p_peo_attribute23 in varchar2 default hr_api.g_varchar2
430: ,p_peo_attribute24 in varchar2 default hr_api.g_varchar2
423: ,p_peo_attribute17 in varchar2 default hr_api.g_varchar2
424: ,p_peo_attribute18 in varchar2 default hr_api.g_varchar2
425: ,p_peo_attribute19 in varchar2 default hr_api.g_varchar2
426: ,p_peo_attribute20 in varchar2 default hr_api.g_varchar2
427: ,p_peo_attribute21 in varchar2 default hr_api.g_varchar2
428: ,p_peo_attribute22 in varchar2 default hr_api.g_varchar2
429: ,p_peo_attribute23 in varchar2 default hr_api.g_varchar2
430: ,p_peo_attribute24 in varchar2 default hr_api.g_varchar2
431: ,p_peo_attribute25 in varchar2 default hr_api.g_varchar2
424: ,p_peo_attribute18 in varchar2 default hr_api.g_varchar2
425: ,p_peo_attribute19 in varchar2 default hr_api.g_varchar2
426: ,p_peo_attribute20 in varchar2 default hr_api.g_varchar2
427: ,p_peo_attribute21 in varchar2 default hr_api.g_varchar2
428: ,p_peo_attribute22 in varchar2 default hr_api.g_varchar2
429: ,p_peo_attribute23 in varchar2 default hr_api.g_varchar2
430: ,p_peo_attribute24 in varchar2 default hr_api.g_varchar2
431: ,p_peo_attribute25 in varchar2 default hr_api.g_varchar2
432: ,p_peo_attribute26 in varchar2 default hr_api.g_varchar2
425: ,p_peo_attribute19 in varchar2 default hr_api.g_varchar2
426: ,p_peo_attribute20 in varchar2 default hr_api.g_varchar2
427: ,p_peo_attribute21 in varchar2 default hr_api.g_varchar2
428: ,p_peo_attribute22 in varchar2 default hr_api.g_varchar2
429: ,p_peo_attribute23 in varchar2 default hr_api.g_varchar2
430: ,p_peo_attribute24 in varchar2 default hr_api.g_varchar2
431: ,p_peo_attribute25 in varchar2 default hr_api.g_varchar2
432: ,p_peo_attribute26 in varchar2 default hr_api.g_varchar2
433: ,p_peo_attribute27 in varchar2 default hr_api.g_varchar2
426: ,p_peo_attribute20 in varchar2 default hr_api.g_varchar2
427: ,p_peo_attribute21 in varchar2 default hr_api.g_varchar2
428: ,p_peo_attribute22 in varchar2 default hr_api.g_varchar2
429: ,p_peo_attribute23 in varchar2 default hr_api.g_varchar2
430: ,p_peo_attribute24 in varchar2 default hr_api.g_varchar2
431: ,p_peo_attribute25 in varchar2 default hr_api.g_varchar2
432: ,p_peo_attribute26 in varchar2 default hr_api.g_varchar2
433: ,p_peo_attribute27 in varchar2 default hr_api.g_varchar2
434: ,p_peo_attribute28 in varchar2 default hr_api.g_varchar2
427: ,p_peo_attribute21 in varchar2 default hr_api.g_varchar2
428: ,p_peo_attribute22 in varchar2 default hr_api.g_varchar2
429: ,p_peo_attribute23 in varchar2 default hr_api.g_varchar2
430: ,p_peo_attribute24 in varchar2 default hr_api.g_varchar2
431: ,p_peo_attribute25 in varchar2 default hr_api.g_varchar2
432: ,p_peo_attribute26 in varchar2 default hr_api.g_varchar2
433: ,p_peo_attribute27 in varchar2 default hr_api.g_varchar2
434: ,p_peo_attribute28 in varchar2 default hr_api.g_varchar2
435: ,p_peo_attribute29 in varchar2 default hr_api.g_varchar2
428: ,p_peo_attribute22 in varchar2 default hr_api.g_varchar2
429: ,p_peo_attribute23 in varchar2 default hr_api.g_varchar2
430: ,p_peo_attribute24 in varchar2 default hr_api.g_varchar2
431: ,p_peo_attribute25 in varchar2 default hr_api.g_varchar2
432: ,p_peo_attribute26 in varchar2 default hr_api.g_varchar2
433: ,p_peo_attribute27 in varchar2 default hr_api.g_varchar2
434: ,p_peo_attribute28 in varchar2 default hr_api.g_varchar2
435: ,p_peo_attribute29 in varchar2 default hr_api.g_varchar2
436: ,p_peo_attribute30 in varchar2 default hr_api.g_varchar2
429: ,p_peo_attribute23 in varchar2 default hr_api.g_varchar2
430: ,p_peo_attribute24 in varchar2 default hr_api.g_varchar2
431: ,p_peo_attribute25 in varchar2 default hr_api.g_varchar2
432: ,p_peo_attribute26 in varchar2 default hr_api.g_varchar2
433: ,p_peo_attribute27 in varchar2 default hr_api.g_varchar2
434: ,p_peo_attribute28 in varchar2 default hr_api.g_varchar2
435: ,p_peo_attribute29 in varchar2 default hr_api.g_varchar2
436: ,p_peo_attribute30 in varchar2 default hr_api.g_varchar2
437: ,p_object_version_number in out nocopy number
430: ,p_peo_attribute24 in varchar2 default hr_api.g_varchar2
431: ,p_peo_attribute25 in varchar2 default hr_api.g_varchar2
432: ,p_peo_attribute26 in varchar2 default hr_api.g_varchar2
433: ,p_peo_attribute27 in varchar2 default hr_api.g_varchar2
434: ,p_peo_attribute28 in varchar2 default hr_api.g_varchar2
435: ,p_peo_attribute29 in varchar2 default hr_api.g_varchar2
436: ,p_peo_attribute30 in varchar2 default hr_api.g_varchar2
437: ,p_object_version_number in out nocopy number
438: ,p_effective_date in date
431: ,p_peo_attribute25 in varchar2 default hr_api.g_varchar2
432: ,p_peo_attribute26 in varchar2 default hr_api.g_varchar2
433: ,p_peo_attribute27 in varchar2 default hr_api.g_varchar2
434: ,p_peo_attribute28 in varchar2 default hr_api.g_varchar2
435: ,p_peo_attribute29 in varchar2 default hr_api.g_varchar2
436: ,p_peo_attribute30 in varchar2 default hr_api.g_varchar2
437: ,p_object_version_number in out nocopy number
438: ,p_effective_date in date
439: ,p_datetrack_mode in varchar2) is
432: ,p_peo_attribute26 in varchar2 default hr_api.g_varchar2
433: ,p_peo_attribute27 in varchar2 default hr_api.g_varchar2
434: ,p_peo_attribute28 in varchar2 default hr_api.g_varchar2
435: ,p_peo_attribute29 in varchar2 default hr_api.g_varchar2
436: ,p_peo_attribute30 in varchar2 default hr_api.g_varchar2
437: ,p_object_version_number in out nocopy number
438: ,p_effective_date in date
439: ,p_datetrack_mode in varchar2) is
440: --
528: ,p_datetrack_mode => p_datetrack_mode);
529: --
530: exception
531: --
532: when hr_api.cannot_find_prog_unit then
533: --
534: hr_api.cannot_find_prog_unit_error
535: (p_module_name => 'UPDATE_ELIG_TO_PRTE_REASON'
536: ,p_hook_type => 'BP');
530: exception
531: --
532: when hr_api.cannot_find_prog_unit then
533: --
534: hr_api.cannot_find_prog_unit_error
535: (p_module_name => 'UPDATE_ELIG_TO_PRTE_REASON'
536: ,p_hook_type => 'BP');
537: --
538: -- End of API User Hook for the before hook of update_ELIG_TO_PRTE_REASON
676: ,p_datetrack_mode => p_datetrack_mode);
677: --
678: exception
679: --
680: when hr_api.cannot_find_prog_unit then
681: --
682: hr_api.cannot_find_prog_unit_error
683: (p_module_name => 'UPDATE_ELIG_TO_PRTE_REASON'
684: ,p_hook_type => 'AP');
678: exception
679: --
680: when hr_api.cannot_find_prog_unit then
681: --
682: hr_api.cannot_find_prog_unit_error
683: (p_module_name => 'UPDATE_ELIG_TO_PRTE_REASON'
684: ,p_hook_type => 'AP');
685: --
686: -- End of API User Hook for the after hook of update_ELIG_TO_PRTE_REASON
691: --
692: -- When in validation only mode raise the Validate_Enabled exception
693: --
694: if p_validate then
695: raise hr_api.validate_enabled;
696: end if;
697: --
698: -- Set all output arguments
699: --
704: hr_utility.set_location(' Leaving:'||l_proc, 70);
705: --
706: exception
707: --
708: when hr_api.validate_enabled then
709: --
710: -- As the Validate_Enabled exception has been raised
711: -- we must rollback to the savepoint
712: --
776: ,p_datetrack_mode => p_datetrack_mode);
777: --
778: exception
779: --
780: when hr_api.cannot_find_prog_unit then
781: --
782: hr_api.cannot_find_prog_unit_error
783: (p_module_name => 'DELETE_ELIG_TO_PRTE_REASON'
784: ,p_hook_type => 'BP');
778: exception
779: --
780: when hr_api.cannot_find_prog_unit then
781: --
782: hr_api.cannot_find_prog_unit_error
783: (p_module_name => 'DELETE_ELIG_TO_PRTE_REASON'
784: ,p_hook_type => 'BP');
785: --
786: -- End of API User Hook for the before hook of delete_ELIG_TO_PRTE_REASON
808: ,p_datetrack_mode => p_datetrack_mode);
809: --
810: exception
811: --
812: when hr_api.cannot_find_prog_unit then
813: --
814: hr_api.cannot_find_prog_unit_error
815: (p_module_name => 'DELETE_ELIG_TO_PRTE_REASON'
816: ,p_hook_type => 'AP');
810: exception
811: --
812: when hr_api.cannot_find_prog_unit then
813: --
814: hr_api.cannot_find_prog_unit_error
815: (p_module_name => 'DELETE_ELIG_TO_PRTE_REASON'
816: ,p_hook_type => 'AP');
817: --
818: -- End of API User Hook for the after hook of delete_ELIG_TO_PRTE_REASON
823: --
824: -- When in validation only mode raise the Validate_Enabled exception
825: --
826: if p_validate then
827: raise hr_api.validate_enabled;
828: end if;
829: --
830: hr_utility.set_location(' Leaving:'||l_proc, 70);
831: --
830: hr_utility.set_location(' Leaving:'||l_proc, 70);
831: --
832: exception
833: --
834: when hr_api.validate_enabled then
835: --
836: -- As the Validate_Enabled exception has been raised
837: -- we must rollback to the savepoint
838: --