[Home] [Help]
132: NVL( svr_table.USING_SVR_GROUP_ID, svr_table.MEMBER_SVR_GROUP_ID )
133: INTO
134: v_all_group_ids(counter)
135: FROM
136: IEO_SVR_SERVERS svr_table
137: WHERE
138: (svr_table.SERVER_ID = P_SERVER_ID_LOOKING) AND
139: (ROWNUM <= 1);
140:
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,
196: IEO_SVR_RT_INFO rt_table
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,
347: IEO_SVR_RT_INFO rt_table
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);
1014: l_refresh_rate_secs NUMBER(5);
1015:
1094: rt_major_load_max,
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
1146: svr_table.SERVER_ID
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
1214: svr_table.SERVER_ID
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
1269: svr_table.SERVER_ID
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
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);
1353: l_refresh_rate_secs NUMBER(5);
1354:
1427: INTO
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
1479: svr_table.SERVER_ID
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
1531: svr_table.SERVER_ID
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
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);
1610: l_refresh_rate_secs NUMBER(5);
1611:
1684: INTO
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
1735: svr_table.SERVER_ID
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
1790: svr_table.SERVER_ID
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
1870: NVL( svr_table.USING_SVR_GROUP_ID, svr_table.MEMBER_SVR_GROUP_ID )
1871: INTO
1872: l_group_id
1873: FROM
1874: IEO_SVR_SERVERS svr_table
1875: WHERE
1876: (svr_table.SERVER_ID = P_SERVER_ID_LOOKING) AND
1877: (ROWNUM <= 1);
1878:
1962: comp_table.COMP_NAME
1963: INTO
1964: X_COMP_NAME
1965: FROM
1966: IEO_SVR_SERVERS svr_table,
1967: IEO_SVR_COMP_DEFS cdef_table,
1968: IEO_SVR_COMPS comp_table,
1969: IEO_SVR_PROTOCOL_MAP prot_table
1970: WHERE
1996: X_DNS_NAME,
1997: X_IP_ADDRESS,
1998: X_PORT
1999: FROM
2000: IEO_SVR_SERVERS svr_table,
2001: IEO_SVR_COMP_DEFS cdef_table,
2002: IEO_SVR_COMPS comp_table,
2003: IEO_SVR_PROTOCOL_MAP prot_table
2004: WHERE
2090: comp_table.COMP_NAME
2091: INTO
2092: X_COMP_NAME
2093: FROM
2094: IEO_SVR_SERVERS svr_table,
2095: IEO_SVR_COMP_DEFS cdef_table,
2096: IEO_SVR_COMPS comp_table,
2097: IEO_SVR_PROTOCOL_MAP prot_table
2098: WHERE
2137: X_DNS_NAME,
2138: X_IP_ADDRESS,
2139: X_PORT
2140: FROM
2141: IEO_SVR_SERVERS svr_table,
2142: IEO_SVR_COMP_DEFS cdef_table,
2143: IEO_SVR_COMPS comp_table,
2144: IEO_SVR_PROTOCOL_MAP prot_table
2145: WHERE
2215:
2216: -- API body
2217:
2218: select ip_address into x_ip
2219: from ieo_svr_servers where server_id = p_server_id;
2220:
2221: SELECT COMP_DEF_ID INTO l_comp_def_id FROM IEO_SVR_COMP_DEFS WHERE
2222: COMP_DEF_NAME = p_comp_def_name and
2223: COMP_DEF_VERSION = p_comp_def_version and
2356: end if;
2357: end if;
2358:
2359: select a.server_name, b.group_name into x_server_name, x_server_group_name
2360: from ieo_Svr_servers a, ieo_Svr_groups b
2361: where a.server_id = p_server_id and a.member_svr_group_id = b.server_group_id;
2362:
2363: IF FND_API.To_Boolean( p_commit ) THEN
2364: COMMIT WORK;