APPS.IEM_DBLINK_PVT dependencies on IEM_DB_SERVERS

Line 54: l_iem_server_rec IEM_DB_SERVERS%ROWTYPE;

50: l_num NUMBER;
51: l_count NUMBER;
52: l_dblink_count number;
53: l_is_admin VARCHAR2(20);
54: l_iem_server_rec IEM_DB_SERVERS%ROWTYPE;
55: l_statement VARCHAR2(2000);
56: l_statement1 VARCHAR2(2000) := 'none';
57: l_global_name VARCHAR2(240);
58: l_glname VARCHAR2(240);

Line 130: select * INTO l_iem_server_rec from IEM_DB_SERVERS where DB_SERVER_ID = p_db_server_id;

126: raise db_link_exist;
127: end if;
128:
129: IF lower(p_db_username) <> 'apps' THEN
130: select * INTO l_iem_server_rec from IEM_DB_SERVERS where DB_SERVER_ID = p_db_server_id;
131:
132: l_v_id := DBMS_SQL.OPEN_CURSOR;
133:
134: IF (p_db_username = 'oo') THEN