DBA Data[Home] [Help]

APPS.HR_COMPETENCE_OUTCOME_API dependencies on HR_API

Line 15: ,p_language_code in varchar2 default hr_api.userenv_lang

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

Line 157: when hr_api.cannot_find_prog_unit then

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: );

Line 158: hr_api.cannot_find_prog_unit_error

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: --

Line 178: hr_api.validate_language_code(p_language_code => l_language_code);

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: --

Line 315: when hr_api.cannot_find_prog_unit then

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: );

Line 316: hr_api.cannot_find_prog_unit_error

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: --

Line 332: raise hr_api.validate_enabled;

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: --

Line 346: when hr_api.validate_enabled then

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: --

Line 385: ,p_language_code in varchar2 default hr_api.userenv_lang

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

Line 388: ,p_competence_id 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

Line 389: ,p_outcome_number in number default hr_api.g_number

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

Line 390: ,p_name 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

Line 391: ,p_date_from in date default hr_api.g_date

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

Line 392: ,p_date_to in date default hr_api.g_date

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

Line 393: ,p_assessment_criteria 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

Line 394: ,p_attribute_category 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

Line 395: ,p_attribute1 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

Line 396: ,p_attribute2 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

Line 397: ,p_attribute3 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

Line 398: ,p_attribute4 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

Line 399: ,p_attribute5 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

Line 400: ,p_attribute6 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

Line 401: ,p_attribute7 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

Line 402: ,p_attribute8 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

Line 403: ,p_attribute9 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

Line 404: ,p_attribute10 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

Line 405: ,p_attribute11 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

Line 406: ,p_attribute12 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

Line 407: ,p_attribute13 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

Line 408: ,p_attribute14 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

Line 409: ,p_attribute15 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

Line 410: ,p_attribute16 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

Line 411: ,p_attribute17 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

Line 412: ,p_attribute18 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

Line 413: ,p_attribute19 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

Line 414: ,p_attribute20 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

Line 415: ,p_information_category 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

Line 416: ,p_information1 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

Line 417: ,p_information2 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

Line 418: ,p_information3 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

Line 419: ,p_information4 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

Line 420: ,p_information5 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

Line 421: ,p_information6 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

Line 422: ,p_information7 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

Line 423: ,p_information8 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

Line 424: ,p_information9 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

Line 425: ,p_information10 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

Line 426: ,p_information11 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

Line 427: ,p_information12 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

Line 428: ,p_information13 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

Line 429: ,p_information14 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

Line 430: ,p_information15 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

Line 431: ,p_information16 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

Line 432: ,p_information17 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

Line 433: ,p_information18 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
437:

Line 434: ,p_information19 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:
438: --

Line 435: ,p_information20 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: --
439: -- Declare cursors and local variables

Line 552: when hr_api.cannot_find_prog_unit then

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: );

Line 553: hr_api.cannot_find_prog_unit_error

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: --

Line 573: hr_api.validate_language_code(p_language_code => l_language_code);

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;

Line 717: when hr_api.cannot_find_prog_unit then

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: );

Line 718: hr_api.cannot_find_prog_unit_error

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: --

Line 732: if p_date_from <> hr_api.g_date or p_date_to <> hr_api.g_date then

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);

Line 735: if (p_competence_id = hr_api.g_number) then

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;

Line 794: raise hr_api.validate_enabled;

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: --

Line 807: when hr_api.validate_enabled then

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: --

Line 893: when hr_api.cannot_find_prog_unit then

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: );

Line 894: hr_api.cannot_find_prog_unit_error

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;

Line 941: when hr_api.cannot_find_prog_unit then

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: );

Line 942: hr_api.cannot_find_prog_unit_error

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;

Line 990: raise hr_api.validate_enabled;

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)

Line 1000: when hr_api.validate_enabled then

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