APPS.PER_PRV_UPD dependencies on HR_API

Line 115: When hr_api.check_integrity_violated Then

111: --
112: hr_utility.set_location(' Leaving:'||l_proc, 10);
113: --
114: Exception
115: When hr_api.check_integrity_violated Then
116: -- A check constraint has been violated
117: per_prv_shd.g_api_dml := false; -- Unset the api dml status
118: per_prv_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

115: When hr_api.check_integrity_violated Then
116: -- A check constraint has been violated
117: per_prv_shd.g_api_dml := false; -- Unset the api dml status
118: per_prv_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.parent_integrity_violated Then
121: -- Parent integrity has been violated
122: per_prv_shd.g_api_dml := false; -- Unset the api dml status
123: per_prv_shd.constraint_error

Line 120: When hr_api.parent_integrity_violated Then

116: -- A check constraint has been violated
117: per_prv_shd.g_api_dml := false; -- Unset the api dml status
118: per_prv_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.parent_integrity_violated Then
121: -- Parent integrity has been violated
122: per_prv_shd.g_api_dml := false; -- Unset the api dml status
123: per_prv_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

120: When hr_api.parent_integrity_violated Then
121: -- Parent integrity has been violated
122: per_prv_shd.g_api_dml := false; -- Unset the api dml status
123: per_prv_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When hr_api.unique_integrity_violated Then
126: -- Unique integrity has been violated
127: per_prv_shd.g_api_dml := false; -- Unset the api dml status
128: per_prv_shd.constraint_error

Line 125: When hr_api.unique_integrity_violated Then

121: -- Parent integrity has been violated
122: per_prv_shd.g_api_dml := false; -- Unset the api dml status
123: per_prv_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When hr_api.unique_integrity_violated Then
126: -- Unique integrity has been violated
127: per_prv_shd.g_api_dml := false; -- Unset the api dml status
128: per_prv_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

125: When hr_api.unique_integrity_violated Then
126: -- Unique integrity has been violated
127: per_prv_shd.g_api_dml := false; -- Unset the api dml status
128: per_prv_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When Others Then
131: per_prv_shd.g_api_dml := false; -- Unset the api dml status
132: Raise;
133: End update_dml;

Line 302: when hr_api.cannot_find_prog_unit then

298: );
299: --
300: exception
301: --
302: when hr_api.cannot_find_prog_unit then
303: --
304: hr_api.cannot_find_prog_unit_error
305: (p_module_name => 'per_performance_reviews'
306: ,p_hook_type => 'AU');

Line 304: hr_api.cannot_find_prog_unit_error

300: exception
301: --
302: when hr_api.cannot_find_prog_unit then
303: --
304: hr_api.cannot_find_prog_unit_error
305: (p_module_name => 'per_performance_reviews'
306: ,p_hook_type => 'AU');
307: --
308: end;

Line 372: If (p_rec.person_id = hr_api.g_number) then

368: -- p_rec plsql record structure
369: -- to see if a system default is being used. If a system default
370: -- is being used then we must set to the 'current' argument value.
371: --
372: If (p_rec.person_id = hr_api.g_number) then
373: p_rec.person_id :=
374: per_prv_shd.g_old_rec.person_id;
375: End If;
376: If (p_rec.event_id = hr_api.g_number) then

Line 376: If (p_rec.event_id = hr_api.g_number) then

372: If (p_rec.person_id = hr_api.g_number) then
373: p_rec.person_id :=
374: per_prv_shd.g_old_rec.person_id;
375: End If;
376: If (p_rec.event_id = hr_api.g_number) then
377: p_rec.event_id :=
378: per_prv_shd.g_old_rec.event_id;
379: End If;
380: If (p_rec.review_date = hr_api.g_date) then

Line 380: If (p_rec.review_date = hr_api.g_date) then

376: If (p_rec.event_id = hr_api.g_number) then
377: p_rec.event_id :=
378: per_prv_shd.g_old_rec.event_id;
379: End If;
380: If (p_rec.review_date = hr_api.g_date) then
381: p_rec.review_date :=
382: per_prv_shd.g_old_rec.review_date;
383: End If;
384: If (p_rec.performance_rating = hr_api.g_varchar2) then

Line 384: If (p_rec.performance_rating = hr_api.g_varchar2) then

380: If (p_rec.review_date = hr_api.g_date) then
381: p_rec.review_date :=
382: per_prv_shd.g_old_rec.review_date;
383: End If;
384: If (p_rec.performance_rating = hr_api.g_varchar2) then
385: p_rec.performance_rating :=
386: per_prv_shd.g_old_rec.performance_rating;
387: End If;
388: If (p_rec.next_perf_review_date = hr_api.g_date) then

Line 388: If (p_rec.next_perf_review_date = hr_api.g_date) then

384: If (p_rec.performance_rating = hr_api.g_varchar2) then
385: p_rec.performance_rating :=
386: per_prv_shd.g_old_rec.performance_rating;
387: End If;
388: If (p_rec.next_perf_review_date = hr_api.g_date) then
389: p_rec.next_perf_review_date :=
390: per_prv_shd.g_old_rec.next_perf_review_date;
391: End If;
392: If (p_rec.attribute_category = hr_api.g_varchar2) then

Line 392: If (p_rec.attribute_category = hr_api.g_varchar2) then

388: If (p_rec.next_perf_review_date = hr_api.g_date) then
389: p_rec.next_perf_review_date :=
390: per_prv_shd.g_old_rec.next_perf_review_date;
391: End If;
392: If (p_rec.attribute_category = hr_api.g_varchar2) then
393: p_rec.attribute_category :=
394: per_prv_shd.g_old_rec.attribute_category;
395: End If;
396: If (p_rec.attribute1 = hr_api.g_varchar2) then

