eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_ELIG_DPNT_API dependencies on HR_API

Line 144: when hr_api.cannot_find_prog_unit then

140: ,p_program_update_date => p_program_update_date
141: ,p_effective_date => trunc(p_effective_date)
142: );
143: exception
144: when hr_api.cannot_find_prog_unit then
145: hr_api.cannot_find_prog_unit_error
146: (
147: p_module_name => 'CREATE_ELIG_DPNT'
148: ,p_hook_type => 'BP'

Line 145: hr_api.cannot_find_prog_unit_error

141: ,p_effective_date => trunc(p_effective_date)
142: );
143: exception
144: when hr_api.cannot_find_prog_unit then
145: hr_api.cannot_find_prog_unit_error
146: (
147: p_module_name => 'CREATE_ELIG_DPNT'
148: ,p_hook_type => 'BP'
149: );

Line 271: when hr_api.cannot_find_prog_unit then

267: ,p_object_version_number => l_object_version_number
268: ,p_effective_date => trunc(p_effective_date)
269: );
270: exception
271: when hr_api.cannot_find_prog_unit then
272: hr_api.cannot_find_prog_unit_error
273: (p_module_name => 'CREATE_ELIG_DPNT'
274: ,p_hook_type => 'AP'
275: );

Line 272: hr_api.cannot_find_prog_unit_error

268: ,p_effective_date => trunc(p_effective_date)
269: );
270: exception
271: when hr_api.cannot_find_prog_unit then
272: hr_api.cannot_find_prog_unit_error
273: (p_module_name => 'CREATE_ELIG_DPNT'
274: ,p_hook_type => 'AP'
275: );
276: --

Line 286: raise hr_api.validate_enabled;

282: --
283: -- When in validation only mode raise the Validate_Enabled exception
284: --
285: if p_validate then
286: raise hr_api.validate_enabled;
287: end if;
288: --
289: -- Set all output arguments
290: --

Line 298: when hr_api.validate_enabled then

294: hr_utility.set_location(' Leaving:'||l_proc, 70);
295: --
296: exception
297: --
298: when hr_api.validate_enabled then
299: --
300: -- As the Validate_Enabled exception has been raised
301: -- we must rollback to the savepoint
302: --

Line 553: raise hr_api.validate_enabled;

549: --
550: -- When in validation only mode raise the Validate_Enabled exception
551: --
552: if p_validate then
553: raise hr_api.validate_enabled;
554: end if;
555: --
556: -- Set all output arguments
557: --

Line 565: when hr_api.validate_enabled then

561: hr_utility.set_location(' Leaving:'||l_proc, 70);
562: --
563: exception
564: --
565: when hr_api.validate_enabled then
566: --
567: -- As the Validate_Enabled exception has been raised
568: -- we must rollback to the savepoint
569: --

Line 596: ,p_create_dt in date default hr_api.g_date

