1 Package ben_pd_rate_and_cvg_module AUTHID CURRENT_USER as
2 /* $Header: bepdcrtc.pkh 115.7 2004/01/13 11:45:26 rpillay noship $ */
3 --
4 procedure create_rate_results
5 (
6 p_validate in number default 0 -- false
7 ,p_copy_entity_result_id in number -- Source Elpro
8 ,p_copy_entity_txn_id in number default null
9 ,p_pgm_id in number default null
10 ,p_ptip_id in number default null
11 ,p_plip_id in number default null
12 ,p_pl_id in number default null
13 ,p_oipl_id in number default null
14 ,p_oiplip_id in number default null
15 ,p_cmbn_plip_id in number default null
16 ,p_cmbn_ptip_id in number default null
17 ,p_cmbn_ptip_opt_id in number default null
18 ,p_business_group_id in number default null
19 ,p_number_of_copies in number default 0
20 ,p_object_version_number out nocopy number
21 ,p_effective_date in date
22 ,p_parent_entity_result_id in number
23 --
24 ,p_opt_id in number default null
25 --
26 ) ;
27 --
28 procedure create_coverage_results
29 (
30 p_validate in number default 0 -- false
31 ,p_copy_entity_result_id in number
32 ,p_copy_entity_txn_id in number default null
33 ,p_plip_id in number default null
34 ,p_pl_id in number default null
35 ,p_oipl_id in number default null
36 ,p_business_group_id in number default null
37 ,p_number_of_copies in number default 0
38 ,p_object_version_number out nocopy number
39 ,p_effective_date in date
40 ,p_parent_entity_result_id in number
41 ) ;
42 --
43 procedure create_premium_results
44 (
45 p_validate in number default 0 -- false
46 ,p_copy_entity_result_id in number
47 ,p_copy_entity_txn_id in number default null
48 ,p_pl_id in number default null
49 ,p_oipl_id in number default null
50 ,p_business_group_id in number default null
51 ,p_number_of_copies in number default 0
52 ,p_object_version_number out nocopy number
53 ,p_effective_date in date
54 ,p_parent_entity_result_id in number
55 ) ;
56 --
57 procedure create_drpar_results
58 (
59 p_validate in number default 0 -- false
60 ,p_copy_entity_result_id in number -- Source Elpro
61 ,p_copy_entity_txn_id in number default null
62 ,p_comp_lvl_fctr_id in number default null
63 ,p_hrs_wkd_in_perd_fctr_id in number default null
64 ,p_los_fctr_id in number default null
65 ,p_pct_fl_tm_fctr_id in number default null
66 ,p_age_fctr_id in number default null
67 ,p_cmbn_age_los_fctr_id in number default null
68 ,p_business_group_id in number default null
69 ,p_number_of_copies in number default 0
70 ,p_object_version_number out nocopy number
71 ,p_effective_date in date
72 ,p_no_dup_rslt in varchar2 default null
73 ) ;
74 --
75 procedure create_vapro_results
76 (
77 p_validate in number default 0 -- false
78 ,p_copy_entity_result_id in number -- Source Elpro
79 ,p_copy_entity_txn_id in number default null
80 ,p_vrbl_rt_prfl_id in number default null
81 ,p_business_group_id in number default null
82 ,p_number_of_copies in number default 0
83 ,p_object_version_number out nocopy number
84 ,p_effective_date in date
85 ,p_parent_entity_result_id in number
86 ,p_no_dup_rslt in varchar2 default null
87 ) ;
88 --
89 procedure create_bnft_pool_results
90 (
91 p_validate in number default 0 -- false
92 ,p_copy_entity_result_id in number -- Source Elpro
93 ,p_copy_entity_txn_id in number default null
94 ,p_pgm_id in number default null
95 ,p_ptip_id in number default null
96 ,p_plip_id in number default null
97 ,p_oiplip_id in number default null
98 ,p_cmbn_plip_id in number default null
99 ,p_cmbn_ptip_id in number default null
100 ,p_cmbn_ptip_opt_id in number default null
101 ,p_business_group_id in number default null
102 ,p_number_of_copies in number default 0
103 ,p_object_version_number out nocopy number
104 ,p_effective_date in date
105 ,p_parent_entity_result_id in number
106 ) ;
107 --
108 procedure create_service_results
109 (
110 p_validate in number default 0 -- false
111 ,p_copy_entity_result_id in number -- Source Elpro
112 ,p_copy_entity_txn_id in number default null
113 ,p_svc_area_id in number
114 ,p_business_group_id in number default null
115 ,p_number_of_copies in number default 0
116 ,p_object_version_number out nocopy number
117 ,p_effective_date in date
118 ) ;
119 --
120 procedure create_postal_results
121 (
122 p_validate in number default 0 -- false
123 ,p_copy_entity_result_id in number -- Source Elpro
124 ,p_copy_entity_txn_id in number default null
125 ,p_pstl_zip_rng_id in number
126 ,p_business_group_id in number default null
127 ,p_number_of_copies in number default 0
128 ,p_object_version_number out nocopy number
129 ,p_effective_date in date
130 ) ;
131 --
132 procedure create_bnft_bal_results
133 (
134 p_validate in number default 0 -- false
135 ,p_copy_entity_result_id in number -- Source Elpro
136 ,p_copy_entity_txn_id in number default null
137 ,p_bnfts_bal_id in number
138 ,p_business_group_id in number default null
139 ,p_number_of_copies in number default 0
140 ,p_object_version_number out nocopy number
141 ,p_effective_date in date
142 ) ;
143 --
144 procedure create_bnft_group_results
145 (
146 p_validate in number default 0 -- false
147 ,p_copy_entity_result_id in number -- Source Elpro
148 ,p_copy_entity_txn_id in number default null
149 ,p_benfts_grp_id in number
150 ,p_business_group_id in number default null
151 ,p_number_of_copies in number default 0
152 ,p_object_version_number out nocopy number
153 ,p_effective_date in date
154 ) ;
155 --
156 procedure create_acrs_ptip_cvg_results
157 (
158 p_validate in number default 0 -- false
159 ,p_copy_entity_result_id in number -- Parent row
160 ,p_copy_entity_txn_id in number default null
161 ,p_pgm_id in number
162 ,p_business_group_id in number default null
163 ,p_number_of_copies in number default 0
164 ,p_object_version_number out nocopy number
165 ,p_effective_date in date
166 ) ;
167 --
168 end ben_pd_rate_and_cvg_module;