eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.ZPB_ECM

Source


1 PACKAGE ZPB_ECM AS
2 /* $Header: zpbecm.pls 120.5 2007/12/04 15:27:01 mbhat ship $ */
3 
4 type AGGR_ECM is record
5    (AggLtRel         varchar2(30),
6     AggLtBaseVar     varchar2(30),
7     AggLtdRel        varchar2(30),
8     AggLtdBaseVar    varchar2(30),
9     LdscVar          varchar2(30));
10 
11 type ALLOC_ECM is record
12    (AlcLtRel         varchar2(30),
13     AlcLtBaseVar     varchar2(30),
14     AlcLtdRel        varchar2(30),
15     AlcLtdBaseVar    varchar2(30));
16 
17 type ANNOT_ECM is record
18    (CellsObjDim      varchar2(30),
19     CellsShapeRel    varchar2(30),
20     CountFrm         varchar2(30),
21     DataVar          varchar2(30),
22     DateVar          varchar2(30),
23     LastDataFrm      varchar2(30),
24     LastDateFrm      varchar2(30),
25     LastRdscFrm      varchar2(30),
26     LastUserFrm      varchar2(30),
27     LookupObjDim     varchar2(30),
28     LookupShapeRel   varchar2(30),
29     ReasonCodeDim    varchar2(30),
30     ReasonCodeLdsc   varchar2(30),
31     ReasonRel        varchar2(30),
32     UserRel          varchar2(30));
33 
34 type ATTR_ECM is record
35    (AttrRelation     varchar2(30),
36     DefOrderVSet     varchar2(30),
37     LdscVar          varchar2(30),
38     LdscFrm          varchar2(30),
39     RangeDimension   varchar2(30));
40 
41 type DIMENSION_DATA is record
42    (Ldsc             varchar2(255),
43     PlLdsc           varchar2(255),
44     PlSdsc           varchar2(150),
45     Sdsc             varchar2(150),
46     Type             varchar2(30),
47     ExpObj           varchar2(30),
48     IsDataDim        varchar2(30),
49     IsOwnerDim       varchar2(30));
50 
51 type DIMENSION_ECM is record
52    (AncestorRel      varchar2(30),
53     AnnDim           varchar2(30),
54     DefaultMember    varchar2(40),
55     DefOrderVS       varchar2(30),
56     DepthFrm         varchar2(30),
57     DepthFrm1        varchar2(30),
58     DfltLevelRel     varchar2(30),
59     DimDrillDir      varchar2(30),
60     DrillInfoFrm     varchar2(30),
61     FmtCatVar        varchar2(30),
62     FmtFlagCatVar    varchar2(30),
63     FmtStringVar     varchar2(30),
64     FullOrderVar     varchar2(30),
65     GID              varchar2(30),
66     HierDefault      varchar2(30),
67     HierDim          varchar2(30),
68     HierDimScpFrm    varchar2(30),
69     HierFEMDefIDVar  varchar2(30),
70     HierFEMIDVar     varchar2(30),
71     HierLdscVar      varchar2(30),
72     HierVersLdscVar  varchar2(30),
73     HierLevelVS      varchar2(30),
74     HierLimitMapVar  varchar2(30),
75     HierHeight       varchar2(30),
76     HierTypeRel      varchar2(30),
77     HOrderVs         varchar2(30),
78     InHierVar        varchar2(30),
79     LastQueryVS      varchar2(30),
80     LdscVar          varchar2(30),
81     LevelDepthVar    varchar2(30),
82     LevelDim         varchar2(30),
83     LevelDimScpFrm   varchar2(30),
84     LevelLdscVar     varchar2(30),
85     LevelMdscVar     varchar2(30),
86     LevelSdscVar     varchar2(30),
87     LevelPersVar     varchar2(30),
88     LevelPlLdscVar   varchar2(30),
89     LevelRel         varchar2(30),
90     LimitMapVar      varchar2(30),
91     MdscVar          varchar2(30),
92     MemberTypeRel    varchar2(30),
93     MLevelLdscFrm    varchar2(30),
94     MPLLevelLdscFrm  varchar2(30),
95     NameFragment     varchar2(30),
96     ParentRel        varchar2(30),
97     RootValSet       varchar2(30),
98     SdscVar          varchar2(30),
99     SecOwnAccVar     varchar2(30),
100     SecOwnDscVar     varchar2(30),
101     SecReadAccFrm    varchar2(30),
102     SecReadAccVar    varchar2(30),
103     SecWrtAccVar     varchar2(30),
104     SibOrderVar      varchar2(30),
105     TempVS           varchar2(30));
106 
107 type DIMENSION_LINE_ECM is record
108    (AggBaseFrm       varchar2(30),
109     AggDefFrm        varchar2(30),
110     AggLdBaseVar     varchar2(30),
111     AggLdRel         varchar2(30),
112     AggLineBaseVar   varchar2(30),
113     AggLineRel       varchar2(30),
114     AggOrderVar      varchar2(30),
115     AlcBaseFrm       varchar2(30),
116     AlcDefBaseVar    varchar2(30),
117     AlcDefFrm        varchar2(30),
118     AlcLdRel         varchar2(30),
119     AlcLineBaseVar   varchar2(30),
120     AlcLineRel       varchar2(30),
121     BetterWorseVar   varchar2(30),
122     CumDataVar       varchar2(30),
123     LineDimVar       varchar2(30),
124     LineTypeRel      varchar2(30),
125     NatSignVar       varchar2(30));
126 
127 type DIMENSION_TIME_ECM is record
128    (CalendarVar      varchar2(30),
129     EndDateVar       varchar2(30),
130     LatestRel        varchar2(30),
131     LatestProcRel    varchar2(30),
132     OffsetVar        varchar2(30),
133     PriorFrm         varchar2(30),
134     RangeRel         varchar2(30),
135     RangeLvlRel      varchar2(30),
136     ROffsetVar       varchar2(30),
137     TimeSpanVar      varchar2(30),
138     TLvlTypeRel      varchar2(30),
139     YardStickDim     varchar2(30),
140     YrAgoFrm         varchar2(30));
141 
142 type GLOBAL_ATTR_ECM is record
143    (AttrDisplayVar   varchar2(30),
144     DomainDimRel     varchar2(30),
145     ExpObjVar        varchar2(30),
146     ExpTypeDim       varchar2(30),
147     ExpTypeRel       varchar2(30),
148     LdscVar          varchar2(30),
149     NameFragVar      varchar2(30),
150     RangeDimRel      varchar2(30),
151     TypeDim          varchar2(30),
152     TypeRel          varchar2(30));
153 
154 type GLOBAL_ECM is record
155    (ECMLocator       varchar2(60),
156     AggTypeDim       varchar2(30),
157     AlcCondDim       varchar2(30),
158     AlcTypeDim       varchar2(30),
159     AnnEntryDim      varchar2(30),
160     AnnPropDim       varchar2(30),
161     AttrDim          varchar2(30),
162     AttrDimScpFrm    varchar2(32),
163     DataTypeDim      varchar2(30),
164     DimDim           varchar2(30),
165     DimTypeRel       varchar2(30),
166     ExpObjVar        varchar2(30),
167     FmtBoolPropDim   varchar2(30),
168     FmtTextPropDim   varchar2(30),
169     IsCurrInstVar    varchar2(30),
170     IsDataDimFrm     varchar2(30),
171     IsDataDimVar     varchar2(30),
172     IsMeasDimFrm     varchar2(30),
173     IsOwnerDim       varchar2(30),
174     LangDim          varchar2(30),
175     LastQueryDimsVS  varchar2(30),
176     LdscVar          varchar2(30),
177     LineTypeDim      varchar2(30),
178     MeasColVar       varchar2(30),
179     MeasDimVar       varchar2(30),
180     MeasExpObjVar    varchar2(30),
181     MeasShapeRel     varchar2(30),
182     MeasTypeRel      varchar2(30),
183     MeasViewDim      varchar2(30),
184     MeasViewRel      varchar2(30),
185     NumAttrFrm       varchar2(30),
186     NumHierFrm       varchar2(30),
187     NumLevelFrm      varchar2(30),
188     PlLdscVar        varchar2(30),
189     PlSdscVar        varchar2(30),
190     SdscVar          varchar2(30),
191     SecEntityDim     varchar2(30),
192     SecOwnerDim      varchar2(30),
193     SecOwnerMapRel   varchar2(30),
194     SecScopeFrm      varchar2(30),
195     SecUserDim       varchar2(30),
196     SecWrtAccFrm     varchar2(30),
197     SecWrtMapVar     varchar2(30),
198     ShapeDimVS       varchar2(30),
199     ShapeEntryDim    varchar2(30),
200     TLvlTypeDim      varchar2(30));
201 
202 type LINE_TYPE_ECM is record
203    (LdscVar          varchar2(30),
204     LineTypeCDataVar varchar2(30),
205     LTypeBWVar       varchar2(30),
206     LTypeNatSignVar  varchar2(30));
207 
208 type SECURITY_ECM is record
209    (SecRInUseFrm     varchar2(30),
210     SecRInUseVar     varchar2(30));
211 
212 function GET_AGGREGATION_ECM (p_aw         in varchar2)
213    return AGGR_ECM;
214 
215 function GET_ALLOCATION_ECM (p_aw         in varchar2)
216    return ALLOC_ECM;
217 
218 function GET_ANNOTATION_ECM (p_aw         in varchar2)
219    return ANNOT_ECM;
220 
221 function GET_ATTR_ECM (p_attr            in varchar2,
222                        p_global_attr_ecm in global_attr_ecm,
223                        p_aw              in varchar2)
224    return ATTR_ECM;
225 
226 function GET_DIMENSION_DATA (p_dim        in varchar2,
227                              p_aw         in varchar2)
228    return DIMENSION_DATA;
229 
230 function GET_DIMENSION_ECM (p_dim        in varchar2,
231                             p_aw         in varchar2)
232    return DIMENSION_ECM;
233 
234 function GET_DIMENSION_LINE_ECM (p_dim        in varchar2,
235                                  p_aw         in varchar2)
236    return DIMENSION_LINE_ECM;
237 
238 function GET_DIMENSION_TIME_ECM (p_dim        in varchar2,
239                                  p_aw         in varchar2)
240    return DIMENSION_TIME_ECM;
241 
242 function GET_GLOBAL_ATTR_ECM (p_aw         in varchar2)
243    return GLOBAL_ATTR_ECM;
244 
245 function GET_GLOBAL_ECM (p_aw in varchar2)
246    return GLOBAL_ECM;
247 
248 function GET_LINE_TYPE_ECM (p_aw         in varchar2)
249    return LINE_TYPE_ECM;
250 
251 function GET_SECURITY_ECM (p_aw         in varchar2)
252    return SECURITY_ECM;
253 
254 procedure TEST;
255 
256 end ZPB_ECM;