1 PACKAGE CZ_IMP_ALL AS
2 /* $Header: czialls.pls 120.2 2007/11/26 07:59:23 kdande ship $ */
3
4 CONCURRENT_SUCCESS CONSTANT NUMBER := 0;
5 CONCURRENT_WARNING CONSTANT NUMBER := 1;
6 CONCURRENT_ERROR CONSTANT NUMBER := 2;
7
8 get_time BOOLEAN := FALSE;
9 RP_ROOT_FOLDER CONSTANT PLS_INTEGER:=0; -- sselahi rpf
10 ------------------------------------------------------------------------------------------
11 PROCEDURE setReturnCode(retcode IN NUMBER, errbuf IN VARCHAR2);
12 ------------------------------------------------------------------------------------------
13 PROCEDURE go_cp(errbuf OUT NOCOPY VARCHAR2,retcode OUT NOCOPY NUMBER);
14 ------------------------------------------------------------------------------------------
15 PROCEDURE go(errbuf IN OUT NOCOPY VARCHAR2,retcode IN OUT NOCOPY NUMBER);
16 ------------------------------------------------------------------------------------------
17 PROCEDURE go_generic(outRun_ID IN OUT NOCOPY PLS_INTEGER,
18 inRun_ID IN PLS_INTEGER DEFAULT NULL, p_rp_folder_id NUMBER); -- sselahi
19 ------------------------------------------------------------------------------------------
20 PROCEDURE populate_table(inRun_ID IN PLS_INTEGER,
21 table_name IN VARCHAR2,
22 commit_size IN PLS_INTEGER,
23 max_err IN PLS_INTEGER,
24 inXFR_GROUP IN VARCHAR2,
25 p_rp_folder_id IN NUMBER,
26 x_failed IN OUT NOCOPY NUMBER);
27 ------------------------------------------------------------------------------------------
28 PROCEDURE import_before_start;
29 ------------------------------------------------------------------------------------------
30 PROCEDURE import_after_complete(inRUN_ID IN PLS_INTEGER);
31 ------------------------------------------------------------------------------------------
32 PROCEDURE goSingleBill(nOrg_ID IN NUMBER,nTop_ID IN NUMBER,
33 COPY_CHILD_MODELS IN VARCHAR2,
34 REFRESH_MODEL_ID IN NUMBER,
35 COPY_ROOT_MODEL IN VARCHAR2,
36 x_run_id OUT NOCOPY NUMBER); -- sselahi: added x_run_id
37 ------------------------------------------------------------------------------------------
38 PROCEDURE AddBillToImport(errbuf OUT NOCOPY VARCHAR2,retcode OUT NOCOPY NUMBER,nOrg_ID IN NUMBER,nTop_ID IN NUMBER,
39 COPY_CHILD_MODELS IN VARCHAR2);
40 ------------------------------------------------------------------------------------------
41 PROCEDURE SetSingleBillState(errbuf OUT NOCOPY VARCHAR2,retcode OUT NOCOPY NUMBER,nOrg_ID IN NUMBER,nTop_ID IN NUMBER,sState IN VARCHAR2);
42 ------------------------------------------------------------------------------------------
43 PROCEDURE goSingleBill_cp
44 (errbuf IN OUT NOCOPY VARCHAR2,retcode IN OUT NOCOPY NUMBER,nORG_ID IN NUMBER,nTOP_ID IN NUMBER,
45 COPY_CHILD_MODELS IN VARCHAR2 DEFAULT '0',
46 REFRESH_MODEL_ID IN NUMBER DEFAULT -1,
47 COPY_ROOT_MODEL IN VARCHAR2 DEFAULT '0');
48 ------------------------------------------------------------------------------------------
49 PROCEDURE RemoveModel(errbuf OUT NOCOPY VARCHAR2,retcode OUT NOCOPY NUMBER,sOrg_ID IN VARCHAR2,
50 dsOrg_ID IN VARCHAR2,sTop_ID IN VARCHAR2);
51 ------------------------------------------------------------------------------------------
52 PROCEDURE PopulateModels_cp(errbuf OUT NOCOPY VARCHAR2,retcode OUT NOCOPY NUMBER,
53 sOrg_ID IN VARCHAR2,dsOrg_ID IN VARCHAR2,
54 sFrom IN VARCHAR2,sTo IN VARCHAR,
55 COPY_CHILD_MODELS IN VARCHAR2 DEFAULT '0');
56 ------------------------------------------------------------------------------------------
57 PROCEDURE RefreshModels(errbuf OUT NOCOPY VARCHAR2,retcode OUT NOCOPY NUMBER);
58 ------------------------------------------------------------------------------------------
59 PROCEDURE setRunID(inRun_ID IN PLS_INTEGER,table_name IN VARCHAR2);
60 ------------------------------------------------------------------------------------------
61 PROCEDURE setRecStatus(inRun_ID IN PLS_INTEGER,table_name IN VARCHAR2);
62 ------------------------------------------------------------------------------------------
63 PROCEDURE check_for_common_bill
64 (errbuf OUT NOCOPY VARCHAR2,
65 retcode OUT NOCOPY NUMBER,
66 nORG_ID IN NUMBER,
67 nTOP_ID IN NUMBER);
68 ------------------------------------------------------------------------------------------
69 FUNCTION REPORT (Msg in VARCHAR2, Urgency in NUMBER, ByCaller in VARCHAR2,
70 StatusCode in NUMBER) RETURN BOOLEAN;
71 ------------------------------------------------------------------------------------------
72 PROCEDURE go_generic_cp(errbuf OUT NOCOPY VARCHAR2,
73 retcode OUT NOCOPY NUMBER,
74 inRun_ID IN PLS_INTEGER,
75 p_rp_folder_id NUMBER); -- sselahi: added new procedure rpf
76 ------------------------------------------------------------------------------------------
77 END CZ_IMP_ALL;