eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_EQT_UPD dependencies on HR_API

Line 148: When hr_api.check_integrity_violated Then

144: --
145: hr_utility.set_location(' Leaving:'||l_proc, 10);
146: --
147: Exception
148: When hr_api.check_integrity_violated Then
149: -- A check constraint has been violated
150: per_eqt_shd.g_api_dml := false; -- Unset the api dml status
151: per_eqt_shd.constraint_error
152: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

148: When hr_api.check_integrity_violated Then
149: -- A check constraint has been violated
150: per_eqt_shd.g_api_dml := false; -- Unset the api dml status
151: per_eqt_shd.constraint_error
152: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
153: When hr_api.parent_integrity_violated Then
154: -- Parent integrity has been violated
155: per_eqt_shd.g_api_dml := false; -- Unset the api dml status
156: per_eqt_shd.constraint_error

Line 153: When hr_api.parent_integrity_violated Then

149: -- A check constraint has been violated
150: per_eqt_shd.g_api_dml := false; -- Unset the api dml status
151: per_eqt_shd.constraint_error
152: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
153: When hr_api.parent_integrity_violated Then
154: -- Parent integrity has been violated
155: per_eqt_shd.g_api_dml := false; -- Unset the api dml status
156: per_eqt_shd.constraint_error
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

153: When hr_api.parent_integrity_violated Then
154: -- Parent integrity has been violated
155: per_eqt_shd.g_api_dml := false; -- Unset the api dml status
156: per_eqt_shd.constraint_error
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
158: When hr_api.unique_integrity_violated Then
159: -- Unique integrity has been violated
160: per_eqt_shd.g_api_dml := false; -- Unset the api dml status
161: per_eqt_shd.constraint_error

Line 158: When hr_api.unique_integrity_violated Then

154: -- Parent integrity has been violated
155: per_eqt_shd.g_api_dml := false; -- Unset the api dml status
156: per_eqt_shd.constraint_error
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
158: When hr_api.unique_integrity_violated Then
159: -- Unique integrity has been violated
160: per_eqt_shd.g_api_dml := false; -- Unset the api dml status
161: per_eqt_shd.constraint_error
162: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

158: When hr_api.unique_integrity_violated Then
159: -- Unique integrity has been violated
160: per_eqt_shd.g_api_dml := false; -- Unset the api dml status
161: per_eqt_shd.constraint_error
162: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
163: When Others Then
164: per_eqt_shd.g_api_dml := false; -- Unset the api dml status
165: Raise;
166: End update_dml;

Line 395: when hr_api.cannot_find_prog_unit then

391: ,p_provider_o => per_eqt_shd.g_old_rec.provider
392: ,p_qa_organization_o => per_eqt_shd.g_old_rec.qa_organization
393: );
394: exception
395: when hr_api.cannot_find_prog_unit then
396: hr_api.cannot_find_prog_unit_error
397: (p_module_name => 'PER_QUALIFICATION_TYPES'
398: ,p_hook_type => 'AU'
399: );

Line 396: hr_api.cannot_find_prog_unit_error

392: ,p_qa_organization_o => per_eqt_shd.g_old_rec.qa_organization
393: );
394: exception
395: when hr_api.cannot_find_prog_unit then
396: hr_api.cannot_find_prog_unit_error
397: (p_module_name => 'PER_QUALIFICATION_TYPES'
398: ,p_hook_type => 'AU'
399: );
400: end;

Line 462: If (p_rec.name = hr_api.g_varchar2) then

458: -- p_rec plsql record structure
459: -- to see if a system default is being used. If a system default
460: -- is being used then we must set to the 'current' argument value.
461: --
462: If (p_rec.name = hr_api.g_varchar2) then
463: p_rec.name :=
464: per_eqt_shd.g_old_rec.name;
465: End If;
466: If (p_rec.category = hr_api.g_varchar2) then

Line 466: If (p_rec.category = hr_api.g_varchar2) then

462: If (p_rec.name = hr_api.g_varchar2) then
463: p_rec.name :=
464: per_eqt_shd.g_old_rec.name;
465: End If;
466: If (p_rec.category = hr_api.g_varchar2) then
467: p_rec.category :=
468: per_eqt_shd.g_old_rec.category;
469: End If;
470: If (p_rec.rank = hr_api.g_number) then

Line 470: If (p_rec.rank = hr_api.g_number) then

466: If (p_rec.category = hr_api.g_varchar2) then
467: p_rec.category :=
468: per_eqt_shd.g_old_rec.category;
469: End If;
470: If (p_rec.rank = hr_api.g_number) then
471: p_rec.rank :=
472: per_eqt_shd.g_old_rec.rank;
473: End If;
474: If (p_rec.attribute_category = hr_api.g_varchar2) then

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

470: If (p_rec.rank = hr_api.g_number) then
471: p_rec.rank :=
472: per_eqt_shd.g_old_rec.rank;
473: End If;
474: If (p_rec.attribute_category = hr_api.g_varchar2) then
475: p_rec.attribute_category :=
476: per_eqt_shd.g_old_rec.attribute_category;
477: End If;
478: If (p_rec.attribute1 = hr_api.g_varchar2) then

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

474: If (p_rec.attribute_category = hr_api.g_varchar2) then
475: p_rec.attribute_category :=
476: per_eqt_shd.g_old_rec.attribute_category;
477: End If;
478: If (p_rec.attribute1 = hr_api.g_varchar2) then
479: p_rec.attribute1 :=
480: per_eqt_shd.g_old_rec.attribute1;
481: End If;
482: If (p_rec.attribute2 = hr_api.g_varchar2) then

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

478: If (p_rec.attribute1 = hr_api.g_varchar2) then
479: p_rec.attribute1 :=
480: per_eqt_shd.g_old_rec.attribute1;
481: End If;
482: If (p_rec.attribute2 = hr_api.g_varchar2) then
483: p_rec.attribute2 :=
484: per_eqt_shd.g_old_rec.attribute2;
485: End If;
486: If (p_rec.attribute3 = hr_api.g_varchar2) then

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

482: If (p_rec.attribute2 = hr_api.g_varchar2) then
483: p_rec.attribute2 :=
484: per_eqt_shd.g_old_rec.attribute2;
485: End If;
486: If (p_rec.attribute3 = hr_api.g_varchar2) then
487: p_rec.attribute3 :=
488: per_eqt_shd.g_old_rec.attribute3;
489: End If;
490: If (p_rec.attribute4 = hr_api.g_varchar2) then

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

486: If (p_rec.attribute3 = hr_api.g_varchar2) then
487: p_rec.attribute3 :=
488: per_eqt_shd.g_old_rec.attribute3;
489: End If;
490: If (p_rec.attribute4 = hr_api.g_varchar2) then
491: p_rec.attribute4 :=
492: per_eqt_shd.g_old_rec.attribute4;
493: End If;
494: If (p_rec.attribute5 = hr_api.g_varchar2) then

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

490: If (p_rec.attribute4 = hr_api.g_varchar2) then
491: p_rec.attribute4 :=
492: per_eqt_shd.g_old_rec.attribute4;
493: End If;
494: If (p_rec.attribute5 = hr_api.g_varchar2) then
495: p_rec.attribute5 :=
496: per_eqt_shd.g_old_rec.attribute5;
497: End If;
498: If (p_rec.attribute6 = hr_api.g_varchar2) then

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

494: If (p_rec.attribute5 = hr_api.g_varchar2) then
495: p_rec.attribute5 :=
496: per_eqt_shd.g_old_rec.attribute5;
497: End If;
498: If (p_rec.attribute6 = hr_api.g_varchar2) then
499: p_rec.attribute6 :=
500: per_eqt_shd.g_old_rec.attribute6;
501: End If;
502: If (p_rec.attribute7 = hr_api.g_varchar2) then

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

498: If (p_rec.attribute6 = hr_api.g_varchar2) then
499: p_rec.attribute6 :=
500: per_eqt_shd.g_old_rec.attribute6;
501: End If;
502: If (p_rec.attribute7 = hr_api.g_varchar2) then
503: p_rec.attribute7 :=
504: per_eqt_shd.g_old_rec.attribute7;
505: End If;
506: If (p_rec.attribute8 = hr_api.g_varchar2) then

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

502: If (p_rec.attribute7 = hr_api.g_varchar2) then
503: p_rec.attribute7 :=
504: per_eqt_shd.g_old_rec.attribute7;
505: End If;
506: If (p_rec.attribute8 = hr_api.g_varchar2) then
507: p_rec.attribute8 :=
508: per_eqt_shd.g_old_rec.attribute8;
509: End If;
510: If (p_rec.attribute9 = hr_api.g_varchar2) then

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

506: If (p_rec.attribute8 = hr_api.g_varchar2) then
507: p_rec.attribute8 :=
508: per_eqt_shd.g_old_rec.attribute8;
509: End If;
510: If (p_rec.attribute9 = hr_api.g_varchar2) then
511: p_rec.attribute9 :=
512: per_eqt_shd.g_old_rec.attribute9;
513: End If;
514: If (p_rec.attribute10 = hr_api.g_varchar2) then

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

510: If (p_rec.attribute9 = hr_api.g_varchar2) then
511: p_rec.attribute9 :=
512: per_eqt_shd.g_old_rec.attribute9;
513: End If;
514: If (p_rec.attribute10 = hr_api.g_varchar2) then
515: p_rec.attribute10 :=
516: per_eqt_shd.g_old_rec.attribute10;
517: End If;
518: If (p_rec.attribute11 = hr_api.g_varchar2) then

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

