DBA Data[Home] [Help]

APPS.PER_CN_ORG_INFO_LEG_HOOK dependencies on HR_API

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

866: ,l_org_information19
867: ,l_org_information20 ;
868: CLOSE csr_org_info;
869:
870: IF NVL(p_org_information1,'X') <> hr_api.g_varchar2 THEN
871: l_org_information1 := p_org_information1;
872: END IF;
873: IF NVL(p_org_information2,'X') <> hr_api.g_varchar2 THEN
874: l_org_information2 := p_org_information2;

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

869:
870: IF NVL(p_org_information1,'X') <> hr_api.g_varchar2 THEN
871: l_org_information1 := p_org_information1;
872: END IF;
873: IF NVL(p_org_information2,'X') <> hr_api.g_varchar2 THEN
874: l_org_information2 := p_org_information2;
875: END IF;
876: IF NVL(p_org_information3,'X') <> hr_api.g_varchar2 THEN
877: l_org_information3 := p_org_information3;

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

872: END IF;
873: IF NVL(p_org_information2,'X') <> hr_api.g_varchar2 THEN
874: l_org_information2 := p_org_information2;
875: END IF;
876: IF NVL(p_org_information3,'X') <> hr_api.g_varchar2 THEN
877: l_org_information3 := p_org_information3;
878: END IF;
879: IF NVL(p_org_information4,'X') <> hr_api.g_varchar2 THEN
880: l_org_information4 := p_org_information4;

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

875: END IF;
876: IF NVL(p_org_information3,'X') <> hr_api.g_varchar2 THEN
877: l_org_information3 := p_org_information3;
878: END IF;
879: IF NVL(p_org_information4,'X') <> hr_api.g_varchar2 THEN
880: l_org_information4 := p_org_information4;
881: END IF;
882: IF NVL(p_org_information5,'X') <> hr_api.g_varchar2 THEN
883: l_org_information5 := p_org_information5;

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

878: END IF;
879: IF NVL(p_org_information4,'X') <> hr_api.g_varchar2 THEN
880: l_org_information4 := p_org_information4;
881: END IF;
882: IF NVL(p_org_information5,'X') <> hr_api.g_varchar2 THEN
883: l_org_information5 := p_org_information5;
884: END IF;
885: IF NVL(p_org_information6,'X') <> hr_api.g_varchar2 THEN
886: l_org_information6 := p_org_information6;

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

881: END IF;
882: IF NVL(p_org_information5,'X') <> hr_api.g_varchar2 THEN
883: l_org_information5 := p_org_information5;
884: END IF;
885: IF NVL(p_org_information6,'X') <> hr_api.g_varchar2 THEN
886: l_org_information6 := p_org_information6;
887: END IF;
888: IF NVL(p_org_information7,'X') <> hr_api.g_varchar2 THEN
889: l_org_information7 := p_org_information7;

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

884: END IF;
885: IF NVL(p_org_information6,'X') <> hr_api.g_varchar2 THEN
886: l_org_information6 := p_org_information6;
887: END IF;
888: IF NVL(p_org_information7,'X') <> hr_api.g_varchar2 THEN
889: l_org_information7 := p_org_information7;
890: END IF;
891: IF NVL(p_org_information8,'X') <> hr_api.g_varchar2 THEN
892: l_org_information8 := p_org_information8;

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

887: END IF;
888: IF NVL(p_org_information7,'X') <> hr_api.g_varchar2 THEN
889: l_org_information7 := p_org_information7;
890: END IF;
891: IF NVL(p_org_information8,'X') <> hr_api.g_varchar2 THEN
892: l_org_information8 := p_org_information8;
893: END IF;
894: IF NVL(p_org_information9,'X') <> hr_api.g_varchar2 THEN
895: l_org_information9 := p_org_information9;

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

890: END IF;
891: IF NVL(p_org_information8,'X') <> hr_api.g_varchar2 THEN
892: l_org_information8 := p_org_information8;
893: END IF;
894: IF NVL(p_org_information9,'X') <> hr_api.g_varchar2 THEN
895: l_org_information9 := p_org_information9;
896: END IF;
897: IF NVL(p_org_information10,'X') <> hr_api.g_varchar2 THEN
898: l_org_information10 := p_org_information10;

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

893: END IF;
894: IF NVL(p_org_information9,'X') <> hr_api.g_varchar2 THEN
895: l_org_information9 := p_org_information9;
896: END IF;
897: IF NVL(p_org_information10,'X') <> hr_api.g_varchar2 THEN
898: l_org_information10 := p_org_information10;
899: END IF;
900: IF NVL(p_org_information11,'X') <> hr_api.g_varchar2 THEN
901: l_org_information11 := p_org_information11;

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

