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.HR_ORI_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: hr_ori_shd.g_api_dml := false; -- Unset the api dml status
127: hr_ori_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: hr_ori_shd.g_api_dml := false; -- Unset the api dml status
127: hr_ori_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: hr_ori_shd.g_api_dml := false; -- Unset the api dml status
132: hr_ori_shd.constraint_error

Line 129: When hr_api.parent_integrity_violated Then

125: -- A check constraint has been violated
126: hr_ori_shd.g_api_dml := false; -- Unset the api dml status
127: hr_ori_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: hr_ori_shd.g_api_dml := false; -- Unset the api dml status
132: hr_ori_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: hr_ori_shd.g_api_dml := false; -- Unset the api dml status
132: hr_ori_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: hr_ori_shd.g_api_dml := false; -- Unset the api dml status
137: hr_ori_shd.constraint_error

Line 134: When hr_api.unique_integrity_violated Then

130: -- Parent integrity has been violated
131: hr_ori_shd.g_api_dml := false; -- Unset the api dml status
132: hr_ori_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: hr_ori_shd.g_api_dml := false; -- Unset the api dml status
137: hr_ori_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: hr_ori_shd.g_api_dml := false; -- Unset the api dml status
137: hr_ori_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When Others Then
140: hr_ori_shd.g_api_dml := false; -- Unset the api dml status
141: Raise;
142: End update_dml;

Line 423: when hr_api.cannot_find_prog_unit then

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

Line 425: hr_api.cannot_find_prog_unit_error

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

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

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

Line 492: If (p_rec.organization_id = hr_api.g_number) then

488: If (p_rec.org_information_context = hr_api.g_varchar2) then
489: p_rec.org_information_context :=
490: hr_ori_shd.g_old_rec.org_information_context;
491: End If;
492: If (p_rec.organization_id = hr_api.g_number) then
493: p_rec.organization_id :=
494: hr_ori_shd.g_old_rec.organization_id;
495: End If;
496: If (p_rec.org_information1 = hr_api.g_varchar2) then

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

492: If (p_rec.organization_id = hr_api.g_number) then
493: p_rec.organization_id :=
494: hr_ori_shd.g_old_rec.organization_id;
495: End If;
496: If (p_rec.org_information1 = hr_api.g_varchar2) then
497: p_rec.org_information1 :=
498: hr_ori_shd.g_old_rec.org_information1;
499: End If;
500: If (p_rec.org_information10 = hr_api.g_varchar2) then

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

496: If (p_rec.org_information1 = hr_api.g_varchar2) then
497: p_rec.org_information1 :=
498: hr_ori_shd.g_old_rec.org_information1;
499: End If;
500: If (p_rec.org_information10 = hr_api.g_varchar2) then
501: p_rec.org_information10 :=
502: hr_ori_shd.g_old_rec.org_information10;
503: End If;
504: If (p_rec.org_information11 = hr_api.g_varchar2) then

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

500: If (p_rec.org_information10 = hr_api.g_varchar2) then
501: p_rec.org_information10 :=
502: hr_ori_shd.g_old_rec.org_information10;
503: End If;
504: If (p_rec.org_information11 = hr_api.g_varchar2) then
505: p_rec.org_information11 :=
506: hr_ori_shd.g_old_rec.org_information11;
507: End If;
508: If (p_rec.org_information12 = hr_api.g_varchar2) then

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

504: If (p_rec.org_information11 = hr_api.g_varchar2) then
505: p_rec.org_information11 :=
506: hr_ori_shd.g_old_rec.org_information11;
507: End If;
508: If (p_rec.org_information12 = hr_api.g_varchar2) then
509: p_rec.org_information12 :=
510: hr_ori_shd.g_old_rec.org_information12;
511: End If;
512: If (p_rec.org_information13 = hr_api.g_varchar2) then

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

508: If (p_rec.org_information12 = hr_api.g_varchar2) then
509: p_rec.org_information12 :=
510: hr_ori_shd.g_old_rec.org_information12;
511: End If;
512: If (p_rec.org_information13 = hr_api.g_varchar2) then
513: p_rec.org_information13 :=
514: hr_ori_shd.g_old_rec.org_information13;
515: End If;
516: If (p_rec.org_information14 = hr_api.g_varchar2) then

Line 516: If (p_rec.org_information14 = hr_api.g_varchar2) then

512: If (p_rec.org_information13 = hr_api.g_varchar2) then
513: p_rec.org_information13 :=
514: hr_ori_shd.g_old_rec.org_information13;
515: End If;
516: If (p_rec.org_information14 = hr_api.g_varchar2) then
517: p_rec.org_information14 :=
518: hr_ori_shd.g_old_rec.org_information14;
519: End If;
520: If (p_rec.org_information15 = hr_api.g_varchar2) then

Line 520: If (p_rec.org_information15 = hr_api.g_varchar2) then

