eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_SFCB_UTILITIES dependencies on FND_DATE

Line 1925: return to_char(to_date(p_displaydate, fnd_date.output_mask), fnd_date.outputdt_mask);

1921: /* date only string to datetime string, assuming time component is 00:00:00 */
1922: function displaydate_to_displayDT(p_displaydate IN VARCHAR2) return VARCHAR2
1923: IS
1924: BEGIN
1925: return to_char(to_date(p_displaydate, fnd_date.output_mask), fnd_date.outputdt_mask);
1926: EXCEPTION WHEN OTHERS THEN
1927: return null;
1928: END;
1929:

Line 1934: return fnd_date.displaydt_to_date(charDT => displaydate_to_displayDT(p_displaydate ),calendar_aware => 2);

1930: /* take a client date only string and convert it to sever time, assuming time is 0 */
1931: function displaydate_to_date_tz(p_displaydate IN VARCHAR2) return DATE
1932: IS
1933: BEGIN
1934: return fnd_date.displaydt_to_date(charDT => displaydate_to_displayDT(p_displaydate ),calendar_aware => 2);
1935: EXCEPTION WHEN OTHERS THEN
1936: return null;
1937: END;
1938:

Line 1944: return fnd_date.displaydt_to_date(charDT => p_displaydt,calendar_aware => 2);

1940: can be used to validate the format too */
1941: function displaydt_to_date_tz(p_displaydt IN VARCHAR2) return DATE
1942: IS
1943: BEGIN
1944: return fnd_date.displaydt_to_date(charDT => p_displaydt,calendar_aware => 2);
1945: EXCEPTION WHEN OTHERS THEN
1946: return null;
1947: END;
1948:

Line 1957: tmp := fnd_date.outputdt_mask;

1953: IS
1954: tmp VARCHAR2(255);
1955: ret VARCHAR2(255);
1956: BEGIN
1957: tmp := fnd_date.outputdt_mask;
1958: -- using date only mask to to the converstion
1959: fnd_date.outputdt_mask := fnd_date.output_mask;
1960: ret := fnd_date.date_to_displaydt(dateval => p_date,calendar_aware => 2);
1961: fnd_date.outputdt_mask := tmp;

Line 1959: fnd_date.outputdt_mask := fnd_date.output_mask;

1955: ret VARCHAR2(255);
1956: BEGIN
1957: tmp := fnd_date.outputdt_mask;
1958: -- using date only mask to to the converstion
1959: fnd_date.outputdt_mask := fnd_date.output_mask;
1960: ret := fnd_date.date_to_displaydt(dateval => p_date,calendar_aware => 2);
1961: fnd_date.outputdt_mask := tmp;
1962:
1963: return ret;

Line 1960: ret := fnd_date.date_to_displaydt(dateval => p_date,calendar_aware => 2);

1956: BEGIN
1957: tmp := fnd_date.outputdt_mask;
1958: -- using date only mask to to the converstion
1959: fnd_date.outputdt_mask := fnd_date.output_mask;
1960: ret := fnd_date.date_to_displaydt(dateval => p_date,calendar_aware => 2);
1961: fnd_date.outputdt_mask := tmp;
1962:
1963: return ret;
1964: END;

Line 1961: fnd_date.outputdt_mask := tmp;

1957: tmp := fnd_date.outputdt_mask;
1958: -- using date only mask to to the converstion
1959: fnd_date.outputdt_mask := fnd_date.output_mask;
1960: ret := fnd_date.date_to_displaydt(dateval => p_date,calendar_aware => 2);
1961: fnd_date.outputdt_mask := tmp;
1962:
1963: return ret;
1964: END;
1965:

Line 1971: return fnd_date.date_to_displayDT(dateval => p_date,calendar_aware => 2);

1967: * the return value contains the time portion */
1968: function date_to_displaydt_tz(p_date IN DATE) return VARCHAR2
1969: IS
1970: BEGIN
1971: return fnd_date.date_to_displayDT(dateval => p_date,calendar_aware => 2);
1972: EXCEPTION WHEN OTHERS THEN
1973: return null;
1974: END;
1975:

Line 1984: select to_date(p_date, fnd_date.output_mask)

1980: t_date DATE;
1981: ret VARCHAR2(4) := FND_API.G_TRUE;
1982: BEGIN
1983: BEGIN
1984: select to_date(p_date, fnd_date.output_mask)
1985: into t_date
1986: from dual;
1987: EXCEPTION WHEN OTHERS THEN
1988: ret := FND_API.G_FALSE;

Line 2000: select to_date(p_date, fnd_date.outputdt_mask)

