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_RT_INFO

Line 196: IEO_SVR_RT_INFO rt_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,
196: IEO_SVR_RT_INFO rt_table
197: WHERE
198: (type_table.TYPE_UUID = P_SERVER_TYPE_UUID) AND
199: (type_table.TYPE_ID = svr_table.TYPE_ID) AND
200: (svr_table.MEMBER_SVR_GROUP_ID = P_GROUP_ID) AND

Line 347: IEO_SVR_RT_INFO rt_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,
347: IEO_SVR_RT_INFO rt_table
348: WHERE
349: (type_table.TYPE_UUID = P_SERVER_TYPE_UUID) AND
350: (type_table.TYPE_ID = svr_table.TYPE_ID) AND
351: (svr_table.MEMBER_SVR_GROUP_ID = P_GROUP_ID) AND

Line 760: UPDATE IEO_SVR_RT_INFO

756:
757: SAVEPOINT start_update;
758:
759:
760: UPDATE IEO_SVR_RT_INFO
761: SET
762: STATUS = P_STATUS,
763: NODE_ID = P_NODE_ID,
764: MAJOR_LOAD_FACTOR = P_MAJOR_LOAD_FACTOR,

Line 774: INSERT INTO IEO_SVR_RT_INFO

770:
771:
772: IF (SQL%NOTFOUND OR (SQL%ROWCOUNT <= 0)) THEN
773:
774: INSERT INTO IEO_SVR_RT_INFO
775: ( SERVER_ID,
776: STATUS,
777: NODE_ID,
778: MAJOR_LOAD_FACTOR,

Line 830: UPDATE IEO_SVR_RT_INFO

826:
827: SAVEPOINT start_update;
828:
829:
830: UPDATE IEO_SVR_RT_INFO
831: SET
832: STATUS = P_STATUS,
833: NODE_ID = P_NODE_ID,
834: EXTRA = P_EXTRA,

Line 842: INSERT INTO IEO_SVR_RT_INFO

838:
839:
840: IF (SQL%NOTFOUND OR (SQL%ROWCOUNT <= 0)) THEN
841:
842: INSERT INTO IEO_SVR_RT_INFO
843: ( SERVER_ID,
844: STATUS,
845: NODE_ID,
846: EXTRA,

Line 890: UPDATE IEO_SVR_RT_INFO

886:
887: SAVEPOINT start_update;
888:
889:
890: UPDATE IEO_SVR_RT_INFO
891: SET
892: STATUS = P_STATUS,
893: MAJOR_LOAD_FACTOR = P_MAJOR_LOAD_FACTOR,
894: MINOR_LOAD_FACTOR = P_MINOR_LOAD_FACTOR,

Line 903: INSERT INTO IEO_SVR_RT_INFO

899:
900:
901: IF (SQL%NOTFOUND OR (SQL%ROWCOUNT <= 0)) THEN
902:
903: INSERT INTO IEO_SVR_RT_INFO
904: ( SERVER_ID,
905: STATUS,
906: MAJOR_LOAD_FACTOR,
907: MINOR_LOAD_FACTOR,

Line 956: UPDATE IEO_SVR_RT_INFO

952:
953: SAVEPOINT start_update;
954:
955:
956: UPDATE IEO_SVR_RT_INFO
957: SET
958: STATUS = P_STATUS,
959: EXTRA = P_EXTRA,
960: LAST_UPDATE_DATE = SYSDATE

Line 967: INSERT INTO IEO_SVR_RT_INFO

963:
964:
965: IF (SQL%NOTFOUND OR (SQL%ROWCOUNT <= 0)) THEN
966:
967: INSERT INTO IEO_SVR_RT_INFO
968: ( SERVER_ID,
969: STATUS,
970: EXTRA,
971: LAST_UPDATE_DATE )

Line 1002: rt_major_load_min IEO_SVR_RT_INFO.MAJOR_LOAD_FACTOR%TYPE;

998: ,P_TIMEOUT_TOLERANCE IN NUMBER
999: )
1000: AS
1001:
1002: rt_major_load_min IEO_SVR_RT_INFO.MAJOR_LOAD_FACTOR%TYPE;
1003: rt_major_load_max IEO_SVR_RT_INFO.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;

Line 1003: rt_major_load_max IEO_SVR_RT_INFO.MAJOR_LOAD_FACTOR%TYPE;

999: )
1000: AS
1001:
1002: rt_major_load_min IEO_SVR_RT_INFO.MAJOR_LOAD_FACTOR%TYPE;
1003: rt_major_load_max IEO_SVR_RT_INFO.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:

Line 1005: rt_minor_load_min IEO_SVR_RT_INFO.MINOR_LOAD_FACTOR%TYPE;

1001:
1002: rt_major_load_min IEO_SVR_RT_INFO.MAJOR_LOAD_FACTOR%TYPE;
1003: rt_major_load_max IEO_SVR_RT_INFO.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;

Line 1006: rt_minor_load_max IEO_SVR_RT_INFO.MINOR_LOAD_FACTOR%TYPE;

1002: rt_major_load_min IEO_SVR_RT_INFO.MAJOR_LOAD_FACTOR%TYPE;
1003: rt_major_load_max IEO_SVR_RT_INFO.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:

Line 1100: IEO_SVR_RT_INFO rt_table

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
1104: (svr_table.SERVER_ID <> l_exclude_server_id) AND

Line 1152: IEO_SVR_RT_INFO rt_table

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
1156: (svr_table.SERVER_ID <> l_exclude_server_id) AND

Line 1220: IEO_SVR_RT_INFO rt_table

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
1224: (svr_table.SERVER_ID <> l_exclude_server_id) AND

Line 1275: IEO_SVR_RT_INFO rt_table

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
1279: (svr_table.SERVER_ID <> l_exclude_server_id) AND

Line 1344: rt_major_load_min IEO_SVR_RT_INFO.MAJOR_LOAD_FACTOR%TYPE;

1340: ,P_TIMEOUT_TOLERANCE IN NUMBER
1341: )
1342: AS
1343:
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;

