23: --
24: -- {End of comments}
25: -- ----------------------------------------------------------------------------
26: PROCEDURE create_pil_elctbl_chc_popl
27: (p_validate in number default hr_api.g_false_num
28: ,p_pil_elctbl_chc_popl_id out nocopy number
29: ,p_dflt_enrt_dt in date default null
30: ,p_dflt_asnd_dt in date default null
31: ,p_elcns_made_dt in date default null
124: --
125: -- {End of comments}
126: -- ----------------------------------------------------------------------------
127: PROCEDURE delete_pil_elctbl_chc_popl
128: (p_validate in number default hr_api.g_false_num
129: ,p_pil_elctbl_chc_popl_id in number
130: ,p_object_version_number in out nocopy number
131: ,p_effective_date in date
132: ,p_return_status out nocopy varchar2
182: --
183: -- {End of comments}
184: -- ----------------------------------------------------------------------------
185: PROCEDURE update_pil_elctbl_chc_popl
186: (p_validate in number default hr_api.g_false_num
187: ,p_pil_elctbl_chc_popl_id in number
188: ,p_dflt_enrt_dt in date default hr_api.g_date
189: ,p_dflt_asnd_dt in date default hr_api.g_date
190: ,p_elcns_made_dt in date default hr_api.g_date
184: -- ----------------------------------------------------------------------------
185: PROCEDURE update_pil_elctbl_chc_popl
186: (p_validate in number default hr_api.g_false_num
187: ,p_pil_elctbl_chc_popl_id in number
188: ,p_dflt_enrt_dt in date default hr_api.g_date
189: ,p_dflt_asnd_dt in date default hr_api.g_date
190: ,p_elcns_made_dt in date default hr_api.g_date
191: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
192: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
185: PROCEDURE update_pil_elctbl_chc_popl
186: (p_validate in number default hr_api.g_false_num
187: ,p_pil_elctbl_chc_popl_id in number
188: ,p_dflt_enrt_dt in date default hr_api.g_date
189: ,p_dflt_asnd_dt in date default hr_api.g_date
190: ,p_elcns_made_dt in date default hr_api.g_date
191: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
192: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
193: ,p_enrt_perd_end_dt in date default hr_api.g_date
186: (p_validate in number default hr_api.g_false_num
187: ,p_pil_elctbl_chc_popl_id in number
188: ,p_dflt_enrt_dt in date default hr_api.g_date
189: ,p_dflt_asnd_dt in date default hr_api.g_date
190: ,p_elcns_made_dt in date default hr_api.g_date
191: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
192: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
193: ,p_enrt_perd_end_dt in date default hr_api.g_date
194: ,p_enrt_perd_strt_dt in date default hr_api.g_date
187: ,p_pil_elctbl_chc_popl_id in number
188: ,p_dflt_enrt_dt in date default hr_api.g_date
189: ,p_dflt_asnd_dt in date default hr_api.g_date
190: ,p_elcns_made_dt in date default hr_api.g_date
191: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
192: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
193: ,p_enrt_perd_end_dt in date default hr_api.g_date
194: ,p_enrt_perd_strt_dt in date default hr_api.g_date
195: ,p_procg_end_dt in date default hr_api.g_date
188: ,p_dflt_enrt_dt in date default hr_api.g_date
189: ,p_dflt_asnd_dt in date default hr_api.g_date
190: ,p_elcns_made_dt in date default hr_api.g_date
191: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
192: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
193: ,p_enrt_perd_end_dt in date default hr_api.g_date
194: ,p_enrt_perd_strt_dt in date default hr_api.g_date
195: ,p_procg_end_dt in date default hr_api.g_date
196: ,p_pil_elctbl_popl_stat_cd in varchar2 default hr_api.g_varchar2
189: ,p_dflt_asnd_dt in date default hr_api.g_date
190: ,p_elcns_made_dt in date default hr_api.g_date
191: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
192: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
193: ,p_enrt_perd_end_dt in date default hr_api.g_date
194: ,p_enrt_perd_strt_dt in date default hr_api.g_date
195: ,p_procg_end_dt in date default hr_api.g_date
196: ,p_pil_elctbl_popl_stat_cd in varchar2 default hr_api.g_varchar2
197: ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
190: ,p_elcns_made_dt in date default hr_api.g_date
191: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
192: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
193: ,p_enrt_perd_end_dt in date default hr_api.g_date
194: ,p_enrt_perd_strt_dt in date default hr_api.g_date
195: ,p_procg_end_dt in date default hr_api.g_date
196: ,p_pil_elctbl_popl_stat_cd in varchar2 default hr_api.g_varchar2
197: ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
198: ,p_uom in varchar2 default hr_api.g_varchar2
191: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
192: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
193: ,p_enrt_perd_end_dt in date default hr_api.g_date
194: ,p_enrt_perd_strt_dt in date default hr_api.g_date
195: ,p_procg_end_dt in date default hr_api.g_date
196: ,p_pil_elctbl_popl_stat_cd in varchar2 default hr_api.g_varchar2
197: ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
198: ,p_uom in varchar2 default hr_api.g_varchar2
199: ,p_comments in varchar2 default hr_api.g_varchar2
192: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
193: ,p_enrt_perd_end_dt in date default hr_api.g_date
194: ,p_enrt_perd_strt_dt in date default hr_api.g_date
195: ,p_procg_end_dt in date default hr_api.g_date
196: ,p_pil_elctbl_popl_stat_cd in varchar2 default hr_api.g_varchar2
197: ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
198: ,p_uom in varchar2 default hr_api.g_varchar2
199: ,p_comments in varchar2 default hr_api.g_varchar2
200: ,p_mgr_ovrid_dt in date default hr_api.g_date
193: ,p_enrt_perd_end_dt in date default hr_api.g_date
194: ,p_enrt_perd_strt_dt in date default hr_api.g_date
195: ,p_procg_end_dt in date default hr_api.g_date
196: ,p_pil_elctbl_popl_stat_cd in varchar2 default hr_api.g_varchar2
197: ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
198: ,p_uom in varchar2 default hr_api.g_varchar2
199: ,p_comments in varchar2 default hr_api.g_varchar2
200: ,p_mgr_ovrid_dt in date default hr_api.g_date
201: ,p_ws_mgr_id in number default hr_api.g_number
194: ,p_enrt_perd_strt_dt in date default hr_api.g_date
195: ,p_procg_end_dt in date default hr_api.g_date
196: ,p_pil_elctbl_popl_stat_cd in varchar2 default hr_api.g_varchar2
197: ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
198: ,p_uom in varchar2 default hr_api.g_varchar2
199: ,p_comments in varchar2 default hr_api.g_varchar2
200: ,p_mgr_ovrid_dt in date default hr_api.g_date
201: ,p_ws_mgr_id in number default hr_api.g_number
202: ,p_mgr_ovrid_person_id in number default hr_api.g_number
195: ,p_procg_end_dt in date default hr_api.g_date
196: ,p_pil_elctbl_popl_stat_cd in varchar2 default hr_api.g_varchar2
197: ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
198: ,p_uom in varchar2 default hr_api.g_varchar2
199: ,p_comments in varchar2 default hr_api.g_varchar2
200: ,p_mgr_ovrid_dt in date default hr_api.g_date
201: ,p_ws_mgr_id in number default hr_api.g_number
202: ,p_mgr_ovrid_person_id in number default hr_api.g_number
203: ,p_assignment_id in number default hr_api.g_number
196: ,p_pil_elctbl_popl_stat_cd in varchar2 default hr_api.g_varchar2
197: ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
198: ,p_uom in varchar2 default hr_api.g_varchar2
199: ,p_comments in varchar2 default hr_api.g_varchar2
200: ,p_mgr_ovrid_dt in date default hr_api.g_date
201: ,p_ws_mgr_id in number default hr_api.g_number
202: ,p_mgr_ovrid_person_id in number default hr_api.g_number
203: ,p_assignment_id in number default hr_api.g_number
204: ,p_bdgt_acc_cd in varchar2 default hr_api.g_varchar2
197: ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
198: ,p_uom in varchar2 default hr_api.g_varchar2
199: ,p_comments in varchar2 default hr_api.g_varchar2
200: ,p_mgr_ovrid_dt in date default hr_api.g_date
201: ,p_ws_mgr_id in number default hr_api.g_number
202: ,p_mgr_ovrid_person_id in number default hr_api.g_number
203: ,p_assignment_id in number default hr_api.g_number
204: ,p_bdgt_acc_cd in varchar2 default hr_api.g_varchar2
205: ,p_pop_cd in varchar2 default hr_api.g_varchar2
198: ,p_uom in varchar2 default hr_api.g_varchar2
199: ,p_comments in varchar2 default hr_api.g_varchar2
200: ,p_mgr_ovrid_dt in date default hr_api.g_date
201: ,p_ws_mgr_id in number default hr_api.g_number
202: ,p_mgr_ovrid_person_id in number default hr_api.g_number
203: ,p_assignment_id in number default hr_api.g_number
204: ,p_bdgt_acc_cd in varchar2 default hr_api.g_varchar2
205: ,p_pop_cd in varchar2 default hr_api.g_varchar2
206: ,p_bdgt_due_dt in date default hr_api.g_date
199: ,p_comments in varchar2 default hr_api.g_varchar2
200: ,p_mgr_ovrid_dt in date default hr_api.g_date
201: ,p_ws_mgr_id in number default hr_api.g_number
202: ,p_mgr_ovrid_person_id in number default hr_api.g_number
203: ,p_assignment_id in number default hr_api.g_number
204: ,p_bdgt_acc_cd in varchar2 default hr_api.g_varchar2
205: ,p_pop_cd in varchar2 default hr_api.g_varchar2
206: ,p_bdgt_due_dt in date default hr_api.g_date
207: ,p_bdgt_export_flag in varchar2 default hr_api.g_varchar2
200: ,p_mgr_ovrid_dt in date default hr_api.g_date
201: ,p_ws_mgr_id in number default hr_api.g_number
202: ,p_mgr_ovrid_person_id in number default hr_api.g_number
203: ,p_assignment_id in number default hr_api.g_number
204: ,p_bdgt_acc_cd in varchar2 default hr_api.g_varchar2
205: ,p_pop_cd in varchar2 default hr_api.g_varchar2
206: ,p_bdgt_due_dt in date default hr_api.g_date
207: ,p_bdgt_export_flag in varchar2 default hr_api.g_varchar2
208: ,p_bdgt_iss_dt in date default hr_api.g_date
201: ,p_ws_mgr_id in number default hr_api.g_number
202: ,p_mgr_ovrid_person_id in number default hr_api.g_number
203: ,p_assignment_id in number default hr_api.g_number
204: ,p_bdgt_acc_cd in varchar2 default hr_api.g_varchar2
205: ,p_pop_cd in varchar2 default hr_api.g_varchar2
206: ,p_bdgt_due_dt in date default hr_api.g_date
207: ,p_bdgt_export_flag in varchar2 default hr_api.g_varchar2
208: ,p_bdgt_iss_dt in date default hr_api.g_date
209: ,p_bdgt_stat_cd in varchar2 default hr_api.g_varchar2
202: ,p_mgr_ovrid_person_id in number default hr_api.g_number
203: ,p_assignment_id in number default hr_api.g_number
204: ,p_bdgt_acc_cd in varchar2 default hr_api.g_varchar2
205: ,p_pop_cd in varchar2 default hr_api.g_varchar2
206: ,p_bdgt_due_dt in date default hr_api.g_date
207: ,p_bdgt_export_flag in varchar2 default hr_api.g_varchar2
208: ,p_bdgt_iss_dt in date default hr_api.g_date
209: ,p_bdgt_stat_cd in varchar2 default hr_api.g_varchar2
210: ,p_ws_acc_cd in varchar2 default hr_api.g_varchar2
203: ,p_assignment_id in number default hr_api.g_number
204: ,p_bdgt_acc_cd in varchar2 default hr_api.g_varchar2
205: ,p_pop_cd in varchar2 default hr_api.g_varchar2
206: ,p_bdgt_due_dt in date default hr_api.g_date
207: ,p_bdgt_export_flag in varchar2 default hr_api.g_varchar2
208: ,p_bdgt_iss_dt in date default hr_api.g_date
209: ,p_bdgt_stat_cd in varchar2 default hr_api.g_varchar2
210: ,p_ws_acc_cd in varchar2 default hr_api.g_varchar2
211: ,p_ws_due_dt in date default hr_api.g_date
204: ,p_bdgt_acc_cd in varchar2 default hr_api.g_varchar2
205: ,p_pop_cd in varchar2 default hr_api.g_varchar2
206: ,p_bdgt_due_dt in date default hr_api.g_date
207: ,p_bdgt_export_flag in varchar2 default hr_api.g_varchar2
208: ,p_bdgt_iss_dt in date default hr_api.g_date
209: ,p_bdgt_stat_cd in varchar2 default hr_api.g_varchar2
210: ,p_ws_acc_cd in varchar2 default hr_api.g_varchar2
211: ,p_ws_due_dt in date default hr_api.g_date
212: ,p_ws_export_flag in varchar2 default hr_api.g_varchar2
205: ,p_pop_cd in varchar2 default hr_api.g_varchar2
206: ,p_bdgt_due_dt in date default hr_api.g_date
207: ,p_bdgt_export_flag in varchar2 default hr_api.g_varchar2
208: ,p_bdgt_iss_dt in date default hr_api.g_date
209: ,p_bdgt_stat_cd in varchar2 default hr_api.g_varchar2
210: ,p_ws_acc_cd in varchar2 default hr_api.g_varchar2
211: ,p_ws_due_dt in date default hr_api.g_date
212: ,p_ws_export_flag in varchar2 default hr_api.g_varchar2
213: ,p_ws_iss_dt in date default hr_api.g_date
206: ,p_bdgt_due_dt in date default hr_api.g_date
207: ,p_bdgt_export_flag in varchar2 default hr_api.g_varchar2
208: ,p_bdgt_iss_dt in date default hr_api.g_date
209: ,p_bdgt_stat_cd in varchar2 default hr_api.g_varchar2
210: ,p_ws_acc_cd in varchar2 default hr_api.g_varchar2
211: ,p_ws_due_dt in date default hr_api.g_date
212: ,p_ws_export_flag in varchar2 default hr_api.g_varchar2
213: ,p_ws_iss_dt in date default hr_api.g_date
214: ,p_ws_stat_cd in varchar2 default hr_api.g_varchar2
207: ,p_bdgt_export_flag in varchar2 default hr_api.g_varchar2
208: ,p_bdgt_iss_dt in date default hr_api.g_date
209: ,p_bdgt_stat_cd in varchar2 default hr_api.g_varchar2
210: ,p_ws_acc_cd in varchar2 default hr_api.g_varchar2
211: ,p_ws_due_dt in date default hr_api.g_date
212: ,p_ws_export_flag in varchar2 default hr_api.g_varchar2
213: ,p_ws_iss_dt in date default hr_api.g_date
214: ,p_ws_stat_cd in varchar2 default hr_api.g_varchar2
215: ,p_auto_asnd_dt in date default hr_api.g_date
208: ,p_bdgt_iss_dt in date default hr_api.g_date
209: ,p_bdgt_stat_cd in varchar2 default hr_api.g_varchar2
210: ,p_ws_acc_cd in varchar2 default hr_api.g_varchar2
211: ,p_ws_due_dt in date default hr_api.g_date
212: ,p_ws_export_flag in varchar2 default hr_api.g_varchar2
213: ,p_ws_iss_dt in date default hr_api.g_date
214: ,p_ws_stat_cd in varchar2 default hr_api.g_varchar2
215: ,p_auto_asnd_dt in date default hr_api.g_date
216: ,p_cbr_elig_perd_strt_dt in date default hr_api.g_date
209: ,p_bdgt_stat_cd in varchar2 default hr_api.g_varchar2
210: ,p_ws_acc_cd in varchar2 default hr_api.g_varchar2
211: ,p_ws_due_dt in date default hr_api.g_date
212: ,p_ws_export_flag in varchar2 default hr_api.g_varchar2
213: ,p_ws_iss_dt in date default hr_api.g_date
214: ,p_ws_stat_cd in varchar2 default hr_api.g_varchar2
215: ,p_auto_asnd_dt in date default hr_api.g_date
216: ,p_cbr_elig_perd_strt_dt in date default hr_api.g_date
217: ,p_cbr_elig_perd_end_dt in date default hr_api.g_date
210: ,p_ws_acc_cd in varchar2 default hr_api.g_varchar2
211: ,p_ws_due_dt in date default hr_api.g_date
212: ,p_ws_export_flag in varchar2 default hr_api.g_varchar2
213: ,p_ws_iss_dt in date default hr_api.g_date
214: ,p_ws_stat_cd in varchar2 default hr_api.g_varchar2
215: ,p_auto_asnd_dt in date default hr_api.g_date
216: ,p_cbr_elig_perd_strt_dt in date default hr_api.g_date
217: ,p_cbr_elig_perd_end_dt in date default hr_api.g_date
218: ,p_lee_rsn_id in number default hr_api.g_number
211: ,p_ws_due_dt in date default hr_api.g_date
212: ,p_ws_export_flag in varchar2 default hr_api.g_varchar2
213: ,p_ws_iss_dt in date default hr_api.g_date
214: ,p_ws_stat_cd in varchar2 default hr_api.g_varchar2
215: ,p_auto_asnd_dt in date default hr_api.g_date
216: ,p_cbr_elig_perd_strt_dt in date default hr_api.g_date
217: ,p_cbr_elig_perd_end_dt in date default hr_api.g_date
218: ,p_lee_rsn_id in number default hr_api.g_number
219: ,p_enrt_perd_id in number default hr_api.g_number
212: ,p_ws_export_flag in varchar2 default hr_api.g_varchar2
213: ,p_ws_iss_dt in date default hr_api.g_date
214: ,p_ws_stat_cd in varchar2 default hr_api.g_varchar2
215: ,p_auto_asnd_dt in date default hr_api.g_date
216: ,p_cbr_elig_perd_strt_dt in date default hr_api.g_date
217: ,p_cbr_elig_perd_end_dt in date default hr_api.g_date
218: ,p_lee_rsn_id in number default hr_api.g_number
219: ,p_enrt_perd_id in number default hr_api.g_number
220: ,p_per_in_ler_id in number default hr_api.g_number
213: ,p_ws_iss_dt in date default hr_api.g_date
214: ,p_ws_stat_cd in varchar2 default hr_api.g_varchar2
215: ,p_auto_asnd_dt in date default hr_api.g_date
216: ,p_cbr_elig_perd_strt_dt in date default hr_api.g_date
217: ,p_cbr_elig_perd_end_dt in date default hr_api.g_date
218: ,p_lee_rsn_id in number default hr_api.g_number
219: ,p_enrt_perd_id in number default hr_api.g_number
220: ,p_per_in_ler_id in number default hr_api.g_number
221: ,p_pgm_id in number default hr_api.g_number
214: ,p_ws_stat_cd in varchar2 default hr_api.g_varchar2
215: ,p_auto_asnd_dt in date default hr_api.g_date
216: ,p_cbr_elig_perd_strt_dt in date default hr_api.g_date
217: ,p_cbr_elig_perd_end_dt in date default hr_api.g_date
218: ,p_lee_rsn_id in number default hr_api.g_number
219: ,p_enrt_perd_id in number default hr_api.g_number
220: ,p_per_in_ler_id in number default hr_api.g_number
221: ,p_pgm_id in number default hr_api.g_number
222: ,p_pl_id in number default hr_api.g_number
215: ,p_auto_asnd_dt in date default hr_api.g_date
216: ,p_cbr_elig_perd_strt_dt in date default hr_api.g_date
217: ,p_cbr_elig_perd_end_dt in date default hr_api.g_date
218: ,p_lee_rsn_id in number default hr_api.g_number
219: ,p_enrt_perd_id in number default hr_api.g_number
220: ,p_per_in_ler_id in number default hr_api.g_number
221: ,p_pgm_id in number default hr_api.g_number
222: ,p_pl_id in number default hr_api.g_number
223: ,p_business_group_id in number default hr_api.g_number
216: ,p_cbr_elig_perd_strt_dt in date default hr_api.g_date
217: ,p_cbr_elig_perd_end_dt in date default hr_api.g_date
218: ,p_lee_rsn_id in number default hr_api.g_number
219: ,p_enrt_perd_id in number default hr_api.g_number
220: ,p_per_in_ler_id in number default hr_api.g_number
221: ,p_pgm_id in number default hr_api.g_number
222: ,p_pl_id in number default hr_api.g_number
223: ,p_business_group_id in number default hr_api.g_number
224: ,p_pel_attribute_category in varchar2 default hr_api.g_varchar2
217: ,p_cbr_elig_perd_end_dt in date default hr_api.g_date
218: ,p_lee_rsn_id in number default hr_api.g_number
219: ,p_enrt_perd_id in number default hr_api.g_number
220: ,p_per_in_ler_id in number default hr_api.g_number
221: ,p_pgm_id in number default hr_api.g_number
222: ,p_pl_id in number default hr_api.g_number
223: ,p_business_group_id in number default hr_api.g_number
224: ,p_pel_attribute_category in varchar2 default hr_api.g_varchar2
225: ,p_pel_attribute1 in varchar2 default hr_api.g_varchar2
218: ,p_lee_rsn_id in number default hr_api.g_number
219: ,p_enrt_perd_id in number default hr_api.g_number
220: ,p_per_in_ler_id in number default hr_api.g_number
221: ,p_pgm_id in number default hr_api.g_number
222: ,p_pl_id in number default hr_api.g_number
223: ,p_business_group_id in number default hr_api.g_number
224: ,p_pel_attribute_category in varchar2 default hr_api.g_varchar2
225: ,p_pel_attribute1 in varchar2 default hr_api.g_varchar2
226: ,p_pel_attribute2 in varchar2 default hr_api.g_varchar2
219: ,p_enrt_perd_id in number default hr_api.g_number
220: ,p_per_in_ler_id in number default hr_api.g_number
221: ,p_pgm_id in number default hr_api.g_number
222: ,p_pl_id in number default hr_api.g_number
223: ,p_business_group_id in number default hr_api.g_number
224: ,p_pel_attribute_category in varchar2 default hr_api.g_varchar2
225: ,p_pel_attribute1 in varchar2 default hr_api.g_varchar2
226: ,p_pel_attribute2 in varchar2 default hr_api.g_varchar2
227: ,p_pel_attribute3 in varchar2 default hr_api.g_varchar2
220: ,p_per_in_ler_id in number default hr_api.g_number
221: ,p_pgm_id in number default hr_api.g_number
222: ,p_pl_id in number default hr_api.g_number
223: ,p_business_group_id in number default hr_api.g_number
224: ,p_pel_attribute_category in varchar2 default hr_api.g_varchar2
225: ,p_pel_attribute1 in varchar2 default hr_api.g_varchar2
226: ,p_pel_attribute2 in varchar2 default hr_api.g_varchar2
227: ,p_pel_attribute3 in varchar2 default hr_api.g_varchar2
228: ,p_pel_attribute4 in varchar2 default hr_api.g_varchar2
221: ,p_pgm_id in number default hr_api.g_number
222: ,p_pl_id in number default hr_api.g_number
223: ,p_business_group_id in number default hr_api.g_number
224: ,p_pel_attribute_category in varchar2 default hr_api.g_varchar2
225: ,p_pel_attribute1 in varchar2 default hr_api.g_varchar2
226: ,p_pel_attribute2 in varchar2 default hr_api.g_varchar2
227: ,p_pel_attribute3 in varchar2 default hr_api.g_varchar2
228: ,p_pel_attribute4 in varchar2 default hr_api.g_varchar2
229: ,p_pel_attribute5 in varchar2 default hr_api.g_varchar2
222: ,p_pl_id in number default hr_api.g_number
223: ,p_business_group_id in number default hr_api.g_number
224: ,p_pel_attribute_category in varchar2 default hr_api.g_varchar2
225: ,p_pel_attribute1 in varchar2 default hr_api.g_varchar2
226: ,p_pel_attribute2 in varchar2 default hr_api.g_varchar2
227: ,p_pel_attribute3 in varchar2 default hr_api.g_varchar2
228: ,p_pel_attribute4 in varchar2 default hr_api.g_varchar2
229: ,p_pel_attribute5 in varchar2 default hr_api.g_varchar2
230: ,p_pel_attribute6 in varchar2 default hr_api.g_varchar2
223: ,p_business_group_id in number default hr_api.g_number
224: ,p_pel_attribute_category in varchar2 default hr_api.g_varchar2
225: ,p_pel_attribute1 in varchar2 default hr_api.g_varchar2
226: ,p_pel_attribute2 in varchar2 default hr_api.g_varchar2
227: ,p_pel_attribute3 in varchar2 default hr_api.g_varchar2
228: ,p_pel_attribute4 in varchar2 default hr_api.g_varchar2
229: ,p_pel_attribute5 in varchar2 default hr_api.g_varchar2
230: ,p_pel_attribute6 in varchar2 default hr_api.g_varchar2
231: ,p_pel_attribute7 in varchar2 default hr_api.g_varchar2
224: ,p_pel_attribute_category in varchar2 default hr_api.g_varchar2
225: ,p_pel_attribute1 in varchar2 default hr_api.g_varchar2
226: ,p_pel_attribute2 in varchar2 default hr_api.g_varchar2
227: ,p_pel_attribute3 in varchar2 default hr_api.g_varchar2
228: ,p_pel_attribute4 in varchar2 default hr_api.g_varchar2
229: ,p_pel_attribute5 in varchar2 default hr_api.g_varchar2
230: ,p_pel_attribute6 in varchar2 default hr_api.g_varchar2
231: ,p_pel_attribute7 in varchar2 default hr_api.g_varchar2
232: ,p_pel_attribute8 in varchar2 default hr_api.g_varchar2
225: ,p_pel_attribute1 in varchar2 default hr_api.g_varchar2
226: ,p_pel_attribute2 in varchar2 default hr_api.g_varchar2
227: ,p_pel_attribute3 in varchar2 default hr_api.g_varchar2
228: ,p_pel_attribute4 in varchar2 default hr_api.g_varchar2
229: ,p_pel_attribute5 in varchar2 default hr_api.g_varchar2
230: ,p_pel_attribute6 in varchar2 default hr_api.g_varchar2
231: ,p_pel_attribute7 in varchar2 default hr_api.g_varchar2
232: ,p_pel_attribute8 in varchar2 default hr_api.g_varchar2
233: ,p_pel_attribute9 in varchar2 default hr_api.g_varchar2
226: ,p_pel_attribute2 in varchar2 default hr_api.g_varchar2
227: ,p_pel_attribute3 in varchar2 default hr_api.g_varchar2
228: ,p_pel_attribute4 in varchar2 default hr_api.g_varchar2
229: ,p_pel_attribute5 in varchar2 default hr_api.g_varchar2
230: ,p_pel_attribute6 in varchar2 default hr_api.g_varchar2
231: ,p_pel_attribute7 in varchar2 default hr_api.g_varchar2
232: ,p_pel_attribute8 in varchar2 default hr_api.g_varchar2
233: ,p_pel_attribute9 in varchar2 default hr_api.g_varchar2
234: ,p_pel_attribute10 in varchar2 default hr_api.g_varchar2
227: ,p_pel_attribute3 in varchar2 default hr_api.g_varchar2
228: ,p_pel_attribute4 in varchar2 default hr_api.g_varchar2
229: ,p_pel_attribute5 in varchar2 default hr_api.g_varchar2
230: ,p_pel_attribute6 in varchar2 default hr_api.g_varchar2
231: ,p_pel_attribute7 in varchar2 default hr_api.g_varchar2
232: ,p_pel_attribute8 in varchar2 default hr_api.g_varchar2
233: ,p_pel_attribute9 in varchar2 default hr_api.g_varchar2
234: ,p_pel_attribute10 in varchar2 default hr_api.g_varchar2
235: ,p_pel_attribute11 in varchar2 default hr_api.g_varchar2
228: ,p_pel_attribute4 in varchar2 default hr_api.g_varchar2
229: ,p_pel_attribute5 in varchar2 default hr_api.g_varchar2
230: ,p_pel_attribute6 in varchar2 default hr_api.g_varchar2
231: ,p_pel_attribute7 in varchar2 default hr_api.g_varchar2
232: ,p_pel_attribute8 in varchar2 default hr_api.g_varchar2
233: ,p_pel_attribute9 in varchar2 default hr_api.g_varchar2
234: ,p_pel_attribute10 in varchar2 default hr_api.g_varchar2
235: ,p_pel_attribute11 in varchar2 default hr_api.g_varchar2
236: ,p_pel_attribute12 in varchar2 default hr_api.g_varchar2
229: ,p_pel_attribute5 in varchar2 default hr_api.g_varchar2
230: ,p_pel_attribute6 in varchar2 default hr_api.g_varchar2
231: ,p_pel_attribute7 in varchar2 default hr_api.g_varchar2
232: ,p_pel_attribute8 in varchar2 default hr_api.g_varchar2
233: ,p_pel_attribute9 in varchar2 default hr_api.g_varchar2
234: ,p_pel_attribute10 in varchar2 default hr_api.g_varchar2
235: ,p_pel_attribute11 in varchar2 default hr_api.g_varchar2
236: ,p_pel_attribute12 in varchar2 default hr_api.g_varchar2
237: ,p_pel_attribute13 in varchar2 default hr_api.g_varchar2
230: ,p_pel_attribute6 in varchar2 default hr_api.g_varchar2
231: ,p_pel_attribute7 in varchar2 default hr_api.g_varchar2
232: ,p_pel_attribute8 in varchar2 default hr_api.g_varchar2
233: ,p_pel_attribute9 in varchar2 default hr_api.g_varchar2
234: ,p_pel_attribute10 in varchar2 default hr_api.g_varchar2
235: ,p_pel_attribute11 in varchar2 default hr_api.g_varchar2
236: ,p_pel_attribute12 in varchar2 default hr_api.g_varchar2
237: ,p_pel_attribute13 in varchar2 default hr_api.g_varchar2
238: ,p_pel_attribute14 in varchar2 default hr_api.g_varchar2
231: ,p_pel_attribute7 in varchar2 default hr_api.g_varchar2
232: ,p_pel_attribute8 in varchar2 default hr_api.g_varchar2
233: ,p_pel_attribute9 in varchar2 default hr_api.g_varchar2
234: ,p_pel_attribute10 in varchar2 default hr_api.g_varchar2
235: ,p_pel_attribute11 in varchar2 default hr_api.g_varchar2
236: ,p_pel_attribute12 in varchar2 default hr_api.g_varchar2
237: ,p_pel_attribute13 in varchar2 default hr_api.g_varchar2
238: ,p_pel_attribute14 in varchar2 default hr_api.g_varchar2
239: ,p_pel_attribute15 in varchar2 default hr_api.g_varchar2
232: ,p_pel_attribute8 in varchar2 default hr_api.g_varchar2
233: ,p_pel_attribute9 in varchar2 default hr_api.g_varchar2
234: ,p_pel_attribute10 in varchar2 default hr_api.g_varchar2
235: ,p_pel_attribute11 in varchar2 default hr_api.g_varchar2
236: ,p_pel_attribute12 in varchar2 default hr_api.g_varchar2
237: ,p_pel_attribute13 in varchar2 default hr_api.g_varchar2
238: ,p_pel_attribute14 in varchar2 default hr_api.g_varchar2
239: ,p_pel_attribute15 in varchar2 default hr_api.g_varchar2
240: ,p_pel_attribute16 in varchar2 default hr_api.g_varchar2
233: ,p_pel_attribute9 in varchar2 default hr_api.g_varchar2
234: ,p_pel_attribute10 in varchar2 default hr_api.g_varchar2
235: ,p_pel_attribute11 in varchar2 default hr_api.g_varchar2
236: ,p_pel_attribute12 in varchar2 default hr_api.g_varchar2
237: ,p_pel_attribute13 in varchar2 default hr_api.g_varchar2
238: ,p_pel_attribute14 in varchar2 default hr_api.g_varchar2
239: ,p_pel_attribute15 in varchar2 default hr_api.g_varchar2
240: ,p_pel_attribute16 in varchar2 default hr_api.g_varchar2
241: ,p_pel_attribute17 in varchar2 default hr_api.g_varchar2
234: ,p_pel_attribute10 in varchar2 default hr_api.g_varchar2
235: ,p_pel_attribute11 in varchar2 default hr_api.g_varchar2
236: ,p_pel_attribute12 in varchar2 default hr_api.g_varchar2
237: ,p_pel_attribute13 in varchar2 default hr_api.g_varchar2
238: ,p_pel_attribute14 in varchar2 default hr_api.g_varchar2
239: ,p_pel_attribute15 in varchar2 default hr_api.g_varchar2
240: ,p_pel_attribute16 in varchar2 default hr_api.g_varchar2
241: ,p_pel_attribute17 in varchar2 default hr_api.g_varchar2
242: ,p_pel_attribute18 in varchar2 default hr_api.g_varchar2
235: ,p_pel_attribute11 in varchar2 default hr_api.g_varchar2
236: ,p_pel_attribute12 in varchar2 default hr_api.g_varchar2
237: ,p_pel_attribute13 in varchar2 default hr_api.g_varchar2
238: ,p_pel_attribute14 in varchar2 default hr_api.g_varchar2
239: ,p_pel_attribute15 in varchar2 default hr_api.g_varchar2
240: ,p_pel_attribute16 in varchar2 default hr_api.g_varchar2
241: ,p_pel_attribute17 in varchar2 default hr_api.g_varchar2
242: ,p_pel_attribute18 in varchar2 default hr_api.g_varchar2
243: ,p_pel_attribute19 in varchar2 default hr_api.g_varchar2
236: ,p_pel_attribute12 in varchar2 default hr_api.g_varchar2
237: ,p_pel_attribute13 in varchar2 default hr_api.g_varchar2
238: ,p_pel_attribute14 in varchar2 default hr_api.g_varchar2
239: ,p_pel_attribute15 in varchar2 default hr_api.g_varchar2
240: ,p_pel_attribute16 in varchar2 default hr_api.g_varchar2
241: ,p_pel_attribute17 in varchar2 default hr_api.g_varchar2
242: ,p_pel_attribute18 in varchar2 default hr_api.g_varchar2
243: ,p_pel_attribute19 in varchar2 default hr_api.g_varchar2
244: ,p_pel_attribute20 in varchar2 default hr_api.g_varchar2
237: ,p_pel_attribute13 in varchar2 default hr_api.g_varchar2
238: ,p_pel_attribute14 in varchar2 default hr_api.g_varchar2
239: ,p_pel_attribute15 in varchar2 default hr_api.g_varchar2
240: ,p_pel_attribute16 in varchar2 default hr_api.g_varchar2
241: ,p_pel_attribute17 in varchar2 default hr_api.g_varchar2
242: ,p_pel_attribute18 in varchar2 default hr_api.g_varchar2
243: ,p_pel_attribute19 in varchar2 default hr_api.g_varchar2
244: ,p_pel_attribute20 in varchar2 default hr_api.g_varchar2
245: ,p_pel_attribute21 in varchar2 default hr_api.g_varchar2
238: ,p_pel_attribute14 in varchar2 default hr_api.g_varchar2
239: ,p_pel_attribute15 in varchar2 default hr_api.g_varchar2
240: ,p_pel_attribute16 in varchar2 default hr_api.g_varchar2
241: ,p_pel_attribute17 in varchar2 default hr_api.g_varchar2
242: ,p_pel_attribute18 in varchar2 default hr_api.g_varchar2
243: ,p_pel_attribute19 in varchar2 default hr_api.g_varchar2
244: ,p_pel_attribute20 in varchar2 default hr_api.g_varchar2
245: ,p_pel_attribute21 in varchar2 default hr_api.g_varchar2
246: ,p_pel_attribute22 in varchar2 default hr_api.g_varchar2
239: ,p_pel_attribute15 in varchar2 default hr_api.g_varchar2
240: ,p_pel_attribute16 in varchar2 default hr_api.g_varchar2
241: ,p_pel_attribute17 in varchar2 default hr_api.g_varchar2
242: ,p_pel_attribute18 in varchar2 default hr_api.g_varchar2
243: ,p_pel_attribute19 in varchar2 default hr_api.g_varchar2
244: ,p_pel_attribute20 in varchar2 default hr_api.g_varchar2
245: ,p_pel_attribute21 in varchar2 default hr_api.g_varchar2
246: ,p_pel_attribute22 in varchar2 default hr_api.g_varchar2
247: ,p_pel_attribute23 in varchar2 default hr_api.g_varchar2
240: ,p_pel_attribute16 in varchar2 default hr_api.g_varchar2
241: ,p_pel_attribute17 in varchar2 default hr_api.g_varchar2
242: ,p_pel_attribute18 in varchar2 default hr_api.g_varchar2
243: ,p_pel_attribute19 in varchar2 default hr_api.g_varchar2
244: ,p_pel_attribute20 in varchar2 default hr_api.g_varchar2
245: ,p_pel_attribute21 in varchar2 default hr_api.g_varchar2
246: ,p_pel_attribute22 in varchar2 default hr_api.g_varchar2
247: ,p_pel_attribute23 in varchar2 default hr_api.g_varchar2
248: ,p_pel_attribute24 in varchar2 default hr_api.g_varchar2
241: ,p_pel_attribute17 in varchar2 default hr_api.g_varchar2
242: ,p_pel_attribute18 in varchar2 default hr_api.g_varchar2
243: ,p_pel_attribute19 in varchar2 default hr_api.g_varchar2
244: ,p_pel_attribute20 in varchar2 default hr_api.g_varchar2
245: ,p_pel_attribute21 in varchar2 default hr_api.g_varchar2
246: ,p_pel_attribute22 in varchar2 default hr_api.g_varchar2
247: ,p_pel_attribute23 in varchar2 default hr_api.g_varchar2
248: ,p_pel_attribute24 in varchar2 default hr_api.g_varchar2
249: ,p_pel_attribute25 in varchar2 default hr_api.g_varchar2
242: ,p_pel_attribute18 in varchar2 default hr_api.g_varchar2
243: ,p_pel_attribute19 in varchar2 default hr_api.g_varchar2
244: ,p_pel_attribute20 in varchar2 default hr_api.g_varchar2
245: ,p_pel_attribute21 in varchar2 default hr_api.g_varchar2
246: ,p_pel_attribute22 in varchar2 default hr_api.g_varchar2
247: ,p_pel_attribute23 in varchar2 default hr_api.g_varchar2
248: ,p_pel_attribute24 in varchar2 default hr_api.g_varchar2
249: ,p_pel_attribute25 in varchar2 default hr_api.g_varchar2
250: ,p_pel_attribute26 in varchar2 default hr_api.g_varchar2
243: ,p_pel_attribute19 in varchar2 default hr_api.g_varchar2
244: ,p_pel_attribute20 in varchar2 default hr_api.g_varchar2
245: ,p_pel_attribute21 in varchar2 default hr_api.g_varchar2
246: ,p_pel_attribute22 in varchar2 default hr_api.g_varchar2
247: ,p_pel_attribute23 in varchar2 default hr_api.g_varchar2
248: ,p_pel_attribute24 in varchar2 default hr_api.g_varchar2
249: ,p_pel_attribute25 in varchar2 default hr_api.g_varchar2
250: ,p_pel_attribute26 in varchar2 default hr_api.g_varchar2
251: ,p_pel_attribute27 in varchar2 default hr_api.g_varchar2
244: ,p_pel_attribute20 in varchar2 default hr_api.g_varchar2
245: ,p_pel_attribute21 in varchar2 default hr_api.g_varchar2
246: ,p_pel_attribute22 in varchar2 default hr_api.g_varchar2
247: ,p_pel_attribute23 in varchar2 default hr_api.g_varchar2
248: ,p_pel_attribute24 in varchar2 default hr_api.g_varchar2
249: ,p_pel_attribute25 in varchar2 default hr_api.g_varchar2
250: ,p_pel_attribute26 in varchar2 default hr_api.g_varchar2
251: ,p_pel_attribute27 in varchar2 default hr_api.g_varchar2
252: ,p_pel_attribute28 in varchar2 default hr_api.g_varchar2
245: ,p_pel_attribute21 in varchar2 default hr_api.g_varchar2
246: ,p_pel_attribute22 in varchar2 default hr_api.g_varchar2
247: ,p_pel_attribute23 in varchar2 default hr_api.g_varchar2
248: ,p_pel_attribute24 in varchar2 default hr_api.g_varchar2
249: ,p_pel_attribute25 in varchar2 default hr_api.g_varchar2
250: ,p_pel_attribute26 in varchar2 default hr_api.g_varchar2
251: ,p_pel_attribute27 in varchar2 default hr_api.g_varchar2
252: ,p_pel_attribute28 in varchar2 default hr_api.g_varchar2
253: ,p_pel_attribute29 in varchar2 default hr_api.g_varchar2
246: ,p_pel_attribute22 in varchar2 default hr_api.g_varchar2
247: ,p_pel_attribute23 in varchar2 default hr_api.g_varchar2
248: ,p_pel_attribute24 in varchar2 default hr_api.g_varchar2
249: ,p_pel_attribute25 in varchar2 default hr_api.g_varchar2
250: ,p_pel_attribute26 in varchar2 default hr_api.g_varchar2
251: ,p_pel_attribute27 in varchar2 default hr_api.g_varchar2
252: ,p_pel_attribute28 in varchar2 default hr_api.g_varchar2
253: ,p_pel_attribute29 in varchar2 default hr_api.g_varchar2
254: ,p_pel_attribute30 in varchar2 default hr_api.g_varchar2
247: ,p_pel_attribute23 in varchar2 default hr_api.g_varchar2
248: ,p_pel_attribute24 in varchar2 default hr_api.g_varchar2
249: ,p_pel_attribute25 in varchar2 default hr_api.g_varchar2
250: ,p_pel_attribute26 in varchar2 default hr_api.g_varchar2
251: ,p_pel_attribute27 in varchar2 default hr_api.g_varchar2
252: ,p_pel_attribute28 in varchar2 default hr_api.g_varchar2
253: ,p_pel_attribute29 in varchar2 default hr_api.g_varchar2
254: ,p_pel_attribute30 in varchar2 default hr_api.g_varchar2
255: ,p_request_id in number default hr_api.g_number
248: ,p_pel_attribute24 in varchar2 default hr_api.g_varchar2
249: ,p_pel_attribute25 in varchar2 default hr_api.g_varchar2
250: ,p_pel_attribute26 in varchar2 default hr_api.g_varchar2
251: ,p_pel_attribute27 in varchar2 default hr_api.g_varchar2
252: ,p_pel_attribute28 in varchar2 default hr_api.g_varchar2
253: ,p_pel_attribute29 in varchar2 default hr_api.g_varchar2
254: ,p_pel_attribute30 in varchar2 default hr_api.g_varchar2
255: ,p_request_id in number default hr_api.g_number
256: ,p_program_application_id in number default hr_api.g_number
249: ,p_pel_attribute25 in varchar2 default hr_api.g_varchar2
250: ,p_pel_attribute26 in varchar2 default hr_api.g_varchar2
251: ,p_pel_attribute27 in varchar2 default hr_api.g_varchar2
252: ,p_pel_attribute28 in varchar2 default hr_api.g_varchar2
253: ,p_pel_attribute29 in varchar2 default hr_api.g_varchar2
254: ,p_pel_attribute30 in varchar2 default hr_api.g_varchar2
255: ,p_request_id in number default hr_api.g_number
256: ,p_program_application_id in number default hr_api.g_number
257: ,p_program_id in number default hr_api.g_number
250: ,p_pel_attribute26 in varchar2 default hr_api.g_varchar2
251: ,p_pel_attribute27 in varchar2 default hr_api.g_varchar2
252: ,p_pel_attribute28 in varchar2 default hr_api.g_varchar2
253: ,p_pel_attribute29 in varchar2 default hr_api.g_varchar2
254: ,p_pel_attribute30 in varchar2 default hr_api.g_varchar2
255: ,p_request_id in number default hr_api.g_number
256: ,p_program_application_id in number default hr_api.g_number
257: ,p_program_id in number default hr_api.g_number
258: ,p_program_update_date in date default hr_api.g_date
251: ,p_pel_attribute27 in varchar2 default hr_api.g_varchar2
252: ,p_pel_attribute28 in varchar2 default hr_api.g_varchar2
253: ,p_pel_attribute29 in varchar2 default hr_api.g_varchar2
254: ,p_pel_attribute30 in varchar2 default hr_api.g_varchar2
255: ,p_request_id in number default hr_api.g_number
256: ,p_program_application_id in number default hr_api.g_number
257: ,p_program_id in number default hr_api.g_number
258: ,p_program_update_date in date default hr_api.g_date
259: ,p_object_version_number in out nocopy number
252: ,p_pel_attribute28 in varchar2 default hr_api.g_varchar2
253: ,p_pel_attribute29 in varchar2 default hr_api.g_varchar2
254: ,p_pel_attribute30 in varchar2 default hr_api.g_varchar2
255: ,p_request_id in number default hr_api.g_number
256: ,p_program_application_id in number default hr_api.g_number
257: ,p_program_id in number default hr_api.g_number
258: ,p_program_update_date in date default hr_api.g_date
259: ,p_object_version_number in out nocopy number
260: ,p_effective_date in date
253: ,p_pel_attribute29 in varchar2 default hr_api.g_varchar2
254: ,p_pel_attribute30 in varchar2 default hr_api.g_varchar2
255: ,p_request_id in number default hr_api.g_number
256: ,p_program_application_id in number default hr_api.g_number
257: ,p_program_id in number default hr_api.g_number
258: ,p_program_update_date in date default hr_api.g_date
259: ,p_object_version_number in out nocopy number
260: ,p_effective_date in date
261: ,p_return_status out nocopy varchar2
254: ,p_pel_attribute30 in varchar2 default hr_api.g_varchar2
255: ,p_request_id in number default hr_api.g_number
256: ,p_program_application_id in number default hr_api.g_number
257: ,p_program_id in number default hr_api.g_number
258: ,p_program_update_date in date default hr_api.g_date
259: ,p_object_version_number in out nocopy number
260: ,p_effective_date in date
261: ,p_return_status out nocopy varchar2
262: );