516: If (p_rec.org_information14 = hr_api.g_varchar2) then
517: p_rec.org_information14 :=
518: hr_ori_shd.g_old_rec.org_information14;
519: End If;
520: If (p_rec.org_information15 = hr_api.g_varchar2) then
521: p_rec.org_information15 :=
522: hr_ori_shd.g_old_rec.org_information15;
523: End If;
524: If (p_rec.org_information16 = hr_api.g_varchar2) then

Line 524: If (p_rec.org_information16 = hr_api.g_varchar2) then

520: If (p_rec.org_information15 = hr_api.g_varchar2) then
521: p_rec.org_information15 :=
522: hr_ori_shd.g_old_rec.org_information15;
523: End If;
524: If (p_rec.org_information16 = hr_api.g_varchar2) then
525: p_rec.org_information16 :=
526: hr_ori_shd.g_old_rec.org_information16;
527: End If;
528: If (p_rec.org_information17 = hr_api.g_varchar2) then

Line 528: If (p_rec.org_information17 = hr_api.g_varchar2) then

524: If (p_rec.org_information16 = hr_api.g_varchar2) then
525: p_rec.org_information16 :=
526: hr_ori_shd.g_old_rec.org_information16;
527: End If;
528: If (p_rec.org_information17 = hr_api.g_varchar2) then
529: p_rec.org_information17 :=
530: hr_ori_shd.g_old_rec.org_information17;
531: End If;
532: If (p_rec.org_information18 = hr_api.g_varchar2) then

Line 532: If (p_rec.org_information18 = hr_api.g_varchar2) then

528: If (p_rec.org_information17 = hr_api.g_varchar2) then
529: p_rec.org_information17 :=
530: hr_ori_shd.g_old_rec.org_information17;
531: End If;
532: If (p_rec.org_information18 = hr_api.g_varchar2) then
533: p_rec.org_information18 :=
534: hr_ori_shd.g_old_rec.org_information18;
535: End If;
536: If (p_rec.org_information19 = hr_api.g_varchar2) then

Line 536: If (p_rec.org_information19 = hr_api.g_varchar2) then

532: If (p_rec.org_information18 = hr_api.g_varchar2) then
533: p_rec.org_information18 :=
534: hr_ori_shd.g_old_rec.org_information18;
535: End If;
536: If (p_rec.org_information19 = hr_api.g_varchar2) then
537: p_rec.org_information19 :=
538: hr_ori_shd.g_old_rec.org_information19;
539: End If;
540: If (p_rec.org_information2 = hr_api.g_varchar2) then

Line 540: If (p_rec.org_information2 = hr_api.g_varchar2) then

536: If (p_rec.org_information19 = hr_api.g_varchar2) then
537: p_rec.org_information19 :=
538: hr_ori_shd.g_old_rec.org_information19;
539: End If;
540: If (p_rec.org_information2 = hr_api.g_varchar2) then
541: p_rec.org_information2 :=
542: hr_ori_shd.g_old_rec.org_information2;
543: End If;
544: If (p_rec.org_information20 = hr_api.g_varchar2) then

Line 544: If (p_rec.org_information20 = hr_api.g_varchar2) then

540: If (p_rec.org_information2 = hr_api.g_varchar2) then
541: p_rec.org_information2 :=
542: hr_ori_shd.g_old_rec.org_information2;
543: End If;
544: If (p_rec.org_information20 = hr_api.g_varchar2) then
545: p_rec.org_information20 :=
546: hr_ori_shd.g_old_rec.org_information20;
547: End If;
548: If (p_rec.org_information3 = hr_api.g_varchar2) then

Line 548: If (p_rec.org_information3 = hr_api.g_varchar2) then

544: If (p_rec.org_information20 = hr_api.g_varchar2) then
545: p_rec.org_information20 :=
546: hr_ori_shd.g_old_rec.org_information20;
547: End If;
548: If (p_rec.org_information3 = hr_api.g_varchar2) then
549: p_rec.org_information3 :=
550: hr_ori_shd.g_old_rec.org_information3;
551: End If;
552: If (p_rec.org_information4 = hr_api.g_varchar2) then

Line 552: If (p_rec.org_information4 = hr_api.g_varchar2) then

548: If (p_rec.org_information3 = hr_api.g_varchar2) then
549: p_rec.org_information3 :=
550: hr_ori_shd.g_old_rec.org_information3;
551: End If;
552: If (p_rec.org_information4 = hr_api.g_varchar2) then
553: p_rec.org_information4 :=
554: hr_ori_shd.g_old_rec.org_information4;
555: End If;
556: If (p_rec.org_information5 = hr_api.g_varchar2) then

Line 556: If (p_rec.org_information5 = hr_api.g_varchar2) then

552: If (p_rec.org_information4 = hr_api.g_varchar2) then
553: p_rec.org_information4 :=
554: hr_ori_shd.g_old_rec.org_information4;
555: End If;
556: If (p_rec.org_information5 = hr_api.g_varchar2) then
557: p_rec.org_information5 :=
558: hr_ori_shd.g_old_rec.org_information5;
559: End If;
560: If (p_rec.org_information6 = hr_api.g_varchar2) then

