Line 187: -- getting the date in the required xml standard
183: select lower(ISO_LANGUAGE) from fnd_languages
184: where language_code = userenv('LANG');
185:
186: begin 187: -- getting the date in the required xml standard 188: select to_char(sysdate,'yyyy-mm-dd') ||'T'
189: || to_char(sysdate,'hh:mi:ss')
190: into l_sysdate
191: from dual;