1 Package ben_ecr_rkd as
2 /* $Header: beecrrhi.pkh 120.0 2005/05/28 01:53:27 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |----------------------------< after_delete >------------------------------|
6 -- ----------------------------------------------------------------------------
7 --
8 procedure after_delete
9 (
10 p_enrt_rt_id in number,
11 p_ordr_num_o in number,
12 p_acty_typ_cd_o in VARCHAR2,
13 p_tx_typ_cd_o in VARCHAR2,
14 p_ctfn_rqd_flag_o in VARCHAR2,
15 p_dflt_flag_o in VARCHAR2,
16 p_dflt_pndg_ctfn_flag_o in VARCHAR2,
17 p_dsply_on_enrt_flag_o in VARCHAR2,
18 p_use_to_calc_net_flx_cr_fla_o in VARCHAR2,
19 p_entr_val_at_enrt_flag_o in VARCHAR2,
20 p_asn_on_enrt_flag_o in VARCHAR2,
21 p_rl_crs_only_flag_o in VARCHAR2,
22 p_dflt_val_o in NUMBER,
23 p_ann_val_o in NUMBER,
24 p_ann_mn_elcn_val_o in NUMBER,
25 p_ann_mx_elcn_val_o in NUMBER,
26 p_val_o in NUMBER,
27 p_nnmntry_uom_o in VARCHAR2,
28 p_mx_elcn_val_o in NUMBER,
29 p_mn_elcn_val_o in NUMBER,
30 p_incrmt_elcn_val_o in NUMBER,
31 p_cmcd_acty_ref_perd_cd_o in VARCHAR2,
32 p_cmcd_mn_elcn_val_o in NUMBER,
33 p_cmcd_mx_elcn_val_o in NUMBER,
34 p_cmcd_val_o in NUMBER,
35 p_cmcd_dflt_val_o in NUMBER,
36 p_rt_usg_cd_o in VARCHAR2,
37 p_ann_dflt_val_o in NUMBER,
38 p_bnft_rt_typ_cd_o in VARCHAR2,
39 p_rt_mlt_cd_o in VARCHAR2,
40 p_dsply_mn_elcn_val_o in NUMBER,
41 p_dsply_mx_elcn_val_o in NUMBER,
42 p_entr_ann_val_flag_o in VARCHAR2,
43 p_rt_strt_dt_o in DATE,
44 p_rt_strt_dt_cd_o in VARCHAR2,
45 p_rt_strt_dt_rl_o in NUMBER,
46 p_rt_typ_cd_o in VARCHAR2,
47 p_elig_per_elctbl_chc_id_o in NUMBER,
48 p_acty_base_rt_id_o in NUMBER,
49 p_spcl_rt_enrt_rt_id_o in NUMBER,
50 p_enrt_bnft_id_o in NUMBER,
51 p_prtt_rt_val_id_o in NUMBER,
52 p_decr_bnft_prvdr_pool_id_o in NUMBER,
53 p_cvg_amt_calc_mthd_id_o in NUMBER,
54 p_actl_prem_id_o in NUMBER,
55 p_comp_lvl_fctr_id_o in NUMBER,
56 p_ptd_comp_lvl_fctr_id_o in NUMBER,
57 p_clm_comp_lvl_fctr_id_o in NUMBER,
58 p_business_group_id_o in NUMBER,
59 --cwb
60 p_iss_val_o in number,
61 p_val_last_upd_date_o in date,
62 p_val_last_upd_person_id_o in number,
63 --cwb
64 p_pp_in_yr_used_num_o in number ,
65 p_ecr_attribute_category_o in VARCHAR2,
66 p_ecr_attribute1_o in VARCHAR2,
67 p_ecr_attribute2_o in VARCHAR2,
68 p_ecr_attribute3_o in VARCHAR2,
69 p_ecr_attribute4_o in VARCHAR2,
70 p_ecr_attribute5_o in VARCHAR2,
71 p_ecr_attribute6_o in VARCHAR2,
72 p_ecr_attribute7_o in VARCHAR2,
73 p_ecr_attribute8_o in VARCHAR2,
74 p_ecr_attribute9_o in VARCHAR2,
75 p_ecr_attribute10_o in VARCHAR2,
76 p_ecr_attribute11_o in VARCHAR2,
77 p_ecr_attribute12_o in VARCHAR2,
78 p_ecr_attribute13_o in VARCHAR2,
79 p_ecr_attribute14_o in VARCHAR2,
80 p_ecr_attribute15_o in VARCHAR2,
81 p_ecr_attribute16_o in VARCHAR2,
82 p_ecr_attribute17_o in VARCHAR2,
83 p_ecr_attribute18_o in VARCHAR2,
84 p_ecr_attribute19_o in VARCHAR2,
85 p_ecr_attribute20_o in VARCHAR2,
86 p_ecr_attribute21_o in VARCHAR2,
87 p_ecr_attribute22_o in VARCHAR2,
88 p_ecr_attribute23_o in VARCHAR2,
89 p_ecr_attribute24_o in VARCHAR2,
90 p_ecr_attribute25_o in VARCHAR2,
91 p_ecr_attribute26_o in VARCHAR2,
92 p_ecr_attribute27_o in VARCHAR2,
93 p_ecr_attribute28_o in VARCHAR2,
94 p_ecr_attribute29_o in VARCHAR2,
95 p_ecr_attribute30_o in VARCHAR2,
96 p_last_update_login_o in NUMBER,
97 p_created_by_o in NUMBER,
98 p_creation_date_o in DATE,
99 p_last_updated_by_o in NUMBER,
100 p_last_update_date_o in DATE,
101 p_request_id_o in NUMBER,
102 p_program_application_id_o in NUMBER,
103 p_program_id_o in NUMBER,
104 p_program_update_date_o in DATE,
105 p_object_version_number_o in NUMBER
106 );
107 --
108 end ben_ecr_rkd;
[Home] [Help]