Line 396: If (p_rec.attribute1 = hr_api.g_varchar2) then

392: If (p_rec.attribute_category = hr_api.g_varchar2) then
393: p_rec.attribute_category :=
394: per_prv_shd.g_old_rec.attribute_category;
395: End If;
396: If (p_rec.attribute1 = hr_api.g_varchar2) then
397: p_rec.attribute1 :=
398: per_prv_shd.g_old_rec.attribute1;
399: End If;
400: If (p_rec.attribute2 = hr_api.g_varchar2) then

Line 400: If (p_rec.attribute2 = hr_api.g_varchar2) then

396: If (p_rec.attribute1 = hr_api.g_varchar2) then
397: p_rec.attribute1 :=
398: per_prv_shd.g_old_rec.attribute1;
399: End If;
400: If (p_rec.attribute2 = hr_api.g_varchar2) then
401: p_rec.attribute2 :=
402: per_prv_shd.g_old_rec.attribute2;
403: End If;
404: If (p_rec.attribute3 = hr_api.g_varchar2) then

Line 404: If (p_rec.attribute3 = hr_api.g_varchar2) then

400: If (p_rec.attribute2 = hr_api.g_varchar2) then
401: p_rec.attribute2 :=
402: per_prv_shd.g_old_rec.attribute2;
403: End If;
404: If (p_rec.attribute3 = hr_api.g_varchar2) then
405: p_rec.attribute3 :=
406: per_prv_shd.g_old_rec.attribute3;
407: End If;
408: If (p_rec.attribute4 = hr_api.g_varchar2) then

Line 408: If (p_rec.attribute4 = hr_api.g_varchar2) then

404: If (p_rec.attribute3 = hr_api.g_varchar2) then
405: p_rec.attribute3 :=
406: per_prv_shd.g_old_rec.attribute3;
407: End If;
408: If (p_rec.attribute4 = hr_api.g_varchar2) then
409: p_rec.attribute4 :=
410: per_prv_shd.g_old_rec.attribute4;
411: End If;
412: If (p_rec.attribute5 = hr_api.g_varchar2) then

Line 412: If (p_rec.attribute5 = hr_api.g_varchar2) then

408: If (p_rec.attribute4 = hr_api.g_varchar2) then
409: p_rec.attribute4 :=
410: per_prv_shd.g_old_rec.attribute4;
411: End If;
412: If (p_rec.attribute5 = hr_api.g_varchar2) then
413: p_rec.attribute5 :=
414: per_prv_shd.g_old_rec.attribute5;
415: End If;
416: If (p_rec.attribute6 = hr_api.g_varchar2) then

Line 416: If (p_rec.attribute6 = hr_api.g_varchar2) then

412: If (p_rec.attribute5 = hr_api.g_varchar2) then
413: p_rec.attribute5 :=
414: per_prv_shd.g_old_rec.attribute5;
415: End If;
416: If (p_rec.attribute6 = hr_api.g_varchar2) then
417: p_rec.attribute6 :=
418: per_prv_shd.g_old_rec.attribute6;
419: End If;
420: If (p_rec.attribute7 = hr_api.g_varchar2) then

Line 420: If (p_rec.attribute7 = hr_api.g_varchar2) then

416: If (p_rec.attribute6 = hr_api.g_varchar2) then
417: p_rec.attribute6 :=
418: per_prv_shd.g_old_rec.attribute6;
419: End If;
420: If (p_rec.attribute7 = hr_api.g_varchar2) then
421: p_rec.attribute7 :=
422: per_prv_shd.g_old_rec.attribute7;
423: End If;
424: If (p_rec.attribute8 = hr_api.g_varchar2) then

Line 424: If (p_rec.attribute8 = hr_api.g_varchar2) then

420: If (p_rec.attribute7 = hr_api.g_varchar2) then
421: p_rec.attribute7 :=
422: per_prv_shd.g_old_rec.attribute7;
423: End If;
424: If (p_rec.attribute8 = hr_api.g_varchar2) then
425: p_rec.attribute8 :=
426: per_prv_shd.g_old_rec.attribute8;
427: End If;
428: If (p_rec.attribute9 = hr_api.g_varchar2) then

Line 428: If (p_rec.attribute9 = hr_api.g_varchar2) then

424: If (p_rec.attribute8 = hr_api.g_varchar2) then
425: p_rec.attribute8 :=
426: per_prv_shd.g_old_rec.attribute8;
427: End If;
428: If (p_rec.attribute9 = hr_api.g_varchar2) then
429: p_rec.attribute9 :=
430: per_prv_shd.g_old_rec.attribute9;
431: End If;
432: If (p_rec.attribute10 = hr_api.g_varchar2) then

Line 432: If (p_rec.attribute10 = hr_api.g_varchar2) then

428: If (p_rec.attribute9 = hr_api.g_varchar2) then
429: p_rec.attribute9 :=
430: per_prv_shd.g_old_rec.attribute9;
431: End If;
432: If (p_rec.attribute10 = hr_api.g_varchar2) then
433: p_rec.attribute10 :=
434: per_prv_shd.g_old_rec.attribute10;
435: End If;
436: If (p_rec.attribute11 = hr_api.g_varchar2) then

Line 436: If (p_rec.attribute11 = hr_api.g_varchar2) then

432: If (p_rec.attribute10 = hr_api.g_varchar2) then
433: p_rec.attribute10 :=
434: per_prv_shd.g_old_rec.attribute10;
435: End If;
436: If (p_rec.attribute11 = hr_api.g_varchar2) then
437: p_rec.attribute11 :=
438: per_prv_shd.g_old_rec.attribute11;
439: End If;
440: If (p_rec.attribute12 = hr_api.g_varchar2) then

