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_SG_ORG_INFO_LEG_HOOK dependencies on HR_API

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

546: ,l_org_information19
547: ,l_org_information20 ;
548: CLOSE csr_org_info;
549:
550: IF NVL(p_org_information1,'X') <> hr_api.g_varchar2 THEN
551: l_org_information1 := p_org_information1;
552: END IF;
553: IF NVL(p_org_information2,'X') <> hr_api.g_varchar2 THEN
554: l_org_information2 := p_org_information2;

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

549:
550: IF NVL(p_org_information1,'X') <> hr_api.g_varchar2 THEN
551: l_org_information1 := p_org_information1;
552: END IF;
553: IF NVL(p_org_information2,'X') <> hr_api.g_varchar2 THEN
554: l_org_information2 := p_org_information2;
555: END IF;
556: IF NVL(p_org_information3,'X') <> hr_api.g_varchar2 THEN
557: l_org_information3 := p_org_information3;

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

552: END IF;
553: IF NVL(p_org_information2,'X') <> hr_api.g_varchar2 THEN
554: l_org_information2 := p_org_information2;
555: END IF;
556: IF NVL(p_org_information3,'X') <> hr_api.g_varchar2 THEN
557: l_org_information3 := p_org_information3;
558: END IF;
559: IF NVL(p_org_information4,'X') <> hr_api.g_varchar2 THEN
560: l_org_information4 := p_org_information4;

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

555: END IF;
556: IF NVL(p_org_information3,'X') <> hr_api.g_varchar2 THEN
557: l_org_information3 := p_org_information3;
558: END IF;
559: IF NVL(p_org_information4,'X') <> hr_api.g_varchar2 THEN
560: l_org_information4 := p_org_information4;
561: END IF;
562: IF NVL(p_org_information5,'X') <> hr_api.g_varchar2 THEN
563: l_org_information5 := p_org_information5;

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

558: END IF;
559: IF NVL(p_org_information4,'X') <> hr_api.g_varchar2 THEN
560: l_org_information4 := p_org_information4;
561: END IF;
562: IF NVL(p_org_information5,'X') <> hr_api.g_varchar2 THEN
563: l_org_information5 := p_org_information5;
564: END IF;
565: IF NVL(p_org_information6,'X') <> hr_api.g_varchar2 THEN
566: l_org_information6 := p_org_information6;

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

561: END IF;
562: IF NVL(p_org_information5,'X') <> hr_api.g_varchar2 THEN
563: l_org_information5 := p_org_information5;
564: END IF;
565: IF NVL(p_org_information6,'X') <> hr_api.g_varchar2 THEN
566: l_org_information6 := p_org_information6;
567: END IF;
568: IF NVL(p_org_information7,'X') <> hr_api.g_varchar2 THEN
569: l_org_information7 := p_org_information7;

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

564: END IF;
565: IF NVL(p_org_information6,'X') <> hr_api.g_varchar2 THEN
566: l_org_information6 := p_org_information6;
567: END IF;
568: IF NVL(p_org_information7,'X') <> hr_api.g_varchar2 THEN
569: l_org_information7 := p_org_information7;
570: END IF;
571: IF NVL(p_org_information8,'X') <> hr_api.g_varchar2 THEN
572: l_org_information8 := p_org_information8;

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

567: END IF;
568: IF NVL(p_org_information7,'X') <> hr_api.g_varchar2 THEN
569: l_org_information7 := p_org_information7;
570: END IF;
571: IF NVL(p_org_information8,'X') <> hr_api.g_varchar2 THEN
572: l_org_information8 := p_org_information8;
573: END IF;
574: IF NVL(p_org_information9,'X') <> hr_api.g_varchar2 THEN
575: l_org_information9 := p_org_information9;

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

570: END IF;
571: IF NVL(p_org_information8,'X') <> hr_api.g_varchar2 THEN
572: l_org_information8 := p_org_information8;
573: END IF;
574: IF NVL(p_org_information9,'X') <> hr_api.g_varchar2 THEN
575: l_org_information9 := p_org_information9;
576: END IF;
577: IF NVL(p_org_information10,'X') <> hr_api.g_varchar2 THEN
578: l_org_information10 := p_org_information10;

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

573: END IF;
574: IF NVL(p_org_information9,'X') <> hr_api.g_varchar2 THEN
575: l_org_information9 := p_org_information9;
576: END IF;
577: IF NVL(p_org_information10,'X') <> hr_api.g_varchar2 THEN
578: l_org_information10 := p_org_information10;
579: END IF;
580: IF NVL(p_org_information11,'X') <> hr_api.g_varchar2 THEN
581: l_org_information11 := p_org_information11;

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

