PACKAGE: APPS.POA_SUPPERF_API_PKG

Source

1 PACKAGE POA_SUPPERF_API_PKG AUTHID CURRENT_USER AS
2 /* $Header: POASPAPS.pls 115.4 2003/01/09 23:25:46 rvickrey ship $*/
3 
4    FUNCTION get_receipt_date(p_line_location_id NUMBER) RETURN DATE;
5 
6    FUNCTION get_avg_price(p_line_location_id NUMBER,
7                           p_price_override   NUMBER) RETURN NUMBER;
8 
9    FUNCTION get_primary_avg_price(p_line_location_id NUMBER,
10                                   p_price_override   NUMBER,
11                                   p_item_id          NUMBER,
12                                   p_organization_id  NUMBER,
13                                   p_uom              VARCHAR2)
14 	RETURN NUMBER;
15 
16    FUNCTION get_num_receipts(p_line_location_id NUMBER) RETURN NUMBER;
17 
18    FUNCTION get_primary_uom(p_item_id NUMBER,
19                             p_organization_id NUMBER)	RETURN VARCHAR2;
20 
21    FUNCTION get_primary_quantity(p_quantity        NUMBER,
22                                  p_item_id         NUMBER,
23                                  p_organization_id NUMBER,
24                                  p_uom             VARCHAR2)	RETURN NUMBER;
25 
26    FUNCTION get_quantity_purchased(p_quantity_ordered   NUMBER,
27                                    p_quantity_billed    NUMBER,
28                                    p_quantity_cancelled NUMBER,
29                                    p_quantity_received  NUMBER,
30                                    p_cancel_flag        VARCHAR2,
31                                    p_closed_code        VARCHAR2)
32 	RETURN NUMBER;
33 
34    FUNCTION get_total_amount(p_line_location_id NUMBER,
35                              p_cancel_flag      VARCHAR2,
36                              p_closed_code      VARCHAR2,
37                              p_price            NUMBER)	    RETURN NUMBER;
38 
39    FUNCTION get_quantity_late(p_line_location_id  NUMBER,
40                               p_expected_date     DATE,
41                               p_days_late_allowed NUMBER)   RETURN NUMBER;
42 
43    FUNCTION get_quantity_early(p_line_location_id  NUMBER,
44                                p_expected_date      DATE,
45                                p_days_early_allowed NUMBER)  RETURN NUMBER;
46 
47    FUNCTION get_quantity_past_due(p_quantity_ordered  NUMBER,
48                                   p_quantity_received NUMBER,
49 				  p_expected_date     DATE,
50 				  p_days_late_allowed NUMBER)	RETURN NUMBER;
51 
52    FUNCTION get_suppliers(p_order_by NUMBER,
53                           p_item NUMBER,
54                           p_fdate DATE,
55                           p_tdate DATE,
56                           p_number_of_suppliers NUMBER)	    RETURN VARCHAR2;
57 
58    FUNCTION get_last_trx_date(p_line_location_id NUMBER)    RETURN DATE;
59 
60    FUNCTION get_rcv_txn_qty(p_line_location_id  NUMBER,
61                             p_txn_type          VARCHAR2)	RETURN NUMBER;
62 
63 
64    -- Pragmas
65 
66    PRAGMA RESTRICT_REFERENCES(get_last_trx_date, WNDS, WNPS, RNPS);
67 
68 END POA_SUPPERF_API_PKG;