APPS.BOM_BULKLOAD_PVT_PKG dependencies on FND_DATE

Line 1000: fnd_date_tz.init_timezones_for_fnd_date;

996: EXECUTE IMMEDIATE l_dyn_sql USING p_Resultfmt_Usage_Id;
997:
998: --------------------------------------------------------------
999: -- Resolve user time zone conversions
1000: fnd_date_tz.init_timezones_for_fnd_date;
1001: IF (l_eff_date_col_name IS NOT NULL OR l_dis_date_col_name IS NOT NULL OR l_imp_date_col_name IS NOT NULL) THEN
1002: l_dyn_sql := '';
1003: l_dyn_sql := 'UPDATE EGO_BULKLOAD_INTF EBI SET';
1004: IF l_eff_date_col_name IS NOT NULL THEN

Line 1879: calendar_aware NUMBER DEFAULT FND_DATE.calendar_aware_default) RETURN DATE IS

1875:
1876: END PROCESS_BOM_INTERFACE_LINES;
1877:
1878: FUNCTION displayDT_to_date(charDT VARCHAR2,
1879: calendar_aware NUMBER DEFAULT FND_DATE.calendar_aware_default) RETURN DATE IS
1880: dateval date;
1881: tz_code varchar2(50);
1882:
1883: icx_date_format varchar2(200);

Line 1894: if (calendar_aware = FND_DATE.calendar_aware AND FND_DATE.is_non_gregorian) then

1890:
1891: output_mask := icx_date_format || ' HH24:MI:SS';
1892:
1893: -- Only non-Gregorian calendar.
1894: if (calendar_aware = FND_DATE.calendar_aware AND FND_DATE.is_non_gregorian) then
1895: dateval := to_date(charDT, output_mask, 'NLS_CALENDAR='''||FND_DATE.user_calendar||'''');
1896: else
1897: dateval := to_date(charDT, output_mask);
1898: end if;

Line 1895: dateval := to_date(charDT, output_mask, 'NLS_CALENDAR='''||FND_DATE.user_calendar||'''');

1891: output_mask := icx_date_format || ' HH24:MI:SS';
1892:
1893: -- Only non-Gregorian calendar.
1894: if (calendar_aware = FND_DATE.calendar_aware AND FND_DATE.is_non_gregorian) then
1895: dateval := to_date(charDT, output_mask, 'NLS_CALENDAR='''||FND_DATE.user_calendar||'''');
1896: else
1897: dateval := to_date(charDT, output_mask);
1898: end if;
1899:

Line 1900: if fnd_date.timezones_enabled then

1896: else
1897: dateval := to_date(charDT, output_mask);
1898: end if;
1899:
1900: if fnd_date.timezones_enabled then
1901: tz_code := fnd_date.client_timezone_code;
1902:
1903: if tz_code <> fnd_date.server_timezone_code and tz_code <> 'FND_NO_CONVERT' then
1904: dateval := fnd_date.adjust_datetime(dateval, tz_code, fnd_date.server_timezone_code);

Line 1901: tz_code := fnd_date.client_timezone_code;

1897: dateval := to_date(charDT, output_mask);
1898: end if;
1899:
1900: if fnd_date.timezones_enabled then
1901: tz_code := fnd_date.client_timezone_code;
1902:
1903: if tz_code <> fnd_date.server_timezone_code and tz_code <> 'FND_NO_CONVERT' then
1904: dateval := fnd_date.adjust_datetime(dateval, tz_code, fnd_date.server_timezone_code);
1905: end if;

Line 1903: if tz_code <> fnd_date.server_timezone_code and tz_code <> 'FND_NO_CONVERT' then

1899:
1900: if fnd_date.timezones_enabled then
1901: tz_code := fnd_date.client_timezone_code;
1902:
1903: if tz_code <> fnd_date.server_timezone_code and tz_code <> 'FND_NO_CONVERT' then
1904: dateval := fnd_date.adjust_datetime(dateval, tz_code, fnd_date.server_timezone_code);
1905: end if;
1906: end if;
1907:

Line 1904: dateval := fnd_date.adjust_datetime(dateval, tz_code, fnd_date.server_timezone_code);

1900: if fnd_date.timezones_enabled then
1901: tz_code := fnd_date.client_timezone_code;
1902:
1903: if tz_code <> fnd_date.server_timezone_code and tz_code <> 'FND_NO_CONVERT' then
1904: dateval := fnd_date.adjust_datetime(dateval, tz_code, fnd_date.server_timezone_code);
1905: end if;
1906: end if;
1907:
1908: return dateval;