APPS.BEN_PTNL_LER_FOR_PER_API dependencies on HR_API

Line 142: when hr_api.cannot_find_prog_unit then

138: ,p_effective_date => trunc(p_effective_date));
139: --
140: exception
141: --
142: when hr_api.cannot_find_prog_unit then
143: --
144: hr_api.cannot_find_prog_unit_error
145: (p_module_name => 'CREATE_ptnl_ler_for_per'
146: ,p_hook_type => 'BP');

Line 144: hr_api.cannot_find_prog_unit_error

140: exception
141: --
142: when hr_api.cannot_find_prog_unit then
143: --
144: hr_api.cannot_find_prog_unit_error
145: (p_module_name => 'CREATE_ptnl_ler_for_per'
146: ,p_hook_type => 'BP');
147: --
148: -- End of API User Hook for the before hook of create_ptnl_ler_for_per

Line 208: when hr_api.cannot_find_prog_unit then

204: ,p_effective_date => trunc(p_effective_date));
205: --
206: exception
207: --
208: when hr_api.cannot_find_prog_unit then
209: --
210: hr_api.cannot_find_prog_unit_error
211: (p_module_name => 'CREATE_ptnl_ler_for_per'
212: ,p_hook_type => 'AP');

Line 210: hr_api.cannot_find_prog_unit_error

206: exception
207: --
208: when hr_api.cannot_find_prog_unit then
209: --
210: hr_api.cannot_find_prog_unit_error
211: (p_module_name => 'CREATE_ptnl_ler_for_per'
212: ,p_hook_type => 'AP');
213: --
214: -- End of API User Hook for the after hook of create_ptnl_ler_for_per

Line 225: raise hr_api.validate_enabled;

221: --
222: -- When in validation only mode raise the Validate_Enabled exception
223: --
224: if p_validate then
225: raise hr_api.validate_enabled;
226: end if;
227: --
228: -- Set all output arguments
229: --

Line 239: when hr_api.validate_enabled then

235: end if;
236: --
237: exception
238: --
239: when hr_api.validate_enabled then
240: --
241: -- As the Validate_Enabled exception has been raised
242: -- we must rollback to the savepoint
243: --

Line 342: when hr_api.cannot_find_prog_unit then

338: ,p_effective_date => trunc(p_effective_date));
339: --
340: exception
341: --
342: when hr_api.cannot_find_prog_unit then
343: --
344: hr_api.cannot_find_prog_unit_error
345: (p_module_name => 'CREATE_ptnl_ler_for_per'
346: ,p_hook_type => 'BP');

Line 344: hr_api.cannot_find_prog_unit_error

340: exception
341: --
342: when hr_api.cannot_find_prog_unit then
343: --
344: hr_api.cannot_find_prog_unit_error
345: (p_module_name => 'CREATE_ptnl_ler_for_per'
346: ,p_hook_type => 'BP');
347: --
348: -- End of API User Hook for the before hook of create_ptnl_ler_for_per

Line 436: when hr_api.cannot_find_prog_unit then

432: ,p_effective_date => trunc(p_effective_date));
433: --
434: exception
435: --
436: when hr_api.cannot_find_prog_unit then
437: --
438: hr_api.cannot_find_prog_unit_error
439: (p_module_name => 'CREATE_ptnl_ler_for_per'
440: ,p_hook_type => 'AP');

Line 438: hr_api.cannot_find_prog_unit_error

434: exception
435: --
436: when hr_api.cannot_find_prog_unit then
437: --
438: hr_api.cannot_find_prog_unit_error
439: (p_module_name => 'CREATE_ptnl_ler_for_per'
440: ,p_hook_type => 'AP');
441: --
442: -- End of API User Hook for the after hook of create_ptnl_ler_for_per

Line 449: raise hr_api.validate_enabled;

445: --
446: -- When in validation only mode raise the Validate_Enabled exception
447: --
448: if p_validate then
449: raise hr_api.validate_enabled;
450: end if;
451: --
452: -- Set all output arguments
453: --

Line 459: when hr_api.validate_enabled then

455: p_object_version_number := l_object_version_number;
456: --
457: exception
458: --
459: when hr_api.validate_enabled then
460: --
461: -- As the Validate_Enabled exception has been raised
462: -- we must rollback to the savepoint
463: --

Line 491: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number

