[Home] [Help]
5355: NULL REQUESTED_SUPPLIER_ID,
5356: NULL REQUESTED_SUPPLIER_NAME,
5357: NULL REQUESTED_SUPPLIER_CONTACT_ID,
5358: NULL REQUESTED_SUPP_CONTACT_NAME
5359: FROM PON_BIDDING_PARTIES PBP,
5360: AP_SUPPLIER_SITES_ALL PS,
5361: AP_SUPPLIERS PV
5362: WHERE PBP.AUCTION_HEADER_ID = p_source_auction_header_id
5363: AND PV.PARTY_ID = PBP.TRADING_PARTNER_ID
5402: PBP.REQUESTED_SUPPLIER_ID,
5403: PBP.REQUESTED_SUPPLIER_NAME,
5404: PBP.REQUESTED_SUPPLIER_CONTACT_ID,
5405: PBP.REQUESTED_SUPP_CONTACT_NAME
5406: FROM PON_BIDDING_PARTIES PBP
5407: WHERE PBP.AUCTION_HEADER_ID = p_source_auction_header_id
5408: AND (PBP.VENDOR_SITE_ID = -1 OR
5409: PBP.VENDOR_SITE_ID IS NULL) ) A;
5410:
5520: NULL REQUESTED_SUPPLIER_ID,
5521: NULL REQUESTED_SUPPLIER_NAME,
5522: NULL REQUESTED_SUPPLIER_CONTACT_ID,
5523: NULL REQUESTED_SUPP_CONTACT_NAME
5524: FROM PON_BIDDING_PARTIES PBP,
5525: AP_SUPPLIER_SITES_ALL PS,
5526: AP_SUPPLIERS PV
5527: WHERE PBP.AUCTION_HEADER_ID = p_source_auction_header_id
5528: AND PV.PARTY_ID = PBP.TRADING_PARTNER_ID
5570: NULL REQUESTED_SUPPLIER_ID,
5571: NULL REQUESTED_SUPPLIER_NAME,
5572: NULL REQUESTED_SUPPLIER_CONTACT_ID,
5573: NULL REQUESTED_SUPP_CONTACT_NAME
5574: FROM PON_BIDDING_PARTIES PBP,
5575: AP_SUPPLIERS PV
5576: WHERE PBP.AUCTION_HEADER_ID = p_source_auction_header_id
5577: AND (PBP.VENDOR_SITE_ID = -1 OR
5578: PBP.VENDOR_SITE_ID IS NULL)
5616: PBP.REQUESTED_SUPPLIER_ID,
5617: PBP.REQUESTED_SUPPLIER_NAME,
5618: PBP.REQUESTED_SUPPLIER_CONTACT_ID,
5619: PBP.REQUESTED_SUPP_CONTACT_NAME
5620: FROM PON_BIDDING_PARTIES PBP
5621: WHERE PBP.AUCTION_HEADER_ID = p_source_auction_header_id
5622: AND PBP.trading_partner_id IS NULL
5623: AND pbp.requested_supplier_id NOT IN (
5624: SELECT supplier_reg_id FROM pos_supplier_registrations
5733: NULL REQUESTED_SUPPLIER_ID,
5734: NULL REQUESTED_SUPPLIER_NAME,
5735: NULL REQUESTED_SUPPLIER_CONTACT_ID,
5736: NULL REQUESTED_SUPP_CONTACT_NAME
5737: FROM PON_BIDDING_PARTIES PBP,
5738: AP_SUPPLIERS PV
5739: WHERE PBP.AUCTION_HEADER_ID = p_source_auction_header_id
5740: AND (TRADING_PARTNER_ID,TRADING_PARTNER_CONTACT_ID,nvl(VENDOR_SITE_ID,-1))
5741: NOT IN (SELECT PBH.TRADING_PARTNER_ID,
5788: REQUESTED_SUPPLIER_ID,
5789: REQUESTED_SUPPLIER_NAME,
5790: REQUESTED_SUPPLIER_CONTACT_ID,
5791: REQUESTED_SUPP_CONTACT_NAME
5792: FROM PON_BIDDING_PARTIES PBP
5793: WHERE PBP.AUCTION_HEADER_ID = p_source_auction_header_id
5794: AND PBP.trading_partner_id IS NULL
5795: AND PBP.requested_supplier_id NOT IN (
5796: SELECT supplier_reg_id
5843: )
5844: AND PBH.BID_STATUS IN ('ACTIVE', 'RESUBMISSION')
5845: AND PBH.TRADING_PARTNER_ID NOT IN
5846: (SELECT NVL(TRADING_PARTNER_ID, -1)
5847: FROM PON_BIDDING_PARTIES
5848: WHERE AUCTION_HEADER_ID = p_source_auction_header_id)
5849: AND PBH.trading_partner_contact_name =
5850: (SELECT MIN(trading_partner_contact_name)
5851: FROM pon_bid_headers pbhinner
5910: --
5911: FORALL x IN 1..l_list_id.COUNT
5912: --{ Start of inserting into loop
5913:
5914: INSERT INTO PON_BIDDING_PARTIES
5915: (
5916: AUCTION_HEADER_ID,
5917: LIST_ID,
5918: LAST_UPDATE_DATE,
5999: l_requested_supp_contact_id(x),
6000: l_requested_supp_contact_name(x)
6001: ) ;
6002:
6003: --} End of inserting into the pon_bidding_parties
6004: --} End of IF (l_list_id.COUNT <> 0)
6005: END IF;
6006:
6007: if (p_copy_type = g_new_rnd_copy
6010: --{ add inactive suppliers warning
6011: BEGIN
6012: SELECT
6013: DISTINCT PBP.trading_partner_name BULK COLLECT INTO l_inactive_suppliers
6014: FROM PON_BIDDING_PARTIES PBP,
6015: PO_VENDORS PV
6016: WHERE PBP.AUCTION_HEADER_ID = p_source_auction_header_id
6017: AND PV.PARTY_ID = PBP.TRADING_PARTNER_ID
6018: AND ( nvl(pv.start_date_active, sysdate) > sysdate OR
6044: BEGIN
6045: SELECT
6046: DISTINCT PBP.trading_partner_contact_id BULK COLLECT
6047: INTO l_inactive_supplier_contacts
6048: FROM PON_BIDDING_PARTIES PBP,
6049: HZ_RELATIONSHIPS HZR
6050: WHERE PBP.AUCTION_HEADER_ID = p_auction_header_id
6051: AND HZR.SUBJECT_ID = PBP.TRADING_PARTNER_CONTACT_ID
6052: AND HZR.OBJECT_ID = PBP.TRADING_PARTNER_ID
6061: BEGIN
6062: FOR x IN 1..l_inactive_supplier_contacts.COUNT
6063: LOOP
6064:
6065: UPDATE PON_BIDDING_PARTIES
6066: SET trading_partner_contact_name = NULL,
6067: trading_partner_contact_id = NULL
6068: WHERE auction_header_id = p_auction_header_id
6069: AND TRADING_PARTNER_CONTACT_ID = l_inactive_supplier_contacts(x);
6077: -- add warning for prospective suppliers that are REJECTED
6078: --l_inactive_suppliers := NULL;
6079: BEGIN
6080: SELECT DISTINCT PBP.requested_supplier_name BULK COLLECT INTO l_inactive_suppliers
6081: FROM PON_BIDDING_PARTIES PBP,
6082: Pos_supplier_registrations posreg
6083: WHERE PBP.AUCTION_HEADER_ID = p_source_auction_header_id
6084: AND posreg.SUPPLIER_REG_ID = pbp.REQUESTED_SUPPLIER_ID
6085: AND posreg.REGISTRATION_STATUS = 'REJECTED';
6620: SYSDATE, -- LAST_UPDATE_DATE
6621: p_user_id, -- LAST_UPDATED_BY
6622: p_user_id, -- LAST_UPDATE_LOGIN
6623: ple.SEQUENCE_NUMBER
6624: FROM PON_PARTY_LINE_EXCLUSIONS ple, pon_bidding_parties pbp
6625: WHERE ple.AUCTION_HEADER_ID = p_source_auction_header_id
6626: AND ple.line_number >= p_from_line_number
6627: AND ple.line_number <= p_to_line_number
6628: AND pbp.auction_header_id = p_auction_header_id
6684: p_user_id -- LAST_UPDATE_LOGIN
6685: FROM PON_PF_SUPPLIER_VALUES PPSV,
6686: PON_PRICE_ELEMENTS PPE,
6687: PON_PRICE_ELEMENT_TYPES_VL VL,
6688: PON_BIDDING_PARTIES PBP
6689: WHERE PPSV.AUCTION_HEADER_ID = p_source_auction_header_id AND
6690: PPSV.AUCTION_HEADER_ID = PPE.AUCTION_HEADER_ID AND
6691: PPSV.LINE_NUMBER = PPE.LINE_NUMBER AND
6692: PPSV.PF_SEQ_NUMBER = PPE.SEQUENCE_NUMBER AND
11167: p_user_id,
11168: fnd_global.login_id
11169: from
11170: pon_price_elements price_elements,
11171: pon_bidding_parties bidding_parties
11172: where
11173: price_elements.AUCTION_HEADER_ID = p_destination_auction_hdr_id and
11174: price_elements.AUCTION_HEADER_ID = bidding_parties.AUCTION_HEADER_ID and
11175: price_elements.PF_TYPE = 'BUYER'