514: If (p_rec.attribute10 = hr_api.g_varchar2) then
515: p_rec.attribute10 :=
516: per_eqt_shd.g_old_rec.attribute10;
517: End If;
518: If (p_rec.attribute11 = hr_api.g_varchar2) then
519: p_rec.attribute11 :=
520: per_eqt_shd.g_old_rec.attribute11;
521: End If;
522: If (p_rec.attribute12 = hr_api.g_varchar2) then

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

518: If (p_rec.attribute11 = hr_api.g_varchar2) then
519: p_rec.attribute11 :=
520: per_eqt_shd.g_old_rec.attribute11;
521: End If;
522: If (p_rec.attribute12 = hr_api.g_varchar2) then
523: p_rec.attribute12 :=
524: per_eqt_shd.g_old_rec.attribute12;
525: End If;
526: If (p_rec.attribute13 = hr_api.g_varchar2) then

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

522: If (p_rec.attribute12 = hr_api.g_varchar2) then
523: p_rec.attribute12 :=
524: per_eqt_shd.g_old_rec.attribute12;
525: End If;
526: If (p_rec.attribute13 = hr_api.g_varchar2) then
527: p_rec.attribute13 :=
528: per_eqt_shd.g_old_rec.attribute13;
529: End If;
530: If (p_rec.attribute14 = hr_api.g_varchar2) then

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

526: If (p_rec.attribute13 = hr_api.g_varchar2) then
527: p_rec.attribute13 :=
528: per_eqt_shd.g_old_rec.attribute13;
529: End If;
530: If (p_rec.attribute14 = hr_api.g_varchar2) then
531: p_rec.attribute14 :=
532: per_eqt_shd.g_old_rec.attribute14;
533: End If;
534: If (p_rec.attribute15 = hr_api.g_varchar2) then

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

530: If (p_rec.attribute14 = hr_api.g_varchar2) then
531: p_rec.attribute14 :=
532: per_eqt_shd.g_old_rec.attribute14;
533: End If;
534: If (p_rec.attribute15 = hr_api.g_varchar2) then
535: p_rec.attribute15 :=
536: per_eqt_shd.g_old_rec.attribute15;
537: End If;
538: If (p_rec.attribute16 = hr_api.g_varchar2) then

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

534: If (p_rec.attribute15 = hr_api.g_varchar2) then
535: p_rec.attribute15 :=
536: per_eqt_shd.g_old_rec.attribute15;
537: End If;
538: If (p_rec.attribute16 = hr_api.g_varchar2) then
539: p_rec.attribute16 :=
540: per_eqt_shd.g_old_rec.attribute16;
541: End If;
542: If (p_rec.attribute17 = hr_api.g_varchar2) then

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

538: If (p_rec.attribute16 = hr_api.g_varchar2) then
539: p_rec.attribute16 :=
540: per_eqt_shd.g_old_rec.attribute16;
541: End If;
542: If (p_rec.attribute17 = hr_api.g_varchar2) then
543: p_rec.attribute17 :=
544: per_eqt_shd.g_old_rec.attribute17;
545: End If;
546: If (p_rec.attribute18 = hr_api.g_varchar2) then

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

542: If (p_rec.attribute17 = hr_api.g_varchar2) then
543: p_rec.attribute17 :=
544: per_eqt_shd.g_old_rec.attribute17;
545: End If;
546: If (p_rec.attribute18 = hr_api.g_varchar2) then
547: p_rec.attribute18 :=
548: per_eqt_shd.g_old_rec.attribute18;
549: End If;
550: If (p_rec.attribute19 = hr_api.g_varchar2) then

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

546: If (p_rec.attribute18 = hr_api.g_varchar2) then
547: p_rec.attribute18 :=
548: per_eqt_shd.g_old_rec.attribute18;
549: End If;
550: If (p_rec.attribute19 = hr_api.g_varchar2) then
551: p_rec.attribute19 :=
552: per_eqt_shd.g_old_rec.attribute19;
553: End If;
554: If (p_rec.attribute20 = hr_api.g_varchar2) then

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

550: If (p_rec.attribute19 = hr_api.g_varchar2) then
551: p_rec.attribute19 :=
552: per_eqt_shd.g_old_rec.attribute19;
553: End If;
554: If (p_rec.attribute20 = hr_api.g_varchar2) then
555: p_rec.attribute20 :=
556: per_eqt_shd.g_old_rec.attribute20;
557: End If;
558:

Line 562: If (p_rec.information_category = hr_api.g_varchar2) then

558:
559: -- mvankada
560: -- For Developer DF columns
561:
562: If (p_rec.information_category = hr_api.g_varchar2) then
563: p_rec.information_category :=
564: per_eqt_shd.g_old_rec.information_category;
565: End If;
566: If (p_rec.information1 = hr_api.g_varchar2) then

Line 566: If (p_rec.information1 = hr_api.g_varchar2) then

562: If (p_rec.information_category = hr_api.g_varchar2) then
563: p_rec.information_category :=
564: per_eqt_shd.g_old_rec.information_category;
565: End If;
566: If (p_rec.information1 = hr_api.g_varchar2) then
567: p_rec.information1 :=
568: per_eqt_shd.g_old_rec.information1;
569: End If;
570: If (p_rec.information2 = hr_api.g_varchar2) then

Line 570: If (p_rec.information2 = hr_api.g_varchar2) then

566: If (p_rec.information1 = hr_api.g_varchar2) then
567: p_rec.information1 :=
568: per_eqt_shd.g_old_rec.information1;
569: End If;
570: If (p_rec.information2 = hr_api.g_varchar2) then
571: p_rec.information2 :=
572: per_eqt_shd.g_old_rec.information2;
573: End If;
574: If (p_rec.information3 = hr_api.g_varchar2) then

Line 574: If (p_rec.information3 = hr_api.g_varchar2) then

570: If (p_rec.information2 = hr_api.g_varchar2) then
571: p_rec.information2 :=
572: per_eqt_shd.g_old_rec.information2;
573: End If;
574: If (p_rec.information3 = hr_api.g_varchar2) then
575: p_rec.information3 :=
576: per_eqt_shd.g_old_rec.information3;
577: End If;
578: If (p_rec.information4 = hr_api.g_varchar2) then

Line 578: If (p_rec.information4 = hr_api.g_varchar2) then

574: If (p_rec.information3 = hr_api.g_varchar2) then
575: p_rec.information3 :=
576: per_eqt_shd.g_old_rec.information3;
577: End If;
578: If (p_rec.information4 = hr_api.g_varchar2) then
579: p_rec.information4 :=
580: per_eqt_shd.g_old_rec.information4;
581: End If;
582: If (p_rec.information5 = hr_api.g_varchar2) then

Line 582: If (p_rec.information5 = hr_api.g_varchar2) then

578: If (p_rec.information4 = hr_api.g_varchar2) then
579: p_rec.information4 :=
580: per_eqt_shd.g_old_rec.information4;
581: End If;
582: If (p_rec.information5 = hr_api.g_varchar2) then
583: p_rec.information5 :=
584: per_eqt_shd.g_old_rec.information5;
585: End If;
586: If (p_rec.information6 = hr_api.g_varchar2) then

Line 586: If (p_rec.information6 = hr_api.g_varchar2) then

582: If (p_rec.information5 = hr_api.g_varchar2) then
583: p_rec.information5 :=
584: per_eqt_shd.g_old_rec.information5;
585: End If;
586: If (p_rec.information6 = hr_api.g_varchar2) then
587: p_rec.information6 :=
588: per_eqt_shd.g_old_rec.information6;
589: End If;
590: If (p_rec.information7 = hr_api.g_varchar2) then

Line 590: If (p_rec.information7 = hr_api.g_varchar2) then

586: If (p_rec.information6 = hr_api.g_varchar2) then
587: p_rec.information6 :=
588: per_eqt_shd.g_old_rec.information6;
589: End If;
590: If (p_rec.information7 = hr_api.g_varchar2) then
591: p_rec.information7 :=
592: per_eqt_shd.g_old_rec.information7;
593: End If;
594: If (p_rec.information8 = hr_api.g_varchar2) then

Line 594: If (p_rec.information8 = hr_api.g_varchar2) then

590: If (p_rec.information7 = hr_api.g_varchar2) then
591: p_rec.information7 :=
592: per_eqt_shd.g_old_rec.information7;
593: End If;
594: If (p_rec.information8 = hr_api.g_varchar2) then
595: p_rec.information8 :=
596: per_eqt_shd.g_old_rec.information8;
597: End If;
598: If (p_rec.information9 = hr_api.g_varchar2) then

Line 598: If (p_rec.information9 = hr_api.g_varchar2) then

594: If (p_rec.information8 = hr_api.g_varchar2) then
595: p_rec.information8 :=
596: per_eqt_shd.g_old_rec.information8;
597: End If;
598: If (p_rec.information9 = hr_api.g_varchar2) then
599: p_rec.information9 :=
600: per_eqt_shd.g_old_rec.information9;
601: End If;
602: If (p_rec.information10 = hr_api.g_varchar2) then

Line 602: If (p_rec.information10 = hr_api.g_varchar2) then

