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