Line 440: If (p_rec.attribute12 = hr_api.g_varchar2) then

436: If (p_rec.attribute11 = hr_api.g_varchar2) then
437: p_rec.attribute11 :=
438: per_prv_shd.g_old_rec.attribute11;
439: End If;
440: If (p_rec.attribute12 = hr_api.g_varchar2) then
441: p_rec.attribute12 :=
442: per_prv_shd.g_old_rec.attribute12;
443: End If;
444: If (p_rec.attribute13 = hr_api.g_varchar2) then

Line 444: If (p_rec.attribute13 = hr_api.g_varchar2) then

440: If (p_rec.attribute12 = hr_api.g_varchar2) then
441: p_rec.attribute12 :=
442: per_prv_shd.g_old_rec.attribute12;
443: End If;
444: If (p_rec.attribute13 = hr_api.g_varchar2) then
445: p_rec.attribute13 :=
446: per_prv_shd.g_old_rec.attribute13;
447: End If;
448: If (p_rec.attribute14 = hr_api.g_varchar2) then

Line 448: If (p_rec.attribute14 = hr_api.g_varchar2) then

444: If (p_rec.attribute13 = hr_api.g_varchar2) then
445: p_rec.attribute13 :=
446: per_prv_shd.g_old_rec.attribute13;
447: End If;
448: If (p_rec.attribute14 = hr_api.g_varchar2) then
449: p_rec.attribute14 :=
450: per_prv_shd.g_old_rec.attribute14;
451: End If;
452: If (p_rec.attribute15 = hr_api.g_varchar2) then

Line 452: If (p_rec.attribute15 = hr_api.g_varchar2) then

448: If (p_rec.attribute14 = hr_api.g_varchar2) then
449: p_rec.attribute14 :=
450: per_prv_shd.g_old_rec.attribute14;
451: End If;
452: If (p_rec.attribute15 = hr_api.g_varchar2) then
453: p_rec.attribute15 :=
454: per_prv_shd.g_old_rec.attribute15;
455: End If;
456: If (p_rec.attribute16 = hr_api.g_varchar2) then

Line 456: If (p_rec.attribute16 = hr_api.g_varchar2) then

452: If (p_rec.attribute15 = hr_api.g_varchar2) then
453: p_rec.attribute15 :=
454: per_prv_shd.g_old_rec.attribute15;
455: End If;
456: If (p_rec.attribute16 = hr_api.g_varchar2) then
457: p_rec.attribute16 :=
458: per_prv_shd.g_old_rec.attribute16;
459: End If;
460: If (p_rec.attribute17 = hr_api.g_varchar2) then

Line 460: If (p_rec.attribute17 = hr_api.g_varchar2) then

456: If (p_rec.attribute16 = hr_api.g_varchar2) then
457: p_rec.attribute16 :=
458: per_prv_shd.g_old_rec.attribute16;
459: End If;
460: If (p_rec.attribute17 = hr_api.g_varchar2) then
461: p_rec.attribute17 :=
462: per_prv_shd.g_old_rec.attribute17;
463: End If;
464: If (p_rec.attribute18 = hr_api.g_varchar2) then

Line 464: If (p_rec.attribute18 = hr_api.g_varchar2) then

460: If (p_rec.attribute17 = hr_api.g_varchar2) then
461: p_rec.attribute17 :=
462: per_prv_shd.g_old_rec.attribute17;
463: End If;
464: If (p_rec.attribute18 = hr_api.g_varchar2) then
465: p_rec.attribute18 :=
466: per_prv_shd.g_old_rec.attribute18;
467: End If;
468: If (p_rec.attribute19 = hr_api.g_varchar2) then

Line 468: If (p_rec.attribute19 = hr_api.g_varchar2) then

464: If (p_rec.attribute18 = hr_api.g_varchar2) then
465: p_rec.attribute18 :=
466: per_prv_shd.g_old_rec.attribute18;
467: End If;
468: If (p_rec.attribute19 = hr_api.g_varchar2) then
469: p_rec.attribute19 :=
470: per_prv_shd.g_old_rec.attribute19;
471: End If;
472: If (p_rec.attribute20 = hr_api.g_varchar2) then

Line 472: If (p_rec.attribute20 = hr_api.g_varchar2) then

468: If (p_rec.attribute19 = hr_api.g_varchar2) then
469: p_rec.attribute19 :=
470: per_prv_shd.g_old_rec.attribute19;
471: End If;
472: If (p_rec.attribute20 = hr_api.g_varchar2) then
473: p_rec.attribute20 :=
474: per_prv_shd.g_old_rec.attribute20;
475: End If;
476: If (p_rec.attribute21 = hr_api.g_varchar2) then

Line 476: If (p_rec.attribute21 = hr_api.g_varchar2) then

472: If (p_rec.attribute20 = hr_api.g_varchar2) then
473: p_rec.attribute20 :=
474: per_prv_shd.g_old_rec.attribute20;
475: End If;
476: If (p_rec.attribute21 = hr_api.g_varchar2) then
477: p_rec.attribute21 :=
478: per_prv_shd.g_old_rec.attribute21;
479: End If;
480: If (p_rec.attribute22 = hr_api.g_varchar2) then

Line 480: If (p_rec.attribute22 = hr_api.g_varchar2) then

476: If (p_rec.attribute21 = hr_api.g_varchar2) then
477: p_rec.attribute21 :=
478: per_prv_shd.g_old_rec.attribute21;
479: End If;
480: If (p_rec.attribute22 = hr_api.g_varchar2) then
481: p_rec.attribute22 :=
482: per_prv_shd.g_old_rec.attribute22;
483: End If;
484: If (p_rec.attribute23 = hr_api.g_varchar2) then

