[Home] [Help]
PACKAGE: APPS.CZ_LOGIC_GEN
Source
1 PACKAGE CZ_LOGIC_GEN AS
2 /* $Header: czlcegns.pls 120.4 2007/01/04 17:29:37 asiaston ship $ */
3 ---------------------------------------------------------------------------------------
4 VersionString CONSTANT VARCHAR2(25) := '11.5.10.20.1';
5 EffDateFormat CONSTANT VARCHAR2(25) := 'YYYY/MM/DD/HH24:MI:SS';
6 EffUsagePrefix CONSTANT VARCHAR2(25) := '0x';
7 EpochBeginDate CONSTANT DATE := CZ_UTILS.EPOCH_BEGIN_;
8 EpochEndDate CONSTANT DATE := CZ_UTILS.EPOCH_END_;
9 NewLine CONSTANT VARCHAR2(25) := FND_GLOBAL.NEWLINE;
10 AnyUsageMask CONSTANT VARCHAR2(16) := '0000000000000000';
11 NlsNumericCharacters CONSTANT VARCHAR2(16) := '.,';
12 ---------------------------------------------------------------------------------------
13 ORACLE_OBJECT_ALREADY_EXISTS CONSTANT PLS_INTEGER := -955;
14 ORACLE_OBJECT_IN_USE CONSTANT PLS_INTEGER := -14452;
15 DBMS_SQL_MAX_BUFFER_SIZE CONSTANT PLS_INTEGER := 65535;
16 MAX_NUMBER_OF_OPTIONS CONSTANT PLS_INTEGER := 4096; --not used (bug #1746927)
17 NEVER_EXISTS_ID CONSTANT PLS_INTEGER := -9999;
18 DEFAULT_COMMIT_BLOCK_SIZE CONSTANT PLS_INTEGER := 500;
19 LOOP_DETECTED_LOOPS_NUMBER CONSTANT PLS_INTEGER := 5000;
20 MAXIMUM_INDEX_LENGTH CONSTANT PLS_INTEGER := 2000;
21 ---------------------------------------------------------------------------------------
22 MATH_CONSTANT_PI CONSTANT VARCHAR2(100) :=
23 '3.14159265358979323846264338327950288419716939937510582097494459230781640628620899862803';
24 MATH_CONSTANT_E CONSTANT VARCHAR2(100) :=
25 '2.71828182845904523536028747135266249775724709369995957496696762772407663035354759457138';
26 ---------------------------------------------------------------------------------------
27 --cz_db_settings string values, must be in lower case
28 DBSETTINGS_SECTION_NAME CONSTANT VARCHAR2(25) := 'logicgen';
29 COMMIT_BLOCK_SETTING_ID CONSTANT VARCHAR2(25) := 'commitblocksize';
30 OPTIMIZE_NOTTRUE_SETTING_ID CONSTANT VARCHAR2(25) := 'optimizenottrue';
31 OPTIMIZE_ALLANYOF_SETTING_ID CONSTANT VARCHAR2(25) := 'optimizeallanyof';
32 CHILDREN_ORDER_SETTING_ID CONSTANT VARCHAR2(25) := 'changechildrenorder';
33 GATED_COMBO_SETTING_ID CONSTANT VARCHAR2(25) := 'generategatedcombo';
34 STOP_ON_ERROR_SETTING_ID CONSTANT VARCHAR2(25) := 'stoponfatalruleerror';
35 UPDATED_ONLY_SETTING_ID CONSTANT VARCHAR2(25) := 'generateupdatedonly';
36 ---------------------------------------------------------------------------------------
37 PACKING_GENERIC CONSTANT PLS_INTEGER := 0;
38 PACKING_EFFECTIVITY CONSTANT PLS_INTEGER := 1;
39 ---------------------------------------------------------------------------------------
40 BOOLEAN_TRUE_REPRESENTATION CONSTANT VARCHAR2(1) := '1';
41 BOOLEAN_FALSE_REPRESENTATION CONSTANT VARCHAR2(1) := '0';
42 ---------------------------------------------------------------------------------------
43 OPTIMIZATION_UNKNOWN CONSTANT PLS_INTEGER := -1;
44 OPTIMIZATION_REQUESTED CONSTANT PLS_INTEGER := 1;
45 OPTIMIZATION_COMPLETED CONSTANT PLS_INTEGER := 0;
46 ---------------------------------------------------------------------------------------
47 GENERATE_SCOPE_ERROR CONSTANT PLS_INTEGER := -1;
48 GENERATE_CONTRIBUTE CONSTANT PLS_INTEGER := 0;
49 GENERATE_INCREMENT CONSTANT PLS_INTEGER := 1;
50 GENERATE_DYNAMIC CONSTANT PLS_INTEGER := 2;
51 ---------------------------------------------------------------------------------------
52 MODEL_TYPE_CONTAINER_MODEL CONSTANT VARCHAR2(1) := 'N';
53 MODEL_TYPE_PTO_MODEL CONSTANT VARCHAR2(1) := 'A';
54 MODEL_TYPE_ATO_MODEL CONSTANT VARCHAR2(1) := 'P';
55 ---------------------------------------------------------------------------------------
56 PS_NODE_TYPE_PRODUCT CONSTANT PLS_INTEGER := 258;
57 PS_NODE_TYPE_COMPONENT CONSTANT PLS_INTEGER := 259;
58 PS_NODE_TYPE_FEATUREGROUP CONSTANT PLS_INTEGER := 260;
59 PS_NODE_TYPE_FEATURE CONSTANT PLS_INTEGER := 261;
60 PS_NODE_TYPE_OPTION CONSTANT PLS_INTEGER := 262;
61 PS_NODE_TYPE_REFERENCE CONSTANT PLS_INTEGER := 263;
62 PS_NODE_TYPE_CONNECTOR CONSTANT PLS_INTEGER := 264;
63 PS_NODE_TYPE_TOTAL CONSTANT PLS_INTEGER := 272;
64 PS_NODE_TYPE_RESOURCE CONSTANT PLS_INTEGER := 273;
65 PS_NODE_TYPE_BOM_MODEL CONSTANT PLS_INTEGER := 436;
66 PS_NODE_TYPE_BOM_OPTIONCLASS CONSTANT PLS_INTEGER := 437;
67 PS_NODE_TYPE_BOM_STANDARD CONSTANT PLS_INTEGER := 438;
68 ---------------------------------------------------------------------------------------
69 PS_NODE_FEATURE_TYPE_OPTION CONSTANT PLS_INTEGER := 0;
70 PS_NODE_FEATURE_TYPE_INTEGER CONSTANT PLS_INTEGER := 1;
71 PS_NODE_FEATURE_TYPE_FLOAT CONSTANT PLS_INTEGER := 2;
72 PS_NODE_FEATURE_TYPE_BOOLEAN CONSTANT PLS_INTEGER := 3;
73 PS_NODE_FEATURE_TYPE_STRING CONSTANT PLS_INTEGER := 4;
74 ---------------------------------------------------------------------------------------
75 EXPL_NODE_TYPE_UNDEFINED CONSTANT PLS_INTEGER := 0;
76 EXPL_NODE_TYPE_OPTIONAL CONSTANT PLS_INTEGER := 1; --A
77 EXPL_NODE_TYPE_MANDATORY CONSTANT PLS_INTEGER := 2; --B
78 EXPL_NODE_TYPE_CONNECTOR CONSTANT PLS_INTEGER := 3; --C
79 EXPL_NODE_TYPE_INSTANTIABLE CONSTANT PLS_INTEGER := 4; --D
80 ---------------------------------------------------------------------------------------
81 LOGIC_NET_TYPE_STRUCTURE CONSTANT PLS_INTEGER := 1;
82 LOGIC_NET_TYPE_MANDATORY CONSTANT PLS_INTEGER := 2;
83 LOGIC_NET_TYPE_CONDITIONAL CONSTANT PLS_INTEGER := 3;
84 LOGIC_NET_TYPE_NETWORK CONSTANT PLS_INTEGER := 4;
85 ---------------------------------------------------------------------------------------
86 EXPR_NODE_TYPE_NODE CONSTANT PLS_INTEGER := 205;
87 EXPR_NODE_TYPE_FEATPROP CONSTANT PLS_INTEGER := 204;
88 EXPR_NODE_TYPE_OPERATOR CONSTANT PLS_INTEGER := 200;
89 EXPR_NODE_TYPE_PUNCT CONSTANT PLS_INTEGER := 208;
90 EXPR_NODE_TYPE_LITERAL CONSTANT PLS_INTEGER := 201;
91 EXPR_NODE_TYPE_SYSPROP CONSTANT PLS_INTEGER := 210;
92 EXPR_NODE_TYPE_PROP CONSTANT PLS_INTEGER := 207;
93 EXPR_NODE_TYPE_COUNT CONSTANT PLS_INTEGER := 209;
94 EXPR_NODE_TYPE_CONSTANT CONSTANT PLS_INTEGER := 211;
95 ---------------------------------------------------------------------------------------
96 EXPR_SUBTYPE_CONSTANT_E CONSTANT PLS_INTEGER := 0;
97 EXPR_SUBTYPE_CONSTANT_PI CONSTANT PLS_INTEGER := 1;
98 ---------------------------------------------------------------------------------------
99 RULE_SYS_PROP_NAME CONSTANT VARCHAR2(30) := 'NAME';
100 RULE_SYS_PROP_DESCRIPTION CONSTANT VARCHAR2(30) := 'DESCRIPTION';
101 RULE_SYS_PROP_PARENT CONSTANT VARCHAR2(30) := 'PARENT';
102 RULE_SYS_PROP_OPTIONS CONSTANT VARCHAR2(30) := 'OPTIONS';
103 RULE_SYS_PROP_MINVALUE CONSTANT VARCHAR2(30) := 'MINVALUE';
104 RULE_SYS_PROP_MAXVALUE CONSTANT VARCHAR2(30) := 'MAXVALUE';
105 RULE_SYS_PROP_MINQUANTITY CONSTANT VARCHAR2(30) := 'MINQUANTITY';
106 RULE_SYS_PROP_MAXQUANTITY CONSTANT VARCHAR2(30) := 'MAXQUANTITY';
107 RULE_SYS_PROP_MINSELECTED CONSTANT VARCHAR2(30) := 'MINSELECTED';
108 RULE_SYS_PROP_MAXSELECTED CONSTANT VARCHAR2(30) := 'MAXSELECTED';
109 RULE_SYS_PROP_MININSTANCE CONSTANT VARCHAR2(30) := 'MININSTANCES';
110 RULE_SYS_PROP_MAXINSTANCE CONSTANT VARCHAR2(30) := 'MAXINSTANCES';
111 RULE_SYS_PROP_SELECTION CONSTANT VARCHAR2(30) := 'SELECTION';
112 RULE_SYS_PROP_STATE CONSTANT VARCHAR2(30) := 'STATE';
113 RULE_SYS_PROP_VALUE CONSTANT VARCHAR2(30) := 'VALUE';
114 RULE_SYS_PROP_QUANTITY CONSTANT VARCHAR2(30) := 'QUANTITY';
115 RULE_SYS_PROP_INSTANCECOUNT CONSTANT VARCHAR2(30) := 'INSTANCECOUNT';
116 ---------------------------------------------------------------------------------------
117 RULE_OPERATOR_REQUIRES CONSTANT PLS_INTEGER := 1;
118 RULE_OPERATOR_IMPLIES CONSTANT PLS_INTEGER := 2;
119 RULE_OPERATOR_EXCLUDES CONSTANT PLS_INTEGER := 3;
120 RULE_OPERATOR_NEGATES CONSTANT PLS_INTEGER := 4;
121 RULE_OPERATOR_DEFAULTS CONSTANT PLS_INTEGER := 5;
122 RULE_OPERATOR_SETS CONSTANT PLS_INTEGER := 707;
123 RULE_OPERATOR_CONTRIBUTES CONSTANT PLS_INTEGER := 708;
124 RULE_OPERATOR_SUPPLIES CONSTANT PLS_INTEGER := 709;
125 RULE_OPERATOR_CONSUMES CONSTANT PLS_INTEGER := 710;
126 ---------------------------------------------------------------------------------------
127 OPERATOR_BEGINSWITH CONSTANT PLS_INTEGER := 300;
128 OPERATOR_ENDSWITH CONSTANT PLS_INTEGER := 301;
129 OPERATOR_CONTAINS CONSTANT PLS_INTEGER := 303;
130 OPERATOR_LIKE CONSTANT PLS_INTEGER := 304;
131 OPERATOR_MATCHES CONSTANT PLS_INTEGER := 305;
132 OPERATOR_ANYOF CONSTANT PLS_INTEGER := 306;
133 OPERATOR_ALLOF CONSTANT PLS_INTEGER := 307;
134 OPERATOR_AND CONSTANT PLS_INTEGER := 316;
135 OPERATOR_OR CONSTANT PLS_INTEGER := 317;
136 OPERATOR_EQUALS CONSTANT PLS_INTEGER := 318;
137 OPERATOR_NOTEQUALS CONSTANT PLS_INTEGER := 320;
138 OPERATOR_MIN CONSTANT PLS_INTEGER := 321;
139 OPERATOR_MAX CONSTANT PLS_INTEGER := 322;
140 OPERATOR_TRUNCATE CONSTANT PLS_INTEGER := 323;
141 OPERATOR_OPTIONSOF CONSTANT PLS_INTEGER := 324;
142 OPERATOR_GT CONSTANT PLS_INTEGER := 350;
143 OPERATOR_LT CONSTANT PLS_INTEGER := 351;
144 OPERATOR_GE CONSTANT PLS_INTEGER := 352;
145 OPERATOR_LE CONSTANT PLS_INTEGER := 353;
146 OPERATOR_NOTTRUE CONSTANT PLS_INTEGER := 360;
147 OPERATOR_DOESNOTBEGINWITH CONSTANT PLS_INTEGER := 361;
148 OPERATOR_DOESNOTENDWITH CONSTANT PLS_INTEGER := 362;
149 OPERATOR_DOESNOTCONTAIN CONSTANT PLS_INTEGER := 363;
150 OPERATOR_NOTLIKE CONSTANT PLS_INTEGER := 364;
151 OPERATOR_CONCAT CONSTANT PLS_INTEGER := 365;
152 OPERATOR_TOTEXT CONSTANT PLS_INTEGER := 366;
153 OPERATOR_NONE CONSTANT PLS_INTEGER := 399;
154 OPERATOR_ADD CONSTANT PLS_INTEGER := 401;
155 OPERATOR_SUB CONSTANT PLS_INTEGER := 402;
156 OPERATOR_MULT CONSTANT PLS_INTEGER := 403;
157 OPERATOR_DIV CONSTANT PLS_INTEGER := 404;
158 OPERATOR_CEILING CONSTANT PLS_INTEGER := 405;
159 OPERATOR_FLOOR CONSTANT PLS_INTEGER := 406;
160 OPERATOR_ROUND CONSTANT PLS_INTEGER := 407;
161 OPERATOR_COS CONSTANT PLS_INTEGER := 431;
162 OPERATOR_ACOS CONSTANT PLS_INTEGER := 432;
163 OPERATOR_COSH CONSTANT PLS_INTEGER := 433;
164 OPERATOR_SIN CONSTANT PLS_INTEGER := 434;
165 OPERATOR_ASIN CONSTANT PLS_INTEGER := 435;
166 OPERATOR_SINH CONSTANT PLS_INTEGER := 436;
167 OPERATOR_TAN CONSTANT PLS_INTEGER := 437;
168 OPERATOR_ATAN CONSTANT PLS_INTEGER := 438;
169 OPERATOR_TANH CONSTANT PLS_INTEGER := 439;
170 OPERATOR_LOG CONSTANT PLS_INTEGER := 414;
171 OPERATOR_LOG10 CONSTANT PLS_INTEGER := 415;
172 OPERATOR_EXP CONSTANT PLS_INTEGER := 416;
173 OPERATOR_ABS CONSTANT PLS_INTEGER := 417;
174 OPERATOR_SQRT CONSTANT PLS_INTEGER := 418;
175 OPERATOR_MATHDIV CONSTANT PLS_INTEGER := 408;
176 OPERATOR_POW CONSTANT PLS_INTEGER := 410;
177 OPERATOR_ATAN2 CONSTANT PLS_INTEGER := 430;
178 OPERATOR_MOD CONSTANT PLS_INTEGER := 409;
179 OPERATOR_ROUNDTONEAREST CONSTANT PLS_INTEGER := 411;
180 OPERATOR_ROUNDUPTONEAREST CONSTANT PLS_INTEGER := 413;
181 OPERATOR_ROUNDDOWNTONEAREST CONSTANT PLS_INTEGER := 412;
182 OPERATOR_POW_INT CONSTANT PLS_INTEGER := 551;
183 OPERATOR_NOT CONSTANT PLS_INTEGER := 552;
184 OPERATOR_EQUALS_INT CONSTANT PLS_INTEGER := 553;
185 OPERATOR_NOTEQUALS_INT CONSTANT PLS_INTEGER := 554;
186 OPERATOR_GT_INT CONSTANT PLS_INTEGER := -1;
187 OPERATOR_LT_INT CONSTANT PLS_INTEGER := -1;
188 OPERATOR_GE_INT CONSTANT PLS_INTEGER := -1;
189 OPERATOR_LE_INT CONSTANT PLS_INTEGER := -1;
190 OPERATOR_ADD_INT CONSTANT PLS_INTEGER := -1;
191 OPERATOR_SUB_INT CONSTANT PLS_INTEGER := -1;
192 OPERATOR_MULT_INT CONSTANT PLS_INTEGER := -1;
193 OPERATOR_VAL CONSTANT PLS_INTEGER := -1;
194 OPERATOR_DOT CONSTANT PLS_INTEGER := -1;
195 ---------------------------------------------------------------------------------------
196 TEMPLATE_ANYTRUE CONSTANT PLS_INTEGER := 306;
197 TEMPLATE_ALLTRUE CONSTANT PLS_INTEGER := 307;
198 ---------------------------------------------------------------------------------------
199 RULE_TYPE_LOGIC_RULE CONSTANT PLS_INTEGER := 21;
200 RULE_TYPE_NUMERIC_RULE CONSTANT PLS_INTEGER := 22;
201 RULE_TYPE_COMPAT_RULE CONSTANT PLS_INTEGER := 23;
202 RULE_TYPE_COMPAT_TABLE CONSTANT PLS_INTEGER := 24;
203 RULE_TYPE_COMPARISON_RULE CONSTANT PLS_INTEGER := 27;
204 RULE_TYPE_FUNC_COMP CONSTANT PLS_INTEGER := 29;
205 RULE_TYPE_DESIGNCHART_RULE CONSTANT PLS_INTEGER := 30;
206 RULE_TYPE_DISPLAY_CONDITION CONSTANT PLS_INTEGER := 33;
207 RULE_TYPE_RULE_FOLDER CONSTANT PLS_INTEGER := 39;
208 RULE_TYPE_TEMPLATE CONSTANT PLS_INTEGER := 100;
209 RULE_TYPE_EXPRESSION CONSTANT PLS_INTEGER := 200;
210 RULE_TYPE_JAVA_METHOD CONSTANT PLS_INTEGER := 300;
211 RULE_TYPE_BINDING_RULE CONSTANT PLS_INTEGER := 400;
212 RULE_TYPE_RULE_SYS_PROP CONSTANT PLS_INTEGER := 500;
213 RULE_TYPE_JAVA_SYS_PROP CONSTANT PLS_INTEGER := 600;
214 RULE_TYPE_CAPTION_RULE CONSTANT PLS_INTEGER := 700;
215 ---------------------------------------------------------------------------------------
216 RULE_TYPE_DESIGNCHART CONSTANT PLS_INTEGER := 28;
217 RULE_TYPE_UNKNOWN CONSTANT PLS_INTEGER := 9999;
218 ---------------------------------------------------------------------------------------
219 EXPR_OPERATOR CONSTANT PLS_INTEGER := 200;
220 EXPR_LITERAL CONSTANT PLS_INTEGER := 201;
221 EXPR_PSNODE CONSTANT PLS_INTEGER := 205;
222 EXPR_REFNODE CONSTANT PLS_INTEGER := 206;
223 EXPR_PROP CONSTANT PLS_INTEGER := 207;
224 EXPR_SYS_PROP CONSTANT PLS_INTEGER := 210;
225 EXPR_JAVA_METHOD CONSTANT PLS_INTEGER := 216;
226 EXPR_SYS_ARGUMENT CONSTANT PLS_INTEGER := 218;
227 EXPR_JAVA_PROPERTY CONSTANT PLS_INTEGER := 220;
228 EXPR_ARGUMENT CONSTANT PLS_INTEGER := 221;
229 EXPR_TEMPLATE CONSTANT PLS_INTEGER := 222;
230 EXPR_FORALL CONSTANT PLS_INTEGER := 223;
231 EXPR_ITERATOR CONSTANT PLS_INTEGER := 224;
232 EXPR_WHERE CONSTANT PLS_INTEGER := 225;
233 EXPR_COMPATIBLE CONSTANT PLS_INTEGER := 226;
234 EXPR_PROPERTYBYNAME CONSTANT PLS_INTEGER := 228;
235 EXPR_OPERATORBYNAME CONSTANT PLS_INTEGER := 229;
236 EXPR_JAVAPROPERTYBYNAME CONSTANT PLS_INTEGER := 230;
237 EXPR_FORALL_DISTINCT CONSTANT PLS_INTEGER := 231;
238 EXPR_PSNODEBYNAME CONSTANT PLS_INTEGER := 232;
239 ---------------------------------------------------------------------------------------
240 DATA_TYPE_VOID CONSTANT PLS_INTEGER := 0;
241 DATA_TYPE_INTEGER CONSTANT PLS_INTEGER := 1;
242 DATA_TYPE_DECIMAL CONSTANT PLS_INTEGER := 2;
243 DATA_TYPE_BOOLEAN CONSTANT PLS_INTEGER := 3;
244 DATA_TYPE_TEXT CONSTANT PLS_INTEGER := 4;
245 DATA_TYPE_NODE CONSTANT PLS_INTEGER := 5;
246 DATA_TYPE_VARIANT CONSTANT PLS_INTEGER := 6;
247 DATA_TYPE_INTEGER_COLL CONSTANT PLS_INTEGER := 7;
248 DATA_TYPE_DECIMAL_COLL CONSTANT PLS_INTEGER := 8;
249 DATA_TYPE_BOOLEAN_COLL CONSTANT PLS_INTEGER := 9;
250 DATA_TYPE_TEXT_COLL CONSTANT PLS_INTEGER := 10;
251 DATA_TYPE_NODE_COLL CONSTANT PLS_INTEGER := 11;
252 DATA_TYPE_VARIANT_COLL CONSTANT PLS_INTEGER := 12;
253 ---------------------------------------------------------------------------------------
254 UNSATISFIED_TYPE_NONE CONSTANT PLS_INTEGER := 0;
255 ---------------------------------------------------------------------------------------
256 PROPERTY_TYPE_SYSTEM CONSTANT PLS_INTEGER := 1;
257 ---------------------------------------------------------------------------------------
258 FLAG_NOT_DELETED CONSTANT CHAR(1) := '0';
259 FLAG_NOT_DISABLED CONSTANT CHAR(1) := '0';
260 FLAG_NON_VIRTUAL CONSTANT CHAR(1) := '0';
261 FLAG_BOM_OPTIONAL CONSTANT CHAR(1) := '0';
262 FLAG_DELETED CONSTANT CHAR(1) := '1';
263 FLAG_VIRTUAL CONSTANT CHAR(1) := '1';
264 FLAG_BOM_REQUIRED CONSTANT CHAR(1) := '1';
265 FLAG_IS_CONSEQUENT CONSTANT CHAR(1) := '1';
266 FLAG_PENDING CONSTANT CHAR(1) := '3';
270 FLAG_NOT_IB_TRACKABLE CONSTANT CHAR(1) := '0';
267 FLAG_DECIMAL_QTY CONSTANT CHAR(1) := '1';
268 FLAG_INTEGER_QTY CONSTANT CHAR(1) := '0';
269 FLAG_IB_TRACKABLE CONSTANT CHAR(1) := '1';
271 FLAG_FREEFORM_RULE CONSTANT CHAR(1) := '0';
272 FLAG_SEEDED CONSTANT CHAR(1) := '1';
273 ---------------------------------------------------------------------------------------
274 FLAG_NO_ACCUMULATOR CONSTANT VARCHAR2(1) := '0';
275 FLAG_ACCUMULATOR_ACC CONSTANT VARCHAR2(1) := '1';
276 FLAG_ACCUMULATOR_NT CONSTANT VARCHAR2(1) := '2';
277 FLAG_ACCUMULATOR_BOTH CONSTANT VARCHAR2(1) := '3';
278 ---------------------------------------------------------------------------------------
279 PATH_DELIMITER CONSTANT CHAR(1) := '^';
280 PROPERTY_DELIMITER CONSTANT CHAR(1) := '|';
281 NAME_DELIMITER CONSTANT CHAR(1) := '.';
282 ALWAYS_TRUE CONSTANT VARCHAR2(16) := '_ALWAYS_TRUE';
283 ALWAYS_FALSE CONSTANT VARCHAR2(16) := '_ALWAYS_FALSE';
284 LOGICAL_CONSTANT_TRUE CONSTANT VARCHAR2(16) := 'TRUE';
285 LOGICAL_CONSTANT_FALSE CONSTANT VARCHAR2(16) := 'FALSE';
286 STEP_UP_DELIMITER CONSTANT VARCHAR2(2) := '..';
287 UNIX_DELIMITER CONSTANT VARCHAR2(1) := '/';
288 ---------------------------------------------------------------------------------------
289 DATATYPE_GENERIC CONSTANT PLS_INTEGER := 0;
290 DATATYPE_INTEGER CONSTANT PLS_INTEGER := 1;
291 DATATYPE_FLOAT CONSTANT PLS_INTEGER := 2;
292 DATATYPE_BOOLEAN CONSTANT PLS_INTEGER := 3;
293 DATATYPE_STRING CONSTANT PLS_INTEGER := 4;
294 ---------------------------------------------------------------------------------------
295 FEATURE_TYPE_PRIMARY CONSTANT PLS_INTEGER := 5;
296 FEATURE_TYPE_DEFINING CONSTANT PLS_INTEGER := 1;
297 FEATURE_TYPE_OPTIONAL CONSTANT PLS_INTEGER := 3;
298 ---------------------------------------------------------------------------------------
299 EVT_ON_COMMAND_NAME CONSTANT VARCHAR2(30) := 'ONCOMMAND';
300 ---------------------------------------------------------------------------------------
301 CZ_G_UNABLE_TO_REPORT_ERROR EXCEPTION;
302 CZ_G_INVALID_RULE_EXPLOSION EXCEPTION;
303 CZ_G_INVALID_MODEL_EXPLOSION EXCEPTION;
304 CZ_G_INVALID_EXPLOSION_TYPE EXCEPTION;
305 CZ_S_DEADLOOP_DETECTED EXCEPTION; --currently not used.
306 CZ_S_ILLEGAL_OPTION_FEATURE EXCEPTION;
307 CZ_S_BAD_BOOLEAN_FEAT_VALUE EXCEPTION;
308 CZ_S_UNABLE_TO_SET_VIRTUAL EXCEPTION;
309 CZ_S_UNABLE_TO_CREATE_HEADER EXCEPTION;
310 CZ_S_UNKNOWN_FEATURE_TYPE EXCEPTION;
311 CZ_S_UNKNOWN_NODE_TYPE EXCEPTION;
312 CZ_S_WRONG_INITIAL_VALUE EXCEPTION;
313 CZ_S_UNKNOWN_BOM_NODE_TYPE EXCEPTION;
314 CZ_S_FEATURE_NO_CHILDREN EXCEPTION;
315 CZ_S_TOO_MANY_OPTIONS EXCEPTION;
316 CZ_S_NO_DATA_IN_PROJECT EXCEPTION;
317 CZ_S_NO_SUCH_PROJECT EXCEPTION;
318 CZ_S_WRONG_EFFECTIVITY_SET EXCEPTION;
319 CZ_S_INCONSISTENT_QUANTITY EXCEPTION;
320 CZ_S_NO_TRACKABLE_FLAG EXCEPTION;
321 CZ_S_TRACKABLE_CONTAINER EXCEPTION;
322 CZ_S_INCORRECT_CONTAINER EXCEPTION;
323 CZ_S_CONNECTOR_TRACKABLE EXCEPTION;
324 CZ_S_CONNECT_NONTRACKABLE EXCEPTION;
325 CZ_S_CONTAINER_REFERENCE EXCEPTION;
326 CZ_S_MULTIPLE_TRACKABLE EXCEPTION;
327 CZ_S_MULTIPLE_INSTANCES EXCEPTION;
328 CZ_S_TRACKABLE_STANDARD EXCEPTION;
329 CZ_S_TRACKABLE_CHILDREN EXCEPTION;
330 CZ_R_AGAINST_TRACKABLE EXCEPTION;
331 CZ_S_INCORRECT_QUANTITY EXCEPTION;
332 CZ_R_TRACKABLE_ANCESTOR EXCEPTION;
333 CZ_R_WRONG_EFFECTIVITY_SET EXCEPTION;
334 CZ_R_UNABLE_TO_CREATE_HEADER EXCEPTION;
335 CZ_R_INVALID_RULE EXCEPTION;
336 CZ_R_UNASSIGNABLE_RULE EXCEPTION;
337 CZ_R_OPTIONAL_INSIDE EXCEPTION;
338 CZ_R_OPTIONAL_ASIDE EXCEPTION;
339 CZ_R_CONNECTOR_ASIDE EXCEPTION;
340 CZ_R_CONFLICTING_NODES EXCEPTION;
341 CZ_R_INCORRECT_NODE_LEVEL EXCEPTION;
342 CZ_R_ACROSS_TRACKABLE EXCEPTION;
343 CZ_R_CONNECTOR_RULE EXCEPTION;
344 CZ_R_UNKNOWN_RULE_TYPE EXCEPTION;
345 CZ_R_INVALID_LOGIC_RULE EXCEPTION;
346 CZ_R_INCOMPLETE_LOGIC_RULE EXCEPTION;
347 CZ_R_LOGIC_RULE_WRONG_FEAT EXCEPTION;
348 CZ_R_INCORRECT_FEATURE_TYPE EXCEPTION;
349 CZ_R_NUMERIC_RULE_WRONG_FEAT EXCEPTION;
350 CZ_R_INVALID_NUMERIC_RULE EXCEPTION;
351 CZ_R_INCORRECT_NUMERIC_RHS EXCEPTION;
352 CZ_R_INVALID_COMPARISON_RULE EXCEPTION;
353 CZ_R_INVALID_NUMERIC_PART EXCEPTION;
354 CZ_R_INVALID_NUM_SIMPLE_EXPR EXCEPTION;
355 CZ_R_INCOMPLETE_NUMERIC_RULE EXCEPTION;
356 CZ_R_NO_PARTICIPANTS EXCEPTION;
357 CZ_R_INVALID_NUMRULE_NODE EXCEPTION;
358 CZ_R_UNABLE_TO_CREATE_TABLE EXCEPTION;
359 CZ_R_WRONG_COMPAT_EXPRESSION EXCEPTION;
360 CZ_R_COMPAT_RULE_NO_PROPERTY EXCEPTION;
361 CZ_R_OPTION_NO_PROPERTY EXCEPTION;
362 CZ_R_LONG_PROPERTY_VALUE EXCEPTION;
363 CZ_R_INCORRECT_DATA_TYPE EXCEPTION;
364 CZ_R_INCORRECT_NUMERICLHS EXCEPTION;
365 CZ_R_PROPERTY_NOT_ALLOWED EXCEPTION;
366 CZ_R_VIRTUAL_COMPONENT EXCEPTION;
367 CZ_R_COMPAT_NO_COMBINATIONS EXCEPTION;
368 CZ_R_WRONG_EXPRESSION_NODE EXCEPTION;
369 CZ_R_RULE_WRONG_EXPRESSION EXCEPTION;
370 CZ_R_NO_PRIMARY_FEATURE EXCEPTION;
371 CZ_R_NO_DEFINING_SELECTION EXCEPTION;
372 CZ_R_WRONG_DESIGNCHART_RULE EXCEPTION; --currently not used.
373 CZ_R_DUPLICATE_COMBINATION EXCEPTION;
374 CZ_R_INCOMPLETE_DES_CHART EXCEPTION;
375 CZ_R_EMPTY_COMPAT_RULE EXCEPTION;
376 CZ_R_COMPAT_SINGLE_FEATURE EXCEPTION;
377 CZ_R_NO_COMPONENT_ID EXCEPTION;
378 CZ_R_WRONG_COMPAT_TABLE EXCEPTION;
379 CZ_R_LITERAL_NO_VALUE EXCEPTION;
380 CZ_R_INCORRECT_NODE_ID EXCEPTION;
381 CZ_R_DELETED_OPTION EXCEPTION;
382 CZ_R_FEATURE_NO_PROPERTY EXCEPTION;
383 CZ_R_TEMPLATE_UNKNOWN EXCEPTION;
384 CZ_R_TEMPLATE_INCORRECT EXCEPTION;
385 CZ_R_INCORRECT_REFNODE EXCEPTION;
386 CZ_R_TYPE_NO_PROPERTY EXCEPTION;
387 CZ_R_EMPTY_PARAMETER_SCOPE EXCEPTION;
388 CZ_R_PARAMETER_NOT_FOUND EXCEPTION;
389 CZ_R_NO_SIGNATURE_ID EXCEPTION;
390 CZ_R_INCOMPATIBLE_SYSPROP EXCEPTION;
391 CZ_E_UNKNOWN_EXPR_TYPE EXCEPTION;
392 CZ_E_WRONG_ARITHMETIC_OPER EXCEPTION;
393 CZ_E_WRONG_COMPARISON_OPER EXCEPTION;
394 CZ_E_WRONG_ROUND_OPERATOR EXCEPTION;
395 CZ_E_WRONG_ANDOR_OPERATOR EXCEPTION;
396 CZ_E_WRONG_NOT_OPERATOR EXCEPTION;
397 CZ_E_WRONG_NOTTRUE_OPERATOR EXCEPTION;
398 CZ_E_WRONG_VAL_EXPRESSION EXCEPTION;
399 CZ_E_WRONG_VAL_EXPRESS_TYPE EXCEPTION;
400 CZ_E_WRONG_MINMAX_OPERATOR EXCEPTION;
401 CZ_E_WRONG_OF_OPERATOR EXCEPTION;
402 CZ_E_WRONG_DOT_OPERATOR EXCEPTION;
403 CZ_E_DOT_TYPE_MISMATCH EXCEPTION;
404 CZ_E_BAD_PROPERTY_TYPE EXCEPTION;
405 CZ_E_NO_SUCH_PROPERTY EXCEPTION;
406 CZ_E_NULL_PROPERTY_VALUE EXCEPTION;
407 CZ_E_INCORRECT_PROPERTY EXCEPTION;
408 CZ_E_WRONG_OPER_IN_COMPAT EXCEPTION;
409 CZ_E_UKNOWN_OPER_IN_COMPAT EXCEPTION;
410 CZ_E_UNKNOWN_OPERATOR_TYPE EXCEPTION;
411 CZ_E_INVALID_OPERAND_TYPE EXCEPTION;
412 CZ_E_NO_EXPECTED_CHILDREN EXCEPTION;
413 CZ_E_NO_OPTIONAL_CHILDREN EXCEPTION;
414 CZ_E_MATH_PARAMETERS EXCEPTION;
415 CZ_E_INCORRECT_POWER EXCEPTION;
416 CZ_LCE_CONTINUE EXCEPTION;
417 CZ_E_DESCRIPTION_IN_WHERE EXCEPTION;
418 CZ_E_PROPERTY_NOT_STATIC EXCEPTION;
419 CZ_LCE_MODEL_OUTOFDATE EXCEPTION;
420 CZ_LCE_INCORRECT_BOM EXCEPTION;
421 CZ_LCE_INCORRECT_ITEM EXCEPTION;
422 CZ_LCE_INCORRECT_TANGIBLE EXCEPTION;
423 CZ_LCE_INCORRECT_SHIPPABLE EXCEPTION;
424 CZ_LCE_RULE_NO_TANGIBLE EXCEPTION;
425 CZ_R_INCORRECT_REFERENCE EXCEPTION;
426 CZ_R_AMBIGUOUS_REFERENCE EXCEPTION;
427 ---------------------------------------------------------------------------------------
428 PROCEDURE GENERATE_LOGIC__(inDevlProjectId IN NUMBER,
429 thisRunId IN NUMBER);
430 ---------------------------------------------------------------------------------------
431 PROCEDURE GENERATE_LOGIC_(inDevlProjectId IN NUMBER,
432 thisRunId IN OUT NOCOPY NUMBER,
436 thisRunId IN OUT NOCOPY NUMBER);
433 TwoPhaseCommit IN PLS_INTEGER);
434 ---------------------------------------------------------------------------------------
435 PROCEDURE GENERATE_LOGIC(inDevlProjectId IN NUMBER,
437 ---------------------------------------------------------------------------------------
438 END;