DBA Data[Home] [Help]

APPS.IEO_SVR_UTIL_PVT dependencies on IEO_SVR_PROTOCOL_MAP

Line 195: IEO_SVR_PROTOCOL_MAP prot_table,

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
197: WHERE
198: (type_table.TYPE_UUID = P_SERVER_TYPE_UUID) AND
199: (type_table.TYPE_ID = svr_table.TYPE_ID) AND

Line 346: IEO_SVR_PROTOCOL_MAP prot_table,

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
348: WHERE
349: (type_table.TYPE_UUID = P_SERVER_TYPE_UUID) AND
350: (type_table.TYPE_ID = svr_table.TYPE_ID) AND

Line 1969: IEO_SVR_PROTOCOL_MAP prot_table

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
1971: (svr_table.SERVER_ID = comp_table.SERVER_ID) AND
1972: (svr_table.SERVER_ID = x_server_id_found) AND
1973: (comp_table.COMP_DEF_ID = cdef_table.COMP_DEF_ID) AND

Line 2003: IEO_SVR_PROTOCOL_MAP prot_table

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
2005: (svr_table.SERVER_ID = x_server_id_found) AND
2006: (svr_table.SERVER_ID = comp_table.SERVER_ID) AND
2007: (comp_table.COMP_DEF_ID = cdef_table.COMP_DEF_ID) AND

Line 2097: IEO_SVR_PROTOCOL_MAP prot_table

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
2099: (svr_table.SERVER_ID = comp_table.SERVER_ID) AND
2100: (svr_table.SERVER_ID = x_server_id_found) AND
2101: (comp_table.COMP_DEF_ID = cdef_table.COMP_DEF_ID) AND

Line 2144: IEO_SVR_PROTOCOL_MAP prot_table

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
2146: (svr_table.SERVER_ID = x_server_id_found) AND
2147: (svr_table.SERVER_ID = comp_table.SERVER_ID) AND
2148: (comp_table.COMP_DEF_ID = cdef_table.COMP_DEF_ID) AND

Line 2228: FROM IEO_SVR_COMPS A, IEO_SVR_PROTOCOL_MAP B

2224: SERVER_TYPE_ID = p_server_type_id;
2225:
2226: SELECT A.COMP_ID, A.COMP_NAME, B.WIRE_PROTOCOL, B.PORT
2227: into x_comp_id, x_comp_name, x_wire_protocol, x_port
2228: FROM IEO_SVR_COMPS A, IEO_SVR_PROTOCOL_MAP B
2229: WHERE A.COMP_ID = B.COMP_ID
2230: AND A.COMP_DEF_ID = l_comp_def_id
2231: AND A.SERVER_ID = p_server_id;
2232: