1 PACKAGE CZ_IMP_PS_NODE AUTHID CURRENT_USER AS
2 /* $Header: czipsns.pls 120.2.12020000.2 2012/08/17 15:06:26 smanna ship $ */
3
4 PROCEDURE KRS_PS_NODE(inRUN_ID IN PLS_INTEGER,
5 COMMIT_SIZE IN PLS_INTEGER,
6 MAX_ERR IN PLS_INTEGER,
7 INSERTS IN OUT NOCOPY PLS_INTEGER,
8 UPDATES IN OUT NOCOPY PLS_INTEGER,
9 FAILED IN OUT NOCOPY PLS_INTEGER,
10 DUPS IN OUT NOCOPY PLS_INTEGER,
11 NOCHANGE IN OUT NOCOPY PLS_INTEGER,
12 inXFR_GROUP IN VARCHAR2
13 );
14 PROCEDURE CND_PS_NODE(inRUN_ID IN PLS_INTEGER,
15 COMMIT_SIZE IN PLS_INTEGER,
16 MAX_ERR IN PLS_INTEGER,
17 FAILED IN OUT NOCOPY PLS_INTEGER
18 );
19 PROCEDURE MAIN_PS_NODE(inRUN_ID IN PLS_INTEGER,
20 COMMIT_SIZE IN PLS_INTEGER,
21 MAX_ERR IN PLS_INTEGER,
22 INSERTS IN OUT NOCOPY PLS_INTEGER,
23 UPDATES IN OUT NOCOPY PLS_INTEGER,
24 FAILED IN OUT NOCOPY PLS_INTEGER,
25 DUPS IN OUT NOCOPY PLS_INTEGER,
26 NOCHANGE IN OUT NOCOPY PLS_INTEGER,
27 inXFR_GROUP IN VARCHAR2
28 );
29 PROCEDURE XFR_PS_NODE(inRUN_ID IN PLS_INTEGER,
30 COMMIT_SIZE IN PLS_INTEGER,
31 MAX_ERR IN PLS_INTEGER,
32 INSERTS IN OUT NOCOPY PLS_INTEGER,
33 UPDATES IN OUT NOCOPY PLS_INTEGER,
34 FAILED IN OUT NOCOPY PLS_INTEGER,
35 NOCHANGE IN OUT NOCOPY PLS_INTEGER,
36 inXFR_GROUP IN VARCHAR2
37 );
38
39 PROCEDURE RPT_PS_NODE(inRUN_ID IN PLS_INTEGER);
40
41 PROCEDURE KRS_INTL_TEXT(inRUN_ID IN PLS_INTEGER,
42 COMMIT_SIZE IN PLS_INTEGER,
43 MAX_ERR IN PLS_INTEGER,
44 INSERTS IN OUT NOCOPY PLS_INTEGER,
45 UPDATES IN OUT NOCOPY PLS_INTEGER,
46 FAILED IN OUT NOCOPY PLS_INTEGER,
47 DUPS IN OUT NOCOPY PLS_INTEGER,
48 NOCHANGE IN OUT NOCOPY PLS_INTEGER,
49 inXFR_GROUP IN VARCHAR2
50 );
51 PROCEDURE CND_INTL_TEXT(inRUN_ID IN PLS_INTEGER,
52 COMMIT_SIZE IN PLS_INTEGER,
53 MAX_ERR IN PLS_INTEGER,
54 FAILED IN OUT NOCOPY PLS_INTEGER
55 );
56 PROCEDURE MAIN_INTL_TEXT(inRUN_ID IN PLS_INTEGER,
57 COMMIT_SIZE IN PLS_INTEGER,
58 MAX_ERR IN PLS_INTEGER,
59 INSERTS IN OUT NOCOPY PLS_INTEGER,
60 UPDATES IN OUT NOCOPY PLS_INTEGER,
61 FAILED IN OUT NOCOPY PLS_INTEGER,
62 DUPS IN OUT NOCOPY PLS_INTEGER,
63 NOCHANGE IN OUT NOCOPY PLS_INTEGER,
64 inXFR_GROUP IN VARCHAR2
65 );
66 PROCEDURE XFR_INTL_TEXT(inRUN_ID IN PLS_INTEGER,
67 COMMIT_SIZE IN PLS_INTEGER,
68 MAX_ERR IN PLS_INTEGER,
69 INSERTS IN OUT NOCOPY PLS_INTEGER,
70 UPDATES IN OUT NOCOPY PLS_INTEGER,
71 FAILED IN OUT NOCOPY PLS_INTEGER,
72 NOCHANGE IN OUT NOCOPY PLS_INTEGER,
73 inXFR_GROUP IN VARCHAR2
74 );
75
76 PROCEDURE RPT_INTL_TEXT(inRUN_ID IN PLS_INTEGER);
77
78 PROCEDURE KRS_DEVL_PROJECT(inRUN_ID IN PLS_INTEGER,
79 COMMIT_SIZE IN PLS_INTEGER,
80 MAX_ERR IN PLS_INTEGER,
81 INSERTS IN OUT NOCOPY PLS_INTEGER,
82 UPDATES IN OUT NOCOPY PLS_INTEGER,
83 FAILED IN OUT NOCOPY PLS_INTEGER,
84 DUPS IN OUT NOCOPY PLS_INTEGER,
85 NOCHANGE IN OUT NOCOPY PLS_INTEGER,
86 inXFR_GROUP IN VARCHAR2,
87 inCONFIG_ENGINE_TYPE IN VARCHAR2 );
88 PROCEDURE CND_DEVL_PROJECT(inRUN_ID IN PLS_INTEGER,
89 COMMIT_SIZE IN PLS_INTEGER,
90 MAX_ERR IN PLS_INTEGER,
91 FAILED IN OUT NOCOPY PLS_INTEGER
92 );
93 PROCEDURE MAIN_DEVL_PROJECT(inRUN_ID IN PLS_INTEGER,
94 COMMIT_SIZE IN PLS_INTEGER,
95 MAX_ERR IN PLS_INTEGER,
96 INSERTS IN OUT NOCOPY PLS_INTEGER,
97 UPDATES IN OUT NOCOPY PLS_INTEGER,
98 FAILED IN OUT NOCOPY PLS_INTEGER,
99 DUPS IN OUT NOCOPY PLS_INTEGER,
100 NOCHANGE IN OUT NOCOPY PLS_INTEGER,
101 inXFR_GROUP IN VARCHAR2,
102 p_rp_folder_id IN NUMBER, -- sselahi rpf
103 inCONFIG_ENGINE_TYPE IN VARCHAR2 );
104 PROCEDURE XFR_DEVL_PROJECT(inRUN_ID IN PLS_INTEGER,
105 COMMIT_SIZE IN PLS_INTEGER,
106 MAX_ERR IN PLS_INTEGER,
107 INSERTS IN OUT NOCOPY PLS_INTEGER,
108 UPDATES IN OUT NOCOPY PLS_INTEGER,
109 FAILED IN OUT NOCOPY PLS_INTEGER,
110 NOCHANGE IN OUT NOCOPY PLS_INTEGER,
111 inXFR_GROUP IN VARCHAR2,
112 P_rp_folder_id IN NUMBER -- sselahi rpf
113 );
114
115 PROCEDURE RPT_DEVL_PROJECT(inRUN_ID IN PLS_INTEGER);
116
117 /* Constant Declarations */
118 cnOracleToMerlinOffset CONSTANT NUMBER:=256; /*Conversion Const*/
119 cnProduct CONSTANT NUMBER:=cnOracleToMerlinOffset+2;/*Product Type*/
120 cnComponent CONSTANT NUMBER:=cnOracleToMerlinOffset+3;/*Component Type*/
121 cnFeature CONSTANT NUMBER:=cnOracleToMerlinOffset+5;/*Feature Type*/
122 cnOption CONSTANT NUMBER:=cnOracleToMerlinOffset+6;/*Option Type*/
123 cnModel CONSTANT NUMBER:=1; /*Oracle Model Type*/
124 cnOptionClass CONSTANT NUMBER:=2; /*Oracle Option Class Type*/
125 cnStandard CONSTANT NUMBER:=4; /*Oracle Standard Type*/
126 cnReference CONSTANT NUMBER:=263;
127 cnConnector CONSTANT NUMBER:=264;
128 cnTotal CONSTANT NUMBER:=272;
129 cnResource CONSTANT NUMBER:=273;
130 bomModel CONSTANT NUMBER:=436; /*BOM Item Model type*/
131 bomOptionClass CONSTANT NUMBER:=437; /*BOM Item OptionClass type*/
132 bomStandard CONSTANT NUMBER:=438; /*BOM Item Standard type*/
133 /* BOM_TREATMENT values */
134 cnNormal CONSTANT NUMBER:=0;
135 cnSkip CONSTANT NUMBER:=1;
136 cnLeaf CONSTANT NUMBER:=2;
137 cnFlatten CONSTANT NUMBER:=3;
138 /* Oracle Yes/No values */
139 OraYes CONSTANT NUMBER:=1;
140 OraNo CONSTANT NUMBER:=2;
141 cnDefSrcAppId CONSTANT NUMBER:=-1;
142 cnDefSrcTypeCode CONSTANT NUMBER:=-1;
143 --The segment length of the SORT_ORDER column, correlates with the value hardcoded in the bom_exploder
144 --procedure
145
146 n_SortWidth NUMBER := Bom_Common_Definitions.G_Bom_SortCode_Width;
147 gContractsModel BOOLEAN := FALSE; /* cz_contracts_api_grp.import_generic must set to true to allow seeded models */
148
149 END CZ_IMP_PS_NODE;