Line 560: If (p_rec.org_information6 = hr_api.g_varchar2) then

556: If (p_rec.org_information5 = hr_api.g_varchar2) then
557: p_rec.org_information5 :=
558: hr_ori_shd.g_old_rec.org_information5;
559: End If;
560: If (p_rec.org_information6 = hr_api.g_varchar2) then
561: p_rec.org_information6 :=
562: hr_ori_shd.g_old_rec.org_information6;
563: End If;
564: If (p_rec.org_information7 = hr_api.g_varchar2) then

Line 564: If (p_rec.org_information7 = hr_api.g_varchar2) then

560: If (p_rec.org_information6 = hr_api.g_varchar2) then
561: p_rec.org_information6 :=
562: hr_ori_shd.g_old_rec.org_information6;
563: End If;
564: If (p_rec.org_information7 = hr_api.g_varchar2) then
565: p_rec.org_information7 :=
566: hr_ori_shd.g_old_rec.org_information7;
567: End If;
568: If (p_rec.org_information8 = hr_api.g_varchar2) then

Line 568: If (p_rec.org_information8 = hr_api.g_varchar2) then

564: If (p_rec.org_information7 = hr_api.g_varchar2) then
565: p_rec.org_information7 :=
566: hr_ori_shd.g_old_rec.org_information7;
567: End If;
568: If (p_rec.org_information8 = hr_api.g_varchar2) then
569: p_rec.org_information8 :=
570: hr_ori_shd.g_old_rec.org_information8;
571: End If;
572: If (p_rec.org_information9 = hr_api.g_varchar2) then

Line 572: If (p_rec.org_information9 = hr_api.g_varchar2) then

568: If (p_rec.org_information8 = hr_api.g_varchar2) then
569: p_rec.org_information8 :=
570: hr_ori_shd.g_old_rec.org_information8;
571: End If;
572: If (p_rec.org_information9 = hr_api.g_varchar2) then
573: p_rec.org_information9 :=
574: hr_ori_shd.g_old_rec.org_information9;
575: End If;
576: If (p_rec.request_id = hr_api.g_number) then

Line 576: If (p_rec.request_id = hr_api.g_number) then

572: If (p_rec.org_information9 = hr_api.g_varchar2) then
573: p_rec.org_information9 :=
574: hr_ori_shd.g_old_rec.org_information9;
575: End If;
576: If (p_rec.request_id = hr_api.g_number) then
577: p_rec.request_id :=
578: hr_ori_shd.g_old_rec.request_id;
579: End If;
580: If (p_rec.program_application_id = hr_api.g_number) then

Line 580: If (p_rec.program_application_id = hr_api.g_number) then

576: If (p_rec.request_id = hr_api.g_number) then
577: p_rec.request_id :=
578: hr_ori_shd.g_old_rec.request_id;
579: End If;
580: If (p_rec.program_application_id = hr_api.g_number) then
581: p_rec.program_application_id :=
582: hr_ori_shd.g_old_rec.program_application_id;
583: End If;
584: If (p_rec.program_id = hr_api.g_number) then

Line 584: If (p_rec.program_id = hr_api.g_number) then

580: If (p_rec.program_application_id = hr_api.g_number) then
581: p_rec.program_application_id :=
582: hr_ori_shd.g_old_rec.program_application_id;
583: End If;
584: If (p_rec.program_id = hr_api.g_number) then
585: p_rec.program_id :=
586: hr_ori_shd.g_old_rec.program_id;
587: End If;
588: If (p_rec.program_update_date = hr_api.g_date) then

Line 588: If (p_rec.program_update_date = hr_api.g_date) then

584: If (p_rec.program_id = hr_api.g_number) then
585: p_rec.program_id :=
586: hr_ori_shd.g_old_rec.program_id;
587: End If;
588: If (p_rec.program_update_date = hr_api.g_date) then
589: p_rec.program_update_date :=
590: hr_ori_shd.g_old_rec.program_update_date;
591: End If;
592: If (p_rec.attribute_category = hr_api.g_varchar2) then

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

588: If (p_rec.program_update_date = hr_api.g_date) then
589: p_rec.program_update_date :=
590: hr_ori_shd.g_old_rec.program_update_date;
591: End If;
592: If (p_rec.attribute_category = hr_api.g_varchar2) then
593: p_rec.attribute_category :=
594: hr_ori_shd.g_old_rec.attribute_category;
595: End If;
596: If (p_rec.attribute1 = hr_api.g_varchar2) then

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

592: If (p_rec.attribute_category = hr_api.g_varchar2) then
593: p_rec.attribute_category :=
594: hr_ori_shd.g_old_rec.attribute_category;
595: End If;
596: If (p_rec.attribute1 = hr_api.g_varchar2) then
597: p_rec.attribute1 :=
598: hr_ori_shd.g_old_rec.attribute1;
599: End If;
600: If (p_rec.attribute2 = hr_api.g_varchar2) then

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

