[Home] [Help]
821: p_min_bid_decr IN pon_auction_headers_all.min_bid_decrement%TYPE,
822: p_min_bid_change IN pon_bid_headers.min_bid_change%TYPE,
823: p_rate IN pon_bid_headers.rate%TYPE,
824: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,
825: p_amt_precision IN fnd_currencies.precision%TYPE,
826: p_bid_curr_code IN pon_bid_headers.bid_currency_code%TYPE,
827: p_suffix IN VARCHAR2,
828: p_batch_id IN pon_interface_errors.batch_id%TYPE,
829: p_request_id IN pon_interface_errors.request_id%TYPE
3459: p_interface_type IN pon_interface_errors.interface_type%TYPE,
3460: p_userid IN pon_interface_errors.created_by%TYPE,
3461: p_spreadsheet IN VARCHAR2,
3462: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,
3463: p_amt_precision IN fnd_currencies.precision%TYPE,
3464: p_suffix IN VARCHAR2,
3465: p_batch_id IN pon_interface_errors.batch_id%TYPE,
3466: p_request_id IN pon_interface_errors.request_id%TYPE
3467: ) IS
6677: x_return_code OUT NOCOPY VARCHAR2
6678: ) IS
6679: l_rate pon_bid_headers.rate%TYPE;
6680: l_price_precision pon_bid_headers.number_price_decimals%TYPE;
6681: l_amt_precision fnd_currencies.precision%TYPE;
6682:
6683: l_source_bid pon_bid_headers.bid_number%TYPE;
6684: l_min_bid_change pon_bid_headers.min_bid_change%TYPE;
6685: l_min_bid_decr pon_auction_headers_all.min_bid_decrement%TYPE;
6792: l_technical_evaluation_status,
6793: l_surrogate_bid_flag
6794: --------------------------------------------------
6795: FROM pon_auction_headers_all ah, pon_bid_headers bh,
6796: fnd_currencies fc, pon_bid_headers old_bh
6797: WHERE ah.auction_header_id = p_auc_header_id
6798: AND ah.auction_header_id = bh.auction_header_id
6799: AND bh.bid_number = p_bid_number
6800: AND fc.currency_code = bh.bid_currency_code