[Home] [Help]
PACKAGE: APPS.CZ_TYPES
Source
1 PACKAGE CZ_TYPES AUTHID CURRENT_USER AS
2 /* $Header: cztypess.pls 120.4 2007/11/15 22:08:58 skudryav ship $ */
3
4 OPTIONAL_EXPL_TYPE CONSTANT INTEGER:=1;
5 MANDATORY_EXPL_TYPE CONSTANT INTEGER:=2;
6 CONNECTOR_EXPL_TYPE CONSTANT INTEGER:=3;
7 MINMAX_EXPL_TYPE CONSTANT INTEGER:=4;
8
9 DATA_TYPE_NODE CONSTANT INTEGER := 5;
10
11 PS_NODE_TYPE_PRODUCT CONSTANT INTEGER := 258;
12 PS_NODE_TYPE_COMPONENT CONSTANT INTEGER := 259;
13 PS_NODE_TYPE_FEATURE CONSTANT INTEGER := 261;
14 PS_NODE_TYPE_OPTION CONSTANT INTEGER := 262;
15 PS_NODE_TYPE_TOTAL CONSTANT INTEGER := 272;
16 PS_NODE_TYPE_RESOURCE CONSTANT INTEGER := 273;
17 PS_NODE_TYPE_INT_TOTAL CONSTANT INTEGER := 274;
18 PS_NODE_TYPE_INT_RESOURCE CONSTANT INTEGER := 275;
19 PS_NODE_TYPE_BOM_MODEL CONSTANT INTEGER := 436;
20 PS_NODE_TYPE_BOM_OPTION_CLASS CONSTANT INTEGER := 437;
21 PS_NODE_TYPE_BOM_STANDART_ITEM CONSTANT INTEGER := 438;
22 PS_NODE_TYPE_REFERENCE CONSTANT INTEGER := 263;
23 PS_NODE_TYPE_CONNECTOR CONSTANT INTEGER := 264;
24
25 MANDATORY_PRODUCT_TYPEID CONSTANT INTEGER := 2052;
26 OPTIONAL_PRODUCT_TYPEID CONSTANT INTEGER := 510;
27 MINMAX_PRODUCT_TYPEID CONSTANT INTEGER := 511;
28 MANDATORY_COMPONENT_TYPEID CONSTANT INTEGER := 2054;
29 OPTIONAL_COMPONENT_TYPEID CONSTANT INTEGER := 512;
30 MINMAX_COMPONENT_TYPEID CONSTANT INTEGER := 513;
31 NON_COUNT_FEATURE_TYPEID CONSTANT INTEGER := 2056;
32 COUNT_FEATURE_TYPEID CONSTANT INTEGER := 2079;
33 COUNT_FEATURE01_TYPEID CONSTANT INTEGER := 2078;
34 MINMAX_FEATURE_TYPEID CONSTANT INTEGER := 2081;
35 MINMAX_FEATURE01_TYPEID CONSTANT INTEGER := 3007;
36 OPTION_TYPEID CONSTANT INTEGER := 262;
37 INTEGER_FEATURE_TYPEID CONSTANT INTEGER := 504;
38 INTEGER_COUNT_FEATURE_TYPEID CONSTANT INTEGER := 503;
39 DECIMAL_FEATURE_TYPEID CONSTANT INTEGER := 505;
40 BOOLEAN_FEATURE_TYPEID CONSTANT INTEGER := 502;
41 TEXT_FEATURE_TYPEID CONSTANT INTEGER := 506;
42 TOTAL_TYPEID CONSTANT INTEGER := 272;
43 RESOURCE_TYPEID CONSTANT INTEGER := 273;
44 INT_TOTAL_TYPEID CONSTANT INTEGER := 274;
45 INT_RESOURCE_TYPEID CONSTANT INTEGER := 275;
46
47 MANDATORY_NONBOM_REF_TYPEID CONSTANT INTEGER := 514;
48 OPTIONAL_NONBOM_REF_TYPEID CONSTANT INTEGER := 515;
49 MINMAX_NONBOM_REF_TYPEID CONSTANT INTEGER := 516;
50
51 MANDATORY_BOM_REF_TYPEID CONSTANT INTEGER := 517;
52 OPTIONAL_BOM_REF_TYPEID CONSTANT INTEGER := 3000;
53 MINMAX_BOM_REF_TYPEID CONSTANT INTEGER := 3001;
54
55 CONNECTOR_TYPEID CONSTANT INTEGER := 264;
56
57 BOM_MODEL_MTX_TYPEID CONSTANT INTEGER := 2082;
58 BOM_MODEL_NMTX_TYPEID CONSTANT INTEGER := 2083;
59
60 BOM_OPTION_CLASS_MTX_TYPEID CONSTANT INTEGER := 2084;
61 BOM_OPTION_CLASS_NMTX_TYPEID CONSTANT INTEGER := 2085;
62
63 BOM_STANDART_ITEM_TYPEID CONSTANT INTEGER := 438;
64 BOM_DECQ_STANDART_ITEM_TYPEID CONSTANT INTEGER := 448;
65
66 --New types added: bug #3962731.
67
68 TRACKABLE_MBOM_REF_TYPEID CONSTANT INTEGER := 3012;
69 TRACKABLE_OPTBOM_REF_TYPEID CONSTANT INTEGER := 3018;
70 TRACKABLE_MMBOM_REF_TYPEID CONSTANT INTEGER := 3019;
71 TRACKABLE_MODEL_MTX_TYPEID CONSTANT INTEGER := 3014;
72 TRACKABLE_MODEL_NMTX_TYPEID CONSTANT INTEGER := 3015;
73 TRACKABLE_OC_MTX_TYPEID CONSTANT INTEGER := 3016;
74 TRACKABLE_OC_NMTX_TYPEID CONSTANT INTEGER := 3017;
75 TRACKABLE_STD_ITEM_TYPEID CONSTANT INTEGER := 3010;
76 TRACKABLE_DECQ_STD_ITEM_TYPEID CONSTANT INTEGER := 3011;
77
78 ----------------------- UI signatures -------------------------
79
80 UMANDATORY_COMPONENT_TYPEID CONSTANT INTEGER := 548;
81 UOPTIONAL_COMPONENT_TYPEID CONSTANT INTEGER := 541;
82 UMINMAX_COMPONENT_TYPEID CONSTANT INTEGER := 542;
83
84 UNON_COUNT_FEATURE_TYPEID CONSTANT INTEGER := 537;
85 UCOUNT_FEATURE_TYPEID CONSTANT INTEGER := 540;
86 UCOUNT_FEATURE01_TYPEID CONSTANT INTEGER := 539;
87 UMINMAX_FEATURE_TYPEID CONSTANT INTEGER := 538;
88
89 UINTEGER_FEATURE_TYPEID CONSTANT INTEGER := 504;
90 UDECIMAL_FEATURE_TYPEID CONSTANT INTEGER := 505;
91
92 UBOOLEAN_FEATURE_TYPEID CONSTANT INTEGER := 502;
93 UTEXT_FEATURE_TYPEID CONSTANT INTEGER := 506;
94
95 UTOTAL_TYPEID CONSTANT INTEGER := 544;
96 URESOURCE_TYPEID CONSTANT INTEGER := 544;
97 UINT_TOTAL_TYPEID CONSTANT INTEGER := 544;
98 UINT_RESOURCE_TYPEID CONSTANT INTEGER := 544;
99
100 UCONNECTOR_TYPEID CONSTANT INTEGER := 264;
101
102 UMANDATORY_REF_TYPEID CONSTANT INTEGER := 2151;
103 UOPTIONAL_BOM_REF_TYPEID CONSTANT INTEGER := 535;
104 UMINMAX_BOM_REF_TYPEID CONSTANT INTEGER := 536;
105
106 UBOM_NSTBOM_NQMTX_TYPEID CONSTANT INTEGER := 532;
107 UBOM_NSTBOM_NQNMTX_TYPEID CONSTANT INTEGER := 534;
108 UBOM_NSTBOM_QNMTX_TYPEID CONSTANT INTEGER := 533;
109 UBOM_NSTBOM_QMTX_TYPEID CONSTANT INTEGER := 531;
110
111 UBOM_STIO_NQMTX_TYPEID CONSTANT INTEGER := 528;
112 UBOM_STIO_NQNMTX_TYPEID CONSTANT INTEGER := 530;
113 UBOM_STIO_QNMTX_TYPEID CONSTANT INTEGER := 529;
114 UBOM_STIO_QMTX_TYPEID CONSTANT INTEGER := 527;
115
116 UBOM_STANDART_ITEM_TYPEID CONSTANT INTEGER := 438;
117 UOPTION_TYPEID CONSTANT INTEGER := 262;
118 UMINMAX_CONNECTOR CONSTANT INTEGER := 7000;
119
120 ---------------------------------------------------------------
121
122 CNON_COUNT_FEATURE_TYPEID CONSTANT INTEGER := 501;
123
124 ---------------------------------------------------------------
125
126 MODEL_TYPE_ATO CONSTANT VARCHAR2(1):= 'A';
127 MODEL_TYPE_PTO CONSTANT VARCHAR2(1):= 'P';
128
129 FUNCTION is_Mutex
130 (p_ps_node_id IN NUMBER,
131 p_max_selected IN NUMBER) RETURN VARCHAR2;
132 PRAGMA RESTRICT_REFERENCES (is_Mutex, WNDS, WNPS);
133
134 FUNCTION is_Mutex
135 (p_ps_node_id IN NUMBER) RETURN VARCHAR2;
136 PRAGMA RESTRICT_REFERENCES (is_Mutex, WNDS, WNPS);
137
138 PROCEDURE is_Mutex
139 (p_ps_node_id IN NUMBER,
140 p_max_selected IN NUMBER,
141 x_mutex_flag OUT NOCOPY VARCHAR2);
142
143 PROCEDURE is_Mutex
144 (p_ps_node_id IN NUMBER,
145 x_mutex_flag OUT NOCOPY VARCHAR2);
146
147 FUNCTION get_UI_Signature_Id
148 (
149 p_ps_node_id IN NUMBER,
150 p_instantiable_flag IN VARCHAR2,
151 p_feature_type IN NUMBER,
152 p_counted_options_flag IN VARCHAR2,
153 p_maximum IN NUMBER,
154 p_minimum IN NUMBER,
155 p_ps_node_type IN NUMBER,
156 p_reference_id IN NUMBER,
157 p_max_selected IN NUMBER
158 ) RETURN NUMBER;
159
160 PRAGMA RESTRICT_REFERENCES (get_UI_Signature_Id, WNDS, WNPS);
161
162 FUNCTION is_It_Region
163 ( p_ps_node_type IN NUMBER) RETURN VARCHAR2;
164
165 PRAGMA RESTRICT_REFERENCES (is_It_Region, WNDS, WNPS);
166
167 FUNCTION get_Persistent_Node_Id(p_ps_node_id IN NUMBER) RETURN NUMBER;
168
169 PRAGMA RESTRICT_REFERENCES (get_Persistent_Node_Id, WNDS, WNPS);
170
171
172 FUNCTION get_Rule_Signature_Id
173 (
174 p_instantiable_flag IN VARCHAR2,
175 p_feature_type IN NUMBER,
176 p_counted_options_flag IN VARCHAR2,
177 p_maximum IN NUMBER,
178 p_minimum IN NUMBER,
179 p_ps_node_type IN NUMBER,
180 p_reference_id IN NUMBER,
181 p_max_selected IN NUMBER,
182 p_decimal_qty_flag IN VARCHAR2,
183 p_ib_trackable IN VARCHAR2,
184 p_devl_project_id IN NUMBER
185 ) RETURN NUMBER;
186
187 PRAGMA RESTRICT_REFERENCES (get_Rule_Signature_Id, WNDS, WNPS);
188
189 FUNCTION NODE_TYPE_AVAILABLE(p_ps_node_id IN NUMBER,
190 p_exp_data_type IN NUMBER,
191 p_exp_mutable_flag IN NUMBER,
192 p_exp_collection_flag IN NUMBER)
193 RETURN NUMBER;
194
195 PRAGMA RESTRICT_REFERENCES (node_type_available, WNDS, WNPS);
196
197 FUNCTION NODE_USER_PROPS_AVAILABLE(p_ps_node_id IN NUMBER,
198 p_exp_data_type IN NUMBER,
199 p_exp_mutable_flag IN NUMBER,
200 p_exp_collection_flag IN NUMBER)
201 RETURN NUMBER;
202
203 PRAGMA RESTRICT_REFERENCES (node_user_props_available, WNDS, WNPS);
204
205
206 FUNCTION NODE_CAPTION_PROPS_AVAILABLE(p_ps_node_id IN NUMBER,
207 p_exp_data_type IN NUMBER,
208 p_exp_mutable_flag IN NUMBER,
209 p_exp_collection_flag IN NUMBER)
210 RETURN NUMBER;
211
212 PROCEDURE get_Ps_Node_Type(p_signature_id IN NUMBER,
213 x_ps_node_type OUT NOCOPY NUMBER,
214 x_ps_node_subtype OUT NOCOPY NUMBER);
215
216 END CZ_TYPES;