596: If (p_rec.attribute1 = hr_api.g_varchar2) then
597: p_rec.attribute1 :=
598: hr_ori_shd.g_old_rec.attribute1;
599: End If;
600: If (p_rec.attribute2 = hr_api.g_varchar2) then
601: p_rec.attribute2 :=
602: hr_ori_shd.g_old_rec.attribute2;
603: End If;
604: If (p_rec.attribute3 = hr_api.g_varchar2) then

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

600: If (p_rec.attribute2 = hr_api.g_varchar2) then
601: p_rec.attribute2 :=
602: hr_ori_shd.g_old_rec.attribute2;
603: End If;
604: If (p_rec.attribute3 = hr_api.g_varchar2) then
605: p_rec.attribute3 :=
606: hr_ori_shd.g_old_rec.attribute3;
607: End If;
608: If (p_rec.attribute4 = hr_api.g_varchar2) then

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

604: If (p_rec.attribute3 = hr_api.g_varchar2) then
605: p_rec.attribute3 :=
606: hr_ori_shd.g_old_rec.attribute3;
607: End If;
608: If (p_rec.attribute4 = hr_api.g_varchar2) then
609: p_rec.attribute4 :=
610: hr_ori_shd.g_old_rec.attribute4;
611: End If;
612: If (p_rec.attribute5 = hr_api.g_varchar2) then

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

608: If (p_rec.attribute4 = hr_api.g_varchar2) then
609: p_rec.attribute4 :=
610: hr_ori_shd.g_old_rec.attribute4;
611: End If;
612: If (p_rec.attribute5 = hr_api.g_varchar2) then
613: p_rec.attribute5 :=
614: hr_ori_shd.g_old_rec.attribute5;
615: End If;
616: If (p_rec.attribute6 = hr_api.g_varchar2) then

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

612: If (p_rec.attribute5 = hr_api.g_varchar2) then
613: p_rec.attribute5 :=
614: hr_ori_shd.g_old_rec.attribute5;
615: End If;
616: If (p_rec.attribute6 = hr_api.g_varchar2) then
617: p_rec.attribute6 :=
618: hr_ori_shd.g_old_rec.attribute6;
619: End If;
620: If (p_rec.attribute7 = hr_api.g_varchar2) then

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

616: If (p_rec.attribute6 = hr_api.g_varchar2) then
617: p_rec.attribute6 :=
618: hr_ori_shd.g_old_rec.attribute6;
619: End If;
620: If (p_rec.attribute7 = hr_api.g_varchar2) then
621: p_rec.attribute7 :=
622: hr_ori_shd.g_old_rec.attribute7;
623: End If;
624: If (p_rec.attribute8 = hr_api.g_varchar2) then

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

620: If (p_rec.attribute7 = hr_api.g_varchar2) then
621: p_rec.attribute7 :=
622: hr_ori_shd.g_old_rec.attribute7;
623: End If;
624: If (p_rec.attribute8 = hr_api.g_varchar2) then
625: p_rec.attribute8 :=
626: hr_ori_shd.g_old_rec.attribute8;
627: End If;
628: If (p_rec.attribute9 = hr_api.g_varchar2) then

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

624: If (p_rec.attribute8 = hr_api.g_varchar2) then
625: p_rec.attribute8 :=
626: hr_ori_shd.g_old_rec.attribute8;
627: End If;
628: If (p_rec.attribute9 = hr_api.g_varchar2) then
629: p_rec.attribute9 :=
630: hr_ori_shd.g_old_rec.attribute9;
631: End If;
632: If (p_rec.attribute10 = hr_api.g_varchar2) then

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

628: If (p_rec.attribute9 = hr_api.g_varchar2) then
629: p_rec.attribute9 :=
630: hr_ori_shd.g_old_rec.attribute9;
631: End If;
632: If (p_rec.attribute10 = hr_api.g_varchar2) then
633: p_rec.attribute10 :=
634: hr_ori_shd.g_old_rec.attribute10;
635: End If;
636: If (p_rec.attribute11 = hr_api.g_varchar2) then

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

632: If (p_rec.attribute10 = hr_api.g_varchar2) then
633: p_rec.attribute10 :=
634: hr_ori_shd.g_old_rec.attribute10;
635: End If;
636: If (p_rec.attribute11 = hr_api.g_varchar2) then
637: p_rec.attribute11 :=
638: hr_ori_shd.g_old_rec.attribute11;
639: End If;
640: If (p_rec.attribute12 = hr_api.g_varchar2) then

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

636: If (p_rec.attribute11 = hr_api.g_varchar2) then
637: p_rec.attribute11 :=
638: hr_ori_shd.g_old_rec.attribute11;
639: End If;
640: If (p_rec.attribute12 = hr_api.g_varchar2) then
641: p_rec.attribute12 :=
642: hr_ori_shd.g_old_rec.attribute12;
643: End If;
644: If (p_rec.attribute13 = hr_api.g_varchar2) then

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

