1 Package ben_PER_CM_api as
2 /* $Header: bepcmapi.pkh 120.0 2005/05/28 10:11:52 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_PER_CM >---------------------------------|
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_lf_evt_ocrd_dt No date
18 -- p_rqstbl_untl_dt No date
19 -- p_ler_id No number
20 -- p_per_in_ler_id No number
21 -- p_prtt_enrt_actn_id No number
22 -- p_person_id Yes number
23 -- p_bnf_person_id No number
24 -- p_dpnt_person_id No number
25 -- p_cm_typ_id Yes number
26 -- p_business_group_id Yes number Business Group of Record
27 -- p_pcm_attribute_category No varchar2 Descriptive Flexfield
28 -- p_pcm_attribute1 No varchar2 Descriptive Flexfield
29 -- p_pcm_attribute2 No varchar2 Descriptive Flexfield
30 -- p_pcm_attribute3 No varchar2 Descriptive Flexfield
31 -- p_pcm_attribute4 No varchar2 Descriptive Flexfield
32 -- p_pcm_attribute5 No varchar2 Descriptive Flexfield
33 -- p_pcm_attribute6 No varchar2 Descriptive Flexfield
34 -- p_pcm_attribute7 No varchar2 Descriptive Flexfield
35 -- p_pcm_attribute8 No varchar2 Descriptive Flexfield
36 -- p_pcm_attribute9 No varchar2 Descriptive Flexfield
37 -- p_pcm_attribute10 No varchar2 Descriptive Flexfield
38 -- p_pcm_attribute11 No varchar2 Descriptive Flexfield
39 -- p_pcm_attribute12 No varchar2 Descriptive Flexfield
40 -- p_pcm_attribute13 No varchar2 Descriptive Flexfield
41 -- p_pcm_attribute14 No varchar2 Descriptive Flexfield
42 -- p_pcm_attribute15 No varchar2 Descriptive Flexfield
43 -- p_pcm_attribute16 No varchar2 Descriptive Flexfield
44 -- p_pcm_attribute17 No varchar2 Descriptive Flexfield
45 -- p_pcm_attribute18 No varchar2 Descriptive Flexfield
46 -- p_pcm_attribute19 No varchar2 Descriptive Flexfield
47 -- p_pcm_attribute20 No varchar2 Descriptive Flexfield
48 -- p_pcm_attribute21 No varchar2 Descriptive Flexfield
49 -- p_pcm_attribute22 No varchar2 Descriptive Flexfield
50 -- p_pcm_attribute23 No varchar2 Descriptive Flexfield
51 -- p_pcm_attribute24 No varchar2 Descriptive Flexfield
52 -- p_pcm_attribute25 No varchar2 Descriptive Flexfield
53 -- p_pcm_attribute26 No varchar2 Descriptive Flexfield
54 -- p_pcm_attribute27 No varchar2 Descriptive Flexfield
55 -- p_pcm_attribute28 No varchar2 Descriptive Flexfield
56 -- p_pcm_attribute29 No varchar2 Descriptive Flexfield
57 -- p_pcm_attribute30 No varchar2 Descriptive Flexfield
58 -- p_request_id No number
59 -- p_program_application_id No number
60 -- p_program_id No number
61 -- p_program_update_date No date
62 -- p_effective_date Yes date Session Date.
63 --
64 -- Post Success:
65 --
66 -- Out Parameters:
67 -- Name Type Description
68 -- p_per_cm_id Yes number PK of record
69 -- p_effective_start_date Yes date Effective Start Date of Record
70 -- p_effective_end_date Yes date Effective End Date of Record
71 -- p_object_version_number No number OVN of record
72 --
73 -- Post Failure:
74 --
75 -- Access Status:
76 -- Public.
77 --
78 -- {End Of Comments}
79 --
80 procedure create_PER_CM
81 (p_validate in boolean default false
82 ,p_per_cm_id out nocopy number
83 ,p_effective_start_date out nocopy date
84 ,p_effective_end_date out nocopy date
85 ,p_lf_evt_ocrd_dt in date default null
86 ,p_rqstbl_untl_dt in date default null
87 ,p_ler_id in number default null
88 ,p_per_in_ler_id in number default null
89 ,p_prtt_enrt_actn_id in number default null
90 ,p_person_id in number default null
91 ,p_bnf_person_id in number default null
92 ,p_dpnt_person_id in number default null
93 ,p_cm_typ_id in number default null
94 ,p_business_group_id in number default null
95 ,p_pcm_attribute_category in varchar2 default null
96 ,p_pcm_attribute1 in varchar2 default null
97 ,p_pcm_attribute2 in varchar2 default null
98 ,p_pcm_attribute3 in varchar2 default null
99 ,p_pcm_attribute4 in varchar2 default null
100 ,p_pcm_attribute5 in varchar2 default null
101 ,p_pcm_attribute6 in varchar2 default null
102 ,p_pcm_attribute7 in varchar2 default null
103 ,p_pcm_attribute8 in varchar2 default null
104 ,p_pcm_attribute9 in varchar2 default null
105 ,p_pcm_attribute10 in varchar2 default null
106 ,p_pcm_attribute11 in varchar2 default null
107 ,p_pcm_attribute12 in varchar2 default null
108 ,p_pcm_attribute13 in varchar2 default null
109 ,p_pcm_attribute14 in varchar2 default null
110 ,p_pcm_attribute15 in varchar2 default null
111 ,p_pcm_attribute16 in varchar2 default null
112 ,p_pcm_attribute17 in varchar2 default null
113 ,p_pcm_attribute18 in varchar2 default null
114 ,p_pcm_attribute19 in varchar2 default null
115 ,p_pcm_attribute20 in varchar2 default null
116 ,p_pcm_attribute21 in varchar2 default null
117 ,p_pcm_attribute22 in varchar2 default null
118 ,p_pcm_attribute23 in varchar2 default null
119 ,p_pcm_attribute24 in varchar2 default null
120 ,p_pcm_attribute25 in varchar2 default null
121 ,p_pcm_attribute26 in varchar2 default null
122 ,p_pcm_attribute27 in varchar2 default null
123 ,p_pcm_attribute28 in varchar2 default null
124 ,p_pcm_attribute29 in varchar2 default null
125 ,p_pcm_attribute30 in varchar2 default null
126 ,p_request_id in number default null
127 ,p_program_application_id in number default null
128 ,p_program_id in number default null
129 ,p_program_update_date in date default null
130 ,p_object_version_number out nocopy number
131 ,p_effective_date in date);
132 --
133 -- ----------------------------------------------------------------------------
134 -- |------------------------< create_PER_CM_perf >----------------------------|
135 -- ----------------------------------------------------------------------------
136 -- {Start Of Comments}
137 --
138 -- Description:
139 --
140 -- Prerequisites:
141 --
142 --
143 -- In Parameters:
144 -- Name Reqd Type Description
145 -- p_validate Yes boolean Commit or Rollback.
146 -- p_lf_evt_ocrd_dt No date
147 -- p_rqstbl_untl_dt No date
148 -- p_ler_id No number
149 -- p_per_in_ler_id No number
150 -- p_prtt_enrt_actn_id No number
151 -- p_person_id Yes number
152 -- p_bnf_person_id No number
153 -- p_dpnt_person_id No number
154 -- p_cm_typ_id Yes number
155 -- p_business_group_id Yes number Business Group of Record
156 -- p_pcm_attribute_category No varchar2 Descriptive Flexfield
157 -- p_pcm_attribute1 No varchar2 Descriptive Flexfield
158 -- p_pcm_attribute2 No varchar2 Descriptive Flexfield
159 -- p_pcm_attribute3 No varchar2 Descriptive Flexfield
160 -- p_pcm_attribute4 No varchar2 Descriptive Flexfield
161 -- p_pcm_attribute5 No varchar2 Descriptive Flexfield
162 -- p_pcm_attribute6 No varchar2 Descriptive Flexfield
163 -- p_pcm_attribute7 No varchar2 Descriptive Flexfield
164 -- p_pcm_attribute8 No varchar2 Descriptive Flexfield
165 -- p_pcm_attribute9 No varchar2 Descriptive Flexfield
166 -- p_pcm_attribute10 No varchar2 Descriptive Flexfield
167 -- p_pcm_attribute11 No varchar2 Descriptive Flexfield
168 -- p_pcm_attribute12 No varchar2 Descriptive Flexfield
169 -- p_pcm_attribute13 No varchar2 Descriptive Flexfield
170 -- p_pcm_attribute14 No varchar2 Descriptive Flexfield
171 -- p_pcm_attribute15 No varchar2 Descriptive Flexfield
172 -- p_pcm_attribute16 No varchar2 Descriptive Flexfield
173 -- p_pcm_attribute17 No varchar2 Descriptive Flexfield
174 -- p_pcm_attribute18 No varchar2 Descriptive Flexfield
175 -- p_pcm_attribute19 No varchar2 Descriptive Flexfield
176 -- p_pcm_attribute20 No varchar2 Descriptive Flexfield
177 -- p_pcm_attribute21 No varchar2 Descriptive Flexfield
178 -- p_pcm_attribute22 No varchar2 Descriptive Flexfield
179 -- p_pcm_attribute23 No varchar2 Descriptive Flexfield
180 -- p_pcm_attribute24 No varchar2 Descriptive Flexfield
181 -- p_pcm_attribute25 No varchar2 Descriptive Flexfield
182 -- p_pcm_attribute26 No varchar2 Descriptive Flexfield
183 -- p_pcm_attribute27 No varchar2 Descriptive Flexfield
184 -- p_pcm_attribute28 No varchar2 Descriptive Flexfield
185 -- p_pcm_attribute29 No varchar2 Descriptive Flexfield
186 -- p_pcm_attribute30 No varchar2 Descriptive Flexfield
187 -- p_request_id No number
188 -- p_program_application_id No number
189 -- p_program_id No number
190 -- p_program_update_date No date
191 -- p_effective_date Yes date Session Date.
192 --
193 -- Post Success:
194 --
195 -- Out Parameters:
196 -- Name Type Description
197 -- p_per_cm_id Yes number PK of record
198 -- p_effective_start_date Yes date Effective Start Date of Record
199 -- p_effective_end_date Yes date Effective End Date of Record
200 -- p_object_version_number No number OVN of record
201 --
202 -- Post Failure:
203 --
204 -- Access Status:
205 -- Public.
206 --
207 -- {End Of Comments}
208 --
209 procedure create_PER_CM_perf
210 (p_validate in boolean default false
211 ,p_per_cm_id out nocopy number
212 ,p_effective_start_date out nocopy date
213 ,p_effective_end_date out nocopy date
214 ,p_lf_evt_ocrd_dt in date default null
215 ,p_rqstbl_untl_dt in date default null
216 ,p_ler_id in number default null
217 ,p_per_in_ler_id in number default null
218 ,p_prtt_enrt_actn_id in number default null
219 ,p_person_id in number default null
220 ,p_bnf_person_id in number default null
221 ,p_dpnt_person_id in number default null
222 ,p_cm_typ_id in number default null
223 ,p_business_group_id in number default null
224 ,p_pcm_attribute_category in varchar2 default null
225 ,p_pcm_attribute1 in varchar2 default null
226 ,p_pcm_attribute2 in varchar2 default null
227 ,p_pcm_attribute3 in varchar2 default null
228 ,p_pcm_attribute4 in varchar2 default null
229 ,p_pcm_attribute5 in varchar2 default null
230 ,p_pcm_attribute6 in varchar2 default null
231 ,p_pcm_attribute7 in varchar2 default null
232 ,p_pcm_attribute8 in varchar2 default null
233 ,p_pcm_attribute9 in varchar2 default null
234 ,p_pcm_attribute10 in varchar2 default null
235 ,p_pcm_attribute11 in varchar2 default null
236 ,p_pcm_attribute12 in varchar2 default null
237 ,p_pcm_attribute13 in varchar2 default null
238 ,p_pcm_attribute14 in varchar2 default null
239 ,p_pcm_attribute15 in varchar2 default null
240 ,p_pcm_attribute16 in varchar2 default null
241 ,p_pcm_attribute17 in varchar2 default null
242 ,p_pcm_attribute18 in varchar2 default null
243 ,p_pcm_attribute19 in varchar2 default null
244 ,p_pcm_attribute20 in varchar2 default null
245 ,p_pcm_attribute21 in varchar2 default null
246 ,p_pcm_attribute22 in varchar2 default null
247 ,p_pcm_attribute23 in varchar2 default null
248 ,p_pcm_attribute24 in varchar2 default null
249 ,p_pcm_attribute25 in varchar2 default null
250 ,p_pcm_attribute26 in varchar2 default null
251 ,p_pcm_attribute27 in varchar2 default null
252 ,p_pcm_attribute28 in varchar2 default null
253 ,p_pcm_attribute29 in varchar2 default null
254 ,p_pcm_attribute30 in varchar2 default null
255 ,p_request_id in number default null
256 ,p_program_application_id in number default null
257 ,p_program_id in number default null
258 ,p_program_update_date in date default null
259 ,p_object_version_number out nocopy number
260 ,p_effective_date in date);
261 -- ----------------------------------------------------------------------------
262 -- |------------------------< update_PER_CM >---------------------------------|
263 -- ----------------------------------------------------------------------------
264 -- {Start Of Comments}
265 --
266 -- Description:
267 --
268 -- Prerequisites:
269 --
270 --
271 -- In Parameters:
272 -- Name Reqd Type Description
273 -- p_validate Yes boolean Commit or Rollback.
274 -- p_per_cm_id Yes number PK of record
275 -- p_lf_evt_ocrd_dt No date
276 -- p_rqstbl_untl_dt No date
277 -- p_ler_id No number
278 -- p_per_in_ler_id No number
279 -- p_prtt_enrt_actn_id No number
280 -- p_person_id Yes number
281 -- p_bnf_person_id No number
282 -- p_dpnt_person_id No number
283 -- p_cm_typ_id Yes number
284 -- p_business_group_id Yes number Business Group of Record
285 -- p_pcm_attribute_category No varchar2 Descriptive Flexfield
286 -- p_pcm_attribute1 No varchar2 Descriptive Flexfield
287 -- p_pcm_attribute2 No varchar2 Descriptive Flexfield
288 -- p_pcm_attribute3 No varchar2 Descriptive Flexfield
289 -- p_pcm_attribute4 No varchar2 Descriptive Flexfield
290 -- p_pcm_attribute5 No varchar2 Descriptive Flexfield
291 -- p_pcm_attribute6 No varchar2 Descriptive Flexfield
292 -- p_pcm_attribute7 No varchar2 Descriptive Flexfield
293 -- p_pcm_attribute8 No varchar2 Descriptive Flexfield
294 -- p_pcm_attribute9 No varchar2 Descriptive Flexfield
295 -- p_pcm_attribute10 No varchar2 Descriptive Flexfield
296 -- p_pcm_attribute11 No varchar2 Descriptive Flexfield
300 -- p_pcm_attribute15 No varchar2 Descriptive Flexfield
297 -- p_pcm_attribute12 No varchar2 Descriptive Flexfield
298 -- p_pcm_attribute13 No varchar2 Descriptive Flexfield
299 -- p_pcm_attribute14 No varchar2 Descriptive Flexfield
301 -- p_pcm_attribute16 No varchar2 Descriptive Flexfield
302 -- p_pcm_attribute17 No varchar2 Descriptive Flexfield
303 -- p_pcm_attribute18 No varchar2 Descriptive Flexfield
304 -- p_pcm_attribute19 No varchar2 Descriptive Flexfield
305 -- p_pcm_attribute20 No varchar2 Descriptive Flexfield
306 -- p_pcm_attribute21 No varchar2 Descriptive Flexfield
307 -- p_pcm_attribute22 No varchar2 Descriptive Flexfield
308 -- p_pcm_attribute23 No varchar2 Descriptive Flexfield
309 -- p_pcm_attribute24 No varchar2 Descriptive Flexfield
310 -- p_pcm_attribute25 No varchar2 Descriptive Flexfield
311 -- p_pcm_attribute26 No varchar2 Descriptive Flexfield
312 -- p_pcm_attribute27 No varchar2 Descriptive Flexfield
313 -- p_pcm_attribute28 No varchar2 Descriptive Flexfield
314 -- p_pcm_attribute29 No varchar2 Descriptive Flexfield
315 -- p_pcm_attribute30 No varchar2 Descriptive Flexfield
316 -- p_request_id No number
317 -- p_program_application_id No number
318 -- p_program_id No number
319 -- p_program_update_date No date
320 -- p_effective_date Yes date Session Date.
321 -- p_datetrack_mode Yes varchar2 Datetrack mode.
322 --
323 -- Post Success:
324 --
325 -- Name Type Description
326 -- p_effective_start_date Yes date Effective Start Date of Record
327 -- p_effective_end_date Yes date Effective End Date of Record
328 -- p_object_version_number No number OVN of record
329 --
330 -- Post Failure:
331 --
332 -- Access Status:
333 -- Public.
334 --
335 -- {End Of Comments}
336 --
337 procedure update_PER_CM
338 (p_validate in boolean default false
339 ,p_per_cm_id in number
340 ,p_effective_start_date out nocopy date
341 ,p_effective_end_date out nocopy date
342 ,p_lf_evt_ocrd_dt in date default hr_api.g_date
343 ,p_rqstbl_untl_dt in date default hr_api.g_date
344 ,p_ler_id in number default hr_api.g_number
345 ,p_per_in_ler_id in number default hr_api.g_number
346 ,p_prtt_enrt_actn_id in number default hr_api.g_number
347 ,p_person_id in number default hr_api.g_number
348 ,p_bnf_person_id in number default hr_api.g_number
349 ,p_dpnt_person_id in number default hr_api.g_number
350 ,p_cm_typ_id in number default hr_api.g_number
351 ,p_business_group_id in number default hr_api.g_number
352 ,p_pcm_attribute_category in varchar2 default hr_api.g_varchar2
353 ,p_pcm_attribute1 in varchar2 default hr_api.g_varchar2
354 ,p_pcm_attribute2 in varchar2 default hr_api.g_varchar2
355 ,p_pcm_attribute3 in varchar2 default hr_api.g_varchar2
356 ,p_pcm_attribute4 in varchar2 default hr_api.g_varchar2
357 ,p_pcm_attribute5 in varchar2 default hr_api.g_varchar2
358 ,p_pcm_attribute6 in varchar2 default hr_api.g_varchar2
359 ,p_pcm_attribute7 in varchar2 default hr_api.g_varchar2
360 ,p_pcm_attribute8 in varchar2 default hr_api.g_varchar2
361 ,p_pcm_attribute9 in varchar2 default hr_api.g_varchar2
362 ,p_pcm_attribute10 in varchar2 default hr_api.g_varchar2
363 ,p_pcm_attribute11 in varchar2 default hr_api.g_varchar2
364 ,p_pcm_attribute12 in varchar2 default hr_api.g_varchar2
365 ,p_pcm_attribute13 in varchar2 default hr_api.g_varchar2
366 ,p_pcm_attribute14 in varchar2 default hr_api.g_varchar2
367 ,p_pcm_attribute15 in varchar2 default hr_api.g_varchar2
368 ,p_pcm_attribute16 in varchar2 default hr_api.g_varchar2
369 ,p_pcm_attribute17 in varchar2 default hr_api.g_varchar2
370 ,p_pcm_attribute18 in varchar2 default hr_api.g_varchar2
371 ,p_pcm_attribute19 in varchar2 default hr_api.g_varchar2
372 ,p_pcm_attribute20 in varchar2 default hr_api.g_varchar2
373 ,p_pcm_attribute21 in varchar2 default hr_api.g_varchar2
374 ,p_pcm_attribute22 in varchar2 default hr_api.g_varchar2
375 ,p_pcm_attribute23 in varchar2 default hr_api.g_varchar2
376 ,p_pcm_attribute24 in varchar2 default hr_api.g_varchar2
377 ,p_pcm_attribute25 in varchar2 default hr_api.g_varchar2
378 ,p_pcm_attribute26 in varchar2 default hr_api.g_varchar2
379 ,p_pcm_attribute27 in varchar2 default hr_api.g_varchar2
380 ,p_pcm_attribute28 in varchar2 default hr_api.g_varchar2
381 ,p_pcm_attribute29 in varchar2 default hr_api.g_varchar2
382 ,p_pcm_attribute30 in varchar2 default hr_api.g_varchar2
383 ,p_request_id in number default hr_api.g_number
384 ,p_program_application_id in number default hr_api.g_number
385 ,p_program_id in number default hr_api.g_number
386 ,p_program_update_date in date default hr_api.g_date
387 ,p_object_version_number in out nocopy number
388 ,p_effective_date in date
389 ,p_datetrack_mode in varchar2);
390 --
391 -- ----------------------------------------------------------------------------
392 -- |------------------------< delete_PER_CM >---------------------------------|
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_per_cm_id Yes number PK of record
405 -- p_effective_date Yes date Session Date.
406 -- p_datetrack_mode Yes varchar2 Datetrack mode.
407 --
408 -- Post Success:
409 --
410 -- Name Type Description
411 -- p_effective_start_date Yes date Effective Start Date of Record
412 -- p_effective_end_date Yes date Effective End Date of Record
413 -- p_object_version_number No number OVN of record
414 --
415 -- Post Failure:
416 --
417 -- Access Status:
418 -- Public.
419 --
420 -- {End Of Comments}
421 --
422 procedure delete_PER_CM
423 (p_validate in boolean default false
424 ,p_per_cm_id in number
425 ,p_effective_start_date out nocopy date
426 ,p_effective_end_date out nocopy date
427 ,p_object_version_number in out nocopy number
428 ,p_effective_date in date
429 ,p_datetrack_mode in varchar2);
430 --
431 -- ----------------------------------------------------------------------------
432 -- |----------------------------------< lck >---------------------------------|
433 -- ----------------------------------------------------------------------------
434 -- {Start Of Comments}
435 --
436 -- Description:
437 --
438 -- Prerequisites:
439 --
440 --
441 -- In Parameters:
442 -- Name Reqd Type Description
443 -- p_per_cm_id Yes number PK of record
444 -- p_object_version_number Yes number OVN of record
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_validation_start_date Yes Derived Effective Start Date.
452 -- p_validation_end_date Yes Derived Effective End Date.
453 --
454 -- Post Failure:
455 --
456 -- Access Status:
457 -- Public.
458 --
459 -- {End Of Comments}
460 --
461 procedure lck
462 (p_per_cm_id in number
463 ,p_object_version_number in number
464 ,p_effective_date in date
465 ,p_datetrack_mode in varchar2
466 ,p_validation_start_date out nocopy date
467 ,p_validation_end_date out nocopy date);
468 --
469 -- ----------------------------------------------------------------------------
470 -- |---------------------------< create_PER_CM_W >----------------------------|
471 -- ----------------------------------------------------------------------------
472 --
473 procedure create_PER_CM_W
474 (p_per_cm_id out nocopy number
475 ,p_effective_start_date out nocopy varchar --- change
476 ,p_effective_end_date out nocopy varchar --- change
477 ,p_lf_evt_ocrd_dt in varchar default null --- change
478 ,p_ler_id in number default null
479 ,p_per_in_ler_id in number default null
480 ,p_person_id in number default null
481 ,p_cm_typ_id in number default null
482 ,p_business_group_id in number default null
483 ,p_object_version_number out nocopy number
484 ,p_effective_date in varchar
485 ,p_return_status out nocopy varchar);
486 ----
487 end ben_PER_CM_api;