105: ,p_offering_id => p_offering_id
106: );
107:
108: exception
109: when hr_api.cannot_find_prog_unit then
110: hr_api.cannot_find_prog_unit_error
111: (p_module_name => 'CREATE_RESOURCE'
112: ,p_hook_type => 'BP'
113: );
106: );
107:
108: exception
109: when hr_api.cannot_find_prog_unit then
110: hr_api.cannot_find_prog_unit_error
111: (p_module_name => 'CREATE_RESOURCE'
112: ,p_hook_type => 'BP'
113: );
114: end;
199: ,p_object_version_number => l_object_version_number
200: ,p_offering_id => p_offering_id
201: );
202: exception
203: when hr_api.cannot_find_prog_unit then
204: hr_api.cannot_find_prog_unit_error
205: (p_module_name => 'CREATE_RESOURCE'
206: ,p_hook_type => 'AP'
207: );
200: ,p_offering_id => p_offering_id
201: );
202: exception
203: when hr_api.cannot_find_prog_unit then
204: hr_api.cannot_find_prog_unit_error
205: (p_module_name => 'CREATE_RESOURCE'
206: ,p_hook_type => 'AP'
207: );
208: end;
210: --
211: -- When in validation only mode raise the Validate_Enabled exception
212: --
213: if p_validate then
214: raise hr_api.validate_enabled;
215: end if;
216: --
217: -- Set all output arguments
218: --
220: p_object_version_number := l_object_version_number;
221: --
222: hr_utility.set_location(' Leaving:'||l_proc, 70);
223: exception
224: when hr_api.validate_enabled then
225: --
226: -- As the Validate_Enabled exception has been raised
227: -- we must rollback to the savepoint
228: --
253: (p_validate in boolean default false
254: ,p_effective_date in date
255: ,p_resource_usage_id in number
256: ,p_object_version_number in out nocopy number
257: ,p_activity_version_id in number default hr_api.g_number
258: ,p_required_flag in varchar2 default hr_api.g_varchar2
259: ,p_start_date in date default hr_api.g_date
260: ,p_supplied_resource_id in number default hr_api.g_number
261: ,p_comments in varchar2 default hr_api.g_varchar2
254: ,p_effective_date in date
255: ,p_resource_usage_id in number
256: ,p_object_version_number in out nocopy number
257: ,p_activity_version_id in number default hr_api.g_number
258: ,p_required_flag in varchar2 default hr_api.g_varchar2
259: ,p_start_date in date default hr_api.g_date
260: ,p_supplied_resource_id in number default hr_api.g_number
261: ,p_comments in varchar2 default hr_api.g_varchar2
262: ,p_end_date in date default hr_api.g_date
255: ,p_resource_usage_id in number
256: ,p_object_version_number in out nocopy number
257: ,p_activity_version_id in number default hr_api.g_number
258: ,p_required_flag in varchar2 default hr_api.g_varchar2
259: ,p_start_date in date default hr_api.g_date
260: ,p_supplied_resource_id in number default hr_api.g_number
261: ,p_comments in varchar2 default hr_api.g_varchar2
262: ,p_end_date in date default hr_api.g_date
263: ,p_quantity in number default hr_api.g_number
256: ,p_object_version_number in out nocopy number
257: ,p_activity_version_id in number default hr_api.g_number
258: ,p_required_flag in varchar2 default hr_api.g_varchar2
259: ,p_start_date in date default hr_api.g_date
260: ,p_supplied_resource_id in number default hr_api.g_number
261: ,p_comments in varchar2 default hr_api.g_varchar2
262: ,p_end_date in date default hr_api.g_date
263: ,p_quantity in number default hr_api.g_number
264: ,p_resource_type in varchar2 default hr_api.g_varchar2
257: ,p_activity_version_id in number default hr_api.g_number
258: ,p_required_flag in varchar2 default hr_api.g_varchar2
259: ,p_start_date in date default hr_api.g_date
260: ,p_supplied_resource_id in number default hr_api.g_number
261: ,p_comments in varchar2 default hr_api.g_varchar2
262: ,p_end_date in date default hr_api.g_date
263: ,p_quantity in number default hr_api.g_number
264: ,p_resource_type in varchar2 default hr_api.g_varchar2
265: ,p_role_to_play in varchar2 default hr_api.g_varchar2
258: ,p_required_flag in varchar2 default hr_api.g_varchar2
259: ,p_start_date in date default hr_api.g_date
260: ,p_supplied_resource_id in number default hr_api.g_number
261: ,p_comments in varchar2 default hr_api.g_varchar2
262: ,p_end_date in date default hr_api.g_date
263: ,p_quantity in number default hr_api.g_number
264: ,p_resource_type in varchar2 default hr_api.g_varchar2
265: ,p_role_to_play in varchar2 default hr_api.g_varchar2
266: ,p_usage_reason in varchar2 default hr_api.g_varchar2
259: ,p_start_date in date default hr_api.g_date
260: ,p_supplied_resource_id in number default hr_api.g_number
261: ,p_comments in varchar2 default hr_api.g_varchar2
262: ,p_end_date in date default hr_api.g_date
263: ,p_quantity in number default hr_api.g_number
264: ,p_resource_type in varchar2 default hr_api.g_varchar2
265: ,p_role_to_play in varchar2 default hr_api.g_varchar2
266: ,p_usage_reason in varchar2 default hr_api.g_varchar2
267: ,p_rud_information_category in varchar2 default hr_api.g_varchar2
260: ,p_supplied_resource_id in number default hr_api.g_number
261: ,p_comments in varchar2 default hr_api.g_varchar2
262: ,p_end_date in date default hr_api.g_date
263: ,p_quantity in number default hr_api.g_number
264: ,p_resource_type in varchar2 default hr_api.g_varchar2
265: ,p_role_to_play in varchar2 default hr_api.g_varchar2
266: ,p_usage_reason in varchar2 default hr_api.g_varchar2
267: ,p_rud_information_category in varchar2 default hr_api.g_varchar2
268: ,p_rud_information1 in varchar2 default hr_api.g_varchar2
261: ,p_comments in varchar2 default hr_api.g_varchar2
262: ,p_end_date in date default hr_api.g_date
263: ,p_quantity in number default hr_api.g_number
264: ,p_resource_type in varchar2 default hr_api.g_varchar2
265: ,p_role_to_play in varchar2 default hr_api.g_varchar2
266: ,p_usage_reason in varchar2 default hr_api.g_varchar2
267: ,p_rud_information_category in varchar2 default hr_api.g_varchar2
268: ,p_rud_information1 in varchar2 default hr_api.g_varchar2
269: ,p_rud_information2 in varchar2 default hr_api.g_varchar2
262: ,p_end_date in date default hr_api.g_date
263: ,p_quantity in number default hr_api.g_number
264: ,p_resource_type in varchar2 default hr_api.g_varchar2
265: ,p_role_to_play in varchar2 default hr_api.g_varchar2
266: ,p_usage_reason in varchar2 default hr_api.g_varchar2
267: ,p_rud_information_category in varchar2 default hr_api.g_varchar2
268: ,p_rud_information1 in varchar2 default hr_api.g_varchar2
269: ,p_rud_information2 in varchar2 default hr_api.g_varchar2
270: ,p_rud_information3 in varchar2 default hr_api.g_varchar2
263: ,p_quantity in number default hr_api.g_number
264: ,p_resource_type in varchar2 default hr_api.g_varchar2
265: ,p_role_to_play in varchar2 default hr_api.g_varchar2
266: ,p_usage_reason in varchar2 default hr_api.g_varchar2
267: ,p_rud_information_category in varchar2 default hr_api.g_varchar2
268: ,p_rud_information1 in varchar2 default hr_api.g_varchar2
269: ,p_rud_information2 in varchar2 default hr_api.g_varchar2
270: ,p_rud_information3 in varchar2 default hr_api.g_varchar2
271: ,p_rud_information4 in varchar2 default hr_api.g_varchar2
264: ,p_resource_type in varchar2 default hr_api.g_varchar2
265: ,p_role_to_play in varchar2 default hr_api.g_varchar2
266: ,p_usage_reason in varchar2 default hr_api.g_varchar2
267: ,p_rud_information_category in varchar2 default hr_api.g_varchar2
268: ,p_rud_information1 in varchar2 default hr_api.g_varchar2
269: ,p_rud_information2 in varchar2 default hr_api.g_varchar2
270: ,p_rud_information3 in varchar2 default hr_api.g_varchar2
271: ,p_rud_information4 in varchar2 default hr_api.g_varchar2
272: ,p_rud_information5 in varchar2 default hr_api.g_varchar2
265: ,p_role_to_play in varchar2 default hr_api.g_varchar2
266: ,p_usage_reason in varchar2 default hr_api.g_varchar2
267: ,p_rud_information_category in varchar2 default hr_api.g_varchar2
268: ,p_rud_information1 in varchar2 default hr_api.g_varchar2
269: ,p_rud_information2 in varchar2 default hr_api.g_varchar2
270: ,p_rud_information3 in varchar2 default hr_api.g_varchar2
271: ,p_rud_information4 in varchar2 default hr_api.g_varchar2
272: ,p_rud_information5 in varchar2 default hr_api.g_varchar2
273: ,p_rud_information6 in varchar2 default hr_api.g_varchar2
266: ,p_usage_reason in varchar2 default hr_api.g_varchar2
267: ,p_rud_information_category in varchar2 default hr_api.g_varchar2
268: ,p_rud_information1 in varchar2 default hr_api.g_varchar2
269: ,p_rud_information2 in varchar2 default hr_api.g_varchar2
270: ,p_rud_information3 in varchar2 default hr_api.g_varchar2
271: ,p_rud_information4 in varchar2 default hr_api.g_varchar2
272: ,p_rud_information5 in varchar2 default hr_api.g_varchar2
273: ,p_rud_information6 in varchar2 default hr_api.g_varchar2
274: ,p_rud_information7 in varchar2 default hr_api.g_varchar2
267: ,p_rud_information_category in varchar2 default hr_api.g_varchar2
268: ,p_rud_information1 in varchar2 default hr_api.g_varchar2
269: ,p_rud_information2 in varchar2 default hr_api.g_varchar2
270: ,p_rud_information3 in varchar2 default hr_api.g_varchar2
271: ,p_rud_information4 in varchar2 default hr_api.g_varchar2
272: ,p_rud_information5 in varchar2 default hr_api.g_varchar2
273: ,p_rud_information6 in varchar2 default hr_api.g_varchar2
274: ,p_rud_information7 in varchar2 default hr_api.g_varchar2
275: ,p_rud_information8 in varchar2 default hr_api.g_varchar2
268: ,p_rud_information1 in varchar2 default hr_api.g_varchar2
269: ,p_rud_information2 in varchar2 default hr_api.g_varchar2
270: ,p_rud_information3 in varchar2 default hr_api.g_varchar2
271: ,p_rud_information4 in varchar2 default hr_api.g_varchar2
272: ,p_rud_information5 in varchar2 default hr_api.g_varchar2
273: ,p_rud_information6 in varchar2 default hr_api.g_varchar2
274: ,p_rud_information7 in varchar2 default hr_api.g_varchar2
275: ,p_rud_information8 in varchar2 default hr_api.g_varchar2
276: ,p_rud_information9 in varchar2 default hr_api.g_varchar2
269: ,p_rud_information2 in varchar2 default hr_api.g_varchar2
270: ,p_rud_information3 in varchar2 default hr_api.g_varchar2
271: ,p_rud_information4 in varchar2 default hr_api.g_varchar2
272: ,p_rud_information5 in varchar2 default hr_api.g_varchar2
273: ,p_rud_information6 in varchar2 default hr_api.g_varchar2
274: ,p_rud_information7 in varchar2 default hr_api.g_varchar2
275: ,p_rud_information8 in varchar2 default hr_api.g_varchar2
276: ,p_rud_information9 in varchar2 default hr_api.g_varchar2
277: ,p_rud_information10 in varchar2 default hr_api.g_varchar2
270: ,p_rud_information3 in varchar2 default hr_api.g_varchar2
271: ,p_rud_information4 in varchar2 default hr_api.g_varchar2
272: ,p_rud_information5 in varchar2 default hr_api.g_varchar2
273: ,p_rud_information6 in varchar2 default hr_api.g_varchar2
274: ,p_rud_information7 in varchar2 default hr_api.g_varchar2
275: ,p_rud_information8 in varchar2 default hr_api.g_varchar2
276: ,p_rud_information9 in varchar2 default hr_api.g_varchar2
277: ,p_rud_information10 in varchar2 default hr_api.g_varchar2
278: ,p_rud_information11 in varchar2 default hr_api.g_varchar2
271: ,p_rud_information4 in varchar2 default hr_api.g_varchar2
272: ,p_rud_information5 in varchar2 default hr_api.g_varchar2
273: ,p_rud_information6 in varchar2 default hr_api.g_varchar2
274: ,p_rud_information7 in varchar2 default hr_api.g_varchar2
275: ,p_rud_information8 in varchar2 default hr_api.g_varchar2
276: ,p_rud_information9 in varchar2 default hr_api.g_varchar2
277: ,p_rud_information10 in varchar2 default hr_api.g_varchar2
278: ,p_rud_information11 in varchar2 default hr_api.g_varchar2
279: ,p_rud_information12 in varchar2 default hr_api.g_varchar2
272: ,p_rud_information5 in varchar2 default hr_api.g_varchar2
273: ,p_rud_information6 in varchar2 default hr_api.g_varchar2
274: ,p_rud_information7 in varchar2 default hr_api.g_varchar2
275: ,p_rud_information8 in varchar2 default hr_api.g_varchar2
276: ,p_rud_information9 in varchar2 default hr_api.g_varchar2
277: ,p_rud_information10 in varchar2 default hr_api.g_varchar2
278: ,p_rud_information11 in varchar2 default hr_api.g_varchar2
279: ,p_rud_information12 in varchar2 default hr_api.g_varchar2
280: ,p_rud_information13 in varchar2 default hr_api.g_varchar2
273: ,p_rud_information6 in varchar2 default hr_api.g_varchar2
274: ,p_rud_information7 in varchar2 default hr_api.g_varchar2
275: ,p_rud_information8 in varchar2 default hr_api.g_varchar2
276: ,p_rud_information9 in varchar2 default hr_api.g_varchar2
277: ,p_rud_information10 in varchar2 default hr_api.g_varchar2
278: ,p_rud_information11 in varchar2 default hr_api.g_varchar2
279: ,p_rud_information12 in varchar2 default hr_api.g_varchar2
280: ,p_rud_information13 in varchar2 default hr_api.g_varchar2
281: ,p_rud_information14 in varchar2 default hr_api.g_varchar2
274: ,p_rud_information7 in varchar2 default hr_api.g_varchar2
275: ,p_rud_information8 in varchar2 default hr_api.g_varchar2
276: ,p_rud_information9 in varchar2 default hr_api.g_varchar2
277: ,p_rud_information10 in varchar2 default hr_api.g_varchar2
278: ,p_rud_information11 in varchar2 default hr_api.g_varchar2
279: ,p_rud_information12 in varchar2 default hr_api.g_varchar2
280: ,p_rud_information13 in varchar2 default hr_api.g_varchar2
281: ,p_rud_information14 in varchar2 default hr_api.g_varchar2
282: ,p_rud_information15 in varchar2 default hr_api.g_varchar2
275: ,p_rud_information8 in varchar2 default hr_api.g_varchar2
276: ,p_rud_information9 in varchar2 default hr_api.g_varchar2
277: ,p_rud_information10 in varchar2 default hr_api.g_varchar2
278: ,p_rud_information11 in varchar2 default hr_api.g_varchar2
279: ,p_rud_information12 in varchar2 default hr_api.g_varchar2
280: ,p_rud_information13 in varchar2 default hr_api.g_varchar2
281: ,p_rud_information14 in varchar2 default hr_api.g_varchar2
282: ,p_rud_information15 in varchar2 default hr_api.g_varchar2
283: ,p_rud_information16 in varchar2 default hr_api.g_varchar2
276: ,p_rud_information9 in varchar2 default hr_api.g_varchar2
277: ,p_rud_information10 in varchar2 default hr_api.g_varchar2
278: ,p_rud_information11 in varchar2 default hr_api.g_varchar2
279: ,p_rud_information12 in varchar2 default hr_api.g_varchar2
280: ,p_rud_information13 in varchar2 default hr_api.g_varchar2
281: ,p_rud_information14 in varchar2 default hr_api.g_varchar2
282: ,p_rud_information15 in varchar2 default hr_api.g_varchar2
283: ,p_rud_information16 in varchar2 default hr_api.g_varchar2
284: ,p_rud_information17 in varchar2 default hr_api.g_varchar2
277: ,p_rud_information10 in varchar2 default hr_api.g_varchar2
278: ,p_rud_information11 in varchar2 default hr_api.g_varchar2
279: ,p_rud_information12 in varchar2 default hr_api.g_varchar2
280: ,p_rud_information13 in varchar2 default hr_api.g_varchar2
281: ,p_rud_information14 in varchar2 default hr_api.g_varchar2
282: ,p_rud_information15 in varchar2 default hr_api.g_varchar2
283: ,p_rud_information16 in varchar2 default hr_api.g_varchar2
284: ,p_rud_information17 in varchar2 default hr_api.g_varchar2
285: ,p_rud_information18 in varchar2 default hr_api.g_varchar2
278: ,p_rud_information11 in varchar2 default hr_api.g_varchar2
279: ,p_rud_information12 in varchar2 default hr_api.g_varchar2
280: ,p_rud_information13 in varchar2 default hr_api.g_varchar2
281: ,p_rud_information14 in varchar2 default hr_api.g_varchar2
282: ,p_rud_information15 in varchar2 default hr_api.g_varchar2
283: ,p_rud_information16 in varchar2 default hr_api.g_varchar2
284: ,p_rud_information17 in varchar2 default hr_api.g_varchar2
285: ,p_rud_information18 in varchar2 default hr_api.g_varchar2
286: ,p_rud_information19 in varchar2 default hr_api.g_varchar2
279: ,p_rud_information12 in varchar2 default hr_api.g_varchar2
280: ,p_rud_information13 in varchar2 default hr_api.g_varchar2
281: ,p_rud_information14 in varchar2 default hr_api.g_varchar2
282: ,p_rud_information15 in varchar2 default hr_api.g_varchar2
283: ,p_rud_information16 in varchar2 default hr_api.g_varchar2
284: ,p_rud_information17 in varchar2 default hr_api.g_varchar2
285: ,p_rud_information18 in varchar2 default hr_api.g_varchar2
286: ,p_rud_information19 in varchar2 default hr_api.g_varchar2
287: ,p_rud_information20 in varchar2 default hr_api.g_varchar2
280: ,p_rud_information13 in varchar2 default hr_api.g_varchar2
281: ,p_rud_information14 in varchar2 default hr_api.g_varchar2
282: ,p_rud_information15 in varchar2 default hr_api.g_varchar2
283: ,p_rud_information16 in varchar2 default hr_api.g_varchar2
284: ,p_rud_information17 in varchar2 default hr_api.g_varchar2
285: ,p_rud_information18 in varchar2 default hr_api.g_varchar2
286: ,p_rud_information19 in varchar2 default hr_api.g_varchar2
287: ,p_rud_information20 in varchar2 default hr_api.g_varchar2
288: ,p_offering_id in number default hr_api.g_number
281: ,p_rud_information14 in varchar2 default hr_api.g_varchar2
282: ,p_rud_information15 in varchar2 default hr_api.g_varchar2
283: ,p_rud_information16 in varchar2 default hr_api.g_varchar2
284: ,p_rud_information17 in varchar2 default hr_api.g_varchar2
285: ,p_rud_information18 in varchar2 default hr_api.g_varchar2
286: ,p_rud_information19 in varchar2 default hr_api.g_varchar2
287: ,p_rud_information20 in varchar2 default hr_api.g_varchar2
288: ,p_offering_id in number default hr_api.g_number
289: ) is
282: ,p_rud_information15 in varchar2 default hr_api.g_varchar2
283: ,p_rud_information16 in varchar2 default hr_api.g_varchar2
284: ,p_rud_information17 in varchar2 default hr_api.g_varchar2
285: ,p_rud_information18 in varchar2 default hr_api.g_varchar2
286: ,p_rud_information19 in varchar2 default hr_api.g_varchar2
287: ,p_rud_information20 in varchar2 default hr_api.g_varchar2
288: ,p_offering_id in number default hr_api.g_number
289: ) is
290: --
283: ,p_rud_information16 in varchar2 default hr_api.g_varchar2
284: ,p_rud_information17 in varchar2 default hr_api.g_varchar2
285: ,p_rud_information18 in varchar2 default hr_api.g_varchar2
286: ,p_rud_information19 in varchar2 default hr_api.g_varchar2
287: ,p_rud_information20 in varchar2 default hr_api.g_varchar2
288: ,p_offering_id in number default hr_api.g_number
289: ) is
290: --
291: -- Declare cursors and local variables
284: ,p_rud_information17 in varchar2 default hr_api.g_varchar2
285: ,p_rud_information18 in varchar2 default hr_api.g_varchar2
286: ,p_rud_information19 in varchar2 default hr_api.g_varchar2
287: ,p_rud_information20 in varchar2 default hr_api.g_varchar2
288: ,p_offering_id in number default hr_api.g_number
289: ) is
290: --
291: -- Declare cursors and local variables
292: --
345: ,p_rud_information20 => p_rud_information20
346: ,p_offering_id => p_offering_id
347: );
348: exception
349: when hr_api.cannot_find_prog_unit then
350: hr_api.cannot_find_prog_unit_error
351: (p_module_name => 'UPDATE_RESOURCE'
352: ,p_hook_type => 'BP'
353: );
346: ,p_offering_id => p_offering_id
347: );
348: exception
349: when hr_api.cannot_find_prog_unit then
350: hr_api.cannot_find_prog_unit_error
351: (p_module_name => 'UPDATE_RESOURCE'
352: ,p_hook_type => 'BP'
353: );
354: end;
438: ,p_rud_information20 => p_rud_information20
439: ,p_offering_id => p_offering_id
440: );
441: exception
442: when hr_api.cannot_find_prog_unit then
443: hr_api.cannot_find_prog_unit_error
444: (p_module_name => 'UPDATE_RESOURCE'
445: ,p_hook_type => 'AP'
446: );
439: ,p_offering_id => p_offering_id
440: );
441: exception
442: when hr_api.cannot_find_prog_unit then
443: hr_api.cannot_find_prog_unit_error
444: (p_module_name => 'UPDATE_RESOURCE'
445: ,p_hook_type => 'AP'
446: );
447: end;
449: --
450: -- When in validation only mode raise the Validate_Enabled exception
451: --
452: if p_validate then
453: raise hr_api.validate_enabled;
454: end if;
455: --
456: -- Set all output arguments
457: --
456: -- Set all output arguments
457: --
458: hr_utility.set_location(' Leaving:'||l_proc, 70);
459: exception
460: when hr_api.validate_enabled then
461: --
462: -- As the Validate_Enabled exception has been raised
463: -- we must rollback to the savepoint
464: --
514: (p_resource_usage_id => p_resource_usage_id
515: ,p_object_version_number => p_object_version_number
516: );
517: exception
518: when hr_api.cannot_find_prog_unit then
519: hr_api.cannot_find_prog_unit_error
520: (p_module_name => 'DELETE_RESOURCE'
521: ,p_hook_type => 'BP'
522: );
515: ,p_object_version_number => p_object_version_number
516: );
517: exception
518: when hr_api.cannot_find_prog_unit then
519: hr_api.cannot_find_prog_unit_error
520: (p_module_name => 'DELETE_RESOURCE'
521: ,p_hook_type => 'BP'
522: );
523: end;
541: (p_resource_usage_id => p_resource_usage_id
542: ,p_object_version_number => p_object_version_number
543: );
544: exception
545: when hr_api.cannot_find_prog_unit then
546: hr_api.cannot_find_prog_unit_error
547: (p_module_name => 'DELETE_RESOURCE'
548: ,p_hook_type => 'AP'
549: );
542: ,p_object_version_number => p_object_version_number
543: );
544: exception
545: when hr_api.cannot_find_prog_unit then
546: hr_api.cannot_find_prog_unit_error
547: (p_module_name => 'DELETE_RESOURCE'
548: ,p_hook_type => 'AP'
549: );
550: end;
552: --
553: -- When in validation only mode raise the Validate_Enabled exception
554: --
555: if p_validate then
556: raise hr_api.validate_enabled;
557: end if;
558: --
559: -- Set all output arguments
560: --
560: --
561: --
562: hr_utility.set_location(' Leaving:'||l_proc, 170);
563: exception
564: when hr_api.validate_enabled then
565: --
566: -- As the Validate_Enabled exception has been raised
567: -- we must rollback to the savepoint
568: --