DBA Data[Home] [Help]

APPS.PER_CN_ORG_INFO_LEG_HOOK dependencies on HR_API

Line 776: IF NVL(p_org_information1,'X') <> hr_api.g_varchar2 THEN

772: ,l_org_information19
773: ,l_org_information20 ;
774: CLOSE csr_org_info;
775:
776: IF NVL(p_org_information1,'X') <> hr_api.g_varchar2 THEN
777: l_org_information1 := p_org_information1;
778: END IF;
779: IF NVL(p_org_information2,'X') <> hr_api.g_varchar2 THEN
780: l_org_information2 := p_org_information2;

Line 779: IF NVL(p_org_information2,'X') <> hr_api.g_varchar2 THEN

775:
776: IF NVL(p_org_information1,'X') <> hr_api.g_varchar2 THEN
777: l_org_information1 := p_org_information1;
778: END IF;
779: IF NVL(p_org_information2,'X') <> hr_api.g_varchar2 THEN
780: l_org_information2 := p_org_information2;
781: END IF;
782: IF NVL(p_org_information3,'X') <> hr_api.g_varchar2 THEN
783: l_org_information3 := p_org_information3;

Line 782: IF NVL(p_org_information3,'X') <> hr_api.g_varchar2 THEN

778: END IF;
779: IF NVL(p_org_information2,'X') <> hr_api.g_varchar2 THEN
780: l_org_information2 := p_org_information2;
781: END IF;
782: IF NVL(p_org_information3,'X') <> hr_api.g_varchar2 THEN
783: l_org_information3 := p_org_information3;
784: END IF;
785: IF NVL(p_org_information4,'X') <> hr_api.g_varchar2 THEN
786: l_org_information4 := p_org_information4;

Line 785: IF NVL(p_org_information4,'X') <> hr_api.g_varchar2 THEN

781: END IF;
782: IF NVL(p_org_information3,'X') <> hr_api.g_varchar2 THEN
783: l_org_information3 := p_org_information3;
784: END IF;
785: IF NVL(p_org_information4,'X') <> hr_api.g_varchar2 THEN
786: l_org_information4 := p_org_information4;
787: END IF;
788: IF NVL(p_org_information5,'X') <> hr_api.g_varchar2 THEN
789: l_org_information5 := p_org_information5;

Line 788: IF NVL(p_org_information5,'X') <> hr_api.g_varchar2 THEN

784: END IF;
785: IF NVL(p_org_information4,'X') <> hr_api.g_varchar2 THEN
786: l_org_information4 := p_org_information4;
787: END IF;
788: IF NVL(p_org_information5,'X') <> hr_api.g_varchar2 THEN
789: l_org_information5 := p_org_information5;
790: END IF;
791: IF NVL(p_org_information6,'X') <> hr_api.g_varchar2 THEN
792: l_org_information6 := p_org_information6;

Line 791: IF NVL(p_org_information6,'X') <> hr_api.g_varchar2 THEN

787: END IF;
788: IF NVL(p_org_information5,'X') <> hr_api.g_varchar2 THEN
789: l_org_information5 := p_org_information5;
790: END IF;
791: IF NVL(p_org_information6,'X') <> hr_api.g_varchar2 THEN
792: l_org_information6 := p_org_information6;
793: END IF;
794: IF NVL(p_org_information7,'X') <> hr_api.g_varchar2 THEN
795: l_org_information7 := p_org_information7;

Line 794: IF NVL(p_org_information7,'X') <> hr_api.g_varchar2 THEN

790: END IF;
791: IF NVL(p_org_information6,'X') <> hr_api.g_varchar2 THEN
792: l_org_information6 := p_org_information6;
793: END IF;
794: IF NVL(p_org_information7,'X') <> hr_api.g_varchar2 THEN
795: l_org_information7 := p_org_information7;
796: END IF;
797: IF NVL(p_org_information8,'X') <> hr_api.g_varchar2 THEN
798: l_org_information8 := p_org_information8;

Line 797: IF NVL(p_org_information8,'X') <> hr_api.g_varchar2 THEN

793: END IF;
794: IF NVL(p_org_information7,'X') <> hr_api.g_varchar2 THEN
795: l_org_information7 := p_org_information7;
796: END IF;
797: IF NVL(p_org_information8,'X') <> hr_api.g_varchar2 THEN
798: l_org_information8 := p_org_information8;
799: END IF;
800: IF NVL(p_org_information9,'X') <> hr_api.g_varchar2 THEN
801: l_org_information9 := p_org_information9;

Line 800: IF NVL(p_org_information9,'X') <> hr_api.g_varchar2 THEN

796: END IF;
797: IF NVL(p_org_information8,'X') <> hr_api.g_varchar2 THEN
798: l_org_information8 := p_org_information8;
799: END IF;
800: IF NVL(p_org_information9,'X') <> hr_api.g_varchar2 THEN
801: l_org_information9 := p_org_information9;
802: END IF;
803: IF NVL(p_org_information10,'X') <> hr_api.g_varchar2 THEN
804: l_org_information10 := p_org_information10;

Line 803: IF NVL(p_org_information10,'X') <> hr_api.g_varchar2 THEN

799: END IF;
800: IF NVL(p_org_information9,'X') <> hr_api.g_varchar2 THEN
801: l_org_information9 := p_org_information9;
802: END IF;
803: IF NVL(p_org_information10,'X') <> hr_api.g_varchar2 THEN
804: l_org_information10 := p_org_information10;
805: END IF;
806: IF NVL(p_org_information11,'X') <> hr_api.g_varchar2 THEN
807: l_org_information11 := p_org_information11;

Line 806: IF NVL(p_org_information11,'X') <> hr_api.g_varchar2 THEN

802: END IF;
803: IF NVL(p_org_information10,'X') <> hr_api.g_varchar2 THEN
804: l_org_information10 := p_org_information10;
805: END IF;
806: IF NVL(p_org_information11,'X') <> hr_api.g_varchar2 THEN
807: l_org_information11 := p_org_information11;
808: END IF;
809: IF NVL(p_org_information12,'X') <> hr_api.g_varchar2 THEN
810: l_org_information12 := p_org_information12;

Line 809: IF NVL(p_org_information12,'X') <> hr_api.g_varchar2 THEN

805: END IF;
806: IF NVL(p_org_information11,'X') <> hr_api.g_varchar2 THEN
807: l_org_information11 := p_org_information11;
808: END IF;
809: IF NVL(p_org_information12,'X') <> hr_api.g_varchar2 THEN
810: l_org_information12 := p_org_information12;
811: END IF;
812: IF NVL(p_org_information13,'X') <> hr_api.g_varchar2 THEN
813: l_org_information13 := p_org_information13;

Line 812: IF NVL(p_org_information13,'X') <> hr_api.g_varchar2 THEN

808: END IF;
809: IF NVL(p_org_information12,'X') <> hr_api.g_varchar2 THEN
810: l_org_information12 := p_org_information12;
811: END IF;
812: IF NVL(p_org_information13,'X') <> hr_api.g_varchar2 THEN
813: l_org_information13 := p_org_information13;
814: END IF;
815: IF NVL(p_org_information14,'X') <> hr_api.g_varchar2 THEN
816: l_org_information14 := p_org_information14;

Line 815: IF NVL(p_org_information14,'X') <> hr_api.g_varchar2 THEN

811: END IF;
812: IF NVL(p_org_information13,'X') <> hr_api.g_varchar2 THEN
813: l_org_information13 := p_org_information13;
814: END IF;
815: IF NVL(p_org_information14,'X') <> hr_api.g_varchar2 THEN
816: l_org_information14 := p_org_information14;
817: END IF;
818: IF NVL(p_org_information15,'X') <> hr_api.g_varchar2 THEN
819: l_org_information15 := p_org_information15;

Line 818: IF NVL(p_org_information15,'X') <> hr_api.g_varchar2 THEN

814: END IF;
815: IF NVL(p_org_information14,'X') <> hr_api.g_varchar2 THEN
816: l_org_information14 := p_org_information14;
817: END IF;
818: IF NVL(p_org_information15,'X') <> hr_api.g_varchar2 THEN
819: l_org_information15 := p_org_information15;
820: END IF;
821: IF NVL(p_org_information16,'X') <> hr_api.g_varchar2 THEN
822: l_org_information16 := p_org_information16;

Line 821: IF NVL(p_org_information16,'X') <> hr_api.g_varchar2 THEN

817: END IF;
818: IF NVL(p_org_information15,'X') <> hr_api.g_varchar2 THEN
819: l_org_information15 := p_org_information15;
820: END IF;
821: IF NVL(p_org_information16,'X') <> hr_api.g_varchar2 THEN
822: l_org_information16 := p_org_information16;
823: END IF;
824: IF NVL(p_org_information17,'X') <> hr_api.g_varchar2 THEN
825: l_org_information17 := p_org_information17;

Line 824: IF NVL(p_org_information17,'X') <> hr_api.g_varchar2 THEN

820: END IF;
821: IF NVL(p_org_information16,'X') <> hr_api.g_varchar2 THEN
822: l_org_information16 := p_org_information16;
823: END IF;
824: IF NVL(p_org_information17,'X') <> hr_api.g_varchar2 THEN
825: l_org_information17 := p_org_information17;
826: END IF;
827: IF NVL(p_org_information18,'X') <> hr_api.g_varchar2 THEN
828: l_org_information18 := p_org_information18;

Line 827: IF NVL(p_org_information18,'X') <> hr_api.g_varchar2 THEN

823: END IF;
824: IF NVL(p_org_information17,'X') <> hr_api.g_varchar2 THEN
825: l_org_information17 := p_org_information17;
826: END IF;
827: IF NVL(p_org_information18,'X') <> hr_api.g_varchar2 THEN
828: l_org_information18 := p_org_information18;
829: END IF;
830: IF NVL(p_org_information19,'X') <> hr_api.g_varchar2 THEN
831: l_org_information19 := p_org_information19;

Line 830: IF NVL(p_org_information19,'X') <> hr_api.g_varchar2 THEN

826: END IF;
827: IF NVL(p_org_information18,'X') <> hr_api.g_varchar2 THEN
828: l_org_information18 := p_org_information18;
829: END IF;
830: IF NVL(p_org_information19,'X') <> hr_api.g_varchar2 THEN
831: l_org_information19 := p_org_information19;
832: END IF;
833: IF NVL(p_org_information20,'X') <> hr_api.g_varchar2 THEN
834: l_org_information20 := p_org_information20;

Line 833: IF NVL(p_org_information20,'X') <> hr_api.g_varchar2 THEN

829: END IF;
830: IF NVL(p_org_information19,'X') <> hr_api.g_varchar2 THEN
831: l_org_information19 := p_org_information19;
832: END IF;
833: IF NVL(p_org_information20,'X') <> hr_api.g_varchar2 THEN
834: l_org_information20 := p_org_information20;
835: END IF;
836:
837: -- Call check_cn_org_internal