DBA Data[Home] [Help]

APPS.CSF_SPATIAL_TTSP_PVT dependencies on V$INSTANCE

Line 108: SELECT instance_name INTO l_instance_name from v$instance;

104: l_table_space := p_table_space;
105:
106: SELECT SYSDATE INTO l_date FROM dual;
107:
108: SELECT instance_name INTO l_instance_name from v$instance;
109:
110: l_job_name := 'EXPORT_JOB' || TO_CHAR(l_date,'MISS');
111:
112: l_log_file := 'EXPORT_' || TO_CHAR(l_date,'DDMMYY_HH24MISS') || '_' || l_instance_name|| '_' || p_data_set_name || '.log';

Line 341: SELECT instance_name INTO l_instance_name from v$instance;

337: l_data_file_str := p_data_file_str;
338:
339: SELECT SYSDATE INTO l_date FROM dual;
340:
341: SELECT instance_name INTO l_instance_name from v$instance;
342:
343: l_job_name := 'IMPORT_JOB' || TO_CHAR(l_date,'MISS');
344:
345: l_log_file := 'IMPORT_' || TO_CHAR(l_date,'DDMMYY_HH24MISS') || '_' || l_instance_name|| '_' || p_data_set_name || '.log';