[Home] [Help]
3845: sum(decode(VL.ENABLED_FLAG,'Y',decode(P.PF_TYPE,'BUYER',1,0),0)) NUM_BUYER_PFS,
3846: 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,
3847: AUCTION_HEADER_ID,
3848: LINE_NUMBER
3849: FROM PON_PRICE_ELEMENTS P, PON_PRICE_ELEMENT_TYPES VL
3850: WHERE P.PRICE_ELEMENT_TYPE_ID = VL.PRICE_ELEMENT_TYPE_ID
3851: GROUP BY AUCTION_HEADER_ID, LINE_NUMBER) COUNTER,
3852:
3853: (SELECT COUNT(ATTRIBUTE_NAME) C2,
6167: -- as it will be inserted later on while publishing the negotiation
6168: -- depending on the other criteria.
6169: --
6170: INSERT INTO
6171: PON_PRICE_ELEMENTS
6172: ( AUCTION_HEADER_ID,
6173: LINE_NUMBER,
6174: LIST_ID,
6175: PRICE_ELEMENT_TYPE_ID,
6200: p_user_id,
6201: PF_TYPE, -- Tranformation project related column
6202: DISPLAY_TO_SUPPLIERS_FLAG, -- Tranformation project related column
6203: NEGATIVE_COST_FACTOR_FLAG
6204: FROM PON_PRICE_ELEMENTS P,
6205: PON_PRICE_ELEMENT_TYPES_VL VL
6206: WHERE P.AUCTION_HEADER_ID = p_source_auction_header_id
6207: AND P.PRICE_ELEMENT_TYPE_ID <> -10
6208: AND P.PRICE_ELEMENT_TYPE_ID = VL.PRICE_ELEMENT_TYPE_ID
7838: SYSDATE, -- LAST_UPDATE_DATE
7839: p_user_id, -- LAST_UPDATED_BY
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
10316: DISTINCT VL.NAME
10317: BULK COLLECT
10318: INTO
10319: l_name
10320: FROM PON_PRICE_ELEMENTS P, PON_PRICE_ELEMENT_TYPES_VL VL
10321: WHERE P.AUCTION_HEADER_ID = p_source_auction_header_id
10322: AND P.PRICE_ELEMENT_TYPE_ID = VL.PRICE_ELEMENT_TYPE_ID
10323: AND VL.ENABLED_FLAG = 'N';
10324:
12314: and ip.group_type in ('LOT', 'LOT_LINE')
12315: or p_group_enabled = 'N'
12316: and ip.group_type in ('GROUP', 'GROUP_LINE')));
12317:
12318: delete from pon_price_elements
12319: where auction_header_id = p_auction_header_id
12320: and line_number in
12321: (select ip.line_number
12322: from pon_auction_item_prices_all ip
12453: sysdate,
12454: p_user_id,
12455: fnd_global.login_id
12456: from
12457: pon_price_elements price_elements,
12458: pon_large_neg_pf_values largeNegPFVal
12459: where
12460: price_elements.AUCTION_HEADER_ID = p_source_auction_hdr_id and
12461: largeNegPFVal.AUCTION_HEADER_ID = price_elements.AUCTION_HEADER_ID and
12464: largeNegPFVal.VALUE is not null and
12465: (price_elements.PRICE_ELEMENT_TYPE_ID, price_elements.PRICING_BASIS) in
12466: (
12467: select distinct PRICE_ELEMENT_TYPE_ID, PRICING_BASIS from
12468: pon_price_elements where auction_header_id = p_destination_auction_hdr_id
12469: --we need not have the below where condition because
12470: --because the large_neg_pf_values will have only
12471: --BUYER price factors and the outer select statement
12472: --always returns the BUYER price factor details. It
12545: p.auction_header_id = p_source_auction_hdr_id and
12546: p.price_element_type_id = vl.price_element_type_id and
12547: vl.enabled_flag = 'Y' and
12548: (p.price_element_type_id,p.pricing_basis) in
12549: (select distinct price_element_type_id,pricing_basis from pon_price_elements
12550: where auction_header_id = p_destination_auction_hdr_id and pf_type = 'BUYER')
12551: );
12552: -- }
12553: END IF;
12607: sysdate,
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