592: --
593: procedure update_ELIG_DPNT
594: (p_validate in boolean default false
595: ,p_elig_dpnt_id in number
596: ,p_create_dt in date default hr_api.g_date
597: ,p_elig_strt_dt in date default hr_api.g_date
598: ,p_elig_thru_dt in date default hr_api.g_date
599: ,p_ovrdn_flag in varchar2 default hr_api.g_varchar2
600: ,p_ovrdn_thru_dt in date default hr_api.g_date

Line 597: ,p_elig_strt_dt in date default hr_api.g_date

593: procedure update_ELIG_DPNT
594: (p_validate in boolean default false
595: ,p_elig_dpnt_id in number
596: ,p_create_dt in date default hr_api.g_date
597: ,p_elig_strt_dt in date default hr_api.g_date
598: ,p_elig_thru_dt in date default hr_api.g_date
599: ,p_ovrdn_flag in varchar2 default hr_api.g_varchar2
600: ,p_ovrdn_thru_dt in date default hr_api.g_date
601: ,p_inelg_rsn_cd in varchar2 default hr_api.g_varchar2

Line 598: ,p_elig_thru_dt in date default hr_api.g_date

594: (p_validate in boolean default false
595: ,p_elig_dpnt_id in number
596: ,p_create_dt in date default hr_api.g_date
597: ,p_elig_strt_dt in date default hr_api.g_date
598: ,p_elig_thru_dt in date default hr_api.g_date
599: ,p_ovrdn_flag in varchar2 default hr_api.g_varchar2
600: ,p_ovrdn_thru_dt in date default hr_api.g_date
601: ,p_inelg_rsn_cd in varchar2 default hr_api.g_varchar2
602: ,p_dpnt_inelig_flag in varchar2 default hr_api.g_varchar2

Line 599: ,p_ovrdn_flag in varchar2 default hr_api.g_varchar2

595: ,p_elig_dpnt_id in number
596: ,p_create_dt in date default hr_api.g_date
597: ,p_elig_strt_dt in date default hr_api.g_date
598: ,p_elig_thru_dt in date default hr_api.g_date
599: ,p_ovrdn_flag in varchar2 default hr_api.g_varchar2
600: ,p_ovrdn_thru_dt in date default hr_api.g_date
601: ,p_inelg_rsn_cd in varchar2 default hr_api.g_varchar2
602: ,p_dpnt_inelig_flag in varchar2 default hr_api.g_varchar2
603: ,p_elig_per_elctbl_chc_id in number default hr_api.g_number

Line 600: ,p_ovrdn_thru_dt in date default hr_api.g_date

596: ,p_create_dt in date default hr_api.g_date
597: ,p_elig_strt_dt in date default hr_api.g_date
598: ,p_elig_thru_dt in date default hr_api.g_date
599: ,p_ovrdn_flag in varchar2 default hr_api.g_varchar2
600: ,p_ovrdn_thru_dt in date default hr_api.g_date
601: ,p_inelg_rsn_cd in varchar2 default hr_api.g_varchar2
602: ,p_dpnt_inelig_flag in varchar2 default hr_api.g_varchar2
603: ,p_elig_per_elctbl_chc_id in number default hr_api.g_number
604: ,p_per_in_ler_id in number default hr_api.g_number

Line 601: ,p_inelg_rsn_cd in varchar2 default hr_api.g_varchar2

597: ,p_elig_strt_dt in date default hr_api.g_date
598: ,p_elig_thru_dt in date default hr_api.g_date
599: ,p_ovrdn_flag in varchar2 default hr_api.g_varchar2
600: ,p_ovrdn_thru_dt in date default hr_api.g_date
601: ,p_inelg_rsn_cd in varchar2 default hr_api.g_varchar2
602: ,p_dpnt_inelig_flag in varchar2 default hr_api.g_varchar2
603: ,p_elig_per_elctbl_chc_id in number default hr_api.g_number
604: ,p_per_in_ler_id in number default hr_api.g_number
605: ,p_elig_per_id in number default hr_api.g_number

Line 602: ,p_dpnt_inelig_flag in varchar2 default hr_api.g_varchar2

598: ,p_elig_thru_dt in date default hr_api.g_date
599: ,p_ovrdn_flag in varchar2 default hr_api.g_varchar2
600: ,p_ovrdn_thru_dt in date default hr_api.g_date
601: ,p_inelg_rsn_cd in varchar2 default hr_api.g_varchar2
602: ,p_dpnt_inelig_flag in varchar2 default hr_api.g_varchar2
603: ,p_elig_per_elctbl_chc_id in number default hr_api.g_number
604: ,p_per_in_ler_id in number default hr_api.g_number
605: ,p_elig_per_id in number default hr_api.g_number
606: ,p_elig_per_opt_id in number default hr_api.g_number

Line 603: ,p_elig_per_elctbl_chc_id in number default hr_api.g_number

599: ,p_ovrdn_flag in varchar2 default hr_api.g_varchar2
600: ,p_ovrdn_thru_dt in date default hr_api.g_date
601: ,p_inelg_rsn_cd in varchar2 default hr_api.g_varchar2
602: ,p_dpnt_inelig_flag in varchar2 default hr_api.g_varchar2
603: ,p_elig_per_elctbl_chc_id in number default hr_api.g_number
604: ,p_per_in_ler_id in number default hr_api.g_number
605: ,p_elig_per_id in number default hr_api.g_number
606: ,p_elig_per_opt_id in number default hr_api.g_number
607: ,p_elig_cvrd_dpnt_id in number default hr_api.g_number

Line 604: ,p_per_in_ler_id in number default hr_api.g_number

600: ,p_ovrdn_thru_dt in date default hr_api.g_date
601: ,p_inelg_rsn_cd in varchar2 default hr_api.g_varchar2
602: ,p_dpnt_inelig_flag in varchar2 default hr_api.g_varchar2
603: ,p_elig_per_elctbl_chc_id in number default hr_api.g_number
604: ,p_per_in_ler_id in number default hr_api.g_number
605: ,p_elig_per_id in number default hr_api.g_number
606: ,p_elig_per_opt_id in number default hr_api.g_number
607: ,p_elig_cvrd_dpnt_id in number default hr_api.g_number
608: ,p_dpnt_person_id in number default hr_api.g_number

Line 605: ,p_elig_per_id in number default hr_api.g_number

601: ,p_inelg_rsn_cd in varchar2 default hr_api.g_varchar2
602: ,p_dpnt_inelig_flag in varchar2 default hr_api.g_varchar2
603: ,p_elig_per_elctbl_chc_id in number default hr_api.g_number
604: ,p_per_in_ler_id in number default hr_api.g_number
605: ,p_elig_per_id in number default hr_api.g_number
606: ,p_elig_per_opt_id in number default hr_api.g_number
607: ,p_elig_cvrd_dpnt_id in number default hr_api.g_number
608: ,p_dpnt_person_id in number default hr_api.g_number
609: ,p_business_group_id in number default hr_api.g_number

Line 606: ,p_elig_per_opt_id in number default hr_api.g_number

602: ,p_dpnt_inelig_flag in varchar2 default hr_api.g_varchar2
603: ,p_elig_per_elctbl_chc_id in number default hr_api.g_number
604: ,p_per_in_ler_id in number default hr_api.g_number
605: ,p_elig_per_id in number default hr_api.g_number
606: ,p_elig_per_opt_id in number default hr_api.g_number
607: ,p_elig_cvrd_dpnt_id in number default hr_api.g_number
608: ,p_dpnt_person_id in number default hr_api.g_number
609: ,p_business_group_id in number default hr_api.g_number
610: ,p_egd_attribute_category in varchar2 default hr_api.g_varchar2

Line 607: ,p_elig_cvrd_dpnt_id in number default hr_api.g_number

603: ,p_elig_per_elctbl_chc_id in number default hr_api.g_number
604: ,p_per_in_ler_id in number default hr_api.g_number
605: ,p_elig_per_id in number default hr_api.g_number
606: ,p_elig_per_opt_id in number default hr_api.g_number
607: ,p_elig_cvrd_dpnt_id in number default hr_api.g_number
608: ,p_dpnt_person_id in number default hr_api.g_number
609: ,p_business_group_id in number default hr_api.g_number
610: ,p_egd_attribute_category in varchar2 default hr_api.g_varchar2
611: ,p_egd_attribute1 in varchar2 default hr_api.g_varchar2

Line 608: ,p_dpnt_person_id in number default hr_api.g_number

604: ,p_per_in_ler_id in number default hr_api.g_number
605: ,p_elig_per_id in number default hr_api.g_number
606: ,p_elig_per_opt_id in number default hr_api.g_number
607: ,p_elig_cvrd_dpnt_id in number default hr_api.g_number
608: ,p_dpnt_person_id in number default hr_api.g_number
609: ,p_business_group_id in number default hr_api.g_number
610: ,p_egd_attribute_category in varchar2 default hr_api.g_varchar2
611: ,p_egd_attribute1 in varchar2 default hr_api.g_varchar2
612: ,p_egd_attribute2 in varchar2 default hr_api.g_varchar2

Line 609: ,p_business_group_id in number default hr_api.g_number

605: ,p_elig_per_id in number default hr_api.g_number
606: ,p_elig_per_opt_id in number default hr_api.g_number
607: ,p_elig_cvrd_dpnt_id in number default hr_api.g_number
608: ,p_dpnt_person_id in number default hr_api.g_number
609: ,p_business_group_id in number default hr_api.g_number
610: ,p_egd_attribute_category in varchar2 default hr_api.g_varchar2
611: ,p_egd_attribute1 in varchar2 default hr_api.g_varchar2
612: ,p_egd_attribute2 in varchar2 default hr_api.g_varchar2
613: ,p_egd_attribute3 in varchar2 default hr_api.g_varchar2

Line 610: ,p_egd_attribute_category in varchar2 default hr_api.g_varchar2

606: ,p_elig_per_opt_id in number default hr_api.g_number
607: ,p_elig_cvrd_dpnt_id in number default hr_api.g_number
608: ,p_dpnt_person_id in number default hr_api.g_number
609: ,p_business_group_id in number default hr_api.g_number
610: ,p_egd_attribute_category in varchar2 default hr_api.g_varchar2
611: ,p_egd_attribute1 in varchar2 default hr_api.g_varchar2
612: ,p_egd_attribute2 in varchar2 default hr_api.g_varchar2
613: ,p_egd_attribute3 in varchar2 default hr_api.g_varchar2
614: ,p_egd_attribute4 in varchar2 default hr_api.g_varchar2

Line 611: ,p_egd_attribute1 in varchar2 default hr_api.g_varchar2

607: ,p_elig_cvrd_dpnt_id in number default hr_api.g_number
608: ,p_dpnt_person_id in number default hr_api.g_number
609: ,p_business_group_id in number default hr_api.g_number
610: ,p_egd_attribute_category in varchar2 default hr_api.g_varchar2
611: ,p_egd_attribute1 in varchar2 default hr_api.g_varchar2
612: ,p_egd_attribute2 in varchar2 default hr_api.g_varchar2
613: ,p_egd_attribute3 in varchar2 default hr_api.g_varchar2
614: ,p_egd_attribute4 in varchar2 default hr_api.g_varchar2
615: ,p_egd_attribute5 in varchar2 default hr_api.g_varchar2

Line 612: ,p_egd_attribute2 in varchar2 default hr_api.g_varchar2

608: ,p_dpnt_person_id in number default hr_api.g_number
609: ,p_business_group_id in number default hr_api.g_number
610: ,p_egd_attribute_category in varchar2 default hr_api.g_varchar2
611: ,p_egd_attribute1 in varchar2 default hr_api.g_varchar2
612: ,p_egd_attribute2 in varchar2 default hr_api.g_varchar2
613: ,p_egd_attribute3 in varchar2 default hr_api.g_varchar2
614: ,p_egd_attribute4 in varchar2 default hr_api.g_varchar2
615: ,p_egd_attribute5 in varchar2 default hr_api.g_varchar2
616: ,p_egd_attribute6 in varchar2 default hr_api.g_varchar2

Line 613: ,p_egd_attribute3 in varchar2 default hr_api.g_varchar2

609: ,p_business_group_id in number default hr_api.g_number
610: ,p_egd_attribute_category in varchar2 default hr_api.g_varchar2
611: ,p_egd_attribute1 in varchar2 default hr_api.g_varchar2
612: ,p_egd_attribute2 in varchar2 default hr_api.g_varchar2
613: ,p_egd_attribute3 in varchar2 default hr_api.g_varchar2
614: ,p_egd_attribute4 in varchar2 default hr_api.g_varchar2
615: ,p_egd_attribute5 in varchar2 default hr_api.g_varchar2
616: ,p_egd_attribute6 in varchar2 default hr_api.g_varchar2
617: ,p_egd_attribute7 in varchar2 default hr_api.g_varchar2

Line 614: ,p_egd_attribute4 in varchar2 default hr_api.g_varchar2

610: ,p_egd_attribute_category in varchar2 default hr_api.g_varchar2
611: ,p_egd_attribute1 in varchar2 default hr_api.g_varchar2
612: ,p_egd_attribute2 in varchar2 default hr_api.g_varchar2
613: ,p_egd_attribute3 in varchar2 default hr_api.g_varchar2
614: ,p_egd_attribute4 in varchar2 default hr_api.g_varchar2
615: ,p_egd_attribute5 in varchar2 default hr_api.g_varchar2
616: ,p_egd_attribute6 in varchar2 default hr_api.g_varchar2
617: ,p_egd_attribute7 in varchar2 default hr_api.g_varchar2
618: ,p_egd_attribute8 in varchar2 default hr_api.g_varchar2

Line 615: ,p_egd_attribute5 in varchar2 default hr_api.g_varchar2

611: ,p_egd_attribute1 in varchar2 default hr_api.g_varchar2
612: ,p_egd_attribute2 in varchar2 default hr_api.g_varchar2
613: ,p_egd_attribute3 in varchar2 default hr_api.g_varchar2
614: ,p_egd_attribute4 in varchar2 default hr_api.g_varchar2
615: ,p_egd_attribute5 in varchar2 default hr_api.g_varchar2
616: ,p_egd_attribute6 in varchar2 default hr_api.g_varchar2
617: ,p_egd_attribute7 in varchar2 default hr_api.g_varchar2
618: ,p_egd_attribute8 in varchar2 default hr_api.g_varchar2
619: ,p_egd_attribute9 in varchar2 default hr_api.g_varchar2

Line 616: ,p_egd_attribute6 in varchar2 default hr_api.g_varchar2

612: ,p_egd_attribute2 in varchar2 default hr_api.g_varchar2
613: ,p_egd_attribute3 in varchar2 default hr_api.g_varchar2
614: ,p_egd_attribute4 in varchar2 default hr_api.g_varchar2
615: ,p_egd_attribute5 in varchar2 default hr_api.g_varchar2
616: ,p_egd_attribute6 in varchar2 default hr_api.g_varchar2
617: ,p_egd_attribute7 in varchar2 default hr_api.g_varchar2
618: ,p_egd_attribute8 in varchar2 default hr_api.g_varchar2
619: ,p_egd_attribute9 in varchar2 default hr_api.g_varchar2
620: ,p_egd_attribute10 in varchar2 default hr_api.g_varchar2

Line 617: ,p_egd_attribute7 in varchar2 default hr_api.g_varchar2

613: ,p_egd_attribute3 in varchar2 default hr_api.g_varchar2
614: ,p_egd_attribute4 in varchar2 default hr_api.g_varchar2
615: ,p_egd_attribute5 in varchar2 default hr_api.g_varchar2
616: ,p_egd_attribute6 in varchar2 default hr_api.g_varchar2
617: ,p_egd_attribute7 in varchar2 default hr_api.g_varchar2
618: ,p_egd_attribute8 in varchar2 default hr_api.g_varchar2
619: ,p_egd_attribute9 in varchar2 default hr_api.g_varchar2
620: ,p_egd_attribute10 in varchar2 default hr_api.g_varchar2
621: ,p_egd_attribute11 in varchar2 default hr_api.g_varchar2

Line 618: ,p_egd_attribute8 in varchar2 default hr_api.g_varchar2

614: ,p_egd_attribute4 in varchar2 default hr_api.g_varchar2
615: ,p_egd_attribute5 in varchar2 default hr_api.g_varchar2
616: ,p_egd_attribute6 in varchar2 default hr_api.g_varchar2
617: ,p_egd_attribute7 in varchar2 default hr_api.g_varchar2
618: ,p_egd_attribute8 in varchar2 default hr_api.g_varchar2
619: ,p_egd_attribute9 in varchar2 default hr_api.g_varchar2
620: ,p_egd_attribute10 in varchar2 default hr_api.g_varchar2
621: ,p_egd_attribute11 in varchar2 default hr_api.g_varchar2
622: ,p_egd_attribute12 in varchar2 default hr_api.g_varchar2

Line 619: ,p_egd_attribute9 in varchar2 default hr_api.g_varchar2

615: ,p_egd_attribute5 in varchar2 default hr_api.g_varchar2
616: ,p_egd_attribute6 in varchar2 default hr_api.g_varchar2
617: ,p_egd_attribute7 in varchar2 default hr_api.g_varchar2
618: ,p_egd_attribute8 in varchar2 default hr_api.g_varchar2
619: ,p_egd_attribute9 in varchar2 default hr_api.g_varchar2
620: ,p_egd_attribute10 in varchar2 default hr_api.g_varchar2
621: ,p_egd_attribute11 in varchar2 default hr_api.g_varchar2
622: ,p_egd_attribute12 in varchar2 default hr_api.g_varchar2
623: ,p_egd_attribute13 in varchar2 default hr_api.g_varchar2

Line 620: ,p_egd_attribute10 in varchar2 default hr_api.g_varchar2

616: ,p_egd_attribute6 in varchar2 default hr_api.g_varchar2
617: ,p_egd_attribute7 in varchar2 default hr_api.g_varchar2
618: ,p_egd_attribute8 in varchar2 default hr_api.g_varchar2
619: ,p_egd_attribute9 in varchar2 default hr_api.g_varchar2
620: ,p_egd_attribute10 in varchar2 default hr_api.g_varchar2
621: ,p_egd_attribute11 in varchar2 default hr_api.g_varchar2
622: ,p_egd_attribute12 in varchar2 default hr_api.g_varchar2
623: ,p_egd_attribute13 in varchar2 default hr_api.g_varchar2
624: ,p_egd_attribute14 in varchar2 default hr_api.g_varchar2

Line 621: ,p_egd_attribute11 in varchar2 default hr_api.g_varchar2

617: ,p_egd_attribute7 in varchar2 default hr_api.g_varchar2
618: ,p_egd_attribute8 in varchar2 default hr_api.g_varchar2
619: ,p_egd_attribute9 in varchar2 default hr_api.g_varchar2
620: ,p_egd_attribute10 in varchar2 default hr_api.g_varchar2
621: ,p_egd_attribute11 in varchar2 default hr_api.g_varchar2
622: ,p_egd_attribute12 in varchar2 default hr_api.g_varchar2
623: ,p_egd_attribute13 in varchar2 default hr_api.g_varchar2
624: ,p_egd_attribute14 in varchar2 default hr_api.g_varchar2
625: ,p_egd_attribute15 in varchar2 default hr_api.g_varchar2

Line 622: ,p_egd_attribute12 in varchar2 default hr_api.g_varchar2

618: ,p_egd_attribute8 in varchar2 default hr_api.g_varchar2
619: ,p_egd_attribute9 in varchar2 default hr_api.g_varchar2
620: ,p_egd_attribute10 in varchar2 default hr_api.g_varchar2
621: ,p_egd_attribute11 in varchar2 default hr_api.g_varchar2
622: ,p_egd_attribute12 in varchar2 default hr_api.g_varchar2
623: ,p_egd_attribute13 in varchar2 default hr_api.g_varchar2
624: ,p_egd_attribute14 in varchar2 default hr_api.g_varchar2
625: ,p_egd_attribute15 in varchar2 default hr_api.g_varchar2
626: ,p_egd_attribute16 in varchar2 default hr_api.g_varchar2

Line 623: ,p_egd_attribute13 in varchar2 default hr_api.g_varchar2

619: ,p_egd_attribute9 in varchar2 default hr_api.g_varchar2
620: ,p_egd_attribute10 in varchar2 default hr_api.g_varchar2
621: ,p_egd_attribute11 in varchar2 default hr_api.g_varchar2
622: ,p_egd_attribute12 in varchar2 default hr_api.g_varchar2
623: ,p_egd_attribute13 in varchar2 default hr_api.g_varchar2
624: ,p_egd_attribute14 in varchar2 default hr_api.g_varchar2
625: ,p_egd_attribute15 in varchar2 default hr_api.g_varchar2
626: ,p_egd_attribute16 in varchar2 default hr_api.g_varchar2
627: ,p_egd_attribute17 in varchar2 default hr_api.g_varchar2

Line 624: ,p_egd_attribute14 in varchar2 default hr_api.g_varchar2

620: ,p_egd_attribute10 in varchar2 default hr_api.g_varchar2
621: ,p_egd_attribute11 in varchar2 default hr_api.g_varchar2
622: ,p_egd_attribute12 in varchar2 default hr_api.g_varchar2
623: ,p_egd_attribute13 in varchar2 default hr_api.g_varchar2
624: ,p_egd_attribute14 in varchar2 default hr_api.g_varchar2
625: ,p_egd_attribute15 in varchar2 default hr_api.g_varchar2
626: ,p_egd_attribute16 in varchar2 default hr_api.g_varchar2
627: ,p_egd_attribute17 in varchar2 default hr_api.g_varchar2
628: ,p_egd_attribute18 in varchar2 default hr_api.g_varchar2

Line 625: ,p_egd_attribute15 in varchar2 default hr_api.g_varchar2

621: ,p_egd_attribute11 in varchar2 default hr_api.g_varchar2
622: ,p_egd_attribute12 in varchar2 default hr_api.g_varchar2
623: ,p_egd_attribute13 in varchar2 default hr_api.g_varchar2
624: ,p_egd_attribute14 in varchar2 default hr_api.g_varchar2
625: ,p_egd_attribute15 in varchar2 default hr_api.g_varchar2
626: ,p_egd_attribute16 in varchar2 default hr_api.g_varchar2
627: ,p_egd_attribute17 in varchar2 default hr_api.g_varchar2
628: ,p_egd_attribute18 in varchar2 default hr_api.g_varchar2
629: ,p_egd_attribute19 in varchar2 default hr_api.g_varchar2

Line 626: ,p_egd_attribute16 in varchar2 default hr_api.g_varchar2

622: ,p_egd_attribute12 in varchar2 default hr_api.g_varchar2
623: ,p_egd_attribute13 in varchar2 default hr_api.g_varchar2
624: ,p_egd_attribute14 in varchar2 default hr_api.g_varchar2
625: ,p_egd_attribute15 in varchar2 default hr_api.g_varchar2
626: ,p_egd_attribute16 in varchar2 default hr_api.g_varchar2
627: ,p_egd_attribute17 in varchar2 default hr_api.g_varchar2
628: ,p_egd_attribute18 in varchar2 default hr_api.g_varchar2
629: ,p_egd_attribute19 in varchar2 default hr_api.g_varchar2
630: ,p_egd_attribute20 in varchar2 default hr_api.g_varchar2

Line 627: ,p_egd_attribute17 in varchar2 default hr_api.g_varchar2

623: ,p_egd_attribute13 in varchar2 default hr_api.g_varchar2
624: ,p_egd_attribute14 in varchar2 default hr_api.g_varchar2
625: ,p_egd_attribute15 in varchar2 default hr_api.g_varchar2
626: ,p_egd_attribute16 in varchar2 default hr_api.g_varchar2
627: ,p_egd_attribute17 in varchar2 default hr_api.g_varchar2
628: ,p_egd_attribute18 in varchar2 default hr_api.g_varchar2
629: ,p_egd_attribute19 in varchar2 default hr_api.g_varchar2
630: ,p_egd_attribute20 in varchar2 default hr_api.g_varchar2
631: ,p_egd_attribute21 in varchar2 default hr_api.g_varchar2

Line 628: ,p_egd_attribute18 in varchar2 default hr_api.g_varchar2

624: ,p_egd_attribute14 in varchar2 default hr_api.g_varchar2
625: ,p_egd_attribute15 in varchar2 default hr_api.g_varchar2
626: ,p_egd_attribute16 in varchar2 default hr_api.g_varchar2
627: ,p_egd_attribute17 in varchar2 default hr_api.g_varchar2
628: ,p_egd_attribute18 in varchar2 default hr_api.g_varchar2
629: ,p_egd_attribute19 in varchar2 default hr_api.g_varchar2
630: ,p_egd_attribute20 in varchar2 default hr_api.g_varchar2
631: ,p_egd_attribute21 in varchar2 default hr_api.g_varchar2
632: ,p_egd_attribute22 in varchar2 default hr_api.g_varchar2

Line 629: ,p_egd_attribute19 in varchar2 default hr_api.g_varchar2

625: ,p_egd_attribute15 in varchar2 default hr_api.g_varchar2
626: ,p_egd_attribute16 in varchar2 default hr_api.g_varchar2
627: ,p_egd_attribute17 in varchar2 default hr_api.g_varchar2
628: ,p_egd_attribute18 in varchar2 default hr_api.g_varchar2
629: ,p_egd_attribute19 in varchar2 default hr_api.g_varchar2
630: ,p_egd_attribute20 in varchar2 default hr_api.g_varchar2
631: ,p_egd_attribute21 in varchar2 default hr_api.g_varchar2
632: ,p_egd_attribute22 in varchar2 default hr_api.g_varchar2
633: ,p_egd_attribute23 in varchar2 default hr_api.g_varchar2

Line 630: ,p_egd_attribute20 in varchar2 default hr_api.g_varchar2

626: ,p_egd_attribute16 in varchar2 default hr_api.g_varchar2
627: ,p_egd_attribute17 in varchar2 default hr_api.g_varchar2
628: ,p_egd_attribute18 in varchar2 default hr_api.g_varchar2
629: ,p_egd_attribute19 in varchar2 default hr_api.g_varchar2
630: ,p_egd_attribute20 in varchar2 default hr_api.g_varchar2
631: ,p_egd_attribute21 in varchar2 default hr_api.g_varchar2
632: ,p_egd_attribute22 in varchar2 default hr_api.g_varchar2
633: ,p_egd_attribute23 in varchar2 default hr_api.g_varchar2
634: ,p_egd_attribute24 in varchar2 default hr_api.g_varchar2

Line 631: ,p_egd_attribute21 in varchar2 default hr_api.g_varchar2

627: ,p_egd_attribute17 in varchar2 default hr_api.g_varchar2
628: ,p_egd_attribute18 in varchar2 default hr_api.g_varchar2
629: ,p_egd_attribute19 in varchar2 default hr_api.g_varchar2
630: ,p_egd_attribute20 in varchar2 default hr_api.g_varchar2
631: ,p_egd_attribute21 in varchar2 default hr_api.g_varchar2
632: ,p_egd_attribute22 in varchar2 default hr_api.g_varchar2
633: ,p_egd_attribute23 in varchar2 default hr_api.g_varchar2
634: ,p_egd_attribute24 in varchar2 default hr_api.g_varchar2
635: ,p_egd_attribute25 in varchar2 default hr_api.g_varchar2

Line 632: ,p_egd_attribute22 in varchar2 default hr_api.g_varchar2

628: ,p_egd_attribute18 in varchar2 default hr_api.g_varchar2
629: ,p_egd_attribute19 in varchar2 default hr_api.g_varchar2
630: ,p_egd_attribute20 in varchar2 default hr_api.g_varchar2
631: ,p_egd_attribute21 in varchar2 default hr_api.g_varchar2
632: ,p_egd_attribute22 in varchar2 default hr_api.g_varchar2
633: ,p_egd_attribute23 in varchar2 default hr_api.g_varchar2
634: ,p_egd_attribute24 in varchar2 default hr_api.g_varchar2
635: ,p_egd_attribute25 in varchar2 default hr_api.g_varchar2
636: ,p_egd_attribute26 in varchar2 default hr_api.g_varchar2

Line 633: ,p_egd_attribute23 in varchar2 default hr_api.g_varchar2

629: ,p_egd_attribute19 in varchar2 default hr_api.g_varchar2
630: ,p_egd_attribute20 in varchar2 default hr_api.g_varchar2
631: ,p_egd_attribute21 in varchar2 default hr_api.g_varchar2
632: ,p_egd_attribute22 in varchar2 default hr_api.g_varchar2
633: ,p_egd_attribute23 in varchar2 default hr_api.g_varchar2
634: ,p_egd_attribute24 in varchar2 default hr_api.g_varchar2
635: ,p_egd_attribute25 in varchar2 default hr_api.g_varchar2
636: ,p_egd_attribute26 in varchar2 default hr_api.g_varchar2
637: ,p_egd_attribute27 in varchar2 default hr_api.g_varchar2

Line 634: ,p_egd_attribute24 in varchar2 default hr_api.g_varchar2

630: ,p_egd_attribute20 in varchar2 default hr_api.g_varchar2
631: ,p_egd_attribute21 in varchar2 default hr_api.g_varchar2
632: ,p_egd_attribute22 in varchar2 default hr_api.g_varchar2
633: ,p_egd_attribute23 in varchar2 default hr_api.g_varchar2
634: ,p_egd_attribute24 in varchar2 default hr_api.g_varchar2
635: ,p_egd_attribute25 in varchar2 default hr_api.g_varchar2
636: ,p_egd_attribute26 in varchar2 default hr_api.g_varchar2
637: ,p_egd_attribute27 in varchar2 default hr_api.g_varchar2
638: ,p_egd_attribute28 in varchar2 default hr_api.g_varchar2

Line 635: ,p_egd_attribute25 in varchar2 default hr_api.g_varchar2

631: ,p_egd_attribute21 in varchar2 default hr_api.g_varchar2
632: ,p_egd_attribute22 in varchar2 default hr_api.g_varchar2
633: ,p_egd_attribute23 in varchar2 default hr_api.g_varchar2
634: ,p_egd_attribute24 in varchar2 default hr_api.g_varchar2
635: ,p_egd_attribute25 in varchar2 default hr_api.g_varchar2
636: ,p_egd_attribute26 in varchar2 default hr_api.g_varchar2
637: ,p_egd_attribute27 in varchar2 default hr_api.g_varchar2
638: ,p_egd_attribute28 in varchar2 default hr_api.g_varchar2
639: ,p_egd_attribute29 in varchar2 default hr_api.g_varchar2

Line 636: ,p_egd_attribute26 in varchar2 default hr_api.g_varchar2

632: ,p_egd_attribute22 in varchar2 default hr_api.g_varchar2
633: ,p_egd_attribute23 in varchar2 default hr_api.g_varchar2
634: ,p_egd_attribute24 in varchar2 default hr_api.g_varchar2
635: ,p_egd_attribute25 in varchar2 default hr_api.g_varchar2
636: ,p_egd_attribute26 in varchar2 default hr_api.g_varchar2
637: ,p_egd_attribute27 in varchar2 default hr_api.g_varchar2
638: ,p_egd_attribute28 in varchar2 default hr_api.g_varchar2
639: ,p_egd_attribute29 in varchar2 default hr_api.g_varchar2
640: ,p_egd_attribute30 in varchar2 default hr_api.g_varchar2

Line 637: ,p_egd_attribute27 in varchar2 default hr_api.g_varchar2

633: ,p_egd_attribute23 in varchar2 default hr_api.g_varchar2
634: ,p_egd_attribute24 in varchar2 default hr_api.g_varchar2
635: ,p_egd_attribute25 in varchar2 default hr_api.g_varchar2
636: ,p_egd_attribute26 in varchar2 default hr_api.g_varchar2
637: ,p_egd_attribute27 in varchar2 default hr_api.g_varchar2
638: ,p_egd_attribute28 in varchar2 default hr_api.g_varchar2
639: ,p_egd_attribute29 in varchar2 default hr_api.g_varchar2
640: ,p_egd_attribute30 in varchar2 default hr_api.g_varchar2
641: ,p_request_id in number default hr_api.g_number

Line 638: ,p_egd_attribute28 in varchar2 default hr_api.g_varchar2

634: ,p_egd_attribute24 in varchar2 default hr_api.g_varchar2
635: ,p_egd_attribute25 in varchar2 default hr_api.g_varchar2
636: ,p_egd_attribute26 in varchar2 default hr_api.g_varchar2
637: ,p_egd_attribute27 in varchar2 default hr_api.g_varchar2
638: ,p_egd_attribute28 in varchar2 default hr_api.g_varchar2
639: ,p_egd_attribute29 in varchar2 default hr_api.g_varchar2
640: ,p_egd_attribute30 in varchar2 default hr_api.g_varchar2
641: ,p_request_id in number default hr_api.g_number
642: ,p_program_application_id in number default hr_api.g_number

Line 639: ,p_egd_attribute29 in varchar2 default hr_api.g_varchar2

635: ,p_egd_attribute25 in varchar2 default hr_api.g_varchar2
636: ,p_egd_attribute26 in varchar2 default hr_api.g_varchar2
637: ,p_egd_attribute27 in varchar2 default hr_api.g_varchar2
638: ,p_egd_attribute28 in varchar2 default hr_api.g_varchar2
639: ,p_egd_attribute29 in varchar2 default hr_api.g_varchar2
640: ,p_egd_attribute30 in varchar2 default hr_api.g_varchar2
641: ,p_request_id in number default hr_api.g_number
642: ,p_program_application_id in number default hr_api.g_number
643: ,p_program_id in number default hr_api.g_number

Line 640: ,p_egd_attribute30 in varchar2 default hr_api.g_varchar2

636: ,p_egd_attribute26 in varchar2 default hr_api.g_varchar2
637: ,p_egd_attribute27 in varchar2 default hr_api.g_varchar2
638: ,p_egd_attribute28 in varchar2 default hr_api.g_varchar2
639: ,p_egd_attribute29 in varchar2 default hr_api.g_varchar2
640: ,p_egd_attribute30 in varchar2 default hr_api.g_varchar2
641: ,p_request_id in number default hr_api.g_number
642: ,p_program_application_id in number default hr_api.g_number
643: ,p_program_id in number default hr_api.g_number
644: ,p_program_update_date in date default hr_api.g_date

Line 641: ,p_request_id in number default hr_api.g_number

637: ,p_egd_attribute27 in varchar2 default hr_api.g_varchar2
638: ,p_egd_attribute28 in varchar2 default hr_api.g_varchar2
639: ,p_egd_attribute29 in varchar2 default hr_api.g_varchar2
640: ,p_egd_attribute30 in varchar2 default hr_api.g_varchar2
641: ,p_request_id in number default hr_api.g_number
642: ,p_program_application_id in number default hr_api.g_number
643: ,p_program_id in number default hr_api.g_number
644: ,p_program_update_date in date default hr_api.g_date
645: ,p_object_version_number in out nocopy number

Line 642: ,p_program_application_id in number default hr_api.g_number

638: ,p_egd_attribute28 in varchar2 default hr_api.g_varchar2
639: ,p_egd_attribute29 in varchar2 default hr_api.g_varchar2
640: ,p_egd_attribute30 in varchar2 default hr_api.g_varchar2
641: ,p_request_id in number default hr_api.g_number
642: ,p_program_application_id in number default hr_api.g_number
643: ,p_program_id in number default hr_api.g_number
644: ,p_program_update_date in date default hr_api.g_date
645: ,p_object_version_number in out nocopy number
646: ,p_effective_date in date

Line 643: ,p_program_id in number default hr_api.g_number

639: ,p_egd_attribute29 in varchar2 default hr_api.g_varchar2
640: ,p_egd_attribute30 in varchar2 default hr_api.g_varchar2
641: ,p_request_id in number default hr_api.g_number
642: ,p_program_application_id in number default hr_api.g_number
643: ,p_program_id in number default hr_api.g_number
644: ,p_program_update_date in date default hr_api.g_date
645: ,p_object_version_number in out nocopy number
646: ,p_effective_date in date
647: ) is

Line 644: ,p_program_update_date in date default hr_api.g_date

640: ,p_egd_attribute30 in varchar2 default hr_api.g_varchar2
641: ,p_request_id in number default hr_api.g_number
642: ,p_program_application_id in number default hr_api.g_number
643: ,p_program_id in number default hr_api.g_number
644: ,p_program_update_date in date default hr_api.g_date
645: ,p_object_version_number in out nocopy number
646: ,p_effective_date in date
647: ) is
648: --

Line 728: when hr_api.cannot_find_prog_unit then

724: ,p_object_version_number => p_object_version_number
725: ,p_effective_date => trunc(p_effective_date)
726: );
727: exception
728: when hr_api.cannot_find_prog_unit then
729: hr_api.cannot_find_prog_unit_error
730: (p_module_name => 'UPDATE_ELIG_DPNT'
731: ,p_hook_type => 'BP'
732: );