576: END IF;
577: IF NVL(p_org_information10,'X') <> hr_api.g_varchar2 THEN
578: l_org_information10 := p_org_information10;
579: END IF;
580: IF NVL(p_org_information11,'X') <> hr_api.g_varchar2 THEN
581: l_org_information11 := p_org_information11;
582: END IF;
583: IF NVL(p_org_information12,'X') <> hr_api.g_varchar2 THEN
584: l_org_information12 := p_org_information12;

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

579: END IF;
580: IF NVL(p_org_information11,'X') <> hr_api.g_varchar2 THEN
581: l_org_information11 := p_org_information11;
582: END IF;
583: IF NVL(p_org_information12,'X') <> hr_api.g_varchar2 THEN
584: l_org_information12 := p_org_information12;
585: END IF;
586: IF NVL(p_org_information13,'X') <> hr_api.g_varchar2 THEN
587: l_org_information13 := p_org_information13;

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

582: END IF;
583: IF NVL(p_org_information12,'X') <> hr_api.g_varchar2 THEN
584: l_org_information12 := p_org_information12;
585: END IF;
586: IF NVL(p_org_information13,'X') <> hr_api.g_varchar2 THEN
587: l_org_information13 := p_org_information13;
588: END IF;
589: IF NVL(p_org_information14,'X') <> hr_api.g_varchar2 THEN
590: l_org_information14 := p_org_information14;

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

585: END IF;
586: IF NVL(p_org_information13,'X') <> hr_api.g_varchar2 THEN
587: l_org_information13 := p_org_information13;
588: END IF;
589: IF NVL(p_org_information14,'X') <> hr_api.g_varchar2 THEN
590: l_org_information14 := p_org_information14;
591: END IF;
592: IF NVL(p_org_information15,'X') <> hr_api.g_varchar2 THEN
593: l_org_information15 := p_org_information15;

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

588: END IF;
589: IF NVL(p_org_information14,'X') <> hr_api.g_varchar2 THEN
590: l_org_information14 := p_org_information14;
591: END IF;
592: IF NVL(p_org_information15,'X') <> hr_api.g_varchar2 THEN
593: l_org_information15 := p_org_information15;
594: END IF;
595: IF NVL(p_org_information16,'X') <> hr_api.g_varchar2 THEN
596: l_org_information16 := p_org_information16;

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

591: END IF;
592: IF NVL(p_org_information15,'X') <> hr_api.g_varchar2 THEN
593: l_org_information15 := p_org_information15;
594: END IF;
595: IF NVL(p_org_information16,'X') <> hr_api.g_varchar2 THEN
596: l_org_information16 := p_org_information16;
597: END IF;
598: IF NVL(p_org_information17,'X') <> hr_api.g_varchar2 THEN
599: l_org_information17 := p_org_information17;

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

594: END IF;
595: IF NVL(p_org_information16,'X') <> hr_api.g_varchar2 THEN
596: l_org_information16 := p_org_information16;
597: END IF;
598: IF NVL(p_org_information17,'X') <> hr_api.g_varchar2 THEN
599: l_org_information17 := p_org_information17;
600: END IF;
601: IF NVL(p_org_information18,'X') <> hr_api.g_varchar2 THEN
602: l_org_information18 := p_org_information18;

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

597: END IF;
598: IF NVL(p_org_information17,'X') <> hr_api.g_varchar2 THEN
599: l_org_information17 := p_org_information17;
600: END IF;
601: IF NVL(p_org_information18,'X') <> hr_api.g_varchar2 THEN
602: l_org_information18 := p_org_information18;
603: END IF;
604: IF NVL(p_org_information19,'X') <> hr_api.g_varchar2 THEN
605: l_org_information19 := p_org_information19;

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

600: END IF;
601: IF NVL(p_org_information18,'X') <> hr_api.g_varchar2 THEN
602: l_org_information18 := p_org_information18;
603: END IF;
604: IF NVL(p_org_information19,'X') <> hr_api.g_varchar2 THEN
605: l_org_information19 := p_org_information19;
606: END IF;
607: IF NVL(p_org_information20,'X') <> hr_api.g_varchar2 THEN
608: l_org_information20 := p_org_information20;

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

603: END IF;
604: IF NVL(p_org_information19,'X') <> hr_api.g_varchar2 THEN
605: l_org_information19 := p_org_information19;
606: END IF;
607: IF NVL(p_org_information20,'X') <> hr_api.g_varchar2 THEN
608: l_org_information20 := p_org_information20;
609: END IF;
610:
611: -- Call check_sg_org_internal