APPS.MSC_SNAPSHOT_PK dependencies on UTL_FILE

Line 1914: fh UTL_FILE.file_type;

1910: v_blob BLOB;
1911: v_data_length NUMBER;
1912: v_offset NUMBER DEFAULT 1;
1913: v_chunk CONSTANT NUMBER DEFAULT 4000;
1914: fh UTL_FILE.file_type;
1915: l_create_stmt VARCHAR2(8000);
1916: l_dest_dir VARCHAR2(400);
1917: BEGIN
1918: /*

Line 1971: fh := UTL_FILE.fopen (l_dest_dir, 'MSLD_XML_SCHEMA.xml', 'wb', v_chunk);

1967: ) mxc1;
1968:
1969: v_blob := v_xml.getblobval (1);
1970: v_data_length := DBMS_LOB.getlength (v_blob);
1971: fh := UTL_FILE.fopen (l_dest_dir, 'MSLD_XML_SCHEMA.xml', 'wb', v_chunk);
1972:
1973: LOOP
1974: EXIT WHEN v_offset > v_data_length;
1975: UTL_FILE.put_raw (fh, DBMS_LOB.SUBSTR (v_blob, v_chunk, v_offset), TRUE);

Line 1975: UTL_FILE.put_raw (fh, DBMS_LOB.SUBSTR (v_blob, v_chunk, v_offset), TRUE);

1971: fh := UTL_FILE.fopen (l_dest_dir, 'MSLD_XML_SCHEMA.xml', 'wb', v_chunk);
1972:
1973: LOOP
1974: EXIT WHEN v_offset > v_data_length;
1975: UTL_FILE.put_raw (fh, DBMS_LOB.SUBSTR (v_blob, v_chunk, v_offset), TRUE);
1976: v_offset := v_offset + v_chunk;
1977: END LOOP;
1978:
1979: UTL_FILE.fclose (fh);

Line 1979: UTL_FILE.fclose (fh);

1975: UTL_FILE.put_raw (fh, DBMS_LOB.SUBSTR (v_blob, v_chunk, v_offset), TRUE);
1976: v_offset := v_offset + v_chunk;
1977: END LOOP;
1978:
1979: UTL_FILE.fclose (fh);
1980:
1981: EXCEPTION
1982: WHEN NO_DATA_FOUND
1983: THEN