APPS.PON_NEG_UPDATE_PKG dependencies on PON_AUCTION_CURRENCY_RATES

Line 521: update pon_auction_currency_rates

517: -- first, reset the modified flag and last amendment update columns
518:
519: if (p_action = 'MULTIROUND') then
520:
521: update pon_auction_currency_rates
522: set MODIFIED_FLAG = null,
523: LAST_AMENDMENT_UPDATE = 0
524: where auction_header_id = p_currAuctionHeaderId;
525:

Line 528: update pon_auction_currency_rates rates

524: where auction_header_id = p_currAuctionHeaderId;
525:
526: else
527:
528: update pon_auction_currency_rates rates
529: set MODIFIED_FLAG = null,
530: LAST_AMENDMENT_UPDATE = (select nvl(last_amendment_update, 0)
531: from pon_auction_currency_rates
532: where auction_header_id = p_prevAuctionHeaderId and

Line 531: from pon_auction_currency_rates

527:
528: update pon_auction_currency_rates rates
529: set MODIFIED_FLAG = null,
530: LAST_AMENDMENT_UPDATE = (select nvl(last_amendment_update, 0)
531: from pon_auction_currency_rates
532: where auction_header_id = p_prevAuctionHeaderId and
533: bid_currency_code = rates.bid_currency_code)
534: where auction_header_id = p_currAuctionHeaderId;
535:

Line 539: update pon_auction_currency_rates rates

535:
536: -- since above query will set last_amendment_update to null for new rows
537: -- need to set last_amendment_update to current amendment number for those rows
538:
539: update pon_auction_currency_rates rates
540: set LAST_AMENDMENT_UPDATE = v_currAmendmentNumber
541: where auction_header_id = p_currAuctionHeaderId and
542: last_amendment_update is null;
543:

Line 548: update pon_auction_currency_rates currRates

544: end if;
545:
546: -- next, do pairwise comparisons to find updated rows
547:
548: update pon_auction_currency_rates currRates
549: set MODIFIED_FLAG = 'Y',
550: LAST_AMENDMENT_UPDATE = v_currAmendmentNumber
551: where auction_header_id = p_currAuctionHeaderId and
552: exists (select null

Line 553: from pon_auction_currency_rates prevRates

549: set MODIFIED_FLAG = 'Y',
550: LAST_AMENDMENT_UPDATE = v_currAmendmentNumber
551: where auction_header_id = p_currAuctionHeaderId and
552: exists (select null
553: from pon_auction_currency_rates prevRates
554: where prevRates.auction_header_id = p_prevAuctionHeaderId and
555: prevRates.bid_currency_code = currRates.bid_currency_code and
556: (nvl(prevRates.rate_dsp, -9999) <> nvl(currRates.rate_dsp, -9999) or
557: nvl(prevRates.number_price_decimals, -9999) <> nvl(currRates.number_price_decimals, -9999)));