Line 729: hr_api.cannot_find_prog_unit_error

725: ,p_effective_date => trunc(p_effective_date)
726: );
727: exception
728: when hr_api.cannot_find_prog_unit then
729: hr_api.cannot_find_prog_unit_error
730: (p_module_name => 'UPDATE_ELIG_DPNT'
731: ,p_hook_type => 'BP'
732: );
733: --

Line 854: when hr_api.cannot_find_prog_unit then

850: ,p_object_version_number => l_object_version_number
851: ,p_effective_date => trunc(p_effective_date)
852: );
853: exception
854: when hr_api.cannot_find_prog_unit then
855: hr_api.cannot_find_prog_unit_error
856: (p_module_name => 'UPDATE_ELIG_DPNT'
857: ,p_hook_type => 'AP'
858: );

Line 855: hr_api.cannot_find_prog_unit_error

851: ,p_effective_date => trunc(p_effective_date)
852: );
853: exception
854: when hr_api.cannot_find_prog_unit then
855: hr_api.cannot_find_prog_unit_error
856: (p_module_name => 'UPDATE_ELIG_DPNT'
857: ,p_hook_type => 'AP'
858: );
859: --

Line 869: raise hr_api.validate_enabled;

865: --
866: -- When in validation only mode raise the Validate_Enabled exception
867: --
868: if p_validate then
869: raise hr_api.validate_enabled;
870: end if;
871: --
872: -- Set all output arguments
873: --

