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.IEO_SVR_UTIL_PVT dependencies on IEO_SVR_TYPES_B

Line 12: ty_major_load_max IEO_SVR_TYPES_B.MAX_MAJOR_LOAD_FACTOR%TYPE;

8: PROCEDURE GET_SVR_TYPE_LOAD_INFO
9: (P_SERVER_TYPE_UUID IN VARCHAR2
10: )
11: AS
12: ty_major_load_max IEO_SVR_TYPES_B.MAX_MAJOR_LOAD_FACTOR%TYPE;
13: ty_minor_load_max IEO_SVR_TYPES_B.MAX_MINOR_LOAD_FACTOR%TYPE;
14: l_refresh_rate_secs NUMBER(5);
15:
16: BEGIN

Line 13: ty_minor_load_max IEO_SVR_TYPES_B.MAX_MINOR_LOAD_FACTOR%TYPE;

9: (P_SERVER_TYPE_UUID IN VARCHAR2
10: )
11: AS
12: ty_major_load_max IEO_SVR_TYPES_B.MAX_MAJOR_LOAD_FACTOR%TYPE;
13: ty_minor_load_max IEO_SVR_TYPES_B.MAX_MINOR_LOAD_FACTOR%TYPE;
14: l_refresh_rate_secs NUMBER(5);
15:
16: BEGIN
17:

Line 35: IEO_SVR_TYPES_B type_table

31: ty_major_load_max,
32: ty_minor_load_max,
33: l_refresh_rate_secs
34: FROM
35: IEO_SVR_TYPES_B type_table
36: WHERE
37: (type_table.TYPE_UUID = P_SERVER_TYPE_UUID) AND
38: (ROWNUM <= 1);
39:

Line 191: IEO_SVR_TYPES_B type_table,

187: rt_table.MAJOR_LOAD_FACTOR,
188: rt_table.MINOR_LOAD_FACTOR,
189: rt_table.LAST_UPDATE_DATE
190: FROM
191: IEO_SVR_TYPES_B type_table,
192: IEO_SVR_SERVERS svr_table,
193: IEO_SVR_COMP_DEFS cdef_table,
194: IEO_SVR_COMPS comp_table,
195: IEO_SVR_PROTOCOL_MAP prot_table,

Line 342: IEO_SVR_TYPES_B type_table,

338: rt_table.MAJOR_LOAD_FACTOR,
339: rt_table.MINOR_LOAD_FACTOR,
340: rt_table.LAST_UPDATE_DATE
341: FROM
342: IEO_SVR_TYPES_B type_table,
343: IEO_SVR_SERVERS svr_table,
344: IEO_SVR_COMP_DEFS cdef_table,
345: IEO_SVR_COMPS comp_table,
346: IEO_SVR_PROTOCOL_MAP prot_table,

Line 1008: ty_major_load_max IEO_SVR_TYPES_B.MAX_MAJOR_LOAD_FACTOR%TYPE;

1004:
1005: rt_minor_load_min IEO_SVR_RT_INFO.MINOR_LOAD_FACTOR%TYPE;
1006: rt_minor_load_max IEO_SVR_RT_INFO.MINOR_LOAD_FACTOR%TYPE;
1007:
1008: ty_major_load_max IEO_SVR_TYPES_B.MAX_MAJOR_LOAD_FACTOR%TYPE;
1009: ty_minor_load_max IEO_SVR_TYPES_B.MAX_MINOR_LOAD_FACTOR%TYPE;
1010:
1011: l_exclude_server_id IEO_SVR_SERVERS.SERVER_ID%TYPE;
1012:

Line 1009: ty_minor_load_max IEO_SVR_TYPES_B.MAX_MINOR_LOAD_FACTOR%TYPE;

1005: rt_minor_load_min IEO_SVR_RT_INFO.MINOR_LOAD_FACTOR%TYPE;
1006: rt_minor_load_max IEO_SVR_RT_INFO.MINOR_LOAD_FACTOR%TYPE;
1007:
1008: ty_major_load_max IEO_SVR_TYPES_B.MAX_MAJOR_LOAD_FACTOR%TYPE;
1009: ty_minor_load_max IEO_SVR_TYPES_B.MAX_MINOR_LOAD_FACTOR%TYPE;
1010:
1011: l_exclude_server_id IEO_SVR_SERVERS.SERVER_ID%TYPE;
1012:
1013: l_curr_time_secs NUMBER(5);

