132: ,p_action_information29 => p_action_information29
133: ,p_action_information30 => p_action_information30
134: );
135: exception
136: when hr_api.cannot_find_prog_unit then
137: hr_api.cannot_find_prog_unit_error
138: (
139: p_module_name => 'CREATE_action_information'
140: ,p_hook_type => 'BP'
133: ,p_action_information30 => p_action_information30
134: );
135: exception
136: when hr_api.cannot_find_prog_unit then
137: hr_api.cannot_find_prog_unit_error
138: (
139: p_module_name => 'CREATE_action_information'
140: ,p_hook_type => 'BP'
141: );
239: ,p_action_information29 => p_action_information29
240: ,p_action_information30 => p_action_information30
241: );
242: exception
243: when hr_api.cannot_find_prog_unit then
244: hr_api.cannot_find_prog_unit_error
245: (p_module_name => 'CREATE_action_information'
246: ,p_hook_type => 'AP'
247: );
240: ,p_action_information30 => p_action_information30
241: );
242: exception
243: when hr_api.cannot_find_prog_unit then
244: hr_api.cannot_find_prog_unit_error
245: (p_module_name => 'CREATE_action_information'
246: ,p_hook_type => 'AP'
247: );
248: --
256: --
257: -- When in validation only mode raise the Validate_Enabled exception
258: --
259: if p_validate then
260: raise hr_api.validate_enabled;
261: end if;
262: --
263: -- Set all output arguments
264: --
270: end if;
271: --
272: exception
273: --
274: when hr_api.validate_enabled then
275: --
276: -- As the Validate_Enabled exception has been raised
277: -- we must rollback to the savepoint
278: --
308: procedure update_action_information
309: (p_validate in boolean default false
310: ,p_action_information_id in number
311: ,p_object_version_number in out nocopy number
312: ,p_action_information1 in varchar2 default hr_api.g_varchar2
313: ,p_action_information2 in varchar2 default hr_api.g_varchar2
314: ,p_action_information3 in varchar2 default hr_api.g_varchar2
315: ,p_action_information4 in varchar2 default hr_api.g_varchar2
316: ,p_action_information5 in varchar2 default hr_api.g_varchar2
309: (p_validate in boolean default false
310: ,p_action_information_id in number
311: ,p_object_version_number in out nocopy number
312: ,p_action_information1 in varchar2 default hr_api.g_varchar2
313: ,p_action_information2 in varchar2 default hr_api.g_varchar2
314: ,p_action_information3 in varchar2 default hr_api.g_varchar2
315: ,p_action_information4 in varchar2 default hr_api.g_varchar2
316: ,p_action_information5 in varchar2 default hr_api.g_varchar2
317: ,p_action_information6 in varchar2 default hr_api.g_varchar2
310: ,p_action_information_id in number
311: ,p_object_version_number in out nocopy number
312: ,p_action_information1 in varchar2 default hr_api.g_varchar2
313: ,p_action_information2 in varchar2 default hr_api.g_varchar2
314: ,p_action_information3 in varchar2 default hr_api.g_varchar2
315: ,p_action_information4 in varchar2 default hr_api.g_varchar2
316: ,p_action_information5 in varchar2 default hr_api.g_varchar2
317: ,p_action_information6 in varchar2 default hr_api.g_varchar2
318: ,p_action_information7 in varchar2 default hr_api.g_varchar2
311: ,p_object_version_number in out nocopy number
312: ,p_action_information1 in varchar2 default hr_api.g_varchar2
313: ,p_action_information2 in varchar2 default hr_api.g_varchar2
314: ,p_action_information3 in varchar2 default hr_api.g_varchar2
315: ,p_action_information4 in varchar2 default hr_api.g_varchar2
316: ,p_action_information5 in varchar2 default hr_api.g_varchar2
317: ,p_action_information6 in varchar2 default hr_api.g_varchar2
318: ,p_action_information7 in varchar2 default hr_api.g_varchar2
319: ,p_action_information8 in varchar2 default hr_api.g_varchar2
312: ,p_action_information1 in varchar2 default hr_api.g_varchar2
313: ,p_action_information2 in varchar2 default hr_api.g_varchar2
314: ,p_action_information3 in varchar2 default hr_api.g_varchar2
315: ,p_action_information4 in varchar2 default hr_api.g_varchar2
316: ,p_action_information5 in varchar2 default hr_api.g_varchar2
317: ,p_action_information6 in varchar2 default hr_api.g_varchar2
318: ,p_action_information7 in varchar2 default hr_api.g_varchar2
319: ,p_action_information8 in varchar2 default hr_api.g_varchar2
320: ,p_action_information9 in varchar2 default hr_api.g_varchar2
313: ,p_action_information2 in varchar2 default hr_api.g_varchar2
314: ,p_action_information3 in varchar2 default hr_api.g_varchar2
315: ,p_action_information4 in varchar2 default hr_api.g_varchar2
316: ,p_action_information5 in varchar2 default hr_api.g_varchar2
317: ,p_action_information6 in varchar2 default hr_api.g_varchar2
318: ,p_action_information7 in varchar2 default hr_api.g_varchar2
319: ,p_action_information8 in varchar2 default hr_api.g_varchar2
320: ,p_action_information9 in varchar2 default hr_api.g_varchar2
321: ,p_action_information10 in varchar2 default hr_api.g_varchar2
314: ,p_action_information3 in varchar2 default hr_api.g_varchar2
315: ,p_action_information4 in varchar2 default hr_api.g_varchar2
316: ,p_action_information5 in varchar2 default hr_api.g_varchar2
317: ,p_action_information6 in varchar2 default hr_api.g_varchar2
318: ,p_action_information7 in varchar2 default hr_api.g_varchar2
319: ,p_action_information8 in varchar2 default hr_api.g_varchar2
320: ,p_action_information9 in varchar2 default hr_api.g_varchar2
321: ,p_action_information10 in varchar2 default hr_api.g_varchar2
322: ,p_action_information11 in varchar2 default hr_api.g_varchar2
315: ,p_action_information4 in varchar2 default hr_api.g_varchar2
316: ,p_action_information5 in varchar2 default hr_api.g_varchar2
317: ,p_action_information6 in varchar2 default hr_api.g_varchar2
318: ,p_action_information7 in varchar2 default hr_api.g_varchar2
319: ,p_action_information8 in varchar2 default hr_api.g_varchar2
320: ,p_action_information9 in varchar2 default hr_api.g_varchar2
321: ,p_action_information10 in varchar2 default hr_api.g_varchar2
322: ,p_action_information11 in varchar2 default hr_api.g_varchar2
323: ,p_action_information12 in varchar2 default hr_api.g_varchar2
316: ,p_action_information5 in varchar2 default hr_api.g_varchar2
317: ,p_action_information6 in varchar2 default hr_api.g_varchar2
318: ,p_action_information7 in varchar2 default hr_api.g_varchar2
319: ,p_action_information8 in varchar2 default hr_api.g_varchar2
320: ,p_action_information9 in varchar2 default hr_api.g_varchar2
321: ,p_action_information10 in varchar2 default hr_api.g_varchar2
322: ,p_action_information11 in varchar2 default hr_api.g_varchar2
323: ,p_action_information12 in varchar2 default hr_api.g_varchar2
324: ,p_action_information13 in varchar2 default hr_api.g_varchar2
317: ,p_action_information6 in varchar2 default hr_api.g_varchar2
318: ,p_action_information7 in varchar2 default hr_api.g_varchar2
319: ,p_action_information8 in varchar2 default hr_api.g_varchar2
320: ,p_action_information9 in varchar2 default hr_api.g_varchar2
321: ,p_action_information10 in varchar2 default hr_api.g_varchar2
322: ,p_action_information11 in varchar2 default hr_api.g_varchar2
323: ,p_action_information12 in varchar2 default hr_api.g_varchar2
324: ,p_action_information13 in varchar2 default hr_api.g_varchar2
325: ,p_action_information14 in varchar2 default hr_api.g_varchar2
318: ,p_action_information7 in varchar2 default hr_api.g_varchar2
319: ,p_action_information8 in varchar2 default hr_api.g_varchar2
320: ,p_action_information9 in varchar2 default hr_api.g_varchar2
321: ,p_action_information10 in varchar2 default hr_api.g_varchar2
322: ,p_action_information11 in varchar2 default hr_api.g_varchar2
323: ,p_action_information12 in varchar2 default hr_api.g_varchar2
324: ,p_action_information13 in varchar2 default hr_api.g_varchar2
325: ,p_action_information14 in varchar2 default hr_api.g_varchar2
326: ,p_action_information15 in varchar2 default hr_api.g_varchar2
319: ,p_action_information8 in varchar2 default hr_api.g_varchar2
320: ,p_action_information9 in varchar2 default hr_api.g_varchar2
321: ,p_action_information10 in varchar2 default hr_api.g_varchar2
322: ,p_action_information11 in varchar2 default hr_api.g_varchar2
323: ,p_action_information12 in varchar2 default hr_api.g_varchar2
324: ,p_action_information13 in varchar2 default hr_api.g_varchar2
325: ,p_action_information14 in varchar2 default hr_api.g_varchar2
326: ,p_action_information15 in varchar2 default hr_api.g_varchar2
327: ,p_action_information16 in varchar2 default hr_api.g_varchar2
320: ,p_action_information9 in varchar2 default hr_api.g_varchar2
321: ,p_action_information10 in varchar2 default hr_api.g_varchar2
322: ,p_action_information11 in varchar2 default hr_api.g_varchar2
323: ,p_action_information12 in varchar2 default hr_api.g_varchar2
324: ,p_action_information13 in varchar2 default hr_api.g_varchar2
325: ,p_action_information14 in varchar2 default hr_api.g_varchar2
326: ,p_action_information15 in varchar2 default hr_api.g_varchar2
327: ,p_action_information16 in varchar2 default hr_api.g_varchar2
328: ,p_action_information17 in varchar2 default hr_api.g_varchar2
321: ,p_action_information10 in varchar2 default hr_api.g_varchar2
322: ,p_action_information11 in varchar2 default hr_api.g_varchar2
323: ,p_action_information12 in varchar2 default hr_api.g_varchar2
324: ,p_action_information13 in varchar2 default hr_api.g_varchar2
325: ,p_action_information14 in varchar2 default hr_api.g_varchar2
326: ,p_action_information15 in varchar2 default hr_api.g_varchar2
327: ,p_action_information16 in varchar2 default hr_api.g_varchar2
328: ,p_action_information17 in varchar2 default hr_api.g_varchar2
329: ,p_action_information18 in varchar2 default hr_api.g_varchar2
322: ,p_action_information11 in varchar2 default hr_api.g_varchar2
323: ,p_action_information12 in varchar2 default hr_api.g_varchar2
324: ,p_action_information13 in varchar2 default hr_api.g_varchar2
325: ,p_action_information14 in varchar2 default hr_api.g_varchar2
326: ,p_action_information15 in varchar2 default hr_api.g_varchar2
327: ,p_action_information16 in varchar2 default hr_api.g_varchar2
328: ,p_action_information17 in varchar2 default hr_api.g_varchar2
329: ,p_action_information18 in varchar2 default hr_api.g_varchar2
330: ,p_action_information19 in varchar2 default hr_api.g_varchar2
323: ,p_action_information12 in varchar2 default hr_api.g_varchar2
324: ,p_action_information13 in varchar2 default hr_api.g_varchar2
325: ,p_action_information14 in varchar2 default hr_api.g_varchar2
326: ,p_action_information15 in varchar2 default hr_api.g_varchar2
327: ,p_action_information16 in varchar2 default hr_api.g_varchar2
328: ,p_action_information17 in varchar2 default hr_api.g_varchar2
329: ,p_action_information18 in varchar2 default hr_api.g_varchar2
330: ,p_action_information19 in varchar2 default hr_api.g_varchar2
331: ,p_action_information20 in varchar2 default hr_api.g_varchar2
324: ,p_action_information13 in varchar2 default hr_api.g_varchar2
325: ,p_action_information14 in varchar2 default hr_api.g_varchar2
326: ,p_action_information15 in varchar2 default hr_api.g_varchar2
327: ,p_action_information16 in varchar2 default hr_api.g_varchar2
328: ,p_action_information17 in varchar2 default hr_api.g_varchar2
329: ,p_action_information18 in varchar2 default hr_api.g_varchar2
330: ,p_action_information19 in varchar2 default hr_api.g_varchar2
331: ,p_action_information20 in varchar2 default hr_api.g_varchar2
332: ,p_action_information21 in varchar2 default hr_api.g_varchar2
325: ,p_action_information14 in varchar2 default hr_api.g_varchar2
326: ,p_action_information15 in varchar2 default hr_api.g_varchar2
327: ,p_action_information16 in varchar2 default hr_api.g_varchar2
328: ,p_action_information17 in varchar2 default hr_api.g_varchar2
329: ,p_action_information18 in varchar2 default hr_api.g_varchar2
330: ,p_action_information19 in varchar2 default hr_api.g_varchar2
331: ,p_action_information20 in varchar2 default hr_api.g_varchar2
332: ,p_action_information21 in varchar2 default hr_api.g_varchar2
333: ,p_action_information22 in varchar2 default hr_api.g_varchar2
326: ,p_action_information15 in varchar2 default hr_api.g_varchar2
327: ,p_action_information16 in varchar2 default hr_api.g_varchar2
328: ,p_action_information17 in varchar2 default hr_api.g_varchar2
329: ,p_action_information18 in varchar2 default hr_api.g_varchar2
330: ,p_action_information19 in varchar2 default hr_api.g_varchar2
331: ,p_action_information20 in varchar2 default hr_api.g_varchar2
332: ,p_action_information21 in varchar2 default hr_api.g_varchar2
333: ,p_action_information22 in varchar2 default hr_api.g_varchar2
334: ,p_action_information23 in varchar2 default hr_api.g_varchar2
327: ,p_action_information16 in varchar2 default hr_api.g_varchar2
328: ,p_action_information17 in varchar2 default hr_api.g_varchar2
329: ,p_action_information18 in varchar2 default hr_api.g_varchar2
330: ,p_action_information19 in varchar2 default hr_api.g_varchar2
331: ,p_action_information20 in varchar2 default hr_api.g_varchar2
332: ,p_action_information21 in varchar2 default hr_api.g_varchar2
333: ,p_action_information22 in varchar2 default hr_api.g_varchar2
334: ,p_action_information23 in varchar2 default hr_api.g_varchar2
335: ,p_action_information24 in varchar2 default hr_api.g_varchar2
328: ,p_action_information17 in varchar2 default hr_api.g_varchar2
329: ,p_action_information18 in varchar2 default hr_api.g_varchar2
330: ,p_action_information19 in varchar2 default hr_api.g_varchar2
331: ,p_action_information20 in varchar2 default hr_api.g_varchar2
332: ,p_action_information21 in varchar2 default hr_api.g_varchar2
333: ,p_action_information22 in varchar2 default hr_api.g_varchar2
334: ,p_action_information23 in varchar2 default hr_api.g_varchar2
335: ,p_action_information24 in varchar2 default hr_api.g_varchar2
336: ,p_action_information25 in varchar2 default hr_api.g_varchar2
329: ,p_action_information18 in varchar2 default hr_api.g_varchar2
330: ,p_action_information19 in varchar2 default hr_api.g_varchar2
331: ,p_action_information20 in varchar2 default hr_api.g_varchar2
332: ,p_action_information21 in varchar2 default hr_api.g_varchar2
333: ,p_action_information22 in varchar2 default hr_api.g_varchar2
334: ,p_action_information23 in varchar2 default hr_api.g_varchar2
335: ,p_action_information24 in varchar2 default hr_api.g_varchar2
336: ,p_action_information25 in varchar2 default hr_api.g_varchar2
337: ,p_action_information26 in varchar2 default hr_api.g_varchar2
330: ,p_action_information19 in varchar2 default hr_api.g_varchar2
331: ,p_action_information20 in varchar2 default hr_api.g_varchar2
332: ,p_action_information21 in varchar2 default hr_api.g_varchar2
333: ,p_action_information22 in varchar2 default hr_api.g_varchar2
334: ,p_action_information23 in varchar2 default hr_api.g_varchar2
335: ,p_action_information24 in varchar2 default hr_api.g_varchar2
336: ,p_action_information25 in varchar2 default hr_api.g_varchar2
337: ,p_action_information26 in varchar2 default hr_api.g_varchar2
338: ,p_action_information27 in varchar2 default hr_api.g_varchar2
331: ,p_action_information20 in varchar2 default hr_api.g_varchar2
332: ,p_action_information21 in varchar2 default hr_api.g_varchar2
333: ,p_action_information22 in varchar2 default hr_api.g_varchar2
334: ,p_action_information23 in varchar2 default hr_api.g_varchar2
335: ,p_action_information24 in varchar2 default hr_api.g_varchar2
336: ,p_action_information25 in varchar2 default hr_api.g_varchar2
337: ,p_action_information26 in varchar2 default hr_api.g_varchar2
338: ,p_action_information27 in varchar2 default hr_api.g_varchar2
339: ,p_action_information28 in varchar2 default hr_api.g_varchar2
332: ,p_action_information21 in varchar2 default hr_api.g_varchar2
333: ,p_action_information22 in varchar2 default hr_api.g_varchar2
334: ,p_action_information23 in varchar2 default hr_api.g_varchar2
335: ,p_action_information24 in varchar2 default hr_api.g_varchar2
336: ,p_action_information25 in varchar2 default hr_api.g_varchar2
337: ,p_action_information26 in varchar2 default hr_api.g_varchar2
338: ,p_action_information27 in varchar2 default hr_api.g_varchar2
339: ,p_action_information28 in varchar2 default hr_api.g_varchar2
340: ,p_action_information29 in varchar2 default hr_api.g_varchar2
333: ,p_action_information22 in varchar2 default hr_api.g_varchar2
334: ,p_action_information23 in varchar2 default hr_api.g_varchar2
335: ,p_action_information24 in varchar2 default hr_api.g_varchar2
336: ,p_action_information25 in varchar2 default hr_api.g_varchar2
337: ,p_action_information26 in varchar2 default hr_api.g_varchar2
338: ,p_action_information27 in varchar2 default hr_api.g_varchar2
339: ,p_action_information28 in varchar2 default hr_api.g_varchar2
340: ,p_action_information29 in varchar2 default hr_api.g_varchar2
341: ,p_action_information30 in varchar2 default hr_api.g_varchar2
334: ,p_action_information23 in varchar2 default hr_api.g_varchar2
335: ,p_action_information24 in varchar2 default hr_api.g_varchar2
336: ,p_action_information25 in varchar2 default hr_api.g_varchar2
337: ,p_action_information26 in varchar2 default hr_api.g_varchar2
338: ,p_action_information27 in varchar2 default hr_api.g_varchar2
339: ,p_action_information28 in varchar2 default hr_api.g_varchar2
340: ,p_action_information29 in varchar2 default hr_api.g_varchar2
341: ,p_action_information30 in varchar2 default hr_api.g_varchar2
342: ) is
335: ,p_action_information24 in varchar2 default hr_api.g_varchar2
336: ,p_action_information25 in varchar2 default hr_api.g_varchar2
337: ,p_action_information26 in varchar2 default hr_api.g_varchar2
338: ,p_action_information27 in varchar2 default hr_api.g_varchar2
339: ,p_action_information28 in varchar2 default hr_api.g_varchar2
340: ,p_action_information29 in varchar2 default hr_api.g_varchar2
341: ,p_action_information30 in varchar2 default hr_api.g_varchar2
342: ) is
343: --
336: ,p_action_information25 in varchar2 default hr_api.g_varchar2
337: ,p_action_information26 in varchar2 default hr_api.g_varchar2
338: ,p_action_information27 in varchar2 default hr_api.g_varchar2
339: ,p_action_information28 in varchar2 default hr_api.g_varchar2
340: ,p_action_information29 in varchar2 default hr_api.g_varchar2
341: ,p_action_information30 in varchar2 default hr_api.g_varchar2
342: ) is
343: --
344: -- Declare cursors and local variables
337: ,p_action_information26 in varchar2 default hr_api.g_varchar2
338: ,p_action_information27 in varchar2 default hr_api.g_varchar2
339: ,p_action_information28 in varchar2 default hr_api.g_varchar2
340: ,p_action_information29 in varchar2 default hr_api.g_varchar2
341: ,p_action_information30 in varchar2 default hr_api.g_varchar2
342: ) is
343: --
344: -- Declare cursors and local variables
345: --
405: ,p_action_information29 => p_action_information29
406: ,p_action_information30 => p_action_information30
407: );
408: exception
409: when hr_api.cannot_find_prog_unit then
410: hr_api.cannot_find_prog_unit_error
411: (p_module_name => 'UPDATE_action_information'
412: ,p_hook_type => 'BP'
413: );
406: ,p_action_information30 => p_action_information30
407: );
408: exception
409: when hr_api.cannot_find_prog_unit then
410: hr_api.cannot_find_prog_unit_error
411: (p_module_name => 'UPDATE_action_information'
412: ,p_hook_type => 'BP'
413: );
414: --
491: ,p_action_information29 => p_action_information29
492: ,p_action_information30 => p_action_information30
493: );
494: exception
495: when hr_api.cannot_find_prog_unit then
496: hr_api.cannot_find_prog_unit_error
497: (p_module_name => 'UPDATE_action_information'
498: ,p_hook_type => 'AP'
499: );
492: ,p_action_information30 => p_action_information30
493: );
494: exception
495: when hr_api.cannot_find_prog_unit then
496: hr_api.cannot_find_prog_unit_error
497: (p_module_name => 'UPDATE_action_information'
498: ,p_hook_type => 'AP'
499: );
500: --
508: --
509: -- When in validation only mode raise the Validate_Enabled exception
510: --
511: if p_validate then
512: raise hr_api.validate_enabled;
513: end if;
514: --
515: -- Set all output arguments
516: --
521: end if;
522: --
523: exception
524: --
525: when hr_api.validate_enabled then
526: --
527: -- As the Validate_Enabled exception has been raised
528: -- we must rollback to the savepoint
529: --
591: p_action_information_id => p_action_information_id
592: ,p_object_version_number => p_object_version_number
593: );
594: exception
595: when hr_api.cannot_find_prog_unit then
596: hr_api.cannot_find_prog_unit_error
597: (p_module_name => 'DELETE_action_information'
598: ,p_hook_type => 'BP'
599: );
592: ,p_object_version_number => p_object_version_number
593: );
594: exception
595: when hr_api.cannot_find_prog_unit then
596: hr_api.cannot_find_prog_unit_error
597: (p_module_name => 'DELETE_action_information'
598: ,p_hook_type => 'BP'
599: );
600: --
617: p_action_information_id => p_action_information_id
618: ,p_object_version_number => l_object_version_number
619: );
620: exception
621: when hr_api.cannot_find_prog_unit then
622: hr_api.cannot_find_prog_unit_error
623: (p_module_name => 'DELETE_action_information'
624: ,p_hook_type => 'AP'
625: );
618: ,p_object_version_number => l_object_version_number
619: );
620: exception
621: when hr_api.cannot_find_prog_unit then
622: hr_api.cannot_find_prog_unit_error
623: (p_module_name => 'DELETE_action_information'
624: ,p_hook_type => 'AP'
625: );
626: --
634: --
635: -- When in validation only mode raise the Validate_Enabled exception
636: --
637: if p_validate then
638: raise hr_api.validate_enabled;
639: end if;
640: --
641: if g_debug then
642: hr_utility.set_location(' Leaving:'||l_proc, 70);
643: end if;
644: --
645: exception
646: --
647: when hr_api.validate_enabled then
648: --
649: -- As the Validate_Enabled exception has been raised
650: -- we must rollback to the savepoint
651: --