APPS.IEU_PVT dependencies on IEO_SVR_SERVERS

Line 393: IEO_SVR_SERVERS svrtab,

389: -- sjm got rid of server side checks altogether for Client Provider enh.
390: -- this is simpler and more flexible for 3rd party providers
391: -- now just check for all media types that have media provider plugins defined
392: /* JTF_RS_RESOURCE_EXTNS restab,
393: IEO_SVR_SERVERS svrtab,
394: IEO_SVR_SERVERS svrtab2,
395: IEU_UWQ_SVR_MPS_MMAPS mmptab,
396: IEU_UWQ_MEDIA_TYPES_B mttab
397: WHERE

Line 394: IEO_SVR_SERVERS svrtab2,

390: -- this is simpler and more flexible for 3rd party providers
391: -- now just check for all media types that have media provider plugins defined
392: /* JTF_RS_RESOURCE_EXTNS restab,
393: IEO_SVR_SERVERS svrtab,
394: IEO_SVR_SERVERS svrtab2,
395: IEU_UWQ_SVR_MPS_MMAPS mmptab,
396: IEU_UWQ_MEDIA_TYPES_B mttab
397: WHERE
398: (restab.RESOURCE_ID = p_resource_id) AND

Line 1517: l_server_id IEO_SVR_SERVERS.SERVER_ID%TYPE;

1513: ,X_HEART_RATE OUT NOCOPY NUMBER
1514: )
1515: AS
1516:
1517: l_server_id IEO_SVR_SERVERS.SERVER_ID%TYPE;
1518: l_server_group_id IEO_SVR_GROUPS.SERVER_GROUP_ID%TYPE;
1519:
1520: l_last_update_secs PLS_INTEGER;
1521: l_curr_time_secs PLS_INTEGER;

Line 1590: IEO_SVR_SERVERS srvrs,

1586: INTO
1587: l_server_id
1588: FROM
1589: IEU_UWQ_AGENT_BINDINGS binds,
1590: IEO_SVR_SERVERS srvrs,
1591: IEO_SVR_RT_INFO rti
1592: WHERE
1593: (binds.RESOURCE_ID = P_RESOURCE_ID) AND
1594: (binds.SERVER_ID = srvrs.SERVER_ID) AND

Line 1629: IEO_SVR_SERVERS srvrs,

1625: ((stype.RT_REFRESH_RATE * 60) + 60)
1626: INTO
1627: l_threshold_secs
1628: FROM
1629: IEO_SVR_SERVERS srvrs,
1630: IEO_SVR_TYPES_B stype
1631: WHERE
1632: (srvrs.SERVER_ID = l_server_id) AND
1633: (srvrs.TYPE_ID = stype.TYPE_ID) AND

Line 1714: IEO_SVR_SERVERS svr_table,

1710: comp_table.COMP_NAME
1711: INTO
1712: X_COMP_NAME
1713: FROM
1714: IEO_SVR_SERVERS svr_table,
1715: IEO_SVR_COMP_DEFS cdef_table,
1716: IEO_SVR_COMPS comp_table,
1717: IEO_SVR_PROTOCOL_MAP prot_table
1718: WHERE

Line 1747: IEO_SVR_SERVERS svr_table,

1743: X_SVR_DNS_NAME,
1744: X_SVR_IP_ADDRESS,
1745: X_SVR_PORT
1746: FROM
1747: IEO_SVR_SERVERS svr_table,
1748: IEO_SVR_COMP_DEFS cdef_table,
1749: IEO_SVR_COMPS comp_table,
1750: IEO_SVR_PROTOCOL_MAP prot_table
1751: WHERE

Line 1809: IEO_SVR_SERVERS srvrs

1805: SELECT
1806: ab.SERVER_ID
1807: FROM
1808: IEU_UWQ_AGENT_BINDINGS ab,
1809: IEO_SVR_SERVERS srvrs
1810: WHERE
1811: ab.RESOURCE_ID = P_RESOURCE_ID AND
1812: ab.SERVER_ID = srvrs.SERVER_ID AND
1813: srvrs.TYPE_ID = svr_type_id;

Line 1837: IEO_SVR_SERVERS

1833: TYPE_ID
1834: INTO
1835: l_svr_type_id
1836: FROM
1837: IEO_SVR_SERVERS
1838: WHERE
1839: SERVER_ID = P_SERVER_ID;
1840:
1841:

Line 1989: UPDATE IEO_SVR_SERVERS

1985: /*clear all old server bindings*/
1986: IEO_SVR_UTIL_PVT.CLEAR_SERVER_BINDINGS( P_SERVER_ID );
1987:
1988: /*update server information*/
1989: UPDATE IEO_SVR_SERVERS
1990: SET DNS_NAME = P_DNS_NAME,
1991: IP_ADDRESS = P_IP_ADDRESS,
1992: USER_ADDRESS = P_USER_ADDRESS
1993: WHERE SERVER_ID = P_SERVER_ID;

Line 2038: ' ieo_svr_servers svrs ' ||

2034: */
2035: l_binding_statement := 'SELECT bindings.server_id, svr_types.type_id FROM ' ||
2036: ' ieu_uwq_agent_bindings bindings, ' ||
2037: ' ieo_svr_types_b svr_types, ' ||
2038: ' ieo_svr_servers svrs ' ||
2039: ' WHERE bindings.resource_id = :1 ' ||
2040: ' AND bindings.server_id=svrs.server_id ' ||
2041: ' AND svr_types.type_id = svrs.type_id ' ||
2042: ' AND bindings.NOT_VALID IS NULL';