APPS.BEN_PTNL_LER_FOR_PER_API dependencies on HR_API

Line 221: when hr_api.cannot_find_prog_unit then

217: );
218: --
219: exception
220: --
221: when hr_api.cannot_find_prog_unit then
222: --
223: hr_api.cannot_find_prog_unit_error
224: (p_module_name => 'CREATE_ptnl_ler_for_per'
225: ,p_hook_type => 'BP');

Line 223: hr_api.cannot_find_prog_unit_error

219: exception
220: --
221: when hr_api.cannot_find_prog_unit then
222: --
223: hr_api.cannot_find_prog_unit_error
224: (p_module_name => 'CREATE_ptnl_ler_for_per'
225: ,p_hook_type => 'BP');
226: --
227: -- End of API User Hook for the before hook of create_ptnl_ler_for_per

Line 288: when hr_api.cannot_find_prog_unit then

284: );
285: --
286: exception
287: --
288: when hr_api.cannot_find_prog_unit then
289: --
290: hr_api.cannot_find_prog_unit_error
291: (p_module_name => 'CREATE_ptnl_ler_for_per'
292: ,p_hook_type => 'AP');

Line 290: hr_api.cannot_find_prog_unit_error

286: exception
287: --
288: when hr_api.cannot_find_prog_unit then
289: --
290: hr_api.cannot_find_prog_unit_error
291: (p_module_name => 'CREATE_ptnl_ler_for_per'
292: ,p_hook_type => 'AP');
293: --
294: -- End of API User Hook for the after hook of create_ptnl_ler_for_per

Line 305: raise hr_api.validate_enabled;

301: --
302: -- When in validation only mode raise the Validate_Enabled exception
303: --
304: if p_validate then
305: raise hr_api.validate_enabled;
306: end if;
307: --
308: -- Set all output arguments
309: --

Line 321: when hr_api.validate_enabled then

317: end if;
318: --
319: exception
320: --
321: when hr_api.validate_enabled then
322: --
323: -- As the Validate_Enabled exception has been raised
324: -- we must rollback to the savepoint
325: --

Line 424: when hr_api.cannot_find_prog_unit then

420: ,p_effective_date => trunc(p_effective_date));
421: --
422: exception
423: --
424: when hr_api.cannot_find_prog_unit then
425: --
426: hr_api.cannot_find_prog_unit_error
427: (p_module_name => 'CREATE_ptnl_ler_for_per'
428: ,p_hook_type => 'BP');

Line 426: hr_api.cannot_find_prog_unit_error

422: exception
423: --
424: when hr_api.cannot_find_prog_unit then
425: --
426: hr_api.cannot_find_prog_unit_error
427: (p_module_name => 'CREATE_ptnl_ler_for_per'
428: ,p_hook_type => 'BP');
429: --
430: -- End of API User Hook for the before hook of create_ptnl_ler_for_per

Line 518: when hr_api.cannot_find_prog_unit then

514: ,p_effective_date => trunc(p_effective_date));
515: --
516: exception
517: --
518: when hr_api.cannot_find_prog_unit then
519: --
520: hr_api.cannot_find_prog_unit_error
521: (p_module_name => 'CREATE_ptnl_ler_for_per'
522: ,p_hook_type => 'AP');

Line 520: hr_api.cannot_find_prog_unit_error

516: exception
517: --
518: when hr_api.cannot_find_prog_unit then
519: --
520: hr_api.cannot_find_prog_unit_error
521: (p_module_name => 'CREATE_ptnl_ler_for_per'
522: ,p_hook_type => 'AP');
523: --
524: -- End of API User Hook for the after hook of create_ptnl_ler_for_per

Line 531: raise hr_api.validate_enabled;

527: --
528: -- When in validation only mode raise the Validate_Enabled exception
529: --
530: if p_validate then
531: raise hr_api.validate_enabled;
532: end if;
533: --
534: -- Set all output arguments
535: --

Line 541: when hr_api.validate_enabled then

537: p_object_version_number := l_object_version_number;
538: --
539: exception
540: --
541: when hr_api.validate_enabled then
542: --
543: -- As the Validate_Enabled exception has been raised
544: -- we must rollback to the savepoint
545: --

Line 573: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number

