137: ) is
138: --
139: -- Declare cursors and local variables
140: --
141: l_cvrd_dpnt_ctfn_prvdd_id ben_cvrd_dpnt_ctfn_prvdd_f.cvrd_dpnt_ctfn_prvdd_id%TYPE;
142: l_effective_start_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_start_date%TYPE;
143: l_effective_end_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_end_date%TYPE;
144: l_proc varchar2(72) := g_package||'create_CVRD_DPNT_CTFN_PRVDD';
145: l_object_version_number ben_cvrd_dpnt_ctfn_prvdd_f.object_version_number%TYPE;
138: --
139: -- Declare cursors and local variables
140: --
141: l_cvrd_dpnt_ctfn_prvdd_id ben_cvrd_dpnt_ctfn_prvdd_f.cvrd_dpnt_ctfn_prvdd_id%TYPE;
142: l_effective_start_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_start_date%TYPE;
143: l_effective_end_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_end_date%TYPE;
144: l_proc varchar2(72) := g_package||'create_CVRD_DPNT_CTFN_PRVDD';
145: l_object_version_number ben_cvrd_dpnt_ctfn_prvdd_f.object_version_number%TYPE;
146: l_prtt_enrt_actn_id ben_prtt_enrt_actn_f.prtt_enrt_actn_id%type;
139: -- Declare cursors and local variables
140: --
141: l_cvrd_dpnt_ctfn_prvdd_id ben_cvrd_dpnt_ctfn_prvdd_f.cvrd_dpnt_ctfn_prvdd_id%TYPE;
142: l_effective_start_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_start_date%TYPE;
143: l_effective_end_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_end_date%TYPE;
144: l_proc varchar2(72) := g_package||'create_CVRD_DPNT_CTFN_PRVDD';
145: l_object_version_number ben_cvrd_dpnt_ctfn_prvdd_f.object_version_number%TYPE;
146: l_prtt_enrt_actn_id ben_prtt_enrt_actn_f.prtt_enrt_actn_id%type;
147: l_prtt_enrt_rslt_id ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%type;
141: l_cvrd_dpnt_ctfn_prvdd_id ben_cvrd_dpnt_ctfn_prvdd_f.cvrd_dpnt_ctfn_prvdd_id%TYPE;
142: l_effective_start_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_start_date%TYPE;
143: l_effective_end_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_end_date%TYPE;
144: l_proc varchar2(72) := g_package||'create_CVRD_DPNT_CTFN_PRVDD';
145: l_object_version_number ben_cvrd_dpnt_ctfn_prvdd_f.object_version_number%TYPE;
146: l_prtt_enrt_actn_id ben_prtt_enrt_actn_f.prtt_enrt_actn_id%type;
147: l_prtt_enrt_rslt_id ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%type;
148: --
149: cursor c_pdp is
479: --
480: -- Declare cursors and local variables
481: --
482: l_proc varchar2(72) := g_package||'update_CVRD_DPNT_CTFN_PRVDD';
483: l_object_version_number ben_cvrd_dpnt_ctfn_prvdd_f.object_version_number%TYPE;
484: l_effective_start_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_start_date%TYPE;
485: l_effective_end_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_end_date%TYPE;
486: --
487: begin
480: -- Declare cursors and local variables
481: --
482: l_proc varchar2(72) := g_package||'update_CVRD_DPNT_CTFN_PRVDD';
483: l_object_version_number ben_cvrd_dpnt_ctfn_prvdd_f.object_version_number%TYPE;
484: l_effective_start_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_start_date%TYPE;
485: l_effective_end_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_end_date%TYPE;
486: --
487: begin
488: --
481: --
482: l_proc varchar2(72) := g_package||'update_CVRD_DPNT_CTFN_PRVDD';
483: l_object_version_number ben_cvrd_dpnt_ctfn_prvdd_f.object_version_number%TYPE;
484: l_effective_start_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_start_date%TYPE;
485: l_effective_end_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_end_date%TYPE;
486: --
487: begin
488: --
489: hr_utility.set_location('Entering:'|| l_proc, 10);
760: --
761: -- Declare cursors and local variables
762: --
763: l_proc varchar2(72) := g_package||'delete_CVRD_DPNT_CTFN_PRVDD';
764: l_object_version_number ben_cvrd_dpnt_ctfn_prvdd_f.object_version_number%TYPE;
765: l_effective_start_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_start_date%TYPE;
766: l_effective_end_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_end_date%TYPE;
767: --
768: l_prtt_enrt_actn_id number(15) := null;
761: -- Declare cursors and local variables
762: --
763: l_proc varchar2(72) := g_package||'delete_CVRD_DPNT_CTFN_PRVDD';
764: l_object_version_number ben_cvrd_dpnt_ctfn_prvdd_f.object_version_number%TYPE;
765: l_effective_start_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_start_date%TYPE;
766: l_effective_end_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_end_date%TYPE;
767: --
768: l_prtt_enrt_actn_id number(15) := null;
769: l_prtt_enrt_rslt_id number(15);
762: --
763: l_proc varchar2(72) := g_package||'delete_CVRD_DPNT_CTFN_PRVDD';
764: l_object_version_number ben_cvrd_dpnt_ctfn_prvdd_f.object_version_number%TYPE;
765: l_effective_start_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_start_date%TYPE;
766: l_effective_end_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_end_date%TYPE;
767: --
768: l_prtt_enrt_actn_id number(15) := null;
769: l_prtt_enrt_rslt_id number(15);
770: l_rslt_object_version_number number(15);
774: l1_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;
775: --
776: cursor get_actn_c is
777: select prtt_enrt_actn_id
778: from ben_cvrd_dpnt_ctfn_prvdd_f
779: where cvrd_dpnt_ctfn_prvdd_id = p_cvrd_dpnt_ctfn_prvdd_id
780: and business_group_id = p_business_group_id
781: and p_effective_date between effective_start_date
782: and effective_end_date;
782: and effective_end_date;
783: --
784: cursor more_ctfn_c is
785: select 'Y'
786: from ben_cvrd_dpnt_ctfn_prvdd_f
787: where prtt_enrt_actn_id = l_prtt_enrt_actn_id
788: and business_group_id = p_business_group_id
789: and p_effective_date + 1 between effective_start_date
790: and effective_end_date;
1004: --
1005: -- Declare cursors and local variables
1006: --
1007: l_proc varchar2(72) := g_package||'delete_CVRD_DPNT_CTFN_PRVDD';
1008: l_object_version_number ben_cvrd_dpnt_ctfn_prvdd_f.object_version_number%TYPE;
1009: l_effective_start_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_start_date%TYPE;
1010: l_effective_end_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_end_date%TYPE;
1011: --
1012: l_prtt_enrt_actn_id number(15) := null;
1005: -- Declare cursors and local variables
1006: --
1007: l_proc varchar2(72) := g_package||'delete_CVRD_DPNT_CTFN_PRVDD';
1008: l_object_version_number ben_cvrd_dpnt_ctfn_prvdd_f.object_version_number%TYPE;
1009: l_effective_start_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_start_date%TYPE;
1010: l_effective_end_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_end_date%TYPE;
1011: --
1012: l_prtt_enrt_actn_id number(15) := null;
1013: l_prtt_enrt_rslt_id number(15);
1006: --
1007: l_proc varchar2(72) := g_package||'delete_CVRD_DPNT_CTFN_PRVDD';
1008: l_object_version_number ben_cvrd_dpnt_ctfn_prvdd_f.object_version_number%TYPE;
1009: l_effective_start_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_start_date%TYPE;
1010: l_effective_end_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_end_date%TYPE;
1011: --
1012: l_prtt_enrt_actn_id number(15) := null;
1013: l_prtt_enrt_rslt_id number(15);
1014: l_rslt_object_version_number number(15);
1018: l1_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;
1019: --
1020: cursor get_actn_c is
1021: select prtt_enrt_actn_id
1022: from ben_cvrd_dpnt_ctfn_prvdd_f
1023: where cvrd_dpnt_ctfn_prvdd_id = p_cvrd_dpnt_ctfn_prvdd_id
1024: and business_group_id = p_business_group_id
1025: and p_effective_date between effective_start_date
1026: and effective_end_date;
1026: and effective_end_date;
1027: --
1028: cursor more_ctfn_c is
1029: select 'Y'
1030: from ben_cvrd_dpnt_ctfn_prvdd_f
1031: where prtt_enrt_actn_id = l_prtt_enrt_actn_id
1032: and business_group_id = p_business_group_id
1033: and p_effective_date + 1 between effective_start_date
1034: and effective_end_date;