APPS.PON_BID_DEFAULTING_PKG dependencies on PON_PF_SUPPLIER_FORMULA

Line 2920: l_unit pon_pf_supplier_formula.unit_price%TYPE;

2916:
2917: l_full_quan_req VARCHAR(1); -- Y is the pon_auction_headers_all.full_quantity_bid_code has code FULL_QTY_BIDS_REQD
2918: l_supplier_view PON_AUCTION_HEADERS_ALL.supplier_view_type%TYPE;
2919:
2920: l_unit pon_pf_supplier_formula.unit_price%TYPE;
2921: l_amount pon_pf_supplier_formula.fixed_amount%TYPE;
2922: l_percentage pon_pf_supplier_formula.percentage%TYPE;
2923:
2924: l_pf_value NUMBER;

Line 2921: l_amount pon_pf_supplier_formula.fixed_amount%TYPE;

2917: l_full_quan_req VARCHAR(1); -- Y is the pon_auction_headers_all.full_quantity_bid_code has code FULL_QTY_BIDS_REQD
2918: l_supplier_view PON_AUCTION_HEADERS_ALL.supplier_view_type%TYPE;
2919:
2920: l_unit pon_pf_supplier_formula.unit_price%TYPE;
2921: l_amount pon_pf_supplier_formula.fixed_amount%TYPE;
2922: l_percentage pon_pf_supplier_formula.percentage%TYPE;
2923:
2924: l_pf_value NUMBER;
2925: l_pf_unit_price NUMBER;

Line 2922: l_percentage pon_pf_supplier_formula.percentage%TYPE;

2918: l_supplier_view PON_AUCTION_HEADERS_ALL.supplier_view_type%TYPE;
2919:
2920: l_unit pon_pf_supplier_formula.unit_price%TYPE;
2921: l_amount pon_pf_supplier_formula.fixed_amount%TYPE;
2922: l_percentage pon_pf_supplier_formula.percentage%TYPE;
2923:
2924: l_pf_value NUMBER;
2925: l_pf_unit_price NUMBER;
2926: l_total_price NUMBER; --double in java

Line 3361: FROM pon_pf_supplier_formula

3357:
3358: BEGIN
3359: SELECT unit_price, fixed_amount, percentage
3360: INTO l_unit, l_amount, l_percentage
3361: FROM pon_pf_supplier_formula
3362: WHERE auction_header_id = p_auc_header_id
3363: AND line_number = l_line_number
3364: AND (trading_partner_id = l_tp_id AND
3365: vendor_site_id = l_vendor_site_id);

Line 5532: FROM pon_pf_supplier_formula ppsf,

5528: 'Y', nvl(p_quantity, 1),
5529: nvl(aip.quantity, 1)
5530: )
5531: INTO l_auc_pf_unit_price
5532: FROM pon_pf_supplier_formula ppsf,
5533: pon_auction_item_prices_all aip,
5534: pon_bid_headers pbh
5535: WHERE ppsf.auction_header_id = p_auction_header_id
5536: AND ppsf.line_number = p_line_number