DBA Data[Home] [Help]

APPS.PON_PRINTING_PKG dependencies on PON_TRANSFORM_BIDDING_PKG

Line 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);

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;

Line 2716: --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,

2712: pon_printing_pkg.format_number(pbip.quantity) bid_quantity,
2713: 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,
2714: --in MAS case, pbip.quantity is null, use paip.quantity instead
2715: to_char(decode(p_user_view_type, 'BUYER',pbip.price, pbip.bid_currency_price)*decode(paip.order_type_lookup_code, 'FIXED PRICE', 1,decode(l_contract_type, 'STANDARD', nvl(pbip.quantity, 0), paip.quantity)), l_amount_mask) bid_amount,
2716: --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,
2717: --bidpdf: Bid Minimum Release Amount
2718: 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,
2719: --bidpdf: MAS Score
2720: pbip.total_weighted_score,

Line 2725: pon_printing_pkg.format_price(pon_transform_bidding_pkg.calculate_price(p_auction_header_id,

2721: --bidpdf: Proxy Minimum
2722: 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,
2723: paip.ship_to_location_id,
2724:
2725: pon_printing_pkg.format_price(pon_transform_bidding_pkg.calculate_price(p_auction_header_id,
2726: paip.line_number, paip.target_price*l_rate, paip.quantity, p_trading_partner_id,
2727: p_trading_partner_contact_id, p_vendor_site_id, p_requested_supplier_id),l_price_mask, l_price_precision)
2728: target_price,
2729: -- Start price comes from the earlier bid for a supplier if he had bid

Line 2737: pon_printing_pkg.format_price(pon_transform_bidding_pkg.calculate_price(p_auction_header_id, paip.line_number,

2733: -- auction start price
2734: --untransform_one_price
2735:
2736: DECODE(l_is_supplier_bidpdf, 'Y',
2737: pon_printing_pkg.format_price(pon_transform_bidding_pkg.calculate_price(p_auction_header_id, paip.line_number,
2738: nvl(pbip.bid_start_price, paip.bid_start_price)*l_rate, paip.quantity,
2739: p_trading_partner_id,
2740: p_trading_partner_contact_id,
2741: p_vendor_site_id,

Line 2745: pon_transform_bidding_pkg.calculate_price(p_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),

2741: p_vendor_site_id,
2742: p_requested_supplier_id),l_price_mask, l_price_precision),
2743: DECODE(l_start_price_from_prev_rnd, 'N',
2744: pon_printing_pkg.format_price(
2745: pon_transform_bidding_pkg.calculate_price(p_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),
2746: l_price_mask, l_price_precision),
2747: pon_printing_pkg.format_price(
2748: 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),
2749: l_price_mask, l_price_precision)

Line 3206: 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

3202: decode(pe.pf_type,
3203: 'SUPPLIER', 'Y',
3204: decode(pe.display_to_suppliers_flag,
3205: 'N', 'N',
3206: 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
3207: FROM
3208: pon_auction_headers_all pah,
3209: pon_price_elements pe,
3210: pon_price_element_types_tl pet,

Line 3307: pon_transform_bidding_pkg.calculate_price(p_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),

3303: pon_printing_pkg.format_number(pbsm.quantity) quantity,
3304: -- in case when supplier add new shipments, there's no target price
3305: decode(pbsm.auction_shipment_number, null, null,
3306: pon_printing_pkg.format_price(
3307: pon_transform_bidding_pkg.calculate_price(p_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),
3308: l_price_mask, l_price_precision)
3309: ) price,
3310:
3311: 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,

Line 3348: pon_transform_bidding_pkg.calculate_price(p_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),

3344: pas.ship_to_location_id,
3345: loc.location_code ship_to_location,
3346: pon_printing_pkg.format_number(pas.quantity) quantity,
3347: pon_printing_pkg.format_price(
3348: pon_transform_bidding_pkg.calculate_price(p_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),
3349: l_price_mask,
3350: l_price_precision
3351: ) price,
3352: 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,

Line 3434: pon_printing_pkg.format_price(pon_transform_bidding_pkg.calculate_price(p_auction_header_id,

3430: pon_printing_pkg.format_number(pbsm.quantity) quantity,
3431: pon_printing_pkg.format_number(pbsm.max_quantity) max_quantity,
3432: -- in case when supplier add new shipments, there's no target price
3433: nvl2(pbsm.auction_shipment_number,
3434: pon_printing_pkg.format_price(pon_transform_bidding_pkg.calculate_price(p_auction_header_id,
3435: pas.line_number, pas.price*l_rate, paip.quantity, p_trading_partner_id, p_trading_partner_contact_id, p_vendor_site_id,
3436: p_requested_supplier_id),l_price_mask, l_price_precision)
3437: , null
3438: ) price,

Line 3460: pon_transform_bidding_pkg.calculate_price(p_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),

3456: pas.shipment_number bid_shipment_number,
3457: pon_printing_pkg.format_number(pas.quantity) quantity,
3458: pon_printing_pkg.format_number(pas.max_quantity) max_quantity,
3459: pon_printing_pkg.format_price(
3460: pon_transform_bidding_pkg.calculate_price(p_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),
3461: l_price_mask,
3462: l_price_precision
3463: ) price,
3464: null bid_currency_unit_price