DBA Data[Home] [Help]

APPS.EDW_GEN_VIEW dependencies on UTL_FILE

Line 91: l_file utl_file.file_type;

87: g_status_failed_all varchar2(30):= 'FAILED_ALL';
88: g_status_failed_pruned varchar2(30):='FAILED_PRUNED';
89: g_status_generated_all varchar2(30):='GENERATED_ALL';
90: g_status_generated_pruned varchar2(30):='GENERATED_PRUNED';
91: l_file utl_file.file_type;
92: -- spool out the view_text into l_out_file
93: l_out_file utl_file.file_type;
94: g_success boolean := true;
95: g_error varchar2(2000):= null;

Line 93: l_out_file utl_file.file_type;

89: g_status_generated_all varchar2(30):='GENERATED_ALL';
90: g_status_generated_pruned varchar2(30):='GENERATED_PRUNED';
91: l_file utl_file.file_type;
92: -- spool out the view_text into l_out_file
93: l_out_file utl_file.file_type;
94: g_success boolean := true;
95: g_error varchar2(2000):= null;
96: g_obj_name VARCHAR2(30);
97: