1 Package ben_ecr_rku as
2 /* $Header: beecrrhi.pkh 120.0 2005/05/28 01:53:27 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |----------------------------< after_update >------------------------------|
6 -- ----------------------------------------------------------------------------
7 --
8 procedure after_update
9 (
10 p_enrt_rt_id in NUMBER,
11 p_ordr_num in number,
12 p_acty_typ_cd in VARCHAR2,
13 p_tx_typ_cd in VARCHAR2,
14 p_ctfn_rqd_flag in VARCHAR2,
15 p_dflt_flag in VARCHAR2,
16 p_dflt_pndg_ctfn_flag in VARCHAR2,
17 p_dsply_on_enrt_flag in VARCHAR2,
18 p_use_to_calc_net_flx_cr_flag in VARCHAR2,
19 p_entr_val_at_enrt_flag in VARCHAR2,
20 p_asn_on_enrt_flag in VARCHAR2,
21 p_rl_crs_only_flag in VARCHAR2,
22 p_dflt_val in NUMBER,
23 p_ann_val in NUMBER,
24 p_ann_mn_elcn_val in NUMBER,
25 p_ann_mx_elcn_val in NUMBER,
26 p_val in NUMBER,
27 p_nnmntry_uom in VARCHAR2,
28 p_mx_elcn_val in NUMBER,
29 p_mn_elcn_val in NUMBER,
30 p_incrmt_elcn_val in NUMBER,
31 p_cmcd_acty_ref_perd_cd in VARCHAR2,
32 p_cmcd_mn_elcn_val in NUMBER,
33 p_cmcd_mx_elcn_val in NUMBER,
34 p_cmcd_val in NUMBER,
35 p_cmcd_dflt_val in NUMBER,
36 p_rt_usg_cd in VARCHAR2,
37 p_ann_dflt_val in NUMBER,
38 p_bnft_rt_typ_cd in VARCHAR2,
39 p_rt_mlt_cd in VARCHAR2,
40 p_dsply_mn_elcn_val in NUMBER,
41 p_dsply_mx_elcn_val in NUMBER,
42 p_entr_ann_val_flag in VARCHAR2,
43 p_rt_strt_dt in DATE,
44 p_rt_strt_dt_cd in VARCHAR2,
45 p_rt_strt_dt_rl in NUMBER,
46 p_rt_typ_cd in VARCHAR2,
47 p_elig_per_elctbl_chc_id in NUMBER,
48 p_acty_base_rt_id in NUMBER,
49 p_spcl_rt_enrt_rt_id in NUMBER,
50 p_enrt_bnft_id in NUMBER,
51 p_prtt_rt_val_id in NUMBER,
52 p_decr_bnft_prvdr_pool_id in NUMBER,
53 p_cvg_amt_calc_mthd_id in NUMBER,
54 p_actl_prem_id in NUMBER,
55 p_comp_lvl_fctr_id in NUMBER,
56 p_ptd_comp_lvl_fctr_id in NUMBER,
57 p_clm_comp_lvl_fctr_id in NUMBER,
58 p_business_group_id in NUMBER,
59 --cwb
60 p_iss_val in number,
61 p_val_last_upd_date in date,
62 p_val_last_upd_person_id in number,
63 --cwb
64 p_pp_in_yr_used_num in number ,
65 p_ecr_attribute_category in VARCHAR2,
66 p_ecr_attribute1 in VARCHAR2,
67 p_ecr_attribute2 in VARCHAR2,
68 p_ecr_attribute3 in VARCHAR2,
69 p_ecr_attribute4 in VARCHAR2,
70 p_ecr_attribute5 in VARCHAR2,
71 p_ecr_attribute6 in VARCHAR2,
72 p_ecr_attribute7 in VARCHAR2,
73 p_ecr_attribute8 in VARCHAR2,
74 p_ecr_attribute9 in VARCHAR2,
75 p_ecr_attribute10 in VARCHAR2,
76 p_ecr_attribute11 in VARCHAR2,
77 p_ecr_attribute12 in VARCHAR2,
78 p_ecr_attribute13 in VARCHAR2,
79 p_ecr_attribute14 in VARCHAR2,
80 p_ecr_attribute15 in VARCHAR2,
81 p_ecr_attribute16 in VARCHAR2,
82 p_ecr_attribute17 in VARCHAR2,
83 p_ecr_attribute18 in VARCHAR2,
84 p_ecr_attribute19 in VARCHAR2,
85 p_ecr_attribute20 in VARCHAR2,
86 p_ecr_attribute21 in VARCHAR2,
87 p_ecr_attribute22 in VARCHAR2,
88 p_ecr_attribute23 in VARCHAR2,
89 p_ecr_attribute24 in VARCHAR2,
90 p_ecr_attribute25 in VARCHAR2,
91 p_ecr_attribute26 in VARCHAR2,
92 p_ecr_attribute27 in VARCHAR2,
93 p_ecr_attribute28 in VARCHAR2,
94 p_ecr_attribute29 in VARCHAR2,
95 p_ecr_attribute30 in VARCHAR2,
96 p_last_update_login in NUMBER,
97 p_created_by in NUMBER,
98 p_creation_date in DATE,
99 p_last_updated_by in NUMBER,
100 p_last_update_date in DATE,
101 p_request_id in NUMBER,
102 p_program_application_id in NUMBER,
103 p_program_id in NUMBER,
104 p_program_update_date in DATE,
105 p_object_version_number in NUMBER,
106 p_effective_date in date,
107 p_ordr_num_o in number,
108 p_acty_typ_cd_o in VARCHAR2,
109 p_tx_typ_cd_o in VARCHAR2,
110 p_ctfn_rqd_flag_o in VARCHAR2,
111 p_dflt_flag_o in VARCHAR2,
112 p_dflt_pndg_ctfn_flag_o in VARCHAR2,
113 p_dsply_on_enrt_flag_o in VARCHAR2,
114 p_use_to_calc_net_flx_cr_fla_o in VARCHAR2,
115 p_entr_val_at_enrt_flag_o in VARCHAR2,
116 p_asn_on_enrt_flag_o in VARCHAR2,
117 p_rl_crs_only_flag_o in VARCHAR2,
118 p_dflt_val_o in NUMBER,
119 p_ann_val_o in NUMBER,
120 p_ann_mn_elcn_val_o in NUMBER,
121 p_ann_mx_elcn_val_o in NUMBER,
122 p_val_o in NUMBER,
123 p_nnmntry_uom_o in VARCHAR2,
124 p_mx_elcn_val_o in NUMBER,
125 p_mn_elcn_val_o in NUMBER,
126 p_incrmt_elcn_val_o in NUMBER,
127 p_cmcd_acty_ref_perd_cd_o in VARCHAR2,
128 p_cmcd_mn_elcn_val_o in NUMBER,
129 p_cmcd_mx_elcn_val_o in NUMBER,
130 p_cmcd_val_o in NUMBER,
131 p_cmcd_dflt_val_o in NUMBER,
132 p_rt_usg_cd_o in VARCHAR2,
133 p_ann_dflt_val_o in NUMBER,
134 p_bnft_rt_typ_cd_o in VARCHAR2,
135 p_rt_mlt_cd_o in VARCHAR2,
136 p_dsply_mn_elcn_val_o in NUMBER,
137 p_dsply_mx_elcn_val_o in NUMBER,
138 p_entr_ann_val_flag_o in VARCHAR2,
139 p_rt_strt_dt_o in DATE,
140 p_rt_strt_dt_cd_o in VARCHAR2,
141 p_rt_strt_dt_rl_o in NUMBER,
142 p_rt_typ_cd_o in VARCHAR2,
143 p_elig_per_elctbl_chc_id_o in NUMBER,
144 p_acty_base_rt_id_o in NUMBER,
145 p_spcl_rt_enrt_rt_id_o in NUMBER,
146 p_enrt_bnft_id_o in NUMBER,
147 p_prtt_rt_val_id_o in NUMBER,
148 p_decr_bnft_prvdr_pool_id_o in NUMBER,
149 p_cvg_amt_calc_mthd_id_o in NUMBER,
150 p_actl_prem_id_o in NUMBER,
151 p_comp_lvl_fctr_id_o in NUMBER,
152 p_ptd_comp_lvl_fctr_id_o in NUMBER,
153 p_clm_comp_lvl_fctr_id_o in NUMBER,
154 p_business_group_id_o in NUMBER,
155 --cwb
156 p_iss_val_o in number,
157 p_val_last_upd_date_o in date,
158 p_val_last_upd_person_id_o in number,
159 --cwb
160 p_pp_in_yr_used_num_o in number,
161 p_ecr_attribute_category_o in VARCHAR2,
162 p_ecr_attribute1_o in VARCHAR2,
163 p_ecr_attribute2_o in VARCHAR2,
164 p_ecr_attribute3_o in VARCHAR2,
165 p_ecr_attribute4_o in VARCHAR2,
166 p_ecr_attribute5_o in VARCHAR2,
167 p_ecr_attribute6_o in VARCHAR2,
168 p_ecr_attribute7_o in VARCHAR2,
169 p_ecr_attribute8_o in VARCHAR2,
170 p_ecr_attribute9_o in VARCHAR2,
171 p_ecr_attribute10_o in VARCHAR2,
172 p_ecr_attribute11_o in VARCHAR2,
173 p_ecr_attribute12_o in VARCHAR2,
174 p_ecr_attribute13_o in VARCHAR2,
175 p_ecr_attribute14_o in VARCHAR2,
176 p_ecr_attribute15_o in VARCHAR2,
177 p_ecr_attribute16_o in VARCHAR2,
178 p_ecr_attribute17_o in VARCHAR2,
179 p_ecr_attribute18_o in VARCHAR2,
180 p_ecr_attribute19_o in VARCHAR2,
181 p_ecr_attribute20_o in VARCHAR2,
182 p_ecr_attribute21_o in VARCHAR2,
183 p_ecr_attribute22_o in VARCHAR2,
184 p_ecr_attribute23_o in VARCHAR2,
185 p_ecr_attribute24_o in VARCHAR2,
186 p_ecr_attribute25_o in VARCHAR2,
187 p_ecr_attribute26_o in VARCHAR2,
188 p_ecr_attribute27_o in VARCHAR2,
189 p_ecr_attribute28_o in VARCHAR2,
190 p_ecr_attribute29_o in VARCHAR2,
191 p_ecr_attribute30_o in VARCHAR2,
192 p_last_update_login_o in NUMBER,
193 p_created_by_o in NUMBER,
194 p_creation_date_o in DATE,
195 p_last_updated_by_o in NUMBER,
196 p_last_update_date_o in DATE,
197 p_request_id_o in NUMBER,
198 p_program_application_id_o in NUMBER,
199 p_program_id_o in NUMBER,
200 p_program_update_date_o in DATE,
201 p_object_version_number_o in NUMBER
202 );
203 --
204 end ben_ecr_rku;