[Home] [Help]
PACKAGE: APPS.BEN_ENRT_BNFT_API
Source
1 Package ben_enrt_bnft_api as
2 /* $Header: beenbapi.pkh 120.0 2005/05/28 02:27:19 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_enrt_bnft >------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 --
11 -- Prerequisites:
12 --
13 --
14 -- Post Success:
15 --
16 -- Out Parameters:
17 -- Name Type Description
18 -- p_enrt_bnft_id Yes number PK of record
19 -- p_object_version_number No number OVN of record
20 --
21 -- Post Failure:
22 --
23 -- Access Status:
24 -- Public.
25 --
26 -- {End Of Comments}
27 --
28 procedure create_enrt_bnft
29 (
30 p_validate in boolean default false
31 ,p_enrt_bnft_id out nocopy number
32 ,p_dflt_flag in varchar2 default 'N'
33 ,p_val_has_bn_prortd_flag in varchar2 default 'N'
34 ,p_bndry_perd_cd in varchar2 default null
35 ,p_val in number default null
36 ,p_nnmntry_uom in varchar2 default null
37 ,p_bnft_typ_cd in varchar2 default null
38 ,p_entr_val_at_enrt_flag in varchar2 default 'N'
39 ,p_mn_val in number default null
40 ,p_mx_val in number default null
41 ,p_incrmt_val in number default null
42 ,p_dflt_val in number default null
43 ,p_rt_typ_cd in varchar2 default null
44 ,p_cvg_mlt_cd in varchar2 default null
45 ,p_ctfn_rqd_flag in varchar2 default 'N'
46 ,p_ordr_num in number default null
47 ,p_crntly_enrld_flag in varchar2 default 'N'
48 ,p_elig_per_elctbl_chc_id in number default null
49 ,p_prtt_enrt_rslt_id in number default null
50 ,p_comp_lvl_fctr_id in number default null
51 ,p_business_group_id in number default null
52 ,p_enb_attribute_category in varchar2 default null
53 ,p_enb_attribute1 in varchar2 default null
54 ,p_enb_attribute2 in varchar2 default null
55 ,p_enb_attribute3 in varchar2 default null
56 ,p_enb_attribute4 in varchar2 default null
57 ,p_enb_attribute5 in varchar2 default null
58 ,p_enb_attribute6 in varchar2 default null
59 ,p_enb_attribute7 in varchar2 default null
60 ,p_enb_attribute8 in varchar2 default null
61 ,p_enb_attribute9 in varchar2 default null
62 ,p_enb_attribute10 in varchar2 default null
63 ,p_enb_attribute11 in varchar2 default null
64 ,p_enb_attribute12 in varchar2 default null
65 ,p_enb_attribute13 in varchar2 default null
66 ,p_enb_attribute14 in varchar2 default null
67 ,p_enb_attribute15 in varchar2 default null
68 ,p_enb_attribute16 in varchar2 default null
69 ,p_enb_attribute17 in varchar2 default null
70 ,p_enb_attribute18 in varchar2 default null
71 ,p_enb_attribute19 in varchar2 default null
72 ,p_enb_attribute20 in varchar2 default null
73 ,p_enb_attribute21 in varchar2 default null
74 ,p_enb_attribute22 in varchar2 default null
75 ,p_enb_attribute23 in varchar2 default null
76 ,p_enb_attribute24 in varchar2 default null
77 ,p_enb_attribute25 in varchar2 default null
78 ,p_enb_attribute26 in varchar2 default null
79 ,p_enb_attribute27 in varchar2 default null
80 ,p_enb_attribute28 in varchar2 default null
81 ,p_enb_attribute29 in varchar2 default null
82 ,p_enb_attribute30 in varchar2 default null
83 ,p_request_id in number default null
84 ,p_program_application_id in number default null
85 ,p_program_id in number default null
86 ,p_program_update_date in date default null
87 ,p_mx_wout_ctfn_val in number default null
88 ,p_mx_wo_ctfn_flag in varchar2 default 'N'
89 ,p_object_version_number out nocopy number
90 ,p_effective_date in date
91 );
92 -- ----------------------------------------------------------------------------
93 -- |------------------------< update_enrt_bnft >------------------------|
94 -- ----------------------------------------------------------------------------
95 -- {Start Of Comments}
96 --
97 -- Description:
98 --
99 -- Prerequisites:
100 --
101 -- Post Success:
102 --
103 -- Name Type Description
104 -- p_object_version_number No number OVN of record
105 --
106 -- Post Failure:
107 --
108 -- Access Status:
109 -- Public.
110 --
111 -- {End Of Comments}
112 --
113 procedure update_enrt_bnft
114 (
115 p_validate in boolean default false
116 ,p_enrt_bnft_id in number
117 ,p_dflt_flag in varchar2 default hr_api.g_varchar2
118 ,p_val_has_bn_prortd_flag in varchar2 default hr_api.g_varchar2
119 ,p_bndry_perd_cd in varchar2 default hr_api.g_varchar2
120 ,p_val in number default hr_api.g_number
121 ,p_nnmntry_uom in varchar2 default hr_api.g_varchar2
122 ,p_bnft_typ_cd in varchar2 default hr_api.g_varchar2
123 ,p_entr_val_at_enrt_flag in varchar2 default hr_api.g_varchar2
124 ,p_mn_val in number default hr_api.g_number
125 ,p_mx_val in number default hr_api.g_number
126 ,p_incrmt_val in number default hr_api.g_number
127 ,p_dflt_val in number default hr_api.g_number
128 ,p_rt_typ_cd in varchar2 default hr_api.g_varchar2
129 ,p_cvg_mlt_cd in varchar2 default hr_api.g_varchar2
130 ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
131 ,p_ordr_num in number default hr_api.g_number
132 ,p_crntly_enrld_flag in varchar2 default hr_api.g_varchar2
133 ,p_elig_per_elctbl_chc_id in number default hr_api.g_number
134 ,p_prtt_enrt_rslt_id in number default hr_api.g_number
135 ,p_comp_lvl_fctr_id in number default hr_api.g_number
136 ,p_business_group_id in number default hr_api.g_number
137 ,p_enb_attribute_category in varchar2 default hr_api.g_varchar2
138 ,p_enb_attribute1 in varchar2 default hr_api.g_varchar2
139 ,p_enb_attribute2 in varchar2 default hr_api.g_varchar2
140 ,p_enb_attribute3 in varchar2 default hr_api.g_varchar2
141 ,p_enb_attribute4 in varchar2 default hr_api.g_varchar2
142 ,p_enb_attribute5 in varchar2 default hr_api.g_varchar2
143 ,p_enb_attribute6 in varchar2 default hr_api.g_varchar2
144 ,p_enb_attribute7 in varchar2 default hr_api.g_varchar2
145 ,p_enb_attribute8 in varchar2 default hr_api.g_varchar2
146 ,p_enb_attribute9 in varchar2 default hr_api.g_varchar2
147 ,p_enb_attribute10 in varchar2 default hr_api.g_varchar2
148 ,p_enb_attribute11 in varchar2 default hr_api.g_varchar2
149 ,p_enb_attribute12 in varchar2 default hr_api.g_varchar2
150 ,p_enb_attribute13 in varchar2 default hr_api.g_varchar2
151 ,p_enb_attribute14 in varchar2 default hr_api.g_varchar2
152 ,p_enb_attribute15 in varchar2 default hr_api.g_varchar2
153 ,p_enb_attribute16 in varchar2 default hr_api.g_varchar2
154 ,p_enb_attribute17 in varchar2 default hr_api.g_varchar2
155 ,p_enb_attribute18 in varchar2 default hr_api.g_varchar2
156 ,p_enb_attribute19 in varchar2 default hr_api.g_varchar2
157 ,p_enb_attribute20 in varchar2 default hr_api.g_varchar2
158 ,p_enb_attribute21 in varchar2 default hr_api.g_varchar2
159 ,p_enb_attribute22 in varchar2 default hr_api.g_varchar2
160 ,p_enb_attribute23 in varchar2 default hr_api.g_varchar2
161 ,p_enb_attribute24 in varchar2 default hr_api.g_varchar2
162 ,p_enb_attribute25 in varchar2 default hr_api.g_varchar2
163 ,p_enb_attribute26 in varchar2 default hr_api.g_varchar2
164 ,p_enb_attribute27 in varchar2 default hr_api.g_varchar2
165 ,p_enb_attribute28 in varchar2 default hr_api.g_varchar2
166 ,p_enb_attribute29 in varchar2 default hr_api.g_varchar2
167 ,p_enb_attribute30 in varchar2 default hr_api.g_varchar2
168 ,p_request_id in number default hr_api.g_number
169 ,p_program_application_id in number default hr_api.g_number
170 ,p_program_id in number default hr_api.g_number
171 ,p_program_update_date in date default hr_api.g_date
172 ,p_mx_wout_ctfn_val in number default hr_api.g_number
173 ,p_mx_wo_ctfn_flag in varchar2 default hr_api.g_varchar2
174 ,p_object_version_number in out nocopy number
175 ,p_effective_date in date
176 );
177 --
178 -- ----------------------------------------------------------------------------
179 -- |------------------------< delete_enrt_bnft >------------------------|
180 -- ----------------------------------------------------------------------------
181 -- {Start Of Comments}
182 --
183 -- Description:
184 --
185 -- Prerequisites:
186 --
187 --
188 -- In Parameters:
189 -- Name Reqd Type Description
190 -- p_validate Yes boolean Commit or Rollback.
191 -- p_enrt_bnft_id Yes number PK of record
192 -- p_effective_date Yes date Session Date.
193 --
194 -- Post Success:
195 --
196 -- Name Type Description
197 -- p_object_version_number No number OVN of record
198 --
199 -- Post Failure:
200 --
201 -- Access Status:
202 -- Public.
203 --
204 -- {End Of Comments}
205 --
206 procedure delete_enrt_bnft
207 (
208 p_validate in boolean default false
209 ,p_enrt_bnft_id in number
210 ,p_object_version_number in out nocopy number
211 ,p_effective_date in date
212 );
213 --
214 -- ----------------------------------------------------------------------------
215 -- |----------------------------------< lck >---------------------------------|
216 -- ----------------------------------------------------------------------------
217 -- {Start Of Comments}
218 --
219 -- Description:
220 --
221 -- Prerequisites:
222 --
223 --
224 -- In Parameters:
225 -- Name Reqd Type Description
226 -- p_enrt_bnft_id Yes number PK of record
227 -- p_object_version_number Yes number OVN of record
228 --
229 -- Post Success:
230 --
231 -- Name Type Description
232 --
233 -- Post Failure:
234 --
235 -- Access Status:
236 -- Public.
237 --
238 -- {End Of Comments}
239 --
240 procedure lck
241 (
242 p_enrt_bnft_id in number
243 ,p_object_version_number in number
244 );
245 --
246 end ben_enrt_bnft_api;