569: --
570: procedure update_ptnl_ler_for_per
571: (p_validate in boolean default false
572: ,p_ptnl_ler_for_per_id in number
573: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number
574: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
575: ,p_trgr_table_pk_id in number default hr_api.g_number
576: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
577: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2

Line 574: ,p_lf_evt_ocrd_dt in date default hr_api.g_date

570: procedure update_ptnl_ler_for_per
571: (p_validate in boolean default false
572: ,p_ptnl_ler_for_per_id in number
573: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number
574: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
575: ,p_trgr_table_pk_id in number default hr_api.g_number
576: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
577: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
578: ,p_mnl_dt in date default hr_api.g_date

Line 575: ,p_trgr_table_pk_id in number default hr_api.g_number

571: (p_validate in boolean default false
572: ,p_ptnl_ler_for_per_id in number
573: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number
574: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
575: ,p_trgr_table_pk_id in number default hr_api.g_number
576: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
577: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
578: ,p_mnl_dt in date default hr_api.g_date
579: ,p_enrt_perd_id in number default hr_api.g_number

Line 576: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2

572: ,p_ptnl_ler_for_per_id in number
573: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number
574: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
575: ,p_trgr_table_pk_id in number default hr_api.g_number
576: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
577: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
578: ,p_mnl_dt in date default hr_api.g_date
579: ,p_enrt_perd_id in number default hr_api.g_number
580: ,p_ler_id in number default hr_api.g_number

Line 577: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2

573: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number
574: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
575: ,p_trgr_table_pk_id in number default hr_api.g_number
576: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
577: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
578: ,p_mnl_dt in date default hr_api.g_date
579: ,p_enrt_perd_id in number default hr_api.g_number
580: ,p_ler_id in number default hr_api.g_number
581: ,p_person_id in number default hr_api.g_number

Line 578: ,p_mnl_dt in date default hr_api.g_date

574: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
575: ,p_trgr_table_pk_id in number default hr_api.g_number
576: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
577: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
578: ,p_mnl_dt in date default hr_api.g_date
579: ,p_enrt_perd_id in number default hr_api.g_number
580: ,p_ler_id in number default hr_api.g_number
581: ,p_person_id in number default hr_api.g_number
582: ,p_business_group_id in number default hr_api.g_number

Line 579: ,p_enrt_perd_id in number default hr_api.g_number

575: ,p_trgr_table_pk_id in number default hr_api.g_number
576: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
577: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
578: ,p_mnl_dt in date default hr_api.g_date
579: ,p_enrt_perd_id in number default hr_api.g_number
580: ,p_ler_id in number default hr_api.g_number
581: ,p_person_id in number default hr_api.g_number
582: ,p_business_group_id in number default hr_api.g_number
583: ,p_dtctd_dt in date default hr_api.g_date

Line 580: ,p_ler_id in number default hr_api.g_number

576: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
577: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
578: ,p_mnl_dt in date default hr_api.g_date
579: ,p_enrt_perd_id in number default hr_api.g_number
580: ,p_ler_id in number default hr_api.g_number
581: ,p_person_id in number default hr_api.g_number
582: ,p_business_group_id in number default hr_api.g_number
583: ,p_dtctd_dt in date default hr_api.g_date
584: ,p_procd_dt in date default hr_api.g_date

Line 581: ,p_person_id in number default hr_api.g_number

577: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
578: ,p_mnl_dt in date default hr_api.g_date
579: ,p_enrt_perd_id in number default hr_api.g_number
580: ,p_ler_id in number default hr_api.g_number
581: ,p_person_id in number default hr_api.g_number
582: ,p_business_group_id in number default hr_api.g_number
583: ,p_dtctd_dt in date default hr_api.g_date
584: ,p_procd_dt in date default hr_api.g_date
585: ,p_unprocd_dt in date default hr_api.g_date

Line 582: ,p_business_group_id in number default hr_api.g_number

578: ,p_mnl_dt in date default hr_api.g_date
579: ,p_enrt_perd_id in number default hr_api.g_number
580: ,p_ler_id in number default hr_api.g_number
581: ,p_person_id in number default hr_api.g_number
582: ,p_business_group_id in number default hr_api.g_number
583: ,p_dtctd_dt in date default hr_api.g_date
584: ,p_procd_dt in date default hr_api.g_date
585: ,p_unprocd_dt in date default hr_api.g_date
586: ,p_voidd_dt in date default hr_api.g_date

Line 583: ,p_dtctd_dt in date default hr_api.g_date

579: ,p_enrt_perd_id in number default hr_api.g_number
580: ,p_ler_id in number default hr_api.g_number
581: ,p_person_id in number default hr_api.g_number
582: ,p_business_group_id in number default hr_api.g_number
583: ,p_dtctd_dt in date default hr_api.g_date
584: ,p_procd_dt in date default hr_api.g_date
585: ,p_unprocd_dt in date default hr_api.g_date
586: ,p_voidd_dt in date default hr_api.g_date
587: ,p_mnlo_dt in date default hr_api.g_date

Line 584: ,p_procd_dt in date default hr_api.g_date

580: ,p_ler_id in number default hr_api.g_number
581: ,p_person_id in number default hr_api.g_number
582: ,p_business_group_id in number default hr_api.g_number
583: ,p_dtctd_dt in date default hr_api.g_date
584: ,p_procd_dt in date default hr_api.g_date
585: ,p_unprocd_dt in date default hr_api.g_date
586: ,p_voidd_dt in date default hr_api.g_date
587: ,p_mnlo_dt in date default hr_api.g_date
588: ,p_ntfn_dt in date default hr_api.g_date

Line 585: ,p_unprocd_dt in date default hr_api.g_date

581: ,p_person_id in number default hr_api.g_number
582: ,p_business_group_id in number default hr_api.g_number
583: ,p_dtctd_dt in date default hr_api.g_date
584: ,p_procd_dt in date default hr_api.g_date
585: ,p_unprocd_dt in date default hr_api.g_date
586: ,p_voidd_dt in date default hr_api.g_date
587: ,p_mnlo_dt in date default hr_api.g_date
588: ,p_ntfn_dt in date default hr_api.g_date
589: ,p_request_id in number default hr_api.g_number

Line 586: ,p_voidd_dt in date default hr_api.g_date

582: ,p_business_group_id in number default hr_api.g_number
583: ,p_dtctd_dt in date default hr_api.g_date
584: ,p_procd_dt in date default hr_api.g_date
585: ,p_unprocd_dt in date default hr_api.g_date
586: ,p_voidd_dt in date default hr_api.g_date
587: ,p_mnlo_dt in date default hr_api.g_date
588: ,p_ntfn_dt in date default hr_api.g_date
589: ,p_request_id in number default hr_api.g_number
590: ,p_program_application_id in number default hr_api.g_number

Line 587: ,p_mnlo_dt in date default hr_api.g_date

583: ,p_dtctd_dt in date default hr_api.g_date
584: ,p_procd_dt in date default hr_api.g_date
585: ,p_unprocd_dt in date default hr_api.g_date
586: ,p_voidd_dt in date default hr_api.g_date
587: ,p_mnlo_dt in date default hr_api.g_date
588: ,p_ntfn_dt in date default hr_api.g_date
589: ,p_request_id in number default hr_api.g_number
590: ,p_program_application_id in number default hr_api.g_number
591: ,p_program_id in number default hr_api.g_number

Line 588: ,p_ntfn_dt in date default hr_api.g_date

584: ,p_procd_dt in date default hr_api.g_date
585: ,p_unprocd_dt in date default hr_api.g_date
586: ,p_voidd_dt in date default hr_api.g_date
587: ,p_mnlo_dt in date default hr_api.g_date
588: ,p_ntfn_dt in date default hr_api.g_date
589: ,p_request_id in number default hr_api.g_number
590: ,p_program_application_id in number default hr_api.g_number
591: ,p_program_id in number default hr_api.g_number
592: ,p_program_update_date in date default hr_api.g_date

Line 589: ,p_request_id in number default hr_api.g_number

585: ,p_unprocd_dt in date default hr_api.g_date
586: ,p_voidd_dt in date default hr_api.g_date
587: ,p_mnlo_dt in date default hr_api.g_date
588: ,p_ntfn_dt in date default hr_api.g_date
589: ,p_request_id in number default hr_api.g_number
590: ,p_program_application_id in number default hr_api.g_number
591: ,p_program_id in number default hr_api.g_number
592: ,p_program_update_date in date default hr_api.g_date
593: ,p_object_version_number in out nocopy number

Line 590: ,p_program_application_id in number default hr_api.g_number

586: ,p_voidd_dt in date default hr_api.g_date
587: ,p_mnlo_dt in date default hr_api.g_date
588: ,p_ntfn_dt in date default hr_api.g_date
589: ,p_request_id in number default hr_api.g_number
590: ,p_program_application_id in number default hr_api.g_number
591: ,p_program_id in number default hr_api.g_number
592: ,p_program_update_date in date default hr_api.g_date
593: ,p_object_version_number in out nocopy number
594: ,p_effective_date in date) is

Line 591: ,p_program_id in number default hr_api.g_number

587: ,p_mnlo_dt in date default hr_api.g_date
588: ,p_ntfn_dt in date default hr_api.g_date
589: ,p_request_id in number default hr_api.g_number
590: ,p_program_application_id in number default hr_api.g_number
591: ,p_program_id in number default hr_api.g_number
592: ,p_program_update_date in date default hr_api.g_date
593: ,p_object_version_number in out nocopy number
594: ,p_effective_date in date) is
595: --

Line 592: ,p_program_update_date in date default hr_api.g_date

588: ,p_ntfn_dt in date default hr_api.g_date
589: ,p_request_id in number default hr_api.g_number
590: ,p_program_application_id in number default hr_api.g_number
591: ,p_program_id in number default hr_api.g_number
592: ,p_program_update_date in date default hr_api.g_date
593: ,p_object_version_number in out nocopy number
594: ,p_effective_date in date) is
595: --
596: -- Declare cursors and local variables