1996: t_date DATE;
1997: ret VARCHAR2(4) := FND_API.G_TRUE;
1998: BEGIN
1999: BEGIN
2000: select to_date(p_date, fnd_date.outputdt_mask)
2001: into t_date
2002: from dual;
2003: EXCEPTION WHEN OTHERS THEN
2004: ret := FND_API.G_FALSE;

Line 2013: return to_date(fnd_date.date_to_displaydt(dateval => p_sdate,calendar_aware => 2), fnd_date.outputdt_mask);

2009: /* convert server date to client date, by faking it. */
2010: function sdate_to_cdate(p_sdate IN DATE) return DATE
2011: IS
2012: BEGIN
2013: return to_date(fnd_date.date_to_displaydt(dateval => p_sdate,calendar_aware => 2), fnd_date.outputdt_mask);
2014: END;
2015:
2016: /* convert a client date back to server date. use it carefully */
2017: function cdate_to_sdate(p_cdate IN DATE) return DATE

Line 2020: return fnd_date.displaydt_to_date(charDT => to_char(p_cdate, fnd_date.outputdt_mask), calendar_aware => 2);

2016: /* convert a client date back to server date. use it carefully */
2017: function cdate_to_sdate(p_cdate IN DATE) return DATE
2018: IS
2019: BEGIN
2020: return fnd_date.displaydt_to_date(charDT => to_char(p_cdate, fnd_date.outputdt_mask), calendar_aware => 2);
2021: END;
2022:
2023:
2024: /* returns the number of hours between the given datetimes */

Line 2031: select to_date(p_to_dt,fnd_date.outputdt_mask) - to_date(p_from_dt,fnd_date.outputdt_mask)

2027: IS
2028: diff NUMBER; --difference in dt's, in days
2029: BEGIN
2030: BEGIN
2031: select to_date(p_to_dt,fnd_date.outputdt_mask) - to_date(p_from_dt,fnd_date.outputdt_mask)
2032: into diff
2033: from dual;
2034: EXCEPTION WHEN OTHERS THEN
2035: return FND_API.G_RET_STS_ERROR;

Line 2057: fnd_date.initialize(p_output_mask, p_outputdt_mask);

2053: */
2054: procedure init_timezone(p_output_mask IN VARCHAR2, p_outputdt_mask IN VARCHAR2)
2055: IS
2056: BEGIN
2057: fnd_date.initialize(p_output_mask, p_outputdt_mask);
2058:
2059: -- comment out the code because it depends on the fnd timezone patch.
2060: /*
2061: fnd_date.client_timezone_code := fnd_timezones.get_code( fnd_profile.value('CLIENT_TIMEZONE_ID'));

Line 2061: fnd_date.client_timezone_code := fnd_timezones.get_code( fnd_profile.value('CLIENT_TIMEZONE_ID'));

2057: fnd_date.initialize(p_output_mask, p_outputdt_mask);
2058:
2059: -- comment out the code because it depends on the fnd timezone patch.
2060: /*
2061: fnd_date.client_timezone_code := fnd_timezones.get_code( fnd_profile.value('CLIENT_TIMEZONE_ID'));
2062: fnd_date.server_timezone_code := fnd_timezones.get_code( fnd_profile.value('SERVER_TIMEZONE_ID'));
2063:
2064: if( fnd_timezones.timezones_enabled = 'Y') then
2065: fnd_date.timezones_enabled := true;

Line 2062: fnd_date.server_timezone_code := fnd_timezones.get_code( fnd_profile.value('SERVER_TIMEZONE_ID'));

2058:
2059: -- comment out the code because it depends on the fnd timezone patch.
2060: /*
2061: fnd_date.client_timezone_code := fnd_timezones.get_code( fnd_profile.value('CLIENT_TIMEZONE_ID'));
2062: fnd_date.server_timezone_code := fnd_timezones.get_code( fnd_profile.value('SERVER_TIMEZONE_ID'));
2063:
2064: if( fnd_timezones.timezones_enabled = 'Y') then
2065: fnd_date.timezones_enabled := true;
2066: else

Line 2065: fnd_date.timezones_enabled := true;

2061: fnd_date.client_timezone_code := fnd_timezones.get_code( fnd_profile.value('CLIENT_TIMEZONE_ID'));
2062: fnd_date.server_timezone_code := fnd_timezones.get_code( fnd_profile.value('SERVER_TIMEZONE_ID'));
2063:
2064: if( fnd_timezones.timezones_enabled = 'Y') then
2065: fnd_date.timezones_enabled := true;
2066: else
2067: fnd_date.timezones_enabled := false;
2068: end if;
2069: */

Line 2067: fnd_date.timezones_enabled := false;

2063:
2064: if( fnd_timezones.timezones_enabled = 'Y') then
2065: fnd_date.timezones_enabled := true;
2066: else
2067: fnd_date.timezones_enabled := false;
2068: end if;
2069: */
2070:
2071: END;