1 PACKAGE ozf_cust_facts_pvt AUTHID CURRENT_USER AS
2 /*$Header: ozfvcfts.pls 120.0 2005/06/01 02:40:42 appldev noship $*/
3 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_REFRESH_DASHB_FACTS_PKG';
4
5 PROCEDURE load_daily_facts( ERRBUF OUT NOCOPY VARCHAR2,
6 RETCODE OUT NOCOPY NUMBER,
7 p_report_date IN VARCHAR2 ) ;
8
9 FUNCTION get_xtd_total( p_period_type_id IN NUMBER,
10 p_time_id IN NUMBER,
11 p_start_date IN DATE,
12 p_end_date IN DATE,
13 p_type IN VARCHAR2) RETURN NUMBER;
14 PRAGMA RESTRICT_REFERENCES(get_xtd_total,WNDS,WNPS,RNPS);
15
16 FUNCTION get_xtd_total( p_resource_id IN NUMBER,
17 p_period_type_id IN NUMBER,
18 p_time_id IN NUMBER,
19 p_type IN VARCHAR2 ) RETURN NUMBER;
20 PRAGMA RESTRICT_REFERENCES(get_xtd_total,WNDS,WNPS,RNPS);
21
22 FUNCTION get_cust_target ( p_site_use_id IN NUMBER,
23 p_bill_to_site_use_id IN NUMBER,
24 p_period_type_id IN NUMBER ,
25 p_time_id IN NUMBER,
26 p_report_date IN DATE ) RETURN NUMBER ;
27 PRAGMA RESTRICT_REFERENCES(get_cust_target,WNDS,WNPS,RNPS);
28
29
30 FUNCTION get_cust_target ( p_party_id IN NUMBER,
31 p_bill_to_site_use_id IN NUMBER,
32 p_site_use_id IN NUMBER,
33 p_col IN VARCHAR2,
34 p_sales IN NUMBER,
35 p_report_date IN DATE,
36 p_resource_id IN NUMBER) RETURN NUMBER ;
37 PRAGMA RESTRICT_REFERENCES(get_cust_target,WNDS,WNPS,RNPS);
38
39
40 END ozf_cust_facts_pvt;