Line 652: when hr_api.cannot_find_prog_unit then

648: ,p_effective_date => trunc(p_effective_date));
649: --
650: exception
651: --
652: when hr_api.cannot_find_prog_unit then
653: --
654: hr_api.cannot_find_prog_unit_error
655: (p_module_name => 'UPDATE_ptnl_ler_for_per'
656: ,p_hook_type => 'BP');

Line 654: hr_api.cannot_find_prog_unit_error

650: exception
651: --
652: when hr_api.cannot_find_prog_unit then
653: --
654: hr_api.cannot_find_prog_unit_error
655: (p_module_name => 'UPDATE_ptnl_ler_for_per'
656: ,p_hook_type => 'BP');
657: --
658: -- End of API User Hook for the before hook of update_ptnl_ler_for_per

Line 718: when hr_api.cannot_find_prog_unit then

714: ,p_effective_date => trunc(p_effective_date));
715: --
716: exception
717: --
718: when hr_api.cannot_find_prog_unit then
719: --
720: hr_api.cannot_find_prog_unit_error
721: (p_module_name => 'UPDATE_ptnl_ler_for_per'
722: ,p_hook_type => 'AP');

Line 720: hr_api.cannot_find_prog_unit_error

716: exception
717: --
718: when hr_api.cannot_find_prog_unit then
719: --
720: hr_api.cannot_find_prog_unit_error
721: (p_module_name => 'UPDATE_ptnl_ler_for_per'
722: ,p_hook_type => 'AP');
723: --
724: -- End of API User Hook for the after hook of update_ptnl_ler_for_per

