APPS.AS_UTILITY_PVT dependencies on UTL_FILE

Line 21: pg_fp utl_file.file_type;

17: G_FILE_NAME CONSTANT VARCHAR2(12):='asxvutlb.pls';
18:
19: pg_file_name VARCHAR2(100) := NULL;
20: pg_path_name VARCHAR2(100) := NULL;
21: pg_fp utl_file.file_type;
22:
23: TYPE indexRec IS Record(index_name dba_indexes.index_name%Type
24: ,index_owner dba_indexes.owner%Type
25: ,tbl_name dba_indexes.table_name%Type

Line 790: utl_file.put_line(pg_fp, line);

786: BEGIN
787: if (pg_file_name is not null) then
788:
789: -- dbms_output.put_line('pg_file_name ' || pg_file_name);
790: utl_file.put_line(pg_fp, line);
791: utl_file.fflush(pg_fp);
792: end if;
793: END file_debug;
794:

Line 791: utl_file.fflush(pg_fp);

787: if (pg_file_name is not null) then
788:
789: -- dbms_output.put_line('pg_file_name ' || pg_file_name);
790: utl_file.put_line(pg_fp, line);
791: utl_file.fflush(pg_fp);
792: end if;
793: END file_debug;
794:
795: PROCEDURE enable_file_debug(path_name in varchar2,

Line 801: pg_fp := utl_file.fopen(path_name, file_name, 'a');

797:
798: BEGIN
799:
800: if (pg_file_name is null) then
801: pg_fp := utl_file.fopen(path_name, file_name, 'a');
802: pg_file_name := file_name;
803: pg_path_name := path_name;
804: end if;
805:

Line 807: when utl_file.invalid_path then

803: pg_path_name := path_name;
804: end if;
805:
806: EXCEPTION
807: when utl_file.invalid_path then
808: app_exception.raise_exception;
809: when utl_file.invalid_mode then
810: app_exception.raise_exception;
811:

Line 809: when utl_file.invalid_mode then

805:
806: EXCEPTION
807: when utl_file.invalid_path then
808: app_exception.raise_exception;
809: when utl_file.invalid_mode then
810: app_exception.raise_exception;
811:
812: END;
813:

Line 817: utl_file.fclose(pg_fp);

813:
814: PROCEDURE disable_file_debug is
815: BEGIN
816: if (pg_file_name is not null) THEN
817: utl_file.fclose(pg_fp);
818: end if;
819: END;
820:
821: PROCEDURE static_sql(p_indRec IN OUT NOCOPY indexRec) IS