640: If (p_rec.attribute12 = hr_api.g_varchar2) then
641: p_rec.attribute12 :=
642: hr_ori_shd.g_old_rec.attribute12;
643: End If;
644: If (p_rec.attribute13 = hr_api.g_varchar2) then
645: p_rec.attribute13 :=
646: hr_ori_shd.g_old_rec.attribute13;
647: End If;
648: If (p_rec.attribute14 = hr_api.g_varchar2) then

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

644: If (p_rec.attribute13 = hr_api.g_varchar2) then
645: p_rec.attribute13 :=
646: hr_ori_shd.g_old_rec.attribute13;
647: End If;
648: If (p_rec.attribute14 = hr_api.g_varchar2) then
649: p_rec.attribute14 :=
650: hr_ori_shd.g_old_rec.attribute14;
651: End If;
652: If (p_rec.attribute15 = hr_api.g_varchar2) then

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

648: If (p_rec.attribute14 = hr_api.g_varchar2) then
649: p_rec.attribute14 :=
650: hr_ori_shd.g_old_rec.attribute14;
651: End If;
652: If (p_rec.attribute15 = hr_api.g_varchar2) then
653: p_rec.attribute15 :=
654: hr_ori_shd.g_old_rec.attribute15;
655: End If;
656: If (p_rec.attribute16 = hr_api.g_varchar2) then

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

652: If (p_rec.attribute15 = hr_api.g_varchar2) then
653: p_rec.attribute15 :=
654: hr_ori_shd.g_old_rec.attribute15;
655: End If;
656: If (p_rec.attribute16 = hr_api.g_varchar2) then
657: p_rec.attribute16 :=
658: hr_ori_shd.g_old_rec.attribute16;
659: End If;
660: If (p_rec.attribute17 = hr_api.g_varchar2) then

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

656: If (p_rec.attribute16 = hr_api.g_varchar2) then
657: p_rec.attribute16 :=
658: hr_ori_shd.g_old_rec.attribute16;
659: End If;
660: If (p_rec.attribute17 = hr_api.g_varchar2) then
661: p_rec.attribute17 :=
662: hr_ori_shd.g_old_rec.attribute17;
663: End If;
664: If (p_rec.attribute18 = hr_api.g_varchar2) then

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

660: If (p_rec.attribute17 = hr_api.g_varchar2) then
661: p_rec.attribute17 :=
662: hr_ori_shd.g_old_rec.attribute17;
663: End If;
664: If (p_rec.attribute18 = hr_api.g_varchar2) then
665: p_rec.attribute18 :=
666: hr_ori_shd.g_old_rec.attribute18;
667: End If;
668: If (p_rec.attribute19 = hr_api.g_varchar2) then

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

664: If (p_rec.attribute18 = hr_api.g_varchar2) then
665: p_rec.attribute18 :=
666: hr_ori_shd.g_old_rec.attribute18;
667: End If;
668: If (p_rec.attribute19 = hr_api.g_varchar2) then
669: p_rec.attribute19 :=
670: hr_ori_shd.g_old_rec.attribute19;
671: End If;
672: If (p_rec.attribute20 = hr_api.g_varchar2) then

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

668: If (p_rec.attribute19 = hr_api.g_varchar2) then
669: p_rec.attribute19 :=
670: hr_ori_shd.g_old_rec.attribute19;
671: End If;
672: If (p_rec.attribute20 = hr_api.g_varchar2) then
673: p_rec.attribute20 :=
674: hr_ori_shd.g_old_rec.attribute20;
675: End If;
676: --

Line 734: ,p_org_information_context in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