896: END IF;
897: IF NVL(p_org_information10,'X') <> hr_api.g_varchar2 THEN
898: l_org_information10 := p_org_information10;
899: END IF;
900: IF NVL(p_org_information11,'X') <> hr_api.g_varchar2 THEN
901: l_org_information11 := p_org_information11;
902: END IF;
903: IF NVL(p_org_information12,'X') <> hr_api.g_varchar2 THEN
904: l_org_information12 := p_org_information12;

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

899: END IF;
900: IF NVL(p_org_information11,'X') <> hr_api.g_varchar2 THEN
901: l_org_information11 := p_org_information11;
902: END IF;
903: IF NVL(p_org_information12,'X') <> hr_api.g_varchar2 THEN
904: l_org_information12 := p_org_information12;
905: END IF;
906: IF NVL(p_org_information13,'X') <> hr_api.g_varchar2 THEN
907: l_org_information13 := p_org_information13;

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

902: END IF;
903: IF NVL(p_org_information12,'X') <> hr_api.g_varchar2 THEN
904: l_org_information12 := p_org_information12;
905: END IF;
906: IF NVL(p_org_information13,'X') <> hr_api.g_varchar2 THEN
907: l_org_information13 := p_org_information13;
908: END IF;
909: IF NVL(p_org_information14,'X') <> hr_api.g_varchar2 THEN
910: l_org_information14 := p_org_information14;

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

905: END IF;
906: IF NVL(p_org_information13,'X') <> hr_api.g_varchar2 THEN
907: l_org_information13 := p_org_information13;
908: END IF;
909: IF NVL(p_org_information14,'X') <> hr_api.g_varchar2 THEN
910: l_org_information14 := p_org_information14;
911: END IF;
912: IF NVL(p_org_information15,'X') <> hr_api.g_varchar2 THEN
913: l_org_information15 := p_org_information15;

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

908: END IF;
909: IF NVL(p_org_information14,'X') <> hr_api.g_varchar2 THEN
910: l_org_information14 := p_org_information14;
911: END IF;
912: IF NVL(p_org_information15,'X') <> hr_api.g_varchar2 THEN
913: l_org_information15 := p_org_information15;
914: END IF;
915: IF NVL(p_org_information16,'X') <> hr_api.g_varchar2 THEN
916: l_org_information16 := p_org_information16;

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

911: END IF;
912: IF NVL(p_org_information15,'X') <> hr_api.g_varchar2 THEN
913: l_org_information15 := p_org_information15;
914: END IF;
915: IF NVL(p_org_information16,'X') <> hr_api.g_varchar2 THEN
916: l_org_information16 := p_org_information16;
917: END IF;
918: IF NVL(p_org_information17,'X') <> hr_api.g_varchar2 THEN
919: l_org_information17 := p_org_information17;

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

914: END IF;
915: IF NVL(p_org_information16,'X') <> hr_api.g_varchar2 THEN
916: l_org_information16 := p_org_information16;
917: END IF;
918: IF NVL(p_org_information17,'X') <> hr_api.g_varchar2 THEN
919: l_org_information17 := p_org_information17;
920: END IF;
921: IF NVL(p_org_information18,'X') <> hr_api.g_varchar2 THEN
922: l_org_information18 := p_org_information18;

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

917: END IF;
918: IF NVL(p_org_information17,'X') <> hr_api.g_varchar2 THEN
919: l_org_information17 := p_org_information17;
920: END IF;
921: IF NVL(p_org_information18,'X') <> hr_api.g_varchar2 THEN
922: l_org_information18 := p_org_information18;
923: END IF;
924: IF NVL(p_org_information19,'X') <> hr_api.g_varchar2 THEN
925: l_org_information19 := p_org_information19;

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

920: END IF;
921: IF NVL(p_org_information18,'X') <> hr_api.g_varchar2 THEN
922: l_org_information18 := p_org_information18;
923: END IF;
924: IF NVL(p_org_information19,'X') <> hr_api.g_varchar2 THEN
925: l_org_information19 := p_org_information19;
926: END IF;
927: IF NVL(p_org_information20,'X') <> hr_api.g_varchar2 THEN
928: l_org_information20 := p_org_information20;

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

923: END IF;
924: IF NVL(p_org_information19,'X') <> hr_api.g_varchar2 THEN
925: l_org_information19 := p_org_information19;
926: END IF;
927: IF NVL(p_org_information20,'X') <> hr_api.g_varchar2 THEN
928: l_org_information20 := p_org_information20;
929: END IF;
930:
931: -- Call check_cn_org_internal