487: --
488: procedure update_ptnl_ler_for_per
489: (p_validate in boolean default false
490: ,p_ptnl_ler_for_per_id in number
491: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number
492: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
493: ,p_trgr_table_pk_id in number default hr_api.g_number
494: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
495: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2

Line 492: ,p_lf_evt_ocrd_dt in date default hr_api.g_date

488: procedure update_ptnl_ler_for_per
489: (p_validate in boolean default false
490: ,p_ptnl_ler_for_per_id in number
491: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number
492: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
493: ,p_trgr_table_pk_id in number default hr_api.g_number
494: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
495: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
496: ,p_mnl_dt in date default hr_api.g_date

Line 493: ,p_trgr_table_pk_id in number default hr_api.g_number

489: (p_validate in boolean default false
490: ,p_ptnl_ler_for_per_id in number
491: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number
492: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
493: ,p_trgr_table_pk_id in number default hr_api.g_number
494: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
495: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
496: ,p_mnl_dt in date default hr_api.g_date
497: ,p_enrt_perd_id in number default hr_api.g_number

Line 494: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2

490: ,p_ptnl_ler_for_per_id in number
491: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number
492: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
493: ,p_trgr_table_pk_id in number default hr_api.g_number
494: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
495: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
496: ,p_mnl_dt in date default hr_api.g_date
497: ,p_enrt_perd_id in number default hr_api.g_number
498: ,p_ler_id in number default hr_api.g_number

Line 495: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2

491: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number
492: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
493: ,p_trgr_table_pk_id in number default hr_api.g_number
494: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
495: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
496: ,p_mnl_dt in date default hr_api.g_date
497: ,p_enrt_perd_id in number default hr_api.g_number
498: ,p_ler_id in number default hr_api.g_number
499: ,p_person_id in number default hr_api.g_number

Line 496: ,p_mnl_dt in date default hr_api.g_date

492: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
493: ,p_trgr_table_pk_id in number default hr_api.g_number
494: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
495: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
496: ,p_mnl_dt in date default hr_api.g_date
497: ,p_enrt_perd_id in number default hr_api.g_number
498: ,p_ler_id in number default hr_api.g_number
499: ,p_person_id in number default hr_api.g_number
500: ,p_business_group_id in number default hr_api.g_number

Line 497: ,p_enrt_perd_id in number default hr_api.g_number

493: ,p_trgr_table_pk_id in number default hr_api.g_number
494: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
495: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
496: ,p_mnl_dt in date default hr_api.g_date
497: ,p_enrt_perd_id in number default hr_api.g_number
498: ,p_ler_id in number default hr_api.g_number
499: ,p_person_id in number default hr_api.g_number
500: ,p_business_group_id in number default hr_api.g_number
501: ,p_dtctd_dt in date default hr_api.g_date

Line 498: ,p_ler_id in number default hr_api.g_number

494: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
495: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
496: ,p_mnl_dt in date default hr_api.g_date
497: ,p_enrt_perd_id in number default hr_api.g_number
498: ,p_ler_id in number default hr_api.g_number
499: ,p_person_id in number default hr_api.g_number
500: ,p_business_group_id in number default hr_api.g_number
501: ,p_dtctd_dt in date default hr_api.g_date
502: ,p_procd_dt in date default hr_api.g_date

Line 499: ,p_person_id in number default hr_api.g_number

495: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
496: ,p_mnl_dt in date default hr_api.g_date
497: ,p_enrt_perd_id in number default hr_api.g_number
498: ,p_ler_id in number default hr_api.g_number
499: ,p_person_id in number default hr_api.g_number
500: ,p_business_group_id in number default hr_api.g_number
501: ,p_dtctd_dt in date default hr_api.g_date
502: ,p_procd_dt in date default hr_api.g_date
503: ,p_unprocd_dt in date default hr_api.g_date

Line 500: ,p_business_group_id in number default hr_api.g_number

496: ,p_mnl_dt in date default hr_api.g_date
497: ,p_enrt_perd_id in number default hr_api.g_number
498: ,p_ler_id in number default hr_api.g_number
499: ,p_person_id in number default hr_api.g_number
500: ,p_business_group_id in number default hr_api.g_number
501: ,p_dtctd_dt in date default hr_api.g_date
502: ,p_procd_dt in date default hr_api.g_date
503: ,p_unprocd_dt in date default hr_api.g_date
504: ,p_voidd_dt in date default hr_api.g_date

Line 501: ,p_dtctd_dt in date default hr_api.g_date

497: ,p_enrt_perd_id in number default hr_api.g_number
498: ,p_ler_id in number default hr_api.g_number
499: ,p_person_id in number default hr_api.g_number
500: ,p_business_group_id in number default hr_api.g_number
501: ,p_dtctd_dt in date default hr_api.g_date
502: ,p_procd_dt in date default hr_api.g_date
503: ,p_unprocd_dt in date default hr_api.g_date
504: ,p_voidd_dt in date default hr_api.g_date
505: ,p_mnlo_dt in date default hr_api.g_date

Line 502: ,p_procd_dt in date default hr_api.g_date

498: ,p_ler_id in number default hr_api.g_number
499: ,p_person_id in number default hr_api.g_number
500: ,p_business_group_id in number default hr_api.g_number
501: ,p_dtctd_dt in date default hr_api.g_date
502: ,p_procd_dt in date default hr_api.g_date
503: ,p_unprocd_dt in date default hr_api.g_date
504: ,p_voidd_dt in date default hr_api.g_date
505: ,p_mnlo_dt in date default hr_api.g_date
506: ,p_ntfn_dt in date default hr_api.g_date

Line 503: ,p_unprocd_dt in date default hr_api.g_date

499: ,p_person_id in number default hr_api.g_number
500: ,p_business_group_id in number default hr_api.g_number
501: ,p_dtctd_dt in date default hr_api.g_date
502: ,p_procd_dt in date default hr_api.g_date
503: ,p_unprocd_dt in date default hr_api.g_date
504: ,p_voidd_dt in date default hr_api.g_date
505: ,p_mnlo_dt in date default hr_api.g_date
506: ,p_ntfn_dt in date default hr_api.g_date
507: ,p_request_id in number default hr_api.g_number

Line 504: ,p_voidd_dt in date default hr_api.g_date

500: ,p_business_group_id in number default hr_api.g_number
501: ,p_dtctd_dt in date default hr_api.g_date
502: ,p_procd_dt in date default hr_api.g_date
503: ,p_unprocd_dt in date default hr_api.g_date
504: ,p_voidd_dt in date default hr_api.g_date
505: ,p_mnlo_dt in date default hr_api.g_date
506: ,p_ntfn_dt in date default hr_api.g_date
507: ,p_request_id in number default hr_api.g_number
508: ,p_program_application_id in number default hr_api.g_number

Line 505: ,p_mnlo_dt in date default hr_api.g_date

501: ,p_dtctd_dt in date default hr_api.g_date
502: ,p_procd_dt in date default hr_api.g_date
503: ,p_unprocd_dt in date default hr_api.g_date
504: ,p_voidd_dt in date default hr_api.g_date
505: ,p_mnlo_dt in date default hr_api.g_date
506: ,p_ntfn_dt in date default hr_api.g_date
507: ,p_request_id in number default hr_api.g_number
508: ,p_program_application_id in number default hr_api.g_number
509: ,p_program_id in number default hr_api.g_number

Line 506: ,p_ntfn_dt in date default hr_api.g_date

502: ,p_procd_dt in date default hr_api.g_date
503: ,p_unprocd_dt in date default hr_api.g_date
504: ,p_voidd_dt in date default hr_api.g_date
505: ,p_mnlo_dt in date default hr_api.g_date
506: ,p_ntfn_dt in date default hr_api.g_date
507: ,p_request_id in number default hr_api.g_number
508: ,p_program_application_id in number default hr_api.g_number
509: ,p_program_id in number default hr_api.g_number
510: ,p_program_update_date in date default hr_api.g_date

Line 507: ,p_request_id in number default hr_api.g_number

503: ,p_unprocd_dt in date default hr_api.g_date
504: ,p_voidd_dt in date default hr_api.g_date
505: ,p_mnlo_dt in date default hr_api.g_date
506: ,p_ntfn_dt in date default hr_api.g_date
507: ,p_request_id in number default hr_api.g_number
508: ,p_program_application_id in number default hr_api.g_number
509: ,p_program_id in number default hr_api.g_number
510: ,p_program_update_date in date default hr_api.g_date
511: ,p_object_version_number in out nocopy number

Line 508: ,p_program_application_id in number default hr_api.g_number

504: ,p_voidd_dt in date default hr_api.g_date
505: ,p_mnlo_dt in date default hr_api.g_date
506: ,p_ntfn_dt in date default hr_api.g_date
507: ,p_request_id in number default hr_api.g_number
508: ,p_program_application_id in number default hr_api.g_number
509: ,p_program_id in number default hr_api.g_number
510: ,p_program_update_date in date default hr_api.g_date
511: ,p_object_version_number in out nocopy number
512: ,p_effective_date in date) is

Line 509: ,p_program_id in number default hr_api.g_number

505: ,p_mnlo_dt in date default hr_api.g_date
506: ,p_ntfn_dt in date default hr_api.g_date
507: ,p_request_id in number default hr_api.g_number
508: ,p_program_application_id in number default hr_api.g_number
509: ,p_program_id in number default hr_api.g_number
510: ,p_program_update_date in date default hr_api.g_date
511: ,p_object_version_number in out nocopy number
512: ,p_effective_date in date) is
513: --

Line 510: ,p_program_update_date in date default hr_api.g_date

506: ,p_ntfn_dt in date default hr_api.g_date
507: ,p_request_id in number default hr_api.g_number
508: ,p_program_application_id in number default hr_api.g_number
509: ,p_program_id in number default hr_api.g_number
510: ,p_program_update_date in date default hr_api.g_date
511: ,p_object_version_number in out nocopy number
512: ,p_effective_date in date) is
513: --
514: -- Declare cursors and local variables

