DBA Data[Home] [Help]

APPS.FA_ASSET_TRACE_PVT dependencies on UTL_FILE

Line 33: g_use_utl_file VARCHAR2(1) := 'N';

29: g_mrc_enabled VARCHAR2(1);
30: g_jx_enabled VARCHAR2(1);
31: g_temp_head VARCHAR2(2000); --holds banner area content
32:
33: g_use_utl_file VARCHAR2(1) := 'N';
34: g_outfile UTL_FILE.FILE_TYPE;
35: g_logfile UTL_FILE.FILE_TYPE;
36:
37: PROCEDURE initialize_globals (p_opt_tbl IN FA_ASSET_TRACE_PUB.t_options_tbl,

Line 34: g_outfile UTL_FILE.FILE_TYPE;

30: g_jx_enabled VARCHAR2(1);
31: g_temp_head VARCHAR2(2000); --holds banner area content
32:
33: g_use_utl_file VARCHAR2(1) := 'N';
34: g_outfile UTL_FILE.FILE_TYPE;
35: g_logfile UTL_FILE.FILE_TYPE;
36:
37: PROCEDURE initialize_globals (p_opt_tbl IN FA_ASSET_TRACE_PUB.t_options_tbl,
38: p_exc_tbl IN FA_ASSET_TRACE_PUB.t_excl_tbl,

Line 35: g_logfile UTL_FILE.FILE_TYPE;

31: g_temp_head VARCHAR2(2000); --holds banner area content
32:
33: g_use_utl_file VARCHAR2(1) := 'N';
34: g_outfile UTL_FILE.FILE_TYPE;
35: g_logfile UTL_FILE.FILE_TYPE;
36:
37: PROCEDURE initialize_globals (p_opt_tbl IN FA_ASSET_TRACE_PUB.t_options_tbl,
38: p_exc_tbl IN FA_ASSET_TRACE_PUB.t_excl_tbl,
39: p_schema OUT NOCOPY VARCHAR2,

Line 105: p_use_utl_file IN VARCHAR2,

101: PROCEDURE build_anchors (p_t_tbl IN FA_ASSET_TRACE_PKG.t_col_tbl,
102: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
103:
104: PROCEDURE save_output (p_calling_prog IN VARCHAR2, --i.e. FATRACE
105: p_use_utl_file IN VARCHAR2,
106: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
107:
108: PROCEDURE log(p_calling_fn IN VARCHAR2,
109: p_msg IN VARCHAR2 default null,

Line 112: PROCEDURE ocfile (p_handle IN OUT NOCOPY utl_file.file_type,

108: PROCEDURE log(p_calling_fn IN VARCHAR2,
109: p_msg IN VARCHAR2 default null,
110: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
111:
112: PROCEDURE ocfile (p_handle IN OUT NOCOPY utl_file.file_type,
113: p_file IN VARCHAR2,
114: p_mode IN VARCHAR2); --C(lose) or O(pen)
115:
116: END FA_ASSET_TRACE_PVT;