270: c_date_format := ''''||NVL(wf_pref.get_pref(user_name,'DATEFORMAT'),
271: 'DD-MON-RRRR')||'''';
272: end if;
273:
274: dbms_session.set_nls('NLS_LANGUAGE' , c_language);
275: dbms_session.set_nls('NLS_TERRITORY' , c_territory);
276: dbms_session.set_nls('NLS_DATE_FORMAT', c_date_format);
277: end if;
278: exception
271: 'DD-MON-RRRR')||'''';
272: end if;
273:
274: dbms_session.set_nls('NLS_LANGUAGE' , c_language);
275: dbms_session.set_nls('NLS_TERRITORY' , c_territory);
276: dbms_session.set_nls('NLS_DATE_FORMAT', c_date_format);
277: end if;
278: exception
279: when others then
272: end if;
273:
274: dbms_session.set_nls('NLS_LANGUAGE' , c_language);
275: dbms_session.set_nls('NLS_TERRITORY' , c_territory);
276: dbms_session.set_nls('NLS_DATE_FORMAT', c_date_format);
277: end if;
278: exception
279: when others then
280: Wf_Core.Context('Wfa_Sec', 'PseudoSession');