605: l_preview_date := wf_engine.getItemAttrDate(itemtype => p_item_type,
606: itemkey => p_item_key,
607: aname => 'PREVIEW_DATE');
608:
609: IF PON_OEX_TIMEZONE_PKG.valid_zone(l_user_timezone) = 1 THEN
610: l_open_bidding_date_tz := PON_OEX_TIMEZONE_PKG.convert_time(l_open_bidding_date, l_server_timezone, l_user_timezone);
611: l_close_bidding_date_tz := PON_OEX_TIMEZONE_PKG.convert_time(l_close_bidding_date, l_server_timezone, l_user_timezone);
612:
613: -- the award by date may be null
606: itemkey => p_item_key,
607: aname => 'PREVIEW_DATE');
608:
609: IF PON_OEX_TIMEZONE_PKG.valid_zone(l_user_timezone) = 1 THEN
610: l_open_bidding_date_tz := PON_OEX_TIMEZONE_PKG.convert_time(l_open_bidding_date, l_server_timezone, l_user_timezone);
611: l_close_bidding_date_tz := PON_OEX_TIMEZONE_PKG.convert_time(l_close_bidding_date, l_server_timezone, l_user_timezone);
612:
613: -- the award by date may be null
614: IF l_award_by_date IS NOT NULL THEN
607: aname => 'PREVIEW_DATE');
608:
609: IF PON_OEX_TIMEZONE_PKG.valid_zone(l_user_timezone) = 1 THEN
610: l_open_bidding_date_tz := PON_OEX_TIMEZONE_PKG.convert_time(l_open_bidding_date, l_server_timezone, l_user_timezone);
611: l_close_bidding_date_tz := PON_OEX_TIMEZONE_PKG.convert_time(l_close_bidding_date, l_server_timezone, l_user_timezone);
612:
613: -- the award by date may be null
614: IF l_award_by_date IS NOT NULL THEN
615: l_award_by_date_tz := PON_OEX_TIMEZONE_PKG.convert_time(l_award_by_date, l_server_timezone, l_user_timezone);
611: l_close_bidding_date_tz := PON_OEX_TIMEZONE_PKG.convert_time(l_close_bidding_date, l_server_timezone, l_user_timezone);
612:
613: -- the award by date may be null
614: IF l_award_by_date IS NOT NULL THEN
615: l_award_by_date_tz := PON_OEX_TIMEZONE_PKG.convert_time(l_award_by_date, l_server_timezone, l_user_timezone);
616: ELSE
617: l_award_by_date_tz := NULL;
618: END IF;
619:
617: l_award_by_date_tz := NULL;
618: END IF;
619:
620: IF p_set_approval_date THEN
621: l_approval_date_tz := PON_OEX_TIMEZONE_PKG.convert_time(l_approval_date, l_server_timezone, l_user_timezone);
622: END IF;
623:
624: IF p_set_rejection_date THEN
625: l_rejection_date_tz := PON_OEX_TIMEZONE_PKG.convert_time(l_rejection_date, l_server_timezone, l_user_timezone);
621: l_approval_date_tz := PON_OEX_TIMEZONE_PKG.convert_time(l_approval_date, l_server_timezone, l_user_timezone);
622: END IF;
623:
624: IF p_set_rejection_date THEN
625: l_rejection_date_tz := PON_OEX_TIMEZONE_PKG.convert_time(l_rejection_date, l_server_timezone, l_user_timezone);
626: END IF;
627:
628: IF l_preview_date IS NOT NULL THEN
629: l_preview_date_tz := PON_OEX_TIMEZONE_PKG.convert_time(l_preview_date, l_server_timezone, l_user_timezone);
625: l_rejection_date_tz := PON_OEX_TIMEZONE_PKG.convert_time(l_rejection_date, l_server_timezone, l_user_timezone);
626: END IF;
627:
628: IF l_preview_date IS NOT NULL THEN
629: l_preview_date_tz := PON_OEX_TIMEZONE_PKG.convert_time(l_preview_date, l_server_timezone, l_user_timezone);
630: END IF;
631: ELSE
632: l_user_timezone := l_server_timezone;
633: l_open_bidding_date_tz := l_open_bidding_date;