DBA Data[Home] [Help]

APPS.PON_AWARD_APPROVAL_PKG dependencies on PON_OEX_TIMEZONE_PKG

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

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

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

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

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

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);

Line 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:

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

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);

Line 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);

Line 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;