[Home] [Help]
6489: NULL REQUESTED_SUPPLIER_ID,
6490: NULL REQUESTED_SUPPLIER_NAME,
6491: NULL REQUESTED_SUPPLIER_CONTACT_ID,
6492: NULL REQUESTED_SUPP_CONTACT_NAME
6493: FROM PON_BIDDING_PARTIES PBP,
6494: AP_SUPPLIER_SITES_ALL PS,
6495: AP_SUPPLIERS PV
6496: WHERE PBP.AUCTION_HEADER_ID = p_source_auction_header_id
6497: --bug 8613219
6538: PBP.REQUESTED_SUPPLIER_ID,
6539: PBP.REQUESTED_SUPPLIER_NAME,
6540: PBP.REQUESTED_SUPPLIER_CONTACT_ID,
6541: PBP.REQUESTED_SUPP_CONTACT_NAME
6542: FROM PON_BIDDING_PARTIES PBP
6543: WHERE PBP.AUCTION_HEADER_ID = p_source_auction_header_id
6544: --bug 8613219
6545: --AND NVL(PBP.from_emd_flag,'N') <> 'Y'-- Added by Lion for EMD on 04/02/2009
6546: AND (PBP.VENDOR_SITE_ID = -1 OR
6658: NULL REQUESTED_SUPPLIER_ID,
6659: NULL REQUESTED_SUPPLIER_NAME,
6660: NULL REQUESTED_SUPPLIER_CONTACT_ID,
6661: NULL REQUESTED_SUPP_CONTACT_NAME
6662: FROM PON_BIDDING_PARTIES PBP,
6663: AP_SUPPLIER_SITES_ALL PS,
6664: AP_SUPPLIERS PV
6665: WHERE PBP.AUCTION_HEADER_ID = p_source_auction_header_id
6666: AND PV.PARTY_ID = PBP.TRADING_PARTNER_ID
6709: NULL REQUESTED_SUPPLIER_ID,
6710: NULL REQUESTED_SUPPLIER_NAME,
6711: NULL REQUESTED_SUPPLIER_CONTACT_ID,
6712: NULL REQUESTED_SUPP_CONTACT_NAME
6713: FROM PON_BIDDING_PARTIES PBP,
6714: AP_SUPPLIERS PV
6715: WHERE PBP.AUCTION_HEADER_ID = p_source_auction_header_id
6716: AND NVL(PBP.from_emd_flag,'N') <> 'Y'-- Added by Lion for EMD on 04/02/2009
6717: AND (PBP.VENDOR_SITE_ID = -1 OR
6756: PBP.REQUESTED_SUPPLIER_ID,
6757: PBP.REQUESTED_SUPPLIER_NAME,
6758: PBP.REQUESTED_SUPPLIER_CONTACT_ID,
6759: PBP.REQUESTED_SUPP_CONTACT_NAME
6760: FROM PON_BIDDING_PARTIES PBP
6761: WHERE PBP.AUCTION_HEADER_ID = p_source_auction_header_id
6762: AND NVL(PBP.from_emd_flag,'N') <> 'Y'-- Added by Lion for EMD on 04/02/2009
6763: AND PBP.trading_partner_id IS NULL
6764: AND pbp.requested_supplier_id NOT IN (
6874: NULL REQUESTED_SUPPLIER_ID,
6875: NULL REQUESTED_SUPPLIER_NAME,
6876: NULL REQUESTED_SUPPLIER_CONTACT_ID,
6877: NULL REQUESTED_SUPP_CONTACT_NAME
6878: FROM PON_BIDDING_PARTIES PBP,
6879: AP_SUPPLIERS PV
6880: WHERE PBP.AUCTION_HEADER_ID = p_source_auction_header_id
6881: --bug 8613219
6882: --AND NVL(PBP.from_emd_flag,'N') <> 'Y'-- Added by Lion for EMD on 04/02/2009
6931: REQUESTED_SUPPLIER_ID,
6932: REQUESTED_SUPPLIER_NAME,
6933: REQUESTED_SUPPLIER_CONTACT_ID,
6934: REQUESTED_SUPP_CONTACT_NAME
6935: FROM PON_BIDDING_PARTIES PBP
6936: WHERE PBP.AUCTION_HEADER_ID = p_source_auction_header_id
6937: --bug 8613219
6938: --AND NVL(PBP.from_emd_flag,'N') <> 'Y' -- Added by Lion for EMD on 04/02/2009
6939: AND PBP.trading_partner_id IS NULL
6988: )
6989: AND PBH.BID_STATUS IN ('ACTIVE', 'RESUBMISSION')
6990: AND PBH.TRADING_PARTNER_ID NOT IN
6991: (SELECT NVL(TRADING_PARTNER_ID, -1)
6992: FROM PON_BIDDING_PARTIES
6993: WHERE AUCTION_HEADER_ID = p_source_auction_header_id)
6994: AND PBH.trading_partner_contact_name =
6995: (SELECT MIN(trading_partner_contact_name)
6996: FROM pon_bid_headers pbhinner
7055: --
7056: FORALL x IN 1..l_list_id.COUNT
7057: --{ Start of inserting into loop
7058:
7059: INSERT INTO PON_BIDDING_PARTIES
7060: (
7061: AUCTION_HEADER_ID,
7062: LIST_ID,
7063: LAST_UPDATE_DATE,
7145: l_requested_supp_contact_id(x),
7146: l_requested_supp_contact_name(x)
7147: ) ;
7148:
7149: --} End of inserting into the pon_bidding_parties
7150: --} End of IF (l_list_id.COUNT <> 0)
7151: END IF;
7152:
7153: if (p_copy_type = g_new_rnd_copy
7156: --{ add inactive suppliers warning
7157: BEGIN
7158: SELECT
7159: DISTINCT PBP.trading_partner_name BULK COLLECT INTO l_inactive_suppliers
7160: FROM PON_BIDDING_PARTIES PBP,
7161: PO_VENDORS PV
7162: WHERE PBP.AUCTION_HEADER_ID = p_source_auction_header_id
7163: AND PV.PARTY_ID = PBP.TRADING_PARTNER_ID
7164: AND ( nvl(pv.start_date_active, sysdate) > sysdate OR
7190: BEGIN
7191: SELECT
7192: DISTINCT PBP.trading_partner_contact_id BULK COLLECT
7193: INTO l_inactive_supplier_contacts
7194: FROM PON_BIDDING_PARTIES PBP,
7195: HZ_RELATIONSHIPS HZR
7196: WHERE PBP.AUCTION_HEADER_ID = p_auction_header_id
7197: AND HZR.SUBJECT_ID = PBP.TRADING_PARTNER_CONTACT_ID
7198: AND HZR.OBJECT_ID = PBP.TRADING_PARTNER_ID
7207: BEGIN
7208: FOR x IN 1..l_inactive_supplier_contacts.COUNT
7209: LOOP
7210:
7211: UPDATE PON_BIDDING_PARTIES
7212: SET trading_partner_contact_name = NULL,
7213: trading_partner_contact_id = NULL
7214: WHERE auction_header_id = p_auction_header_id
7215: AND TRADING_PARTNER_CONTACT_ID = l_inactive_supplier_contacts(x);
7223: -- add warning for prospective suppliers that are REJECTED
7224: --l_inactive_suppliers := NULL;
7225: BEGIN
7226: SELECT DISTINCT PBP.requested_supplier_name BULK COLLECT INTO l_inactive_suppliers
7227: FROM PON_BIDDING_PARTIES PBP,
7228: Pos_supplier_registrations posreg
7229: WHERE PBP.AUCTION_HEADER_ID = p_source_auction_header_id
7230: AND posreg.SUPPLIER_REG_ID = pbp.REQUESTED_SUPPLIER_ID
7231: AND posreg.REGISTRATION_STATUS = 'REJECTED';
7776: SYSDATE, -- LAST_UPDATE_DATE
7777: p_user_id, -- LAST_UPDATED_BY
7778: p_user_id, -- LAST_UPDATE_LOGIN
7779: ple.SEQUENCE_NUMBER
7780: FROM PON_PARTY_LINE_EXCLUSIONS ple, pon_bidding_parties pbp
7781: WHERE ple.AUCTION_HEADER_ID = p_source_auction_header_id
7782: AND ple.line_number >= p_from_line_number
7783: AND ple.line_number <= p_to_line_number
7784: AND pbp.auction_header_id = p_auction_header_id
7840: p_user_id -- LAST_UPDATE_LOGIN
7841: FROM PON_PF_SUPPLIER_VALUES PPSV,
7842: PON_PRICE_ELEMENTS PPE,
7843: PON_PRICE_ELEMENT_TYPES_VL VL,
7844: PON_BIDDING_PARTIES PBP
7845: WHERE PPSV.AUCTION_HEADER_ID = p_source_auction_header_id AND
7846: PPSV.AUCTION_HEADER_ID = PPE.AUCTION_HEADER_ID AND
7847: PPSV.LINE_NUMBER = PPE.LINE_NUMBER AND
7848: PPSV.PF_SEQ_NUMBER = PPE.SEQUENCE_NUMBER AND
12608: p_user_id,
12609: fnd_global.login_id
12610: from
12611: pon_price_elements price_elements,
12612: pon_bidding_parties bidding_parties
12613: where
12614: price_elements.AUCTION_HEADER_ID = p_destination_auction_hdr_id and
12615: price_elements.AUCTION_HEADER_ID = bidding_parties.AUCTION_HEADER_ID and
12616: price_elements.PF_TYPE = 'BUYER'