11: -- ----------------------------------------------------------------------------
12: procedure create_outcome
13: (p_validate in boolean default false
14: ,p_effective_date in date
15: ,p_language_code in varchar2 default hr_api.userenv_lang
16: ,p_competence_id in number
17: ,p_outcome_number in number
18: ,p_name in varchar2
19: ,p_date_from in date
153: ,p_information19 => p_information19
154: ,p_information20 => p_information20
155: );
156: exception
157: when hr_api.cannot_find_prog_unit then
158: hr_api.cannot_find_prog_unit_error
159: (p_module_name => 'CREATE_OUTCOME'
160: ,p_hook_type => 'BP'
161: );
154: ,p_information20 => p_information20
155: );
156: exception
157: when hr_api.cannot_find_prog_unit then
158: hr_api.cannot_find_prog_unit_error
159: (p_module_name => 'CREATE_OUTCOME'
160: ,p_hook_type => 'BP'
161: );
162: --
174: -- functions instead of p_language_code from now on, to allow an IN OUT
175: -- parameter to be passed through.
176: --
177: l_language_code := p_language_code;
178: hr_api.validate_language_code(p_language_code => l_language_code);
179:
180: hr_utility.set_location(l_proc, 40);
181:
182: --
311: ,p_information20 => p_information20
312: ,p_object_version_number => l_object_version_number
313: );
314: exception
315: when hr_api.cannot_find_prog_unit then
316: hr_api.cannot_find_prog_unit_error
317: (p_module_name => 'CREATE_OUTCOME'
318: ,p_hook_type => 'AP'
319: );
312: ,p_object_version_number => l_object_version_number
313: );
314: exception
315: when hr_api.cannot_find_prog_unit then
316: hr_api.cannot_find_prog_unit_error
317: (p_module_name => 'CREATE_OUTCOME'
318: ,p_hook_type => 'AP'
319: );
320: --
328: -- When in validation only mode raise the Validate_Enabled exception
329: --
330: if p_validate
331: then
332: raise hr_api.validate_enabled;
333: end if;
334: --
335: hr_utility.set_location(l_proc, 80);
336: --
342: hr_utility.set_location(' Leaving:' ||l_proc, 90);
343: --
344: exception
345: --
346: when hr_api.validate_enabled then
347: --
348: -- As the Validate_Enabled exception has been raised
349: -- we must rollback to the savepoint
350: --
381: --
382: procedure update_outcome
383: (p_validate in boolean default false
384: ,p_effective_date in date
385: ,p_language_code in varchar2 default hr_api.userenv_lang
386: ,p_outcome_id in number
387: ,p_object_version_number in out nocopy number
388: ,p_competence_id in number default hr_api.g_number
389: ,p_outcome_number in number default hr_api.g_number
384: ,p_effective_date in date
385: ,p_language_code in varchar2 default hr_api.userenv_lang
386: ,p_outcome_id in number
387: ,p_object_version_number in out nocopy number
388: ,p_competence_id in number default hr_api.g_number
389: ,p_outcome_number in number default hr_api.g_number
390: ,p_name in varchar2 default hr_api.g_varchar2
391: ,p_date_from in date default hr_api.g_date
392: ,p_date_to in date default hr_api.g_date
385: ,p_language_code in varchar2 default hr_api.userenv_lang
386: ,p_outcome_id in number
387: ,p_object_version_number in out nocopy number
388: ,p_competence_id in number default hr_api.g_number
389: ,p_outcome_number in number default hr_api.g_number
390: ,p_name in varchar2 default hr_api.g_varchar2
391: ,p_date_from in date default hr_api.g_date
392: ,p_date_to in date default hr_api.g_date
393: ,p_assessment_criteria in varchar2 default hr_api.g_varchar2
386: ,p_outcome_id in number
387: ,p_object_version_number in out nocopy number
388: ,p_competence_id in number default hr_api.g_number
389: ,p_outcome_number in number default hr_api.g_number
390: ,p_name in varchar2 default hr_api.g_varchar2
391: ,p_date_from in date default hr_api.g_date
392: ,p_date_to in date default hr_api.g_date
393: ,p_assessment_criteria in varchar2 default hr_api.g_varchar2
394: ,p_attribute_category in varchar2 default hr_api.g_varchar2
387: ,p_object_version_number in out nocopy number
388: ,p_competence_id in number default hr_api.g_number
389: ,p_outcome_number in number default hr_api.g_number
390: ,p_name in varchar2 default hr_api.g_varchar2
391: ,p_date_from in date default hr_api.g_date
392: ,p_date_to in date default hr_api.g_date
393: ,p_assessment_criteria in varchar2 default hr_api.g_varchar2
394: ,p_attribute_category in varchar2 default hr_api.g_varchar2
395: ,p_attribute1 in varchar2 default hr_api.g_varchar2
388: ,p_competence_id in number default hr_api.g_number
389: ,p_outcome_number in number default hr_api.g_number
390: ,p_name in varchar2 default hr_api.g_varchar2
391: ,p_date_from in date default hr_api.g_date
392: ,p_date_to in date default hr_api.g_date
393: ,p_assessment_criteria in varchar2 default hr_api.g_varchar2
394: ,p_attribute_category in varchar2 default hr_api.g_varchar2
395: ,p_attribute1 in varchar2 default hr_api.g_varchar2
396: ,p_attribute2 in varchar2 default hr_api.g_varchar2
389: ,p_outcome_number in number default hr_api.g_number
390: ,p_name in varchar2 default hr_api.g_varchar2
391: ,p_date_from in date default hr_api.g_date
392: ,p_date_to in date default hr_api.g_date
393: ,p_assessment_criteria in varchar2 default hr_api.g_varchar2
394: ,p_attribute_category in varchar2 default hr_api.g_varchar2
395: ,p_attribute1 in varchar2 default hr_api.g_varchar2
396: ,p_attribute2 in varchar2 default hr_api.g_varchar2
397: ,p_attribute3 in varchar2 default hr_api.g_varchar2
390: ,p_name in varchar2 default hr_api.g_varchar2
391: ,p_date_from in date default hr_api.g_date
392: ,p_date_to in date default hr_api.g_date
393: ,p_assessment_criteria in varchar2 default hr_api.g_varchar2
394: ,p_attribute_category in varchar2 default hr_api.g_varchar2
395: ,p_attribute1 in varchar2 default hr_api.g_varchar2
396: ,p_attribute2 in varchar2 default hr_api.g_varchar2
397: ,p_attribute3 in varchar2 default hr_api.g_varchar2
398: ,p_attribute4 in varchar2 default hr_api.g_varchar2
391: ,p_date_from in date default hr_api.g_date
392: ,p_date_to in date default hr_api.g_date
393: ,p_assessment_criteria in varchar2 default hr_api.g_varchar2
394: ,p_attribute_category in varchar2 default hr_api.g_varchar2
395: ,p_attribute1 in varchar2 default hr_api.g_varchar2
396: ,p_attribute2 in varchar2 default hr_api.g_varchar2
397: ,p_attribute3 in varchar2 default hr_api.g_varchar2
398: ,p_attribute4 in varchar2 default hr_api.g_varchar2
399: ,p_attribute5 in varchar2 default hr_api.g_varchar2
392: ,p_date_to in date default hr_api.g_date
393: ,p_assessment_criteria in varchar2 default hr_api.g_varchar2
394: ,p_attribute_category in varchar2 default hr_api.g_varchar2
395: ,p_attribute1 in varchar2 default hr_api.g_varchar2
396: ,p_attribute2 in varchar2 default hr_api.g_varchar2
397: ,p_attribute3 in varchar2 default hr_api.g_varchar2
398: ,p_attribute4 in varchar2 default hr_api.g_varchar2
399: ,p_attribute5 in varchar2 default hr_api.g_varchar2
400: ,p_attribute6 in varchar2 default hr_api.g_varchar2
393: ,p_assessment_criteria in varchar2 default hr_api.g_varchar2
394: ,p_attribute_category in varchar2 default hr_api.g_varchar2
395: ,p_attribute1 in varchar2 default hr_api.g_varchar2
396: ,p_attribute2 in varchar2 default hr_api.g_varchar2
397: ,p_attribute3 in varchar2 default hr_api.g_varchar2
398: ,p_attribute4 in varchar2 default hr_api.g_varchar2
399: ,p_attribute5 in varchar2 default hr_api.g_varchar2
400: ,p_attribute6 in varchar2 default hr_api.g_varchar2
401: ,p_attribute7 in varchar2 default hr_api.g_varchar2
394: ,p_attribute_category in varchar2 default hr_api.g_varchar2
395: ,p_attribute1 in varchar2 default hr_api.g_varchar2
396: ,p_attribute2 in varchar2 default hr_api.g_varchar2
397: ,p_attribute3 in varchar2 default hr_api.g_varchar2
398: ,p_attribute4 in varchar2 default hr_api.g_varchar2
399: ,p_attribute5 in varchar2 default hr_api.g_varchar2
400: ,p_attribute6 in varchar2 default hr_api.g_varchar2
401: ,p_attribute7 in varchar2 default hr_api.g_varchar2
402: ,p_attribute8 in varchar2 default hr_api.g_varchar2
395: ,p_attribute1 in varchar2 default hr_api.g_varchar2
396: ,p_attribute2 in varchar2 default hr_api.g_varchar2
397: ,p_attribute3 in varchar2 default hr_api.g_varchar2
398: ,p_attribute4 in varchar2 default hr_api.g_varchar2
399: ,p_attribute5 in varchar2 default hr_api.g_varchar2
400: ,p_attribute6 in varchar2 default hr_api.g_varchar2
401: ,p_attribute7 in varchar2 default hr_api.g_varchar2
402: ,p_attribute8 in varchar2 default hr_api.g_varchar2
403: ,p_attribute9 in varchar2 default hr_api.g_varchar2
396: ,p_attribute2 in varchar2 default hr_api.g_varchar2
397: ,p_attribute3 in varchar2 default hr_api.g_varchar2
398: ,p_attribute4 in varchar2 default hr_api.g_varchar2
399: ,p_attribute5 in varchar2 default hr_api.g_varchar2
400: ,p_attribute6 in varchar2 default hr_api.g_varchar2
401: ,p_attribute7 in varchar2 default hr_api.g_varchar2
402: ,p_attribute8 in varchar2 default hr_api.g_varchar2
403: ,p_attribute9 in varchar2 default hr_api.g_varchar2
404: ,p_attribute10 in varchar2 default hr_api.g_varchar2
397: ,p_attribute3 in varchar2 default hr_api.g_varchar2
398: ,p_attribute4 in varchar2 default hr_api.g_varchar2
399: ,p_attribute5 in varchar2 default hr_api.g_varchar2
400: ,p_attribute6 in varchar2 default hr_api.g_varchar2
401: ,p_attribute7 in varchar2 default hr_api.g_varchar2
402: ,p_attribute8 in varchar2 default hr_api.g_varchar2
403: ,p_attribute9 in varchar2 default hr_api.g_varchar2
404: ,p_attribute10 in varchar2 default hr_api.g_varchar2
405: ,p_attribute11 in varchar2 default hr_api.g_varchar2
398: ,p_attribute4 in varchar2 default hr_api.g_varchar2
399: ,p_attribute5 in varchar2 default hr_api.g_varchar2
400: ,p_attribute6 in varchar2 default hr_api.g_varchar2
401: ,p_attribute7 in varchar2 default hr_api.g_varchar2
402: ,p_attribute8 in varchar2 default hr_api.g_varchar2
403: ,p_attribute9 in varchar2 default hr_api.g_varchar2
404: ,p_attribute10 in varchar2 default hr_api.g_varchar2
405: ,p_attribute11 in varchar2 default hr_api.g_varchar2
406: ,p_attribute12 in varchar2 default hr_api.g_varchar2
399: ,p_attribute5 in varchar2 default hr_api.g_varchar2
400: ,p_attribute6 in varchar2 default hr_api.g_varchar2
401: ,p_attribute7 in varchar2 default hr_api.g_varchar2
402: ,p_attribute8 in varchar2 default hr_api.g_varchar2
403: ,p_attribute9 in varchar2 default hr_api.g_varchar2
404: ,p_attribute10 in varchar2 default hr_api.g_varchar2
405: ,p_attribute11 in varchar2 default hr_api.g_varchar2
406: ,p_attribute12 in varchar2 default hr_api.g_varchar2
407: ,p_attribute13 in varchar2 default hr_api.g_varchar2
400: ,p_attribute6 in varchar2 default hr_api.g_varchar2
401: ,p_attribute7 in varchar2 default hr_api.g_varchar2
402: ,p_attribute8 in varchar2 default hr_api.g_varchar2
403: ,p_attribute9 in varchar2 default hr_api.g_varchar2
404: ,p_attribute10 in varchar2 default hr_api.g_varchar2
405: ,p_attribute11 in varchar2 default hr_api.g_varchar2
406: ,p_attribute12 in varchar2 default hr_api.g_varchar2
407: ,p_attribute13 in varchar2 default hr_api.g_varchar2
408: ,p_attribute14 in varchar2 default hr_api.g_varchar2
401: ,p_attribute7 in varchar2 default hr_api.g_varchar2
402: ,p_attribute8 in varchar2 default hr_api.g_varchar2
403: ,p_attribute9 in varchar2 default hr_api.g_varchar2
404: ,p_attribute10 in varchar2 default hr_api.g_varchar2
405: ,p_attribute11 in varchar2 default hr_api.g_varchar2
406: ,p_attribute12 in varchar2 default hr_api.g_varchar2
407: ,p_attribute13 in varchar2 default hr_api.g_varchar2
408: ,p_attribute14 in varchar2 default hr_api.g_varchar2
409: ,p_attribute15 in varchar2 default hr_api.g_varchar2
402: ,p_attribute8 in varchar2 default hr_api.g_varchar2
403: ,p_attribute9 in varchar2 default hr_api.g_varchar2
404: ,p_attribute10 in varchar2 default hr_api.g_varchar2
405: ,p_attribute11 in varchar2 default hr_api.g_varchar2
406: ,p_attribute12 in varchar2 default hr_api.g_varchar2
407: ,p_attribute13 in varchar2 default hr_api.g_varchar2
408: ,p_attribute14 in varchar2 default hr_api.g_varchar2
409: ,p_attribute15 in varchar2 default hr_api.g_varchar2
410: ,p_attribute16 in varchar2 default hr_api.g_varchar2
403: ,p_attribute9 in varchar2 default hr_api.g_varchar2
404: ,p_attribute10 in varchar2 default hr_api.g_varchar2
405: ,p_attribute11 in varchar2 default hr_api.g_varchar2
406: ,p_attribute12 in varchar2 default hr_api.g_varchar2
407: ,p_attribute13 in varchar2 default hr_api.g_varchar2
408: ,p_attribute14 in varchar2 default hr_api.g_varchar2
409: ,p_attribute15 in varchar2 default hr_api.g_varchar2
410: ,p_attribute16 in varchar2 default hr_api.g_varchar2
411: ,p_attribute17 in varchar2 default hr_api.g_varchar2
404: ,p_attribute10 in varchar2 default hr_api.g_varchar2
405: ,p_attribute11 in varchar2 default hr_api.g_varchar2
406: ,p_attribute12 in varchar2 default hr_api.g_varchar2
407: ,p_attribute13 in varchar2 default hr_api.g_varchar2
408: ,p_attribute14 in varchar2 default hr_api.g_varchar2
409: ,p_attribute15 in varchar2 default hr_api.g_varchar2
410: ,p_attribute16 in varchar2 default hr_api.g_varchar2
411: ,p_attribute17 in varchar2 default hr_api.g_varchar2
412: ,p_attribute18 in varchar2 default hr_api.g_varchar2
405: ,p_attribute11 in varchar2 default hr_api.g_varchar2
406: ,p_attribute12 in varchar2 default hr_api.g_varchar2
407: ,p_attribute13 in varchar2 default hr_api.g_varchar2
408: ,p_attribute14 in varchar2 default hr_api.g_varchar2
409: ,p_attribute15 in varchar2 default hr_api.g_varchar2
410: ,p_attribute16 in varchar2 default hr_api.g_varchar2
411: ,p_attribute17 in varchar2 default hr_api.g_varchar2
412: ,p_attribute18 in varchar2 default hr_api.g_varchar2
413: ,p_attribute19 in varchar2 default hr_api.g_varchar2
406: ,p_attribute12 in varchar2 default hr_api.g_varchar2
407: ,p_attribute13 in varchar2 default hr_api.g_varchar2
408: ,p_attribute14 in varchar2 default hr_api.g_varchar2
409: ,p_attribute15 in varchar2 default hr_api.g_varchar2
410: ,p_attribute16 in varchar2 default hr_api.g_varchar2
411: ,p_attribute17 in varchar2 default hr_api.g_varchar2
412: ,p_attribute18 in varchar2 default hr_api.g_varchar2
413: ,p_attribute19 in varchar2 default hr_api.g_varchar2
414: ,p_attribute20 in varchar2 default hr_api.g_varchar2
407: ,p_attribute13 in varchar2 default hr_api.g_varchar2
408: ,p_attribute14 in varchar2 default hr_api.g_varchar2
409: ,p_attribute15 in varchar2 default hr_api.g_varchar2
410: ,p_attribute16 in varchar2 default hr_api.g_varchar2
411: ,p_attribute17 in varchar2 default hr_api.g_varchar2
412: ,p_attribute18 in varchar2 default hr_api.g_varchar2
413: ,p_attribute19 in varchar2 default hr_api.g_varchar2
414: ,p_attribute20 in varchar2 default hr_api.g_varchar2
415: ,p_information_category in varchar2 default hr_api.g_varchar2
408: ,p_attribute14 in varchar2 default hr_api.g_varchar2
409: ,p_attribute15 in varchar2 default hr_api.g_varchar2
410: ,p_attribute16 in varchar2 default hr_api.g_varchar2
411: ,p_attribute17 in varchar2 default hr_api.g_varchar2
412: ,p_attribute18 in varchar2 default hr_api.g_varchar2
413: ,p_attribute19 in varchar2 default hr_api.g_varchar2
414: ,p_attribute20 in varchar2 default hr_api.g_varchar2
415: ,p_information_category in varchar2 default hr_api.g_varchar2
416: ,p_information1 in varchar2 default hr_api.g_varchar2
409: ,p_attribute15 in varchar2 default hr_api.g_varchar2
410: ,p_attribute16 in varchar2 default hr_api.g_varchar2
411: ,p_attribute17 in varchar2 default hr_api.g_varchar2
412: ,p_attribute18 in varchar2 default hr_api.g_varchar2
413: ,p_attribute19 in varchar2 default hr_api.g_varchar2
414: ,p_attribute20 in varchar2 default hr_api.g_varchar2
415: ,p_information_category in varchar2 default hr_api.g_varchar2
416: ,p_information1 in varchar2 default hr_api.g_varchar2
417: ,p_information2 in varchar2 default hr_api.g_varchar2
410: ,p_attribute16 in varchar2 default hr_api.g_varchar2
411: ,p_attribute17 in varchar2 default hr_api.g_varchar2
412: ,p_attribute18 in varchar2 default hr_api.g_varchar2
413: ,p_attribute19 in varchar2 default hr_api.g_varchar2
414: ,p_attribute20 in varchar2 default hr_api.g_varchar2
415: ,p_information_category in varchar2 default hr_api.g_varchar2
416: ,p_information1 in varchar2 default hr_api.g_varchar2
417: ,p_information2 in varchar2 default hr_api.g_varchar2
418: ,p_information3 in varchar2 default hr_api.g_varchar2
411: ,p_attribute17 in varchar2 default hr_api.g_varchar2
412: ,p_attribute18 in varchar2 default hr_api.g_varchar2
413: ,p_attribute19 in varchar2 default hr_api.g_varchar2
414: ,p_attribute20 in varchar2 default hr_api.g_varchar2
415: ,p_information_category in varchar2 default hr_api.g_varchar2
416: ,p_information1 in varchar2 default hr_api.g_varchar2
417: ,p_information2 in varchar2 default hr_api.g_varchar2
418: ,p_information3 in varchar2 default hr_api.g_varchar2
419: ,p_information4 in varchar2 default hr_api.g_varchar2
412: ,p_attribute18 in varchar2 default hr_api.g_varchar2
413: ,p_attribute19 in varchar2 default hr_api.g_varchar2
414: ,p_attribute20 in varchar2 default hr_api.g_varchar2
415: ,p_information_category in varchar2 default hr_api.g_varchar2
416: ,p_information1 in varchar2 default hr_api.g_varchar2
417: ,p_information2 in varchar2 default hr_api.g_varchar2
418: ,p_information3 in varchar2 default hr_api.g_varchar2
419: ,p_information4 in varchar2 default hr_api.g_varchar2
420: ,p_information5 in varchar2 default hr_api.g_varchar2
413: ,p_attribute19 in varchar2 default hr_api.g_varchar2
414: ,p_attribute20 in varchar2 default hr_api.g_varchar2
415: ,p_information_category in varchar2 default hr_api.g_varchar2
416: ,p_information1 in varchar2 default hr_api.g_varchar2
417: ,p_information2 in varchar2 default hr_api.g_varchar2
418: ,p_information3 in varchar2 default hr_api.g_varchar2
419: ,p_information4 in varchar2 default hr_api.g_varchar2
420: ,p_information5 in varchar2 default hr_api.g_varchar2
421: ,p_information6 in varchar2 default hr_api.g_varchar2
414: ,p_attribute20 in varchar2 default hr_api.g_varchar2
415: ,p_information_category in varchar2 default hr_api.g_varchar2
416: ,p_information1 in varchar2 default hr_api.g_varchar2
417: ,p_information2 in varchar2 default hr_api.g_varchar2
418: ,p_information3 in varchar2 default hr_api.g_varchar2
419: ,p_information4 in varchar2 default hr_api.g_varchar2
420: ,p_information5 in varchar2 default hr_api.g_varchar2
421: ,p_information6 in varchar2 default hr_api.g_varchar2
422: ,p_information7 in varchar2 default hr_api.g_varchar2
415: ,p_information_category in varchar2 default hr_api.g_varchar2
416: ,p_information1 in varchar2 default hr_api.g_varchar2
417: ,p_information2 in varchar2 default hr_api.g_varchar2
418: ,p_information3 in varchar2 default hr_api.g_varchar2
419: ,p_information4 in varchar2 default hr_api.g_varchar2
420: ,p_information5 in varchar2 default hr_api.g_varchar2
421: ,p_information6 in varchar2 default hr_api.g_varchar2
422: ,p_information7 in varchar2 default hr_api.g_varchar2
423: ,p_information8 in varchar2 default hr_api.g_varchar2
416: ,p_information1 in varchar2 default hr_api.g_varchar2
417: ,p_information2 in varchar2 default hr_api.g_varchar2
418: ,p_information3 in varchar2 default hr_api.g_varchar2
419: ,p_information4 in varchar2 default hr_api.g_varchar2
420: ,p_information5 in varchar2 default hr_api.g_varchar2
421: ,p_information6 in varchar2 default hr_api.g_varchar2
422: ,p_information7 in varchar2 default hr_api.g_varchar2
423: ,p_information8 in varchar2 default hr_api.g_varchar2
424: ,p_information9 in varchar2 default hr_api.g_varchar2
417: ,p_information2 in varchar2 default hr_api.g_varchar2
418: ,p_information3 in varchar2 default hr_api.g_varchar2
419: ,p_information4 in varchar2 default hr_api.g_varchar2
420: ,p_information5 in varchar2 default hr_api.g_varchar2
421: ,p_information6 in varchar2 default hr_api.g_varchar2
422: ,p_information7 in varchar2 default hr_api.g_varchar2
423: ,p_information8 in varchar2 default hr_api.g_varchar2
424: ,p_information9 in varchar2 default hr_api.g_varchar2
425: ,p_information10 in varchar2 default hr_api.g_varchar2
418: ,p_information3 in varchar2 default hr_api.g_varchar2
419: ,p_information4 in varchar2 default hr_api.g_varchar2
420: ,p_information5 in varchar2 default hr_api.g_varchar2
421: ,p_information6 in varchar2 default hr_api.g_varchar2
422: ,p_information7 in varchar2 default hr_api.g_varchar2
423: ,p_information8 in varchar2 default hr_api.g_varchar2
424: ,p_information9 in varchar2 default hr_api.g_varchar2
425: ,p_information10 in varchar2 default hr_api.g_varchar2
426: ,p_information11 in varchar2 default hr_api.g_varchar2
419: ,p_information4 in varchar2 default hr_api.g_varchar2
420: ,p_information5 in varchar2 default hr_api.g_varchar2
421: ,p_information6 in varchar2 default hr_api.g_varchar2
422: ,p_information7 in varchar2 default hr_api.g_varchar2
423: ,p_information8 in varchar2 default hr_api.g_varchar2
424: ,p_information9 in varchar2 default hr_api.g_varchar2
425: ,p_information10 in varchar2 default hr_api.g_varchar2
426: ,p_information11 in varchar2 default hr_api.g_varchar2
427: ,p_information12 in varchar2 default hr_api.g_varchar2
420: ,p_information5 in varchar2 default hr_api.g_varchar2
421: ,p_information6 in varchar2 default hr_api.g_varchar2
422: ,p_information7 in varchar2 default hr_api.g_varchar2
423: ,p_information8 in varchar2 default hr_api.g_varchar2
424: ,p_information9 in varchar2 default hr_api.g_varchar2
425: ,p_information10 in varchar2 default hr_api.g_varchar2
426: ,p_information11 in varchar2 default hr_api.g_varchar2
427: ,p_information12 in varchar2 default hr_api.g_varchar2
428: ,p_information13 in varchar2 default hr_api.g_varchar2
421: ,p_information6 in varchar2 default hr_api.g_varchar2
422: ,p_information7 in varchar2 default hr_api.g_varchar2
423: ,p_information8 in varchar2 default hr_api.g_varchar2
424: ,p_information9 in varchar2 default hr_api.g_varchar2
425: ,p_information10 in varchar2 default hr_api.g_varchar2
426: ,p_information11 in varchar2 default hr_api.g_varchar2
427: ,p_information12 in varchar2 default hr_api.g_varchar2
428: ,p_information13 in varchar2 default hr_api.g_varchar2
429: ,p_information14 in varchar2 default hr_api.g_varchar2
422: ,p_information7 in varchar2 default hr_api.g_varchar2
423: ,p_information8 in varchar2 default hr_api.g_varchar2
424: ,p_information9 in varchar2 default hr_api.g_varchar2
425: ,p_information10 in varchar2 default hr_api.g_varchar2
426: ,p_information11 in varchar2 default hr_api.g_varchar2
427: ,p_information12 in varchar2 default hr_api.g_varchar2
428: ,p_information13 in varchar2 default hr_api.g_varchar2
429: ,p_information14 in varchar2 default hr_api.g_varchar2
430: ,p_information15 in varchar2 default hr_api.g_varchar2
423: ,p_information8 in varchar2 default hr_api.g_varchar2
424: ,p_information9 in varchar2 default hr_api.g_varchar2
425: ,p_information10 in varchar2 default hr_api.g_varchar2
426: ,p_information11 in varchar2 default hr_api.g_varchar2
427: ,p_information12 in varchar2 default hr_api.g_varchar2
428: ,p_information13 in varchar2 default hr_api.g_varchar2
429: ,p_information14 in varchar2 default hr_api.g_varchar2
430: ,p_information15 in varchar2 default hr_api.g_varchar2
431: ,p_information16 in varchar2 default hr_api.g_varchar2
424: ,p_information9 in varchar2 default hr_api.g_varchar2
425: ,p_information10 in varchar2 default hr_api.g_varchar2
426: ,p_information11 in varchar2 default hr_api.g_varchar2
427: ,p_information12 in varchar2 default hr_api.g_varchar2
428: ,p_information13 in varchar2 default hr_api.g_varchar2
429: ,p_information14 in varchar2 default hr_api.g_varchar2
430: ,p_information15 in varchar2 default hr_api.g_varchar2
431: ,p_information16 in varchar2 default hr_api.g_varchar2
432: ,p_information17 in varchar2 default hr_api.g_varchar2
425: ,p_information10 in varchar2 default hr_api.g_varchar2
426: ,p_information11 in varchar2 default hr_api.g_varchar2
427: ,p_information12 in varchar2 default hr_api.g_varchar2
428: ,p_information13 in varchar2 default hr_api.g_varchar2
429: ,p_information14 in varchar2 default hr_api.g_varchar2
430: ,p_information15 in varchar2 default hr_api.g_varchar2
431: ,p_information16 in varchar2 default hr_api.g_varchar2
432: ,p_information17 in varchar2 default hr_api.g_varchar2
433: ,p_information18 in varchar2 default hr_api.g_varchar2
426: ,p_information11 in varchar2 default hr_api.g_varchar2
427: ,p_information12 in varchar2 default hr_api.g_varchar2
428: ,p_information13 in varchar2 default hr_api.g_varchar2
429: ,p_information14 in varchar2 default hr_api.g_varchar2
430: ,p_information15 in varchar2 default hr_api.g_varchar2
431: ,p_information16 in varchar2 default hr_api.g_varchar2
432: ,p_information17 in varchar2 default hr_api.g_varchar2
433: ,p_information18 in varchar2 default hr_api.g_varchar2
434: ,p_information19 in varchar2 default hr_api.g_varchar2
427: ,p_information12 in varchar2 default hr_api.g_varchar2
428: ,p_information13 in varchar2 default hr_api.g_varchar2
429: ,p_information14 in varchar2 default hr_api.g_varchar2
430: ,p_information15 in varchar2 default hr_api.g_varchar2
431: ,p_information16 in varchar2 default hr_api.g_varchar2
432: ,p_information17 in varchar2 default hr_api.g_varchar2
433: ,p_information18 in varchar2 default hr_api.g_varchar2
434: ,p_information19 in varchar2 default hr_api.g_varchar2
435: ,p_information20 in varchar2 default hr_api.g_varchar2
428: ,p_information13 in varchar2 default hr_api.g_varchar2
429: ,p_information14 in varchar2 default hr_api.g_varchar2
430: ,p_information15 in varchar2 default hr_api.g_varchar2
431: ,p_information16 in varchar2 default hr_api.g_varchar2
432: ,p_information17 in varchar2 default hr_api.g_varchar2
433: ,p_information18 in varchar2 default hr_api.g_varchar2
434: ,p_information19 in varchar2 default hr_api.g_varchar2
435: ,p_information20 in varchar2 default hr_api.g_varchar2
436: ) is
429: ,p_information14 in varchar2 default hr_api.g_varchar2
430: ,p_information15 in varchar2 default hr_api.g_varchar2
431: ,p_information16 in varchar2 default hr_api.g_varchar2
432: ,p_information17 in varchar2 default hr_api.g_varchar2
433: ,p_information18 in varchar2 default hr_api.g_varchar2
434: ,p_information19 in varchar2 default hr_api.g_varchar2
435: ,p_information20 in varchar2 default hr_api.g_varchar2
436: ) is
437:
430: ,p_information15 in varchar2 default hr_api.g_varchar2
431: ,p_information16 in varchar2 default hr_api.g_varchar2
432: ,p_information17 in varchar2 default hr_api.g_varchar2
433: ,p_information18 in varchar2 default hr_api.g_varchar2
434: ,p_information19 in varchar2 default hr_api.g_varchar2
435: ,p_information20 in varchar2 default hr_api.g_varchar2
436: ) is
437:
438: --
431: ,p_information16 in varchar2 default hr_api.g_varchar2
432: ,p_information17 in varchar2 default hr_api.g_varchar2
433: ,p_information18 in varchar2 default hr_api.g_varchar2
434: ,p_information19 in varchar2 default hr_api.g_varchar2
435: ,p_information20 in varchar2 default hr_api.g_varchar2
436: ) is
437:
438: --
439: -- Declare cursors and local variables
548: ,p_information20 => p_information20
549: ,p_object_version_number => l_object_version_number
550: );
551: exception
552: when hr_api.cannot_find_prog_unit then
553: hr_api.cannot_find_prog_unit_error
554: (p_module_name => 'UPDATE_OUTCOME'
555: ,p_hook_type => 'BP'
556: );
549: ,p_object_version_number => l_object_version_number
550: );
551: exception
552: when hr_api.cannot_find_prog_unit then
553: hr_api.cannot_find_prog_unit_error
554: (p_module_name => 'UPDATE_OUTCOME'
555: ,p_hook_type => 'BP'
556: );
557: --
569: -- functions instead of p_language_code from now on, to allow an IN OUT
570: -- parameter to be passed through.
571: --
572: l_language_code := p_language_code;
573: hr_api.validate_language_code(p_language_code => l_language_code);
574:
575: hr_utility.set_location(l_proc, 40);
576:
577: l_object_version_number := p_object_version_number;
713: ,p_information19 => p_information19
714: ,p_information20 => p_information20
715: );
716: exception
717: when hr_api.cannot_find_prog_unit then
718: hr_api.cannot_find_prog_unit_error
719: (p_module_name => 'UPDATE_OUTCOME'
720: ,p_hook_type => 'AP'
721: );
714: ,p_information20 => p_information20
715: );
716: exception
717: when hr_api.cannot_find_prog_unit then
718: hr_api.cannot_find_prog_unit_error
719: (p_module_name => 'UPDATE_OUTCOME'
720: ,p_hook_type => 'AP'
721: );
722: --
728: --
729: -- If the outcome is end dated, associated outcome achieved should
730: -- change to 'IN_PROGRESS'
731: --
732: if p_date_from <> hr_api.g_date or p_date_to <> hr_api.g_date then
733: hr_utility.set_location(l_proc, 71);
734: hr_utility.trace('p_competence_id : ' || p_competence_id);
735: if (p_competence_id = hr_api.g_number) then
736: hr_utility.set_location(l_proc, 72);
731: --
732: if p_date_from <> hr_api.g_date or p_date_to <> hr_api.g_date then
733: hr_utility.set_location(l_proc, 71);
734: hr_utility.trace('p_competence_id : ' || p_competence_id);
735: if (p_competence_id = hr_api.g_number) then
736: hr_utility.set_location(l_proc, 72);
737: select competence_id into l_competence_id
738: from per_competence_outcomes
739: where outcome_id = p_outcome_id;
790: -- When in validation only mode raise the Validate_Enabled exception
791: --
792: if p_validate
793: then
794: raise hr_api.validate_enabled;
795: end if;
796: --
797: hr_utility.set_location(l_proc, 80);
798: --
803: hr_utility.set_location(' Leaving:' ||l_proc, 90);
804: --
805: exception
806: --
807: when hr_api.validate_enabled then
808: --
809: -- As the Validate_Enabled exception has been raised
810: -- we must rollback to the savepoint
811: --
889: (p_outcome_id => p_outcome_id
890: ,p_object_version_number => l_object_version_number
891: );
892: exception
893: when hr_api.cannot_find_prog_unit then
894: hr_api.cannot_find_prog_unit_error
895: (p_module_name => 'DELETE_OUTCOME'
896: ,p_hook_type => 'BP'
897: );
890: ,p_object_version_number => l_object_version_number
891: );
892: exception
893: when hr_api.cannot_find_prog_unit then
894: hr_api.cannot_find_prog_unit_error
895: (p_module_name => 'DELETE_OUTCOME'
896: ,p_hook_type => 'BP'
897: );
898: end;
937: (p_outcome_id => p_outcome_id
938: ,p_object_version_number => l_object_version_number
939: );
940: exception
941: when hr_api.cannot_find_prog_unit then
942: hr_api.cannot_find_prog_unit_error
943: (p_module_name => 'DELETE_OUTCOME'
944: ,p_hook_type => 'AP'
945: );
938: ,p_object_version_number => l_object_version_number
939: );
940: exception
941: when hr_api.cannot_find_prog_unit then
942: hr_api.cannot_find_prog_unit_error
943: (p_module_name => 'DELETE_OUTCOME'
944: ,p_hook_type => 'AP'
945: );
946: end;
986: --
987: -- When in validation only mode raise the Validate_Enabled exception
988: --
989: if p_validate then
990: raise hr_api.validate_enabled;
991: end if;
992:
993: --
994: -- Set all output arguments (returned by some dt modes only)
996: p_object_version_number := l_object_version_number;
997:
998: hr_utility.set_location(' Leaving:'||l_proc, 80);
999: exception
1000: when hr_api.validate_enabled then
1001: hr_utility.set_location(' Leaving...:'||l_proc, 90);
1002: --
1003: -- As the Validate_Enabled exception has been raised
1004: -- we must rollback to the savepoint