DBA Data[Home] [Help]

APPS.FND_FILE dependencies on DUAL

Line 128: from sys.dual;

124: when OTHERS then
125: if (Sql%NotFound) then
126: select lpad(to_char(fnd_temp_files_s.nextval), 7, '0')
127: into BASE
128: from sys.dual;
129: end if;
130:
131: commit;
132: return BASE;

Line 210: from dual ;

206:
207: if (instr(TEMP_UTL,' ') > 0 and TEMP_UTL is not null) then
208: select substrb(TEMP_UTL, 1, instr(TEMP_UTL,' ') - 1)
209: into TEMP_DIR
210: from dual ;
211: elsif (TEMP_UTL is not null) then
212: TEMP_DIR := TEMP_UTL;
213: end if;
214: