DBA Data[Home] [Help]

APPS.CLN_CH_COLLABORATION_PKG dependencies on FND_TIMEZONES

Line 185: ecx_cln_debug_pub.Add('Server Time Zone : ' || FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE, 1);

181: l_timezone_num := to_number(l_timezone_string);
182: x_doc_creation_date := x_doc_creation_date - trunc(l_timezone_num/100)/24 - mod(l_timezone_num,100)/1440;
183: IF (l_Debug_Level <= 1) THEN
184: ecx_cln_debug_pub.Add('Date after conversion : ' || to_char(x_doc_creation_date,'yyyy-mm-dd-hh24-mi-ss'), 1);
185: ecx_cln_debug_pub.Add('Server Time Zone : ' || FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE, 1);
186: END IF;
187:
188: x_doc_creation_date := fnd_timezones_pvt.adjust_datetime(x_doc_creation_date,'GMT',FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE);
189: IF (l_Debug_Level <= 1) THEN

Line 188: x_doc_creation_date := fnd_timezones_pvt.adjust_datetime(x_doc_creation_date,'GMT',FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE);

184: ecx_cln_debug_pub.Add('Date after conversion : ' || to_char(x_doc_creation_date,'yyyy-mm-dd-hh24-mi-ss'), 1);
185: ecx_cln_debug_pub.Add('Server Time Zone : ' || FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE, 1);
186: END IF;
187:
188: x_doc_creation_date := fnd_timezones_pvt.adjust_datetime(x_doc_creation_date,'GMT',FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE);
189: IF (l_Debug_Level <= 1) THEN
190: ecx_cln_debug_pub.Add('Date after converting to server Time Zone : ' || to_char(x_doc_creation_date,'yyyy-mm-dd-hh24-mi-ss'), 1);
191: END IF;
192: EXCEPTION