DBA Data[Home] [Help]

APPS.PER_PMA_UPD dependencies on HR_API

Line 124: When hr_api.check_integrity_violated Then

120: --
121: hr_utility.set_location(' Leaving:'||l_proc, 10);
122: --
123: Exception
124: When hr_api.check_integrity_violated Then
125: -- A check constraint has been violated
126: --
127: per_pma_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

124: When hr_api.check_integrity_violated Then
125: -- A check constraint has been violated
126: --
127: per_pma_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When hr_api.parent_integrity_violated Then
130: -- Parent integrity has been violated
131: --
132: per_pma_shd.constraint_error

Line 129: When hr_api.parent_integrity_violated Then

125: -- A check constraint has been violated
126: --
127: per_pma_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When hr_api.parent_integrity_violated Then
130: -- Parent integrity has been violated
131: --
132: per_pma_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

129: When hr_api.parent_integrity_violated Then
130: -- Parent integrity has been violated
131: --
132: per_pma_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When hr_api.unique_integrity_violated Then
135: -- Unique integrity has been violated
136: --
137: per_pma_shd.constraint_error

Line 134: When hr_api.unique_integrity_violated Then

130: -- Parent integrity has been violated
131: --
132: per_pma_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When hr_api.unique_integrity_violated Then
135: -- Unique integrity has been violated
136: --
137: per_pma_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

134: When hr_api.unique_integrity_violated Then
135: -- Unique integrity has been violated
136: --
137: per_pma_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When Others Then
140: --
141: Raise;
142: End update_dml;

Line 424: when hr_api.cannot_find_prog_unit then

420: );
421: --
422: exception
423: --
424: when hr_api.cannot_find_prog_unit then
425: --
426: hr_api.cannot_find_prog_unit_error
427: (p_module_name => 'PER_APPRAISAL_PERIODS'
428: ,p_hook_type => 'AU');

Line 426: hr_api.cannot_find_prog_unit_error

422: exception
423: --
424: when hr_api.cannot_find_prog_unit then
425: --
426: hr_api.cannot_find_prog_unit_error
427: (p_module_name => 'PER_APPRAISAL_PERIODS'
428: ,p_hook_type => 'AU');
429: --
430: end;

Line 489: If (p_rec.plan_id = hr_api.g_number) then

485: -- p_rec plsql record structure
486: -- to see if a system default is being used. If a system default
487: -- is being used then we must set to the 'current' argument value.
488: --
489: If (p_rec.plan_id = hr_api.g_number) then
490: p_rec.plan_id :=
491: per_pma_shd.g_old_rec.plan_id;
492: End If;
493: If (p_rec.appraisal_template_id = hr_api.g_number) then

Line 493: If (p_rec.appraisal_template_id = hr_api.g_number) then

489: If (p_rec.plan_id = hr_api.g_number) then
490: p_rec.plan_id :=
491: per_pma_shd.g_old_rec.plan_id;
492: End If;
493: If (p_rec.appraisal_template_id = hr_api.g_number) then
494: p_rec.appraisal_template_id :=
495: per_pma_shd.g_old_rec.appraisal_template_id;
496: End If;
497: If (p_rec.start_date = hr_api.g_date) then

Line 497: If (p_rec.start_date = hr_api.g_date) then

493: If (p_rec.appraisal_template_id = hr_api.g_number) then
494: p_rec.appraisal_template_id :=
495: per_pma_shd.g_old_rec.appraisal_template_id;
496: End If;
497: If (p_rec.start_date = hr_api.g_date) then
498: p_rec.start_date :=
499: per_pma_shd.g_old_rec.start_date;
500: End If;
501: If (p_rec.end_date = hr_api.g_date) then

Line 501: If (p_rec.end_date = hr_api.g_date) then

497: If (p_rec.start_date = hr_api.g_date) then
498: p_rec.start_date :=
499: per_pma_shd.g_old_rec.start_date;
500: End If;
501: If (p_rec.end_date = hr_api.g_date) then
502: p_rec.end_date :=
503: per_pma_shd.g_old_rec.end_date;
504: End If;
505: If (p_rec.task_start_date = hr_api.g_date) then

Line 505: If (p_rec.task_start_date = hr_api.g_date) then

501: If (p_rec.end_date = hr_api.g_date) then
502: p_rec.end_date :=
503: per_pma_shd.g_old_rec.end_date;
504: End If;
505: If (p_rec.task_start_date = hr_api.g_date) then
506: p_rec.task_start_date :=
507: per_pma_shd.g_old_rec.task_start_date;
508: End If;
509: If (p_rec.task_end_date = hr_api.g_date) then

Line 509: If (p_rec.task_end_date = hr_api.g_date) then

505: If (p_rec.task_start_date = hr_api.g_date) then
506: p_rec.task_start_date :=
507: per_pma_shd.g_old_rec.task_start_date;
508: End If;
509: If (p_rec.task_end_date = hr_api.g_date) then
510: p_rec.task_end_date :=
511: per_pma_shd.g_old_rec.task_end_date;
512: End If;
513: If (p_rec.initiator_code = hr_api.g_varchar2) then

Line 513: If (p_rec.initiator_code = hr_api.g_varchar2) then

509: If (p_rec.task_end_date = hr_api.g_date) then
510: p_rec.task_end_date :=
511: per_pma_shd.g_old_rec.task_end_date;
512: End If;
513: If (p_rec.initiator_code = hr_api.g_varchar2) then
514: p_rec.initiator_code :=
515: per_pma_shd.g_old_rec.initiator_code;
516: End If;
517: If (p_rec.appraisal_system_type = hr_api.g_varchar2) then

Line 517: If (p_rec.appraisal_system_type = hr_api.g_varchar2) then

513: If (p_rec.initiator_code = hr_api.g_varchar2) then
514: p_rec.initiator_code :=
515: per_pma_shd.g_old_rec.initiator_code;
516: End If;
517: If (p_rec.appraisal_system_type = hr_api.g_varchar2) then
518: p_rec.appraisal_system_type :=
519: per_pma_shd.g_old_rec.appraisal_system_type;
520: End If;
521: If (p_rec.appraisal_type = hr_api.g_varchar2) then

Line 521: If (p_rec.appraisal_type = hr_api.g_varchar2) then

517: If (p_rec.appraisal_system_type = hr_api.g_varchar2) then
518: p_rec.appraisal_system_type :=
519: per_pma_shd.g_old_rec.appraisal_system_type;
520: End If;
521: If (p_rec.appraisal_type = hr_api.g_varchar2) then
522: p_rec.appraisal_type :=
523: per_pma_shd.g_old_rec.appraisal_type;
524: End If;
525: If (p_rec.appraisal_assmt_status = hr_api.g_varchar2) then