Line 484: If (p_rec.attribute23 = hr_api.g_varchar2) then

480: If (p_rec.attribute22 = hr_api.g_varchar2) then
481: p_rec.attribute22 :=
482: per_prv_shd.g_old_rec.attribute22;
483: End If;
484: If (p_rec.attribute23 = hr_api.g_varchar2) then
485: p_rec.attribute23 :=
486: per_prv_shd.g_old_rec.attribute23;
487: End If;
488: If (p_rec.attribute24 = hr_api.g_varchar2) then

Line 488: If (p_rec.attribute24 = hr_api.g_varchar2) then

484: If (p_rec.attribute23 = hr_api.g_varchar2) then
485: p_rec.attribute23 :=
486: per_prv_shd.g_old_rec.attribute23;
487: End If;
488: If (p_rec.attribute24 = hr_api.g_varchar2) then
489: p_rec.attribute24 :=
490: per_prv_shd.g_old_rec.attribute24;
491: End If;
492: If (p_rec.attribute25 = hr_api.g_varchar2) then

Line 492: If (p_rec.attribute25 = hr_api.g_varchar2) then

488: If (p_rec.attribute24 = hr_api.g_varchar2) then
489: p_rec.attribute24 :=
490: per_prv_shd.g_old_rec.attribute24;
491: End If;
492: If (p_rec.attribute25 = hr_api.g_varchar2) then
493: p_rec.attribute25 :=
494: per_prv_shd.g_old_rec.attribute25;
495: End If;
496: If (p_rec.attribute26 = hr_api.g_varchar2) then

Line 496: If (p_rec.attribute26 = hr_api.g_varchar2) then

492: If (p_rec.attribute25 = hr_api.g_varchar2) then
493: p_rec.attribute25 :=
494: per_prv_shd.g_old_rec.attribute25;
495: End If;
496: If (p_rec.attribute26 = hr_api.g_varchar2) then
497: p_rec.attribute26 :=
498: per_prv_shd.g_old_rec.attribute26;
499: End If;
500: If (p_rec.attribute27 = hr_api.g_varchar2) then

Line 500: If (p_rec.attribute27 = hr_api.g_varchar2) then

496: If (p_rec.attribute26 = hr_api.g_varchar2) then
497: p_rec.attribute26 :=
498: per_prv_shd.g_old_rec.attribute26;
499: End If;
500: If (p_rec.attribute27 = hr_api.g_varchar2) then
501: p_rec.attribute27 :=
502: per_prv_shd.g_old_rec.attribute27;
503: End If;
504: If (p_rec.attribute28 = hr_api.g_varchar2) then

Line 504: If (p_rec.attribute28 = hr_api.g_varchar2) then

500: If (p_rec.attribute27 = hr_api.g_varchar2) then
501: p_rec.attribute27 :=
502: per_prv_shd.g_old_rec.attribute27;
503: End If;
504: If (p_rec.attribute28 = hr_api.g_varchar2) then
505: p_rec.attribute28 :=
506: per_prv_shd.g_old_rec.attribute28;
507: End If;
508: If (p_rec.attribute29 = hr_api.g_varchar2) then

Line 508: If (p_rec.attribute29 = hr_api.g_varchar2) then

504: If (p_rec.attribute28 = hr_api.g_varchar2) then
505: p_rec.attribute28 :=
506: per_prv_shd.g_old_rec.attribute28;
507: End If;
508: If (p_rec.attribute29 = hr_api.g_varchar2) then
509: p_rec.attribute29 :=
510: per_prv_shd.g_old_rec.attribute29;
511: End If;
512: If (p_rec.attribute30 = hr_api.g_varchar2) then

Line 512: If (p_rec.attribute30 = hr_api.g_varchar2) then

508: If (p_rec.attribute29 = hr_api.g_varchar2) then
509: p_rec.attribute29 :=
510: per_prv_shd.g_old_rec.attribute29;
511: End If;
512: If (p_rec.attribute30 = hr_api.g_varchar2) then
513: p_rec.attribute30 :=
514: per_prv_shd.g_old_rec.attribute30;
515: End If;
516:

Line 580: Raise HR_Api.Validate_Enabled;

576: --
577: -- If we are validating then raise the Validate_Enabled exception
578: --
579: If p_validate then
580: Raise HR_Api.Validate_Enabled;
581: End If;
582: --
583: hr_utility.set_location(' Leaving:'||l_proc, 10);
584: Exception

Line 585: When HR_Api.Validate_Enabled Then

581: End If;
582: --
583: hr_utility.set_location(' Leaving:'||l_proc, 10);
584: Exception
585: When HR_Api.Validate_Enabled Then
586: --
587: -- As the Validate_Enabled exception has been raised
588: -- we must rollback to the savepoint
589: --

Line 599: p_event_id in number default hr_api.g_number,

595: -- ----------------------------------------------------------------------------
596: Procedure upd
597: (
598: p_performance_review_id in number,
599: p_event_id in number default hr_api.g_number,
600: p_review_date in date default hr_api.g_date,
601: p_performance_rating in varchar2 default hr_api.g_varchar2,
602: p_next_perf_review_date in date default hr_api.g_date,
603: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 600: p_review_date in date default hr_api.g_date,

596: Procedure upd
597: (
598: p_performance_review_id in number,
599: p_event_id in number default hr_api.g_number,
600: p_review_date in date default hr_api.g_date,
601: p_performance_rating in varchar2 default hr_api.g_varchar2,
602: p_next_perf_review_date in date default hr_api.g_date,
603: p_attribute_category in varchar2 default hr_api.g_varchar2,
604: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 601: p_performance_rating in varchar2 default hr_api.g_varchar2,

597: (
598: p_performance_review_id in number,
599: p_event_id in number default hr_api.g_number,
600: p_review_date in date default hr_api.g_date,
601: p_performance_rating in varchar2 default hr_api.g_varchar2,
602: p_next_perf_review_date in date default hr_api.g_date,
603: p_attribute_category in varchar2 default hr_api.g_varchar2,
604: p_attribute1 in varchar2 default hr_api.g_varchar2,
605: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 602: p_next_perf_review_date in date default hr_api.g_date,

598: p_performance_review_id in number,
599: p_event_id in number default hr_api.g_number,
600: p_review_date in date default hr_api.g_date,
601: p_performance_rating in varchar2 default hr_api.g_varchar2,
602: p_next_perf_review_date in date default hr_api.g_date,
603: p_attribute_category in varchar2 default hr_api.g_varchar2,
604: p_attribute1 in varchar2 default hr_api.g_varchar2,
605: p_attribute2 in varchar2 default hr_api.g_varchar2,
606: p_attribute3 in varchar2 default hr_api.g_varchar2,

Line 603: p_attribute_category in varchar2 default hr_api.g_varchar2,

599: p_event_id in number default hr_api.g_number,
600: p_review_date in date default hr_api.g_date,
601: p_performance_rating in varchar2 default hr_api.g_varchar2,
602: p_next_perf_review_date in date default hr_api.g_date,
603: p_attribute_category in varchar2 default hr_api.g_varchar2,
604: p_attribute1 in varchar2 default hr_api.g_varchar2,
605: p_attribute2 in varchar2 default hr_api.g_varchar2,
606: p_attribute3 in varchar2 default hr_api.g_varchar2,
607: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 604: p_attribute1 in varchar2 default hr_api.g_varchar2,

600: p_review_date in date default hr_api.g_date,
601: p_performance_rating in varchar2 default hr_api.g_varchar2,
602: p_next_perf_review_date in date default hr_api.g_date,
603: p_attribute_category in varchar2 default hr_api.g_varchar2,
604: p_attribute1 in varchar2 default hr_api.g_varchar2,
605: p_attribute2 in varchar2 default hr_api.g_varchar2,
606: p_attribute3 in varchar2 default hr_api.g_varchar2,
607: p_attribute4 in varchar2 default hr_api.g_varchar2,
608: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 605: p_attribute2 in varchar2 default hr_api.g_varchar2,

601: p_performance_rating in varchar2 default hr_api.g_varchar2,
602: p_next_perf_review_date in date default hr_api.g_date,
603: p_attribute_category in varchar2 default hr_api.g_varchar2,
604: p_attribute1 in varchar2 default hr_api.g_varchar2,
605: p_attribute2 in varchar2 default hr_api.g_varchar2,
606: p_attribute3 in varchar2 default hr_api.g_varchar2,
607: p_attribute4 in varchar2 default hr_api.g_varchar2,
608: p_attribute5 in varchar2 default hr_api.g_varchar2,
609: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 606: p_attribute3 in varchar2 default hr_api.g_varchar2,

602: p_next_perf_review_date in date default hr_api.g_date,
603: p_attribute_category in varchar2 default hr_api.g_varchar2,
604: p_attribute1 in varchar2 default hr_api.g_varchar2,
605: p_attribute2 in varchar2 default hr_api.g_varchar2,
606: p_attribute3 in varchar2 default hr_api.g_varchar2,
607: p_attribute4 in varchar2 default hr_api.g_varchar2,
608: p_attribute5 in varchar2 default hr_api.g_varchar2,
609: p_attribute6 in varchar2 default hr_api.g_varchar2,
610: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 607: p_attribute4 in varchar2 default hr_api.g_varchar2,

603: p_attribute_category in varchar2 default hr_api.g_varchar2,
604: p_attribute1 in varchar2 default hr_api.g_varchar2,
605: p_attribute2 in varchar2 default hr_api.g_varchar2,
606: p_attribute3 in varchar2 default hr_api.g_varchar2,
607: p_attribute4 in varchar2 default hr_api.g_varchar2,
608: p_attribute5 in varchar2 default hr_api.g_varchar2,
609: p_attribute6 in varchar2 default hr_api.g_varchar2,
610: p_attribute7 in varchar2 default hr_api.g_varchar2,
611: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 608: p_attribute5 in varchar2 default hr_api.g_varchar2,

604: p_attribute1 in varchar2 default hr_api.g_varchar2,
605: p_attribute2 in varchar2 default hr_api.g_varchar2,
606: p_attribute3 in varchar2 default hr_api.g_varchar2,
607: p_attribute4 in varchar2 default hr_api.g_varchar2,
608: p_attribute5 in varchar2 default hr_api.g_varchar2,
609: p_attribute6 in varchar2 default hr_api.g_varchar2,
610: p_attribute7 in varchar2 default hr_api.g_varchar2,
611: p_attribute8 in varchar2 default hr_api.g_varchar2,
612: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 609: p_attribute6 in varchar2 default hr_api.g_varchar2,

605: p_attribute2 in varchar2 default hr_api.g_varchar2,
606: p_attribute3 in varchar2 default hr_api.g_varchar2,
607: p_attribute4 in varchar2 default hr_api.g_varchar2,
608: p_attribute5 in varchar2 default hr_api.g_varchar2,
609: p_attribute6 in varchar2 default hr_api.g_varchar2,
610: p_attribute7 in varchar2 default hr_api.g_varchar2,
611: p_attribute8 in varchar2 default hr_api.g_varchar2,
612: p_attribute9 in varchar2 default hr_api.g_varchar2,
613: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 610: p_attribute7 in varchar2 default hr_api.g_varchar2,

606: p_attribute3 in varchar2 default hr_api.g_varchar2,
607: p_attribute4 in varchar2 default hr_api.g_varchar2,
608: p_attribute5 in varchar2 default hr_api.g_varchar2,
609: p_attribute6 in varchar2 default hr_api.g_varchar2,
610: p_attribute7 in varchar2 default hr_api.g_varchar2,
611: p_attribute8 in varchar2 default hr_api.g_varchar2,
612: p_attribute9 in varchar2 default hr_api.g_varchar2,
613: p_attribute10 in varchar2 default hr_api.g_varchar2,
614: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 611: p_attribute8 in varchar2 default hr_api.g_varchar2,

607: p_attribute4 in varchar2 default hr_api.g_varchar2,
608: p_attribute5 in varchar2 default hr_api.g_varchar2,
609: p_attribute6 in varchar2 default hr_api.g_varchar2,
610: p_attribute7 in varchar2 default hr_api.g_varchar2,
611: p_attribute8 in varchar2 default hr_api.g_varchar2,
612: p_attribute9 in varchar2 default hr_api.g_varchar2,
613: p_attribute10 in varchar2 default hr_api.g_varchar2,
614: p_attribute11 in varchar2 default hr_api.g_varchar2,
615: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 612: p_attribute9 in varchar2 default hr_api.g_varchar2,

608: p_attribute5 in varchar2 default hr_api.g_varchar2,
609: p_attribute6 in varchar2 default hr_api.g_varchar2,
610: p_attribute7 in varchar2 default hr_api.g_varchar2,
611: p_attribute8 in varchar2 default hr_api.g_varchar2,
612: p_attribute9 in varchar2 default hr_api.g_varchar2,
613: p_attribute10 in varchar2 default hr_api.g_varchar2,
614: p_attribute11 in varchar2 default hr_api.g_varchar2,
615: p_attribute12 in varchar2 default hr_api.g_varchar2,
616: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 613: p_attribute10 in varchar2 default hr_api.g_varchar2,

609: p_attribute6 in varchar2 default hr_api.g_varchar2,
610: p_attribute7 in varchar2 default hr_api.g_varchar2,
611: p_attribute8 in varchar2 default hr_api.g_varchar2,
612: p_attribute9 in varchar2 default hr_api.g_varchar2,
613: p_attribute10 in varchar2 default hr_api.g_varchar2,
614: p_attribute11 in varchar2 default hr_api.g_varchar2,
615: p_attribute12 in varchar2 default hr_api.g_varchar2,
616: p_attribute13 in varchar2 default hr_api.g_varchar2,
617: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 614: p_attribute11 in varchar2 default hr_api.g_varchar2,

610: p_attribute7 in varchar2 default hr_api.g_varchar2,
611: p_attribute8 in varchar2 default hr_api.g_varchar2,
612: p_attribute9 in varchar2 default hr_api.g_varchar2,
613: p_attribute10 in varchar2 default hr_api.g_varchar2,
614: p_attribute11 in varchar2 default hr_api.g_varchar2,
615: p_attribute12 in varchar2 default hr_api.g_varchar2,
616: p_attribute13 in varchar2 default hr_api.g_varchar2,
617: p_attribute14 in varchar2 default hr_api.g_varchar2,
618: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 615: p_attribute12 in varchar2 default hr_api.g_varchar2,

611: p_attribute8 in varchar2 default hr_api.g_varchar2,
612: p_attribute9 in varchar2 default hr_api.g_varchar2,
613: p_attribute10 in varchar2 default hr_api.g_varchar2,
614: p_attribute11 in varchar2 default hr_api.g_varchar2,
615: p_attribute12 in varchar2 default hr_api.g_varchar2,
616: p_attribute13 in varchar2 default hr_api.g_varchar2,
617: p_attribute14 in varchar2 default hr_api.g_varchar2,
618: p_attribute15 in varchar2 default hr_api.g_varchar2,
619: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 616: p_attribute13 in varchar2 default hr_api.g_varchar2,

612: p_attribute9 in varchar2 default hr_api.g_varchar2,
613: p_attribute10 in varchar2 default hr_api.g_varchar2,
614: p_attribute11 in varchar2 default hr_api.g_varchar2,
615: p_attribute12 in varchar2 default hr_api.g_varchar2,
616: p_attribute13 in varchar2 default hr_api.g_varchar2,
617: p_attribute14 in varchar2 default hr_api.g_varchar2,
618: p_attribute15 in varchar2 default hr_api.g_varchar2,
619: p_attribute16 in varchar2 default hr_api.g_varchar2,
620: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 617: p_attribute14 in varchar2 default hr_api.g_varchar2,

613: p_attribute10 in varchar2 default hr_api.g_varchar2,
614: p_attribute11 in varchar2 default hr_api.g_varchar2,
615: p_attribute12 in varchar2 default hr_api.g_varchar2,
616: p_attribute13 in varchar2 default hr_api.g_varchar2,
617: p_attribute14 in varchar2 default hr_api.g_varchar2,
618: p_attribute15 in varchar2 default hr_api.g_varchar2,
619: p_attribute16 in varchar2 default hr_api.g_varchar2,
620: p_attribute17 in varchar2 default hr_api.g_varchar2,
621: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 618: p_attribute15 in varchar2 default hr_api.g_varchar2,

614: p_attribute11 in varchar2 default hr_api.g_varchar2,
615: p_attribute12 in varchar2 default hr_api.g_varchar2,
616: p_attribute13 in varchar2 default hr_api.g_varchar2,
617: p_attribute14 in varchar2 default hr_api.g_varchar2,
618: p_attribute15 in varchar2 default hr_api.g_varchar2,
619: p_attribute16 in varchar2 default hr_api.g_varchar2,
620: p_attribute17 in varchar2 default hr_api.g_varchar2,
621: p_attribute18 in varchar2 default hr_api.g_varchar2,
622: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 619: p_attribute16 in varchar2 default hr_api.g_varchar2,

615: p_attribute12 in varchar2 default hr_api.g_varchar2,
616: p_attribute13 in varchar2 default hr_api.g_varchar2,
617: p_attribute14 in varchar2 default hr_api.g_varchar2,
618: p_attribute15 in varchar2 default hr_api.g_varchar2,
619: p_attribute16 in varchar2 default hr_api.g_varchar2,
620: p_attribute17 in varchar2 default hr_api.g_varchar2,
621: p_attribute18 in varchar2 default hr_api.g_varchar2,
622: p_attribute19 in varchar2 default hr_api.g_varchar2,
623: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 620: p_attribute17 in varchar2 default hr_api.g_varchar2,

616: p_attribute13 in varchar2 default hr_api.g_varchar2,
617: p_attribute14 in varchar2 default hr_api.g_varchar2,
618: p_attribute15 in varchar2 default hr_api.g_varchar2,
619: p_attribute16 in varchar2 default hr_api.g_varchar2,
620: p_attribute17 in varchar2 default hr_api.g_varchar2,
621: p_attribute18 in varchar2 default hr_api.g_varchar2,
622: p_attribute19 in varchar2 default hr_api.g_varchar2,
623: p_attribute20 in varchar2 default hr_api.g_varchar2,
624: p_attribute21 in varchar2 default hr_api.g_varchar2,

Line 621: p_attribute18 in varchar2 default hr_api.g_varchar2,

617: p_attribute14 in varchar2 default hr_api.g_varchar2,
618: p_attribute15 in varchar2 default hr_api.g_varchar2,
619: p_attribute16 in varchar2 default hr_api.g_varchar2,
620: p_attribute17 in varchar2 default hr_api.g_varchar2,
621: p_attribute18 in varchar2 default hr_api.g_varchar2,
622: p_attribute19 in varchar2 default hr_api.g_varchar2,
623: p_attribute20 in varchar2 default hr_api.g_varchar2,
624: p_attribute21 in varchar2 default hr_api.g_varchar2,
625: p_attribute22 in varchar2 default hr_api.g_varchar2,

Line 622: p_attribute19 in varchar2 default hr_api.g_varchar2,

618: p_attribute15 in varchar2 default hr_api.g_varchar2,
619: p_attribute16 in varchar2 default hr_api.g_varchar2,
620: p_attribute17 in varchar2 default hr_api.g_varchar2,
621: p_attribute18 in varchar2 default hr_api.g_varchar2,
622: p_attribute19 in varchar2 default hr_api.g_varchar2,
623: p_attribute20 in varchar2 default hr_api.g_varchar2,
624: p_attribute21 in varchar2 default hr_api.g_varchar2,
625: p_attribute22 in varchar2 default hr_api.g_varchar2,
626: p_attribute23 in varchar2 default hr_api.g_varchar2,

Line 623: p_attribute20 in varchar2 default hr_api.g_varchar2,

619: p_attribute16 in varchar2 default hr_api.g_varchar2,
620: p_attribute17 in varchar2 default hr_api.g_varchar2,
621: p_attribute18 in varchar2 default hr_api.g_varchar2,
622: p_attribute19 in varchar2 default hr_api.g_varchar2,
623: p_attribute20 in varchar2 default hr_api.g_varchar2,
624: p_attribute21 in varchar2 default hr_api.g_varchar2,
625: p_attribute22 in varchar2 default hr_api.g_varchar2,
626: p_attribute23 in varchar2 default hr_api.g_varchar2,
627: p_attribute24 in varchar2 default hr_api.g_varchar2,

Line 624: p_attribute21 in varchar2 default hr_api.g_varchar2,

620: p_attribute17 in varchar2 default hr_api.g_varchar2,
621: p_attribute18 in varchar2 default hr_api.g_varchar2,
622: p_attribute19 in varchar2 default hr_api.g_varchar2,
623: p_attribute20 in varchar2 default hr_api.g_varchar2,
624: p_attribute21 in varchar2 default hr_api.g_varchar2,
625: p_attribute22 in varchar2 default hr_api.g_varchar2,
626: p_attribute23 in varchar2 default hr_api.g_varchar2,
627: p_attribute24 in varchar2 default hr_api.g_varchar2,
628: p_attribute25 in varchar2 default hr_api.g_varchar2,

Line 625: p_attribute22 in varchar2 default hr_api.g_varchar2,

621: p_attribute18 in varchar2 default hr_api.g_varchar2,
622: p_attribute19 in varchar2 default hr_api.g_varchar2,
623: p_attribute20 in varchar2 default hr_api.g_varchar2,
624: p_attribute21 in varchar2 default hr_api.g_varchar2,
625: p_attribute22 in varchar2 default hr_api.g_varchar2,
626: p_attribute23 in varchar2 default hr_api.g_varchar2,
627: p_attribute24 in varchar2 default hr_api.g_varchar2,
628: p_attribute25 in varchar2 default hr_api.g_varchar2,
629: p_attribute26 in varchar2 default hr_api.g_varchar2,

Line 626: p_attribute23 in varchar2 default hr_api.g_varchar2,

622: p_attribute19 in varchar2 default hr_api.g_varchar2,
623: p_attribute20 in varchar2 default hr_api.g_varchar2,
624: p_attribute21 in varchar2 default hr_api.g_varchar2,
625: p_attribute22 in varchar2 default hr_api.g_varchar2,
626: p_attribute23 in varchar2 default hr_api.g_varchar2,
627: p_attribute24 in varchar2 default hr_api.g_varchar2,
628: p_attribute25 in varchar2 default hr_api.g_varchar2,
629: p_attribute26 in varchar2 default hr_api.g_varchar2,
630: p_attribute27 in varchar2 default hr_api.g_varchar2,

Line 627: p_attribute24 in varchar2 default hr_api.g_varchar2,

623: p_attribute20 in varchar2 default hr_api.g_varchar2,
624: p_attribute21 in varchar2 default hr_api.g_varchar2,
625: p_attribute22 in varchar2 default hr_api.g_varchar2,
626: p_attribute23 in varchar2 default hr_api.g_varchar2,
627: p_attribute24 in varchar2 default hr_api.g_varchar2,
628: p_attribute25 in varchar2 default hr_api.g_varchar2,
629: p_attribute26 in varchar2 default hr_api.g_varchar2,
630: p_attribute27 in varchar2 default hr_api.g_varchar2,
631: p_attribute28 in varchar2 default hr_api.g_varchar2,

Line 628: p_attribute25 in varchar2 default hr_api.g_varchar2,

624: p_attribute21 in varchar2 default hr_api.g_varchar2,
625: p_attribute22 in varchar2 default hr_api.g_varchar2,
626: p_attribute23 in varchar2 default hr_api.g_varchar2,
627: p_attribute24 in varchar2 default hr_api.g_varchar2,
628: p_attribute25 in varchar2 default hr_api.g_varchar2,
629: p_attribute26 in varchar2 default hr_api.g_varchar2,
630: p_attribute27 in varchar2 default hr_api.g_varchar2,
631: p_attribute28 in varchar2 default hr_api.g_varchar2,
632: p_attribute29 in varchar2 default hr_api.g_varchar2,

Line 629: p_attribute26 in varchar2 default hr_api.g_varchar2,

625: p_attribute22 in varchar2 default hr_api.g_varchar2,
626: p_attribute23 in varchar2 default hr_api.g_varchar2,
627: p_attribute24 in varchar2 default hr_api.g_varchar2,
628: p_attribute25 in varchar2 default hr_api.g_varchar2,
629: p_attribute26 in varchar2 default hr_api.g_varchar2,
630: p_attribute27 in varchar2 default hr_api.g_varchar2,
631: p_attribute28 in varchar2 default hr_api.g_varchar2,
632: p_attribute29 in varchar2 default hr_api.g_varchar2,
633: p_attribute30 in varchar2 default hr_api.g_varchar2,

Line 630: p_attribute27 in varchar2 default hr_api.g_varchar2,

626: p_attribute23 in varchar2 default hr_api.g_varchar2,
627: p_attribute24 in varchar2 default hr_api.g_varchar2,
628: p_attribute25 in varchar2 default hr_api.g_varchar2,
629: p_attribute26 in varchar2 default hr_api.g_varchar2,
630: p_attribute27 in varchar2 default hr_api.g_varchar2,
631: p_attribute28 in varchar2 default hr_api.g_varchar2,
632: p_attribute29 in varchar2 default hr_api.g_varchar2,
633: p_attribute30 in varchar2 default hr_api.g_varchar2,
634: p_object_version_number in out nocopy number,

Line 631: p_attribute28 in varchar2 default hr_api.g_varchar2,

627: p_attribute24 in varchar2 default hr_api.g_varchar2,
628: p_attribute25 in varchar2 default hr_api.g_varchar2,
629: p_attribute26 in varchar2 default hr_api.g_varchar2,
630: p_attribute27 in varchar2 default hr_api.g_varchar2,
631: p_attribute28 in varchar2 default hr_api.g_varchar2,
632: p_attribute29 in varchar2 default hr_api.g_varchar2,
633: p_attribute30 in varchar2 default hr_api.g_varchar2,
634: p_object_version_number in out nocopy number,
635: p_validate in boolean default false,

Line 632: p_attribute29 in varchar2 default hr_api.g_varchar2,

628: p_attribute25 in varchar2 default hr_api.g_varchar2,
629: p_attribute26 in varchar2 default hr_api.g_varchar2,
630: p_attribute27 in varchar2 default hr_api.g_varchar2,
631: p_attribute28 in varchar2 default hr_api.g_varchar2,
632: p_attribute29 in varchar2 default hr_api.g_varchar2,
633: p_attribute30 in varchar2 default hr_api.g_varchar2,
634: p_object_version_number in out nocopy number,
635: p_validate in boolean default false,
636: p_next_review_date_warning out nocopy boolean

Line 633: p_attribute30 in varchar2 default hr_api.g_varchar2,

629: p_attribute26 in varchar2 default hr_api.g_varchar2,
630: p_attribute27 in varchar2 default hr_api.g_varchar2,
631: p_attribute28 in varchar2 default hr_api.g_varchar2,
632: p_attribute29 in varchar2 default hr_api.g_varchar2,
633: p_attribute30 in varchar2 default hr_api.g_varchar2,
634: p_object_version_number in out nocopy number,
635: p_validate in boolean default false,
636: p_next_review_date_warning out nocopy boolean
637: ) is

Line 652: hr_api.g_number,

648: l_rec :=
649: per_prv_shd.convert_args
650: (
651: p_performance_review_id,
652: hr_api.g_number,
653: p_event_id,
654: p_review_date,
655: p_performance_rating,
656: p_next_perf_review_date,