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_PERUSEO1_XMLP_PKG dependencies on HR_LOCATION_EXTRA_INFO

Line 95: HR_LOCATION_EXTRA_INFO HLEI1,

91: SELECT
92: null
93: INTO L_DUMMY
94: FROM
95: HR_LOCATION_EXTRA_INFO HLEI1,
96: HR_LOCATION_EXTRA_INFO HLEI2,
97: PER_GEN_HIERARCHY_NODES PGN,
98: HR_LOCATIONS_ALL ELOC
99: WHERE PGN.HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID

Line 96: HR_LOCATION_EXTRA_INFO HLEI2,

92: null
93: INTO L_DUMMY
94: FROM
95: HR_LOCATION_EXTRA_INFO HLEI1,
96: HR_LOCATION_EXTRA_INFO HLEI2,
97: PER_GEN_HIERARCHY_NODES PGN,
98: HR_LOCATIONS_ALL ELOC
99: WHERE PGN.HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
100: AND PGN.NODE_TYPE = 'EST'

Line 124: HR_LOCATION_EXTRA_INFO HLEI1,

120: ELOC.LOCATION_ID,
121: ELOC.LOCATION_CODE
122: INTO L_LOCATION_ID,L_LOCATION_CODE
123: FROM
124: HR_LOCATION_EXTRA_INFO HLEI1,
125: PER_GEN_HIERARCHY_NODES PGN,
126: HR_LOCATIONS_ALL ELOC
127: WHERE PGN.HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
128: AND PGN.NODE_TYPE = 'EST'

Line 164: HR_LOCATION_EXTRA_INFO HLEI1,

160: ELOC.LOCATION_ID,
161: ELOC.LOCATION_CODE
162: INTO L_DUMMY,L_LOCATION_ID,L_LOCATION_CODE
163: FROM
164: HR_LOCATION_EXTRA_INFO HLEI1,
165: PER_GEN_HIERARCHY_NODES PGN,
166: HR_LOCATIONS_ALL ELOC
167: WHERE PGN.HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
168: AND PGN.NODE_TYPE = 'EST'

Line 188: HR_LOCATION_EXTRA_INFO

184: SELECT
185: 2
186: INTO L_DUMMY
187: FROM
188: HR_LOCATION_EXTRA_INFO
189: WHERE LEI_INFORMATION1 = CP_PREV_YEAR_FILED
190: AND LEI_INFORMATION_CATEGORY = 'EEO-1 Archive Information';
191: EXCEPTION
192: WHEN NO_DATA_FOUND THEN

Line 414: HR_LOCATION_EXTRA_INFO HLEI,

410: ,C_DEF_ACTIV_3),
411: NVL(HLEI.LEI_INFORMATION8
412: ,C_DEF_ACTIV_4)
413: FROM
414: HR_LOCATION_EXTRA_INFO HLEI,
415: PER_GEN_HIERARCHY_NODES PGHN
416: WHERE HLEI.INFORMATION_TYPE = 'EEO-1 Specific Information'
417: AND HLEI.LEI_INFORMATION_CATEGORY = 'EEO-1 Specific Information'
418: AND HLEI.LOCATION_ID = PGHN.ENTITY_ID

Line 568: HR_LOCATION_EXTRA_INFO LEI

