[Home] [Help]
2045: -- Profiles must be properly initialized before fnd_number.initialize.
2046: --
2047: -- Bug 2489275 - Since ICX_DATE_FORMAT is not tied to NLS_DATE_FORMAT, and
2048: -- the following relies on FND_GLOBAL.set_nls() being called when people
2049: -- want to initialize FND_DATE and FND_NUMBER packages, FND_DATE has been
2050: -- removed from this conditional and we leave FND_NUMBER which should be NLS
2051: -- related.
2052: --
2053: if nls_context_change then
2114:
2115: -- @todo is this too broad? should it just be if security_context_changed?
2116: if context_changed then
2117:
2118: -- Bug 2489275, FND_DATE.initialize will only be called with the
2119: -- ICX_DATE_FORMAT_MASK profile value if the profile value is NOT NULL
2120: -- and either this is the first time into FND_GLOBAL.initialize or there
2121: -- has been a real context change.
2122: declare
2124: -- a profile value
2125: icx_date_format varchar(240) := fnd_profile.value('ICX_DATE_FORMAT_MASK');
2126: begin
2127: -- this should never happen, but just in case
2128: -- ICX_DATE_FORMAT is null, we'll let fnd_date
2129: -- default to whatever it does.
2130: if icx_date_format is not null then
2131: fnd_date.initialize(icx_date_format);
2132: end if;
2127: -- this should never happen, but just in case
2128: -- ICX_DATE_FORMAT is null, we'll let fnd_date
2129: -- default to whatever it does.
2130: if icx_date_format is not null then
2131: fnd_date.initialize(icx_date_format);
2132: end if;
2133: end;
2134:
2135: end if;