Line 1077: IEO_SVR_TYPES_B type_table

1073: ty_major_load_max,
1074: ty_minor_load_max,
1075: l_refresh_rate_secs
1076: FROM
1077: IEO_SVR_TYPES_B type_table
1078: WHERE
1079: (type_table.TYPE_UUID = P_SERVER_TYPE_UUID) AND
1080: (ROWNUM <= 1);
1081:

Line 1099: IEO_SVR_TYPES_B type_table,

1095: rt_minor_load_min,
1096: rt_minor_load_max
1097: FROM
1098: IEO_SVR_SERVERS svr_table,
1099: IEO_SVR_TYPES_B type_table,
1100: IEO_SVR_RT_INFO rt_table
1101: WHERE
1102: (svr_table.TYPE_ID = type_table.TYPE_ID) AND
1103: (svr_table.SERVER_ID = rt_table.SERVER_ID) AND

Line 1151: IEO_SVR_TYPES_B type_table,

1147: INTO
1148: X_SERVER_ID
1149: FROM
1150: IEO_SVR_SERVERS svr_table,
1151: IEO_SVR_TYPES_B type_table,
1152: IEO_SVR_RT_INFO rt_table
1153: WHERE
1154: (svr_table.TYPE_ID = type_table.TYPE_ID) AND
1155: (svr_table.SERVER_ID = rt_table.SERVER_ID) AND

Line 1219: IEO_SVR_TYPES_B type_table,

1215: INTO
1216: X_SERVER_ID
1217: FROM
1218: IEO_SVR_SERVERS svr_table,
1219: IEO_SVR_TYPES_B type_table,
1220: IEO_SVR_RT_INFO rt_table
1221: WHERE
1222: (svr_table.TYPE_ID = type_table.TYPE_ID) AND
1223: (svr_table.SERVER_ID = rt_table.SERVER_ID) AND

Line 1274: IEO_SVR_TYPES_B type_table,

1270: INTO
1271: X_SERVER_ID
1272: FROM
1273: IEO_SVR_SERVERS svr_table,
1274: IEO_SVR_TYPES_B type_table,
1275: IEO_SVR_RT_INFO rt_table
1276: WHERE
1277: (svr_table.TYPE_ID = type_table.TYPE_ID) AND
1278: (svr_table.SERVER_ID = rt_table.SERVER_ID) AND

Line 1348: ty_major_load_max IEO_SVR_TYPES_B.MAX_MAJOR_LOAD_FACTOR%TYPE;

1344: rt_major_load_min IEO_SVR_RT_INFO.MAJOR_LOAD_FACTOR%TYPE;
1345: rt_major_load_max IEO_SVR_RT_INFO.MAJOR_LOAD_FACTOR%TYPE;
1346:
1347:
1348: ty_major_load_max IEO_SVR_TYPES_B.MAX_MAJOR_LOAD_FACTOR%TYPE;
1349:
1350: l_exclude_server_id IEO_SVR_SERVERS.SERVER_ID%TYPE;
1351:
1352: l_curr_time_secs NUMBER(5);

Line 1414: IEO_SVR_TYPES_B type_table

1410: INTO
1411: ty_major_load_max,
1412: l_refresh_rate_secs
1413: FROM
1414: IEO_SVR_TYPES_B type_table
1415: WHERE
1416: (type_table.TYPE_UUID = P_SERVER_TYPE_UUID) AND
1417: (ROWNUM <= 1);
1418:

Line 1432: IEO_SVR_TYPES_B type_table,

1428: rt_major_load_min,
1429: rt_major_load_max
1430: FROM
1431: IEO_SVR_SERVERS svr_table,
1432: IEO_SVR_TYPES_B type_table,
1433: IEO_SVR_RT_INFO rt_table
1434: WHERE
1435: (svr_table.TYPE_ID = type_table.TYPE_ID) AND
1436: (svr_table.SERVER_ID = rt_table.SERVER_ID) AND

