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