1 Package ben_Person_Life_Event_api as
2 /* $Header: bepilapi.pkh 120.0 2005/05/28 10:49:48 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |----------------------< create_Person_Life_Event >------------------------|
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_per_in_ler_stat_cd No varchar2
18 -- p_prev_stat_cd No varchar2
19 -- p_lf_evt_ocrd_dt Yes date
20 -- p_trgr_table_pk_id No number
21 -- p_procd_dt No date
22 -- p_strtd_dt No date
23 -- p_voidd_dt No date
24 -- p_bckt_dt No date
25 -- p_clsd_dt No date
26 -- p_ntfn_dt No date
27 -- p_ptnl_ler_for_per_id Yes number
28 -- p_bckt_per_in_ler_id No number
29 -- p_ler_id Yes number
30 -- p_person_id Yes number
31 -- p_business_group_id Yes number Business Group of Record
32 -- p_pil_attribute_category No varchar2 Descriptive Flexfield
33 -- p_pil_attribute1 No varchar2 Descriptive Flexfield
34 -- p_pil_attribute2 No varchar2 Descriptive Flexfield
35 -- p_pil_attribute3 No varchar2 Descriptive Flexfield
36 -- p_pil_attribute4 No varchar2 Descriptive Flexfield
37 -- p_pil_attribute5 No varchar2 Descriptive Flexfield
38 -- p_pil_attribute6 No varchar2 Descriptive Flexfield
39 -- p_pil_attribute7 No varchar2 Descriptive Flexfield
40 -- p_pil_attribute8 No varchar2 Descriptive Flexfield
41 -- p_pil_attribute9 No varchar2 Descriptive Flexfield
42 -- p_pil_attribute10 No varchar2 Descriptive Flexfield
43 -- p_pil_attribute11 No varchar2 Descriptive Flexfield
44 -- p_pil_attribute12 No varchar2 Descriptive Flexfield
45 -- p_pil_attribute13 No varchar2 Descriptive Flexfield
46 -- p_pil_attribute14 No varchar2 Descriptive Flexfield
47 -- p_pil_attribute15 No varchar2 Descriptive Flexfield
48 -- p_pil_attribute16 No varchar2 Descriptive Flexfield
49 -- p_pil_attribute17 No varchar2 Descriptive Flexfield
50 -- p_pil_attribute18 No varchar2 Descriptive Flexfield
51 -- p_pil_attribute19 No varchar2 Descriptive Flexfield
52 -- p_pil_attribute20 No varchar2 Descriptive Flexfield
53 -- p_pil_attribute21 No varchar2 Descriptive Flexfield
54 -- p_pil_attribute22 No varchar2 Descriptive Flexfield
55 -- p_pil_attribute23 No varchar2 Descriptive Flexfield
56 -- p_pil_attribute24 No varchar2 Descriptive Flexfield
57 -- p_pil_attribute25 No varchar2 Descriptive Flexfield
58 -- p_pil_attribute26 No varchar2 Descriptive Flexfield
59 -- p_pil_attribute27 No varchar2 Descriptive Flexfield
60 -- p_pil_attribute28 No varchar2 Descriptive Flexfield
61 -- p_pil_attribute29 No varchar2 Descriptive Flexfield
62 -- p_pil_attribute30 No varchar2 Descriptive Flexfield
63 -- p_request_id No number
64 -- p_program_application_id No number
65 -- p_program_id No number
66 -- p_program_update_date No date
67 -- p_effective_date Yes date Session Date.
68 --
69 -- Post Success:
70 --
71 -- Out Parameters:
72 -- Name Type Description
73 -- p_per_in_ler_id Yes number PK of record
74 -- p_object_version_number No number OVN of record
75 --
76 -- Post Failure:
77 --
78 -- Access Status:
79 -- Public.
80 --
81 -- {End Of Comments}
82 --
83 procedure create_Person_Life_Event
84 (p_validate in boolean default false
85 ,p_per_in_ler_id out NOCOPY number
86 ,p_per_in_ler_stat_cd in varchar2 default null
87 ,p_prvs_stat_cd in varchar2 default null
88 ,p_lf_evt_ocrd_dt in date default null
89 ,p_trgr_table_pk_id in number default null
90 ,p_procd_dt out NOCOPY date
91 ,p_strtd_dt out NOCOPY date
92 ,p_voidd_dt out NOCOPY date
93 ,p_bckt_dt in date default null
94 ,p_clsd_dt in date default null
95 ,p_ntfn_dt in date default null
96 ,p_ptnl_ler_for_per_id in number default null
97 ,p_bckt_per_in_ler_id in number default null
98 ,p_ler_id in number default null
99 ,p_person_id in number default null
100 ,p_business_group_id in number default null
101 ,p_ASSIGNMENT_ID in number default null
102 ,p_WS_MGR_ID in number default null
103 ,p_GROUP_PL_ID in number default null
104 ,p_MGR_OVRID_PERSON_ID in number default null
105 ,p_MGR_OVRID_DT in date default null
106 ,p_pil_attribute_category in varchar2 default null
107 ,p_pil_attribute1 in varchar2 default null
108 ,p_pil_attribute2 in varchar2 default null
109 ,p_pil_attribute3 in varchar2 default null
110 ,p_pil_attribute4 in varchar2 default null
111 ,p_pil_attribute5 in varchar2 default null
112 ,p_pil_attribute6 in varchar2 default null
113 ,p_pil_attribute7 in varchar2 default null
114 ,p_pil_attribute8 in varchar2 default null
115 ,p_pil_attribute9 in varchar2 default null
116 ,p_pil_attribute10 in varchar2 default null
117 ,p_pil_attribute11 in varchar2 default null
118 ,p_pil_attribute12 in varchar2 default null
119 ,p_pil_attribute13 in varchar2 default null
120 ,p_pil_attribute14 in varchar2 default null
121 ,p_pil_attribute15 in varchar2 default null
122 ,p_pil_attribute16 in varchar2 default null
123 ,p_pil_attribute17 in varchar2 default null
124 ,p_pil_attribute18 in varchar2 default null
125 ,p_pil_attribute19 in varchar2 default null
126 ,p_pil_attribute20 in varchar2 default null
127 ,p_pil_attribute21 in varchar2 default null
128 ,p_pil_attribute22 in varchar2 default null
129 ,p_pil_attribute23 in varchar2 default null
130 ,p_pil_attribute24 in varchar2 default null
131 ,p_pil_attribute25 in varchar2 default null
132 ,p_pil_attribute26 in varchar2 default null
133 ,p_pil_attribute27 in varchar2 default null
134 ,p_pil_attribute28 in varchar2 default null
135 ,p_pil_attribute29 in varchar2 default null
136 ,p_pil_attribute30 in varchar2 default null
137 ,p_request_id in number default null
138 ,p_program_application_id in number default null
139 ,p_program_id in number default null
140 ,p_program_update_date in date default null
141 ,p_object_version_number out NOCOPY number
142 ,p_effective_date in date);
143 -- ----------------------------------------------------------------------------
144 -- |----------------------< create_Person_Life_Event_perf >-------------------|
145 -- ----------------------------------------------------------------------------
146 -- {Start Of Comments}
147 --
148 -- Description:
149 --
150 -- Prerequisites:
151 --
152 --
153 -- In Parameters:
154 -- Name Reqd Type Description
155 -- p_validate Yes boolean Commit or Rollback.
156 -- p_per_in_ler_stat_cd No varchar2
157 -- p_prvs_stat_cd No varchar2
158 -- p_lf_evt_ocrd_dt Yes date
159 -- p_trgr_table_pk_id No number
160 -- p_procd_dt No date
161 -- p_strtd_dt No date
162 -- p_voidd_dt No date
163 -- p_bckt_dt No date
164 -- p_clsd_dt No date
165 -- p_ntfn_dt No date
166 -- p_ptnl_ler_for_per_id Yes number
167 -- p_bckt_per_in_ler_id No number
168 -- p_ler_id Yes number
169 -- p_person_id Yes number
170 -- p_business_group_id Yes number Business Group of Record
171 -- p_pil_attribute_category No varchar2 Descriptive Flexfield
172 -- p_pil_attribute1 No varchar2 Descriptive Flexfield
173 -- p_pil_attribute2 No varchar2 Descriptive Flexfield
174 -- p_pil_attribute3 No varchar2 Descriptive Flexfield
175 -- p_pil_attribute4 No varchar2 Descriptive Flexfield
176 -- p_pil_attribute5 No varchar2 Descriptive Flexfield
177 -- p_pil_attribute6 No varchar2 Descriptive Flexfield
178 -- p_pil_attribute7 No varchar2 Descriptive Flexfield
179 -- p_pil_attribute8 No varchar2 Descriptive Flexfield
180 -- p_pil_attribute9 No varchar2 Descriptive Flexfield
181 -- p_pil_attribute10 No varchar2 Descriptive Flexfield
182 -- p_pil_attribute11 No varchar2 Descriptive Flexfield
183 -- p_pil_attribute12 No varchar2 Descriptive Flexfield
184 -- p_pil_attribute13 No varchar2 Descriptive Flexfield
185 -- p_pil_attribute14 No varchar2 Descriptive Flexfield
186 -- p_pil_attribute15 No varchar2 Descriptive Flexfield
187 -- p_pil_attribute16 No varchar2 Descriptive Flexfield
188 -- p_pil_attribute17 No varchar2 Descriptive Flexfield
189 -- p_pil_attribute18 No varchar2 Descriptive Flexfield
190 -- p_pil_attribute19 No varchar2 Descriptive Flexfield
191 -- p_pil_attribute20 No varchar2 Descriptive Flexfield
192 -- p_pil_attribute21 No varchar2 Descriptive Flexfield
193 -- p_pil_attribute22 No varchar2 Descriptive Flexfield
194 -- p_pil_attribute23 No varchar2 Descriptive Flexfield
195 -- p_pil_attribute24 No varchar2 Descriptive Flexfield
196 -- p_pil_attribute25 No varchar2 Descriptive Flexfield
197 -- p_pil_attribute26 No varchar2 Descriptive Flexfield
198 -- p_pil_attribute27 No varchar2 Descriptive Flexfield
199 -- p_pil_attribute28 No varchar2 Descriptive Flexfield
200 -- p_pil_attribute29 No varchar2 Descriptive Flexfield
201 -- p_pil_attribute30 No varchar2 Descriptive Flexfield
202 -- p_request_id No number
203 -- p_program_application_id No number
204 -- p_program_id No number
205 -- p_program_update_date No date
206 -- p_effective_date Yes date Session Date.
207 --
208 -- Post Success:
209 --
210 -- Out Parameters:
211 -- Name Type Description
212 -- p_per_in_ler_id Yes number PK of record
213 -- p_object_version_number No number OVN of record
214 --
215 -- Post Failure:
216 --
217 -- Access Status:
218 -- Public.
219 --
220 -- {End Of Comments}
221 --
222 procedure create_Person_Life_Event_perf
223 (p_validate in boolean default false
224 ,p_per_in_ler_id out NOCOPY number
225 ,p_per_in_ler_stat_cd in varchar2 default null
226 ,p_prvs_stat_cd in varchar2 default null
227 ,p_lf_evt_ocrd_dt in date default null
228 ,p_trgr_table_pk_id in number default null
229 ,p_procd_dt out NOCOPY date
230 ,p_strtd_dt out NOCOPY date
231 ,p_voidd_dt out NOCOPY date
232 ,p_bckt_dt in date default null
233 ,p_clsd_dt in date default null
234 ,p_ntfn_dt in date default null
235 ,p_ptnl_ler_for_per_id in number default null
236 ,p_bckt_per_in_ler_id in number default null
237 ,p_ler_id in number default null
238 ,p_person_id in number default null
239 ,p_business_group_id in number default null
240 ,p_ASSIGNMENT_ID in number default null
241 ,p_WS_MGR_ID in number default null
242 ,p_GROUP_PL_ID in number default null
243 ,p_MGR_OVRID_PERSON_ID in number default null
244 ,p_MGR_OVRID_DT in date default null
245 ,p_pil_attribute_category in varchar2 default null
246 ,p_pil_attribute1 in varchar2 default null
247 ,p_pil_attribute2 in varchar2 default null
248 ,p_pil_attribute3 in varchar2 default null
249 ,p_pil_attribute4 in varchar2 default null
250 ,p_pil_attribute5 in varchar2 default null
251 ,p_pil_attribute6 in varchar2 default null
252 ,p_pil_attribute7 in varchar2 default null
253 ,p_pil_attribute8 in varchar2 default null
254 ,p_pil_attribute9 in varchar2 default null
255 ,p_pil_attribute10 in varchar2 default null
256 ,p_pil_attribute11 in varchar2 default null
257 ,p_pil_attribute12 in varchar2 default null
258 ,p_pil_attribute13 in varchar2 default null
259 ,p_pil_attribute14 in varchar2 default null
260 ,p_pil_attribute15 in varchar2 default null
261 ,p_pil_attribute16 in varchar2 default null
262 ,p_pil_attribute17 in varchar2 default null
263 ,p_pil_attribute18 in varchar2 default null
264 ,p_pil_attribute19 in varchar2 default null
265 ,p_pil_attribute20 in varchar2 default null
266 ,p_pil_attribute21 in varchar2 default null
267 ,p_pil_attribute22 in varchar2 default null
268 ,p_pil_attribute23 in varchar2 default null
269 ,p_pil_attribute24 in varchar2 default null
270 ,p_pil_attribute25 in varchar2 default null
271 ,p_pil_attribute26 in varchar2 default null
272 ,p_pil_attribute27 in varchar2 default null
273 ,p_pil_attribute28 in varchar2 default null
274 ,p_pil_attribute29 in varchar2 default null
275 ,p_pil_attribute30 in varchar2 default null
276 ,p_request_id in number default null
277 ,p_program_application_id in number default null
278 ,p_program_id in number default null
279 ,p_program_update_date in date default null
280 ,p_object_version_number out NOCOPY number
281 ,p_effective_date in date);
282 -- ----------------------------------------------------------------------------
283 -- |----------------------< update_Person_Life_Event >------------------------|
287 -- Description:
284 -- ----------------------------------------------------------------------------
285 -- {Start Of Comments}
286 --
288 --
289 -- Prerequisites:
290 --
291 --
292 -- In Parameters:
293 -- Name Reqd Type Description
294 -- p_validate Yes boolean Commit or Rollback.
295 -- p_per_in_ler_id Yes number PK of record
296 -- p_per_in_ler_stat_cd No varchar2
297 -- p_prvs_stat_cd No varchar2
298 -- p_lf_evt_ocrd_dt Yes date
299 -- p_trgr_table_pk_id No number
300 -- p_procd_dt No date
301 -- p_strtd_dt No date
302 -- p_voidd_dt No date
303 -- p_bckt_dt No date
304 -- p_clsd_dt No date
305 -- p_ntfn_dt No date
306 -- p_ptnl_ler_for_per_id Yes number
307 -- p_bckt_per_in_ler_id No number
308 -- p_ler_id Yes number
309 -- p_person_id Yes number
310 -- p_business_group_id Yes number Business Group of Record
311 -- p_pil_attribute_category No varchar2 Descriptive Flexfield
312 -- p_pil_attribute1 No varchar2 Descriptive Flexfield
313 -- p_pil_attribute2 No varchar2 Descriptive Flexfield
314 -- p_pil_attribute3 No varchar2 Descriptive Flexfield
315 -- p_pil_attribute4 No varchar2 Descriptive Flexfield
316 -- p_pil_attribute5 No varchar2 Descriptive Flexfield
317 -- p_pil_attribute6 No varchar2 Descriptive Flexfield
318 -- p_pil_attribute7 No varchar2 Descriptive Flexfield
319 -- p_pil_attribute8 No varchar2 Descriptive Flexfield
320 -- p_pil_attribute9 No varchar2 Descriptive Flexfield
321 -- p_pil_attribute10 No varchar2 Descriptive Flexfield
322 -- p_pil_attribute11 No varchar2 Descriptive Flexfield
323 -- p_pil_attribute12 No varchar2 Descriptive Flexfield
324 -- p_pil_attribute13 No varchar2 Descriptive Flexfield
325 -- p_pil_attribute14 No varchar2 Descriptive Flexfield
326 -- p_pil_attribute15 No varchar2 Descriptive Flexfield
327 -- p_pil_attribute16 No varchar2 Descriptive Flexfield
328 -- p_pil_attribute17 No varchar2 Descriptive Flexfield
329 -- p_pil_attribute18 No varchar2 Descriptive Flexfield
330 -- p_pil_attribute19 No varchar2 Descriptive Flexfield
331 -- p_pil_attribute20 No varchar2 Descriptive Flexfield
332 -- p_pil_attribute21 No varchar2 Descriptive Flexfield
333 -- p_pil_attribute22 No varchar2 Descriptive Flexfield
334 -- p_pil_attribute23 No varchar2 Descriptive Flexfield
335 -- p_pil_attribute24 No varchar2 Descriptive Flexfield
336 -- p_pil_attribute25 No varchar2 Descriptive Flexfield
337 -- p_pil_attribute26 No varchar2 Descriptive Flexfield
338 -- p_pil_attribute27 No varchar2 Descriptive Flexfield
339 -- p_pil_attribute28 No varchar2 Descriptive Flexfield
340 -- p_pil_attribute29 No varchar2 Descriptive Flexfield
341 -- p_pil_attribute30 No varchar2 Descriptive Flexfield
342 -- p_request_id No number
343 -- p_program_application_id No number
344 -- p_program_id No number
345 -- p_program_update_date No date
346 -- p_effective_date Yes date Session Date.
347 --
348 -- Post Success:
349 --
350 -- Name Type Description
351 -- p_object_version_number No number OVN of record
352 --
353 -- Post Failure:
354 --
355 -- Access Status:
356 -- Public.
357 --
358 -- {End Of Comments}
359 --
360 procedure update_Person_Life_Event
361 (p_validate in boolean default false
362 ,p_per_in_ler_id in number
363 ,p_per_in_ler_stat_cd in varchar2 default hr_api.g_varchar2
364 ,p_prvs_stat_cd in varchar2 default hr_api.g_varchar2
365 ,p_lf_evt_ocrd_dt in date default hr_api.g_date
366 ,p_trgr_table_pk_id in number default hr_api.g_number
367 ,p_procd_dt out NOCOPY date
368 ,p_strtd_dt out NOCOPY date
369 ,p_voidd_dt out NOCOPY date
370 ,p_bckt_dt in date default hr_api.g_date
371 ,p_clsd_dt in date default hr_api.g_date
372 ,p_ntfn_dt in date default hr_api.g_date
373 ,p_ptnl_ler_for_per_id in number default hr_api.g_number
374 ,p_bckt_per_in_ler_id in number default hr_api.g_number
375 ,p_ler_id in number default hr_api.g_number
376 ,p_person_id in number default hr_api.g_number
377 ,p_business_group_id in number default hr_api.g_number
378 ,p_ASSIGNMENT_ID in number default hr_api.g_number
379 ,p_WS_MGR_ID in number default hr_api.g_number
380 ,p_GROUP_PL_ID in number default hr_api.g_number
381 ,p_MGR_OVRID_PERSON_ID in number default hr_api.g_number
382 ,p_MGR_OVRID_DT in date default hr_api.g_date
386 ,p_pil_attribute3 in varchar2 default hr_api.g_varchar2
383 ,p_pil_attribute_category in varchar2 default hr_api.g_varchar2
384 ,p_pil_attribute1 in varchar2 default hr_api.g_varchar2
385 ,p_pil_attribute2 in varchar2 default hr_api.g_varchar2
387 ,p_pil_attribute4 in varchar2 default hr_api.g_varchar2
388 ,p_pil_attribute5 in varchar2 default hr_api.g_varchar2
389 ,p_pil_attribute6 in varchar2 default hr_api.g_varchar2
390 ,p_pil_attribute7 in varchar2 default hr_api.g_varchar2
391 ,p_pil_attribute8 in varchar2 default hr_api.g_varchar2
392 ,p_pil_attribute9 in varchar2 default hr_api.g_varchar2
393 ,p_pil_attribute10 in varchar2 default hr_api.g_varchar2
394 ,p_pil_attribute11 in varchar2 default hr_api.g_varchar2
395 ,p_pil_attribute12 in varchar2 default hr_api.g_varchar2
396 ,p_pil_attribute13 in varchar2 default hr_api.g_varchar2
397 ,p_pil_attribute14 in varchar2 default hr_api.g_varchar2
398 ,p_pil_attribute15 in varchar2 default hr_api.g_varchar2
399 ,p_pil_attribute16 in varchar2 default hr_api.g_varchar2
400 ,p_pil_attribute17 in varchar2 default hr_api.g_varchar2
401 ,p_pil_attribute18 in varchar2 default hr_api.g_varchar2
402 ,p_pil_attribute19 in varchar2 default hr_api.g_varchar2
403 ,p_pil_attribute20 in varchar2 default hr_api.g_varchar2
404 ,p_pil_attribute21 in varchar2 default hr_api.g_varchar2
405 ,p_pil_attribute22 in varchar2 default hr_api.g_varchar2
406 ,p_pil_attribute23 in varchar2 default hr_api.g_varchar2
407 ,p_pil_attribute24 in varchar2 default hr_api.g_varchar2
408 ,p_pil_attribute25 in varchar2 default hr_api.g_varchar2
409 ,p_pil_attribute26 in varchar2 default hr_api.g_varchar2
410 ,p_pil_attribute27 in varchar2 default hr_api.g_varchar2
411 ,p_pil_attribute28 in varchar2 default hr_api.g_varchar2
412 ,p_pil_attribute29 in varchar2 default hr_api.g_varchar2
413 ,p_pil_attribute30 in varchar2 default hr_api.g_varchar2
414 ,p_request_id in number default hr_api.g_number
415 ,p_program_application_id in number default hr_api.g_number
416 ,p_program_id in number default hr_api.g_number
417 ,p_program_update_date in date default hr_api.g_date
418 ,p_object_version_number in out NOCOPY number
419 ,p_effective_date in date);
420 --
421 -- ----------------------------------------------------------------------------
422 -- |----------------------< delete_Person_Life_Event >------------------------|
423 -- ----------------------------------------------------------------------------
424 -- {Start Of Comments}
425 --
426 -- Description:
427 --
428 -- Prerequisites:
429 --
430 --
431 -- In Parameters:
432 -- Name Reqd Type Description
433 -- p_validate Yes boolean Commit or Rollback.
434 -- p_per_in_ler_id Yes number PK of record
435 -- p_effective_date Yes date Session Date.
436 --
437 -- Post Success:
438 --
439 -- Name Type Description
440 -- p_object_version_number No number OVN of record
441 --
442 -- Post Failure:
443 --
444 -- Access Status:
445 -- Public.
446 --
447 -- {End Of Comments}
448 --
449 procedure delete_Person_Life_Event
450 (p_validate in boolean default false
451 ,p_per_in_ler_id in number
452 ,p_object_version_number in out NOCOPY number
453 ,p_effective_date in date);
454 --
455 -- ----------------------------------------------------------------------------
456 -- |----------------------------------< lck >---------------------------------|
457 -- ----------------------------------------------------------------------------
458 -- {Start Of Comments}
459 --
460 -- Description:
461 --
462 -- Prerequisites:
463 --
464 --
465 -- In Parameters:
466 -- Name Reqd Type Description
467 -- p_per_in_ler_id Yes number PK of record
468 -- p_object_version_number Yes number OVN of record
469 --
470 -- Post Success:
471 --
472 -- Name Type Description
473 --
474 -- Post Failure:
475 --
476 -- Access Status:
477 -- Public.
478 --
479 -- {End Of Comments}
480 --
481 procedure lck
482 (p_per_in_ler_id in number
483 ,p_object_version_number in number);
484 --
485 end ben_Person_Life_Event_api;