[Home] [Help]
892: p_min_bid_decr IN pon_auction_headers_all.min_bid_decrement%TYPE,
893: p_min_bid_change IN pon_bid_headers.min_bid_change%TYPE,
894: p_rate IN pon_bid_headers.rate%TYPE,
895: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,
896: p_amt_precision IN fnd_currencies.precision%TYPE,
897: p_bid_curr_code IN pon_bid_headers.bid_currency_code%TYPE,
898: p_suffix IN VARCHAR2,
899: p_batch_id IN pon_interface_errors.batch_id%TYPE,
900: p_request_id IN pon_interface_errors.request_id%TYPE
4161: p_interface_type IN pon_interface_errors.interface_type%TYPE,
4162: p_userid IN pon_interface_errors.created_by%TYPE,
4163: p_spreadsheet IN VARCHAR2,
4164: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,
4165: p_amt_precision IN fnd_currencies.precision%TYPE,
4166: p_suffix IN VARCHAR2,
4167: p_batch_id IN pon_interface_errors.batch_id%TYPE,
4168: p_request_id IN pon_interface_errors.request_id%TYPE
4169: ) IS
7520: x_return_code OUT NOCOPY VARCHAR2
7521: ) IS
7522: l_rate pon_bid_headers.rate%TYPE;
7523: l_price_precision pon_bid_headers.number_price_decimals%TYPE;
7524: l_amt_precision fnd_currencies.precision%TYPE;
7525:
7526: l_source_bid pon_bid_headers.bid_number%TYPE;
7527: l_min_bid_change pon_bid_headers.min_bid_change%TYPE;
7528: l_min_bid_decr pon_auction_headers_all.min_bid_decrement%TYPE;
7661: l_surrogate_bid_flag,
7662: --------------------------------------------------
7663: l_evaluation_flag -- Added for ER: Supplier Management: Supplier Evaluation
7664: FROM pon_auction_headers_all ah, pon_bid_headers bh,
7665: fnd_currencies fc, pon_bid_headers old_bh
7666: WHERE ah.auction_header_id = p_auc_header_id
7667: AND ah.auction_header_id = bh.auction_header_id
7668: AND bh.bid_number = p_bid_number
7669: AND fc.currency_code = bh.bid_currency_code