Line 570: when hr_api.cannot_find_prog_unit then

566: ,p_effective_date => trunc(p_effective_date));
567: --
568: exception
569: --
570: when hr_api.cannot_find_prog_unit then
571: --
572: hr_api.cannot_find_prog_unit_error
573: (p_module_name => 'UPDATE_ptnl_ler_for_per'
574: ,p_hook_type => 'BP');

Line 572: hr_api.cannot_find_prog_unit_error

568: exception
569: --
570: when hr_api.cannot_find_prog_unit then
571: --
572: hr_api.cannot_find_prog_unit_error
573: (p_module_name => 'UPDATE_ptnl_ler_for_per'
574: ,p_hook_type => 'BP');
575: --
576: -- End of API User Hook for the before hook of update_ptnl_ler_for_per

Line 636: when hr_api.cannot_find_prog_unit then

632: ,p_effective_date => trunc(p_effective_date));
633: --
634: exception
635: --
636: when hr_api.cannot_find_prog_unit then
637: --
638: hr_api.cannot_find_prog_unit_error
639: (p_module_name => 'UPDATE_ptnl_ler_for_per'
640: ,p_hook_type => 'AP');

Line 638: hr_api.cannot_find_prog_unit_error

634: exception
635: --
636: when hr_api.cannot_find_prog_unit then
637: --
638: hr_api.cannot_find_prog_unit_error
639: (p_module_name => 'UPDATE_ptnl_ler_for_per'
640: ,p_hook_type => 'AP');
641: --
642: -- End of API User Hook for the after hook of update_ptnl_ler_for_per

