1 PACKAGE OKI_LOAD_TERR_PVT AS
2 /* $Header: OKITERRS.pls 120.0 2005/08/12 06:24:08 asparama noship $ */
3
4 /* This API is used to load Territory fact.
5 This will be called by SubWorkers and not be Main Request.
6 It has two Parameters
7 p_worker_number : IN parameter, gives information about worker_number
8 x_rec_count : OUT parameter, gives no of records updated in
9 territory fact table by this worker */
10 PROCEDURE load_jtf_terr ( p_worker_number IN NUMBER
11 , x_rec_count OUT NOCOPY NUMBER);
12
13 /* This API will be called by Initial Load Concurrent Program.
14 This is the Driving Procedure for Initial Load
15 It has three Parameters
16 errbuf : OUT parameter, Used to store the Error Information if
17 this API fails.
18 retcode : OUT parameter, Used to store the Error Code if
19 this API fails.
20 p_worker_number : IN parameter, gives information about
21 Number of workers to spawn.*/
22 PROCEDURE initial_load ( errbuf OUT NOCOPY VARCHAR2
23 , retcode OUT NOCOPY VARCHAR2
24 , p_number_of_workers IN NUMBER);
25
26 /* This API will be called by Incremental Load Concurrent Program.
27 This is the Driving Procedure for Incremental Load
28 It has three Parameters
29 errbuf : OUT parameter, Used to store the Error Information if
30 this API fails.
31 retcode : OUT parameter, Used to store the Error Code if
32 this API fails.
33 p_worker_number : IN parameter, gives information about
34 Number of workers to spawn. */
35 PROCEDURE incr_load ( errbuf OUT NOCOPY VARCHAR2
36 , retcode OUT NOCOPY VARCHAR2
37 , p_number_of_workers IN NUMBER);
38
39 /* This API will be called by SubWorker Concurrent Program.
40 This is the Driving Procedure for Workers
41 It has four Parameters
42 errbuf : OUT parameter, Used to store the Error Information if
43 this API fails.
44 retcode : OUT parameter, Used to store the Error Code if
45 this API fails.
46 p_worker_no : IN parameter, gives information about
47 the worker number
48 p_load_type : IN parameter, gives information about load type.
49 possible values are 'INIT','INCR'*/
50 PROCEDURE worker( errbuf OUT NOCOPY VARCHAR2
51 , retcode OUT NOCOPY VARCHAR2
52 , p_worker_no IN NUMBER
53 , p_load_type IN VARCHAR2
54 );
55 END OKI_LOAD_TERR_PVT;