APPS.BOM_CALC_CYNP dependencies on UTL_FILE

Line 80: g_Debug_File UTL_FILE.FILE_TYPE;

76: p_op_seq_id IN NUMBER,
77: p_ind IN NUMBER
78: ) RETURN BOOLEAN;
79:
80: g_Debug_File UTL_FILE.FILE_TYPE;
81:
82:
83: -- Declare variables
84: v_tab_size NUMBER;

Line 183: l_utl_file_dir VARCHAR2(2000);

179:
180: PROCEDURE Open_Debug_Session
181: IS
182: l_found NUMBER := 0;
183: l_utl_file_dir VARCHAR2(2000);
184: p_output_dir VARCHAR2(80) := '/sqlcom/log/tst115rw' ;
185: p_debug_filename VARCHAR2(30) := 'bom_cynpp.log' ;
186:
187: BEGIN

Line 190: INTO l_utl_file_dir

186:
187: BEGIN
188:
189: select value
190: INTO l_utl_file_dir
191: FROM v$parameter
192: WHERE name = 'utl_file_dir';
193:
194: l_found := INSTR(l_utl_file_dir, p_output_dir);

Line 192: WHERE name = 'utl_file_dir';

188:
189: select value
190: INTO l_utl_file_dir
191: FROM v$parameter
192: WHERE name = 'utl_file_dir';
193:
194: l_found := INSTR(l_utl_file_dir, p_output_dir);
195:
196:

Line 194: l_found := INSTR(l_utl_file_dir, p_output_dir);

190: INTO l_utl_file_dir
191: FROM v$parameter
192: WHERE name = 'utl_file_dir';
193:
194: l_found := INSTR(l_utl_file_dir, p_output_dir);
195:
196:
197: IF l_found = 0
198: THEN

Line 202: g_Debug_File := utl_file.fopen( p_output_dir

198: THEN
199: RETURN;
200: END IF;
201:
202: g_Debug_File := utl_file.fopen( p_output_dir
203: , p_debug_filename
204: , 'w');
205:
206: END ;

Line 212: utl_file.fclose(g_Debug_File);

208: -- Close Debug_Session
209: PROCEDURE Close_Debug_Session
210: IS
211: BEGIN
212: utl_file.fclose(g_Debug_File);
213: END Close_Debug_Session;
214:
215:
216: -- Test Debug

Line 222: utl_file.put_line(g_Debug_File, p_debug_message);

218: ( p_debug_message IN VARCHAR2 )
219: IS
220: BEGIN
221:
222: utl_file.put_line(g_Debug_File, p_debug_message);
223:
224: END Write_Debug;
225:
226: PROCEDURE copy_ntwk_op_tbl