598: If (p_rec.information9 = hr_api.g_varchar2) then
599: p_rec.information9 :=
600: per_eqt_shd.g_old_rec.information9;
601: End If;
602: If (p_rec.information10 = hr_api.g_varchar2) then
603: p_rec.information10 :=
604: per_eqt_shd.g_old_rec.information10;
605: End If;
606: If (p_rec.information11 = hr_api.g_varchar2) then

Line 606: If (p_rec.information11 = hr_api.g_varchar2) then

602: If (p_rec.information10 = hr_api.g_varchar2) then
603: p_rec.information10 :=
604: per_eqt_shd.g_old_rec.information10;
605: End If;
606: If (p_rec.information11 = hr_api.g_varchar2) then
607: p_rec.information11 :=
608: per_eqt_shd.g_old_rec.information11;
609: End If;
610: If (p_rec.information12 = hr_api.g_varchar2) then

Line 610: If (p_rec.information12 = hr_api.g_varchar2) then

606: If (p_rec.information11 = hr_api.g_varchar2) then
607: p_rec.information11 :=
608: per_eqt_shd.g_old_rec.information11;
609: End If;
610: If (p_rec.information12 = hr_api.g_varchar2) then
611: p_rec.information12 :=
612: per_eqt_shd.g_old_rec.information12;
613: End If;
614: If (p_rec.information13 = hr_api.g_varchar2) then

Line 614: If (p_rec.information13 = hr_api.g_varchar2) then

610: If (p_rec.information12 = hr_api.g_varchar2) then
611: p_rec.information12 :=
612: per_eqt_shd.g_old_rec.information12;
613: End If;
614: If (p_rec.information13 = hr_api.g_varchar2) then
615: p_rec.information13 :=
616: per_eqt_shd.g_old_rec.information13;
617: End If;
618: If (p_rec.information14 = hr_api.g_varchar2) then

Line 618: If (p_rec.information14 = hr_api.g_varchar2) then

614: If (p_rec.information13 = hr_api.g_varchar2) then
615: p_rec.information13 :=
616: per_eqt_shd.g_old_rec.information13;
617: End If;
618: If (p_rec.information14 = hr_api.g_varchar2) then
619: p_rec.information14 :=
620: per_eqt_shd.g_old_rec.information14;
621: End If;
622: If (p_rec.information15 = hr_api.g_varchar2) then

Line 622: If (p_rec.information15 = hr_api.g_varchar2) then

618: If (p_rec.information14 = hr_api.g_varchar2) then
619: p_rec.information14 :=
620: per_eqt_shd.g_old_rec.information14;
621: End If;
622: If (p_rec.information15 = hr_api.g_varchar2) then
623: p_rec.information15 :=
624: per_eqt_shd.g_old_rec.information15;
625: End If;
626: If (p_rec.information16 = hr_api.g_varchar2) then

Line 626: If (p_rec.information16 = hr_api.g_varchar2) then

622: If (p_rec.information15 = hr_api.g_varchar2) then
623: p_rec.information15 :=
624: per_eqt_shd.g_old_rec.information15;
625: End If;
626: If (p_rec.information16 = hr_api.g_varchar2) then
627: p_rec.information16 :=
628: per_eqt_shd.g_old_rec.information16;
629: End If;
630: If (p_rec.information17 = hr_api.g_varchar2) then

Line 630: If (p_rec.information17 = hr_api.g_varchar2) then

626: If (p_rec.information16 = hr_api.g_varchar2) then
627: p_rec.information16 :=
628: per_eqt_shd.g_old_rec.information16;
629: End If;
630: If (p_rec.information17 = hr_api.g_varchar2) then
631: p_rec.information17 :=
632: per_eqt_shd.g_old_rec.information17;
633: End If;
634: If (p_rec.information18 = hr_api.g_varchar2) then

Line 634: If (p_rec.information18 = hr_api.g_varchar2) then

630: If (p_rec.information17 = hr_api.g_varchar2) then
631: p_rec.information17 :=
632: per_eqt_shd.g_old_rec.information17;
633: End If;
634: If (p_rec.information18 = hr_api.g_varchar2) then
635: p_rec.information18 :=
636: per_eqt_shd.g_old_rec.information18;
637: End If;
638: If (p_rec.information19 = hr_api.g_varchar2) then

Line 638: If (p_rec.information19 = hr_api.g_varchar2) then

634: If (p_rec.information18 = hr_api.g_varchar2) then
635: p_rec.information18 :=
636: per_eqt_shd.g_old_rec.information18;
637: End If;
638: If (p_rec.information19 = hr_api.g_varchar2) then
639: p_rec.information19 :=
640: per_eqt_shd.g_old_rec.information19;
641: End If;
642: If (p_rec.information20 = hr_api.g_varchar2) then

Line 642: If (p_rec.information20 = hr_api.g_varchar2) then

638: If (p_rec.information19 = hr_api.g_varchar2) then
639: p_rec.information19 :=
640: per_eqt_shd.g_old_rec.information19;
641: End If;
642: If (p_rec.information20 = hr_api.g_varchar2) then
643: p_rec.information20 :=
644: per_eqt_shd.g_old_rec.information20;
645: End If;
646: If (p_rec.information21 = hr_api.g_varchar2) then

Line 646: If (p_rec.information21 = hr_api.g_varchar2) then

642: If (p_rec.information20 = hr_api.g_varchar2) then
643: p_rec.information20 :=
644: per_eqt_shd.g_old_rec.information20;
645: End If;
646: If (p_rec.information21 = hr_api.g_varchar2) then
647: p_rec.information21 :=
648: per_eqt_shd.g_old_rec.information21;
649: End If;
650: If (p_rec.information22 = hr_api.g_varchar2) then

Line 650: If (p_rec.information22 = hr_api.g_varchar2) then

646: If (p_rec.information21 = hr_api.g_varchar2) then
647: p_rec.information21 :=
648: per_eqt_shd.g_old_rec.information21;
649: End If;
650: If (p_rec.information22 = hr_api.g_varchar2) then
651: p_rec.information22 :=
652: per_eqt_shd.g_old_rec.information22;
653: End If;
654: If (p_rec.information23 = hr_api.g_varchar2) then

Line 654: If (p_rec.information23 = hr_api.g_varchar2) then

650: If (p_rec.information22 = hr_api.g_varchar2) then
651: p_rec.information22 :=
652: per_eqt_shd.g_old_rec.information22;
653: End If;
654: If (p_rec.information23 = hr_api.g_varchar2) then
655: p_rec.information23 :=
656: per_eqt_shd.g_old_rec.information23;
657: End If;
658: If (p_rec.information24 = hr_api.g_varchar2) then

Line 658: If (p_rec.information24 = hr_api.g_varchar2) then

654: If (p_rec.information23 = hr_api.g_varchar2) then
655: p_rec.information23 :=
656: per_eqt_shd.g_old_rec.information23;
657: End If;
658: If (p_rec.information24 = hr_api.g_varchar2) then
659: p_rec.information24 :=
660: per_eqt_shd.g_old_rec.information24;
661: End If;
662: If (p_rec.information25 = hr_api.g_varchar2) then

Line 662: If (p_rec.information25 = hr_api.g_varchar2) then

658: If (p_rec.information24 = hr_api.g_varchar2) then
659: p_rec.information24 :=
660: per_eqt_shd.g_old_rec.information24;
661: End If;
662: If (p_rec.information25 = hr_api.g_varchar2) then
663: p_rec.information25 :=
664: per_eqt_shd.g_old_rec.information25;
665: End If;
666: If (p_rec.information26 = hr_api.g_varchar2) then

Line 666: If (p_rec.information26 = hr_api.g_varchar2) then

662: If (p_rec.information25 = hr_api.g_varchar2) then
663: p_rec.information25 :=
664: per_eqt_shd.g_old_rec.information25;
665: End If;
666: If (p_rec.information26 = hr_api.g_varchar2) then
667: p_rec.information26 :=
668: per_eqt_shd.g_old_rec.information26;
669: End If;
670: If (p_rec.information27 = hr_api.g_varchar2) then

Line 670: If (p_rec.information27 = hr_api.g_varchar2) then

666: If (p_rec.information26 = hr_api.g_varchar2) then
667: p_rec.information26 :=
668: per_eqt_shd.g_old_rec.information26;
669: End If;
670: If (p_rec.information27 = hr_api.g_varchar2) then
671: p_rec.information27 :=
672: per_eqt_shd.g_old_rec.information27;
673: End If;
674: If (p_rec.information28 = hr_api.g_varchar2) then

Line 674: If (p_rec.information28 = hr_api.g_varchar2) then

670: If (p_rec.information27 = hr_api.g_varchar2) then
671: p_rec.information27 :=
672: per_eqt_shd.g_old_rec.information27;
673: End If;
674: If (p_rec.information28 = hr_api.g_varchar2) then
675: p_rec.information28 :=
676: per_eqt_shd.g_old_rec.information28;
677: End If;
678: If (p_rec.information29 = hr_api.g_varchar2) then

Line 678: If (p_rec.information29 = hr_api.g_varchar2) then

674: If (p_rec.information28 = hr_api.g_varchar2) then
675: p_rec.information28 :=
676: per_eqt_shd.g_old_rec.information28;
677: End If;
678: If (p_rec.information29 = hr_api.g_varchar2) then
679: p_rec.information29 :=
680: per_eqt_shd.g_old_rec.information29;
681: End If;
682: If (p_rec.information30 = hr_api.g_varchar2) then

Line 682: If (p_rec.information30 = hr_api.g_varchar2) then

