DBA Data[Home] [Help]

APPS.EDW_DB_STATUS dependencies on EDW_MISC_UTIL

Line 163: edw_misc_util.globalNamesOff;

159: BEGIN
160:
161: x_instance_code:='';
162: l_progress := '010';
163: edw_misc_util.globalNamesOff;
164:
165: -- Check to make sure that all the enabled OLTP sources are up and running
166:
167: cid := DBMS_SQL.open_cursor;

Line 227: edw_misc_util.globalNamesOff;

223: BEGIN
224:
225: l_progress := '010';
226:
227: edw_misc_util.globalNamesOff;
228: -- Check to make sure that all the enabled OLTP sources are up and running
229:
230: cid := DBMS_SQL.open_cursor;
231:

Line 281: edw_misc_util.globalNamesOff;

277: -- Make sure that the repository is up and running
278: -- ASSUMPTION : That the db link from runtime to rep is fixed and is edw_wh_to_rep
279:
280: l_progress := '010';
281: edw_misc_util.globalNamesOff;
282:
283: cid := DBMS_SQL.open_cursor;
284: cid1 := DBMS_SQL.open_cursor;
285: cid2 := DBMS_SQL.open_cursor;

Line 382: edw_misc_util.globalNamesOff;

378: l_status VARCHAR2(200):='';
379:
380: BEGIN
381: l_progress := '010';
382: edw_misc_util.globalNamesOff;
383: cid := DBMS_SQL.open_cursor;
384:
385: OPEN instances;
386:

Line 460: edw_misc_util.globalNamesOff;

456: l_progress := '010';
457:
458: cid := DBMS_SQL.open_cursor;
459:
460: edw_misc_util.globalNamesOff;
461: OPEN instances;
462:
463: l_progress := '020';
464:

Line 515: edw_misc_util.globalNamesOff;

511: TYPE CurTyp IS REF CURSOR;
512: cv CurTyp;
513: BEGIN
514:
515: edw_misc_util.globalNamesOff;
516:
517: l_stmt:='select upper(db.name) from v$database@'||p_dblink ||' db';
518: open cv for l_stmt ;
519: fetch cv into l_host;