459: l_timezone := l_oex_timezone;
460: end if;
461:
462:
463: IF (PON_OEX_TIMEZONE_PKG.VALID_ZONE(l_timezone) = 1) THEN
464: l_open_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(l_open_bidding_date,l_oex_timezone,l_timezone);
465: l_close_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(l_close_bidding_date,l_oex_timezone,l_timezone);
466: l_preview_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(l_preview_date,l_oex_timezone,l_timezone);
467: ELSE
460: end if;
461:
462:
463: IF (PON_OEX_TIMEZONE_PKG.VALID_ZONE(l_timezone) = 1) THEN
464: l_open_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(l_open_bidding_date,l_oex_timezone,l_timezone);
465: l_close_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(l_close_bidding_date,l_oex_timezone,l_timezone);
466: l_preview_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(l_preview_date,l_oex_timezone,l_timezone);
467: ELSE
468: l_open_date_in_tz := l_open_bidding_date;
461:
462:
463: IF (PON_OEX_TIMEZONE_PKG.VALID_ZONE(l_timezone) = 1) THEN
464: l_open_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(l_open_bidding_date,l_oex_timezone,l_timezone);
465: l_close_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(l_close_bidding_date,l_oex_timezone,l_timezone);
466: l_preview_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(l_preview_date,l_oex_timezone,l_timezone);
467: ELSE
468: l_open_date_in_tz := l_open_bidding_date;
469: l_close_date_in_tz := l_close_bidding_date;
462:
463: IF (PON_OEX_TIMEZONE_PKG.VALID_ZONE(l_timezone) = 1) THEN
464: l_open_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(l_open_bidding_date,l_oex_timezone,l_timezone);
465: l_close_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(l_close_bidding_date,l_oex_timezone,l_timezone);
466: l_preview_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(l_preview_date,l_oex_timezone,l_timezone);
467: ELSE
468: l_open_date_in_tz := l_open_bidding_date;
469: l_close_date_in_tz := l_close_bidding_date;
470: l_preview_date_in_tz := l_preview_date;
951: itemkey => l_itemKey,
952: aname => 'TIMEZONE',
953: avalue => l_timezone_disp);
954:
955: l_open_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(r1.open_bidding_date,l_oex_timezone,l_timezone);
956: l_close_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(r1.close_bidding_date,l_oex_timezone,l_timezone);
957:
958: wf_engine.SetItemAttrDate (itemtype => l_itemType,
959: itemkey => l_itemKey,
952: aname => 'TIMEZONE',
953: avalue => l_timezone_disp);
954:
955: l_open_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(r1.open_bidding_date,l_oex_timezone,l_timezone);
956: l_close_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(r1.close_bidding_date,l_oex_timezone,l_timezone);
957:
958: wf_engine.SetItemAttrDate (itemtype => l_itemType,
959: itemkey => l_itemKey,
960: aname => 'AUCTION_START_DATE',
1254:
1255:
1256: -- Convert the date to the user's timezone.
1257: -- If the timezone is not recognized, just use server timezone
1258: IF (PON_OEX_TIMEZONE_PKG.VALID_ZONE(l_timezone) = 1) THEN
1259: l_approve_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(l_approve_date,l_oex_timezone,l_timezone);
1260: ELSE
1261: l_approve_date_in_tz := l_approve_date;
1262: l_timezone := l_oex_timezone;
1255:
1256: -- Convert the date to the user's timezone.
1257: -- If the timezone is not recognized, just use server timezone
1258: IF (PON_OEX_TIMEZONE_PKG.VALID_ZONE(l_timezone) = 1) THEN
1259: l_approve_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(l_approve_date,l_oex_timezone,l_timezone);
1260: ELSE
1261: l_approve_date_in_tz := l_approve_date;
1262: l_timezone := l_oex_timezone;
1263: END IF;
1353:
1354:
1355: -- Convert the date to the user's timezone.
1356: -- If the timezone is not recognized, just use server timezone
1357: IF (PON_OEX_TIMEZONE_PKG.VALID_ZONE(l_timezone) = 1) THEN
1358: l_reject_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(l_reject_date,l_oex_timezone,l_timezone);
1359: ELSE
1360: l_reject_date_in_tz := l_reject_date;
1361: l_timezone := l_oex_timezone;
1354:
1355: -- Convert the date to the user's timezone.
1356: -- If the timezone is not recognized, just use server timezone
1357: IF (PON_OEX_TIMEZONE_PKG.VALID_ZONE(l_timezone) = 1) THEN
1358: l_reject_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(l_reject_date,l_oex_timezone,l_timezone);
1359: ELSE
1360: l_reject_date_in_tz := l_reject_date;
1361: l_timezone := l_oex_timezone;
1362: END IF;