[Home] [Help]
PACKAGE: APPS.ZPB_MD_RECORDS
Source
1 PACKAGE ZPB_MD_RECORDS AS
2 /* $Header: zpbmdrecs.pls 120.0.12010.2 2005/12/23 08:19:18 appldev noship $ */
3 type DIMENSIONS_ENTRY is record
4 (
5 AwName VARCHAR2(30),
6 BusAreaID NUMBER,
7 DefaultHier VARCHAR2(60),
8 DefaultMember VARCHAR2(60),
9 DimensionId NUMBER,
10 DimCode VARCHAR2(30),
11 DimType VARCHAR2(30),
12 EpbId VARCHAR2(30),
13 IsCurrencyDim VARCHAR2(3),
14 IsDataDim VARCHAR2(3),
15 IsOwnerDim VARCHAR2(3),
16 PersCWMName VARCHAR2(60),
17 PersTableId NUMBER,
18 SharCWMName VARCHAR2(60),
19 SharTableId NUMBER,
20 AnnotationDim VARCHAR2(30),
21 CreatedBy NUMBER(15),
22 CreationDate DATE,
23 LastUpdatedBy NUMBER(15),
24 LastUpdatedDate DATE,
25 LastUpdatedLogin NUMBER(15)
26 );
27
28 type DIMENSIONS_TL_ENTRY is record
29 (
30 DimensionId NUMBER,
31 Language VARCHAR2(4),
32 LongName VARCHAR2(240),
33 Name VARCHAR2(240),
34 PluralLongName VARCHAR2(240),
35 PluralName VARCHAR2(240),
36 CreatedBy NUMBER(15),
37 CreationDate DATE,
38 LastUpdatedBy NUMBER(15),
39 LastUpdatedDate DATE,
40 LastUpdatedLogin NUMBER(15)
41 );
42
43 type CUBE_DIMS_ENTRY is record
44 (
45 ColumnId NUMBER,
46 CubeId NUMBER,
47 DimensionId NUMBER,
48 RelationId NUMBER,
49 CreatedBy NUMBER(15),
50 CreationDate DATE,
51 LastUpdatedBy NUMBER(15),
52 LastUpdatedDate DATE,
53 LastUpdatedLogin NUMBER(15)
54 );
55
56 type CUBES_ENTRY is record
57 (
58 BusAreaId NUMBER,
59 CubeId NUMBER,
60 EpbId VARCHAR2(30),
61 Name VARCHAR2(60),
62 TableId NUMBER,
63 Type VARCHAR2(30),
64 CreatedBy NUMBER(15),
65 CreationDate DATE,
66 LastUpdatedBy NUMBER(15),
67 LastUpdatedDate DATE,
68 LastUpdatedLogin NUMBER(15)
69 );
70
71 type MEASURES_ENTRY is record
72 (
73 AwName VARCHAR2(30),
74 ColumnId NUMBER,
75 CubeId NUMBER,
76 CurrencyType VARCHAR2(30),
77 CurrInstFlag VARCHAR2(3),
78 CwmName VARCHAR2(60),
79 EpbId VARCHAR2(30),
80 InstanceId NUMBER,
81 MeasureId NUMBER,
82 TemplateId NUMBER,
83 ApproveeId VARCHAR2(240),
84 Type VARCHAR2(64),
85 SelectedCur VARCHAR2(30),
86 Name VARCHAR2(255),
87 CurrencyRel VARCHAR2(30),
88 CPRMeasure VARCHAR2(3),
89 CreatedBy NUMBER(15),
90 CreationDate DATE,
91 LastUpdatedBy NUMBER(15),
92 LastUpdatedDate DATE,
93 LastUpdatedLogin NUMBER(15)
94 );
95
96 type CUBE_HIER_ENTRY is record
97 (
98 ColumnId NUMBER,
99 CubeId NUMBER,
100 HierarchyId NUMBER,
101 RelationId NUMBER,
102 CreatedBy NUMBER(15),
103 CreationDate DATE,
104 LastUpdatedBy NUMBER(15),
105 LastUpdatedDate DATE,
106 LastUpdatedLogin NUMBER(15)
107 );
108
109 type TABLES_ENTRY is record
110 (
111 AwName VARCHAR2(30),
112 BusAreaId NUMBER,
113 TableId NUMBER,
114 TableName VARCHAR2(60),
115 TableType VARCHAR2(30),
116 CreatedBy NUMBER(15),
117 CreationDate DATE,
118 LastUpdatedBy NUMBER(15),
119 LastUpdatedDate DATE,
120 LastUpdatedLogin NUMBER(15)
121 );
122
123 type COLUMNS_ENTRY is record
124 (
125 ColumnId NUMBER,
126 AwName VARCHAR2(30),
127 ColumnName VARCHAR2(60),
128 ColumnType VARCHAR2(30),
129 TableId NUMBER,
130 CreatedBy NUMBER(15),
131 CreationDate DATE,
132 LastUpdatedBy NUMBER(15),
133 LastUpdatedDate DATE,
134 LastUpdatedLogin NUMBER(15)
135 );
136
137 type ATTRIBUTES_ENTRY is record
138 (
139 AttributeId NUMBER,
140 DimensionId NUMBER,
141 EpbId VARCHAR2(30),
142 Label VARCHAR2(240),
143 RangeDimId NUMBER,
144 SharCWMName VARCHAR2(60),
145 Type VARCHAR2(30),
146 PersCWMName VARCHAR2(60),
147 FEMAttrId NUMBER,
148 CreatedBy NUMBER(15),
149 CreationDate DATE,
150 LastUpdatedBy NUMBER(15),
151 LastUpdatedDate DATE,
152 LastUpdatedLogin NUMBER(15)
153 );
154
155 type ATTR_TABLE_COL_ENTRY is record
156 (
157 AttributeId NUMBER,
158 ColumnId NUMBER,
159 RelationId NUMBER,
160 TableId NUMBER,
161 CreatedBy NUMBER(15),
162 CreationDate DATE,
163 LastUpdatedBy NUMBER(15),
164 LastUpdatedDate DATE,
165 LastUpdatedLogin NUMBER(15)
166 );
167
168 type ATTRIBUTES_TL_ENTRY is record
169 (
170 AttributeId NUMBER,
171 Language VARCHAR2(4),
172 LongName VARCHAR2(240),
173 Name VARCHAR2(240),
174 PluralLongName VARCHAR2(240),
175 PluralName VARCHAR2(240),
176 CreatedBy NUMBER(15),
177 CreationDate DATE,
178 LastUpdatedBy NUMBER(15),
179 LastUpdatedDate DATE,
180 LastUpdatedLogin NUMBER(15)
181 );
182
183 type HIERARCHIES_TL_ENTRY is record
184 (
185 HierarchyId NUMBER,
186 Language VARCHAR2(4),
187 LongName VARCHAR2(240),
188 Name VARCHAR2(240),
189 PluralLongName VARCHAR2(240),
190 PluralName VARCHAR2(240),
191 CreatedBy NUMBER(15),
192 CreationDate DATE,
193 LastUpdatedBy NUMBER(15),
194 LastUpdatedDate DATE,
195 LastUpdatedLogin NUMBER(15)
196 );
197
198 type HIERARCHIES_ENTRY is record
199 (
200 DimensionId NUMBER,
201 EpbId VARCHAR2(30),
202 HierarchyId NUMBER,
203 HierType VARCHAR2(30),
204 PersCWMName VARCHAR2(60),
205 PersTableId NUMBER,
206 SharCWMName VARCHAR2(60),
207 SharTableId NUMBER,
208 CreatedBy NUMBER(15),
209 CreationDate DATE,
210 LastUpdatedBy NUMBER(15),
211 LastUpdatedDate DATE,
212 LastUpdatedLogin NUMBER(15)
213 );
214
215 type HIER_LEVEL_ENTRY is record
216 (
217 HierId NUMBER,
218 LevelId NUMBER,
219 LevelOrder NUMBER,
220 PersColId NUMBER,
221 RelationId NUMBER,
222 SharColId NUMBER,
223 CreatedBy NUMBER(15),
224 CreationDate DATE,
225 LastUpdatedBy NUMBER(15),
226 LastUpdatedDate DATE,
227 LastUpdatedLogin NUMBER(15)
228 );
229
230 type LEVELS_ENTRY is record
231 (
232 PersCWMName VARCHAR2(240),
233 DimensionId NUMBER,
234 EpbId VARCHAR2(30),
235 LevelId NUMBER,
236 SharCWMName VARCHAR2(60),
237 PersLevelFlag VARCHAR2(3),
238 CreatedBy NUMBER(15),
239 CreationDate DATE,
240 LastUpdatedBy NUMBER(15),
241 LastUpdatedDate DATE,
242 LastUpdatedLogin NUMBER(15)
243 );
244
245 type LEVELS_TL_ENTRY is record
246 (
247 Language VARCHAR2(4),
248 LevelId NUMBER,
249 LongName VARCHAR2(240),
250 Name VARCHAR2(240),
251 PluralLongName VARCHAR2(240),
252 PluralName VARCHAR2(240),
253 CreatedBy NUMBER(15),
254 CreationDate DATE,
255 LastUpdatedBy NUMBER(15),
256 LastUpdatedDate DATE,
257 LastUpdatedLogin NUMBER(15)
258 );
259
260 type MEAS_SCOPE_ENTRY is record
261 (
262 EndDate DATE,
263 MeasureId NUMBER,
264 ScopeId NUMBER,
265 StartDate DATE,
266 UserId NUMBER,
267 CreatedBy NUMBER(15),
268 CreationDate DATE,
269 LastUpdatedBy NUMBER(15),
270 LastUpdatedDate DATE,
271 LastUpdatedLogin NUMBER(15)
272 );
273
274 type HIER_SCOPE_ENTRY is record
275 (
276 EndDate DATE,
277 HierarchyId NUMBER,
278 ScopeId NUMBER,
279 StartDate DATE,
280 UserId NUMBER,
281 PersTableId NUMBER,
282 CreatedBy NUMBER(15),
283 CreationDate DATE,
284 LastUpdatedBy NUMBER(15),
285 LastUpdatedDate DATE,
286 LastUpdatedLogin NUMBER(15)
287 );
288
289 type HIER_LEVEL_SCOPE_ENTRY is record
290 (
291 HierId NUMBER,
292 LevelId NUMBER,
293 ScopeId NUMBER,
294 UserId NUMBER,
295 PersColId NUMBER,
296 CreatedBy NUMBER(15),
297 CreationDate DATE,
298 LastUpdatedBy NUMBER(15),
299 LastUpdatedDate DATE,
300 LastUpdatedLogin NUMBER(15)
301 );
302
303 type ATTRIBUTE_SCOPE_ENTRY is record
304 (
305 AttributeId NUMBER,
306 EndDate DATE,
307 ScopeId NUMBER,
308 StartDate DATE,
309 UserId NUMBER,
310 CreatedBy NUMBER(15),
311 CreationDate DATE,
312 LastUpdatedBy NUMBER(15),
313 LastUpdatedDate DATE,
314 LastUpdatedLogin NUMBER(15)
315 );
316
317
318 end ZPB_MD_RECORDS;
319