1 PACKAGE FA_BALREP_PKG AUTHID CURRENT_USER AS
2 /*$Header: fabalreps.pls 120.7 2011/01/14 14:14:38 skchawla noship $*/
3 PROCEDURE LOAD_WORKERS (
4 p_book_type_code IN VARCHAR2,
5 p_request_id IN NUMBER --,batch_size in number\
6 ,
7 p_errbuf OUT NOCOPY VARCHAR2,
8 p_retcode OUT NOCOPY NUMBER
9 );
10
11 PROCEDURE populate_gt_table (
12 errbuf IN OUT NOCOPY VARCHAR2,
13 retcode IN OUT NOCOPY VARCHAR2,
14 Book IN VARCHAR2,
15 Report_Type IN VARCHAR2,
16 Report_Style IN VARCHAR2,
17 Request_id IN NUMBER,
18 Worker_number IN NUMBER,
19 Period1_PC IN NUMBER,
20 Period1_POD IN DATE,
21 Period1_PCD IN DATE,
22 Period2_PC IN NUMBER,
23 Period2_PCD IN DATE,
24 Distribution_Source_Book IN VARCHAR2);
25
26 PROCEDURE LAUNCH_WORKERS (
27 Book IN VARCHAR2,
28 Report_Type IN VARCHAR2,
29 report_style IN VARCHAR2,
30 l_Request_id IN NUMBER,
31 Period1_PC IN NUMBER,
32 Period1_POD IN DATE,
33 Period1_PCD IN DATE,
34 Period2_PC IN NUMBER,
35 Period2_PCD IN DATE,
36 Distribution_Source_Book IN VARCHAR2,
37 p_total_requests1 IN NUMBER,
38 l_errbuf OUT NOCOPY VARCHAR2,
39 l_retcode OUT NOCOPY NUMBER);
40 END FA_BALREP_PKG;