170: ,p_candidate_information28 => p_candidate_information28
171: ,p_candidate_information29 => p_candidate_information29
172: ,p_candidate_information30 => p_candidate_information30);
173: exception
174: when hr_api.cannot_find_prog_unit then
175: hr_api.cannot_find_prog_unit_error
176: (p_module_name => 'create_election_candidate_b'
177: ,p_hook_type => 'BP'
178: );
171: ,p_candidate_information29 => p_candidate_information29
172: ,p_candidate_information30 => p_candidate_information30);
173: exception
174: when hr_api.cannot_find_prog_unit then
175: hr_api.cannot_find_prog_unit_error
176: (p_module_name => 'create_election_candidate_b'
177: ,p_hook_type => 'BP'
178: );
179: end;
333: ,p_object_version_number => l_object_version_number);
334:
335:
336: exception
337: when hr_api.cannot_find_prog_unit then
338: hr_api.cannot_find_prog_unit_error
339: (p_module_name => 'create_election_candidate_a'
340: ,p_hook_type => 'AP'
341: );
334:
335:
336: exception
337: when hr_api.cannot_find_prog_unit then
338: hr_api.cannot_find_prog_unit_error
339: (p_module_name => 'create_election_candidate_a'
340: ,p_hook_type => 'AP'
341: );
342: end;
343: --
344: -- When in validation only mode raise the Validate_Enabled exception
345: --
346: if p_validate then
347: raise hr_api.validate_enabled;
348: end if;
349: --
350: -- Set all output arguments
351: --
353: p_object_version_number := l_object_version_number;
354: --
355: hr_utility.set_location(' Leaving:'||l_proc, 70);
356: exception
357: when hr_api.validate_enabled then
358: --
359: -- As the Validate_Enabled exception has been raised
360: -- we must rollback to the savepoint
361: --
392: procedure update_election_candidate
393: (p_validate in boolean default false
394: ,p_election_candidate_id in number
395: ,p_object_version_number in out nocopy number
396: ,p_business_group_id in number default hr_api.g_number
397: ,p_person_id in number default hr_api.g_number
398: ,p_election_id in number default hr_api.g_number
399: ,p_rank in number default hr_api.g_number
400: ,p_role_id in number default hr_api.g_number
393: (p_validate in boolean default false
394: ,p_election_candidate_id in number
395: ,p_object_version_number in out nocopy number
396: ,p_business_group_id in number default hr_api.g_number
397: ,p_person_id in number default hr_api.g_number
398: ,p_election_id in number default hr_api.g_number
399: ,p_rank in number default hr_api.g_number
400: ,p_role_id in number default hr_api.g_number
401: ,p_attribute_category in varchar2 default hr_api.g_varchar2
394: ,p_election_candidate_id in number
395: ,p_object_version_number in out nocopy number
396: ,p_business_group_id in number default hr_api.g_number
397: ,p_person_id in number default hr_api.g_number
398: ,p_election_id in number default hr_api.g_number
399: ,p_rank in number default hr_api.g_number
400: ,p_role_id in number default hr_api.g_number
401: ,p_attribute_category in varchar2 default hr_api.g_varchar2
402: ,p_attribute1 in varchar2 default hr_api.g_varchar2
395: ,p_object_version_number in out nocopy number
396: ,p_business_group_id in number default hr_api.g_number
397: ,p_person_id in number default hr_api.g_number
398: ,p_election_id in number default hr_api.g_number
399: ,p_rank in number default hr_api.g_number
400: ,p_role_id in number default hr_api.g_number
401: ,p_attribute_category in varchar2 default hr_api.g_varchar2
402: ,p_attribute1 in varchar2 default hr_api.g_varchar2
403: ,p_attribute2 in varchar2 default hr_api.g_varchar2
396: ,p_business_group_id in number default hr_api.g_number
397: ,p_person_id in number default hr_api.g_number
398: ,p_election_id in number default hr_api.g_number
399: ,p_rank in number default hr_api.g_number
400: ,p_role_id in number default hr_api.g_number
401: ,p_attribute_category in varchar2 default hr_api.g_varchar2
402: ,p_attribute1 in varchar2 default hr_api.g_varchar2
403: ,p_attribute2 in varchar2 default hr_api.g_varchar2
404: ,p_attribute3 in varchar2 default hr_api.g_varchar2
397: ,p_person_id in number default hr_api.g_number
398: ,p_election_id in number default hr_api.g_number
399: ,p_rank in number default hr_api.g_number
400: ,p_role_id in number default hr_api.g_number
401: ,p_attribute_category in varchar2 default hr_api.g_varchar2
402: ,p_attribute1 in varchar2 default hr_api.g_varchar2
403: ,p_attribute2 in varchar2 default hr_api.g_varchar2
404: ,p_attribute3 in varchar2 default hr_api.g_varchar2
405: ,p_attribute4 in varchar2 default hr_api.g_varchar2
398: ,p_election_id in number default hr_api.g_number
399: ,p_rank in number default hr_api.g_number
400: ,p_role_id in number default hr_api.g_number
401: ,p_attribute_category in varchar2 default hr_api.g_varchar2
402: ,p_attribute1 in varchar2 default hr_api.g_varchar2
403: ,p_attribute2 in varchar2 default hr_api.g_varchar2
404: ,p_attribute3 in varchar2 default hr_api.g_varchar2
405: ,p_attribute4 in varchar2 default hr_api.g_varchar2
406: ,p_attribute5 in varchar2 default hr_api.g_varchar2
399: ,p_rank in number default hr_api.g_number
400: ,p_role_id in number default hr_api.g_number
401: ,p_attribute_category in varchar2 default hr_api.g_varchar2
402: ,p_attribute1 in varchar2 default hr_api.g_varchar2
403: ,p_attribute2 in varchar2 default hr_api.g_varchar2
404: ,p_attribute3 in varchar2 default hr_api.g_varchar2
405: ,p_attribute4 in varchar2 default hr_api.g_varchar2
406: ,p_attribute5 in varchar2 default hr_api.g_varchar2
407: ,p_attribute6 in varchar2 default hr_api.g_varchar2
400: ,p_role_id in number default hr_api.g_number
401: ,p_attribute_category in varchar2 default hr_api.g_varchar2
402: ,p_attribute1 in varchar2 default hr_api.g_varchar2
403: ,p_attribute2 in varchar2 default hr_api.g_varchar2
404: ,p_attribute3 in varchar2 default hr_api.g_varchar2
405: ,p_attribute4 in varchar2 default hr_api.g_varchar2
406: ,p_attribute5 in varchar2 default hr_api.g_varchar2
407: ,p_attribute6 in varchar2 default hr_api.g_varchar2
408: ,p_attribute7 in varchar2 default hr_api.g_varchar2
401: ,p_attribute_category in varchar2 default hr_api.g_varchar2
402: ,p_attribute1 in varchar2 default hr_api.g_varchar2
403: ,p_attribute2 in varchar2 default hr_api.g_varchar2
404: ,p_attribute3 in varchar2 default hr_api.g_varchar2
405: ,p_attribute4 in varchar2 default hr_api.g_varchar2
406: ,p_attribute5 in varchar2 default hr_api.g_varchar2
407: ,p_attribute6 in varchar2 default hr_api.g_varchar2
408: ,p_attribute7 in varchar2 default hr_api.g_varchar2
409: ,p_attribute8 in varchar2 default hr_api.g_varchar2
402: ,p_attribute1 in varchar2 default hr_api.g_varchar2
403: ,p_attribute2 in varchar2 default hr_api.g_varchar2
404: ,p_attribute3 in varchar2 default hr_api.g_varchar2
405: ,p_attribute4 in varchar2 default hr_api.g_varchar2
406: ,p_attribute5 in varchar2 default hr_api.g_varchar2
407: ,p_attribute6 in varchar2 default hr_api.g_varchar2
408: ,p_attribute7 in varchar2 default hr_api.g_varchar2
409: ,p_attribute8 in varchar2 default hr_api.g_varchar2
410: ,p_attribute9 in varchar2 default hr_api.g_varchar2
403: ,p_attribute2 in varchar2 default hr_api.g_varchar2
404: ,p_attribute3 in varchar2 default hr_api.g_varchar2
405: ,p_attribute4 in varchar2 default hr_api.g_varchar2
406: ,p_attribute5 in varchar2 default hr_api.g_varchar2
407: ,p_attribute6 in varchar2 default hr_api.g_varchar2
408: ,p_attribute7 in varchar2 default hr_api.g_varchar2
409: ,p_attribute8 in varchar2 default hr_api.g_varchar2
410: ,p_attribute9 in varchar2 default hr_api.g_varchar2
411: ,p_attribute10 in varchar2 default hr_api.g_varchar2
404: ,p_attribute3 in varchar2 default hr_api.g_varchar2
405: ,p_attribute4 in varchar2 default hr_api.g_varchar2
406: ,p_attribute5 in varchar2 default hr_api.g_varchar2
407: ,p_attribute6 in varchar2 default hr_api.g_varchar2
408: ,p_attribute7 in varchar2 default hr_api.g_varchar2
409: ,p_attribute8 in varchar2 default hr_api.g_varchar2
410: ,p_attribute9 in varchar2 default hr_api.g_varchar2
411: ,p_attribute10 in varchar2 default hr_api.g_varchar2
412: ,p_attribute11 in varchar2 default hr_api.g_varchar2
405: ,p_attribute4 in varchar2 default hr_api.g_varchar2
406: ,p_attribute5 in varchar2 default hr_api.g_varchar2
407: ,p_attribute6 in varchar2 default hr_api.g_varchar2
408: ,p_attribute7 in varchar2 default hr_api.g_varchar2
409: ,p_attribute8 in varchar2 default hr_api.g_varchar2
410: ,p_attribute9 in varchar2 default hr_api.g_varchar2
411: ,p_attribute10 in varchar2 default hr_api.g_varchar2
412: ,p_attribute11 in varchar2 default hr_api.g_varchar2
413: ,p_attribute12 in varchar2 default hr_api.g_varchar2
406: ,p_attribute5 in varchar2 default hr_api.g_varchar2
407: ,p_attribute6 in varchar2 default hr_api.g_varchar2
408: ,p_attribute7 in varchar2 default hr_api.g_varchar2
409: ,p_attribute8 in varchar2 default hr_api.g_varchar2
410: ,p_attribute9 in varchar2 default hr_api.g_varchar2
411: ,p_attribute10 in varchar2 default hr_api.g_varchar2
412: ,p_attribute11 in varchar2 default hr_api.g_varchar2
413: ,p_attribute12 in varchar2 default hr_api.g_varchar2
414: ,p_attribute13 in varchar2 default hr_api.g_varchar2
407: ,p_attribute6 in varchar2 default hr_api.g_varchar2
408: ,p_attribute7 in varchar2 default hr_api.g_varchar2
409: ,p_attribute8 in varchar2 default hr_api.g_varchar2
410: ,p_attribute9 in varchar2 default hr_api.g_varchar2
411: ,p_attribute10 in varchar2 default hr_api.g_varchar2
412: ,p_attribute11 in varchar2 default hr_api.g_varchar2
413: ,p_attribute12 in varchar2 default hr_api.g_varchar2
414: ,p_attribute13 in varchar2 default hr_api.g_varchar2
415: ,p_attribute14 in varchar2 default hr_api.g_varchar2
408: ,p_attribute7 in varchar2 default hr_api.g_varchar2
409: ,p_attribute8 in varchar2 default hr_api.g_varchar2
410: ,p_attribute9 in varchar2 default hr_api.g_varchar2
411: ,p_attribute10 in varchar2 default hr_api.g_varchar2
412: ,p_attribute11 in varchar2 default hr_api.g_varchar2
413: ,p_attribute12 in varchar2 default hr_api.g_varchar2
414: ,p_attribute13 in varchar2 default hr_api.g_varchar2
415: ,p_attribute14 in varchar2 default hr_api.g_varchar2
416: ,p_attribute15 in varchar2 default hr_api.g_varchar2
409: ,p_attribute8 in varchar2 default hr_api.g_varchar2
410: ,p_attribute9 in varchar2 default hr_api.g_varchar2
411: ,p_attribute10 in varchar2 default hr_api.g_varchar2
412: ,p_attribute11 in varchar2 default hr_api.g_varchar2
413: ,p_attribute12 in varchar2 default hr_api.g_varchar2
414: ,p_attribute13 in varchar2 default hr_api.g_varchar2
415: ,p_attribute14 in varchar2 default hr_api.g_varchar2
416: ,p_attribute15 in varchar2 default hr_api.g_varchar2
417: ,p_attribute16 in varchar2 default hr_api.g_varchar2
410: ,p_attribute9 in varchar2 default hr_api.g_varchar2
411: ,p_attribute10 in varchar2 default hr_api.g_varchar2
412: ,p_attribute11 in varchar2 default hr_api.g_varchar2
413: ,p_attribute12 in varchar2 default hr_api.g_varchar2
414: ,p_attribute13 in varchar2 default hr_api.g_varchar2
415: ,p_attribute14 in varchar2 default hr_api.g_varchar2
416: ,p_attribute15 in varchar2 default hr_api.g_varchar2
417: ,p_attribute16 in varchar2 default hr_api.g_varchar2
418: ,p_attribute17 in varchar2 default hr_api.g_varchar2
411: ,p_attribute10 in varchar2 default hr_api.g_varchar2
412: ,p_attribute11 in varchar2 default hr_api.g_varchar2
413: ,p_attribute12 in varchar2 default hr_api.g_varchar2
414: ,p_attribute13 in varchar2 default hr_api.g_varchar2
415: ,p_attribute14 in varchar2 default hr_api.g_varchar2
416: ,p_attribute15 in varchar2 default hr_api.g_varchar2
417: ,p_attribute16 in varchar2 default hr_api.g_varchar2
418: ,p_attribute17 in varchar2 default hr_api.g_varchar2
419: ,p_attribute18 in varchar2 default hr_api.g_varchar2
412: ,p_attribute11 in varchar2 default hr_api.g_varchar2
413: ,p_attribute12 in varchar2 default hr_api.g_varchar2
414: ,p_attribute13 in varchar2 default hr_api.g_varchar2
415: ,p_attribute14 in varchar2 default hr_api.g_varchar2
416: ,p_attribute15 in varchar2 default hr_api.g_varchar2
417: ,p_attribute16 in varchar2 default hr_api.g_varchar2
418: ,p_attribute17 in varchar2 default hr_api.g_varchar2
419: ,p_attribute18 in varchar2 default hr_api.g_varchar2
420: ,p_attribute19 in varchar2 default hr_api.g_varchar2
413: ,p_attribute12 in varchar2 default hr_api.g_varchar2
414: ,p_attribute13 in varchar2 default hr_api.g_varchar2
415: ,p_attribute14 in varchar2 default hr_api.g_varchar2
416: ,p_attribute15 in varchar2 default hr_api.g_varchar2
417: ,p_attribute16 in varchar2 default hr_api.g_varchar2
418: ,p_attribute17 in varchar2 default hr_api.g_varchar2
419: ,p_attribute18 in varchar2 default hr_api.g_varchar2
420: ,p_attribute19 in varchar2 default hr_api.g_varchar2
421: ,p_attribute20 in varchar2 default hr_api.g_varchar2
414: ,p_attribute13 in varchar2 default hr_api.g_varchar2
415: ,p_attribute14 in varchar2 default hr_api.g_varchar2
416: ,p_attribute15 in varchar2 default hr_api.g_varchar2
417: ,p_attribute16 in varchar2 default hr_api.g_varchar2
418: ,p_attribute17 in varchar2 default hr_api.g_varchar2
419: ,p_attribute18 in varchar2 default hr_api.g_varchar2
420: ,p_attribute19 in varchar2 default hr_api.g_varchar2
421: ,p_attribute20 in varchar2 default hr_api.g_varchar2
422: ,p_attribute21 in varchar2 default hr_api.g_varchar2
415: ,p_attribute14 in varchar2 default hr_api.g_varchar2
416: ,p_attribute15 in varchar2 default hr_api.g_varchar2
417: ,p_attribute16 in varchar2 default hr_api.g_varchar2
418: ,p_attribute17 in varchar2 default hr_api.g_varchar2
419: ,p_attribute18 in varchar2 default hr_api.g_varchar2
420: ,p_attribute19 in varchar2 default hr_api.g_varchar2
421: ,p_attribute20 in varchar2 default hr_api.g_varchar2
422: ,p_attribute21 in varchar2 default hr_api.g_varchar2
423: ,p_attribute22 in varchar2 default hr_api.g_varchar2
416: ,p_attribute15 in varchar2 default hr_api.g_varchar2
417: ,p_attribute16 in varchar2 default hr_api.g_varchar2
418: ,p_attribute17 in varchar2 default hr_api.g_varchar2
419: ,p_attribute18 in varchar2 default hr_api.g_varchar2
420: ,p_attribute19 in varchar2 default hr_api.g_varchar2
421: ,p_attribute20 in varchar2 default hr_api.g_varchar2
422: ,p_attribute21 in varchar2 default hr_api.g_varchar2
423: ,p_attribute22 in varchar2 default hr_api.g_varchar2
424: ,p_attribute23 in varchar2 default hr_api.g_varchar2
417: ,p_attribute16 in varchar2 default hr_api.g_varchar2
418: ,p_attribute17 in varchar2 default hr_api.g_varchar2
419: ,p_attribute18 in varchar2 default hr_api.g_varchar2
420: ,p_attribute19 in varchar2 default hr_api.g_varchar2
421: ,p_attribute20 in varchar2 default hr_api.g_varchar2
422: ,p_attribute21 in varchar2 default hr_api.g_varchar2
423: ,p_attribute22 in varchar2 default hr_api.g_varchar2
424: ,p_attribute23 in varchar2 default hr_api.g_varchar2
425: ,p_attribute24 in varchar2 default hr_api.g_varchar2
418: ,p_attribute17 in varchar2 default hr_api.g_varchar2
419: ,p_attribute18 in varchar2 default hr_api.g_varchar2
420: ,p_attribute19 in varchar2 default hr_api.g_varchar2
421: ,p_attribute20 in varchar2 default hr_api.g_varchar2
422: ,p_attribute21 in varchar2 default hr_api.g_varchar2
423: ,p_attribute22 in varchar2 default hr_api.g_varchar2
424: ,p_attribute23 in varchar2 default hr_api.g_varchar2
425: ,p_attribute24 in varchar2 default hr_api.g_varchar2
426: ,p_attribute25 in varchar2 default hr_api.g_varchar2
419: ,p_attribute18 in varchar2 default hr_api.g_varchar2
420: ,p_attribute19 in varchar2 default hr_api.g_varchar2
421: ,p_attribute20 in varchar2 default hr_api.g_varchar2
422: ,p_attribute21 in varchar2 default hr_api.g_varchar2
423: ,p_attribute22 in varchar2 default hr_api.g_varchar2
424: ,p_attribute23 in varchar2 default hr_api.g_varchar2
425: ,p_attribute24 in varchar2 default hr_api.g_varchar2
426: ,p_attribute25 in varchar2 default hr_api.g_varchar2
427: ,p_attribute26 in varchar2 default hr_api.g_varchar2
420: ,p_attribute19 in varchar2 default hr_api.g_varchar2
421: ,p_attribute20 in varchar2 default hr_api.g_varchar2
422: ,p_attribute21 in varchar2 default hr_api.g_varchar2
423: ,p_attribute22 in varchar2 default hr_api.g_varchar2
424: ,p_attribute23 in varchar2 default hr_api.g_varchar2
425: ,p_attribute24 in varchar2 default hr_api.g_varchar2
426: ,p_attribute25 in varchar2 default hr_api.g_varchar2
427: ,p_attribute26 in varchar2 default hr_api.g_varchar2
428: ,p_attribute27 in varchar2 default hr_api.g_varchar2
421: ,p_attribute20 in varchar2 default hr_api.g_varchar2
422: ,p_attribute21 in varchar2 default hr_api.g_varchar2
423: ,p_attribute22 in varchar2 default hr_api.g_varchar2
424: ,p_attribute23 in varchar2 default hr_api.g_varchar2
425: ,p_attribute24 in varchar2 default hr_api.g_varchar2
426: ,p_attribute25 in varchar2 default hr_api.g_varchar2
427: ,p_attribute26 in varchar2 default hr_api.g_varchar2
428: ,p_attribute27 in varchar2 default hr_api.g_varchar2
429: ,p_attribute28 in varchar2 default hr_api.g_varchar2
422: ,p_attribute21 in varchar2 default hr_api.g_varchar2
423: ,p_attribute22 in varchar2 default hr_api.g_varchar2
424: ,p_attribute23 in varchar2 default hr_api.g_varchar2
425: ,p_attribute24 in varchar2 default hr_api.g_varchar2
426: ,p_attribute25 in varchar2 default hr_api.g_varchar2
427: ,p_attribute26 in varchar2 default hr_api.g_varchar2
428: ,p_attribute27 in varchar2 default hr_api.g_varchar2
429: ,p_attribute28 in varchar2 default hr_api.g_varchar2
430: ,p_attribute29 in varchar2 default hr_api.g_varchar2
423: ,p_attribute22 in varchar2 default hr_api.g_varchar2
424: ,p_attribute23 in varchar2 default hr_api.g_varchar2
425: ,p_attribute24 in varchar2 default hr_api.g_varchar2
426: ,p_attribute25 in varchar2 default hr_api.g_varchar2
427: ,p_attribute26 in varchar2 default hr_api.g_varchar2
428: ,p_attribute27 in varchar2 default hr_api.g_varchar2
429: ,p_attribute28 in varchar2 default hr_api.g_varchar2
430: ,p_attribute29 in varchar2 default hr_api.g_varchar2
431: ,p_attribute30 in varchar2 default hr_api.g_varchar2
424: ,p_attribute23 in varchar2 default hr_api.g_varchar2
425: ,p_attribute24 in varchar2 default hr_api.g_varchar2
426: ,p_attribute25 in varchar2 default hr_api.g_varchar2
427: ,p_attribute26 in varchar2 default hr_api.g_varchar2
428: ,p_attribute27 in varchar2 default hr_api.g_varchar2
429: ,p_attribute28 in varchar2 default hr_api.g_varchar2
430: ,p_attribute29 in varchar2 default hr_api.g_varchar2
431: ,p_attribute30 in varchar2 default hr_api.g_varchar2
432: ,p_candidate_info_category in varchar2 default hr_api.g_varchar2
425: ,p_attribute24 in varchar2 default hr_api.g_varchar2
426: ,p_attribute25 in varchar2 default hr_api.g_varchar2
427: ,p_attribute26 in varchar2 default hr_api.g_varchar2
428: ,p_attribute27 in varchar2 default hr_api.g_varchar2
429: ,p_attribute28 in varchar2 default hr_api.g_varchar2
430: ,p_attribute29 in varchar2 default hr_api.g_varchar2
431: ,p_attribute30 in varchar2 default hr_api.g_varchar2
432: ,p_candidate_info_category in varchar2 default hr_api.g_varchar2
433: ,p_candidate_information1 in varchar2 default hr_api.g_varchar2
426: ,p_attribute25 in varchar2 default hr_api.g_varchar2
427: ,p_attribute26 in varchar2 default hr_api.g_varchar2
428: ,p_attribute27 in varchar2 default hr_api.g_varchar2
429: ,p_attribute28 in varchar2 default hr_api.g_varchar2
430: ,p_attribute29 in varchar2 default hr_api.g_varchar2
431: ,p_attribute30 in varchar2 default hr_api.g_varchar2
432: ,p_candidate_info_category in varchar2 default hr_api.g_varchar2
433: ,p_candidate_information1 in varchar2 default hr_api.g_varchar2
434: ,p_candidate_information2 in varchar2 default hr_api.g_varchar2
427: ,p_attribute26 in varchar2 default hr_api.g_varchar2
428: ,p_attribute27 in varchar2 default hr_api.g_varchar2
429: ,p_attribute28 in varchar2 default hr_api.g_varchar2
430: ,p_attribute29 in varchar2 default hr_api.g_varchar2
431: ,p_attribute30 in varchar2 default hr_api.g_varchar2
432: ,p_candidate_info_category in varchar2 default hr_api.g_varchar2
433: ,p_candidate_information1 in varchar2 default hr_api.g_varchar2
434: ,p_candidate_information2 in varchar2 default hr_api.g_varchar2
435: ,p_candidate_information3 in varchar2 default hr_api.g_varchar2
428: ,p_attribute27 in varchar2 default hr_api.g_varchar2
429: ,p_attribute28 in varchar2 default hr_api.g_varchar2
430: ,p_attribute29 in varchar2 default hr_api.g_varchar2
431: ,p_attribute30 in varchar2 default hr_api.g_varchar2
432: ,p_candidate_info_category in varchar2 default hr_api.g_varchar2
433: ,p_candidate_information1 in varchar2 default hr_api.g_varchar2
434: ,p_candidate_information2 in varchar2 default hr_api.g_varchar2
435: ,p_candidate_information3 in varchar2 default hr_api.g_varchar2
436: ,p_candidate_information4 in varchar2 default hr_api.g_varchar2
429: ,p_attribute28 in varchar2 default hr_api.g_varchar2
430: ,p_attribute29 in varchar2 default hr_api.g_varchar2
431: ,p_attribute30 in varchar2 default hr_api.g_varchar2
432: ,p_candidate_info_category in varchar2 default hr_api.g_varchar2
433: ,p_candidate_information1 in varchar2 default hr_api.g_varchar2
434: ,p_candidate_information2 in varchar2 default hr_api.g_varchar2
435: ,p_candidate_information3 in varchar2 default hr_api.g_varchar2
436: ,p_candidate_information4 in varchar2 default hr_api.g_varchar2
437: ,p_candidate_information5 in varchar2 default hr_api.g_varchar2
430: ,p_attribute29 in varchar2 default hr_api.g_varchar2
431: ,p_attribute30 in varchar2 default hr_api.g_varchar2
432: ,p_candidate_info_category in varchar2 default hr_api.g_varchar2
433: ,p_candidate_information1 in varchar2 default hr_api.g_varchar2
434: ,p_candidate_information2 in varchar2 default hr_api.g_varchar2
435: ,p_candidate_information3 in varchar2 default hr_api.g_varchar2
436: ,p_candidate_information4 in varchar2 default hr_api.g_varchar2
437: ,p_candidate_information5 in varchar2 default hr_api.g_varchar2
438: ,p_candidate_information6 in varchar2 default hr_api.g_varchar2
431: ,p_attribute30 in varchar2 default hr_api.g_varchar2
432: ,p_candidate_info_category in varchar2 default hr_api.g_varchar2
433: ,p_candidate_information1 in varchar2 default hr_api.g_varchar2
434: ,p_candidate_information2 in varchar2 default hr_api.g_varchar2
435: ,p_candidate_information3 in varchar2 default hr_api.g_varchar2
436: ,p_candidate_information4 in varchar2 default hr_api.g_varchar2
437: ,p_candidate_information5 in varchar2 default hr_api.g_varchar2
438: ,p_candidate_information6 in varchar2 default hr_api.g_varchar2
439: ,p_candidate_information7 in varchar2 default hr_api.g_varchar2
432: ,p_candidate_info_category in varchar2 default hr_api.g_varchar2
433: ,p_candidate_information1 in varchar2 default hr_api.g_varchar2
434: ,p_candidate_information2 in varchar2 default hr_api.g_varchar2
435: ,p_candidate_information3 in varchar2 default hr_api.g_varchar2
436: ,p_candidate_information4 in varchar2 default hr_api.g_varchar2
437: ,p_candidate_information5 in varchar2 default hr_api.g_varchar2
438: ,p_candidate_information6 in varchar2 default hr_api.g_varchar2
439: ,p_candidate_information7 in varchar2 default hr_api.g_varchar2
440: ,p_candidate_information8 in varchar2 default hr_api.g_varchar2
433: ,p_candidate_information1 in varchar2 default hr_api.g_varchar2
434: ,p_candidate_information2 in varchar2 default hr_api.g_varchar2
435: ,p_candidate_information3 in varchar2 default hr_api.g_varchar2
436: ,p_candidate_information4 in varchar2 default hr_api.g_varchar2
437: ,p_candidate_information5 in varchar2 default hr_api.g_varchar2
438: ,p_candidate_information6 in varchar2 default hr_api.g_varchar2
439: ,p_candidate_information7 in varchar2 default hr_api.g_varchar2
440: ,p_candidate_information8 in varchar2 default hr_api.g_varchar2
441: ,p_candidate_information9 in varchar2 default hr_api.g_varchar2
434: ,p_candidate_information2 in varchar2 default hr_api.g_varchar2
435: ,p_candidate_information3 in varchar2 default hr_api.g_varchar2
436: ,p_candidate_information4 in varchar2 default hr_api.g_varchar2
437: ,p_candidate_information5 in varchar2 default hr_api.g_varchar2
438: ,p_candidate_information6 in varchar2 default hr_api.g_varchar2
439: ,p_candidate_information7 in varchar2 default hr_api.g_varchar2
440: ,p_candidate_information8 in varchar2 default hr_api.g_varchar2
441: ,p_candidate_information9 in varchar2 default hr_api.g_varchar2
442: ,p_candidate_information10 in varchar2 default hr_api.g_varchar2
435: ,p_candidate_information3 in varchar2 default hr_api.g_varchar2
436: ,p_candidate_information4 in varchar2 default hr_api.g_varchar2
437: ,p_candidate_information5 in varchar2 default hr_api.g_varchar2
438: ,p_candidate_information6 in varchar2 default hr_api.g_varchar2
439: ,p_candidate_information7 in varchar2 default hr_api.g_varchar2
440: ,p_candidate_information8 in varchar2 default hr_api.g_varchar2
441: ,p_candidate_information9 in varchar2 default hr_api.g_varchar2
442: ,p_candidate_information10 in varchar2 default hr_api.g_varchar2
443: ,p_candidate_information11 in varchar2 default hr_api.g_varchar2
436: ,p_candidate_information4 in varchar2 default hr_api.g_varchar2
437: ,p_candidate_information5 in varchar2 default hr_api.g_varchar2
438: ,p_candidate_information6 in varchar2 default hr_api.g_varchar2
439: ,p_candidate_information7 in varchar2 default hr_api.g_varchar2
440: ,p_candidate_information8 in varchar2 default hr_api.g_varchar2
441: ,p_candidate_information9 in varchar2 default hr_api.g_varchar2
442: ,p_candidate_information10 in varchar2 default hr_api.g_varchar2
443: ,p_candidate_information11 in varchar2 default hr_api.g_varchar2
444: ,p_candidate_information12 in varchar2 default hr_api.g_varchar2
437: ,p_candidate_information5 in varchar2 default hr_api.g_varchar2
438: ,p_candidate_information6 in varchar2 default hr_api.g_varchar2
439: ,p_candidate_information7 in varchar2 default hr_api.g_varchar2
440: ,p_candidate_information8 in varchar2 default hr_api.g_varchar2
441: ,p_candidate_information9 in varchar2 default hr_api.g_varchar2
442: ,p_candidate_information10 in varchar2 default hr_api.g_varchar2
443: ,p_candidate_information11 in varchar2 default hr_api.g_varchar2
444: ,p_candidate_information12 in varchar2 default hr_api.g_varchar2
445: ,p_candidate_information13 in varchar2 default hr_api.g_varchar2
438: ,p_candidate_information6 in varchar2 default hr_api.g_varchar2
439: ,p_candidate_information7 in varchar2 default hr_api.g_varchar2
440: ,p_candidate_information8 in varchar2 default hr_api.g_varchar2
441: ,p_candidate_information9 in varchar2 default hr_api.g_varchar2
442: ,p_candidate_information10 in varchar2 default hr_api.g_varchar2
443: ,p_candidate_information11 in varchar2 default hr_api.g_varchar2
444: ,p_candidate_information12 in varchar2 default hr_api.g_varchar2
445: ,p_candidate_information13 in varchar2 default hr_api.g_varchar2
446: ,p_candidate_information14 in varchar2 default hr_api.g_varchar2
439: ,p_candidate_information7 in varchar2 default hr_api.g_varchar2
440: ,p_candidate_information8 in varchar2 default hr_api.g_varchar2
441: ,p_candidate_information9 in varchar2 default hr_api.g_varchar2
442: ,p_candidate_information10 in varchar2 default hr_api.g_varchar2
443: ,p_candidate_information11 in varchar2 default hr_api.g_varchar2
444: ,p_candidate_information12 in varchar2 default hr_api.g_varchar2
445: ,p_candidate_information13 in varchar2 default hr_api.g_varchar2
446: ,p_candidate_information14 in varchar2 default hr_api.g_varchar2
447: ,p_candidate_information15 in varchar2 default hr_api.g_varchar2
440: ,p_candidate_information8 in varchar2 default hr_api.g_varchar2
441: ,p_candidate_information9 in varchar2 default hr_api.g_varchar2
442: ,p_candidate_information10 in varchar2 default hr_api.g_varchar2
443: ,p_candidate_information11 in varchar2 default hr_api.g_varchar2
444: ,p_candidate_information12 in varchar2 default hr_api.g_varchar2
445: ,p_candidate_information13 in varchar2 default hr_api.g_varchar2
446: ,p_candidate_information14 in varchar2 default hr_api.g_varchar2
447: ,p_candidate_information15 in varchar2 default hr_api.g_varchar2
448: ,p_candidate_information16 in varchar2 default hr_api.g_varchar2
441: ,p_candidate_information9 in varchar2 default hr_api.g_varchar2
442: ,p_candidate_information10 in varchar2 default hr_api.g_varchar2
443: ,p_candidate_information11 in varchar2 default hr_api.g_varchar2
444: ,p_candidate_information12 in varchar2 default hr_api.g_varchar2
445: ,p_candidate_information13 in varchar2 default hr_api.g_varchar2
446: ,p_candidate_information14 in varchar2 default hr_api.g_varchar2
447: ,p_candidate_information15 in varchar2 default hr_api.g_varchar2
448: ,p_candidate_information16 in varchar2 default hr_api.g_varchar2
449: ,p_candidate_information17 in varchar2 default hr_api.g_varchar2
442: ,p_candidate_information10 in varchar2 default hr_api.g_varchar2
443: ,p_candidate_information11 in varchar2 default hr_api.g_varchar2
444: ,p_candidate_information12 in varchar2 default hr_api.g_varchar2
445: ,p_candidate_information13 in varchar2 default hr_api.g_varchar2
446: ,p_candidate_information14 in varchar2 default hr_api.g_varchar2
447: ,p_candidate_information15 in varchar2 default hr_api.g_varchar2
448: ,p_candidate_information16 in varchar2 default hr_api.g_varchar2
449: ,p_candidate_information17 in varchar2 default hr_api.g_varchar2
450: ,p_candidate_information18 in varchar2 default hr_api.g_varchar2
443: ,p_candidate_information11 in varchar2 default hr_api.g_varchar2
444: ,p_candidate_information12 in varchar2 default hr_api.g_varchar2
445: ,p_candidate_information13 in varchar2 default hr_api.g_varchar2
446: ,p_candidate_information14 in varchar2 default hr_api.g_varchar2
447: ,p_candidate_information15 in varchar2 default hr_api.g_varchar2
448: ,p_candidate_information16 in varchar2 default hr_api.g_varchar2
449: ,p_candidate_information17 in varchar2 default hr_api.g_varchar2
450: ,p_candidate_information18 in varchar2 default hr_api.g_varchar2
451: ,p_candidate_information19 in varchar2 default hr_api.g_varchar2
444: ,p_candidate_information12 in varchar2 default hr_api.g_varchar2
445: ,p_candidate_information13 in varchar2 default hr_api.g_varchar2
446: ,p_candidate_information14 in varchar2 default hr_api.g_varchar2
447: ,p_candidate_information15 in varchar2 default hr_api.g_varchar2
448: ,p_candidate_information16 in varchar2 default hr_api.g_varchar2
449: ,p_candidate_information17 in varchar2 default hr_api.g_varchar2
450: ,p_candidate_information18 in varchar2 default hr_api.g_varchar2
451: ,p_candidate_information19 in varchar2 default hr_api.g_varchar2
452: ,p_candidate_information20 in varchar2 default hr_api.g_varchar2
445: ,p_candidate_information13 in varchar2 default hr_api.g_varchar2
446: ,p_candidate_information14 in varchar2 default hr_api.g_varchar2
447: ,p_candidate_information15 in varchar2 default hr_api.g_varchar2
448: ,p_candidate_information16 in varchar2 default hr_api.g_varchar2
449: ,p_candidate_information17 in varchar2 default hr_api.g_varchar2
450: ,p_candidate_information18 in varchar2 default hr_api.g_varchar2
451: ,p_candidate_information19 in varchar2 default hr_api.g_varchar2
452: ,p_candidate_information20 in varchar2 default hr_api.g_varchar2
453: ,p_candidate_information21 in varchar2 default hr_api.g_varchar2
446: ,p_candidate_information14 in varchar2 default hr_api.g_varchar2
447: ,p_candidate_information15 in varchar2 default hr_api.g_varchar2
448: ,p_candidate_information16 in varchar2 default hr_api.g_varchar2
449: ,p_candidate_information17 in varchar2 default hr_api.g_varchar2
450: ,p_candidate_information18 in varchar2 default hr_api.g_varchar2
451: ,p_candidate_information19 in varchar2 default hr_api.g_varchar2
452: ,p_candidate_information20 in varchar2 default hr_api.g_varchar2
453: ,p_candidate_information21 in varchar2 default hr_api.g_varchar2
454: ,p_candidate_information22 in varchar2 default hr_api.g_varchar2
447: ,p_candidate_information15 in varchar2 default hr_api.g_varchar2
448: ,p_candidate_information16 in varchar2 default hr_api.g_varchar2
449: ,p_candidate_information17 in varchar2 default hr_api.g_varchar2
450: ,p_candidate_information18 in varchar2 default hr_api.g_varchar2
451: ,p_candidate_information19 in varchar2 default hr_api.g_varchar2
452: ,p_candidate_information20 in varchar2 default hr_api.g_varchar2
453: ,p_candidate_information21 in varchar2 default hr_api.g_varchar2
454: ,p_candidate_information22 in varchar2 default hr_api.g_varchar2
455: ,p_candidate_information23 in varchar2 default hr_api.g_varchar2
448: ,p_candidate_information16 in varchar2 default hr_api.g_varchar2
449: ,p_candidate_information17 in varchar2 default hr_api.g_varchar2
450: ,p_candidate_information18 in varchar2 default hr_api.g_varchar2
451: ,p_candidate_information19 in varchar2 default hr_api.g_varchar2
452: ,p_candidate_information20 in varchar2 default hr_api.g_varchar2
453: ,p_candidate_information21 in varchar2 default hr_api.g_varchar2
454: ,p_candidate_information22 in varchar2 default hr_api.g_varchar2
455: ,p_candidate_information23 in varchar2 default hr_api.g_varchar2
456: ,p_candidate_information24 in varchar2 default hr_api.g_varchar2
449: ,p_candidate_information17 in varchar2 default hr_api.g_varchar2
450: ,p_candidate_information18 in varchar2 default hr_api.g_varchar2
451: ,p_candidate_information19 in varchar2 default hr_api.g_varchar2
452: ,p_candidate_information20 in varchar2 default hr_api.g_varchar2
453: ,p_candidate_information21 in varchar2 default hr_api.g_varchar2
454: ,p_candidate_information22 in varchar2 default hr_api.g_varchar2
455: ,p_candidate_information23 in varchar2 default hr_api.g_varchar2
456: ,p_candidate_information24 in varchar2 default hr_api.g_varchar2
457: ,p_candidate_information25 in varchar2 default hr_api.g_varchar2
450: ,p_candidate_information18 in varchar2 default hr_api.g_varchar2
451: ,p_candidate_information19 in varchar2 default hr_api.g_varchar2
452: ,p_candidate_information20 in varchar2 default hr_api.g_varchar2
453: ,p_candidate_information21 in varchar2 default hr_api.g_varchar2
454: ,p_candidate_information22 in varchar2 default hr_api.g_varchar2
455: ,p_candidate_information23 in varchar2 default hr_api.g_varchar2
456: ,p_candidate_information24 in varchar2 default hr_api.g_varchar2
457: ,p_candidate_information25 in varchar2 default hr_api.g_varchar2
458: ,p_candidate_information26 in varchar2 default hr_api.g_varchar2
451: ,p_candidate_information19 in varchar2 default hr_api.g_varchar2
452: ,p_candidate_information20 in varchar2 default hr_api.g_varchar2
453: ,p_candidate_information21 in varchar2 default hr_api.g_varchar2
454: ,p_candidate_information22 in varchar2 default hr_api.g_varchar2
455: ,p_candidate_information23 in varchar2 default hr_api.g_varchar2
456: ,p_candidate_information24 in varchar2 default hr_api.g_varchar2
457: ,p_candidate_information25 in varchar2 default hr_api.g_varchar2
458: ,p_candidate_information26 in varchar2 default hr_api.g_varchar2
459: ,p_candidate_information27 in varchar2 default hr_api.g_varchar2
452: ,p_candidate_information20 in varchar2 default hr_api.g_varchar2
453: ,p_candidate_information21 in varchar2 default hr_api.g_varchar2
454: ,p_candidate_information22 in varchar2 default hr_api.g_varchar2
455: ,p_candidate_information23 in varchar2 default hr_api.g_varchar2
456: ,p_candidate_information24 in varchar2 default hr_api.g_varchar2
457: ,p_candidate_information25 in varchar2 default hr_api.g_varchar2
458: ,p_candidate_information26 in varchar2 default hr_api.g_varchar2
459: ,p_candidate_information27 in varchar2 default hr_api.g_varchar2
460: ,p_candidate_information28 in varchar2 default hr_api.g_varchar2
453: ,p_candidate_information21 in varchar2 default hr_api.g_varchar2
454: ,p_candidate_information22 in varchar2 default hr_api.g_varchar2
455: ,p_candidate_information23 in varchar2 default hr_api.g_varchar2
456: ,p_candidate_information24 in varchar2 default hr_api.g_varchar2
457: ,p_candidate_information25 in varchar2 default hr_api.g_varchar2
458: ,p_candidate_information26 in varchar2 default hr_api.g_varchar2
459: ,p_candidate_information27 in varchar2 default hr_api.g_varchar2
460: ,p_candidate_information28 in varchar2 default hr_api.g_varchar2
461: ,p_candidate_information29 in varchar2 default hr_api.g_varchar2
454: ,p_candidate_information22 in varchar2 default hr_api.g_varchar2
455: ,p_candidate_information23 in varchar2 default hr_api.g_varchar2
456: ,p_candidate_information24 in varchar2 default hr_api.g_varchar2
457: ,p_candidate_information25 in varchar2 default hr_api.g_varchar2
458: ,p_candidate_information26 in varchar2 default hr_api.g_varchar2
459: ,p_candidate_information27 in varchar2 default hr_api.g_varchar2
460: ,p_candidate_information28 in varchar2 default hr_api.g_varchar2
461: ,p_candidate_information29 in varchar2 default hr_api.g_varchar2
462: ,p_candidate_information30 in varchar2 default hr_api.g_varchar2
455: ,p_candidate_information23 in varchar2 default hr_api.g_varchar2
456: ,p_candidate_information24 in varchar2 default hr_api.g_varchar2
457: ,p_candidate_information25 in varchar2 default hr_api.g_varchar2
458: ,p_candidate_information26 in varchar2 default hr_api.g_varchar2
459: ,p_candidate_information27 in varchar2 default hr_api.g_varchar2
460: ,p_candidate_information28 in varchar2 default hr_api.g_varchar2
461: ,p_candidate_information29 in varchar2 default hr_api.g_varchar2
462: ,p_candidate_information30 in varchar2 default hr_api.g_varchar2
463: ) is
456: ,p_candidate_information24 in varchar2 default hr_api.g_varchar2
457: ,p_candidate_information25 in varchar2 default hr_api.g_varchar2
458: ,p_candidate_information26 in varchar2 default hr_api.g_varchar2
459: ,p_candidate_information27 in varchar2 default hr_api.g_varchar2
460: ,p_candidate_information28 in varchar2 default hr_api.g_varchar2
461: ,p_candidate_information29 in varchar2 default hr_api.g_varchar2
462: ,p_candidate_information30 in varchar2 default hr_api.g_varchar2
463: ) is
464: --
457: ,p_candidate_information25 in varchar2 default hr_api.g_varchar2
458: ,p_candidate_information26 in varchar2 default hr_api.g_varchar2
459: ,p_candidate_information27 in varchar2 default hr_api.g_varchar2
460: ,p_candidate_information28 in varchar2 default hr_api.g_varchar2
461: ,p_candidate_information29 in varchar2 default hr_api.g_varchar2
462: ,p_candidate_information30 in varchar2 default hr_api.g_varchar2
463: ) is
464: --
465: -- Declare cursors and local variables
458: ,p_candidate_information26 in varchar2 default hr_api.g_varchar2
459: ,p_candidate_information27 in varchar2 default hr_api.g_varchar2
460: ,p_candidate_information28 in varchar2 default hr_api.g_varchar2
461: ,p_candidate_information29 in varchar2 default hr_api.g_varchar2
462: ,p_candidate_information30 in varchar2 default hr_api.g_varchar2
463: ) is
464: --
465: -- Declare cursors and local variables
466: --
555: ,p_candidate_information28 => p_candidate_information28
556: ,p_candidate_information29 => p_candidate_information29
557: ,p_candidate_information30 => p_candidate_information30);
558: exception
559: when hr_api.cannot_find_prog_unit then
560: hr_api.cannot_find_prog_unit_error
561: (p_module_name => 'update_election_candidate_b'
562: ,p_hook_type => 'BP'
563: );
556: ,p_candidate_information29 => p_candidate_information29
557: ,p_candidate_information30 => p_candidate_information30);
558: exception
559: when hr_api.cannot_find_prog_unit then
560: hr_api.cannot_find_prog_unit_error
561: (p_module_name => 'update_election_candidate_b'
562: ,p_hook_type => 'BP'
563: );
564: end;
716: ,p_candidate_information29 => p_candidate_information29
717: ,p_candidate_information30 => p_candidate_information30
718: );
719: exception
720: when hr_api.cannot_find_prog_unit then
721: hr_api.cannot_find_prog_unit_error
722: (p_module_name => 'update_election_candidate_a'
723: ,p_hook_type => 'AP'
724: );
717: ,p_candidate_information30 => p_candidate_information30
718: );
719: exception
720: when hr_api.cannot_find_prog_unit then
721: hr_api.cannot_find_prog_unit_error
722: (p_module_name => 'update_election_candidate_a'
723: ,p_hook_type => 'AP'
724: );
725: end;
726: --
727: -- When in validation only mode raise the Validate_Enabled exception
728: --
729: if p_validate then
730: raise hr_api.validate_enabled;
731: end if;
732: --
733: -- Set all output arguments
734: --
735: p_object_version_number := l_object_version_number;
736: --
737: hr_utility.set_location(' Leaving:'||l_proc, 70);
738: exception
739: when hr_api.validate_enabled then
740: --
741: -- As the Validate_Enabled exception has been raised
742: -- we must rollback to the savepoint
743: --
803: ,p_object_version_number => l_object_version_number
804: );
805: --
806: exception
807: when hr_api.cannot_find_prog_unit then
808: hr_api.cannot_find_prog_unit_error
809: (p_module_name => 'delete_election_candidate_b'
810: ,p_hook_type => 'BP'
811: );
804: );
805: --
806: exception
807: when hr_api.cannot_find_prog_unit then
808: hr_api.cannot_find_prog_unit_error
809: (p_module_name => 'delete_election_candidate_b'
810: ,p_hook_type => 'BP'
811: );
812: --
827: (p_election_candidate_id => p_election_candidate_id
828: ,p_object_version_number => l_object_version_number
829: );
830: exception
831: when hr_api.cannot_find_prog_unit then
832: hr_api.cannot_find_prog_unit_error
833: (p_module_name => 'delete_election_candidate_a'
834: ,p_hook_type => 'AP'
835: );
828: ,p_object_version_number => l_object_version_number
829: );
830: exception
831: when hr_api.cannot_find_prog_unit then
832: hr_api.cannot_find_prog_unit_error
833: (p_module_name => 'delete_election_candidate_a'
834: ,p_hook_type => 'AP'
835: );
836: --
842: --
843: p_object_version_number := l_object_version_number;
844: --
845: if p_validate then
846: raise hr_api.validate_enabled;
847: end if;
848: --
849: -- Set all output arguments (returned by some dt modes only)
850: --
853: hr_utility.set_location(' Leaving:'||l_proc, 70);
854: --
855: exception
856: --
857: when hr_api.validate_enabled then
858: --
859: -- As the Validate_Enabled exception has been raised
860: -- we must rollback to the savepoint --
861: ROLLBACK TO delete_election_candidate;