Line 1484: IEO_SVR_TYPES_B type_table,

1480: INTO
1481: X_SERVER_ID
1482: FROM
1483: IEO_SVR_SERVERS svr_table,
1484: IEO_SVR_TYPES_B type_table,
1485: IEO_SVR_RT_INFO rt_table
1486: WHERE
1487: (svr_table.TYPE_ID = type_table.TYPE_ID) AND
1488: (svr_table.SERVER_ID = rt_table.SERVER_ID) AND

Line 1536: IEO_SVR_TYPES_B type_table,

1532: INTO
1533: X_SERVER_ID
1534: FROM
1535: IEO_SVR_SERVERS svr_table,
1536: IEO_SVR_TYPES_B type_table,
1537: IEO_SVR_RT_INFO rt_table
1538: WHERE
1539: (svr_table.TYPE_ID = type_table.TYPE_ID) AND
1540: (svr_table.SERVER_ID = rt_table.SERVER_ID) AND

Line 1605: ty_minor_load_max IEO_SVR_TYPES_B.MAX_MINOR_LOAD_FACTOR%TYPE;

1601: )
1602: AS
1603: rt_minor_load_min IEO_SVR_RT_INFO.MINOR_LOAD_FACTOR%TYPE;
1604: rt_minor_load_max IEO_SVR_RT_INFO.MINOR_LOAD_FACTOR%TYPE;
1605: ty_minor_load_max IEO_SVR_TYPES_B.MAX_MINOR_LOAD_FACTOR%TYPE;
1606:
1607: l_exclude_server_id IEO_SVR_SERVERS.SERVER_ID%TYPE;
1608:
1609: l_curr_time_secs NUMBER(5);

Line 1671: IEO_SVR_TYPES_B type_table

1667: INTO
1668: ty_minor_load_max,
1669: l_refresh_rate_secs
1670: FROM
1671: IEO_SVR_TYPES_B type_table
1672: WHERE
1673: (type_table.TYPE_UUID = P_SERVER_TYPE_UUID) AND
1674: (ROWNUM <= 1);
1675:

Line 1689: IEO_SVR_TYPES_B type_table,

1685: rt_minor_load_min,
1686: rt_minor_load_max
1687: FROM
1688: IEO_SVR_SERVERS svr_table,
1689: IEO_SVR_TYPES_B type_table,
1690: IEO_SVR_RT_INFO rt_table
1691: WHERE
1692: (svr_table.TYPE_ID = type_table.TYPE_ID) AND
1693: (svr_table.SERVER_ID = rt_table.SERVER_ID) AND

Line 1740: IEO_SVR_TYPES_B type_table,

1736: INTO
1737: X_SERVER_ID
1738: FROM
1739: IEO_SVR_SERVERS svr_table,
1740: IEO_SVR_TYPES_B type_table,
1741: IEO_SVR_RT_INFO rt_table
1742: WHERE
1743: (svr_table.TYPE_ID = type_table.TYPE_ID) AND
1744: (svr_table.SERVER_ID = rt_table.SERVER_ID) AND

Line 1795: IEO_SVR_TYPES_B type_table,

1791: INTO
1792: X_SERVER_ID
1793: FROM
1794: IEO_SVR_SERVERS svr_table,
1795: IEO_SVR_TYPES_B type_table,
1796: IEO_SVR_RT_INFO rt_table
1797: WHERE
1798: (svr_table.TYPE_ID = type_table.TYPE_ID) AND
1799: (svr_table.SERVER_ID = rt_table.SERVER_ID) AND

Line 2340: FROM IEO_SVR_TYPES_B

2336: x_server_group_name := null;
2337:
2338:
2339: SELECT RT_REFRESH_RATE into l_refresh_rate
2340: FROM IEO_SVR_TYPES_B
2341: WHERE TYPE_ID = p_server_type_id;
2342:
2343: SELECT STATUS, LAST_UPDATE_DATE, SYSDATE NOW
2344: into x_server_status, l_last_update_date, l_sysdate