Line 525: If (p_rec.appraisal_assmt_status = hr_api.g_varchar2) then

521: If (p_rec.appraisal_type = hr_api.g_varchar2) then
522: p_rec.appraisal_type :=
523: per_pma_shd.g_old_rec.appraisal_type;
524: End If;
525: If (p_rec.appraisal_assmt_status = hr_api.g_varchar2) then
526: p_rec.appraisal_assmt_status :=
527: per_pma_shd.g_old_rec.appraisal_assmt_status;
528: End If;
529: If (p_rec.auto_conc_process = hr_api.g_varchar2) then

Line 529: If (p_rec.auto_conc_process = hr_api.g_varchar2) then

525: If (p_rec.appraisal_assmt_status = hr_api.g_varchar2) then
526: p_rec.appraisal_assmt_status :=
527: per_pma_shd.g_old_rec.appraisal_assmt_status;
528: End If;
529: If (p_rec.auto_conc_process = hr_api.g_varchar2) then
530: p_rec.auto_conc_process :=
531: per_pma_shd.g_old_rec.auto_conc_process;
532: End If;
533: If (p_rec.days_before_task_st_dt = hr_api.g_number) then

Line 533: If (p_rec.days_before_task_st_dt = hr_api.g_number) then

529: If (p_rec.auto_conc_process = hr_api.g_varchar2) then
530: p_rec.auto_conc_process :=
531: per_pma_shd.g_old_rec.auto_conc_process;
532: End If;
533: If (p_rec.days_before_task_st_dt = hr_api.g_number) then
534: p_rec.days_before_task_st_dt :=
535: per_pma_shd.g_old_rec.days_before_task_st_dt;
536: End If;
537: If (p_rec.participation_type = hr_api.g_varchar2) then

Line 537: If (p_rec.participation_type = hr_api.g_varchar2) then

533: If (p_rec.days_before_task_st_dt = hr_api.g_number) then
534: p_rec.days_before_task_st_dt :=
535: per_pma_shd.g_old_rec.days_before_task_st_dt;
536: End If;
537: If (p_rec.participation_type = hr_api.g_varchar2) then
538: p_rec.participation_type :=
539: per_pma_shd.g_old_rec.participation_type;
540: End If;
541: If (p_rec.questionnaire_template_id = hr_api.g_number) then

Line 541: If (p_rec.questionnaire_template_id = hr_api.g_number) then

537: If (p_rec.participation_type = hr_api.g_varchar2) then
538: p_rec.participation_type :=
539: per_pma_shd.g_old_rec.participation_type;
540: End If;
541: If (p_rec.questionnaire_template_id = hr_api.g_number) then
542: p_rec.questionnaire_template_id :=
543: per_pma_shd.g_old_rec.questionnaire_template_id;
544: End If;
545: If (p_rec.attribute_category = hr_api.g_varchar2) then

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

541: If (p_rec.questionnaire_template_id = hr_api.g_number) then
542: p_rec.questionnaire_template_id :=
543: per_pma_shd.g_old_rec.questionnaire_template_id;
544: End If;
545: If (p_rec.attribute_category = hr_api.g_varchar2) then
546: p_rec.attribute_category :=
547: per_pma_shd.g_old_rec.attribute_category;
548: End If;
549: If (p_rec.attribute1 = hr_api.g_varchar2) then

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

545: If (p_rec.attribute_category = hr_api.g_varchar2) then
546: p_rec.attribute_category :=
547: per_pma_shd.g_old_rec.attribute_category;
548: End If;
549: If (p_rec.attribute1 = hr_api.g_varchar2) then
550: p_rec.attribute1 :=
551: per_pma_shd.g_old_rec.attribute1;
552: End If;
553: If (p_rec.attribute2 = hr_api.g_varchar2) then

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

549: If (p_rec.attribute1 = hr_api.g_varchar2) then
550: p_rec.attribute1 :=
551: per_pma_shd.g_old_rec.attribute1;
552: End If;
553: If (p_rec.attribute2 = hr_api.g_varchar2) then
554: p_rec.attribute2 :=
555: per_pma_shd.g_old_rec.attribute2;
556: End If;
557: If (p_rec.attribute3 = hr_api.g_varchar2) then

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

553: If (p_rec.attribute2 = hr_api.g_varchar2) then
554: p_rec.attribute2 :=
555: per_pma_shd.g_old_rec.attribute2;
556: End If;
557: If (p_rec.attribute3 = hr_api.g_varchar2) then
558: p_rec.attribute3 :=
559: per_pma_shd.g_old_rec.attribute3;
560: End If;
561: If (p_rec.attribute4 = hr_api.g_varchar2) then

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

557: If (p_rec.attribute3 = hr_api.g_varchar2) then
558: p_rec.attribute3 :=
559: per_pma_shd.g_old_rec.attribute3;
560: End If;
561: If (p_rec.attribute4 = hr_api.g_varchar2) then
562: p_rec.attribute4 :=
563: per_pma_shd.g_old_rec.attribute4;
564: End If;
565: If (p_rec.attribute5 = hr_api.g_varchar2) then

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

561: If (p_rec.attribute4 = hr_api.g_varchar2) then
562: p_rec.attribute4 :=
563: per_pma_shd.g_old_rec.attribute4;
564: End If;
565: If (p_rec.attribute5 = hr_api.g_varchar2) then
566: p_rec.attribute5 :=
567: per_pma_shd.g_old_rec.attribute5;
568: End If;
569: If (p_rec.attribute6 = hr_api.g_varchar2) then

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

565: If (p_rec.attribute5 = hr_api.g_varchar2) then
566: p_rec.attribute5 :=
567: per_pma_shd.g_old_rec.attribute5;
568: End If;
569: If (p_rec.attribute6 = hr_api.g_varchar2) then
570: p_rec.attribute6 :=
571: per_pma_shd.g_old_rec.attribute6;
572: End If;
573: If (p_rec.attribute7 = hr_api.g_varchar2) then

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

569: If (p_rec.attribute6 = hr_api.g_varchar2) then
570: p_rec.attribute6 :=
571: per_pma_shd.g_old_rec.attribute6;
572: End If;
573: If (p_rec.attribute7 = hr_api.g_varchar2) then
574: p_rec.attribute7 :=
575: per_pma_shd.g_old_rec.attribute7;
576: End If;
577: If (p_rec.attribute8 = hr_api.g_varchar2) then

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

573: If (p_rec.attribute7 = hr_api.g_varchar2) then
574: p_rec.attribute7 :=
575: per_pma_shd.g_old_rec.attribute7;
576: End If;
577: If (p_rec.attribute8 = hr_api.g_varchar2) then
578: p_rec.attribute8 :=
579: per_pma_shd.g_old_rec.attribute8;
580: End If;
581: If (p_rec.attribute9 = hr_api.g_varchar2) then

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

577: If (p_rec.attribute8 = hr_api.g_varchar2) then
578: p_rec.attribute8 :=
579: per_pma_shd.g_old_rec.attribute8;
580: End If;
581: If (p_rec.attribute9 = hr_api.g_varchar2) then
582: p_rec.attribute9 :=
583: per_pma_shd.g_old_rec.attribute9;
584: End If;
585: If (p_rec.attribute10 = hr_api.g_varchar2) then

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

581: If (p_rec.attribute9 = hr_api.g_varchar2) then
582: p_rec.attribute9 :=
583: per_pma_shd.g_old_rec.attribute9;
584: End If;
585: If (p_rec.attribute10 = hr_api.g_varchar2) then
586: p_rec.attribute10 :=
587: per_pma_shd.g_old_rec.attribute10;
588: End If;
589: If (p_rec.attribute11 = hr_api.g_varchar2) then

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

585: If (p_rec.attribute10 = hr_api.g_varchar2) then
586: p_rec.attribute10 :=
587: per_pma_shd.g_old_rec.attribute10;
588: End If;
589: If (p_rec.attribute11 = hr_api.g_varchar2) then
590: p_rec.attribute11 :=
591: per_pma_shd.g_old_rec.attribute11;
592: End If;
593: If (p_rec.attribute12 = hr_api.g_varchar2) then

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

589: If (p_rec.attribute11 = hr_api.g_varchar2) then
590: p_rec.attribute11 :=
591: per_pma_shd.g_old_rec.attribute11;
592: End If;
593: If (p_rec.attribute12 = hr_api.g_varchar2) then
594: p_rec.attribute12 :=
595: per_pma_shd.g_old_rec.attribute12;
596: End If;
597: If (p_rec.attribute13 = hr_api.g_varchar2) then

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

593: If (p_rec.attribute12 = hr_api.g_varchar2) then
594: p_rec.attribute12 :=
595: per_pma_shd.g_old_rec.attribute12;
596: End If;
597: If (p_rec.attribute13 = hr_api.g_varchar2) then
598: p_rec.attribute13 :=
599: per_pma_shd.g_old_rec.attribute13;
600: End If;
601: If (p_rec.attribute14 = hr_api.g_varchar2) then

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

597: If (p_rec.attribute13 = hr_api.g_varchar2) then
598: p_rec.attribute13 :=
599: per_pma_shd.g_old_rec.attribute13;
600: End If;
601: If (p_rec.attribute14 = hr_api.g_varchar2) then
602: p_rec.attribute14 :=
603: per_pma_shd.g_old_rec.attribute14;
604: End If;
605: If (p_rec.attribute15 = hr_api.g_varchar2) then

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

601: If (p_rec.attribute14 = hr_api.g_varchar2) then
602: p_rec.attribute14 :=
603: per_pma_shd.g_old_rec.attribute14;
604: End If;
605: If (p_rec.attribute15 = hr_api.g_varchar2) then
606: p_rec.attribute15 :=
607: per_pma_shd.g_old_rec.attribute15;
608: End If;
609: If (p_rec.attribute16 = hr_api.g_varchar2) then

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

605: If (p_rec.attribute15 = hr_api.g_varchar2) then
606: p_rec.attribute15 :=
607: per_pma_shd.g_old_rec.attribute15;
608: End If;
609: If (p_rec.attribute16 = hr_api.g_varchar2) then
610: p_rec.attribute16 :=
611: per_pma_shd.g_old_rec.attribute16;
612: End If;
613: If (p_rec.attribute17 = hr_api.g_varchar2) then

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

609: If (p_rec.attribute16 = hr_api.g_varchar2) then
610: p_rec.attribute16 :=
611: per_pma_shd.g_old_rec.attribute16;
612: End If;
613: If (p_rec.attribute17 = hr_api.g_varchar2) then
614: p_rec.attribute17 :=
615: per_pma_shd.g_old_rec.attribute17;
616: End If;
617: If (p_rec.attribute18 = hr_api.g_varchar2) then

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

613: If (p_rec.attribute17 = hr_api.g_varchar2) then
614: p_rec.attribute17 :=
615: per_pma_shd.g_old_rec.attribute17;
616: End If;
617: If (p_rec.attribute18 = hr_api.g_varchar2) then
618: p_rec.attribute18 :=
619: per_pma_shd.g_old_rec.attribute18;
620: End If;
621: If (p_rec.attribute19 = hr_api.g_varchar2) then

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

617: If (p_rec.attribute18 = hr_api.g_varchar2) then
618: p_rec.attribute18 :=
619: per_pma_shd.g_old_rec.attribute18;
620: End If;
621: If (p_rec.attribute19 = hr_api.g_varchar2) then
622: p_rec.attribute19 :=
623: per_pma_shd.g_old_rec.attribute19;
624: End If;
625: If (p_rec.attribute20 = hr_api.g_varchar2) then

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

621: If (p_rec.attribute19 = hr_api.g_varchar2) then
622: p_rec.attribute19 :=
623: per_pma_shd.g_old_rec.attribute19;
624: End If;
625: If (p_rec.attribute20 = hr_api.g_varchar2) then
626: p_rec.attribute20 :=
627: per_pma_shd.g_old_rec.attribute20;
628: End If;
629: If (p_rec.attribute21 = hr_api.g_varchar2) then

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

625: If (p_rec.attribute20 = hr_api.g_varchar2) then
626: p_rec.attribute20 :=
627: per_pma_shd.g_old_rec.attribute20;
628: End If;
629: If (p_rec.attribute21 = hr_api.g_varchar2) then
630: p_rec.attribute21 :=
631: per_pma_shd.g_old_rec.attribute21;
632: End If;
633: If (p_rec.attribute22 = hr_api.g_varchar2) then

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

629: If (p_rec.attribute21 = hr_api.g_varchar2) then
630: p_rec.attribute21 :=
631: per_pma_shd.g_old_rec.attribute21;
632: End If;
633: If (p_rec.attribute22 = hr_api.g_varchar2) then
634: p_rec.attribute22 :=
635: per_pma_shd.g_old_rec.attribute22;
636: End If;
637: If (p_rec.attribute23 = hr_api.g_varchar2) then

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

