118: ,p_attribute29 => p_attribute29
119: ,p_attribute30 => p_attribute30
120: );
121: exception
122: when hr_api.cannot_find_prog_unit then
123: hr_api.cannot_find_prog_unit_error
124: (p_module_name => 'CREATE_REQUISITION'
125: ,p_hook_type => 'BP'
126: );
119: ,p_attribute30 => p_attribute30
120: );
121: exception
122: when hr_api.cannot_find_prog_unit then
123: hr_api.cannot_find_prog_unit_error
124: (p_module_name => 'CREATE_REQUISITION'
125: ,p_hook_type => 'BP'
126: );
127: end;
210: ,p_attribute29 => p_attribute29
211: ,p_attribute30 => p_attribute30
212: );
213: exception
214: when hr_api.cannot_find_prog_unit then
215: hr_api.cannot_find_prog_unit_error
216: (p_module_name => 'CREATE_REQUISITION'
217: ,p_hook_type => 'AP'
218: );
211: ,p_attribute30 => p_attribute30
212: );
213: exception
214: when hr_api.cannot_find_prog_unit then
215: hr_api.cannot_find_prog_unit_error
216: (p_module_name => 'CREATE_REQUISITION'
217: ,p_hook_type => 'AP'
218: );
219: end;
220: --
221: -- When in validation only mode raise the Validate_Enabled exception
222: --
223: if p_validate then
224: raise hr_api.validate_enabled;
225: end if;
226: --
227: -- Set all output arguments
228: --
230: p_object_version_number := l_object_version_number;
231: --
232: hr_utility.set_location(' Leaving:'||l_proc, 70);
233: exception
234: when hr_api.validate_enabled then
235: --
236: -- As the Validate_Enabled exception has been raised
237: -- we must rollback to the savepoint
238: --
263: procedure update_requisition
264: (p_validate in boolean default false
265: ,p_requisition_id in number
266: ,p_object_version_number in out nocopy number
267: ,p_date_from in date default hr_api.g_date
268: ,p_person_id in number default hr_api.g_number
269: ,p_comments in varchar2 default hr_api.g_varchar2
270: ,p_date_to in date default hr_api.g_date
271: ,p_description in varchar2 default hr_api.g_varchar2
264: (p_validate in boolean default false
265: ,p_requisition_id in number
266: ,p_object_version_number in out nocopy number
267: ,p_date_from in date default hr_api.g_date
268: ,p_person_id in number default hr_api.g_number
269: ,p_comments in varchar2 default hr_api.g_varchar2
270: ,p_date_to in date default hr_api.g_date
271: ,p_description in varchar2 default hr_api.g_varchar2
272: ,p_attribute_category in varchar2 default hr_api.g_varchar2
265: ,p_requisition_id in number
266: ,p_object_version_number in out nocopy number
267: ,p_date_from in date default hr_api.g_date
268: ,p_person_id in number default hr_api.g_number
269: ,p_comments in varchar2 default hr_api.g_varchar2
270: ,p_date_to in date default hr_api.g_date
271: ,p_description in varchar2 default hr_api.g_varchar2
272: ,p_attribute_category in varchar2 default hr_api.g_varchar2
273: ,p_attribute1 in varchar2 default hr_api.g_varchar2
266: ,p_object_version_number in out nocopy number
267: ,p_date_from in date default hr_api.g_date
268: ,p_person_id in number default hr_api.g_number
269: ,p_comments in varchar2 default hr_api.g_varchar2
270: ,p_date_to in date default hr_api.g_date
271: ,p_description in varchar2 default hr_api.g_varchar2
272: ,p_attribute_category in varchar2 default hr_api.g_varchar2
273: ,p_attribute1 in varchar2 default hr_api.g_varchar2
274: ,p_attribute2 in varchar2 default hr_api.g_varchar2
267: ,p_date_from in date default hr_api.g_date
268: ,p_person_id in number default hr_api.g_number
269: ,p_comments in varchar2 default hr_api.g_varchar2
270: ,p_date_to in date default hr_api.g_date
271: ,p_description in varchar2 default hr_api.g_varchar2
272: ,p_attribute_category in varchar2 default hr_api.g_varchar2
273: ,p_attribute1 in varchar2 default hr_api.g_varchar2
274: ,p_attribute2 in varchar2 default hr_api.g_varchar2
275: ,p_attribute3 in varchar2 default hr_api.g_varchar2
268: ,p_person_id in number default hr_api.g_number
269: ,p_comments in varchar2 default hr_api.g_varchar2
270: ,p_date_to in date default hr_api.g_date
271: ,p_description in varchar2 default hr_api.g_varchar2
272: ,p_attribute_category in varchar2 default hr_api.g_varchar2
273: ,p_attribute1 in varchar2 default hr_api.g_varchar2
274: ,p_attribute2 in varchar2 default hr_api.g_varchar2
275: ,p_attribute3 in varchar2 default hr_api.g_varchar2
276: ,p_attribute4 in varchar2 default hr_api.g_varchar2
269: ,p_comments in varchar2 default hr_api.g_varchar2
270: ,p_date_to in date default hr_api.g_date
271: ,p_description in varchar2 default hr_api.g_varchar2
272: ,p_attribute_category in varchar2 default hr_api.g_varchar2
273: ,p_attribute1 in varchar2 default hr_api.g_varchar2
274: ,p_attribute2 in varchar2 default hr_api.g_varchar2
275: ,p_attribute3 in varchar2 default hr_api.g_varchar2
276: ,p_attribute4 in varchar2 default hr_api.g_varchar2
277: ,p_attribute5 in varchar2 default hr_api.g_varchar2
270: ,p_date_to in date default hr_api.g_date
271: ,p_description in varchar2 default hr_api.g_varchar2
272: ,p_attribute_category in varchar2 default hr_api.g_varchar2
273: ,p_attribute1 in varchar2 default hr_api.g_varchar2
274: ,p_attribute2 in varchar2 default hr_api.g_varchar2
275: ,p_attribute3 in varchar2 default hr_api.g_varchar2
276: ,p_attribute4 in varchar2 default hr_api.g_varchar2
277: ,p_attribute5 in varchar2 default hr_api.g_varchar2
278: ,p_attribute6 in varchar2 default hr_api.g_varchar2
271: ,p_description in varchar2 default hr_api.g_varchar2
272: ,p_attribute_category in varchar2 default hr_api.g_varchar2
273: ,p_attribute1 in varchar2 default hr_api.g_varchar2
274: ,p_attribute2 in varchar2 default hr_api.g_varchar2
275: ,p_attribute3 in varchar2 default hr_api.g_varchar2
276: ,p_attribute4 in varchar2 default hr_api.g_varchar2
277: ,p_attribute5 in varchar2 default hr_api.g_varchar2
278: ,p_attribute6 in varchar2 default hr_api.g_varchar2
279: ,p_attribute7 in varchar2 default hr_api.g_varchar2
272: ,p_attribute_category in varchar2 default hr_api.g_varchar2
273: ,p_attribute1 in varchar2 default hr_api.g_varchar2
274: ,p_attribute2 in varchar2 default hr_api.g_varchar2
275: ,p_attribute3 in varchar2 default hr_api.g_varchar2
276: ,p_attribute4 in varchar2 default hr_api.g_varchar2
277: ,p_attribute5 in varchar2 default hr_api.g_varchar2
278: ,p_attribute6 in varchar2 default hr_api.g_varchar2
279: ,p_attribute7 in varchar2 default hr_api.g_varchar2
280: ,p_attribute8 in varchar2 default hr_api.g_varchar2
273: ,p_attribute1 in varchar2 default hr_api.g_varchar2
274: ,p_attribute2 in varchar2 default hr_api.g_varchar2
275: ,p_attribute3 in varchar2 default hr_api.g_varchar2
276: ,p_attribute4 in varchar2 default hr_api.g_varchar2
277: ,p_attribute5 in varchar2 default hr_api.g_varchar2
278: ,p_attribute6 in varchar2 default hr_api.g_varchar2
279: ,p_attribute7 in varchar2 default hr_api.g_varchar2
280: ,p_attribute8 in varchar2 default hr_api.g_varchar2
281: ,p_attribute9 in varchar2 default hr_api.g_varchar2
274: ,p_attribute2 in varchar2 default hr_api.g_varchar2
275: ,p_attribute3 in varchar2 default hr_api.g_varchar2
276: ,p_attribute4 in varchar2 default hr_api.g_varchar2
277: ,p_attribute5 in varchar2 default hr_api.g_varchar2
278: ,p_attribute6 in varchar2 default hr_api.g_varchar2
279: ,p_attribute7 in varchar2 default hr_api.g_varchar2
280: ,p_attribute8 in varchar2 default hr_api.g_varchar2
281: ,p_attribute9 in varchar2 default hr_api.g_varchar2
282: ,p_attribute10 in varchar2 default hr_api.g_varchar2
275: ,p_attribute3 in varchar2 default hr_api.g_varchar2
276: ,p_attribute4 in varchar2 default hr_api.g_varchar2
277: ,p_attribute5 in varchar2 default hr_api.g_varchar2
278: ,p_attribute6 in varchar2 default hr_api.g_varchar2
279: ,p_attribute7 in varchar2 default hr_api.g_varchar2
280: ,p_attribute8 in varchar2 default hr_api.g_varchar2
281: ,p_attribute9 in varchar2 default hr_api.g_varchar2
282: ,p_attribute10 in varchar2 default hr_api.g_varchar2
283: ,p_attribute11 in varchar2 default hr_api.g_varchar2
276: ,p_attribute4 in varchar2 default hr_api.g_varchar2
277: ,p_attribute5 in varchar2 default hr_api.g_varchar2
278: ,p_attribute6 in varchar2 default hr_api.g_varchar2
279: ,p_attribute7 in varchar2 default hr_api.g_varchar2
280: ,p_attribute8 in varchar2 default hr_api.g_varchar2
281: ,p_attribute9 in varchar2 default hr_api.g_varchar2
282: ,p_attribute10 in varchar2 default hr_api.g_varchar2
283: ,p_attribute11 in varchar2 default hr_api.g_varchar2
284: ,p_attribute12 in varchar2 default hr_api.g_varchar2
277: ,p_attribute5 in varchar2 default hr_api.g_varchar2
278: ,p_attribute6 in varchar2 default hr_api.g_varchar2
279: ,p_attribute7 in varchar2 default hr_api.g_varchar2
280: ,p_attribute8 in varchar2 default hr_api.g_varchar2
281: ,p_attribute9 in varchar2 default hr_api.g_varchar2
282: ,p_attribute10 in varchar2 default hr_api.g_varchar2
283: ,p_attribute11 in varchar2 default hr_api.g_varchar2
284: ,p_attribute12 in varchar2 default hr_api.g_varchar2
285: ,p_attribute13 in varchar2 default hr_api.g_varchar2
278: ,p_attribute6 in varchar2 default hr_api.g_varchar2
279: ,p_attribute7 in varchar2 default hr_api.g_varchar2
280: ,p_attribute8 in varchar2 default hr_api.g_varchar2
281: ,p_attribute9 in varchar2 default hr_api.g_varchar2
282: ,p_attribute10 in varchar2 default hr_api.g_varchar2
283: ,p_attribute11 in varchar2 default hr_api.g_varchar2
284: ,p_attribute12 in varchar2 default hr_api.g_varchar2
285: ,p_attribute13 in varchar2 default hr_api.g_varchar2
286: ,p_attribute14 in varchar2 default hr_api.g_varchar2
279: ,p_attribute7 in varchar2 default hr_api.g_varchar2
280: ,p_attribute8 in varchar2 default hr_api.g_varchar2
281: ,p_attribute9 in varchar2 default hr_api.g_varchar2
282: ,p_attribute10 in varchar2 default hr_api.g_varchar2
283: ,p_attribute11 in varchar2 default hr_api.g_varchar2
284: ,p_attribute12 in varchar2 default hr_api.g_varchar2
285: ,p_attribute13 in varchar2 default hr_api.g_varchar2
286: ,p_attribute14 in varchar2 default hr_api.g_varchar2
287: ,p_attribute15 in varchar2 default hr_api.g_varchar2
280: ,p_attribute8 in varchar2 default hr_api.g_varchar2
281: ,p_attribute9 in varchar2 default hr_api.g_varchar2
282: ,p_attribute10 in varchar2 default hr_api.g_varchar2
283: ,p_attribute11 in varchar2 default hr_api.g_varchar2
284: ,p_attribute12 in varchar2 default hr_api.g_varchar2
285: ,p_attribute13 in varchar2 default hr_api.g_varchar2
286: ,p_attribute14 in varchar2 default hr_api.g_varchar2
287: ,p_attribute15 in varchar2 default hr_api.g_varchar2
288: ,p_attribute16 in varchar2 default hr_api.g_varchar2
281: ,p_attribute9 in varchar2 default hr_api.g_varchar2
282: ,p_attribute10 in varchar2 default hr_api.g_varchar2
283: ,p_attribute11 in varchar2 default hr_api.g_varchar2
284: ,p_attribute12 in varchar2 default hr_api.g_varchar2
285: ,p_attribute13 in varchar2 default hr_api.g_varchar2
286: ,p_attribute14 in varchar2 default hr_api.g_varchar2
287: ,p_attribute15 in varchar2 default hr_api.g_varchar2
288: ,p_attribute16 in varchar2 default hr_api.g_varchar2
289: ,p_attribute17 in varchar2 default hr_api.g_varchar2
282: ,p_attribute10 in varchar2 default hr_api.g_varchar2
283: ,p_attribute11 in varchar2 default hr_api.g_varchar2
284: ,p_attribute12 in varchar2 default hr_api.g_varchar2
285: ,p_attribute13 in varchar2 default hr_api.g_varchar2
286: ,p_attribute14 in varchar2 default hr_api.g_varchar2
287: ,p_attribute15 in varchar2 default hr_api.g_varchar2
288: ,p_attribute16 in varchar2 default hr_api.g_varchar2
289: ,p_attribute17 in varchar2 default hr_api.g_varchar2
290: ,p_attribute18 in varchar2 default hr_api.g_varchar2
283: ,p_attribute11 in varchar2 default hr_api.g_varchar2
284: ,p_attribute12 in varchar2 default hr_api.g_varchar2
285: ,p_attribute13 in varchar2 default hr_api.g_varchar2
286: ,p_attribute14 in varchar2 default hr_api.g_varchar2
287: ,p_attribute15 in varchar2 default hr_api.g_varchar2
288: ,p_attribute16 in varchar2 default hr_api.g_varchar2
289: ,p_attribute17 in varchar2 default hr_api.g_varchar2
290: ,p_attribute18 in varchar2 default hr_api.g_varchar2
291: ,p_attribute19 in varchar2 default hr_api.g_varchar2
284: ,p_attribute12 in varchar2 default hr_api.g_varchar2
285: ,p_attribute13 in varchar2 default hr_api.g_varchar2
286: ,p_attribute14 in varchar2 default hr_api.g_varchar2
287: ,p_attribute15 in varchar2 default hr_api.g_varchar2
288: ,p_attribute16 in varchar2 default hr_api.g_varchar2
289: ,p_attribute17 in varchar2 default hr_api.g_varchar2
290: ,p_attribute18 in varchar2 default hr_api.g_varchar2
291: ,p_attribute19 in varchar2 default hr_api.g_varchar2
292: ,p_attribute20 in varchar2 default hr_api.g_varchar2
285: ,p_attribute13 in varchar2 default hr_api.g_varchar2
286: ,p_attribute14 in varchar2 default hr_api.g_varchar2
287: ,p_attribute15 in varchar2 default hr_api.g_varchar2
288: ,p_attribute16 in varchar2 default hr_api.g_varchar2
289: ,p_attribute17 in varchar2 default hr_api.g_varchar2
290: ,p_attribute18 in varchar2 default hr_api.g_varchar2
291: ,p_attribute19 in varchar2 default hr_api.g_varchar2
292: ,p_attribute20 in varchar2 default hr_api.g_varchar2
293: ,p_attribute21 in varchar2 default hr_api.g_varchar2
286: ,p_attribute14 in varchar2 default hr_api.g_varchar2
287: ,p_attribute15 in varchar2 default hr_api.g_varchar2
288: ,p_attribute16 in varchar2 default hr_api.g_varchar2
289: ,p_attribute17 in varchar2 default hr_api.g_varchar2
290: ,p_attribute18 in varchar2 default hr_api.g_varchar2
291: ,p_attribute19 in varchar2 default hr_api.g_varchar2
292: ,p_attribute20 in varchar2 default hr_api.g_varchar2
293: ,p_attribute21 in varchar2 default hr_api.g_varchar2
294: ,p_attribute22 in varchar2 default hr_api.g_varchar2
287: ,p_attribute15 in varchar2 default hr_api.g_varchar2
288: ,p_attribute16 in varchar2 default hr_api.g_varchar2
289: ,p_attribute17 in varchar2 default hr_api.g_varchar2
290: ,p_attribute18 in varchar2 default hr_api.g_varchar2
291: ,p_attribute19 in varchar2 default hr_api.g_varchar2
292: ,p_attribute20 in varchar2 default hr_api.g_varchar2
293: ,p_attribute21 in varchar2 default hr_api.g_varchar2
294: ,p_attribute22 in varchar2 default hr_api.g_varchar2
295: ,p_attribute23 in varchar2 default hr_api.g_varchar2
288: ,p_attribute16 in varchar2 default hr_api.g_varchar2
289: ,p_attribute17 in varchar2 default hr_api.g_varchar2
290: ,p_attribute18 in varchar2 default hr_api.g_varchar2
291: ,p_attribute19 in varchar2 default hr_api.g_varchar2
292: ,p_attribute20 in varchar2 default hr_api.g_varchar2
293: ,p_attribute21 in varchar2 default hr_api.g_varchar2
294: ,p_attribute22 in varchar2 default hr_api.g_varchar2
295: ,p_attribute23 in varchar2 default hr_api.g_varchar2
296: ,p_attribute24 in varchar2 default hr_api.g_varchar2
289: ,p_attribute17 in varchar2 default hr_api.g_varchar2
290: ,p_attribute18 in varchar2 default hr_api.g_varchar2
291: ,p_attribute19 in varchar2 default hr_api.g_varchar2
292: ,p_attribute20 in varchar2 default hr_api.g_varchar2
293: ,p_attribute21 in varchar2 default hr_api.g_varchar2
294: ,p_attribute22 in varchar2 default hr_api.g_varchar2
295: ,p_attribute23 in varchar2 default hr_api.g_varchar2
296: ,p_attribute24 in varchar2 default hr_api.g_varchar2
297: ,p_attribute25 in varchar2 default hr_api.g_varchar2
290: ,p_attribute18 in varchar2 default hr_api.g_varchar2
291: ,p_attribute19 in varchar2 default hr_api.g_varchar2
292: ,p_attribute20 in varchar2 default hr_api.g_varchar2
293: ,p_attribute21 in varchar2 default hr_api.g_varchar2
294: ,p_attribute22 in varchar2 default hr_api.g_varchar2
295: ,p_attribute23 in varchar2 default hr_api.g_varchar2
296: ,p_attribute24 in varchar2 default hr_api.g_varchar2
297: ,p_attribute25 in varchar2 default hr_api.g_varchar2
298: ,p_attribute26 in varchar2 default hr_api.g_varchar2
291: ,p_attribute19 in varchar2 default hr_api.g_varchar2
292: ,p_attribute20 in varchar2 default hr_api.g_varchar2
293: ,p_attribute21 in varchar2 default hr_api.g_varchar2
294: ,p_attribute22 in varchar2 default hr_api.g_varchar2
295: ,p_attribute23 in varchar2 default hr_api.g_varchar2
296: ,p_attribute24 in varchar2 default hr_api.g_varchar2
297: ,p_attribute25 in varchar2 default hr_api.g_varchar2
298: ,p_attribute26 in varchar2 default hr_api.g_varchar2
299: ,p_attribute27 in varchar2 default hr_api.g_varchar2
292: ,p_attribute20 in varchar2 default hr_api.g_varchar2
293: ,p_attribute21 in varchar2 default hr_api.g_varchar2
294: ,p_attribute22 in varchar2 default hr_api.g_varchar2
295: ,p_attribute23 in varchar2 default hr_api.g_varchar2
296: ,p_attribute24 in varchar2 default hr_api.g_varchar2
297: ,p_attribute25 in varchar2 default hr_api.g_varchar2
298: ,p_attribute26 in varchar2 default hr_api.g_varchar2
299: ,p_attribute27 in varchar2 default hr_api.g_varchar2
300: ,p_attribute28 in varchar2 default hr_api.g_varchar2
293: ,p_attribute21 in varchar2 default hr_api.g_varchar2
294: ,p_attribute22 in varchar2 default hr_api.g_varchar2
295: ,p_attribute23 in varchar2 default hr_api.g_varchar2
296: ,p_attribute24 in varchar2 default hr_api.g_varchar2
297: ,p_attribute25 in varchar2 default hr_api.g_varchar2
298: ,p_attribute26 in varchar2 default hr_api.g_varchar2
299: ,p_attribute27 in varchar2 default hr_api.g_varchar2
300: ,p_attribute28 in varchar2 default hr_api.g_varchar2
301: ,p_attribute29 in varchar2 default hr_api.g_varchar2
294: ,p_attribute22 in varchar2 default hr_api.g_varchar2
295: ,p_attribute23 in varchar2 default hr_api.g_varchar2
296: ,p_attribute24 in varchar2 default hr_api.g_varchar2
297: ,p_attribute25 in varchar2 default hr_api.g_varchar2
298: ,p_attribute26 in varchar2 default hr_api.g_varchar2
299: ,p_attribute27 in varchar2 default hr_api.g_varchar2
300: ,p_attribute28 in varchar2 default hr_api.g_varchar2
301: ,p_attribute29 in varchar2 default hr_api.g_varchar2
302: ,p_attribute30 in varchar2 default hr_api.g_varchar2
295: ,p_attribute23 in varchar2 default hr_api.g_varchar2
296: ,p_attribute24 in varchar2 default hr_api.g_varchar2
297: ,p_attribute25 in varchar2 default hr_api.g_varchar2
298: ,p_attribute26 in varchar2 default hr_api.g_varchar2
299: ,p_attribute27 in varchar2 default hr_api.g_varchar2
300: ,p_attribute28 in varchar2 default hr_api.g_varchar2
301: ,p_attribute29 in varchar2 default hr_api.g_varchar2
302: ,p_attribute30 in varchar2 default hr_api.g_varchar2
303: ) is
296: ,p_attribute24 in varchar2 default hr_api.g_varchar2
297: ,p_attribute25 in varchar2 default hr_api.g_varchar2
298: ,p_attribute26 in varchar2 default hr_api.g_varchar2
299: ,p_attribute27 in varchar2 default hr_api.g_varchar2
300: ,p_attribute28 in varchar2 default hr_api.g_varchar2
301: ,p_attribute29 in varchar2 default hr_api.g_varchar2
302: ,p_attribute30 in varchar2 default hr_api.g_varchar2
303: ) is
304: --
297: ,p_attribute25 in varchar2 default hr_api.g_varchar2
298: ,p_attribute26 in varchar2 default hr_api.g_varchar2
299: ,p_attribute27 in varchar2 default hr_api.g_varchar2
300: ,p_attribute28 in varchar2 default hr_api.g_varchar2
301: ,p_attribute29 in varchar2 default hr_api.g_varchar2
302: ,p_attribute30 in varchar2 default hr_api.g_varchar2
303: ) is
304: --
305: -- Declare cursors and local variables
298: ,p_attribute26 in varchar2 default hr_api.g_varchar2
299: ,p_attribute27 in varchar2 default hr_api.g_varchar2
300: ,p_attribute28 in varchar2 default hr_api.g_varchar2
301: ,p_attribute29 in varchar2 default hr_api.g_varchar2
302: ,p_attribute30 in varchar2 default hr_api.g_varchar2
303: ) is
304: --
305: -- Declare cursors and local variables
306: --
366: ,p_attribute29 => p_attribute29
367: ,p_attribute30 => p_attribute30
368: );
369: exception
370: when hr_api.cannot_find_prog_unit then
371: hr_api.cannot_find_prog_unit_error
372: (p_module_name => 'UPDATE_REQUISITION'
373: ,p_hook_type => 'BP'
374: );
367: ,p_attribute30 => p_attribute30
368: );
369: exception
370: when hr_api.cannot_find_prog_unit then
371: hr_api.cannot_find_prog_unit_error
372: (p_module_name => 'UPDATE_REQUISITION'
373: ,p_hook_type => 'BP'
374: );
375: end;
457: ,p_attribute29 => p_attribute29
458: ,p_attribute30 => p_attribute30
459: );
460: exception
461: when hr_api.cannot_find_prog_unit then
462: hr_api.cannot_find_prog_unit_error
463: (p_module_name => 'UPDATE_REQUISITION'
464: ,p_hook_type => 'AP'
465: );
458: ,p_attribute30 => p_attribute30
459: );
460: exception
461: when hr_api.cannot_find_prog_unit then
462: hr_api.cannot_find_prog_unit_error
463: (p_module_name => 'UPDATE_REQUISITION'
464: ,p_hook_type => 'AP'
465: );
466: end;
467: --
468: -- When in validation only mode raise the Validate_Enabled exception
469: --
470: if p_validate then
471: raise hr_api.validate_enabled;
472: end if;
473: --
474: -- Set all output arguments
475: --
476: p_object_version_number := l_object_version_number;
477: --
478: hr_utility.set_location(' Leaving:'||l_proc, 70);
479: exception
480: when hr_api.validate_enabled then
481: --
482: -- As the Validate_Enabled exception has been raised
483: -- we must rollback to the savepoint
484: --
529: p_requisition_id => p_requisition_id
530: ,p_object_version_number => p_object_version_number
531: );
532: exception
533: when hr_api.cannot_find_prog_unit then
534: hr_api.cannot_find_prog_unit_error
535: (p_module_name => 'DELETE_REQUISITION'
536: ,p_hook_type => 'BP'
537: );
530: ,p_object_version_number => p_object_version_number
531: );
532: exception
533: when hr_api.cannot_find_prog_unit then
534: hr_api.cannot_find_prog_unit_error
535: (p_module_name => 'DELETE_REQUISITION'
536: ,p_hook_type => 'BP'
537: );
538: end;
557: p_requisition_id => p_requisition_id
558: ,p_object_version_number => p_object_version_number
559: );
560: exception
561: when hr_api.cannot_find_prog_unit then
562: hr_api.cannot_find_prog_unit_error
563: (p_module_name => 'DELETE_REQUISITION'
564: ,p_hook_type => 'AP'
565: );
558: ,p_object_version_number => p_object_version_number
559: );
560: exception
561: when hr_api.cannot_find_prog_unit then
562: hr_api.cannot_find_prog_unit_error
563: (p_module_name => 'DELETE_REQUISITION'
564: ,p_hook_type => 'AP'
565: );
566: end;
567: --
568: -- When in validation only mode raise the Validate_Enabled exception
569: --
570: if p_validate then
571: raise hr_api.validate_enabled;
572: end if;
573: --
574: -- Set all output arguments
575: --
575: --
576: --
577: hr_utility.set_location(' Leaving:'||l_proc, 70);
578: exception
579: when hr_api.validate_enabled then
580: --
581: -- As the Validate_Enabled exception has been raised
582: -- we must rollback to the savepoint
583: --