APPS.PER_DATA_UPDATE_REPORT dependencies on UTL_FILE

Line 676: p_l_fp UTL_FILE.FILE_TYPE;

672:
673: PROCEDURE WritetoXML (
674: p_output_fname out nocopy varchar2)
675: IS
676: p_l_fp UTL_FILE.FILE_TYPE;
677: l_audit_log_dir varchar2(500);
678: l_file_name varchar2(50);
679: l_check_flag number;
680: l_database_name varchar2(10);

Line 693: WHERE LOWER(name) = 'utl_file_dir';

689: BEGIN
690: SELECT value
691: INTO l_audit_log_dir
692: FROM v$parameter
693: WHERE LOWER(name) = 'utl_file_dir';
694: -- Check whether more than one util file directory is found
695: IF INSTR(l_audit_log_dir,',') > 0 THEN
696: l_audit_log_dir := substr(l_audit_log_dir,1,instr(l_audit_log_dir,',')-1);
697: END IF;

Line 710: p_l_fp := utl_file.fopen(l_audit_log_dir,l_file_name,'A');

706: ELSE
707: p_output_fname := l_audit_log_dir || '\' || l_file_name;
708: END IF;
709: -- getting Agency name
710: p_l_fp := utl_file.fopen(l_audit_log_dir,l_file_name,'A');
711: -- Writing from and to dates
712: --
713: --
714: --

Line 754: utl_file.fclose(p_l_fp);

750: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP
751: WriteXMLvalues(p_l_fp,vXMLTable(ctr_table).TagValue);
752: END LOOP;
753: END IF;
754: utl_file.fclose(p_l_fp);
755: END WritetoXML;
756: ------------------------------------------------------------------
757: PROCEDURE WriteXMLvalues( p_l_fp utl_file.file_type, p_value IN VARCHAR2) IS
758: BEGIN

Line 757: PROCEDURE WriteXMLvalues( p_l_fp utl_file.file_type, p_value IN VARCHAR2) IS

753: END IF;
754: utl_file.fclose(p_l_fp);
755: END WritetoXML;
756: ------------------------------------------------------------------
757: PROCEDURE WriteXMLvalues( p_l_fp utl_file.file_type, p_value IN VARCHAR2) IS
758: BEGIN
759: utl_file.put_line(p_l_fp, p_value );
760: null;
761: END WriteXMLvalues;

Line 759: utl_file.put_line(p_l_fp, p_value );

755: END WritetoXML;
756: ------------------------------------------------------------------
757: PROCEDURE WriteXMLvalues( p_l_fp utl_file.file_type, p_value IN VARCHAR2) IS
758: BEGIN
759: utl_file.put_line(p_l_fp, p_value );
760: null;
761: END WriteXMLvalues;
762: ------------------------------------------------------------------
763: procedure fetch_rtf_blob