APPS.PON_NEG_UPDATE_PKG dependencies on PON_BIDDING_PARTIES

Line 654: update pon_bidding_parties

650: -- this will influence all sql below...
651:
652: if (p_action = 'MULTIROUND') then
653:
654: update pon_bidding_parties
655: set MODIFIED_FLAG = null,
656: LAST_AMENDMENT_UPDATE = 0
657: where auction_header_id = p_currAuctionHeaderId and
658: nvl(modified_flag, 'N') <> 'P' and

Line 663: update pon_bidding_parties invitees

659: nvl(modified_flag, 'N') <> 'S';
660:
661: else
662:
663: update pon_bidding_parties invitees
664: set MODIFIED_FLAG = null,
665: LAST_AMENDMENT_UPDATE = (select nvl(last_amendment_update, 0)
666: from pon_bidding_parties
667: where auction_header_id = p_prevAuctionHeaderId and

Line 666: from pon_bidding_parties

662:
663: update pon_bidding_parties invitees
664: set MODIFIED_FLAG = null,
665: LAST_AMENDMENT_UPDATE = (select nvl(last_amendment_update, 0)
666: from pon_bidding_parties
667: where auction_header_id = p_prevAuctionHeaderId and
668: (trading_partner_id = invitees.trading_partner_id
669: OR requested_supplier_id =invitees.requested_supplier_id) and
670: nvl(vendor_site_id, -9999) = nvl(invitees.vendor_site_id, -9999))

Line 678: update pon_bidding_parties invitees

674:
675: -- since above query will set last_amendment_update to null for new rows
676: -- need to set last_amendment_update to current amendment number for those rows
677:
678: update pon_bidding_parties invitees
679: set LAST_AMENDMENT_UPDATE = v_currAmendmentNumber
680: where auction_header_id = p_currAuctionHeaderId and
681: last_amendment_update is null;
682:

Line 687: update pon_bidding_parties currInvitees

683: end if;
684:
685: -- next, do pairwise comparisons to find updated rows
686:
687: update pon_bidding_parties currInvitees
688: set MODIFIED_FLAG = 'Y',
689: LAST_AMENDMENT_UPDATE = v_currAmendmentNumber
690: where auction_header_id = p_currAuctionHeaderId and
691: nvl(modified_flag, 'N') <> 'P' and

Line 694: from pon_bidding_parties prevInvitees

690: where auction_header_id = p_currAuctionHeaderId and
691: nvl(modified_flag, 'N') <> 'P' and
692: nvl(modified_flag, 'N') <> 'S' and
693: exists (select null
694: from pon_bidding_parties prevInvitees
695: where prevInvitees.auction_header_id = p_prevAuctionHeaderId and
696: (prevInvitees.trading_partner_id = currInvitees.trading_partner_id
697: or prevInvitees.requested_supplier_id = currInvitees.requested_supplier_id) and
698: nvl(prevInvitees.vendor_site_id, -9999) = nvl(currInvitees.vendor_site_id, -9999) and

Line 833: insert into pon_bidding_parties

829: into v_auctionHeaderIdOrigAmend, v_currAmendmentNumber
830: from pon_auction_headers_all
831: where auction_header_id = p_currAuctionHeaderId;
832:
833: insert into pon_bidding_parties
834: (auction_header_id,
835: list_id,
836: last_update_date,
837: last_updated_by,

Line 888: pon_bidding_parties pbp

884: pbp.vendor_site_code,
885: pbp.modified_flag,
886: pbp.access_type
887: from pon_auction_headers_all pah,
888: pon_bidding_parties pbp
889: where pah.auction_header_id_orig_amend = v_auctionHeaderIdOrigAmend and
890: pah.amendment_number < v_currAmendmentNumber and
891: pbp.auction_header_id = p_currAuctionHeaderId and
892: pbp.sequence = p_sequence ;

Line 917: update pon_bidding_parties pbp

913: into v_auctionHeaderIdOrigAmend, v_currAmendmentNumber
914: from pon_auction_headers_all
915: where auction_header_id = p_currAuctionHeaderId;
916:
917: update pon_bidding_parties pbp
918: set (ack_partner_contact_id, supp_acknowledgement, ack_note_to_auctioneer, acknowledgement_time) =
919:
920: (select currPbp.ack_partner_contact_id, currPbp.supp_acknowledgement, currPbp.ack_note_to_auctioneer, currPbp.acknowledgement_time
921: from pon_bidding_parties currPbp

Line 921: from pon_bidding_parties currPbp

917: update pon_bidding_parties pbp
918: set (ack_partner_contact_id, supp_acknowledgement, ack_note_to_auctioneer, acknowledgement_time) =
919:
920: (select currPbp.ack_partner_contact_id, currPbp.supp_acknowledgement, currPbp.ack_note_to_auctioneer, currPbp.acknowledgement_time
921: from pon_bidding_parties currPbp
922: where currPbp.auction_header_id = p_currAuctionHeaderId and
923: currPbp.sequence = p_sequence)
924:
925: 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 1193: pon_bidding_parties pbp,

1189: sysdate,
1190: p_user_id,
1191: p_login_id
1192: from pon_auction_item_prices_all paip,
1193: pon_bidding_parties pbp,
1194: pon_pf_supplier_values ppsv,
1195: pon_price_elements ppe
1196: where paip.auction_header_id = p_auction_header_id and
1197: pbp.auction_header_id = paip.auction_header_id and