Line 880: when hr_api.validate_enabled then

876: hr_utility.set_location(' Leaving:'||l_proc, 70);
877: --
878: exception
879: --
880: when hr_api.validate_enabled then
881: --
882: -- As the Validate_Enabled exception has been raised
883: -- we must rollback to the savepoint
884: --

Line 912: ,p_create_dt in date default hr_api.g_date

908: procedure update_perf_ELIG_DPNT
909: (
910: p_validate in boolean default false
911: ,p_elig_dpnt_id in number
912: ,p_create_dt in date default hr_api.g_date
913: ,p_elig_strt_dt in date default hr_api.g_date
914: ,p_elig_thru_dt in date default hr_api.g_date
915: ,p_ovrdn_flag in varchar2 default hr_api.g_varchar2
916: ,p_ovrdn_thru_dt in date default hr_api.g_date

Line 913: ,p_elig_strt_dt in date default hr_api.g_date

909: (
910: p_validate in boolean default false
911: ,p_elig_dpnt_id in number
912: ,p_create_dt in date default hr_api.g_date
913: ,p_elig_strt_dt in date default hr_api.g_date
914: ,p_elig_thru_dt in date default hr_api.g_date
915: ,p_ovrdn_flag in varchar2 default hr_api.g_varchar2
916: ,p_ovrdn_thru_dt in date default hr_api.g_date
917: ,p_inelg_rsn_cd in varchar2 default hr_api.g_varchar2

Line 914: ,p_elig_thru_dt in date default hr_api.g_date

910: p_validate in boolean default false
911: ,p_elig_dpnt_id in number
912: ,p_create_dt in date default hr_api.g_date
913: ,p_elig_strt_dt in date default hr_api.g_date
914: ,p_elig_thru_dt in date default hr_api.g_date
915: ,p_ovrdn_flag in varchar2 default hr_api.g_varchar2
916: ,p_ovrdn_thru_dt in date default hr_api.g_date
917: ,p_inelg_rsn_cd in varchar2 default hr_api.g_varchar2
918: ,p_dpnt_inelig_flag in varchar2 default hr_api.g_varchar2

Line 915: ,p_ovrdn_flag in varchar2 default hr_api.g_varchar2

911: ,p_elig_dpnt_id in number
912: ,p_create_dt in date default hr_api.g_date
913: ,p_elig_strt_dt in date default hr_api.g_date
914: ,p_elig_thru_dt in date default hr_api.g_date
915: ,p_ovrdn_flag in varchar2 default hr_api.g_varchar2
916: ,p_ovrdn_thru_dt in date default hr_api.g_date
917: ,p_inelg_rsn_cd in varchar2 default hr_api.g_varchar2
918: ,p_dpnt_inelig_flag in varchar2 default hr_api.g_varchar2
919: ,p_elig_per_elctbl_chc_id in number default hr_api.g_number

Line 916: ,p_ovrdn_thru_dt in date default hr_api.g_date

912: ,p_create_dt in date default hr_api.g_date
913: ,p_elig_strt_dt in date default hr_api.g_date
914: ,p_elig_thru_dt in date default hr_api.g_date
915: ,p_ovrdn_flag in varchar2 default hr_api.g_varchar2
916: ,p_ovrdn_thru_dt in date default hr_api.g_date
917: ,p_inelg_rsn_cd in varchar2 default hr_api.g_varchar2
918: ,p_dpnt_inelig_flag in varchar2 default hr_api.g_varchar2
919: ,p_elig_per_elctbl_chc_id in number default hr_api.g_number
920: ,p_per_in_ler_id in number default hr_api.g_number

Line 917: ,p_inelg_rsn_cd in varchar2 default hr_api.g_varchar2

913: ,p_elig_strt_dt in date default hr_api.g_date
914: ,p_elig_thru_dt in date default hr_api.g_date
915: ,p_ovrdn_flag in varchar2 default hr_api.g_varchar2
916: ,p_ovrdn_thru_dt in date default hr_api.g_date
917: ,p_inelg_rsn_cd in varchar2 default hr_api.g_varchar2
918: ,p_dpnt_inelig_flag in varchar2 default hr_api.g_varchar2
919: ,p_elig_per_elctbl_chc_id in number default hr_api.g_number
920: ,p_per_in_ler_id in number default hr_api.g_number
921: ,p_elig_per_id in number default hr_api.g_number

Line 918: ,p_dpnt_inelig_flag in varchar2 default hr_api.g_varchar2

914: ,p_elig_thru_dt in date default hr_api.g_date
915: ,p_ovrdn_flag in varchar2 default hr_api.g_varchar2
916: ,p_ovrdn_thru_dt in date default hr_api.g_date
917: ,p_inelg_rsn_cd in varchar2 default hr_api.g_varchar2
918: ,p_dpnt_inelig_flag in varchar2 default hr_api.g_varchar2
919: ,p_elig_per_elctbl_chc_id in number default hr_api.g_number
920: ,p_per_in_ler_id in number default hr_api.g_number
921: ,p_elig_per_id in number default hr_api.g_number
922: ,p_elig_per_opt_id in number default hr_api.g_number

Line 919: ,p_elig_per_elctbl_chc_id in number default hr_api.g_number

915: ,p_ovrdn_flag in varchar2 default hr_api.g_varchar2
916: ,p_ovrdn_thru_dt in date default hr_api.g_date
917: ,p_inelg_rsn_cd in varchar2 default hr_api.g_varchar2
918: ,p_dpnt_inelig_flag in varchar2 default hr_api.g_varchar2
919: ,p_elig_per_elctbl_chc_id in number default hr_api.g_number
920: ,p_per_in_ler_id in number default hr_api.g_number
921: ,p_elig_per_id in number default hr_api.g_number
922: ,p_elig_per_opt_id in number default hr_api.g_number
923: ,p_elig_cvrd_dpnt_id in number default hr_api.g_number

Line 920: ,p_per_in_ler_id in number default hr_api.g_number

916: ,p_ovrdn_thru_dt in date default hr_api.g_date
917: ,p_inelg_rsn_cd in varchar2 default hr_api.g_varchar2
918: ,p_dpnt_inelig_flag in varchar2 default hr_api.g_varchar2
919: ,p_elig_per_elctbl_chc_id in number default hr_api.g_number
920: ,p_per_in_ler_id in number default hr_api.g_number
921: ,p_elig_per_id in number default hr_api.g_number
922: ,p_elig_per_opt_id in number default hr_api.g_number
923: ,p_elig_cvrd_dpnt_id in number default hr_api.g_number
924: ,p_dpnt_person_id in number default hr_api.g_number

Line 921: ,p_elig_per_id in number default hr_api.g_number

917: ,p_inelg_rsn_cd in varchar2 default hr_api.g_varchar2
918: ,p_dpnt_inelig_flag in varchar2 default hr_api.g_varchar2
919: ,p_elig_per_elctbl_chc_id in number default hr_api.g_number
920: ,p_per_in_ler_id in number default hr_api.g_number
921: ,p_elig_per_id in number default hr_api.g_number
922: ,p_elig_per_opt_id in number default hr_api.g_number
923: ,p_elig_cvrd_dpnt_id in number default hr_api.g_number
924: ,p_dpnt_person_id in number default hr_api.g_number
925: ,p_business_group_id in number default hr_api.g_number

Line 922: ,p_elig_per_opt_id in number default hr_api.g_number

918: ,p_dpnt_inelig_flag in varchar2 default hr_api.g_varchar2
919: ,p_elig_per_elctbl_chc_id in number default hr_api.g_number
920: ,p_per_in_ler_id in number default hr_api.g_number
921: ,p_elig_per_id in number default hr_api.g_number
922: ,p_elig_per_opt_id in number default hr_api.g_number
923: ,p_elig_cvrd_dpnt_id in number default hr_api.g_number
924: ,p_dpnt_person_id in number default hr_api.g_number
925: ,p_business_group_id in number default hr_api.g_number
926: ,p_egd_attribute_category in varchar2 default hr_api.g_varchar2

Line 923: ,p_elig_cvrd_dpnt_id in number default hr_api.g_number

919: ,p_elig_per_elctbl_chc_id in number default hr_api.g_number
920: ,p_per_in_ler_id in number default hr_api.g_number
921: ,p_elig_per_id in number default hr_api.g_number
922: ,p_elig_per_opt_id in number default hr_api.g_number
923: ,p_elig_cvrd_dpnt_id in number default hr_api.g_number
924: ,p_dpnt_person_id in number default hr_api.g_number
925: ,p_business_group_id in number default hr_api.g_number
926: ,p_egd_attribute_category in varchar2 default hr_api.g_varchar2
927: ,p_egd_attribute1 in varchar2 default hr_api.g_varchar2

Line 924: ,p_dpnt_person_id in number default hr_api.g_number

920: ,p_per_in_ler_id in number default hr_api.g_number
921: ,p_elig_per_id in number default hr_api.g_number
922: ,p_elig_per_opt_id in number default hr_api.g_number
923: ,p_elig_cvrd_dpnt_id in number default hr_api.g_number
924: ,p_dpnt_person_id in number default hr_api.g_number
925: ,p_business_group_id in number default hr_api.g_number
926: ,p_egd_attribute_category in varchar2 default hr_api.g_varchar2
927: ,p_egd_attribute1 in varchar2 default hr_api.g_varchar2
928: ,p_egd_attribute2 in varchar2 default hr_api.g_varchar2

Line 925: ,p_business_group_id in number default hr_api.g_number

921: ,p_elig_per_id in number default hr_api.g_number
922: ,p_elig_per_opt_id in number default hr_api.g_number
923: ,p_elig_cvrd_dpnt_id in number default hr_api.g_number
924: ,p_dpnt_person_id in number default hr_api.g_number
925: ,p_business_group_id in number default hr_api.g_number
926: ,p_egd_attribute_category in varchar2 default hr_api.g_varchar2
927: ,p_egd_attribute1 in varchar2 default hr_api.g_varchar2
928: ,p_egd_attribute2 in varchar2 default hr_api.g_varchar2
929: ,p_egd_attribute3 in varchar2 default hr_api.g_varchar2

Line 926: ,p_egd_attribute_category in varchar2 default hr_api.g_varchar2

922: ,p_elig_per_opt_id in number default hr_api.g_number
923: ,p_elig_cvrd_dpnt_id in number default hr_api.g_number
924: ,p_dpnt_person_id in number default hr_api.g_number
925: ,p_business_group_id in number default hr_api.g_number
926: ,p_egd_attribute_category in varchar2 default hr_api.g_varchar2
927: ,p_egd_attribute1 in varchar2 default hr_api.g_varchar2
928: ,p_egd_attribute2 in varchar2 default hr_api.g_varchar2
929: ,p_egd_attribute3 in varchar2 default hr_api.g_varchar2
930: ,p_egd_attribute4 in varchar2 default hr_api.g_varchar2

Line 927: ,p_egd_attribute1 in varchar2 default hr_api.g_varchar2

923: ,p_elig_cvrd_dpnt_id in number default hr_api.g_number
924: ,p_dpnt_person_id in number default hr_api.g_number
925: ,p_business_group_id in number default hr_api.g_number
926: ,p_egd_attribute_category in varchar2 default hr_api.g_varchar2
927: ,p_egd_attribute1 in varchar2 default hr_api.g_varchar2
928: ,p_egd_attribute2 in varchar2 default hr_api.g_varchar2
929: ,p_egd_attribute3 in varchar2 default hr_api.g_varchar2
930: ,p_egd_attribute4 in varchar2 default hr_api.g_varchar2
931: ,p_egd_attribute5 in varchar2 default hr_api.g_varchar2

Line 928: ,p_egd_attribute2 in varchar2 default hr_api.g_varchar2

924: ,p_dpnt_person_id in number default hr_api.g_number
925: ,p_business_group_id in number default hr_api.g_number
926: ,p_egd_attribute_category in varchar2 default hr_api.g_varchar2
927: ,p_egd_attribute1 in varchar2 default hr_api.g_varchar2
928: ,p_egd_attribute2 in varchar2 default hr_api.g_varchar2
929: ,p_egd_attribute3 in varchar2 default hr_api.g_varchar2
930: ,p_egd_attribute4 in varchar2 default hr_api.g_varchar2
931: ,p_egd_attribute5 in varchar2 default hr_api.g_varchar2
932: ,p_egd_attribute6 in varchar2 default hr_api.g_varchar2

Line 929: ,p_egd_attribute3 in varchar2 default hr_api.g_varchar2

925: ,p_business_group_id in number default hr_api.g_number
926: ,p_egd_attribute_category in varchar2 default hr_api.g_varchar2
927: ,p_egd_attribute1 in varchar2 default hr_api.g_varchar2
928: ,p_egd_attribute2 in varchar2 default hr_api.g_varchar2
929: ,p_egd_attribute3 in varchar2 default hr_api.g_varchar2
930: ,p_egd_attribute4 in varchar2 default hr_api.g_varchar2
931: ,p_egd_attribute5 in varchar2 default hr_api.g_varchar2
932: ,p_egd_attribute6 in varchar2 default hr_api.g_varchar2
933: ,p_egd_attribute7 in varchar2 default hr_api.g_varchar2

Line 930: ,p_egd_attribute4 in varchar2 default hr_api.g_varchar2

926: ,p_egd_attribute_category in varchar2 default hr_api.g_varchar2
927: ,p_egd_attribute1 in varchar2 default hr_api.g_varchar2
928: ,p_egd_attribute2 in varchar2 default hr_api.g_varchar2
929: ,p_egd_attribute3 in varchar2 default hr_api.g_varchar2
930: ,p_egd_attribute4 in varchar2 default hr_api.g_varchar2
931: ,p_egd_attribute5 in varchar2 default hr_api.g_varchar2
932: ,p_egd_attribute6 in varchar2 default hr_api.g_varchar2
933: ,p_egd_attribute7 in varchar2 default hr_api.g_varchar2
934: ,p_egd_attribute8 in varchar2 default hr_api.g_varchar2

Line 931: ,p_egd_attribute5 in varchar2 default hr_api.g_varchar2

927: ,p_egd_attribute1 in varchar2 default hr_api.g_varchar2
928: ,p_egd_attribute2 in varchar2 default hr_api.g_varchar2
929: ,p_egd_attribute3 in varchar2 default hr_api.g_varchar2
930: ,p_egd_attribute4 in varchar2 default hr_api.g_varchar2
931: ,p_egd_attribute5 in varchar2 default hr_api.g_varchar2
932: ,p_egd_attribute6 in varchar2 default hr_api.g_varchar2
933: ,p_egd_attribute7 in varchar2 default hr_api.g_varchar2
934: ,p_egd_attribute8 in varchar2 default hr_api.g_varchar2
935: ,p_egd_attribute9 in varchar2 default hr_api.g_varchar2

Line 932: ,p_egd_attribute6 in varchar2 default hr_api.g_varchar2

928: ,p_egd_attribute2 in varchar2 default hr_api.g_varchar2
929: ,p_egd_attribute3 in varchar2 default hr_api.g_varchar2
930: ,p_egd_attribute4 in varchar2 default hr_api.g_varchar2
931: ,p_egd_attribute5 in varchar2 default hr_api.g_varchar2
932: ,p_egd_attribute6 in varchar2 default hr_api.g_varchar2
933: ,p_egd_attribute7 in varchar2 default hr_api.g_varchar2
934: ,p_egd_attribute8 in varchar2 default hr_api.g_varchar2
935: ,p_egd_attribute9 in varchar2 default hr_api.g_varchar2
936: ,p_egd_attribute10 in varchar2 default hr_api.g_varchar2

Line 933: ,p_egd_attribute7 in varchar2 default hr_api.g_varchar2

929: ,p_egd_attribute3 in varchar2 default hr_api.g_varchar2
930: ,p_egd_attribute4 in varchar2 default hr_api.g_varchar2
931: ,p_egd_attribute5 in varchar2 default hr_api.g_varchar2
932: ,p_egd_attribute6 in varchar2 default hr_api.g_varchar2
933: ,p_egd_attribute7 in varchar2 default hr_api.g_varchar2
934: ,p_egd_attribute8 in varchar2 default hr_api.g_varchar2
935: ,p_egd_attribute9 in varchar2 default hr_api.g_varchar2
936: ,p_egd_attribute10 in varchar2 default hr_api.g_varchar2
937: ,p_egd_attribute11 in varchar2 default hr_api.g_varchar2

Line 934: ,p_egd_attribute8 in varchar2 default hr_api.g_varchar2

930: ,p_egd_attribute4 in varchar2 default hr_api.g_varchar2
931: ,p_egd_attribute5 in varchar2 default hr_api.g_varchar2
932: ,p_egd_attribute6 in varchar2 default hr_api.g_varchar2
933: ,p_egd_attribute7 in varchar2 default hr_api.g_varchar2
934: ,p_egd_attribute8 in varchar2 default hr_api.g_varchar2
935: ,p_egd_attribute9 in varchar2 default hr_api.g_varchar2
936: ,p_egd_attribute10 in varchar2 default hr_api.g_varchar2
937: ,p_egd_attribute11 in varchar2 default hr_api.g_varchar2
938: ,p_egd_attribute12 in varchar2 default hr_api.g_varchar2

Line 935: ,p_egd_attribute9 in varchar2 default hr_api.g_varchar2

931: ,p_egd_attribute5 in varchar2 default hr_api.g_varchar2
932: ,p_egd_attribute6 in varchar2 default hr_api.g_varchar2
933: ,p_egd_attribute7 in varchar2 default hr_api.g_varchar2
934: ,p_egd_attribute8 in varchar2 default hr_api.g_varchar2
935: ,p_egd_attribute9 in varchar2 default hr_api.g_varchar2
936: ,p_egd_attribute10 in varchar2 default hr_api.g_varchar2
937: ,p_egd_attribute11 in varchar2 default hr_api.g_varchar2
938: ,p_egd_attribute12 in varchar2 default hr_api.g_varchar2
939: ,p_egd_attribute13 in varchar2 default hr_api.g_varchar2

Line 936: ,p_egd_attribute10 in varchar2 default hr_api.g_varchar2

932: ,p_egd_attribute6 in varchar2 default hr_api.g_varchar2
933: ,p_egd_attribute7 in varchar2 default hr_api.g_varchar2
934: ,p_egd_attribute8 in varchar2 default hr_api.g_varchar2
935: ,p_egd_attribute9 in varchar2 default hr_api.g_varchar2
936: ,p_egd_attribute10 in varchar2 default hr_api.g_varchar2
937: ,p_egd_attribute11 in varchar2 default hr_api.g_varchar2
938: ,p_egd_attribute12 in varchar2 default hr_api.g_varchar2
939: ,p_egd_attribute13 in varchar2 default hr_api.g_varchar2
940: ,p_egd_attribute14 in varchar2 default hr_api.g_varchar2

Line 937: ,p_egd_attribute11 in varchar2 default hr_api.g_varchar2

933: ,p_egd_attribute7 in varchar2 default hr_api.g_varchar2
934: ,p_egd_attribute8 in varchar2 default hr_api.g_varchar2
935: ,p_egd_attribute9 in varchar2 default hr_api.g_varchar2
936: ,p_egd_attribute10 in varchar2 default hr_api.g_varchar2
937: ,p_egd_attribute11 in varchar2 default hr_api.g_varchar2
938: ,p_egd_attribute12 in varchar2 default hr_api.g_varchar2
939: ,p_egd_attribute13 in varchar2 default hr_api.g_varchar2
940: ,p_egd_attribute14 in varchar2 default hr_api.g_varchar2
941: ,p_egd_attribute15 in varchar2 default hr_api.g_varchar2

Line 938: ,p_egd_attribute12 in varchar2 default hr_api.g_varchar2

934: ,p_egd_attribute8 in varchar2 default hr_api.g_varchar2
935: ,p_egd_attribute9 in varchar2 default hr_api.g_varchar2
936: ,p_egd_attribute10 in varchar2 default hr_api.g_varchar2
937: ,p_egd_attribute11 in varchar2 default hr_api.g_varchar2
938: ,p_egd_attribute12 in varchar2 default hr_api.g_varchar2
939: ,p_egd_attribute13 in varchar2 default hr_api.g_varchar2
940: ,p_egd_attribute14 in varchar2 default hr_api.g_varchar2
941: ,p_egd_attribute15 in varchar2 default hr_api.g_varchar2
942: ,p_egd_attribute16 in varchar2 default hr_api.g_varchar2

Line 939: ,p_egd_attribute13 in varchar2 default hr_api.g_varchar2

935: ,p_egd_attribute9 in varchar2 default hr_api.g_varchar2
936: ,p_egd_attribute10 in varchar2 default hr_api.g_varchar2
937: ,p_egd_attribute11 in varchar2 default hr_api.g_varchar2
938: ,p_egd_attribute12 in varchar2 default hr_api.g_varchar2
939: ,p_egd_attribute13 in varchar2 default hr_api.g_varchar2
940: ,p_egd_attribute14 in varchar2 default hr_api.g_varchar2
941: ,p_egd_attribute15 in varchar2 default hr_api.g_varchar2
942: ,p_egd_attribute16 in varchar2 default hr_api.g_varchar2
943: ,p_egd_attribute17 in varchar2 default hr_api.g_varchar2

Line 940: ,p_egd_attribute14 in varchar2 default hr_api.g_varchar2

936: ,p_egd_attribute10 in varchar2 default hr_api.g_varchar2
937: ,p_egd_attribute11 in varchar2 default hr_api.g_varchar2
938: ,p_egd_attribute12 in varchar2 default hr_api.g_varchar2
939: ,p_egd_attribute13 in varchar2 default hr_api.g_varchar2
940: ,p_egd_attribute14 in varchar2 default hr_api.g_varchar2
941: ,p_egd_attribute15 in varchar2 default hr_api.g_varchar2
942: ,p_egd_attribute16 in varchar2 default hr_api.g_varchar2
943: ,p_egd_attribute17 in varchar2 default hr_api.g_varchar2
944: ,p_egd_attribute18 in varchar2 default hr_api.g_varchar2

Line 941: ,p_egd_attribute15 in varchar2 default hr_api.g_varchar2

937: ,p_egd_attribute11 in varchar2 default hr_api.g_varchar2
938: ,p_egd_attribute12 in varchar2 default hr_api.g_varchar2
939: ,p_egd_attribute13 in varchar2 default hr_api.g_varchar2
940: ,p_egd_attribute14 in varchar2 default hr_api.g_varchar2
941: ,p_egd_attribute15 in varchar2 default hr_api.g_varchar2
942: ,p_egd_attribute16 in varchar2 default hr_api.g_varchar2
943: ,p_egd_attribute17 in varchar2 default hr_api.g_varchar2
944: ,p_egd_attribute18 in varchar2 default hr_api.g_varchar2
945: ,p_egd_attribute19 in varchar2 default hr_api.g_varchar2

Line 942: ,p_egd_attribute16 in varchar2 default hr_api.g_varchar2

938: ,p_egd_attribute12 in varchar2 default hr_api.g_varchar2
939: ,p_egd_attribute13 in varchar2 default hr_api.g_varchar2
940: ,p_egd_attribute14 in varchar2 default hr_api.g_varchar2
941: ,p_egd_attribute15 in varchar2 default hr_api.g_varchar2
942: ,p_egd_attribute16 in varchar2 default hr_api.g_varchar2
943: ,p_egd_attribute17 in varchar2 default hr_api.g_varchar2
944: ,p_egd_attribute18 in varchar2 default hr_api.g_varchar2
945: ,p_egd_attribute19 in varchar2 default hr_api.g_varchar2
946: ,p_egd_attribute20 in varchar2 default hr_api.g_varchar2

Line 943: ,p_egd_attribute17 in varchar2 default hr_api.g_varchar2

939: ,p_egd_attribute13 in varchar2 default hr_api.g_varchar2
940: ,p_egd_attribute14 in varchar2 default hr_api.g_varchar2
941: ,p_egd_attribute15 in varchar2 default hr_api.g_varchar2
942: ,p_egd_attribute16 in varchar2 default hr_api.g_varchar2
943: ,p_egd_attribute17 in varchar2 default hr_api.g_varchar2
944: ,p_egd_attribute18 in varchar2 default hr_api.g_varchar2
945: ,p_egd_attribute19 in varchar2 default hr_api.g_varchar2
946: ,p_egd_attribute20 in varchar2 default hr_api.g_varchar2
947: ,p_egd_attribute21 in varchar2 default hr_api.g_varchar2

Line 944: ,p_egd_attribute18 in varchar2 default hr_api.g_varchar2

940: ,p_egd_attribute14 in varchar2 default hr_api.g_varchar2
941: ,p_egd_attribute15 in varchar2 default hr_api.g_varchar2
942: ,p_egd_attribute16 in varchar2 default hr_api.g_varchar2
943: ,p_egd_attribute17 in varchar2 default hr_api.g_varchar2
944: ,p_egd_attribute18 in varchar2 default hr_api.g_varchar2
945: ,p_egd_attribute19 in varchar2 default hr_api.g_varchar2
946: ,p_egd_attribute20 in varchar2 default hr_api.g_varchar2
947: ,p_egd_attribute21 in varchar2 default hr_api.g_varchar2
948: ,p_egd_attribute22 in varchar2 default hr_api.g_varchar2

Line 945: ,p_egd_attribute19 in varchar2 default hr_api.g_varchar2

941: ,p_egd_attribute15 in varchar2 default hr_api.g_varchar2
942: ,p_egd_attribute16 in varchar2 default hr_api.g_varchar2
943: ,p_egd_attribute17 in varchar2 default hr_api.g_varchar2
944: ,p_egd_attribute18 in varchar2 default hr_api.g_varchar2
945: ,p_egd_attribute19 in varchar2 default hr_api.g_varchar2
946: ,p_egd_attribute20 in varchar2 default hr_api.g_varchar2
947: ,p_egd_attribute21 in varchar2 default hr_api.g_varchar2
948: ,p_egd_attribute22 in varchar2 default hr_api.g_varchar2
949: ,p_egd_attribute23 in varchar2 default hr_api.g_varchar2

Line 946: ,p_egd_attribute20 in varchar2 default hr_api.g_varchar2

942: ,p_egd_attribute16 in varchar2 default hr_api.g_varchar2
943: ,p_egd_attribute17 in varchar2 default hr_api.g_varchar2
944: ,p_egd_attribute18 in varchar2 default hr_api.g_varchar2
945: ,p_egd_attribute19 in varchar2 default hr_api.g_varchar2
946: ,p_egd_attribute20 in varchar2 default hr_api.g_varchar2
947: ,p_egd_attribute21 in varchar2 default hr_api.g_varchar2
948: ,p_egd_attribute22 in varchar2 default hr_api.g_varchar2
949: ,p_egd_attribute23 in varchar2 default hr_api.g_varchar2
950: ,p_egd_attribute24 in varchar2 default hr_api.g_varchar2

Line 947: ,p_egd_attribute21 in varchar2 default hr_api.g_varchar2

943: ,p_egd_attribute17 in varchar2 default hr_api.g_varchar2
944: ,p_egd_attribute18 in varchar2 default hr_api.g_varchar2
945: ,p_egd_attribute19 in varchar2 default hr_api.g_varchar2
946: ,p_egd_attribute20 in varchar2 default hr_api.g_varchar2
947: ,p_egd_attribute21 in varchar2 default hr_api.g_varchar2
948: ,p_egd_attribute22 in varchar2 default hr_api.g_varchar2
949: ,p_egd_attribute23 in varchar2 default hr_api.g_varchar2
950: ,p_egd_attribute24 in varchar2 default hr_api.g_varchar2
951: ,p_egd_attribute25 in varchar2 default hr_api.g_varchar2

Line 948: ,p_egd_attribute22 in varchar2 default hr_api.g_varchar2

944: ,p_egd_attribute18 in varchar2 default hr_api.g_varchar2
945: ,p_egd_attribute19 in varchar2 default hr_api.g_varchar2
946: ,p_egd_attribute20 in varchar2 default hr_api.g_varchar2
947: ,p_egd_attribute21 in varchar2 default hr_api.g_varchar2
948: ,p_egd_attribute22 in varchar2 default hr_api.g_varchar2
949: ,p_egd_attribute23 in varchar2 default hr_api.g_varchar2
950: ,p_egd_attribute24 in varchar2 default hr_api.g_varchar2
951: ,p_egd_attribute25 in varchar2 default hr_api.g_varchar2
952: ,p_egd_attribute26 in varchar2 default hr_api.g_varchar2

Line 949: ,p_egd_attribute23 in varchar2 default hr_api.g_varchar2

945: ,p_egd_attribute19 in varchar2 default hr_api.g_varchar2
946: ,p_egd_attribute20 in varchar2 default hr_api.g_varchar2
947: ,p_egd_attribute21 in varchar2 default hr_api.g_varchar2
948: ,p_egd_attribute22 in varchar2 default hr_api.g_varchar2
949: ,p_egd_attribute23 in varchar2 default hr_api.g_varchar2
950: ,p_egd_attribute24 in varchar2 default hr_api.g_varchar2
951: ,p_egd_attribute25 in varchar2 default hr_api.g_varchar2
952: ,p_egd_attribute26 in varchar2 default hr_api.g_varchar2
953: ,p_egd_attribute27 in varchar2 default hr_api.g_varchar2

Line 950: ,p_egd_attribute24 in varchar2 default hr_api.g_varchar2

946: ,p_egd_attribute20 in varchar2 default hr_api.g_varchar2
947: ,p_egd_attribute21 in varchar2 default hr_api.g_varchar2
948: ,p_egd_attribute22 in varchar2 default hr_api.g_varchar2
949: ,p_egd_attribute23 in varchar2 default hr_api.g_varchar2
950: ,p_egd_attribute24 in varchar2 default hr_api.g_varchar2
951: ,p_egd_attribute25 in varchar2 default hr_api.g_varchar2
952: ,p_egd_attribute26 in varchar2 default hr_api.g_varchar2
953: ,p_egd_attribute27 in varchar2 default hr_api.g_varchar2
954: ,p_egd_attribute28 in varchar2 default hr_api.g_varchar2

Line 951: ,p_egd_attribute25 in varchar2 default hr_api.g_varchar2

947: ,p_egd_attribute21 in varchar2 default hr_api.g_varchar2
948: ,p_egd_attribute22 in varchar2 default hr_api.g_varchar2
949: ,p_egd_attribute23 in varchar2 default hr_api.g_varchar2
950: ,p_egd_attribute24 in varchar2 default hr_api.g_varchar2
951: ,p_egd_attribute25 in varchar2 default hr_api.g_varchar2
952: ,p_egd_attribute26 in varchar2 default hr_api.g_varchar2
953: ,p_egd_attribute27 in varchar2 default hr_api.g_varchar2
954: ,p_egd_attribute28 in varchar2 default hr_api.g_varchar2
955: ,p_egd_attribute29 in varchar2 default hr_api.g_varchar2

Line 952: ,p_egd_attribute26 in varchar2 default hr_api.g_varchar2

948: ,p_egd_attribute22 in varchar2 default hr_api.g_varchar2
949: ,p_egd_attribute23 in varchar2 default hr_api.g_varchar2
950: ,p_egd_attribute24 in varchar2 default hr_api.g_varchar2
951: ,p_egd_attribute25 in varchar2 default hr_api.g_varchar2
952: ,p_egd_attribute26 in varchar2 default hr_api.g_varchar2
953: ,p_egd_attribute27 in varchar2 default hr_api.g_varchar2
954: ,p_egd_attribute28 in varchar2 default hr_api.g_varchar2
955: ,p_egd_attribute29 in varchar2 default hr_api.g_varchar2
956: ,p_egd_attribute30 in varchar2 default hr_api.g_varchar2

Line 953: ,p_egd_attribute27 in varchar2 default hr_api.g_varchar2

949: ,p_egd_attribute23 in varchar2 default hr_api.g_varchar2
950: ,p_egd_attribute24 in varchar2 default hr_api.g_varchar2
951: ,p_egd_attribute25 in varchar2 default hr_api.g_varchar2
952: ,p_egd_attribute26 in varchar2 default hr_api.g_varchar2
953: ,p_egd_attribute27 in varchar2 default hr_api.g_varchar2
954: ,p_egd_attribute28 in varchar2 default hr_api.g_varchar2
955: ,p_egd_attribute29 in varchar2 default hr_api.g_varchar2
956: ,p_egd_attribute30 in varchar2 default hr_api.g_varchar2
957: ,p_request_id in number default hr_api.g_number

Line 954: ,p_egd_attribute28 in varchar2 default hr_api.g_varchar2

950: ,p_egd_attribute24 in varchar2 default hr_api.g_varchar2
951: ,p_egd_attribute25 in varchar2 default hr_api.g_varchar2
952: ,p_egd_attribute26 in varchar2 default hr_api.g_varchar2
953: ,p_egd_attribute27 in varchar2 default hr_api.g_varchar2
954: ,p_egd_attribute28 in varchar2 default hr_api.g_varchar2
955: ,p_egd_attribute29 in varchar2 default hr_api.g_varchar2
956: ,p_egd_attribute30 in varchar2 default hr_api.g_varchar2
957: ,p_request_id in number default hr_api.g_number
958: ,p_program_application_id in number default hr_api.g_number

Line 955: ,p_egd_attribute29 in varchar2 default hr_api.g_varchar2

951: ,p_egd_attribute25 in varchar2 default hr_api.g_varchar2
952: ,p_egd_attribute26 in varchar2 default hr_api.g_varchar2
953: ,p_egd_attribute27 in varchar2 default hr_api.g_varchar2
954: ,p_egd_attribute28 in varchar2 default hr_api.g_varchar2
955: ,p_egd_attribute29 in varchar2 default hr_api.g_varchar2
956: ,p_egd_attribute30 in varchar2 default hr_api.g_varchar2
957: ,p_request_id in number default hr_api.g_number
958: ,p_program_application_id in number default hr_api.g_number
959: ,p_program_id in number default hr_api.g_number

Line 956: ,p_egd_attribute30 in varchar2 default hr_api.g_varchar2

952: ,p_egd_attribute26 in varchar2 default hr_api.g_varchar2
953: ,p_egd_attribute27 in varchar2 default hr_api.g_varchar2
954: ,p_egd_attribute28 in varchar2 default hr_api.g_varchar2
955: ,p_egd_attribute29 in varchar2 default hr_api.g_varchar2
956: ,p_egd_attribute30 in varchar2 default hr_api.g_varchar2
957: ,p_request_id in number default hr_api.g_number
958: ,p_program_application_id in number default hr_api.g_number
959: ,p_program_id in number default hr_api.g_number
960: ,p_program_update_date in date default hr_api.g_date

Line 957: ,p_request_id in number default hr_api.g_number

953: ,p_egd_attribute27 in varchar2 default hr_api.g_varchar2
954: ,p_egd_attribute28 in varchar2 default hr_api.g_varchar2
955: ,p_egd_attribute29 in varchar2 default hr_api.g_varchar2
956: ,p_egd_attribute30 in varchar2 default hr_api.g_varchar2
957: ,p_request_id in number default hr_api.g_number
958: ,p_program_application_id in number default hr_api.g_number
959: ,p_program_id in number default hr_api.g_number
960: ,p_program_update_date in date default hr_api.g_date
961: ,p_object_version_number in out nocopy number

Line 958: ,p_program_application_id in number default hr_api.g_number

954: ,p_egd_attribute28 in varchar2 default hr_api.g_varchar2
955: ,p_egd_attribute29 in varchar2 default hr_api.g_varchar2
956: ,p_egd_attribute30 in varchar2 default hr_api.g_varchar2
957: ,p_request_id in number default hr_api.g_number
958: ,p_program_application_id in number default hr_api.g_number
959: ,p_program_id in number default hr_api.g_number
960: ,p_program_update_date in date default hr_api.g_date
961: ,p_object_version_number in out nocopy number
962: ,p_effective_date in date

Line 959: ,p_program_id in number default hr_api.g_number

955: ,p_egd_attribute29 in varchar2 default hr_api.g_varchar2
956: ,p_egd_attribute30 in varchar2 default hr_api.g_varchar2
957: ,p_request_id in number default hr_api.g_number
958: ,p_program_application_id in number default hr_api.g_number
959: ,p_program_id in number default hr_api.g_number
960: ,p_program_update_date in date default hr_api.g_date
961: ,p_object_version_number in out nocopy number
962: ,p_effective_date in date
963: )

Line 960: ,p_program_update_date in date default hr_api.g_date

956: ,p_egd_attribute30 in varchar2 default hr_api.g_varchar2
957: ,p_request_id in number default hr_api.g_number
958: ,p_program_application_id in number default hr_api.g_number
959: ,p_program_id in number default hr_api.g_number
960: ,p_program_update_date in date default hr_api.g_date
961: ,p_object_version_number in out nocopy number
962: ,p_effective_date in date
963: )
964: is

