DBA Data[Home] [Help]

APPS.HR_PERSONAL_SCORECARD_API dependencies on HR_API

Line 174: when hr_api.cannot_find_prog_unit then

170: ,p_eligibility_status => p_eligibility_status
171: ,p_eligibility_eval_date => p_eligibility_eval_date
172: );
173: exception
174: when hr_api.cannot_find_prog_unit then
175: hr_api.cannot_find_prog_unit_error
176: (p_module_name => 'CREATE_SCORECARD'
177: ,p_hook_type => 'BP'
178: );

Line 175: hr_api.cannot_find_prog_unit_error

171: ,p_eligibility_eval_date => p_eligibility_eval_date
172: );
173: exception
174: when hr_api.cannot_find_prog_unit then
175: hr_api.cannot_find_prog_unit_error
176: (p_module_name => 'CREATE_SCORECARD'
177: ,p_hook_type => 'BP'
178: );
179: end;

Line 291: when hr_api.cannot_find_prog_unit then

287: ,p_eligibility_status => p_eligibility_status
288: ,p_eligibility_eval_date => p_eligibility_eval_date
289: );
290: exception
291: when hr_api.cannot_find_prog_unit then
292: hr_api.cannot_find_prog_unit_error
293: (p_module_name => 'CREATE_SCORECARD'
294: ,p_hook_type => 'AP'
295: );

Line 292: hr_api.cannot_find_prog_unit_error

288: ,p_eligibility_eval_date => p_eligibility_eval_date
289: );
290: exception
291: when hr_api.cannot_find_prog_unit then
292: hr_api.cannot_find_prog_unit_error
293: (p_module_name => 'CREATE_SCORECARD'
294: ,p_hook_type => 'AP'
295: );
296: end;

Line 303: raise hr_api.validate_enabled;

299: --
300: -- When in validation only mode raise the Validate_Enabled exception
301: --
302: if p_validate then
303: raise hr_api.validate_enabled;
304: end if;
305: --
306: -- Set all IN OUT and OUT parameters with out values
307: --

Line 346: when hr_api.validate_enabled then

342:
343: END IF;
344:
345: exception
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 388: ,p_scorecard_name in varchar2 default hr_api.g_varchar2

