[Home] [Help]
PACKAGE BODY: APPS.BEN_DSGN_RQMT_RLSHP_TYP_API
Source
1 Package Body ben_DSGN_RQMT_RLSHP_TYP_api as
2 /* $Header: bedrrapi.pkb 115.2 2002/12/11 10:37:24 lakrish ship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := ' ben_DSGN_RQMT_RLSHP_TYP_api.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |------------------------< create_DSGN_RQMT_RLSHP_TYP >----------------------|
10 -- ----------------------------------------------------------------------------
11 --
12 procedure create_DSGN_RQMT_RLSHP_TYP
13 (p_validate in boolean default false
14 ,p_dsgn_rqmt_rlshp_typ_id out nocopy number
15 ,p_rlshp_typ_cd in varchar2 default null
16 ,p_dsgn_rqmt_id in number default null
17 ,p_business_group_id in number default null
18 ,p_drr_attribute_category in varchar2 default null
19 ,p_drr_attribute1 in varchar2 default null
20 ,p_drr_attribute2 in varchar2 default null
21 ,p_drr_attribute3 in varchar2 default null
22 ,p_drr_attribute4 in varchar2 default null
23 ,p_drr_attribute5 in varchar2 default null
24 ,p_drr_attribute6 in varchar2 default null
25 ,p_drr_attribute7 in varchar2 default null
26 ,p_drr_attribute8 in varchar2 default null
27 ,p_drr_attribute9 in varchar2 default null
28 ,p_drr_attribute10 in varchar2 default null
29 ,p_drr_attribute11 in varchar2 default null
30 ,p_drr_attribute12 in varchar2 default null
31 ,p_drr_attribute13 in varchar2 default null
32 ,p_drr_attribute14 in varchar2 default null
33 ,p_drr_attribute15 in varchar2 default null
34 ,p_drr_attribute16 in varchar2 default null
35 ,p_drr_attribute17 in varchar2 default null
36 ,p_drr_attribute18 in varchar2 default null
37 ,p_drr_attribute19 in varchar2 default null
38 ,p_drr_attribute20 in varchar2 default null
39 ,p_drr_attribute21 in varchar2 default null
40 ,p_drr_attribute22 in varchar2 default null
41 ,p_drr_attribute23 in varchar2 default null
42 ,p_drr_attribute24 in varchar2 default null
43 ,p_drr_attribute25 in varchar2 default null
44 ,p_drr_attribute26 in varchar2 default null
45 ,p_drr_attribute27 in varchar2 default null
46 ,p_drr_attribute28 in varchar2 default null
47 ,p_drr_attribute29 in varchar2 default null
48 ,p_drr_attribute30 in varchar2 default null
49 ,p_object_version_number out nocopy number
50 ,p_effective_date in date
51 ) is
52 --
53 -- Declare cursors and local variables
54 --
55 l_dsgn_rqmt_rlshp_typ_id ben_dsgn_rqmt_rlshp_typ.dsgn_rqmt_rlshp_typ_id%TYPE;
56 l_proc varchar2(72) := g_package||'create_DSGN_RQMT_RLSHP_TYP';
57 l_object_version_number ben_dsgn_rqmt_rlshp_typ.object_version_number%TYPE;
58 --
59 begin
60 --
61 hr_utility.set_location('Entering:'|| l_proc, 10);
62 --
63 -- Issue a savepoint if operating in validation only mode
64 --
65 savepoint create_DSGN_RQMT_RLSHP_TYP;
66 --
67 hr_utility.set_location(l_proc, 20);
68 --
69 -- Process Logic
70 --
71 begin
72 --
73 -- Start of API User Hook for the before hook of create_DSGN_RQMT_RLSHP_TYP
74 --
75 ben_DSGN_RQMT_RLSHP_TYP_bk1.create_DSGN_RQMT_RLSHP_TYP_b
76 (
77 p_rlshp_typ_cd => p_rlshp_typ_cd
78 ,p_dsgn_rqmt_id => p_dsgn_rqmt_id
79 ,p_business_group_id => p_business_group_id
80 ,p_drr_attribute_category => p_drr_attribute_category
81 ,p_drr_attribute1 => p_drr_attribute1
82 ,p_drr_attribute2 => p_drr_attribute2
83 ,p_drr_attribute3 => p_drr_attribute3
84 ,p_drr_attribute4 => p_drr_attribute4
85 ,p_drr_attribute5 => p_drr_attribute5
86 ,p_drr_attribute6 => p_drr_attribute6
87 ,p_drr_attribute7 => p_drr_attribute7
88 ,p_drr_attribute8 => p_drr_attribute8
89 ,p_drr_attribute9 => p_drr_attribute9
90 ,p_drr_attribute10 => p_drr_attribute10
91 ,p_drr_attribute11 => p_drr_attribute11
92 ,p_drr_attribute12 => p_drr_attribute12
93 ,p_drr_attribute13 => p_drr_attribute13
94 ,p_drr_attribute14 => p_drr_attribute14
95 ,p_drr_attribute15 => p_drr_attribute15
96 ,p_drr_attribute16 => p_drr_attribute16
97 ,p_drr_attribute17 => p_drr_attribute17
98 ,p_drr_attribute18 => p_drr_attribute18
99 ,p_drr_attribute19 => p_drr_attribute19
100 ,p_drr_attribute20 => p_drr_attribute20
101 ,p_drr_attribute21 => p_drr_attribute21
102 ,p_drr_attribute22 => p_drr_attribute22
103 ,p_drr_attribute23 => p_drr_attribute23
104 ,p_drr_attribute24 => p_drr_attribute24
105 ,p_drr_attribute25 => p_drr_attribute25
106 ,p_drr_attribute26 => p_drr_attribute26
107 ,p_drr_attribute27 => p_drr_attribute27
108 ,p_drr_attribute28 => p_drr_attribute28
109 ,p_drr_attribute29 => p_drr_attribute29
110 ,p_drr_attribute30 => p_drr_attribute30
111 ,p_effective_date => trunc(p_effective_date)
112 );
113 exception
114 when hr_api.cannot_find_prog_unit then
115 hr_api.cannot_find_prog_unit_error
116 (
117 p_module_name => 'CREATE_DSGN_RQMT_RLSHP_TYP'
118 ,p_hook_type => 'BP'
119 );
120 --
121 -- End of API User Hook for the before hook of create_DSGN_RQMT_RLSHP_TYP
122 --
123 end;
124 --
125 ben_drr_ins.ins
126 (
127 p_dsgn_rqmt_rlshp_typ_id => l_dsgn_rqmt_rlshp_typ_id
128 ,p_rlshp_typ_cd => p_rlshp_typ_cd
129 ,p_dsgn_rqmt_id => p_dsgn_rqmt_id
130 ,p_business_group_id => p_business_group_id
131 ,p_drr_attribute_category => p_drr_attribute_category
132 ,p_drr_attribute1 => p_drr_attribute1
133 ,p_drr_attribute2 => p_drr_attribute2
134 ,p_drr_attribute3 => p_drr_attribute3
135 ,p_drr_attribute4 => p_drr_attribute4
136 ,p_drr_attribute5 => p_drr_attribute5
137 ,p_drr_attribute6 => p_drr_attribute6
138 ,p_drr_attribute7 => p_drr_attribute7
139 ,p_drr_attribute8 => p_drr_attribute8
140 ,p_drr_attribute9 => p_drr_attribute9
141 ,p_drr_attribute10 => p_drr_attribute10
142 ,p_drr_attribute11 => p_drr_attribute11
143 ,p_drr_attribute12 => p_drr_attribute12
144 ,p_drr_attribute13 => p_drr_attribute13
145 ,p_drr_attribute14 => p_drr_attribute14
146 ,p_drr_attribute15 => p_drr_attribute15
147 ,p_drr_attribute16 => p_drr_attribute16
148 ,p_drr_attribute17 => p_drr_attribute17
149 ,p_drr_attribute18 => p_drr_attribute18
150 ,p_drr_attribute19 => p_drr_attribute19
151 ,p_drr_attribute20 => p_drr_attribute20
152 ,p_drr_attribute21 => p_drr_attribute21
153 ,p_drr_attribute22 => p_drr_attribute22
154 ,p_drr_attribute23 => p_drr_attribute23
155 ,p_drr_attribute24 => p_drr_attribute24
156 ,p_drr_attribute25 => p_drr_attribute25
157 ,p_drr_attribute26 => p_drr_attribute26
158 ,p_drr_attribute27 => p_drr_attribute27
159 ,p_drr_attribute28 => p_drr_attribute28
160 ,p_drr_attribute29 => p_drr_attribute29
161 ,p_drr_attribute30 => p_drr_attribute30
162 ,p_object_version_number => l_object_version_number
163 ,p_effective_date => trunc(p_effective_date)
164 );
165 --
166 begin
167 --
168 -- Start of API User Hook for the after hook of create_DSGN_RQMT_RLSHP_TYP
169 --
170 ben_DSGN_RQMT_RLSHP_TYP_bk1.create_DSGN_RQMT_RLSHP_TYP_a
171 (
172 p_dsgn_rqmt_rlshp_typ_id => l_dsgn_rqmt_rlshp_typ_id
173 ,p_rlshp_typ_cd => p_rlshp_typ_cd
174 ,p_dsgn_rqmt_id => p_dsgn_rqmt_id
175 ,p_business_group_id => p_business_group_id
176 ,p_drr_attribute_category => p_drr_attribute_category
177 ,p_drr_attribute1 => p_drr_attribute1
178 ,p_drr_attribute2 => p_drr_attribute2
179 ,p_drr_attribute3 => p_drr_attribute3
180 ,p_drr_attribute4 => p_drr_attribute4
181 ,p_drr_attribute5 => p_drr_attribute5
182 ,p_drr_attribute6 => p_drr_attribute6
183 ,p_drr_attribute7 => p_drr_attribute7
184 ,p_drr_attribute8 => p_drr_attribute8
185 ,p_drr_attribute9 => p_drr_attribute9
186 ,p_drr_attribute10 => p_drr_attribute10
187 ,p_drr_attribute11 => p_drr_attribute11
188 ,p_drr_attribute12 => p_drr_attribute12
189 ,p_drr_attribute13 => p_drr_attribute13
190 ,p_drr_attribute14 => p_drr_attribute14
191 ,p_drr_attribute15 => p_drr_attribute15
192 ,p_drr_attribute16 => p_drr_attribute16
193 ,p_drr_attribute17 => p_drr_attribute17
194 ,p_drr_attribute18 => p_drr_attribute18
195 ,p_drr_attribute19 => p_drr_attribute19
196 ,p_drr_attribute20 => p_drr_attribute20
197 ,p_drr_attribute21 => p_drr_attribute21
198 ,p_drr_attribute22 => p_drr_attribute22
199 ,p_drr_attribute23 => p_drr_attribute23
200 ,p_drr_attribute24 => p_drr_attribute24
201 ,p_drr_attribute25 => p_drr_attribute25
202 ,p_drr_attribute26 => p_drr_attribute26
203 ,p_drr_attribute27 => p_drr_attribute27
204 ,p_drr_attribute28 => p_drr_attribute28
205 ,p_drr_attribute29 => p_drr_attribute29
206 ,p_drr_attribute30 => p_drr_attribute30
207 ,p_object_version_number => l_object_version_number
208 ,p_effective_date => trunc(p_effective_date)
209 );
210 exception
211 when hr_api.cannot_find_prog_unit then
212 hr_api.cannot_find_prog_unit_error
213 (p_module_name => 'CREATE_DSGN_RQMT_RLSHP_TYP'
214 ,p_hook_type => 'AP'
215 );
216 --
217 -- End of API User Hook for the after hook of create_DSGN_RQMT_RLSHP_TYP
218 --
219 end;
220 --
221 hr_utility.set_location(l_proc, 60);
222 --
223 -- When in validation only mode raise the Validate_Enabled exception
224 --
225 if p_validate then
226 raise hr_api.validate_enabled;
227 end if;
228 --
229 -- Set all output arguments
230 --
231 p_dsgn_rqmt_rlshp_typ_id := l_dsgn_rqmt_rlshp_typ_id;
232 p_object_version_number := l_object_version_number;
233 --
234 hr_utility.set_location(' Leaving:'||l_proc, 70);
235 --
236 exception
237 --
238 when hr_api.validate_enabled then
239 --
240 -- As the Validate_Enabled exception has been raised
241 -- we must rollback to the savepoint
242 --
243 ROLLBACK TO create_DSGN_RQMT_RLSHP_TYP;
244 --
245 -- Only set output warning arguments
246 -- (Any key or derived arguments must be set to null
247 -- when validation only mode is being used.)
248 --
249 p_dsgn_rqmt_rlshp_typ_id := null;
250 p_object_version_number := null;
251 hr_utility.set_location(' Leaving:'||l_proc, 80);
252 --
253 when others then
254 --
255 -- A validation or unexpected error has occured
256 --
257 ROLLBACK TO create_DSGN_RQMT_RLSHP_TYP;
258
259 -- NOCOPY, Reset out parameters
260 p_dsgn_rqmt_rlshp_typ_id := null;
261 p_object_version_number := null;
262
263 raise;
264 --
265 end create_DSGN_RQMT_RLSHP_TYP;
266 -- ----------------------------------------------------------------------------
267 -- |------------------------< update_DSGN_RQMT_RLSHP_TYP >--- ------------------|
268 -- ----------------------------------------------------------------------------
269 --
270 procedure update_DSGN_RQMT_RLSHP_TYP
271 (p_validate in boolean default false
272 ,p_dsgn_rqmt_rlshp_typ_id in number
273 ,p_rlshp_typ_cd in varchar2 default hr_api.g_varchar2
274 ,p_dsgn_rqmt_id in number default hr_api.g_number
275 ,p_business_group_id in number default hr_api.g_number
276 ,p_drr_attribute_category in varchar2 default hr_api.g_varchar2
277 ,p_drr_attribute1 in varchar2 default hr_api.g_varchar2
278 ,p_drr_attribute2 in varchar2 default hr_api.g_varchar2
279 ,p_drr_attribute3 in varchar2 default hr_api.g_varchar2
280 ,p_drr_attribute4 in varchar2 default hr_api.g_varchar2
281 ,p_drr_attribute5 in varchar2 default hr_api.g_varchar2
282 ,p_drr_attribute6 in varchar2 default hr_api.g_varchar2
283 ,p_drr_attribute7 in varchar2 default hr_api.g_varchar2
284 ,p_drr_attribute8 in varchar2 default hr_api.g_varchar2
285 ,p_drr_attribute9 in varchar2 default hr_api.g_varchar2
286 ,p_drr_attribute10 in varchar2 default hr_api.g_varchar2
287 ,p_drr_attribute11 in varchar2 default hr_api.g_varchar2
288 ,p_drr_attribute12 in varchar2 default hr_api.g_varchar2
289 ,p_drr_attribute13 in varchar2 default hr_api.g_varchar2
290 ,p_drr_attribute14 in varchar2 default hr_api.g_varchar2
291 ,p_drr_attribute15 in varchar2 default hr_api.g_varchar2
292 ,p_drr_attribute16 in varchar2 default hr_api.g_varchar2
293 ,p_drr_attribute17 in varchar2 default hr_api.g_varchar2
294 ,p_drr_attribute18 in varchar2 default hr_api.g_varchar2
295 ,p_drr_attribute19 in varchar2 default hr_api.g_varchar2
296 ,p_drr_attribute20 in varchar2 default hr_api.g_varchar2
297 ,p_drr_attribute21 in varchar2 default hr_api.g_varchar2
298 ,p_drr_attribute22 in varchar2 default hr_api.g_varchar2
299 ,p_drr_attribute23 in varchar2 default hr_api.g_varchar2
300 ,p_drr_attribute24 in varchar2 default hr_api.g_varchar2
301 ,p_drr_attribute25 in varchar2 default hr_api.g_varchar2
302 ,p_drr_attribute26 in varchar2 default hr_api.g_varchar2
303 ,p_drr_attribute27 in varchar2 default hr_api.g_varchar2
304 ,p_drr_attribute28 in varchar2 default hr_api.g_varchar2
305 ,p_drr_attribute29 in varchar2 default hr_api.g_varchar2
306 ,p_drr_attribute30 in varchar2 default hr_api.g_varchar2
307 ,p_object_version_number in out nocopy number
308 ,p_effective_date in date
309 ) is
310 --
311 -- Declare cursors and local variables
312 --
313 l_proc varchar2(72) := g_package||'update_DSGN_RQMT_RLSHP_TYP';
314 l_object_version_number ben_dsgn_rqmt_rlshp_typ.object_version_number%TYPE;
315 --
316 begin
317 --
318 hr_utility.set_location('Entering:'|| l_proc, 10);
319 --
320 -- Issue a savepoint if operating in validation only mode
321 --
322 savepoint update_DSGN_RQMT_RLSHP_TYP;
323 --
324 hr_utility.set_location(l_proc, 20);
325 --
326 -- Process Logic
327 --
328 l_object_version_number := p_object_version_number;
329 --
330 begin
331 --
332 -- Start of API User Hook for the before hook of update_DSGN_RQMT_RLSHP_TYP
333 --
334 ben_DSGN_RQMT_RLSHP_TYP_bk2.update_DSGN_RQMT_RLSHP_TYP_b
335 (
336 p_dsgn_rqmt_rlshp_typ_id => p_dsgn_rqmt_rlshp_typ_id
337 ,p_rlshp_typ_cd => p_rlshp_typ_cd
338 ,p_dsgn_rqmt_id => p_dsgn_rqmt_id
339 ,p_business_group_id => p_business_group_id
340 ,p_drr_attribute_category => p_drr_attribute_category
341 ,p_drr_attribute1 => p_drr_attribute1
342 ,p_drr_attribute2 => p_drr_attribute2
343 ,p_drr_attribute3 => p_drr_attribute3
344 ,p_drr_attribute4 => p_drr_attribute4
345 ,p_drr_attribute5 => p_drr_attribute5
346 ,p_drr_attribute6 => p_drr_attribute6
347 ,p_drr_attribute7 => p_drr_attribute7
348 ,p_drr_attribute8 => p_drr_attribute8
349 ,p_drr_attribute9 => p_drr_attribute9
350 ,p_drr_attribute10 => p_drr_attribute10
351 ,p_drr_attribute11 => p_drr_attribute11
352 ,p_drr_attribute12 => p_drr_attribute12
353 ,p_drr_attribute13 => p_drr_attribute13
354 ,p_drr_attribute14 => p_drr_attribute14
355 ,p_drr_attribute15 => p_drr_attribute15
356 ,p_drr_attribute16 => p_drr_attribute16
357 ,p_drr_attribute17 => p_drr_attribute17
358 ,p_drr_attribute18 => p_drr_attribute18
359 ,p_drr_attribute19 => p_drr_attribute19
360 ,p_drr_attribute20 => p_drr_attribute20
361 ,p_drr_attribute21 => p_drr_attribute21
362 ,p_drr_attribute22 => p_drr_attribute22
363 ,p_drr_attribute23 => p_drr_attribute23
364 ,p_drr_attribute24 => p_drr_attribute24
365 ,p_drr_attribute25 => p_drr_attribute25
366 ,p_drr_attribute26 => p_drr_attribute26
367 ,p_drr_attribute27 => p_drr_attribute27
368 ,p_drr_attribute28 => p_drr_attribute28
369 ,p_drr_attribute29 => p_drr_attribute29
370 ,p_drr_attribute30 => p_drr_attribute30
371 ,p_object_version_number => p_object_version_number
372 ,p_effective_date => trunc(p_effective_date)
373 );
374 exception
375 when hr_api.cannot_find_prog_unit then
376 hr_api.cannot_find_prog_unit_error
377 (p_module_name => 'UPDATE_DSGN_RQMT_RLSHP_TYP'
378 ,p_hook_type => 'BP'
379 );
380 --
381 -- End of API User Hook for the before hook of update_DSGN_RQMT_RLSHP_TYP
382 --
383 end;
384 --
385 ben_drr_upd.upd
386 (
387 p_dsgn_rqmt_rlshp_typ_id => p_dsgn_rqmt_rlshp_typ_id
388 ,p_rlshp_typ_cd => p_rlshp_typ_cd
389 ,p_dsgn_rqmt_id => p_dsgn_rqmt_id
390 ,p_business_group_id => p_business_group_id
391 ,p_drr_attribute_category => p_drr_attribute_category
392 ,p_drr_attribute1 => p_drr_attribute1
393 ,p_drr_attribute2 => p_drr_attribute2
394 ,p_drr_attribute3 => p_drr_attribute3
395 ,p_drr_attribute4 => p_drr_attribute4
396 ,p_drr_attribute5 => p_drr_attribute5
397 ,p_drr_attribute6 => p_drr_attribute6
398 ,p_drr_attribute7 => p_drr_attribute7
399 ,p_drr_attribute8 => p_drr_attribute8
400 ,p_drr_attribute9 => p_drr_attribute9
401 ,p_drr_attribute10 => p_drr_attribute10
402 ,p_drr_attribute11 => p_drr_attribute11
403 ,p_drr_attribute12 => p_drr_attribute12
404 ,p_drr_attribute13 => p_drr_attribute13
405 ,p_drr_attribute14 => p_drr_attribute14
406 ,p_drr_attribute15 => p_drr_attribute15
407 ,p_drr_attribute16 => p_drr_attribute16
408 ,p_drr_attribute17 => p_drr_attribute17
409 ,p_drr_attribute18 => p_drr_attribute18
410 ,p_drr_attribute19 => p_drr_attribute19
411 ,p_drr_attribute20 => p_drr_attribute20
412 ,p_drr_attribute21 => p_drr_attribute21
413 ,p_drr_attribute22 => p_drr_attribute22
414 ,p_drr_attribute23 => p_drr_attribute23
415 ,p_drr_attribute24 => p_drr_attribute24
416 ,p_drr_attribute25 => p_drr_attribute25
417 ,p_drr_attribute26 => p_drr_attribute26
418 ,p_drr_attribute27 => p_drr_attribute27
419 ,p_drr_attribute28 => p_drr_attribute28
420 ,p_drr_attribute29 => p_drr_attribute29
421 ,p_drr_attribute30 => p_drr_attribute30
422 ,p_object_version_number => l_object_version_number
423 ,p_effective_date => trunc(p_effective_date)
424 );
425 --
426 begin
427 --
428 -- Start of API User Hook for the after hook of update_DSGN_RQMT_RLSHP_TYP
429 --
430 ben_DSGN_RQMT_RLSHP_TYP_bk2.update_DSGN_RQMT_RLSHP_TYP_a
431 (
432 p_dsgn_rqmt_rlshp_typ_id => p_dsgn_rqmt_rlshp_typ_id
433 ,p_rlshp_typ_cd => p_rlshp_typ_cd
434 ,p_dsgn_rqmt_id => p_dsgn_rqmt_id
435 ,p_business_group_id => p_business_group_id
436 ,p_drr_attribute_category => p_drr_attribute_category
437 ,p_drr_attribute1 => p_drr_attribute1
438 ,p_drr_attribute2 => p_drr_attribute2
439 ,p_drr_attribute3 => p_drr_attribute3
440 ,p_drr_attribute4 => p_drr_attribute4
441 ,p_drr_attribute5 => p_drr_attribute5
442 ,p_drr_attribute6 => p_drr_attribute6
443 ,p_drr_attribute7 => p_drr_attribute7
444 ,p_drr_attribute8 => p_drr_attribute8
445 ,p_drr_attribute9 => p_drr_attribute9
446 ,p_drr_attribute10 => p_drr_attribute10
447 ,p_drr_attribute11 => p_drr_attribute11
448 ,p_drr_attribute12 => p_drr_attribute12
449 ,p_drr_attribute13 => p_drr_attribute13
450 ,p_drr_attribute14 => p_drr_attribute14
451 ,p_drr_attribute15 => p_drr_attribute15
452 ,p_drr_attribute16 => p_drr_attribute16
453 ,p_drr_attribute17 => p_drr_attribute17
454 ,p_drr_attribute18 => p_drr_attribute18
455 ,p_drr_attribute19 => p_drr_attribute19
456 ,p_drr_attribute20 => p_drr_attribute20
457 ,p_drr_attribute21 => p_drr_attribute21
458 ,p_drr_attribute22 => p_drr_attribute22
459 ,p_drr_attribute23 => p_drr_attribute23
460 ,p_drr_attribute24 => p_drr_attribute24
461 ,p_drr_attribute25 => p_drr_attribute25
462 ,p_drr_attribute26 => p_drr_attribute26
463 ,p_drr_attribute27 => p_drr_attribute27
464 ,p_drr_attribute28 => p_drr_attribute28
465 ,p_drr_attribute29 => p_drr_attribute29
466 ,p_drr_attribute30 => p_drr_attribute30
467 ,p_object_version_number => l_object_version_number
468 ,p_effective_date => trunc(p_effective_date)
469 );
470 exception
471 when hr_api.cannot_find_prog_unit then
472 hr_api.cannot_find_prog_unit_error
473 (p_module_name => 'UPDATE_DSGN_RQMT_RLSHP_TYP'
474 ,p_hook_type => 'AP'
475 );
476 --
477 -- End of API User Hook for the after hook of update_DSGN_RQMT_RLSHP_TYP
478 --
479 end;
480 --
481 hr_utility.set_location(l_proc, 60);
482 --
483 -- When in validation only mode raise the Validate_Enabled exception
484 --
485 if p_validate then
486 raise hr_api.validate_enabled;
487 end if;
488 --
489 -- Set all output arguments
490 --
491 p_object_version_number := l_object_version_number;
492 --
493 hr_utility.set_location(' Leaving:'||l_proc, 70);
494 --
495 exception
496 --
497 when hr_api.validate_enabled then
498 --
499 -- As the Validate_Enabled exception has been raised
500 -- we must rollback to the savepoint
501 --
502 ROLLBACK TO update_DSGN_RQMT_RLSHP_TYP;
503 --
504 -- Only set output warning arguments
505 -- (Any key or derived arguments must be set to null
506 -- when validation only mode is being used.)
507 --
508 hr_utility.set_location(' Leaving:'||l_proc, 80);
509 --
510 when others then
511 --
512 -- A validation or unexpected error has occured
513 --
514 ROLLBACK TO update_DSGN_RQMT_RLSHP_TYP;
515 raise;
516 --
517 end update_DSGN_RQMT_RLSHP_TYP;
518 -- ----------------------------------------------------------------------------
519 -- |------------------------< delete_DSGN_RQMT_RLSHP_TYP >----------------------|
520 -- ----------------------------------------------------------------------------
521 --
522 procedure delete_DSGN_RQMT_RLSHP_TYP
523 (p_validate in boolean default false
524 ,p_dsgn_rqmt_rlshp_typ_id in number
525 ,p_object_version_number in out nocopy number
526 ,p_effective_date in date
527 ) is
528 --
529 -- Declare cursors and local variables
530 --
531 l_proc varchar2(72) := g_package||'update_DSGN_RQMT_RLSHP_TYP';
532 l_object_version_number ben_dsgn_rqmt_rlshp_typ.object_version_number%TYPE;
533 --
534 begin
535 --
536 hr_utility.set_location('Entering:'|| l_proc, 10);
537 --
538 -- Issue a savepoint if operating in validation only mode
539 --
540 savepoint delete_DSGN_RQMT_RLSHP_TYP;
541 --
542 hr_utility.set_location(l_proc, 20);
543 --
544 -- Process Logic
545 --
546 l_object_version_number := p_object_version_number;
547 --
548 --
549 begin
550 --
551 -- Start of API User Hook for the before hook of delete_DSGN_RQMT_RLSHP_TYP
552 --
553 ben_DSGN_RQMT_RLSHP_TYP_bk3.delete_DSGN_RQMT_RLSHP_TYP_b
554 (
555 p_dsgn_rqmt_rlshp_typ_id => p_dsgn_rqmt_rlshp_typ_id
556 ,p_object_version_number => p_object_version_number
557 ,p_effective_date => trunc(p_effective_date)
558 );
559 exception
560 when hr_api.cannot_find_prog_unit then
561 hr_api.cannot_find_prog_unit_error
562 (p_module_name => 'DELETE_DSGN_RQMT_RLSHP_TYP'
563 ,p_hook_type => 'BP'
564 );
565 --
566 -- End of API User Hook for the before hook of delete_DSGN_RQMT_RLSHP_TYP
567 --
568 end;
569 --
570 ben_drr_del.del
571 (
572 p_dsgn_rqmt_rlshp_typ_id => p_dsgn_rqmt_rlshp_typ_id
573 ,p_object_version_number => l_object_version_number
574 ,p_effective_date => p_effective_date
575 );
576 --
577 begin
578 --
579 -- Start of API User Hook for the after hook of delete_DSGN_RQMT_RLSHP_TYP
580 --
581 ben_DSGN_RQMT_RLSHP_TYP_bk3.delete_DSGN_RQMT_RLSHP_TYP_a
582 (
583 p_dsgn_rqmt_rlshp_typ_id => p_dsgn_rqmt_rlshp_typ_id
584 ,p_object_version_number => l_object_version_number
585 ,p_effective_date => trunc(p_effective_date)
586 );
587 exception
588 when hr_api.cannot_find_prog_unit then
589 hr_api.cannot_find_prog_unit_error
590 (p_module_name => 'DELETE_DSGN_RQMT_RLSHP_TYP'
591 ,p_hook_type => 'AP'
592 );
593 --
594 -- End of API User Hook for the after hook of delete_DSGN_RQMT_RLSHP_TYP
595 --
596 end;
597 --
598 hr_utility.set_location(l_proc, 60);
599 --
600 -- When in validation only mode raise the Validate_Enabled exception
601 --
602 if p_validate then
603 raise hr_api.validate_enabled;
604 end if;
605 --
606 hr_utility.set_location(' Leaving:'||l_proc, 70);
607 --
608 exception
609 --
610 when hr_api.validate_enabled then
611 --
612 -- As the Validate_Enabled exception has been raised
613 -- we must rollback to the savepoint
614 --
615 ROLLBACK TO delete_DSGN_RQMT_RLSHP_TYP;
616 --
617 -- Only set output warning arguments
618 -- (Any key or derived arguments must be set to null
619 -- when validation only mode is being used.)
620 --
621 --
622 when others then
623 --
624 -- A validation or unexpected error has occured
625 --
626 ROLLBACK TO delete_DSGN_RQMT_RLSHP_TYP;
627 raise;
628 --
629 end delete_DSGN_RQMT_RLSHP_TYP;
630 --
631 -- ----------------------------------------------------------------------------
632 -- |-------------------------------< lck >------------------------------------|
633 -- ----------------------------------------------------------------------------
634 --
635 procedure lck
636 (
637 p_dsgn_rqmt_rlshp_typ_id in number
638 ,p_object_version_number in number
639 ) is
640 --
641 --
642 -- Declare cursors and local variables
643 --
644 l_proc varchar2(72) := g_package||'lck';
645 --
646 begin
647 --
648 hr_utility.set_location('Entering:'|| l_proc, 10);
649 --
650 ben_drr_shd.lck
651 (
652 p_dsgn_rqmt_rlshp_typ_id => p_dsgn_rqmt_rlshp_typ_id
653 ,p_object_version_number => p_object_version_number
654 );
655 --
656 hr_utility.set_location(' Leaving:'||l_proc, 70);
657 --
658 end lck;
659 --
660 end ben_DSGN_RQMT_RLSHP_TYP_api;