Line 1143: raise hr_api.validate_enabled;

1139: --
1140: -- When in validation only mode raise the Validate_Enabled exception
1141: --
1142: if p_validate then
1143: raise hr_api.validate_enabled;
1144: end if;
1145: --
1146: -- Set all output arguments
1147: --

Line 1154: when hr_api.validate_enabled then

1150: hr_utility.set_location(' Leaving:'||l_proc, 70);
1151: --
1152: exception
1153: --
1154: when hr_api.validate_enabled then
1155: --
1156: -- As the Validate_Enabled exception has been raised
1157: -- we must rollback to the savepoint
1158: --

Line 1219: when hr_api.cannot_find_prog_unit then

1215: ,p_object_version_number => p_object_version_number
1216: ,p_effective_date => trunc(p_effective_date)
1217: );
1218: exception
1219: when hr_api.cannot_find_prog_unit then
1220: hr_api.cannot_find_prog_unit_error
1221: (p_module_name => 'DELETE_ELIG_DPNT'
1222: ,p_hook_type => 'BP'
1223: );

Line 1220: hr_api.cannot_find_prog_unit_error

1216: ,p_effective_date => trunc(p_effective_date)
1217: );
1218: exception
1219: when hr_api.cannot_find_prog_unit then
1220: hr_api.cannot_find_prog_unit_error
1221: (p_module_name => 'DELETE_ELIG_DPNT'
1222: ,p_hook_type => 'BP'
1223: );
1224: --

