APPS.IEB_SYNC_SERVER dependencies on IEO_SVR_SERVERS

Line 139: from IEO_SVR_SERVERS

135: x_return_status OUT NOCOPY VARCHAR2 )
136: IS
137: cursor c1 is
138: select *
139: from IEO_SVR_SERVERS
140: where type_id = 10020
141: and not exists (select 'x' from IEB_WB_SERVERS SRV, IEB_WB_SVC_CATS SVC
142: where SRV.WB_SERVER_NAME = SERVER_NAME AND
143: SVC.WBSVR_WBSVR_ID = SRV.WBSVR_ID );

Line 156: (SELECT server_name FROM ieo_svr_servers WHERE type_id = 10020);

152: -- create data for new servers created in ieo schema
153:
154: -- this takes care of deleting data from ieb schema
155: DELETE FROM ieb_wb_servers WHERE wb_server_name NOT IN
156: (SELECT server_name FROM ieo_svr_servers WHERE type_id = 10020);
157:
158: if (sql%notfound) then
159: null; -- not finding any such iebs is good
160: else

Line 282: set a.IEO_SERVER_ID = (select b.server_id from ieo_svr_servers b where a.WB_SERVER_NAME = b.SERVER_NAME);

278: commit;
279: end loop;
280:
281: update ieb_wb_servers a
282: set a.IEO_SERVER_ID = (select b.server_id from ieo_svr_servers b where a.WB_SERVER_NAME = b.SERVER_NAME);
283: if (sql%notfound) then
284: null;
285: end if;
286: commit;

Line 417: (SELECT server_name FROM ieo_svr_servers WHERE type_id = 10020);

413: l_count number(5);
414:
415: cursor c1 is
416: select * from ieb_wb_servers WHERE wb_server_name IN
417: (SELECT server_name FROM ieo_svr_servers WHERE type_id = 10020);
418:
419:
420: cursor c2 is
421: select a.direction, b.created_by, b.creation_date, b.last_updated_by,