Line 653: raise hr_api.validate_enabled;

649: --
650: -- When in validation only mode raise the Validate_Enabled exception
651: --
652: if p_validate then
653: raise hr_api.validate_enabled;
654: end if;
655: --
656: -- Set all output arguments
657: --

Line 666: when hr_api.validate_enabled then

662: end if;
663: --
664: exception
665: --
666: when hr_api.validate_enabled then
667: --
668: -- As the Validate_Enabled exception has been raised
669: -- we must rollback to the savepoint
670: --

Line 697: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number

693: --
694: procedure update_ptnl_ler_for_per_perf
695: (p_validate in boolean default false
696: ,p_ptnl_ler_for_per_id in number
697: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number
698: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
699: ,p_trgr_table_pk_id in number default hr_api.g_number
700: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
701: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2

Line 698: ,p_lf_evt_ocrd_dt in date default hr_api.g_date

694: procedure update_ptnl_ler_for_per_perf
695: (p_validate in boolean default false
696: ,p_ptnl_ler_for_per_id in number
697: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number
698: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
699: ,p_trgr_table_pk_id in number default hr_api.g_number
700: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
701: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
702: ,p_mnl_dt in date default hr_api.g_date

Line 699: ,p_trgr_table_pk_id in number default hr_api.g_number

695: (p_validate in boolean default false
696: ,p_ptnl_ler_for_per_id in number
697: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number
698: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
699: ,p_trgr_table_pk_id in number default hr_api.g_number
700: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
701: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
702: ,p_mnl_dt in date default hr_api.g_date
703: ,p_enrt_perd_id in number default hr_api.g_number

Line 700: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2

696: ,p_ptnl_ler_for_per_id in number
697: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number
698: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
699: ,p_trgr_table_pk_id in number default hr_api.g_number
700: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
701: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
702: ,p_mnl_dt in date default hr_api.g_date
703: ,p_enrt_perd_id in number default hr_api.g_number
704: ,p_ler_id in number default hr_api.g_number

Line 701: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2

697: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number
698: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
699: ,p_trgr_table_pk_id in number default hr_api.g_number
700: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
701: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
702: ,p_mnl_dt in date default hr_api.g_date
703: ,p_enrt_perd_id in number default hr_api.g_number
704: ,p_ler_id in number default hr_api.g_number
705: ,p_person_id in number default hr_api.g_number

Line 702: ,p_mnl_dt in date default hr_api.g_date

698: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
699: ,p_trgr_table_pk_id in number default hr_api.g_number
700: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
701: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
702: ,p_mnl_dt in date default hr_api.g_date
703: ,p_enrt_perd_id in number default hr_api.g_number
704: ,p_ler_id in number default hr_api.g_number
705: ,p_person_id in number default hr_api.g_number
706: ,p_business_group_id in number default hr_api.g_number

Line 703: ,p_enrt_perd_id in number default hr_api.g_number

699: ,p_trgr_table_pk_id in number default hr_api.g_number
700: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
701: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
702: ,p_mnl_dt in date default hr_api.g_date
703: ,p_enrt_perd_id in number default hr_api.g_number
704: ,p_ler_id in number default hr_api.g_number
705: ,p_person_id in number default hr_api.g_number
706: ,p_business_group_id in number default hr_api.g_number
707: ,p_dtctd_dt in date default hr_api.g_date

Line 704: ,p_ler_id in number default hr_api.g_number

700: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
701: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
702: ,p_mnl_dt in date default hr_api.g_date
703: ,p_enrt_perd_id in number default hr_api.g_number
704: ,p_ler_id in number default hr_api.g_number
705: ,p_person_id in number default hr_api.g_number
706: ,p_business_group_id in number default hr_api.g_number
707: ,p_dtctd_dt in date default hr_api.g_date
708: ,p_procd_dt in date default hr_api.g_date

Line 705: ,p_person_id in number default hr_api.g_number

701: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
702: ,p_mnl_dt in date default hr_api.g_date
703: ,p_enrt_perd_id in number default hr_api.g_number
704: ,p_ler_id in number default hr_api.g_number
705: ,p_person_id in number default hr_api.g_number
706: ,p_business_group_id in number default hr_api.g_number
707: ,p_dtctd_dt in date default hr_api.g_date
708: ,p_procd_dt in date default hr_api.g_date
709: ,p_unprocd_dt in date default hr_api.g_date

Line 706: ,p_business_group_id in number default hr_api.g_number

702: ,p_mnl_dt in date default hr_api.g_date
703: ,p_enrt_perd_id in number default hr_api.g_number
704: ,p_ler_id in number default hr_api.g_number
705: ,p_person_id in number default hr_api.g_number
706: ,p_business_group_id in number default hr_api.g_number
707: ,p_dtctd_dt in date default hr_api.g_date
708: ,p_procd_dt in date default hr_api.g_date
709: ,p_unprocd_dt in date default hr_api.g_date
710: ,p_voidd_dt in date default hr_api.g_date

Line 707: ,p_dtctd_dt in date default hr_api.g_date

703: ,p_enrt_perd_id in number default hr_api.g_number
704: ,p_ler_id in number default hr_api.g_number
705: ,p_person_id in number default hr_api.g_number
706: ,p_business_group_id in number default hr_api.g_number
707: ,p_dtctd_dt in date default hr_api.g_date
708: ,p_procd_dt in date default hr_api.g_date
709: ,p_unprocd_dt in date default hr_api.g_date
710: ,p_voidd_dt in date default hr_api.g_date
711: ,p_mnlo_dt in date default hr_api.g_date

Line 708: ,p_procd_dt in date default hr_api.g_date

704: ,p_ler_id in number default hr_api.g_number
705: ,p_person_id in number default hr_api.g_number
706: ,p_business_group_id in number default hr_api.g_number
707: ,p_dtctd_dt in date default hr_api.g_date
708: ,p_procd_dt in date default hr_api.g_date
709: ,p_unprocd_dt in date default hr_api.g_date
710: ,p_voidd_dt in date default hr_api.g_date
711: ,p_mnlo_dt in date default hr_api.g_date
712: ,p_ntfn_dt in date default hr_api.g_date

Line 709: ,p_unprocd_dt in date default hr_api.g_date

705: ,p_person_id in number default hr_api.g_number
706: ,p_business_group_id in number default hr_api.g_number
707: ,p_dtctd_dt in date default hr_api.g_date
708: ,p_procd_dt in date default hr_api.g_date
709: ,p_unprocd_dt in date default hr_api.g_date
710: ,p_voidd_dt in date default hr_api.g_date
711: ,p_mnlo_dt in date default hr_api.g_date
712: ,p_ntfn_dt in date default hr_api.g_date
713: ,p_request_id in number default hr_api.g_number

Line 710: ,p_voidd_dt in date default hr_api.g_date

706: ,p_business_group_id in number default hr_api.g_number
707: ,p_dtctd_dt in date default hr_api.g_date
708: ,p_procd_dt in date default hr_api.g_date
709: ,p_unprocd_dt in date default hr_api.g_date
710: ,p_voidd_dt in date default hr_api.g_date
711: ,p_mnlo_dt in date default hr_api.g_date
712: ,p_ntfn_dt in date default hr_api.g_date
713: ,p_request_id in number default hr_api.g_number
714: ,p_program_application_id in number default hr_api.g_number

Line 711: ,p_mnlo_dt in date default hr_api.g_date

707: ,p_dtctd_dt in date default hr_api.g_date
708: ,p_procd_dt in date default hr_api.g_date
709: ,p_unprocd_dt in date default hr_api.g_date
710: ,p_voidd_dt in date default hr_api.g_date
711: ,p_mnlo_dt in date default hr_api.g_date
712: ,p_ntfn_dt in date default hr_api.g_date
713: ,p_request_id in number default hr_api.g_number
714: ,p_program_application_id in number default hr_api.g_number
715: ,p_program_id in number default hr_api.g_number

Line 712: ,p_ntfn_dt in date default hr_api.g_date

708: ,p_procd_dt in date default hr_api.g_date
709: ,p_unprocd_dt in date default hr_api.g_date
710: ,p_voidd_dt in date default hr_api.g_date
711: ,p_mnlo_dt in date default hr_api.g_date
712: ,p_ntfn_dt in date default hr_api.g_date
713: ,p_request_id in number default hr_api.g_number
714: ,p_program_application_id in number default hr_api.g_number
715: ,p_program_id in number default hr_api.g_number
716: ,p_program_update_date in date default hr_api.g_date

Line 713: ,p_request_id in number default hr_api.g_number

709: ,p_unprocd_dt in date default hr_api.g_date
710: ,p_voidd_dt in date default hr_api.g_date
711: ,p_mnlo_dt in date default hr_api.g_date
712: ,p_ntfn_dt in date default hr_api.g_date
713: ,p_request_id in number default hr_api.g_number
714: ,p_program_application_id in number default hr_api.g_number
715: ,p_program_id in number default hr_api.g_number
716: ,p_program_update_date in date default hr_api.g_date
717: ,p_object_version_number in out nocopy number

Line 714: ,p_program_application_id in number default hr_api.g_number

710: ,p_voidd_dt in date default hr_api.g_date
711: ,p_mnlo_dt in date default hr_api.g_date
712: ,p_ntfn_dt in date default hr_api.g_date
713: ,p_request_id in number default hr_api.g_number
714: ,p_program_application_id in number default hr_api.g_number
715: ,p_program_id in number default hr_api.g_number
716: ,p_program_update_date in date default hr_api.g_date
717: ,p_object_version_number in out nocopy number
718: ,p_effective_date in date) is

Line 715: ,p_program_id in number default hr_api.g_number

711: ,p_mnlo_dt in date default hr_api.g_date
712: ,p_ntfn_dt in date default hr_api.g_date
713: ,p_request_id in number default hr_api.g_number
714: ,p_program_application_id in number default hr_api.g_number
715: ,p_program_id in number default hr_api.g_number
716: ,p_program_update_date in date default hr_api.g_date
717: ,p_object_version_number in out nocopy number
718: ,p_effective_date in date) is
719: --

Line 716: ,p_program_update_date in date default hr_api.g_date

712: ,p_ntfn_dt in date default hr_api.g_date
713: ,p_request_id in number default hr_api.g_number
714: ,p_program_application_id in number default hr_api.g_number
715: ,p_program_id in number default hr_api.g_number
716: ,p_program_update_date in date default hr_api.g_date
717: ,p_object_version_number in out nocopy number
718: ,p_effective_date in date) is
719: --
720: -- Declare cursors and local variables

Line 790: when hr_api.cannot_find_prog_unit then

786: ,p_effective_date => trunc(p_effective_date));
787: --
788: exception
789: --
790: when hr_api.cannot_find_prog_unit then
791: --
792: hr_api.cannot_find_prog_unit_error
793: (p_module_name => 'UPDATE_ptnl_ler_for_per'
794: ,p_hook_type => 'BP');

Line 792: hr_api.cannot_find_prog_unit_error

788: exception
789: --
790: when hr_api.cannot_find_prog_unit then
791: --
792: hr_api.cannot_find_prog_unit_error
793: (p_module_name => 'UPDATE_ptnl_ler_for_per'
794: ,p_hook_type => 'BP');
795: --
796: -- End of API User Hook for the before hook of update_ptnl_ler_for_per

Line 808: If (l_csd_by_ptnl_ler_for_per_id = hr_api.g_number) then

804: --
805: -- default variables for update
806: --
807: l_csd_by_ptnl_ler_for_per_id := p_csd_by_ptnl_ler_for_per_id;
808: If (l_csd_by_ptnl_ler_for_per_id = hr_api.g_number) then
809: l_csd_by_ptnl_ler_for_per_id :=
810: ben_ppl_shd.g_old_rec.csd_by_ptnl_ler_for_per_id;
811: End If;
812: l_lf_evt_ocrd_dt := trunc(p_lf_evt_ocrd_dt);