Line 735: raise hr_api.validate_enabled;

731: --
732: -- When in validation only mode raise the Validate_Enabled exception
733: --
734: if p_validate then
735: raise hr_api.validate_enabled;
736: end if;
737: --
738: -- Set all output arguments
739: --

Line 748: when hr_api.validate_enabled then

744: end if;
745: --
746: exception
747: --
748: when hr_api.validate_enabled then
749: --
750: -- As the Validate_Enabled exception has been raised
751: -- we must rollback to the savepoint
752: --

Line 779: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number

775: --
776: procedure update_ptnl_ler_for_per_perf
777: (p_validate in boolean default false
778: ,p_ptnl_ler_for_per_id in number
779: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number
780: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
781: ,p_trgr_table_pk_id in number default hr_api.g_number
782: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
783: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2

Line 780: ,p_lf_evt_ocrd_dt in date default hr_api.g_date

776: procedure update_ptnl_ler_for_per_perf
777: (p_validate in boolean default false
778: ,p_ptnl_ler_for_per_id in number
779: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number
780: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
781: ,p_trgr_table_pk_id in number default hr_api.g_number
782: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
783: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
784: ,p_mnl_dt in date default hr_api.g_date

Line 781: ,p_trgr_table_pk_id in number default hr_api.g_number

777: (p_validate in boolean default false
778: ,p_ptnl_ler_for_per_id in number
779: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number
780: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
781: ,p_trgr_table_pk_id in number default hr_api.g_number
782: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
783: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
784: ,p_mnl_dt in date default hr_api.g_date
785: ,p_enrt_perd_id in number default hr_api.g_number

Line 782: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2

778: ,p_ptnl_ler_for_per_id in number
779: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number
780: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
781: ,p_trgr_table_pk_id in number default hr_api.g_number
782: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
783: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
784: ,p_mnl_dt in date default hr_api.g_date
785: ,p_enrt_perd_id in number default hr_api.g_number
786: ,p_ler_id in number default hr_api.g_number

Line 783: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2

779: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number
780: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
781: ,p_trgr_table_pk_id in number default hr_api.g_number
782: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
783: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
784: ,p_mnl_dt in date default hr_api.g_date
785: ,p_enrt_perd_id in number default hr_api.g_number
786: ,p_ler_id in number default hr_api.g_number
787: ,p_person_id in number default hr_api.g_number

Line 784: ,p_mnl_dt in date default hr_api.g_date

780: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
781: ,p_trgr_table_pk_id in number default hr_api.g_number
782: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
783: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
784: ,p_mnl_dt in date default hr_api.g_date
785: ,p_enrt_perd_id in number default hr_api.g_number
786: ,p_ler_id in number default hr_api.g_number
787: ,p_person_id in number default hr_api.g_number
788: ,p_business_group_id in number default hr_api.g_number

Line 785: ,p_enrt_perd_id in number default hr_api.g_number

781: ,p_trgr_table_pk_id in number default hr_api.g_number
782: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
783: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
784: ,p_mnl_dt in date default hr_api.g_date
785: ,p_enrt_perd_id in number default hr_api.g_number
786: ,p_ler_id in number default hr_api.g_number
787: ,p_person_id in number default hr_api.g_number
788: ,p_business_group_id in number default hr_api.g_number
789: ,p_dtctd_dt in date default hr_api.g_date

Line 786: ,p_ler_id in number default hr_api.g_number

782: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
783: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
784: ,p_mnl_dt in date default hr_api.g_date
785: ,p_enrt_perd_id in number default hr_api.g_number
786: ,p_ler_id in number default hr_api.g_number
787: ,p_person_id in number default hr_api.g_number
788: ,p_business_group_id in number default hr_api.g_number
789: ,p_dtctd_dt in date default hr_api.g_date
790: ,p_procd_dt in date default hr_api.g_date

Line 787: ,p_person_id in number default hr_api.g_number

783: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
784: ,p_mnl_dt in date default hr_api.g_date
785: ,p_enrt_perd_id in number default hr_api.g_number
786: ,p_ler_id in number default hr_api.g_number
787: ,p_person_id in number default hr_api.g_number
788: ,p_business_group_id in number default hr_api.g_number
789: ,p_dtctd_dt in date default hr_api.g_date
790: ,p_procd_dt in date default hr_api.g_date
791: ,p_unprocd_dt in date default hr_api.g_date

Line 788: ,p_business_group_id in number default hr_api.g_number

784: ,p_mnl_dt in date default hr_api.g_date
785: ,p_enrt_perd_id in number default hr_api.g_number
786: ,p_ler_id in number default hr_api.g_number
787: ,p_person_id in number default hr_api.g_number
788: ,p_business_group_id in number default hr_api.g_number
789: ,p_dtctd_dt in date default hr_api.g_date
790: ,p_procd_dt in date default hr_api.g_date
791: ,p_unprocd_dt in date default hr_api.g_date
792: ,p_voidd_dt in date default hr_api.g_date

Line 789: ,p_dtctd_dt in date default hr_api.g_date

785: ,p_enrt_perd_id in number default hr_api.g_number
786: ,p_ler_id in number default hr_api.g_number
787: ,p_person_id in number default hr_api.g_number
788: ,p_business_group_id in number default hr_api.g_number
789: ,p_dtctd_dt in date default hr_api.g_date
790: ,p_procd_dt in date default hr_api.g_date
791: ,p_unprocd_dt in date default hr_api.g_date
792: ,p_voidd_dt in date default hr_api.g_date
793: ,p_mnlo_dt in date default hr_api.g_date

Line 790: ,p_procd_dt in date default hr_api.g_date

786: ,p_ler_id in number default hr_api.g_number
787: ,p_person_id in number default hr_api.g_number
788: ,p_business_group_id in number default hr_api.g_number
789: ,p_dtctd_dt in date default hr_api.g_date
790: ,p_procd_dt in date default hr_api.g_date
791: ,p_unprocd_dt in date default hr_api.g_date
792: ,p_voidd_dt in date default hr_api.g_date
793: ,p_mnlo_dt in date default hr_api.g_date
794: ,p_ntfn_dt in date default hr_api.g_date

Line 791: ,p_unprocd_dt in date default hr_api.g_date

787: ,p_person_id in number default hr_api.g_number
788: ,p_business_group_id in number default hr_api.g_number
789: ,p_dtctd_dt in date default hr_api.g_date
790: ,p_procd_dt in date default hr_api.g_date
791: ,p_unprocd_dt in date default hr_api.g_date
792: ,p_voidd_dt in date default hr_api.g_date
793: ,p_mnlo_dt in date default hr_api.g_date
794: ,p_ntfn_dt in date default hr_api.g_date
795: ,p_request_id in number default hr_api.g_number

Line 792: ,p_voidd_dt in date default hr_api.g_date

788: ,p_business_group_id in number default hr_api.g_number
789: ,p_dtctd_dt in date default hr_api.g_date
790: ,p_procd_dt in date default hr_api.g_date
791: ,p_unprocd_dt in date default hr_api.g_date
792: ,p_voidd_dt in date default hr_api.g_date
793: ,p_mnlo_dt in date default hr_api.g_date
794: ,p_ntfn_dt in date default hr_api.g_date
795: ,p_request_id in number default hr_api.g_number
796: ,p_program_application_id in number default hr_api.g_number

Line 793: ,p_mnlo_dt in date default hr_api.g_date

789: ,p_dtctd_dt in date default hr_api.g_date
790: ,p_procd_dt in date default hr_api.g_date
791: ,p_unprocd_dt in date default hr_api.g_date
792: ,p_voidd_dt in date default hr_api.g_date
793: ,p_mnlo_dt in date default hr_api.g_date
794: ,p_ntfn_dt in date default hr_api.g_date
795: ,p_request_id in number default hr_api.g_number
796: ,p_program_application_id in number default hr_api.g_number
797: ,p_program_id in number default hr_api.g_number

Line 794: ,p_ntfn_dt in date default hr_api.g_date

790: ,p_procd_dt in date default hr_api.g_date
791: ,p_unprocd_dt in date default hr_api.g_date
792: ,p_voidd_dt in date default hr_api.g_date
793: ,p_mnlo_dt in date default hr_api.g_date
794: ,p_ntfn_dt in date default hr_api.g_date
795: ,p_request_id in number default hr_api.g_number
796: ,p_program_application_id in number default hr_api.g_number
797: ,p_program_id in number default hr_api.g_number
798: ,p_program_update_date in date default hr_api.g_date

Line 795: ,p_request_id in number default hr_api.g_number

791: ,p_unprocd_dt in date default hr_api.g_date
792: ,p_voidd_dt in date default hr_api.g_date
793: ,p_mnlo_dt in date default hr_api.g_date
794: ,p_ntfn_dt in date default hr_api.g_date
795: ,p_request_id in number default hr_api.g_number
796: ,p_program_application_id in number default hr_api.g_number
797: ,p_program_id in number default hr_api.g_number
798: ,p_program_update_date in date default hr_api.g_date
799: ,p_object_version_number in out nocopy number

Line 796: ,p_program_application_id in number default hr_api.g_number

792: ,p_voidd_dt in date default hr_api.g_date
793: ,p_mnlo_dt in date default hr_api.g_date
794: ,p_ntfn_dt in date default hr_api.g_date
795: ,p_request_id in number default hr_api.g_number
796: ,p_program_application_id in number default hr_api.g_number
797: ,p_program_id in number default hr_api.g_number
798: ,p_program_update_date in date default hr_api.g_date
799: ,p_object_version_number in out nocopy number
800: ,p_effective_date in date) is

Line 797: ,p_program_id in number default hr_api.g_number

793: ,p_mnlo_dt in date default hr_api.g_date
794: ,p_ntfn_dt in date default hr_api.g_date
795: ,p_request_id in number default hr_api.g_number
796: ,p_program_application_id in number default hr_api.g_number
797: ,p_program_id in number default hr_api.g_number
798: ,p_program_update_date in date default hr_api.g_date
799: ,p_object_version_number in out nocopy number
800: ,p_effective_date in date) is
801: --

Line 798: ,p_program_update_date in date default hr_api.g_date

794: ,p_ntfn_dt in date default hr_api.g_date
795: ,p_request_id in number default hr_api.g_number
796: ,p_program_application_id in number default hr_api.g_number
797: ,p_program_id in number default hr_api.g_number
798: ,p_program_update_date in date default hr_api.g_date
799: ,p_object_version_number in out nocopy number
800: ,p_effective_date in date) is
801: --
802: -- Declare cursors and local variables