Line 1247: when hr_api.cannot_find_prog_unit then

1243: ,p_object_version_number => l_object_version_number
1244: ,p_effective_date => trunc(p_effective_date)
1245: );
1246: exception
1247: when hr_api.cannot_find_prog_unit then
1248: hr_api.cannot_find_prog_unit_error
1249: (p_module_name => 'DELETE_ELIG_DPNT'
1250: ,p_hook_type => 'AP'
1251: );

Line 1248: hr_api.cannot_find_prog_unit_error

1244: ,p_effective_date => trunc(p_effective_date)
1245: );
1246: exception
1247: when hr_api.cannot_find_prog_unit then
1248: hr_api.cannot_find_prog_unit_error
1249: (p_module_name => 'DELETE_ELIG_DPNT'
1250: ,p_hook_type => 'AP'
1251: );
1252: --

Line 1262: raise hr_api.validate_enabled;

1258: --
1259: -- When in validation only mode raise the Validate_Enabled exception
1260: --
1261: if p_validate then
1262: raise hr_api.validate_enabled;
1263: end if;
1264: --
1265: hr_utility.set_location(' Leaving:'||l_proc, 70);
1266: --

Line 1269: when hr_api.validate_enabled then

1265: hr_utility.set_location(' Leaving:'||l_proc, 70);
1266: --
1267: exception
1268: --
1269: when hr_api.validate_enabled then
1270: --
1271: -- As the Validate_Enabled exception has been raised
1272: -- we must rollback to the savepoint
1273: --

