APPS.CSF_SPATIAL_TTSP_PVT dependencies on DUAL

Line 106: SELECT SYSDATE INTO l_date FROM dual;

102: l_dmp_file := p_dmp_file;
103:
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');

Line 339: SELECT SYSDATE INTO l_date FROM dual;

335: l_dmp_file := p_dmp_file;
336:
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');

Line 398: SELECT SUBSTR(l_data_file_dir, length(l_data_file_dir)) INTO l_temp FROM dual;

394: BEGIN
395:
396: l_data_file_dir := p_data_file_dir;
397:
398: SELECT SUBSTR(l_data_file_dir, length(l_data_file_dir)) INTO l_temp FROM dual;
399:
400: IF l_temp <> '/' THEN
401: l_data_file_dir := l_data_file_dir || '/';
402: END IF;

Line 410: SELECT SUBSTR(l_data_file_str, 1, INSTR(l_data_file_str , ',')-1) INTO l_data_file FROM dual;

406: LOOP
407:
408: EXIT WHEN INSTR(l_data_file_str , ',') = 0 OR INSTR(l_data_file_str , ',') is null;
409:
410: SELECT SUBSTR(l_data_file_str, 1, INSTR(l_data_file_str , ',')-1) INTO l_data_file FROM dual;
411:
412: SELECT SUBSTR(l_data_file_str, INSTR(l_data_file_str , ',')+1) INTO l_data_file_str FROM dual;
413:
414: DBMS_DATAPUMP.SET_PARAMETER(

Line 412: SELECT SUBSTR(l_data_file_str, INSTR(l_data_file_str , ',')+1) INTO l_data_file_str FROM dual;

408: EXIT WHEN INSTR(l_data_file_str , ',') = 0 OR INSTR(l_data_file_str , ',') is null;
409:
410: SELECT SUBSTR(l_data_file_str, 1, INSTR(l_data_file_str , ',')-1) INTO l_data_file FROM dual;
411:
412: SELECT SUBSTR(l_data_file_str, INSTR(l_data_file_str , ',')+1) INTO l_data_file_str FROM dual;
413:
414: DBMS_DATAPUMP.SET_PARAMETER(
415: handle => l_dp_handle,
416: name=>'TABLESPACE_DATAFILE',