Line 813: If (p_lf_evt_ocrd_dt = hr_api.g_date) then

809: l_csd_by_ptnl_ler_for_per_id :=
810: ben_ppl_shd.g_old_rec.csd_by_ptnl_ler_for_per_id;
811: End If;
812: l_lf_evt_ocrd_dt := trunc(p_lf_evt_ocrd_dt);
813: If (p_lf_evt_ocrd_dt = hr_api.g_date) then
814: l_lf_evt_ocrd_dt :=
815: ben_ppl_shd.g_old_rec.lf_evt_ocrd_dt;
816: End If;
817: l_trgr_table_pk_id := p_trgr_table_pk_id;

Line 818: If (p_trgr_table_pk_id = hr_api.g_number) then

814: l_lf_evt_ocrd_dt :=
815: ben_ppl_shd.g_old_rec.lf_evt_ocrd_dt;
816: End If;
817: l_trgr_table_pk_id := p_trgr_table_pk_id;
818: If (p_trgr_table_pk_id = hr_api.g_number) then
819: l_trgr_table_pk_id :=
820: ben_ppl_shd.g_old_rec.trgr_table_pk_id;
821: End If;
822: l_ptnl_ler_for_per_stat_cd := p_ptnl_ler_for_per_stat_cd;

Line 823: If (l_ptnl_ler_for_per_stat_cd = hr_api.g_varchar2) then

819: l_trgr_table_pk_id :=
820: ben_ppl_shd.g_old_rec.trgr_table_pk_id;
821: End If;
822: l_ptnl_ler_for_per_stat_cd := p_ptnl_ler_for_per_stat_cd;
823: If (l_ptnl_ler_for_per_stat_cd = hr_api.g_varchar2) then
824: l_ptnl_ler_for_per_stat_cd :=
825: ben_ppl_shd.g_old_rec.ptnl_ler_for_per_stat_cd;
826: End If;
827: l_ptnl_ler_for_per_src_cd := p_ptnl_ler_for_per_src_cd;

Line 828: If (l_ptnl_ler_for_per_src_cd = hr_api.g_varchar2) then

824: l_ptnl_ler_for_per_stat_cd :=
825: ben_ppl_shd.g_old_rec.ptnl_ler_for_per_stat_cd;
826: End If;
827: l_ptnl_ler_for_per_src_cd := p_ptnl_ler_for_per_src_cd;
828: If (l_ptnl_ler_for_per_src_cd = hr_api.g_varchar2) then
829: l_ptnl_ler_for_per_src_cd :=
830: ben_ppl_shd.g_old_rec.ptnl_ler_for_per_src_cd;
831: End If;
832: l_enrt_perd_id := p_enrt_perd_id;

Line 833: If (l_enrt_perd_id = hr_api.g_number) then

