1 PACKAGE pon_supplier_research_pvt AS
2 -- $Header: PONSUPRS.pls 120.0 2005/06/01 18:33:39 appldev noship $
3
4 -- To return the total Invited negotiations for a given supplier.
5 -- Called for the Supplier Search page results table region VOImpl.
6 -- Also called by get_total_txn_history for Supplier Details page Transaction History region info.
7 FUNCTION get_total_invited_negotiations (p_tp_id IN PLS_INTEGER,
8 p_txn_history_range_in_months IN PLS_INTEGER DEFAULT NULL )
9 RETURN PLS_INTEGER;
10
11 -- To return the total Awarded bids for a given supplier.
12 -- Called for the Supplier Search page results table region VOImpl.
13 -- Also called by get_total_txn_history for Supplier Details page Transaction History region info.
14 FUNCTION get_total_awarded_bids (p_tp_id IN PLS_INTEGER,
15 p_txn_history_range_in_months IN PLS_INTEGER DEFAULT NULL )
16 RETURN PLS_INTEGER;
17
18 -- To return the total purchase order documents for a given supplier.
19 -- This total includes SPO, BPA, CPA and Purchase Order Releases.
20 -- Called for the Supplier Search page results table region VOImpl.
21 FUNCTION get_total_po_documents (p_tp_id IN PLS_INTEGER,
22 p_vendor_id IN PLS_INTEGER)
23 RETURN PLS_INTEGER;
24
25 -- To return the total Sourcing and Purchasing related totals a given supplier.
26 -- Called for the Supplier Details page Transaction History region.
27 PROCEDURE get_total_txn_history (p_tp_id IN PLS_INTEGER,
28 p_vendor_id IN PLS_INTEGER,
29 x_total_invited OUT NOCOPY PLS_INTEGER,
30 x_total_invited_responses OUT NOCOPY PLS_INTEGER,
31 x_total_other_responses OUT NOCOPY PLS_INTEGER,
32 x_total_awarded OUT NOCOPY PLS_INTEGER,
33 x_total_spo OUT NOCOPY PLS_INTEGER,
34 x_total_bpa OUT NOCOPY PLS_INTEGER,
35 x_total_cpa OUT NOCOPY PLS_INTEGER,
36 x_total_po_releases OUT NOCOPY PLS_INTEGER );
37
38 END pon_supplier_research_pvt;