1 Package FII_AP_INV_B_C AUTHID CURRENT_USER AS
2 /* $Header: FIIAP17S.pls 115.6 2003/10/13 22:11:39 jcchu noship $ */
3
4 -----------------------------------------------------------
5 -- PROCEDURE COLLECT
6 -----------------------------------------------------------
7 Procedure Collect(Errbuf IN OUT NOCOPY VARCHAR2,
8 Retcode IN OUT NOCOPY VARCHAR2,
9 p_from_date IN VARCHAR2,
10 p_to_date IN VARCHAR2,
11 p_no_worker IN NUMBER DEFAULT 2,
12 p_program_type IN VARCHAR2 DEFAULT 'I',
13 p_parallel_query IN NUMBER,
14 p_hash_area_size IN NUMBER,
15 p_sort_area_size IN NUMBER
16 );
17
18
19 PROCEDURE WORKER(
20 Errbuf IN OUT NOCOPY VARCHAR2,
21 Retcode IN OUT NOCOPY VARCHAR2,
22 p_worker_no IN NUMBER);
23
24
25 END FII_AP_INV_B_C;