APPS.PER_NL_WAZO_ARCHIVE dependencies on UTL_FILE

Line 74: |Description: Procedure to create an XML file output in utl_file_dir |

70:
71: /*-----------------------------------------------------------------------------
72: |Name : write_file |
73: |Type : Procedure |
74: |Description: Procedure to create an XML file output in utl_file_dir |
75: -------------------------------------------------------------------------------*/
76:
77: PROCEDURE write_file(p_XMLTable IN tXMLTable
78: ,p_file_name IN VARCHAR) IS

Line 82: l_file UTL_FILE.FILE_TYPE;

78: ,p_file_name IN VARCHAR) IS
79:
80: l_str1 VARCHAR2(80) ;
81: l_xml_element VARCHAR2(800);
82: l_file UTL_FILE.FILE_TYPE;
83: l_directory_path VARCHAR2(500);
84: l_file_name VARCHAR2(50);
85:
86: CURSOR cur_get_directory_path IS

Line 89: WHERE lower (name) = 'utl_file_dir';

85:
86: CURSOR cur_get_directory_path IS
87: SELECT value
88: FROM v$parameter
89: WHERE lower (name) = 'utl_file_dir';
90:
91: BEGIN
92: hr_utility.trace('+====write_file============================================+');
93: OPEN cur_get_directory_path;

Line 101: l_file := utl_file.fopen(l_directory_path, p_file_name, 'W');

97: IF INSTR(l_directory_path,',') > 0 THEN
98: l_directory_path := SUBSTR(l_directory_path, 1, INSTR(l_directory_path,',')-1);
99: END IF;
100:
101: l_file := utl_file.fopen(l_directory_path, p_file_name, 'W');
102: l_str1 := ''||EOL;
103: utl_file.put_line(l_file, l_str1);
104:
105: IF p_XMLTable.COUNT > 0 THEN

Line 103: utl_file.put_line(l_file, l_str1);

99: END IF;
100:
101: l_file := utl_file.fopen(l_directory_path, p_file_name, 'W');
102: l_str1 := ''||EOL;
103: utl_file.put_line(l_file, l_str1);
104:
105: IF p_XMLTable.COUNT > 0 THEN
106:
107: FOR table_counter IN p_XMLTable.FIRST .. p_XMLTable.LAST

Line 119: utl_file.put_line(l_file,l_xml_element);

115: '>'|| clean_XML(p_XMLTable(table_counter).tagvalue) ||
116: '';
117: END IF;
118: -- IF p_XMLTable(table_counter).tagvalue IS NOT NULL THEN
119: utl_file.put_line(l_file,l_xml_element);
120: -- END IF;
121: END LOOP;
122: END IF;
123: utl_file.fclose(l_file);

Line 123: utl_file.fclose(l_file);

119: utl_file.put_line(l_file,l_xml_element);
120: -- END IF;
121: END LOOP;
122: END IF;
123: utl_file.fclose(l_file);
124: hr_utility.trace('Written file : '||l_directory_path||'/'||p_file_name);
125: hr_utility.trace('x====write_file============================================x');
126: EXCEPTION
127: WHEN others THEN

Line 2103: l_file UTL_FILE.FILE_TYPE;

2099: --Variables--
2100:
2101: l_clob PAY_FILE_DETAILS.FILE_FRAGMENT%TYPE;
2102: l_blob PAY_FILE_DETAILS.BLOB_FILE_FRAGMENT%TYPE;
2103: l_file UTL_FILE.FILE_TYPE;
2104: l_directory_path VARCHAR2(500);
2105: l_file_name VARCHAR2(50);
2106: x NUMBER := 0;
2107: r NUMBER := 0;