384: (p_validate in boolean default false
385: ,p_effective_date in date
386: ,p_scorecard_id in number
387: ,p_object_version_number in out nocopy number
388: ,p_scorecard_name in varchar2 default hr_api.g_varchar2
389: ,p_start_date in date default hr_api.g_date
390: ,p_end_date in date default hr_api.g_date
391: ,p_plan_id in number default hr_api.g_number
392: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 389: ,p_start_date in date default hr_api.g_date

385: ,p_effective_date in date
386: ,p_scorecard_id in number
387: ,p_object_version_number in out nocopy number
388: ,p_scorecard_name in varchar2 default hr_api.g_varchar2
389: ,p_start_date in date default hr_api.g_date
390: ,p_end_date in date default hr_api.g_date
391: ,p_plan_id in number default hr_api.g_number
392: ,p_attribute_category in varchar2 default hr_api.g_varchar2
393: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 390: ,p_end_date in date default hr_api.g_date

386: ,p_scorecard_id in number
387: ,p_object_version_number in out nocopy number
388: ,p_scorecard_name in varchar2 default hr_api.g_varchar2
389: ,p_start_date in date default hr_api.g_date
390: ,p_end_date in date default hr_api.g_date
391: ,p_plan_id in number default hr_api.g_number
392: ,p_attribute_category in varchar2 default hr_api.g_varchar2
393: ,p_attribute1 in varchar2 default hr_api.g_varchar2
394: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 391: ,p_plan_id in number default hr_api.g_number

387: ,p_object_version_number in out nocopy number
388: ,p_scorecard_name in varchar2 default hr_api.g_varchar2
389: ,p_start_date in date default hr_api.g_date
390: ,p_end_date in date default hr_api.g_date
391: ,p_plan_id in number default hr_api.g_number
392: ,p_attribute_category in varchar2 default hr_api.g_varchar2
393: ,p_attribute1 in varchar2 default hr_api.g_varchar2
394: ,p_attribute2 in varchar2 default hr_api.g_varchar2
395: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 392: ,p_attribute_category in varchar2 default hr_api.g_varchar2

388: ,p_scorecard_name in varchar2 default hr_api.g_varchar2
389: ,p_start_date in date default hr_api.g_date
390: ,p_end_date in date default hr_api.g_date
391: ,p_plan_id in number default hr_api.g_number
392: ,p_attribute_category in varchar2 default hr_api.g_varchar2
393: ,p_attribute1 in varchar2 default hr_api.g_varchar2
394: ,p_attribute2 in varchar2 default hr_api.g_varchar2
395: ,p_attribute3 in varchar2 default hr_api.g_varchar2
396: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 393: ,p_attribute1 in varchar2 default hr_api.g_varchar2

389: ,p_start_date in date default hr_api.g_date
390: ,p_end_date in date default hr_api.g_date
391: ,p_plan_id in number default hr_api.g_number
392: ,p_attribute_category in varchar2 default hr_api.g_varchar2
393: ,p_attribute1 in varchar2 default hr_api.g_varchar2
394: ,p_attribute2 in varchar2 default hr_api.g_varchar2
395: ,p_attribute3 in varchar2 default hr_api.g_varchar2
396: ,p_attribute4 in varchar2 default hr_api.g_varchar2
397: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 394: ,p_attribute2 in varchar2 default hr_api.g_varchar2

390: ,p_end_date in date default hr_api.g_date
391: ,p_plan_id in number default hr_api.g_number
392: ,p_attribute_category in varchar2 default hr_api.g_varchar2
393: ,p_attribute1 in varchar2 default hr_api.g_varchar2
394: ,p_attribute2 in varchar2 default hr_api.g_varchar2
395: ,p_attribute3 in varchar2 default hr_api.g_varchar2
396: ,p_attribute4 in varchar2 default hr_api.g_varchar2
397: ,p_attribute5 in varchar2 default hr_api.g_varchar2
398: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 395: ,p_attribute3 in varchar2 default hr_api.g_varchar2

391: ,p_plan_id in number default hr_api.g_number
392: ,p_attribute_category in varchar2 default hr_api.g_varchar2
393: ,p_attribute1 in varchar2 default hr_api.g_varchar2
394: ,p_attribute2 in varchar2 default hr_api.g_varchar2
395: ,p_attribute3 in varchar2 default hr_api.g_varchar2
396: ,p_attribute4 in varchar2 default hr_api.g_varchar2
397: ,p_attribute5 in varchar2 default hr_api.g_varchar2
398: ,p_attribute6 in varchar2 default hr_api.g_varchar2
399: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 396: ,p_attribute4 in varchar2 default hr_api.g_varchar2

392: ,p_attribute_category in varchar2 default hr_api.g_varchar2
393: ,p_attribute1 in varchar2 default hr_api.g_varchar2
394: ,p_attribute2 in varchar2 default hr_api.g_varchar2
395: ,p_attribute3 in varchar2 default hr_api.g_varchar2
396: ,p_attribute4 in varchar2 default hr_api.g_varchar2
397: ,p_attribute5 in varchar2 default hr_api.g_varchar2
398: ,p_attribute6 in varchar2 default hr_api.g_varchar2
399: ,p_attribute7 in varchar2 default hr_api.g_varchar2
400: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 397: ,p_attribute5 in varchar2 default hr_api.g_varchar2

393: ,p_attribute1 in varchar2 default hr_api.g_varchar2
394: ,p_attribute2 in varchar2 default hr_api.g_varchar2
395: ,p_attribute3 in varchar2 default hr_api.g_varchar2
396: ,p_attribute4 in varchar2 default hr_api.g_varchar2
397: ,p_attribute5 in varchar2 default hr_api.g_varchar2
398: ,p_attribute6 in varchar2 default hr_api.g_varchar2
399: ,p_attribute7 in varchar2 default hr_api.g_varchar2
400: ,p_attribute8 in varchar2 default hr_api.g_varchar2
401: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 398: ,p_attribute6 in varchar2 default hr_api.g_varchar2

394: ,p_attribute2 in varchar2 default hr_api.g_varchar2
395: ,p_attribute3 in varchar2 default hr_api.g_varchar2
396: ,p_attribute4 in varchar2 default hr_api.g_varchar2
397: ,p_attribute5 in varchar2 default hr_api.g_varchar2
398: ,p_attribute6 in varchar2 default hr_api.g_varchar2
399: ,p_attribute7 in varchar2 default hr_api.g_varchar2
400: ,p_attribute8 in varchar2 default hr_api.g_varchar2
401: ,p_attribute9 in varchar2 default hr_api.g_varchar2
402: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 399: ,p_attribute7 in varchar2 default hr_api.g_varchar2

395: ,p_attribute3 in varchar2 default hr_api.g_varchar2
396: ,p_attribute4 in varchar2 default hr_api.g_varchar2
397: ,p_attribute5 in varchar2 default hr_api.g_varchar2
398: ,p_attribute6 in varchar2 default hr_api.g_varchar2
399: ,p_attribute7 in varchar2 default hr_api.g_varchar2
400: ,p_attribute8 in varchar2 default hr_api.g_varchar2
401: ,p_attribute9 in varchar2 default hr_api.g_varchar2
402: ,p_attribute10 in varchar2 default hr_api.g_varchar2
403: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 400: ,p_attribute8 in varchar2 default hr_api.g_varchar2

396: ,p_attribute4 in varchar2 default hr_api.g_varchar2
397: ,p_attribute5 in varchar2 default hr_api.g_varchar2
398: ,p_attribute6 in varchar2 default hr_api.g_varchar2
399: ,p_attribute7 in varchar2 default hr_api.g_varchar2
400: ,p_attribute8 in varchar2 default hr_api.g_varchar2
401: ,p_attribute9 in varchar2 default hr_api.g_varchar2
402: ,p_attribute10 in varchar2 default hr_api.g_varchar2
403: ,p_attribute11 in varchar2 default hr_api.g_varchar2
404: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 401: ,p_attribute9 in varchar2 default hr_api.g_varchar2

397: ,p_attribute5 in varchar2 default hr_api.g_varchar2
398: ,p_attribute6 in varchar2 default hr_api.g_varchar2
399: ,p_attribute7 in varchar2 default hr_api.g_varchar2
400: ,p_attribute8 in varchar2 default hr_api.g_varchar2
401: ,p_attribute9 in varchar2 default hr_api.g_varchar2
402: ,p_attribute10 in varchar2 default hr_api.g_varchar2
403: ,p_attribute11 in varchar2 default hr_api.g_varchar2
404: ,p_attribute12 in varchar2 default hr_api.g_varchar2
405: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 402: ,p_attribute10 in varchar2 default hr_api.g_varchar2

398: ,p_attribute6 in varchar2 default hr_api.g_varchar2
399: ,p_attribute7 in varchar2 default hr_api.g_varchar2
400: ,p_attribute8 in varchar2 default hr_api.g_varchar2
401: ,p_attribute9 in varchar2 default hr_api.g_varchar2
402: ,p_attribute10 in varchar2 default hr_api.g_varchar2
403: ,p_attribute11 in varchar2 default hr_api.g_varchar2
404: ,p_attribute12 in varchar2 default hr_api.g_varchar2
405: ,p_attribute13 in varchar2 default hr_api.g_varchar2
406: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 403: ,p_attribute11 in varchar2 default hr_api.g_varchar2

399: ,p_attribute7 in varchar2 default hr_api.g_varchar2
400: ,p_attribute8 in varchar2 default hr_api.g_varchar2
401: ,p_attribute9 in varchar2 default hr_api.g_varchar2
402: ,p_attribute10 in varchar2 default hr_api.g_varchar2
403: ,p_attribute11 in varchar2 default hr_api.g_varchar2
404: ,p_attribute12 in varchar2 default hr_api.g_varchar2
405: ,p_attribute13 in varchar2 default hr_api.g_varchar2
406: ,p_attribute14 in varchar2 default hr_api.g_varchar2
407: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 404: ,p_attribute12 in varchar2 default hr_api.g_varchar2

400: ,p_attribute8 in varchar2 default hr_api.g_varchar2
401: ,p_attribute9 in varchar2 default hr_api.g_varchar2
402: ,p_attribute10 in varchar2 default hr_api.g_varchar2
403: ,p_attribute11 in varchar2 default hr_api.g_varchar2
404: ,p_attribute12 in varchar2 default hr_api.g_varchar2
405: ,p_attribute13 in varchar2 default hr_api.g_varchar2
406: ,p_attribute14 in varchar2 default hr_api.g_varchar2
407: ,p_attribute15 in varchar2 default hr_api.g_varchar2
408: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 405: ,p_attribute13 in varchar2 default hr_api.g_varchar2

401: ,p_attribute9 in varchar2 default hr_api.g_varchar2
402: ,p_attribute10 in varchar2 default hr_api.g_varchar2
403: ,p_attribute11 in varchar2 default hr_api.g_varchar2
404: ,p_attribute12 in varchar2 default hr_api.g_varchar2
405: ,p_attribute13 in varchar2 default hr_api.g_varchar2
406: ,p_attribute14 in varchar2 default hr_api.g_varchar2
407: ,p_attribute15 in varchar2 default hr_api.g_varchar2
408: ,p_attribute16 in varchar2 default hr_api.g_varchar2
409: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 406: ,p_attribute14 in varchar2 default hr_api.g_varchar2

402: ,p_attribute10 in varchar2 default hr_api.g_varchar2
403: ,p_attribute11 in varchar2 default hr_api.g_varchar2
404: ,p_attribute12 in varchar2 default hr_api.g_varchar2
405: ,p_attribute13 in varchar2 default hr_api.g_varchar2
406: ,p_attribute14 in varchar2 default hr_api.g_varchar2
407: ,p_attribute15 in varchar2 default hr_api.g_varchar2
408: ,p_attribute16 in varchar2 default hr_api.g_varchar2
409: ,p_attribute17 in varchar2 default hr_api.g_varchar2
410: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 407: ,p_attribute15 in varchar2 default hr_api.g_varchar2

403: ,p_attribute11 in varchar2 default hr_api.g_varchar2
404: ,p_attribute12 in varchar2 default hr_api.g_varchar2
405: ,p_attribute13 in varchar2 default hr_api.g_varchar2
406: ,p_attribute14 in varchar2 default hr_api.g_varchar2
407: ,p_attribute15 in varchar2 default hr_api.g_varchar2
408: ,p_attribute16 in varchar2 default hr_api.g_varchar2
409: ,p_attribute17 in varchar2 default hr_api.g_varchar2
410: ,p_attribute18 in varchar2 default hr_api.g_varchar2
411: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 408: ,p_attribute16 in varchar2 default hr_api.g_varchar2

404: ,p_attribute12 in varchar2 default hr_api.g_varchar2
405: ,p_attribute13 in varchar2 default hr_api.g_varchar2
406: ,p_attribute14 in varchar2 default hr_api.g_varchar2
407: ,p_attribute15 in varchar2 default hr_api.g_varchar2
408: ,p_attribute16 in varchar2 default hr_api.g_varchar2
409: ,p_attribute17 in varchar2 default hr_api.g_varchar2
410: ,p_attribute18 in varchar2 default hr_api.g_varchar2
411: ,p_attribute19 in varchar2 default hr_api.g_varchar2
412: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 409: ,p_attribute17 in varchar2 default hr_api.g_varchar2

405: ,p_attribute13 in varchar2 default hr_api.g_varchar2
406: ,p_attribute14 in varchar2 default hr_api.g_varchar2
407: ,p_attribute15 in varchar2 default hr_api.g_varchar2
408: ,p_attribute16 in varchar2 default hr_api.g_varchar2
409: ,p_attribute17 in varchar2 default hr_api.g_varchar2
410: ,p_attribute18 in varchar2 default hr_api.g_varchar2
411: ,p_attribute19 in varchar2 default hr_api.g_varchar2
412: ,p_attribute20 in varchar2 default hr_api.g_varchar2
413: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 410: ,p_attribute18 in varchar2 default hr_api.g_varchar2

406: ,p_attribute14 in varchar2 default hr_api.g_varchar2
407: ,p_attribute15 in varchar2 default hr_api.g_varchar2
408: ,p_attribute16 in varchar2 default hr_api.g_varchar2
409: ,p_attribute17 in varchar2 default hr_api.g_varchar2
410: ,p_attribute18 in varchar2 default hr_api.g_varchar2
411: ,p_attribute19 in varchar2 default hr_api.g_varchar2
412: ,p_attribute20 in varchar2 default hr_api.g_varchar2
413: ,p_attribute21 in varchar2 default hr_api.g_varchar2
414: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 411: ,p_attribute19 in varchar2 default hr_api.g_varchar2

407: ,p_attribute15 in varchar2 default hr_api.g_varchar2
408: ,p_attribute16 in varchar2 default hr_api.g_varchar2
409: ,p_attribute17 in varchar2 default hr_api.g_varchar2
410: ,p_attribute18 in varchar2 default hr_api.g_varchar2
411: ,p_attribute19 in varchar2 default hr_api.g_varchar2
412: ,p_attribute20 in varchar2 default hr_api.g_varchar2
413: ,p_attribute21 in varchar2 default hr_api.g_varchar2
414: ,p_attribute22 in varchar2 default hr_api.g_varchar2
415: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 412: ,p_attribute20 in varchar2 default hr_api.g_varchar2

408: ,p_attribute16 in varchar2 default hr_api.g_varchar2
409: ,p_attribute17 in varchar2 default hr_api.g_varchar2
410: ,p_attribute18 in varchar2 default hr_api.g_varchar2
411: ,p_attribute19 in varchar2 default hr_api.g_varchar2
412: ,p_attribute20 in varchar2 default hr_api.g_varchar2
413: ,p_attribute21 in varchar2 default hr_api.g_varchar2
414: ,p_attribute22 in varchar2 default hr_api.g_varchar2
415: ,p_attribute23 in varchar2 default hr_api.g_varchar2
416: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 413: ,p_attribute21 in varchar2 default hr_api.g_varchar2

409: ,p_attribute17 in varchar2 default hr_api.g_varchar2
410: ,p_attribute18 in varchar2 default hr_api.g_varchar2
411: ,p_attribute19 in varchar2 default hr_api.g_varchar2
412: ,p_attribute20 in varchar2 default hr_api.g_varchar2
413: ,p_attribute21 in varchar2 default hr_api.g_varchar2
414: ,p_attribute22 in varchar2 default hr_api.g_varchar2
415: ,p_attribute23 in varchar2 default hr_api.g_varchar2
416: ,p_attribute24 in varchar2 default hr_api.g_varchar2
417: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 414: ,p_attribute22 in varchar2 default hr_api.g_varchar2

410: ,p_attribute18 in varchar2 default hr_api.g_varchar2
411: ,p_attribute19 in varchar2 default hr_api.g_varchar2
412: ,p_attribute20 in varchar2 default hr_api.g_varchar2
413: ,p_attribute21 in varchar2 default hr_api.g_varchar2
414: ,p_attribute22 in varchar2 default hr_api.g_varchar2
415: ,p_attribute23 in varchar2 default hr_api.g_varchar2
416: ,p_attribute24 in varchar2 default hr_api.g_varchar2
417: ,p_attribute25 in varchar2 default hr_api.g_varchar2
418: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 415: ,p_attribute23 in varchar2 default hr_api.g_varchar2

411: ,p_attribute19 in varchar2 default hr_api.g_varchar2
412: ,p_attribute20 in varchar2 default hr_api.g_varchar2
413: ,p_attribute21 in varchar2 default hr_api.g_varchar2
414: ,p_attribute22 in varchar2 default hr_api.g_varchar2
415: ,p_attribute23 in varchar2 default hr_api.g_varchar2
416: ,p_attribute24 in varchar2 default hr_api.g_varchar2
417: ,p_attribute25 in varchar2 default hr_api.g_varchar2
418: ,p_attribute26 in varchar2 default hr_api.g_varchar2
419: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 416: ,p_attribute24 in varchar2 default hr_api.g_varchar2

412: ,p_attribute20 in varchar2 default hr_api.g_varchar2
413: ,p_attribute21 in varchar2 default hr_api.g_varchar2
414: ,p_attribute22 in varchar2 default hr_api.g_varchar2
415: ,p_attribute23 in varchar2 default hr_api.g_varchar2
416: ,p_attribute24 in varchar2 default hr_api.g_varchar2
417: ,p_attribute25 in varchar2 default hr_api.g_varchar2
418: ,p_attribute26 in varchar2 default hr_api.g_varchar2
419: ,p_attribute27 in varchar2 default hr_api.g_varchar2
420: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 417: ,p_attribute25 in varchar2 default hr_api.g_varchar2

413: ,p_attribute21 in varchar2 default hr_api.g_varchar2
414: ,p_attribute22 in varchar2 default hr_api.g_varchar2
415: ,p_attribute23 in varchar2 default hr_api.g_varchar2
416: ,p_attribute24 in varchar2 default hr_api.g_varchar2
417: ,p_attribute25 in varchar2 default hr_api.g_varchar2
418: ,p_attribute26 in varchar2 default hr_api.g_varchar2
419: ,p_attribute27 in varchar2 default hr_api.g_varchar2
420: ,p_attribute28 in varchar2 default hr_api.g_varchar2
421: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 418: ,p_attribute26 in varchar2 default hr_api.g_varchar2

414: ,p_attribute22 in varchar2 default hr_api.g_varchar2
415: ,p_attribute23 in varchar2 default hr_api.g_varchar2
416: ,p_attribute24 in varchar2 default hr_api.g_varchar2
417: ,p_attribute25 in varchar2 default hr_api.g_varchar2
418: ,p_attribute26 in varchar2 default hr_api.g_varchar2
419: ,p_attribute27 in varchar2 default hr_api.g_varchar2
420: ,p_attribute28 in varchar2 default hr_api.g_varchar2
421: ,p_attribute29 in varchar2 default hr_api.g_varchar2
422: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 419: ,p_attribute27 in varchar2 default hr_api.g_varchar2

415: ,p_attribute23 in varchar2 default hr_api.g_varchar2
416: ,p_attribute24 in varchar2 default hr_api.g_varchar2
417: ,p_attribute25 in varchar2 default hr_api.g_varchar2
418: ,p_attribute26 in varchar2 default hr_api.g_varchar2
419: ,p_attribute27 in varchar2 default hr_api.g_varchar2
420: ,p_attribute28 in varchar2 default hr_api.g_varchar2
421: ,p_attribute29 in varchar2 default hr_api.g_varchar2
422: ,p_attribute30 in varchar2 default hr_api.g_varchar2
423: ,p_status_code in varchar2 default hr_api.g_varchar2

Line 420: ,p_attribute28 in varchar2 default hr_api.g_varchar2

416: ,p_attribute24 in varchar2 default hr_api.g_varchar2
417: ,p_attribute25 in varchar2 default hr_api.g_varchar2
418: ,p_attribute26 in varchar2 default hr_api.g_varchar2
419: ,p_attribute27 in varchar2 default hr_api.g_varchar2
420: ,p_attribute28 in varchar2 default hr_api.g_varchar2
421: ,p_attribute29 in varchar2 default hr_api.g_varchar2
422: ,p_attribute30 in varchar2 default hr_api.g_varchar2
423: ,p_status_code in varchar2 default hr_api.g_varchar2
424: ,p_duplicate_name_warning out nocopy boolean

Line 421: ,p_attribute29 in varchar2 default hr_api.g_varchar2

417: ,p_attribute25 in varchar2 default hr_api.g_varchar2
418: ,p_attribute26 in varchar2 default hr_api.g_varchar2
419: ,p_attribute27 in varchar2 default hr_api.g_varchar2
420: ,p_attribute28 in varchar2 default hr_api.g_varchar2
421: ,p_attribute29 in varchar2 default hr_api.g_varchar2
422: ,p_attribute30 in varchar2 default hr_api.g_varchar2
423: ,p_status_code in varchar2 default hr_api.g_varchar2
424: ,p_duplicate_name_warning out nocopy boolean
425: ,p_obj_setting_deadline in date default hr_api.g_date

Line 422: ,p_attribute30 in varchar2 default hr_api.g_varchar2

418: ,p_attribute26 in varchar2 default hr_api.g_varchar2
419: ,p_attribute27 in varchar2 default hr_api.g_varchar2
420: ,p_attribute28 in varchar2 default hr_api.g_varchar2
421: ,p_attribute29 in varchar2 default hr_api.g_varchar2
422: ,p_attribute30 in varchar2 default hr_api.g_varchar2
423: ,p_status_code in varchar2 default hr_api.g_varchar2
424: ,p_duplicate_name_warning out nocopy boolean
425: ,p_obj_setting_deadline in date default hr_api.g_date
426: ,p_supervisor_id in number default hr_api.g_number

Line 423: ,p_status_code in varchar2 default hr_api.g_varchar2

419: ,p_attribute27 in varchar2 default hr_api.g_varchar2
420: ,p_attribute28 in varchar2 default hr_api.g_varchar2
421: ,p_attribute29 in varchar2 default hr_api.g_varchar2
422: ,p_attribute30 in varchar2 default hr_api.g_varchar2
423: ,p_status_code in varchar2 default hr_api.g_varchar2
424: ,p_duplicate_name_warning out nocopy boolean
425: ,p_obj_setting_deadline in date default hr_api.g_date
426: ,p_supervisor_id in number default hr_api.g_number
427: ,p_supervisor_assignment_id in number default hr_api.g_number

Line 425: ,p_obj_setting_deadline in date default hr_api.g_date

421: ,p_attribute29 in varchar2 default hr_api.g_varchar2
422: ,p_attribute30 in varchar2 default hr_api.g_varchar2
423: ,p_status_code in varchar2 default hr_api.g_varchar2
424: ,p_duplicate_name_warning out nocopy boolean
425: ,p_obj_setting_deadline in date default hr_api.g_date
426: ,p_supervisor_id in number default hr_api.g_number
427: ,p_supervisor_assignment_id in number default hr_api.g_number
428: ,p_eligibility_status in varchar2 default hr_api.g_varchar2
429: ,p_eligibility_eval_date in date default hr_api.g_date

Line 426: ,p_supervisor_id in number default hr_api.g_number

422: ,p_attribute30 in varchar2 default hr_api.g_varchar2
423: ,p_status_code in varchar2 default hr_api.g_varchar2
424: ,p_duplicate_name_warning out nocopy boolean
425: ,p_obj_setting_deadline in date default hr_api.g_date
426: ,p_supervisor_id in number default hr_api.g_number
427: ,p_supervisor_assignment_id in number default hr_api.g_number
428: ,p_eligibility_status in varchar2 default hr_api.g_varchar2
429: ,p_eligibility_eval_date in date default hr_api.g_date
430: ) is

