DBA Data[Home] [Help]

APPS.HR_ADE_UPGRADE dependencies on DUAL

Line 114: select sysdate into l_date from dual;

110: fnd_profile.get('PER_DATA_EXCHANGE_DIR', l_dir);
111: -- open input file for reading
112: l_infile := UTL_FILE.FOPEN(l_dir,p_file,'r');
113: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing '||l_dir||'/'||p_file);
114: select sysdate into l_date from dual;
115: l_datestamp := to_char(l_date,'DDMMYYHH24MISS');
116: --
117: --create output file names
118: l_out_file_name := 'UPG' ||l_datestamp||'.csv';