829: l_ptnl_ler_for_per_src_cd :=
830: ben_ppl_shd.g_old_rec.ptnl_ler_for_per_src_cd;
831: End If;
832: l_enrt_perd_id := p_enrt_perd_id;
833: If (l_enrt_perd_id = hr_api.g_number) then
834: l_enrt_perd_id :=
835: ben_ppl_shd.g_old_rec.enrt_perd_id;
836: End If;
837: l_ler_id := p_ler_id;

Line 838: If (l_ler_id = hr_api.g_number) then

834: l_enrt_perd_id :=
835: ben_ppl_shd.g_old_rec.enrt_perd_id;
836: End If;
837: l_ler_id := p_ler_id;
838: If (l_ler_id = hr_api.g_number) then
839: l_ler_id :=
840: ben_ppl_shd.g_old_rec.ler_id;
841: End If;
842: l_ntfn_dt := trunc(p_ntfn_dt);

Line 843: If (l_ntfn_dt = hr_api.g_date) then

839: l_ler_id :=
840: ben_ppl_shd.g_old_rec.ler_id;
841: End If;
842: l_ntfn_dt := trunc(p_ntfn_dt);
843: If (l_ntfn_dt = hr_api.g_date) then
844: l_ntfn_dt :=
845: ben_ppl_shd.g_old_rec.ntfn_dt;
846: End If;
847: l_dtctd_dt := trunc(p_dtctd_dt);

Line 848: If (l_dtctd_dt = hr_api.g_date) then

844: l_ntfn_dt :=
845: ben_ppl_shd.g_old_rec.ntfn_dt;
846: End If;
847: l_dtctd_dt := trunc(p_dtctd_dt);
848: If (l_dtctd_dt = hr_api.g_date) then
849: l_dtctd_dt :=
850: ben_ppl_shd.g_old_rec.dtctd_dt;
851: End If;
852: l_procd_dt := trunc(p_procd_dt);

Line 853: If (l_procd_dt = hr_api.g_date) then

849: l_dtctd_dt :=
850: ben_ppl_shd.g_old_rec.dtctd_dt;
851: End If;
852: l_procd_dt := trunc(p_procd_dt);
853: If (l_procd_dt = hr_api.g_date) then
854: l_procd_dt :=
855: ben_ppl_shd.g_old_rec.procd_dt;
856: End If;
857: l_unprocd_dt := trunc(p_unprocd_dt);

Line 858: If (l_unprocd_dt = hr_api.g_date) then

854: l_procd_dt :=
855: ben_ppl_shd.g_old_rec.procd_dt;
856: End If;
857: l_unprocd_dt := trunc(p_unprocd_dt);
858: If (l_unprocd_dt = hr_api.g_date) then
859: l_unprocd_dt :=
860: ben_ppl_shd.g_old_rec.unprocd_dt;
861: End If;
862: l_voidd_dt := trunc(p_voidd_dt);

Line 863: If (l_voidd_dt = hr_api.g_date) then

859: l_unprocd_dt :=
860: ben_ppl_shd.g_old_rec.unprocd_dt;
861: End If;
862: l_voidd_dt := trunc(p_voidd_dt);
863: If (l_voidd_dt = hr_api.g_date) then
864: l_voidd_dt :=
865: ben_ppl_shd.g_old_rec.voidd_dt;
866: End If;
867: l_mnlo_dt := trunc(p_mnlo_dt);

Line 868: If (l_mnlo_dt = hr_api.g_date) then

864: l_voidd_dt :=
865: ben_ppl_shd.g_old_rec.voidd_dt;
866: End If;
867: l_mnlo_dt := trunc(p_mnlo_dt);
868: If (l_mnlo_dt = hr_api.g_date) then
869: l_mnlo_dt :=
870: ben_ppl_shd.g_old_rec.mnlo_dt;
871: End If;
872: l_mnl_dt := trunc(p_mnl_dt);

Line 873: If (l_mnl_dt = hr_api.g_date) then

869: l_mnlo_dt :=
870: ben_ppl_shd.g_old_rec.mnlo_dt;
871: End If;
872: l_mnl_dt := trunc(p_mnl_dt);
873: If (l_mnl_dt = hr_api.g_date) then
874: l_mnl_dt :=
875: ben_ppl_shd.g_old_rec.mnl_dt;
876: End If;
877: l_person_id := p_person_id;

Line 878: If (l_person_id = hr_api.g_number) then

874: l_mnl_dt :=
875: ben_ppl_shd.g_old_rec.mnl_dt;
876: End If;
877: l_person_id := p_person_id;
878: If (l_person_id = hr_api.g_number) then
879: l_person_id :=
880: ben_ppl_shd.g_old_rec.person_id;
881: End If;
882: l_business_group_id := p_business_group_id;

Line 883: If (l_business_group_id = hr_api.g_number) then

879: l_person_id :=
880: ben_ppl_shd.g_old_rec.person_id;
881: End If;
882: l_business_group_id := p_business_group_id;
883: If (l_business_group_id = hr_api.g_number) then
884: l_business_group_id :=
885: ben_ppl_shd.g_old_rec.business_group_id;
886: End If;
887: l_request_id := p_request_id;

Line 888: If (l_request_id = hr_api.g_number) then

