[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select full_name
from per_all_people_f per
,ben_per_in_ler pil
,ben_elig_per_elctbl_chc epe
where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
and epe.per_in_ler_id = pil.per_in_ler_id
and pil.person_id = per.person_id
and p_effective_date between per.EFFECTIVE_START_DATE and per.EFFECTIVE_END_DATE;
p_program_update_date in DATE DEFAULT NULL,
p_object_version_number out nocopy NUMBER,
p_effective_date in date
) is
--
-- Declare cursors and local variables
--
l_enrt_rt_id ben_enrt_rt.enrt_rt_id%TYPE;
,p_program_update_date => p_program_update_date
,p_effective_date => trunc(p_effective_date)
);
,p_program_update_date => p_program_update_date
,p_object_version_number => p_object_version_number
,p_effective_date => trunc(p_effective_date)
);
,p_program_update_date => p_program_update_date
,p_object_version_number => p_object_version_number
,p_effective_date => trunc(p_effective_date)
);
p_program_update_date in DATE DEFAULT NULL,
p_object_version_number out nocopy NUMBER,
p_effective_date in date
)
is
--
l_proc varchar2(72) := g_package||'create_perf_Enrollment_Rate';
l_last_update_date ben_enrt_rt.last_update_date%TYPE;
l_last_updated_by ben_enrt_rt.last_updated_by%TYPE;
l_last_update_login ben_enrt_rt.last_update_login%TYPE;
Cursor C_Sel1 is select ben_enrt_rt_s.nextval from sys.dual;
hr_utility.set_location('Insert ECR: '||l_proc, 5);
insert into ben_enrt_rt
(enrt_rt_id
,ordr_num
,acty_typ_cd
,tx_typ_cd
,ctfn_rqd_flag
,dflt_flag
,dflt_pndg_ctfn_flag
,dsply_on_enrt_flag
,use_to_calc_net_flx_cr_flag
,entr_val_at_enrt_flag
,asn_on_enrt_flag
,rl_crs_only_flag
,dflt_val
,ann_val
,ann_mn_elcn_val
,ann_mx_elcn_val
,val
,nnmntry_uom
,mx_elcn_val
,mn_elcn_val
,incrmt_elcn_val
,cmcd_acty_ref_perd_cd
,cmcd_mn_elcn_val
,cmcd_mx_elcn_val
,cmcd_val
,cmcd_dflt_val
,rt_usg_cd
,ann_dflt_val
,bnft_rt_typ_cd
,rt_mlt_cd
,dsply_mn_elcn_val
,dsply_mx_elcn_val
,entr_ann_val_flag
,rt_strt_dt
,rt_strt_dt_cd
,rt_strt_dt_rl
,rt_typ_cd
,elig_per_elctbl_chc_id
,acty_base_rt_id
,spcl_rt_enrt_rt_id
,enrt_bnft_id
,prtt_rt_val_id
,decr_bnft_prvdr_pool_id
,cvg_amt_calc_mthd_id
,actl_prem_id
,comp_lvl_fctr_id
,ptd_comp_lvl_fctr_id
,clm_comp_lvl_fctr_id
,business_group_id
--cwb
,iss_val
,val_last_upd_date
,val_last_upd_person_id
--cwb
,ecr_attribute_category
,ecr_attribute1
,ecr_attribute2
,ecr_attribute3
,ecr_attribute4
,ecr_attribute5
,ecr_attribute6
,ecr_attribute7
,ecr_attribute8
,ecr_attribute9
,ecr_attribute10
,ecr_attribute11
,ecr_attribute12
,ecr_attribute13
,ecr_attribute14
,ecr_attribute15
,ecr_attribute16
,ecr_attribute17
,ecr_attribute18
,ecr_attribute19
,ecr_attribute20
,ecr_attribute21
,ecr_attribute22
,ecr_attribute23
,ecr_attribute24
,ecr_attribute25
,ecr_attribute26
,ecr_attribute27
,ecr_attribute28
,ecr_attribute29
,ecr_attribute30
,last_update_login
,created_by
,creation_date
,last_updated_by
,last_update_date
,request_id
,program_application_id
,program_id
,program_update_date
,object_version_number
)
Values
(ben_enrt_rt_s.nextval
,p_ordr_num
,p_acty_typ_cd
,p_tx_typ_cd
,p_ctfn_rqd_flag
,p_dflt_flag
,p_dflt_pndg_ctfn_flag
,p_dsply_on_enrt_flag
,p_use_to_calc_net_flx_cr_flag
,p_entr_val_at_enrt_flag
,p_asn_on_enrt_flag
,p_rl_crs_only_flag
,p_dflt_val
,p_ann_val
,p_ann_mn_elcn_val
,p_ann_mx_elcn_val
,p_val
,p_nnmntry_uom
,p_mx_elcn_val
,p_mn_elcn_val
,p_incrmt_elcn_val
,p_cmcd_acty_ref_perd_cd
,p_cmcd_mn_elcn_val
,p_cmcd_mx_elcn_val
,p_cmcd_val
,p_cmcd_dflt_val
,p_rt_usg_cd
,p_ann_dflt_val
,p_bnft_rt_typ_cd
,p_rt_mlt_cd
,p_dsply_mn_elcn_val
,p_dsply_mx_elcn_val
,p_entr_ann_val_flag
,p_rt_strt_dt
,p_rt_strt_dt_cd
,p_rt_strt_dt_rl
,p_rt_typ_cd
,p_elig_per_elctbl_chc_id
,p_acty_base_rt_id
,p_spcl_rt_enrt_rt_id
,p_enrt_bnft_id
,p_prtt_rt_val_id
,p_decr_bnft_prvdr_pool_id
,p_cvg_amt_calc_mthd_id
,p_actl_prem_id
,p_comp_lvl_fctr_id
,p_ptd_comp_lvl_fctr_id
,p_clm_comp_lvl_fctr_id
,p_business_group_id
--cwb
,p_iss_val
,p_val_last_upd_date
,p_val_last_upd_person_id
--cwb
,p_ecr_attribute_category
,p_ecr_attribute1
,p_ecr_attribute2
,p_ecr_attribute3
,p_ecr_attribute4
,p_ecr_attribute5
,p_ecr_attribute6
,p_ecr_attribute7
,p_ecr_attribute8
,p_ecr_attribute9
,p_ecr_attribute10
,p_ecr_attribute11
,p_ecr_attribute12
,p_ecr_attribute13
,p_ecr_attribute14
,p_ecr_attribute15
,p_ecr_attribute16
,p_ecr_attribute17
,p_ecr_attribute18
,p_ecr_attribute19
,p_ecr_attribute20
,p_ecr_attribute21
,p_ecr_attribute22
,p_ecr_attribute23
,p_ecr_attribute24
,p_ecr_attribute25
,p_ecr_attribute26
,p_ecr_attribute27
,p_ecr_attribute28
,p_ecr_attribute29
,p_ecr_attribute30
,l_last_update_login
,l_created_by
,l_creation_date
,l_last_updated_by
,l_last_update_date
,p_request_id
,p_program_application_id
,p_program_id
,p_program_update_date
,l_object_version_number
) RETURNING enrt_rt_id into l_enrt_rt_id;
hr_utility.set_location('Dn Insert: '||l_proc, 5);
p_program_update_date in DATE DEFAULT hr_api.g_date,
p_object_version_number in out nocopy NUMBER,
p_effective_date in date
) IS
l_ann_val number := p_ann_val;
select
payroll_id
from
per_all_assignments_f ass
where
ass.person_id = p_person_id
and p_effective_date between ass.effective_start_date and ass.effective_end_date
and primary_flag = 'Y'
and assignment_type in ( 'E','B' ) ;
is select rate_periodization_rl
from ben_acty_base_rt_f abr
where abr.acty_base_rt_id = cv_acty_base_rt_id
and p_effective_date between abr.effective_start_date
and abr.effective_end_date ;
ben_Enrollment_Rate_api.update_Enrollment_Rate
(
p_validate => p_validate
,p_enrt_rt_id => p_enrt_rt_id
,p_ordr_num => p_ordr_num
,p_acty_typ_cd => p_acty_typ_cd
,p_tx_typ_cd => p_tx_typ_cd
,p_ctfn_rqd_flag => p_ctfn_rqd_flag
,p_dflt_flag => p_dflt_flag
,p_dflt_pndg_ctfn_flag => p_dflt_pndg_ctfn_flag
,p_dsply_on_enrt_flag => p_dsply_on_enrt_flag
,p_use_to_calc_net_flx_cr_flag => p_use_to_calc_net_flx_cr_flag
,p_entr_val_at_enrt_flag => p_entr_val_at_enrt_flag
,p_asn_on_enrt_flag => p_asn_on_enrt_flag
,p_rl_crs_only_flag => p_rl_crs_only_flag
,p_dflt_val => p_dflt_val
,p_ann_val => l_ann_val
,p_ann_mn_elcn_val => p_ann_mn_elcn_val
,p_ann_mx_elcn_val => p_ann_mx_elcn_val
,p_val => l_val
,p_nnmntry_uom => p_nnmntry_uom
,p_mx_elcn_val => p_mx_elcn_val
,p_mn_elcn_val => p_mn_elcn_val
,p_incrmt_elcn_val => p_incrmt_elcn_val
,p_cmcd_acty_ref_perd_cd => p_cmcd_acty_ref_perd_cd
,p_cmcd_mn_elcn_val => p_cmcd_mn_elcn_val
,p_cmcd_mx_elcn_val => p_cmcd_mx_elcn_val
,p_cmcd_val => l_cmcd_val
,p_cmcd_dflt_val => p_cmcd_dflt_val
,p_rt_usg_cd => p_rt_usg_cd
,p_ann_dflt_val => p_ann_dflt_val
,p_bnft_rt_typ_cd => p_bnft_rt_typ_cd
,p_rt_mlt_cd => p_rt_mlt_cd
,p_dsply_mn_elcn_val => p_dsply_mn_elcn_val
,p_dsply_mx_elcn_val => p_dsply_mx_elcn_val
,p_entr_ann_val_flag => p_entr_ann_val_flag
,p_rt_strt_dt => p_rt_strt_dt
,p_rt_strt_dt_cd => p_rt_strt_dt_cd
,p_rt_strt_dt_rl => p_rt_strt_dt_rl
,p_rt_typ_cd => p_rt_typ_cd
,p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id
,p_acty_base_rt_id => p_acty_base_rt_id
,p_spcl_rt_enrt_rt_id => p_spcl_rt_enrt_rt_id
,p_enrt_bnft_id => p_enrt_bnft_id
,p_prtt_rt_val_id => p_prtt_rt_val_id
,p_decr_bnft_prvdr_pool_id => p_decr_bnft_prvdr_pool_id
,p_cvg_amt_calc_mthd_id => p_cvg_amt_calc_mthd_id
,p_actl_prem_id => p_actl_prem_id
,p_comp_lvl_fctr_id => p_comp_lvl_fctr_id
,p_ptd_comp_lvl_fctr_id => p_ptd_comp_lvl_fctr_id
,p_clm_comp_lvl_fctr_id => p_clm_comp_lvl_fctr_id
,p_business_group_id => p_business_group_id
,p_perf_min_max_edit => p_perf_min_max_edit
,p_iss_val => p_iss_val
,p_val_last_upd_date => p_val_last_upd_date
,p_val_last_upd_person_id => p_val_last_upd_person_id
,p_ecr_attribute_category => p_ecr_attribute_category
,p_ecr_attribute1 => p_ecr_attribute1
,p_ecr_attribute2 => p_ecr_attribute2
,p_ecr_attribute3 => p_ecr_attribute3
,p_ecr_attribute4 => p_ecr_attribute4
,p_ecr_attribute5 => p_ecr_attribute5
,p_ecr_attribute6 => p_ecr_attribute6
,p_ecr_attribute7 => p_ecr_attribute7
,p_ecr_attribute8 => p_ecr_attribute8
,p_ecr_attribute9 => p_ecr_attribute9
,p_ecr_attribute10 => p_ecr_attribute10
,p_ecr_attribute11 => p_ecr_attribute11
,p_ecr_attribute12 => p_ecr_attribute12
,p_ecr_attribute13 => p_ecr_attribute13
,p_ecr_attribute14 => p_ecr_attribute14
,p_ecr_attribute15 => p_ecr_attribute15
,p_ecr_attribute16 => p_ecr_attribute16
,p_ecr_attribute17 => p_ecr_attribute17
,p_ecr_attribute18 => p_ecr_attribute18
,p_ecr_attribute19 => p_ecr_attribute19
,p_ecr_attribute20 => p_ecr_attribute20
,p_ecr_attribute21 => p_ecr_attribute21
,p_ecr_attribute22 => p_ecr_attribute22
,p_ecr_attribute23 => p_ecr_attribute23
,p_ecr_attribute24 => p_ecr_attribute24
,p_ecr_attribute25 => p_ecr_attribute25
,p_ecr_attribute26 => p_ecr_attribute26
,p_ecr_attribute27 => p_ecr_attribute27
,p_ecr_attribute28 => p_ecr_attribute28
,p_ecr_attribute29 => p_ecr_attribute29
,p_ecr_attribute30 => p_ecr_attribute30
,p_request_id => p_request_id
,p_program_application_id => p_program_application_id
,p_program_id => p_program_id
,p_program_update_date => p_program_update_date
,p_object_version_number => p_object_version_number
,p_effective_date => p_effective_date
);
procedure update_Enrollment_Rate
( p_validate in boolean default false,
p_enrt_rt_id in NUMBER,
p_ordr_num in number default hr_api.g_number,
p_acty_typ_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_tx_typ_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_ctfn_rqd_flag in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_dflt_flag in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_dflt_pndg_ctfn_flag in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_dsply_on_enrt_flag in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_use_to_calc_net_flx_cr_flag in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_entr_val_at_enrt_flag in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_asn_on_enrt_flag in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_rl_crs_only_flag in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_dflt_val in NUMBER DEFAULT hr_api.g_number,
p_ann_val in NUMBER DEFAULT hr_api.g_number,
p_ann_mn_elcn_val in NUMBER DEFAULT hr_api.g_number,
p_ann_mx_elcn_val in NUMBER DEFAULT hr_api.g_number,
p_val in NUMBER DEFAULT hr_api.g_number,
p_nnmntry_uom in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_mx_elcn_val in NUMBER DEFAULT hr_api.g_number,
p_mn_elcn_val in NUMBER DEFAULT hr_api.g_number,
p_incrmt_elcn_val in NUMBER DEFAULT hr_api.g_number,
p_cmcd_acty_ref_perd_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_cmcd_mn_elcn_val in NUMBER DEFAULT hr_api.g_number,
p_cmcd_mx_elcn_val in NUMBER DEFAULT hr_api.g_number,
p_cmcd_val in NUMBER DEFAULT hr_api.g_number,
p_cmcd_dflt_val in NUMBER DEFAULT hr_api.g_number,
p_rt_usg_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_ann_dflt_val in NUMBER DEFAULT hr_api.g_number,
p_bnft_rt_typ_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_rt_mlt_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_dsply_mn_elcn_val in NUMBER DEFAULT hr_api.g_number,
p_dsply_mx_elcn_val in NUMBER DEFAULT hr_api.g_number,
p_entr_ann_val_flag in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_rt_strt_dt in DATE DEFAULT hr_api.g_date,
p_rt_strt_dt_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_rt_strt_dt_rl in NUMBER DEFAULT hr_api.g_number,
p_rt_typ_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_elig_per_elctbl_chc_id in NUMBER DEFAULT hr_api.g_number,
p_acty_base_rt_id in NUMBER DEFAULT hr_api.g_number,
p_spcl_rt_enrt_rt_id in NUMBER DEFAULT hr_api.g_number,
p_enrt_bnft_id in NUMBER DEFAULT hr_api.g_number,
p_prtt_rt_val_id in NUMBER DEFAULT hr_api.g_number,
p_decr_bnft_prvdr_pool_id in NUMBER DEFAULT hr_api.g_number,
p_cvg_amt_calc_mthd_id in NUMBER DEFAULT hr_api.g_number,
p_actl_prem_id in NUMBER DEFAULT hr_api.g_number,
p_comp_lvl_fctr_id in NUMBER DEFAULT hr_api.g_number,
p_ptd_comp_lvl_fctr_id in NUMBER DEFAULT hr_api.g_number,
p_clm_comp_lvl_fctr_id in NUMBER DEFAULT hr_api.g_number,
p_business_group_id in NUMBER DEFAULT hr_api.g_number,
--cwb
p_perf_min_max_edit in VARCHAR2 DEFAULT NULL,
p_iss_val in number DEFAULT hr_api.g_number,
p_val_last_upd_date in date DEFAULT hr_api.g_date,
p_val_last_upd_person_id in number DEFAULT hr_api.g_number,
--cwb
p_pp_in_yr_used_num in number default hr_api.g_number,
p_ecr_attribute_category in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_ecr_attribute1 in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_ecr_attribute2 in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_ecr_attribute3 in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_ecr_attribute4 in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_ecr_attribute5 in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_ecr_attribute6 in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_ecr_attribute7 in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_ecr_attribute8 in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_ecr_attribute9 in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_ecr_attribute10 in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_ecr_attribute11 in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_ecr_attribute12 in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_ecr_attribute13 in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_ecr_attribute14 in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_ecr_attribute15 in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_ecr_attribute16 in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_ecr_attribute17 in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_ecr_attribute18 in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_ecr_attribute19 in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_ecr_attribute20 in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_ecr_attribute21 in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_ecr_attribute22 in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_ecr_attribute23 in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_ecr_attribute24 in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_ecr_attribute25 in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_ecr_attribute26 in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_ecr_attribute27 in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_ecr_attribute28 in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_ecr_attribute29 in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_ecr_attribute30 in VARCHAR2 DEFAULT hr_api.g_varchar2,
p_request_id in NUMBER DEFAULT hr_api.g_number,
p_program_application_id in NUMBER DEFAULT hr_api.g_number,
p_program_id in NUMBER DEFAULT hr_api.g_number,
p_program_update_date in DATE DEFAULT hr_api.g_date,
p_object_version_number in out nocopy NUMBER,
p_effective_date in date
) is
--
-- Declare cursors and local variables
--
cursor c_rate_vals is
select mx_elcn_val , mn_elcn_val , incrmt_elcn_val , elig_per_elctbl_chc_id
from ben_enrt_rt
where enrt_rt_id = p_enrt_rt_id ;
l_proc varchar2(72) := g_package||'update_Enrollment_Rate';
savepoint update_Enrollment_Rate;
ben_Enrollment_Rate_bk2.update_Enrollment_Rate_b
(
p_enrt_rt_id => p_enrt_rt_id
,p_ordr_num => p_ordr_num
,p_acty_typ_cd => p_acty_typ_cd
,p_tx_typ_cd => p_tx_typ_cd
,p_ctfn_rqd_flag => p_ctfn_rqd_flag
,p_dflt_flag => p_dflt_flag
,p_dflt_pndg_ctfn_flag => p_dflt_pndg_ctfn_flag
,p_dsply_on_enrt_flag => p_dsply_on_enrt_flag
,p_use_to_calc_net_flx_cr_flag => p_use_to_calc_net_flx_cr_flag
,p_entr_val_at_enrt_flag => p_entr_val_at_enrt_flag
,p_asn_on_enrt_flag => p_asn_on_enrt_flag
,p_rl_crs_only_flag => p_rl_crs_only_flag
,p_dflt_val => p_dflt_val
,p_ann_val => p_ann_val
,p_ann_mn_elcn_val => p_ann_mn_elcn_val
,p_ann_mx_elcn_val => p_ann_mx_elcn_val
,p_val => p_val
,p_nnmntry_uom => p_nnmntry_uom
,p_mx_elcn_val => p_mx_elcn_val
,p_mn_elcn_val => p_mn_elcn_val
,p_incrmt_elcn_val => p_incrmt_elcn_val
,p_cmcd_acty_ref_perd_cd => p_cmcd_acty_ref_perd_cd
,p_cmcd_mn_elcn_val => p_cmcd_mn_elcn_val
,p_cmcd_mx_elcn_val => p_cmcd_mx_elcn_val
,p_cmcd_val => p_cmcd_val
,p_cmcd_dflt_val => p_cmcd_dflt_val
,p_rt_usg_cd => p_rt_usg_cd
,p_ann_dflt_val => p_ann_dflt_val
,p_bnft_rt_typ_cd => p_bnft_rt_typ_cd
,p_rt_mlt_cd => p_rt_mlt_cd
,p_dsply_mn_elcn_val => p_dsply_mn_elcn_val
,p_dsply_mx_elcn_val => p_dsply_mx_elcn_val
,p_entr_ann_val_flag => p_entr_ann_val_flag
,p_rt_strt_dt => p_rt_strt_dt
,p_rt_strt_dt_cd => p_rt_strt_dt_cd
,p_rt_strt_dt_rl => p_rt_strt_dt_rl
,p_rt_typ_cd => p_rt_typ_cd
,p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id
,p_acty_base_rt_id => p_acty_base_rt_id
,p_spcl_rt_enrt_rt_id => p_spcl_rt_enrt_rt_id
,p_enrt_bnft_id => p_enrt_bnft_id
,p_prtt_rt_val_id => p_prtt_rt_val_id
,p_decr_bnft_prvdr_pool_id => p_decr_bnft_prvdr_pool_id
,p_cvg_amt_calc_mthd_id => p_cvg_amt_calc_mthd_id
,p_actl_prem_id => p_actl_prem_id
,p_comp_lvl_fctr_id => p_comp_lvl_fctr_id
,p_ptd_comp_lvl_fctr_id => p_ptd_comp_lvl_fctr_id
,p_clm_comp_lvl_fctr_id => p_clm_comp_lvl_fctr_id
,p_business_group_id => p_business_group_id
--cwb
,p_iss_val => p_iss_val
,p_val_last_upd_date => p_val_last_upd_date
,p_val_last_upd_person_id => p_val_last_upd_person_id
--cwb
,p_pp_in_yr_used_num => p_pp_in_yr_used_num
,p_ecr_attribute_category => p_ecr_attribute_category
,p_ecr_attribute1 => p_ecr_attribute1
,p_ecr_attribute2 => p_ecr_attribute2
,p_ecr_attribute3 => p_ecr_attribute3
,p_ecr_attribute4 => p_ecr_attribute4
,p_ecr_attribute5 => p_ecr_attribute5
,p_ecr_attribute6 => p_ecr_attribute6
,p_ecr_attribute7 => p_ecr_attribute7
,p_ecr_attribute8 => p_ecr_attribute8
,p_ecr_attribute9 => p_ecr_attribute9
,p_ecr_attribute10 => p_ecr_attribute10
,p_ecr_attribute11 => p_ecr_attribute11
,p_ecr_attribute12 => p_ecr_attribute12
,p_ecr_attribute13 => p_ecr_attribute13
,p_ecr_attribute14 => p_ecr_attribute14
,p_ecr_attribute15 => p_ecr_attribute15
,p_ecr_attribute16 => p_ecr_attribute16
,p_ecr_attribute17 => p_ecr_attribute17
,p_ecr_attribute18 => p_ecr_attribute18
,p_ecr_attribute19 => p_ecr_attribute19
,p_ecr_attribute20 => p_ecr_attribute20
,p_ecr_attribute21 => p_ecr_attribute21
,p_ecr_attribute22 => p_ecr_attribute22
,p_ecr_attribute23 => p_ecr_attribute23
,p_ecr_attribute24 => p_ecr_attribute24
,p_ecr_attribute25 => p_ecr_attribute25
,p_ecr_attribute26 => p_ecr_attribute26
,p_ecr_attribute27 => p_ecr_attribute27
,p_ecr_attribute28 => p_ecr_attribute28
,p_ecr_attribute29 => p_ecr_attribute29
,p_ecr_attribute30 => p_ecr_attribute30
,p_request_id => p_request_id
,p_program_application_id => p_program_application_id
,p_program_id => p_program_id
,p_program_update_date => p_program_update_date
,p_object_version_number => p_object_version_number
,p_effective_date => trunc(p_effective_date)
);
(p_module_name => 'UPDATE_Enrollment_Rate'
,p_hook_type => 'BP'
);
,p_program_update_date => p_program_update_date
,p_object_version_number => p_object_version_number
,p_effective_date => trunc(p_effective_date)
);
ben_Enrollment_Rate_bk2.update_Enrollment_Rate_a
(
p_enrt_rt_id => p_enrt_rt_id
,p_ordr_num => p_ordr_num
,p_acty_typ_cd => p_acty_typ_cd
,p_tx_typ_cd => p_tx_typ_cd
,p_ctfn_rqd_flag => p_ctfn_rqd_flag
,p_dflt_flag => p_dflt_flag
,p_dflt_pndg_ctfn_flag => p_dflt_pndg_ctfn_flag
,p_dsply_on_enrt_flag => p_dsply_on_enrt_flag
,p_use_to_calc_net_flx_cr_flag => p_use_to_calc_net_flx_cr_flag
,p_entr_val_at_enrt_flag => p_entr_val_at_enrt_flag
,p_asn_on_enrt_flag => p_asn_on_enrt_flag
,p_rl_crs_only_flag => p_rl_crs_only_flag
,p_dflt_val => p_dflt_val
,p_ann_val => p_ann_val
,p_ann_mn_elcn_val => p_ann_mn_elcn_val
,p_ann_mx_elcn_val => p_ann_mx_elcn_val
,p_val => p_val
,p_nnmntry_uom => p_nnmntry_uom
,p_mx_elcn_val => p_mx_elcn_val
,p_mn_elcn_val => p_mn_elcn_val
,p_incrmt_elcn_val => p_incrmt_elcn_val
,p_cmcd_acty_ref_perd_cd => p_cmcd_acty_ref_perd_cd
,p_cmcd_mn_elcn_val => p_cmcd_mn_elcn_val
,p_cmcd_mx_elcn_val => p_cmcd_mx_elcn_val
,p_cmcd_val => p_cmcd_val
,p_cmcd_dflt_val => p_cmcd_dflt_val
,p_rt_usg_cd => p_rt_usg_cd
,p_ann_dflt_val => p_ann_dflt_val
,p_bnft_rt_typ_cd => p_bnft_rt_typ_cd
,p_rt_mlt_cd => p_rt_mlt_cd
,p_dsply_mn_elcn_val => p_dsply_mn_elcn_val
,p_dsply_mx_elcn_val => p_dsply_mx_elcn_val
,p_entr_ann_val_flag => p_entr_ann_val_flag
,p_rt_strt_dt => p_rt_strt_dt
,p_rt_strt_dt_cd => p_rt_strt_dt_cd
,p_rt_strt_dt_rl => p_rt_strt_dt_rl
,p_rt_typ_cd => p_rt_typ_cd
,p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id
,p_acty_base_rt_id => p_acty_base_rt_id
,p_spcl_rt_enrt_rt_id => p_spcl_rt_enrt_rt_id
,p_enrt_bnft_id => p_enrt_bnft_id
,p_prtt_rt_val_id => p_prtt_rt_val_id
,p_decr_bnft_prvdr_pool_id => p_decr_bnft_prvdr_pool_id
,p_cvg_amt_calc_mthd_id => p_cvg_amt_calc_mthd_id
,p_actl_prem_id => p_actl_prem_id
,p_comp_lvl_fctr_id => p_comp_lvl_fctr_id
,p_ptd_comp_lvl_fctr_id => p_ptd_comp_lvl_fctr_id
,p_clm_comp_lvl_fctr_id => p_clm_comp_lvl_fctr_id
,p_business_group_id => p_business_group_id
--cwb
,p_iss_val => p_iss_val
,p_val_last_upd_date => p_val_last_upd_date
,p_val_last_upd_person_id => p_val_last_upd_person_id
--cwb
,p_pp_in_yr_used_num => p_pp_in_yr_used_num
,p_ecr_attribute_category => p_ecr_attribute_category
,p_ecr_attribute1 => p_ecr_attribute1
,p_ecr_attribute2 => p_ecr_attribute2
,p_ecr_attribute3 => p_ecr_attribute3
,p_ecr_attribute4 => p_ecr_attribute4
,p_ecr_attribute5 => p_ecr_attribute5
,p_ecr_attribute6 => p_ecr_attribute6
,p_ecr_attribute7 => p_ecr_attribute7
,p_ecr_attribute8 => p_ecr_attribute8
,p_ecr_attribute9 => p_ecr_attribute9
,p_ecr_attribute10 => p_ecr_attribute10
,p_ecr_attribute11 => p_ecr_attribute11
,p_ecr_attribute12 => p_ecr_attribute12
,p_ecr_attribute13 => p_ecr_attribute13
,p_ecr_attribute14 => p_ecr_attribute14
,p_ecr_attribute15 => p_ecr_attribute15
,p_ecr_attribute16 => p_ecr_attribute16
,p_ecr_attribute17 => p_ecr_attribute17
,p_ecr_attribute18 => p_ecr_attribute18
,p_ecr_attribute19 => p_ecr_attribute19
,p_ecr_attribute20 => p_ecr_attribute20
,p_ecr_attribute21 => p_ecr_attribute21 ,p_ecr_attribute22 => p_ecr_attribute22
,p_ecr_attribute23 => p_ecr_attribute23
,p_ecr_attribute24 => p_ecr_attribute24
,p_ecr_attribute25 => p_ecr_attribute25
,p_ecr_attribute26 => p_ecr_attribute26
,p_ecr_attribute27 => p_ecr_attribute27
,p_ecr_attribute28 => p_ecr_attribute28
,p_ecr_attribute29 => p_ecr_attribute29
,p_ecr_attribute30 => p_ecr_attribute30
,p_request_id => p_request_id
,p_program_application_id => p_program_application_id
,p_program_id => p_program_id
,p_program_update_date => p_program_update_date
,p_object_version_number => p_object_version_number
,p_effective_date => trunc(p_effective_date)
);
(p_module_name => 'UPDATE_Enrollment_Rate'
,p_hook_type => 'AP'
);
ROLLBACK TO update_Enrollment_Rate;
ROLLBACK TO update_Enrollment_Rate;
end update_Enrollment_Rate;
procedure delete_Enrollment_Rate
(p_validate in boolean default false
,p_enrt_rt_id in number
,p_object_version_number in out nocopy number
,p_effective_date in date
) is
--
-- Declare cursors and local variables
--
l_proc varchar2(72) := g_package||'update_Enrollment_Rate';
savepoint delete_Enrollment_Rate;
ben_Enrollment_Rate_bk3.delete_Enrollment_Rate_b
(
p_enrt_rt_id => p_enrt_rt_id
,p_object_version_number => p_object_version_number
,p_effective_date => trunc(p_effective_date)
);
(p_module_name => 'DELETE_Enrollment_Rate'
,p_hook_type => 'BP'
);
ben_Enrollment_Rate_bk3.delete_Enrollment_Rate_a
(
p_enrt_rt_id => p_enrt_rt_id
,p_object_version_number => l_object_version_number
,p_effective_date => trunc(p_effective_date)
);
(p_module_name => 'DELETE_Enrollment_Rate'
,p_hook_type => 'AP'
);
ROLLBACK TO delete_Enrollment_Rate;
ROLLBACK TO delete_Enrollment_Rate;
end delete_Enrollment_Rate;