1 Package ben_PRTT_PREM_api AUTHID CURRENT_USER as
2 /* $Header: beppeapi.pkh 120.0.12000000.1 2007/01/19 21:44:45 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< recalc_PRTT_PREM >------------------------|
6 -- ----------------------------------------------------------------------------
7 procedure recalc_PRTT_PREM
8 (p_prtt_prem_id in number default null
9 ,p_std_prem_uom in varchar2 default null
10 ,p_std_prem_val in out nocopy number
11 ,p_actl_prem_id in number default null
12 ,p_prtt_enrt_rslt_id in number default null
13 ,p_per_in_ler_id in number
14 ,p_ler_id in number
15 ,p_lf_evt_ocrd_dt in date
16 ,p_elig_per_elctbl_chc_id in number
17 ,p_enrt_bnft_id in number
18 ,p_business_group_id in number default null
19 -- bof FONM
20 ,p_enrt_cvg_strt_dt in date default null
21 ,p_rt_strt_dt in date default null
22 -- eof FONM
23 ,p_effective_date in date);
24
25 -- ----------------------------------------------------------------------------
26 -- |------------------------< create_PRTT_PREM >------------------------|
27 -- ----------------------------------------------------------------------------
28 -- {Start Of Comments}
29 --
30 -- Description:
31 --
32 -- Prerequisites:
33 --
34 --
35 -- In Parameters:
36 -- Name Reqd Type Description
37 -- p_validate Yes boolean Commit or Rollback.
38 -- p_std_prem_uom No varchar2
39 -- p_std_prem_val No number
40 -- p_actl_prem_id Yes number
41 -- p_prtt_enrt_rslt_id Yes number
42 -- p_per_in_ler_id Yes number
43 -- p_business_group_id Yes number Business Group of Record
44 -- p_ppe_attribute_category No varchar2 Descriptive Flexfield
45 -- p_ppe_attribute1 No varchar2 Descriptive Flexfield
46 -- p_ppe_attribute2 No varchar2 Descriptive Flexfield
47 -- p_ppe_attribute3 No varchar2 Descriptive Flexfield
48 -- p_ppe_attribute4 No varchar2 Descriptive Flexfield
49 -- p_ppe_attribute5 No varchar2 Descriptive Flexfield
50 -- p_ppe_attribute6 No varchar2 Descriptive Flexfield
51 -- p_ppe_attribute7 No varchar2 Descriptive Flexfield
52 -- p_ppe_attribute8 No varchar2 Descriptive Flexfield
53 -- p_ppe_attribute9 No varchar2 Descriptive Flexfield
54 -- p_ppe_attribute10 No varchar2 Descriptive Flexfield
55 -- p_ppe_attribute11 No varchar2 Descriptive Flexfield
56 -- p_ppe_attribute12 No varchar2 Descriptive Flexfield
57 -- p_ppe_attribute13 No varchar2 Descriptive Flexfield
58 -- p_ppe_attribute14 No varchar2 Descriptive Flexfield
59 -- p_ppe_attribute15 No varchar2 Descriptive Flexfield
60 -- p_ppe_attribute16 No varchar2 Descriptive Flexfield
64 -- p_ppe_attribute20 No varchar2 Descriptive Flexfield
61 -- p_ppe_attribute17 No varchar2 Descriptive Flexfield
62 -- p_ppe_attribute18 No varchar2 Descriptive Flexfield
63 -- p_ppe_attribute19 No varchar2 Descriptive Flexfield
65 -- p_ppe_attribute21 No varchar2 Descriptive Flexfield
66 -- p_ppe_attribute22 No varchar2 Descriptive Flexfield
67 -- p_ppe_attribute23 No varchar2 Descriptive Flexfield
68 -- p_ppe_attribute24 No varchar2 Descriptive Flexfield
69 -- p_ppe_attribute25 No varchar2 Descriptive Flexfield
70 -- p_ppe_attribute26 No varchar2 Descriptive Flexfield
71 -- p_ppe_attribute27 No varchar2 Descriptive Flexfield
72 -- p_ppe_attribute28 No varchar2 Descriptive Flexfield
73 -- p_ppe_attribute29 No varchar2 Descriptive Flexfield
74 -- p_ppe_attribute30 No varchar2 Descriptive Flexfield
75 -- p_request_id No number
76 -- p_program_application_id No number
77 -- p_program_id No number
78 -- p_program_update_date No date
79 -- p_effective_date Yes date Session Date.
80 --
81 -- Post Success:
82 --
83 -- Out Parameters:
84 -- Name Type Description
85 -- p_prtt_prem_id Yes number PK of record
86 -- p_effective_start_date Yes date Effective Start Date of Record
87 -- p_effective_end_date Yes date Effective End Date of Record
88 -- p_object_version_number No number OVN of record
89 --
90 -- Post Failure:
91 --
92 -- Access Status:
93 -- Public.
94 --
95 -- {End Of Comments}
96 --
97 procedure create_PRTT_PREM
98 (
99 p_validate in boolean default false
100 ,p_prtt_prem_id out nocopy number
101 ,p_effective_start_date out nocopy date
102 ,p_effective_end_date out nocopy date
103 ,p_std_prem_uom in varchar2 default null
104 ,p_std_prem_val in number default null
105 ,p_actl_prem_id in number default null
106 ,p_prtt_enrt_rslt_id in number default null
107 ,p_per_in_ler_id in number
108 ,p_business_group_id in number default null
109 ,p_ppe_attribute_category in varchar2 default null
110 ,p_ppe_attribute1 in varchar2 default null
111 ,p_ppe_attribute2 in varchar2 default null
112 ,p_ppe_attribute3 in varchar2 default null
113 ,p_ppe_attribute4 in varchar2 default null
114 ,p_ppe_attribute5 in varchar2 default null
115 ,p_ppe_attribute6 in varchar2 default null
116 ,p_ppe_attribute7 in varchar2 default null
117 ,p_ppe_attribute8 in varchar2 default null
118 ,p_ppe_attribute9 in varchar2 default null
119 ,p_ppe_attribute10 in varchar2 default null
120 ,p_ppe_attribute11 in varchar2 default null
121 ,p_ppe_attribute12 in varchar2 default null
122 ,p_ppe_attribute13 in varchar2 default null
123 ,p_ppe_attribute14 in varchar2 default null
124 ,p_ppe_attribute15 in varchar2 default null
125 ,p_ppe_attribute16 in varchar2 default null
126 ,p_ppe_attribute17 in varchar2 default null
127 ,p_ppe_attribute18 in varchar2 default null
128 ,p_ppe_attribute19 in varchar2 default null
129 ,p_ppe_attribute20 in varchar2 default null
130 ,p_ppe_attribute21 in varchar2 default null
131 ,p_ppe_attribute22 in varchar2 default null
132 ,p_ppe_attribute23 in varchar2 default null
133 ,p_ppe_attribute24 in varchar2 default null
134 ,p_ppe_attribute25 in varchar2 default null
135 ,p_ppe_attribute26 in varchar2 default null
136 ,p_ppe_attribute27 in varchar2 default null
137 ,p_ppe_attribute28 in varchar2 default null
138 ,p_ppe_attribute29 in varchar2 default null
139 ,p_ppe_attribute30 in varchar2 default null
140 ,p_object_version_number out nocopy number
141 ,p_request_id in number default null
142 ,p_program_application_id in number default null
143 ,p_program_id in number default null
144 ,p_program_update_date in date default null
145 ,p_effective_date in date
146 );
147 --
148 -- ----------------------------------------------------------------------------
149 -- |------------------------< create_PRTT_PREM >------------------------|
150 -- ----------------------------------------------------------------------------
151 -- {Start Of Comments}
152 --
153 -- Description:
154 --
155 -- Prerequisites:
156 --
157 --
158 -- In Parameters:
159 -- Name Reqd Type Description
160 -- p_validate Yes boolean Commit or Rollback.
161 -- p_std_prem_uom No varchar2
162 -- p_std_prem_val No number
163 -- p_actl_prem_id Yes number
164 -- p_prtt_enrt_rslt_id Yes number
165 -- p_business_group_id Yes number Business Group of Record
166 -- p_ppe_attribute_category No varchar2 Descriptive Flexfield
167 -- p_ppe_attribute1 No varchar2 Descriptive Flexfield
168 -- p_ppe_attribute2 No varchar2 Descriptive Flexfield
169 -- p_ppe_attribute3 No varchar2 Descriptive Flexfield
170 -- p_ppe_attribute4 No varchar2 Descriptive Flexfield
171 -- p_ppe_attribute5 No varchar2 Descriptive Flexfield
172 -- p_ppe_attribute6 No varchar2 Descriptive Flexfield
173 -- p_ppe_attribute7 No varchar2 Descriptive Flexfield
174 -- p_ppe_attribute8 No varchar2 Descriptive Flexfield
175 -- p_ppe_attribute9 No varchar2 Descriptive Flexfield
176 -- p_ppe_attribute10 No varchar2 Descriptive Flexfield
177 -- p_ppe_attribute11 No varchar2 Descriptive Flexfield
178 -- p_ppe_attribute12 No varchar2 Descriptive Flexfield
179 -- p_ppe_attribute13 No varchar2 Descriptive Flexfield
180 -- p_ppe_attribute14 No varchar2 Descriptive Flexfield
181 -- p_ppe_attribute15 No varchar2 Descriptive Flexfield
182 -- p_ppe_attribute16 No varchar2 Descriptive Flexfield
183 -- p_ppe_attribute17 No varchar2 Descriptive Flexfield
184 -- p_ppe_attribute18 No varchar2 Descriptive Flexfield
185 -- p_ppe_attribute19 No varchar2 Descriptive Flexfield
186 -- p_ppe_attribute20 No varchar2 Descriptive Flexfield
187 -- p_ppe_attribute21 No varchar2 Descriptive Flexfield
188 -- p_ppe_attribute22 No varchar2 Descriptive Flexfield
189 -- p_ppe_attribute23 No varchar2 Descriptive Flexfield
190 -- p_ppe_attribute24 No varchar2 Descriptive Flexfield
191 -- p_ppe_attribute25 No varchar2 Descriptive Flexfield
192 -- p_ppe_attribute26 No varchar2 Descriptive Flexfield
193 -- p_ppe_attribute27 No varchar2 Descriptive Flexfield
194 -- p_ppe_attribute28 No varchar2 Descriptive Flexfield
195 -- p_ppe_attribute29 No varchar2 Descriptive Flexfield
196 -- p_ppe_attribute30 No varchar2 Descriptive Flexfield
197 -- p_request_id No number
198 -- p_program_application_id No number
199 -- p_program_id No number
200 -- p_program_update_date No date
201 -- p_effective_date Yes date Session Date.
202 --
203 -- Post Success:
204 --
205 -- Out Parameters:
206 -- Name Type Description
207 -- p_prtt_prem_id Yes number PK of record
208 -- p_effective_start_date Yes date Effective Start Date of Record
209 -- p_effective_end_date Yes date Effective End Date of Record
210 -- p_object_version_number No number OVN of record
211 --
212 -- Post Failure:
213 --
214 -- Access Status:
215 -- Public.
216 --
217 -- {End Of Comments}
218 --
219 procedure create_PRTT_PREM
220 (
221 p_validate in boolean default false
222 ,p_prtt_prem_id out nocopy number
223 ,p_effective_start_date out nocopy date
224 ,p_effective_end_date out nocopy date
225 ,p_std_prem_uom in varchar2 default null
226 ,p_std_prem_val in number default null
227 ,p_actl_prem_id in number default null
228 ,p_prtt_enrt_rslt_id in number default null
229 ,p_business_group_id in number default null
230 ,p_ppe_attribute_category in varchar2 default null
231 ,p_ppe_attribute1 in varchar2 default null
232 ,p_ppe_attribute2 in varchar2 default null
233 ,p_ppe_attribute3 in varchar2 default null
234 ,p_ppe_attribute4 in varchar2 default null
235 ,p_ppe_attribute5 in varchar2 default null
236 ,p_ppe_attribute6 in varchar2 default null
237 ,p_ppe_attribute7 in varchar2 default null
238 ,p_ppe_attribute8 in varchar2 default null
239 ,p_ppe_attribute9 in varchar2 default null
240 ,p_ppe_attribute10 in varchar2 default null
241 ,p_ppe_attribute11 in varchar2 default null
242 ,p_ppe_attribute12 in varchar2 default null
243 ,p_ppe_attribute13 in varchar2 default null
244 ,p_ppe_attribute14 in varchar2 default null
245 ,p_ppe_attribute15 in varchar2 default null
246 ,p_ppe_attribute16 in varchar2 default null
247 ,p_ppe_attribute17 in varchar2 default null
248 ,p_ppe_attribute18 in varchar2 default null
249 ,p_ppe_attribute19 in varchar2 default null
250 ,p_ppe_attribute20 in varchar2 default null
251 ,p_ppe_attribute21 in varchar2 default null
252 ,p_ppe_attribute22 in varchar2 default null
253 ,p_ppe_attribute23 in varchar2 default null
254 ,p_ppe_attribute24 in varchar2 default null
255 ,p_ppe_attribute25 in varchar2 default null
256 ,p_ppe_attribute26 in varchar2 default null
257 ,p_ppe_attribute27 in varchar2 default null
258 ,p_ppe_attribute28 in varchar2 default null
259 ,p_ppe_attribute29 in varchar2 default null
260 ,p_ppe_attribute30 in varchar2 default null
261 ,p_object_version_number out nocopy number
262 ,p_request_id in number default null
263 ,p_program_application_id in number default null
264 ,p_program_id in number default null
265 ,p_program_update_date in date default null
266 ,p_effective_date in date
267 );
268 -- ----------------------------------------------------------------------------
269 -- |------------------------< update_PRTT_PREM >------------------------|
270 -- ----------------------------------------------------------------------------
271 -- {Start Of Comments}
272 --
273 -- Description:
274 --
275 -- Prerequisites:
276 --
277 --
278 -- In Parameters:
279 -- Name Reqd Type Description
280 -- p_validate Yes boolean Commit or Rollback.
281 -- p_prtt_prem_id Yes number PK of record
282 -- p_std_prem_uom No varchar2
283 -- p_std_prem_val No number
284 -- p_actl_prem_id Yes number
285 -- p_prtt_enrt_rslt_id Yes number
286 -- p_per_in_ler_id Yes number
287 -- p_business_group_id Yes number Business Group of Record
288 -- p_ppe_attribute_category No varchar2 Descriptive Flexfield
289 -- p_ppe_attribute1 No varchar2 Descriptive Flexfield
290 -- p_ppe_attribute2 No varchar2 Descriptive Flexfield
291 -- p_ppe_attribute3 No varchar2 Descriptive Flexfield
292 -- p_ppe_attribute4 No varchar2 Descriptive Flexfield
293 -- p_ppe_attribute5 No varchar2 Descriptive Flexfield
294 -- p_ppe_attribute6 No varchar2 Descriptive Flexfield
295 -- p_ppe_attribute7 No varchar2 Descriptive Flexfield
296 -- p_ppe_attribute8 No varchar2 Descriptive Flexfield
297 -- p_ppe_attribute9 No varchar2 Descriptive Flexfield
298 -- p_ppe_attribute10 No varchar2 Descriptive Flexfield
299 -- p_ppe_attribute11 No varchar2 Descriptive Flexfield
300 -- p_ppe_attribute12 No varchar2 Descriptive Flexfield
301 -- p_ppe_attribute13 No varchar2 Descriptive Flexfield
302 -- p_ppe_attribute14 No varchar2 Descriptive Flexfield
303 -- p_ppe_attribute15 No varchar2 Descriptive Flexfield
304 -- p_ppe_attribute16 No varchar2 Descriptive Flexfield
305 -- p_ppe_attribute17 No varchar2 Descriptive Flexfield
306 -- p_ppe_attribute18 No varchar2 Descriptive Flexfield
307 -- p_ppe_attribute19 No varchar2 Descriptive Flexfield
308 -- p_ppe_attribute20 No varchar2 Descriptive Flexfield
309 -- p_ppe_attribute21 No varchar2 Descriptive Flexfield
310 -- p_ppe_attribute22 No varchar2 Descriptive Flexfield
311 -- p_ppe_attribute23 No varchar2 Descriptive Flexfield
312 -- p_ppe_attribute24 No varchar2 Descriptive Flexfield
313 -- p_ppe_attribute25 No varchar2 Descriptive Flexfield
314 -- p_ppe_attribute26 No varchar2 Descriptive Flexfield
315 -- p_ppe_attribute27 No varchar2 Descriptive Flexfield
316 -- p_ppe_attribute28 No varchar2 Descriptive Flexfield
317 -- p_ppe_attribute29 No varchar2 Descriptive Flexfield
318 -- p_ppe_attribute30 No varchar2 Descriptive Flexfield
319 -- p_request_id No number
320 -- p_program_application_id No number
321 -- p_program_id No number
322 -- p_program_update_date No date
323 -- p_effective_date Yes date Session Date.
324 -- p_datetrack_mode Yes varchar2 Datetrack mode.
325 --
326 -- Post Success:
327 --
328 -- Name Type Description
329 -- p_effective_start_date Yes date Effective Start Date of Record
330 -- p_effective_end_date Yes date Effective End Date of Record
331 -- p_object_version_number No number OVN of record
332 --
333 -- Post Failure:
334 --
335 -- Access Status:
336 -- Public.
337 --
338 -- {End Of Comments}
339 --
340 procedure update_PRTT_PREM
341 (
342 p_validate in boolean default false
343 ,p_prtt_prem_id in number
344 ,p_effective_start_date out nocopy date
345 ,p_effective_end_date out nocopy date
346 ,p_std_prem_uom in varchar2 default hr_api.g_varchar2
347 ,p_std_prem_val in number default hr_api.g_number
348 ,p_actl_prem_id in number default hr_api.g_number
349 ,p_prtt_enrt_rslt_id in number default hr_api.g_number
350 ,p_per_in_ler_id in number
351 ,p_business_group_id in number default hr_api.g_number
352 ,p_ppe_attribute_category in varchar2 default hr_api.g_varchar2
353 ,p_ppe_attribute1 in varchar2 default hr_api.g_varchar2
354 ,p_ppe_attribute2 in varchar2 default hr_api.g_varchar2
355 ,p_ppe_attribute3 in varchar2 default hr_api.g_varchar2
356 ,p_ppe_attribute4 in varchar2 default hr_api.g_varchar2
357 ,p_ppe_attribute5 in varchar2 default hr_api.g_varchar2
358 ,p_ppe_attribute6 in varchar2 default hr_api.g_varchar2
359 ,p_ppe_attribute7 in varchar2 default hr_api.g_varchar2
360 ,p_ppe_attribute8 in varchar2 default hr_api.g_varchar2
361 ,p_ppe_attribute9 in varchar2 default hr_api.g_varchar2
362 ,p_ppe_attribute10 in varchar2 default hr_api.g_varchar2
363 ,p_ppe_attribute11 in varchar2 default hr_api.g_varchar2
364 ,p_ppe_attribute12 in varchar2 default hr_api.g_varchar2
365 ,p_ppe_attribute13 in varchar2 default hr_api.g_varchar2
366 ,p_ppe_attribute14 in varchar2 default hr_api.g_varchar2
367 ,p_ppe_attribute15 in varchar2 default hr_api.g_varchar2
368 ,p_ppe_attribute16 in varchar2 default hr_api.g_varchar2
369 ,p_ppe_attribute17 in varchar2 default hr_api.g_varchar2
370 ,p_ppe_attribute18 in varchar2 default hr_api.g_varchar2
371 ,p_ppe_attribute19 in varchar2 default hr_api.g_varchar2
372 ,p_ppe_attribute20 in varchar2 default hr_api.g_varchar2
373 ,p_ppe_attribute21 in varchar2 default hr_api.g_varchar2
374 ,p_ppe_attribute22 in varchar2 default hr_api.g_varchar2
375 ,p_ppe_attribute23 in varchar2 default hr_api.g_varchar2
376 ,p_ppe_attribute24 in varchar2 default hr_api.g_varchar2
377 ,p_ppe_attribute25 in varchar2 default hr_api.g_varchar2
378 ,p_ppe_attribute26 in varchar2 default hr_api.g_varchar2
379 ,p_ppe_attribute27 in varchar2 default hr_api.g_varchar2
380 ,p_ppe_attribute28 in varchar2 default hr_api.g_varchar2
381 ,p_ppe_attribute29 in varchar2 default hr_api.g_varchar2
382 ,p_ppe_attribute30 in varchar2 default hr_api.g_varchar2
383 ,p_object_version_number in out nocopy number
384 ,p_request_id in number default hr_api.g_number
385 ,p_program_application_id in number default hr_api.g_number
386 ,p_program_id in number default hr_api.g_number
387 ,p_program_update_date in date default hr_api.g_date
388 ,p_effective_date in date
389 ,p_datetrack_mode in varchar2
390 );
391 -- ----------------------------------------------------------------------------
392 -- |------------------------< update_PRTT_PREM >------------------------|
393 -- ----------------------------------------------------------------------------
394 -- {Start Of Comments}
395 --
396 -- Description:
397 --
398 -- Prerequisites:
399 --
400 --
401 -- In Parameters:
402 -- Name Reqd Type Description
403 -- p_validate Yes boolean Commit or Rollback.
404 -- p_prtt_prem_id Yes number PK of record
405 -- p_std_prem_uom No varchar2
406 -- p_std_prem_val No number
407 -- p_actl_prem_id Yes number
408 -- p_prtt_enrt_rslt_id Yes number
409 -- p_business_group_id Yes number Business Group of Record
410 -- p_ppe_attribute_category No varchar2 Descriptive Flexfield
411 -- p_ppe_attribute1 No varchar2 Descriptive Flexfield
412 -- p_ppe_attribute2 No varchar2 Descriptive Flexfield
413 -- p_ppe_attribute3 No varchar2 Descriptive Flexfield
414 -- p_ppe_attribute4 No varchar2 Descriptive Flexfield
415 -- p_ppe_attribute5 No varchar2 Descriptive Flexfield
416 -- p_ppe_attribute6 No varchar2 Descriptive Flexfield
417 -- p_ppe_attribute7 No varchar2 Descriptive Flexfield
418 -- p_ppe_attribute8 No varchar2 Descriptive Flexfield
419 -- p_ppe_attribute9 No varchar2 Descriptive Flexfield
420 -- p_ppe_attribute10 No varchar2 Descriptive Flexfield
421 -- p_ppe_attribute11 No varchar2 Descriptive Flexfield
422 -- p_ppe_attribute12 No varchar2 Descriptive Flexfield
423 -- p_ppe_attribute13 No varchar2 Descriptive Flexfield
424 -- p_ppe_attribute14 No varchar2 Descriptive Flexfield
425 -- p_ppe_attribute15 No varchar2 Descriptive Flexfield
426 -- p_ppe_attribute16 No varchar2 Descriptive Flexfield
427 -- p_ppe_attribute17 No varchar2 Descriptive Flexfield
428 -- p_ppe_attribute18 No varchar2 Descriptive Flexfield
429 -- p_ppe_attribute19 No varchar2 Descriptive Flexfield
430 -- p_ppe_attribute20 No varchar2 Descriptive Flexfield
431 -- p_ppe_attribute21 No varchar2 Descriptive Flexfield
432 -- p_ppe_attribute22 No varchar2 Descriptive Flexfield
433 -- p_ppe_attribute23 No varchar2 Descriptive Flexfield
434 -- p_ppe_attribute24 No varchar2 Descriptive Flexfield
435 -- p_ppe_attribute25 No varchar2 Descriptive Flexfield
436 -- p_ppe_attribute26 No varchar2 Descriptive Flexfield
437 -- p_ppe_attribute27 No varchar2 Descriptive Flexfield
438 -- p_ppe_attribute28 No varchar2 Descriptive Flexfield
439 -- p_ppe_attribute29 No varchar2 Descriptive Flexfield
440 -- p_ppe_attribute30 No varchar2 Descriptive Flexfield
441 -- p_request_id No number
442 -- p_program_application_id No number
443 -- p_program_id No number
444 -- p_program_update_date No date
445 -- p_effective_date Yes date Session Date.
446 -- p_datetrack_mode Yes varchar2 Datetrack mode.
447 --
448 -- Post Success:
449 --
450 -- Name Type Description
451 -- p_effective_start_date Yes date Effective Start Date of Record
452 -- p_effective_end_date Yes date Effective End Date of Record
453 -- p_object_version_number No number OVN of record
454 --
455 -- Post Failure:
456 --
457 -- Access Status:
458 -- Public.
459 --
460 -- {End Of Comments}
461 --
462 procedure update_PRTT_PREM
463 (
464 p_validate in boolean default false
465 ,p_prtt_prem_id in number
466 ,p_effective_start_date out nocopy date
467 ,p_effective_end_date out nocopy date
468 ,p_std_prem_uom in varchar2 default hr_api.g_varchar2
469 ,p_std_prem_val in number default hr_api.g_number
470 ,p_actl_prem_id in number default hr_api.g_number
471 ,p_prtt_enrt_rslt_id in number default hr_api.g_number
472 ,p_business_group_id in number default hr_api.g_number
473 ,p_ppe_attribute_category in varchar2 default hr_api.g_varchar2
474 ,p_ppe_attribute1 in varchar2 default hr_api.g_varchar2
475 ,p_ppe_attribute2 in varchar2 default hr_api.g_varchar2
476 ,p_ppe_attribute3 in varchar2 default hr_api.g_varchar2
477 ,p_ppe_attribute4 in varchar2 default hr_api.g_varchar2
478 ,p_ppe_attribute5 in varchar2 default hr_api.g_varchar2
479 ,p_ppe_attribute6 in varchar2 default hr_api.g_varchar2
480 ,p_ppe_attribute7 in varchar2 default hr_api.g_varchar2
481 ,p_ppe_attribute8 in varchar2 default hr_api.g_varchar2
482 ,p_ppe_attribute9 in varchar2 default hr_api.g_varchar2
483 ,p_ppe_attribute10 in varchar2 default hr_api.g_varchar2
484 ,p_ppe_attribute11 in varchar2 default hr_api.g_varchar2
485 ,p_ppe_attribute12 in varchar2 default hr_api.g_varchar2
486 ,p_ppe_attribute13 in varchar2 default hr_api.g_varchar2
487 ,p_ppe_attribute14 in varchar2 default hr_api.g_varchar2
488 ,p_ppe_attribute15 in varchar2 default hr_api.g_varchar2
489 ,p_ppe_attribute16 in varchar2 default hr_api.g_varchar2
490 ,p_ppe_attribute17 in varchar2 default hr_api.g_varchar2
491 ,p_ppe_attribute18 in varchar2 default hr_api.g_varchar2
492 ,p_ppe_attribute19 in varchar2 default hr_api.g_varchar2
493 ,p_ppe_attribute20 in varchar2 default hr_api.g_varchar2
494 ,p_ppe_attribute21 in varchar2 default hr_api.g_varchar2
495 ,p_ppe_attribute22 in varchar2 default hr_api.g_varchar2
496 ,p_ppe_attribute23 in varchar2 default hr_api.g_varchar2
497 ,p_ppe_attribute24 in varchar2 default hr_api.g_varchar2
498 ,p_ppe_attribute25 in varchar2 default hr_api.g_varchar2
499 ,p_ppe_attribute26 in varchar2 default hr_api.g_varchar2
500 ,p_ppe_attribute27 in varchar2 default hr_api.g_varchar2
501 ,p_ppe_attribute28 in varchar2 default hr_api.g_varchar2
502 ,p_ppe_attribute29 in varchar2 default hr_api.g_varchar2
503 ,p_ppe_attribute30 in varchar2 default hr_api.g_varchar2
504 ,p_object_version_number in out nocopy number
505 ,p_request_id in number default hr_api.g_number
506 ,p_program_application_id in number default hr_api.g_number
507 ,p_program_id in number default hr_api.g_number
508 ,p_program_update_date in date default hr_api.g_date
509 ,p_effective_date in date
510 ,p_datetrack_mode in varchar2
511 );
512 --
513 -- ----------------------------------------------------------------------------
514 -- |------------------------< delete_PRTT_PREM >------------------------|
515 -- ----------------------------------------------------------------------------
516 -- {Start Of Comments}
517 --
518 -- Description:
519 --
520 -- Prerequisites:
521 --
522 --
523 -- In Parameters:
524 -- Name Reqd Type Description
525 -- p_validate Yes boolean Commit or Rollback.
526 -- p_prtt_prem_id Yes number PK of record
527 -- p_effective_date Yes date Session Date.
528 -- p_datetrack_mode Yes varchar2 Datetrack mode.
529 --
530 -- Post Success:
531 --
532 -- Name Type Description
533 -- p_effective_start_date Yes date Effective Start Date of Record
534 -- p_effective_end_date Yes date Effective End Date of Record
535 -- p_object_version_number No number OVN of record
536 --
537 -- Post Failure:
538 --
539 -- Access Status:
540 -- Public.
541 --
542 -- {End Of Comments}
543 --
544 procedure delete_PRTT_PREM
545 (
546 p_validate in boolean default false
547 ,p_prtt_prem_id in number
548 ,p_effective_start_date out nocopy date
549 ,p_effective_end_date out nocopy date
550 ,p_object_version_number in out nocopy number
551 ,p_effective_date in date
552 ,p_datetrack_mode in varchar2
553 );
554 --
555 -- ----------------------------------------------------------------------------
556 -- |----------------------------------< lck >---------------------------------|
557 -- ----------------------------------------------------------------------------
558 -- {Start Of Comments}
559 --
560 -- Description:
561 --
562 -- Prerequisites:
563 --
564 --
565 -- In Parameters:
566 -- Name Reqd Type Description
567 -- p_prtt_prem_id Yes number PK of record
568 -- p_object_version_number Yes number OVN of record
569 -- p_effective_date Yes date Session Date.
570 -- p_datetrack_mode Yes varchar2 Datetrack mode.
571 --
572 -- Post Success:
573 --
574 -- Name Type Description
575 -- p_validation_start_date Yes Derived Effective Start Date.
576 -- p_validation_end_date Yes Derived Effective End Date.
577 --
578 -- Post Failure:
579 --
580 -- Access Status:
581 -- Public.
582 --
583 -- {End Of Comments}
584 --
585 procedure lck
586 (
587 p_prtt_prem_id in number
588 ,p_object_version_number in number
589 ,p_effective_date in date
590 ,p_datetrack_mode in varchar2
591 ,p_validation_start_date out nocopy date
592 ,p_validation_end_date out nocopy date
593 );
594 --
595 end ben_PRTT_PREM_api;
[Home] [Help]