633: If (p_rec.attribute22 = hr_api.g_varchar2) then
634: p_rec.attribute22 :=
635: per_pma_shd.g_old_rec.attribute22;
636: End If;
637: If (p_rec.attribute23 = hr_api.g_varchar2) then
638: p_rec.attribute23 :=
639: per_pma_shd.g_old_rec.attribute23;
640: End If;
641: If (p_rec.attribute24 = hr_api.g_varchar2) then

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

637: If (p_rec.attribute23 = hr_api.g_varchar2) then
638: p_rec.attribute23 :=
639: per_pma_shd.g_old_rec.attribute23;
640: End If;
641: If (p_rec.attribute24 = hr_api.g_varchar2) then
642: p_rec.attribute24 :=
643: per_pma_shd.g_old_rec.attribute24;
644: End If;
645: If (p_rec.attribute25 = hr_api.g_varchar2) then

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

641: If (p_rec.attribute24 = hr_api.g_varchar2) then
642: p_rec.attribute24 :=
643: per_pma_shd.g_old_rec.attribute24;
644: End If;
645: If (p_rec.attribute25 = hr_api.g_varchar2) then
646: p_rec.attribute25 :=
647: per_pma_shd.g_old_rec.attribute25;
648: End If;
649: If (p_rec.attribute26 = hr_api.g_varchar2) then

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

645: If (p_rec.attribute25 = hr_api.g_varchar2) then
646: p_rec.attribute25 :=
647: per_pma_shd.g_old_rec.attribute25;
648: End If;
649: If (p_rec.attribute26 = hr_api.g_varchar2) then
650: p_rec.attribute26 :=
651: per_pma_shd.g_old_rec.attribute26;
652: End If;
653: If (p_rec.attribute27 = hr_api.g_varchar2) then

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

649: If (p_rec.attribute26 = hr_api.g_varchar2) then
650: p_rec.attribute26 :=
651: per_pma_shd.g_old_rec.attribute26;
652: End If;
653: If (p_rec.attribute27 = hr_api.g_varchar2) then
654: p_rec.attribute27 :=
655: per_pma_shd.g_old_rec.attribute27;
656: End If;
657: If (p_rec.attribute28 = hr_api.g_varchar2) then

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

653: If (p_rec.attribute27 = hr_api.g_varchar2) then
654: p_rec.attribute27 :=
655: per_pma_shd.g_old_rec.attribute27;
656: End If;
657: If (p_rec.attribute28 = hr_api.g_varchar2) then
658: p_rec.attribute28 :=
659: per_pma_shd.g_old_rec.attribute28;
660: End If;
661: If (p_rec.attribute29 = hr_api.g_varchar2) then

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

657: If (p_rec.attribute28 = hr_api.g_varchar2) then
658: p_rec.attribute28 :=
659: per_pma_shd.g_old_rec.attribute28;
660: End If;
661: If (p_rec.attribute29 = hr_api.g_varchar2) then
662: p_rec.attribute29 :=
663: per_pma_shd.g_old_rec.attribute29;
664: End If;
665: If (p_rec.attribute30 = hr_api.g_varchar2) then

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

661: If (p_rec.attribute29 = hr_api.g_varchar2) then
662: p_rec.attribute29 :=
663: per_pma_shd.g_old_rec.attribute29;
664: End If;
665: If (p_rec.attribute30 = hr_api.g_varchar2) then
666: p_rec.attribute30 :=
667: per_pma_shd.g_old_rec.attribute30;
668: End If;
669: --

Line 733: ,p_start_date in date default hr_api.g_date

