APPS.EDW_SYSTEM_PARAMS_PKG dependencies on EDW_MISC_UTIL

Line 27: edw_misc_util.globalNamesOff;

23: BEGIN
24:
25:
26: BEGIN
27: edw_misc_util.globalNamesOff;
28:
29: cid := DBMS_SQL.open_cursor;
30:
31: dbms_sql.parse(cid, 'SELECT 1 FROM dual@'||p_db_link, dbms_sql.native);

Line 72: edw_misc_util.globalNamesOff;

68:
69:
70: /* Turn Off global names for the session */
71:
72: edw_misc_util.globalNamesOff;
73:
74:
75: /* IF (cols%ISOPEN) THEN
76: CLOSE cols;

Line 199: edw_misc_util.globalnamesoff;

195: result number;
196: Type CurTyp is Ref Cursor;
197: cv CurTyp;
198: begin
199: edw_misc_util.globalnamesoff;
200: l_stmt:='select count(*) from fnd_id_flex_segments@'||l_db_link ||
201: ' where application_id=''401'' '||
202: ' and id_flex_code= ''MCAT'' '||
203: ' and enabled_flag=''Y'' '||

Line 221: edw_misc_util.globalnamesoff;

217: result varchar2(5):=null;
218: Type CurTyp is Ref Cursor;
219: cv CurTyp;
220: begin
221: edw_misc_util.globalnamesoff;
222:
223: l_stmt:='select ''YES'' VBH_INSTALLED from mtl_category_sets_b@'||l_db_link ||
224: ' where category_set_id = ''1000000006'' ';
225: open cv for l_stmt;