[Home] [Help]
PACKAGE: APPS.MSD_COLLECT_FACT_DATA
Source
1 PACKAGE MSD_COLLECT_FACT_DATA AUTHID CURRENT_USER AS
2 /* $Header: msdcfcts.pls 120.3 2005/12/06 23:10:55 sjagathe noship $ */
3
4 /* Bug# 4615390 ISO */
5 /* Bug# 4747555 */
6 SYS_YES CONSTANT NUMBER := 1;
7 SYS_NO CONSTANT NUMBER := 2;
8
9 /* Public Procedures */
10
11 procedure collect_fact_data(
12 errbuf OUT NOCOPY VARCHAR2,
13 retcode OUT NOCOPY VARCHAR2,
14 p_instance_id IN NUMBER,
15 p_from_date IN VARCHAR2,
16 p_to_date IN VARCHAR2,
17 p_fcst_desg IN VARCHAR2,
18 p_price_list IN VARCHAR2 );
19
20
21 procedure collect_shipment_data(
22 errbuf OUT NOCOPY VARCHAR2,
23 retcode OUT NOCOPY VARCHAR2,
24 p_instance_id IN NUMBER,
25 p_from_date IN VARCHAR2,
26 p_to_date IN VARCHAR2,
27 p_collect_ISO IN NUMBER DEFAULT SYS_NO, /* Bug# 4615390 ISO, Bug# 4865396 */
28 p_collect_all_order_types IN NUMBER DEFAULT SYS_YES, /* Bug# 4747555*/
29 p_include_order_types IN VARCHAR2 DEFAULT NULL,
30 p_exclude_order_types IN VARCHAR2 DEFAULT NULL) ;
31
32 procedure collect_booking_data(
33 errbuf OUT NOCOPY VARCHAR2,
34 retcode OUT NOCOPY VARCHAR2,
35 p_instance_id IN NUMBER,
36 p_from_date IN VARCHAR2,
37 p_to_date IN VARCHAR2,
38 p_collect_ISO IN NUMBER DEFAULT SYS_NO, /* Bug# 4615390 ISO, Bug# 4865396 */
39 p_collect_all_order_types IN NUMBER DEFAULT SYS_YES, /* Bug# 4747555*/
40 p_include_order_types IN VARCHAR2 DEFAULT NULL,
41 p_exclude_order_types IN VARCHAR2 DEFAULT NULL) ;
42
43 procedure collect_uom_conversion(
44 errbuf OUT NOCOPY VARCHAR2,
45 retcode OUT NOCOPY VARCHAR2,
46 p_instance_id IN NUMBER);
47
48 procedure collect_currency_conversion(
49 errbuf OUT NOCOPY VARCHAR2,
50 retcode OUT NOCOPY VARCHAR2,
51 p_instance_id IN NUMBER,
52 p_from_date IN VARCHAR2,
53 p_to_date IN VARCHAR2) ;
54
55 /* procedure collect_opportunities_data(
56 errbuf OUT NOCOPY VARCHAR2,
57 retcode OUT NOCOPY VARCHAR2,
58 p_instance_id IN NUMBER,
59 p_from_date IN VARCHAR2,
60 p_to_date IN VARCHAR2) ;
61
62 procedure collect_sales_forecast(
63 errbuf OUT NOCOPY VARCHAR2,
64 retcode OUT NOCOPY VARCHAR2,
65 p_instance_id IN NUMBER,
66 p_from_date IN VARCHAR2,
67 p_to_date IN VARCHAR2) ;
68 */
69
70 procedure collect_mfg_forecast(
71 errbuf OUT NOCOPY VARCHAR2,
72 retcode OUT NOCOPY VARCHAR2,
73 p_instance_id IN NUMBER,
74 p_fcst_desg IN VARCHAR2) ;
75
76 procedure collect_pricing_data(
77 errbuf OUT NOCOPY VARCHAR2,
78 retcode OUT NOCOPY VARCHAR2,
79 p_instance_id IN NUMBER,
80 p_price_list IN VARCHAR2) ;
81
82 procedure purge_facts(
83 errbuf OUT NOCOPY VARCHAR2,
84 retcode OUT NOCOPY VARCHAR2,
85 p_instance_id IN NUMBER);
86
87
88 /* Private functions */
89 function get_purge_sql(p_table VARCHAR2, p_instance_id NUMBER) RETURN VARCHAR2;
90
91 END MSD_COLLECT_FACT_DATA;