Line 1343: AND inter.enrt_cvg_thru_dt = hr_api.g_eot

1339: AND sspndd.pl_id = inter.pl_id
1340: AND NVL (sspndd.oipl_id, -1) = NVL (inter.oipl_id, -1)
1341: AND sspndd.prtt_enrt_rslt_stat_cd IS NULL
1342: AND inter.prtt_enrt_rslt_stat_cd IS NULL
1343: AND inter.enrt_cvg_thru_dt = hr_api.g_eot
1344: AND sspndd.enrt_cvg_thru_dt = hr_api.g_eot
1345: and cv_effective_date between sspndd.effective_start_date
1346: and sspndd.effective_end_date
1347: and cv_effective_date between inter.effective_start_date

Line 1344: AND sspndd.enrt_cvg_thru_dt = hr_api.g_eot

1340: AND NVL (sspndd.oipl_id, -1) = NVL (inter.oipl_id, -1)
1341: AND sspndd.prtt_enrt_rslt_stat_cd IS NULL
1342: AND inter.prtt_enrt_rslt_stat_cd IS NULL
1343: AND inter.enrt_cvg_thru_dt = hr_api.g_eot
1344: AND sspndd.enrt_cvg_thru_dt = hr_api.g_eot
1345: and cv_effective_date between sspndd.effective_start_date
1346: and sspndd.effective_end_date
1347: and cv_effective_date between inter.effective_start_date
1348: and inter.effective_end_date;

