[Home] [Help]
884: ) IS
885: BEGIN
886:
887: -- If it is a super large negotiation, then proxy is not allowed
888: IF (pon_large_auction_util_pkg.is_super_large_neg(p_auc_header_id)) THEN
889:
890: UPDATE pon_bid_item_prices_interface
891: SET bid_currency_limit_price = null
892: WHERE batch_id = p_batch_id;
1432: FROM pon_bid_headers bh, pon_auction_headers_all ah
1433: WHERE bh.bid_number = p_bid_number
1434: AND ah.auction_header_id = bh.auction_header_id;
1435:
1436: l_suffix := PON_LARGE_AUCTION_UTIL_PKG.get_doctype_suffix(l_auc_header_id);
1437:
1438: -- Determine if there are any invalid lines or lines to be skipped
1439: remove_invalid_skipped_lines
1440: (l_auc_header_id,
1533: l_interface_type := 'BIDBYSPREADSHEET';
1534: l_header_worksheet_sequence := 1;
1535: l_lines_worksheet_sequence := 2;
1536:
1537: l_suffix := PON_LARGE_AUCTION_UTIL_PKG.get_doctype_suffix(p_auction_header_id);
1538:
1539: INSERT ALL
1540: --1
1541: WHEN s_min_bid_change IS NOT NULL
3100: FROM pon_bid_headers bh, pon_auction_headers_all ah
3101: WHERE bh.bid_number = p_bid_number
3102: AND ah.auction_header_id = bh.auction_header_id;
3103:
3104: l_suffix := PON_LARGE_AUCTION_UTIL_PKG.get_doctype_suffix(l_auc_header_id);
3105:
3106: -- Determine if there are any invalid lines or lines to be skipped
3107: remove_xml_skipped_lines
3108: (l_auc_header_id,