Line 427: ,p_supervisor_assignment_id in number default hr_api.g_number

423: ,p_status_code in varchar2 default hr_api.g_varchar2
424: ,p_duplicate_name_warning out nocopy boolean
425: ,p_obj_setting_deadline in date default hr_api.g_date
426: ,p_supervisor_id in number default hr_api.g_number
427: ,p_supervisor_assignment_id in number default hr_api.g_number
428: ,p_eligibility_status in varchar2 default hr_api.g_varchar2
429: ,p_eligibility_eval_date in date default hr_api.g_date
430: ) is
431: --

Line 428: ,p_eligibility_status in varchar2 default hr_api.g_varchar2

424: ,p_duplicate_name_warning out nocopy boolean
425: ,p_obj_setting_deadline in date default hr_api.g_date
426: ,p_supervisor_id in number default hr_api.g_number
427: ,p_supervisor_assignment_id in number default hr_api.g_number
428: ,p_eligibility_status in varchar2 default hr_api.g_varchar2
429: ,p_eligibility_eval_date in date default hr_api.g_date
430: ) is
431: --
432: -- Declare cursors and local variables

Line 429: ,p_eligibility_eval_date in date default hr_api.g_date

425: ,p_obj_setting_deadline in date default hr_api.g_date
426: ,p_supervisor_id in number default hr_api.g_number
427: ,p_supervisor_assignment_id in number default hr_api.g_number
428: ,p_eligibility_status in varchar2 default hr_api.g_varchar2
429: ,p_eligibility_eval_date in date default hr_api.g_date
430: ) is
431: --
432: -- Declare cursors and local variables
433: --

