1 Package ben_ecr_rki as
2 /* $Header: beecrrhi.pkh 120.0 2005/05/28 01:53:27 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |-----------------------------< after_insert >-----------------------------|
6 -- ----------------------------------------------------------------------------
7 --
8 procedure after_insert
9 (
10 p_effective_date in date,
11 p_enrt_rt_id in NUMBER,
12 p_ordr_num in number,
13 p_acty_typ_cd in VARCHAR2,
14 p_tx_typ_cd in VARCHAR2,
15 p_ctfn_rqd_flag in VARCHAR2,
16 p_dflt_flag in VARCHAR2,
17 p_dflt_pndg_ctfn_flag in VARCHAR2,
18 p_dsply_on_enrt_flag in VARCHAR2,
19 p_use_to_calc_net_flx_cr_flag in VARCHAR2,
20 p_entr_val_at_enrt_flag in VARCHAR2,
21 p_asn_on_enrt_flag in VARCHAR2,
22 p_rl_crs_only_flag in VARCHAR2,
23 p_dflt_val in NUMBER,
24 p_ann_val in NUMBER,
25 p_ann_mn_elcn_val in NUMBER,
26 p_ann_mx_elcn_val in NUMBER,
27 p_val in NUMBER,
28 p_nnmntry_uom in VARCHAR2,
29 p_mx_elcn_val in NUMBER,
30 p_mn_elcn_val in NUMBER,
31 p_incrmt_elcn_val in NUMBER,
32 p_cmcd_acty_ref_perd_cd in VARCHAR2,
33 p_cmcd_mn_elcn_val in NUMBER,
34 p_cmcd_mx_elcn_val in NUMBER,
35 p_cmcd_val in NUMBER,
36 p_cmcd_dflt_val in NUMBER,
37 p_rt_usg_cd in VARCHAR2,
38 p_ann_dflt_val in NUMBER,
39 p_bnft_rt_typ_cd in VARCHAR2,
40 p_rt_mlt_cd in VARCHAR2,
41 p_dsply_mn_elcn_val in NUMBER,
42 p_dsply_mx_elcn_val in NUMBER,
43 p_entr_ann_val_flag in VARCHAR2,
44 p_rt_strt_dt in DATE,
45 p_rt_strt_dt_cd in VARCHAR2,
46 p_rt_strt_dt_rl in NUMBER,
47 p_rt_typ_cd in VARCHAR2,
48 p_elig_per_elctbl_chc_id in NUMBER,
49 p_acty_base_rt_id in NUMBER,
50 p_spcl_rt_enrt_rt_id in NUMBER,
51 p_enrt_bnft_id in NUMBER,
52 p_prtt_rt_val_id in NUMBER,
53 p_decr_bnft_prvdr_pool_id in NUMBER,
54 p_cvg_amt_calc_mthd_id in NUMBER,
55 p_actl_prem_id in NUMBER,
56 p_comp_lvl_fctr_id in NUMBER,
57 p_ptd_comp_lvl_fctr_id in NUMBER,
58 p_clm_comp_lvl_fctr_id in NUMBER,
59 p_business_group_id in NUMBER,
60 --cwb
61 p_iss_val in number,
62 p_val_last_upd_date in date,
63 p_val_last_upd_person_id in number,
64 --cwb
65 p_pp_in_yr_used_num in number,
66 p_ecr_attribute_category in VARCHAR2,
67 p_ecr_attribute1 in VARCHAR2,
68 p_ecr_attribute2 in VARCHAR2,
69 p_ecr_attribute3 in VARCHAR2,
70 p_ecr_attribute4 in VARCHAR2,
71 p_ecr_attribute5 in VARCHAR2,
72 p_ecr_attribute6 in VARCHAR2,
73 p_ecr_attribute7 in VARCHAR2,
74 p_ecr_attribute8 in VARCHAR2,
75 p_ecr_attribute9 in VARCHAR2,
76 p_ecr_attribute10 in VARCHAR2,
77 p_ecr_attribute11 in VARCHAR2,
78 p_ecr_attribute12 in VARCHAR2,
79 p_ecr_attribute13 in VARCHAR2,
80 p_ecr_attribute14 in VARCHAR2,
81 p_ecr_attribute15 in VARCHAR2,
82 p_ecr_attribute16 in VARCHAR2,
83 p_ecr_attribute17 in VARCHAR2,
84 p_ecr_attribute18 in VARCHAR2,
85 p_ecr_attribute19 in VARCHAR2,
86 p_ecr_attribute20 in VARCHAR2,
87 p_ecr_attribute21 in VARCHAR2,
88 p_ecr_attribute22 in VARCHAR2,
89 p_ecr_attribute23 in VARCHAR2,
90 p_ecr_attribute24 in VARCHAR2,
91 p_ecr_attribute25 in VARCHAR2,
92 p_ecr_attribute26 in VARCHAR2,
93 p_ecr_attribute27 in VARCHAR2,
94 p_ecr_attribute28 in VARCHAR2,
95 p_ecr_attribute29 in VARCHAR2,
96 p_ecr_attribute30 in VARCHAR2,
97 p_last_update_login in NUMBER,
98 p_created_by in NUMBER,
99 p_creation_date in DATE,
100 p_last_updated_by in NUMBER,
101 p_last_update_date in DATE,
102 p_request_id in NUMBER,
103 p_program_application_id in NUMBER,
104 p_program_id in NUMBER,
105 p_program_update_date in DATE,
106 p_object_version_number in NUMBER
107 );
108 end ben_ecr_rki;
[Home] [Help]