DBA Data[Home] [Help]

PACKAGE BODY: APPS.BEN_PRTT_ANTHR_PL_RT_API

Source


1 Package Body ben_PRTT_ANTHR_PL_RT_api as
2 /* $Header: bepapapi.pkb 115.1 2002/12/11 11:27:26 lakrish noship $ */
3 --
4 -- Package Variables
5 --
6 g_package  varchar2(33) := '  ben_PRTT_ANTHR_PL_RT_api.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |------------------------< create_PRTT_ANTHR_PL_RT >----------------------|
10 -- ----------------------------------------------------------------------------
11 --
12 procedure create_PRTT_ANTHR_PL_RT
13   (p_validate                       in  boolean   default false
14   ,p_prtt_anthr_pl_rt_id     out nocopy number
15   ,p_effective_start_date           out nocopy date
16   ,p_effective_end_date             out nocopy date
17   ,p_excld_flag                     in  varchar2  default null
18   ,p_ordr_num                       in  number    default null
19   ,p_vrbl_rt_prfl_id                  in  number    default null
20   ,p_pl_id                          in  number    default null
21   ,p_business_group_id              in  number    default null
22   ,p_pap_attribute_category         in  varchar2  default null
23   ,p_pap_attribute1                 in  varchar2  default null
24   ,p_pap_attribute2                 in  varchar2  default null
25   ,p_pap_attribute3                 in  varchar2  default null
26   ,p_pap_attribute4                 in  varchar2  default null
27   ,p_pap_attribute5                 in  varchar2  default null
28   ,p_pap_attribute6                 in  varchar2  default null
29   ,p_pap_attribute7                 in  varchar2  default null
30   ,p_pap_attribute8                 in  varchar2  default null
31   ,p_pap_attribute9                 in  varchar2  default null
32   ,p_pap_attribute10                in  varchar2  default null
33   ,p_pap_attribute11                in  varchar2  default null
34   ,p_pap_attribute12                in  varchar2  default null
35   ,p_pap_attribute13                in  varchar2  default null
36   ,p_pap_attribute14                in  varchar2  default null
37   ,p_pap_attribute15                in  varchar2  default null
38   ,p_pap_attribute16                in  varchar2  default null
39   ,p_pap_attribute17                in  varchar2  default null
40   ,p_pap_attribute18                in  varchar2  default null
41   ,p_pap_attribute19                in  varchar2  default null
42   ,p_pap_attribute20                in  varchar2  default null
43   ,p_pap_attribute21                in  varchar2  default null
44   ,p_pap_attribute22                in  varchar2  default null
45   ,p_pap_attribute23                in  varchar2  default null
46   ,p_pap_attribute24                in  varchar2  default null
47   ,p_pap_attribute25                in  varchar2  default null
48   ,p_pap_attribute26                in  varchar2  default null
49   ,p_pap_attribute27                in  varchar2  default null
50   ,p_pap_attribute28                in  varchar2  default null
51   ,p_pap_attribute29                in  varchar2  default null
52   ,p_pap_attribute30                in  varchar2  default null
53   ,p_object_version_number          out nocopy number
54   ,p_effective_date                 in  date
55   ) is
56   --
57   -- Declare cursors and local variables
58   --
59   l_prtt_anthr_pl_rt_id ben_prtt_anthr_pl_rt_f.prtt_anthr_pl_rt_id%TYPE;
60   l_effective_start_date ben_prtt_anthr_pl_rt_f.effective_start_date%TYPE;
61   l_effective_end_date ben_prtt_anthr_pl_rt_f.effective_end_date%TYPE;
62   l_proc varchar2(72) := g_package||'create_PRTT_ANTHR_PL_RT';
63   l_object_version_number ben_prtt_anthr_pl_rt_f.object_version_number%TYPE;
64   --
65 begin
66   --
67   hr_utility.set_location('Entering:'|| l_proc, 10);
68   --
69   -- Issue a savepoint if operating in validation only mode
70   --
71   savepoint create_PRTT_ANTHR_PL_RT;
72   --
73   hr_utility.set_location(l_proc, 20);
74   --
75   -- Process Logic
76   --
77   begin
78     --
79     -- Start of API User Hook for the before hook of create_PRTT_ANTHR_PL_RT
80     --
81     ben_PRTT_ANTHR_PL_RT_bk1.create_PRTT_ANTHR_PL_RT_b
82       (
83        p_excld_flag                     =>  p_excld_flag
84       ,p_ordr_num                       =>  p_ordr_num
85       ,p_vrbl_rt_prfl_id                  =>  p_vrbl_rt_prfl_id
86       ,p_pl_id                          =>  p_pl_id
87       ,p_business_group_id              =>  p_business_group_id
88       ,p_pap_attribute_category         =>  p_pap_attribute_category
89       ,p_pap_attribute1                 =>  p_pap_attribute1
90       ,p_pap_attribute2                 =>  p_pap_attribute2
91       ,p_pap_attribute3                 =>  p_pap_attribute3
92       ,p_pap_attribute4                 =>  p_pap_attribute4
93       ,p_pap_attribute5                 =>  p_pap_attribute5
94       ,p_pap_attribute6                 =>  p_pap_attribute6
95       ,p_pap_attribute7                 =>  p_pap_attribute7
96       ,p_pap_attribute8                 =>  p_pap_attribute8
97       ,p_pap_attribute9                 =>  p_pap_attribute9
98       ,p_pap_attribute10                =>  p_pap_attribute10
99       ,p_pap_attribute11                =>  p_pap_attribute11
100       ,p_pap_attribute12                =>  p_pap_attribute12
101       ,p_pap_attribute13                =>  p_pap_attribute13
102       ,p_pap_attribute14                =>  p_pap_attribute14
103       ,p_pap_attribute15                =>  p_pap_attribute15
104       ,p_pap_attribute16                =>  p_pap_attribute16
105       ,p_pap_attribute17                =>  p_pap_attribute17
106       ,p_pap_attribute18                =>  p_pap_attribute18
107       ,p_pap_attribute19                =>  p_pap_attribute19
108       ,p_pap_attribute20                =>  p_pap_attribute20
109       ,p_pap_attribute21                =>  p_pap_attribute21
110       ,p_pap_attribute22                =>  p_pap_attribute22
111       ,p_pap_attribute23                =>  p_pap_attribute23
112       ,p_pap_attribute24                =>  p_pap_attribute24
113       ,p_pap_attribute25                =>  p_pap_attribute25
114       ,p_pap_attribute26                =>  p_pap_attribute26
115       ,p_pap_attribute27                =>  p_pap_attribute27
116       ,p_pap_attribute28                =>  p_pap_attribute28
117       ,p_pap_attribute29                =>  p_pap_attribute29
118       ,p_pap_attribute30                =>  p_pap_attribute30
119       ,p_effective_date                 => trunc(p_effective_date)
120       );
121   exception
122     when hr_api.cannot_find_prog_unit then
123       hr_api.cannot_find_prog_unit_error
124         (
125          p_module_name => 'CREATE_PRTT_ANTHR_PL_RT'
126         ,p_hook_type   => 'BP'
127         );
128     --
129     -- End of API User Hook for the before hook of create_PRTT_ANTHR_PL_RT
130     --
131   end;
132   --
133   ben_pap_ins.ins
134     (
135      p_prtt_anthr_pl_rt_id    => l_prtt_anthr_pl_rt_id
136     ,p_effective_start_date          => l_effective_start_date
137     ,p_effective_end_date            => l_effective_end_date
138     ,p_excld_flag                    => p_excld_flag
139     ,p_ordr_num                      => p_ordr_num
140     ,p_vrbl_rt_prfl_id                 => p_vrbl_rt_prfl_id
141     ,p_pl_id                         => p_pl_id
142     ,p_business_group_id             => p_business_group_id
143     ,p_pap_attribute_category        => p_pap_attribute_category
144     ,p_pap_attribute1                => p_pap_attribute1
145     ,p_pap_attribute2                => p_pap_attribute2
146     ,p_pap_attribute3                => p_pap_attribute3
147     ,p_pap_attribute4                => p_pap_attribute4
148     ,p_pap_attribute5                => p_pap_attribute5
149     ,p_pap_attribute6                => p_pap_attribute6
150     ,p_pap_attribute7                => p_pap_attribute7
151     ,p_pap_attribute8                => p_pap_attribute8
152     ,p_pap_attribute9                => p_pap_attribute9
153     ,p_pap_attribute10               => p_pap_attribute10
154     ,p_pap_attribute11               => p_pap_attribute11
155     ,p_pap_attribute12               => p_pap_attribute12
156     ,p_pap_attribute13               => p_pap_attribute13
157     ,p_pap_attribute14               => p_pap_attribute14
158     ,p_pap_attribute15               => p_pap_attribute15
159     ,p_pap_attribute16               => p_pap_attribute16
160     ,p_pap_attribute17               => p_pap_attribute17
161     ,p_pap_attribute18               => p_pap_attribute18
162     ,p_pap_attribute19               => p_pap_attribute19
163     ,p_pap_attribute20               => p_pap_attribute20
164     ,p_pap_attribute21               => p_pap_attribute21
165     ,p_pap_attribute22               => p_pap_attribute22
166     ,p_pap_attribute23               => p_pap_attribute23
167     ,p_pap_attribute24               => p_pap_attribute24
168     ,p_pap_attribute25               => p_pap_attribute25
169     ,p_pap_attribute26               => p_pap_attribute26
170     ,p_pap_attribute27               => p_pap_attribute27
171     ,p_pap_attribute28               => p_pap_attribute28
172     ,p_pap_attribute29               => p_pap_attribute29
173     ,p_pap_attribute30               => p_pap_attribute30
174     ,p_object_version_number         => l_object_version_number
175     ,p_effective_date                => trunc(p_effective_date)
176     );
177   --
178   begin
179     --
180     -- Start of API User Hook for the after hook of create_PRTT_ANTHR_PL_RT
181     --
182     ben_PRTT_ANTHR_PL_RT_bk1.create_PRTT_ANTHR_PL_RT_a
183       (
184        p_prtt_anthr_pl_rt_id     =>  l_prtt_anthr_pl_rt_id
185       ,p_effective_start_date           =>  l_effective_start_date
186       ,p_effective_end_date             =>  l_effective_end_date
187       ,p_excld_flag                     =>  p_excld_flag
188       ,p_ordr_num                       =>  p_ordr_num
189       ,p_vrbl_rt_prfl_id                  =>  p_vrbl_rt_prfl_id
190       ,p_pl_id                          =>  p_pl_id
191       ,p_business_group_id              =>  p_business_group_id
192       ,p_pap_attribute_category         =>  p_pap_attribute_category
193       ,p_pap_attribute1                 =>  p_pap_attribute1
194       ,p_pap_attribute2                 =>  p_pap_attribute2
195       ,p_pap_attribute3                 =>  p_pap_attribute3
196       ,p_pap_attribute4                 =>  p_pap_attribute4
197       ,p_pap_attribute5                 =>  p_pap_attribute5
198       ,p_pap_attribute6                 =>  p_pap_attribute6
199       ,p_pap_attribute7                 =>  p_pap_attribute7
200       ,p_pap_attribute8                 =>  p_pap_attribute8
201       ,p_pap_attribute9                 =>  p_pap_attribute9
202       ,p_pap_attribute10                =>  p_pap_attribute10
203       ,p_pap_attribute11                =>  p_pap_attribute11
204       ,p_pap_attribute12                =>  p_pap_attribute12
205       ,p_pap_attribute13                =>  p_pap_attribute13
206       ,p_pap_attribute14                =>  p_pap_attribute14
207       ,p_pap_attribute15                =>  p_pap_attribute15
208       ,p_pap_attribute16                =>  p_pap_attribute16
209       ,p_pap_attribute17                =>  p_pap_attribute17
210       ,p_pap_attribute18                =>  p_pap_attribute18
211       ,p_pap_attribute19                =>  p_pap_attribute19
212       ,p_pap_attribute20                =>  p_pap_attribute20
213       ,p_pap_attribute21                =>  p_pap_attribute21
214       ,p_pap_attribute22                =>  p_pap_attribute22
215       ,p_pap_attribute23                =>  p_pap_attribute23
216       ,p_pap_attribute24                =>  p_pap_attribute24
217       ,p_pap_attribute25                =>  p_pap_attribute25
218       ,p_pap_attribute26                =>  p_pap_attribute26
219       ,p_pap_attribute27                =>  p_pap_attribute27
220       ,p_pap_attribute28                =>  p_pap_attribute28
221       ,p_pap_attribute29                =>  p_pap_attribute29
222       ,p_pap_attribute30                =>  p_pap_attribute30
223       ,p_object_version_number          =>  l_object_version_number
224       ,p_effective_date                      => trunc(p_effective_date)
225       );
226   exception
227     when hr_api.cannot_find_prog_unit then
228       hr_api.cannot_find_prog_unit_error
229         (p_module_name => 'CREATE_PRTT_ANTHR_PL_RT'
230         ,p_hook_type   => 'AP'
231         );
232     --
233     -- End of API User Hook for the after hook of create_PRTT_ANTHR_PL_RT
234     --
235   end;
236   --
237   ben_profile_handler.event_handler
238     (p_event                       => 'CREATE',
239      p_base_table                  => 'BEN_VRBL_RT_PRFL_F',
240      p_base_table_column           => 'VRBL_RT_PRFL_ID',
241      p_base_table_column_value     => p_vrbl_rt_prfl_id,
242      p_base_table_reference_column => 'RT_PRTT_ANTHR_PL_FLAG',
243      p_reference_table             => 'BEN_prtt_anthr_pl_rt_F',
244      p_reference_table_column      => 'VRBL_RT_PRFL_ID');
245   --
246   hr_utility.set_location(l_proc, 60);
247   --
248   -- When in validation only mode raise the Validate_Enabled exception
249   --
250   if p_validate then
251     raise hr_api.validate_enabled;
252   end if;
253   --
254   -- Set all output arguments
255   --
256   p_prtt_anthr_pl_rt_id := l_prtt_anthr_pl_rt_id;
257   p_effective_start_date := l_effective_start_date;
258   p_effective_end_date := l_effective_end_date;
259   p_object_version_number := l_object_version_number;
260   --
261   hr_utility.set_location(' Leaving:'||l_proc, 70);
262   --
263 exception
264   --
265   when hr_api.validate_enabled then
266     --
267     -- As the Validate_Enabled exception has been raised
268     -- we must rollback to the savepoint
269     --
270     ROLLBACK TO create_PRTT_ANTHR_PL_RT;
271     --
272     -- Only set output warning arguments
273     -- (Any key or derived arguments must be set to null
274     -- when validation only mode is being used.)
275     --
276     p_prtt_anthr_pl_rt_id := null;
277     p_effective_start_date := null;
278     p_effective_end_date := null;
279     p_object_version_number  := null;
280     hr_utility.set_location(' Leaving:'||l_proc, 80);
281     --
282   when others then
283     --
284     -- A validation or unexpected error has occured
285     --
286     ROLLBACK TO create_PRTT_ANTHR_PL_RT;
287 
288     -- NOCOPY, Reset out parameters
289     p_prtt_anthr_pl_rt_id := null;
290     p_effective_start_date := null;
291     p_effective_end_date := null;
292     p_object_version_number  := null;
293 
294     raise;
295     --
296 end create_PRTT_ANTHR_PL_RT;
297 -- ----------------------------------------------------------------------------
298 -- |------------------------< update_PRTT_ANTHR_PL_RT >--- ------------------|
299 -- ----------------------------------------------------------------------------
300 --
301 procedure update_PRTT_ANTHR_PL_RT
302   (p_validate                       in  boolean   default false
303   ,p_prtt_anthr_pl_rt_id     in  number
304   ,p_effective_start_date           out nocopy date
305   ,p_effective_end_date             out nocopy date
306   ,p_excld_flag                     in  varchar2  default hr_api.g_varchar2
307   ,p_ordr_num                       in  number    default hr_api.g_number
308   ,p_vrbl_rt_prfl_id                  in  number    default hr_api.g_number
309   ,p_pl_id                          in  number    default hr_api.g_number
310   ,p_business_group_id              in  number    default hr_api.g_number
311   ,p_pap_attribute_category         in  varchar2  default hr_api.g_varchar2
312   ,p_pap_attribute1                 in  varchar2  default hr_api.g_varchar2
313   ,p_pap_attribute2                 in  varchar2  default hr_api.g_varchar2
314   ,p_pap_attribute3                 in  varchar2  default hr_api.g_varchar2
315   ,p_pap_attribute4                 in  varchar2  default hr_api.g_varchar2
316   ,p_pap_attribute5                 in  varchar2  default hr_api.g_varchar2
320   ,p_pap_attribute9                 in  varchar2  default hr_api.g_varchar2
317   ,p_pap_attribute6                 in  varchar2  default hr_api.g_varchar2
318   ,p_pap_attribute7                 in  varchar2  default hr_api.g_varchar2
319   ,p_pap_attribute8                 in  varchar2  default hr_api.g_varchar2
321   ,p_pap_attribute10                in  varchar2  default hr_api.g_varchar2
322   ,p_pap_attribute11                in  varchar2  default hr_api.g_varchar2
323   ,p_pap_attribute12                in  varchar2  default hr_api.g_varchar2
324   ,p_pap_attribute13                in  varchar2  default hr_api.g_varchar2
325   ,p_pap_attribute14                in  varchar2  default hr_api.g_varchar2
326   ,p_pap_attribute15                in  varchar2  default hr_api.g_varchar2
327   ,p_pap_attribute16                in  varchar2  default hr_api.g_varchar2
328   ,p_pap_attribute17                in  varchar2  default hr_api.g_varchar2
329   ,p_pap_attribute18                in  varchar2  default hr_api.g_varchar2
330   ,p_pap_attribute19                in  varchar2  default hr_api.g_varchar2
331   ,p_pap_attribute20                in  varchar2  default hr_api.g_varchar2
332   ,p_pap_attribute21                in  varchar2  default hr_api.g_varchar2
333   ,p_pap_attribute22                in  varchar2  default hr_api.g_varchar2
334   ,p_pap_attribute23                in  varchar2  default hr_api.g_varchar2
335   ,p_pap_attribute24                in  varchar2  default hr_api.g_varchar2
336   ,p_pap_attribute25                in  varchar2  default hr_api.g_varchar2
337   ,p_pap_attribute26                in  varchar2  default hr_api.g_varchar2
338   ,p_pap_attribute27                in  varchar2  default hr_api.g_varchar2
339   ,p_pap_attribute28                in  varchar2  default hr_api.g_varchar2
340   ,p_pap_attribute29                in  varchar2  default hr_api.g_varchar2
341   ,p_pap_attribute30                in  varchar2  default hr_api.g_varchar2
342   ,p_object_version_number          in out nocopy number
343   ,p_effective_date                 in  date
344   ,p_datetrack_mode                 in  varchar2
345   ) is
346   --
347   -- Declare cursors and local variables
348   --
349   l_proc varchar2(72) := g_package||'update_PRTT_ANTHR_PL_RT';
350   l_object_version_number ben_prtt_anthr_pl_rt_f.object_version_number%TYPE;
351   l_effective_start_date ben_prtt_anthr_pl_rt_f.effective_start_date%TYPE;
352   l_effective_end_date ben_prtt_anthr_pl_rt_f.effective_end_date%TYPE;
353   --
354 begin
355   --
356   hr_utility.set_location('Entering:'|| l_proc, 10);
357   --
358   -- Issue a savepoint if operating in validation only mode
359   --
360   savepoint update_PRTT_ANTHR_PL_RT;
361   --
362   hr_utility.set_location(l_proc, 20);
363   --
364   -- Process Logic
365   --
366   l_object_version_number := p_object_version_number;
367   --
368   begin
369     --
370     -- Start of API User Hook for the before hook of update_PRTT_ANTHR_PL_RT
371     --
372     ben_PRTT_ANTHR_PL_RT_bk2.update_PRTT_ANTHR_PL_RT_b
373       (
374        p_prtt_anthr_pl_rt_id     =>  p_prtt_anthr_pl_rt_id
375       ,p_excld_flag                     =>  p_excld_flag
376       ,p_ordr_num                       =>  p_ordr_num
377       ,p_vrbl_rt_prfl_id                  =>  p_vrbl_rt_prfl_id
378       ,p_pl_id                          =>  p_pl_id
379       ,p_business_group_id              =>  p_business_group_id
380       ,p_pap_attribute_category         =>  p_pap_attribute_category
381       ,p_pap_attribute1                 =>  p_pap_attribute1
382       ,p_pap_attribute2                 =>  p_pap_attribute2
383       ,p_pap_attribute3                 =>  p_pap_attribute3
384       ,p_pap_attribute4                 =>  p_pap_attribute4
385       ,p_pap_attribute5                 =>  p_pap_attribute5
386       ,p_pap_attribute6                 =>  p_pap_attribute6
387       ,p_pap_attribute7                 =>  p_pap_attribute7
388       ,p_pap_attribute8                 =>  p_pap_attribute8
389       ,p_pap_attribute9                 =>  p_pap_attribute9
390       ,p_pap_attribute10                =>  p_pap_attribute10
391       ,p_pap_attribute11                =>  p_pap_attribute11
392       ,p_pap_attribute12                =>  p_pap_attribute12
393       ,p_pap_attribute13                =>  p_pap_attribute13
394       ,p_pap_attribute14                =>  p_pap_attribute14
395       ,p_pap_attribute15                =>  p_pap_attribute15
396       ,p_pap_attribute16                =>  p_pap_attribute16
397       ,p_pap_attribute17                =>  p_pap_attribute17
398       ,p_pap_attribute18                =>  p_pap_attribute18
399       ,p_pap_attribute19                =>  p_pap_attribute19
400       ,p_pap_attribute20                =>  p_pap_attribute20
401       ,p_pap_attribute21                =>  p_pap_attribute21
402       ,p_pap_attribute22                =>  p_pap_attribute22
403       ,p_pap_attribute23                =>  p_pap_attribute23
404       ,p_pap_attribute24                =>  p_pap_attribute24
405       ,p_pap_attribute25                =>  p_pap_attribute25
406       ,p_pap_attribute26                =>  p_pap_attribute26
407       ,p_pap_attribute27                =>  p_pap_attribute27
408       ,p_pap_attribute28                =>  p_pap_attribute28
409       ,p_pap_attribute29                =>  p_pap_attribute29
410       ,p_pap_attribute30                =>  p_pap_attribute30
411       ,p_object_version_number          =>  p_object_version_number
412     ,p_effective_date                      => trunc(p_effective_date)
413     ,p_datetrack_mode                      => p_datetrack_mode
414       );
415   exception
416     when hr_api.cannot_find_prog_unit then
417       hr_api.cannot_find_prog_unit_error
421     --
418         (p_module_name => 'UPDATE_PRTT_ANTHR_PL_RT'
419         ,p_hook_type   => 'BP'
420         );
422     -- End of API User Hook for the before hook of update_PRTT_ANTHR_PL_RT
423     --
424   end;
425   --
426   ben_pap_upd.upd
427     (
428      p_prtt_anthr_pl_rt_id    => p_prtt_anthr_pl_rt_id
429     ,p_effective_start_date          => l_effective_start_date
430     ,p_effective_end_date            => l_effective_end_date
431     ,p_excld_flag                    => p_excld_flag
432     ,p_ordr_num                      => p_ordr_num
433     ,p_vrbl_rt_prfl_id                 => p_vrbl_rt_prfl_id
434     ,p_pl_id                         => p_pl_id
435     ,p_business_group_id             => p_business_group_id
436     ,p_pap_attribute_category        => p_pap_attribute_category
437     ,p_pap_attribute1                => p_pap_attribute1
438     ,p_pap_attribute2                => p_pap_attribute2
439     ,p_pap_attribute3                => p_pap_attribute3
440     ,p_pap_attribute4                => p_pap_attribute4
441     ,p_pap_attribute5                => p_pap_attribute5
442     ,p_pap_attribute6                => p_pap_attribute6
443     ,p_pap_attribute7                => p_pap_attribute7
444     ,p_pap_attribute8                => p_pap_attribute8
445     ,p_pap_attribute9                => p_pap_attribute9
446     ,p_pap_attribute10               => p_pap_attribute10
447     ,p_pap_attribute11               => p_pap_attribute11
448     ,p_pap_attribute12               => p_pap_attribute12
449     ,p_pap_attribute13               => p_pap_attribute13
450     ,p_pap_attribute14               => p_pap_attribute14
451     ,p_pap_attribute15               => p_pap_attribute15
452     ,p_pap_attribute16               => p_pap_attribute16
453     ,p_pap_attribute17               => p_pap_attribute17
454     ,p_pap_attribute18               => p_pap_attribute18
455     ,p_pap_attribute19               => p_pap_attribute19
456     ,p_pap_attribute20               => p_pap_attribute20
457     ,p_pap_attribute21               => p_pap_attribute21
458     ,p_pap_attribute22               => p_pap_attribute22
459     ,p_pap_attribute23               => p_pap_attribute23
460     ,p_pap_attribute24               => p_pap_attribute24
461     ,p_pap_attribute25               => p_pap_attribute25
462     ,p_pap_attribute26               => p_pap_attribute26
463     ,p_pap_attribute27               => p_pap_attribute27
464     ,p_pap_attribute28               => p_pap_attribute28
465     ,p_pap_attribute29               => p_pap_attribute29
466     ,p_pap_attribute30               => p_pap_attribute30
467     ,p_object_version_number         => l_object_version_number
468     ,p_effective_date                => trunc(p_effective_date)
469     ,p_datetrack_mode                => p_datetrack_mode
470     );
471   --
472   begin
473     --
474     -- Start of API User Hook for the after hook of update_PRTT_ANTHR_PL_RT
475     --
476     ben_PRTT_ANTHR_PL_RT_bk2.update_PRTT_ANTHR_PL_RT_a
477       (
478        p_prtt_anthr_pl_rt_id     =>  p_prtt_anthr_pl_rt_id
479       ,p_effective_start_date           =>  l_effective_start_date
480       ,p_effective_end_date             =>  l_effective_end_date
481       ,p_excld_flag                     =>  p_excld_flag
482       ,p_ordr_num                       =>  p_ordr_num
483       ,p_vrbl_rt_prfl_id                  =>  p_vrbl_rt_prfl_id
484       ,p_pl_id                          =>  p_pl_id
485       ,p_business_group_id              =>  p_business_group_id
486       ,p_pap_attribute_category         =>  p_pap_attribute_category
487       ,p_pap_attribute1                 =>  p_pap_attribute1
488       ,p_pap_attribute2                 =>  p_pap_attribute2
489       ,p_pap_attribute3                 =>  p_pap_attribute3
490       ,p_pap_attribute4                 =>  p_pap_attribute4
491       ,p_pap_attribute5                 =>  p_pap_attribute5
492       ,p_pap_attribute6                 =>  p_pap_attribute6
493       ,p_pap_attribute7                 =>  p_pap_attribute7
494       ,p_pap_attribute8                 =>  p_pap_attribute8
495       ,p_pap_attribute9                 =>  p_pap_attribute9
496       ,p_pap_attribute10                =>  p_pap_attribute10
497       ,p_pap_attribute11                =>  p_pap_attribute11
498       ,p_pap_attribute12                =>  p_pap_attribute12
499       ,p_pap_attribute13                =>  p_pap_attribute13
500       ,p_pap_attribute14                =>  p_pap_attribute14
501       ,p_pap_attribute15                =>  p_pap_attribute15
502       ,p_pap_attribute16                =>  p_pap_attribute16
503       ,p_pap_attribute17                =>  p_pap_attribute17
504       ,p_pap_attribute18                =>  p_pap_attribute18
505       ,p_pap_attribute19                =>  p_pap_attribute19
506       ,p_pap_attribute20                =>  p_pap_attribute20
507       ,p_pap_attribute21                =>  p_pap_attribute21
508       ,p_pap_attribute22                =>  p_pap_attribute22
509       ,p_pap_attribute23                =>  p_pap_attribute23
510       ,p_pap_attribute24                =>  p_pap_attribute24
511       ,p_pap_attribute25                =>  p_pap_attribute25
512       ,p_pap_attribute26                =>  p_pap_attribute26
513       ,p_pap_attribute27                =>  p_pap_attribute27
514       ,p_pap_attribute28                =>  p_pap_attribute28
515       ,p_pap_attribute29                =>  p_pap_attribute29
516       ,p_pap_attribute30                =>  p_pap_attribute30
517       ,p_object_version_number          =>  l_object_version_number
518       ,p_effective_date                     => trunc(p_effective_date)
519       ,p_datetrack_mode                     => p_datetrack_mode
520       );
524         (p_module_name => 'UPDATE_PRTT_ANTHR_PL_RT'
521   exception
522     when hr_api.cannot_find_prog_unit then
523       hr_api.cannot_find_prog_unit_error
525         ,p_hook_type   => 'AP'
526         );
527     --
528     -- End of API User Hook for the after hook of update_PRTT_ANTHR_PL_RT
529     --
530   end;
531   --
532   hr_utility.set_location(l_proc, 60);
533   --
534   -- When in validation only mode raise the Validate_Enabled exception
535   --
536   if p_validate then
537     raise hr_api.validate_enabled;
538   end if;
539   --
540   -- Set all output arguments
541   --
542   p_object_version_number := l_object_version_number;
543   p_effective_start_date := l_effective_start_date;
544   p_effective_end_date := l_effective_end_date;
545   --
546   hr_utility.set_location(' Leaving:'||l_proc, 70);
547   --
548 exception
549   --
550   when hr_api.validate_enabled then
551     --
552     -- As the Validate_Enabled exception has been raised
553     -- we must rollback to the savepoint
554     --
555     ROLLBACK TO update_PRTT_ANTHR_PL_RT;
556     --
557     -- Only set output warning arguments
558     -- (Any key or derived arguments must be set to null
559     -- when validation only mode is being used.)
560     --
561     p_effective_start_date := null;
562     p_effective_end_date   := null;
563 
564     hr_utility.set_location(' Leaving:'||l_proc, 80);
565     --
566   when others then
567     --
568     -- A validation or unexpected error has occured
569     --
570     ROLLBACK TO update_PRTT_ANTHR_PL_RT;
571 
572     -- NOCOPY, Reset out parameters
573     p_effective_start_date := null;
574     p_effective_end_date   := null;
575 
576     raise;
577     --
578 end update_PRTT_ANTHR_PL_RT;
579 -- ----------------------------------------------------------------------------
580 -- |------------------------< delete_PRTT_ANTHR_PL_RT >----------------------|
581 -- ----------------------------------------------------------------------------
582 --
583 procedure delete_PRTT_ANTHR_PL_RT
584   (p_validate                       in  boolean  default false
585   ,p_prtt_anthr_pl_rt_id     in  number
586   ,p_effective_start_date           out nocopy date
587   ,p_effective_end_date             out nocopy date
588   ,p_object_version_number          in out nocopy number
589   ,p_effective_date                 in  date
590   ,p_datetrack_mode                 in  varchar2
591   ) is
592   --
593   -- Declare cursors and local variables
594   --
595   l_proc varchar2(72) := g_package||'update_PRTT_ANTHR_PL_RT';
596   l_object_version_number ben_prtt_anthr_pl_rt_f.object_version_number%TYPE;
597   l_effective_start_date ben_prtt_anthr_pl_rt_f.effective_start_date%TYPE;
598   l_effective_end_date ben_prtt_anthr_pl_rt_f.effective_end_date%TYPE;
599   --
600 begin
601   --
602   hr_utility.set_location('Entering:'|| l_proc, 10);
603   --
604   -- Issue a savepoint if operating in validation only mode
605   --
606   savepoint delete_PRTT_ANTHR_PL_RT;
607   --
608   hr_utility.set_location(l_proc, 20);
609   --
610   -- Process Logic
611   --
612   l_object_version_number := p_object_version_number;
613   --
614   --
615   begin
616     --
617     -- Start of API User Hook for the before hook of delete_PRTT_ANTHR_PL_RT
618     --
619     ben_PRTT_ANTHR_PL_RT_bk3.delete_PRTT_ANTHR_PL_RT_b
620       (
621        p_prtt_anthr_pl_rt_id     =>  p_prtt_anthr_pl_rt_id
622       ,p_object_version_number          =>  p_object_version_number
623     ,p_effective_date                      => trunc(p_effective_date)
624     ,p_datetrack_mode                      => p_datetrack_mode
625       );
626   exception
627     when hr_api.cannot_find_prog_unit then
628       hr_api.cannot_find_prog_unit_error
629         (p_module_name => 'DELETE_PRTT_ANTHR_PL_RT'
630         ,p_hook_type   => 'BP'
631         );
632     --
633     -- End of API User Hook for the before hook of delete_PRTT_ANTHR_PL_RT
634     --
635   end;
636   --
637   ben_pap_del.del
638     (
639      p_prtt_anthr_pl_rt_id    => p_prtt_anthr_pl_rt_id
640     ,p_effective_start_date          => l_effective_start_date
641     ,p_effective_end_date            => l_effective_end_date
642     ,p_object_version_number         => l_object_version_number
643     ,p_effective_date                => p_effective_date
644     ,p_datetrack_mode                => p_datetrack_mode
645     );
646   --
647   begin
648     --
649     -- Start of API User Hook for the after hook of delete_PRTT_ANTHR_PL_RT
650     --
651     ben_PRTT_ANTHR_PL_RT_bk3.delete_PRTT_ANTHR_PL_RT_a
652       (
653        p_prtt_anthr_pl_rt_id     =>  p_prtt_anthr_pl_rt_id
654       ,p_effective_start_date           =>  l_effective_start_date
655       ,p_effective_end_date             =>  l_effective_end_date
656       ,p_object_version_number          =>  l_object_version_number
657     ,p_effective_date                      => trunc(p_effective_date)
658     ,p_datetrack_mode                      => p_datetrack_mode
659       );
660   exception
661     when hr_api.cannot_find_prog_unit then
662       hr_api.cannot_find_prog_unit_error
663         (p_module_name => 'DELETE_PRTT_ANTHR_PL_RT'
664         ,p_hook_type   => 'AP'
665         );
666     --
667     -- End of API User Hook for the after hook of delete_PRTT_ANTHR_PL_RT
668     --
669   end;
670   --
671   ben_profile_handler.event_handler
672     (p_event                       => 'DELETE',
673      p_base_table                  => 'BEN_VRBL_RT_PRFL_F',
674      p_base_table_column           => 'VRBL_RT_PRFL_ID',
675      p_base_table_column_value     => ben_pap_shd.g_old_rec.vrbl_rt_prfl_id,
676      p_base_table_reference_column => 'RT_PRTT_ANTHR_PL_FLAG',
677      p_reference_table             => 'BEN_prtt_anthr_pl_rt_F',
678      p_reference_table_column      => 'VRBL_RT_PRFL_ID');
679   --
680   hr_utility.set_location(l_proc, 60);
681   --
682   -- When in validation only mode raise the Validate_Enabled exception
683   --
684   if p_validate then
685     raise hr_api.validate_enabled;
686   end if;
687   --
688   hr_utility.set_location(' Leaving:'||l_proc, 70);
689   --
690 exception
691   --
692   when hr_api.validate_enabled then
693     --
694     -- As the Validate_Enabled exception has been raised
695     -- we must rollback to the savepoint
696     --
697     ROLLBACK TO delete_PRTT_ANTHR_PL_RT;
698     --
699     -- Only set output warning arguments
700     -- (Any key or derived arguments must be set to null
701     -- when validation only mode is being used.)
702     --
703     p_effective_start_date := null;
704     p_effective_end_date := null;
705     --
706   when others then
707     --
708     -- A validation or unexpected error has occured
709     --
710     ROLLBACK TO delete_PRTT_ANTHR_PL_RT;
711 
712     -- NOCOPY, Reset out parameters
713     p_effective_start_date := null;
714     p_effective_end_date   := null;
715 
716     raise;
717     --
718 end delete_PRTT_ANTHR_PL_RT;
719 --
720 -- ----------------------------------------------------------------------------
721 -- |-------------------------------< lck >------------------------------------|
722 -- ----------------------------------------------------------------------------
723 --
724 procedure lck
725   (
726    p_prtt_anthr_pl_rt_id                   in     number
727   ,p_object_version_number          in     number
728   ,p_effective_date                 in     date
729   ,p_datetrack_mode                 in     varchar2
730   ,p_validation_start_date          out nocopy    date
731   ,p_validation_end_date            out nocopy    date
732   ) is
733   --
734   --
735   -- Declare cursors and local variables
736   --
737   l_proc varchar2(72) := g_package||'lck';
738   l_validation_start_date date;
739   l_validation_end_date date;
740   --
741 begin
742   --
743   hr_utility.set_location('Entering:'|| l_proc, 10);
744   --
745   ben_pap_shd.lck
746     (
747       p_prtt_anthr_pl_rt_id                 => p_prtt_anthr_pl_rt_id
748      ,p_validation_start_date      => l_validation_start_date
749      ,p_validation_end_date        => l_validation_end_date
750      ,p_object_version_number      => p_object_version_number
751      ,p_effective_date             => p_effective_date
752      ,p_datetrack_mode             => p_datetrack_mode
753     );
754   --
755   hr_utility.set_location(' Leaving:'||l_proc, 70);
756   --
757 end lck;
758 --
759 end ben_PRTT_ANTHR_PL_RT_api;