[Home] [Help]
96: pbpe.auction_currency_value,
97: 'PERCENTAGE',
98: 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(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);
1068: FROM pon_bid_attribute_values
1069: WHERE auction_header_id = p_auctionHeaderId
1070: AND bid_number = p_bidNumber;
1071: --
1072: INSERT INTO pon_bid_price_elements (
1073: bid_number,
1074: line_number,
1075: price_element_type_id,
1076: auction_header_id,
1095: created_by,
1096: sysdate,
1097: last_updated_by,
1098: pf_type
1099: FROM pon_bid_price_elements
1100: WHERE auction_header_id = p_auctionHeaderId
1101: AND bid_number = p_bidNumber;
1102:
1103:
1538: print_log(l_api_name, 'x_lineNumber=' || x_lineNumber );
1539:
1540: select count(*)
1541: into return_value
1542: from PON_BID_PRICE_ELEMENTS b1,PON_BID_PRICE_ELEMENTS b2
1543: where b1.bid_number = x_oldBidNumber
1544: and b1.line_number = x_lineNumber
1545: and b2.bid_number = x_newBidNumber
1546: and b2.line_number = b1.line_number
3005: SELECT
3006: price_element_type_id,
3007: pricing_basis,
3008: bid_currency_value
3009: FROM pon_bid_price_elements bid_pfs
3010: WHERE
3011: bid_pfs.bid_number = p_bid_number
3012: AND bid_pfs.line_number = p_line_number
3013: AND bid_pfs.price_element_type_id <> -10
5850: )
5851: )
5852: ,0)
5853: INTO l_bid_line_pf_unit_price
5854: FROM pon_bid_price_elements spf,
5855: pon_auction_item_prices_all aip
5856: WHERE spf.bid_number = p_prev_auc_active_bid_number
5857: AND spf.line_number = p_line_number
5858: AND spf.sequence_number <> -10