Line 537: when hr_api.cannot_find_prog_unit then

533: ,p_eligibility_status => p_eligibility_status
534: ,p_eligibility_eval_date => p_eligibility_eval_date
535: );
536: exception
537: when hr_api.cannot_find_prog_unit then
538: hr_api.cannot_find_prog_unit_error
539: (p_module_name => 'UPDATE_SCORECARD'
540: ,p_hook_type => 'BP'
541: );

Line 538: hr_api.cannot_find_prog_unit_error

534: ,p_eligibility_eval_date => p_eligibility_eval_date
535: );
536: exception
537: when hr_api.cannot_find_prog_unit then
538: hr_api.cannot_find_prog_unit_error
539: (p_module_name => 'UPDATE_SCORECARD'
540: ,p_hook_type => 'BP'
541: );
542: end;

Line 649: when hr_api.cannot_find_prog_unit then

645: ,p_eligibility_status => p_eligibility_status
646: ,p_eligibility_eval_date => p_eligibility_eval_date
647: );
648: exception
649: when hr_api.cannot_find_prog_unit then
650: hr_api.cannot_find_prog_unit_error
651: (p_module_name => 'UPDATE_SCORECARD'
652: ,p_hook_type => 'AP'
653: );

Line 650: hr_api.cannot_find_prog_unit_error

646: ,p_eligibility_eval_date => p_eligibility_eval_date
647: );
648: exception
649: when hr_api.cannot_find_prog_unit then
650: hr_api.cannot_find_prog_unit_error
651: (p_module_name => 'UPDATE_SCORECARD'
652: ,p_hook_type => 'AP'
653: );
654: end;

Line 661: raise hr_api.validate_enabled;

657: --
658: -- When in validation only mode raise the Validate_Enabled exception
659: --
660: if p_validate then
661: raise hr_api.validate_enabled;
662: end if;
663: --
664: -- Set all IN OUT and OUT parameters with out values
665: --

Line 698: when hr_api.validate_enabled then

694:
695: END IF;
696:
697: exception
698: when hr_api.validate_enabled then
699: --
700: -- As the Validate_Enabled exception has been raised
701: -- we must rollback to the savepoint
702: --

Line 794: when hr_api.cannot_find_prog_unit then

790: ,p_object_version_number => l_object_version_number
791: ,p_status_code => p_status_code
792: );
793: exception
794: when hr_api.cannot_find_prog_unit then
795: hr_api.cannot_find_prog_unit_error
796: (p_module_name => 'UPDATE_SCORECARD_STATUS'
797: ,p_hook_type => 'BP'
798: );

Line 795: hr_api.cannot_find_prog_unit_error

