APPS.PON_NEG_UPDATE_PKG dependencies on PON_NEG_TEAM_MEMBERS

Line 583: update pon_neg_team_members

579: -- first, reset the modified flag and last amendment update columns
580:
581: if (p_action = 'MULTIROUND') then
582:
583: update pon_neg_team_members
584: set MODIFIED_FLAG = null,
585: LAST_AMENDMENT_UPDATE = 0
586: where auction_header_id = p_currAuctionHeaderId;
587:

Line 590: update pon_neg_team_members neg

586: where auction_header_id = p_currAuctionHeaderId;
587:
588: else
589:
590: update pon_neg_team_members neg
591: set MODIFIED_FLAG = null,
592: LAST_AMENDMENT_UPDATE = (select nvl(last_amendment_update, 0)
593: from pon_neg_team_members
594: where auction_header_id = p_prevAuctionHeaderId and

Line 593: from pon_neg_team_members

589:
590: update pon_neg_team_members neg
591: set MODIFIED_FLAG = null,
592: LAST_AMENDMENT_UPDATE = (select nvl(last_amendment_update, 0)
593: from pon_neg_team_members
594: where auction_header_id = p_prevAuctionHeaderId and
595: user_id = neg.user_id)
596: where auction_header_id = p_currAuctionHeaderId;
597:

Line 601: update pon_neg_team_members neg

597:
598: -- since above query will set last_amendment_update to null for new rows
599: -- need to set last_amendment_update to current amendment number for those rows
600:
601: update pon_neg_team_members neg
602: set LAST_AMENDMENT_UPDATE = v_currAmendmentNumber
603: where auction_header_id = p_currAuctionHeaderId and
604: last_amendment_update is null;
605:

Line 610: update pon_neg_team_members currNeg

606: end if;
607:
608: -- next, do pairwise comparisons to find updated rows
609:
610: update pon_neg_team_members currNeg
611: set MODIFIED_FLAG = 'Y',
612: LAST_AMENDMENT_UPDATE = v_currAmendmentNumber
613: where auction_header_id = p_currAuctionHeaderId and
614: exists (select null

Line 615: from pon_neg_team_members prevNeg

611: set MODIFIED_FLAG = 'Y',
612: LAST_AMENDMENT_UPDATE = v_currAmendmentNumber
613: where auction_header_id = p_currAuctionHeaderId and
614: exists (select null
615: from pon_neg_team_members prevNeg
616: where prevNeg.auction_header_id = p_prevAuctionHeaderId and
617: prevNeg.user_id = currNeg.user_id and
618:
619: (nvl(prevNeg.approver_flag, 'N') <> nvl(currNeg.approver_flag, 'N') or

Line 952: insert into pon_neg_team_members

948: into v_auctionHeaderIdOrigAmend, v_currAmendmentNumber
949: from pon_auction_headers_all
950: where auction_header_id = p_currAuctionHeaderId;
951:
952: insert into pon_neg_team_members
953: (auction_header_id,
954: list_id,
955: user_id,
956: menu_name,

Line 987: pon_neg_team_members pntm

983: pntm.last_updated_by,
984: pntm.last_amendment_update,
985: pntm.modified_flag
986: from pon_auction_headers_all pah,
987: pon_neg_team_members pntm
988: where pah.auction_header_id_orig_amend = v_auctionHeaderIdOrigAmend and
989: pah.amendment_number < v_currAmendmentNumber and
990: pntm.auction_header_id = p_currAuctionHeaderId and
991: pntm.user_id = p_userId;