564: TO_NUMBER((LEI_INFORMATION4 + LEI_INFORMATION5 + LEI_INFORMATION6 + LEI_INFORMATION7 + LEI_INFORMATION8 + LEI_INFORMATION14 + LEI_INFORMATION16)) TOTALMALE,
565: TO_NUMBER((LEI_INFORMATION9 + LEI_INFORMATION10 + LEI_INFORMATION11 + LEI_INFORMATION12 + LEI_INFORMATION13 + LEI_INFORMATION15 + LEI_INFORMATION17)) TOTALFEM
566: INTO HW_AUD_TOT,HW_AUD_MALE,HW_AUD_FEMALE
567: FROM
568: HR_LOCATION_EXTRA_INFO LEI
569: WHERE LEI_INFORMATION1 = CP_PREV_YEAR_FILED
570: AND TO_CHAR(LEI.LOCATION_ID) in (
571: SELECT
572: DISTINCT

Line 707: HR_LOCATION_EXTRA_INFO

703: 'U',
704: LOCATION_EXTRA_INFO_ID
705: INTO P_UPDATE,L_LOCATION_EXTRA_INFO_ID
706: FROM
707: HR_LOCATION_EXTRA_INFO
708: WHERE LEI_INFORMATION1 = P_REPORT_YEAR
709: AND LEI_INFORMATION_CATEGORY = 'EEO-1 Archive Information'
710: AND LOCATION_ID = L_LOCATION_ID;
711: EXCEPTION

Line 731: HR_LOCATION_EXTRA_INFO

727: SELECT
728: OBJECT_VERSION_NUMBER
729: INTO L_OBJECT_VERSION_NUMBER
730: FROM
731: HR_LOCATION_EXTRA_INFO
732: WHERE LOCATION_EXTRA_INFO_ID = L_LOCATION_EXTRA_INFO_ID;
733: END;
734: /*SRW.MESSAGE('25'
735: ,'object version number to delete for update is ' || L_OBJECT_VERSION_NUMBER)*/NULL;

Line 737: HR_LOCATION_EXTRA_INFO_API.DELETE_LOCATION_EXTRA_INFO(P_VALIDATE => FALSE

733: END;
734: /*SRW.MESSAGE('25'
735: ,'object version number to delete for update is ' || L_OBJECT_VERSION_NUMBER)*/NULL;
736: BEGIN
737: HR_LOCATION_EXTRA_INFO_API.DELETE_LOCATION_EXTRA_INFO(P_VALIDATE => FALSE
738: ,P_LOCATION_EXTRA_INFO_ID => L_LOCATION_EXTRA_INFO_ID
739: ,P_OBJECT_VERSION_NUMBER => L_OBJECT_VERSION_NUMBER);
740: END;
741: COMMIT;

Line 750: HR_LOCATION_EXTRA_INFO_API.CREATE_LOCATION_EXTRA_INFO(P_VALIDATE => FALSE

746: ,'p_update ' || P_UPDATE || ' location_id ' || L_LOCATION_ID)*/NULL;
747: /*SRW.MESSAGE('22'
748: ,'need to create new eit')*/NULL;
749: BEGIN
750: HR_LOCATION_EXTRA_INFO_API.CREATE_LOCATION_EXTRA_INFO(P_VALIDATE => FALSE
751: ,P_LOCATION_ID => L_LOCATION_ID
752: ,P_INFORMATION_TYPE => 'EEO-1 Archive Information'
753: ,P_LEI_INFORMATION_CATEGORY => 'EEO-1 Archive Information'
754: ,P_LEI_INFORMATION1 => P_REPORT_YEAR

Line 794: HR_LOCATION_EXTRA_INFO LEI

790: SELECT
791: count(*)
792: INTO L_EIT_COUNT
793: FROM
794: HR_LOCATION_EXTRA_INFO LEI
795: WHERE LOCATION_ID = L_LOCATION_ID
796: AND INFORMATION_TYPE = 'EEO-1 Archive Information';
797: EXCEPTION
798: WHEN NO_DATA_FOUND THEN

Line 809: HR_LOCATION_EXTRA_INFO LEI

805: SELECT
806: MIN(LEI_INFORMATION1)
807: INTO L_MIN_YEAR
808: FROM
809: HR_LOCATION_EXTRA_INFO LEI
810: WHERE LOCATION_ID = L_LOCATION_ID
811: AND INFORMATION_TYPE = 'EEO-1 Archive Information';
812: END;
813: BEGIN

Line 819: HR_LOCATION_EXTRA_INFO LEI

815: LOCATION_EXTRA_INFO_ID,
816: OBJECT_VERSION_NUMBER
817: INTO L_LOCATION_EXTRA_INFO_ID,L_OBJECT_VERSION_NUMBER
818: FROM
819: HR_LOCATION_EXTRA_INFO LEI
820: WHERE LEI_INFORMATION1 = L_MIN_YEAR
821: AND INFORMATION_TYPE = 'EEO-1 Archive Information'
822: AND LOCATION_ID = L_LOCATION_ID;
823: END;

Line 825: HR_LOCATION_EXTRA_INFO_API.DELETE_LOCATION_EXTRA_INFO(P_VALIDATE => FALSE

821: AND INFORMATION_TYPE = 'EEO-1 Archive Information'
822: AND LOCATION_ID = L_LOCATION_ID;
823: END;
824: BEGIN
825: HR_LOCATION_EXTRA_INFO_API.DELETE_LOCATION_EXTRA_INFO(P_VALIDATE => FALSE
826: ,P_LOCATION_EXTRA_INFO_ID => L_LOCATION_EXTRA_INFO_ID
827: ,P_OBJECT_VERSION_NUMBER => L_OBJECT_VERSION_NUMBER);
828: END;
829: /*SRW.MESSAGE('999999'