APPS.AD_LONGTOLOB_PKG dependencies on UTL_FILE

Line 790: fp utl_file.file_type;

786:
787: TYPE cur_type IS REF CURSOR ;
788: l_cursor cur_type;
789:
790: fp utl_file.file_type;
791: l_Row_4000_Count NUMBER ;
792: l_str VARCHAR2 (2000);
793: l_query VARCHAR2 (400);
794: l_number NUMBER ;

Line 819: utl_file.put_line(fp,l_str);

815: BEGIN
816: IF l_pr = 0 THEN
817: DBMS_OUTPUT.PUT_LINE(l_str);
818: ELSE
819: utl_file.put_line(fp,l_str);
820: END IF ;
821: END print_data;
822: BEGIN
823: l_Path := p_Path;

Line 852: fp := utl_file.fopen(l_Path,l_File_Name,'w');

848:
849: BEGIN -- begin for the main block of actions
850: l_File_Name := 'long_report.'||to_char(sysdate,'DD-MON-YY.HH24:MI:SS')||'.txt';
851: IF (l_pr = 1 ) THEN
852: fp := utl_file.fopen(l_Path,l_File_Name,'w');
853: END IF ;
854:
855: l_str := 'Sl.No '||lpad('Table Name',28)||'*'|| lpad('Column Name',29)||'*'|| lpad('Owner',11)||'*'||
856: lpad('Data Type',14)||'*'|| lpad('Table Size',14)||'*'|| lpad('Total Rows',14) ||'*'||

Line 897: utl_file.fclose(fp);

893: print_data(l_str);
894: END LOOP ;
895: END LOOP ;
896: IF (l_pr = 1 ) THEN
897: utl_file.fclose(fp);
898: END IF ;
899: END; -- end for the main block of actions
900: END write_long_rep;
901: