APPS.PON_NEG_UPDATE_PKG dependencies on PON_BIDDING_PARTIES

Line 712: update pon_bidding_parties

708: -- this will influence all sql below...
709:
710: if (p_action = 'MULTIROUND') then
711:
712: update pon_bidding_parties
713: set MODIFIED_FLAG = null,
714: LAST_AMENDMENT_UPDATE = 0
715: where auction_header_id = p_currAuctionHeaderId and
716: nvl(modified_flag, 'N') <> 'P' and

Line 721: update pon_bidding_parties invitees

717: nvl(modified_flag, 'N') <> 'S';
718:
719: else
720:
721: update pon_bidding_parties invitees
722: set MODIFIED_FLAG = null,
723: LAST_AMENDMENT_UPDATE = (select nvl(last_amendment_update, 0)
724: from pon_bidding_parties
725: where auction_header_id = p_prevAuctionHeaderId and

Line 724: from pon_bidding_parties

720:
721: update pon_bidding_parties invitees
722: set MODIFIED_FLAG = null,
723: LAST_AMENDMENT_UPDATE = (select nvl(last_amendment_update, 0)
724: from pon_bidding_parties
725: where auction_header_id = p_prevAuctionHeaderId and
726: (trading_partner_id = invitees.trading_partner_id
727: OR requested_supplier_id =invitees.requested_supplier_id) and
728: nvl(vendor_site_id, -9999) = nvl(invitees.vendor_site_id, -9999))

Line 736: update pon_bidding_parties invitees

732:
733: -- since above query will set last_amendment_update to null for new rows
734: -- need to set last_amendment_update to current amendment number for those rows
735:
736: update pon_bidding_parties invitees
737: set LAST_AMENDMENT_UPDATE = v_currAmendmentNumber
738: where auction_header_id = p_currAuctionHeaderId and
739: last_amendment_update is null;
740:

Line 745: update pon_bidding_parties currInvitees

741: end if;
742:
743: -- next, do pairwise comparisons to find updated rows
744:
745: update pon_bidding_parties currInvitees
746: set MODIFIED_FLAG = 'Y',
747: LAST_AMENDMENT_UPDATE = v_currAmendmentNumber
748: where auction_header_id = p_currAuctionHeaderId and
749: nvl(modified_flag, 'N') <> 'P' and

Line 752: from pon_bidding_parties prevInvitees

748: where auction_header_id = p_currAuctionHeaderId and
749: nvl(modified_flag, 'N') <> 'P' and
750: nvl(modified_flag, 'N') <> 'S' and
751: exists (select null
752: from pon_bidding_parties prevInvitees
753: where prevInvitees.auction_header_id = p_prevAuctionHeaderId and
754: (prevInvitees.trading_partner_id = currInvitees.trading_partner_id
755: or prevInvitees.requested_supplier_id = currInvitees.requested_supplier_id) and
756: nvl(prevInvitees.vendor_site_id, -9999) = nvl(currInvitees.vendor_site_id, -9999) and

Line 891: insert into pon_bidding_parties

887: into v_auctionHeaderIdOrigAmend, v_currAmendmentNumber
888: from pon_auction_headers_all
889: where auction_header_id = p_currAuctionHeaderId;
890:
891: insert into pon_bidding_parties
892: (auction_header_id,
893: list_id,
894: last_update_date,
895: last_updated_by,

Line 946: pon_bidding_parties pbp

942: pbp.vendor_site_code,
943: pbp.modified_flag,
944: pbp.access_type
945: from pon_auction_headers_all pah,
946: pon_bidding_parties pbp
947: where pah.auction_header_id_orig_amend = v_auctionHeaderIdOrigAmend and
948: pah.amendment_number < v_currAmendmentNumber and
949: pbp.auction_header_id = p_currAuctionHeaderId and
950: pbp.sequence = p_sequence ;

Line 975: update pon_bidding_parties pbp

971: into v_auctionHeaderIdOrigAmend, v_currAmendmentNumber
972: from pon_auction_headers_all
973: where auction_header_id = p_currAuctionHeaderId;
974:
975: update pon_bidding_parties pbp
976: set (ack_partner_contact_id, supp_acknowledgement, ack_note_to_auctioneer, acknowledgement_time) =
977:
978: (select currPbp.ack_partner_contact_id, currPbp.supp_acknowledgement, currPbp.ack_note_to_auctioneer, currPbp.acknowledgement_time
979: from pon_bidding_parties currPbp

Line 979: from pon_bidding_parties currPbp

975: update pon_bidding_parties pbp
976: set (ack_partner_contact_id, supp_acknowledgement, ack_note_to_auctioneer, acknowledgement_time) =
977:
978: (select currPbp.ack_partner_contact_id, currPbp.supp_acknowledgement, currPbp.ack_note_to_auctioneer, currPbp.acknowledgement_time
979: from pon_bidding_parties currPbp
980: where currPbp.auction_header_id = p_currAuctionHeaderId and
981: currPbp.sequence = p_sequence)
982:
983: where pbp.auction_header_id in (select auction_header_id from pon_auction_headers_all where auction_header_id_orig_amend = v_auctionHeaderIdOrigAmend and amendment_number <> v_currAmendmentNumber) and

Line 1251: pon_bidding_parties pbp,

1247: sysdate,
1248: p_user_id,
1249: p_login_id
1250: from pon_auction_item_prices_all paip,
1251: pon_bidding_parties pbp,
1252: pon_pf_supplier_values ppsv,
1253: pon_price_elements ppe
1254: where paip.auction_header_id = p_auction_header_id and
1255: pbp.auction_header_id = paip.auction_header_id and