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
78: p_requested_supplier_id IN NUMBER)
79: RETURN NUMBER;
80:
81: FUNCTION calculate_quote_amount
82: (p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
83: p_line_number IN pon_auction_item_prices_all.line_number%TYPE,
84: p_bid_number IN pon_bid_headers.bid_number%TYPE,
85: p_supplier_view_type IN pon_auction_headers_all.supplier_view_type%TYPE,
86: p_buyer_tpid IN pon_auction_headers_all.trading_partner_id%TYPE,
80:
81: FUNCTION calculate_quote_amount
82: (p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
83: p_line_number IN pon_auction_item_prices_all.line_number%TYPE,
84: p_bid_number IN pon_bid_headers.bid_number%TYPE,
85: p_supplier_view_type IN pon_auction_headers_all.supplier_view_type%TYPE,
86: p_buyer_tpid IN pon_auction_headers_all.trading_partner_id%TYPE,
87: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
88: p_site IN pon_bid_headers.vendor_site_id%TYPE)
83: p_line_number IN pon_auction_item_prices_all.line_number%TYPE,
84: p_bid_number IN pon_bid_headers.bid_number%TYPE,
85: p_supplier_view_type IN pon_auction_headers_all.supplier_view_type%TYPE,
86: p_buyer_tpid IN pon_auction_headers_all.trading_partner_id%TYPE,
87: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
88: p_site IN pon_bid_headers.vendor_site_id%TYPE)
89: RETURN NUMBER;
90:
91: FUNCTION has_pf_values_defined
84: p_bid_number IN pon_bid_headers.bid_number%TYPE,
85: p_supplier_view_type IN pon_auction_headers_all.supplier_view_type%TYPE,
86: p_buyer_tpid IN pon_auction_headers_all.trading_partner_id%TYPE,
87: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
88: p_site IN pon_bid_headers.vendor_site_id%TYPE)
89: RETURN NUMBER;
90:
91: FUNCTION has_pf_values_defined
92: (p_auction_header_id IN NUMBER,