eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.DDR_ETL_UTIL_PKG dependencies on UTL_FILE

Line 212: l_file UTL_FILE.FILE_TYPE;

208: AS
209: l_dir_name VARCHAR2(100);
210: l_table_name VARCHAR2(30);
211: l_where_clause VARCHAR2(500);
212: l_file UTL_FILE.FILE_TYPE;
213: l_column_name string_tab;
214: l_column_type string_tab;
215: l_column_count INTEGER;
216: l_column_list VARCHAR2(10000);

Line 257: l_file := UTL_FILE.FOPEN(l_dir_name,p_file_name,'W',g_max_linesize);

253: END IF;
254: l_SQL_stmt := l_SQL_stmt || l_where_clause;
255:
256: l_dir_name := Get_Directory_Name;
257: l_file := UTL_FILE.FOPEN(l_dir_name,p_file_name,'W',g_max_linesize);
258:
259: /* Retrieve the records */
260: cur_err := DBMS_SQL.OPEN_CURSOR;
261: DBMS_SQL.PARSE(cur_err,l_SQL_stmt,DBMS_SQL.NATIVE);

Line 284: UTL_FILE.PUT_LINE(l_file,l_hdr_line);

280:
281: IF DBMS_SQL.last_row_count = 1
282: THEN
283: /* Write the column header line in file */
284: UTL_FILE.PUT_LINE(l_file,l_hdr_line);
285: END IF;
286:
287: l_line := NULL;
288: FOR col_indx IN 1 .. l_column_count

Line 308: UTL_FILE.PUT_LINE(l_file,l_line);

304: END LOOP;
305: l_line := SUBSTR(l_line,2);
306:
307: /* Write the line to the file */
308: UTL_FILE.PUT_LINE(l_file,l_line);
309: END LOOP;
310: DBMS_SQL.CLOSE_CURSOR(cur_err);
311:
312: UTL_FILE.FCLOSE(l_file);

Line 312: UTL_FILE.FCLOSE(l_file);

308: UTL_FILE.PUT_LINE(l_file,l_line);
309: END LOOP;
310: DBMS_SQL.CLOSE_CURSOR(cur_err);
311:
312: UTL_FILE.FCLOSE(l_file);
313: EXCEPTION
314: WHEN OTHERS
315: THEN
316: IF UTL_FILE.IS_OPEN(l_file)

Line 316: IF UTL_FILE.IS_OPEN(l_file)

312: UTL_FILE.FCLOSE(l_file);
313: EXCEPTION
314: WHEN OTHERS
315: THEN
316: IF UTL_FILE.IS_OPEN(l_file)
317: THEN
318: UTL_FILE.FCLOSE(l_file);
319: END IF;
320: IF DBMS_SQL.IS_OPEN(cur_err)

Line 318: UTL_FILE.FCLOSE(l_file);

314: WHEN OTHERS
315: THEN
316: IF UTL_FILE.IS_OPEN(l_file)
317: THEN
318: UTL_FILE.FCLOSE(l_file);
319: END IF;
320: IF DBMS_SQL.IS_OPEN(cur_err)
321: THEN
322: DBMS_SQL.CLOSE_CURSOR(cur_err);

Line 335: l_file UTL_FILE.FILE_TYPE;

331: AS
332: l_dir_name VARCHAR2(100);
333: l_table_name VARCHAR2(30);
334: l_file_name VARCHAR2(100);
335: l_file UTL_FILE.FILE_TYPE;
336: l_column_name string_tab;
337: l_column_type string_tab;
338: l_column_count INTEGER;
339: l_update_stmt VARCHAR2(10000);

Line 372: l_file := UTL_FILE.FOPEN(l_dir_name,l_file_name,'R',g_max_linesize);

368: l_col_type_by_name(l_column_name(indx)) := l_column_type(indx);
369: END LOOP;
370:
371: l_dir_name := Get_Directory_Name;
372: l_file := UTL_FILE.FOPEN(l_dir_name,l_file_name,'R',g_max_linesize);
373:
374: /* Read and Process all records from the file */
375: cur_err_upd := DBMS_SQL.OPEN_CURSOR;
376: cur_err_ins := DBMS_SQL.OPEN_CURSOR;

Line 380: UTL_FILE.GET_LINE(l_file,l_line,g_max_linesize);

