196: --
197: procedure update_ptnl_ler_for_per
198: (p_validate in boolean default false
199: ,p_ptnl_ler_for_per_id in number
200: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number
201: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
202: ,p_trgr_table_pk_id in number default hr_api.g_number
203: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
204: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
197: procedure update_ptnl_ler_for_per
198: (p_validate in boolean default false
199: ,p_ptnl_ler_for_per_id in number
200: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number
201: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
202: ,p_trgr_table_pk_id in number default hr_api.g_number
203: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
204: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
205: ,p_mnl_dt in date default hr_api.g_date
198: (p_validate in boolean default false
199: ,p_ptnl_ler_for_per_id in number
200: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number
201: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
202: ,p_trgr_table_pk_id in number default hr_api.g_number
203: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
204: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
205: ,p_mnl_dt in date default hr_api.g_date
206: ,p_enrt_perd_id in number default hr_api.g_number
199: ,p_ptnl_ler_for_per_id in number
200: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number
201: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
202: ,p_trgr_table_pk_id in number default hr_api.g_number
203: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
204: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
205: ,p_mnl_dt in date default hr_api.g_date
206: ,p_enrt_perd_id in number default hr_api.g_number
207: ,p_ler_id in number default hr_api.g_number
200: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number
201: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
202: ,p_trgr_table_pk_id in number default hr_api.g_number
203: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
204: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
205: ,p_mnl_dt in date default hr_api.g_date
206: ,p_enrt_perd_id in number default hr_api.g_number
207: ,p_ler_id in number default hr_api.g_number
208: ,p_person_id in number default hr_api.g_number
201: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
202: ,p_trgr_table_pk_id in number default hr_api.g_number
203: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
204: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
205: ,p_mnl_dt in date default hr_api.g_date
206: ,p_enrt_perd_id in number default hr_api.g_number
207: ,p_ler_id in number default hr_api.g_number
208: ,p_person_id in number default hr_api.g_number
209: ,p_business_group_id in number default hr_api.g_number
202: ,p_trgr_table_pk_id in number default hr_api.g_number
203: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
204: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
205: ,p_mnl_dt in date default hr_api.g_date
206: ,p_enrt_perd_id in number default hr_api.g_number
207: ,p_ler_id in number default hr_api.g_number
208: ,p_person_id in number default hr_api.g_number
209: ,p_business_group_id in number default hr_api.g_number
210: ,p_dtctd_dt in date default hr_api.g_date
203: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
204: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
205: ,p_mnl_dt in date default hr_api.g_date
206: ,p_enrt_perd_id in number default hr_api.g_number
207: ,p_ler_id in number default hr_api.g_number
208: ,p_person_id in number default hr_api.g_number
209: ,p_business_group_id in number default hr_api.g_number
210: ,p_dtctd_dt in date default hr_api.g_date
211: ,p_procd_dt in date default hr_api.g_date
204: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
205: ,p_mnl_dt in date default hr_api.g_date
206: ,p_enrt_perd_id in number default hr_api.g_number
207: ,p_ler_id in number default hr_api.g_number
208: ,p_person_id in number default hr_api.g_number
209: ,p_business_group_id in number default hr_api.g_number
210: ,p_dtctd_dt in date default hr_api.g_date
211: ,p_procd_dt in date default hr_api.g_date
212: ,p_unprocd_dt in date default hr_api.g_date
205: ,p_mnl_dt in date default hr_api.g_date
206: ,p_enrt_perd_id in number default hr_api.g_number
207: ,p_ler_id in number default hr_api.g_number
208: ,p_person_id in number default hr_api.g_number
209: ,p_business_group_id in number default hr_api.g_number
210: ,p_dtctd_dt in date default hr_api.g_date
211: ,p_procd_dt in date default hr_api.g_date
212: ,p_unprocd_dt in date default hr_api.g_date
213: ,p_voidd_dt in date default hr_api.g_date
206: ,p_enrt_perd_id in number default hr_api.g_number
207: ,p_ler_id in number default hr_api.g_number
208: ,p_person_id in number default hr_api.g_number
209: ,p_business_group_id in number default hr_api.g_number
210: ,p_dtctd_dt in date default hr_api.g_date
211: ,p_procd_dt in date default hr_api.g_date
212: ,p_unprocd_dt in date default hr_api.g_date
213: ,p_voidd_dt in date default hr_api.g_date
214: ,p_mnlo_dt in date default hr_api.g_date
207: ,p_ler_id in number default hr_api.g_number
208: ,p_person_id in number default hr_api.g_number
209: ,p_business_group_id in number default hr_api.g_number
210: ,p_dtctd_dt in date default hr_api.g_date
211: ,p_procd_dt in date default hr_api.g_date
212: ,p_unprocd_dt in date default hr_api.g_date
213: ,p_voidd_dt in date default hr_api.g_date
214: ,p_mnlo_dt in date default hr_api.g_date
215: ,p_ntfn_dt in date default hr_api.g_date
208: ,p_person_id in number default hr_api.g_number
209: ,p_business_group_id in number default hr_api.g_number
210: ,p_dtctd_dt in date default hr_api.g_date
211: ,p_procd_dt in date default hr_api.g_date
212: ,p_unprocd_dt in date default hr_api.g_date
213: ,p_voidd_dt in date default hr_api.g_date
214: ,p_mnlo_dt in date default hr_api.g_date
215: ,p_ntfn_dt in date default hr_api.g_date
216: ,p_request_id in number default hr_api.g_number
209: ,p_business_group_id in number default hr_api.g_number
210: ,p_dtctd_dt in date default hr_api.g_date
211: ,p_procd_dt in date default hr_api.g_date
212: ,p_unprocd_dt in date default hr_api.g_date
213: ,p_voidd_dt in date default hr_api.g_date
214: ,p_mnlo_dt in date default hr_api.g_date
215: ,p_ntfn_dt in date default hr_api.g_date
216: ,p_request_id in number default hr_api.g_number
217: ,p_program_application_id in number default hr_api.g_number
210: ,p_dtctd_dt in date default hr_api.g_date
211: ,p_procd_dt in date default hr_api.g_date
212: ,p_unprocd_dt in date default hr_api.g_date
213: ,p_voidd_dt in date default hr_api.g_date
214: ,p_mnlo_dt in date default hr_api.g_date
215: ,p_ntfn_dt in date default hr_api.g_date
216: ,p_request_id in number default hr_api.g_number
217: ,p_program_application_id in number default hr_api.g_number
218: ,p_program_id in number default hr_api.g_number
211: ,p_procd_dt in date default hr_api.g_date
212: ,p_unprocd_dt in date default hr_api.g_date
213: ,p_voidd_dt in date default hr_api.g_date
214: ,p_mnlo_dt in date default hr_api.g_date
215: ,p_ntfn_dt in date default hr_api.g_date
216: ,p_request_id in number default hr_api.g_number
217: ,p_program_application_id in number default hr_api.g_number
218: ,p_program_id in number default hr_api.g_number
219: ,p_program_update_date in date default hr_api.g_date
212: ,p_unprocd_dt in date default hr_api.g_date
213: ,p_voidd_dt in date default hr_api.g_date
214: ,p_mnlo_dt in date default hr_api.g_date
215: ,p_ntfn_dt in date default hr_api.g_date
216: ,p_request_id in number default hr_api.g_number
217: ,p_program_application_id in number default hr_api.g_number
218: ,p_program_id in number default hr_api.g_number
219: ,p_program_update_date in date default hr_api.g_date
220: ,p_object_version_number in out nocopy number
213: ,p_voidd_dt in date default hr_api.g_date
214: ,p_mnlo_dt in date default hr_api.g_date
215: ,p_ntfn_dt in date default hr_api.g_date
216: ,p_request_id in number default hr_api.g_number
217: ,p_program_application_id in number default hr_api.g_number
218: ,p_program_id in number default hr_api.g_number
219: ,p_program_update_date in date default hr_api.g_date
220: ,p_object_version_number in out nocopy number
221: ,p_effective_date in date);
214: ,p_mnlo_dt in date default hr_api.g_date
215: ,p_ntfn_dt in date default hr_api.g_date
216: ,p_request_id in number default hr_api.g_number
217: ,p_program_application_id in number default hr_api.g_number
218: ,p_program_id in number default hr_api.g_number
219: ,p_program_update_date in date default hr_api.g_date
220: ,p_object_version_number in out nocopy number
221: ,p_effective_date in date);
222: --
215: ,p_ntfn_dt in date default hr_api.g_date
216: ,p_request_id in number default hr_api.g_number
217: ,p_program_application_id in number default hr_api.g_number
218: ,p_program_id in number default hr_api.g_number
219: ,p_program_update_date in date default hr_api.g_date
220: ,p_object_version_number in out nocopy number
221: ,p_effective_date in date);
222: --
223: -- ----------------------------------------------------------------------------
269: --
270: procedure update_ptnl_ler_for_per_perf
271: (p_validate in boolean default false
272: ,p_ptnl_ler_for_per_id in number
273: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number
274: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
275: ,p_trgr_table_pk_id in number default hr_api.g_number
276: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
277: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
270: procedure update_ptnl_ler_for_per_perf
271: (p_validate in boolean default false
272: ,p_ptnl_ler_for_per_id in number
273: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number
274: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
275: ,p_trgr_table_pk_id in number default hr_api.g_number
276: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
277: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
278: ,p_mnl_dt in date default hr_api.g_date
271: (p_validate in boolean default false
272: ,p_ptnl_ler_for_per_id in number
273: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number
274: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
275: ,p_trgr_table_pk_id in number default hr_api.g_number
276: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
277: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
278: ,p_mnl_dt in date default hr_api.g_date
279: ,p_enrt_perd_id in number default hr_api.g_number
272: ,p_ptnl_ler_for_per_id in number
273: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number
274: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
275: ,p_trgr_table_pk_id in number default hr_api.g_number
276: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
277: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
278: ,p_mnl_dt in date default hr_api.g_date
279: ,p_enrt_perd_id in number default hr_api.g_number
280: ,p_ler_id in number default hr_api.g_number
273: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number
274: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
275: ,p_trgr_table_pk_id in number default hr_api.g_number
276: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
277: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
278: ,p_mnl_dt in date default hr_api.g_date
279: ,p_enrt_perd_id in number default hr_api.g_number
280: ,p_ler_id in number default hr_api.g_number
281: ,p_person_id in number default hr_api.g_number
274: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
275: ,p_trgr_table_pk_id in number default hr_api.g_number
276: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
277: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
278: ,p_mnl_dt in date default hr_api.g_date
279: ,p_enrt_perd_id in number default hr_api.g_number
280: ,p_ler_id in number default hr_api.g_number
281: ,p_person_id in number default hr_api.g_number
282: ,p_business_group_id in number default hr_api.g_number
275: ,p_trgr_table_pk_id in number default hr_api.g_number
276: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
277: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
278: ,p_mnl_dt in date default hr_api.g_date
279: ,p_enrt_perd_id in number default hr_api.g_number
280: ,p_ler_id in number default hr_api.g_number
281: ,p_person_id in number default hr_api.g_number
282: ,p_business_group_id in number default hr_api.g_number
283: ,p_dtctd_dt in date default hr_api.g_date
276: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
277: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
278: ,p_mnl_dt in date default hr_api.g_date
279: ,p_enrt_perd_id in number default hr_api.g_number
280: ,p_ler_id in number default hr_api.g_number
281: ,p_person_id in number default hr_api.g_number
282: ,p_business_group_id in number default hr_api.g_number
283: ,p_dtctd_dt in date default hr_api.g_date
284: ,p_procd_dt in date default hr_api.g_date
277: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
278: ,p_mnl_dt in date default hr_api.g_date
279: ,p_enrt_perd_id in number default hr_api.g_number
280: ,p_ler_id in number default hr_api.g_number
281: ,p_person_id in number default hr_api.g_number
282: ,p_business_group_id in number default hr_api.g_number
283: ,p_dtctd_dt in date default hr_api.g_date
284: ,p_procd_dt in date default hr_api.g_date
285: ,p_unprocd_dt in date default hr_api.g_date
278: ,p_mnl_dt in date default hr_api.g_date
279: ,p_enrt_perd_id in number default hr_api.g_number
280: ,p_ler_id in number default hr_api.g_number
281: ,p_person_id in number default hr_api.g_number
282: ,p_business_group_id in number default hr_api.g_number
283: ,p_dtctd_dt in date default hr_api.g_date
284: ,p_procd_dt in date default hr_api.g_date
285: ,p_unprocd_dt in date default hr_api.g_date
286: ,p_voidd_dt in date default hr_api.g_date
279: ,p_enrt_perd_id in number default hr_api.g_number
280: ,p_ler_id in number default hr_api.g_number
281: ,p_person_id in number default hr_api.g_number
282: ,p_business_group_id in number default hr_api.g_number
283: ,p_dtctd_dt in date default hr_api.g_date
284: ,p_procd_dt in date default hr_api.g_date
285: ,p_unprocd_dt in date default hr_api.g_date
286: ,p_voidd_dt in date default hr_api.g_date
287: ,p_mnlo_dt in date default hr_api.g_date
280: ,p_ler_id in number default hr_api.g_number
281: ,p_person_id in number default hr_api.g_number
282: ,p_business_group_id in number default hr_api.g_number
283: ,p_dtctd_dt in date default hr_api.g_date
284: ,p_procd_dt in date default hr_api.g_date
285: ,p_unprocd_dt in date default hr_api.g_date
286: ,p_voidd_dt in date default hr_api.g_date
287: ,p_mnlo_dt in date default hr_api.g_date
288: ,p_ntfn_dt in date default hr_api.g_date
281: ,p_person_id in number default hr_api.g_number
282: ,p_business_group_id in number default hr_api.g_number
283: ,p_dtctd_dt in date default hr_api.g_date
284: ,p_procd_dt in date default hr_api.g_date
285: ,p_unprocd_dt in date default hr_api.g_date
286: ,p_voidd_dt in date default hr_api.g_date
287: ,p_mnlo_dt in date default hr_api.g_date
288: ,p_ntfn_dt in date default hr_api.g_date
289: ,p_request_id in number default hr_api.g_number
282: ,p_business_group_id in number default hr_api.g_number
283: ,p_dtctd_dt in date default hr_api.g_date
284: ,p_procd_dt in date default hr_api.g_date
285: ,p_unprocd_dt in date default hr_api.g_date
286: ,p_voidd_dt in date default hr_api.g_date
287: ,p_mnlo_dt in date default hr_api.g_date
288: ,p_ntfn_dt in date default hr_api.g_date
289: ,p_request_id in number default hr_api.g_number
290: ,p_program_application_id in number default hr_api.g_number
283: ,p_dtctd_dt in date default hr_api.g_date
284: ,p_procd_dt in date default hr_api.g_date
285: ,p_unprocd_dt in date default hr_api.g_date
286: ,p_voidd_dt in date default hr_api.g_date
287: ,p_mnlo_dt in date default hr_api.g_date
288: ,p_ntfn_dt in date default hr_api.g_date
289: ,p_request_id in number default hr_api.g_number
290: ,p_program_application_id in number default hr_api.g_number
291: ,p_program_id in number default hr_api.g_number
284: ,p_procd_dt in date default hr_api.g_date
285: ,p_unprocd_dt in date default hr_api.g_date
286: ,p_voidd_dt in date default hr_api.g_date
287: ,p_mnlo_dt in date default hr_api.g_date
288: ,p_ntfn_dt in date default hr_api.g_date
289: ,p_request_id in number default hr_api.g_number
290: ,p_program_application_id in number default hr_api.g_number
291: ,p_program_id in number default hr_api.g_number
292: ,p_program_update_date in date default hr_api.g_date
285: ,p_unprocd_dt in date default hr_api.g_date
286: ,p_voidd_dt in date default hr_api.g_date
287: ,p_mnlo_dt in date default hr_api.g_date
288: ,p_ntfn_dt in date default hr_api.g_date
289: ,p_request_id in number default hr_api.g_number
290: ,p_program_application_id in number default hr_api.g_number
291: ,p_program_id in number default hr_api.g_number
292: ,p_program_update_date in date default hr_api.g_date
293: ,p_object_version_number in out nocopy number
286: ,p_voidd_dt in date default hr_api.g_date
287: ,p_mnlo_dt in date default hr_api.g_date
288: ,p_ntfn_dt in date default hr_api.g_date
289: ,p_request_id in number default hr_api.g_number
290: ,p_program_application_id in number default hr_api.g_number
291: ,p_program_id in number default hr_api.g_number
292: ,p_program_update_date in date default hr_api.g_date
293: ,p_object_version_number in out nocopy number
294: ,p_effective_date in date);
287: ,p_mnlo_dt in date default hr_api.g_date
288: ,p_ntfn_dt in date default hr_api.g_date
289: ,p_request_id in number default hr_api.g_number
290: ,p_program_application_id in number default hr_api.g_number
291: ,p_program_id in number default hr_api.g_number
292: ,p_program_update_date in date default hr_api.g_date
293: ,p_object_version_number in out nocopy number
294: ,p_effective_date in date);
295: --
288: ,p_ntfn_dt in date default hr_api.g_date
289: ,p_request_id in number default hr_api.g_number
290: ,p_program_application_id in number default hr_api.g_number
291: ,p_program_id in number default hr_api.g_number
292: ,p_program_update_date in date default hr_api.g_date
293: ,p_object_version_number in out nocopy number
294: ,p_effective_date in date);
295: --
296: -- ----------------------------------------------------------------------------