884: l_business_group_id :=
885: ben_ppl_shd.g_old_rec.business_group_id;
886: End If;
887: l_request_id := p_request_id;
888: If (l_request_id = hr_api.g_number) then
889: l_request_id :=
890: ben_ppl_shd.g_old_rec.request_id;
891: End If;
892: l_program_application_id := p_program_application_id;

Line 893: If (l_program_application_id = hr_api.g_number) then

889: l_request_id :=
890: ben_ppl_shd.g_old_rec.request_id;
891: End If;
892: l_program_application_id := p_program_application_id;
893: If (l_program_application_id = hr_api.g_number) then
894: l_program_application_id :=
895: ben_ppl_shd.g_old_rec.program_application_id;
896: End If;
897: l_program_id := p_program_id;

Line 898: If (l_program_id = hr_api.g_number) then

894: l_program_application_id :=
895: ben_ppl_shd.g_old_rec.program_application_id;
896: End If;
897: l_program_id := p_program_id;
898: If (l_program_id = hr_api.g_number) then
899: l_program_id :=
900: ben_ppl_shd.g_old_rec.program_id;
901: End If;
902: l_program_update_date := trunc(p_program_update_date);

Line 903: If (l_program_update_date = hr_api.g_date) then

899: l_program_id :=
900: ben_ppl_shd.g_old_rec.program_id;
901: End If;
902: l_program_update_date := trunc(p_program_update_date);
903: If (l_program_update_date = hr_api.g_date) then
904: l_program_update_date :=
905: ben_ppl_shd.g_old_rec.program_update_date;
906: End If;
907: --

Line 968: when hr_api.cannot_find_prog_unit then

964: ,p_effective_date => trunc(p_effective_date));
965: --
966: exception
967: --
968: when hr_api.cannot_find_prog_unit then
969: --
970: hr_api.cannot_find_prog_unit_error
971: (p_module_name => 'UPDATE_ptnl_ler_for_per'
972: ,p_hook_type => 'AP');

Line 970: hr_api.cannot_find_prog_unit_error

966: exception
967: --
968: when hr_api.cannot_find_prog_unit then
969: --
970: hr_api.cannot_find_prog_unit_error
971: (p_module_name => 'UPDATE_ptnl_ler_for_per'
972: ,p_hook_type => 'AP');
973: --
974: -- End of API User Hook for the after hook of update_ptnl_ler_for_per

Line 981: raise hr_api.validate_enabled;

977: --
978: -- When in validation only mode raise the Validate_Enabled exception
979: --
980: if p_validate then
981: raise hr_api.validate_enabled;
982: end if;
983: --
984: -- Set all output arguments
985: --

Line 990: when hr_api.validate_enabled then

986: p_object_version_number := l_object_version_number;
987: --
988: exception
989: --
990: when hr_api.validate_enabled then
991: --
992: -- As the Validate_Enabled exception has been raised
993: -- we must rollback to the savepoint
994: --

Line 1056: when hr_api.cannot_find_prog_unit then

1052: ,p_effective_date => trunc(p_effective_date));
1053: --
1054: exception
1055: --
1056: when hr_api.cannot_find_prog_unit then
1057: --
1058: hr_api.cannot_find_prog_unit_error
1059: (p_module_name => 'DELETE_ptnl_ler_for_per'
1060: ,p_hook_type => 'BP');

Line 1058: hr_api.cannot_find_prog_unit_error

1054: exception
1055: --
1056: when hr_api.cannot_find_prog_unit then
1057: --
1058: hr_api.cannot_find_prog_unit_error
1059: (p_module_name => 'DELETE_ptnl_ler_for_per'
1060: ,p_hook_type => 'BP');
1061: --
1062: -- End of API User Hook for the before hook of delete_ptnl_ler_for_per

Line 1082: when hr_api.cannot_find_prog_unit then

1078: ,p_effective_date => trunc(p_effective_date));
1079: --
1080: exception
1081: --
1082: when hr_api.cannot_find_prog_unit then
1083: --
1084: hr_api.cannot_find_prog_unit_error
1085: (p_module_name => 'DELETE_ptnl_ler_for_per'
1086: ,p_hook_type => 'AP');

Line 1084: hr_api.cannot_find_prog_unit_error

1080: exception
1081: --
1082: when hr_api.cannot_find_prog_unit then
1083: --
1084: hr_api.cannot_find_prog_unit_error
1085: (p_module_name => 'DELETE_ptnl_ler_for_per'
1086: ,p_hook_type => 'AP');
1087: --
1088: -- End of API User Hook for the after hook of delete_ptnl_ler_for_per

Line 1099: raise hr_api.validate_enabled;

1095: --
1096: -- When in validation only mode raise the Validate_Enabled exception
1097: --
1098: if p_validate then
1099: raise hr_api.validate_enabled;
1100: end if;
1101: --
1102: if g_debug then
1103: hr_utility.set_location(' Leaving:'||l_proc, 70);

Line 1108: when hr_api.validate_enabled then

1104: end if;
1105: --
1106: exception
1107: --
1108: when hr_api.validate_enabled then
1109: --
1110: -- As the Validate_Enabled exception has been raised
1111: -- we must rollback to the savepoint
1112: --