DBA Data[Home] [Help]

PACKAGE BODY: APPS.PQH_TXN_JOB_REQUIREMENTS_API

Source


1 Package Body PQH_TXN_JOB_REQUIREMENTS_API as
2 /* $Header: pqtjrapi.pkb 115.2 2002/12/06 23:49:05 rpasapul noship $ */
3 --
4 -- Package Variables
5 --
6 g_package  varchar2(33) := '  PQH_TXN_JOB_REQUIREMENTS_API.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |------------------< CREATE_TXN_JOB_REQUIREMENT >--------------------------|
10 -- ----------------------------------------------------------------------------
11 --
12 procedure CREATE_TXN_JOB_REQUIREMENT
13   (p_validate                       in     boolean  default false
14   ,p_effective_date                 in     date
15   ,p_txn_job_requirement_id         out nocopy   number
16   ,p_object_version_number          out nocopy    number
17   ,p_business_group_id              in     number
18   ,p_analysis_criteria_id           in     number
19   ,p_position_transaction_id        in     number   default null
20   ,p_job_requirement_id             in     number   default null
21   ,p_date_from                      in     date     default null
22   ,p_date_to                        in     date     default null
23   ,p_essential                      in     varchar2 default null
24   ,p_job_id                         in     number   default null
25   ,p_request_id                     in     number   default null
26   ,p_program_application_id         in     number   default null
27   ,p_program_id                     in     number   default null
28   ,p_program_update_date            in     date     default null
29   ,p_attribute_category             in     varchar2 default null
30   ,p_attribute1                     in     varchar2 default null
31   ,p_attribute2                     in     varchar2 default null
32   ,p_attribute3                     in     varchar2 default null
33   ,p_attribute4                     in     varchar2 default null
34   ,p_attribute5                     in     varchar2 default null
35   ,p_attribute6                     in     varchar2 default null
36   ,p_attribute7                     in     varchar2 default null
37   ,p_attribute8                     in     varchar2 default null
38   ,p_attribute9                     in     varchar2 default null
39   ,p_attribute10                    in     varchar2 default null
40   ,p_attribute11                    in     varchar2 default null
41   ,p_attribute12                    in     varchar2 default null
42   ,p_attribute13                    in     varchar2 default null
43   ,p_attribute14                    in     varchar2 default null
44   ,p_attribute15                    in     varchar2 default null
45   ,p_attribute16                    in     varchar2 default null
46   ,p_attribute17                    in     varchar2 default null
47   ,p_attribute18                    in     varchar2 default null
48   ,p_attribute19                    in     varchar2 default null
49   ,p_attribute20                    in     varchar2 default null
50   ,p_comments                       in     varchar2 default null
51   ) is
52   --
53   -- Declare cursors and local variables
54   --
55 
56   l_proc                varchar2(72) := g_package||'CREATE_TXN_JOB_REQUIREMENT';
57   l_txn_job_requirement_id  PQH_TXN_JOB_REQUIREMENTS.TXN_JOB_REQUIREMENT_ID%TYPE;
58   l_object_version_number   PQH_TXN_JOB_REQUIREMENTS.object_version_number%TYPE;
59 begin
60   hr_utility.set_location('Entering:'|| l_proc, 10);
61   --
62   -- Issue a savepoint
63   --
64   savepoint CREATE_TXN_JOB_REQUIREMENT;
65   --
66   -- Truncate the time portion from all IN date parameters
67   --
68 
69   --
70   -- Call Before Process User Hook
71   --
72   begin
73     PQH_TXN_JOB_REQUIREMENTS_BK1.CREATE_TXN_JOB_REQUIREMENT_b
74       (p_effective_date                 => p_effective_date
75       ,p_business_group_id              => p_business_group_id
76       ,p_analysis_criteria_id           => p_analysis_criteria_id
77       ,p_position_transaction_id        => p_position_transaction_id
78       ,p_job_requirement_id             => p_job_requirement_id
79       ,p_date_from                      => p_date_from
80       ,p_date_to                        => p_date_to
81       ,p_essential                      => p_essential
82       ,p_job_id                         => p_job_id
83       ,p_request_id                     => p_request_id
84       ,p_program_application_id         => p_program_application_id
85       ,p_program_id                     => p_program_id
86       ,p_program_update_date            => p_program_update_date
87       ,p_attribute_category             => p_attribute_category
88       ,p_attribute1                     => p_attribute1
89       ,p_attribute2                     => p_attribute2
90       ,p_attribute3                     => p_attribute3
91       ,p_attribute4                     => p_attribute4
92       ,p_attribute5                     => p_attribute5
93       ,p_attribute6                     => p_attribute6
94       ,p_attribute7                     => p_attribute7
95       ,p_attribute8                     => p_attribute8
96       ,p_attribute9                     => p_attribute9
97       ,p_attribute10                    => p_attribute10
98       ,p_attribute11                    => p_attribute11
99       ,p_attribute12                    => p_attribute12
100       ,p_attribute13                    => p_attribute13
101       ,p_attribute14                    => p_attribute14
102       ,p_attribute15                    => p_attribute15
103       ,p_attribute16                    => p_attribute16
104       ,p_attribute17                    => p_attribute17
105       ,p_attribute18                    => p_attribute18
106       ,p_attribute19                    => p_attribute19
107       ,p_attribute20                    => p_attribute20
108       ,p_comments                       => p_comments
109       );
110   exception
111     when hr_api.cannot_find_prog_unit then
112       hr_api.cannot_find_prog_unit_error
113         (p_module_name => 'CREATE_TXN_JOB_REQUIREMENT'
114         ,p_hook_type   => 'BP'
115         );
116   end;
117   --
118   -- Validation in addition to Row Handlers
119   --
120 
121 
122 
123   --
124   -- Process Logic
125   --
126   pqh_tjr_ins.ins
127   (p_business_group_id              => p_business_group_id
128       ,p_analysis_criteria_id           => p_analysis_criteria_id
129       ,p_position_transaction_id        => p_position_transaction_id
130       ,p_job_requirement_id             => p_job_requirement_id
131       ,p_date_from                      => p_date_from
132       ,p_date_to                        => p_date_to
133       ,p_essential                      => p_essential
134       ,p_job_id                         => p_job_id
135       ,p_request_id                     => p_request_id
136       ,p_program_application_id         => p_program_application_id
137       ,p_program_id                     => p_program_id
138       ,p_program_update_date            => p_program_update_date
139       ,p_attribute_category             => p_attribute_category
140       ,p_attribute1                     => p_attribute1
141       ,p_attribute2                     => p_attribute2
142       ,p_attribute3                     => p_attribute3
143       ,p_attribute4                     => p_attribute4
144       ,p_attribute5                     => p_attribute5
145       ,p_attribute6                     => p_attribute6
146       ,p_attribute7                     => p_attribute7
147       ,p_attribute8                     => p_attribute8
148       ,p_attribute9                     => p_attribute9
149       ,p_attribute10                    => p_attribute10
150       ,p_attribute11                    => p_attribute11
151       ,p_attribute12                    => p_attribute12
152       ,p_attribute13                    => p_attribute13
153       ,p_attribute14                    => p_attribute14
154       ,p_attribute15                    => p_attribute15
155       ,p_attribute16                    => p_attribute16
156       ,p_attribute17                    => p_attribute17
157       ,p_attribute18                    => p_attribute18
158       ,p_attribute19                    => p_attribute19
159       ,p_attribute20                    => p_attribute20
160       ,p_comments                       => p_comments
161       ,p_txn_job_requirement_id         => l_txn_job_requirement_id
162       ,p_object_version_number          => l_object_version_number
163   );
164 
165 
166   --
167   -- Call After Process User Hook
168   --
169   begin
170     PQH_TXN_JOB_REQUIREMENTS_BK1.CREATE_TXN_JOB_REQUIREMENT_a
171       (p_effective_date                 => p_effective_date
172       ,p_txn_job_requirement_id         => l_txn_job_requirement_id
173       ,p_object_version_number          => l_object_version_number
174       ,p_business_group_id              => p_business_group_id
175       ,p_analysis_criteria_id           => p_analysis_criteria_id
176       ,p_position_transaction_id        => p_position_transaction_id
177       ,p_job_requirement_id             => p_job_requirement_id
178       ,p_date_from                      => p_date_from
179       ,p_date_to                        => p_date_to
180       ,p_essential                      => p_essential
181       ,p_job_id                         => p_job_id
182       ,p_request_id                     => p_request_id
183       ,p_program_application_id         => p_program_application_id
184       ,p_program_id                     => p_program_id
185       ,p_program_update_date            => p_program_update_date
186       ,p_attribute_category             => p_attribute_category
187       ,p_attribute1                     => p_attribute1
188       ,p_attribute2                     => p_attribute2
189       ,p_attribute3                     => p_attribute3
190       ,p_attribute4                     => p_attribute4
191       ,p_attribute5                     => p_attribute5
192       ,p_attribute6                     => p_attribute6
193       ,p_attribute7                     => p_attribute7
194       ,p_attribute8                     => p_attribute8
195       ,p_attribute9                     => p_attribute9
196       ,p_attribute10                    => p_attribute10
197       ,p_attribute11                    => p_attribute11
198       ,p_attribute12                    => p_attribute12
199       ,p_attribute13                    => p_attribute13
200       ,p_attribute14                    => p_attribute14
201       ,p_attribute15                    => p_attribute15
202       ,p_attribute16                    => p_attribute16
203       ,p_attribute17                    => p_attribute17
204       ,p_attribute18                    => p_attribute18
205       ,p_attribute19                    => p_attribute19
206       ,p_attribute20                    => p_attribute20
207       ,p_comments                       => p_comments
208       );
209   exception
210     when hr_api.cannot_find_prog_unit then
211       hr_api.cannot_find_prog_unit_error
212         (p_module_name => 'CREATE_TXN_JOB_REQUIREMENT'
213         ,p_hook_type   => 'AP'
214         );
215   end;
216   --
217   -- When in validation only mode raise the Validate_Enabled exception
218   --
219   if p_validate then
220     raise hr_api.validate_enabled;
221   end if;
222   --
223   -- Set all output arguments
224   --
225   p_txn_job_requirement_id := l_txn_job_requirement_id;
226   p_object_version_number  := l_object_version_number;
227   --
228   hr_utility.set_location(' Leaving:'||l_proc, 70);
229 exception
230   when hr_api.validate_enabled then
231     --
232     -- As the Validate_Enabled exception has been raised
233     -- we must rollback to the savepoint
234     --
235     rollback to CREATE_TXN_JOB_REQUIREMENT;
236     --
237     -- Only set output warning arguments
238     -- (Any key or derived arguments must be set to null
239     -- when validation only mode is being used.)
240     --
241     p_txn_job_requirement_id := null;
242     p_object_version_number  := null;
243     hr_utility.set_location(' Leaving:'||l_proc, 80);
244   when others then
245       p_txn_job_requirement_id := null;
246     p_object_version_number  := null;
247     --
248     -- A validation or unexpected error has occured
249     --
250     rollback to CREATE_TXN_JOB_REQUIREMENT;
251     hr_utility.set_location(' Leaving:'||l_proc, 90);
252     raise;
253 end CREATE_TXN_JOB_REQUIREMENT;
254 --
255 -- ----------------------------------------------------------------------------
256 -- |------------------< UPDATE_TXN_JOB_REQUIREMENT >--------------------------|
257 -- ----------------------------------------------------------------------------
258 --
259 procedure UPDATE_TXN_JOB_REQUIREMENT
260   (p_validate                     in     boolean  default false
261   ,p_effective_date               in     date
262   ,p_txn_job_requirement_id       in     number
263   ,p_object_version_number        in out nocopy number
264   ,p_business_group_id            in     number    default hr_api.g_number
265   ,p_analysis_criteria_id         in     number    default hr_api.g_number
266   ,p_position_transaction_id      in     number    default hr_api.g_number
267   ,p_job_requirement_id           in     number    default hr_api.g_number
268   ,p_date_from                    in     date      default hr_api.g_date
269   ,p_date_to                      in     date      default hr_api.g_date
270   ,p_essential                    in     varchar2  default hr_api.g_varchar2
271   ,p_job_id                       in     number    default hr_api.g_number
272   ,p_request_id                   in     number    default hr_api.g_number
273   ,p_program_application_id       in     number    default hr_api.g_number
274   ,p_program_id                   in     number    default hr_api.g_number
275   ,p_program_update_date          in     date      default hr_api.g_date
276   ,p_attribute_category           in     varchar2  default hr_api.g_varchar2
277   ,p_attribute1                   in     varchar2  default hr_api.g_varchar2
278   ,p_attribute2                   in     varchar2  default hr_api.g_varchar2
279   ,p_attribute3                   in     varchar2  default hr_api.g_varchar2
280   ,p_attribute4                   in     varchar2  default hr_api.g_varchar2
281   ,p_attribute5                   in     varchar2  default hr_api.g_varchar2
282   ,p_attribute6                   in     varchar2  default hr_api.g_varchar2
283   ,p_attribute7                   in     varchar2  default hr_api.g_varchar2
284   ,p_attribute8                   in     varchar2  default hr_api.g_varchar2
285   ,p_attribute9                   in     varchar2  default hr_api.g_varchar2
286   ,p_attribute10                  in     varchar2  default hr_api.g_varchar2
287   ,p_attribute11                  in     varchar2  default hr_api.g_varchar2
288   ,p_attribute12                  in     varchar2  default hr_api.g_varchar2
289   ,p_attribute13                  in     varchar2  default hr_api.g_varchar2
290   ,p_attribute14                  in     varchar2  default hr_api.g_varchar2
291   ,p_attribute15                  in     varchar2  default hr_api.g_varchar2
292   ,p_attribute16                  in     varchar2  default hr_api.g_varchar2
293   ,p_attribute17                  in     varchar2  default hr_api.g_varchar2
294   ,p_attribute18                  in     varchar2  default hr_api.g_varchar2
295   ,p_attribute19                  in     varchar2  default hr_api.g_varchar2
296   ,p_attribute20                  in     varchar2  default hr_api.g_varchar2
297   ,p_comments                     in     varchar2  default hr_api.g_varchar2
298   ) is
299   --
300   -- Declare cursors and local variables
301   --
302 
303   l_proc                varchar2(72) := g_package||'UPDATE_TXN_JOB_REQUIREMENT';
304   l_object_version_number   PQH_TXN_JOB_REQUIREMENTS.object_version_number%TYPE;
305 begin
306   hr_utility.set_location('Entering:'|| l_proc, 10);
307   --
308   -- Issue a savepoint
309   --
310   savepoint UPDATE_TXN_JOB_REQUIREMENT;
311   --
312   -- Truncate the time portion from all IN date parameters
313   --
314   l_object_version_number := p_object_version_number;
315   --
316   -- Call Before Process User Hook
317   --
318   begin
319     PQH_TXN_JOB_REQUIREMENTS_BK2.UPDATE_TXN_JOB_REQUIREMENT_b
320       (p_effective_date                 => p_effective_date
321       ,p_business_group_id              => p_business_group_id
322       ,p_analysis_criteria_id           => p_analysis_criteria_id
323       ,p_position_transaction_id        => p_position_transaction_id
324       ,p_job_requirement_id             => p_job_requirement_id
325       ,p_date_from                      => p_date_from
326       ,p_date_to                        => p_date_to
327       ,p_essential                      => p_essential
328       ,p_job_id                         => p_job_id
329       ,p_request_id                     => p_request_id
330       ,p_program_application_id         => p_program_application_id
331       ,p_program_id                     => p_program_id
332       ,p_program_update_date            => p_program_update_date
333       ,p_attribute_category             => p_attribute_category
334       ,p_attribute1                     => p_attribute1
335       ,p_attribute2                     => p_attribute2
336       ,p_attribute3                     => p_attribute3
337       ,p_attribute4                     => p_attribute4
338       ,p_attribute5                     => p_attribute5
339       ,p_attribute6                     => p_attribute6
340       ,p_attribute7                     => p_attribute7
341       ,p_attribute8                     => p_attribute8
342       ,p_attribute9                     => p_attribute9
343       ,p_attribute10                    => p_attribute10
344       ,p_attribute11                    => p_attribute11
345       ,p_attribute12                    => p_attribute12
346       ,p_attribute13                    => p_attribute13
347       ,p_attribute14                    => p_attribute14
348       ,p_attribute15                    => p_attribute15
349       ,p_attribute16                    => p_attribute16
350       ,p_attribute17                    => p_attribute17
351       ,p_attribute18                    => p_attribute18
352       ,p_attribute19                    => p_attribute19
353       ,p_attribute20                    => p_attribute20
354       ,p_comments                       => p_comments
355       ,p_txn_job_requirement_id         => p_txn_job_requirement_id
356       ,p_object_version_number          => p_object_version_number
357       );
358   exception
359     when hr_api.cannot_find_prog_unit then
360       hr_api.cannot_find_prog_unit_error
361         (p_module_name => 'UPDATE_TXN_JOB_REQUIREMENT'
362         ,p_hook_type   => 'BP'
363         );
364   end;
365   --
366   -- Validation in addition to Row Handlers
367   --
368 
369 
370 
371   --
372   -- Process Logic
373   --
374   pqh_tjr_upd.upd
375   (    p_business_group_id              => p_business_group_id
376       ,p_analysis_criteria_id           => p_analysis_criteria_id
377       ,p_position_transaction_id        => p_position_transaction_id
378       ,p_job_requirement_id             => p_job_requirement_id
379       ,p_date_from                      => p_date_from
380       ,p_date_to                        => p_date_to
381       ,p_essential                      => p_essential
382       ,p_job_id                         => p_job_id
383       ,p_request_id                     => p_request_id
384       ,p_program_application_id         => p_program_application_id
385       ,p_program_id                     => p_program_id
386       ,p_program_update_date            => p_program_update_date
387       ,p_attribute_category             => p_attribute_category
388       ,p_attribute1                     => p_attribute1
389       ,p_attribute2                     => p_attribute2
390       ,p_attribute3                     => p_attribute3
391       ,p_attribute4                     => p_attribute4
392       ,p_attribute5                     => p_attribute5
393       ,p_attribute6                     => p_attribute6
394       ,p_attribute7                     => p_attribute7
395       ,p_attribute8                     => p_attribute8
396       ,p_attribute9                     => p_attribute9
397       ,p_attribute10                    => p_attribute10
398       ,p_attribute11                    => p_attribute11
399       ,p_attribute12                    => p_attribute12
400       ,p_attribute13                    => p_attribute13
401       ,p_attribute14                    => p_attribute14
402       ,p_attribute15                    => p_attribute15
403       ,p_attribute16                    => p_attribute16
404       ,p_attribute17                    => p_attribute17
405       ,p_attribute18                    => p_attribute18
406       ,p_attribute19                    => p_attribute19
407       ,p_attribute20                    => p_attribute20
408       ,p_comments                       => p_comments
409       ,p_txn_job_requirement_id         => p_txn_job_requirement_id
410       ,p_object_version_number          => l_object_version_number
411   );
412 
413 
414   --
415   -- Call After Process User Hook
416   --
417   begin
418     PQH_TXN_JOB_REQUIREMENTS_BK2.UPDATE_TXN_JOB_REQUIREMENT_a
419       (p_effective_date                 => p_effective_date
420       ,p_txn_job_requirement_id         => p_txn_job_requirement_id
421       ,p_object_version_number          => l_object_version_number
422       ,p_business_group_id              => p_business_group_id
423       ,p_analysis_criteria_id           => p_analysis_criteria_id
424       ,p_position_transaction_id        => p_position_transaction_id
425       ,p_job_requirement_id             => p_job_requirement_id
426       ,p_date_from                      => p_date_from
427       ,p_date_to                        => p_date_to
428       ,p_essential                      => p_essential
429       ,p_job_id                         => p_job_id
430       ,p_request_id                     => p_request_id
431       ,p_program_application_id         => p_program_application_id
432       ,p_program_id                     => p_program_id
433       ,p_program_update_date            => p_program_update_date
434       ,p_attribute_category             => p_attribute_category
435       ,p_attribute1                     => p_attribute1
436       ,p_attribute2                     => p_attribute2
437       ,p_attribute3                     => p_attribute3
438       ,p_attribute4                     => p_attribute4
439       ,p_attribute5                     => p_attribute5
440       ,p_attribute6                     => p_attribute6
441       ,p_attribute7                     => p_attribute7
442       ,p_attribute8                     => p_attribute8
443       ,p_attribute9                     => p_attribute9
444       ,p_attribute10                    => p_attribute10
445       ,p_attribute11                    => p_attribute11
446       ,p_attribute12                    => p_attribute12
447       ,p_attribute13                    => p_attribute13
448       ,p_attribute14                    => p_attribute14
449       ,p_attribute15                    => p_attribute15
450       ,p_attribute16                    => p_attribute16
451       ,p_attribute17                    => p_attribute17
452       ,p_attribute18                    => p_attribute18
453       ,p_attribute19                    => p_attribute19
454       ,p_attribute20                    => p_attribute20
455       ,p_comments                       => p_comments
456       );
457   exception
458     when hr_api.cannot_find_prog_unit then
459       hr_api.cannot_find_prog_unit_error
460         (p_module_name => 'UPDATE_TXN_JOB_REQUIREMENT'
461         ,p_hook_type   => 'AP'
462         );
463   end;
464   --
465   -- When in validation only mode raise the Validate_Enabled exception
466   --
467   if p_validate then
468     raise hr_api.validate_enabled;
469   end if;
470   --
471   -- Set all output arguments
472   --
473   p_object_version_number  := l_object_version_number;
474   --
475   hr_utility.set_location(' Leaving:'||l_proc, 70);
476 exception
477   when hr_api.validate_enabled then
478     --
479     -- As the Validate_Enabled exception has been raised
480     -- we must rollback to the savepoint
481     --
482     rollback to UPDATE_TXN_JOB_REQUIREMENT;
483     --
484     -- Only set output warning arguments
485     -- (Any key or derived arguments must be set to null
486     -- when validation only mode is being used.)
487     --
488     p_object_version_number  := null;
489     hr_utility.set_location(' Leaving:'||l_proc, 80);
490   when others then
491     p_object_version_number  := l_object_version_number;
492     --
493     -- A validation or unexpected error has occured
494     --
495     rollback to UPDATE_TXN_JOB_REQUIREMENT;
496     hr_utility.set_location(' Leaving:'||l_proc, 90);
497     raise;
498 end UPDATE_TXN_JOB_REQUIREMENT;
499 --
500 -- ----------------------------------------------------------------------------
501 -- |------------------< DELETE_TXN_JOB_REQUIREMENT >--------------------------|
502 -- ----------------------------------------------------------------------------
503 --
504 procedure DELETE_TXN_JOB_REQUIREMENT
505   (p_validate                       in     boolean  default false
506   ,p_effective_date                 in     date
507   ,p_txn_job_requirement_id         in     number
508   ,p_object_version_number          in     number
509   ) is
510   --
511   -- Declare cursors and local variables
512   --
513 
514   l_proc                varchar2(72) := g_package||'DELETE_TXN_JOB_REQUIREMENT';
515   l_object_version_number   PQH_TXN_JOB_REQUIREMENTS.object_version_number%TYPE;
516 begin
517   hr_utility.set_location('Entering:'|| l_proc, 10);
518   --
519   -- Issue a savepoint
520   --
521   savepoint DELETE_TXN_JOB_REQUIREMENT;
522   --
523   -- Truncate the time portion from all IN date parameters
524   --
525   l_object_version_number := p_object_version_number;
526   --
527   -- Call Before Process User Hook
528   --
529   begin
530     PQH_TXN_JOB_REQUIREMENTS_BK3.DELETE_TXN_JOB_REQUIREMENT_b
531       (p_effective_date                 => p_effective_date
532       ,p_txn_job_requirement_id         => p_txn_job_requirement_id
533       ,p_object_version_number          => l_object_version_number
534       );
535   exception
536     when hr_api.cannot_find_prog_unit then
537       hr_api.cannot_find_prog_unit_error
538         (p_module_name => 'DELETE_TXN_JOB_REQUIREMENT'
539         ,p_hook_type   => 'BP'
540         );
541   end;
542   --
543   -- Validation in addition to Row Handlers
544   --
545 
546 
547 
548   --
549   -- Process Logic
550   --
551   pqh_tjr_del.del
552   (    p_txn_job_requirement_id         => p_txn_job_requirement_id
553       ,p_object_version_number          => l_object_version_number
554   );
555 
556 
557   --
558   -- Call After Process User Hook
559   --
560   begin
561     PQH_TXN_JOB_REQUIREMENTS_BK3.DELETE_TXN_JOB_REQUIREMENT_a
562       (p_effective_date                 => p_effective_date
563       ,p_txn_job_requirement_id         => p_txn_job_requirement_id
564       ,p_object_version_number          => l_object_version_number
565       );
566   exception
567     when hr_api.cannot_find_prog_unit then
568       hr_api.cannot_find_prog_unit_error
569         (p_module_name => 'DELETE_TXN_JOB_REQUIREMENT'
570         ,p_hook_type   => 'AP'
571         );
572   end;
573   --
574   -- When in validation only mode raise the Validate_Enabled exception
575   --
576   if p_validate then
577     raise hr_api.validate_enabled;
578   end if;
579   --
580   -- Set all output arguments
581   --
582   --
583   hr_utility.set_location(' Leaving:'||l_proc, 70);
584 exception
585   when hr_api.validate_enabled then
586     --
587     -- As the Validate_Enabled exception has been raised
588     -- we must rollback to the savepoint
589     --
590     rollback to DELETE_TXN_JOB_REQUIREMENT;
591     --
592     -- Only set output warning arguments
593     -- (Any key or derived arguments must be set to null
594     -- when validation only mode is being used.)
595     --
596     hr_utility.set_location(' Leaving:'||l_proc, 80);
597   when others then
598     --
599     -- A validation or unexpected error has occured
600     --
601     rollback to DELETE_TXN_JOB_REQUIREMENT;
602     hr_utility.set_location(' Leaving:'||l_proc, 90);
603     raise;
604 end DELETE_TXN_JOB_REQUIREMENT;
605 --
606 end PQH_TXN_JOB_REQUIREMENTS_API;