DBA Data[Home] [Help]

APPS.PON_AUCTION_APPROVAL_PKG dependencies on PON_OEX_TIMEZONE_PKG

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

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

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

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

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;

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

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;

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

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,

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

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

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

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;

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

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

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;

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