1 PACKAGE CZ_IMP_ALL AUTHID CURRENT_USER AS
2 /* $Header: czialls.pls 120.3 2010/10/22 19:17:59 lamrute 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 -- Bug10011026 This procedure was introduced for Sun implementation where new Concurrent Program
58 -- was introduced with same (segment1) value for sFrom and sTo parameters and cursor in original
59 -- procedure was changed to go against only cz_exv_mtl_system_items for performance improvement
60 PROCEDURE PopulateSingleModel_cp(errbuf OUT NOCOPY VARCHAR2,retcode OUT NOCOPY NUMBER,
61 sOrg_ID IN VARCHAR2,dsOrg_ID IN VARCHAR2,
62 sFrom IN VARCHAR2,sTo IN VARCHAR,
63 COPY_CHILD_MODELS IN VARCHAR2 DEFAULT '0');
64 ------------------------------------------------------------------------------------------
65 PROCEDURE RefreshModels(errbuf OUT NOCOPY VARCHAR2,retcode OUT NOCOPY NUMBER);
66 ------------------------------------------------------------------------------------------
67 PROCEDURE setRunID(inRun_ID IN PLS_INTEGER,table_name IN VARCHAR2);
68 ------------------------------------------------------------------------------------------
69 PROCEDURE setRecStatus(inRun_ID IN PLS_INTEGER,table_name IN VARCHAR2);
70 ------------------------------------------------------------------------------------------
71 PROCEDURE check_for_common_bill
72 (errbuf OUT NOCOPY VARCHAR2,
73 retcode OUT NOCOPY NUMBER,
74 nORG_ID IN NUMBER,
75 nTOP_ID IN NUMBER);
76 ------------------------------------------------------------------------------------------
77 FUNCTION REPORT (Msg in VARCHAR2, Urgency in NUMBER, ByCaller in VARCHAR2,
78 StatusCode in NUMBER) RETURN BOOLEAN;
79 ------------------------------------------------------------------------------------------
80 PROCEDURE go_generic_cp(errbuf OUT NOCOPY VARCHAR2,
81 retcode OUT NOCOPY NUMBER,
82 inRun_ID IN PLS_INTEGER,
83 p_rp_folder_id NUMBER); -- sselahi: added new procedure rpf
84 ------------------------------------------------------------------------------------------
85 END CZ_IMP_ALL;
[Home] [Help]