DBA Data[Home] [Help]

APPS.OZF_SD_UTIL_PVT dependencies on FND_TIMEZONES

Line 150: l_db_timezone := FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE;

146: --Datetime Format: YYYYMMDDThhmmss.SSSZ
147: l_rn_timezone := fnd_profile.value('CLN_RN_TIMEZONE');
148:
149: -- get the timezone of the db server
150: l_db_timezone := FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE;
151:
152:
153: l_rn_frmt_date := substr(p_rn_date,1,8)||substr(p_rn_date,10,6);
154:

Line 158: x_db_date := FND_TIMEZONES_PVT.adjust_datetime(l_utc_datetime,l_rn_timezone,l_db_timezone);

154:
155: l_utc_datetime := TO_DATE(l_rn_frmt_date,'YYYYMMDDHH24MISS');
156:
157: -- this function converts the datetime from the user entered/db timezone to UTC
158: x_db_date := FND_TIMEZONES_PVT.adjust_datetime(l_utc_datetime,l_rn_timezone,l_db_timezone);
159:
160: ELSE
161: --Date Format : YYYYMMDDZ
162:

Line 563: l_db_timezone := FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE;

559: l_msg_data VARCHAR2(255);
560: BEGIN
561:
562: -- get the timezone of the db server
563: l_db_timezone := FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE;
564:
565: l_rn_timezone := fnd_profile.value('CLN_RN_TIMEZONE');
566:
567:

Line 569: x_utc_date := FND_TIMEZONES_PVT.adjust_datetime(p_input_date,l_db_timezone,l_rn_timezone);

565: l_rn_timezone := fnd_profile.value('CLN_RN_TIMEZONE');
566:
567:
568: -- this function converts the datetime from the user entered/db timezone to UTC
569: x_utc_date := FND_TIMEZONES_PVT.adjust_datetime(p_input_date,l_db_timezone,l_rn_timezone);
570:
571:
572: -- Exception Handling
573: EXCEPTION