APPS.BSC_METADATA_OPTIMIZER_PKG dependencies on UTL_FILE

Line 5: g_doc_file utl_file.file_type;

1: Package Body BSC_METADATA_OPTIMIZER_PKG AS
2: /* $Header: BSCMOPTB.pls 120.25 2006/03/27 12:47:07 arsantha noship $ */
3:
4:
5: g_doc_file utl_file.file_type;
6: g_progressCounter NUMBER := 0;
7:
8: PROCEDURE createTmpLogTables IS
9: l_stmt varchar2(1000);

Line 122: FROM v$parameter param where upper(param.name) = 'UTL_FILE_DIR';

118: l_dummy NUMBER;
119:
120: BEGIN
121: SELECT value INTO l_dir
122: FROM v$parameter param where upper(param.name) = 'UTL_FILE_DIR';
123: l_log_begin := INSTR(l_dir, '/log');
124:
125: IF (l_log_begin = 0) THEN /* then get the first string */
126: l_utl_dir := substr(l_dir, 1, INSTR(l_dir, ',') - 1);

Line 152: Write to the log file using utl_file. Write only IF the logging

148: RETURN l_utl_dir;
149: END;
150:
151: /*---------------------------------------------------------------------
152: Write to the log file using utl_file. Write only IF the logging
153: flag is TRUE.
154: ---------------------------------------------------------------------*/
155:
156: --Procedure writeLog(p_message IN VARCHAR2) IS

Line 802: g_dir:=fnd_profile.value('UTL_FILE_LOG');

798: g_bsc_apps_initialized := true;
799: bsc_apps.Init_Big_In_Cond_Table;
800: logProgress('INIT', 'Starting Setup');
801: g_dir := null;
802: g_dir:=fnd_profile.value('UTL_FILE_LOG');
803: IF g_dir is null THEN
804: g_dir:=getUtlFileDir;
805: END IF;
806: g_log_level := fnd_profile.value('AFLOG_LEVEL');

Line 820: --g_doc_file := utl_file.fOPEN(g_dir, 'METADATA.OUT' ,'w');

816: END IF;
817: g_log_level := FND_LOG.LEVEL_STATEMENT;
818: fnd_file.put_names(g_filename||'.log', g_filename||'.OUT', g_dir);
819: g_fileOpened := TRUE;
820: --g_doc_file := utl_file.fOPEN(g_dir, 'METADATA.OUT' ,'w');
821: logProgress('INIT', 'Completed Setup');
822:
823: bsc_mo_helper_pkg.writeTmp('---------------------------------------------------------'
824: ||newline, fnd_log.level_procedure, true);