DBA Data[Home] [Help]

APPS.PON_AWARD_APPROVAL_PKG dependencies on PON_OEX_TIMEZONE_PKG

Line 595: IF PON_OEX_TIMEZONE_PKG.valid_zone(l_user_timezone) = 1 THEN

591: l_preview_date := wf_engine.getItemAttrDate(itemtype => p_item_type,
592: itemkey => p_item_key,
593: aname => 'PREVIEW_DATE');
594:
595: IF PON_OEX_TIMEZONE_PKG.valid_zone(l_user_timezone) = 1 THEN
596: l_open_bidding_date_tz := PON_OEX_TIMEZONE_PKG.convert_time(l_open_bidding_date, l_server_timezone, l_user_timezone);
597: l_close_bidding_date_tz := PON_OEX_TIMEZONE_PKG.convert_time(l_close_bidding_date, l_server_timezone, l_user_timezone);
598:
599: -- the award by date may be null

Line 596: l_open_bidding_date_tz := PON_OEX_TIMEZONE_PKG.convert_time(l_open_bidding_date, l_server_timezone, l_user_timezone);

592: itemkey => p_item_key,
593: aname => 'PREVIEW_DATE');
594:
595: IF PON_OEX_TIMEZONE_PKG.valid_zone(l_user_timezone) = 1 THEN
596: l_open_bidding_date_tz := PON_OEX_TIMEZONE_PKG.convert_time(l_open_bidding_date, l_server_timezone, l_user_timezone);
597: l_close_bidding_date_tz := PON_OEX_TIMEZONE_PKG.convert_time(l_close_bidding_date, l_server_timezone, l_user_timezone);
598:
599: -- the award by date may be null
600: IF l_award_by_date IS NOT NULL THEN

Line 597: l_close_bidding_date_tz := PON_OEX_TIMEZONE_PKG.convert_time(l_close_bidding_date, l_server_timezone, l_user_timezone);

593: aname => 'PREVIEW_DATE');
594:
595: IF PON_OEX_TIMEZONE_PKG.valid_zone(l_user_timezone) = 1 THEN
596: l_open_bidding_date_tz := PON_OEX_TIMEZONE_PKG.convert_time(l_open_bidding_date, l_server_timezone, l_user_timezone);
597: l_close_bidding_date_tz := PON_OEX_TIMEZONE_PKG.convert_time(l_close_bidding_date, l_server_timezone, l_user_timezone);
598:
599: -- the award by date may be null
600: IF l_award_by_date IS NOT NULL THEN
601: l_award_by_date_tz := PON_OEX_TIMEZONE_PKG.convert_time(l_award_by_date, l_server_timezone, l_user_timezone);

Line 601: l_award_by_date_tz := PON_OEX_TIMEZONE_PKG.convert_time(l_award_by_date, l_server_timezone, l_user_timezone);

597: l_close_bidding_date_tz := PON_OEX_TIMEZONE_PKG.convert_time(l_close_bidding_date, l_server_timezone, l_user_timezone);
598:
599: -- the award by date may be null
600: IF l_award_by_date IS NOT NULL THEN
601: l_award_by_date_tz := PON_OEX_TIMEZONE_PKG.convert_time(l_award_by_date, l_server_timezone, l_user_timezone);
602: ELSE
603: l_award_by_date_tz := NULL;
604: END IF;
605:

Line 607: l_approval_date_tz := PON_OEX_TIMEZONE_PKG.convert_time(l_approval_date, l_server_timezone, l_user_timezone);

603: l_award_by_date_tz := NULL;
604: END IF;
605:
606: IF p_set_approval_date THEN
607: l_approval_date_tz := PON_OEX_TIMEZONE_PKG.convert_time(l_approval_date, l_server_timezone, l_user_timezone);
608: END IF;
609:
610: IF p_set_rejection_date THEN
611: l_rejection_date_tz := PON_OEX_TIMEZONE_PKG.convert_time(l_rejection_date, l_server_timezone, l_user_timezone);

Line 611: l_rejection_date_tz := PON_OEX_TIMEZONE_PKG.convert_time(l_rejection_date, l_server_timezone, l_user_timezone);

607: l_approval_date_tz := PON_OEX_TIMEZONE_PKG.convert_time(l_approval_date, l_server_timezone, l_user_timezone);
608: END IF;
609:
610: IF p_set_rejection_date THEN
611: l_rejection_date_tz := PON_OEX_TIMEZONE_PKG.convert_time(l_rejection_date, l_server_timezone, l_user_timezone);
612: END IF;
613:
614: IF l_preview_date IS NOT NULL THEN
615: l_preview_date_tz := PON_OEX_TIMEZONE_PKG.convert_time(l_preview_date, l_server_timezone, l_user_timezone);

Line 615: l_preview_date_tz := PON_OEX_TIMEZONE_PKG.convert_time(l_preview_date, l_server_timezone, l_user_timezone);

611: l_rejection_date_tz := PON_OEX_TIMEZONE_PKG.convert_time(l_rejection_date, l_server_timezone, l_user_timezone);
612: END IF;
613:
614: IF l_preview_date IS NOT NULL THEN
615: l_preview_date_tz := PON_OEX_TIMEZONE_PKG.convert_time(l_preview_date, l_server_timezone, l_user_timezone);
616: END IF;
617: ELSE
618: l_user_timezone := l_server_timezone;
619: l_open_bidding_date_tz := l_open_bidding_date;