730: Procedure upd
731: (p_effective_date in date
732: ,p_org_information_id in number
733: ,p_object_version_number in out nocopy number
734: ,p_org_information_context in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
735: ,p_organization_id in number -- default hr_api.g_number --r115.21
736: ,p_org_information1 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
737: ,p_org_information10 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
738: ,p_org_information11 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

Line 735: ,p_organization_id in number -- default hr_api.g_number --r115.21

731: (p_effective_date in date
732: ,p_org_information_id in number
733: ,p_object_version_number in out nocopy number
734: ,p_org_information_context in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
735: ,p_organization_id in number -- default hr_api.g_number --r115.21
736: ,p_org_information1 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
737: ,p_org_information10 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
738: ,p_org_information11 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
739: ,p_org_information12 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

Line 736: ,p_org_information1 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

732: ,p_org_information_id in number
733: ,p_object_version_number in out nocopy number
734: ,p_org_information_context in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
735: ,p_organization_id in number -- default hr_api.g_number --r115.21
736: ,p_org_information1 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
737: ,p_org_information10 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
738: ,p_org_information11 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
739: ,p_org_information12 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
740: ,p_org_information13 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

Line 737: ,p_org_information10 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

733: ,p_object_version_number in out nocopy number
734: ,p_org_information_context in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
735: ,p_organization_id in number -- default hr_api.g_number --r115.21
736: ,p_org_information1 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
737: ,p_org_information10 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
738: ,p_org_information11 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
739: ,p_org_information12 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
740: ,p_org_information13 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
741: ,p_org_information14 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

Line 738: ,p_org_information11 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

734: ,p_org_information_context in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
735: ,p_organization_id in number -- default hr_api.g_number --r115.21
736: ,p_org_information1 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
737: ,p_org_information10 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
738: ,p_org_information11 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
739: ,p_org_information12 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
740: ,p_org_information13 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
741: ,p_org_information14 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
742: ,p_org_information15 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

Line 739: ,p_org_information12 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

735: ,p_organization_id in number -- default hr_api.g_number --r115.21
736: ,p_org_information1 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
737: ,p_org_information10 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
738: ,p_org_information11 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
739: ,p_org_information12 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
740: ,p_org_information13 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
741: ,p_org_information14 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
742: ,p_org_information15 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
743: ,p_org_information16 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

Line 740: ,p_org_information13 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

736: ,p_org_information1 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
737: ,p_org_information10 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
738: ,p_org_information11 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
739: ,p_org_information12 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
740: ,p_org_information13 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
741: ,p_org_information14 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
742: ,p_org_information15 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
743: ,p_org_information16 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
744: ,p_org_information17 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

Line 741: ,p_org_information14 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

737: ,p_org_information10 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
738: ,p_org_information11 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
739: ,p_org_information12 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
740: ,p_org_information13 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
741: ,p_org_information14 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
742: ,p_org_information15 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
743: ,p_org_information16 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
744: ,p_org_information17 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
745: ,p_org_information18 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

Line 742: ,p_org_information15 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

738: ,p_org_information11 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
739: ,p_org_information12 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
740: ,p_org_information13 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
741: ,p_org_information14 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
742: ,p_org_information15 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
743: ,p_org_information16 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
744: ,p_org_information17 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
745: ,p_org_information18 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
746: ,p_org_information19 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

Line 743: ,p_org_information16 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

739: ,p_org_information12 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
740: ,p_org_information13 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
741: ,p_org_information14 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
742: ,p_org_information15 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
743: ,p_org_information16 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
744: ,p_org_information17 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
745: ,p_org_information18 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
746: ,p_org_information19 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
747: ,p_org_information2 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

Line 744: ,p_org_information17 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

740: ,p_org_information13 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
741: ,p_org_information14 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
742: ,p_org_information15 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
743: ,p_org_information16 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
744: ,p_org_information17 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
745: ,p_org_information18 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
746: ,p_org_information19 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
747: ,p_org_information2 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
748: ,p_org_information20 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

Line 745: ,p_org_information18 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

741: ,p_org_information14 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
742: ,p_org_information15 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
743: ,p_org_information16 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
744: ,p_org_information17 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
745: ,p_org_information18 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
746: ,p_org_information19 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
747: ,p_org_information2 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
748: ,p_org_information20 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
749: ,p_org_information3 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

Line 746: ,p_org_information19 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

742: ,p_org_information15 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
743: ,p_org_information16 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
744: ,p_org_information17 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
745: ,p_org_information18 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
746: ,p_org_information19 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
747: ,p_org_information2 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
748: ,p_org_information20 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
749: ,p_org_information3 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
750: ,p_org_information4 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

Line 747: ,p_org_information2 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

743: ,p_org_information16 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
744: ,p_org_information17 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
745: ,p_org_information18 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
746: ,p_org_information19 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
747: ,p_org_information2 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
748: ,p_org_information20 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
749: ,p_org_information3 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
750: ,p_org_information4 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
751: ,p_org_information5 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

Line 748: ,p_org_information20 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

744: ,p_org_information17 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
745: ,p_org_information18 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
746: ,p_org_information19 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
747: ,p_org_information2 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
748: ,p_org_information20 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
749: ,p_org_information3 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
750: ,p_org_information4 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
751: ,p_org_information5 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
752: ,p_org_information6 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

Line 749: ,p_org_information3 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

745: ,p_org_information18 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
746: ,p_org_information19 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
747: ,p_org_information2 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
748: ,p_org_information20 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
749: ,p_org_information3 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
750: ,p_org_information4 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
751: ,p_org_information5 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
752: ,p_org_information6 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
753: ,p_org_information7 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

Line 750: ,p_org_information4 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

746: ,p_org_information19 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
747: ,p_org_information2 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
748: ,p_org_information20 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
749: ,p_org_information3 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
750: ,p_org_information4 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
751: ,p_org_information5 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
752: ,p_org_information6 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
753: ,p_org_information7 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
754: ,p_org_information8 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

Line 751: ,p_org_information5 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

747: ,p_org_information2 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
748: ,p_org_information20 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
749: ,p_org_information3 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
750: ,p_org_information4 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
751: ,p_org_information5 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
752: ,p_org_information6 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
753: ,p_org_information7 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
754: ,p_org_information8 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
755: ,p_org_information9 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

Line 752: ,p_org_information6 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

748: ,p_org_information20 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
749: ,p_org_information3 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
750: ,p_org_information4 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
751: ,p_org_information5 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
752: ,p_org_information6 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
753: ,p_org_information7 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
754: ,p_org_information8 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
755: ,p_org_information9 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
756: ,p_attribute_category in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

Line 753: ,p_org_information7 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

749: ,p_org_information3 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
750: ,p_org_information4 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
751: ,p_org_information5 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
752: ,p_org_information6 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
753: ,p_org_information7 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
754: ,p_org_information8 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
755: ,p_org_information9 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
756: ,p_attribute_category in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
757: ,p_attribute1 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

Line 754: ,p_org_information8 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

750: ,p_org_information4 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
751: ,p_org_information5 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
752: ,p_org_information6 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
753: ,p_org_information7 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
754: ,p_org_information8 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
755: ,p_org_information9 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
756: ,p_attribute_category in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
757: ,p_attribute1 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
758: ,p_attribute2 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

Line 755: ,p_org_information9 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

751: ,p_org_information5 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
752: ,p_org_information6 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
753: ,p_org_information7 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
754: ,p_org_information8 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
755: ,p_org_information9 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
756: ,p_attribute_category in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
757: ,p_attribute1 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
758: ,p_attribute2 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
759: ,p_attribute3 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

Line 756: ,p_attribute_category in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

752: ,p_org_information6 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
753: ,p_org_information7 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
754: ,p_org_information8 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
755: ,p_org_information9 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
756: ,p_attribute_category in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
757: ,p_attribute1 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
758: ,p_attribute2 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
759: ,p_attribute3 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
760: ,p_attribute4 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

Line 757: ,p_attribute1 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

753: ,p_org_information7 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
754: ,p_org_information8 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
755: ,p_org_information9 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
756: ,p_attribute_category in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
757: ,p_attribute1 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
758: ,p_attribute2 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
759: ,p_attribute3 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
760: ,p_attribute4 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
761: ,p_attribute5 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

Line 758: ,p_attribute2 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

754: ,p_org_information8 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
755: ,p_org_information9 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
756: ,p_attribute_category in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
757: ,p_attribute1 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
758: ,p_attribute2 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
759: ,p_attribute3 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
760: ,p_attribute4 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
761: ,p_attribute5 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
762: ,p_attribute6 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

Line 759: ,p_attribute3 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

755: ,p_org_information9 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
756: ,p_attribute_category in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
757: ,p_attribute1 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
758: ,p_attribute2 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
759: ,p_attribute3 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
760: ,p_attribute4 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
761: ,p_attribute5 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
762: ,p_attribute6 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
763: ,p_attribute7 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

Line 760: ,p_attribute4 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

756: ,p_attribute_category in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
757: ,p_attribute1 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
758: ,p_attribute2 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
759: ,p_attribute3 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
760: ,p_attribute4 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
761: ,p_attribute5 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
762: ,p_attribute6 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
763: ,p_attribute7 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
764: ,p_attribute8 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

Line 761: ,p_attribute5 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

757: ,p_attribute1 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
758: ,p_attribute2 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
759: ,p_attribute3 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
760: ,p_attribute4 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
761: ,p_attribute5 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
762: ,p_attribute6 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
763: ,p_attribute7 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
764: ,p_attribute8 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
765: ,p_attribute9 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

Line 762: ,p_attribute6 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

758: ,p_attribute2 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
759: ,p_attribute3 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
760: ,p_attribute4 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
761: ,p_attribute5 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
762: ,p_attribute6 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
763: ,p_attribute7 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
764: ,p_attribute8 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
765: ,p_attribute9 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
766: ,p_attribute10 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

Line 763: ,p_attribute7 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

759: ,p_attribute3 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
760: ,p_attribute4 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
761: ,p_attribute5 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
762: ,p_attribute6 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
763: ,p_attribute7 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
764: ,p_attribute8 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
765: ,p_attribute9 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
766: ,p_attribute10 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
767: ,p_attribute11 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

Line 764: ,p_attribute8 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

760: ,p_attribute4 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
761: ,p_attribute5 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
762: ,p_attribute6 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
763: ,p_attribute7 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
764: ,p_attribute8 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
765: ,p_attribute9 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
766: ,p_attribute10 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
767: ,p_attribute11 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
768: ,p_attribute12 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

Line 765: ,p_attribute9 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

761: ,p_attribute5 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
762: ,p_attribute6 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
763: ,p_attribute7 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
764: ,p_attribute8 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
765: ,p_attribute9 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
766: ,p_attribute10 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
767: ,p_attribute11 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
768: ,p_attribute12 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
769: ,p_attribute13 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

Line 766: ,p_attribute10 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

762: ,p_attribute6 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
763: ,p_attribute7 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
764: ,p_attribute8 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
765: ,p_attribute9 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
766: ,p_attribute10 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
767: ,p_attribute11 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
768: ,p_attribute12 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
769: ,p_attribute13 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
770: ,p_attribute14 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

Line 767: ,p_attribute11 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

763: ,p_attribute7 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
764: ,p_attribute8 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
765: ,p_attribute9 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
766: ,p_attribute10 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
767: ,p_attribute11 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
768: ,p_attribute12 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
769: ,p_attribute13 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
770: ,p_attribute14 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
771: ,p_attribute15 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

Line 768: ,p_attribute12 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

764: ,p_attribute8 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
765: ,p_attribute9 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
766: ,p_attribute10 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
767: ,p_attribute11 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
768: ,p_attribute12 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
769: ,p_attribute13 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
770: ,p_attribute14 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
771: ,p_attribute15 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
772: ,p_attribute16 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

Line 769: ,p_attribute13 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

765: ,p_attribute9 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
766: ,p_attribute10 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
767: ,p_attribute11 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
768: ,p_attribute12 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
769: ,p_attribute13 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
770: ,p_attribute14 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
771: ,p_attribute15 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
772: ,p_attribute16 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
773: ,p_attribute17 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

Line 770: ,p_attribute14 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

766: ,p_attribute10 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
767: ,p_attribute11 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
768: ,p_attribute12 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
769: ,p_attribute13 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
770: ,p_attribute14 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
771: ,p_attribute15 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
772: ,p_attribute16 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
773: ,p_attribute17 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
774: ,p_attribute18 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

Line 771: ,p_attribute15 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

767: ,p_attribute11 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
768: ,p_attribute12 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
769: ,p_attribute13 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
770: ,p_attribute14 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
771: ,p_attribute15 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
772: ,p_attribute16 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
773: ,p_attribute17 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
774: ,p_attribute18 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
775: ,p_attribute19 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

Line 772: ,p_attribute16 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

768: ,p_attribute12 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
769: ,p_attribute13 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
770: ,p_attribute14 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
771: ,p_attribute15 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
772: ,p_attribute16 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
773: ,p_attribute17 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
774: ,p_attribute18 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
775: ,p_attribute19 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
776: ,p_attribute20 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

Line 773: ,p_attribute17 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

769: ,p_attribute13 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
770: ,p_attribute14 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
771: ,p_attribute15 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
772: ,p_attribute16 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
773: ,p_attribute17 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
774: ,p_attribute18 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
775: ,p_attribute19 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
776: ,p_attribute20 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
777: ) is

Line 774: ,p_attribute18 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

770: ,p_attribute14 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
771: ,p_attribute15 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
772: ,p_attribute16 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
773: ,p_attribute17 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
774: ,p_attribute18 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
775: ,p_attribute19 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
776: ,p_attribute20 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
777: ) is
778: --

