1 Package ben_batch_rate_info_api as
2 /* $Header: bebriapi.pkh 120.0 2005/05/28 00:51:31 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_batch_rate_info >------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 --
11 -- Prerequisites:
12 --
13 --
14 -- In Parameters:
15 -- Name Reqd Type Description
16 -- p_validate Yes boolean Commit or Rollback.
17 -- p_benefit_action_id Yes number
18 -- p_person_id Yes number
19 -- p_pgm_id No number
20 -- p_pl_id No number
21 -- p_oipl_id No number
22 -- p_bnft_rt_typ_cd No varchar2
23 -- p_dflt_flag Yes varchar2
24 -- p_val No number
25 -- p_tx_typ_cd No varchar2
26 -- p_acty_typ_cd No varchar2
27 -- p_mn_elcn_val No number
28 -- p_mx_elcn_val No number
29 -- p_incrmt_elcn_val No number
30 -- p_dflt_val No number
31 -- p_rt_strt_dt No date
32 -- p_enrt_cvg_strt_dt No date
33 -- p_enrt_cvg_thru_dt No date
34 -- p_actn_cd No varchar2
35 -- p_close_actn_itm_dt No date
36 -- p_business_group_id Yes number Business Group of Record
37 -- p_effective_date Yes date Session Date.
38 -- p_old_val No number
39 --
40 -- Post Success:
41 --
42 -- Out Parameters:
43 -- Name Type Description
44 -- p_batch_rt_id Yes number PK of record
45 -- p_object_version_number Yes number OVN of record
46 --
47 -- Post Failure:
48 --
49 -- Access Status:
50 -- Public.
51 --
52 -- {End Of Comments}
53 --
54 procedure create_batch_rate_info
55 (p_validate in boolean default false
56 ,p_batch_rt_id out nocopy number
57 ,p_benefit_action_id in number default null
58 ,p_person_id in number default null
59 ,p_pgm_id in number default null
60 ,p_pl_id in number default null
61 ,p_oipl_id in number default null
62 ,p_bnft_rt_typ_cd in varchar2 default null
63 ,p_dflt_flag in varchar2 default null
64 ,p_val in number default null
65 ,p_old_val in number default null
66 ,p_tx_typ_cd in varchar2 default null
67 ,p_acty_typ_cd in varchar2 default null
68 ,p_mn_elcn_val in number default null
69 ,p_mx_elcn_val in number default null
70 ,p_incrmt_elcn_val in number default null
71 ,p_dflt_val in number default null
72 ,p_rt_strt_dt in date default null
73 ,p_business_group_id in number default null
74 ,p_object_version_number out nocopy number
75 ,p_enrt_cvg_strt_dt in date default null
76 ,p_enrt_cvg_thru_dt in date default null
77 ,p_actn_cd in varchar2 default null
78 ,p_close_actn_itm_dt in date default null
79 ,p_effective_date in date);
80 -- ----------------------------------------------------------------------------
81 -- |------------------------< update_batch_rate_info >------------------------|
82 -- ----------------------------------------------------------------------------
83 -- {Start Of Comments}
84 --
85 -- Description:
86 --
87 -- Prerequisites:
88 --
89 --
90 -- In Parameters:
91 -- Name Reqd Type Description
92 -- p_validate Yes boolean Commit or Rollback.
93 -- p_batch_rt_id Yes number PK of record
94 -- p_benefit_action_id Yes number
95 -- p_person_id Yes number
96 -- p_pgm_id No number
97 -- p_pl_id No number
98 -- p_oipl_id No number
99 -- p_bnft_rt_typ_cd No varchar2
100 -- p_dflt_flag Yes varchar2
101 -- p_val No number
102 -- p_tx_typ_cd No varchar2
103 -- p_acty_typ_cd No varchar2
104 -- p_mn_elcn_val No number
105 -- p_mx_elcn_val No number
106 -- p_incrmt_elcn_val No number
107 -- p_dflt_val No number
108 -- p_rt_strt_dt No date
109 -- p_business_group_id Yes number Business Group of Record
110 -- p_enrt_cvg_strt_dt No date
111 -- p_enrt_cvg_thru_dt No date
112 -- p_actn_cd No varchar2
113 -- p_close_actn_itm_dt No date
114 -- p_effective_date Yes date Session Date.
115 -- p_old_val No number
116 --
117 -- Post Success:
118 --
119 -- Name Type Description
120 -- p_object_version_number Yes number OVN of record
121 --
122 -- Post Failure:
123 --
124 -- Access Status:
125 -- Public.
126 --
127 -- {End Of Comments}
128 --
129 procedure update_batch_rate_info
130 (p_validate in boolean default false
131 ,p_batch_rt_id in number
132 ,p_benefit_action_id in number default hr_api.g_number
133 ,p_person_id in number default hr_api.g_number
134 ,p_pgm_id in number default hr_api.g_number
135 ,p_pl_id in number default hr_api.g_number
136 ,p_oipl_id in number default hr_api.g_number
137 ,p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2
138 ,p_dflt_flag in varchar2 default hr_api.g_varchar2
139 ,p_val in number default hr_api.g_number
140 ,p_old_val in number default hr_api.g_number
141 ,p_tx_typ_cd in varchar2 default hr_api.g_varchar2
142 ,p_acty_typ_cd in varchar2 default hr_api.g_varchar2
143 ,p_mn_elcn_val in number default hr_api.g_number
144 ,p_mx_elcn_val in number default hr_api.g_number
145 ,p_incrmt_elcn_val in number default hr_api.g_number
146 ,p_dflt_val in number default hr_api.g_number
147 ,p_rt_strt_dt in date default hr_api.g_date
148 ,p_business_group_id in number default hr_api.g_number
149 ,p_object_version_number in out nocopy number
150 ,p_enrt_cvg_strt_dt in date default hr_api.g_date
151 ,p_enrt_cvg_thru_dt in date default hr_api.g_date
152 ,p_actn_cd in varchar2 default hr_api.g_varchar2
153 ,p_close_actn_itm_dt in date default hr_api.g_date
154 ,p_effective_date in date);
155 --
156 -- ----------------------------------------------------------------------------
157 -- |------------------------< delete_batch_rate_info >------------------------|
158 -- ----------------------------------------------------------------------------
159 -- {Start Of Comments}
160 --
161 -- Description:
162 --
163 -- Prerequisites:
164 --
165 --
166 -- In Parameters:
167 -- Name Reqd Type Description
168 -- p_validate Yes boolean Commit or Rollback.
169 -- p_batch_rt_id Yes number PK of record
170 -- p_effective_date Yes date Session Date.
171 --
172 -- Post Success:
173 --
174 -- Name Type Description
175 -- p_object_version_number Yes number OVN of record
176 --
177 -- Post Failure:
178 --
179 -- Access Status:
180 -- Public.
181 --
182 -- {End Of Comments}
183 --
184 procedure delete_batch_rate_info
185 (p_validate in boolean default false
186 ,p_batch_rt_id in number
187 ,p_object_version_number in out nocopy number
188 ,p_effective_date in date);
189 --
190 -- ----------------------------------------------------------------------------
191 -- |----------------------------------< lck >---------------------------------|
192 -- ----------------------------------------------------------------------------
193 -- {Start Of Comments}
194 --
195 -- Description:
196 --
197 -- Prerequisites:
198 --
199 --
200 -- In Parameters:
201 -- Name Reqd Type Description
202 -- p_batch_rt_id Yes number PK of record
203 -- p_object_version_number Yes number OVN of record
204 --
205 -- Post Success:
206 --
207 -- Name Type Description
208 --
209 -- Post Failure:
210 --
211 -- Access Status:
212 -- Public.
213 --
214 -- {End Of Comments}
215 --
216 procedure lck
217 (p_batch_rt_id in number
218 ,p_object_version_number in number);
219 --
220 end ben_batch_rate_info_api;