[Home] [Help]
96: Decode (Nvl(pbpe.negative_cost_factor_flag,'N'),'Y',-pbpe.auction_currency_value,pbpe.auction_currency_value),
97: 'PERCENTAGE',
98: Decode (Nvl(pbpe.negative_cost_factor_flag,'N'),'Y',-pbpe.auction_currency_value,pbpe.auction_currency_value) / 100 * pbip.unit_price, 0))
99: FROM
100: pon_bid_price_elements pbpe
101: WHERE
102: pbpe.bid_number = pbip.bid_number
103: AND pbpe.line_number = pbip.line_number
104: AND pbpe.pricing_basis IN ('PER_UNIT', 'PERCENTAGE')
107: nvl((
108: SELECT
109: Sum(Decode (Nvl(pbpe.negative_cost_factor_flag,'N'),'Y',-pbpe.auction_currency_value,pbpe.auction_currency_value))
110: FROM
111: pon_bid_price_elements pbpe
112: WHERE
113: pbpe.bid_number = pbip.bid_number
114: AND pbpe.line_number = pbip.line_number
115: AND pbpe.pricing_basis = 'FIXED_AMOUNT'
129: SELECT SUM(DECODE(pbpe.pricing_basis,
130: 'PER_UNIT', pbpe.auction_currency_value,
131: 'PERCENTAGE', pbpe.auction_currency_value / 100 * pbs.unit_price, 0))
132: FROM
133: pon_bid_price_elements pbpe
134: WHERE
135: pbpe.bid_number = pbs.bid_number
136: AND pbpe.line_number = pbs.line_number
137: AND pbpe.pricing_basis IN ('PER_UNIT', 'PERCENTAGE')
230: -- 1) add the Line Price price factor to each bid line that has an applicable buyer factor
231: -- if the supplier view type of the auction is UNTRANSFORMED
232: IF p_supplier_view_type = 'UNTRANSFORMED' THEN
233: INSERT INTO
234: pon_bid_price_elements (
235: bid_number,
236: line_number,
237: price_element_type_id,
238: auction_header_id,
276: AND pf_values.supplier_seq_number = l_supplier_sequence_number
277: AND NVL(pf_values.value, 0) <> 0);
278: END IF;
279:
280: -- 2) add those buyer price factors that have not been added yet to pon_bid_price_elements
281: -- (these will end up being the price factors hidden from the bidding UI by the buyer)
282: INSERT INTO
283: pon_bid_price_elements (
284: bid_number,
279:
280: -- 2) add those buyer price factors that have not been added yet to pon_bid_price_elements
281: -- (these will end up being the price factors hidden from the bidding UI by the buyer)
282: INSERT INTO
283: pon_bid_price_elements (
284: bid_number,
285: line_number,
286: price_element_type_id,
287: auction_header_id,
321: AND pfs.pf_type = 'BUYER'
322: AND pf_values.supplier_seq_number = l_supplier_sequence_number
323: AND NVL(pf_values.value, 0) <> 0
324: AND NOT EXISTS (SELECT NULL
325: FROM pon_bid_price_elements bid_pfs
326: WHERE
327: bid_pfs.bid_number = p_bid_number
328: AND bid_pfs.line_number = pfs.line_number
329: AND bid_pfs.price_element_type_id = pfs.price_element_type_id);
1091: FROM pon_bid_attribute_values
1092: WHERE auction_header_id = p_auctionHeaderId
1093: AND bid_number = p_bidNumber;
1094: --
1095: INSERT INTO pon_bid_price_elements (
1096: bid_number,
1097: line_number,
1098: price_element_type_id,
1099: auction_header_id,
1118: created_by,
1119: sysdate,
1120: last_updated_by,
1121: pf_type
1122: FROM pon_bid_price_elements
1123: WHERE auction_header_id = p_auctionHeaderId
1124: AND bid_number = p_bidNumber;
1125:
1126:
1595: print_log(l_api_name, 'x_lineNumber=' || x_lineNumber );
1596:
1597: select count(*)
1598: into return_value
1599: from PON_BID_PRICE_ELEMENTS b1,PON_BID_PRICE_ELEMENTS b2
1600: where b1.bid_number = x_oldBidNumber
1601: and b1.line_number = x_lineNumber
1602: and b2.bid_number = x_newBidNumber
1603: and b2.line_number = b1.line_number
3080: SELECT
3081: price_element_type_id,
3082: pricing_basis,
3083: bid_currency_value
3084: FROM pon_bid_price_elements bid_pfs
3085: WHERE
3086: bid_pfs.bid_number = p_bid_number
3087: AND bid_pfs.line_number = p_line_number
3088: AND bid_pfs.price_element_type_id <> -10
6018: )
6019: )
6020: ,0)
6021: INTO l_bid_line_pf_unit_price
6022: FROM pon_bid_price_elements spf,
6023: pon_auction_item_prices_all aip
6024: WHERE spf.bid_number = p_prev_auc_active_bid_number
6025: AND spf.line_number = p_line_number
6026: AND spf.sequence_number <> -10