1 Package ben_PRMRY_CARE_PRVDR_api AUTHID CURRENT_USER as
2 /* $Header: bepprapi.pkh 120.1.12000000.1 2007/01/19 21:49:51 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |--------------------< determine_datetrack_mode >---------------------------|
6 -- ----------------------------------------------------------------------------
7 procedure determine_datetrack_mode
8 (p_effective_date in date
9 ,p_base_key_value in number
10 ,p_desired_datetrack_mode in varchar2
11 ,p_mini_mode in varchar2
12 ,p_datetrack_allow in out nocopy varchar2
13 );
14
15 -- ----------------------------------------------------------------------------
16 -- |------------------------< create_PRMRY_CARE_PRVDR >------------------------|
17 -- ----------------------------------------------------------------------------
18 -- {Start Of Comments}
19 --
20 -- Description:
21 --
22 -- Prerequisites:
23 --
24 --
25 -- In Parameters:
26 -- Name Reqd Type Description
27 -- p_validate Yes boolean Commit or Rollback.
28 -- p_prmry_care_prvdr_typ_cd Yes varchar2
29 -- p_name Yes varchar2
30 -- p_ext_ident No varchar2
31 -- p_prtt_enrt_rslt_id No number
32 -- p_elig_cvrd_dpnt_id No number
33 -- p_business_group_id Yes number Business Group of Record
34 -- p_ppr_attribute_category No varchar2 Descriptive Flexfield
35 -- p_ppr_attribute1 No varchar2 Descriptive Flexfield
36 -- p_ppr_attribute2 No varchar2 Descriptive Flexfield
37 -- p_ppr_attribute3 No varchar2 Descriptive Flexfield
38 -- p_ppr_attribute4 No varchar2 Descriptive Flexfield
39 -- p_ppr_attribute5 No varchar2 Descriptive Flexfield
40 -- p_ppr_attribute6 No varchar2 Descriptive Flexfield
41 -- p_ppr_attribute7 No varchar2 Descriptive Flexfield
42 -- p_ppr_attribute8 No varchar2 Descriptive Flexfield
43 -- p_ppr_attribute9 No varchar2 Descriptive Flexfield
44 -- p_ppr_attribute10 No varchar2 Descriptive Flexfield
45 -- p_ppr_attribute11 No varchar2 Descriptive Flexfield
46 -- p_ppr_attribute12 No varchar2 Descriptive Flexfield
47 -- p_ppr_attribute13 No varchar2 Descriptive Flexfield
48 -- p_ppr_attribute14 No varchar2 Descriptive Flexfield
49 -- p_ppr_attribute15 No varchar2 Descriptive Flexfield
50 -- p_ppr_attribute16 No varchar2 Descriptive Flexfield
51 -- p_ppr_attribute17 No varchar2 Descriptive Flexfield
52 -- p_ppr_attribute18 No varchar2 Descriptive Flexfield
53 -- p_ppr_attribute19 No varchar2 Descriptive Flexfield
54 -- p_ppr_attribute20 No varchar2 Descriptive Flexfield
55 -- p_ppr_attribute21 No varchar2 Descriptive Flexfield
56 -- p_ppr_attribute22 No varchar2 Descriptive Flexfield
57 -- p_ppr_attribute23 No varchar2 Descriptive Flexfield
58 -- p_ppr_attribute24 No varchar2 Descriptive Flexfield
59 -- p_ppr_attribute25 No varchar2 Descriptive Flexfield
60 -- p_ppr_attribute26 No varchar2 Descriptive Flexfield
61 -- p_ppr_attribute27 No varchar2 Descriptive Flexfield
62 -- p_ppr_attribute28 No varchar2 Descriptive Flexfield
63 -- p_ppr_attribute29 No varchar2 Descriptive Flexfield
64 -- p_ppr_attribute30 No varchar2 Descriptive Flexfield
65 -- p_request_id No number
66 -- p_program_application_id No number
67 -- p_program_id No number
68 -- p_program_update_date No date
69 -- p_effective_date Yes date Session Date.
70 --
71 -- Post Success:
72 --
73 -- Out Parameters:
74 -- Name Type Description
75 -- p_prmry_care_prvdr_id Yes number PK of record
76 -- p_effective_start_date Yes date Effective Start Date of Record
77 -- p_effective_end_date Yes date Effective End Date of Record
78 -- p_object_version_number No number OVN of record
79 --
80 -- Post Failure:
81 --
82 -- Access Status:
83 -- Public.
84 --
85 -- {End Of Comments}
86 --
87 procedure create_PRMRY_CARE_PRVDR
88 (
89 p_validate in boolean default false
90 ,p_prmry_care_prvdr_id out nocopy number
91 ,p_effective_start_date out nocopy date
92 ,p_effective_end_date out nocopy date
93 ,p_prmry_care_prvdr_typ_cd in varchar2 default null
94 ,p_name in varchar2 default null
95 ,p_ext_ident in varchar2 default null
96 ,p_prtt_enrt_rslt_id in number default null
97 ,p_elig_cvrd_dpnt_id in number default null
98 ,p_business_group_id in number default null
99 ,p_ppr_attribute_category in varchar2 default null
100 ,p_ppr_attribute1 in varchar2 default null
101 ,p_ppr_attribute2 in varchar2 default null
102 ,p_ppr_attribute3 in varchar2 default null
103 ,p_ppr_attribute4 in varchar2 default null
104 ,p_ppr_attribute5 in varchar2 default null
105 ,p_ppr_attribute6 in varchar2 default null
106 ,p_ppr_attribute7 in varchar2 default null
107 ,p_ppr_attribute8 in varchar2 default null
108 ,p_ppr_attribute9 in varchar2 default null
109 ,p_ppr_attribute10 in varchar2 default null
110 ,p_ppr_attribute11 in varchar2 default null
111 ,p_ppr_attribute12 in varchar2 default null
112 ,p_ppr_attribute13 in varchar2 default null
113 ,p_ppr_attribute14 in varchar2 default null
114 ,p_ppr_attribute15 in varchar2 default null
115 ,p_ppr_attribute16 in varchar2 default null
116 ,p_ppr_attribute17 in varchar2 default null
117 ,p_ppr_attribute18 in varchar2 default null
118 ,p_ppr_attribute19 in varchar2 default null
119 ,p_ppr_attribute20 in varchar2 default null
120 ,p_ppr_attribute21 in varchar2 default null
121 ,p_ppr_attribute22 in varchar2 default null
122 ,p_ppr_attribute23 in varchar2 default null
123 ,p_ppr_attribute24 in varchar2 default null
124 ,p_ppr_attribute25 in varchar2 default null
125 ,p_ppr_attribute26 in varchar2 default null
126 ,p_ppr_attribute27 in varchar2 default null
127 ,p_ppr_attribute28 in varchar2 default null
128 ,p_ppr_attribute29 in varchar2 default null
129 ,p_ppr_attribute30 in varchar2 default null
130 ,p_request_id in number default null
131 ,p_program_application_id in number default null
132 ,p_program_id in number default null
136 );
133 ,p_program_update_date in date default null
134 ,p_object_version_number out nocopy number
135 ,p_effective_date in date
137 --
138 -- ----------------------------------------------------------------------------
139 -- |----------------------< create_prmry_care_prvdr_w >-----------------------|
140 -- ----------------------------------------------------------------------------
141 -- {Start Of Comments}
142 --
143 -- Description: Wrapper for self service development
144 --
145 -- Prerequisites:
146 --
147 --
148 -- In Parameters:
149 -- Name Reqd Type Description
150 -- p_prmry_care_prvdr_typ_cd Yes varchar2
151 -- p_name Yes varchar2
152 -- p_ext_ident No varchar2
153 -- p_prtt_enrt_rslt_id No number
154 -- p_elig_cvrd_dpnt_id No number
155 -- p_business_group_id Yes number Business Group of Record
156 -- p_effective_date Yes date Session Date.
157 --
158 -- Post Success:
159 --
160 -- Out Parameters:
161 -- Name Type Description
162 -- p_prmry_care_prvdr_id Yes number PK of record
163 -- p_effective_start_date Yes date Effective Start Date of Record
164 -- p_effective_end_date Yes date Effective End Date of Record
165 -- p_object_version_number No number OVN of record
166 --
167 -- Post Failure:
168 --
169 -- Access Status:
170 -- Public.
171 --
172 -- {End Of Comments}
173 --
174 procedure create_prmry_care_prvdr_w
175 (
176 p_prmry_care_prvdr_id out nocopy number
177 ,p_effective_start_date out nocopy date
178 ,p_effective_end_date out nocopy date
179 ,p_prmry_care_prvdr_typ_cd in varchar2 default null
180 ,p_name in varchar2 default null
181 ,p_ext_ident in varchar2 default null
182 ,p_prtt_enrt_rslt_id in number default null
183 ,p_elig_cvrd_dpnt_id in number default null
184 ,p_business_group_id in number default null
185 ,p_object_version_number out nocopy number
186 ,p_effective_date in date
187 ,p_return_status out nocopy varchar2
188 );
189 --
190 -- ----------------------------------------------------------------------------
191 -- |------------------------< update_PRMRY_CARE_PRVDR >-----------------------|
192 -- ----------------------------------------------------------------------------
193 -- {Start Of Comments}
194 --
195 -- Description:
196 --
197 -- Prerequisites:
198 --
199 --
200 -- In Parameters:
201 -- Name Reqd Type Description
202 -- p_validate Yes boolean Commit or Rollback.
203 -- p_prmry_care_prvdr_id Yes number PK of record
204 -- p_prmry_care_prvdr_typ_cd Yes varchar2
205 -- p_name Yes varchar2
206 -- p_ext_ident No varchar2
207 -- p_prtt_enrt_rslt_id No number
208 -- p_elig_cvrd_dpnt_id No number
209 -- p_business_group_id Yes number Business Group of Record
210 -- p_ppr_attribute_category No varchar2 Descriptive Flexfield
211 -- p_ppr_attribute1 No varchar2 Descriptive Flexfield
212 -- p_ppr_attribute2 No varchar2 Descriptive Flexfield
213 -- p_ppr_attribute3 No varchar2 Descriptive Flexfield
214 -- p_ppr_attribute4 No varchar2 Descriptive Flexfield
215 -- p_ppr_attribute5 No varchar2 Descriptive Flexfield
216 -- p_ppr_attribute6 No varchar2 Descriptive Flexfield
217 -- p_ppr_attribute7 No varchar2 Descriptive Flexfield
218 -- p_ppr_attribute8 No varchar2 Descriptive Flexfield
219 -- p_ppr_attribute9 No varchar2 Descriptive Flexfield
220 -- p_ppr_attribute10 No varchar2 Descriptive Flexfield
221 -- p_ppr_attribute11 No varchar2 Descriptive Flexfield
222 -- p_ppr_attribute12 No varchar2 Descriptive Flexfield
223 -- p_ppr_attribute13 No varchar2 Descriptive Flexfield
224 -- p_ppr_attribute14 No varchar2 Descriptive Flexfield
225 -- p_ppr_attribute15 No varchar2 Descriptive Flexfield
226 -- p_ppr_attribute16 No varchar2 Descriptive Flexfield
227 -- p_ppr_attribute17 No varchar2 Descriptive Flexfield
228 -- p_ppr_attribute18 No varchar2 Descriptive Flexfield
229 -- p_ppr_attribute19 No varchar2 Descriptive Flexfield
230 -- p_ppr_attribute20 No varchar2 Descriptive Flexfield
231 -- p_ppr_attribute21 No varchar2 Descriptive Flexfield
232 -- p_ppr_attribute22 No varchar2 Descriptive Flexfield
233 -- p_ppr_attribute23 No varchar2 Descriptive Flexfield
234 -- p_ppr_attribute24 No varchar2 Descriptive Flexfield
235 -- p_ppr_attribute25 No varchar2 Descriptive Flexfield
236 -- p_ppr_attribute26 No varchar2 Descriptive Flexfield
237 -- p_ppr_attribute27 No varchar2 Descriptive Flexfield
238 -- p_ppr_attribute28 No varchar2 Descriptive Flexfield
239 -- p_ppr_attribute29 No varchar2 Descriptive Flexfield
240 -- p_ppr_attribute30 No varchar2 Descriptive Flexfield
241 -- p_request_id No number
242 -- p_program_application_id No number
243 -- p_program_id No number
244 -- p_program_update_date No date
245 -- p_effective_date Yes date Session Date.
246 -- p_datetrack_mode Yes varchar2 Datetrack mode.
247 --
248 -- Post Success:
249 --
250 -- Name Type Description
251 -- p_effective_start_date Yes date Effective Start Date of Record
252 -- p_effective_end_date Yes date Effective End Date of Record
253 -- p_object_version_number No number OVN of record
254 --
255 -- Post Failure:
256 --
257 -- Access Status:
258 -- Public.
259 --
260 -- {End Of Comments}
261 --
262 procedure update_PRMRY_CARE_PRVDR
263 (
264 p_validate in boolean default false
265 ,p_prmry_care_prvdr_id in number
266 ,p_effective_start_date out nocopy date
267 ,p_effective_end_date out nocopy date
268 ,p_prmry_care_prvdr_typ_cd in varchar2 default hr_api.g_varchar2
269 ,p_name in varchar2 default hr_api.g_varchar2
270 ,p_ext_ident in varchar2 default hr_api.g_varchar2
271 ,p_prtt_enrt_rslt_id in number default hr_api.g_number
272 ,p_elig_cvrd_dpnt_id in number default hr_api.g_number
273 ,p_business_group_id in number default hr_api.g_number
274 ,p_ppr_attribute_category in varchar2 default hr_api.g_varchar2
275 ,p_ppr_attribute1 in varchar2 default hr_api.g_varchar2
276 ,p_ppr_attribute2 in varchar2 default hr_api.g_varchar2
277 ,p_ppr_attribute3 in varchar2 default hr_api.g_varchar2
278 ,p_ppr_attribute4 in varchar2 default hr_api.g_varchar2
279 ,p_ppr_attribute5 in varchar2 default hr_api.g_varchar2
280 ,p_ppr_attribute6 in varchar2 default hr_api.g_varchar2
281 ,p_ppr_attribute7 in varchar2 default hr_api.g_varchar2
282 ,p_ppr_attribute8 in varchar2 default hr_api.g_varchar2
283 ,p_ppr_attribute9 in varchar2 default hr_api.g_varchar2
284 ,p_ppr_attribute10 in varchar2 default hr_api.g_varchar2
285 ,p_ppr_attribute11 in varchar2 default hr_api.g_varchar2
286 ,p_ppr_attribute12 in varchar2 default hr_api.g_varchar2
287 ,p_ppr_attribute13 in varchar2 default hr_api.g_varchar2
288 ,p_ppr_attribute14 in varchar2 default hr_api.g_varchar2
289 ,p_ppr_attribute15 in varchar2 default hr_api.g_varchar2
290 ,p_ppr_attribute16 in varchar2 default hr_api.g_varchar2
291 ,p_ppr_attribute17 in varchar2 default hr_api.g_varchar2
292 ,p_ppr_attribute18 in varchar2 default hr_api.g_varchar2
293 ,p_ppr_attribute19 in varchar2 default hr_api.g_varchar2
294 ,p_ppr_attribute20 in varchar2 default hr_api.g_varchar2
295 ,p_ppr_attribute21 in varchar2 default hr_api.g_varchar2
296 ,p_ppr_attribute22 in varchar2 default hr_api.g_varchar2
297 ,p_ppr_attribute23 in varchar2 default hr_api.g_varchar2
298 ,p_ppr_attribute24 in varchar2 default hr_api.g_varchar2
299 ,p_ppr_attribute25 in varchar2 default hr_api.g_varchar2
300 ,p_ppr_attribute26 in varchar2 default hr_api.g_varchar2
301 ,p_ppr_attribute27 in varchar2 default hr_api.g_varchar2
302 ,p_ppr_attribute28 in varchar2 default hr_api.g_varchar2
303 ,p_ppr_attribute29 in varchar2 default hr_api.g_varchar2
304 ,p_ppr_attribute30 in varchar2 default hr_api.g_varchar2
305 ,p_request_id in number default hr_api.g_number
306 ,p_program_application_id in number default hr_api.g_number
307 ,p_program_id in number default hr_api.g_number
308 ,p_program_update_date in date default hr_api.g_date
309 ,p_object_version_number in out nocopy number
310 ,p_effective_date in date
311 ,p_datetrack_mode in varchar2
312 );
313 --
314 -- ----------------------------------------------------------------------------
315 -- |-----------------------< update_prmry_care_prvdr_w >----------------------|
316 -- ----------------------------------------------------------------------------
317 -- {Start Of Comments}
318 --
319 -- Description: Wrapper for self service development
320 --
321 -- Prerequisites:
322 --
323 --
324 -- In Parameters:
325 -- Name Reqd Type Description
326 -- p_prmry_care_prvdr_id Yes number PK of record
327 -- p_prmry_care_prvdr_typ_cd Yes varchar2
331 -- p_elig_cvrd_dpnt_id No number
328 -- p_name Yes varchar2
329 -- p_ext_ident No varchar2
330 -- p_prtt_enrt_rslt_id No number
332 -- p_business_group_id Yes number Business Group of Record
333 -- p_effective_date Yes date Session Date.
334 -- p_datetrack_mode Yes varchar2 Datetrack mode.
335 --
336 -- Post Success:
337 --
338 -- Name Type Description
339 -- p_effective_start_date Yes date Effective Start Date of Record
340 -- p_effective_end_date Yes date Effective End Date of Record
341 -- p_object_version_number No number OVN of record
342 --
343 -- Post Failure:
344 --
345 -- Access Status:
346 -- Public.
347 --
348 -- {End Of Comments}
349 --
350 procedure update_prmry_care_prvdr_w
351 (
352 p_prmry_care_prvdr_id in number
353 ,p_effective_start_date out nocopy date
354 ,p_effective_end_date out nocopy date
355 ,p_prmry_care_prvdr_typ_cd in varchar2 default hr_api.g_varchar2
356 ,p_name in varchar2 default hr_api.g_varchar2
357 ,p_ext_ident in varchar2 default hr_api.g_varchar2
358 ,p_prtt_enrt_rslt_id in number default hr_api.g_number
359 ,p_elig_cvrd_dpnt_id in number default hr_api.g_number
360 ,p_business_group_id in number default hr_api.g_number
361 ,p_object_version_number in out nocopy number
362 ,p_effective_date in date
363 ,p_datetrack_mode in varchar2
364 ,p_return_status out nocopy varchar2
365 );
366 --
367 -- ----------------------------------------------------------------------------
368 -- |------------------------< delete_PRMRY_CARE_PRVDR >-----------------------|
369 -- ----------------------------------------------------------------------------
370 -- {Start Of Comments}
371 --
372 -- Description:
373 --
374 -- Prerequisites:
375 --
376 --
377 -- In Parameters:
378 -- Name Reqd Type Description
379 -- p_validate Yes boolean Commit or Rollback.
380 -- p_prmry_care_prvdr_id Yes number PK of record
381 -- p_effective_date Yes date Session Date.
382 -- p_datetrack_mode Yes varchar2 Datetrack mode.
383 --
384 -- Post Success:
385 --
386 -- Name Type Description
387 -- p_effective_start_date Yes date Effective Start Date of Record
388 -- p_effective_end_date Yes date Effective End Date of Record
389 -- p_object_version_number No number OVN of record
390 --
391 -- Post Failure:
392 --
393 -- Access Status:
394 -- Public.
395 --
396 -- {End Of Comments}
397 --
398 procedure delete_PRMRY_CARE_PRVDR
399 (
400 p_validate in boolean default false
401 ,p_prmry_care_prvdr_id in number
402 ,p_effective_start_date out nocopy date
403 ,p_effective_end_date out nocopy date
404 ,p_object_version_number in out nocopy number
405 ,p_effective_date in date
406 ,p_datetrack_mode in varchar2
407 ,p_called_from in varchar2 default null
408 );
409 --
410 -- ----------------------------------------------------------------------------
411 -- |-----------------------< delete_prmry_care_prvdr_w >----------------------|
412 -- ----------------------------------------------------------------------------
413 -- {Start Of Comments}
414 --
415 -- Description: Wrapper for self service development
416 --
417 -- Prerequisites:
418 --
419 --
420 -- In Parameters:
421 -- Name Reqd Type Description
422 -- p_validate Yes boolean Commit or Rollback.
423 -- p_prmry_care_prvdr_id Yes number PK of record
424 -- p_effective_date Yes date Session Date.
425 -- p_datetrack_mode Yes varchar2 Datetrack mode.
426 --
427 -- Post Success:
428 --
429 -- Name Type Description
430 -- p_effective_start_date Yes date Effective Start Date of Record
431 -- p_effective_end_date Yes date Effective End Date of Record
432 -- p_object_version_number No number OVN of record
433 --
434 -- Post Failure:
435 --
436 -- Access Status:
437 -- Public.
438 --
439 -- {End Of Comments}
440 --
441 procedure delete_prmry_care_prvdr_w
442 (
443 p_prmry_care_prvdr_id in number
444 ,p_effective_start_date out nocopy date
445 ,p_effective_end_date out nocopy date
446 ,p_object_version_number in out nocopy number
447 ,p_effective_date in date
448 ,p_datetrack_mode in varchar2
449 ,p_return_status out nocopy varchar2
450 );
451 --
452 -- ----------------------------------------------------------------------------
453 -- |----------------------------------< lck >---------------------------------|
454 -- ----------------------------------------------------------------------------
455 -- {Start Of Comments}
456 --
457 -- Description:
458 --
459 -- Prerequisites:
460 --
461 --
462 -- In Parameters:
463 -- Name Reqd Type Description
464 -- p_prmry_care_prvdr_id Yes number PK of record
465 -- p_object_version_number Yes number OVN of record
466 -- p_effective_date Yes date Session Date.
467 -- p_datetrack_mode Yes varchar2 Datetrack mode.
468 --
469 -- Post Success:
470 --
471 -- Name Type Description
472 -- p_validation_start_date Yes Derived Effective Start Date.
473 -- p_validation_end_date Yes Derived Effective End Date.
474 --
475 -- Post Failure:
476 --
477 -- Access Status:
478 -- Public.
479 --
480 -- {End Of Comments}
481 --
482 procedure lck
483 (
484 p_prmry_care_prvdr_id in number
485 ,p_object_version_number in number
486 ,p_effective_date in date
487 ,p_datetrack_mode in varchar2
488 ,p_validation_start_date out nocopy date
489 ,p_validation_end_date out nocopy date
490 );
491 --
492 -- ----------------------------------------------------------------------------
493 -- |---------------------------< pcp_actn_items >-----------------|
494 -- ----------------------------------------------------------------------------
495 procedure pcp_actn_items
496 (
497 p_prtt_enrt_rslt_id in number
498 ,p_elig_cvrd_dpnt_id in number
499 ,p_effective_date in date
500 ,p_business_group_id in number
501 ,p_validate in boolean default false
502 ,p_datetrack_mode in varchar2
503 );
504 --
505 end ben_PRMRY_CARE_PRVDR_api;