APPS.PON_NEG_UPDATE_PKG dependencies on PON_NEG_TEAM_MEMBERS

Line 641: update pon_neg_team_members

637: -- first, reset the modified flag and last amendment update columns
638:
639: if (p_action = 'MULTIROUND') then
640:
641: update pon_neg_team_members
642: set MODIFIED_FLAG = null,
643: LAST_AMENDMENT_UPDATE = 0
644: where auction_header_id = p_currAuctionHeaderId;
645:

Line 648: update pon_neg_team_members neg

644: where auction_header_id = p_currAuctionHeaderId;
645:
646: else
647:
648: update pon_neg_team_members neg
649: set MODIFIED_FLAG = null,
650: LAST_AMENDMENT_UPDATE = (select nvl(last_amendment_update, 0)
651: from pon_neg_team_members
652: where auction_header_id = p_prevAuctionHeaderId and

Line 651: from pon_neg_team_members

647:
648: update pon_neg_team_members neg
649: set MODIFIED_FLAG = null,
650: LAST_AMENDMENT_UPDATE = (select nvl(last_amendment_update, 0)
651: from pon_neg_team_members
652: where auction_header_id = p_prevAuctionHeaderId and
653: user_id = neg.user_id)
654: where auction_header_id = p_currAuctionHeaderId;
655:

Line 659: update pon_neg_team_members neg

655:
656: -- since above query will set last_amendment_update to null for new rows
657: -- need to set last_amendment_update to current amendment number for those rows
658:
659: update pon_neg_team_members neg
660: set LAST_AMENDMENT_UPDATE = v_currAmendmentNumber
661: where auction_header_id = p_currAuctionHeaderId and
662: last_amendment_update is null;
663:

Line 668: update pon_neg_team_members currNeg

664: end if;
665:
666: -- next, do pairwise comparisons to find updated rows
667:
668: update pon_neg_team_members currNeg
669: set MODIFIED_FLAG = 'Y',
670: LAST_AMENDMENT_UPDATE = v_currAmendmentNumber
671: where auction_header_id = p_currAuctionHeaderId and
672: exists (select null

Line 673: from pon_neg_team_members prevNeg

669: set MODIFIED_FLAG = 'Y',
670: LAST_AMENDMENT_UPDATE = v_currAmendmentNumber
671: where auction_header_id = p_currAuctionHeaderId and
672: exists (select null
673: from pon_neg_team_members prevNeg
674: where prevNeg.auction_header_id = p_prevAuctionHeaderId and
675: prevNeg.user_id = currNeg.user_id and
676:
677: (nvl(prevNeg.approver_flag, 'N') <> nvl(currNeg.approver_flag, 'N') or

Line 1010: insert into pon_neg_team_members

1006: into v_auctionHeaderIdOrigAmend, v_currAmendmentNumber
1007: from pon_auction_headers_all
1008: where auction_header_id = p_currAuctionHeaderId;
1009:
1010: insert into pon_neg_team_members
1011: (auction_header_id,
1012: list_id,
1013: user_id,
1014: menu_name,

Line 1045: pon_neg_team_members pntm

1041: pntm.last_updated_by,
1042: pntm.last_amendment_update,
1043: pntm.modified_flag
1044: from pon_auction_headers_all pah,
1045: pon_neg_team_members pntm
1046: where pah.auction_header_id_orig_amend = v_auctionHeaderIdOrigAmend and
1047: pah.amendment_number < v_currAmendmentNumber and
1048: pntm.auction_header_id = p_currAuctionHeaderId and
1049: pntm.user_id = p_userId;