Line 872: when hr_api.cannot_find_prog_unit then

868: ,p_effective_date => trunc(p_effective_date));
869: --
870: exception
871: --
872: when hr_api.cannot_find_prog_unit then
873: --
874: hr_api.cannot_find_prog_unit_error
875: (p_module_name => 'UPDATE_ptnl_ler_for_per'
876: ,p_hook_type => 'BP');

Line 874: hr_api.cannot_find_prog_unit_error

870: exception
871: --
872: when hr_api.cannot_find_prog_unit then
873: --
874: hr_api.cannot_find_prog_unit_error
875: (p_module_name => 'UPDATE_ptnl_ler_for_per'
876: ,p_hook_type => 'BP');
877: --
878: -- End of API User Hook for the before hook of update_ptnl_ler_for_per

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

886: --
887: -- default variables for update
888: --
889: l_csd_by_ptnl_ler_for_per_id := p_csd_by_ptnl_ler_for_per_id;
890: If (l_csd_by_ptnl_ler_for_per_id = hr_api.g_number) then
891: l_csd_by_ptnl_ler_for_per_id :=
892: ben_ppl_shd.g_old_rec.csd_by_ptnl_ler_for_per_id;
893: End If;
894: l_lf_evt_ocrd_dt := trunc(p_lf_evt_ocrd_dt);

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

