96: --
97: hr_utility.set_location(' Leaving:'||l_proc, 10);
98: --
99: Exception
100: When hr_api.check_integrity_violated Then
101: -- A check constraint has been violated
102: ben_ppl_shd.g_api_dml := false; -- Unset the api dml status
103: ben_ppl_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.check_integrity_violated Then
101: -- A check constraint has been violated
102: ben_ppl_shd.g_api_dml := false; -- Unset the api dml status
103: ben_ppl_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.parent_integrity_violated Then
106: -- Parent integrity has been violated
107: ben_ppl_shd.g_api_dml := false; -- Unset the api dml status
108: ben_ppl_shd.constraint_error
101: -- A check constraint has been violated
102: ben_ppl_shd.g_api_dml := false; -- Unset the api dml status
103: ben_ppl_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.parent_integrity_violated Then
106: -- Parent integrity has been violated
107: ben_ppl_shd.g_api_dml := false; -- Unset the api dml status
108: ben_ppl_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.parent_integrity_violated Then
106: -- Parent integrity has been violated
107: ben_ppl_shd.g_api_dml := false; -- Unset the api dml status
108: ben_ppl_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.unique_integrity_violated Then
111: -- Unique integrity has been violated
112: ben_ppl_shd.g_api_dml := false; -- Unset the api dml status
113: ben_ppl_shd.constraint_error
106: -- Parent integrity has been violated
107: ben_ppl_shd.g_api_dml := false; -- Unset the api dml status
108: ben_ppl_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.unique_integrity_violated Then
111: -- Unique integrity has been violated
112: ben_ppl_shd.g_api_dml := false; -- Unset the api dml status
113: ben_ppl_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.unique_integrity_violated Then
111: -- Unique integrity has been violated
112: ben_ppl_shd.g_api_dml := false; -- Unset the api dml status
113: ben_ppl_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When Others Then
116: ben_ppl_shd.g_api_dml := false; -- Unset the api dml status
117: Raise;
118: End update_dml;
253: );
254: --
255: exception
256: --
257: when hr_api.cannot_find_prog_unit then
258: --
259: hr_api.cannot_find_prog_unit_error
260: (p_module_name => 'ben_ptnl_ler_for_per'
261: ,p_hook_type => 'AU');
255: exception
256: --
257: when hr_api.cannot_find_prog_unit then
258: --
259: hr_api.cannot_find_prog_unit_error
260: (p_module_name => 'ben_ptnl_ler_for_per'
261: ,p_hook_type => 'AU');
262: --
263: end;
323: -- p_rec plsql record structure
324: -- to see if a system default is being used. If a system default
325: -- is being used then we must set to the 'current' argument value.
326: --
327: If (p_rec.csd_by_ptnl_ler_for_per_id = hr_api.g_number) then
328: p_rec.csd_by_ptnl_ler_for_per_id :=
329: ben_ppl_shd.g_old_rec.csd_by_ptnl_ler_for_per_id;
330: End If;
331: If (p_rec.lf_evt_ocrd_dt = hr_api.g_date) then
327: If (p_rec.csd_by_ptnl_ler_for_per_id = hr_api.g_number) then
328: p_rec.csd_by_ptnl_ler_for_per_id :=
329: ben_ppl_shd.g_old_rec.csd_by_ptnl_ler_for_per_id;
330: End If;
331: If (p_rec.lf_evt_ocrd_dt = hr_api.g_date) then
332: p_rec.lf_evt_ocrd_dt :=
333: ben_ppl_shd.g_old_rec.lf_evt_ocrd_dt;
334: End If;
335: If (p_rec.trgr_table_pk_id = hr_api.g_number) then
331: If (p_rec.lf_evt_ocrd_dt = hr_api.g_date) then
332: p_rec.lf_evt_ocrd_dt :=
333: ben_ppl_shd.g_old_rec.lf_evt_ocrd_dt;
334: End If;
335: If (p_rec.trgr_table_pk_id = hr_api.g_number) then
336: p_rec.trgr_table_pk_id :=
337: ben_ppl_shd.g_old_rec.trgr_table_pk_id;
338: End If;
339: If (p_rec.ptnl_ler_for_per_stat_cd = hr_api.g_varchar2) then
335: If (p_rec.trgr_table_pk_id = hr_api.g_number) then
336: p_rec.trgr_table_pk_id :=
337: ben_ppl_shd.g_old_rec.trgr_table_pk_id;
338: End If;
339: If (p_rec.ptnl_ler_for_per_stat_cd = hr_api.g_varchar2) then
340: p_rec.ptnl_ler_for_per_stat_cd :=
341: ben_ppl_shd.g_old_rec.ptnl_ler_for_per_stat_cd;
342: End If;
343: If (p_rec.ptnl_ler_for_per_src_cd = hr_api.g_varchar2) then
339: If (p_rec.ptnl_ler_for_per_stat_cd = hr_api.g_varchar2) then
340: p_rec.ptnl_ler_for_per_stat_cd :=
341: ben_ppl_shd.g_old_rec.ptnl_ler_for_per_stat_cd;
342: End If;
343: If (p_rec.ptnl_ler_for_per_src_cd = hr_api.g_varchar2) then
344: p_rec.ptnl_ler_for_per_src_cd :=
345: ben_ppl_shd.g_old_rec.ptnl_ler_for_per_src_cd;
346: End If;
347: If (p_rec.mnl_dt = hr_api.g_date) then
343: If (p_rec.ptnl_ler_for_per_src_cd = hr_api.g_varchar2) then
344: p_rec.ptnl_ler_for_per_src_cd :=
345: ben_ppl_shd.g_old_rec.ptnl_ler_for_per_src_cd;
346: End If;
347: If (p_rec.mnl_dt = hr_api.g_date) then
348: p_rec.mnl_dt :=
349: ben_ppl_shd.g_old_rec.mnl_dt;
350: End If;
351: If (p_rec.enrt_perd_id = hr_api.g_number) then
347: If (p_rec.mnl_dt = hr_api.g_date) then
348: p_rec.mnl_dt :=
349: ben_ppl_shd.g_old_rec.mnl_dt;
350: End If;
351: If (p_rec.enrt_perd_id = hr_api.g_number) then
352: p_rec.enrt_perd_id :=
353: ben_ppl_shd.g_old_rec.enrt_perd_id;
354: End If;
355: If (p_rec.ntfn_dt = hr_api.g_date) then
351: If (p_rec.enrt_perd_id = hr_api.g_number) then
352: p_rec.enrt_perd_id :=
353: ben_ppl_shd.g_old_rec.enrt_perd_id;
354: End If;
355: If (p_rec.ntfn_dt = hr_api.g_date) then
356: p_rec.ntfn_dt :=
357: ben_ppl_shd.g_old_rec.ntfn_dt;
358: End If;
359: If (p_rec.dtctd_dt = hr_api.g_date) then
355: If (p_rec.ntfn_dt = hr_api.g_date) then
356: p_rec.ntfn_dt :=
357: ben_ppl_shd.g_old_rec.ntfn_dt;
358: End If;
359: If (p_rec.dtctd_dt = hr_api.g_date) then
360: p_rec.dtctd_dt :=
361: ben_ppl_shd.g_old_rec.dtctd_dt;
362: End If;
363: If (p_rec.procd_dt = hr_api.g_date) then
359: If (p_rec.dtctd_dt = hr_api.g_date) then
360: p_rec.dtctd_dt :=
361: ben_ppl_shd.g_old_rec.dtctd_dt;
362: End If;
363: If (p_rec.procd_dt = hr_api.g_date) then
364: p_rec.procd_dt :=
365: ben_ppl_shd.g_old_rec.procd_dt;
366: End If;
367: If (p_rec.unprocd_dt = hr_api.g_date) then
363: If (p_rec.procd_dt = hr_api.g_date) then
364: p_rec.procd_dt :=
365: ben_ppl_shd.g_old_rec.procd_dt;
366: End If;
367: If (p_rec.unprocd_dt = hr_api.g_date) then
368: p_rec.unprocd_dt :=
369: ben_ppl_shd.g_old_rec.unprocd_dt;
370: End If;
371: If (p_rec.voidd_dt = hr_api.g_date) then
367: If (p_rec.unprocd_dt = hr_api.g_date) then
368: p_rec.unprocd_dt :=
369: ben_ppl_shd.g_old_rec.unprocd_dt;
370: End If;
371: If (p_rec.voidd_dt = hr_api.g_date) then
372: p_rec.voidd_dt :=
373: ben_ppl_shd.g_old_rec.voidd_dt;
374: End If;
375: If (p_rec.mnlo_dt = hr_api.g_date) then
371: If (p_rec.voidd_dt = hr_api.g_date) then
372: p_rec.voidd_dt :=
373: ben_ppl_shd.g_old_rec.voidd_dt;
374: End If;
375: If (p_rec.mnlo_dt = hr_api.g_date) then
376: p_rec.mnlo_dt :=
377: ben_ppl_shd.g_old_rec.mnlo_dt;
378: End If;
379: If (p_rec.ler_id = hr_api.g_number) then
375: If (p_rec.mnlo_dt = hr_api.g_date) then
376: p_rec.mnlo_dt :=
377: ben_ppl_shd.g_old_rec.mnlo_dt;
378: End If;
379: If (p_rec.ler_id = hr_api.g_number) then
380: p_rec.ler_id :=
381: ben_ppl_shd.g_old_rec.ler_id;
382: End If;
383: If (p_rec.person_id = hr_api.g_number) then
379: If (p_rec.ler_id = hr_api.g_number) then
380: p_rec.ler_id :=
381: ben_ppl_shd.g_old_rec.ler_id;
382: End If;
383: If (p_rec.person_id = hr_api.g_number) then
384: p_rec.person_id :=
385: ben_ppl_shd.g_old_rec.person_id;
386: End If;
387: If (p_rec.business_group_id = hr_api.g_number) then
383: If (p_rec.person_id = hr_api.g_number) then
384: p_rec.person_id :=
385: ben_ppl_shd.g_old_rec.person_id;
386: End If;
387: If (p_rec.business_group_id = hr_api.g_number) then
388: p_rec.business_group_id :=
389: ben_ppl_shd.g_old_rec.business_group_id;
390: End If;
391: If (p_rec.request_id = hr_api.g_number) then
387: If (p_rec.business_group_id = hr_api.g_number) then
388: p_rec.business_group_id :=
389: ben_ppl_shd.g_old_rec.business_group_id;
390: End If;
391: If (p_rec.request_id = hr_api.g_number) then
392: p_rec.request_id :=
393: ben_ppl_shd.g_old_rec.request_id;
394: End If;
395: If (p_rec.program_application_id = hr_api.g_number) then
391: If (p_rec.request_id = hr_api.g_number) then
392: p_rec.request_id :=
393: ben_ppl_shd.g_old_rec.request_id;
394: End If;
395: If (p_rec.program_application_id = hr_api.g_number) then
396: p_rec.program_application_id :=
397: ben_ppl_shd.g_old_rec.program_application_id;
398: End If;
399: If (p_rec.program_id = hr_api.g_number) then
395: If (p_rec.program_application_id = hr_api.g_number) then
396: p_rec.program_application_id :=
397: ben_ppl_shd.g_old_rec.program_application_id;
398: End If;
399: If (p_rec.program_id = hr_api.g_number) then
400: p_rec.program_id :=
401: ben_ppl_shd.g_old_rec.program_id;
402: End If;
403: If (p_rec.program_update_date = hr_api.g_date) then
399: If (p_rec.program_id = hr_api.g_number) then
400: p_rec.program_id :=
401: ben_ppl_shd.g_old_rec.program_id;
402: End If;
403: If (p_rec.program_update_date = hr_api.g_date) then
404: p_rec.program_update_date :=
405: ben_ppl_shd.g_old_rec.program_update_date;
406: End If;
407:
461: Procedure upd
462: (
463: p_effective_date in date,
464: p_ptnl_ler_for_per_id in number,
465: p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number,
466: p_lf_evt_ocrd_dt in date default hr_api.g_date,
467: p_trgr_table_pk_id in number default hr_api.g_number,
468: p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2,
469: p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2,
462: (
463: p_effective_date in date,
464: p_ptnl_ler_for_per_id in number,
465: p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number,
466: p_lf_evt_ocrd_dt in date default hr_api.g_date,
467: p_trgr_table_pk_id in number default hr_api.g_number,
468: p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2,
469: p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2,
470: p_mnl_dt in date default hr_api.g_date,
463: p_effective_date in date,
464: p_ptnl_ler_for_per_id in number,
465: p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number,
466: p_lf_evt_ocrd_dt in date default hr_api.g_date,
467: p_trgr_table_pk_id in number default hr_api.g_number,
468: p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2,
469: p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2,
470: p_mnl_dt in date default hr_api.g_date,
471: p_enrt_perd_id in number default hr_api.g_number,
464: p_ptnl_ler_for_per_id in number,
465: p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number,
466: p_lf_evt_ocrd_dt in date default hr_api.g_date,
467: p_trgr_table_pk_id in number default hr_api.g_number,
468: p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2,
469: p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2,
470: p_mnl_dt in date default hr_api.g_date,
471: p_enrt_perd_id in number default hr_api.g_number,
472: p_ntfn_dt in date default hr_api.g_date,
465: p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number,
466: p_lf_evt_ocrd_dt in date default hr_api.g_date,
467: p_trgr_table_pk_id in number default hr_api.g_number,
468: p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2,
469: p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2,
470: p_mnl_dt in date default hr_api.g_date,
471: p_enrt_perd_id in number default hr_api.g_number,
472: p_ntfn_dt in date default hr_api.g_date,
473: p_dtctd_dt in date default hr_api.g_date,
466: p_lf_evt_ocrd_dt in date default hr_api.g_date,
467: p_trgr_table_pk_id in number default hr_api.g_number,
468: p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2,
469: p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2,
470: p_mnl_dt in date default hr_api.g_date,
471: p_enrt_perd_id in number default hr_api.g_number,
472: p_ntfn_dt in date default hr_api.g_date,
473: p_dtctd_dt in date default hr_api.g_date,
474: p_procd_dt in date default hr_api.g_date,
467: p_trgr_table_pk_id in number default hr_api.g_number,
468: p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2,
469: p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2,
470: p_mnl_dt in date default hr_api.g_date,
471: p_enrt_perd_id in number default hr_api.g_number,
472: p_ntfn_dt in date default hr_api.g_date,
473: p_dtctd_dt in date default hr_api.g_date,
474: p_procd_dt in date default hr_api.g_date,
475: p_unprocd_dt in date default hr_api.g_date,
468: p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2,
469: p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2,
470: p_mnl_dt in date default hr_api.g_date,
471: p_enrt_perd_id in number default hr_api.g_number,
472: p_ntfn_dt in date default hr_api.g_date,
473: p_dtctd_dt in date default hr_api.g_date,
474: p_procd_dt in date default hr_api.g_date,
475: p_unprocd_dt in date default hr_api.g_date,
476: p_voidd_dt in date default hr_api.g_date,
469: p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2,
470: p_mnl_dt in date default hr_api.g_date,
471: p_enrt_perd_id in number default hr_api.g_number,
472: p_ntfn_dt in date default hr_api.g_date,
473: p_dtctd_dt in date default hr_api.g_date,
474: p_procd_dt in date default hr_api.g_date,
475: p_unprocd_dt in date default hr_api.g_date,
476: p_voidd_dt in date default hr_api.g_date,
477: p_mnlo_dt in date default hr_api.g_date,
470: p_mnl_dt in date default hr_api.g_date,
471: p_enrt_perd_id in number default hr_api.g_number,
472: p_ntfn_dt in date default hr_api.g_date,
473: p_dtctd_dt in date default hr_api.g_date,
474: p_procd_dt in date default hr_api.g_date,
475: p_unprocd_dt in date default hr_api.g_date,
476: p_voidd_dt in date default hr_api.g_date,
477: p_mnlo_dt in date default hr_api.g_date,
478: p_ler_id in number default hr_api.g_number,
471: p_enrt_perd_id in number default hr_api.g_number,
472: p_ntfn_dt in date default hr_api.g_date,
473: p_dtctd_dt in date default hr_api.g_date,
474: p_procd_dt in date default hr_api.g_date,
475: p_unprocd_dt in date default hr_api.g_date,
476: p_voidd_dt in date default hr_api.g_date,
477: p_mnlo_dt in date default hr_api.g_date,
478: p_ler_id in number default hr_api.g_number,
479: p_person_id in number default hr_api.g_number,
472: p_ntfn_dt in date default hr_api.g_date,
473: p_dtctd_dt in date default hr_api.g_date,
474: p_procd_dt in date default hr_api.g_date,
475: p_unprocd_dt in date default hr_api.g_date,
476: p_voidd_dt in date default hr_api.g_date,
477: p_mnlo_dt in date default hr_api.g_date,
478: p_ler_id in number default hr_api.g_number,
479: p_person_id in number default hr_api.g_number,
480: p_business_group_id in number default hr_api.g_number,
473: p_dtctd_dt in date default hr_api.g_date,
474: p_procd_dt in date default hr_api.g_date,
475: p_unprocd_dt in date default hr_api.g_date,
476: p_voidd_dt in date default hr_api.g_date,
477: p_mnlo_dt in date default hr_api.g_date,
478: p_ler_id in number default hr_api.g_number,
479: p_person_id in number default hr_api.g_number,
480: p_business_group_id in number default hr_api.g_number,
481: p_request_id in number default hr_api.g_number,
474: p_procd_dt in date default hr_api.g_date,
475: p_unprocd_dt in date default hr_api.g_date,
476: p_voidd_dt in date default hr_api.g_date,
477: p_mnlo_dt in date default hr_api.g_date,
478: p_ler_id in number default hr_api.g_number,
479: p_person_id in number default hr_api.g_number,
480: p_business_group_id in number default hr_api.g_number,
481: p_request_id in number default hr_api.g_number,
482: p_program_application_id in number default hr_api.g_number,
475: p_unprocd_dt in date default hr_api.g_date,
476: p_voidd_dt in date default hr_api.g_date,
477: p_mnlo_dt in date default hr_api.g_date,
478: p_ler_id in number default hr_api.g_number,
479: p_person_id in number default hr_api.g_number,
480: p_business_group_id in number default hr_api.g_number,
481: p_request_id in number default hr_api.g_number,
482: p_program_application_id in number default hr_api.g_number,
483: p_program_id in number default hr_api.g_number,
476: p_voidd_dt in date default hr_api.g_date,
477: p_mnlo_dt in date default hr_api.g_date,
478: p_ler_id in number default hr_api.g_number,
479: p_person_id in number default hr_api.g_number,
480: p_business_group_id in number default hr_api.g_number,
481: p_request_id in number default hr_api.g_number,
482: p_program_application_id in number default hr_api.g_number,
483: p_program_id in number default hr_api.g_number,
484: p_program_update_date in date default hr_api.g_date,
477: p_mnlo_dt in date default hr_api.g_date,
478: p_ler_id in number default hr_api.g_number,
479: p_person_id in number default hr_api.g_number,
480: p_business_group_id in number default hr_api.g_number,
481: p_request_id in number default hr_api.g_number,
482: p_program_application_id in number default hr_api.g_number,
483: p_program_id in number default hr_api.g_number,
484: p_program_update_date in date default hr_api.g_date,
485: p_object_version_number in out nocopy number
478: p_ler_id in number default hr_api.g_number,
479: p_person_id in number default hr_api.g_number,
480: p_business_group_id in number default hr_api.g_number,
481: p_request_id in number default hr_api.g_number,
482: p_program_application_id in number default hr_api.g_number,
483: p_program_id in number default hr_api.g_number,
484: p_program_update_date in date default hr_api.g_date,
485: p_object_version_number in out nocopy number
486: ) is
479: p_person_id in number default hr_api.g_number,
480: p_business_group_id in number default hr_api.g_number,
481: p_request_id in number default hr_api.g_number,
482: p_program_application_id in number default hr_api.g_number,
483: p_program_id in number default hr_api.g_number,
484: p_program_update_date in date default hr_api.g_date,
485: p_object_version_number in out nocopy number
486: ) is
487: --
480: p_business_group_id in number default hr_api.g_number,
481: p_request_id in number default hr_api.g_number,
482: p_program_application_id in number default hr_api.g_number,
483: p_program_id in number default hr_api.g_number,
484: p_program_update_date in date default hr_api.g_date,
485: p_object_version_number in out nocopy number
486: ) is
487: --
488: l_rec ben_ppl_shd.g_rec_type;