[Home] [Help]
2288: -- Profiles must be properly initialized before fnd_number.initialize.
2289: --
2290: -- Bug 2489275 - Since ICX_DATE_FORMAT_MASK is not tied to NLS_DATE_FORMAT,
2291: -- and the following relies on FND_GLOBAL.set_nls() being called when
2292: -- people want to initialize FND_DATE and FND_NUMBER packages, FND_DATE has
2293: -- been removed from this conditional and we leave FND_NUMBER which should
2294: -- be NLS related.
2295: --
2296: if nls_context_change then
2335:
2336: -- @todo is this too broad? should it just be if security_context_changed?
2337: if context_changed then
2338:
2339: -- Bug 2489275, FND_DATE.initialize will only be called with the
2340: -- ICX_DATE_FORMAT_MASK profile value if the profile value is NOT NULL
2341: -- and either this is the first time into FND_GLOBAL.initialize or there
2342: -- has been a real context change.
2343: declare
2341: -- and either this is the first time into FND_GLOBAL.initialize or there
2342: -- has been a real context change.
2343: declare
2344: user_calendar varchar2(20);
2345: plsql_block varchar2(240) := 'begin fnd_date.initialize_with_calendar(:1, null, :2); end;';
2346: -- This is declared as 240 simply because that is the maximum length of
2347: -- a profile value
2348: icx_date_format varchar(240) := fnd_profile.value('ICX_DATE_FORMAT_MASK');
2349: begin
2347: -- a profile value
2348: icx_date_format varchar(240) := fnd_profile.value('ICX_DATE_FORMAT_MASK');
2349: begin
2350: -- this should never happen, but just in case ICX_DATE_FORMAT is null,
2351: -- we'll let fnd_date default to whatever it does.
2352: if icx_date_format is not null then
2353: -- Bug 9536949: non-Gregorian calendar support was introduced for the
2354: -- R12.FND.B (12.1) release.
2355: if fnd_release.major_version >= 12 and
2360: -- instances < 12.1.
2361: user_calendar := nvl(fnd_profile.value('FND_FORMS_USER_CALENDAR'),'GREGORIAN');
2362: execute immediate plsql_block using icx_date_format, user_calendar;
2363: else
2364: fnd_date.initialize(icx_date_format);
2365: end if;
2366: end if;
2367: end;
2368: