APPS.PON_OEX_TIMEZONE_PKG dependencies on PON_OEX_TIMEZONE_PKG

Line 1: PACKAGE BODY PON_OEX_TIMEZONE_PKG as

1: PACKAGE BODY PON_OEX_TIMEZONE_PKG as
2: /* $Header: PONOEXTB.pls 120.5 2010/12/09 07:04:01 sgulkota ship $ */
3:
4: g_module constant varchar2(200) := 'PON.PLSQL.PON_OEX_TIMEZONE_PKG';
5:

Line 4: g_module constant varchar2(200) := 'PON.PLSQL.PON_OEX_TIMEZONE_PKG';

1: PACKAGE BODY PON_OEX_TIMEZONE_PKG as
2: /* $Header: PONOEXTB.pls 120.5 2010/12/09 07:04:01 sgulkota ship $ */
3:
4: g_module constant varchar2(200) := 'PON.PLSQL.PON_OEX_TIMEZONE_PKG';
5:
6: /**
7: * This function returns number because it used to be a java stored procedure
8: * It now takes in HZ_TIMEZONES.TIMEZONE_ID as the timezone name

Line 186: IF (PON_OEX_TIMEZONE_PKG.VALID_ZONE(l_timezone) = 1) THEN

182: IF (l_timezone is null or l_timezone = '') THEN
183: l_timezone := l_oex_timezone;
184: END IF;
185:
186: IF (PON_OEX_TIMEZONE_PKG.VALID_ZONE(l_timezone) = 1) THEN
187: l_progress := '050';
188: IF (x_date_value1 is not null) THEN
189: x_date_value1 := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(x_date_value1,l_oex_timezone,l_timezone);
190: END IF;

Line 189: x_date_value1 := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(x_date_value1,l_oex_timezone,l_timezone);

185:
186: IF (PON_OEX_TIMEZONE_PKG.VALID_ZONE(l_timezone) = 1) THEN
187: l_progress := '050';
188: IF (x_date_value1 is not null) THEN
189: x_date_value1 := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(x_date_value1,l_oex_timezone,l_timezone);
190: END IF;
191:
192: IF (x_date_value2 is not null) THEN
193: x_date_value2 := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(x_date_value2,l_oex_timezone,l_timezone);

Line 193: x_date_value2 := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(x_date_value2,l_oex_timezone,l_timezone);

189: x_date_value1 := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(x_date_value1,l_oex_timezone,l_timezone);
190: END IF;
191:
192: IF (x_date_value2 is not null) THEN
193: x_date_value2 := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(x_date_value2,l_oex_timezone,l_timezone);
194: END IF;
195:
196: IF (x_date_value3 is not null) THEN
197: x_date_value3 := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(x_date_value3,l_oex_timezone,l_timezone);

Line 197: x_date_value3 := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(x_date_value3,l_oex_timezone,l_timezone);

193: x_date_value2 := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(x_date_value2,l_oex_timezone,l_timezone);
194: END IF;
195:
196: IF (x_date_value3 is not null) THEN
197: x_date_value3 := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(x_date_value3,l_oex_timezone,l_timezone);
198: END IF;
199:
200: IF (x_date_value4 is not null) THEN
201: x_date_value4 := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(x_date_value4,l_oex_timezone,l_timezone);

Line 201: x_date_value4 := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(x_date_value4,l_oex_timezone,l_timezone);

197: x_date_value3 := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(x_date_value3,l_oex_timezone,l_timezone);
198: END IF;
199:
200: IF (x_date_value4 is not null) THEN
201: x_date_value4 := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(x_date_value4,l_oex_timezone,l_timezone);
202: END IF;
203:
204: IF (x_date_value5 is not null) THEN
205: x_date_value5 := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(x_date_value5,l_oex_timezone,l_timezone);

Line 205: x_date_value5 := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(x_date_value5,l_oex_timezone,l_timezone);

201: x_date_value4 := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(x_date_value4,l_oex_timezone,l_timezone);
202: END IF;
203:
204: IF (x_date_value5 is not null) THEN
205: x_date_value5 := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(x_date_value5,l_oex_timezone,l_timezone);
206: END IF;
207: ELSE
208: l_progress := '060';
209: l_timezone := l_oex_timezone;

Line 247: END PON_OEX_TIMEZONE_PKG;

243: END IF;
244: END CONVERT_DATE_TO_USER_TZ;
245:
246:
247: END PON_OEX_TIMEZONE_PKG;