106: is
107: --
108: -- Declare cursors and local variables
109: --
110: l_elig_per_opt_id ben_elig_per_opt_f.elig_per_opt_id%TYPE;
111: l_effective_start_date ben_elig_per_opt_f.effective_start_date%TYPE;
112: l_effective_end_date ben_elig_per_opt_f.effective_end_date%TYPE;
113: l_proc varchar2(72) := g_package||'create_Elig_Person_Option';
114: l_object_version_number ben_elig_per_opt_f.object_version_number%TYPE;
107: --
108: -- Declare cursors and local variables
109: --
110: l_elig_per_opt_id ben_elig_per_opt_f.elig_per_opt_id%TYPE;
111: l_effective_start_date ben_elig_per_opt_f.effective_start_date%TYPE;
112: l_effective_end_date ben_elig_per_opt_f.effective_end_date%TYPE;
113: l_proc varchar2(72) := g_package||'create_Elig_Person_Option';
114: l_object_version_number ben_elig_per_opt_f.object_version_number%TYPE;
115: --
108: -- Declare cursors and local variables
109: --
110: l_elig_per_opt_id ben_elig_per_opt_f.elig_per_opt_id%TYPE;
111: l_effective_start_date ben_elig_per_opt_f.effective_start_date%TYPE;
112: l_effective_end_date ben_elig_per_opt_f.effective_end_date%TYPE;
113: l_proc varchar2(72) := g_package||'create_Elig_Person_Option';
114: l_object_version_number ben_elig_per_opt_f.object_version_number%TYPE;
115: --
116: begin
110: l_elig_per_opt_id ben_elig_per_opt_f.elig_per_opt_id%TYPE;
111: l_effective_start_date ben_elig_per_opt_f.effective_start_date%TYPE;
112: l_effective_end_date ben_elig_per_opt_f.effective_end_date%TYPE;
113: l_proc varchar2(72) := g_package||'create_Elig_Person_Option';
114: l_object_version_number ben_elig_per_opt_f.object_version_number%TYPE;
115: --
116: begin
117: --
118: hr_utility.set_location('Entering:'|| l_proc, 10);
584: l_proc varchar2(72) := g_package||'create_perf_Elig_Person_Option';
585: --
586: -- Declare cursors and local variables
587: --
588: l_object_version_number ben_elig_per_opt_f.object_version_number%TYPE;
589: l_elig_per_opt_id ben_elig_per_opt_f.elig_per_opt_id%TYPE;
590: l_effective_start_date ben_elig_per_opt_f.effective_start_date%TYPE;
591: l_effective_end_date ben_elig_per_opt_f.effective_end_date%TYPE;
592: --
585: --
586: -- Declare cursors and local variables
587: --
588: l_object_version_number ben_elig_per_opt_f.object_version_number%TYPE;
589: l_elig_per_opt_id ben_elig_per_opt_f.elig_per_opt_id%TYPE;
590: l_effective_start_date ben_elig_per_opt_f.effective_start_date%TYPE;
591: l_effective_end_date ben_elig_per_opt_f.effective_end_date%TYPE;
592: --
593: l_created_by ben_elig_per_opt_f.created_by%TYPE;
586: -- Declare cursors and local variables
587: --
588: l_object_version_number ben_elig_per_opt_f.object_version_number%TYPE;
589: l_elig_per_opt_id ben_elig_per_opt_f.elig_per_opt_id%TYPE;
590: l_effective_start_date ben_elig_per_opt_f.effective_start_date%TYPE;
591: l_effective_end_date ben_elig_per_opt_f.effective_end_date%TYPE;
592: --
593: l_created_by ben_elig_per_opt_f.created_by%TYPE;
594: l_creation_date ben_elig_per_opt_f.creation_date%TYPE;
587: --
588: l_object_version_number ben_elig_per_opt_f.object_version_number%TYPE;
589: l_elig_per_opt_id ben_elig_per_opt_f.elig_per_opt_id%TYPE;
590: l_effective_start_date ben_elig_per_opt_f.effective_start_date%TYPE;
591: l_effective_end_date ben_elig_per_opt_f.effective_end_date%TYPE;
592: --
593: l_created_by ben_elig_per_opt_f.created_by%TYPE;
594: l_creation_date ben_elig_per_opt_f.creation_date%TYPE;
595: l_last_update_date ben_elig_per_opt_f.last_update_date%TYPE;
589: l_elig_per_opt_id ben_elig_per_opt_f.elig_per_opt_id%TYPE;
590: l_effective_start_date ben_elig_per_opt_f.effective_start_date%TYPE;
591: l_effective_end_date ben_elig_per_opt_f.effective_end_date%TYPE;
592: --
593: l_created_by ben_elig_per_opt_f.created_by%TYPE;
594: l_creation_date ben_elig_per_opt_f.creation_date%TYPE;
595: l_last_update_date ben_elig_per_opt_f.last_update_date%TYPE;
596: l_last_updated_by ben_elig_per_opt_f.last_updated_by%TYPE;
597: l_last_update_login ben_elig_per_opt_f.last_update_login%TYPE;
590: l_effective_start_date ben_elig_per_opt_f.effective_start_date%TYPE;
591: l_effective_end_date ben_elig_per_opt_f.effective_end_date%TYPE;
592: --
593: l_created_by ben_elig_per_opt_f.created_by%TYPE;
594: l_creation_date ben_elig_per_opt_f.creation_date%TYPE;
595: l_last_update_date ben_elig_per_opt_f.last_update_date%TYPE;
596: l_last_updated_by ben_elig_per_opt_f.last_updated_by%TYPE;
597: l_last_update_login ben_elig_per_opt_f.last_update_login%TYPE;
598: --
591: l_effective_end_date ben_elig_per_opt_f.effective_end_date%TYPE;
592: --
593: l_created_by ben_elig_per_opt_f.created_by%TYPE;
594: l_creation_date ben_elig_per_opt_f.creation_date%TYPE;
595: l_last_update_date ben_elig_per_opt_f.last_update_date%TYPE;
596: l_last_updated_by ben_elig_per_opt_f.last_updated_by%TYPE;
597: l_last_update_login ben_elig_per_opt_f.last_update_login%TYPE;
598: --
599: Cursor C_Sel1 is select ben_elig_per_opt_f_s.nextval from sys.dual;
592: --
593: l_created_by ben_elig_per_opt_f.created_by%TYPE;
594: l_creation_date ben_elig_per_opt_f.creation_date%TYPE;
595: l_last_update_date ben_elig_per_opt_f.last_update_date%TYPE;
596: l_last_updated_by ben_elig_per_opt_f.last_updated_by%TYPE;
597: l_last_update_login ben_elig_per_opt_f.last_update_login%TYPE;
598: --
599: Cursor C_Sel1 is select ben_elig_per_opt_f_s.nextval from sys.dual;
600: --
593: l_created_by ben_elig_per_opt_f.created_by%TYPE;
594: l_creation_date ben_elig_per_opt_f.creation_date%TYPE;
595: l_last_update_date ben_elig_per_opt_f.last_update_date%TYPE;
596: l_last_updated_by ben_elig_per_opt_f.last_updated_by%TYPE;
597: l_last_update_login ben_elig_per_opt_f.last_update_login%TYPE;
598: --
599: Cursor C_Sel1 is select ben_elig_per_opt_f_s.nextval from sys.dual;
600: --
601: l_minmax_rec ben_batch_dt_api.gtyp_dtsum_row;
595: l_last_update_date ben_elig_per_opt_f.last_update_date%TYPE;
596: l_last_updated_by ben_elig_per_opt_f.last_updated_by%TYPE;
597: l_last_update_login ben_elig_per_opt_f.last_update_login%TYPE;
598: --
599: Cursor C_Sel1 is select ben_elig_per_opt_f_s.nextval from sys.dual;
600: --
601: l_minmax_rec ben_batch_dt_api.gtyp_dtsum_row;
602: --
603: begin
651: -- Insert the row into: ben_elig_per_f
652: --
653: hr_utility.set_location('Insert: '||l_proc, 5);
654: hr_utility.set_location('Ins EPO:'||l_proc, 5);
655: insert into ben_elig_per_opt_f
656: ( elig_per_opt_id,
657: elig_per_id,
658: effective_start_date,
659: effective_end_date,
995: --
996: -- Declare cursors and local variables
997: --
998: l_proc varchar2(72) := g_package||'update_Elig_Person_Option';
999: l_object_version_number ben_elig_per_opt_f.object_version_number%TYPE;
1000: l_effective_start_date ben_elig_per_opt_f.effective_start_date%TYPE;
1001: l_effective_end_date ben_elig_per_opt_f.effective_end_date%TYPE;
1002: --
1003: begin
996: -- Declare cursors and local variables
997: --
998: l_proc varchar2(72) := g_package||'update_Elig_Person_Option';
999: l_object_version_number ben_elig_per_opt_f.object_version_number%TYPE;
1000: l_effective_start_date ben_elig_per_opt_f.effective_start_date%TYPE;
1001: l_effective_end_date ben_elig_per_opt_f.effective_end_date%TYPE;
1002: --
1003: begin
1004: --
997: --
998: l_proc varchar2(72) := g_package||'update_Elig_Person_Option';
999: l_object_version_number ben_elig_per_opt_f.object_version_number%TYPE;
1000: l_effective_start_date ben_elig_per_opt_f.effective_start_date%TYPE;
1001: l_effective_end_date ben_elig_per_opt_f.effective_end_date%TYPE;
1002: --
1003: begin
1004: --
1005: hr_utility.set_location('Entering:'|| l_proc, 10);
1384: --
1385: -- Declare cursors and local variables
1386: --
1387: l_proc varchar2(72) := g_package||'update_Elig_Person_Option';
1388: l_object_version_number ben_elig_per_opt_f.object_version_number%TYPE;
1389: l_effective_start_date ben_elig_per_opt_f.effective_start_date%TYPE;
1390: l_effective_end_date ben_elig_per_opt_f.effective_end_date%TYPE;
1391: --
1392: begin
1385: -- Declare cursors and local variables
1386: --
1387: l_proc varchar2(72) := g_package||'update_Elig_Person_Option';
1388: l_object_version_number ben_elig_per_opt_f.object_version_number%TYPE;
1389: l_effective_start_date ben_elig_per_opt_f.effective_start_date%TYPE;
1390: l_effective_end_date ben_elig_per_opt_f.effective_end_date%TYPE;
1391: --
1392: begin
1393: --
1386: --
1387: l_proc varchar2(72) := g_package||'update_Elig_Person_Option';
1388: l_object_version_number ben_elig_per_opt_f.object_version_number%TYPE;
1389: l_effective_start_date ben_elig_per_opt_f.effective_start_date%TYPE;
1390: l_effective_end_date ben_elig_per_opt_f.effective_end_date%TYPE;
1391: --
1392: begin
1393: --
1394: hr_utility.set_location('Entering:'|| l_proc, 10);