APPS.PON_NEG_UPDATE_PKG dependencies on PON_AUCTION_ATTRIBUTES

Line 731: update pon_auction_attributes auctionAttr

727: -- first, reset the modified flag and last amendment update columns
728:
729: if (p_action = 'MULTIROUND') then
730:
731: update pon_auction_attributes auctionAttr
732: set MODIFIED_FLAG = null,
733: MODIFIED_DATE = (select modified_date
734: from pon_auction_attributes
735: where auction_header_id = p_prevAuctionHeaderId and

Line 734: from pon_auction_attributes

730:
731: update pon_auction_attributes auctionAttr
732: set MODIFIED_FLAG = null,
733: MODIFIED_DATE = (select modified_date
734: from pon_auction_attributes
735: where auction_header_id = p_prevAuctionHeaderId and
736: sequence_number = auctionAttr.sequence_number and
737: line_number = -1),
738: LAST_AMENDMENT_UPDATE = 0

Line 745: update pon_auction_attributes auctionAttr

741:
742: -- since above query will set modified_date to null for new rows
743: -- need to set modified_date to sysdate for those rows
744:
745: update pon_auction_attributes auctionAttr
746: set MODIFIED_DATE = sysdate
747: where auction_header_id = p_currAuctionHeaderId and
748: line_number = -1 and
749: modified_date is null;

Line 753: update pon_auction_attributes auctionAttr

749: modified_date is null;
750:
751: else
752:
753: update pon_auction_attributes auctionAttr
754: set MODIFIED_FLAG = null,
755: MODIFIED_DATE = (select modified_date
756: from pon_auction_attributes
757: where auction_header_id = p_prevAuctionHeaderId and

Line 756: from pon_auction_attributes

752:
753: update pon_auction_attributes auctionAttr
754: set MODIFIED_FLAG = null,
755: MODIFIED_DATE = (select modified_date
756: from pon_auction_attributes
757: where auction_header_id = p_prevAuctionHeaderId and
758: sequence_number = auctionAttr.sequence_number and
759: line_number = -1),
760: LAST_AMENDMENT_UPDATE = (select nvl(last_amendment_update, 0)

Line 761: from pon_auction_attributes

757: where auction_header_id = p_prevAuctionHeaderId and
758: sequence_number = auctionAttr.sequence_number and
759: line_number = -1),
760: LAST_AMENDMENT_UPDATE = (select nvl(last_amendment_update, 0)
761: from pon_auction_attributes
762: where auction_header_id = p_prevAuctionHeaderId and
763: sequence_number = auctionAttr.sequence_number and
764: line_number = -1)
765: where auction_header_id = p_currAuctionHeaderId

Line 771: update pon_auction_attributes auctionAttr

767:
768: -- since above query will set modified_date and last_amendment_update to null for new rows
769: -- need to set modified_date and last_amendment_update to sysdate and current amendment number respectively for those rows
770:
771: update pon_auction_attributes auctionAttr
772: set MODIFIED_DATE = sysdate,
773: LAST_AMENDMENT_UPDATE = v_currAmendmentNumber
774: where auction_header_id = p_currAuctionHeaderId and
775: line_number = -1 and

Line 782: update pon_auction_attributes currAttr

778: end if;
779:
780: -- next, do pairwise comparisons to find updated rows
781:
782: update pon_auction_attributes currAttr
783: set MODIFIED_FLAG = 'Y',
784: MODIFIED_DATE = sysdate,
785: LAST_AMENDMENT_UPDATE = v_currAmendmentNumber
786: where auction_header_id = p_currAuctionHeaderId and

Line 789: from pon_auction_attributes prevAttr

785: LAST_AMENDMENT_UPDATE = v_currAmendmentNumber
786: where auction_header_id = p_currAuctionHeaderId and
787: line_number = -1 and
788: exists (select null
789: from pon_auction_attributes prevAttr
790: where prevAttr.auction_header_id = p_prevAuctionHeaderId and
791: prevAttr.line_number = -1 and
792: prevAttr.sequence_number = currAttr.sequence_number and
793: (nvl(currAttr.attribute_name, 'null') <> nvl(prevAttr.attribute_name, 'null') OR