376: cur_err_ins := DBMS_SQL.OPEN_CURSOR;
377: l_rec_count := 0;
378: LOOP
379: BEGIN
380: UTL_FILE.GET_LINE(l_file,l_line,g_max_linesize);
381: l_rec_count := l_rec_count + 1;
382:
383: IF l_rec_count = 1 /* Assuming that the first line is the File Column Header Line */
384: THEN

Line 473: UTL_FILE.FCLOSE(l_file);

469: END LOOP;
470:
471: DBMS_SQL.CLOSE_CURSOR(cur_err_upd);
472: DBMS_SQL.CLOSE_CURSOR(cur_err_ins);
473: UTL_FILE.FCLOSE(l_file);
474:
475: COMMIT;
476: EXCEPTION
477: WHEN OTHERS

Line 479: IF UTL_FILE.IS_OPEN(l_file)

475: COMMIT;
476: EXCEPTION
477: WHEN OTHERS
478: THEN
479: IF UTL_FILE.IS_OPEN(l_file)
480: THEN
481: UTL_FILE.FCLOSE(l_file);
482: END IF;
483: IF DBMS_SQL.IS_OPEN(cur_err_upd)

Line 481: UTL_FILE.FCLOSE(l_file);

477: WHEN OTHERS
478: THEN
479: IF UTL_FILE.IS_OPEN(l_file)
480: THEN
481: UTL_FILE.FCLOSE(l_file);
482: END IF;
483: IF DBMS_SQL.IS_OPEN(cur_err_upd)
484: THEN
485: DBMS_SQL.CLOSE_CURSOR(cur_err_upd);

Line 522: l_file UTL_FILE.FILE_TYPE;

518: AS
519: l_dir_name VARCHAR2(100);
520: l_table_name VARCHAR2(30);
521: l_file_name VARCHAR2(100);
522: l_file UTL_FILE.FILE_TYPE;
523: l_column_name string_tab;
524: l_column_type string_tab;
525: l_column_count INTEGER;
526: l_insert_stmt VARCHAR2(10000);

Line 555: l_file := UTL_FILE.FOPEN(l_dir_name,l_file_name,'R',g_max_linesize);

551: l_col_type_by_name(l_column_name(indx)) := l_column_type(indx);
552: END LOOP;
553:
554: l_dir_name := Get_Directory_Name;
555: l_file := UTL_FILE.FOPEN(l_dir_name,l_file_name,'R',g_max_linesize);
556:
557: /* Read and Process all records from the file */
558: cur_err_ins := DBMS_SQL.OPEN_CURSOR;
559: l_rec_count := 0;

Line 562: UTL_FILE.GET_LINE(l_file,l_line,g_max_linesize);

558: cur_err_ins := DBMS_SQL.OPEN_CURSOR;
559: l_rec_count := 0;
560: LOOP
561: BEGIN
562: UTL_FILE.GET_LINE(l_file,l_line,g_max_linesize);
563: l_rec_count := l_rec_count + 1;
564:
565: IF l_rec_count = 1 /* Assuming that the first line is the File Column Header Line */
566: THEN

Line 614: UTL_FILE.FCLOSE(l_file);

610: END;
611: END LOOP;
612:
613: DBMS_SQL.CLOSE_CURSOR(cur_err_ins);
614: UTL_FILE.FCLOSE(l_file);
615:
616: COMMIT;
617: EXCEPTION
618: WHEN OTHERS

Line 620: IF UTL_FILE.IS_OPEN(l_file)

616: COMMIT;
617: EXCEPTION
618: WHEN OTHERS
619: THEN
620: IF UTL_FILE.IS_OPEN(l_file)
621: THEN
622: UTL_FILE.FCLOSE(l_file);
623: END IF;
624: IF DBMS_SQL.IS_OPEN(cur_err_ins)

Line 622: UTL_FILE.FCLOSE(l_file);

618: WHEN OTHERS
619: THEN
620: IF UTL_FILE.IS_OPEN(l_file)
621: THEN
622: UTL_FILE.FCLOSE(l_file);
623: END IF;
624: IF DBMS_SQL.IS_OPEN(cur_err_ins)
625: THEN
626: DBMS_SQL.CLOSE_CURSOR(cur_err_ins);