[Home] [Help]
2955: sum(decode(VL.ENABLED_FLAG,'Y',decode(P.PF_TYPE,'BUYER',1,0),0)) NUM_BUYER_PFS,
2956: sum(decode(VL.ENABLED_FLAG,'Y',decode(P.PF_TYPE,'SUPPLIER',decode(P.PRICE_ELEMENT_TYPE_ID,-10,0,1),0),0)) NUM_SUPPLIER_PFS,
2957: AUCTION_HEADER_ID,
2958: LINE_NUMBER
2959: FROM PON_PRICE_ELEMENTS P, PON_PRICE_ELEMENT_TYPES VL
2960: WHERE P.PRICE_ELEMENT_TYPE_ID = VL.PRICE_ELEMENT_TYPE_ID
2961: GROUP BY AUCTION_HEADER_ID, LINE_NUMBER) COUNTER,
2962:
2963: (SELECT COUNT(ATTRIBUTE_NAME) C2,
5036: -- as it will be inserted later on while publishing the negotiation
5037: -- depending on the other criteria.
5038: --
5039: INSERT INTO
5040: PON_PRICE_ELEMENTS
5041: ( AUCTION_HEADER_ID,
5042: LINE_NUMBER,
5043: LIST_ID,
5044: PRICE_ELEMENT_TYPE_ID,
5067: SYSDATE,
5068: p_user_id,
5069: PF_TYPE, -- Tranformation project related column
5070: DISPLAY_TO_SUPPLIERS_FLAG -- Tranformation project related column
5071: FROM PON_PRICE_ELEMENTS P,
5072: PON_PRICE_ELEMENT_TYPES_VL VL
5073: WHERE P.AUCTION_HEADER_ID = p_source_auction_header_id
5074: AND P.PRICE_ELEMENT_TYPE_ID <> -10
5075: AND P.PRICE_ELEMENT_TYPE_ID = VL.PRICE_ELEMENT_TYPE_ID
6682: SYSDATE, -- LAST_UPDATE_DATE
6683: p_user_id, -- LAST_UPDATED_BY
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
9119: DISTINCT VL.NAME
9120: BULK COLLECT
9121: INTO
9122: l_name
9123: FROM PON_PRICE_ELEMENTS P, PON_PRICE_ELEMENT_TYPES_VL VL
9124: WHERE P.AUCTION_HEADER_ID = p_source_auction_header_id
9125: AND P.PRICE_ELEMENT_TYPE_ID = VL.PRICE_ELEMENT_TYPE_ID
9126: AND VL.ENABLED_FLAG = 'N';
9127:
10873: and ip.group_type in ('LOT', 'LOT_LINE')
10874: or p_group_enabled = 'N'
10875: and ip.group_type in ('GROUP', 'GROUP_LINE')));
10876:
10877: delete from pon_price_elements
10878: where auction_header_id = p_auction_header_id
10879: and line_number in
10880: (select ip.line_number
10881: from pon_auction_item_prices_all ip
11012: sysdate,
11013: p_user_id,
11014: fnd_global.login_id
11015: from
11016: pon_price_elements price_elements,
11017: pon_large_neg_pf_values largeNegPFVal
11018: where
11019: price_elements.AUCTION_HEADER_ID = p_source_auction_hdr_id and
11020: largeNegPFVal.AUCTION_HEADER_ID = price_elements.AUCTION_HEADER_ID and
11023: largeNegPFVal.VALUE is not null and
11024: (price_elements.PRICE_ELEMENT_TYPE_ID, price_elements.PRICING_BASIS) in
11025: (
11026: select distinct PRICE_ELEMENT_TYPE_ID, PRICING_BASIS from
11027: pon_price_elements where auction_header_id = p_destination_auction_hdr_id
11028: --we need not have the below where condition because
11029: --because the large_neg_pf_values will have only
11030: --BUYER price factors and the outer select statement
11031: --always returns the BUYER price factor details. It
11104: p.auction_header_id = p_source_auction_hdr_id and
11105: p.price_element_type_id = vl.price_element_type_id and
11106: vl.enabled_flag = 'Y' and
11107: (p.price_element_type_id,p.pricing_basis) in
11108: (select distinct price_element_type_id,pricing_basis from pon_price_elements
11109: where auction_header_id = p_destination_auction_hdr_id and pf_type = 'BUYER')
11110: );
11111: -- }
11112: END IF;
11166: sysdate,
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