DBA Data[Home] [Help]

PACKAGE: APPS.BEN_PER_CM_PRVDD_API

Source


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