4: -- PROCEDURES
5: --===================
6:
7: FUNCTION find_user_site
8: (p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
9: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
10: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE)
11: RETURN NUMBER;
12:
5: --===================
6:
7: FUNCTION find_user_site
8: (p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
9: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
10: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE)
11: RETURN NUMBER;
12:
13:
6:
7: FUNCTION find_user_site
8: (p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
9: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
10: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE)
11: RETURN NUMBER;
12:
13:
14: FUNCTION check_est_qty_on_all_bid_lines
96: p_requested_supplier_id IN NUMBER)
97: RETURN NUMBER;
98:
99: FUNCTION calculate_quote_amount
100: (p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
101: p_line_number IN pon_auction_item_prices_all.line_number%TYPE,
102: p_bid_number IN pon_bid_headers.bid_number%TYPE,
103: p_supplier_view_type IN pon_auction_headers_all.supplier_view_type%TYPE,
104: p_buyer_tpid IN pon_auction_headers_all.trading_partner_id%TYPE,
98:
99: FUNCTION calculate_quote_amount
100: (p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
101: p_line_number IN pon_auction_item_prices_all.line_number%TYPE,
102: p_bid_number IN pon_bid_headers.bid_number%TYPE,
103: p_supplier_view_type IN pon_auction_headers_all.supplier_view_type%TYPE,
104: p_buyer_tpid IN pon_auction_headers_all.trading_partner_id%TYPE,
105: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
106: p_site IN pon_bid_headers.vendor_site_id%TYPE)
101: p_line_number IN pon_auction_item_prices_all.line_number%TYPE,
102: p_bid_number IN pon_bid_headers.bid_number%TYPE,
103: p_supplier_view_type IN pon_auction_headers_all.supplier_view_type%TYPE,
104: p_buyer_tpid IN pon_auction_headers_all.trading_partner_id%TYPE,
105: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
106: p_site IN pon_bid_headers.vendor_site_id%TYPE)
107: RETURN NUMBER;
108:
109: FUNCTION has_pf_values_defined
102: p_bid_number IN pon_bid_headers.bid_number%TYPE,
103: p_supplier_view_type IN pon_auction_headers_all.supplier_view_type%TYPE,
104: p_buyer_tpid IN pon_auction_headers_all.trading_partner_id%TYPE,
105: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
106: p_site IN pon_bid_headers.vendor_site_id%TYPE)
107: RETURN NUMBER;
108:
109: FUNCTION has_pf_values_defined
110: (p_auction_header_id IN NUMBER,