185: ,p_attribute28 => p_attribute28
186: ,p_attribute29 => p_attribute29
187: ,p_attribute30 => p_attribute30);
188: exception
189: when hr_api.cannot_find_prog_unit then
190: hr_api.cannot_find_prog_unit_error
191: (p_module_name => 'create_link'
192: ,p_hook_type => 'BP'
193: );
186: ,p_attribute29 => p_attribute29
187: ,p_attribute30 => p_attribute30);
188: exception
189: when hr_api.cannot_find_prog_unit then
190: hr_api.cannot_find_prog_unit_error
191: (p_module_name => 'create_link'
192: ,p_hook_type => 'BP'
193: );
194: end;
339: ,p_attribute30 => p_attribute30
340: ,p_organization_link_id => l_organization_link_id
341: ,p_object_version_number => l_object_version_number);
342: exception
343: when hr_api.cannot_find_prog_unit then
344: hr_api.cannot_find_prog_unit_error
345: (p_module_name => 'create_link'
346: ,p_hook_type => 'AP'
347: );
340: ,p_organization_link_id => l_organization_link_id
341: ,p_object_version_number => l_object_version_number);
342: exception
343: when hr_api.cannot_find_prog_unit then
344: hr_api.cannot_find_prog_unit_error
345: (p_module_name => 'create_link'
346: ,p_hook_type => 'AP'
347: );
348: end;
349: --
350: -- When in validation only mode raise the Validate_Enabled exception
351: --
352: if p_validate then
353: raise hr_api.validate_enabled;
354: end if;
355: --
356: -- Set all output arguments
357: --
359: p_object_version_number := l_object_version_number;
360: --
361: hr_utility.set_location(' Leaving:'||l_proc, 70);
362: exception
363: when hr_api.validate_enabled then
364: --
365: -- As the Validate_Enabled exception has been raised
366: -- we must rollback to the savepoint
367: --
394: procedure update_link
395: (p_validate in boolean default false
396: ,p_effective_date in date
397: ,p_organization_link_id in number
398: ,p_org_link_information_categor in varchar2 default hr_api.g_varchar2
399: ,p_org_link_information1 in varchar2 default hr_api.g_varchar2
400: ,p_org_link_information2 in varchar2 default hr_api.g_varchar2
401: ,p_org_link_information3 in varchar2 default hr_api.g_varchar2
402: ,p_org_link_information4 in varchar2 default hr_api.g_varchar2
395: (p_validate in boolean default false
396: ,p_effective_date in date
397: ,p_organization_link_id in number
398: ,p_org_link_information_categor in varchar2 default hr_api.g_varchar2
399: ,p_org_link_information1 in varchar2 default hr_api.g_varchar2
400: ,p_org_link_information2 in varchar2 default hr_api.g_varchar2
401: ,p_org_link_information3 in varchar2 default hr_api.g_varchar2
402: ,p_org_link_information4 in varchar2 default hr_api.g_varchar2
403: ,p_org_link_information5 in varchar2 default hr_api.g_varchar2
396: ,p_effective_date in date
397: ,p_organization_link_id in number
398: ,p_org_link_information_categor in varchar2 default hr_api.g_varchar2
399: ,p_org_link_information1 in varchar2 default hr_api.g_varchar2
400: ,p_org_link_information2 in varchar2 default hr_api.g_varchar2
401: ,p_org_link_information3 in varchar2 default hr_api.g_varchar2
402: ,p_org_link_information4 in varchar2 default hr_api.g_varchar2
403: ,p_org_link_information5 in varchar2 default hr_api.g_varchar2
404: ,p_org_link_information6 in varchar2 default hr_api.g_varchar2
397: ,p_organization_link_id in number
398: ,p_org_link_information_categor in varchar2 default hr_api.g_varchar2
399: ,p_org_link_information1 in varchar2 default hr_api.g_varchar2
400: ,p_org_link_information2 in varchar2 default hr_api.g_varchar2
401: ,p_org_link_information3 in varchar2 default hr_api.g_varchar2
402: ,p_org_link_information4 in varchar2 default hr_api.g_varchar2
403: ,p_org_link_information5 in varchar2 default hr_api.g_varchar2
404: ,p_org_link_information6 in varchar2 default hr_api.g_varchar2
405: ,p_org_link_information7 in varchar2 default hr_api.g_varchar2
398: ,p_org_link_information_categor in varchar2 default hr_api.g_varchar2
399: ,p_org_link_information1 in varchar2 default hr_api.g_varchar2
400: ,p_org_link_information2 in varchar2 default hr_api.g_varchar2
401: ,p_org_link_information3 in varchar2 default hr_api.g_varchar2
402: ,p_org_link_information4 in varchar2 default hr_api.g_varchar2
403: ,p_org_link_information5 in varchar2 default hr_api.g_varchar2
404: ,p_org_link_information6 in varchar2 default hr_api.g_varchar2
405: ,p_org_link_information7 in varchar2 default hr_api.g_varchar2
406: ,p_org_link_information8 in varchar2 default hr_api.g_varchar2
399: ,p_org_link_information1 in varchar2 default hr_api.g_varchar2
400: ,p_org_link_information2 in varchar2 default hr_api.g_varchar2
401: ,p_org_link_information3 in varchar2 default hr_api.g_varchar2
402: ,p_org_link_information4 in varchar2 default hr_api.g_varchar2
403: ,p_org_link_information5 in varchar2 default hr_api.g_varchar2
404: ,p_org_link_information6 in varchar2 default hr_api.g_varchar2
405: ,p_org_link_information7 in varchar2 default hr_api.g_varchar2
406: ,p_org_link_information8 in varchar2 default hr_api.g_varchar2
407: ,p_org_link_information9 in varchar2 default hr_api.g_varchar2
400: ,p_org_link_information2 in varchar2 default hr_api.g_varchar2
401: ,p_org_link_information3 in varchar2 default hr_api.g_varchar2
402: ,p_org_link_information4 in varchar2 default hr_api.g_varchar2
403: ,p_org_link_information5 in varchar2 default hr_api.g_varchar2
404: ,p_org_link_information6 in varchar2 default hr_api.g_varchar2
405: ,p_org_link_information7 in varchar2 default hr_api.g_varchar2
406: ,p_org_link_information8 in varchar2 default hr_api.g_varchar2
407: ,p_org_link_information9 in varchar2 default hr_api.g_varchar2
408: ,p_org_link_information10 in varchar2 default hr_api.g_varchar2
401: ,p_org_link_information3 in varchar2 default hr_api.g_varchar2
402: ,p_org_link_information4 in varchar2 default hr_api.g_varchar2
403: ,p_org_link_information5 in varchar2 default hr_api.g_varchar2
404: ,p_org_link_information6 in varchar2 default hr_api.g_varchar2
405: ,p_org_link_information7 in varchar2 default hr_api.g_varchar2
406: ,p_org_link_information8 in varchar2 default hr_api.g_varchar2
407: ,p_org_link_information9 in varchar2 default hr_api.g_varchar2
408: ,p_org_link_information10 in varchar2 default hr_api.g_varchar2
409: ,p_org_link_information11 in varchar2 default hr_api.g_varchar2
402: ,p_org_link_information4 in varchar2 default hr_api.g_varchar2
403: ,p_org_link_information5 in varchar2 default hr_api.g_varchar2
404: ,p_org_link_information6 in varchar2 default hr_api.g_varchar2
405: ,p_org_link_information7 in varchar2 default hr_api.g_varchar2
406: ,p_org_link_information8 in varchar2 default hr_api.g_varchar2
407: ,p_org_link_information9 in varchar2 default hr_api.g_varchar2
408: ,p_org_link_information10 in varchar2 default hr_api.g_varchar2
409: ,p_org_link_information11 in varchar2 default hr_api.g_varchar2
410: ,p_org_link_information12 in varchar2 default hr_api.g_varchar2
403: ,p_org_link_information5 in varchar2 default hr_api.g_varchar2
404: ,p_org_link_information6 in varchar2 default hr_api.g_varchar2
405: ,p_org_link_information7 in varchar2 default hr_api.g_varchar2
406: ,p_org_link_information8 in varchar2 default hr_api.g_varchar2
407: ,p_org_link_information9 in varchar2 default hr_api.g_varchar2
408: ,p_org_link_information10 in varchar2 default hr_api.g_varchar2
409: ,p_org_link_information11 in varchar2 default hr_api.g_varchar2
410: ,p_org_link_information12 in varchar2 default hr_api.g_varchar2
411: ,p_org_link_information13 in varchar2 default hr_api.g_varchar2
404: ,p_org_link_information6 in varchar2 default hr_api.g_varchar2
405: ,p_org_link_information7 in varchar2 default hr_api.g_varchar2
406: ,p_org_link_information8 in varchar2 default hr_api.g_varchar2
407: ,p_org_link_information9 in varchar2 default hr_api.g_varchar2
408: ,p_org_link_information10 in varchar2 default hr_api.g_varchar2
409: ,p_org_link_information11 in varchar2 default hr_api.g_varchar2
410: ,p_org_link_information12 in varchar2 default hr_api.g_varchar2
411: ,p_org_link_information13 in varchar2 default hr_api.g_varchar2
412: ,p_org_link_information14 in varchar2 default hr_api.g_varchar2
405: ,p_org_link_information7 in varchar2 default hr_api.g_varchar2
406: ,p_org_link_information8 in varchar2 default hr_api.g_varchar2
407: ,p_org_link_information9 in varchar2 default hr_api.g_varchar2
408: ,p_org_link_information10 in varchar2 default hr_api.g_varchar2
409: ,p_org_link_information11 in varchar2 default hr_api.g_varchar2
410: ,p_org_link_information12 in varchar2 default hr_api.g_varchar2
411: ,p_org_link_information13 in varchar2 default hr_api.g_varchar2
412: ,p_org_link_information14 in varchar2 default hr_api.g_varchar2
413: ,p_org_link_information15 in varchar2 default hr_api.g_varchar2
406: ,p_org_link_information8 in varchar2 default hr_api.g_varchar2
407: ,p_org_link_information9 in varchar2 default hr_api.g_varchar2
408: ,p_org_link_information10 in varchar2 default hr_api.g_varchar2
409: ,p_org_link_information11 in varchar2 default hr_api.g_varchar2
410: ,p_org_link_information12 in varchar2 default hr_api.g_varchar2
411: ,p_org_link_information13 in varchar2 default hr_api.g_varchar2
412: ,p_org_link_information14 in varchar2 default hr_api.g_varchar2
413: ,p_org_link_information15 in varchar2 default hr_api.g_varchar2
414: ,p_org_link_information16 in varchar2 default hr_api.g_varchar2
407: ,p_org_link_information9 in varchar2 default hr_api.g_varchar2
408: ,p_org_link_information10 in varchar2 default hr_api.g_varchar2
409: ,p_org_link_information11 in varchar2 default hr_api.g_varchar2
410: ,p_org_link_information12 in varchar2 default hr_api.g_varchar2
411: ,p_org_link_information13 in varchar2 default hr_api.g_varchar2
412: ,p_org_link_information14 in varchar2 default hr_api.g_varchar2
413: ,p_org_link_information15 in varchar2 default hr_api.g_varchar2
414: ,p_org_link_information16 in varchar2 default hr_api.g_varchar2
415: ,p_org_link_information17 in varchar2 default hr_api.g_varchar2
408: ,p_org_link_information10 in varchar2 default hr_api.g_varchar2
409: ,p_org_link_information11 in varchar2 default hr_api.g_varchar2
410: ,p_org_link_information12 in varchar2 default hr_api.g_varchar2
411: ,p_org_link_information13 in varchar2 default hr_api.g_varchar2
412: ,p_org_link_information14 in varchar2 default hr_api.g_varchar2
413: ,p_org_link_information15 in varchar2 default hr_api.g_varchar2
414: ,p_org_link_information16 in varchar2 default hr_api.g_varchar2
415: ,p_org_link_information17 in varchar2 default hr_api.g_varchar2
416: ,p_org_link_information18 in varchar2 default hr_api.g_varchar2
409: ,p_org_link_information11 in varchar2 default hr_api.g_varchar2
410: ,p_org_link_information12 in varchar2 default hr_api.g_varchar2
411: ,p_org_link_information13 in varchar2 default hr_api.g_varchar2
412: ,p_org_link_information14 in varchar2 default hr_api.g_varchar2
413: ,p_org_link_information15 in varchar2 default hr_api.g_varchar2
414: ,p_org_link_information16 in varchar2 default hr_api.g_varchar2
415: ,p_org_link_information17 in varchar2 default hr_api.g_varchar2
416: ,p_org_link_information18 in varchar2 default hr_api.g_varchar2
417: ,p_org_link_information19 in varchar2 default hr_api.g_varchar2
410: ,p_org_link_information12 in varchar2 default hr_api.g_varchar2
411: ,p_org_link_information13 in varchar2 default hr_api.g_varchar2
412: ,p_org_link_information14 in varchar2 default hr_api.g_varchar2
413: ,p_org_link_information15 in varchar2 default hr_api.g_varchar2
414: ,p_org_link_information16 in varchar2 default hr_api.g_varchar2
415: ,p_org_link_information17 in varchar2 default hr_api.g_varchar2
416: ,p_org_link_information18 in varchar2 default hr_api.g_varchar2
417: ,p_org_link_information19 in varchar2 default hr_api.g_varchar2
418: ,p_org_link_information20 in varchar2 default hr_api.g_varchar2
411: ,p_org_link_information13 in varchar2 default hr_api.g_varchar2
412: ,p_org_link_information14 in varchar2 default hr_api.g_varchar2
413: ,p_org_link_information15 in varchar2 default hr_api.g_varchar2
414: ,p_org_link_information16 in varchar2 default hr_api.g_varchar2
415: ,p_org_link_information17 in varchar2 default hr_api.g_varchar2
416: ,p_org_link_information18 in varchar2 default hr_api.g_varchar2
417: ,p_org_link_information19 in varchar2 default hr_api.g_varchar2
418: ,p_org_link_information20 in varchar2 default hr_api.g_varchar2
419: ,p_org_link_information21 in varchar2 default hr_api.g_varchar2
412: ,p_org_link_information14 in varchar2 default hr_api.g_varchar2
413: ,p_org_link_information15 in varchar2 default hr_api.g_varchar2
414: ,p_org_link_information16 in varchar2 default hr_api.g_varchar2
415: ,p_org_link_information17 in varchar2 default hr_api.g_varchar2
416: ,p_org_link_information18 in varchar2 default hr_api.g_varchar2
417: ,p_org_link_information19 in varchar2 default hr_api.g_varchar2
418: ,p_org_link_information20 in varchar2 default hr_api.g_varchar2
419: ,p_org_link_information21 in varchar2 default hr_api.g_varchar2
420: ,p_org_link_information22 in varchar2 default hr_api.g_varchar2
413: ,p_org_link_information15 in varchar2 default hr_api.g_varchar2
414: ,p_org_link_information16 in varchar2 default hr_api.g_varchar2
415: ,p_org_link_information17 in varchar2 default hr_api.g_varchar2
416: ,p_org_link_information18 in varchar2 default hr_api.g_varchar2
417: ,p_org_link_information19 in varchar2 default hr_api.g_varchar2
418: ,p_org_link_information20 in varchar2 default hr_api.g_varchar2
419: ,p_org_link_information21 in varchar2 default hr_api.g_varchar2
420: ,p_org_link_information22 in varchar2 default hr_api.g_varchar2
421: ,p_org_link_information23 in varchar2 default hr_api.g_varchar2
414: ,p_org_link_information16 in varchar2 default hr_api.g_varchar2
415: ,p_org_link_information17 in varchar2 default hr_api.g_varchar2
416: ,p_org_link_information18 in varchar2 default hr_api.g_varchar2
417: ,p_org_link_information19 in varchar2 default hr_api.g_varchar2
418: ,p_org_link_information20 in varchar2 default hr_api.g_varchar2
419: ,p_org_link_information21 in varchar2 default hr_api.g_varchar2
420: ,p_org_link_information22 in varchar2 default hr_api.g_varchar2
421: ,p_org_link_information23 in varchar2 default hr_api.g_varchar2
422: ,p_org_link_information24 in varchar2 default hr_api.g_varchar2
415: ,p_org_link_information17 in varchar2 default hr_api.g_varchar2
416: ,p_org_link_information18 in varchar2 default hr_api.g_varchar2
417: ,p_org_link_information19 in varchar2 default hr_api.g_varchar2
418: ,p_org_link_information20 in varchar2 default hr_api.g_varchar2
419: ,p_org_link_information21 in varchar2 default hr_api.g_varchar2
420: ,p_org_link_information22 in varchar2 default hr_api.g_varchar2
421: ,p_org_link_information23 in varchar2 default hr_api.g_varchar2
422: ,p_org_link_information24 in varchar2 default hr_api.g_varchar2
423: ,p_org_link_information25 in varchar2 default hr_api.g_varchar2
416: ,p_org_link_information18 in varchar2 default hr_api.g_varchar2
417: ,p_org_link_information19 in varchar2 default hr_api.g_varchar2
418: ,p_org_link_information20 in varchar2 default hr_api.g_varchar2
419: ,p_org_link_information21 in varchar2 default hr_api.g_varchar2
420: ,p_org_link_information22 in varchar2 default hr_api.g_varchar2
421: ,p_org_link_information23 in varchar2 default hr_api.g_varchar2
422: ,p_org_link_information24 in varchar2 default hr_api.g_varchar2
423: ,p_org_link_information25 in varchar2 default hr_api.g_varchar2
424: ,p_org_link_information26 in varchar2 default hr_api.g_varchar2
417: ,p_org_link_information19 in varchar2 default hr_api.g_varchar2
418: ,p_org_link_information20 in varchar2 default hr_api.g_varchar2
419: ,p_org_link_information21 in varchar2 default hr_api.g_varchar2
420: ,p_org_link_information22 in varchar2 default hr_api.g_varchar2
421: ,p_org_link_information23 in varchar2 default hr_api.g_varchar2
422: ,p_org_link_information24 in varchar2 default hr_api.g_varchar2
423: ,p_org_link_information25 in varchar2 default hr_api.g_varchar2
424: ,p_org_link_information26 in varchar2 default hr_api.g_varchar2
425: ,p_org_link_information27 in varchar2 default hr_api.g_varchar2
418: ,p_org_link_information20 in varchar2 default hr_api.g_varchar2
419: ,p_org_link_information21 in varchar2 default hr_api.g_varchar2
420: ,p_org_link_information22 in varchar2 default hr_api.g_varchar2
421: ,p_org_link_information23 in varchar2 default hr_api.g_varchar2
422: ,p_org_link_information24 in varchar2 default hr_api.g_varchar2
423: ,p_org_link_information25 in varchar2 default hr_api.g_varchar2
424: ,p_org_link_information26 in varchar2 default hr_api.g_varchar2
425: ,p_org_link_information27 in varchar2 default hr_api.g_varchar2
426: ,p_org_link_information28 in varchar2 default hr_api.g_varchar2
419: ,p_org_link_information21 in varchar2 default hr_api.g_varchar2
420: ,p_org_link_information22 in varchar2 default hr_api.g_varchar2
421: ,p_org_link_information23 in varchar2 default hr_api.g_varchar2
422: ,p_org_link_information24 in varchar2 default hr_api.g_varchar2
423: ,p_org_link_information25 in varchar2 default hr_api.g_varchar2
424: ,p_org_link_information26 in varchar2 default hr_api.g_varchar2
425: ,p_org_link_information27 in varchar2 default hr_api.g_varchar2
426: ,p_org_link_information28 in varchar2 default hr_api.g_varchar2
427: ,p_org_link_information29 in varchar2 default hr_api.g_varchar2
420: ,p_org_link_information22 in varchar2 default hr_api.g_varchar2
421: ,p_org_link_information23 in varchar2 default hr_api.g_varchar2
422: ,p_org_link_information24 in varchar2 default hr_api.g_varchar2
423: ,p_org_link_information25 in varchar2 default hr_api.g_varchar2
424: ,p_org_link_information26 in varchar2 default hr_api.g_varchar2
425: ,p_org_link_information27 in varchar2 default hr_api.g_varchar2
426: ,p_org_link_information28 in varchar2 default hr_api.g_varchar2
427: ,p_org_link_information29 in varchar2 default hr_api.g_varchar2
428: ,p_org_link_information30 in varchar2 default hr_api.g_varchar2
421: ,p_org_link_information23 in varchar2 default hr_api.g_varchar2
422: ,p_org_link_information24 in varchar2 default hr_api.g_varchar2
423: ,p_org_link_information25 in varchar2 default hr_api.g_varchar2
424: ,p_org_link_information26 in varchar2 default hr_api.g_varchar2
425: ,p_org_link_information27 in varchar2 default hr_api.g_varchar2
426: ,p_org_link_information28 in varchar2 default hr_api.g_varchar2
427: ,p_org_link_information29 in varchar2 default hr_api.g_varchar2
428: ,p_org_link_information30 in varchar2 default hr_api.g_varchar2
429: ,p_attribute_category in varchar2 default hr_api.g_varchar2
422: ,p_org_link_information24 in varchar2 default hr_api.g_varchar2
423: ,p_org_link_information25 in varchar2 default hr_api.g_varchar2
424: ,p_org_link_information26 in varchar2 default hr_api.g_varchar2
425: ,p_org_link_information27 in varchar2 default hr_api.g_varchar2
426: ,p_org_link_information28 in varchar2 default hr_api.g_varchar2
427: ,p_org_link_information29 in varchar2 default hr_api.g_varchar2
428: ,p_org_link_information30 in varchar2 default hr_api.g_varchar2
429: ,p_attribute_category in varchar2 default hr_api.g_varchar2
430: ,p_attribute1 in varchar2 default hr_api.g_varchar2
423: ,p_org_link_information25 in varchar2 default hr_api.g_varchar2
424: ,p_org_link_information26 in varchar2 default hr_api.g_varchar2
425: ,p_org_link_information27 in varchar2 default hr_api.g_varchar2
426: ,p_org_link_information28 in varchar2 default hr_api.g_varchar2
427: ,p_org_link_information29 in varchar2 default hr_api.g_varchar2
428: ,p_org_link_information30 in varchar2 default hr_api.g_varchar2
429: ,p_attribute_category in varchar2 default hr_api.g_varchar2
430: ,p_attribute1 in varchar2 default hr_api.g_varchar2
431: ,p_attribute2 in varchar2 default hr_api.g_varchar2
424: ,p_org_link_information26 in varchar2 default hr_api.g_varchar2
425: ,p_org_link_information27 in varchar2 default hr_api.g_varchar2
426: ,p_org_link_information28 in varchar2 default hr_api.g_varchar2
427: ,p_org_link_information29 in varchar2 default hr_api.g_varchar2
428: ,p_org_link_information30 in varchar2 default hr_api.g_varchar2
429: ,p_attribute_category in varchar2 default hr_api.g_varchar2
430: ,p_attribute1 in varchar2 default hr_api.g_varchar2
431: ,p_attribute2 in varchar2 default hr_api.g_varchar2
432: ,p_attribute3 in varchar2 default hr_api.g_varchar2
425: ,p_org_link_information27 in varchar2 default hr_api.g_varchar2
426: ,p_org_link_information28 in varchar2 default hr_api.g_varchar2
427: ,p_org_link_information29 in varchar2 default hr_api.g_varchar2
428: ,p_org_link_information30 in varchar2 default hr_api.g_varchar2
429: ,p_attribute_category in varchar2 default hr_api.g_varchar2
430: ,p_attribute1 in varchar2 default hr_api.g_varchar2
431: ,p_attribute2 in varchar2 default hr_api.g_varchar2
432: ,p_attribute3 in varchar2 default hr_api.g_varchar2
433: ,p_attribute4 in varchar2 default hr_api.g_varchar2
426: ,p_org_link_information28 in varchar2 default hr_api.g_varchar2
427: ,p_org_link_information29 in varchar2 default hr_api.g_varchar2
428: ,p_org_link_information30 in varchar2 default hr_api.g_varchar2
429: ,p_attribute_category in varchar2 default hr_api.g_varchar2
430: ,p_attribute1 in varchar2 default hr_api.g_varchar2
431: ,p_attribute2 in varchar2 default hr_api.g_varchar2
432: ,p_attribute3 in varchar2 default hr_api.g_varchar2
433: ,p_attribute4 in varchar2 default hr_api.g_varchar2
434: ,p_attribute5 in varchar2 default hr_api.g_varchar2
427: ,p_org_link_information29 in varchar2 default hr_api.g_varchar2
428: ,p_org_link_information30 in varchar2 default hr_api.g_varchar2
429: ,p_attribute_category in varchar2 default hr_api.g_varchar2
430: ,p_attribute1 in varchar2 default hr_api.g_varchar2
431: ,p_attribute2 in varchar2 default hr_api.g_varchar2
432: ,p_attribute3 in varchar2 default hr_api.g_varchar2
433: ,p_attribute4 in varchar2 default hr_api.g_varchar2
434: ,p_attribute5 in varchar2 default hr_api.g_varchar2
435: ,p_attribute6 in varchar2 default hr_api.g_varchar2
428: ,p_org_link_information30 in varchar2 default hr_api.g_varchar2
429: ,p_attribute_category in varchar2 default hr_api.g_varchar2
430: ,p_attribute1 in varchar2 default hr_api.g_varchar2
431: ,p_attribute2 in varchar2 default hr_api.g_varchar2
432: ,p_attribute3 in varchar2 default hr_api.g_varchar2
433: ,p_attribute4 in varchar2 default hr_api.g_varchar2
434: ,p_attribute5 in varchar2 default hr_api.g_varchar2
435: ,p_attribute6 in varchar2 default hr_api.g_varchar2
436: ,p_attribute7 in varchar2 default hr_api.g_varchar2
429: ,p_attribute_category in varchar2 default hr_api.g_varchar2
430: ,p_attribute1 in varchar2 default hr_api.g_varchar2
431: ,p_attribute2 in varchar2 default hr_api.g_varchar2
432: ,p_attribute3 in varchar2 default hr_api.g_varchar2
433: ,p_attribute4 in varchar2 default hr_api.g_varchar2
434: ,p_attribute5 in varchar2 default hr_api.g_varchar2
435: ,p_attribute6 in varchar2 default hr_api.g_varchar2
436: ,p_attribute7 in varchar2 default hr_api.g_varchar2
437: ,p_attribute8 in varchar2 default hr_api.g_varchar2
430: ,p_attribute1 in varchar2 default hr_api.g_varchar2
431: ,p_attribute2 in varchar2 default hr_api.g_varchar2
432: ,p_attribute3 in varchar2 default hr_api.g_varchar2
433: ,p_attribute4 in varchar2 default hr_api.g_varchar2
434: ,p_attribute5 in varchar2 default hr_api.g_varchar2
435: ,p_attribute6 in varchar2 default hr_api.g_varchar2
436: ,p_attribute7 in varchar2 default hr_api.g_varchar2
437: ,p_attribute8 in varchar2 default hr_api.g_varchar2
438: ,p_attribute9 in varchar2 default hr_api.g_varchar2
431: ,p_attribute2 in varchar2 default hr_api.g_varchar2
432: ,p_attribute3 in varchar2 default hr_api.g_varchar2
433: ,p_attribute4 in varchar2 default hr_api.g_varchar2
434: ,p_attribute5 in varchar2 default hr_api.g_varchar2
435: ,p_attribute6 in varchar2 default hr_api.g_varchar2
436: ,p_attribute7 in varchar2 default hr_api.g_varchar2
437: ,p_attribute8 in varchar2 default hr_api.g_varchar2
438: ,p_attribute9 in varchar2 default hr_api.g_varchar2
439: ,p_attribute10 in varchar2 default hr_api.g_varchar2
432: ,p_attribute3 in varchar2 default hr_api.g_varchar2
433: ,p_attribute4 in varchar2 default hr_api.g_varchar2
434: ,p_attribute5 in varchar2 default hr_api.g_varchar2
435: ,p_attribute6 in varchar2 default hr_api.g_varchar2
436: ,p_attribute7 in varchar2 default hr_api.g_varchar2
437: ,p_attribute8 in varchar2 default hr_api.g_varchar2
438: ,p_attribute9 in varchar2 default hr_api.g_varchar2
439: ,p_attribute10 in varchar2 default hr_api.g_varchar2
440: ,p_attribute11 in varchar2 default hr_api.g_varchar2
433: ,p_attribute4 in varchar2 default hr_api.g_varchar2
434: ,p_attribute5 in varchar2 default hr_api.g_varchar2
435: ,p_attribute6 in varchar2 default hr_api.g_varchar2
436: ,p_attribute7 in varchar2 default hr_api.g_varchar2
437: ,p_attribute8 in varchar2 default hr_api.g_varchar2
438: ,p_attribute9 in varchar2 default hr_api.g_varchar2
439: ,p_attribute10 in varchar2 default hr_api.g_varchar2
440: ,p_attribute11 in varchar2 default hr_api.g_varchar2
441: ,p_attribute12 in varchar2 default hr_api.g_varchar2
434: ,p_attribute5 in varchar2 default hr_api.g_varchar2
435: ,p_attribute6 in varchar2 default hr_api.g_varchar2
436: ,p_attribute7 in varchar2 default hr_api.g_varchar2
437: ,p_attribute8 in varchar2 default hr_api.g_varchar2
438: ,p_attribute9 in varchar2 default hr_api.g_varchar2
439: ,p_attribute10 in varchar2 default hr_api.g_varchar2
440: ,p_attribute11 in varchar2 default hr_api.g_varchar2
441: ,p_attribute12 in varchar2 default hr_api.g_varchar2
442: ,p_attribute13 in varchar2 default hr_api.g_varchar2
435: ,p_attribute6 in varchar2 default hr_api.g_varchar2
436: ,p_attribute7 in varchar2 default hr_api.g_varchar2
437: ,p_attribute8 in varchar2 default hr_api.g_varchar2
438: ,p_attribute9 in varchar2 default hr_api.g_varchar2
439: ,p_attribute10 in varchar2 default hr_api.g_varchar2
440: ,p_attribute11 in varchar2 default hr_api.g_varchar2
441: ,p_attribute12 in varchar2 default hr_api.g_varchar2
442: ,p_attribute13 in varchar2 default hr_api.g_varchar2
443: ,p_attribute14 in varchar2 default hr_api.g_varchar2
436: ,p_attribute7 in varchar2 default hr_api.g_varchar2
437: ,p_attribute8 in varchar2 default hr_api.g_varchar2
438: ,p_attribute9 in varchar2 default hr_api.g_varchar2
439: ,p_attribute10 in varchar2 default hr_api.g_varchar2
440: ,p_attribute11 in varchar2 default hr_api.g_varchar2
441: ,p_attribute12 in varchar2 default hr_api.g_varchar2
442: ,p_attribute13 in varchar2 default hr_api.g_varchar2
443: ,p_attribute14 in varchar2 default hr_api.g_varchar2
444: ,p_attribute15 in varchar2 default hr_api.g_varchar2
437: ,p_attribute8 in varchar2 default hr_api.g_varchar2
438: ,p_attribute9 in varchar2 default hr_api.g_varchar2
439: ,p_attribute10 in varchar2 default hr_api.g_varchar2
440: ,p_attribute11 in varchar2 default hr_api.g_varchar2
441: ,p_attribute12 in varchar2 default hr_api.g_varchar2
442: ,p_attribute13 in varchar2 default hr_api.g_varchar2
443: ,p_attribute14 in varchar2 default hr_api.g_varchar2
444: ,p_attribute15 in varchar2 default hr_api.g_varchar2
445: ,p_attribute16 in varchar2 default hr_api.g_varchar2
438: ,p_attribute9 in varchar2 default hr_api.g_varchar2
439: ,p_attribute10 in varchar2 default hr_api.g_varchar2
440: ,p_attribute11 in varchar2 default hr_api.g_varchar2
441: ,p_attribute12 in varchar2 default hr_api.g_varchar2
442: ,p_attribute13 in varchar2 default hr_api.g_varchar2
443: ,p_attribute14 in varchar2 default hr_api.g_varchar2
444: ,p_attribute15 in varchar2 default hr_api.g_varchar2
445: ,p_attribute16 in varchar2 default hr_api.g_varchar2
446: ,p_attribute17 in varchar2 default hr_api.g_varchar2
439: ,p_attribute10 in varchar2 default hr_api.g_varchar2
440: ,p_attribute11 in varchar2 default hr_api.g_varchar2
441: ,p_attribute12 in varchar2 default hr_api.g_varchar2
442: ,p_attribute13 in varchar2 default hr_api.g_varchar2
443: ,p_attribute14 in varchar2 default hr_api.g_varchar2
444: ,p_attribute15 in varchar2 default hr_api.g_varchar2
445: ,p_attribute16 in varchar2 default hr_api.g_varchar2
446: ,p_attribute17 in varchar2 default hr_api.g_varchar2
447: ,p_attribute18 in varchar2 default hr_api.g_varchar2
440: ,p_attribute11 in varchar2 default hr_api.g_varchar2
441: ,p_attribute12 in varchar2 default hr_api.g_varchar2
442: ,p_attribute13 in varchar2 default hr_api.g_varchar2
443: ,p_attribute14 in varchar2 default hr_api.g_varchar2
444: ,p_attribute15 in varchar2 default hr_api.g_varchar2
445: ,p_attribute16 in varchar2 default hr_api.g_varchar2
446: ,p_attribute17 in varchar2 default hr_api.g_varchar2
447: ,p_attribute18 in varchar2 default hr_api.g_varchar2
448: ,p_attribute19 in varchar2 default hr_api.g_varchar2
441: ,p_attribute12 in varchar2 default hr_api.g_varchar2
442: ,p_attribute13 in varchar2 default hr_api.g_varchar2
443: ,p_attribute14 in varchar2 default hr_api.g_varchar2
444: ,p_attribute15 in varchar2 default hr_api.g_varchar2
445: ,p_attribute16 in varchar2 default hr_api.g_varchar2
446: ,p_attribute17 in varchar2 default hr_api.g_varchar2
447: ,p_attribute18 in varchar2 default hr_api.g_varchar2
448: ,p_attribute19 in varchar2 default hr_api.g_varchar2
449: ,p_attribute20 in varchar2 default hr_api.g_varchar2
442: ,p_attribute13 in varchar2 default hr_api.g_varchar2
443: ,p_attribute14 in varchar2 default hr_api.g_varchar2
444: ,p_attribute15 in varchar2 default hr_api.g_varchar2
445: ,p_attribute16 in varchar2 default hr_api.g_varchar2
446: ,p_attribute17 in varchar2 default hr_api.g_varchar2
447: ,p_attribute18 in varchar2 default hr_api.g_varchar2
448: ,p_attribute19 in varchar2 default hr_api.g_varchar2
449: ,p_attribute20 in varchar2 default hr_api.g_varchar2
450: ,p_attribute21 in varchar2 default hr_api.g_varchar2
443: ,p_attribute14 in varchar2 default hr_api.g_varchar2
444: ,p_attribute15 in varchar2 default hr_api.g_varchar2
445: ,p_attribute16 in varchar2 default hr_api.g_varchar2
446: ,p_attribute17 in varchar2 default hr_api.g_varchar2
447: ,p_attribute18 in varchar2 default hr_api.g_varchar2
448: ,p_attribute19 in varchar2 default hr_api.g_varchar2
449: ,p_attribute20 in varchar2 default hr_api.g_varchar2
450: ,p_attribute21 in varchar2 default hr_api.g_varchar2
451: ,p_attribute22 in varchar2 default hr_api.g_varchar2
444: ,p_attribute15 in varchar2 default hr_api.g_varchar2
445: ,p_attribute16 in varchar2 default hr_api.g_varchar2
446: ,p_attribute17 in varchar2 default hr_api.g_varchar2
447: ,p_attribute18 in varchar2 default hr_api.g_varchar2
448: ,p_attribute19 in varchar2 default hr_api.g_varchar2
449: ,p_attribute20 in varchar2 default hr_api.g_varchar2
450: ,p_attribute21 in varchar2 default hr_api.g_varchar2
451: ,p_attribute22 in varchar2 default hr_api.g_varchar2
452: ,p_attribute23 in varchar2 default hr_api.g_varchar2
445: ,p_attribute16 in varchar2 default hr_api.g_varchar2
446: ,p_attribute17 in varchar2 default hr_api.g_varchar2
447: ,p_attribute18 in varchar2 default hr_api.g_varchar2
448: ,p_attribute19 in varchar2 default hr_api.g_varchar2
449: ,p_attribute20 in varchar2 default hr_api.g_varchar2
450: ,p_attribute21 in varchar2 default hr_api.g_varchar2
451: ,p_attribute22 in varchar2 default hr_api.g_varchar2
452: ,p_attribute23 in varchar2 default hr_api.g_varchar2
453: ,p_attribute24 in varchar2 default hr_api.g_varchar2
446: ,p_attribute17 in varchar2 default hr_api.g_varchar2
447: ,p_attribute18 in varchar2 default hr_api.g_varchar2
448: ,p_attribute19 in varchar2 default hr_api.g_varchar2
449: ,p_attribute20 in varchar2 default hr_api.g_varchar2
450: ,p_attribute21 in varchar2 default hr_api.g_varchar2
451: ,p_attribute22 in varchar2 default hr_api.g_varchar2
452: ,p_attribute23 in varchar2 default hr_api.g_varchar2
453: ,p_attribute24 in varchar2 default hr_api.g_varchar2
454: ,p_attribute25 in varchar2 default hr_api.g_varchar2
447: ,p_attribute18 in varchar2 default hr_api.g_varchar2
448: ,p_attribute19 in varchar2 default hr_api.g_varchar2
449: ,p_attribute20 in varchar2 default hr_api.g_varchar2
450: ,p_attribute21 in varchar2 default hr_api.g_varchar2
451: ,p_attribute22 in varchar2 default hr_api.g_varchar2
452: ,p_attribute23 in varchar2 default hr_api.g_varchar2
453: ,p_attribute24 in varchar2 default hr_api.g_varchar2
454: ,p_attribute25 in varchar2 default hr_api.g_varchar2
455: ,p_attribute26 in varchar2 default hr_api.g_varchar2
448: ,p_attribute19 in varchar2 default hr_api.g_varchar2
449: ,p_attribute20 in varchar2 default hr_api.g_varchar2
450: ,p_attribute21 in varchar2 default hr_api.g_varchar2
451: ,p_attribute22 in varchar2 default hr_api.g_varchar2
452: ,p_attribute23 in varchar2 default hr_api.g_varchar2
453: ,p_attribute24 in varchar2 default hr_api.g_varchar2
454: ,p_attribute25 in varchar2 default hr_api.g_varchar2
455: ,p_attribute26 in varchar2 default hr_api.g_varchar2
456: ,p_attribute27 in varchar2 default hr_api.g_varchar2
449: ,p_attribute20 in varchar2 default hr_api.g_varchar2
450: ,p_attribute21 in varchar2 default hr_api.g_varchar2
451: ,p_attribute22 in varchar2 default hr_api.g_varchar2
452: ,p_attribute23 in varchar2 default hr_api.g_varchar2
453: ,p_attribute24 in varchar2 default hr_api.g_varchar2
454: ,p_attribute25 in varchar2 default hr_api.g_varchar2
455: ,p_attribute26 in varchar2 default hr_api.g_varchar2
456: ,p_attribute27 in varchar2 default hr_api.g_varchar2
457: ,p_attribute28 in varchar2 default hr_api.g_varchar2
450: ,p_attribute21 in varchar2 default hr_api.g_varchar2
451: ,p_attribute22 in varchar2 default hr_api.g_varchar2
452: ,p_attribute23 in varchar2 default hr_api.g_varchar2
453: ,p_attribute24 in varchar2 default hr_api.g_varchar2
454: ,p_attribute25 in varchar2 default hr_api.g_varchar2
455: ,p_attribute26 in varchar2 default hr_api.g_varchar2
456: ,p_attribute27 in varchar2 default hr_api.g_varchar2
457: ,p_attribute28 in varchar2 default hr_api.g_varchar2
458: ,p_attribute29 in varchar2 default hr_api.g_varchar2
451: ,p_attribute22 in varchar2 default hr_api.g_varchar2
452: ,p_attribute23 in varchar2 default hr_api.g_varchar2
453: ,p_attribute24 in varchar2 default hr_api.g_varchar2
454: ,p_attribute25 in varchar2 default hr_api.g_varchar2
455: ,p_attribute26 in varchar2 default hr_api.g_varchar2
456: ,p_attribute27 in varchar2 default hr_api.g_varchar2
457: ,p_attribute28 in varchar2 default hr_api.g_varchar2
458: ,p_attribute29 in varchar2 default hr_api.g_varchar2
459: ,p_attribute30 in varchar2 default hr_api.g_varchar2
452: ,p_attribute23 in varchar2 default hr_api.g_varchar2
453: ,p_attribute24 in varchar2 default hr_api.g_varchar2
454: ,p_attribute25 in varchar2 default hr_api.g_varchar2
455: ,p_attribute26 in varchar2 default hr_api.g_varchar2
456: ,p_attribute27 in varchar2 default hr_api.g_varchar2
457: ,p_attribute28 in varchar2 default hr_api.g_varchar2
458: ,p_attribute29 in varchar2 default hr_api.g_varchar2
459: ,p_attribute30 in varchar2 default hr_api.g_varchar2
460: ,p_object_version_number in out nocopy number
453: ,p_attribute24 in varchar2 default hr_api.g_varchar2
454: ,p_attribute25 in varchar2 default hr_api.g_varchar2
455: ,p_attribute26 in varchar2 default hr_api.g_varchar2
456: ,p_attribute27 in varchar2 default hr_api.g_varchar2
457: ,p_attribute28 in varchar2 default hr_api.g_varchar2
458: ,p_attribute29 in varchar2 default hr_api.g_varchar2
459: ,p_attribute30 in varchar2 default hr_api.g_varchar2
460: ,p_object_version_number in out nocopy number
461: ) is
454: ,p_attribute25 in varchar2 default hr_api.g_varchar2
455: ,p_attribute26 in varchar2 default hr_api.g_varchar2
456: ,p_attribute27 in varchar2 default hr_api.g_varchar2
457: ,p_attribute28 in varchar2 default hr_api.g_varchar2
458: ,p_attribute29 in varchar2 default hr_api.g_varchar2
459: ,p_attribute30 in varchar2 default hr_api.g_varchar2
460: ,p_object_version_number in out nocopy number
461: ) is
462: --
455: ,p_attribute26 in varchar2 default hr_api.g_varchar2
456: ,p_attribute27 in varchar2 default hr_api.g_varchar2
457: ,p_attribute28 in varchar2 default hr_api.g_varchar2
458: ,p_attribute29 in varchar2 default hr_api.g_varchar2
459: ,p_attribute30 in varchar2 default hr_api.g_varchar2
460: ,p_object_version_number in out nocopy number
461: ) is
462: --
463: -- Declare local variables
541: ,p_attribute29 => p_attribute29
542: ,p_attribute30 => p_attribute30
543: ,p_object_version_number => l_object_version_number);
544: exception
545: when hr_api.cannot_find_prog_unit then
546: hr_api.cannot_find_prog_unit_error
547: (p_module_name => 'update_link'
548: ,p_hook_type => 'BP'
549: );
542: ,p_attribute30 => p_attribute30
543: ,p_object_version_number => l_object_version_number);
544: exception
545: when hr_api.cannot_find_prog_unit then
546: hr_api.cannot_find_prog_unit_error
547: (p_module_name => 'update_link'
548: ,p_hook_type => 'BP'
549: );
550: end;
687: ,p_attribute29 => p_attribute29
688: ,p_attribute30 => p_attribute30
689: ,p_object_version_number => l_object_version_number);
690: exception
691: when hr_api.cannot_find_prog_unit then
692: hr_api.cannot_find_prog_unit_error
693: (p_module_name => 'update_link'
694: ,p_hook_type => 'AP'
695: );
688: ,p_attribute30 => p_attribute30
689: ,p_object_version_number => l_object_version_number);
690: exception
691: when hr_api.cannot_find_prog_unit then
692: hr_api.cannot_find_prog_unit_error
693: (p_module_name => 'update_link'
694: ,p_hook_type => 'AP'
695: );
696: end;
697: --
698: -- When in validation only mode raise the Validate_Enabled exception
699: --
700: if p_validate then
701: raise hr_api.validate_enabled;
702: end if;
703: --
704: -- Set all output arguments
705: --
706: p_object_version_number := l_object_version_number;
707: --
708: hr_utility.set_location(' Leaving:'||l_proc, 70);
709: exception
710: when hr_api.validate_enabled then
711: --
712: -- As the Validate_Enabled exception has been raised
713: -- we must rollback to the savepoint
714: --
757: hr_de_organization_links_bk3.delete_link_b
758: (p_organization_link_id => p_organization_link_id
759: ,p_object_version_number => p_object_version_number);
760: exception
761: when hr_api.cannot_find_prog_unit then
762: hr_api.cannot_find_prog_unit_error
763: (p_module_name => 'delete_link'
764: ,p_hook_type => 'BP'
765: );
758: (p_organization_link_id => p_organization_link_id
759: ,p_object_version_number => p_object_version_number);
760: exception
761: when hr_api.cannot_find_prog_unit then
762: hr_api.cannot_find_prog_unit_error
763: (p_module_name => 'delete_link'
764: ,p_hook_type => 'BP'
765: );
766: end;
775: hr_de_organization_links_bk3.delete_link_a
776: (p_organization_link_id => p_organization_link_id
777: ,p_object_version_number => p_object_version_number);
778: exception
779: when hr_api.cannot_find_prog_unit then
780: hr_api.cannot_find_prog_unit_error
781: (p_module_name => 'delete_link'
782: ,p_hook_type => 'AP'
783: );
776: (p_organization_link_id => p_organization_link_id
777: ,p_object_version_number => p_object_version_number);
778: exception
779: when hr_api.cannot_find_prog_unit then
780: hr_api.cannot_find_prog_unit_error
781: (p_module_name => 'delete_link'
782: ,p_hook_type => 'AP'
783: );
784: end;
785: --
786: -- When in validation only mode raise the Validate_Enabled exception
787: --
788: if p_validate then
789: raise hr_api.validate_enabled;
790: end if;
791: --
792: hr_utility.set_location(' Leaving:'||l_proc, 70);
793: exception
790: end if;
791: --
792: hr_utility.set_location(' Leaving:'||l_proc, 70);
793: exception
794: when hr_api.validate_enabled then
795: --
796: -- As the Validate_Enabled exception has been raised
797: -- we must rollback to the savepoint
798: --