678: If (p_rec.information29 = hr_api.g_varchar2) then
679: p_rec.information29 :=
680: per_eqt_shd.g_old_rec.information29;
681: End If;
682: If (p_rec.information30 = hr_api.g_varchar2) then
683: p_rec.information30 :=
684: per_eqt_shd.g_old_rec.information30;
685: End If;
686: --

Line 689: If (p_rec.qual_framework_id = hr_api.g_number) then

685: End If;
686: --
687: -- BUG3356369
688: --
689: If (p_rec.qual_framework_id = hr_api.g_number) then
690: p_rec.qual_framework_id :=
691: per_eqt_shd.g_old_rec.qual_framework_id;
692: End If;
693: If (p_rec.qualification_type = hr_api.g_varchar2) then

Line 693: If (p_rec.qualification_type = hr_api.g_varchar2) then

689: If (p_rec.qual_framework_id = hr_api.g_number) then
690: p_rec.qual_framework_id :=
691: per_eqt_shd.g_old_rec.qual_framework_id;
692: End If;
693: If (p_rec.qualification_type = hr_api.g_varchar2) then
694: p_rec.qualification_type :=
695: per_eqt_shd.g_old_rec.qualification_type;
696: End If;
697: If (p_rec.credit_type = hr_api.g_varchar2) then

Line 697: If (p_rec.credit_type = hr_api.g_varchar2) then

693: If (p_rec.qualification_type = hr_api.g_varchar2) then
694: p_rec.qualification_type :=
695: per_eqt_shd.g_old_rec.qualification_type;
696: End If;
697: If (p_rec.credit_type = hr_api.g_varchar2) then
698: p_rec.credit_type :=
699: per_eqt_shd.g_old_rec.credit_type;
700: End If;
701: If (p_rec.credits = hr_api.g_number) then

Line 701: If (p_rec.credits = hr_api.g_number) then

697: If (p_rec.credit_type = hr_api.g_varchar2) then
698: p_rec.credit_type :=
699: per_eqt_shd.g_old_rec.credit_type;
700: End If;
701: If (p_rec.credits = hr_api.g_number) then
702: p_rec.credits :=
703: per_eqt_shd.g_old_rec.credits;
704: End If;
705: If (p_rec.level_type = hr_api.g_varchar2) then

Line 705: If (p_rec.level_type = hr_api.g_varchar2) then

701: If (p_rec.credits = hr_api.g_number) then
702: p_rec.credits :=
703: per_eqt_shd.g_old_rec.credits;
704: End If;
705: If (p_rec.level_type = hr_api.g_varchar2) then
706: p_rec.level_type :=
707: per_eqt_shd.g_old_rec.level_type;
708: End If;
709: If (p_rec.level_number = hr_api.g_number) then

Line 709: If (p_rec.level_number = hr_api.g_number) then

705: If (p_rec.level_type = hr_api.g_varchar2) then
706: p_rec.level_type :=
707: per_eqt_shd.g_old_rec.level_type;
708: End If;
709: If (p_rec.level_number = hr_api.g_number) then
710: p_rec.level_number :=
711: per_eqt_shd.g_old_rec.level_number;
712: End If;
713: If (p_rec.field = hr_api.g_varchar2) then

Line 713: If (p_rec.field = hr_api.g_varchar2) then

709: If (p_rec.level_number = hr_api.g_number) then
710: p_rec.level_number :=
711: per_eqt_shd.g_old_rec.level_number;
712: End If;
713: If (p_rec.field = hr_api.g_varchar2) then
714: p_rec.field :=
715: per_eqt_shd.g_old_rec.field ;
716: End If;
717: If (p_rec.sub_field = hr_api.g_varchar2) then

Line 717: If (p_rec.sub_field = hr_api.g_varchar2) then

713: If (p_rec.field = hr_api.g_varchar2) then
714: p_rec.field :=
715: per_eqt_shd.g_old_rec.field ;
716: End If;
717: If (p_rec.sub_field = hr_api.g_varchar2) then
718: p_rec.sub_field :=
719: per_eqt_shd.g_old_rec.sub_field;
720: End If;
721: If (p_rec.provider = hr_api.g_varchar2) then

Line 721: If (p_rec.provider = hr_api.g_varchar2) then

717: If (p_rec.sub_field = hr_api.g_varchar2) then
718: p_rec.sub_field :=
719: per_eqt_shd.g_old_rec.sub_field;
720: End If;
721: If (p_rec.provider = hr_api.g_varchar2) then
722: p_rec.provider :=
723: per_eqt_shd.g_old_rec.provider;
724: End If;
725: If (p_rec.qa_organization = hr_api.g_varchar2) then

Line 725: If (p_rec.qa_organization = hr_api.g_varchar2) then

721: If (p_rec.provider = hr_api.g_varchar2) then
722: p_rec.provider :=
723: per_eqt_shd.g_old_rec.provider;
724: End If;
725: If (p_rec.qa_organization = hr_api.g_varchar2) then
726: p_rec.qa_organization :=
727: per_eqt_shd.g_old_rec.qa_organization;
728: End If;
729:

Line 793: Raise HR_Api.Validate_Enabled;

789: --
790: -- If we are validating then raise the Validate_Enabled exception
791: --
792: If p_validate then
793: Raise HR_Api.Validate_Enabled;
794: End If;
795: --
796: hr_utility.set_location(' Leaving:'||l_proc, 10);
797: Exception

Line 798: When HR_Api.Validate_Enabled Then

794: End If;
795: --
796: hr_utility.set_location(' Leaving:'||l_proc, 10);
797: Exception
798: When HR_Api.Validate_Enabled Then
799: --
800: -- As the Validate_Enabled exception has been raised
801: -- we must rollback to the savepoint
802: --

Line 816: p_name in varchar2 default hr_api.g_varchar2,

