105: -- Check that p_rep_body_id, p_business_group_id, election_date are not null.
106: --
107: hr_utility.set_location('Entering mandatory arg check', 20);
108: --
109: hr_api.mandatory_arg_error
110: (p_api_name => l_proc,
111: p_argument => 'rep_body_id',
112: p_argument_value => p_rep_body_id);
113: --
110: (p_api_name => l_proc,
111: p_argument => 'rep_body_id',
112: p_argument_value => p_rep_body_id);
113: --
114: hr_api.mandatory_arg_error
115: (p_api_name => l_proc,
116: p_argument => 'business_group_id',
117: p_argument_value => p_business_group_id);
118: --
115: (p_api_name => l_proc,
116: p_argument => 'business_group_id',
117: p_argument_value => p_business_group_id);
118: --
119: hr_api.mandatory_arg_error
120: (p_api_name => l_proc,
121: p_argument => 'effective_date',
122: p_argument_value => p_effective_date);
123: --
120: (p_api_name => l_proc,
121: p_argument => 'effective_date',
122: p_argument_value => p_effective_date);
123: --
124: hr_api.mandatory_arg_error
125: (p_api_name => l_proc,
126: p_argument => 'election_date',
127: p_argument_value => p_election_date);
128: --
205: ,p_election_information29 => p_election_information29
206: ,p_election_information30 => p_election_information30
207: );
208: exception
209: when hr_api.cannot_find_prog_unit then
210: hr_api.cannot_find_prog_unit_error
211: (p_module_name => 'CREATE_ELECTION_INFORMATION'
212: ,p_hook_type => 'BP'
213: );
206: ,p_election_information30 => p_election_information30
207: );
208: exception
209: when hr_api.cannot_find_prog_unit then
210: hr_api.cannot_find_prog_unit_error
211: (p_module_name => 'CREATE_ELECTION_INFORMATION'
212: ,p_hook_type => 'BP'
213: );
214:
370: ,p_object_version_number => l_object_version_number
371: );
372:
373: exception
374: when hr_api.cannot_find_prog_unit then
375: hr_api.cannot_find_prog_unit_error
376: (p_module_name => 'CREATE_ELECTION_INFORMATION'
377: ,p_hook_type => 'AP'
378: );
371: );
372:
373: exception
374: when hr_api.cannot_find_prog_unit then
375: hr_api.cannot_find_prog_unit_error
376: (p_module_name => 'CREATE_ELECTION_INFORMATION'
377: ,p_hook_type => 'AP'
378: );
379: end;
381: --
382: -- When in validation only mode raise the Validate_Enabled exception
383: --
384: if p_validate then
385: raise hr_api.validate_enabled;
386: end if;
387: --
388: -- Set all output arguments
389: --
391: p_object_version_number := l_object_version_number;
392: --
393: hr_utility.set_location(' Leaving:'||l_proc, 70);
394: exception
395: when hr_api.validate_enabled then
396: --
397: -- As the Validate_Enabled exception has been raised
398: -- we must rollback to the savepoint
399: --
435: ,p_business_group_id in number
436: ,p_election_date in date
437: ,p_description in varchar2
438: ,p_rep_body_id in number
439: ,p_previous_election_date in date default hr_api.g_date
440: ,p_next_election_date in date default hr_api.g_date
441: ,p_result_publish_date in date default hr_api.g_date
442: ,p_attribute_category in varchar2 default hr_api.g_varchar2
443: ,p_attribute1 in varchar2 default hr_api.g_varchar2
436: ,p_election_date in date
437: ,p_description in varchar2
438: ,p_rep_body_id in number
439: ,p_previous_election_date in date default hr_api.g_date
440: ,p_next_election_date in date default hr_api.g_date
441: ,p_result_publish_date in date default hr_api.g_date
442: ,p_attribute_category in varchar2 default hr_api.g_varchar2
443: ,p_attribute1 in varchar2 default hr_api.g_varchar2
444: ,p_attribute2 in varchar2 default hr_api.g_varchar2
437: ,p_description in varchar2
438: ,p_rep_body_id in number
439: ,p_previous_election_date in date default hr_api.g_date
440: ,p_next_election_date in date default hr_api.g_date
441: ,p_result_publish_date in date default hr_api.g_date
442: ,p_attribute_category in varchar2 default hr_api.g_varchar2
443: ,p_attribute1 in varchar2 default hr_api.g_varchar2
444: ,p_attribute2 in varchar2 default hr_api.g_varchar2
445: ,p_attribute3 in varchar2 default hr_api.g_varchar2
438: ,p_rep_body_id in number
439: ,p_previous_election_date in date default hr_api.g_date
440: ,p_next_election_date in date default hr_api.g_date
441: ,p_result_publish_date in date default hr_api.g_date
442: ,p_attribute_category in varchar2 default hr_api.g_varchar2
443: ,p_attribute1 in varchar2 default hr_api.g_varchar2
444: ,p_attribute2 in varchar2 default hr_api.g_varchar2
445: ,p_attribute3 in varchar2 default hr_api.g_varchar2
446: ,p_attribute4 in varchar2 default hr_api.g_varchar2
439: ,p_previous_election_date in date default hr_api.g_date
440: ,p_next_election_date in date default hr_api.g_date
441: ,p_result_publish_date in date default hr_api.g_date
442: ,p_attribute_category in varchar2 default hr_api.g_varchar2
443: ,p_attribute1 in varchar2 default hr_api.g_varchar2
444: ,p_attribute2 in varchar2 default hr_api.g_varchar2
445: ,p_attribute3 in varchar2 default hr_api.g_varchar2
446: ,p_attribute4 in varchar2 default hr_api.g_varchar2
447: ,p_attribute5 in varchar2 default hr_api.g_varchar2
440: ,p_next_election_date in date default hr_api.g_date
441: ,p_result_publish_date in date default hr_api.g_date
442: ,p_attribute_category in varchar2 default hr_api.g_varchar2
443: ,p_attribute1 in varchar2 default hr_api.g_varchar2
444: ,p_attribute2 in varchar2 default hr_api.g_varchar2
445: ,p_attribute3 in varchar2 default hr_api.g_varchar2
446: ,p_attribute4 in varchar2 default hr_api.g_varchar2
447: ,p_attribute5 in varchar2 default hr_api.g_varchar2
448: ,p_attribute6 in varchar2 default hr_api.g_varchar2
441: ,p_result_publish_date in date default hr_api.g_date
442: ,p_attribute_category in varchar2 default hr_api.g_varchar2
443: ,p_attribute1 in varchar2 default hr_api.g_varchar2
444: ,p_attribute2 in varchar2 default hr_api.g_varchar2
445: ,p_attribute3 in varchar2 default hr_api.g_varchar2
446: ,p_attribute4 in varchar2 default hr_api.g_varchar2
447: ,p_attribute5 in varchar2 default hr_api.g_varchar2
448: ,p_attribute6 in varchar2 default hr_api.g_varchar2
449: ,p_attribute7 in varchar2 default hr_api.g_varchar2
442: ,p_attribute_category in varchar2 default hr_api.g_varchar2
443: ,p_attribute1 in varchar2 default hr_api.g_varchar2
444: ,p_attribute2 in varchar2 default hr_api.g_varchar2
445: ,p_attribute3 in varchar2 default hr_api.g_varchar2
446: ,p_attribute4 in varchar2 default hr_api.g_varchar2
447: ,p_attribute5 in varchar2 default hr_api.g_varchar2
448: ,p_attribute6 in varchar2 default hr_api.g_varchar2
449: ,p_attribute7 in varchar2 default hr_api.g_varchar2
450: ,p_attribute8 in varchar2 default hr_api.g_varchar2
443: ,p_attribute1 in varchar2 default hr_api.g_varchar2
444: ,p_attribute2 in varchar2 default hr_api.g_varchar2
445: ,p_attribute3 in varchar2 default hr_api.g_varchar2
446: ,p_attribute4 in varchar2 default hr_api.g_varchar2
447: ,p_attribute5 in varchar2 default hr_api.g_varchar2
448: ,p_attribute6 in varchar2 default hr_api.g_varchar2
449: ,p_attribute7 in varchar2 default hr_api.g_varchar2
450: ,p_attribute8 in varchar2 default hr_api.g_varchar2
451: ,p_attribute9 in varchar2 default hr_api.g_varchar2
444: ,p_attribute2 in varchar2 default hr_api.g_varchar2
445: ,p_attribute3 in varchar2 default hr_api.g_varchar2
446: ,p_attribute4 in varchar2 default hr_api.g_varchar2
447: ,p_attribute5 in varchar2 default hr_api.g_varchar2
448: ,p_attribute6 in varchar2 default hr_api.g_varchar2
449: ,p_attribute7 in varchar2 default hr_api.g_varchar2
450: ,p_attribute8 in varchar2 default hr_api.g_varchar2
451: ,p_attribute9 in varchar2 default hr_api.g_varchar2
452: ,p_attribute10 in varchar2 default hr_api.g_varchar2
445: ,p_attribute3 in varchar2 default hr_api.g_varchar2
446: ,p_attribute4 in varchar2 default hr_api.g_varchar2
447: ,p_attribute5 in varchar2 default hr_api.g_varchar2
448: ,p_attribute6 in varchar2 default hr_api.g_varchar2
449: ,p_attribute7 in varchar2 default hr_api.g_varchar2
450: ,p_attribute8 in varchar2 default hr_api.g_varchar2
451: ,p_attribute9 in varchar2 default hr_api.g_varchar2
452: ,p_attribute10 in varchar2 default hr_api.g_varchar2
453: ,p_attribute11 in varchar2 default hr_api.g_varchar2
446: ,p_attribute4 in varchar2 default hr_api.g_varchar2
447: ,p_attribute5 in varchar2 default hr_api.g_varchar2
448: ,p_attribute6 in varchar2 default hr_api.g_varchar2
449: ,p_attribute7 in varchar2 default hr_api.g_varchar2
450: ,p_attribute8 in varchar2 default hr_api.g_varchar2
451: ,p_attribute9 in varchar2 default hr_api.g_varchar2
452: ,p_attribute10 in varchar2 default hr_api.g_varchar2
453: ,p_attribute11 in varchar2 default hr_api.g_varchar2
454: ,p_attribute12 in varchar2 default hr_api.g_varchar2
447: ,p_attribute5 in varchar2 default hr_api.g_varchar2
448: ,p_attribute6 in varchar2 default hr_api.g_varchar2
449: ,p_attribute7 in varchar2 default hr_api.g_varchar2
450: ,p_attribute8 in varchar2 default hr_api.g_varchar2
451: ,p_attribute9 in varchar2 default hr_api.g_varchar2
452: ,p_attribute10 in varchar2 default hr_api.g_varchar2
453: ,p_attribute11 in varchar2 default hr_api.g_varchar2
454: ,p_attribute12 in varchar2 default hr_api.g_varchar2
455: ,p_attribute13 in varchar2 default hr_api.g_varchar2
448: ,p_attribute6 in varchar2 default hr_api.g_varchar2
449: ,p_attribute7 in varchar2 default hr_api.g_varchar2
450: ,p_attribute8 in varchar2 default hr_api.g_varchar2
451: ,p_attribute9 in varchar2 default hr_api.g_varchar2
452: ,p_attribute10 in varchar2 default hr_api.g_varchar2
453: ,p_attribute11 in varchar2 default hr_api.g_varchar2
454: ,p_attribute12 in varchar2 default hr_api.g_varchar2
455: ,p_attribute13 in varchar2 default hr_api.g_varchar2
456: ,p_attribute14 in varchar2 default hr_api.g_varchar2
449: ,p_attribute7 in varchar2 default hr_api.g_varchar2
450: ,p_attribute8 in varchar2 default hr_api.g_varchar2
451: ,p_attribute9 in varchar2 default hr_api.g_varchar2
452: ,p_attribute10 in varchar2 default hr_api.g_varchar2
453: ,p_attribute11 in varchar2 default hr_api.g_varchar2
454: ,p_attribute12 in varchar2 default hr_api.g_varchar2
455: ,p_attribute13 in varchar2 default hr_api.g_varchar2
456: ,p_attribute14 in varchar2 default hr_api.g_varchar2
457: ,p_attribute15 in varchar2 default hr_api.g_varchar2
450: ,p_attribute8 in varchar2 default hr_api.g_varchar2
451: ,p_attribute9 in varchar2 default hr_api.g_varchar2
452: ,p_attribute10 in varchar2 default hr_api.g_varchar2
453: ,p_attribute11 in varchar2 default hr_api.g_varchar2
454: ,p_attribute12 in varchar2 default hr_api.g_varchar2
455: ,p_attribute13 in varchar2 default hr_api.g_varchar2
456: ,p_attribute14 in varchar2 default hr_api.g_varchar2
457: ,p_attribute15 in varchar2 default hr_api.g_varchar2
458: ,p_attribute16 in varchar2 default hr_api.g_varchar2
451: ,p_attribute9 in varchar2 default hr_api.g_varchar2
452: ,p_attribute10 in varchar2 default hr_api.g_varchar2
453: ,p_attribute11 in varchar2 default hr_api.g_varchar2
454: ,p_attribute12 in varchar2 default hr_api.g_varchar2
455: ,p_attribute13 in varchar2 default hr_api.g_varchar2
456: ,p_attribute14 in varchar2 default hr_api.g_varchar2
457: ,p_attribute15 in varchar2 default hr_api.g_varchar2
458: ,p_attribute16 in varchar2 default hr_api.g_varchar2
459: ,p_attribute17 in varchar2 default hr_api.g_varchar2
452: ,p_attribute10 in varchar2 default hr_api.g_varchar2
453: ,p_attribute11 in varchar2 default hr_api.g_varchar2
454: ,p_attribute12 in varchar2 default hr_api.g_varchar2
455: ,p_attribute13 in varchar2 default hr_api.g_varchar2
456: ,p_attribute14 in varchar2 default hr_api.g_varchar2
457: ,p_attribute15 in varchar2 default hr_api.g_varchar2
458: ,p_attribute16 in varchar2 default hr_api.g_varchar2
459: ,p_attribute17 in varchar2 default hr_api.g_varchar2
460: ,p_attribute18 in varchar2 default hr_api.g_varchar2
453: ,p_attribute11 in varchar2 default hr_api.g_varchar2
454: ,p_attribute12 in varchar2 default hr_api.g_varchar2
455: ,p_attribute13 in varchar2 default hr_api.g_varchar2
456: ,p_attribute14 in varchar2 default hr_api.g_varchar2
457: ,p_attribute15 in varchar2 default hr_api.g_varchar2
458: ,p_attribute16 in varchar2 default hr_api.g_varchar2
459: ,p_attribute17 in varchar2 default hr_api.g_varchar2
460: ,p_attribute18 in varchar2 default hr_api.g_varchar2
461: ,p_attribute19 in varchar2 default hr_api.g_varchar2
454: ,p_attribute12 in varchar2 default hr_api.g_varchar2
455: ,p_attribute13 in varchar2 default hr_api.g_varchar2
456: ,p_attribute14 in varchar2 default hr_api.g_varchar2
457: ,p_attribute15 in varchar2 default hr_api.g_varchar2
458: ,p_attribute16 in varchar2 default hr_api.g_varchar2
459: ,p_attribute17 in varchar2 default hr_api.g_varchar2
460: ,p_attribute18 in varchar2 default hr_api.g_varchar2
461: ,p_attribute19 in varchar2 default hr_api.g_varchar2
462: ,p_attribute20 in varchar2 default hr_api.g_varchar2
455: ,p_attribute13 in varchar2 default hr_api.g_varchar2
456: ,p_attribute14 in varchar2 default hr_api.g_varchar2
457: ,p_attribute15 in varchar2 default hr_api.g_varchar2
458: ,p_attribute16 in varchar2 default hr_api.g_varchar2
459: ,p_attribute17 in varchar2 default hr_api.g_varchar2
460: ,p_attribute18 in varchar2 default hr_api.g_varchar2
461: ,p_attribute19 in varchar2 default hr_api.g_varchar2
462: ,p_attribute20 in varchar2 default hr_api.g_varchar2
463: ,p_attribute21 in varchar2 default hr_api.g_varchar2
456: ,p_attribute14 in varchar2 default hr_api.g_varchar2
457: ,p_attribute15 in varchar2 default hr_api.g_varchar2
458: ,p_attribute16 in varchar2 default hr_api.g_varchar2
459: ,p_attribute17 in varchar2 default hr_api.g_varchar2
460: ,p_attribute18 in varchar2 default hr_api.g_varchar2
461: ,p_attribute19 in varchar2 default hr_api.g_varchar2
462: ,p_attribute20 in varchar2 default hr_api.g_varchar2
463: ,p_attribute21 in varchar2 default hr_api.g_varchar2
464: ,p_attribute22 in varchar2 default hr_api.g_varchar2
457: ,p_attribute15 in varchar2 default hr_api.g_varchar2
458: ,p_attribute16 in varchar2 default hr_api.g_varchar2
459: ,p_attribute17 in varchar2 default hr_api.g_varchar2
460: ,p_attribute18 in varchar2 default hr_api.g_varchar2
461: ,p_attribute19 in varchar2 default hr_api.g_varchar2
462: ,p_attribute20 in varchar2 default hr_api.g_varchar2
463: ,p_attribute21 in varchar2 default hr_api.g_varchar2
464: ,p_attribute22 in varchar2 default hr_api.g_varchar2
465: ,p_attribute23 in varchar2 default hr_api.g_varchar2
458: ,p_attribute16 in varchar2 default hr_api.g_varchar2
459: ,p_attribute17 in varchar2 default hr_api.g_varchar2
460: ,p_attribute18 in varchar2 default hr_api.g_varchar2
461: ,p_attribute19 in varchar2 default hr_api.g_varchar2
462: ,p_attribute20 in varchar2 default hr_api.g_varchar2
463: ,p_attribute21 in varchar2 default hr_api.g_varchar2
464: ,p_attribute22 in varchar2 default hr_api.g_varchar2
465: ,p_attribute23 in varchar2 default hr_api.g_varchar2
466: ,p_attribute24 in varchar2 default hr_api.g_varchar2
459: ,p_attribute17 in varchar2 default hr_api.g_varchar2
460: ,p_attribute18 in varchar2 default hr_api.g_varchar2
461: ,p_attribute19 in varchar2 default hr_api.g_varchar2
462: ,p_attribute20 in varchar2 default hr_api.g_varchar2
463: ,p_attribute21 in varchar2 default hr_api.g_varchar2
464: ,p_attribute22 in varchar2 default hr_api.g_varchar2
465: ,p_attribute23 in varchar2 default hr_api.g_varchar2
466: ,p_attribute24 in varchar2 default hr_api.g_varchar2
467: ,p_attribute25 in varchar2 default hr_api.g_varchar2
460: ,p_attribute18 in varchar2 default hr_api.g_varchar2
461: ,p_attribute19 in varchar2 default hr_api.g_varchar2
462: ,p_attribute20 in varchar2 default hr_api.g_varchar2
463: ,p_attribute21 in varchar2 default hr_api.g_varchar2
464: ,p_attribute22 in varchar2 default hr_api.g_varchar2
465: ,p_attribute23 in varchar2 default hr_api.g_varchar2
466: ,p_attribute24 in varchar2 default hr_api.g_varchar2
467: ,p_attribute25 in varchar2 default hr_api.g_varchar2
468: ,p_attribute26 in varchar2 default hr_api.g_varchar2
461: ,p_attribute19 in varchar2 default hr_api.g_varchar2
462: ,p_attribute20 in varchar2 default hr_api.g_varchar2
463: ,p_attribute21 in varchar2 default hr_api.g_varchar2
464: ,p_attribute22 in varchar2 default hr_api.g_varchar2
465: ,p_attribute23 in varchar2 default hr_api.g_varchar2
466: ,p_attribute24 in varchar2 default hr_api.g_varchar2
467: ,p_attribute25 in varchar2 default hr_api.g_varchar2
468: ,p_attribute26 in varchar2 default hr_api.g_varchar2
469: ,p_attribute27 in varchar2 default hr_api.g_varchar2
462: ,p_attribute20 in varchar2 default hr_api.g_varchar2
463: ,p_attribute21 in varchar2 default hr_api.g_varchar2
464: ,p_attribute22 in varchar2 default hr_api.g_varchar2
465: ,p_attribute23 in varchar2 default hr_api.g_varchar2
466: ,p_attribute24 in varchar2 default hr_api.g_varchar2
467: ,p_attribute25 in varchar2 default hr_api.g_varchar2
468: ,p_attribute26 in varchar2 default hr_api.g_varchar2
469: ,p_attribute27 in varchar2 default hr_api.g_varchar2
470: ,p_attribute28 in varchar2 default hr_api.g_varchar2
463: ,p_attribute21 in varchar2 default hr_api.g_varchar2
464: ,p_attribute22 in varchar2 default hr_api.g_varchar2
465: ,p_attribute23 in varchar2 default hr_api.g_varchar2
466: ,p_attribute24 in varchar2 default hr_api.g_varchar2
467: ,p_attribute25 in varchar2 default hr_api.g_varchar2
468: ,p_attribute26 in varchar2 default hr_api.g_varchar2
469: ,p_attribute27 in varchar2 default hr_api.g_varchar2
470: ,p_attribute28 in varchar2 default hr_api.g_varchar2
471: ,p_attribute29 in varchar2 default hr_api.g_varchar2
464: ,p_attribute22 in varchar2 default hr_api.g_varchar2
465: ,p_attribute23 in varchar2 default hr_api.g_varchar2
466: ,p_attribute24 in varchar2 default hr_api.g_varchar2
467: ,p_attribute25 in varchar2 default hr_api.g_varchar2
468: ,p_attribute26 in varchar2 default hr_api.g_varchar2
469: ,p_attribute27 in varchar2 default hr_api.g_varchar2
470: ,p_attribute28 in varchar2 default hr_api.g_varchar2
471: ,p_attribute29 in varchar2 default hr_api.g_varchar2
472: ,p_attribute30 in varchar2 default hr_api.g_varchar2
465: ,p_attribute23 in varchar2 default hr_api.g_varchar2
466: ,p_attribute24 in varchar2 default hr_api.g_varchar2
467: ,p_attribute25 in varchar2 default hr_api.g_varchar2
468: ,p_attribute26 in varchar2 default hr_api.g_varchar2
469: ,p_attribute27 in varchar2 default hr_api.g_varchar2
470: ,p_attribute28 in varchar2 default hr_api.g_varchar2
471: ,p_attribute29 in varchar2 default hr_api.g_varchar2
472: ,p_attribute30 in varchar2 default hr_api.g_varchar2
473: ,p_election_info_category in varchar2 default hr_api.g_varchar2
466: ,p_attribute24 in varchar2 default hr_api.g_varchar2
467: ,p_attribute25 in varchar2 default hr_api.g_varchar2
468: ,p_attribute26 in varchar2 default hr_api.g_varchar2
469: ,p_attribute27 in varchar2 default hr_api.g_varchar2
470: ,p_attribute28 in varchar2 default hr_api.g_varchar2
471: ,p_attribute29 in varchar2 default hr_api.g_varchar2
472: ,p_attribute30 in varchar2 default hr_api.g_varchar2
473: ,p_election_info_category in varchar2 default hr_api.g_varchar2
474: ,p_election_information1 in varchar2 default hr_api.g_varchar2
467: ,p_attribute25 in varchar2 default hr_api.g_varchar2
468: ,p_attribute26 in varchar2 default hr_api.g_varchar2
469: ,p_attribute27 in varchar2 default hr_api.g_varchar2
470: ,p_attribute28 in varchar2 default hr_api.g_varchar2
471: ,p_attribute29 in varchar2 default hr_api.g_varchar2
472: ,p_attribute30 in varchar2 default hr_api.g_varchar2
473: ,p_election_info_category in varchar2 default hr_api.g_varchar2
474: ,p_election_information1 in varchar2 default hr_api.g_varchar2
475: ,p_election_information2 in varchar2 default hr_api.g_varchar2
468: ,p_attribute26 in varchar2 default hr_api.g_varchar2
469: ,p_attribute27 in varchar2 default hr_api.g_varchar2
470: ,p_attribute28 in varchar2 default hr_api.g_varchar2
471: ,p_attribute29 in varchar2 default hr_api.g_varchar2
472: ,p_attribute30 in varchar2 default hr_api.g_varchar2
473: ,p_election_info_category in varchar2 default hr_api.g_varchar2
474: ,p_election_information1 in varchar2 default hr_api.g_varchar2
475: ,p_election_information2 in varchar2 default hr_api.g_varchar2
476: ,p_election_information3 in varchar2 default hr_api.g_varchar2
469: ,p_attribute27 in varchar2 default hr_api.g_varchar2
470: ,p_attribute28 in varchar2 default hr_api.g_varchar2
471: ,p_attribute29 in varchar2 default hr_api.g_varchar2
472: ,p_attribute30 in varchar2 default hr_api.g_varchar2
473: ,p_election_info_category in varchar2 default hr_api.g_varchar2
474: ,p_election_information1 in varchar2 default hr_api.g_varchar2
475: ,p_election_information2 in varchar2 default hr_api.g_varchar2
476: ,p_election_information3 in varchar2 default hr_api.g_varchar2
477: ,p_election_information4 in varchar2 default hr_api.g_varchar2
470: ,p_attribute28 in varchar2 default hr_api.g_varchar2
471: ,p_attribute29 in varchar2 default hr_api.g_varchar2
472: ,p_attribute30 in varchar2 default hr_api.g_varchar2
473: ,p_election_info_category in varchar2 default hr_api.g_varchar2
474: ,p_election_information1 in varchar2 default hr_api.g_varchar2
475: ,p_election_information2 in varchar2 default hr_api.g_varchar2
476: ,p_election_information3 in varchar2 default hr_api.g_varchar2
477: ,p_election_information4 in varchar2 default hr_api.g_varchar2
478: ,p_election_information5 in varchar2 default hr_api.g_varchar2
471: ,p_attribute29 in varchar2 default hr_api.g_varchar2
472: ,p_attribute30 in varchar2 default hr_api.g_varchar2
473: ,p_election_info_category in varchar2 default hr_api.g_varchar2
474: ,p_election_information1 in varchar2 default hr_api.g_varchar2
475: ,p_election_information2 in varchar2 default hr_api.g_varchar2
476: ,p_election_information3 in varchar2 default hr_api.g_varchar2
477: ,p_election_information4 in varchar2 default hr_api.g_varchar2
478: ,p_election_information5 in varchar2 default hr_api.g_varchar2
479: ,p_election_information6 in varchar2 default hr_api.g_varchar2
472: ,p_attribute30 in varchar2 default hr_api.g_varchar2
473: ,p_election_info_category in varchar2 default hr_api.g_varchar2
474: ,p_election_information1 in varchar2 default hr_api.g_varchar2
475: ,p_election_information2 in varchar2 default hr_api.g_varchar2
476: ,p_election_information3 in varchar2 default hr_api.g_varchar2
477: ,p_election_information4 in varchar2 default hr_api.g_varchar2
478: ,p_election_information5 in varchar2 default hr_api.g_varchar2
479: ,p_election_information6 in varchar2 default hr_api.g_varchar2
480: ,p_election_information7 in varchar2 default hr_api.g_varchar2
473: ,p_election_info_category in varchar2 default hr_api.g_varchar2
474: ,p_election_information1 in varchar2 default hr_api.g_varchar2
475: ,p_election_information2 in varchar2 default hr_api.g_varchar2
476: ,p_election_information3 in varchar2 default hr_api.g_varchar2
477: ,p_election_information4 in varchar2 default hr_api.g_varchar2
478: ,p_election_information5 in varchar2 default hr_api.g_varchar2
479: ,p_election_information6 in varchar2 default hr_api.g_varchar2
480: ,p_election_information7 in varchar2 default hr_api.g_varchar2
481: ,p_election_information8 in varchar2 default hr_api.g_varchar2
474: ,p_election_information1 in varchar2 default hr_api.g_varchar2
475: ,p_election_information2 in varchar2 default hr_api.g_varchar2
476: ,p_election_information3 in varchar2 default hr_api.g_varchar2
477: ,p_election_information4 in varchar2 default hr_api.g_varchar2
478: ,p_election_information5 in varchar2 default hr_api.g_varchar2
479: ,p_election_information6 in varchar2 default hr_api.g_varchar2
480: ,p_election_information7 in varchar2 default hr_api.g_varchar2
481: ,p_election_information8 in varchar2 default hr_api.g_varchar2
482: ,p_election_information9 in varchar2 default hr_api.g_varchar2
475: ,p_election_information2 in varchar2 default hr_api.g_varchar2
476: ,p_election_information3 in varchar2 default hr_api.g_varchar2
477: ,p_election_information4 in varchar2 default hr_api.g_varchar2
478: ,p_election_information5 in varchar2 default hr_api.g_varchar2
479: ,p_election_information6 in varchar2 default hr_api.g_varchar2
480: ,p_election_information7 in varchar2 default hr_api.g_varchar2
481: ,p_election_information8 in varchar2 default hr_api.g_varchar2
482: ,p_election_information9 in varchar2 default hr_api.g_varchar2
483: ,p_election_information10 in varchar2 default hr_api.g_varchar2
476: ,p_election_information3 in varchar2 default hr_api.g_varchar2
477: ,p_election_information4 in varchar2 default hr_api.g_varchar2
478: ,p_election_information5 in varchar2 default hr_api.g_varchar2
479: ,p_election_information6 in varchar2 default hr_api.g_varchar2
480: ,p_election_information7 in varchar2 default hr_api.g_varchar2
481: ,p_election_information8 in varchar2 default hr_api.g_varchar2
482: ,p_election_information9 in varchar2 default hr_api.g_varchar2
483: ,p_election_information10 in varchar2 default hr_api.g_varchar2
484: ,p_election_information11 in varchar2 default hr_api.g_varchar2
477: ,p_election_information4 in varchar2 default hr_api.g_varchar2
478: ,p_election_information5 in varchar2 default hr_api.g_varchar2
479: ,p_election_information6 in varchar2 default hr_api.g_varchar2
480: ,p_election_information7 in varchar2 default hr_api.g_varchar2
481: ,p_election_information8 in varchar2 default hr_api.g_varchar2
482: ,p_election_information9 in varchar2 default hr_api.g_varchar2
483: ,p_election_information10 in varchar2 default hr_api.g_varchar2
484: ,p_election_information11 in varchar2 default hr_api.g_varchar2
485: ,p_election_information12 in varchar2 default hr_api.g_varchar2
478: ,p_election_information5 in varchar2 default hr_api.g_varchar2
479: ,p_election_information6 in varchar2 default hr_api.g_varchar2
480: ,p_election_information7 in varchar2 default hr_api.g_varchar2
481: ,p_election_information8 in varchar2 default hr_api.g_varchar2
482: ,p_election_information9 in varchar2 default hr_api.g_varchar2
483: ,p_election_information10 in varchar2 default hr_api.g_varchar2
484: ,p_election_information11 in varchar2 default hr_api.g_varchar2
485: ,p_election_information12 in varchar2 default hr_api.g_varchar2
486: ,p_election_information13 in varchar2 default hr_api.g_varchar2
479: ,p_election_information6 in varchar2 default hr_api.g_varchar2
480: ,p_election_information7 in varchar2 default hr_api.g_varchar2
481: ,p_election_information8 in varchar2 default hr_api.g_varchar2
482: ,p_election_information9 in varchar2 default hr_api.g_varchar2
483: ,p_election_information10 in varchar2 default hr_api.g_varchar2
484: ,p_election_information11 in varchar2 default hr_api.g_varchar2
485: ,p_election_information12 in varchar2 default hr_api.g_varchar2
486: ,p_election_information13 in varchar2 default hr_api.g_varchar2
487: ,p_election_information14 in varchar2 default hr_api.g_varchar2
480: ,p_election_information7 in varchar2 default hr_api.g_varchar2
481: ,p_election_information8 in varchar2 default hr_api.g_varchar2
482: ,p_election_information9 in varchar2 default hr_api.g_varchar2
483: ,p_election_information10 in varchar2 default hr_api.g_varchar2
484: ,p_election_information11 in varchar2 default hr_api.g_varchar2
485: ,p_election_information12 in varchar2 default hr_api.g_varchar2
486: ,p_election_information13 in varchar2 default hr_api.g_varchar2
487: ,p_election_information14 in varchar2 default hr_api.g_varchar2
488: ,p_election_information15 in varchar2 default hr_api.g_varchar2
481: ,p_election_information8 in varchar2 default hr_api.g_varchar2
482: ,p_election_information9 in varchar2 default hr_api.g_varchar2
483: ,p_election_information10 in varchar2 default hr_api.g_varchar2
484: ,p_election_information11 in varchar2 default hr_api.g_varchar2
485: ,p_election_information12 in varchar2 default hr_api.g_varchar2
486: ,p_election_information13 in varchar2 default hr_api.g_varchar2
487: ,p_election_information14 in varchar2 default hr_api.g_varchar2
488: ,p_election_information15 in varchar2 default hr_api.g_varchar2
489: ,p_election_information16 in varchar2 default hr_api.g_varchar2
482: ,p_election_information9 in varchar2 default hr_api.g_varchar2
483: ,p_election_information10 in varchar2 default hr_api.g_varchar2
484: ,p_election_information11 in varchar2 default hr_api.g_varchar2
485: ,p_election_information12 in varchar2 default hr_api.g_varchar2
486: ,p_election_information13 in varchar2 default hr_api.g_varchar2
487: ,p_election_information14 in varchar2 default hr_api.g_varchar2
488: ,p_election_information15 in varchar2 default hr_api.g_varchar2
489: ,p_election_information16 in varchar2 default hr_api.g_varchar2
490: ,p_election_information17 in varchar2 default hr_api.g_varchar2
483: ,p_election_information10 in varchar2 default hr_api.g_varchar2
484: ,p_election_information11 in varchar2 default hr_api.g_varchar2
485: ,p_election_information12 in varchar2 default hr_api.g_varchar2
486: ,p_election_information13 in varchar2 default hr_api.g_varchar2
487: ,p_election_information14 in varchar2 default hr_api.g_varchar2
488: ,p_election_information15 in varchar2 default hr_api.g_varchar2
489: ,p_election_information16 in varchar2 default hr_api.g_varchar2
490: ,p_election_information17 in varchar2 default hr_api.g_varchar2
491: ,p_election_information18 in varchar2 default hr_api.g_varchar2
484: ,p_election_information11 in varchar2 default hr_api.g_varchar2
485: ,p_election_information12 in varchar2 default hr_api.g_varchar2
486: ,p_election_information13 in varchar2 default hr_api.g_varchar2
487: ,p_election_information14 in varchar2 default hr_api.g_varchar2
488: ,p_election_information15 in varchar2 default hr_api.g_varchar2
489: ,p_election_information16 in varchar2 default hr_api.g_varchar2
490: ,p_election_information17 in varchar2 default hr_api.g_varchar2
491: ,p_election_information18 in varchar2 default hr_api.g_varchar2
492: ,p_election_information19 in varchar2 default hr_api.g_varchar2
485: ,p_election_information12 in varchar2 default hr_api.g_varchar2
486: ,p_election_information13 in varchar2 default hr_api.g_varchar2
487: ,p_election_information14 in varchar2 default hr_api.g_varchar2
488: ,p_election_information15 in varchar2 default hr_api.g_varchar2
489: ,p_election_information16 in varchar2 default hr_api.g_varchar2
490: ,p_election_information17 in varchar2 default hr_api.g_varchar2
491: ,p_election_information18 in varchar2 default hr_api.g_varchar2
492: ,p_election_information19 in varchar2 default hr_api.g_varchar2
493: ,p_election_information20 in varchar2 default hr_api.g_varchar2
486: ,p_election_information13 in varchar2 default hr_api.g_varchar2
487: ,p_election_information14 in varchar2 default hr_api.g_varchar2
488: ,p_election_information15 in varchar2 default hr_api.g_varchar2
489: ,p_election_information16 in varchar2 default hr_api.g_varchar2
490: ,p_election_information17 in varchar2 default hr_api.g_varchar2
491: ,p_election_information18 in varchar2 default hr_api.g_varchar2
492: ,p_election_information19 in varchar2 default hr_api.g_varchar2
493: ,p_election_information20 in varchar2 default hr_api.g_varchar2
494: ,p_election_information21 in varchar2 default hr_api.g_varchar2
487: ,p_election_information14 in varchar2 default hr_api.g_varchar2
488: ,p_election_information15 in varchar2 default hr_api.g_varchar2
489: ,p_election_information16 in varchar2 default hr_api.g_varchar2
490: ,p_election_information17 in varchar2 default hr_api.g_varchar2
491: ,p_election_information18 in varchar2 default hr_api.g_varchar2
492: ,p_election_information19 in varchar2 default hr_api.g_varchar2
493: ,p_election_information20 in varchar2 default hr_api.g_varchar2
494: ,p_election_information21 in varchar2 default hr_api.g_varchar2
495: ,p_election_information22 in varchar2 default hr_api.g_varchar2
488: ,p_election_information15 in varchar2 default hr_api.g_varchar2
489: ,p_election_information16 in varchar2 default hr_api.g_varchar2
490: ,p_election_information17 in varchar2 default hr_api.g_varchar2
491: ,p_election_information18 in varchar2 default hr_api.g_varchar2
492: ,p_election_information19 in varchar2 default hr_api.g_varchar2
493: ,p_election_information20 in varchar2 default hr_api.g_varchar2
494: ,p_election_information21 in varchar2 default hr_api.g_varchar2
495: ,p_election_information22 in varchar2 default hr_api.g_varchar2
496: ,p_election_information23 in varchar2 default hr_api.g_varchar2
489: ,p_election_information16 in varchar2 default hr_api.g_varchar2
490: ,p_election_information17 in varchar2 default hr_api.g_varchar2
491: ,p_election_information18 in varchar2 default hr_api.g_varchar2
492: ,p_election_information19 in varchar2 default hr_api.g_varchar2
493: ,p_election_information20 in varchar2 default hr_api.g_varchar2
494: ,p_election_information21 in varchar2 default hr_api.g_varchar2
495: ,p_election_information22 in varchar2 default hr_api.g_varchar2
496: ,p_election_information23 in varchar2 default hr_api.g_varchar2
497: ,p_election_information24 in varchar2 default hr_api.g_varchar2
490: ,p_election_information17 in varchar2 default hr_api.g_varchar2
491: ,p_election_information18 in varchar2 default hr_api.g_varchar2
492: ,p_election_information19 in varchar2 default hr_api.g_varchar2
493: ,p_election_information20 in varchar2 default hr_api.g_varchar2
494: ,p_election_information21 in varchar2 default hr_api.g_varchar2
495: ,p_election_information22 in varchar2 default hr_api.g_varchar2
496: ,p_election_information23 in varchar2 default hr_api.g_varchar2
497: ,p_election_information24 in varchar2 default hr_api.g_varchar2
498: ,p_election_information25 in varchar2 default hr_api.g_varchar2
491: ,p_election_information18 in varchar2 default hr_api.g_varchar2
492: ,p_election_information19 in varchar2 default hr_api.g_varchar2
493: ,p_election_information20 in varchar2 default hr_api.g_varchar2
494: ,p_election_information21 in varchar2 default hr_api.g_varchar2
495: ,p_election_information22 in varchar2 default hr_api.g_varchar2
496: ,p_election_information23 in varchar2 default hr_api.g_varchar2
497: ,p_election_information24 in varchar2 default hr_api.g_varchar2
498: ,p_election_information25 in varchar2 default hr_api.g_varchar2
499: ,p_election_information26 in varchar2 default hr_api.g_varchar2
492: ,p_election_information19 in varchar2 default hr_api.g_varchar2
493: ,p_election_information20 in varchar2 default hr_api.g_varchar2
494: ,p_election_information21 in varchar2 default hr_api.g_varchar2
495: ,p_election_information22 in varchar2 default hr_api.g_varchar2
496: ,p_election_information23 in varchar2 default hr_api.g_varchar2
497: ,p_election_information24 in varchar2 default hr_api.g_varchar2
498: ,p_election_information25 in varchar2 default hr_api.g_varchar2
499: ,p_election_information26 in varchar2 default hr_api.g_varchar2
500: ,p_election_information27 in varchar2 default hr_api.g_varchar2
493: ,p_election_information20 in varchar2 default hr_api.g_varchar2
494: ,p_election_information21 in varchar2 default hr_api.g_varchar2
495: ,p_election_information22 in varchar2 default hr_api.g_varchar2
496: ,p_election_information23 in varchar2 default hr_api.g_varchar2
497: ,p_election_information24 in varchar2 default hr_api.g_varchar2
498: ,p_election_information25 in varchar2 default hr_api.g_varchar2
499: ,p_election_information26 in varchar2 default hr_api.g_varchar2
500: ,p_election_information27 in varchar2 default hr_api.g_varchar2
501: ,p_election_information28 in varchar2 default hr_api.g_varchar2
494: ,p_election_information21 in varchar2 default hr_api.g_varchar2
495: ,p_election_information22 in varchar2 default hr_api.g_varchar2
496: ,p_election_information23 in varchar2 default hr_api.g_varchar2
497: ,p_election_information24 in varchar2 default hr_api.g_varchar2
498: ,p_election_information25 in varchar2 default hr_api.g_varchar2
499: ,p_election_information26 in varchar2 default hr_api.g_varchar2
500: ,p_election_information27 in varchar2 default hr_api.g_varchar2
501: ,p_election_information28 in varchar2 default hr_api.g_varchar2
502: ,p_election_information29 in varchar2 default hr_api.g_varchar2
495: ,p_election_information22 in varchar2 default hr_api.g_varchar2
496: ,p_election_information23 in varchar2 default hr_api.g_varchar2
497: ,p_election_information24 in varchar2 default hr_api.g_varchar2
498: ,p_election_information25 in varchar2 default hr_api.g_varchar2
499: ,p_election_information26 in varchar2 default hr_api.g_varchar2
500: ,p_election_information27 in varchar2 default hr_api.g_varchar2
501: ,p_election_information28 in varchar2 default hr_api.g_varchar2
502: ,p_election_information29 in varchar2 default hr_api.g_varchar2
503: ,p_election_information30 in varchar2 default hr_api.g_varchar2
496: ,p_election_information23 in varchar2 default hr_api.g_varchar2
497: ,p_election_information24 in varchar2 default hr_api.g_varchar2
498: ,p_election_information25 in varchar2 default hr_api.g_varchar2
499: ,p_election_information26 in varchar2 default hr_api.g_varchar2
500: ,p_election_information27 in varchar2 default hr_api.g_varchar2
501: ,p_election_information28 in varchar2 default hr_api.g_varchar2
502: ,p_election_information29 in varchar2 default hr_api.g_varchar2
503: ,p_election_information30 in varchar2 default hr_api.g_varchar2
504: ,p_object_version_number in out nocopy number
497: ,p_election_information24 in varchar2 default hr_api.g_varchar2
498: ,p_election_information25 in varchar2 default hr_api.g_varchar2
499: ,p_election_information26 in varchar2 default hr_api.g_varchar2
500: ,p_election_information27 in varchar2 default hr_api.g_varchar2
501: ,p_election_information28 in varchar2 default hr_api.g_varchar2
502: ,p_election_information29 in varchar2 default hr_api.g_varchar2
503: ,p_election_information30 in varchar2 default hr_api.g_varchar2
504: ,p_object_version_number in out nocopy number
505: ) is
498: ,p_election_information25 in varchar2 default hr_api.g_varchar2
499: ,p_election_information26 in varchar2 default hr_api.g_varchar2
500: ,p_election_information27 in varchar2 default hr_api.g_varchar2
501: ,p_election_information28 in varchar2 default hr_api.g_varchar2
502: ,p_election_information29 in varchar2 default hr_api.g_varchar2
503: ,p_election_information30 in varchar2 default hr_api.g_varchar2
504: ,p_object_version_number in out nocopy number
505: ) is
506: --
499: ,p_election_information26 in varchar2 default hr_api.g_varchar2
500: ,p_election_information27 in varchar2 default hr_api.g_varchar2
501: ,p_election_information28 in varchar2 default hr_api.g_varchar2
502: ,p_election_information29 in varchar2 default hr_api.g_varchar2
503: ,p_election_information30 in varchar2 default hr_api.g_varchar2
504: ,p_object_version_number in out nocopy number
505: ) is
506: --
507: -- Declare cursors and local variables
524: -- Check that p_rep_body_id, p_business_group_id, election_date are not null.
525: --
526: hr_utility.set_location('Entering mandatory arg check', 20);
527: --
528: hr_api.mandatory_arg_error
529: (p_api_name => l_proc,
530: p_argument => 'rep_body_id',
531: p_argument_value => p_rep_body_id);
532: --
529: (p_api_name => l_proc,
530: p_argument => 'rep_body_id',
531: p_argument_value => p_rep_body_id);
532: --
533: hr_api.mandatory_arg_error
534: (p_api_name => l_proc,
535: p_argument => 'business_group_id',
536: p_argument_value => p_business_group_id);
537: --
534: (p_api_name => l_proc,
535: p_argument => 'business_group_id',
536: p_argument_value => p_business_group_id);
537: --
538: hr_api.mandatory_arg_error
539: (p_api_name => l_proc,
540: p_argument => 'effective_date',
541: p_argument_value => p_effective_date);
542: --
539: (p_api_name => l_proc,
540: p_argument => 'effective_date',
541: p_argument_value => p_effective_date);
542: --
543: hr_api.mandatory_arg_error
544: (p_api_name => l_proc,
545: p_argument => 'election_date',
546: p_argument_value => p_election_date);
547: --
625: ,p_election_information30 => p_election_information30
626: ,p_object_version_number => p_object_version_number
627: );
628: exception
629: when hr_api.cannot_find_prog_unit then
630: hr_api.cannot_find_prog_unit_error
631: (p_module_name => 'UPDATE_ELECTION_INFORMATION'
632: ,p_hook_type => 'BP'
633: );
626: ,p_object_version_number => p_object_version_number
627: );
628: exception
629: when hr_api.cannot_find_prog_unit then
630: hr_api.cannot_find_prog_unit_error
631: (p_module_name => 'UPDATE_ELECTION_INFORMATION'
632: ,p_hook_type => 'BP'
633: );
634:
794: ,p_election_information30 => p_election_information30
795: );
796:
797: exception
798: when hr_api.cannot_find_prog_unit then
799: hr_api.cannot_find_prog_unit_error
800: (p_module_name => 'UPDATE_ELECTION_INFORMATION'
801: ,p_hook_type => 'AP'
802: );
795: );
796:
797: exception
798: when hr_api.cannot_find_prog_unit then
799: hr_api.cannot_find_prog_unit_error
800: (p_module_name => 'UPDATE_ELECTION_INFORMATION'
801: ,p_hook_type => 'AP'
802: );
803: end;
804: --
805: -- When in validation only mode raise the Validate_Enabled exception
806: --
807: if p_validate then
808: raise hr_api.validate_enabled;
809: end if;
810: --
811: --
812: hr_utility.set_location(' Leaving:'||l_proc, 70);
810: --
811: --
812: hr_utility.set_location(' Leaving:'||l_proc, 70);
813: exception
814: when hr_api.validate_enabled then
815: --
816: -- As the Validate_Enabled exception has been raised
817: -- we must rollback to the savepoint
818: --
875: p_election_id => p_election_id
876: ,p_object_version_number => p_object_version_number
877: );
878: exception
879: when hr_api.cannot_find_prog_unit then
880: hr_api.cannot_find_prog_unit_error
881: (p_module_name => 'delete_election_information'
882: ,p_hook_type => 'BP'
883: );
876: ,p_object_version_number => p_object_version_number
877: );
878: exception
879: when hr_api.cannot_find_prog_unit then
880: hr_api.cannot_find_prog_unit_error
881: (p_module_name => 'delete_election_information'
882: ,p_hook_type => 'BP'
883: );
884: --
902: p_election_id => p_election_id
903: ,p_object_version_number => p_object_version_number
904: );
905: exception
906: when hr_api.cannot_find_prog_unit then
907: hr_api.cannot_find_prog_unit_error
908: (p_module_name => 'delete_election_information'
909: ,p_hook_type => 'AP'
910: );
903: ,p_object_version_number => p_object_version_number
904: );
905: exception
906: when hr_api.cannot_find_prog_unit then
907: hr_api.cannot_find_prog_unit_error
908: (p_module_name => 'delete_election_information'
909: ,p_hook_type => 'AP'
910: );
911: --
917: --
918: -- When in validation only mode raise the Validate_Enabled exception
919: --
920: if p_validate then
921: raise hr_api.validate_enabled;
922: end if;
923: --
924: hr_utility.set_location(' Leaving:'||l_proc, 70);
925: --
924: hr_utility.set_location(' Leaving:'||l_proc, 70);
925: --
926: exception
927: --
928: when hr_api.validate_enabled then
929: --
930: -- As the Validate_Enabled exception has been raised
931: -- we must rollback to the savepoint
932: --