891: l_csd_by_ptnl_ler_for_per_id :=
892: ben_ppl_shd.g_old_rec.csd_by_ptnl_ler_for_per_id;
893: End If;
894: l_lf_evt_ocrd_dt := trunc(p_lf_evt_ocrd_dt);
895: If (p_lf_evt_ocrd_dt = hr_api.g_date) then
896: l_lf_evt_ocrd_dt :=
897: ben_ppl_shd.g_old_rec.lf_evt_ocrd_dt;
898: End If;
899: l_trgr_table_pk_id := p_trgr_table_pk_id;

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

896: l_lf_evt_ocrd_dt :=
897: ben_ppl_shd.g_old_rec.lf_evt_ocrd_dt;
898: End If;
899: l_trgr_table_pk_id := p_trgr_table_pk_id;
900: If (p_trgr_table_pk_id = hr_api.g_number) then
901: l_trgr_table_pk_id :=
902: ben_ppl_shd.g_old_rec.trgr_table_pk_id;
903: End If;
904: l_ptnl_ler_for_per_stat_cd := p_ptnl_ler_for_per_stat_cd;

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

901: l_trgr_table_pk_id :=
902: ben_ppl_shd.g_old_rec.trgr_table_pk_id;
903: End If;
904: l_ptnl_ler_for_per_stat_cd := p_ptnl_ler_for_per_stat_cd;
905: If (l_ptnl_ler_for_per_stat_cd = hr_api.g_varchar2) then
906: l_ptnl_ler_for_per_stat_cd :=
907: ben_ppl_shd.g_old_rec.ptnl_ler_for_per_stat_cd;
908: End If;
909: l_ptnl_ler_for_per_src_cd := p_ptnl_ler_for_per_src_cd;

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

906: l_ptnl_ler_for_per_stat_cd :=
907: ben_ppl_shd.g_old_rec.ptnl_ler_for_per_stat_cd;
908: End If;
909: l_ptnl_ler_for_per_src_cd := p_ptnl_ler_for_per_src_cd;
910: If (l_ptnl_ler_for_per_src_cd = hr_api.g_varchar2) then
911: l_ptnl_ler_for_per_src_cd :=
912: ben_ppl_shd.g_old_rec.ptnl_ler_for_per_src_cd;
913: End If;
914: l_enrt_perd_id := p_enrt_perd_id;

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

