APPS.PON_NEG_UPDATE_PKG dependencies on PON_AUCTION_ATTRIBUTES

Line 789: update pon_auction_attributes auctionAttr

785: -- first, reset the modified flag and last amendment update columns
786:
787: if (p_action = 'MULTIROUND') then
788:
789: update pon_auction_attributes auctionAttr
790: set MODIFIED_FLAG = null,
791: MODIFIED_DATE = (select modified_date
792: from pon_auction_attributes
793: where auction_header_id = p_prevAuctionHeaderId and

Line 792: from pon_auction_attributes

788:
789: update pon_auction_attributes auctionAttr
790: set MODIFIED_FLAG = null,
791: MODIFIED_DATE = (select modified_date
792: from pon_auction_attributes
793: where auction_header_id = p_prevAuctionHeaderId and
794: sequence_number = auctionAttr.sequence_number and
795: line_number = -1),
796: LAST_AMENDMENT_UPDATE = 0

Line 803: update pon_auction_attributes auctionAttr

799:
800: -- since above query will set modified_date to null for new rows
801: -- need to set modified_date to sysdate for those rows
802:
803: update pon_auction_attributes auctionAttr
804: set MODIFIED_DATE = sysdate
805: where auction_header_id = p_currAuctionHeaderId and
806: line_number = -1 and
807: modified_date is null;

Line 811: update pon_auction_attributes auctionAttr

807: modified_date is null;
808:
809: else
810:
811: update pon_auction_attributes auctionAttr
812: set MODIFIED_FLAG = null,
813: MODIFIED_DATE = (select modified_date
814: from pon_auction_attributes
815: where auction_header_id = p_prevAuctionHeaderId and

Line 814: from pon_auction_attributes

810:
811: update pon_auction_attributes auctionAttr
812: set MODIFIED_FLAG = null,
813: MODIFIED_DATE = (select modified_date
814: from pon_auction_attributes
815: where auction_header_id = p_prevAuctionHeaderId and
816: sequence_number = auctionAttr.sequence_number and
817: line_number = -1),
818: LAST_AMENDMENT_UPDATE = (select nvl(last_amendment_update, 0)

Line 819: from pon_auction_attributes

815: where auction_header_id = p_prevAuctionHeaderId and
816: sequence_number = auctionAttr.sequence_number and
817: line_number = -1),
818: LAST_AMENDMENT_UPDATE = (select nvl(last_amendment_update, 0)
819: from pon_auction_attributes
820: where auction_header_id = p_prevAuctionHeaderId and
821: sequence_number = auctionAttr.sequence_number and
822: line_number = -1)
823: where auction_header_id = p_currAuctionHeaderId

Line 829: update pon_auction_attributes auctionAttr

825:
826: -- since above query will set modified_date and last_amendment_update to null for new rows
827: -- need to set modified_date and last_amendment_update to sysdate and current amendment number respectively for those rows
828:
829: update pon_auction_attributes auctionAttr
830: set MODIFIED_DATE = sysdate,
831: LAST_AMENDMENT_UPDATE = v_currAmendmentNumber
832: where auction_header_id = p_currAuctionHeaderId and
833: line_number = -1 and

Line 840: update pon_auction_attributes currAttr

836: end if;
837:
838: -- next, do pairwise comparisons to find updated rows
839:
840: update pon_auction_attributes currAttr
841: set MODIFIED_FLAG = 'Y',
842: MODIFIED_DATE = sysdate,
843: LAST_AMENDMENT_UPDATE = v_currAmendmentNumber
844: where auction_header_id = p_currAuctionHeaderId and

Line 847: from pon_auction_attributes prevAttr

843: LAST_AMENDMENT_UPDATE = v_currAmendmentNumber
844: where auction_header_id = p_currAuctionHeaderId and
845: line_number = -1 and
846: exists (select null
847: from pon_auction_attributes prevAttr
848: where prevAttr.auction_header_id = p_prevAuctionHeaderId and
849: prevAttr.line_number = -1 and
850: prevAttr.sequence_number = currAttr.sequence_number and
851: (nvl(currAttr.attribute_name, 'null') <> nvl(prevAttr.attribute_name, 'null') OR