Line 775: ,p_attribute19 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

771: ,p_attribute15 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
772: ,p_attribute16 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
773: ,p_attribute17 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
774: ,p_attribute18 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
775: ,p_attribute19 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
776: ,p_attribute20 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
777: ) is
778: --
779: l_rec hr_ori_shd.g_rec_type;

Line 776: ,p_attribute20 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21

772: ,p_attribute16 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
773: ,p_attribute17 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
774: ,p_attribute18 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
775: ,p_attribute19 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
776: ,p_attribute20 in varchar2 -- r115.21 -- default hr_api.g_varchar2 -- r115.21
777: ) is
778: --
779: l_rec hr_ori_shd.g_rec_type;
780: l_proc varchar2(72) := g_package||'upd';

Line 813: ,hr_api.g_number

809: ,p_org_information6
810: ,p_org_information7
811: ,p_org_information8
812: ,p_org_information9
813: ,hr_api.g_number
814: ,hr_api.g_number
815: ,hr_api.g_number
816: ,hr_api.g_date
817: ,p_attribute_category

Line 814: ,hr_api.g_number

810: ,p_org_information7
811: ,p_org_information8
812: ,p_org_information9
813: ,hr_api.g_number
814: ,hr_api.g_number
815: ,hr_api.g_number
816: ,hr_api.g_date
817: ,p_attribute_category
818: ,p_attribute1

Line 815: ,hr_api.g_number

811: ,p_org_information8
812: ,p_org_information9
813: ,hr_api.g_number
814: ,hr_api.g_number
815: ,hr_api.g_number
816: ,hr_api.g_date
817: ,p_attribute_category
818: ,p_attribute1
819: ,p_attribute2

Line 816: ,hr_api.g_date

812: ,p_org_information9
813: ,hr_api.g_number
814: ,hr_api.g_number
815: ,hr_api.g_number
816: ,hr_api.g_date
817: ,p_attribute_category
818: ,p_attribute1
819: ,p_attribute2
820: ,p_attribute3