1 Package ben_pil_elctbl_chc_popl_swi AUTHID CURRENT_USER As
2 /* $Header: bepelswi.pkh 115.0 2003/03/10 15:20:17 aupadhya noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |----------------------< create_pil_elctbl_chc_popl >----------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: ben_pil_elctbl_chc_popl_api.create_pil_elctbl_chc_popl
11 --
12 -- Pre-requisites
13 -- All 'IN' parameters to this procedure have been appropriately derived.
14 --
15 -- Post Success:
16 -- p_return_status will return value indicating success.
17 --
18 -- Post Failure:
19 -- p_return_status will return value indication failure.
20 --
21 -- Access Status:
22 -- Internal Development use only.
23 --
24 -- {End of comments}
25 -- ----------------------------------------------------------------------------
26 PROCEDURE create_pil_elctbl_chc_popl
27 (p_validate in number default hr_api.g_false_num
28 ,p_pil_elctbl_chc_popl_id out nocopy number
29 ,p_dflt_enrt_dt in date default null
30 ,p_dflt_asnd_dt in date default null
31 ,p_elcns_made_dt in date default null
32 ,p_cls_enrt_dt_to_use_cd in varchar2 default null
33 ,p_enrt_typ_cycl_cd in varchar2 default null
34 ,p_enrt_perd_end_dt in date default null
35 ,p_enrt_perd_strt_dt in date default null
36 ,p_procg_end_dt in date default null
37 ,p_pil_elctbl_popl_stat_cd in varchar2 default null
38 ,p_acty_ref_perd_cd in varchar2 default null
39 ,p_uom in varchar2 default null
40 ,p_comments in varchar2 default null
41 ,p_mgr_ovrid_dt in date default null
42 ,p_ws_mgr_id in number default null
43 ,p_mgr_ovrid_person_id in number default null
44 ,p_assignment_id in number default null
45 ,p_bdgt_acc_cd in varchar2 default null
46 ,p_pop_cd in varchar2 default null
47 ,p_bdgt_due_dt in date default null
48 ,p_bdgt_export_flag in varchar2 default null
49 ,p_bdgt_iss_dt in date default null
50 ,p_bdgt_stat_cd in varchar2 default null
51 ,p_ws_acc_cd in varchar2 default null
52 ,p_ws_due_dt in date default null
53 ,p_ws_export_flag in varchar2 default null
54 ,p_ws_iss_dt in date default null
55 ,p_ws_stat_cd in varchar2 default null
56 ,p_auto_asnd_dt in date default null
57 ,p_cbr_elig_perd_strt_dt in date default null
58 ,p_cbr_elig_perd_end_dt in date default null
59 ,p_lee_rsn_id in number default null
60 ,p_enrt_perd_id in number default null
61 ,p_per_in_ler_id in number default null
62 ,p_pgm_id in number default null
63 ,p_pl_id in number default null
64 ,p_business_group_id in number default null
65 ,p_pel_attribute_category in varchar2 default null
66 ,p_pel_attribute1 in varchar2 default null
67 ,p_pel_attribute2 in varchar2 default null
68 ,p_pel_attribute3 in varchar2 default null
69 ,p_pel_attribute4 in varchar2 default null
70 ,p_pel_attribute5 in varchar2 default null
71 ,p_pel_attribute6 in varchar2 default null
72 ,p_pel_attribute7 in varchar2 default null
73 ,p_pel_attribute8 in varchar2 default null
74 ,p_pel_attribute9 in varchar2 default null
75 ,p_pel_attribute10 in varchar2 default null
76 ,p_pel_attribute11 in varchar2 default null
77 ,p_pel_attribute12 in varchar2 default null
78 ,p_pel_attribute13 in varchar2 default null
79 ,p_pel_attribute14 in varchar2 default null
80 ,p_pel_attribute15 in varchar2 default null
81 ,p_pel_attribute16 in varchar2 default null
82 ,p_pel_attribute17 in varchar2 default null
83 ,p_pel_attribute18 in varchar2 default null
84 ,p_pel_attribute19 in varchar2 default null
85 ,p_pel_attribute20 in varchar2 default null
86 ,p_pel_attribute21 in varchar2 default null
87 ,p_pel_attribute22 in varchar2 default null
88 ,p_pel_attribute23 in varchar2 default null
89 ,p_pel_attribute24 in varchar2 default null
90 ,p_pel_attribute25 in varchar2 default null
91 ,p_pel_attribute26 in varchar2 default null
92 ,p_pel_attribute27 in varchar2 default null
93 ,p_pel_attribute28 in varchar2 default null
94 ,p_pel_attribute29 in varchar2 default null
95 ,p_pel_attribute30 in varchar2 default null
96 ,p_request_id in number default null
97 ,p_program_application_id in number default null
98 ,p_program_id in number default null
99 ,p_program_update_date in date default null
100 ,p_object_version_number out nocopy number
101 ,p_effective_date in date
102 ,p_return_status out nocopy varchar2
103 );
104 -- ----------------------------------------------------------------------------
105 -- |----------------------< delete_pil_elctbl_chc_popl >----------------------|
106 -- ----------------------------------------------------------------------------
107 -- {Start of comments}
108 --
109 -- Description:
110 -- This procedure is the self-service wrapper procedure to the following
111 -- API: ben_pil_elctbl_chc_popl_api.delete_pil_elctbl_chc_popl
112 --
113 -- Pre-requisites
114 -- All 'IN' parameters to this procedure have been appropriately derived.
115 --
116 -- Post Success:
117 -- p_return_status will return value indicating success.
118 --
119 -- Post Failure:
120 -- p_return_status will return value indication failure.
121 --
122 -- Access Status:
123 -- Internal Development use only.
124 --
125 -- {End of comments}
126 -- ----------------------------------------------------------------------------
127 PROCEDURE delete_pil_elctbl_chc_popl
128 (p_validate in number default hr_api.g_false_num
129 ,p_pil_elctbl_chc_popl_id in number
130 ,p_object_version_number in out nocopy number
131 ,p_effective_date in date
132 ,p_return_status out nocopy varchar2
133 );
134 -- ----------------------------------------------------------------------------
135 -- |----------------------------------< lck >---------------------------------|
136 -- ----------------------------------------------------------------------------
137 -- {Start of comments}
138 --
139 -- Description:
140 -- This procedure is the self-service wrapper procedure to the following
141 -- API: ben_pil_elctbl_chc_popl_api.lck
142 --
143 -- Pre-requisites
144 -- All 'IN' parameters to this procedure have been appropriately derived.
145 --
146 -- Post Success:
147 -- p_return_status will return value indicating success.
148 --
149 -- Post Failure:
150 -- p_return_status will return value indication failure.
151 --
152 -- Access Status:
153 -- Internal Development use only.
154 --
155 -- {End of comments}
156 -- ----------------------------------------------------------------------------
157 PROCEDURE lck
158 (p_pil_elctbl_chc_popl_id in number
159 ,p_object_version_number in number
160 ,p_return_status out nocopy varchar2
161 );
162 -- ----------------------------------------------------------------------------
163 -- |----------------------< update_pil_elctbl_chc_popl >----------------------|
164 -- ----------------------------------------------------------------------------
165 -- {Start of comments}
166 --
167 -- Description:
168 -- This procedure is the self-service wrapper procedure to the following
169 -- API: ben_pil_elctbl_chc_popl_api.update_pil_elctbl_chc_popl
170 --
171 -- Pre-requisites
172 -- All 'IN' parameters to this procedure have been appropriately derived.
173 --
174 -- Post Success:
175 -- p_return_status will return value indicating success.
176 --
177 -- Post Failure:
178 -- p_return_status will return value indication failure.
179 --
180 -- Access Status:
181 -- Internal Development use only.
182 --
183 -- {End of comments}
184 -- ----------------------------------------------------------------------------
185 PROCEDURE update_pil_elctbl_chc_popl
186 (p_validate in number default hr_api.g_false_num
187 ,p_pil_elctbl_chc_popl_id in number
188 ,p_dflt_enrt_dt in date default hr_api.g_date
189 ,p_dflt_asnd_dt in date default hr_api.g_date
193 ,p_enrt_perd_end_dt in date default hr_api.g_date
190 ,p_elcns_made_dt in date default hr_api.g_date
191 ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
192 ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
194 ,p_enrt_perd_strt_dt in date default hr_api.g_date
195 ,p_procg_end_dt in date default hr_api.g_date
196 ,p_pil_elctbl_popl_stat_cd in varchar2 default hr_api.g_varchar2
197 ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
198 ,p_uom in varchar2 default hr_api.g_varchar2
199 ,p_comments in varchar2 default hr_api.g_varchar2
200 ,p_mgr_ovrid_dt in date default hr_api.g_date
201 ,p_ws_mgr_id in number default hr_api.g_number
202 ,p_mgr_ovrid_person_id in number default hr_api.g_number
203 ,p_assignment_id in number default hr_api.g_number
204 ,p_bdgt_acc_cd in varchar2 default hr_api.g_varchar2
205 ,p_pop_cd in varchar2 default hr_api.g_varchar2
206 ,p_bdgt_due_dt in date default hr_api.g_date
207 ,p_bdgt_export_flag in varchar2 default hr_api.g_varchar2
208 ,p_bdgt_iss_dt in date default hr_api.g_date
209 ,p_bdgt_stat_cd in varchar2 default hr_api.g_varchar2
210 ,p_ws_acc_cd in varchar2 default hr_api.g_varchar2
211 ,p_ws_due_dt in date default hr_api.g_date
212 ,p_ws_export_flag in varchar2 default hr_api.g_varchar2
213 ,p_ws_iss_dt in date default hr_api.g_date
214 ,p_ws_stat_cd in varchar2 default hr_api.g_varchar2
215 ,p_auto_asnd_dt in date default hr_api.g_date
216 ,p_cbr_elig_perd_strt_dt in date default hr_api.g_date
217 ,p_cbr_elig_perd_end_dt in date default hr_api.g_date
218 ,p_lee_rsn_id in number default hr_api.g_number
219 ,p_enrt_perd_id in number default hr_api.g_number
220 ,p_per_in_ler_id in number default hr_api.g_number
221 ,p_pgm_id in number default hr_api.g_number
222 ,p_pl_id in number default hr_api.g_number
223 ,p_business_group_id in number default hr_api.g_number
224 ,p_pel_attribute_category in varchar2 default hr_api.g_varchar2
225 ,p_pel_attribute1 in varchar2 default hr_api.g_varchar2
226 ,p_pel_attribute2 in varchar2 default hr_api.g_varchar2
227 ,p_pel_attribute3 in varchar2 default hr_api.g_varchar2
228 ,p_pel_attribute4 in varchar2 default hr_api.g_varchar2
229 ,p_pel_attribute5 in varchar2 default hr_api.g_varchar2
230 ,p_pel_attribute6 in varchar2 default hr_api.g_varchar2
231 ,p_pel_attribute7 in varchar2 default hr_api.g_varchar2
232 ,p_pel_attribute8 in varchar2 default hr_api.g_varchar2
233 ,p_pel_attribute9 in varchar2 default hr_api.g_varchar2
234 ,p_pel_attribute10 in varchar2 default hr_api.g_varchar2
235 ,p_pel_attribute11 in varchar2 default hr_api.g_varchar2
239 ,p_pel_attribute15 in varchar2 default hr_api.g_varchar2
236 ,p_pel_attribute12 in varchar2 default hr_api.g_varchar2
237 ,p_pel_attribute13 in varchar2 default hr_api.g_varchar2
238 ,p_pel_attribute14 in varchar2 default hr_api.g_varchar2
240 ,p_pel_attribute16 in varchar2 default hr_api.g_varchar2
241 ,p_pel_attribute17 in varchar2 default hr_api.g_varchar2
242 ,p_pel_attribute18 in varchar2 default hr_api.g_varchar2
243 ,p_pel_attribute19 in varchar2 default hr_api.g_varchar2
244 ,p_pel_attribute20 in varchar2 default hr_api.g_varchar2
245 ,p_pel_attribute21 in varchar2 default hr_api.g_varchar2
246 ,p_pel_attribute22 in varchar2 default hr_api.g_varchar2
247 ,p_pel_attribute23 in varchar2 default hr_api.g_varchar2
248 ,p_pel_attribute24 in varchar2 default hr_api.g_varchar2
249 ,p_pel_attribute25 in varchar2 default hr_api.g_varchar2
250 ,p_pel_attribute26 in varchar2 default hr_api.g_varchar2
251 ,p_pel_attribute27 in varchar2 default hr_api.g_varchar2
252 ,p_pel_attribute28 in varchar2 default hr_api.g_varchar2
253 ,p_pel_attribute29 in varchar2 default hr_api.g_varchar2
254 ,p_pel_attribute30 in varchar2 default hr_api.g_varchar2
255 ,p_request_id in number default hr_api.g_number
256 ,p_program_application_id in number default hr_api.g_number
257 ,p_program_id in number default hr_api.g_number
258 ,p_program_update_date in date default hr_api.g_date
259 ,p_object_version_number in out nocopy number
260 ,p_effective_date in date
261 ,p_return_status out nocopy varchar2
262 );
263 end ben_pil_elctbl_chc_popl_swi;