791: ,p_status_code => p_status_code
792: );
793: exception
794: when hr_api.cannot_find_prog_unit then
795: hr_api.cannot_find_prog_unit_error
796: (p_module_name => 'UPDATE_SCORECARD_STATUS'
797: ,p_hook_type => 'BP'
798: );
799: end;

Line 825: when hr_api.cannot_find_prog_unit then

821: ,p_object_version_number => l_object_version_number
822: ,p_status_code => p_status_code
823: );
824: exception
825: when hr_api.cannot_find_prog_unit then
826: hr_api.cannot_find_prog_unit_error
827: (p_module_name => 'UPDATE_SCORECARD_STATUS'
828: ,p_hook_type => 'AP'
829: );

Line 826: hr_api.cannot_find_prog_unit_error

822: ,p_status_code => p_status_code
823: );
824: exception
825: when hr_api.cannot_find_prog_unit then
826: hr_api.cannot_find_prog_unit_error
827: (p_module_name => 'UPDATE_SCORECARD_STATUS'
828: ,p_hook_type => 'AP'
829: );
830: end;

Line 837: raise hr_api.validate_enabled;

833: --
834: -- When in validation only mode raise the Validate_Enabled exception
835: --
836: if p_validate then
837: raise hr_api.validate_enabled;
838: end if;
839: --
840: -- Set all IN OUT and OUT parameters with out values
841: --

