8: -- ----------------------------------------------------------------------------
9: -- |----------------------< create_pil_elctbl_chc_popl >----------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_pil_elctbl_chc_popl
12: (p_validate in number default hr_api.g_false_num
13: ,p_pil_elctbl_chc_popl_id out nocopy number
14: ,p_dflt_enrt_dt in date default null
15: ,p_dflt_asnd_dt in date default null
16: ,p_elcns_made_dt in date default null
110: --
111: -- Convert constant values to their corresponding boolean value
112: --
113: l_validate :=
114: hr_api.constant_to_boolean
115: (p_constant_value => p_validate);
116: --
117: -- Register Surrogate ID or user key values
118: --
250: -- ----------------------------------------------------------------------------
251: -- |----------------------< delete_pil_elctbl_chc_popl >----------------------|
252: -- ----------------------------------------------------------------------------
253: PROCEDURE delete_pil_elctbl_chc_popl
254: (p_validate in number default hr_api.g_false_num
255: ,p_pil_elctbl_chc_popl_id in number
256: ,p_object_version_number in out nocopy number
257: ,p_effective_date in date
258: ,p_return_status out nocopy varchar2
283: --
284: -- Convert constant values to their corresponding boolean value
285: --
286: l_validate :=
287: hr_api.constant_to_boolean
288: (p_constant_value => p_validate);
289: --
290: -- Register Surrogate ID or user key values
291: --
438: -- ----------------------------------------------------------------------------
439: -- |----------------------< update_pil_elctbl_chc_popl >----------------------|
440: -- ----------------------------------------------------------------------------
441: PROCEDURE update_pil_elctbl_chc_popl
442: (p_validate in number default hr_api.g_false_num
443: ,p_pil_elctbl_chc_popl_id in number
444: ,p_dflt_enrt_dt in date default hr_api.g_date
445: ,p_dflt_asnd_dt in date default hr_api.g_date
446: ,p_elcns_made_dt in date default hr_api.g_date
440: -- ----------------------------------------------------------------------------
441: PROCEDURE update_pil_elctbl_chc_popl
442: (p_validate in number default hr_api.g_false_num
443: ,p_pil_elctbl_chc_popl_id in number
444: ,p_dflt_enrt_dt in date default hr_api.g_date
445: ,p_dflt_asnd_dt in date default hr_api.g_date
446: ,p_elcns_made_dt in date default hr_api.g_date
447: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
448: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
441: PROCEDURE update_pil_elctbl_chc_popl
442: (p_validate in number default hr_api.g_false_num
443: ,p_pil_elctbl_chc_popl_id in number
444: ,p_dflt_enrt_dt in date default hr_api.g_date
445: ,p_dflt_asnd_dt in date default hr_api.g_date
446: ,p_elcns_made_dt in date default hr_api.g_date
447: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
448: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
449: ,p_enrt_perd_end_dt in date default hr_api.g_date
442: (p_validate in number default hr_api.g_false_num
443: ,p_pil_elctbl_chc_popl_id in number
444: ,p_dflt_enrt_dt in date default hr_api.g_date
445: ,p_dflt_asnd_dt in date default hr_api.g_date
446: ,p_elcns_made_dt in date default hr_api.g_date
447: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
448: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
449: ,p_enrt_perd_end_dt in date default hr_api.g_date
450: ,p_enrt_perd_strt_dt in date default hr_api.g_date
443: ,p_pil_elctbl_chc_popl_id in number
444: ,p_dflt_enrt_dt in date default hr_api.g_date
445: ,p_dflt_asnd_dt in date default hr_api.g_date
446: ,p_elcns_made_dt in date default hr_api.g_date
447: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
448: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
449: ,p_enrt_perd_end_dt in date default hr_api.g_date
450: ,p_enrt_perd_strt_dt in date default hr_api.g_date
451: ,p_procg_end_dt in date default hr_api.g_date
444: ,p_dflt_enrt_dt in date default hr_api.g_date
445: ,p_dflt_asnd_dt in date default hr_api.g_date
446: ,p_elcns_made_dt in date default hr_api.g_date
447: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
448: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
449: ,p_enrt_perd_end_dt in date default hr_api.g_date
450: ,p_enrt_perd_strt_dt in date default hr_api.g_date
451: ,p_procg_end_dt in date default hr_api.g_date
452: ,p_pil_elctbl_popl_stat_cd in varchar2 default hr_api.g_varchar2
445: ,p_dflt_asnd_dt in date default hr_api.g_date
446: ,p_elcns_made_dt in date default hr_api.g_date
447: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
448: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
449: ,p_enrt_perd_end_dt in date default hr_api.g_date
450: ,p_enrt_perd_strt_dt in date default hr_api.g_date
451: ,p_procg_end_dt in date default hr_api.g_date
452: ,p_pil_elctbl_popl_stat_cd in varchar2 default hr_api.g_varchar2
453: ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
446: ,p_elcns_made_dt in date default hr_api.g_date
447: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
448: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
449: ,p_enrt_perd_end_dt in date default hr_api.g_date
450: ,p_enrt_perd_strt_dt in date default hr_api.g_date
451: ,p_procg_end_dt in date default hr_api.g_date
452: ,p_pil_elctbl_popl_stat_cd in varchar2 default hr_api.g_varchar2
453: ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
454: ,p_uom in varchar2 default hr_api.g_varchar2
447: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
448: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
449: ,p_enrt_perd_end_dt in date default hr_api.g_date
450: ,p_enrt_perd_strt_dt in date default hr_api.g_date
451: ,p_procg_end_dt in date default hr_api.g_date
452: ,p_pil_elctbl_popl_stat_cd in varchar2 default hr_api.g_varchar2
453: ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
454: ,p_uom in varchar2 default hr_api.g_varchar2
455: ,p_comments in varchar2 default hr_api.g_varchar2
448: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
449: ,p_enrt_perd_end_dt in date default hr_api.g_date
450: ,p_enrt_perd_strt_dt in date default hr_api.g_date
451: ,p_procg_end_dt in date default hr_api.g_date
452: ,p_pil_elctbl_popl_stat_cd in varchar2 default hr_api.g_varchar2
453: ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
454: ,p_uom in varchar2 default hr_api.g_varchar2
455: ,p_comments in varchar2 default hr_api.g_varchar2
456: ,p_mgr_ovrid_dt in date default hr_api.g_date
449: ,p_enrt_perd_end_dt in date default hr_api.g_date
450: ,p_enrt_perd_strt_dt in date default hr_api.g_date
451: ,p_procg_end_dt in date default hr_api.g_date
452: ,p_pil_elctbl_popl_stat_cd in varchar2 default hr_api.g_varchar2
453: ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
454: ,p_uom in varchar2 default hr_api.g_varchar2
455: ,p_comments in varchar2 default hr_api.g_varchar2
456: ,p_mgr_ovrid_dt in date default hr_api.g_date
457: ,p_ws_mgr_id in number default hr_api.g_number
450: ,p_enrt_perd_strt_dt in date default hr_api.g_date
451: ,p_procg_end_dt in date default hr_api.g_date
452: ,p_pil_elctbl_popl_stat_cd in varchar2 default hr_api.g_varchar2
453: ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
454: ,p_uom in varchar2 default hr_api.g_varchar2
455: ,p_comments in varchar2 default hr_api.g_varchar2
456: ,p_mgr_ovrid_dt in date default hr_api.g_date
457: ,p_ws_mgr_id in number default hr_api.g_number
458: ,p_mgr_ovrid_person_id in number default hr_api.g_number
451: ,p_procg_end_dt in date default hr_api.g_date
452: ,p_pil_elctbl_popl_stat_cd in varchar2 default hr_api.g_varchar2
453: ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
454: ,p_uom in varchar2 default hr_api.g_varchar2
455: ,p_comments in varchar2 default hr_api.g_varchar2
456: ,p_mgr_ovrid_dt in date default hr_api.g_date
457: ,p_ws_mgr_id in number default hr_api.g_number
458: ,p_mgr_ovrid_person_id in number default hr_api.g_number
459: ,p_assignment_id in number default hr_api.g_number
452: ,p_pil_elctbl_popl_stat_cd in varchar2 default hr_api.g_varchar2
453: ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
454: ,p_uom in varchar2 default hr_api.g_varchar2
455: ,p_comments in varchar2 default hr_api.g_varchar2
456: ,p_mgr_ovrid_dt in date default hr_api.g_date
457: ,p_ws_mgr_id in number default hr_api.g_number
458: ,p_mgr_ovrid_person_id in number default hr_api.g_number
459: ,p_assignment_id in number default hr_api.g_number
460: ,p_bdgt_acc_cd in varchar2 default hr_api.g_varchar2
453: ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
454: ,p_uom in varchar2 default hr_api.g_varchar2
455: ,p_comments in varchar2 default hr_api.g_varchar2
456: ,p_mgr_ovrid_dt in date default hr_api.g_date
457: ,p_ws_mgr_id in number default hr_api.g_number
458: ,p_mgr_ovrid_person_id in number default hr_api.g_number
459: ,p_assignment_id in number default hr_api.g_number
460: ,p_bdgt_acc_cd in varchar2 default hr_api.g_varchar2
461: ,p_pop_cd in varchar2 default hr_api.g_varchar2
454: ,p_uom in varchar2 default hr_api.g_varchar2
455: ,p_comments in varchar2 default hr_api.g_varchar2
456: ,p_mgr_ovrid_dt in date default hr_api.g_date
457: ,p_ws_mgr_id in number default hr_api.g_number
458: ,p_mgr_ovrid_person_id in number default hr_api.g_number
459: ,p_assignment_id in number default hr_api.g_number
460: ,p_bdgt_acc_cd in varchar2 default hr_api.g_varchar2
461: ,p_pop_cd in varchar2 default hr_api.g_varchar2
462: ,p_bdgt_due_dt in date default hr_api.g_date
455: ,p_comments in varchar2 default hr_api.g_varchar2
456: ,p_mgr_ovrid_dt in date default hr_api.g_date
457: ,p_ws_mgr_id in number default hr_api.g_number
458: ,p_mgr_ovrid_person_id in number default hr_api.g_number
459: ,p_assignment_id in number default hr_api.g_number
460: ,p_bdgt_acc_cd in varchar2 default hr_api.g_varchar2
461: ,p_pop_cd in varchar2 default hr_api.g_varchar2
462: ,p_bdgt_due_dt in date default hr_api.g_date
463: ,p_bdgt_export_flag in varchar2 default hr_api.g_varchar2
456: ,p_mgr_ovrid_dt in date default hr_api.g_date
457: ,p_ws_mgr_id in number default hr_api.g_number
458: ,p_mgr_ovrid_person_id in number default hr_api.g_number
459: ,p_assignment_id in number default hr_api.g_number
460: ,p_bdgt_acc_cd in varchar2 default hr_api.g_varchar2
461: ,p_pop_cd in varchar2 default hr_api.g_varchar2
462: ,p_bdgt_due_dt in date default hr_api.g_date
463: ,p_bdgt_export_flag in varchar2 default hr_api.g_varchar2
464: ,p_bdgt_iss_dt in date default hr_api.g_date
457: ,p_ws_mgr_id in number default hr_api.g_number
458: ,p_mgr_ovrid_person_id in number default hr_api.g_number
459: ,p_assignment_id in number default hr_api.g_number
460: ,p_bdgt_acc_cd in varchar2 default hr_api.g_varchar2
461: ,p_pop_cd in varchar2 default hr_api.g_varchar2
462: ,p_bdgt_due_dt in date default hr_api.g_date
463: ,p_bdgt_export_flag in varchar2 default hr_api.g_varchar2
464: ,p_bdgt_iss_dt in date default hr_api.g_date
465: ,p_bdgt_stat_cd in varchar2 default hr_api.g_varchar2
458: ,p_mgr_ovrid_person_id in number default hr_api.g_number
459: ,p_assignment_id in number default hr_api.g_number
460: ,p_bdgt_acc_cd in varchar2 default hr_api.g_varchar2
461: ,p_pop_cd in varchar2 default hr_api.g_varchar2
462: ,p_bdgt_due_dt in date default hr_api.g_date
463: ,p_bdgt_export_flag in varchar2 default hr_api.g_varchar2
464: ,p_bdgt_iss_dt in date default hr_api.g_date
465: ,p_bdgt_stat_cd in varchar2 default hr_api.g_varchar2
466: ,p_ws_acc_cd in varchar2 default hr_api.g_varchar2
459: ,p_assignment_id in number default hr_api.g_number
460: ,p_bdgt_acc_cd in varchar2 default hr_api.g_varchar2
461: ,p_pop_cd in varchar2 default hr_api.g_varchar2
462: ,p_bdgt_due_dt in date default hr_api.g_date
463: ,p_bdgt_export_flag in varchar2 default hr_api.g_varchar2
464: ,p_bdgt_iss_dt in date default hr_api.g_date
465: ,p_bdgt_stat_cd in varchar2 default hr_api.g_varchar2
466: ,p_ws_acc_cd in varchar2 default hr_api.g_varchar2
467: ,p_ws_due_dt in date default hr_api.g_date
460: ,p_bdgt_acc_cd in varchar2 default hr_api.g_varchar2
461: ,p_pop_cd in varchar2 default hr_api.g_varchar2
462: ,p_bdgt_due_dt in date default hr_api.g_date
463: ,p_bdgt_export_flag in varchar2 default hr_api.g_varchar2
464: ,p_bdgt_iss_dt in date default hr_api.g_date
465: ,p_bdgt_stat_cd in varchar2 default hr_api.g_varchar2
466: ,p_ws_acc_cd in varchar2 default hr_api.g_varchar2
467: ,p_ws_due_dt in date default hr_api.g_date
468: ,p_ws_export_flag in varchar2 default hr_api.g_varchar2
461: ,p_pop_cd in varchar2 default hr_api.g_varchar2
462: ,p_bdgt_due_dt in date default hr_api.g_date
463: ,p_bdgt_export_flag in varchar2 default hr_api.g_varchar2
464: ,p_bdgt_iss_dt in date default hr_api.g_date
465: ,p_bdgt_stat_cd in varchar2 default hr_api.g_varchar2
466: ,p_ws_acc_cd in varchar2 default hr_api.g_varchar2
467: ,p_ws_due_dt in date default hr_api.g_date
468: ,p_ws_export_flag in varchar2 default hr_api.g_varchar2
469: ,p_ws_iss_dt in date default hr_api.g_date
462: ,p_bdgt_due_dt in date default hr_api.g_date
463: ,p_bdgt_export_flag in varchar2 default hr_api.g_varchar2
464: ,p_bdgt_iss_dt in date default hr_api.g_date
465: ,p_bdgt_stat_cd in varchar2 default hr_api.g_varchar2
466: ,p_ws_acc_cd in varchar2 default hr_api.g_varchar2
467: ,p_ws_due_dt in date default hr_api.g_date
468: ,p_ws_export_flag in varchar2 default hr_api.g_varchar2
469: ,p_ws_iss_dt in date default hr_api.g_date
470: ,p_ws_stat_cd in varchar2 default hr_api.g_varchar2
463: ,p_bdgt_export_flag in varchar2 default hr_api.g_varchar2
464: ,p_bdgt_iss_dt in date default hr_api.g_date
465: ,p_bdgt_stat_cd in varchar2 default hr_api.g_varchar2
466: ,p_ws_acc_cd in varchar2 default hr_api.g_varchar2
467: ,p_ws_due_dt in date default hr_api.g_date
468: ,p_ws_export_flag in varchar2 default hr_api.g_varchar2
469: ,p_ws_iss_dt in date default hr_api.g_date
470: ,p_ws_stat_cd in varchar2 default hr_api.g_varchar2
471: ,p_auto_asnd_dt in date default hr_api.g_date
464: ,p_bdgt_iss_dt in date default hr_api.g_date
465: ,p_bdgt_stat_cd in varchar2 default hr_api.g_varchar2
466: ,p_ws_acc_cd in varchar2 default hr_api.g_varchar2
467: ,p_ws_due_dt in date default hr_api.g_date
468: ,p_ws_export_flag in varchar2 default hr_api.g_varchar2
469: ,p_ws_iss_dt in date default hr_api.g_date
470: ,p_ws_stat_cd in varchar2 default hr_api.g_varchar2
471: ,p_auto_asnd_dt in date default hr_api.g_date
472: ,p_cbr_elig_perd_strt_dt in date default hr_api.g_date
465: ,p_bdgt_stat_cd in varchar2 default hr_api.g_varchar2
466: ,p_ws_acc_cd in varchar2 default hr_api.g_varchar2
467: ,p_ws_due_dt in date default hr_api.g_date
468: ,p_ws_export_flag in varchar2 default hr_api.g_varchar2
469: ,p_ws_iss_dt in date default hr_api.g_date
470: ,p_ws_stat_cd in varchar2 default hr_api.g_varchar2
471: ,p_auto_asnd_dt in date default hr_api.g_date
472: ,p_cbr_elig_perd_strt_dt in date default hr_api.g_date
473: ,p_cbr_elig_perd_end_dt in date default hr_api.g_date
466: ,p_ws_acc_cd in varchar2 default hr_api.g_varchar2
467: ,p_ws_due_dt in date default hr_api.g_date
468: ,p_ws_export_flag in varchar2 default hr_api.g_varchar2
469: ,p_ws_iss_dt in date default hr_api.g_date
470: ,p_ws_stat_cd in varchar2 default hr_api.g_varchar2
471: ,p_auto_asnd_dt in date default hr_api.g_date
472: ,p_cbr_elig_perd_strt_dt in date default hr_api.g_date
473: ,p_cbr_elig_perd_end_dt in date default hr_api.g_date
474: ,p_lee_rsn_id in number default hr_api.g_number
467: ,p_ws_due_dt in date default hr_api.g_date
468: ,p_ws_export_flag in varchar2 default hr_api.g_varchar2
469: ,p_ws_iss_dt in date default hr_api.g_date
470: ,p_ws_stat_cd in varchar2 default hr_api.g_varchar2
471: ,p_auto_asnd_dt in date default hr_api.g_date
472: ,p_cbr_elig_perd_strt_dt in date default hr_api.g_date
473: ,p_cbr_elig_perd_end_dt in date default hr_api.g_date
474: ,p_lee_rsn_id in number default hr_api.g_number
475: ,p_enrt_perd_id in number default hr_api.g_number
468: ,p_ws_export_flag in varchar2 default hr_api.g_varchar2
469: ,p_ws_iss_dt in date default hr_api.g_date
470: ,p_ws_stat_cd in varchar2 default hr_api.g_varchar2
471: ,p_auto_asnd_dt in date default hr_api.g_date
472: ,p_cbr_elig_perd_strt_dt in date default hr_api.g_date
473: ,p_cbr_elig_perd_end_dt in date default hr_api.g_date
474: ,p_lee_rsn_id in number default hr_api.g_number
475: ,p_enrt_perd_id in number default hr_api.g_number
476: ,p_per_in_ler_id in number default hr_api.g_number
469: ,p_ws_iss_dt in date default hr_api.g_date
470: ,p_ws_stat_cd in varchar2 default hr_api.g_varchar2
471: ,p_auto_asnd_dt in date default hr_api.g_date
472: ,p_cbr_elig_perd_strt_dt in date default hr_api.g_date
473: ,p_cbr_elig_perd_end_dt in date default hr_api.g_date
474: ,p_lee_rsn_id in number default hr_api.g_number
475: ,p_enrt_perd_id in number default hr_api.g_number
476: ,p_per_in_ler_id in number default hr_api.g_number
477: ,p_pgm_id in number default hr_api.g_number
470: ,p_ws_stat_cd in varchar2 default hr_api.g_varchar2
471: ,p_auto_asnd_dt in date default hr_api.g_date
472: ,p_cbr_elig_perd_strt_dt in date default hr_api.g_date
473: ,p_cbr_elig_perd_end_dt in date default hr_api.g_date
474: ,p_lee_rsn_id in number default hr_api.g_number
475: ,p_enrt_perd_id in number default hr_api.g_number
476: ,p_per_in_ler_id in number default hr_api.g_number
477: ,p_pgm_id in number default hr_api.g_number
478: ,p_pl_id in number default hr_api.g_number
471: ,p_auto_asnd_dt in date default hr_api.g_date
472: ,p_cbr_elig_perd_strt_dt in date default hr_api.g_date
473: ,p_cbr_elig_perd_end_dt in date default hr_api.g_date
474: ,p_lee_rsn_id in number default hr_api.g_number
475: ,p_enrt_perd_id in number default hr_api.g_number
476: ,p_per_in_ler_id in number default hr_api.g_number
477: ,p_pgm_id in number default hr_api.g_number
478: ,p_pl_id in number default hr_api.g_number
479: ,p_business_group_id in number default hr_api.g_number
472: ,p_cbr_elig_perd_strt_dt in date default hr_api.g_date
473: ,p_cbr_elig_perd_end_dt in date default hr_api.g_date
474: ,p_lee_rsn_id in number default hr_api.g_number
475: ,p_enrt_perd_id in number default hr_api.g_number
476: ,p_per_in_ler_id in number default hr_api.g_number
477: ,p_pgm_id in number default hr_api.g_number
478: ,p_pl_id in number default hr_api.g_number
479: ,p_business_group_id in number default hr_api.g_number
480: ,p_pel_attribute_category in varchar2 default hr_api.g_varchar2
473: ,p_cbr_elig_perd_end_dt in date default hr_api.g_date
474: ,p_lee_rsn_id in number default hr_api.g_number
475: ,p_enrt_perd_id in number default hr_api.g_number
476: ,p_per_in_ler_id in number default hr_api.g_number
477: ,p_pgm_id in number default hr_api.g_number
478: ,p_pl_id in number default hr_api.g_number
479: ,p_business_group_id in number default hr_api.g_number
480: ,p_pel_attribute_category in varchar2 default hr_api.g_varchar2
481: ,p_pel_attribute1 in varchar2 default hr_api.g_varchar2
474: ,p_lee_rsn_id in number default hr_api.g_number
475: ,p_enrt_perd_id in number default hr_api.g_number
476: ,p_per_in_ler_id in number default hr_api.g_number
477: ,p_pgm_id in number default hr_api.g_number
478: ,p_pl_id in number default hr_api.g_number
479: ,p_business_group_id in number default hr_api.g_number
480: ,p_pel_attribute_category in varchar2 default hr_api.g_varchar2
481: ,p_pel_attribute1 in varchar2 default hr_api.g_varchar2
482: ,p_pel_attribute2 in varchar2 default hr_api.g_varchar2
475: ,p_enrt_perd_id in number default hr_api.g_number
476: ,p_per_in_ler_id in number default hr_api.g_number
477: ,p_pgm_id in number default hr_api.g_number
478: ,p_pl_id in number default hr_api.g_number
479: ,p_business_group_id in number default hr_api.g_number
480: ,p_pel_attribute_category in varchar2 default hr_api.g_varchar2
481: ,p_pel_attribute1 in varchar2 default hr_api.g_varchar2
482: ,p_pel_attribute2 in varchar2 default hr_api.g_varchar2
483: ,p_pel_attribute3 in varchar2 default hr_api.g_varchar2
476: ,p_per_in_ler_id in number default hr_api.g_number
477: ,p_pgm_id in number default hr_api.g_number
478: ,p_pl_id in number default hr_api.g_number
479: ,p_business_group_id in number default hr_api.g_number
480: ,p_pel_attribute_category in varchar2 default hr_api.g_varchar2
481: ,p_pel_attribute1 in varchar2 default hr_api.g_varchar2
482: ,p_pel_attribute2 in varchar2 default hr_api.g_varchar2
483: ,p_pel_attribute3 in varchar2 default hr_api.g_varchar2
484: ,p_pel_attribute4 in varchar2 default hr_api.g_varchar2
477: ,p_pgm_id in number default hr_api.g_number
478: ,p_pl_id in number default hr_api.g_number
479: ,p_business_group_id in number default hr_api.g_number
480: ,p_pel_attribute_category in varchar2 default hr_api.g_varchar2
481: ,p_pel_attribute1 in varchar2 default hr_api.g_varchar2
482: ,p_pel_attribute2 in varchar2 default hr_api.g_varchar2
483: ,p_pel_attribute3 in varchar2 default hr_api.g_varchar2
484: ,p_pel_attribute4 in varchar2 default hr_api.g_varchar2
485: ,p_pel_attribute5 in varchar2 default hr_api.g_varchar2
478: ,p_pl_id in number default hr_api.g_number
479: ,p_business_group_id in number default hr_api.g_number
480: ,p_pel_attribute_category in varchar2 default hr_api.g_varchar2
481: ,p_pel_attribute1 in varchar2 default hr_api.g_varchar2
482: ,p_pel_attribute2 in varchar2 default hr_api.g_varchar2
483: ,p_pel_attribute3 in varchar2 default hr_api.g_varchar2
484: ,p_pel_attribute4 in varchar2 default hr_api.g_varchar2
485: ,p_pel_attribute5 in varchar2 default hr_api.g_varchar2
486: ,p_pel_attribute6 in varchar2 default hr_api.g_varchar2
479: ,p_business_group_id in number default hr_api.g_number
480: ,p_pel_attribute_category in varchar2 default hr_api.g_varchar2
481: ,p_pel_attribute1 in varchar2 default hr_api.g_varchar2
482: ,p_pel_attribute2 in varchar2 default hr_api.g_varchar2
483: ,p_pel_attribute3 in varchar2 default hr_api.g_varchar2
484: ,p_pel_attribute4 in varchar2 default hr_api.g_varchar2
485: ,p_pel_attribute5 in varchar2 default hr_api.g_varchar2
486: ,p_pel_attribute6 in varchar2 default hr_api.g_varchar2
487: ,p_pel_attribute7 in varchar2 default hr_api.g_varchar2
480: ,p_pel_attribute_category in varchar2 default hr_api.g_varchar2
481: ,p_pel_attribute1 in varchar2 default hr_api.g_varchar2
482: ,p_pel_attribute2 in varchar2 default hr_api.g_varchar2
483: ,p_pel_attribute3 in varchar2 default hr_api.g_varchar2
484: ,p_pel_attribute4 in varchar2 default hr_api.g_varchar2
485: ,p_pel_attribute5 in varchar2 default hr_api.g_varchar2
486: ,p_pel_attribute6 in varchar2 default hr_api.g_varchar2
487: ,p_pel_attribute7 in varchar2 default hr_api.g_varchar2
488: ,p_pel_attribute8 in varchar2 default hr_api.g_varchar2
481: ,p_pel_attribute1 in varchar2 default hr_api.g_varchar2
482: ,p_pel_attribute2 in varchar2 default hr_api.g_varchar2
483: ,p_pel_attribute3 in varchar2 default hr_api.g_varchar2
484: ,p_pel_attribute4 in varchar2 default hr_api.g_varchar2
485: ,p_pel_attribute5 in varchar2 default hr_api.g_varchar2
486: ,p_pel_attribute6 in varchar2 default hr_api.g_varchar2
487: ,p_pel_attribute7 in varchar2 default hr_api.g_varchar2
488: ,p_pel_attribute8 in varchar2 default hr_api.g_varchar2
489: ,p_pel_attribute9 in varchar2 default hr_api.g_varchar2
482: ,p_pel_attribute2 in varchar2 default hr_api.g_varchar2
483: ,p_pel_attribute3 in varchar2 default hr_api.g_varchar2
484: ,p_pel_attribute4 in varchar2 default hr_api.g_varchar2
485: ,p_pel_attribute5 in varchar2 default hr_api.g_varchar2
486: ,p_pel_attribute6 in varchar2 default hr_api.g_varchar2
487: ,p_pel_attribute7 in varchar2 default hr_api.g_varchar2
488: ,p_pel_attribute8 in varchar2 default hr_api.g_varchar2
489: ,p_pel_attribute9 in varchar2 default hr_api.g_varchar2
490: ,p_pel_attribute10 in varchar2 default hr_api.g_varchar2
483: ,p_pel_attribute3 in varchar2 default hr_api.g_varchar2
484: ,p_pel_attribute4 in varchar2 default hr_api.g_varchar2
485: ,p_pel_attribute5 in varchar2 default hr_api.g_varchar2
486: ,p_pel_attribute6 in varchar2 default hr_api.g_varchar2
487: ,p_pel_attribute7 in varchar2 default hr_api.g_varchar2
488: ,p_pel_attribute8 in varchar2 default hr_api.g_varchar2
489: ,p_pel_attribute9 in varchar2 default hr_api.g_varchar2
490: ,p_pel_attribute10 in varchar2 default hr_api.g_varchar2
491: ,p_pel_attribute11 in varchar2 default hr_api.g_varchar2
484: ,p_pel_attribute4 in varchar2 default hr_api.g_varchar2
485: ,p_pel_attribute5 in varchar2 default hr_api.g_varchar2
486: ,p_pel_attribute6 in varchar2 default hr_api.g_varchar2
487: ,p_pel_attribute7 in varchar2 default hr_api.g_varchar2
488: ,p_pel_attribute8 in varchar2 default hr_api.g_varchar2
489: ,p_pel_attribute9 in varchar2 default hr_api.g_varchar2
490: ,p_pel_attribute10 in varchar2 default hr_api.g_varchar2
491: ,p_pel_attribute11 in varchar2 default hr_api.g_varchar2
492: ,p_pel_attribute12 in varchar2 default hr_api.g_varchar2
485: ,p_pel_attribute5 in varchar2 default hr_api.g_varchar2
486: ,p_pel_attribute6 in varchar2 default hr_api.g_varchar2
487: ,p_pel_attribute7 in varchar2 default hr_api.g_varchar2
488: ,p_pel_attribute8 in varchar2 default hr_api.g_varchar2
489: ,p_pel_attribute9 in varchar2 default hr_api.g_varchar2
490: ,p_pel_attribute10 in varchar2 default hr_api.g_varchar2
491: ,p_pel_attribute11 in varchar2 default hr_api.g_varchar2
492: ,p_pel_attribute12 in varchar2 default hr_api.g_varchar2
493: ,p_pel_attribute13 in varchar2 default hr_api.g_varchar2
486: ,p_pel_attribute6 in varchar2 default hr_api.g_varchar2
487: ,p_pel_attribute7 in varchar2 default hr_api.g_varchar2
488: ,p_pel_attribute8 in varchar2 default hr_api.g_varchar2
489: ,p_pel_attribute9 in varchar2 default hr_api.g_varchar2
490: ,p_pel_attribute10 in varchar2 default hr_api.g_varchar2
491: ,p_pel_attribute11 in varchar2 default hr_api.g_varchar2
492: ,p_pel_attribute12 in varchar2 default hr_api.g_varchar2
493: ,p_pel_attribute13 in varchar2 default hr_api.g_varchar2
494: ,p_pel_attribute14 in varchar2 default hr_api.g_varchar2
487: ,p_pel_attribute7 in varchar2 default hr_api.g_varchar2
488: ,p_pel_attribute8 in varchar2 default hr_api.g_varchar2
489: ,p_pel_attribute9 in varchar2 default hr_api.g_varchar2
490: ,p_pel_attribute10 in varchar2 default hr_api.g_varchar2
491: ,p_pel_attribute11 in varchar2 default hr_api.g_varchar2
492: ,p_pel_attribute12 in varchar2 default hr_api.g_varchar2
493: ,p_pel_attribute13 in varchar2 default hr_api.g_varchar2
494: ,p_pel_attribute14 in varchar2 default hr_api.g_varchar2
495: ,p_pel_attribute15 in varchar2 default hr_api.g_varchar2
488: ,p_pel_attribute8 in varchar2 default hr_api.g_varchar2
489: ,p_pel_attribute9 in varchar2 default hr_api.g_varchar2
490: ,p_pel_attribute10 in varchar2 default hr_api.g_varchar2
491: ,p_pel_attribute11 in varchar2 default hr_api.g_varchar2
492: ,p_pel_attribute12 in varchar2 default hr_api.g_varchar2
493: ,p_pel_attribute13 in varchar2 default hr_api.g_varchar2
494: ,p_pel_attribute14 in varchar2 default hr_api.g_varchar2
495: ,p_pel_attribute15 in varchar2 default hr_api.g_varchar2
496: ,p_pel_attribute16 in varchar2 default hr_api.g_varchar2
489: ,p_pel_attribute9 in varchar2 default hr_api.g_varchar2
490: ,p_pel_attribute10 in varchar2 default hr_api.g_varchar2
491: ,p_pel_attribute11 in varchar2 default hr_api.g_varchar2
492: ,p_pel_attribute12 in varchar2 default hr_api.g_varchar2
493: ,p_pel_attribute13 in varchar2 default hr_api.g_varchar2
494: ,p_pel_attribute14 in varchar2 default hr_api.g_varchar2
495: ,p_pel_attribute15 in varchar2 default hr_api.g_varchar2
496: ,p_pel_attribute16 in varchar2 default hr_api.g_varchar2
497: ,p_pel_attribute17 in varchar2 default hr_api.g_varchar2
490: ,p_pel_attribute10 in varchar2 default hr_api.g_varchar2
491: ,p_pel_attribute11 in varchar2 default hr_api.g_varchar2
492: ,p_pel_attribute12 in varchar2 default hr_api.g_varchar2
493: ,p_pel_attribute13 in varchar2 default hr_api.g_varchar2
494: ,p_pel_attribute14 in varchar2 default hr_api.g_varchar2
495: ,p_pel_attribute15 in varchar2 default hr_api.g_varchar2
496: ,p_pel_attribute16 in varchar2 default hr_api.g_varchar2
497: ,p_pel_attribute17 in varchar2 default hr_api.g_varchar2
498: ,p_pel_attribute18 in varchar2 default hr_api.g_varchar2
491: ,p_pel_attribute11 in varchar2 default hr_api.g_varchar2
492: ,p_pel_attribute12 in varchar2 default hr_api.g_varchar2
493: ,p_pel_attribute13 in varchar2 default hr_api.g_varchar2
494: ,p_pel_attribute14 in varchar2 default hr_api.g_varchar2
495: ,p_pel_attribute15 in varchar2 default hr_api.g_varchar2
496: ,p_pel_attribute16 in varchar2 default hr_api.g_varchar2
497: ,p_pel_attribute17 in varchar2 default hr_api.g_varchar2
498: ,p_pel_attribute18 in varchar2 default hr_api.g_varchar2
499: ,p_pel_attribute19 in varchar2 default hr_api.g_varchar2
492: ,p_pel_attribute12 in varchar2 default hr_api.g_varchar2
493: ,p_pel_attribute13 in varchar2 default hr_api.g_varchar2
494: ,p_pel_attribute14 in varchar2 default hr_api.g_varchar2
495: ,p_pel_attribute15 in varchar2 default hr_api.g_varchar2
496: ,p_pel_attribute16 in varchar2 default hr_api.g_varchar2
497: ,p_pel_attribute17 in varchar2 default hr_api.g_varchar2
498: ,p_pel_attribute18 in varchar2 default hr_api.g_varchar2
499: ,p_pel_attribute19 in varchar2 default hr_api.g_varchar2
500: ,p_pel_attribute20 in varchar2 default hr_api.g_varchar2
493: ,p_pel_attribute13 in varchar2 default hr_api.g_varchar2
494: ,p_pel_attribute14 in varchar2 default hr_api.g_varchar2
495: ,p_pel_attribute15 in varchar2 default hr_api.g_varchar2
496: ,p_pel_attribute16 in varchar2 default hr_api.g_varchar2
497: ,p_pel_attribute17 in varchar2 default hr_api.g_varchar2
498: ,p_pel_attribute18 in varchar2 default hr_api.g_varchar2
499: ,p_pel_attribute19 in varchar2 default hr_api.g_varchar2
500: ,p_pel_attribute20 in varchar2 default hr_api.g_varchar2
501: ,p_pel_attribute21 in varchar2 default hr_api.g_varchar2
494: ,p_pel_attribute14 in varchar2 default hr_api.g_varchar2
495: ,p_pel_attribute15 in varchar2 default hr_api.g_varchar2
496: ,p_pel_attribute16 in varchar2 default hr_api.g_varchar2
497: ,p_pel_attribute17 in varchar2 default hr_api.g_varchar2
498: ,p_pel_attribute18 in varchar2 default hr_api.g_varchar2
499: ,p_pel_attribute19 in varchar2 default hr_api.g_varchar2
500: ,p_pel_attribute20 in varchar2 default hr_api.g_varchar2
501: ,p_pel_attribute21 in varchar2 default hr_api.g_varchar2
502: ,p_pel_attribute22 in varchar2 default hr_api.g_varchar2
495: ,p_pel_attribute15 in varchar2 default hr_api.g_varchar2
496: ,p_pel_attribute16 in varchar2 default hr_api.g_varchar2
497: ,p_pel_attribute17 in varchar2 default hr_api.g_varchar2
498: ,p_pel_attribute18 in varchar2 default hr_api.g_varchar2
499: ,p_pel_attribute19 in varchar2 default hr_api.g_varchar2
500: ,p_pel_attribute20 in varchar2 default hr_api.g_varchar2
501: ,p_pel_attribute21 in varchar2 default hr_api.g_varchar2
502: ,p_pel_attribute22 in varchar2 default hr_api.g_varchar2
503: ,p_pel_attribute23 in varchar2 default hr_api.g_varchar2
496: ,p_pel_attribute16 in varchar2 default hr_api.g_varchar2
497: ,p_pel_attribute17 in varchar2 default hr_api.g_varchar2
498: ,p_pel_attribute18 in varchar2 default hr_api.g_varchar2
499: ,p_pel_attribute19 in varchar2 default hr_api.g_varchar2
500: ,p_pel_attribute20 in varchar2 default hr_api.g_varchar2
501: ,p_pel_attribute21 in varchar2 default hr_api.g_varchar2
502: ,p_pel_attribute22 in varchar2 default hr_api.g_varchar2
503: ,p_pel_attribute23 in varchar2 default hr_api.g_varchar2
504: ,p_pel_attribute24 in varchar2 default hr_api.g_varchar2
497: ,p_pel_attribute17 in varchar2 default hr_api.g_varchar2
498: ,p_pel_attribute18 in varchar2 default hr_api.g_varchar2
499: ,p_pel_attribute19 in varchar2 default hr_api.g_varchar2
500: ,p_pel_attribute20 in varchar2 default hr_api.g_varchar2
501: ,p_pel_attribute21 in varchar2 default hr_api.g_varchar2
502: ,p_pel_attribute22 in varchar2 default hr_api.g_varchar2
503: ,p_pel_attribute23 in varchar2 default hr_api.g_varchar2
504: ,p_pel_attribute24 in varchar2 default hr_api.g_varchar2
505: ,p_pel_attribute25 in varchar2 default hr_api.g_varchar2
498: ,p_pel_attribute18 in varchar2 default hr_api.g_varchar2
499: ,p_pel_attribute19 in varchar2 default hr_api.g_varchar2
500: ,p_pel_attribute20 in varchar2 default hr_api.g_varchar2
501: ,p_pel_attribute21 in varchar2 default hr_api.g_varchar2
502: ,p_pel_attribute22 in varchar2 default hr_api.g_varchar2
503: ,p_pel_attribute23 in varchar2 default hr_api.g_varchar2
504: ,p_pel_attribute24 in varchar2 default hr_api.g_varchar2
505: ,p_pel_attribute25 in varchar2 default hr_api.g_varchar2
506: ,p_pel_attribute26 in varchar2 default hr_api.g_varchar2
499: ,p_pel_attribute19 in varchar2 default hr_api.g_varchar2
500: ,p_pel_attribute20 in varchar2 default hr_api.g_varchar2
501: ,p_pel_attribute21 in varchar2 default hr_api.g_varchar2
502: ,p_pel_attribute22 in varchar2 default hr_api.g_varchar2
503: ,p_pel_attribute23 in varchar2 default hr_api.g_varchar2
504: ,p_pel_attribute24 in varchar2 default hr_api.g_varchar2
505: ,p_pel_attribute25 in varchar2 default hr_api.g_varchar2
506: ,p_pel_attribute26 in varchar2 default hr_api.g_varchar2
507: ,p_pel_attribute27 in varchar2 default hr_api.g_varchar2
500: ,p_pel_attribute20 in varchar2 default hr_api.g_varchar2
501: ,p_pel_attribute21 in varchar2 default hr_api.g_varchar2
502: ,p_pel_attribute22 in varchar2 default hr_api.g_varchar2
503: ,p_pel_attribute23 in varchar2 default hr_api.g_varchar2
504: ,p_pel_attribute24 in varchar2 default hr_api.g_varchar2
505: ,p_pel_attribute25 in varchar2 default hr_api.g_varchar2
506: ,p_pel_attribute26 in varchar2 default hr_api.g_varchar2
507: ,p_pel_attribute27 in varchar2 default hr_api.g_varchar2
508: ,p_pel_attribute28 in varchar2 default hr_api.g_varchar2
501: ,p_pel_attribute21 in varchar2 default hr_api.g_varchar2
502: ,p_pel_attribute22 in varchar2 default hr_api.g_varchar2
503: ,p_pel_attribute23 in varchar2 default hr_api.g_varchar2
504: ,p_pel_attribute24 in varchar2 default hr_api.g_varchar2
505: ,p_pel_attribute25 in varchar2 default hr_api.g_varchar2
506: ,p_pel_attribute26 in varchar2 default hr_api.g_varchar2
507: ,p_pel_attribute27 in varchar2 default hr_api.g_varchar2
508: ,p_pel_attribute28 in varchar2 default hr_api.g_varchar2
509: ,p_pel_attribute29 in varchar2 default hr_api.g_varchar2
502: ,p_pel_attribute22 in varchar2 default hr_api.g_varchar2
503: ,p_pel_attribute23 in varchar2 default hr_api.g_varchar2
504: ,p_pel_attribute24 in varchar2 default hr_api.g_varchar2
505: ,p_pel_attribute25 in varchar2 default hr_api.g_varchar2
506: ,p_pel_attribute26 in varchar2 default hr_api.g_varchar2
507: ,p_pel_attribute27 in varchar2 default hr_api.g_varchar2
508: ,p_pel_attribute28 in varchar2 default hr_api.g_varchar2
509: ,p_pel_attribute29 in varchar2 default hr_api.g_varchar2
510: ,p_pel_attribute30 in varchar2 default hr_api.g_varchar2
503: ,p_pel_attribute23 in varchar2 default hr_api.g_varchar2
504: ,p_pel_attribute24 in varchar2 default hr_api.g_varchar2
505: ,p_pel_attribute25 in varchar2 default hr_api.g_varchar2
506: ,p_pel_attribute26 in varchar2 default hr_api.g_varchar2
507: ,p_pel_attribute27 in varchar2 default hr_api.g_varchar2
508: ,p_pel_attribute28 in varchar2 default hr_api.g_varchar2
509: ,p_pel_attribute29 in varchar2 default hr_api.g_varchar2
510: ,p_pel_attribute30 in varchar2 default hr_api.g_varchar2
511: ,p_request_id in number default hr_api.g_number
504: ,p_pel_attribute24 in varchar2 default hr_api.g_varchar2
505: ,p_pel_attribute25 in varchar2 default hr_api.g_varchar2
506: ,p_pel_attribute26 in varchar2 default hr_api.g_varchar2
507: ,p_pel_attribute27 in varchar2 default hr_api.g_varchar2
508: ,p_pel_attribute28 in varchar2 default hr_api.g_varchar2
509: ,p_pel_attribute29 in varchar2 default hr_api.g_varchar2
510: ,p_pel_attribute30 in varchar2 default hr_api.g_varchar2
511: ,p_request_id in number default hr_api.g_number
512: ,p_program_application_id in number default hr_api.g_number
505: ,p_pel_attribute25 in varchar2 default hr_api.g_varchar2
506: ,p_pel_attribute26 in varchar2 default hr_api.g_varchar2
507: ,p_pel_attribute27 in varchar2 default hr_api.g_varchar2
508: ,p_pel_attribute28 in varchar2 default hr_api.g_varchar2
509: ,p_pel_attribute29 in varchar2 default hr_api.g_varchar2
510: ,p_pel_attribute30 in varchar2 default hr_api.g_varchar2
511: ,p_request_id in number default hr_api.g_number
512: ,p_program_application_id in number default hr_api.g_number
513: ,p_program_id in number default hr_api.g_number
506: ,p_pel_attribute26 in varchar2 default hr_api.g_varchar2
507: ,p_pel_attribute27 in varchar2 default hr_api.g_varchar2
508: ,p_pel_attribute28 in varchar2 default hr_api.g_varchar2
509: ,p_pel_attribute29 in varchar2 default hr_api.g_varchar2
510: ,p_pel_attribute30 in varchar2 default hr_api.g_varchar2
511: ,p_request_id in number default hr_api.g_number
512: ,p_program_application_id in number default hr_api.g_number
513: ,p_program_id in number default hr_api.g_number
514: ,p_program_update_date in date default hr_api.g_date
507: ,p_pel_attribute27 in varchar2 default hr_api.g_varchar2
508: ,p_pel_attribute28 in varchar2 default hr_api.g_varchar2
509: ,p_pel_attribute29 in varchar2 default hr_api.g_varchar2
510: ,p_pel_attribute30 in varchar2 default hr_api.g_varchar2
511: ,p_request_id in number default hr_api.g_number
512: ,p_program_application_id in number default hr_api.g_number
513: ,p_program_id in number default hr_api.g_number
514: ,p_program_update_date in date default hr_api.g_date
515: ,p_object_version_number in out nocopy number
508: ,p_pel_attribute28 in varchar2 default hr_api.g_varchar2
509: ,p_pel_attribute29 in varchar2 default hr_api.g_varchar2
510: ,p_pel_attribute30 in varchar2 default hr_api.g_varchar2
511: ,p_request_id in number default hr_api.g_number
512: ,p_program_application_id in number default hr_api.g_number
513: ,p_program_id in number default hr_api.g_number
514: ,p_program_update_date in date default hr_api.g_date
515: ,p_object_version_number in out nocopy number
516: ,p_effective_date in date
509: ,p_pel_attribute29 in varchar2 default hr_api.g_varchar2
510: ,p_pel_attribute30 in varchar2 default hr_api.g_varchar2
511: ,p_request_id in number default hr_api.g_number
512: ,p_program_application_id in number default hr_api.g_number
513: ,p_program_id in number default hr_api.g_number
514: ,p_program_update_date in date default hr_api.g_date
515: ,p_object_version_number in out nocopy number
516: ,p_effective_date in date
517: ,p_return_status out nocopy varchar2
510: ,p_pel_attribute30 in varchar2 default hr_api.g_varchar2
511: ,p_request_id in number default hr_api.g_number
512: ,p_program_application_id in number default hr_api.g_number
513: ,p_program_id in number default hr_api.g_number
514: ,p_program_update_date in date default hr_api.g_date
515: ,p_object_version_number in out nocopy number
516: ,p_effective_date in date
517: ,p_return_status out nocopy varchar2
518: ) is
542: --
543: -- Convert constant values to their corresponding boolean value
544: --
545: l_validate :=
546: hr_api.constant_to_boolean
547: (p_constant_value => p_validate);
548: --
549: -- Register Surrogate ID or user key values
550: --