Line 1520: l_pdp_datetrack_mode := hr_api.g_correction;

1516: l_pdp_found := true;
1517: --
1518: if l_pdp_rec.effective_start_date = p_effective_date then
1519: --
1520: l_pdp_datetrack_mode := hr_api.g_correction;
1521: --
1522: else
1523: --
1524: l_pdp_datetrack_mode := p_datetrack_mode;

Line 1541: l_cvg_thru_dt := hr_api.g_eot;

1537: -- Take note of this, when looking for cases.
1538: --
1539: if p_cvg_thru_dt is null then
1540: --
1541: l_cvg_thru_dt := hr_api.g_eot;
1542: --
1543: else
1544: --
1545: l_cvg_thru_dt := p_cvg_thru_dt;

Line 1563: elsif l_cvg_thru_dt <> hr_api.g_eot and not l_pdp_found then

1559: --
1560: fnd_message.set_name('BEN','BEN_92322_EGD_NOT_FOUND');
1561: fnd_message.raise_error;
1562: --
1563: elsif l_cvg_thru_dt <> hr_api.g_eot and not l_pdp_found then
1564: --
1565: -- The Coverage through date is not EOT, it means that the
1566: -- user is trying to end coverage. But here the covered dependent
1567: -- record is not found, so we cannot end coverage.

Line 1575: elsif l_pdp_found and (l_cvg_thru_dt <> hr_api.g_eot

1571: --
1572: fnd_message.set_name('BEN','BEN_92323_CVG_CANNOT_BE_ENDED');
1573: fnd_message.raise_error;
1574: --
1575: elsif l_pdp_found and (l_cvg_thru_dt <> hr_api.g_eot
1576: or p_cvg_strt_dt is null) then
1577: --
1578: -- The coverage through date is not EOT or the coverage start date
1579: -- is null. In both the case, the user is trying to end the coverage

Line 1656: p_datetrack_mode => hr_api.g_zap,

1652: p_effective_end_date => l_effective_end_date,
1653: p_object_version_number => l_pdp_rec.object_version_number,
1654: p_business_group_id => p_business_group_id,
1655: p_effective_date => p_effective_date,
1656: p_datetrack_mode => hr_api.g_zap,
1657: p_multi_row_actn => true,
1658: p_called_from => 'beegdapi' );
1659: --
1660: ben_elig_dpnt_api.update_elig_dpnt(

Line 1696: l_pdp_rec.effective_end_date = hr_api.g_eot and

1692: ( p_effective_date >=l_pdp_rec.effective_start_date and
1693: p_cvg_strt_dt = l_pdp_rec.cvg_strt_dt) or
1694: (p_effective_date between
1695: l_pdp_rec.effective_start_date and l_pdp_rec.effective_end_date and -----Bug 9051021
1696: l_pdp_rec.effective_end_date = hr_api.g_eot and
1697: l_pdp_rec.cvg_strt_dt between
1698: l_pdp_rec.effective_start_date and l_pdp_rec.effective_end_date and
1699: l_pdp_rec.cvg_thru_dt = hr_api.g_eot)) then
1700:

Line 1699: l_pdp_rec.cvg_thru_dt = hr_api.g_eot)) then

1695: l_pdp_rec.effective_start_date and l_pdp_rec.effective_end_date and -----Bug 9051021
1696: l_pdp_rec.effective_end_date = hr_api.g_eot and
1697: l_pdp_rec.cvg_strt_dt between
1698: l_pdp_rec.effective_start_date and l_pdp_rec.effective_end_date and
1699: l_pdp_rec.cvg_thru_dt = hr_api.g_eot)) then
1700:
1701: --
1702: -- As we have reached here, it means the coverge through date is EOT,
1703: -- and hence we are not trying to de-enroll the dependent.

Line 1717: p_cvg_thru_dt => hr_api.g_eot,

1713: p_effective_start_date => p_effective_start_date,
1714: p_effective_end_date => p_effective_end_date,
1715: p_per_in_ler_id => l_egd_rec.per_in_ler_id,
1716: p_cvg_strt_dt => p_cvg_strt_dt, -- 3453213
1717: p_cvg_thru_dt => hr_api.g_eot,
1718: p_object_version_number => l_pdp_rec.object_version_number,
1719: p_datetrack_mode => l_pdp_datetrack_mode,
1720: p_multi_row_actn => p_multi_row_actn,
1721: p_pdp_attribute_category => p_pdp_attribute_category,

Line 1781: p_cvg_thru_dt => hr_api.g_eot,

1777: p_business_group_id => p_business_group_id,
1778: p_dpnt_person_id => l_egd_rec.dpnt_person_id,
1779: p_per_in_ler_id => l_egd_rec.per_in_ler_id,
1780: p_cvg_strt_dt => p_cvg_strt_dt,
1781: p_cvg_thru_dt => hr_api.g_eot,
1782: p_prtt_enrt_rslt_id => l_egd_rec.prtt_enrt_rslt_id,
1783: p_object_version_number => p_object_version_number,
1784: p_effective_date => p_effective_date,
1785: p_multi_row_actn => p_multi_row_actn,

Line 1842: raise hr_api.validate_enabled;

1838: --
1839: -- When in validation only mode raise the Validate_Enabled exception
1840: --
1841: if p_validate then
1842: raise hr_api.validate_enabled;
1843: end if;
1844: --
1845: exception
1846: --

Line 1847: when hr_api.validate_enabled then

1843: end if;
1844: --
1845: exception
1846: --
1847: when hr_api.validate_enabled then
1848: --
1849: -- As the Validate_Enabled exception has been raised
1850: -- we must rollback to the savepoint
1851: --

Line 1950: raise hr_api.validate_enabled;

1946: ,p_object_version_number => p_object_version_number
1947: ,p_multi_row_actn => l_multi_row_actn);
1948: --
1949: if l_validate then
1950: raise hr_api.validate_enabled;
1951: end if;
1952: --
1953: -- Set all output arguments
1954: --

Line 1964: when hr_api.validate_enabled then

1960: hr_utility.set_location(' Leaving:'||l_proc, 40);
1961:
1962: exception
1963: --
1964: when hr_api.validate_enabled then
1965: --
1966: -- As the Validate_Enabled exception has been raised
1967: -- we must rollback to the savepoint
1968: --

Line 2064: AND pen.enrt_cvg_thru_dt = hr_api.g_eot

2060: AND pen.prtt_enrt_rslt_id = chc.prtt_enrt_rslt_id
2061: AND pen.prtt_enrt_rslt_stat_cd IS NULL
2062: AND p_effective_date between pen.effective_start_date
2063: and pen.effective_end_date
2064: AND pen.enrt_cvg_thru_dt = hr_api.g_eot
2065: AND pen.pl_id = pln.pl_id
2066: AND pln.pl_stat_cd = 'A'
2067: AND pln.svgs_pl_flag <> 'Y'
2068: AND pln.alws_qmcso_flag = 'Y'

Line 2096: and pen2.enrt_cvg_thru_dt = hr_api.g_eot);

2092: and pen2.sspndd_flag = 'Y'
2093: and pen2.prtt_enrt_rslt_stat_cd is null
2094: and p_effective_date between
2095: pen2.effective_start_date and pen2.effective_end_date
2096: and pen2.enrt_cvg_thru_dt = hr_api.g_eot);
2097: --
2098: l_comp_obj_list varchar2(2000) := null;
2099: l_proc varchar2(72) := g_package||'.store_crt_ord_warng_DDNA';
2100: begin

Line 2705: open c_chk_enrt(l_dpnt_rltp_row.date_start,nvl(l_dpnt_rltp_row.date_end,hr_api.g_eot));

2701: close c_rltp;
2702:
2703: if(l_dpnt_rltp_row.date_start is not null and l_dpnt_rltp_row.personal_flag = 'Y' and (p_rltp_type <> l_dpnt_rltp_row.contact_type) ) then
2704: hr_utility.set_location('Date not null ', 10);
2705: open c_chk_enrt(l_dpnt_rltp_row.date_start,nvl(l_dpnt_rltp_row.date_end,hr_api.g_eot));
2706: fetch c_chk_enrt into l_flag;
2707: if(c_chk_enrt%found) then
2708: hr_utility.set_location('Enrollment Rec exists for Dep ', 10);
2709: fnd_message.set_name('BEN','BEN_94714_RELATION_TYP_UPD');