472: p_site_id IN NUMBER,
473: p_requested_supplier_id IN NUMBER)
474: RETURN NUMBER
475: IS
476: v_percentage pon_pf_supplier_formula.percentage%TYPE;
477: v_unit pon_pf_supplier_formula.unit_price%TYPE;
478: v_amount pon_pf_supplier_formula.fixed_amount%TYPE;
479: v_quantity NUMBER;
480:
473: p_requested_supplier_id IN NUMBER)
474: RETURN NUMBER
475: IS
476: v_percentage pon_pf_supplier_formula.percentage%TYPE;
477: v_unit pon_pf_supplier_formula.unit_price%TYPE;
478: v_amount pon_pf_supplier_formula.fixed_amount%TYPE;
479: v_quantity NUMBER;
480:
481: BEGIN
474: RETURN NUMBER
475: IS
476: v_percentage pon_pf_supplier_formula.percentage%TYPE;
477: v_unit pon_pf_supplier_formula.unit_price%TYPE;
478: v_amount pon_pf_supplier_formula.fixed_amount%TYPE;
479: v_quantity NUMBER;
480:
481: BEGIN
482:
481: BEGIN
482:
483: SELECT unit_price, fixed_amount, percentage
484: INTO v_unit, v_amount, v_percentage
485: FROM pon_pf_supplier_formula
486: WHERE auction_header_id = p_auction_header_id
487: AND line_number = p_line_number
488: AND ((trading_partner_id = p_tpid AND
489: vendor_site_id = p_site_id)