DBA Data[Home] [Help]

PACKAGE: APPS.OE_BIS

Source


1 PACKAGE OE_BIS AUTHID CURRENT_USER AS
2 /* $Header: OEXBISRS.pls 115.2 99/10/13 14:41:23 porting shi $ */
3 function get_daily_value_shipped ( p_day          IN DATE,
4                                    p_warehouse_id IN NUMBER,
5 				   p_currency     IN VARCHAR2)
6    return number;
7    pragma restrict_references (get_daily_value_shipped, WNDS, RNPS, WNPS);
8 
9 function get_days_top_returns (p_day IN DATE,
10                                p_org_id IN NUMBER)
11    return NUMBER;
12    pragma restrict_references (get_days_top_returns, WNDS);
13 
14 function get_days_top_deliveries (p_day IN DATE,
15                                   p_org_id IN NUMBER)
16    return NUMBER;
17    pragma restrict_references (get_days_top_deliveries, WNDS, RNPS, WNPS);
18 
19 procedure get_top_customers    ( p_period_start IN DATE,
20 				 P_PERIOD_END   IN DATE,
21                                  P_CURRENCY     IN VARCHAR2,
22                                  P_ORG_ID       IN NUMBER );
23 
24 procedure get_bbb_info         ( p_period_start IN DATE,
25 				 P_PERIOD_END   IN DATE,
26                                  P_CURRENCY     IN VARCHAR2,
27                                  P_ORG_ID       IN NUMBER );
28 
29 end oe_bis;