DBA Data[Home] [Help]

APPS.PON_AUCTION_APPROVAL_PKG dependencies on PON_OEX_TIMEZONE_PKG

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

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

Line 653: l_open_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(l_open_bidding_date,l_oex_timezone,l_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
657: l_open_date_in_tz := l_open_bidding_date;

Line 654: l_close_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(l_close_bidding_date,l_oex_timezone,l_timezone);

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;

Line 655: l_preview_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(l_preview_date,l_oex_timezone,l_timezone);

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;

Line 1193: l_open_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(r1.open_bidding_date,l_oex_timezone,l_timezone);

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,

Line 1194: l_close_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(r1.close_bidding_date,l_oex_timezone,l_timezone);

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',

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

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;

Line 1687: l_approve_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(l_approve_date,l_oex_timezone,l_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;

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

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;

Line 1812: l_reject_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(l_reject_date,l_oex_timezone,l_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;

Line 2471: l_open_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME( r1.open_bidding_date

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

Line 2474: l_close_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME( r1.close_bidding_date

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