911: l_ptnl_ler_for_per_src_cd :=
912: ben_ppl_shd.g_old_rec.ptnl_ler_for_per_src_cd;
913: End If;
914: l_enrt_perd_id := p_enrt_perd_id;
915: If (l_enrt_perd_id = hr_api.g_number) then
916: l_enrt_perd_id :=
917: ben_ppl_shd.g_old_rec.enrt_perd_id;
918: End If;
919: l_ler_id := p_ler_id;

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

916: l_enrt_perd_id :=
917: ben_ppl_shd.g_old_rec.enrt_perd_id;
918: End If;
919: l_ler_id := p_ler_id;
920: If (l_ler_id = hr_api.g_number) then
921: l_ler_id :=
922: ben_ppl_shd.g_old_rec.ler_id;
923: End If;
924: l_ntfn_dt := trunc(p_ntfn_dt);

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

921: l_ler_id :=
922: ben_ppl_shd.g_old_rec.ler_id;
923: End If;
924: l_ntfn_dt := trunc(p_ntfn_dt);
925: If (l_ntfn_dt = hr_api.g_date) then
926: l_ntfn_dt :=
927: ben_ppl_shd.g_old_rec.ntfn_dt;
928: End If;
929: l_dtctd_dt := trunc(p_dtctd_dt);

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

926: l_ntfn_dt :=
927: ben_ppl_shd.g_old_rec.ntfn_dt;
928: End If;
929: l_dtctd_dt := trunc(p_dtctd_dt);
930: If (l_dtctd_dt = hr_api.g_date) then
931: l_dtctd_dt :=
932: ben_ppl_shd.g_old_rec.dtctd_dt;
933: End If;
934: l_procd_dt := trunc(p_procd_dt);

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

931: l_dtctd_dt :=
932: ben_ppl_shd.g_old_rec.dtctd_dt;
933: End If;
934: l_procd_dt := trunc(p_procd_dt);
935: If (l_procd_dt = hr_api.g_date) then
936: l_procd_dt :=
937: ben_ppl_shd.g_old_rec.procd_dt;
938: End If;
939: l_unprocd_dt := trunc(p_unprocd_dt);

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

936: l_procd_dt :=
937: ben_ppl_shd.g_old_rec.procd_dt;
938: End If;
939: l_unprocd_dt := trunc(p_unprocd_dt);
940: If (l_unprocd_dt = hr_api.g_date) then
941: l_unprocd_dt :=
942: ben_ppl_shd.g_old_rec.unprocd_dt;
943: End If;
944: l_voidd_dt := trunc(p_voidd_dt);

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

941: l_unprocd_dt :=
942: ben_ppl_shd.g_old_rec.unprocd_dt;
943: End If;
944: l_voidd_dt := trunc(p_voidd_dt);
945: If (l_voidd_dt = hr_api.g_date) then
946: l_voidd_dt :=
947: ben_ppl_shd.g_old_rec.voidd_dt;
948: End If;
949: l_mnlo_dt := trunc(p_mnlo_dt);

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

946: l_voidd_dt :=
947: ben_ppl_shd.g_old_rec.voidd_dt;
948: End If;
949: l_mnlo_dt := trunc(p_mnlo_dt);
950: If (l_mnlo_dt = hr_api.g_date) then
951: l_mnlo_dt :=
952: ben_ppl_shd.g_old_rec.mnlo_dt;
953: End If;
954: l_mnl_dt := trunc(p_mnl_dt);

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

951: l_mnlo_dt :=
952: ben_ppl_shd.g_old_rec.mnlo_dt;
953: End If;
954: l_mnl_dt := trunc(p_mnl_dt);
955: If (l_mnl_dt = hr_api.g_date) then
956: l_mnl_dt :=
957: ben_ppl_shd.g_old_rec.mnl_dt;
958: End If;
959: l_person_id := p_person_id;

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

956: l_mnl_dt :=
957: ben_ppl_shd.g_old_rec.mnl_dt;
958: End If;
959: l_person_id := p_person_id;
960: If (l_person_id = hr_api.g_number) then
961: l_person_id :=
962: ben_ppl_shd.g_old_rec.person_id;
963: End If;
964: l_business_group_id := p_business_group_id;

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

961: l_person_id :=
962: ben_ppl_shd.g_old_rec.person_id;
963: End If;
964: l_business_group_id := p_business_group_id;
965: If (l_business_group_id = hr_api.g_number) then
966: l_business_group_id :=
967: ben_ppl_shd.g_old_rec.business_group_id;
968: End If;
969: l_request_id := p_request_id;

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

