648: l_timezone := l_oex_timezone;
649: end if;
650:
651:
652: IF (PON_OEX_TIMEZONE_PKG.VALID_ZONE(l_timezone) = 1) THEN
653: l_open_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(l_open_bidding_date,l_oex_timezone,l_timezone);
654: l_close_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(l_close_bidding_date,l_oex_timezone,l_timezone);
655: l_preview_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(l_preview_date,l_oex_timezone,l_timezone);
656: ELSE
649: end if;
650:
651:
652: IF (PON_OEX_TIMEZONE_PKG.VALID_ZONE(l_timezone) = 1) THEN
653: l_open_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(l_open_bidding_date,l_oex_timezone,l_timezone);
654: l_close_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(l_close_bidding_date,l_oex_timezone,l_timezone);
655: l_preview_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(l_preview_date,l_oex_timezone,l_timezone);
656: ELSE
657: l_open_date_in_tz := l_open_bidding_date;
650:
651:
652: IF (PON_OEX_TIMEZONE_PKG.VALID_ZONE(l_timezone) = 1) THEN
653: l_open_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(l_open_bidding_date,l_oex_timezone,l_timezone);
654: l_close_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(l_close_bidding_date,l_oex_timezone,l_timezone);
655: l_preview_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(l_preview_date,l_oex_timezone,l_timezone);
656: ELSE
657: l_open_date_in_tz := l_open_bidding_date;
658: l_close_date_in_tz := l_close_bidding_date;
651:
652: IF (PON_OEX_TIMEZONE_PKG.VALID_ZONE(l_timezone) = 1) THEN
653: l_open_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(l_open_bidding_date,l_oex_timezone,l_timezone);
654: l_close_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(l_close_bidding_date,l_oex_timezone,l_timezone);
655: l_preview_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(l_preview_date,l_oex_timezone,l_timezone);
656: ELSE
657: l_open_date_in_tz := l_open_bidding_date;
658: l_close_date_in_tz := l_close_bidding_date;
659: l_preview_date_in_tz := l_preview_date;
1189: itemkey => l_itemKey,
1190: aname => 'TIMEZONE',
1191: avalue => l_timezone_disp);
1192:
1193: l_open_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(r1.open_bidding_date,l_oex_timezone,l_timezone);
1194: l_close_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(r1.close_bidding_date,l_oex_timezone,l_timezone);
1195:
1196: wf_engine.SetItemAttrDate (itemtype => l_itemType,
1197: itemkey => l_itemKey,
1190: aname => 'TIMEZONE',
1191: avalue => l_timezone_disp);
1192:
1193: l_open_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(r1.open_bidding_date,l_oex_timezone,l_timezone);
1194: l_close_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(r1.close_bidding_date,l_oex_timezone,l_timezone);
1195:
1196: wf_engine.SetItemAttrDate (itemtype => l_itemType,
1197: itemkey => l_itemKey,
1198: aname => 'AUCTION_START_DATE',
1682:
1683:
1684: -- Convert the date to the user's timezone.
1685: -- If the timezone is not recognized, just use server timezone
1686: IF (PON_OEX_TIMEZONE_PKG.VALID_ZONE(l_timezone) = 1) THEN
1687: l_approve_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(l_approve_date,l_oex_timezone,l_timezone);
1688: ELSE
1689: l_approve_date_in_tz := l_approve_date;
1690: l_timezone := l_oex_timezone;
1683:
1684: -- Convert the date to the user's timezone.
1685: -- If the timezone is not recognized, just use server timezone
1686: IF (PON_OEX_TIMEZONE_PKG.VALID_ZONE(l_timezone) = 1) THEN
1687: l_approve_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(l_approve_date,l_oex_timezone,l_timezone);
1688: ELSE
1689: l_approve_date_in_tz := l_approve_date;
1690: l_timezone := l_oex_timezone;
1691: END IF;
1807:
1808:
1809: -- Convert the date to the user's timezone.
1810: -- If the timezone is not recognized, just use server timezone
1811: IF (PON_OEX_TIMEZONE_PKG.VALID_ZONE(l_timezone) = 1) THEN
1812: l_reject_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(l_reject_date,l_oex_timezone,l_timezone);
1813: ELSE
1814: l_reject_date_in_tz := l_reject_date;
1815: l_timezone := l_oex_timezone;
1808:
1809: -- Convert the date to the user's timezone.
1810: -- If the timezone is not recognized, just use server timezone
1811: IF (PON_OEX_TIMEZONE_PKG.VALID_ZONE(l_timezone) = 1) THEN
1812: l_reject_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(l_reject_date,l_oex_timezone,l_timezone);
1813: ELSE
1814: l_reject_date_in_tz := l_reject_date;
1815: l_timezone := l_oex_timezone;
1816: END IF;
2467: , itemkey => l_itemKey
2468: , aname => 'TIMEZONE'
2469: , avalue => l_timezone_disp);
2470:
2471: l_open_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME( r1.open_bidding_date
2472: , l_oex_timezone
2473: , l_timezone);
2474: l_close_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME( r1.close_bidding_date
2475: , l_oex_timezone
2470:
2471: l_open_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME( r1.open_bidding_date
2472: , l_oex_timezone
2473: , l_timezone);
2474: l_close_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME( r1.close_bidding_date
2475: , l_oex_timezone
2476: , l_timezone);
2477:
2478: wf_engine.SetItemAttrDate(itemtype => l_itemType