[Home] [Help]
187:
188: IF p_buyer_bid_total is null OR p_buyer_bid_total = '' OR p_buyer_bid_total < 0 THEN
189: IF (p_bid_status = 'DRAFT') THEN
190: IF ((p_doctype_group_name = 'REQUEST_FOR_INFORMATION') OR (p_outcome = 'BLANKET' OR p_outcome = 'CONTRACT')) THEN
191: v_has_est_qty_on_all_bid_lines := PON_TRANSFORM_BIDDING_PKG.check_est_qty_on_all_bid_lines(p_auction_header_id, p_bid_number);
192: IF (v_has_est_qty_on_all_bid_lines = 'N') THEN
193: RETURN null;
194: END IF;
195: END IF;
1567: pon_printing_pkg.format_number(pbip.quantity) bid_quantity,
1568: pon_oa_util_pkg.display_date_time(pbip.promised_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') bid_promised_date,
1569: --in MAS case, pbip.quantity is null, use paip.quantity instead
1570: to_char(decode(p_user_view_type, 'BUYER',pbip.price, pbip.bid_currency_price)*decode(paip.order_type_lookup_code, 'FIXED PRICE', 1,decode(pah.contract_type, 'STANDARD', nvl(pbip.quantity, 0), paip.quantity)), l_amount_mask) bid_amount,
1571: --response/inquiry/server/ViewBidItemsVORowImpl.java:getBidTotalDisplay(): exchange_rate * PON_TRANSFORM_BIDDING_PKG.calculate_quote_amount (paip.auction_header_id, pbip.line_number, pbip.bid_number, 'TRANSFORMED', 12637, 12438, -1) bid_amount,
1572: --bidpdf: Bid Minimum Release Amount
1573: decode(p_user_view_type, 'BUYER', to_char(pbip.po_min_rel_amount, l_amount_mask), to_char(pbip.po_bid_min_rel_amount, l_amount_mask)) bid_min_rel_amount,
1574: --bidpdf: MAS Score
1575: pbip.total_weighted_score,
1576: --bidpdf: Proxy Minimum
1577: decode(p_user_view_type, 'BUYER', pon_printing_pkg.format_price(pbip.proxy_bid_limit_price, l_price_mask, l_price_precision), pon_printing_pkg.format_price(pbip.bid_currency_limit_price, l_price_mask, l_price_precision)) bid_currency_limit_price,
1578: paip.ship_to_location_id,
1579:
1580: pon_printing_pkg.format_price(pon_transform_bidding_pkg.calculate_price(pah.auction_header_id,
1581: paip.line_number, paip.target_price*l_rate, paip.quantity, p_trading_partner_id,
1582: p_trading_partner_contact_id, p_vendor_site_id, p_requested_supplier_id),l_price_mask, l_price_precision)
1583: target_price,
1584: -- Start price comes from the earlier bid for a supplier if he had bid
1588: -- auction start price
1589: --untransform_one_price
1590:
1591: DECODE(l_is_supplier_bidpdf, 'Y',
1592: pon_printing_pkg.format_price(pon_transform_bidding_pkg.calculate_price(pah.auction_header_id, paip.line_number,
1593: nvl(pbip.bid_start_price, paip.bid_start_price)*l_rate, paip.quantity,
1594: p_trading_partner_id,
1595: p_trading_partner_contact_id,
1596: p_vendor_site_id,
1596: p_vendor_site_id,
1597: p_requested_supplier_id),l_price_mask, l_price_precision),
1598: DECODE(l_start_price_from_prev_rnd, 'N',
1599: pon_printing_pkg.format_price(
1600: pon_transform_bidding_pkg.calculate_price(pah.auction_header_id, paip.line_number, paip.bid_start_price, paip.quantity, p_trading_partner_id, p_trading_partner_contact_id, p_vendor_site_id, p_requested_supplier_id),
1601: l_price_mask, l_price_precision),
1602: pon_printing_pkg.format_price(
1603: NVL(pon_auction_headers_pkg.apply_price_factors(p_auction_header_id ,l_prev_rnd_bid_number,paip.line_number, l_contract_type, l_supplier_view_type, l_pf_type_allowed, 'Y'),paip.bid_start_price),
1604: l_price_mask, l_price_precision)
2093: decode(pe.pf_type,
2094: 'SUPPLIER', 'Y',
2095: decode(pe.display_to_suppliers_flag,
2096: 'N', 'N',
2097: PON_TRANSFORM_BIDDING_PKG.has_pf_values_defined(pe.auction_header_id, pe.line_number, pe.sequence_number, p_trading_partner_id, p_vendor_site_id, p_requested_supplier_id)))) can_view_pf_flag
2098: FROM
2099: pon_price_elements pe,
2100: pon_price_element_types_tl pet,
2101: pon_auction_item_prices_all itm,
2224: pon_printing_pkg.format_number(pbsm.quantity) quantity,
2225: -- in case when supplier add new shipments, there's no target price
2226: decode(pbsm.auction_shipment_number, null, null,
2227: pon_printing_pkg.format_price(
2228: pon_transform_bidding_pkg.calculate_price(pah.auction_header_id, pas.line_number, pas.price*l_rate, paip.quantity, p_trading_partner_id, p_trading_partner_contact_id, p_vendor_site_id, p_requested_supplier_id),
2229: l_price_mask, l_price_precision)
2230: ) price,
2231:
2232: PON_OA_UTIL_PKG.DISPLAY_DATE(pbsm.effective_start_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') effective_start_date,
2266: pas.ship_to_location_id,
2267: loc.location_code ship_to_location,
2268: pon_printing_pkg.format_number(pas.quantity) quantity,
2269: pon_printing_pkg.format_price(
2270: pon_transform_bidding_pkg.calculate_price(pah.auction_header_id, pas.line_number, pas.price*l_rate, paip.quantity, p_trading_partner_id,p_trading_partner_contact_id,p_vendor_site_id, p_requested_supplier_id),
2271: l_price_mask,
2272: l_price_precision
2273: ) price,
2274: PON_OA_UTIL_PKG.DISPLAY_DATE(pas.effective_start_date, p_client_time_zone, p_server_time_zone, p_date_format,'N') effective_start_date,
2302: pon_printing_pkg.format_number(pbsm.quantity) quantity,
2303: pon_printing_pkg.format_number(pbsm.max_quantity) max_quantity,
2304: -- in case when supplier add new shipments, there's no target price
2305: nvl2(pbsm.auction_shipment_number,
2306: pon_printing_pkg.format_price(pon_transform_bidding_pkg.calculate_price(pah.auction_header_id,
2307: pas.line_number, pas.price*l_rate, paip.quantity, p_trading_partner_id, p_trading_partner_contact_id, p_vendor_site_id,
2308: p_requested_supplier_id),l_price_mask, l_price_precision)
2309: , null
2310: ) price,
2329: pas.shipment_number bid_shipment_number,
2330: pon_printing_pkg.format_number(pas.quantity) quantity,
2331: pon_printing_pkg.format_number(pas.max_quantity) max_quantity,
2332: pon_printing_pkg.format_price(
2333: pon_transform_bidding_pkg.calculate_price(pah.auction_header_id, pas.line_number, pas.price*l_rate, paip.quantity, p_trading_partner_id,p_trading_partner_contact_id,p_vendor_site_id, p_requested_supplier_id),
2334: l_price_mask,
2335: l_price_precision
2336: ) price,
2337: null bid_currency_unit_price