812:
813: Procedure upd
814: (
815: p_qualification_type_id in number,
816: p_name in varchar2 default hr_api.g_varchar2,
817: p_category in varchar2 default hr_api.g_varchar2,
818: p_rank in number default hr_api.g_number,
819: p_attribute_category in varchar2 default hr_api.g_varchar2,
820: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 817: p_category in varchar2 default hr_api.g_varchar2,

813: Procedure upd
814: (
815: p_qualification_type_id in number,
816: p_name in varchar2 default hr_api.g_varchar2,
817: p_category in varchar2 default hr_api.g_varchar2,
818: p_rank in number default hr_api.g_number,
819: p_attribute_category in varchar2 default hr_api.g_varchar2,
820: p_attribute1 in varchar2 default hr_api.g_varchar2,
821: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 818: p_rank in number default hr_api.g_number,

814: (
815: p_qualification_type_id in number,
816: p_name in varchar2 default hr_api.g_varchar2,
817: p_category in varchar2 default hr_api.g_varchar2,
818: p_rank in number default hr_api.g_number,
819: p_attribute_category in varchar2 default hr_api.g_varchar2,
820: p_attribute1 in varchar2 default hr_api.g_varchar2,
821: p_attribute2 in varchar2 default hr_api.g_varchar2,
822: p_attribute3 in varchar2 default hr_api.g_varchar2,

Line 819: p_attribute_category in varchar2 default hr_api.g_varchar2,

815: p_qualification_type_id in number,
816: p_name in varchar2 default hr_api.g_varchar2,
817: p_category in varchar2 default hr_api.g_varchar2,
818: p_rank in number default hr_api.g_number,
819: p_attribute_category in varchar2 default hr_api.g_varchar2,
820: p_attribute1 in varchar2 default hr_api.g_varchar2,
821: p_attribute2 in varchar2 default hr_api.g_varchar2,
822: p_attribute3 in varchar2 default hr_api.g_varchar2,
823: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 820: p_attribute1 in varchar2 default hr_api.g_varchar2,

816: p_name in varchar2 default hr_api.g_varchar2,
817: p_category in varchar2 default hr_api.g_varchar2,
818: p_rank in number default hr_api.g_number,
819: p_attribute_category in varchar2 default hr_api.g_varchar2,
820: p_attribute1 in varchar2 default hr_api.g_varchar2,
821: p_attribute2 in varchar2 default hr_api.g_varchar2,
822: p_attribute3 in varchar2 default hr_api.g_varchar2,
823: p_attribute4 in varchar2 default hr_api.g_varchar2,
824: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 821: p_attribute2 in varchar2 default hr_api.g_varchar2,

817: p_category in varchar2 default hr_api.g_varchar2,
818: p_rank in number default hr_api.g_number,
819: p_attribute_category in varchar2 default hr_api.g_varchar2,
820: p_attribute1 in varchar2 default hr_api.g_varchar2,
821: p_attribute2 in varchar2 default hr_api.g_varchar2,
822: p_attribute3 in varchar2 default hr_api.g_varchar2,
823: p_attribute4 in varchar2 default hr_api.g_varchar2,
824: p_attribute5 in varchar2 default hr_api.g_varchar2,
825: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 822: p_attribute3 in varchar2 default hr_api.g_varchar2,

818: p_rank in number default hr_api.g_number,
819: p_attribute_category in varchar2 default hr_api.g_varchar2,
820: p_attribute1 in varchar2 default hr_api.g_varchar2,
821: p_attribute2 in varchar2 default hr_api.g_varchar2,
822: p_attribute3 in varchar2 default hr_api.g_varchar2,
823: p_attribute4 in varchar2 default hr_api.g_varchar2,
824: p_attribute5 in varchar2 default hr_api.g_varchar2,
825: p_attribute6 in varchar2 default hr_api.g_varchar2,
826: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 823: p_attribute4 in varchar2 default hr_api.g_varchar2,

819: p_attribute_category in varchar2 default hr_api.g_varchar2,
820: p_attribute1 in varchar2 default hr_api.g_varchar2,
821: p_attribute2 in varchar2 default hr_api.g_varchar2,
822: p_attribute3 in varchar2 default hr_api.g_varchar2,
823: p_attribute4 in varchar2 default hr_api.g_varchar2,
824: p_attribute5 in varchar2 default hr_api.g_varchar2,
825: p_attribute6 in varchar2 default hr_api.g_varchar2,
826: p_attribute7 in varchar2 default hr_api.g_varchar2,
827: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 824: p_attribute5 in varchar2 default hr_api.g_varchar2,

820: p_attribute1 in varchar2 default hr_api.g_varchar2,
821: p_attribute2 in varchar2 default hr_api.g_varchar2,
822: p_attribute3 in varchar2 default hr_api.g_varchar2,
823: p_attribute4 in varchar2 default hr_api.g_varchar2,
824: p_attribute5 in varchar2 default hr_api.g_varchar2,
825: p_attribute6 in varchar2 default hr_api.g_varchar2,
826: p_attribute7 in varchar2 default hr_api.g_varchar2,
827: p_attribute8 in varchar2 default hr_api.g_varchar2,
828: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 825: p_attribute6 in varchar2 default hr_api.g_varchar2,

821: p_attribute2 in varchar2 default hr_api.g_varchar2,
822: p_attribute3 in varchar2 default hr_api.g_varchar2,
823: p_attribute4 in varchar2 default hr_api.g_varchar2,
824: p_attribute5 in varchar2 default hr_api.g_varchar2,
825: p_attribute6 in varchar2 default hr_api.g_varchar2,
826: p_attribute7 in varchar2 default hr_api.g_varchar2,
827: p_attribute8 in varchar2 default hr_api.g_varchar2,
828: p_attribute9 in varchar2 default hr_api.g_varchar2,
829: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 826: p_attribute7 in varchar2 default hr_api.g_varchar2,

822: p_attribute3 in varchar2 default hr_api.g_varchar2,
823: p_attribute4 in varchar2 default hr_api.g_varchar2,
824: p_attribute5 in varchar2 default hr_api.g_varchar2,
825: p_attribute6 in varchar2 default hr_api.g_varchar2,
826: p_attribute7 in varchar2 default hr_api.g_varchar2,
827: p_attribute8 in varchar2 default hr_api.g_varchar2,
828: p_attribute9 in varchar2 default hr_api.g_varchar2,
829: p_attribute10 in varchar2 default hr_api.g_varchar2,
830: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 827: p_attribute8 in varchar2 default hr_api.g_varchar2,

823: p_attribute4 in varchar2 default hr_api.g_varchar2,
824: p_attribute5 in varchar2 default hr_api.g_varchar2,
825: p_attribute6 in varchar2 default hr_api.g_varchar2,
826: p_attribute7 in varchar2 default hr_api.g_varchar2,
827: p_attribute8 in varchar2 default hr_api.g_varchar2,
828: p_attribute9 in varchar2 default hr_api.g_varchar2,
829: p_attribute10 in varchar2 default hr_api.g_varchar2,
830: p_attribute11 in varchar2 default hr_api.g_varchar2,
831: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 828: p_attribute9 in varchar2 default hr_api.g_varchar2,

824: p_attribute5 in varchar2 default hr_api.g_varchar2,
825: p_attribute6 in varchar2 default hr_api.g_varchar2,
826: p_attribute7 in varchar2 default hr_api.g_varchar2,
827: p_attribute8 in varchar2 default hr_api.g_varchar2,
828: p_attribute9 in varchar2 default hr_api.g_varchar2,
829: p_attribute10 in varchar2 default hr_api.g_varchar2,
830: p_attribute11 in varchar2 default hr_api.g_varchar2,
831: p_attribute12 in varchar2 default hr_api.g_varchar2,
832: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 829: p_attribute10 in varchar2 default hr_api.g_varchar2,

825: p_attribute6 in varchar2 default hr_api.g_varchar2,
826: p_attribute7 in varchar2 default hr_api.g_varchar2,
827: p_attribute8 in varchar2 default hr_api.g_varchar2,
828: p_attribute9 in varchar2 default hr_api.g_varchar2,
829: p_attribute10 in varchar2 default hr_api.g_varchar2,
830: p_attribute11 in varchar2 default hr_api.g_varchar2,
831: p_attribute12 in varchar2 default hr_api.g_varchar2,
832: p_attribute13 in varchar2 default hr_api.g_varchar2,
833: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 830: p_attribute11 in varchar2 default hr_api.g_varchar2,

826: p_attribute7 in varchar2 default hr_api.g_varchar2,
827: p_attribute8 in varchar2 default hr_api.g_varchar2,
828: p_attribute9 in varchar2 default hr_api.g_varchar2,
829: p_attribute10 in varchar2 default hr_api.g_varchar2,
830: p_attribute11 in varchar2 default hr_api.g_varchar2,
831: p_attribute12 in varchar2 default hr_api.g_varchar2,
832: p_attribute13 in varchar2 default hr_api.g_varchar2,
833: p_attribute14 in varchar2 default hr_api.g_varchar2,
834: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 831: p_attribute12 in varchar2 default hr_api.g_varchar2,

827: p_attribute8 in varchar2 default hr_api.g_varchar2,
828: p_attribute9 in varchar2 default hr_api.g_varchar2,
829: p_attribute10 in varchar2 default hr_api.g_varchar2,
830: p_attribute11 in varchar2 default hr_api.g_varchar2,
831: p_attribute12 in varchar2 default hr_api.g_varchar2,
832: p_attribute13 in varchar2 default hr_api.g_varchar2,
833: p_attribute14 in varchar2 default hr_api.g_varchar2,
834: p_attribute15 in varchar2 default hr_api.g_varchar2,
835: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 832: p_attribute13 in varchar2 default hr_api.g_varchar2,

828: p_attribute9 in varchar2 default hr_api.g_varchar2,
829: p_attribute10 in varchar2 default hr_api.g_varchar2,
830: p_attribute11 in varchar2 default hr_api.g_varchar2,
831: p_attribute12 in varchar2 default hr_api.g_varchar2,
832: p_attribute13 in varchar2 default hr_api.g_varchar2,
833: p_attribute14 in varchar2 default hr_api.g_varchar2,
834: p_attribute15 in varchar2 default hr_api.g_varchar2,
835: p_attribute16 in varchar2 default hr_api.g_varchar2,
836: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 833: p_attribute14 in varchar2 default hr_api.g_varchar2,

829: p_attribute10 in varchar2 default hr_api.g_varchar2,
830: p_attribute11 in varchar2 default hr_api.g_varchar2,
831: p_attribute12 in varchar2 default hr_api.g_varchar2,
832: p_attribute13 in varchar2 default hr_api.g_varchar2,
833: p_attribute14 in varchar2 default hr_api.g_varchar2,
834: p_attribute15 in varchar2 default hr_api.g_varchar2,
835: p_attribute16 in varchar2 default hr_api.g_varchar2,
836: p_attribute17 in varchar2 default hr_api.g_varchar2,
837: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 834: p_attribute15 in varchar2 default hr_api.g_varchar2,

830: p_attribute11 in varchar2 default hr_api.g_varchar2,
831: p_attribute12 in varchar2 default hr_api.g_varchar2,
832: p_attribute13 in varchar2 default hr_api.g_varchar2,
833: p_attribute14 in varchar2 default hr_api.g_varchar2,
834: p_attribute15 in varchar2 default hr_api.g_varchar2,
835: p_attribute16 in varchar2 default hr_api.g_varchar2,
836: p_attribute17 in varchar2 default hr_api.g_varchar2,
837: p_attribute18 in varchar2 default hr_api.g_varchar2,
838: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 835: p_attribute16 in varchar2 default hr_api.g_varchar2,

831: p_attribute12 in varchar2 default hr_api.g_varchar2,
832: p_attribute13 in varchar2 default hr_api.g_varchar2,
833: p_attribute14 in varchar2 default hr_api.g_varchar2,
834: p_attribute15 in varchar2 default hr_api.g_varchar2,
835: p_attribute16 in varchar2 default hr_api.g_varchar2,
836: p_attribute17 in varchar2 default hr_api.g_varchar2,
837: p_attribute18 in varchar2 default hr_api.g_varchar2,
838: p_attribute19 in varchar2 default hr_api.g_varchar2,
839: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 836: p_attribute17 in varchar2 default hr_api.g_varchar2,

832: p_attribute13 in varchar2 default hr_api.g_varchar2,
833: p_attribute14 in varchar2 default hr_api.g_varchar2,
834: p_attribute15 in varchar2 default hr_api.g_varchar2,
835: p_attribute16 in varchar2 default hr_api.g_varchar2,
836: p_attribute17 in varchar2 default hr_api.g_varchar2,
837: p_attribute18 in varchar2 default hr_api.g_varchar2,
838: p_attribute19 in varchar2 default hr_api.g_varchar2,
839: p_attribute20 in varchar2 default hr_api.g_varchar2,
840: p_object_version_number in out nocopy number,

Line 837: p_attribute18 in varchar2 default hr_api.g_varchar2,

833: p_attribute14 in varchar2 default hr_api.g_varchar2,
834: p_attribute15 in varchar2 default hr_api.g_varchar2,
835: p_attribute16 in varchar2 default hr_api.g_varchar2,
836: p_attribute17 in varchar2 default hr_api.g_varchar2,
837: p_attribute18 in varchar2 default hr_api.g_varchar2,
838: p_attribute19 in varchar2 default hr_api.g_varchar2,
839: p_attribute20 in varchar2 default hr_api.g_varchar2,
840: p_object_version_number in out nocopy number,
841: p_effective_date in date,

Line 838: p_attribute19 in varchar2 default hr_api.g_varchar2,

834: p_attribute15 in varchar2 default hr_api.g_varchar2,
835: p_attribute16 in varchar2 default hr_api.g_varchar2,
836: p_attribute17 in varchar2 default hr_api.g_varchar2,
837: p_attribute18 in varchar2 default hr_api.g_varchar2,
838: p_attribute19 in varchar2 default hr_api.g_varchar2,
839: p_attribute20 in varchar2 default hr_api.g_varchar2,
840: p_object_version_number in out nocopy number,
841: p_effective_date in date,
842: p_validate in boolean default false,

Line 839: p_attribute20 in varchar2 default hr_api.g_varchar2,

835: p_attribute16 in varchar2 default hr_api.g_varchar2,
836: p_attribute17 in varchar2 default hr_api.g_varchar2,
837: p_attribute18 in varchar2 default hr_api.g_varchar2,
838: p_attribute19 in varchar2 default hr_api.g_varchar2,
839: p_attribute20 in varchar2 default hr_api.g_varchar2,
840: p_object_version_number in out nocopy number,
841: p_effective_date in date,
842: p_validate in boolean default false,
843: p_information_category in varchar2 default hr_api.g_varchar2,

Line 843: p_information_category in varchar2 default hr_api.g_varchar2,

839: p_attribute20 in varchar2 default hr_api.g_varchar2,
840: p_object_version_number in out nocopy number,
841: p_effective_date in date,
842: p_validate in boolean default false,
843: p_information_category in varchar2 default hr_api.g_varchar2,
844: p_information1 in varchar2 default hr_api.g_varchar2,
845: p_information2 in varchar2 default hr_api.g_varchar2,
846: p_information3 in varchar2 default hr_api.g_varchar2,
847: p_information4 in varchar2 default hr_api.g_varchar2,

Line 844: p_information1 in varchar2 default hr_api.g_varchar2,

840: p_object_version_number in out nocopy number,
841: p_effective_date in date,
842: p_validate in boolean default false,
843: p_information_category in varchar2 default hr_api.g_varchar2,
844: p_information1 in varchar2 default hr_api.g_varchar2,
845: p_information2 in varchar2 default hr_api.g_varchar2,
846: p_information3 in varchar2 default hr_api.g_varchar2,
847: p_information4 in varchar2 default hr_api.g_varchar2,
848: p_information5 in varchar2 default hr_api.g_varchar2,

Line 845: p_information2 in varchar2 default hr_api.g_varchar2,

841: p_effective_date in date,
842: p_validate in boolean default false,
843: p_information_category in varchar2 default hr_api.g_varchar2,
844: p_information1 in varchar2 default hr_api.g_varchar2,
845: p_information2 in varchar2 default hr_api.g_varchar2,
846: p_information3 in varchar2 default hr_api.g_varchar2,
847: p_information4 in varchar2 default hr_api.g_varchar2,
848: p_information5 in varchar2 default hr_api.g_varchar2,
849: p_information6 in varchar2 default hr_api.g_varchar2,

Line 846: p_information3 in varchar2 default hr_api.g_varchar2,

842: p_validate in boolean default false,
843: p_information_category in varchar2 default hr_api.g_varchar2,
844: p_information1 in varchar2 default hr_api.g_varchar2,
845: p_information2 in varchar2 default hr_api.g_varchar2,
846: p_information3 in varchar2 default hr_api.g_varchar2,
847: p_information4 in varchar2 default hr_api.g_varchar2,
848: p_information5 in varchar2 default hr_api.g_varchar2,
849: p_information6 in varchar2 default hr_api.g_varchar2,
850: p_information7 in varchar2 default hr_api.g_varchar2,

Line 847: p_information4 in varchar2 default hr_api.g_varchar2,

843: p_information_category in varchar2 default hr_api.g_varchar2,
844: p_information1 in varchar2 default hr_api.g_varchar2,
845: p_information2 in varchar2 default hr_api.g_varchar2,
846: p_information3 in varchar2 default hr_api.g_varchar2,
847: p_information4 in varchar2 default hr_api.g_varchar2,
848: p_information5 in varchar2 default hr_api.g_varchar2,
849: p_information6 in varchar2 default hr_api.g_varchar2,
850: p_information7 in varchar2 default hr_api.g_varchar2,
851: p_information8 in varchar2 default hr_api.g_varchar2,

Line 848: p_information5 in varchar2 default hr_api.g_varchar2,

844: p_information1 in varchar2 default hr_api.g_varchar2,
845: p_information2 in varchar2 default hr_api.g_varchar2,
846: p_information3 in varchar2 default hr_api.g_varchar2,
847: p_information4 in varchar2 default hr_api.g_varchar2,
848: p_information5 in varchar2 default hr_api.g_varchar2,
849: p_information6 in varchar2 default hr_api.g_varchar2,
850: p_information7 in varchar2 default hr_api.g_varchar2,
851: p_information8 in varchar2 default hr_api.g_varchar2,
852: p_information9 in varchar2 default hr_api.g_varchar2,

Line 849: p_information6 in varchar2 default hr_api.g_varchar2,

845: p_information2 in varchar2 default hr_api.g_varchar2,
846: p_information3 in varchar2 default hr_api.g_varchar2,
847: p_information4 in varchar2 default hr_api.g_varchar2,
848: p_information5 in varchar2 default hr_api.g_varchar2,
849: p_information6 in varchar2 default hr_api.g_varchar2,
850: p_information7 in varchar2 default hr_api.g_varchar2,
851: p_information8 in varchar2 default hr_api.g_varchar2,
852: p_information9 in varchar2 default hr_api.g_varchar2,
853: p_information10 in varchar2 default hr_api.g_varchar2,

Line 850: p_information7 in varchar2 default hr_api.g_varchar2,

846: p_information3 in varchar2 default hr_api.g_varchar2,
847: p_information4 in varchar2 default hr_api.g_varchar2,
848: p_information5 in varchar2 default hr_api.g_varchar2,
849: p_information6 in varchar2 default hr_api.g_varchar2,
850: p_information7 in varchar2 default hr_api.g_varchar2,
851: p_information8 in varchar2 default hr_api.g_varchar2,
852: p_information9 in varchar2 default hr_api.g_varchar2,
853: p_information10 in varchar2 default hr_api.g_varchar2,
854: p_information11 in varchar2 default hr_api.g_varchar2,

Line 851: p_information8 in varchar2 default hr_api.g_varchar2,

847: p_information4 in varchar2 default hr_api.g_varchar2,
848: p_information5 in varchar2 default hr_api.g_varchar2,
849: p_information6 in varchar2 default hr_api.g_varchar2,
850: p_information7 in varchar2 default hr_api.g_varchar2,
851: p_information8 in varchar2 default hr_api.g_varchar2,
852: p_information9 in varchar2 default hr_api.g_varchar2,
853: p_information10 in varchar2 default hr_api.g_varchar2,
854: p_information11 in varchar2 default hr_api.g_varchar2,
855: p_information12 in varchar2 default hr_api.g_varchar2,

Line 852: p_information9 in varchar2 default hr_api.g_varchar2,

848: p_information5 in varchar2 default hr_api.g_varchar2,
849: p_information6 in varchar2 default hr_api.g_varchar2,
850: p_information7 in varchar2 default hr_api.g_varchar2,
851: p_information8 in varchar2 default hr_api.g_varchar2,
852: p_information9 in varchar2 default hr_api.g_varchar2,
853: p_information10 in varchar2 default hr_api.g_varchar2,
854: p_information11 in varchar2 default hr_api.g_varchar2,
855: p_information12 in varchar2 default hr_api.g_varchar2,
856: p_information13 in varchar2 default hr_api.g_varchar2,

Line 853: p_information10 in varchar2 default hr_api.g_varchar2,

849: p_information6 in varchar2 default hr_api.g_varchar2,
850: p_information7 in varchar2 default hr_api.g_varchar2,
851: p_information8 in varchar2 default hr_api.g_varchar2,
852: p_information9 in varchar2 default hr_api.g_varchar2,
853: p_information10 in varchar2 default hr_api.g_varchar2,
854: p_information11 in varchar2 default hr_api.g_varchar2,
855: p_information12 in varchar2 default hr_api.g_varchar2,
856: p_information13 in varchar2 default hr_api.g_varchar2,
857: p_information14 in varchar2 default hr_api.g_varchar2,

Line 854: p_information11 in varchar2 default hr_api.g_varchar2,

850: p_information7 in varchar2 default hr_api.g_varchar2,
851: p_information8 in varchar2 default hr_api.g_varchar2,
852: p_information9 in varchar2 default hr_api.g_varchar2,
853: p_information10 in varchar2 default hr_api.g_varchar2,
854: p_information11 in varchar2 default hr_api.g_varchar2,
855: p_information12 in varchar2 default hr_api.g_varchar2,
856: p_information13 in varchar2 default hr_api.g_varchar2,
857: p_information14 in varchar2 default hr_api.g_varchar2,
858: p_information15 in varchar2 default hr_api.g_varchar2,

Line 855: p_information12 in varchar2 default hr_api.g_varchar2,

851: p_information8 in varchar2 default hr_api.g_varchar2,
852: p_information9 in varchar2 default hr_api.g_varchar2,
853: p_information10 in varchar2 default hr_api.g_varchar2,
854: p_information11 in varchar2 default hr_api.g_varchar2,
855: p_information12 in varchar2 default hr_api.g_varchar2,
856: p_information13 in varchar2 default hr_api.g_varchar2,
857: p_information14 in varchar2 default hr_api.g_varchar2,
858: p_information15 in varchar2 default hr_api.g_varchar2,
859: p_information16 in varchar2 default hr_api.g_varchar2,

Line 856: p_information13 in varchar2 default hr_api.g_varchar2,

852: p_information9 in varchar2 default hr_api.g_varchar2,
853: p_information10 in varchar2 default hr_api.g_varchar2,
854: p_information11 in varchar2 default hr_api.g_varchar2,
855: p_information12 in varchar2 default hr_api.g_varchar2,
856: p_information13 in varchar2 default hr_api.g_varchar2,
857: p_information14 in varchar2 default hr_api.g_varchar2,
858: p_information15 in varchar2 default hr_api.g_varchar2,
859: p_information16 in varchar2 default hr_api.g_varchar2,
860: p_information17 in varchar2 default hr_api.g_varchar2,

Line 857: p_information14 in varchar2 default hr_api.g_varchar2,

853: p_information10 in varchar2 default hr_api.g_varchar2,
854: p_information11 in varchar2 default hr_api.g_varchar2,
855: p_information12 in varchar2 default hr_api.g_varchar2,
856: p_information13 in varchar2 default hr_api.g_varchar2,
857: p_information14 in varchar2 default hr_api.g_varchar2,
858: p_information15 in varchar2 default hr_api.g_varchar2,
859: p_information16 in varchar2 default hr_api.g_varchar2,
860: p_information17 in varchar2 default hr_api.g_varchar2,
861: p_information18 in varchar2 default hr_api.g_varchar2,

Line 858: p_information15 in varchar2 default hr_api.g_varchar2,

854: p_information11 in varchar2 default hr_api.g_varchar2,
855: p_information12 in varchar2 default hr_api.g_varchar2,
856: p_information13 in varchar2 default hr_api.g_varchar2,
857: p_information14 in varchar2 default hr_api.g_varchar2,
858: p_information15 in varchar2 default hr_api.g_varchar2,
859: p_information16 in varchar2 default hr_api.g_varchar2,
860: p_information17 in varchar2 default hr_api.g_varchar2,
861: p_information18 in varchar2 default hr_api.g_varchar2,
862: p_information19 in varchar2 default hr_api.g_varchar2,

Line 859: p_information16 in varchar2 default hr_api.g_varchar2,

855: p_information12 in varchar2 default hr_api.g_varchar2,
856: p_information13 in varchar2 default hr_api.g_varchar2,
857: p_information14 in varchar2 default hr_api.g_varchar2,
858: p_information15 in varchar2 default hr_api.g_varchar2,
859: p_information16 in varchar2 default hr_api.g_varchar2,
860: p_information17 in varchar2 default hr_api.g_varchar2,
861: p_information18 in varchar2 default hr_api.g_varchar2,
862: p_information19 in varchar2 default hr_api.g_varchar2,
863: p_information20 in varchar2 default hr_api.g_varchar2,

Line 860: p_information17 in varchar2 default hr_api.g_varchar2,

856: p_information13 in varchar2 default hr_api.g_varchar2,
857: p_information14 in varchar2 default hr_api.g_varchar2,
858: p_information15 in varchar2 default hr_api.g_varchar2,
859: p_information16 in varchar2 default hr_api.g_varchar2,
860: p_information17 in varchar2 default hr_api.g_varchar2,
861: p_information18 in varchar2 default hr_api.g_varchar2,
862: p_information19 in varchar2 default hr_api.g_varchar2,
863: p_information20 in varchar2 default hr_api.g_varchar2,
864: p_information21 in varchar2 default hr_api.g_varchar2,

Line 861: p_information18 in varchar2 default hr_api.g_varchar2,

857: p_information14 in varchar2 default hr_api.g_varchar2,
858: p_information15 in varchar2 default hr_api.g_varchar2,
859: p_information16 in varchar2 default hr_api.g_varchar2,
860: p_information17 in varchar2 default hr_api.g_varchar2,
861: p_information18 in varchar2 default hr_api.g_varchar2,
862: p_information19 in varchar2 default hr_api.g_varchar2,
863: p_information20 in varchar2 default hr_api.g_varchar2,
864: p_information21 in varchar2 default hr_api.g_varchar2,
865: p_information22 in varchar2 default hr_api.g_varchar2,

Line 862: p_information19 in varchar2 default hr_api.g_varchar2,

858: p_information15 in varchar2 default hr_api.g_varchar2,
859: p_information16 in varchar2 default hr_api.g_varchar2,
860: p_information17 in varchar2 default hr_api.g_varchar2,
861: p_information18 in varchar2 default hr_api.g_varchar2,
862: p_information19 in varchar2 default hr_api.g_varchar2,
863: p_information20 in varchar2 default hr_api.g_varchar2,
864: p_information21 in varchar2 default hr_api.g_varchar2,
865: p_information22 in varchar2 default hr_api.g_varchar2,
866: p_information23 in varchar2 default hr_api.g_varchar2,

Line 863: p_information20 in varchar2 default hr_api.g_varchar2,

859: p_information16 in varchar2 default hr_api.g_varchar2,
860: p_information17 in varchar2 default hr_api.g_varchar2,
861: p_information18 in varchar2 default hr_api.g_varchar2,
862: p_information19 in varchar2 default hr_api.g_varchar2,
863: p_information20 in varchar2 default hr_api.g_varchar2,
864: p_information21 in varchar2 default hr_api.g_varchar2,
865: p_information22 in varchar2 default hr_api.g_varchar2,
866: p_information23 in varchar2 default hr_api.g_varchar2,
867: p_information24 in varchar2 default hr_api.g_varchar2,

Line 864: p_information21 in varchar2 default hr_api.g_varchar2,

860: p_information17 in varchar2 default hr_api.g_varchar2,
861: p_information18 in varchar2 default hr_api.g_varchar2,
862: p_information19 in varchar2 default hr_api.g_varchar2,
863: p_information20 in varchar2 default hr_api.g_varchar2,
864: p_information21 in varchar2 default hr_api.g_varchar2,
865: p_information22 in varchar2 default hr_api.g_varchar2,
866: p_information23 in varchar2 default hr_api.g_varchar2,
867: p_information24 in varchar2 default hr_api.g_varchar2,
868: p_information25 in varchar2 default hr_api.g_varchar2,

Line 865: p_information22 in varchar2 default hr_api.g_varchar2,

861: p_information18 in varchar2 default hr_api.g_varchar2,
862: p_information19 in varchar2 default hr_api.g_varchar2,
863: p_information20 in varchar2 default hr_api.g_varchar2,
864: p_information21 in varchar2 default hr_api.g_varchar2,
865: p_information22 in varchar2 default hr_api.g_varchar2,
866: p_information23 in varchar2 default hr_api.g_varchar2,
867: p_information24 in varchar2 default hr_api.g_varchar2,
868: p_information25 in varchar2 default hr_api.g_varchar2,
869: p_information26 in varchar2 default hr_api.g_varchar2,

Line 866: p_information23 in varchar2 default hr_api.g_varchar2,

862: p_information19 in varchar2 default hr_api.g_varchar2,
863: p_information20 in varchar2 default hr_api.g_varchar2,
864: p_information21 in varchar2 default hr_api.g_varchar2,
865: p_information22 in varchar2 default hr_api.g_varchar2,
866: p_information23 in varchar2 default hr_api.g_varchar2,
867: p_information24 in varchar2 default hr_api.g_varchar2,
868: p_information25 in varchar2 default hr_api.g_varchar2,
869: p_information26 in varchar2 default hr_api.g_varchar2,
870: p_information27 in varchar2 default hr_api.g_varchar2,

Line 867: p_information24 in varchar2 default hr_api.g_varchar2,

863: p_information20 in varchar2 default hr_api.g_varchar2,
864: p_information21 in varchar2 default hr_api.g_varchar2,
865: p_information22 in varchar2 default hr_api.g_varchar2,
866: p_information23 in varchar2 default hr_api.g_varchar2,
867: p_information24 in varchar2 default hr_api.g_varchar2,
868: p_information25 in varchar2 default hr_api.g_varchar2,
869: p_information26 in varchar2 default hr_api.g_varchar2,
870: p_information27 in varchar2 default hr_api.g_varchar2,
871: p_information28 in varchar2 default hr_api.g_varchar2,

Line 868: p_information25 in varchar2 default hr_api.g_varchar2,

864: p_information21 in varchar2 default hr_api.g_varchar2,
865: p_information22 in varchar2 default hr_api.g_varchar2,
866: p_information23 in varchar2 default hr_api.g_varchar2,
867: p_information24 in varchar2 default hr_api.g_varchar2,
868: p_information25 in varchar2 default hr_api.g_varchar2,
869: p_information26 in varchar2 default hr_api.g_varchar2,
870: p_information27 in varchar2 default hr_api.g_varchar2,
871: p_information28 in varchar2 default hr_api.g_varchar2,
872: p_information29 in varchar2 default hr_api.g_varchar2,

Line 869: p_information26 in varchar2 default hr_api.g_varchar2,

865: p_information22 in varchar2 default hr_api.g_varchar2,
866: p_information23 in varchar2 default hr_api.g_varchar2,
867: p_information24 in varchar2 default hr_api.g_varchar2,
868: p_information25 in varchar2 default hr_api.g_varchar2,
869: p_information26 in varchar2 default hr_api.g_varchar2,
870: p_information27 in varchar2 default hr_api.g_varchar2,
871: p_information28 in varchar2 default hr_api.g_varchar2,
872: p_information29 in varchar2 default hr_api.g_varchar2,
873: p_information30 in varchar2 default hr_api.g_varchar2

Line 870: p_information27 in varchar2 default hr_api.g_varchar2,

866: p_information23 in varchar2 default hr_api.g_varchar2,
867: p_information24 in varchar2 default hr_api.g_varchar2,
868: p_information25 in varchar2 default hr_api.g_varchar2,
869: p_information26 in varchar2 default hr_api.g_varchar2,
870: p_information27 in varchar2 default hr_api.g_varchar2,
871: p_information28 in varchar2 default hr_api.g_varchar2,
872: p_information29 in varchar2 default hr_api.g_varchar2,
873: p_information30 in varchar2 default hr_api.g_varchar2
874: -- BUG3356369

Line 871: p_information28 in varchar2 default hr_api.g_varchar2,

867: p_information24 in varchar2 default hr_api.g_varchar2,
868: p_information25 in varchar2 default hr_api.g_varchar2,
869: p_information26 in varchar2 default hr_api.g_varchar2,
870: p_information27 in varchar2 default hr_api.g_varchar2,
871: p_information28 in varchar2 default hr_api.g_varchar2,
872: p_information29 in varchar2 default hr_api.g_varchar2,
873: p_information30 in varchar2 default hr_api.g_varchar2
874: -- BUG3356369
875: ,p_qual_framework_id in number default hr_api.g_number

Line 872: p_information29 in varchar2 default hr_api.g_varchar2,

868: p_information25 in varchar2 default hr_api.g_varchar2,
869: p_information26 in varchar2 default hr_api.g_varchar2,
870: p_information27 in varchar2 default hr_api.g_varchar2,
871: p_information28 in varchar2 default hr_api.g_varchar2,
872: p_information29 in varchar2 default hr_api.g_varchar2,
873: p_information30 in varchar2 default hr_api.g_varchar2
874: -- BUG3356369
875: ,p_qual_framework_id in number default hr_api.g_number
876: ,p_qualification_type in varchar2 default hr_api.g_varchar2

Line 873: p_information30 in varchar2 default hr_api.g_varchar2

869: p_information26 in varchar2 default hr_api.g_varchar2,
870: p_information27 in varchar2 default hr_api.g_varchar2,
871: p_information28 in varchar2 default hr_api.g_varchar2,
872: p_information29 in varchar2 default hr_api.g_varchar2,
873: p_information30 in varchar2 default hr_api.g_varchar2
874: -- BUG3356369
875: ,p_qual_framework_id in number default hr_api.g_number
876: ,p_qualification_type in varchar2 default hr_api.g_varchar2
877: ,p_credit_type in varchar2 default hr_api.g_varchar2

Line 875: ,p_qual_framework_id in number default hr_api.g_number

871: p_information28 in varchar2 default hr_api.g_varchar2,
872: p_information29 in varchar2 default hr_api.g_varchar2,
873: p_information30 in varchar2 default hr_api.g_varchar2
874: -- BUG3356369
875: ,p_qual_framework_id in number default hr_api.g_number
876: ,p_qualification_type in varchar2 default hr_api.g_varchar2
877: ,p_credit_type in varchar2 default hr_api.g_varchar2
878: ,p_credits in number default hr_api.g_number
879: ,p_level_type in varchar2 default hr_api.g_varchar2

Line 876: ,p_qualification_type in varchar2 default hr_api.g_varchar2

872: p_information29 in varchar2 default hr_api.g_varchar2,
873: p_information30 in varchar2 default hr_api.g_varchar2
874: -- BUG3356369
875: ,p_qual_framework_id in number default hr_api.g_number
876: ,p_qualification_type in varchar2 default hr_api.g_varchar2
877: ,p_credit_type in varchar2 default hr_api.g_varchar2
878: ,p_credits in number default hr_api.g_number
879: ,p_level_type in varchar2 default hr_api.g_varchar2
880: ,p_level_number in number default hr_api.g_number

Line 877: ,p_credit_type in varchar2 default hr_api.g_varchar2

873: p_information30 in varchar2 default hr_api.g_varchar2
874: -- BUG3356369
875: ,p_qual_framework_id in number default hr_api.g_number
876: ,p_qualification_type in varchar2 default hr_api.g_varchar2
877: ,p_credit_type in varchar2 default hr_api.g_varchar2
878: ,p_credits in number default hr_api.g_number
879: ,p_level_type in varchar2 default hr_api.g_varchar2
880: ,p_level_number in number default hr_api.g_number
881: ,p_field in varchar2 default hr_api.g_varchar2

Line 878: ,p_credits in number default hr_api.g_number

874: -- BUG3356369
875: ,p_qual_framework_id in number default hr_api.g_number
876: ,p_qualification_type in varchar2 default hr_api.g_varchar2
877: ,p_credit_type in varchar2 default hr_api.g_varchar2
878: ,p_credits in number default hr_api.g_number
879: ,p_level_type in varchar2 default hr_api.g_varchar2
880: ,p_level_number in number default hr_api.g_number
881: ,p_field in varchar2 default hr_api.g_varchar2
882: ,p_sub_field in varchar2 default hr_api.g_varchar2

Line 879: ,p_level_type in varchar2 default hr_api.g_varchar2

875: ,p_qual_framework_id in number default hr_api.g_number
876: ,p_qualification_type in varchar2 default hr_api.g_varchar2
877: ,p_credit_type in varchar2 default hr_api.g_varchar2
878: ,p_credits in number default hr_api.g_number
879: ,p_level_type in varchar2 default hr_api.g_varchar2
880: ,p_level_number in number default hr_api.g_number
881: ,p_field in varchar2 default hr_api.g_varchar2
882: ,p_sub_field in varchar2 default hr_api.g_varchar2
883: ,p_provider in varchar2 default hr_api.g_varchar2

Line 880: ,p_level_number in number default hr_api.g_number

876: ,p_qualification_type in varchar2 default hr_api.g_varchar2
877: ,p_credit_type in varchar2 default hr_api.g_varchar2
878: ,p_credits in number default hr_api.g_number
879: ,p_level_type in varchar2 default hr_api.g_varchar2
880: ,p_level_number in number default hr_api.g_number
881: ,p_field in varchar2 default hr_api.g_varchar2
882: ,p_sub_field in varchar2 default hr_api.g_varchar2
883: ,p_provider in varchar2 default hr_api.g_varchar2
884: ,p_qa_organization in varchar2 default hr_api.g_varchar2

Line 881: ,p_field in varchar2 default hr_api.g_varchar2

877: ,p_credit_type in varchar2 default hr_api.g_varchar2
878: ,p_credits in number default hr_api.g_number
879: ,p_level_type in varchar2 default hr_api.g_varchar2
880: ,p_level_number in number default hr_api.g_number
881: ,p_field in varchar2 default hr_api.g_varchar2
882: ,p_sub_field in varchar2 default hr_api.g_varchar2
883: ,p_provider in varchar2 default hr_api.g_varchar2
884: ,p_qa_organization in varchar2 default hr_api.g_varchar2
885: ) is

Line 882: ,p_sub_field in varchar2 default hr_api.g_varchar2

878: ,p_credits in number default hr_api.g_number
879: ,p_level_type in varchar2 default hr_api.g_varchar2
880: ,p_level_number in number default hr_api.g_number
881: ,p_field in varchar2 default hr_api.g_varchar2
882: ,p_sub_field in varchar2 default hr_api.g_varchar2
883: ,p_provider in varchar2 default hr_api.g_varchar2
884: ,p_qa_organization in varchar2 default hr_api.g_varchar2
885: ) is
886: --

Line 883: ,p_provider in varchar2 default hr_api.g_varchar2

879: ,p_level_type in varchar2 default hr_api.g_varchar2
880: ,p_level_number in number default hr_api.g_number
881: ,p_field in varchar2 default hr_api.g_varchar2
882: ,p_sub_field in varchar2 default hr_api.g_varchar2
883: ,p_provider in varchar2 default hr_api.g_varchar2
884: ,p_qa_organization in varchar2 default hr_api.g_varchar2
885: ) is
886: --
887: l_rec per_eqt_shd.g_rec_type;

Line 884: ,p_qa_organization in varchar2 default hr_api.g_varchar2

880: ,p_level_number in number default hr_api.g_number
881: ,p_field in varchar2 default hr_api.g_varchar2
882: ,p_sub_field in varchar2 default hr_api.g_varchar2
883: ,p_provider in varchar2 default hr_api.g_varchar2
884: ,p_qa_organization in varchar2 default hr_api.g_varchar2
885: ) is
886: --
887: l_rec per_eqt_shd.g_rec_type;
888: l_proc varchar2(72) := g_package||'upd';