1 PACKAGE ASO_BI_POPULATE_FACTS AUTHID CURRENT_USER AS
2 /* $Header: asovbipfs.pls 120.0 2005/05/31 01:26:50 appldev noship $ */
3
4 --This is the Main Procedure for Incremental Data collection from Quote Header
5 --transaction table.
6
7 PROCEDURE Populate_Facts(errbuf OUT NOCOPY VARCHAR2,
8 retcode OUT NOCOPY NUMBER,
9 p_from_date IN VARCHAR2,
10 p_to_date IN VARCHAR2,
11 p_no_worker IN NUMBER);
12
13 --This is the Main Procedure for Initial Data collection from Quote Header
14 --transaction table.
15
16 PROCEDURE Initial_Load_Hdr(errbuf OUT NOCOPY VARCHAR2,
17 retcode OUT NOCOPY NUMBER,
18 p_from_date IN VARCHAR2,
19 p_to_date IN VARCHAR2 );
20
21
22 --This is the Main Procedure for Incremental Data collection from Quote Lines
23 --transaction table.
24
25 PROCEDURE Populate_Lines_Fact(errbuf OUT NOCOPY VARCHAR2,
26 retcode OUT NOCOPY NUMBER,
27 p_from_date IN VARCHAR2,
28 p_to_date IN VARCHAR2,
29 p_worker_no IN NUMBER);
30
31 --This is the Main Procedure for Initial Data collection from Quote Lines
32 --transaction table.
33
34 PROCEDURE Initial_Load_Lines(errbuf OUT NOCOPY VARCHAR2,
35 retcode OUT NOCOPY NUMBER,
36 p_from_date IN VARCHAR2,
37 p_to_date IN VARCHAR2 );
38 END ASO_BI_POPULATE_FACTS;