1 PACKAGE OKI_DBI_LOAD_CLEB_PVT AS
2 /* $Header: OKIRILES.pls 120.1 2006/03/28 23:35:16 asparama noship $ */
3
4 g_start_date DATE;
5 g_end_date DATE;
6 g_run_date DATE;
7 g_load_type VARCHAR2(100);
8
9
10 PROCEDURE Rlog ( p_string IN VARCHAR2, p_indent IN NUMBER );
11 PROCEDURE Rout ( p_string IN VARCHAR2, p_indent IN NUMBER );
12
13
14 PROCEDURE Reset_Base_Tables ( errbuf OUT NOCOPY VARCHAR2, retcode OUT NOCOPY VARCHAR2 );
15 PROCEDURE Direct_Load ( p_recs_processed OUT NOCOPY NUMBER );
16 PROCEDURE incr_Load ( p_recs_processed OUT NOCOPY NUMBER );
17
18 PROCEDURE Populate_Inc_Table_Init;
19 PROCEDURE Populate_Inc_Table_Inc;
20 PROCEDURE Report_Missing_Currencies;
21 PROCEDURE Process_Deletes;
22 PROCEDURE Load_Currencies;
23 PROCEDURE Populate_Ren_Rel(p_no_of_Workers IN NUMBER);
24
25
26 PROCEDURE Load_staging(
27 p_worker IN NUMBER
28 , p_recs_processed OUT NOCOPY NUMBER
29 );
30 PROCEDURE Update_LHS (
31 p_worker IN NUMBER
32 , p_no_of_workers IN NUMBER
33 , p_recs_processed OUT NOCOPY NUMBER
34 );
35 PROCEDURE populate_prev_inc (
36 p_worker IN NUMBER
37 , p_no_of_workers IN NUMBER
38 , p_stage IN NUMBER
39 , p_recs_processed OUT NOCOPY NUMBER
40 );
41 PROCEDURE delta_changes( p_worker IN NUMBER
42 , p_no_of_workers IN NUMBER
43 , p_recs_processed OUT NOCOPY NUMBER
44 );
45 PROCEDURE Update_RHS (
46 p_worker IN NUMBER
47 , p_no_of_workers IN NUMBER
48 , p_recs_processed OUT NOCOPY NUMBER
49 );
50
51 PROCEDURE update_staging( p_worker IN NUMBER
52 , p_no_of_workers IN NUMBER
53 , p_recs_processed OUT NOCOPY NUMBER
54 );
55 PROCEDURE worker (
56 errbuf OUT NOCOPY VARCHAR2,
57 retcode OUT NOCOPY VARCHAR2,
58 p_worker_no IN NUMBER,
59 p_phase IN NUMBER,
60 p_no_of_workers IN NUMBER
61 );
62
63 FUNCTION launch_worker( p_worker_no IN NUMBER ,
64 p_phase IN NUMBER,
65 p_no_of_workers IN NUMBER) RETURN NUMBER;
66 PROCEDURE Initial_Load (
67 errbuf OUT NOCOPY VARCHAR2,
68 retcode OUT NOCOPY VARCHAR2,
69 p_start_date IN VARCHAR2,
70 p_end_date IN VARCHAR2
71 );
72 PROCEDURE Populate_Base_Tables
73 (
74 errbuf OUT NOCOPY VARCHAR2,
75 retcode OUT NOCOPY VARCHAR2,
76 p_start_date IN VARCHAR2,
77 p_end_date IN VARCHAR2,
78 p_no_of_workers IN NUMBER
79 );
80
81 END OKI_DBI_LOAD_CLEB_PVT;