[Home] [Help]
PACKAGE BODY: APPS.BEN_LER_BNFT_RSTRN_API
Source
1 Package Body ben_LER_BNFT_RSTRN_api as
2 /* $Header: belbrapi.pkb 120.0 2005/05/28 03:16:12 appldev noship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := ' ben_LER_BNFT_RSTRN_api.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |------------------------< create_LER_BNFT_RSTRN >----------------------|
10 -- ----------------------------------------------------------------------------
11 --
12 procedure create_LER_BNFT_RSTRN
13 (p_validate in boolean default false
14 ,p_ler_bnft_rstrn_id out nocopy number
15 ,p_effective_start_date out nocopy date
16 ,p_effective_end_date out nocopy date
17 ,p_no_mx_cvg_amt_apls_flag in varchar2 default null
18 ,p_no_mn_cvg_incr_apls_flag in varchar2 default null
19 ,p_no_mx_cvg_incr_apls_flag in varchar2 default null
20 ,p_mx_cvg_incr_wcf_alwd_amt in number default null
21 ,p_mx_cvg_incr_alwd_amt in number default null
22 ,p_mx_cvg_alwd_amt in number default null
23 ,p_mx_cvg_mlt_incr_num in number default null
24 ,p_mx_cvg_mlt_incr_wcf_num in number default null
25 ,p_mx_cvg_rl in number default null
26 ,p_mx_cvg_wcfn_amt in number default null
27 ,p_mx_cvg_wcfn_mlt_num in number default null
28 ,p_mn_cvg_amt in number default null
29 ,p_mn_cvg_rl in number default null
30 ,p_cvg_incr_r_decr_only_cd in varchar2 default null
31 ,p_unsspnd_enrt_cd in varchar2 default null
32 ,p_dflt_to_asn_pndg_ctfn_cd in varchar2 default null
33 ,p_dflt_to_asn_pndg_ctfn_rl in number default null
34 ,p_ler_id in number default null
35 ,p_pl_id in number default null
36 ,p_business_group_id in number default null
37 ,p_plip_id in number default null
38 ,p_lbr_attribute_category in varchar2 default null
39 ,p_lbr_attribute1 in varchar2 default null
40 ,p_lbr_attribute2 in varchar2 default null
41 ,p_lbr_attribute3 in varchar2 default null
42 ,p_lbr_attribute4 in varchar2 default null
43 ,p_lbr_attribute5 in varchar2 default null
44 ,p_lbr_attribute6 in varchar2 default null
45 ,p_lbr_attribute7 in varchar2 default null
46 ,p_lbr_attribute8 in varchar2 default null
47 ,p_lbr_attribute9 in varchar2 default null
48 ,p_lbr_attribute10 in varchar2 default null
49 ,p_lbr_attribute11 in varchar2 default null
50 ,p_lbr_attribute12 in varchar2 default null
51 ,p_lbr_attribute13 in varchar2 default null
52 ,p_lbr_attribute14 in varchar2 default null
53 ,p_lbr_attribute15 in varchar2 default null
54 ,p_lbr_attribute16 in varchar2 default null
55 ,p_lbr_attribute17 in varchar2 default null
56 ,p_lbr_attribute18 in varchar2 default null
57 ,p_lbr_attribute19 in varchar2 default null
58 ,p_lbr_attribute20 in varchar2 default null
59 ,p_lbr_attribute21 in varchar2 default null
60 ,p_lbr_attribute22 in varchar2 default null
61 ,p_lbr_attribute23 in varchar2 default null
62 ,p_lbr_attribute24 in varchar2 default null
63 ,p_lbr_attribute25 in varchar2 default null
64 ,p_lbr_attribute26 in varchar2 default null
65 ,p_lbr_attribute27 in varchar2 default null
66 ,p_lbr_attribute28 in varchar2 default null
67 ,p_lbr_attribute29 in varchar2 default null
68 ,p_lbr_attribute30 in varchar2 default null
69 ,p_susp_if_ctfn_not_prvd_flag in varchar2 default 'Y'
70 ,p_ctfn_determine_cd in varchar2 default null
71 ,p_object_version_number out nocopy number
72 ,p_effective_date in date
73 ) is
74 --
75 -- Declare cursors and local variables
76 --
77 l_ler_bnft_rstrn_id ben_ler_bnft_rstrn_f.ler_bnft_rstrn_id%TYPE;
78 l_effective_start_date ben_ler_bnft_rstrn_f.effective_start_date%TYPE;
79 l_effective_end_date ben_ler_bnft_rstrn_f.effective_end_date%TYPE;
80 l_proc varchar2(72) := g_package||'create_LER_BNFT_RSTRN';
81 l_object_version_number ben_ler_bnft_rstrn_f.object_version_number%TYPE;
82 --
83 begin
84 --
85 hr_utility.set_location('Entering:'|| l_proc, 10);
86 --
87 -- Issue a savepoint if operating in validation only mode
88 --
89 savepoint create_LER_BNFT_RSTRN;
90 --
91 hr_utility.set_location(l_proc, 20);
92 --
93 -- Process Logic
94 --
95 begin
96 --
97 -- Start of API User Hook for the before hook of create_LER_BNFT_RSTRN
98 --
99 ben_LER_BNFT_RSTRN_bk1.create_LER_BNFT_RSTRN_b
100 (
101 p_no_mx_cvg_amt_apls_flag => p_no_mx_cvg_amt_apls_flag
102 ,p_no_mn_cvg_incr_apls_flag => p_no_mn_cvg_incr_apls_flag
103 ,p_no_mx_cvg_incr_apls_flag => p_no_mx_cvg_incr_apls_flag
104 ,p_mx_cvg_incr_wcf_alwd_amt => p_mx_cvg_incr_wcf_alwd_amt
105 ,p_mx_cvg_incr_alwd_amt => p_mx_cvg_incr_alwd_amt
106 ,p_mx_cvg_alwd_amt => p_mx_cvg_alwd_amt
107 ,p_mx_cvg_mlt_incr_num => p_mx_cvg_mlt_incr_num
108 ,p_mx_cvg_mlt_incr_wcf_num => p_mx_cvg_mlt_incr_wcf_num
109 ,p_mx_cvg_rl => p_mx_cvg_rl
110 ,p_mx_cvg_wcfn_amt => p_mx_cvg_wcfn_amt
111 ,p_mx_cvg_wcfn_mlt_num => p_mx_cvg_wcfn_mlt_num
112 ,p_mn_cvg_amt => p_mn_cvg_amt
113 ,p_mn_cvg_rl => p_mn_cvg_rl
114 ,p_cvg_incr_r_decr_only_cd => p_cvg_incr_r_decr_only_cd
115 ,p_unsspnd_enrt_cd => p_unsspnd_enrt_cd
116 ,p_dflt_to_asn_pndg_ctfn_cd => p_dflt_to_asn_pndg_ctfn_cd
117 ,p_dflt_to_asn_pndg_ctfn_rl => p_dflt_to_asn_pndg_ctfn_rl
118 ,p_ler_id => p_ler_id
119 ,p_pl_id => p_pl_id
120 ,p_business_group_id => p_business_group_id
121 ,p_plip_id => p_plip_id
122 ,p_lbr_attribute_category => p_lbr_attribute_category
123 ,p_lbr_attribute1 => p_lbr_attribute1
124 ,p_lbr_attribute2 => p_lbr_attribute2
125 ,p_lbr_attribute3 => p_lbr_attribute3
126 ,p_lbr_attribute4 => p_lbr_attribute4
127 ,p_lbr_attribute5 => p_lbr_attribute5
128 ,p_lbr_attribute6 => p_lbr_attribute6
129 ,p_lbr_attribute7 => p_lbr_attribute7
130 ,p_lbr_attribute8 => p_lbr_attribute8
131 ,p_lbr_attribute9 => p_lbr_attribute9
132 ,p_lbr_attribute10 => p_lbr_attribute10
133 ,p_lbr_attribute11 => p_lbr_attribute11
134 ,p_lbr_attribute12 => p_lbr_attribute12
135 ,p_lbr_attribute13 => p_lbr_attribute13
136 ,p_lbr_attribute14 => p_lbr_attribute14
137 ,p_lbr_attribute15 => p_lbr_attribute15
138 ,p_lbr_attribute16 => p_lbr_attribute16
139 ,p_lbr_attribute17 => p_lbr_attribute17
140 ,p_lbr_attribute18 => p_lbr_attribute18
141 ,p_lbr_attribute19 => p_lbr_attribute19
142 ,p_lbr_attribute20 => p_lbr_attribute20
143 ,p_lbr_attribute21 => p_lbr_attribute21
144 ,p_lbr_attribute22 => p_lbr_attribute22
145 ,p_lbr_attribute23 => p_lbr_attribute23
146 ,p_lbr_attribute24 => p_lbr_attribute24
147 ,p_lbr_attribute25 => p_lbr_attribute25
148 ,p_lbr_attribute26 => p_lbr_attribute26
149 ,p_lbr_attribute27 => p_lbr_attribute27
150 ,p_lbr_attribute28 => p_lbr_attribute28
151 ,p_lbr_attribute29 => p_lbr_attribute29
152 ,p_lbr_attribute30 => p_lbr_attribute30
153 ,p_susp_if_ctfn_not_prvd_flag => p_susp_if_ctfn_not_prvd_flag
154 ,p_ctfn_determine_cd => p_ctfn_determine_cd
155 ,p_effective_date => trunc(p_effective_date)
156 );
157 exception
158 when hr_api.cannot_find_prog_unit then
159 hr_api.cannot_find_prog_unit_error
160 (
161 p_module_name => 'CREATE_LER_BNFT_RSTRN'
162 ,p_hook_type => 'BP'
163 );
164 --
165 -- End of API User Hook for the before hook of create_LER_BNFT_RSTRN
166 --
167 end;
168 --
169 ben_lbr_ins.ins
170 (
171 p_ler_bnft_rstrn_id => l_ler_bnft_rstrn_id
172 ,p_effective_start_date => l_effective_start_date
173 ,p_effective_end_date => l_effective_end_date
174 ,p_no_mx_cvg_amt_apls_flag => p_no_mx_cvg_amt_apls_flag
175 ,p_no_mn_cvg_incr_apls_flag => p_no_mn_cvg_incr_apls_flag
176 ,p_no_mx_cvg_incr_apls_flag => p_no_mx_cvg_incr_apls_flag
177 ,p_mx_cvg_incr_wcf_alwd_amt => p_mx_cvg_incr_wcf_alwd_amt
178 ,p_mx_cvg_incr_alwd_amt => p_mx_cvg_incr_alwd_amt
179 ,p_mx_cvg_alwd_amt => p_mx_cvg_alwd_amt
180 ,p_mx_cvg_mlt_incr_num => p_mx_cvg_mlt_incr_num
181 ,p_mx_cvg_mlt_incr_wcf_num => p_mx_cvg_mlt_incr_wcf_num
182 ,p_mx_cvg_rl => p_mx_cvg_rl
183 ,p_mx_cvg_wcfn_amt => p_mx_cvg_wcfn_amt
184 ,p_mx_cvg_wcfn_mlt_num => p_mx_cvg_wcfn_mlt_num
185 ,p_mn_cvg_amt => p_mn_cvg_amt
186 ,p_mn_cvg_rl => p_mn_cvg_rl
187 ,p_cvg_incr_r_decr_only_cd => p_cvg_incr_r_decr_only_cd
188 ,p_unsspnd_enrt_cd => p_unsspnd_enrt_cd
189 ,p_dflt_to_asn_pndg_ctfn_cd => p_dflt_to_asn_pndg_ctfn_cd
190 ,p_dflt_to_asn_pndg_ctfn_rl => p_dflt_to_asn_pndg_ctfn_rl
191 ,p_ler_id => p_ler_id
192 ,p_pl_id => p_pl_id
193 ,p_business_group_id => p_business_group_id
194 ,p_plip_id => p_plip_id
195 ,p_lbr_attribute_category => p_lbr_attribute_category
196 ,p_lbr_attribute1 => p_lbr_attribute1
197 ,p_lbr_attribute2 => p_lbr_attribute2
198 ,p_lbr_attribute3 => p_lbr_attribute3
199 ,p_lbr_attribute4 => p_lbr_attribute4
200 ,p_lbr_attribute5 => p_lbr_attribute5
201 ,p_lbr_attribute6 => p_lbr_attribute6
202 ,p_lbr_attribute7 => p_lbr_attribute7
203 ,p_lbr_attribute8 => p_lbr_attribute8
204 ,p_lbr_attribute9 => p_lbr_attribute9
205 ,p_lbr_attribute10 => p_lbr_attribute10
206 ,p_lbr_attribute11 => p_lbr_attribute11
207 ,p_lbr_attribute12 => p_lbr_attribute12
208 ,p_lbr_attribute13 => p_lbr_attribute13
209 ,p_lbr_attribute14 => p_lbr_attribute14
210 ,p_lbr_attribute15 => p_lbr_attribute15
211 ,p_lbr_attribute16 => p_lbr_attribute16
212 ,p_lbr_attribute17 => p_lbr_attribute17
213 ,p_lbr_attribute18 => p_lbr_attribute18
214 ,p_lbr_attribute19 => p_lbr_attribute19
215 ,p_lbr_attribute20 => p_lbr_attribute20
216 ,p_lbr_attribute21 => p_lbr_attribute21
217 ,p_lbr_attribute22 => p_lbr_attribute22
218 ,p_lbr_attribute23 => p_lbr_attribute23
219 ,p_lbr_attribute24 => p_lbr_attribute24
220 ,p_lbr_attribute25 => p_lbr_attribute25
221 ,p_lbr_attribute26 => p_lbr_attribute26
222 ,p_lbr_attribute27 => p_lbr_attribute27
223 ,p_lbr_attribute28 => p_lbr_attribute28
224 ,p_lbr_attribute29 => p_lbr_attribute29
225 ,p_lbr_attribute30 => p_lbr_attribute30
226 ,p_susp_if_ctfn_not_prvd_flag => p_susp_if_ctfn_not_prvd_flag
227 ,p_ctfn_determine_cd => p_ctfn_determine_cd
228 ,p_object_version_number => l_object_version_number
229 ,p_effective_date => trunc(p_effective_date)
230 );
231 --
232 begin
233 --
234 -- Start of API User Hook for the after hook of create_LER_BNFT_RSTRN
235 --
236 ben_LER_BNFT_RSTRN_bk1.create_LER_BNFT_RSTRN_a
237 (
238 p_ler_bnft_rstrn_id => l_ler_bnft_rstrn_id
239 ,p_effective_start_date => l_effective_start_date
240 ,p_effective_end_date => l_effective_end_date
241 ,p_no_mx_cvg_amt_apls_flag => p_no_mx_cvg_amt_apls_flag
242 ,p_no_mn_cvg_incr_apls_flag => p_no_mn_cvg_incr_apls_flag
243 ,p_no_mx_cvg_incr_apls_flag => p_no_mx_cvg_incr_apls_flag
244 ,p_mx_cvg_incr_wcf_alwd_amt => p_mx_cvg_incr_wcf_alwd_amt
245 ,p_mx_cvg_incr_alwd_amt => p_mx_cvg_incr_alwd_amt
246 ,p_mx_cvg_alwd_amt => p_mx_cvg_alwd_amt
247 ,p_mx_cvg_mlt_incr_num => p_mx_cvg_mlt_incr_num
248 ,p_mx_cvg_mlt_incr_wcf_num => p_mx_cvg_mlt_incr_wcf_num
249 ,p_mx_cvg_rl => p_mx_cvg_rl
250 ,p_mx_cvg_wcfn_amt => p_mx_cvg_wcfn_amt
251 ,p_mx_cvg_wcfn_mlt_num => p_mx_cvg_wcfn_mlt_num
252 ,p_mn_cvg_amt => p_mn_cvg_amt
253 ,p_mn_cvg_rl => p_mn_cvg_rl
254 ,p_cvg_incr_r_decr_only_cd => p_cvg_incr_r_decr_only_cd
255 ,p_unsspnd_enrt_cd => p_unsspnd_enrt_cd
256 ,p_dflt_to_asn_pndg_ctfn_cd => p_dflt_to_asn_pndg_ctfn_cd
257 ,p_dflt_to_asn_pndg_ctfn_rl => p_dflt_to_asn_pndg_ctfn_rl
258 ,p_ler_id => p_ler_id
259 ,p_pl_id => p_pl_id
260 ,p_business_group_id => p_business_group_id
261 ,p_plip_id => p_plip_id
262 ,p_lbr_attribute_category => p_lbr_attribute_category
263 ,p_lbr_attribute1 => p_lbr_attribute1
264 ,p_lbr_attribute2 => p_lbr_attribute2
265 ,p_lbr_attribute3 => p_lbr_attribute3
266 ,p_lbr_attribute4 => p_lbr_attribute4
267 ,p_lbr_attribute5 => p_lbr_attribute5
268 ,p_lbr_attribute6 => p_lbr_attribute6
269 ,p_lbr_attribute7 => p_lbr_attribute7
270 ,p_lbr_attribute8 => p_lbr_attribute8
271 ,p_lbr_attribute9 => p_lbr_attribute9
272 ,p_lbr_attribute10 => p_lbr_attribute10
273 ,p_lbr_attribute11 => p_lbr_attribute11
274 ,p_lbr_attribute12 => p_lbr_attribute12
275 ,p_lbr_attribute13 => p_lbr_attribute13
276 ,p_lbr_attribute14 => p_lbr_attribute14
277 ,p_lbr_attribute15 => p_lbr_attribute15
278 ,p_lbr_attribute16 => p_lbr_attribute16
279 ,p_lbr_attribute17 => p_lbr_attribute17
280 ,p_lbr_attribute18 => p_lbr_attribute18
281 ,p_lbr_attribute19 => p_lbr_attribute19
282 ,p_lbr_attribute20 => p_lbr_attribute20
283 ,p_lbr_attribute21 => p_lbr_attribute21
284 ,p_lbr_attribute22 => p_lbr_attribute22
285 ,p_lbr_attribute23 => p_lbr_attribute23
286 ,p_lbr_attribute24 => p_lbr_attribute24
287 ,p_lbr_attribute25 => p_lbr_attribute25
288 ,p_lbr_attribute26 => p_lbr_attribute26
289 ,p_lbr_attribute27 => p_lbr_attribute27
290 ,p_lbr_attribute28 => p_lbr_attribute28
291 ,p_lbr_attribute29 => p_lbr_attribute29
292 ,p_lbr_attribute30 => p_lbr_attribute30
293 ,p_susp_if_ctfn_not_prvd_flag => p_susp_if_ctfn_not_prvd_flag
294 ,p_ctfn_determine_cd => p_ctfn_determine_cd
295 ,p_object_version_number => l_object_version_number
296 ,p_effective_date => trunc(p_effective_date)
297 );
298 exception
299 when hr_api.cannot_find_prog_unit then
300 hr_api.cannot_find_prog_unit_error
301 (p_module_name => 'CREATE_LER_BNFT_RSTRN'
302 ,p_hook_type => 'AP'
303 );
304 --
305 -- End of API User Hook for the after hook of create_LER_BNFT_RSTRN
306 --
307 end;
308 --
309 hr_utility.set_location(l_proc, 60);
310 --
311 -- When in validation only mode raise the Validate_Enabled exception
312 --
313 if p_validate then
314 raise hr_api.validate_enabled;
315 end if;
316 --
317 -- Set all output arguments
318 --
319 p_ler_bnft_rstrn_id := l_ler_bnft_rstrn_id;
320 p_effective_start_date := l_effective_start_date;
321 p_effective_end_date := l_effective_end_date;
322 p_object_version_number := l_object_version_number;
323 --
324 hr_utility.set_location(' Leaving:'||l_proc, 70);
325 --
326 exception
327 --
328 when hr_api.validate_enabled then
329 --
330 -- As the Validate_Enabled exception has been raised
331 -- we must rollback to the savepoint
332 --
333 ROLLBACK TO create_LER_BNFT_RSTRN;
334 --
335 -- Only set output warning arguments
336 -- (Any key or derived arguments must be set to null
337 -- when validation only mode is being used.)
338 --
339 p_ler_bnft_rstrn_id := null;
340 p_effective_start_date := null;
341 p_effective_end_date := null;
342 p_object_version_number := null;
343 hr_utility.set_location(' Leaving:'||l_proc, 80);
344 --
345 when others then
346 --
347 -- A validation or unexpected error has occured
348 --
349 ROLLBACK TO create_LER_BNFT_RSTRN;
350 raise;
351 --
352 end create_LER_BNFT_RSTRN;
353 -- ----------------------------------------------------------------------------
354 -- |------------------------< update_LER_BNFT_RSTRN >--- ------------------|
355 -- ----------------------------------------------------------------------------
356 --
357 procedure update_LER_BNFT_RSTRN
358 (p_validate in boolean default false
359 ,p_ler_bnft_rstrn_id in number
360 ,p_effective_start_date out nocopy date
361 ,p_effective_end_date out nocopy date
362 ,p_no_mx_cvg_amt_apls_flag in varchar2 default hr_api.g_varchar2
363 ,p_no_mn_cvg_incr_apls_flag in varchar2 default hr_api.g_varchar2
364 ,p_no_mx_cvg_incr_apls_flag in varchar2 default hr_api.g_varchar2
365 ,p_mx_cvg_incr_wcf_alwd_amt in number default hr_api.g_number
366 ,p_mx_cvg_incr_alwd_amt in number default hr_api.g_number
367 ,p_mx_cvg_alwd_amt in number default hr_api.g_number
368 ,p_mx_cvg_mlt_incr_num in number default hr_api.g_number
369 ,p_mx_cvg_mlt_incr_wcf_num in number default hr_api.g_number
370 ,p_mx_cvg_rl in number default hr_api.g_number
371 ,p_mx_cvg_wcfn_amt in number default hr_api.g_number
372 ,p_mx_cvg_wcfn_mlt_num in number default hr_api.g_number
373 ,p_mn_cvg_amt in number default hr_api.g_number
374 ,p_mn_cvg_rl in number default hr_api.g_number
375 ,p_cvg_incr_r_decr_only_cd in varchar2 default hr_api.g_varchar2
376 ,p_unsspnd_enrt_cd in varchar2 default hr_api.g_varchar2
377 ,p_dflt_to_asn_pndg_ctfn_cd in varchar2 default hr_api.g_varchar2
378 ,p_dflt_to_asn_pndg_ctfn_rl in number default hr_api.g_number
379 ,p_ler_id in number default hr_api.g_number
380 ,p_pl_id in number default hr_api.g_number
381 ,p_business_group_id in number default hr_api.g_number
382 ,p_plip_id in number default hr_api.g_number
383 ,p_lbr_attribute_category in varchar2 default hr_api.g_varchar2
384 ,p_lbr_attribute1 in varchar2 default hr_api.g_varchar2
385 ,p_lbr_attribute2 in varchar2 default hr_api.g_varchar2
386 ,p_lbr_attribute3 in varchar2 default hr_api.g_varchar2
387 ,p_lbr_attribute4 in varchar2 default hr_api.g_varchar2
388 ,p_lbr_attribute5 in varchar2 default hr_api.g_varchar2
389 ,p_lbr_attribute6 in varchar2 default hr_api.g_varchar2
390 ,p_lbr_attribute7 in varchar2 default hr_api.g_varchar2
391 ,p_lbr_attribute8 in varchar2 default hr_api.g_varchar2
392 ,p_lbr_attribute9 in varchar2 default hr_api.g_varchar2
393 ,p_lbr_attribute10 in varchar2 default hr_api.g_varchar2
394 ,p_lbr_attribute11 in varchar2 default hr_api.g_varchar2
395 ,p_lbr_attribute12 in varchar2 default hr_api.g_varchar2
396 ,p_lbr_attribute13 in varchar2 default hr_api.g_varchar2
397 ,p_lbr_attribute14 in varchar2 default hr_api.g_varchar2
398 ,p_lbr_attribute15 in varchar2 default hr_api.g_varchar2
399 ,p_lbr_attribute16 in varchar2 default hr_api.g_varchar2
400 ,p_lbr_attribute17 in varchar2 default hr_api.g_varchar2
401 ,p_lbr_attribute18 in varchar2 default hr_api.g_varchar2
402 ,p_lbr_attribute19 in varchar2 default hr_api.g_varchar2
403 ,p_lbr_attribute20 in varchar2 default hr_api.g_varchar2
404 ,p_lbr_attribute21 in varchar2 default hr_api.g_varchar2
405 ,p_lbr_attribute22 in varchar2 default hr_api.g_varchar2
406 ,p_lbr_attribute23 in varchar2 default hr_api.g_varchar2
407 ,p_lbr_attribute24 in varchar2 default hr_api.g_varchar2
408 ,p_lbr_attribute25 in varchar2 default hr_api.g_varchar2
409 ,p_lbr_attribute26 in varchar2 default hr_api.g_varchar2
410 ,p_lbr_attribute27 in varchar2 default hr_api.g_varchar2
411 ,p_lbr_attribute28 in varchar2 default hr_api.g_varchar2
412 ,p_lbr_attribute29 in varchar2 default hr_api.g_varchar2
413 ,p_lbr_attribute30 in varchar2 default hr_api.g_varchar2
414 ,p_susp_if_ctfn_not_prvd_flag in varchar2 default hr_api.g_varchar2
415 ,p_ctfn_determine_cd in varchar2 default hr_api.g_varchar2
416 ,p_object_version_number in out nocopy number
417 ,p_effective_date in date
418 ,p_datetrack_mode in varchar2
419 ) is
420 --
421 -- Declare cursors and local variables
422 --
423 l_proc varchar2(72) := g_package||'update_LER_BNFT_RSTRN';
424 l_object_version_number ben_ler_bnft_rstrn_f.object_version_number%TYPE;
425 l_effective_start_date ben_ler_bnft_rstrn_f.effective_start_date%TYPE;
426 l_effective_end_date ben_ler_bnft_rstrn_f.effective_end_date%TYPE;
427 --
428 begin
429 --
430 hr_utility.set_location('Entering:'|| l_proc, 10);
431 --
432 -- Issue a savepoint if operating in validation only mode
433 --
434 savepoint update_LER_BNFT_RSTRN;
435 --
436 hr_utility.set_location(l_proc, 20);
437 --
438 -- Process Logic
439 --
440 l_object_version_number := p_object_version_number;
441 --
442 begin
443 --
444 -- Start of API User Hook for the before hook of update_LER_BNFT_RSTRN
445 --
446 ben_LER_BNFT_RSTRN_bk2.update_LER_BNFT_RSTRN_b
447 (
448 p_ler_bnft_rstrn_id => p_ler_bnft_rstrn_id
449 ,p_no_mx_cvg_amt_apls_flag => p_no_mx_cvg_amt_apls_flag
450 ,p_no_mn_cvg_incr_apls_flag => p_no_mn_cvg_incr_apls_flag
451 ,p_no_mx_cvg_incr_apls_flag => p_no_mx_cvg_incr_apls_flag
452 ,p_mx_cvg_incr_wcf_alwd_amt => p_mx_cvg_incr_wcf_alwd_amt
453 ,p_mx_cvg_incr_alwd_amt => p_mx_cvg_incr_alwd_amt
454 ,p_mx_cvg_alwd_amt => p_mx_cvg_alwd_amt
455 ,p_mx_cvg_mlt_incr_num => p_mx_cvg_mlt_incr_num
456 ,p_mx_cvg_mlt_incr_wcf_num => p_mx_cvg_mlt_incr_wcf_num
457 ,p_mx_cvg_rl => p_mx_cvg_rl
458 ,p_mx_cvg_wcfn_amt => p_mx_cvg_wcfn_amt
459 ,p_mx_cvg_wcfn_mlt_num => p_mx_cvg_wcfn_mlt_num
460 ,p_mn_cvg_amt => p_mn_cvg_amt
461 ,p_mn_cvg_rl => p_mn_cvg_rl
462 ,p_cvg_incr_r_decr_only_cd => p_cvg_incr_r_decr_only_cd
463 ,p_unsspnd_enrt_cd => p_unsspnd_enrt_cd
464 ,p_dflt_to_asn_pndg_ctfn_cd => p_dflt_to_asn_pndg_ctfn_cd
465 ,p_dflt_to_asn_pndg_ctfn_rl => p_dflt_to_asn_pndg_ctfn_rl
466 ,p_ler_id => p_ler_id
467 ,p_pl_id => p_pl_id
468 ,p_business_group_id => p_business_group_id
469 ,p_plip_id => p_plip_id
470 ,p_lbr_attribute_category => p_lbr_attribute_category
471 ,p_lbr_attribute1 => p_lbr_attribute1
472 ,p_lbr_attribute2 => p_lbr_attribute2
473 ,p_lbr_attribute3 => p_lbr_attribute3
474 ,p_lbr_attribute4 => p_lbr_attribute4
475 ,p_lbr_attribute5 => p_lbr_attribute5
476 ,p_lbr_attribute6 => p_lbr_attribute6
477 ,p_lbr_attribute7 => p_lbr_attribute7
478 ,p_lbr_attribute8 => p_lbr_attribute8
479 ,p_lbr_attribute9 => p_lbr_attribute9
480 ,p_lbr_attribute10 => p_lbr_attribute10
481 ,p_lbr_attribute11 => p_lbr_attribute11
482 ,p_lbr_attribute12 => p_lbr_attribute12
483 ,p_lbr_attribute13 => p_lbr_attribute13
484 ,p_lbr_attribute14 => p_lbr_attribute14
485 ,p_lbr_attribute15 => p_lbr_attribute15
486 ,p_lbr_attribute16 => p_lbr_attribute16
487 ,p_lbr_attribute17 => p_lbr_attribute17
488 ,p_lbr_attribute18 => p_lbr_attribute18
489 ,p_lbr_attribute19 => p_lbr_attribute19
490 ,p_lbr_attribute20 => p_lbr_attribute20
491 ,p_lbr_attribute21 => p_lbr_attribute21
492 ,p_lbr_attribute22 => p_lbr_attribute22
493 ,p_lbr_attribute23 => p_lbr_attribute23
494 ,p_lbr_attribute24 => p_lbr_attribute24
495 ,p_lbr_attribute25 => p_lbr_attribute25
496 ,p_lbr_attribute26 => p_lbr_attribute26
497 ,p_lbr_attribute27 => p_lbr_attribute27
498 ,p_lbr_attribute28 => p_lbr_attribute28
499 ,p_lbr_attribute29 => p_lbr_attribute29
500 ,p_lbr_attribute30 => p_lbr_attribute30
501 ,p_susp_if_ctfn_not_prvd_flag => p_susp_if_ctfn_not_prvd_flag
502 ,p_ctfn_determine_cd => p_ctfn_determine_cd
503 ,p_object_version_number => p_object_version_number
504 ,p_effective_date => trunc(p_effective_date)
505 ,p_datetrack_mode => p_datetrack_mode
506 );
507 exception
508 when hr_api.cannot_find_prog_unit then
509 hr_api.cannot_find_prog_unit_error
510 (p_module_name => 'UPDATE_LER_BNFT_RSTRN'
511 ,p_hook_type => 'BP'
512 );
513 --
514 -- End of API User Hook for the before hook of update_LER_BNFT_RSTRN
515 --
516 end;
517 --
518 ben_lbr_upd.upd
519 (
520 p_ler_bnft_rstrn_id => p_ler_bnft_rstrn_id
521 ,p_effective_start_date => l_effective_start_date
522 ,p_effective_end_date => l_effective_end_date
523 ,p_no_mx_cvg_amt_apls_flag => p_no_mx_cvg_amt_apls_flag
524 ,p_no_mn_cvg_incr_apls_flag => p_no_mn_cvg_incr_apls_flag
525 ,p_no_mx_cvg_incr_apls_flag => p_no_mx_cvg_incr_apls_flag
526 ,p_mx_cvg_incr_wcf_alwd_amt => p_mx_cvg_incr_wcf_alwd_amt
527 ,p_mx_cvg_incr_alwd_amt => p_mx_cvg_incr_alwd_amt
528 ,p_mx_cvg_alwd_amt => p_mx_cvg_alwd_amt
529 ,p_mx_cvg_mlt_incr_num => p_mx_cvg_mlt_incr_num
530 ,p_mx_cvg_mlt_incr_wcf_num => p_mx_cvg_mlt_incr_wcf_num
531 ,p_mx_cvg_rl => p_mx_cvg_rl
532 ,p_mx_cvg_wcfn_amt => p_mx_cvg_wcfn_amt
533 ,p_mx_cvg_wcfn_mlt_num => p_mx_cvg_wcfn_mlt_num
534 ,p_mn_cvg_amt => p_mn_cvg_amt
535 ,p_mn_cvg_rl => p_mn_cvg_rl
536 ,p_cvg_incr_r_decr_only_cd => p_cvg_incr_r_decr_only_cd
537 ,p_unsspnd_enrt_cd => p_unsspnd_enrt_cd
538 ,p_dflt_to_asn_pndg_ctfn_cd => p_dflt_to_asn_pndg_ctfn_cd
539 ,p_dflt_to_asn_pndg_ctfn_rl => p_dflt_to_asn_pndg_ctfn_rl
540 ,p_ler_id => p_ler_id
541 ,p_pl_id => p_pl_id
542 ,p_business_group_id => p_business_group_id
543 ,p_plip_id => p_plip_id
544 ,p_lbr_attribute_category => p_lbr_attribute_category
545 ,p_lbr_attribute1 => p_lbr_attribute1
546 ,p_lbr_attribute2 => p_lbr_attribute2
547 ,p_lbr_attribute3 => p_lbr_attribute3
548 ,p_lbr_attribute4 => p_lbr_attribute4
549 ,p_lbr_attribute5 => p_lbr_attribute5
550 ,p_lbr_attribute6 => p_lbr_attribute6
551 ,p_lbr_attribute7 => p_lbr_attribute7
552 ,p_lbr_attribute8 => p_lbr_attribute8
553 ,p_lbr_attribute9 => p_lbr_attribute9
554 ,p_lbr_attribute10 => p_lbr_attribute10
555 ,p_lbr_attribute11 => p_lbr_attribute11
556 ,p_lbr_attribute12 => p_lbr_attribute12
557 ,p_lbr_attribute13 => p_lbr_attribute13
558 ,p_lbr_attribute14 => p_lbr_attribute14
559 ,p_lbr_attribute15 => p_lbr_attribute15
560 ,p_lbr_attribute16 => p_lbr_attribute16
561 ,p_lbr_attribute17 => p_lbr_attribute17
562 ,p_lbr_attribute18 => p_lbr_attribute18
563 ,p_lbr_attribute19 => p_lbr_attribute19
564 ,p_lbr_attribute20 => p_lbr_attribute20
565 ,p_lbr_attribute21 => p_lbr_attribute21
566 ,p_lbr_attribute22 => p_lbr_attribute22
567 ,p_lbr_attribute23 => p_lbr_attribute23
568 ,p_lbr_attribute24 => p_lbr_attribute24
569 ,p_lbr_attribute25 => p_lbr_attribute25
570 ,p_lbr_attribute26 => p_lbr_attribute26
571 ,p_lbr_attribute27 => p_lbr_attribute27
572 ,p_lbr_attribute28 => p_lbr_attribute28
573 ,p_lbr_attribute29 => p_lbr_attribute29
574 ,p_lbr_attribute30 => p_lbr_attribute30
575 ,p_susp_if_ctfn_not_prvd_flag => p_susp_if_ctfn_not_prvd_flag
576 ,p_ctfn_determine_cd => p_ctfn_determine_cd
577 ,p_object_version_number => l_object_version_number
578 ,p_effective_date => trunc(p_effective_date)
579 ,p_datetrack_mode => p_datetrack_mode
580 );
581 --
582 begin
583 --
584 -- Start of API User Hook for the after hook of update_LER_BNFT_RSTRN
585 --
586 ben_LER_BNFT_RSTRN_bk2.update_LER_BNFT_RSTRN_a
587 (
588 p_ler_bnft_rstrn_id => p_ler_bnft_rstrn_id
589 ,p_effective_start_date => l_effective_start_date
590 ,p_effective_end_date => l_effective_end_date
591 ,p_no_mx_cvg_amt_apls_flag => p_no_mx_cvg_amt_apls_flag
592 ,p_no_mn_cvg_incr_apls_flag => p_no_mn_cvg_incr_apls_flag
593 ,p_no_mx_cvg_incr_apls_flag => p_no_mx_cvg_incr_apls_flag
594 ,p_mx_cvg_incr_wcf_alwd_amt => p_mx_cvg_incr_wcf_alwd_amt
595 ,p_mx_cvg_incr_alwd_amt => p_mx_cvg_incr_alwd_amt
596 ,p_mx_cvg_alwd_amt => p_mx_cvg_alwd_amt
597 ,p_mx_cvg_mlt_incr_num => p_mx_cvg_mlt_incr_num
598 ,p_mx_cvg_mlt_incr_wcf_num => p_mx_cvg_mlt_incr_wcf_num
599 ,p_mx_cvg_rl => p_mx_cvg_rl
600 ,p_mx_cvg_wcfn_amt => p_mx_cvg_wcfn_amt
601 ,p_mx_cvg_wcfn_mlt_num => p_mx_cvg_wcfn_mlt_num
602 ,p_mn_cvg_amt => p_mn_cvg_amt
603 ,p_mn_cvg_rl => p_mn_cvg_rl
604 ,p_cvg_incr_r_decr_only_cd => p_cvg_incr_r_decr_only_cd
605 ,p_unsspnd_enrt_cd => p_unsspnd_enrt_cd
606 ,p_dflt_to_asn_pndg_ctfn_cd => p_dflt_to_asn_pndg_ctfn_cd
607 ,p_dflt_to_asn_pndg_ctfn_rl => p_dflt_to_asn_pndg_ctfn_rl
608 ,p_ler_id => p_ler_id
609 ,p_pl_id => p_pl_id
610 ,p_business_group_id => p_business_group_id
611 ,p_plip_id => p_plip_id
612 ,p_lbr_attribute_category => p_lbr_attribute_category
613 ,p_lbr_attribute1 => p_lbr_attribute1
614 ,p_lbr_attribute2 => p_lbr_attribute2
615 ,p_lbr_attribute3 => p_lbr_attribute3
616 ,p_lbr_attribute4 => p_lbr_attribute4
617 ,p_lbr_attribute5 => p_lbr_attribute5
618 ,p_lbr_attribute6 => p_lbr_attribute6
619 ,p_lbr_attribute7 => p_lbr_attribute7
620 ,p_lbr_attribute8 => p_lbr_attribute8
621 ,p_lbr_attribute9 => p_lbr_attribute9
622 ,p_lbr_attribute10 => p_lbr_attribute10
623 ,p_lbr_attribute11 => p_lbr_attribute11
624 ,p_lbr_attribute12 => p_lbr_attribute12
625 ,p_lbr_attribute13 => p_lbr_attribute13
626 ,p_lbr_attribute14 => p_lbr_attribute14
627 ,p_lbr_attribute15 => p_lbr_attribute15
628 ,p_lbr_attribute16 => p_lbr_attribute16
629 ,p_lbr_attribute17 => p_lbr_attribute17
630 ,p_lbr_attribute18 => p_lbr_attribute18
631 ,p_lbr_attribute19 => p_lbr_attribute19
632 ,p_lbr_attribute20 => p_lbr_attribute20
633 ,p_lbr_attribute21 => p_lbr_attribute21
634 ,p_lbr_attribute22 => p_lbr_attribute22
635 ,p_lbr_attribute23 => p_lbr_attribute23
636 ,p_lbr_attribute24 => p_lbr_attribute24
637 ,p_lbr_attribute25 => p_lbr_attribute25
638 ,p_lbr_attribute26 => p_lbr_attribute26
639 ,p_lbr_attribute27 => p_lbr_attribute27
640 ,p_lbr_attribute28 => p_lbr_attribute28
641 ,p_lbr_attribute29 => p_lbr_attribute29
642 ,p_lbr_attribute30 => p_lbr_attribute30
643 ,p_susp_if_ctfn_not_prvd_flag => p_susp_if_ctfn_not_prvd_flag
644 ,p_ctfn_determine_cd => p_ctfn_determine_cd
645 ,p_object_version_number => l_object_version_number
646 ,p_effective_date => trunc(p_effective_date)
647 ,p_datetrack_mode => p_datetrack_mode
648 );
649 exception
650 when hr_api.cannot_find_prog_unit then
651 hr_api.cannot_find_prog_unit_error
652 (p_module_name => 'UPDATE_LER_BNFT_RSTRN'
653 ,p_hook_type => 'AP'
654 );
655 --
656 -- End of API User Hook for the after hook of update_LER_BNFT_RSTRN
657 --
658 end;
659 --
660 hr_utility.set_location(l_proc, 60);
661 --
662 -- When in validation only mode raise the Validate_Enabled exception
663 --
664 if p_validate then
665 raise hr_api.validate_enabled;
666 end if;
667 --
668 -- Set all output arguments
669 --
670 p_object_version_number := l_object_version_number;
671 p_effective_start_date := l_effective_start_date;
672 p_effective_end_date := l_effective_end_date;
673 --
674 hr_utility.set_location(' Leaving:'||l_proc, 70);
675 --
676 exception
677 --
678 when hr_api.validate_enabled then
679 --
680 -- As the Validate_Enabled exception has been raised
681 -- we must rollback to the savepoint
682 --
683 ROLLBACK TO update_LER_BNFT_RSTRN;
684 --
685 -- Only set output warning arguments
686 -- (Any key or derived arguments must be set to null
687 -- when validation only mode is being used.)
688 --
689 hr_utility.set_location(' Leaving:'||l_proc, 80);
690 --
691 when others then
692 --
693 -- A validation or unexpected error has occured
694 --
695 ROLLBACK TO update_LER_BNFT_RSTRN;
696 /* Inserted for nocopy changes */
697 p_object_version_number := l_object_version_number;
698 p_effective_start_date := null;
699 p_effective_end_date := null;
700 raise;
701 --
702 end update_LER_BNFT_RSTRN;
703 -- ----------------------------------------------------------------------------
704 -- |------------------------< delete_LER_BNFT_RSTRN >----------------------|
705 -- ----------------------------------------------------------------------------
706 --
707 procedure delete_LER_BNFT_RSTRN
708 (p_validate in boolean default false
709 ,p_ler_bnft_rstrn_id in number
710 ,p_effective_start_date out nocopy date
711 ,p_effective_end_date out nocopy date
712 ,p_object_version_number in out nocopy number
713 ,p_effective_date in date
714 ,p_datetrack_mode in varchar2
715 ) is
716 --
717 -- Declare cursors and local variables
718 --
719 l_proc varchar2(72) := g_package||'update_LER_BNFT_RSTRN';
720 l_object_version_number ben_ler_bnft_rstrn_f.object_version_number%TYPE;
721 l_effective_start_date ben_ler_bnft_rstrn_f.effective_start_date%TYPE;
722 l_effective_end_date ben_ler_bnft_rstrn_f.effective_end_date%TYPE;
723 --
724 begin
725 --
726 hr_utility.set_location('Entering:'|| l_proc, 10);
727 --
728 -- Issue a savepoint if operating in validation only mode
729 --
730 savepoint delete_LER_BNFT_RSTRN;
731 --
732 hr_utility.set_location(l_proc, 20);
733 --
734 -- Process Logic
735 --
736 l_object_version_number := p_object_version_number;
737 --
738 --
739 begin
740 --
741 -- Start of API User Hook for the before hook of delete_LER_BNFT_RSTRN
742 --
743 ben_LER_BNFT_RSTRN_bk3.delete_LER_BNFT_RSTRN_b
744 (
745 p_ler_bnft_rstrn_id => p_ler_bnft_rstrn_id
746 ,p_object_version_number => p_object_version_number
747 ,p_effective_date => trunc(p_effective_date)
748 ,p_datetrack_mode => p_datetrack_mode
749 );
750 exception
751 when hr_api.cannot_find_prog_unit then
752 hr_api.cannot_find_prog_unit_error
753 (p_module_name => 'DELETE_LER_BNFT_RSTRN'
754 ,p_hook_type => 'BP'
755 );
756 --
757 -- End of API User Hook for the before hook of delete_LER_BNFT_RSTRN
758 --
759 end;
760 --
761 ben_lbr_del.del
762 (
763 p_ler_bnft_rstrn_id => p_ler_bnft_rstrn_id
764 ,p_effective_start_date => l_effective_start_date
765 ,p_effective_end_date => l_effective_end_date
766 ,p_object_version_number => l_object_version_number
767 ,p_effective_date => p_effective_date
768 ,p_datetrack_mode => p_datetrack_mode
769 );
770 --
771 begin
772 --
773 -- Start of API User Hook for the after hook of delete_LER_BNFT_RSTRN
774 --
775 ben_LER_BNFT_RSTRN_bk3.delete_LER_BNFT_RSTRN_a
776 (
777 p_ler_bnft_rstrn_id => p_ler_bnft_rstrn_id
778 ,p_effective_start_date => l_effective_start_date
779 ,p_effective_end_date => l_effective_end_date
780 ,p_object_version_number => l_object_version_number
781 ,p_effective_date => trunc(p_effective_date)
782 ,p_datetrack_mode => p_datetrack_mode
783 );
784 exception
785 when hr_api.cannot_find_prog_unit then
786 hr_api.cannot_find_prog_unit_error
787 (p_module_name => 'DELETE_LER_BNFT_RSTRN'
788 ,p_hook_type => 'AP'
789 );
790 --
791 -- End of API User Hook for the after hook of delete_LER_BNFT_RSTRN
792 --
793 end;
794 --
795 hr_utility.set_location(l_proc, 60);
796 --
797 -- When in validation only mode raise the Validate_Enabled exception
798 --
799 if p_validate then
800 raise hr_api.validate_enabled;
801 end if;
802 --
803 hr_utility.set_location(' Leaving:'||l_proc, 70);
804 --
805 exception
806 --
807 when hr_api.validate_enabled then
808 --
809 -- As the Validate_Enabled exception has been raised
810 -- we must rollback to the savepoint
811 --
812 ROLLBACK TO delete_LER_BNFT_RSTRN;
813 --
814 -- Only set output warning arguments
815 -- (Any key or derived arguments must be set to null
816 -- when validation only mode is being used.)
817 --
818 p_effective_start_date := null;
819 p_effective_end_date := null;
820 --
821 when others then
822 --
823 -- A validation or unexpected error has occured
824 --
825 ROLLBACK TO delete_LER_BNFT_RSTRN;
826 /* Inserted for nocopy changes */
827 p_object_version_number := l_object_version_number;
828 p_effective_start_date := null;
829 p_effective_end_date := null;
830 raise;
831 --
832 end delete_LER_BNFT_RSTRN;
833 --
834 -- ----------------------------------------------------------------------------
835 -- |-------------------------------< lck >------------------------------------|
836 -- ----------------------------------------------------------------------------
837 --
838 procedure lck
839 (
840 p_ler_bnft_rstrn_id in number
841 ,p_object_version_number in number
842 ,p_effective_date in date
843 ,p_datetrack_mode in varchar2
844 ,p_validation_start_date out nocopy date
845 ,p_validation_end_date out nocopy date
846 ) is
847 --
848 --
849 -- Declare cursors and local variables
850 --
851 l_proc varchar2(72) := g_package||'lck';
852 l_validation_start_date date;
853 l_validation_end_date date;
854 --
855 begin
856 --
857 hr_utility.set_location('Entering:'|| l_proc, 10);
858 --
859 ben_lbr_shd.lck
860 (
861 p_ler_bnft_rstrn_id => p_ler_bnft_rstrn_id
862 ,p_validation_start_date => l_validation_start_date
863 ,p_validation_end_date => l_validation_end_date
864 ,p_object_version_number => p_object_version_number
865 ,p_effective_date => p_effective_date
866 ,p_datetrack_mode => p_datetrack_mode
867 );
868 --
869 hr_utility.set_location(' Leaving:'||l_proc, 70);
870 --
871 end lck;
872 --
873 end ben_LER_BNFT_RSTRN_api;