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 236: HR_LOCATION_EXTRA_INFO HLEI1,

232: SELECT
233: null
234: INTO L_DUMMY
235: FROM
236: HR_LOCATION_EXTRA_INFO HLEI1,
237: HR_LOCATION_EXTRA_INFO HLEI2,
238: PER_GEN_HIERARCHY_NODES PGN,
239: HR_LOCATIONS_ALL ELOC
240: WHERE PGN.HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID

Line 237: HR_LOCATION_EXTRA_INFO HLEI2,

233: null
234: INTO L_DUMMY
235: FROM
236: HR_LOCATION_EXTRA_INFO HLEI1,
237: HR_LOCATION_EXTRA_INFO HLEI2,
238: PER_GEN_HIERARCHY_NODES PGN,
239: HR_LOCATIONS_ALL ELOC
240: WHERE PGN.HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
241: AND PGN.NODE_TYPE = 'EST'

Line 265: HR_LOCATION_EXTRA_INFO HLEI1,

261: ELOC.LOCATION_ID,
262: ELOC.LOCATION_CODE
263: INTO L_LOCATION_ID,L_LOCATION_CODE
264: FROM
265: HR_LOCATION_EXTRA_INFO HLEI1,
266: PER_GEN_HIERARCHY_NODES PGN,
267: HR_LOCATIONS_ALL ELOC
268: WHERE PGN.HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
269: AND PGN.NODE_TYPE = 'EST'

Line 305: HR_LOCATION_EXTRA_INFO HLEI1,

301: ELOC.LOCATION_ID,
302: ELOC.LOCATION_CODE
303: INTO L_DUMMY,L_LOCATION_ID,L_LOCATION_CODE
304: FROM
305: HR_LOCATION_EXTRA_INFO HLEI1,
306: PER_GEN_HIERARCHY_NODES PGN,
307: HR_LOCATIONS_ALL ELOC
308: WHERE PGN.HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
309: AND PGN.NODE_TYPE = 'EST'

Line 329: HR_LOCATION_EXTRA_INFO

325: SELECT
326: 2
327: INTO L_DUMMY
328: FROM
329: HR_LOCATION_EXTRA_INFO
330: WHERE LEI_INFORMATION1 = CP_PREV_YEAR_FILED
331: AND LEI_INFORMATION_CATEGORY = 'EEO-1 Archive Information';
332: EXCEPTION
333: WHEN NO_DATA_FOUND THEN

Line 647: HR_LOCATION_EXTRA_INFO HLEI,

643: ,C_DEF_ACTIV_3),
644: NVL(HLEI.LEI_INFORMATION8
645: ,C_DEF_ACTIV_4)
646: FROM
647: HR_LOCATION_EXTRA_INFO HLEI,
648: PER_GEN_HIERARCHY_NODES PGHN
649: WHERE HLEI.INFORMATION_TYPE = 'EEO-1 Specific Information'
650: AND HLEI.LEI_INFORMATION_CATEGORY = 'EEO-1 Specific Information'
651: AND HLEI.LOCATION_ID = PGHN.ENTITY_ID

Line 871: HR_LOCATION_EXTRA_INFO LEI