729: Procedure upd
730: (p_effective_date in date
731: ,p_appraisal_period_id in number
732: ,p_object_version_number in out nocopy number
733: ,p_start_date in date default hr_api.g_date
734: ,p_end_date in date default hr_api.g_date
735: ,p_task_start_date in date default hr_api.g_date
736: ,p_task_end_date in date default hr_api.g_date
737: ,p_initiator_code in varchar2 default hr_api.g_varchar2

Line 734: ,p_end_date in date default hr_api.g_date

730: (p_effective_date in date
731: ,p_appraisal_period_id in number
732: ,p_object_version_number in out nocopy number
733: ,p_start_date in date default hr_api.g_date
734: ,p_end_date in date default hr_api.g_date
735: ,p_task_start_date in date default hr_api.g_date
736: ,p_task_end_date in date default hr_api.g_date
737: ,p_initiator_code in varchar2 default hr_api.g_varchar2
738: ,p_appraisal_system_type in varchar2 default hr_api.g_varchar2

Line 735: ,p_task_start_date in date default hr_api.g_date

731: ,p_appraisal_period_id in number
732: ,p_object_version_number in out nocopy number
733: ,p_start_date in date default hr_api.g_date
734: ,p_end_date in date default hr_api.g_date
735: ,p_task_start_date in date default hr_api.g_date
736: ,p_task_end_date in date default hr_api.g_date
737: ,p_initiator_code in varchar2 default hr_api.g_varchar2
738: ,p_appraisal_system_type in varchar2 default hr_api.g_varchar2
739: ,p_appraisal_type in varchar2 default hr_api.g_varchar2

Line 736: ,p_task_end_date in date default hr_api.g_date

732: ,p_object_version_number in out nocopy number
733: ,p_start_date in date default hr_api.g_date
734: ,p_end_date in date default hr_api.g_date
735: ,p_task_start_date in date default hr_api.g_date
736: ,p_task_end_date in date default hr_api.g_date
737: ,p_initiator_code in varchar2 default hr_api.g_varchar2
738: ,p_appraisal_system_type in varchar2 default hr_api.g_varchar2
739: ,p_appraisal_type in varchar2 default hr_api.g_varchar2
740: ,p_appraisal_assmt_status in varchar2 default hr_api.g_varchar2

Line 737: ,p_initiator_code in varchar2 default hr_api.g_varchar2

733: ,p_start_date in date default hr_api.g_date
734: ,p_end_date in date default hr_api.g_date
735: ,p_task_start_date in date default hr_api.g_date
736: ,p_task_end_date in date default hr_api.g_date
737: ,p_initiator_code in varchar2 default hr_api.g_varchar2
738: ,p_appraisal_system_type in varchar2 default hr_api.g_varchar2
739: ,p_appraisal_type in varchar2 default hr_api.g_varchar2
740: ,p_appraisal_assmt_status in varchar2 default hr_api.g_varchar2
741: ,p_auto_conc_process in varchar2 default hr_api.g_varchar2

Line 738: ,p_appraisal_system_type in varchar2 default hr_api.g_varchar2

734: ,p_end_date in date default hr_api.g_date
735: ,p_task_start_date in date default hr_api.g_date
736: ,p_task_end_date in date default hr_api.g_date
737: ,p_initiator_code in varchar2 default hr_api.g_varchar2
738: ,p_appraisal_system_type in varchar2 default hr_api.g_varchar2
739: ,p_appraisal_type in varchar2 default hr_api.g_varchar2
740: ,p_appraisal_assmt_status in varchar2 default hr_api.g_varchar2
741: ,p_auto_conc_process in varchar2 default hr_api.g_varchar2
742: ,p_days_before_task_st_dt in number default hr_api.g_number

Line 739: ,p_appraisal_type in varchar2 default hr_api.g_varchar2

735: ,p_task_start_date in date default hr_api.g_date
736: ,p_task_end_date in date default hr_api.g_date
737: ,p_initiator_code in varchar2 default hr_api.g_varchar2
738: ,p_appraisal_system_type in varchar2 default hr_api.g_varchar2
739: ,p_appraisal_type in varchar2 default hr_api.g_varchar2
740: ,p_appraisal_assmt_status in varchar2 default hr_api.g_varchar2
741: ,p_auto_conc_process in varchar2 default hr_api.g_varchar2
742: ,p_days_before_task_st_dt in number default hr_api.g_number
743: ,p_participation_type in varchar2 default hr_api.g_varchar2

Line 740: ,p_appraisal_assmt_status in varchar2 default hr_api.g_varchar2

736: ,p_task_end_date in date default hr_api.g_date
737: ,p_initiator_code in varchar2 default hr_api.g_varchar2
738: ,p_appraisal_system_type in varchar2 default hr_api.g_varchar2
739: ,p_appraisal_type in varchar2 default hr_api.g_varchar2
740: ,p_appraisal_assmt_status in varchar2 default hr_api.g_varchar2
741: ,p_auto_conc_process in varchar2 default hr_api.g_varchar2
742: ,p_days_before_task_st_dt in number default hr_api.g_number
743: ,p_participation_type in varchar2 default hr_api.g_varchar2
744: ,p_questionnaire_template_id in number default hr_api.g_number

Line 741: ,p_auto_conc_process in varchar2 default hr_api.g_varchar2

737: ,p_initiator_code in varchar2 default hr_api.g_varchar2
738: ,p_appraisal_system_type in varchar2 default hr_api.g_varchar2
739: ,p_appraisal_type in varchar2 default hr_api.g_varchar2
740: ,p_appraisal_assmt_status in varchar2 default hr_api.g_varchar2
741: ,p_auto_conc_process in varchar2 default hr_api.g_varchar2
742: ,p_days_before_task_st_dt in number default hr_api.g_number
743: ,p_participation_type in varchar2 default hr_api.g_varchar2
744: ,p_questionnaire_template_id in number default hr_api.g_number
745: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 742: ,p_days_before_task_st_dt in number default hr_api.g_number

738: ,p_appraisal_system_type in varchar2 default hr_api.g_varchar2
739: ,p_appraisal_type in varchar2 default hr_api.g_varchar2
740: ,p_appraisal_assmt_status in varchar2 default hr_api.g_varchar2
741: ,p_auto_conc_process in varchar2 default hr_api.g_varchar2
742: ,p_days_before_task_st_dt in number default hr_api.g_number
743: ,p_participation_type in varchar2 default hr_api.g_varchar2
744: ,p_questionnaire_template_id in number default hr_api.g_number
745: ,p_attribute_category in varchar2 default hr_api.g_varchar2
746: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 743: ,p_participation_type in varchar2 default hr_api.g_varchar2

739: ,p_appraisal_type in varchar2 default hr_api.g_varchar2
740: ,p_appraisal_assmt_status in varchar2 default hr_api.g_varchar2
741: ,p_auto_conc_process in varchar2 default hr_api.g_varchar2
742: ,p_days_before_task_st_dt in number default hr_api.g_number
743: ,p_participation_type in varchar2 default hr_api.g_varchar2
744: ,p_questionnaire_template_id in number default hr_api.g_number
745: ,p_attribute_category in varchar2 default hr_api.g_varchar2
746: ,p_attribute1 in varchar2 default hr_api.g_varchar2
747: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 744: ,p_questionnaire_template_id in number default hr_api.g_number

740: ,p_appraisal_assmt_status in varchar2 default hr_api.g_varchar2
741: ,p_auto_conc_process in varchar2 default hr_api.g_varchar2
742: ,p_days_before_task_st_dt in number default hr_api.g_number
743: ,p_participation_type in varchar2 default hr_api.g_varchar2
744: ,p_questionnaire_template_id in number default hr_api.g_number
745: ,p_attribute_category in varchar2 default hr_api.g_varchar2
746: ,p_attribute1 in varchar2 default hr_api.g_varchar2
747: ,p_attribute2 in varchar2 default hr_api.g_varchar2
748: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 745: ,p_attribute_category in varchar2 default hr_api.g_varchar2

741: ,p_auto_conc_process in varchar2 default hr_api.g_varchar2
742: ,p_days_before_task_st_dt in number default hr_api.g_number
743: ,p_participation_type in varchar2 default hr_api.g_varchar2
744: ,p_questionnaire_template_id in number default hr_api.g_number
745: ,p_attribute_category in varchar2 default hr_api.g_varchar2
746: ,p_attribute1 in varchar2 default hr_api.g_varchar2
747: ,p_attribute2 in varchar2 default hr_api.g_varchar2
748: ,p_attribute3 in varchar2 default hr_api.g_varchar2
749: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 746: ,p_attribute1 in varchar2 default hr_api.g_varchar2

742: ,p_days_before_task_st_dt in number default hr_api.g_number
743: ,p_participation_type in varchar2 default hr_api.g_varchar2
744: ,p_questionnaire_template_id in number default hr_api.g_number
745: ,p_attribute_category in varchar2 default hr_api.g_varchar2
746: ,p_attribute1 in varchar2 default hr_api.g_varchar2
747: ,p_attribute2 in varchar2 default hr_api.g_varchar2
748: ,p_attribute3 in varchar2 default hr_api.g_varchar2
749: ,p_attribute4 in varchar2 default hr_api.g_varchar2
750: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 747: ,p_attribute2 in varchar2 default hr_api.g_varchar2

743: ,p_participation_type in varchar2 default hr_api.g_varchar2
744: ,p_questionnaire_template_id in number default hr_api.g_number
745: ,p_attribute_category in varchar2 default hr_api.g_varchar2
746: ,p_attribute1 in varchar2 default hr_api.g_varchar2
747: ,p_attribute2 in varchar2 default hr_api.g_varchar2
748: ,p_attribute3 in varchar2 default hr_api.g_varchar2
749: ,p_attribute4 in varchar2 default hr_api.g_varchar2
750: ,p_attribute5 in varchar2 default hr_api.g_varchar2
751: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 748: ,p_attribute3 in varchar2 default hr_api.g_varchar2

744: ,p_questionnaire_template_id in number default hr_api.g_number
745: ,p_attribute_category in varchar2 default hr_api.g_varchar2
746: ,p_attribute1 in varchar2 default hr_api.g_varchar2
747: ,p_attribute2 in varchar2 default hr_api.g_varchar2
748: ,p_attribute3 in varchar2 default hr_api.g_varchar2
749: ,p_attribute4 in varchar2 default hr_api.g_varchar2
750: ,p_attribute5 in varchar2 default hr_api.g_varchar2
751: ,p_attribute6 in varchar2 default hr_api.g_varchar2
752: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 749: ,p_attribute4 in varchar2 default hr_api.g_varchar2

745: ,p_attribute_category in varchar2 default hr_api.g_varchar2
746: ,p_attribute1 in varchar2 default hr_api.g_varchar2
747: ,p_attribute2 in varchar2 default hr_api.g_varchar2
748: ,p_attribute3 in varchar2 default hr_api.g_varchar2
749: ,p_attribute4 in varchar2 default hr_api.g_varchar2
750: ,p_attribute5 in varchar2 default hr_api.g_varchar2
751: ,p_attribute6 in varchar2 default hr_api.g_varchar2
752: ,p_attribute7 in varchar2 default hr_api.g_varchar2
753: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 750: ,p_attribute5 in varchar2 default hr_api.g_varchar2

746: ,p_attribute1 in varchar2 default hr_api.g_varchar2
747: ,p_attribute2 in varchar2 default hr_api.g_varchar2
748: ,p_attribute3 in varchar2 default hr_api.g_varchar2
749: ,p_attribute4 in varchar2 default hr_api.g_varchar2
750: ,p_attribute5 in varchar2 default hr_api.g_varchar2
751: ,p_attribute6 in varchar2 default hr_api.g_varchar2
752: ,p_attribute7 in varchar2 default hr_api.g_varchar2
753: ,p_attribute8 in varchar2 default hr_api.g_varchar2
754: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 751: ,p_attribute6 in varchar2 default hr_api.g_varchar2

747: ,p_attribute2 in varchar2 default hr_api.g_varchar2
748: ,p_attribute3 in varchar2 default hr_api.g_varchar2
749: ,p_attribute4 in varchar2 default hr_api.g_varchar2
750: ,p_attribute5 in varchar2 default hr_api.g_varchar2
751: ,p_attribute6 in varchar2 default hr_api.g_varchar2
752: ,p_attribute7 in varchar2 default hr_api.g_varchar2
753: ,p_attribute8 in varchar2 default hr_api.g_varchar2
754: ,p_attribute9 in varchar2 default hr_api.g_varchar2
755: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 752: ,p_attribute7 in varchar2 default hr_api.g_varchar2

748: ,p_attribute3 in varchar2 default hr_api.g_varchar2
749: ,p_attribute4 in varchar2 default hr_api.g_varchar2
750: ,p_attribute5 in varchar2 default hr_api.g_varchar2
751: ,p_attribute6 in varchar2 default hr_api.g_varchar2
752: ,p_attribute7 in varchar2 default hr_api.g_varchar2
753: ,p_attribute8 in varchar2 default hr_api.g_varchar2
754: ,p_attribute9 in varchar2 default hr_api.g_varchar2
755: ,p_attribute10 in varchar2 default hr_api.g_varchar2
756: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 753: ,p_attribute8 in varchar2 default hr_api.g_varchar2

749: ,p_attribute4 in varchar2 default hr_api.g_varchar2
750: ,p_attribute5 in varchar2 default hr_api.g_varchar2
751: ,p_attribute6 in varchar2 default hr_api.g_varchar2
752: ,p_attribute7 in varchar2 default hr_api.g_varchar2
753: ,p_attribute8 in varchar2 default hr_api.g_varchar2
754: ,p_attribute9 in varchar2 default hr_api.g_varchar2
755: ,p_attribute10 in varchar2 default hr_api.g_varchar2
756: ,p_attribute11 in varchar2 default hr_api.g_varchar2
757: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 754: ,p_attribute9 in varchar2 default hr_api.g_varchar2

750: ,p_attribute5 in varchar2 default hr_api.g_varchar2
751: ,p_attribute6 in varchar2 default hr_api.g_varchar2
752: ,p_attribute7 in varchar2 default hr_api.g_varchar2
753: ,p_attribute8 in varchar2 default hr_api.g_varchar2
754: ,p_attribute9 in varchar2 default hr_api.g_varchar2
755: ,p_attribute10 in varchar2 default hr_api.g_varchar2
756: ,p_attribute11 in varchar2 default hr_api.g_varchar2
757: ,p_attribute12 in varchar2 default hr_api.g_varchar2
758: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 755: ,p_attribute10 in varchar2 default hr_api.g_varchar2

751: ,p_attribute6 in varchar2 default hr_api.g_varchar2
752: ,p_attribute7 in varchar2 default hr_api.g_varchar2
753: ,p_attribute8 in varchar2 default hr_api.g_varchar2
754: ,p_attribute9 in varchar2 default hr_api.g_varchar2
755: ,p_attribute10 in varchar2 default hr_api.g_varchar2
756: ,p_attribute11 in varchar2 default hr_api.g_varchar2
757: ,p_attribute12 in varchar2 default hr_api.g_varchar2
758: ,p_attribute13 in varchar2 default hr_api.g_varchar2
759: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 756: ,p_attribute11 in varchar2 default hr_api.g_varchar2

752: ,p_attribute7 in varchar2 default hr_api.g_varchar2
753: ,p_attribute8 in varchar2 default hr_api.g_varchar2
754: ,p_attribute9 in varchar2 default hr_api.g_varchar2
755: ,p_attribute10 in varchar2 default hr_api.g_varchar2
756: ,p_attribute11 in varchar2 default hr_api.g_varchar2
757: ,p_attribute12 in varchar2 default hr_api.g_varchar2
758: ,p_attribute13 in varchar2 default hr_api.g_varchar2
759: ,p_attribute14 in varchar2 default hr_api.g_varchar2
760: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 757: ,p_attribute12 in varchar2 default hr_api.g_varchar2

753: ,p_attribute8 in varchar2 default hr_api.g_varchar2
754: ,p_attribute9 in varchar2 default hr_api.g_varchar2
755: ,p_attribute10 in varchar2 default hr_api.g_varchar2
756: ,p_attribute11 in varchar2 default hr_api.g_varchar2
757: ,p_attribute12 in varchar2 default hr_api.g_varchar2
758: ,p_attribute13 in varchar2 default hr_api.g_varchar2
759: ,p_attribute14 in varchar2 default hr_api.g_varchar2
760: ,p_attribute15 in varchar2 default hr_api.g_varchar2
761: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 758: ,p_attribute13 in varchar2 default hr_api.g_varchar2

754: ,p_attribute9 in varchar2 default hr_api.g_varchar2
755: ,p_attribute10 in varchar2 default hr_api.g_varchar2
756: ,p_attribute11 in varchar2 default hr_api.g_varchar2
757: ,p_attribute12 in varchar2 default hr_api.g_varchar2
758: ,p_attribute13 in varchar2 default hr_api.g_varchar2
759: ,p_attribute14 in varchar2 default hr_api.g_varchar2
760: ,p_attribute15 in varchar2 default hr_api.g_varchar2
761: ,p_attribute16 in varchar2 default hr_api.g_varchar2
762: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 759: ,p_attribute14 in varchar2 default hr_api.g_varchar2

755: ,p_attribute10 in varchar2 default hr_api.g_varchar2
756: ,p_attribute11 in varchar2 default hr_api.g_varchar2
757: ,p_attribute12 in varchar2 default hr_api.g_varchar2
758: ,p_attribute13 in varchar2 default hr_api.g_varchar2
759: ,p_attribute14 in varchar2 default hr_api.g_varchar2
760: ,p_attribute15 in varchar2 default hr_api.g_varchar2
761: ,p_attribute16 in varchar2 default hr_api.g_varchar2
762: ,p_attribute17 in varchar2 default hr_api.g_varchar2
763: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 760: ,p_attribute15 in varchar2 default hr_api.g_varchar2

756: ,p_attribute11 in varchar2 default hr_api.g_varchar2
757: ,p_attribute12 in varchar2 default hr_api.g_varchar2
758: ,p_attribute13 in varchar2 default hr_api.g_varchar2
759: ,p_attribute14 in varchar2 default hr_api.g_varchar2
760: ,p_attribute15 in varchar2 default hr_api.g_varchar2
761: ,p_attribute16 in varchar2 default hr_api.g_varchar2
762: ,p_attribute17 in varchar2 default hr_api.g_varchar2
763: ,p_attribute18 in varchar2 default hr_api.g_varchar2
764: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 761: ,p_attribute16 in varchar2 default hr_api.g_varchar2

757: ,p_attribute12 in varchar2 default hr_api.g_varchar2
758: ,p_attribute13 in varchar2 default hr_api.g_varchar2
759: ,p_attribute14 in varchar2 default hr_api.g_varchar2
760: ,p_attribute15 in varchar2 default hr_api.g_varchar2
761: ,p_attribute16 in varchar2 default hr_api.g_varchar2
762: ,p_attribute17 in varchar2 default hr_api.g_varchar2
763: ,p_attribute18 in varchar2 default hr_api.g_varchar2
764: ,p_attribute19 in varchar2 default hr_api.g_varchar2
765: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 762: ,p_attribute17 in varchar2 default hr_api.g_varchar2

758: ,p_attribute13 in varchar2 default hr_api.g_varchar2
759: ,p_attribute14 in varchar2 default hr_api.g_varchar2
760: ,p_attribute15 in varchar2 default hr_api.g_varchar2
761: ,p_attribute16 in varchar2 default hr_api.g_varchar2
762: ,p_attribute17 in varchar2 default hr_api.g_varchar2
763: ,p_attribute18 in varchar2 default hr_api.g_varchar2
764: ,p_attribute19 in varchar2 default hr_api.g_varchar2
765: ,p_attribute20 in varchar2 default hr_api.g_varchar2
766: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 763: ,p_attribute18 in varchar2 default hr_api.g_varchar2

759: ,p_attribute14 in varchar2 default hr_api.g_varchar2
760: ,p_attribute15 in varchar2 default hr_api.g_varchar2
761: ,p_attribute16 in varchar2 default hr_api.g_varchar2
762: ,p_attribute17 in varchar2 default hr_api.g_varchar2
763: ,p_attribute18 in varchar2 default hr_api.g_varchar2
764: ,p_attribute19 in varchar2 default hr_api.g_varchar2
765: ,p_attribute20 in varchar2 default hr_api.g_varchar2
766: ,p_attribute21 in varchar2 default hr_api.g_varchar2
767: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 764: ,p_attribute19 in varchar2 default hr_api.g_varchar2

760: ,p_attribute15 in varchar2 default hr_api.g_varchar2
761: ,p_attribute16 in varchar2 default hr_api.g_varchar2
762: ,p_attribute17 in varchar2 default hr_api.g_varchar2
763: ,p_attribute18 in varchar2 default hr_api.g_varchar2
764: ,p_attribute19 in varchar2 default hr_api.g_varchar2
765: ,p_attribute20 in varchar2 default hr_api.g_varchar2
766: ,p_attribute21 in varchar2 default hr_api.g_varchar2
767: ,p_attribute22 in varchar2 default hr_api.g_varchar2
768: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 765: ,p_attribute20 in varchar2 default hr_api.g_varchar2

761: ,p_attribute16 in varchar2 default hr_api.g_varchar2
762: ,p_attribute17 in varchar2 default hr_api.g_varchar2
763: ,p_attribute18 in varchar2 default hr_api.g_varchar2
764: ,p_attribute19 in varchar2 default hr_api.g_varchar2
765: ,p_attribute20 in varchar2 default hr_api.g_varchar2
766: ,p_attribute21 in varchar2 default hr_api.g_varchar2
767: ,p_attribute22 in varchar2 default hr_api.g_varchar2
768: ,p_attribute23 in varchar2 default hr_api.g_varchar2
769: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 766: ,p_attribute21 in varchar2 default hr_api.g_varchar2

762: ,p_attribute17 in varchar2 default hr_api.g_varchar2
763: ,p_attribute18 in varchar2 default hr_api.g_varchar2
764: ,p_attribute19 in varchar2 default hr_api.g_varchar2
765: ,p_attribute20 in varchar2 default hr_api.g_varchar2
766: ,p_attribute21 in varchar2 default hr_api.g_varchar2
767: ,p_attribute22 in varchar2 default hr_api.g_varchar2
768: ,p_attribute23 in varchar2 default hr_api.g_varchar2
769: ,p_attribute24 in varchar2 default hr_api.g_varchar2
770: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 767: ,p_attribute22 in varchar2 default hr_api.g_varchar2

763: ,p_attribute18 in varchar2 default hr_api.g_varchar2
764: ,p_attribute19 in varchar2 default hr_api.g_varchar2
765: ,p_attribute20 in varchar2 default hr_api.g_varchar2
766: ,p_attribute21 in varchar2 default hr_api.g_varchar2
767: ,p_attribute22 in varchar2 default hr_api.g_varchar2
768: ,p_attribute23 in varchar2 default hr_api.g_varchar2
769: ,p_attribute24 in varchar2 default hr_api.g_varchar2
770: ,p_attribute25 in varchar2 default hr_api.g_varchar2
771: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 768: ,p_attribute23 in varchar2 default hr_api.g_varchar2

764: ,p_attribute19 in varchar2 default hr_api.g_varchar2
765: ,p_attribute20 in varchar2 default hr_api.g_varchar2
766: ,p_attribute21 in varchar2 default hr_api.g_varchar2
767: ,p_attribute22 in varchar2 default hr_api.g_varchar2
768: ,p_attribute23 in varchar2 default hr_api.g_varchar2
769: ,p_attribute24 in varchar2 default hr_api.g_varchar2
770: ,p_attribute25 in varchar2 default hr_api.g_varchar2
771: ,p_attribute26 in varchar2 default hr_api.g_varchar2
772: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 769: ,p_attribute24 in varchar2 default hr_api.g_varchar2

765: ,p_attribute20 in varchar2 default hr_api.g_varchar2
766: ,p_attribute21 in varchar2 default hr_api.g_varchar2
767: ,p_attribute22 in varchar2 default hr_api.g_varchar2
768: ,p_attribute23 in varchar2 default hr_api.g_varchar2
769: ,p_attribute24 in varchar2 default hr_api.g_varchar2
770: ,p_attribute25 in varchar2 default hr_api.g_varchar2
771: ,p_attribute26 in varchar2 default hr_api.g_varchar2
772: ,p_attribute27 in varchar2 default hr_api.g_varchar2
773: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 770: ,p_attribute25 in varchar2 default hr_api.g_varchar2

766: ,p_attribute21 in varchar2 default hr_api.g_varchar2
767: ,p_attribute22 in varchar2 default hr_api.g_varchar2
768: ,p_attribute23 in varchar2 default hr_api.g_varchar2
769: ,p_attribute24 in varchar2 default hr_api.g_varchar2
770: ,p_attribute25 in varchar2 default hr_api.g_varchar2
771: ,p_attribute26 in varchar2 default hr_api.g_varchar2
772: ,p_attribute27 in varchar2 default hr_api.g_varchar2
773: ,p_attribute28 in varchar2 default hr_api.g_varchar2
774: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 771: ,p_attribute26 in varchar2 default hr_api.g_varchar2

767: ,p_attribute22 in varchar2 default hr_api.g_varchar2
768: ,p_attribute23 in varchar2 default hr_api.g_varchar2
769: ,p_attribute24 in varchar2 default hr_api.g_varchar2
770: ,p_attribute25 in varchar2 default hr_api.g_varchar2
771: ,p_attribute26 in varchar2 default hr_api.g_varchar2
772: ,p_attribute27 in varchar2 default hr_api.g_varchar2
773: ,p_attribute28 in varchar2 default hr_api.g_varchar2
774: ,p_attribute29 in varchar2 default hr_api.g_varchar2
775: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 772: ,p_attribute27 in varchar2 default hr_api.g_varchar2

768: ,p_attribute23 in varchar2 default hr_api.g_varchar2
769: ,p_attribute24 in varchar2 default hr_api.g_varchar2
770: ,p_attribute25 in varchar2 default hr_api.g_varchar2
771: ,p_attribute26 in varchar2 default hr_api.g_varchar2
772: ,p_attribute27 in varchar2 default hr_api.g_varchar2
773: ,p_attribute28 in varchar2 default hr_api.g_varchar2
774: ,p_attribute29 in varchar2 default hr_api.g_varchar2
775: ,p_attribute30 in varchar2 default hr_api.g_varchar2
776: ) is

Line 773: ,p_attribute28 in varchar2 default hr_api.g_varchar2

769: ,p_attribute24 in varchar2 default hr_api.g_varchar2
770: ,p_attribute25 in varchar2 default hr_api.g_varchar2
771: ,p_attribute26 in varchar2 default hr_api.g_varchar2
772: ,p_attribute27 in varchar2 default hr_api.g_varchar2
773: ,p_attribute28 in varchar2 default hr_api.g_varchar2
774: ,p_attribute29 in varchar2 default hr_api.g_varchar2
775: ,p_attribute30 in varchar2 default hr_api.g_varchar2
776: ) is
777: --

