[Home] [Help]
PACKAGE: APPS.CZ_UPGRADE
Source
1 PACKAGE CZ_UPGRADE AS
2 /* $Header: czupgrds.pls 120.0 2005/05/25 06:14:49 appldev noship $ */
3 ---------------------------------------------------------------------------------------
4 NEVER_EXISTS_ID CONSTANT PLS_INTEGER := -9999;
5 PATH_DELIMITER CONSTANT CHAR(1) := '^';
6 ---------------------------------------------------------------------------------------
7 ps_node_type_product CONSTANT NUMBER := 258;
8 ps_node_type_component CONSTANT NUMBER := 259;
9 ps_node_type_reference CONSTANT NUMBER := 263;
10 ps_node_type_connector CONSTANT NUMBER := 264;
11 ps_node_type_feature CONSTANT NUMBER := 261;
12 ps_node_type_option CONSTANT NUMBER := 262;
13 ps_node_type_total CONSTANT NUMBER := 272;
14 ps_node_type_resource CONSTANT NUMBER := 273;
15 ps_node_type_bom_model CONSTANT NUMBER := 436;
16 ps_node_type_bom_optionclass CONSTANT NUMBER := 437;
17 ps_node_type_bom_standard CONSTANT NUMBER := 438;
18 ---------------------------------------------------------------------------------------
19 EXPL_NODE_TYPE_UNDEFINED CONSTANT PLS_INTEGER := 0;
20 EXPL_NODE_TYPE_OPTIONAL CONSTANT PLS_INTEGER := 1; --A
21 EXPL_NODE_TYPE_MANDATORY CONSTANT PLS_INTEGER := 2; --B
22 EXPL_NODE_TYPE_CONNECTOR CONSTANT PLS_INTEGER := 3; --C
23 EXPL_NODE_TYPE_INSTANTIABLE CONSTANT PLS_INTEGER := 4; --D
24 ---------------------------------------------------------------------------------------
25 ps_node_feature_type_option CONSTANT NUMBER := 0;
26 ps_node_feature_type_integer CONSTANT NUMBER := 1;
27 ps_node_feature_type_float CONSTANT NUMBER := 2;
28 ps_node_feature_type_boolean CONSTANT NUMBER := 3;
29 ps_node_feature_type_string CONSTANT NUMBER := 4;
30 ---------------------------------------------------------------------------------------
31 expr_node_type_node CONSTANT PLS_INTEGER := 205;
32 expr_node_type_featprop CONSTANT PLS_INTEGER := 204;
33 expr_node_type_operator CONSTANT PLS_INTEGER := 200;
34 expr_node_type_punct CONSTANT PLS_INTEGER := 208;
35 expr_node_type_literal CONSTANT PLS_INTEGER := 201;
36 expr_node_type_sysprop CONSTANT PLS_INTEGER := 210;
37 expr_node_type_prop CONSTANT PLS_INTEGER := 207;
38 expr_node_type_count CONSTANT PLS_INTEGER := 209;
39 EXPR_NODE_TYPE_CONSTANT CONSTANT PLS_INTEGER := 211;
40 ---------------------------------------------------------------------------------------
41 operator_dot CONSTANT PLS_INTEGER := 326;
42 ---------------------------------------------------------------------------------------
43 SYS_PROP_NAME CONSTANT PLS_INTEGER := 1;
44 SYS_PROP_SELECTION CONSTANT PLS_INTEGER := 2;
45 SYS_PROP_COUNT CONSTANT PLS_INTEGER := 3;
46 sys_prop_min CONSTANT PLS_INTEGER := 4;
47 sys_prop_max CONSTANT PLS_INTEGER := 5;
48 ---------------------------------------------------------------------------------------
49 flag_not_deleted CONSTANT CHAR(1) := '0';
50 flag_not_disabled CONSTANT CHAR(1) := '0';
51 flag_non_virtual CONSTANT CHAR(1) := '0';
52 flag_not_consequent CONSTANT CHAR(1) := '0';
53 flag_virtual CONSTANT CHAR(1) := '1';
54 flag_bom_required CONSTANT CHAR(1) := '1';
55 flag_is_consequent CONSTANT CHAR(1) := '1';
56 ---------------------------------------------------------------------------------------
57 fatal_illegal_option_feature EXCEPTION;
58 fatal_unable_to_set_virtual EXCEPTION;
59 fatal_unable_to_create_header EXCEPTION;
60 fatal_invalid_rule EXCEPTION;
61 CZ_G_UNABLE_TO_REPORT_ERROR EXCEPTION;
62 CZ_S_MODEL_IGNORED EXCEPTION;
63 CZ_R_RULE_IGNORED EXCEPTION;
64 CZ_R_RULE_REPORTED EXCEPTION;
65 ---------------------------------------------------------------------------------------
66 RULE_TYPE_LOGIC_RULE CONSTANT PLS_INTEGER := 21;
67 RULE_TYPE_NUMERIC_RULE CONSTANT PLS_INTEGER := 22;
68 RULE_TYPE_COMPAT_RULE CONSTANT PLS_INTEGER := 23;
69 RULE_TYPE_COMPAT_TABLE CONSTANT PLS_INTEGER := 24;
70 RULE_TYPE_COMPARISON_RULE CONSTANT PLS_INTEGER := 27;
71 RULE_TYPE_FUNC_COMP CONSTANT PLS_INTEGER := 29;
72 RULE_TYPE_DESIGNCHART_RULE CONSTANT PLS_INTEGER := 30;
73 RULE_TYPE_RULE_FOLDER CONSTANT PLS_INTEGER := 39;
74 ---------------------------------------------------------------------------------------
75 -- Use fixed sort width for all pre21 (Note starting with 21 sort width is defined by
76 -- Bom_Common_Definitions.G_Bom_SortCode_Width)
77 -- Note czsort.sql has hard coded '0001' and substr(bom_sort_order, 5)
78 SORT_WIDTH_PRE21 CONSTANT NUMBER := 4;
79 ---------------------------------------------------------------------------------------
80
81 -------used for logic upgrade from 14,15,16,17 to 18 or more
82 TYPE t_ref IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
83
84 MAJOR_SCHEMA_VERSION CONSTANT VARCHAR2(40) := 'MAJOR_VERSION';
85 v_lce_hdr NUMBER := 0; /* to trap lce header id that errored OUT NOCOPY */
86 v_schema_version cz_db_settings.value%TYPE;
87
88 ---------------------------------------------------------------------------------------
89 PROCEDURE VERIFY_RULES(inDevlProjectId IN NUMBER,
90 thisRunId IN OUT NOCOPY NUMBER);
91 ---------------------------------------------------------------------------------------
92
93 PROCEDURE AUTO_PUBLISH (p_server_id IN NUMBER);
94
95 PROCEDURE CZBOMSORT(p_model_id IN INTEGER,
96 p_sort_width IN INTEGER,
97 p_batch_size IN INTEGER);
98
99 PROCEDURE CZNATIVEBOMSORT(p_sort_width IN INTEGER,
100 p_batch_size IN INTEGER);
101
102
103 PROCEDURE generate_model_tree(indevlprojectid IN NUMBER);
104
105 PROCEDURE generate_component_tree(incomponentid IN NUMBER,
106 inlogicnetlevel IN NUMBER,
107 inparentexplid IN NUMBER,
108 inparentcomponentid IN NUMBER,
109 inreferringnodeid IN NUMBER);
110
111 PROCEDURE generate_explosion;
112
113 -----------procedures used by logic upgrade
114
115 PROCEDURE cz_populate_lce_load_specs(p_lce_header_id IN NUMBER,
116 x_populate_error_flag IN OUT NOCOPY VARCHAR2,
117 x_populate_error_msg IN OUT NOCOPY VARCHAR2);
118
119 PROCEDURE upgrade_logic_files_to_18;
120
121 PROCEDURE verify_logic (x_logic_status IN OUT NOCOPY VARCHAR2);
122
123 PROCEDURE publish_vision_models;
124
125 ----------------------
126 END CZ_UPGRADE;