103: p_attribute20 => p_attribute20,
104: p_participant_usage_status => p_participant_usage_status
105: );
106: exception
107: when hr_api.cannot_find_prog_unit then
108: hr_api.cannot_find_prog_unit_error
109: (p_module_name => 'create_participant',
110: p_hook_type => 'BP'
111: );
104: p_participant_usage_status => p_participant_usage_status
105: );
106: exception
107: when hr_api.cannot_find_prog_unit then
108: hr_api.cannot_find_prog_unit_error
109: (p_module_name => 'create_participant',
110: p_hook_type => 'BP'
111: );
112: end;
202: p_attribute20 => p_attribute20,
203: p_participant_usage_status => p_participant_usage_status
204: );
205: exception
206: when hr_api.cannot_find_prog_unit then
207: hr_api.cannot_find_prog_unit_error
208: (p_module_name => 'create_participant',
209: p_hook_type => 'AP'
210: );
203: p_participant_usage_status => p_participant_usage_status
204: );
205: exception
206: when hr_api.cannot_find_prog_unit then
207: hr_api.cannot_find_prog_unit_error
208: (p_module_name => 'create_participant',
209: p_hook_type => 'AP'
210: );
211: end;
214: --
215: -- When in validation only mode raise the Validate_Enabled exception
216: --
217: if p_validate then
218: raise hr_api.validate_enabled;
219: end if;
220: --
221: -- Set all output arguments
222: --
224: p_object_version_number := l_object_version_number;
225: --
226: hr_utility.set_location(' Leaving:'||l_proc, 11);
227: exception
228: when hr_api.validate_enabled then
229: --
230: -- As the Validate_Enabled exception has been raised
231: -- we must rollback to the savepoint
232: --
267: (p_validate in boolean default false,
268: p_effective_date in date,
269: p_participant_id in number,
270: p_object_version_number in out nocopy number,
271: p_questionnaire_template_id in number default hr_api.g_number,
272: p_participation_status in varchar2 default hr_api.g_varchar2,
273: p_participation_type in varchar2 default hr_api.g_varchar2,
274: p_last_notified_date in date default hr_api.g_date,
275: p_date_completed in date default hr_api.g_date,
268: p_effective_date in date,
269: p_participant_id in number,
270: p_object_version_number in out nocopy number,
271: p_questionnaire_template_id in number default hr_api.g_number,
272: p_participation_status in varchar2 default hr_api.g_varchar2,
273: p_participation_type in varchar2 default hr_api.g_varchar2,
274: p_last_notified_date in date default hr_api.g_date,
275: p_date_completed in date default hr_api.g_date,
276: p_comments in varchar2 default hr_api.g_varchar2,
269: p_participant_id in number,
270: p_object_version_number in out nocopy number,
271: p_questionnaire_template_id in number default hr_api.g_number,
272: p_participation_status in varchar2 default hr_api.g_varchar2,
273: p_participation_type in varchar2 default hr_api.g_varchar2,
274: p_last_notified_date in date default hr_api.g_date,
275: p_date_completed in date default hr_api.g_date,
276: p_comments in varchar2 default hr_api.g_varchar2,
277: p_person_id in number default hr_api.g_number,
270: p_object_version_number in out nocopy number,
271: p_questionnaire_template_id in number default hr_api.g_number,
272: p_participation_status in varchar2 default hr_api.g_varchar2,
273: p_participation_type in varchar2 default hr_api.g_varchar2,
274: p_last_notified_date in date default hr_api.g_date,
275: p_date_completed in date default hr_api.g_date,
276: p_comments in varchar2 default hr_api.g_varchar2,
277: p_person_id in number default hr_api.g_number,
278: p_attribute_category in varchar2 default hr_api.g_varchar2,
271: p_questionnaire_template_id in number default hr_api.g_number,
272: p_participation_status in varchar2 default hr_api.g_varchar2,
273: p_participation_type in varchar2 default hr_api.g_varchar2,
274: p_last_notified_date in date default hr_api.g_date,
275: p_date_completed in date default hr_api.g_date,
276: p_comments in varchar2 default hr_api.g_varchar2,
277: p_person_id in number default hr_api.g_number,
278: p_attribute_category in varchar2 default hr_api.g_varchar2,
279: p_attribute1 in varchar2 default hr_api.g_varchar2,
272: p_participation_status in varchar2 default hr_api.g_varchar2,
273: p_participation_type in varchar2 default hr_api.g_varchar2,
274: p_last_notified_date in date default hr_api.g_date,
275: p_date_completed in date default hr_api.g_date,
276: p_comments in varchar2 default hr_api.g_varchar2,
277: p_person_id in number default hr_api.g_number,
278: p_attribute_category in varchar2 default hr_api.g_varchar2,
279: p_attribute1 in varchar2 default hr_api.g_varchar2,
280: p_attribute2 in varchar2 default hr_api.g_varchar2,
273: p_participation_type in varchar2 default hr_api.g_varchar2,
274: p_last_notified_date in date default hr_api.g_date,
275: p_date_completed in date default hr_api.g_date,
276: p_comments in varchar2 default hr_api.g_varchar2,
277: p_person_id in number default hr_api.g_number,
278: p_attribute_category in varchar2 default hr_api.g_varchar2,
279: p_attribute1 in varchar2 default hr_api.g_varchar2,
280: p_attribute2 in varchar2 default hr_api.g_varchar2,
281: p_attribute3 in varchar2 default hr_api.g_varchar2,
274: p_last_notified_date in date default hr_api.g_date,
275: p_date_completed in date default hr_api.g_date,
276: p_comments in varchar2 default hr_api.g_varchar2,
277: p_person_id in number default hr_api.g_number,
278: p_attribute_category in varchar2 default hr_api.g_varchar2,
279: p_attribute1 in varchar2 default hr_api.g_varchar2,
280: p_attribute2 in varchar2 default hr_api.g_varchar2,
281: p_attribute3 in varchar2 default hr_api.g_varchar2,
282: p_attribute4 in varchar2 default hr_api.g_varchar2,
275: p_date_completed in date default hr_api.g_date,
276: p_comments in varchar2 default hr_api.g_varchar2,
277: p_person_id in number default hr_api.g_number,
278: p_attribute_category in varchar2 default hr_api.g_varchar2,
279: p_attribute1 in varchar2 default hr_api.g_varchar2,
280: p_attribute2 in varchar2 default hr_api.g_varchar2,
281: p_attribute3 in varchar2 default hr_api.g_varchar2,
282: p_attribute4 in varchar2 default hr_api.g_varchar2,
283: p_attribute5 in varchar2 default hr_api.g_varchar2,
276: p_comments in varchar2 default hr_api.g_varchar2,
277: p_person_id in number default hr_api.g_number,
278: p_attribute_category in varchar2 default hr_api.g_varchar2,
279: p_attribute1 in varchar2 default hr_api.g_varchar2,
280: p_attribute2 in varchar2 default hr_api.g_varchar2,
281: p_attribute3 in varchar2 default hr_api.g_varchar2,
282: p_attribute4 in varchar2 default hr_api.g_varchar2,
283: p_attribute5 in varchar2 default hr_api.g_varchar2,
284: p_attribute6 in varchar2 default hr_api.g_varchar2,
277: p_person_id in number default hr_api.g_number,
278: p_attribute_category in varchar2 default hr_api.g_varchar2,
279: p_attribute1 in varchar2 default hr_api.g_varchar2,
280: p_attribute2 in varchar2 default hr_api.g_varchar2,
281: p_attribute3 in varchar2 default hr_api.g_varchar2,
282: p_attribute4 in varchar2 default hr_api.g_varchar2,
283: p_attribute5 in varchar2 default hr_api.g_varchar2,
284: p_attribute6 in varchar2 default hr_api.g_varchar2,
285: p_attribute7 in varchar2 default hr_api.g_varchar2,
278: p_attribute_category in varchar2 default hr_api.g_varchar2,
279: p_attribute1 in varchar2 default hr_api.g_varchar2,
280: p_attribute2 in varchar2 default hr_api.g_varchar2,
281: p_attribute3 in varchar2 default hr_api.g_varchar2,
282: p_attribute4 in varchar2 default hr_api.g_varchar2,
283: p_attribute5 in varchar2 default hr_api.g_varchar2,
284: p_attribute6 in varchar2 default hr_api.g_varchar2,
285: p_attribute7 in varchar2 default hr_api.g_varchar2,
286: p_attribute8 in varchar2 default hr_api.g_varchar2,
279: p_attribute1 in varchar2 default hr_api.g_varchar2,
280: p_attribute2 in varchar2 default hr_api.g_varchar2,
281: p_attribute3 in varchar2 default hr_api.g_varchar2,
282: p_attribute4 in varchar2 default hr_api.g_varchar2,
283: p_attribute5 in varchar2 default hr_api.g_varchar2,
284: p_attribute6 in varchar2 default hr_api.g_varchar2,
285: p_attribute7 in varchar2 default hr_api.g_varchar2,
286: p_attribute8 in varchar2 default hr_api.g_varchar2,
287: p_attribute9 in varchar2 default hr_api.g_varchar2,
280: p_attribute2 in varchar2 default hr_api.g_varchar2,
281: p_attribute3 in varchar2 default hr_api.g_varchar2,
282: p_attribute4 in varchar2 default hr_api.g_varchar2,
283: p_attribute5 in varchar2 default hr_api.g_varchar2,
284: p_attribute6 in varchar2 default hr_api.g_varchar2,
285: p_attribute7 in varchar2 default hr_api.g_varchar2,
286: p_attribute8 in varchar2 default hr_api.g_varchar2,
287: p_attribute9 in varchar2 default hr_api.g_varchar2,
288: p_attribute10 in varchar2 default hr_api.g_varchar2,
281: p_attribute3 in varchar2 default hr_api.g_varchar2,
282: p_attribute4 in varchar2 default hr_api.g_varchar2,
283: p_attribute5 in varchar2 default hr_api.g_varchar2,
284: p_attribute6 in varchar2 default hr_api.g_varchar2,
285: p_attribute7 in varchar2 default hr_api.g_varchar2,
286: p_attribute8 in varchar2 default hr_api.g_varchar2,
287: p_attribute9 in varchar2 default hr_api.g_varchar2,
288: p_attribute10 in varchar2 default hr_api.g_varchar2,
289: p_attribute11 in varchar2 default hr_api.g_varchar2,
282: p_attribute4 in varchar2 default hr_api.g_varchar2,
283: p_attribute5 in varchar2 default hr_api.g_varchar2,
284: p_attribute6 in varchar2 default hr_api.g_varchar2,
285: p_attribute7 in varchar2 default hr_api.g_varchar2,
286: p_attribute8 in varchar2 default hr_api.g_varchar2,
287: p_attribute9 in varchar2 default hr_api.g_varchar2,
288: p_attribute10 in varchar2 default hr_api.g_varchar2,
289: p_attribute11 in varchar2 default hr_api.g_varchar2,
290: p_attribute12 in varchar2 default hr_api.g_varchar2,
283: p_attribute5 in varchar2 default hr_api.g_varchar2,
284: p_attribute6 in varchar2 default hr_api.g_varchar2,
285: p_attribute7 in varchar2 default hr_api.g_varchar2,
286: p_attribute8 in varchar2 default hr_api.g_varchar2,
287: p_attribute9 in varchar2 default hr_api.g_varchar2,
288: p_attribute10 in varchar2 default hr_api.g_varchar2,
289: p_attribute11 in varchar2 default hr_api.g_varchar2,
290: p_attribute12 in varchar2 default hr_api.g_varchar2,
291: p_attribute13 in varchar2 default hr_api.g_varchar2,
284: p_attribute6 in varchar2 default hr_api.g_varchar2,
285: p_attribute7 in varchar2 default hr_api.g_varchar2,
286: p_attribute8 in varchar2 default hr_api.g_varchar2,
287: p_attribute9 in varchar2 default hr_api.g_varchar2,
288: p_attribute10 in varchar2 default hr_api.g_varchar2,
289: p_attribute11 in varchar2 default hr_api.g_varchar2,
290: p_attribute12 in varchar2 default hr_api.g_varchar2,
291: p_attribute13 in varchar2 default hr_api.g_varchar2,
292: p_attribute14 in varchar2 default hr_api.g_varchar2,
285: p_attribute7 in varchar2 default hr_api.g_varchar2,
286: p_attribute8 in varchar2 default hr_api.g_varchar2,
287: p_attribute9 in varchar2 default hr_api.g_varchar2,
288: p_attribute10 in varchar2 default hr_api.g_varchar2,
289: p_attribute11 in varchar2 default hr_api.g_varchar2,
290: p_attribute12 in varchar2 default hr_api.g_varchar2,
291: p_attribute13 in varchar2 default hr_api.g_varchar2,
292: p_attribute14 in varchar2 default hr_api.g_varchar2,
293: p_attribute15 in varchar2 default hr_api.g_varchar2,
286: p_attribute8 in varchar2 default hr_api.g_varchar2,
287: p_attribute9 in varchar2 default hr_api.g_varchar2,
288: p_attribute10 in varchar2 default hr_api.g_varchar2,
289: p_attribute11 in varchar2 default hr_api.g_varchar2,
290: p_attribute12 in varchar2 default hr_api.g_varchar2,
291: p_attribute13 in varchar2 default hr_api.g_varchar2,
292: p_attribute14 in varchar2 default hr_api.g_varchar2,
293: p_attribute15 in varchar2 default hr_api.g_varchar2,
294: p_attribute16 in varchar2 default hr_api.g_varchar2,
287: p_attribute9 in varchar2 default hr_api.g_varchar2,
288: p_attribute10 in varchar2 default hr_api.g_varchar2,
289: p_attribute11 in varchar2 default hr_api.g_varchar2,
290: p_attribute12 in varchar2 default hr_api.g_varchar2,
291: p_attribute13 in varchar2 default hr_api.g_varchar2,
292: p_attribute14 in varchar2 default hr_api.g_varchar2,
293: p_attribute15 in varchar2 default hr_api.g_varchar2,
294: p_attribute16 in varchar2 default hr_api.g_varchar2,
295: p_attribute17 in varchar2 default hr_api.g_varchar2,
288: p_attribute10 in varchar2 default hr_api.g_varchar2,
289: p_attribute11 in varchar2 default hr_api.g_varchar2,
290: p_attribute12 in varchar2 default hr_api.g_varchar2,
291: p_attribute13 in varchar2 default hr_api.g_varchar2,
292: p_attribute14 in varchar2 default hr_api.g_varchar2,
293: p_attribute15 in varchar2 default hr_api.g_varchar2,
294: p_attribute16 in varchar2 default hr_api.g_varchar2,
295: p_attribute17 in varchar2 default hr_api.g_varchar2,
296: p_attribute18 in varchar2 default hr_api.g_varchar2,
289: p_attribute11 in varchar2 default hr_api.g_varchar2,
290: p_attribute12 in varchar2 default hr_api.g_varchar2,
291: p_attribute13 in varchar2 default hr_api.g_varchar2,
292: p_attribute14 in varchar2 default hr_api.g_varchar2,
293: p_attribute15 in varchar2 default hr_api.g_varchar2,
294: p_attribute16 in varchar2 default hr_api.g_varchar2,
295: p_attribute17 in varchar2 default hr_api.g_varchar2,
296: p_attribute18 in varchar2 default hr_api.g_varchar2,
297: p_attribute19 in varchar2 default hr_api.g_varchar2,
290: p_attribute12 in varchar2 default hr_api.g_varchar2,
291: p_attribute13 in varchar2 default hr_api.g_varchar2,
292: p_attribute14 in varchar2 default hr_api.g_varchar2,
293: p_attribute15 in varchar2 default hr_api.g_varchar2,
294: p_attribute16 in varchar2 default hr_api.g_varchar2,
295: p_attribute17 in varchar2 default hr_api.g_varchar2,
296: p_attribute18 in varchar2 default hr_api.g_varchar2,
297: p_attribute19 in varchar2 default hr_api.g_varchar2,
298: p_attribute20 in varchar2 default hr_api.g_varchar2,
291: p_attribute13 in varchar2 default hr_api.g_varchar2,
292: p_attribute14 in varchar2 default hr_api.g_varchar2,
293: p_attribute15 in varchar2 default hr_api.g_varchar2,
294: p_attribute16 in varchar2 default hr_api.g_varchar2,
295: p_attribute17 in varchar2 default hr_api.g_varchar2,
296: p_attribute18 in varchar2 default hr_api.g_varchar2,
297: p_attribute19 in varchar2 default hr_api.g_varchar2,
298: p_attribute20 in varchar2 default hr_api.g_varchar2,
299: p_participant_usage_status in varchar2 default hr_api.g_varchar2
292: p_attribute14 in varchar2 default hr_api.g_varchar2,
293: p_attribute15 in varchar2 default hr_api.g_varchar2,
294: p_attribute16 in varchar2 default hr_api.g_varchar2,
295: p_attribute17 in varchar2 default hr_api.g_varchar2,
296: p_attribute18 in varchar2 default hr_api.g_varchar2,
297: p_attribute19 in varchar2 default hr_api.g_varchar2,
298: p_attribute20 in varchar2 default hr_api.g_varchar2,
299: p_participant_usage_status in varchar2 default hr_api.g_varchar2
300: ) is
293: p_attribute15 in varchar2 default hr_api.g_varchar2,
294: p_attribute16 in varchar2 default hr_api.g_varchar2,
295: p_attribute17 in varchar2 default hr_api.g_varchar2,
296: p_attribute18 in varchar2 default hr_api.g_varchar2,
297: p_attribute19 in varchar2 default hr_api.g_varchar2,
298: p_attribute20 in varchar2 default hr_api.g_varchar2,
299: p_participant_usage_status in varchar2 default hr_api.g_varchar2
300: ) is
301: --
294: p_attribute16 in varchar2 default hr_api.g_varchar2,
295: p_attribute17 in varchar2 default hr_api.g_varchar2,
296: p_attribute18 in varchar2 default hr_api.g_varchar2,
297: p_attribute19 in varchar2 default hr_api.g_varchar2,
298: p_attribute20 in varchar2 default hr_api.g_varchar2,
299: p_participant_usage_status in varchar2 default hr_api.g_varchar2
300: ) is
301: --
302: -- Declare cursors and local variables
295: p_attribute17 in varchar2 default hr_api.g_varchar2,
296: p_attribute18 in varchar2 default hr_api.g_varchar2,
297: p_attribute19 in varchar2 default hr_api.g_varchar2,
298: p_attribute20 in varchar2 default hr_api.g_varchar2,
299: p_participant_usage_status in varchar2 default hr_api.g_varchar2
300: ) is
301: --
302: -- Declare cursors and local variables
303: --
350: p_attribute20 => p_attribute20,
351: p_participant_usage_status => p_participant_usage_status
352: );
353: exception
354: when hr_api.cannot_find_prog_unit then
355: hr_api.cannot_find_prog_unit_error
356: (p_module_name => 'update_participant',
357: p_hook_type => 'BP'
358: );
351: p_participant_usage_status => p_participant_usage_status
352: );
353: exception
354: when hr_api.cannot_find_prog_unit then
355: hr_api.cannot_find_prog_unit_error
356: (p_module_name => 'update_participant',
357: p_hook_type => 'BP'
358: );
359: end;
444: p_attribute20 => p_attribute20,
445: p_participant_usage_status => p_participant_usage_status
446: );
447: exception
448: when hr_api.cannot_find_prog_unit then
449: hr_api.cannot_find_prog_unit_error
450: (p_module_name => 'update_participant',
451: p_hook_type => 'AP'
452: );
445: p_participant_usage_status => p_participant_usage_status
446: );
447: exception
448: when hr_api.cannot_find_prog_unit then
449: hr_api.cannot_find_prog_unit_error
450: (p_module_name => 'update_participant',
451: p_hook_type => 'AP'
452: );
453: end;
456: --
457: -- When in validation only mode raise the Validate_Enabled exception
458: --
459: if p_validate then
460: raise hr_api.validate_enabled;
461: end if;
462: --
463: -- Set all output arguments. l_object_version_number now has the new
464: -- object version number as the update was successful
466: p_object_version_number := l_object_version_number;
467: --
468: hr_utility.set_location(' Leaving:'||l_proc, 11);
469: exception
470: when hr_api.validate_enabled then
471: --
472: -- As the Validate_Enabled exception has been raised
473: -- we must rollback to the savepoint
474: --
543: p_participant_id => p_participant_id,
544: p_object_version_number => p_object_version_number
545: );
546: exception
547: when hr_api.cannot_find_prog_unit then
548: hr_api.cannot_find_prog_unit_error
549: (p_module_name => 'delete_participant',
550: p_hook_type => 'BP'
551: );
544: p_object_version_number => p_object_version_number
545: );
546: exception
547: when hr_api.cannot_find_prog_unit then
548: hr_api.cannot_find_prog_unit_error
549: (p_module_name => 'delete_participant',
550: p_hook_type => 'BP'
551: );
552: end;
587: p_participant_id => p_participant_id,
588: p_object_version_number => p_object_version_number
589: );
590: exception
591: when hr_api.cannot_find_prog_unit then
592: hr_api.cannot_find_prog_unit_error
593: (p_module_name => 'delete_participant',
594: p_hook_type => 'AP'
595: );
588: p_object_version_number => p_object_version_number
589: );
590: exception
591: when hr_api.cannot_find_prog_unit then
592: hr_api.cannot_find_prog_unit_error
593: (p_module_name => 'delete_participant',
594: p_hook_type => 'AP'
595: );
596: end;
599: --
600: -- When in validation only mode raise the Validate_Enabled exception
601: --
602: if p_validate then
603: raise hr_api.validate_enabled;
604: end if;
605: --
606: hr_utility.set_location(' Leaving:'||l_proc, 11);
607: exception
604: end if;
605: --
606: hr_utility.set_location(' Leaving:'||l_proc, 11);
607: exception
608: when hr_api.validate_enabled then
609: --
610: -- As the Validate_Enabled exception has been raised
611: -- we must rollback to the savepoint
612: --