Line 1345: rt_major_load_max IEO_SVR_RT_INFO.MAJOR_LOAD_FACTOR%TYPE;

1341: )
1342: AS
1343:
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:

Line 1433: IEO_SVR_RT_INFO rt_table

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
1437: (svr_table.SERVER_ID <> l_exclude_server_id) AND

Line 1485: IEO_SVR_RT_INFO rt_table

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
1489: (svr_table.SERVER_ID <> l_exclude_server_id) AND

Line 1537: IEO_SVR_RT_INFO rt_table

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
1541: (svr_table.SERVER_ID <> l_exclude_server_id) AND

Line 1603: rt_minor_load_min IEO_SVR_RT_INFO.MINOR_LOAD_FACTOR%TYPE;

1599: ,X_SERVER_ID OUT NOCOPY NUMBER
1600: ,P_TIMEOUT_TOLERANCE IN NUMBER
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;

Line 1604: rt_minor_load_max IEO_SVR_RT_INFO.MINOR_LOAD_FACTOR%TYPE;

1600: ,P_TIMEOUT_TOLERANCE IN NUMBER
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:

Line 1690: IEO_SVR_RT_INFO rt_table

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
1694: (svr_table.SERVER_ID <> l_exclude_server_id) AND

Line 1741: IEO_SVR_RT_INFO rt_table

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
1745: (svr_table.SERVER_ID <> l_exclude_server_id) AND

Line 1796: IEO_SVR_RT_INFO rt_table

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
1800: (svr_table.SERVER_ID <> l_exclude_server_id) AND

Line 2345: FROM IEO_SVR_RT_INFO

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
2345: FROM IEO_SVR_RT_INFO
2346: WHERE SERVER_ID = p_server_id;
2347:
2348: --dbms_output.put_line('sysdate= ' || l_sysdate);
2349: --dbms_output.put_line('last_update_date ' || l_last_update_date);