867: TO_NUMBER((LEI_INFORMATION4 + LEI_INFORMATION5 + LEI_INFORMATION6 + LEI_INFORMATION7 + LEI_INFORMATION8 + LEI_INFORMATION14 + LEI_INFORMATION16)) TOTALMALE,
868: TO_NUMBER((LEI_INFORMATION9 + LEI_INFORMATION10 + LEI_INFORMATION11 + LEI_INFORMATION12 + LEI_INFORMATION13 + LEI_INFORMATION15 + LEI_INFORMATION17)) TOTALFEM
869: INTO HW_AUD_TOT,HW_AUD_MALE,HW_AUD_FEMALE
870: FROM
871: HR_LOCATION_EXTRA_INFO LEI
872: WHERE LEI_INFORMATION1 = CP_PREV_YEAR_FILED
873: AND TO_CHAR(LEI.LOCATION_ID) in (
874: SELECT
875: DISTINCT

Line 1088: HR_LOCATION_EXTRA_INFO

1084: 'U',
1085: LOCATION_EXTRA_INFO_ID
1086: INTO P_UPDATE,L_LOCATION_EXTRA_INFO_ID
1087: FROM
1088: HR_LOCATION_EXTRA_INFO
1089: WHERE LEI_INFORMATION1 = P_REPORT_YEAR
1090: AND LEI_INFORMATION_CATEGORY = 'EEO-1 Archive Information'
1091: AND LOCATION_ID = L_LOCATION_ID;
1092: EXCEPTION

Line 1112: HR_LOCATION_EXTRA_INFO

1108: SELECT
1109: OBJECT_VERSION_NUMBER
1110: INTO L_OBJECT_VERSION_NUMBER
1111: FROM
1112: HR_LOCATION_EXTRA_INFO
1113: WHERE LOCATION_EXTRA_INFO_ID = L_LOCATION_EXTRA_INFO_ID;
1114: END;
1115: /*SRW.MESSAGE('25'
1116: ,'object version number to delete for update is ' || L_OBJECT_VERSION_NUMBER)*/NULL;

Line 1118: HR_LOCATION_EXTRA_INFO_API.DELETE_LOCATION_EXTRA_INFO(P_VALIDATE => FALSE

1114: END;
1115: /*SRW.MESSAGE('25'
1116: ,'object version number to delete for update is ' || L_OBJECT_VERSION_NUMBER)*/NULL;
1117: BEGIN
1118: HR_LOCATION_EXTRA_INFO_API.DELETE_LOCATION_EXTRA_INFO(P_VALIDATE => FALSE
1119: ,P_LOCATION_EXTRA_INFO_ID => L_LOCATION_EXTRA_INFO_ID
1120: ,P_OBJECT_VERSION_NUMBER => L_OBJECT_VERSION_NUMBER);
1121: END;
1122: COMMIT;

Line 1131: HR_LOCATION_EXTRA_INFO_API.CREATE_LOCATION_EXTRA_INFO(P_VALIDATE => FALSE

1127: ,'p_update ' || P_UPDATE || ' location_id ' || L_LOCATION_ID)*/NULL;
1128: /*SRW.MESSAGE('22'
1129: ,'need to create new eit')*/NULL;
1130: BEGIN
1131: HR_LOCATION_EXTRA_INFO_API.CREATE_LOCATION_EXTRA_INFO(P_VALIDATE => FALSE
1132: ,P_LOCATION_ID => L_LOCATION_ID
1133: ,P_INFORMATION_TYPE => 'EEO-1 Archive Information'
1134: ,P_LEI_INFORMATION_CATEGORY => 'EEO-1 Archive Information'
1135: ,P_LEI_INFORMATION1 => P_REPORT_YEAR

Line 1175: HR_LOCATION_EXTRA_INFO LEI

1171: SELECT
1172: count(*)
1173: INTO L_EIT_COUNT
1174: FROM
1175: HR_LOCATION_EXTRA_INFO LEI
1176: WHERE LOCATION_ID = L_LOCATION_ID
1177: AND INFORMATION_TYPE = 'EEO-1 Archive Information';
1178: EXCEPTION
1179: WHEN NO_DATA_FOUND THEN

Line 1190: HR_LOCATION_EXTRA_INFO LEI

1186: SELECT
1187: MIN(LEI_INFORMATION1)
1188: INTO L_MIN_YEAR
1189: FROM
1190: HR_LOCATION_EXTRA_INFO LEI
1191: WHERE LOCATION_ID = L_LOCATION_ID
1192: AND INFORMATION_TYPE = 'EEO-1 Archive Information';
1193: END;
1194: BEGIN

Line 1200: HR_LOCATION_EXTRA_INFO LEI

1196: LOCATION_EXTRA_INFO_ID,
1197: OBJECT_VERSION_NUMBER
1198: INTO L_LOCATION_EXTRA_INFO_ID,L_OBJECT_VERSION_NUMBER
1199: FROM
1200: HR_LOCATION_EXTRA_INFO LEI
1201: WHERE LEI_INFORMATION1 = L_MIN_YEAR
1202: AND INFORMATION_TYPE = 'EEO-1 Archive Information'
1203: AND LOCATION_ID = L_LOCATION_ID;
1204: END;

Line 1206: HR_LOCATION_EXTRA_INFO_API.DELETE_LOCATION_EXTRA_INFO(P_VALIDATE => FALSE

1202: AND INFORMATION_TYPE = 'EEO-1 Archive Information'
1203: AND LOCATION_ID = L_LOCATION_ID;
1204: END;
1205: BEGIN
1206: HR_LOCATION_EXTRA_INFO_API.DELETE_LOCATION_EXTRA_INFO(P_VALIDATE => FALSE
1207: ,P_LOCATION_EXTRA_INFO_ID => L_LOCATION_EXTRA_INFO_ID
1208: ,P_OBJECT_VERSION_NUMBER => L_OBJECT_VERSION_NUMBER);
1209: END;
1210: /*SRW.MESSAGE('999999'