Line 865: when hr_api.validate_enabled then

861:
862: END IF;
863:
864: exception
865: when hr_api.validate_enabled then
866: --
867: -- As the Validate_Enabled exception has been raised
868: -- we must rollback to the savepoint
869: --

Line 948: when hr_api.cannot_find_prog_unit then

944: (p_scorecard_id => p_scorecard_id
945: ,p_object_version_number => p_object_version_number
946: );
947: exception
948: when hr_api.cannot_find_prog_unit then
949: hr_api.cannot_find_prog_unit_error
950: (p_module_name => 'DELETE_SCORECARD'
951: ,p_hook_type => 'BP'
952: );

Line 949: hr_api.cannot_find_prog_unit_error

945: ,p_object_version_number => p_object_version_number
946: );
947: exception
948: when hr_api.cannot_find_prog_unit then
949: hr_api.cannot_find_prog_unit_error
950: (p_module_name => 'DELETE_SCORECARD'
951: ,p_hook_type => 'BP'
952: );
953: end;

Line 976: when hr_api.cannot_find_prog_unit then

972: ,p_object_version_number => p_object_version_number
973: ,p_created_by_plan_warning => l_created_by_plan_warning
974: );
975: exception
976: when hr_api.cannot_find_prog_unit then
977: hr_api.cannot_find_prog_unit_error
978: (p_module_name => 'DELETE_SCORECARD'
979: ,p_hook_type => 'AP'
980: );

Line 977: hr_api.cannot_find_prog_unit_error

973: ,p_created_by_plan_warning => l_created_by_plan_warning
974: );
975: exception
976: when hr_api.cannot_find_prog_unit then
977: hr_api.cannot_find_prog_unit_error
978: (p_module_name => 'DELETE_SCORECARD'
979: ,p_hook_type => 'AP'
980: );
981: end;

Line 988: raise hr_api.validate_enabled;

984: --
985: -- When in validation only mode raise the Validate_Enabled exception
986: --
987: if p_validate then
988: raise hr_api.validate_enabled;
989: end if;
990: --
991: -- Set all IN OUT and OUT parameters with out values
992: --

Line 1024: when hr_api.validate_enabled then

1020:
1021: END IF;
1022:
1023: exception
1024: when hr_api.validate_enabled then
1025: --
1026: -- As the Validate_Enabled exception has been raised
1027: -- we must rollback to the savepoint
1028: --