Line 774: ,p_attribute29 in varchar2 default hr_api.g_varchar2

770: ,p_attribute25 in varchar2 default hr_api.g_varchar2
771: ,p_attribute26 in varchar2 default hr_api.g_varchar2
772: ,p_attribute27 in varchar2 default hr_api.g_varchar2
773: ,p_attribute28 in varchar2 default hr_api.g_varchar2
774: ,p_attribute29 in varchar2 default hr_api.g_varchar2
775: ,p_attribute30 in varchar2 default hr_api.g_varchar2
776: ) is
777: --
778: l_rec per_pma_shd.g_rec_type;

Line 775: ,p_attribute30 in varchar2 default hr_api.g_varchar2

771: ,p_attribute26 in varchar2 default hr_api.g_varchar2
772: ,p_attribute27 in varchar2 default hr_api.g_varchar2
773: ,p_attribute28 in varchar2 default hr_api.g_varchar2
774: ,p_attribute29 in varchar2 default hr_api.g_varchar2
775: ,p_attribute30 in varchar2 default hr_api.g_varchar2
776: ) is
777: --
778: l_rec per_pma_shd.g_rec_type;
779: l_proc varchar2(72) := g_package||'upd';

Line 791: ,hr_api.g_number --p_plan_id

787: l_rec :=
788: per_pma_shd.convert_args
789: (p_appraisal_period_id
790: ,p_object_version_number
791: ,hr_api.g_number --p_plan_id
792: ,hr_api.g_number --p_appraisal_template_id
793: ,p_start_date
794: ,p_end_date
795: ,p_task_start_date

Line 792: ,hr_api.g_number --p_appraisal_template_id

788: per_pma_shd.convert_args
789: (p_appraisal_period_id
790: ,p_object_version_number
791: ,hr_api.g_number --p_plan_id
792: ,hr_api.g_number --p_appraisal_template_id
793: ,p_start_date
794: ,p_end_date
795: ,p_task_start_date
796: ,p_task_end_date