APPS.EDW_ALTER_INDEXES dependencies on UTL_FILE

Line 4: g_file utl_file.file_type;

1: package body edw_alter_indexes AS
2: /* $Header: EDWINDXB.pls 115.6 2004/02/13 05:11:06 smulye noship $ */
3:
4: g_file utl_file.file_type;
5: OUT number := 0;
6: LOG number := 1;
7: BOTH number :=2;
8:

Line 93: utl_file.put_line(g_file, 'Inside getIndexStatus for :'||p_index);

89:
90: Type CurTyp is Ref Cursor;
91: cv CurTyp;
92: BEGIN
93: utl_file.put_line(g_file, 'Inside getIndexStatus for :'||p_index);
94:
95: OPEN cv FOR l_stmt USING p_table, p_owner, p_index;
96: FETCH cv into l_status;
97: CLOSE cv;

Line 98: utl_file.put_line(g_file, 'Completed getIndexStatus for :'||p_index||' : '||l_status);

94:
95: OPEN cv FOR l_stmt USING p_table, p_owner, p_index;
96: FETCH cv into l_status;
97: CLOSE cv;
98: utl_file.put_line(g_file, 'Completed getIndexStatus for :'||p_index||' : '||l_status);
99: RETURN l_status;
100:
101: END;
102:

Line 128: utl_file.put_line(g_file, 'Inside getIndexForFK for :'||p_fk_name);

124: indexName varchar2(30) := null;
125:
126: BEGIN
127:
128: utl_file.put_line(g_file, 'Inside getIndexForFK for :'||p_fk_name);
129:
130: counter := g_indexes.first;
131:
132: LOOP

Line 142: utl_file.put_line(g_file, 'Completed getIndexForFK for :'||p_fk_name || ' returning '||indexName);

138: EXIT;
139: END IF;
140: counter := counter + 1;
141: END LOOP;
142: utl_file.put_line(g_file, 'Completed getIndexForFK for :'||p_fk_name || ' returning '||indexName);
143:
144: return indexName;
145:
146: END;

Line 248: utl_file.fclose(g_file);

244: alterIndexesForFact(l_fact);
245: END LOOP;
246:
247: CLOSE c_getFacts;
248: utl_file.fclose(g_file);
249:
250: */
251:
252: null;