APPS.PON_NEG_UPDATE_PKG dependencies on PON_AUCTION_CURRENCY_RATES

Line 579: update pon_auction_currency_rates

575: -- first, reset the modified flag and last amendment update columns
576:
577: if (p_action = 'MULTIROUND') then
578:
579: update pon_auction_currency_rates
580: set MODIFIED_FLAG = null,
581: LAST_AMENDMENT_UPDATE = 0
582: where auction_header_id = p_currAuctionHeaderId;
583:

Line 586: update pon_auction_currency_rates rates

582: where auction_header_id = p_currAuctionHeaderId;
583:
584: else
585:
586: update pon_auction_currency_rates rates
587: set MODIFIED_FLAG = null,
588: LAST_AMENDMENT_UPDATE = (select nvl(last_amendment_update, 0)
589: from pon_auction_currency_rates
590: where auction_header_id = p_prevAuctionHeaderId and

Line 589: from pon_auction_currency_rates

585:
586: update pon_auction_currency_rates rates
587: set MODIFIED_FLAG = null,
588: LAST_AMENDMENT_UPDATE = (select nvl(last_amendment_update, 0)
589: from pon_auction_currency_rates
590: where auction_header_id = p_prevAuctionHeaderId and
591: bid_currency_code = rates.bid_currency_code)
592: where auction_header_id = p_currAuctionHeaderId;
593:

Line 597: update pon_auction_currency_rates rates

593:
594: -- since above query will set last_amendment_update to null for new rows
595: -- need to set last_amendment_update to current amendment number for those rows
596:
597: update pon_auction_currency_rates rates
598: set LAST_AMENDMENT_UPDATE = v_currAmendmentNumber
599: where auction_header_id = p_currAuctionHeaderId and
600: last_amendment_update is null;
601:

Line 606: update pon_auction_currency_rates currRates

602: end if;
603:
604: -- next, do pairwise comparisons to find updated rows
605:
606: update pon_auction_currency_rates currRates
607: set MODIFIED_FLAG = 'Y',
608: LAST_AMENDMENT_UPDATE = v_currAmendmentNumber
609: where auction_header_id = p_currAuctionHeaderId and
610: exists (select null

Line 611: from pon_auction_currency_rates prevRates

607: set MODIFIED_FLAG = 'Y',
608: LAST_AMENDMENT_UPDATE = v_currAmendmentNumber
609: where auction_header_id = p_currAuctionHeaderId and
610: exists (select null
611: from pon_auction_currency_rates prevRates
612: where prevRates.auction_header_id = p_prevAuctionHeaderId and
613: prevRates.bid_currency_code = currRates.bid_currency_code and
614: (nvl(prevRates.rate_dsp, -9999) <> nvl(currRates.rate_dsp, -9999) or
615: nvl(prevRates.number_price_decimals, -9999) <> nvl(currRates.number_price_decimals, -9999)));