966: l_business_group_id :=
967: ben_ppl_shd.g_old_rec.business_group_id;
968: End If;
969: l_request_id := p_request_id;
970: If (l_request_id = hr_api.g_number) then
971: l_request_id :=
972: ben_ppl_shd.g_old_rec.request_id;
973: End If;
974: l_program_application_id := p_program_application_id;

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

971: l_request_id :=
972: ben_ppl_shd.g_old_rec.request_id;
973: End If;
974: l_program_application_id := p_program_application_id;
975: If (l_program_application_id = hr_api.g_number) then
976: l_program_application_id :=
977: ben_ppl_shd.g_old_rec.program_application_id;
978: End If;
979: l_program_id := p_program_id;

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

976: l_program_application_id :=
977: ben_ppl_shd.g_old_rec.program_application_id;
978: End If;
979: l_program_id := p_program_id;
980: If (l_program_id = hr_api.g_number) then
981: l_program_id :=
982: ben_ppl_shd.g_old_rec.program_id;
983: End If;
984: l_program_update_date := trunc(p_program_update_date);

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

981: l_program_id :=
982: ben_ppl_shd.g_old_rec.program_id;
983: End If;
984: l_program_update_date := trunc(p_program_update_date);
985: If (l_program_update_date = hr_api.g_date) then
986: l_program_update_date :=
987: ben_ppl_shd.g_old_rec.program_update_date;
988: End If;
989: --

Line 1050: when hr_api.cannot_find_prog_unit then

1046: ,p_effective_date => trunc(p_effective_date));
1047: --
1048: exception
1049: --
1050: when hr_api.cannot_find_prog_unit then
1051: --
1052: hr_api.cannot_find_prog_unit_error
1053: (p_module_name => 'UPDATE_ptnl_ler_for_per'
1054: ,p_hook_type => 'AP');

Line 1052: hr_api.cannot_find_prog_unit_error

1048: exception
1049: --
1050: when hr_api.cannot_find_prog_unit then
1051: --
1052: hr_api.cannot_find_prog_unit_error
1053: (p_module_name => 'UPDATE_ptnl_ler_for_per'
1054: ,p_hook_type => 'AP');
1055: --
1056: -- End of API User Hook for the after hook of update_ptnl_ler_for_per

Line 1063: raise hr_api.validate_enabled;

1059: --
1060: -- When in validation only mode raise the Validate_Enabled exception
1061: --
1062: if p_validate then
1063: raise hr_api.validate_enabled;
1064: end if;
1065: --
1066: -- Set all output arguments
1067: --

Line 1072: when hr_api.validate_enabled then

1068: p_object_version_number := l_object_version_number;
1069: --
1070: exception
1071: --
1072: when hr_api.validate_enabled then
1073: --
1074: -- As the Validate_Enabled exception has been raised
1075: -- we must rollback to the savepoint
1076: --

Line 1138: when hr_api.cannot_find_prog_unit then

1134: ,p_effective_date => trunc(p_effective_date));
1135: --
1136: exception
1137: --
1138: when hr_api.cannot_find_prog_unit then
1139: --
1140: hr_api.cannot_find_prog_unit_error
1141: (p_module_name => 'DELETE_ptnl_ler_for_per'
1142: ,p_hook_type => 'BP');

Line 1140: hr_api.cannot_find_prog_unit_error

1136: exception
1137: --
1138: when hr_api.cannot_find_prog_unit then
1139: --
1140: hr_api.cannot_find_prog_unit_error
1141: (p_module_name => 'DELETE_ptnl_ler_for_per'
1142: ,p_hook_type => 'BP');
1143: --
1144: -- End of API User Hook for the before hook of delete_ptnl_ler_for_per

Line 1164: when hr_api.cannot_find_prog_unit then

1160: ,p_effective_date => trunc(p_effective_date));
1161: --
1162: exception
1163: --
1164: when hr_api.cannot_find_prog_unit then
1165: --
1166: hr_api.cannot_find_prog_unit_error
1167: (p_module_name => 'DELETE_ptnl_ler_for_per'
1168: ,p_hook_type => 'AP');

Line 1166: hr_api.cannot_find_prog_unit_error

1162: exception
1163: --
1164: when hr_api.cannot_find_prog_unit then
1165: --
1166: hr_api.cannot_find_prog_unit_error
1167: (p_module_name => 'DELETE_ptnl_ler_for_per'
1168: ,p_hook_type => 'AP');
1169: --
1170: -- End of API User Hook for the after hook of delete_ptnl_ler_for_per

Line 1181: raise hr_api.validate_enabled;

1177: --
1178: -- When in validation only mode raise the Validate_Enabled exception
1179: --
1180: if p_validate then
1181: raise hr_api.validate_enabled;
1182: end if;
1183: --
1184: if g_debug then
1185: hr_utility.set_location(' Leaving:'||l_proc, 70);

Line 1190: when hr_api.validate_enabled then

1186: end if;
1187: --
1188: exception
1189: --
1190: when hr_api.validate_enabled then
1191: --
1192: -- As the Validate_Enabled exception has been raised
1193: -- we must rollback to the savepoint
1194: --