APPS.ZPB_AW_STATUS dependencies on ZPB_ECM

Line 77: l_global_ecm zpb_ecm.global_ecm;

73: l_pers VARCHAR2(30);
74: l_value VARCHAR2(30);
75: l_value2 VARCHAR2(30);
76: l_members VARCHAR2(4000);
77: l_global_ecm zpb_ecm.global_ecm;
78: l_dim_ecm zpb_ecm.dimension_ecm;
79:
80:
81: TYPE QueryCursType IS REF CURSOR;

Line 78: l_dim_ecm zpb_ecm.dimension_ecm;

74: l_value VARCHAR2(30);
75: l_value2 VARCHAR2(30);
76: l_members VARCHAR2(4000);
77: l_global_ecm zpb_ecm.global_ecm;
78: l_dim_ecm zpb_ecm.dimension_ecm;
79:
80:
81: TYPE QueryCursType IS REF CURSOR;
82: queryCurs QueryCursType;

Line 119: l_global_ecm := zpb_ecm.get_global_ecm (l_aw);

115: end if;
116: end if;
117:
118: l_awQual := l_aw||'!';
119: l_global_ecm := zpb_ecm.get_global_ecm (l_aw);
120: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.LastQueryDimsVS||
121: ' remove all');
122: l_dimension := '';
123: l_sql_statement := ' ';

Line 129: l_dim_ecm := zpb_ecm.get_dimension_ecm(l_ecmDim, l_aw);

125: if (l_dimension <> each.dimension_name and l_dimension <> '') then
126: l_ecmDim := zpb_aw.eval_text('lmt('||l_awQual||l_global_ecm.DimDim||
127: ' to '||l_awQual||l_global_ecm.ExpObjVar||
128: ' eq '''||l_dimension||''')');
129: l_dim_ecm := zpb_ecm.get_dimension_ecm(l_ecmDim, l_aw);
130: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.LastQueryDimsVS||
131: ' add '''||l_ecmDim||'''');
132:
133: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LastQueryVS||

Line 157: l_dim_ecm := zpb_ecm.get_dimension_ecm(l_ecmDim, l_aw);

153: if (l_dimension <> '') then
154: l_ecmDim := zpb_aw.eval_text('lmt('||l_awQual||l_global_ecm.DimDim||
155: ' to '||l_awQual||l_global_ecm.ExpObjVar||
156: ' eq '''||l_dimension||''')');
157: l_dim_ecm := zpb_ecm.get_dimension_ecm(l_ecmDim, l_aw);
158: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.LastQueryDimsVS||
159: ' add '''||l_ecmDim||'''');
160:
161: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LastQueryVS||' remove all');

Line 276: l_global_ecm zpb_ecm.global_ecm;

272: l_newCol VARCHAR2(30);
273: l_value VARCHAR2(30);
274: l_value2 VARCHAR2(30);
275: l_members VARCHAR2(4000);
276: l_global_ecm zpb_ecm.global_ecm;
277: l_dim_ecm zpb_ecm.dimension_ecm;
278:
279: TYPE QueryCursType IS REF CURSOR;
280: queryCurs QueryCursType;

Line 277: l_dim_ecm zpb_ecm.dimension_ecm;

273: l_value VARCHAR2(30);
274: l_value2 VARCHAR2(30);
275: l_members VARCHAR2(4000);
276: l_global_ecm zpb_ecm.global_ecm;
277: l_dim_ecm zpb_ecm.dimension_ecm;
278:
279: TYPE QueryCursType IS REF CURSOR;
280: queryCurs QueryCursType;
281:

Line 292: l_global_ecm := zpb_ecm.get_global_ecm (l_aw);

288: l_aw := zpb_aw.get_personal_aw(p_user_id);
289: l_schema := zpb_aw.get_schema||'.';
290: l_sharedAw := l_schema||zpb_aw.get_shared_aw;
291: l_awQual := l_schema||l_aw||'!';
292: l_global_ecm := zpb_ecm.get_global_ecm (l_aw);
293:
294: l_meas := zpb_aw.eval_text('CM.GETINSTOBJECT ('''||p_instance||
295: ''' ''SHARED DATA OBJECT ID''');
296: l_newCol := zpb_aw.eval_text('SHARED!'||l_global_ecm.MeasColVar||

Line 312: l_dim_ecm := zpb_ecm.get_dimension_ecm(l_ecmDim, l_aw);

308:
309: l_ecmDim := zpb_aw.eval_text('lmt('||l_awQual||l_global_ecm.DimDim||
310: ' to '||l_awQual||l_global_ecm.ExpObjVar||
311: ' eq '''||l_dimension||''')');
312: l_dim_ecm := zpb_ecm.get_dimension_ecm(l_ecmDim, l_aw);
313:
314: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.LastQueryDimsVS||
315: ' add '''||l_ecmDim||'''');
316: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LastQueryVS||

Line 339: l_dim_ecm := zpb_ecm.get_dimension_ecm(l_ecmDim, l_aw);

335: if (l_dimension <> '') then
336: l_ecmDim := zpb_aw.eval_text ('lmt('||l_awQual||l_global_ecm.DimDim||
337: ' to '||l_awQual||l_global_ecm.ExpObjVar||
338: ' eq '''||l_dimension||''')');
339: l_dim_ecm := zpb_ecm.get_dimension_ecm(l_ecmDim, l_aw);
340: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.LastQueryDimsVS||
341: ' add '''||l_ecmDim||'''');
342: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LastQueryVS||' remove all');
343:

Line 363: l_global_ecm zpb_ecm.global_ecm;

359: is
360: l_ecmDim VARCHAR2(30);
361: l_aw VARCHAR2(30);
362: l_awQual VARCHAR2(30);
363: l_global_ecm zpb_ecm.global_ecm;
364:
365: cursor dimensions is
366: select distinct DIMENSION_NAME
367: from ZPB_STATUS_SQL

Line 379: l_global_ecm := zpb_ecm.get_global_ecm (l_aw);

375: l_aw := p_aw;
376: end if;
377:
378: l_awQual := l_aw||'!';
379: l_global_ecm := zpb_ecm.get_global_ecm (l_aw);
380: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.LastQueryDimsVS||
381: ' remove all');
382:
383: for each in dimensions loop