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.

APPS.ZPB_AW_STATUS dependencies on ZPB_AW

Line 1: PACKAGE BODY ZPB_AW_STATUS AS

1: PACKAGE BODY ZPB_AW_STATUS AS
2: /* $Header: zpb_aw_status.plb 120.6 2007/12/04 14:40:40 mbhat ship $ */
3: G_PERSONAL_ALIAS_FLAG VARCHAR2(1) := 'N';
4:
5: ------------------------------------------------------------------------------

Line 2: /* $Header: zpb_aw_status.plb 120.6 2007/12/04 14:40:40 mbhat ship $ */

1: PACKAGE BODY ZPB_AW_STATUS AS
2: /* $Header: zpb_aw_status.plb 120.6 2007/12/04 14:40:40 mbhat ship $ */
3: G_PERSONAL_ALIAS_FLAG VARCHAR2(1) := 'N';
4:
5: ------------------------------------------------------------------------------
6: -- RUN_QUERY (private)

Line 45: zpb_aw.execute ('lmt '||p_dimVset||' add '||l_members);

41: exit when (DBMS_SQL.FETCH_ROWS(l_cursor) = 0);
42: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_member);
43: l_members := l_members||' '''||l_member||'''';
44: if (length(l_members) > 3900) then
45: zpb_aw.execute ('lmt '||p_dimVset||' add '||l_members);
46: l_members := null;
47: end if;
48: end loop;
49: if (l_members is not null) then

Line 50: zpb_aw.execute ('lmt '||p_dimVset||' add '||l_members);

46: l_members := null;
47: end if;
48: end loop;
49: if (l_members is not null) then
50: zpb_aw.execute ('lmt '||p_dimVset||' add '||l_members);
51: end if;
52: DBMS_SQL.CLOSE_CURSOR(l_cursor);
53: END RUN_QUERY;
54:

Line 90: if (instr (upper(p_aw), upper(zpb_aw.get_schema)||'.') = 0 and

86: FROM zpb_status_sql
87: WHERE (query_path = p_query)
88: ORDER BY DIMENSION_NAME, ROW_NUM;
89: BEGIN
90: if (instr (upper(p_aw), upper(zpb_aw.get_schema)||'.') = 0 and
91: instr (upper(p_aw), 'ZPB') > 0) then
92: l_aw := zpb_aw.get_schema||'.'||p_aw;
93: else
94: l_aw := p_aw;

Line 92: l_aw := zpb_aw.get_schema||'.'||p_aw;

88: ORDER BY DIMENSION_NAME, ROW_NUM;
89: BEGIN
90: if (instr (upper(p_aw), upper(zpb_aw.get_schema)||'.') = 0 and
91: instr (upper(p_aw), 'ZPB') > 0) then
92: l_aw := zpb_aw.get_schema||'.'||p_aw;
93: else
94: l_aw := p_aw;
95: end if;
96:

Line 101: if (zpb_aw.interpbool('shw aw(attached ''PERSONAL'')')

97: --
98: -- Store the personal AW and reset it if the AW is different
99: --
100: l_pers := null;
101: if (zpb_aw.interpbool('shw aw(attached ''PERSONAL'')')
102: and instr(l_aw, '.')>0 and instr(l_aw, 'DATA')=0) then
103: l_value := zpb_aw.eval_text('aw(name ''PERSONAL'')');
104: if (l_value <> upper(l_aw)) then
105: l_pers := l_value;

Line 103: l_value := zpb_aw.eval_text('aw(name ''PERSONAL'')');

99: --
100: l_pers := null;
101: if (zpb_aw.interpbool('shw aw(attached ''PERSONAL'')')
102: and instr(l_aw, '.')>0 and instr(l_aw, 'DATA')=0) then
103: l_value := zpb_aw.eval_text('aw(name ''PERSONAL'')');
104: if (l_value <> upper(l_aw)) then
105: l_pers := l_value;
106: if (zpb_aw.interpbool('shw aw(attached ''' || l_pers || ''')')) then
107: zpb_aw.execute ('aw aliaslist '||l_pers||' unalias PERSONAL');

Line 106: if (zpb_aw.interpbool('shw aw(attached ''' || l_pers || ''')')) then

102: and instr(l_aw, '.')>0 and instr(l_aw, 'DATA')=0) then
103: l_value := zpb_aw.eval_text('aw(name ''PERSONAL'')');
104: if (l_value <> upper(l_aw)) then
105: l_pers := l_value;
106: if (zpb_aw.interpbool('shw aw(attached ''' || l_pers || ''')')) then
107: zpb_aw.execute ('aw aliaslist '||l_pers||' unalias PERSONAL');
108: end if;
109: if (zpb_aw.interpbool('shw aw(attached ''' || l_aw || ''')')) then
110: zpb_aw.execute ('aw aliaslist '||l_aw||' alias PERSONAL');

Line 107: zpb_aw.execute ('aw aliaslist '||l_pers||' unalias PERSONAL');

103: l_value := zpb_aw.eval_text('aw(name ''PERSONAL'')');
104: if (l_value <> upper(l_aw)) then
105: l_pers := l_value;
106: if (zpb_aw.interpbool('shw aw(attached ''' || l_pers || ''')')) then
107: zpb_aw.execute ('aw aliaslist '||l_pers||' unalias PERSONAL');
108: end if;
109: if (zpb_aw.interpbool('shw aw(attached ''' || l_aw || ''')')) then
110: zpb_aw.execute ('aw aliaslist '||l_aw||' alias PERSONAL');
111: end if;

Line 109: if (zpb_aw.interpbool('shw aw(attached ''' || l_aw || ''')')) then

105: l_pers := l_value;
106: if (zpb_aw.interpbool('shw aw(attached ''' || l_pers || ''')')) then
107: zpb_aw.execute ('aw aliaslist '||l_pers||' unalias PERSONAL');
108: end if;
109: if (zpb_aw.interpbool('shw aw(attached ''' || l_aw || ''')')) then
110: zpb_aw.execute ('aw aliaslist '||l_aw||' alias PERSONAL');
111: end if;
112: zpb_aw_status.set_personal_alias_flag();
113: -- setting this flag so as aw.initialize is not called in get_limitmap

Line 110: zpb_aw.execute ('aw aliaslist '||l_aw||' alias PERSONAL');

106: if (zpb_aw.interpbool('shw aw(attached ''' || l_pers || ''')')) then
107: zpb_aw.execute ('aw aliaslist '||l_pers||' unalias PERSONAL');
108: end if;
109: if (zpb_aw.interpbool('shw aw(attached ''' || l_aw || ''')')) then
110: zpb_aw.execute ('aw aliaslist '||l_aw||' alias PERSONAL');
111: end if;
112: zpb_aw_status.set_personal_alias_flag();
113: -- setting this flag so as aw.initialize is not called in get_limitmap
114:

Line 112: zpb_aw_status.set_personal_alias_flag();

108: end if;
109: if (zpb_aw.interpbool('shw aw(attached ''' || l_aw || ''')')) then
110: zpb_aw.execute ('aw aliaslist '||l_aw||' alias PERSONAL');
111: end if;
112: zpb_aw_status.set_personal_alias_flag();
113: -- setting this flag so as aw.initialize is not called in get_limitmap
114:
115: end if;
116: end if;

Line 120: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.LastQueryDimsVS||

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 := ' ';
124: for each in queries loop

Line 126: l_ecmDim := zpb_aw.eval_text('lmt('||l_awQual||l_global_ecm.DimDim||

122: l_dimension := '';
123: l_sql_statement := ' ';
124: for each in queries loop
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||

Line 130: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.LastQueryDimsVS||

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||
134: ' remove all');

Line 133: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LastQueryVS||

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||
134: ' remove all');
135:
136: RUN_QUERY(l_sql_statement, l_awQual||l_dim_ecm.LastQueryVS);
137:

Line 151: --zpb_aw.execute ('CALL MD.VIEW.CMD.SET ('''||l_dimension||

147:
148: --
149: -- Run last query:
150: --
151: --zpb_aw.execute ('CALL MD.VIEW.CMD.SET ('''||l_dimension||
152: -- ''' '''||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||

Line 154: l_ecmDim := zpb_aw.eval_text('lmt('||l_awQual||l_global_ecm.DimDim||

150: --
151: --zpb_aw.execute ('CALL MD.VIEW.CMD.SET ('''||l_dimension||
152: -- ''' '''||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||

Line 158: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.LastQueryDimsVS||

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');
162:

Line 161: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LastQueryVS||' remove all');

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');
162:
163: RUN_QUERY(l_sql_statement, l_awQual||l_dim_ecm.LastQueryVS);
164: else
165: ZPB_LOG.WRITE_EVENT ('zpb_aw_status.get_status',

Line 165: ZPB_LOG.WRITE_EVENT ('zpb_aw_status.get_status',

161: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LastQueryVS||' remove all');
162:
163: RUN_QUERY(l_sql_statement, l_awQual||l_dim_ecm.LastQueryVS);
164: else
165: ZPB_LOG.WRITE_EVENT ('zpb_aw_status.get_status',
166: 'Could not find query: '||p_query);
167: end if;
168: --zpb_aw.execute ('CALL MD.VIEW.CMD.CLEANUP');
169: if (l_pers is not null) then

Line 168: --zpb_aw.execute ('CALL MD.VIEW.CMD.CLEANUP');

164: else
165: ZPB_LOG.WRITE_EVENT ('zpb_aw_status.get_status',
166: 'Could not find query: '||p_query);
167: end if;
168: --zpb_aw.execute ('CALL MD.VIEW.CMD.CLEANUP');
169: if (l_pers is not null) then
170: if (zpb_aw.interpbool('shw aw(attached ''' || l_aw || ''')')) then
171: zpb_aw.execute ('aw aliaslist '||l_aw||' unalias PERSONAL');
172: end if;

Line 170: if (zpb_aw.interpbool('shw aw(attached ''' || l_aw || ''')')) then

166: 'Could not find query: '||p_query);
167: end if;
168: --zpb_aw.execute ('CALL MD.VIEW.CMD.CLEANUP');
169: if (l_pers is not null) then
170: if (zpb_aw.interpbool('shw aw(attached ''' || l_aw || ''')')) then
171: zpb_aw.execute ('aw aliaslist '||l_aw||' unalias PERSONAL');
172: end if;
173: if (zpb_aw.interpbool('shw aw(attached ''' || l_pers || ''')')) then
174: zpb_aw.execute ('aw aliaslist '||l_pers||' alias PERSONAL');

Line 171: zpb_aw.execute ('aw aliaslist '||l_aw||' unalias PERSONAL');

167: end if;
168: --zpb_aw.execute ('CALL MD.VIEW.CMD.CLEANUP');
169: if (l_pers is not null) then
170: if (zpb_aw.interpbool('shw aw(attached ''' || l_aw || ''')')) then
171: zpb_aw.execute ('aw aliaslist '||l_aw||' unalias PERSONAL');
172: end if;
173: if (zpb_aw.interpbool('shw aw(attached ''' || l_pers || ''')')) then
174: zpb_aw.execute ('aw aliaslist '||l_pers||' alias PERSONAL');
175: end if;

Line 173: if (zpb_aw.interpbool('shw aw(attached ''' || l_pers || ''')')) then

169: if (l_pers is not null) then
170: if (zpb_aw.interpbool('shw aw(attached ''' || l_aw || ''')')) then
171: zpb_aw.execute ('aw aliaslist '||l_aw||' unalias PERSONAL');
172: end if;
173: if (zpb_aw.interpbool('shw aw(attached ''' || l_pers || ''')')) then
174: zpb_aw.execute ('aw aliaslist '||l_pers||' alias PERSONAL');
175: end if;
176: zpb_aw_status.RESET_PERSONAL_ALIAS_FLAG();
177:

Line 174: zpb_aw.execute ('aw aliaslist '||l_pers||' alias PERSONAL');

170: if (zpb_aw.interpbool('shw aw(attached ''' || l_aw || ''')')) then
171: zpb_aw.execute ('aw aliaslist '||l_aw||' unalias PERSONAL');
172: end if;
173: if (zpb_aw.interpbool('shw aw(attached ''' || l_pers || ''')')) then
174: zpb_aw.execute ('aw aliaslist '||l_pers||' alias PERSONAL');
175: end if;
176: zpb_aw_status.RESET_PERSONAL_ALIAS_FLAG();
177:
178: end if;

Line 176: zpb_aw_status.RESET_PERSONAL_ALIAS_FLAG();

172: end if;
173: if (zpb_aw.interpbool('shw aw(attached ''' || l_pers || ''')')) then
174: zpb_aw.execute ('aw aliaslist '||l_pers||' alias PERSONAL');
175: end if;
176: zpb_aw_status.RESET_PERSONAL_ALIAS_FLAG();
177:
178: end if;
179:
180: exception

Line 186: if (zpb_aw.interpbool('shw aw(attached ''' || l_aw || ''')')) then

182: -- Must cleanup and reset PERSONAL alias in case of crash
183: --
184: when others then
185: if (l_pers is not null) then
186: if (zpb_aw.interpbool('shw aw(attached ''' || l_aw || ''')')) then
187: zpb_aw.execute ('aw aliaslist '||l_aw||' unalias PERSONAL');
188: end if;
189: if (zpb_aw.interpbool('shw aw(attached ''' || l_pers || ''')')) then
190: zpb_aw.execute ('aw aliaslist '||l_pers||' alias PERSONAL');

Line 187: zpb_aw.execute ('aw aliaslist '||l_aw||' unalias PERSONAL');

183: --
184: when others then
185: if (l_pers is not null) then
186: if (zpb_aw.interpbool('shw aw(attached ''' || l_aw || ''')')) then
187: zpb_aw.execute ('aw aliaslist '||l_aw||' unalias PERSONAL');
188: end if;
189: if (zpb_aw.interpbool('shw aw(attached ''' || l_pers || ''')')) then
190: zpb_aw.execute ('aw aliaslist '||l_pers||' alias PERSONAL');
191: end if;

Line 189: if (zpb_aw.interpbool('shw aw(attached ''' || l_pers || ''')')) then

185: if (l_pers is not null) then
186: if (zpb_aw.interpbool('shw aw(attached ''' || l_aw || ''')')) then
187: zpb_aw.execute ('aw aliaslist '||l_aw||' unalias PERSONAL');
188: end if;
189: if (zpb_aw.interpbool('shw aw(attached ''' || l_pers || ''')')) then
190: zpb_aw.execute ('aw aliaslist '||l_pers||' alias PERSONAL');
191: end if;
192: zpb_aw_status.RESET_PERSONAL_ALIAS_FLAG();
193: end if;

Line 190: zpb_aw.execute ('aw aliaslist '||l_pers||' alias PERSONAL');

186: if (zpb_aw.interpbool('shw aw(attached ''' || l_aw || ''')')) then
187: zpb_aw.execute ('aw aliaslist '||l_aw||' unalias PERSONAL');
188: end if;
189: if (zpb_aw.interpbool('shw aw(attached ''' || l_pers || ''')')) then
190: zpb_aw.execute ('aw aliaslist '||l_pers||' alias PERSONAL');
191: end if;
192: zpb_aw_status.RESET_PERSONAL_ALIAS_FLAG();
193: end if;
194:

Line 192: zpb_aw_status.RESET_PERSONAL_ALIAS_FLAG();

188: end if;
189: if (zpb_aw.interpbool('shw aw(attached ''' || l_pers || ''')')) then
190: zpb_aw.execute ('aw aliaslist '||l_pers||' alias PERSONAL');
191: end if;
192: zpb_aw_status.RESET_PERSONAL_ALIAS_FLAG();
193: end if;
194:
195: ZPB_LOG.LOG_PLSQL_EXCEPTION('zpb_aw_status', 'get_status');
196: RAISE;

Line 195: ZPB_LOG.LOG_PLSQL_EXCEPTION('zpb_aw_status', 'get_status');

191: end if;
192: zpb_aw_status.RESET_PERSONAL_ALIAS_FLAG();
193: end if;
194:
195: ZPB_LOG.LOG_PLSQL_EXCEPTION('zpb_aw_status', 'get_status');
196: RAISE;
197:
198: END GET_STATUS;
199:

Line 288: l_aw := zpb_aw.get_personal_aw(p_user_id);

284: FROM zpb_status_sql
285: WHERE (query_path = p_query)
286: ORDER BY DIMENSION_NAME, ROW_NUM;
287: BEGIN
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);

Line 289: l_schema := zpb_aw.get_schema||'.';

285: WHERE (query_path = p_query)
286: ORDER BY DIMENSION_NAME, ROW_NUM;
287: BEGIN
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:

Line 290: l_sharedAw := l_schema||zpb_aw.get_shared_aw;

286: ORDER BY DIMENSION_NAME, ROW_NUM;
287: BEGIN
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||

Line 294: l_meas := zpb_aw.eval_text('CM.GETINSTOBJECT ('''||p_instance||

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||
297: ' (SHARED!MEASURE '''||l_meas||''')');
298: l_newView := zpb_aw.eval_text('SHARED!'||l_global_ecm.MeasViewRel||

Line 296: l_newCol := zpb_aw.eval_text('SHARED!'||l_global_ecm.MeasColVar||

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||
297: ' (SHARED!MEASURE '''||l_meas||''')');
298: l_newView := zpb_aw.eval_text('SHARED!'||l_global_ecm.MeasViewRel||
299: ' (SHARED!MEASURE '''||l_meas||''')');
300:

Line 298: l_newView := zpb_aw.eval_text('SHARED!'||l_global_ecm.MeasViewRel||

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||
297: ' (SHARED!MEASURE '''||l_meas||''')');
298: l_newView := zpb_aw.eval_text('SHARED!'||l_global_ecm.MeasViewRel||
299: ' (SHARED!MEASURE '''||l_meas||''')');
300:
301: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.LastQueryDimsVS||
302: ' remove all');

Line 301: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.LastQueryDimsVS||

297: ' (SHARED!MEASURE '''||l_meas||''')');
298: l_newView := zpb_aw.eval_text('SHARED!'||l_global_ecm.MeasViewRel||
299: ' (SHARED!MEASURE '''||l_meas||''')');
300:
301: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.LastQueryDimsVS||
302: ' remove all');
303:
304: l_dimension := '';
305: l_sql_statement := ' ';

Line 309: l_ecmDim := zpb_aw.eval_text('lmt('||l_awQual||l_global_ecm.DimDim||

305: l_sql_statement := ' ';
306: for each in queries loop
307: if (l_dimension <> each.dimension_name and l_dimension <> '') then
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:

Line 314: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.LastQueryDimsVS||

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||
317: ' remove all');
318:

Line 316: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LastQueryVS||

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||
317: ' remove all');
318:
319: REPLACE_EXCEPTION_OBJS(l_sql_statement,l_sharedAW,l_newView,l_newCol);
320: RUN_QUERY(l_sql_statement, l_awQual||l_dim_ecm.LastQueryVS);

Line 336: l_ecmDim := zpb_aw.eval_text ('lmt('||l_awQual||l_global_ecm.DimDim||

332: --
333: -- Run last query:
334: --
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||

Line 340: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.LastQueryDimsVS||

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:
344: REPLACE_EXCEPTION_OBJS(l_sql_statement, l_sharedAW, l_newView, l_newCol);

Line 342: zpb_aw.execute ('lmt '||l_awQual||l_dim_ecm.LastQueryVS||' remove all');

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:
344: REPLACE_EXCEPTION_OBJS(l_sql_statement, l_sharedAW, l_newView, l_newCol);
345: RUN_QUERY(l_sql_statement, l_awQual||l_dim_ecm.LastQueryVS);
346: else

Line 347: ZPB_LOG.WRITE_EVENT ('zpb_aw_status.get_exception_status',

343:
344: REPLACE_EXCEPTION_OBJS(l_sql_statement, l_sharedAW, l_newView, l_newCol);
345: RUN_QUERY(l_sql_statement, l_awQual||l_dim_ecm.LastQueryVS);
346: else
347: ZPB_LOG.WRITE_EVENT ('zpb_aw_status.get_exception_status',
348: 'Could not find query: '||p_query);
349: end if;
350: end GET_EXCEPTION_STATUS;
351:

Line 371: if (instr (upper(p_aw), upper(zpb_aw.get_schema)||'.') = 0 and

367: from ZPB_STATUS_SQL
368: where (query_path = p_query);
369: begin
370:
371: if (instr (upper(p_aw), upper(zpb_aw.get_schema)||'.') = 0 and
372: instr (upper(p_aw), 'ZPB') > 0) then
373: l_aw := zpb_aw.get_schema||'.'||p_aw;
374: else
375: l_aw := p_aw;

Line 373: l_aw := zpb_aw.get_schema||'.'||p_aw;

369: begin
370:
371: if (instr (upper(p_aw), upper(zpb_aw.get_schema)||'.') = 0 and
372: instr (upper(p_aw), 'ZPB') > 0) then
373: l_aw := zpb_aw.get_schema||'.'||p_aw;
374: else
375: l_aw := p_aw;
376: end if;
377:

Line 380: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.LastQueryDimsVS||

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
384: l_ecmDim := zpb_aw.eval_text('lmt('||l_awQual||l_global_ecm.DimDim||

Line 384: l_ecmDim := zpb_aw.eval_text('lmt('||l_awQual||l_global_ecm.DimDim||

380: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.LastQueryDimsVS||
381: ' remove all');
382:
383: for each in dimensions loop
384: l_ecmDim := zpb_aw.eval_text('lmt('||l_awQual||l_global_ecm.DimDim||
385: ' to '||l_awQual||l_global_ecm.ExpObjVar||
386: ' eq '''||each.DIMENSION_NAME||''')');
387: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.LastQueryDimsVS||
388: ' add '''||l_ecmDim||'''');

Line 387: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.LastQueryDimsVS||

383: for each in dimensions loop
384: l_ecmDim := zpb_aw.eval_text('lmt('||l_awQual||l_global_ecm.DimDim||
385: ' to '||l_awQual||l_global_ecm.ExpObjVar||
386: ' eq '''||each.DIMENSION_NAME||''')');
387: zpb_aw.execute ('lmt '||l_awQual||l_global_ecm.LastQueryDimsVS||
388: ' add '''||l_ecmDim||'''');
389: end loop;
390:
391: end GET_QUERY_DIMS;

Line 422: if (instr (upper(p_aw), upper(zpb_aw.get_schema)||'.') = 0 and

418: ORDER BY ROW_NUM;
419: BEGIN
420: dbms_aw.execute ('call cm.log(''moo'' 2 '''||p_aw||': '||p_query||': '||p_dimension||''')');
421: dbms_aw.execute ('call cm.log(''moo'' 2 '''||sys_context('ZPB_CONTEXT', 'business_area_id')||''')');
422: if (instr (upper(p_aw), upper(zpb_aw.get_schema)||'.') = 0 and
423: instr (upper(p_aw), 'ZPB') > 0) then
424: l_aw := zpb_aw.get_schema||'.'||p_aw;
425: else
426: l_aw := p_aw;

Line 424: l_aw := zpb_aw.get_schema||'.'||p_aw;

420: dbms_aw.execute ('call cm.log(''moo'' 2 '''||p_aw||': '||p_query||': '||p_dimension||''')');
421: dbms_aw.execute ('call cm.log(''moo'' 2 '''||sys_context('ZPB_CONTEXT', 'business_area_id')||''')');
422: if (instr (upper(p_aw), upper(zpb_aw.get_schema)||'.') = 0 and
423: instr (upper(p_aw), 'ZPB') > 0) then
424: l_aw := zpb_aw.get_schema||'.'||p_aw;
425: else
426: l_aw := p_aw;
427: end if;
428:

Line 433: if (zpb_aw.interpbool('shw aw(attached ''PERSONAL'')')

429: --
430: -- Store the personal AW and reset it if the AW is different
431: --
432: l_pers := null;
433: if (zpb_aw.interpbool('shw aw(attached ''PERSONAL'')')
434: and instr(l_aw, '.')>0 and instr(l_aw, 'DATA')=0) then
435: l_value := zpb_aw.eval_text('aw(name ''PERSONAL'')');
436: if (l_value <> upper(l_aw)) then
437: l_pers := l_value;

Line 435: l_value := zpb_aw.eval_text('aw(name ''PERSONAL'')');

431: --
432: l_pers := null;
433: if (zpb_aw.interpbool('shw aw(attached ''PERSONAL'')')
434: and instr(l_aw, '.')>0 and instr(l_aw, 'DATA')=0) then
435: l_value := zpb_aw.eval_text('aw(name ''PERSONAL'')');
436: if (l_value <> upper(l_aw)) then
437: l_pers := l_value;
438: if (zpb_aw.interpbool('shw aw(attached '''||l_pers||''')')) then
439: zpb_aw.execute ('aw aliaslist '||l_pers||' unalias PERSONAL');

Line 438: if (zpb_aw.interpbool('shw aw(attached '''||l_pers||''')')) then

434: and instr(l_aw, '.')>0 and instr(l_aw, 'DATA')=0) then
435: l_value := zpb_aw.eval_text('aw(name ''PERSONAL'')');
436: if (l_value <> upper(l_aw)) then
437: l_pers := l_value;
438: if (zpb_aw.interpbool('shw aw(attached '''||l_pers||''')')) then
439: zpb_aw.execute ('aw aliaslist '||l_pers||' unalias PERSONAL');
440: end if;
441: if (zpb_aw.interpbool('shw aw(attached '''||l_aw||''')')) then
442: zpb_aw.execute ('aw aliaslist '||l_aw||' alias PERSONAL');

Line 439: zpb_aw.execute ('aw aliaslist '||l_pers||' unalias PERSONAL');

435: l_value := zpb_aw.eval_text('aw(name ''PERSONAL'')');
436: if (l_value <> upper(l_aw)) then
437: l_pers := l_value;
438: if (zpb_aw.interpbool('shw aw(attached '''||l_pers||''')')) then
439: zpb_aw.execute ('aw aliaslist '||l_pers||' unalias PERSONAL');
440: end if;
441: if (zpb_aw.interpbool('shw aw(attached '''||l_aw||''')')) then
442: zpb_aw.execute ('aw aliaslist '||l_aw||' alias PERSONAL');
443: end if;

Line 441: if (zpb_aw.interpbool('shw aw(attached '''||l_aw||''')')) then

437: l_pers := l_value;
438: if (zpb_aw.interpbool('shw aw(attached '''||l_pers||''')')) then
439: zpb_aw.execute ('aw aliaslist '||l_pers||' unalias PERSONAL');
440: end if;
441: if (zpb_aw.interpbool('shw aw(attached '''||l_aw||''')')) then
442: zpb_aw.execute ('aw aliaslist '||l_aw||' alias PERSONAL');
443: end if;
444: zpb_aw_status.set_personal_alias_flag();
445: -- setting this flag so as aw.initialize is not called in get_limitmap

Line 442: zpb_aw.execute ('aw aliaslist '||l_aw||' alias PERSONAL');

438: if (zpb_aw.interpbool('shw aw(attached '''||l_pers||''')')) then
439: zpb_aw.execute ('aw aliaslist '||l_pers||' unalias PERSONAL');
440: end if;
441: if (zpb_aw.interpbool('shw aw(attached '''||l_aw||''')')) then
442: zpb_aw.execute ('aw aliaslist '||l_aw||' alias PERSONAL');
443: end if;
444: zpb_aw_status.set_personal_alias_flag();
445: -- setting this flag so as aw.initialize is not called in get_limitmap
446:

Line 444: zpb_aw_status.set_personal_alias_flag();

440: end if;
441: if (zpb_aw.interpbool('shw aw(attached '''||l_aw||''')')) then
442: zpb_aw.execute ('aw aliaslist '||l_aw||' alias PERSONAL');
443: end if;
444: zpb_aw_status.set_personal_alias_flag();
445: -- setting this flag so as aw.initialize is not called in get_limitmap
446:
447: end if;
448: end if;

Line 463: --zpb_aw.execute ('CALL MD.VIEW.CMD.CLEANUP');

459: fetch queryCurs into l_count;
460: close queryCurs;
461: end if;
462:
463: --zpb_aw.execute ('CALL MD.VIEW.CMD.CLEANUP');
464: if (l_pers is not null) then
465: if (zpb_aw.interpbool('shw aw(attached '''||l_aw||''')')) then
466: zpb_aw.execute ('aw aliaslist '||l_aw||' unalias PERSONAL');
467: end if;

Line 465: if (zpb_aw.interpbool('shw aw(attached '''||l_aw||''')')) then

461: end if;
462:
463: --zpb_aw.execute ('CALL MD.VIEW.CMD.CLEANUP');
464: if (l_pers is not null) then
465: if (zpb_aw.interpbool('shw aw(attached '''||l_aw||''')')) then
466: zpb_aw.execute ('aw aliaslist '||l_aw||' unalias PERSONAL');
467: end if;
468: if (zpb_aw.interpbool('shw aw(attached '''||l_pers||''')')) then
469: zpb_aw.execute ('aw aliaslist '||l_pers||' alias PERSONAL');

Line 466: zpb_aw.execute ('aw aliaslist '||l_aw||' unalias PERSONAL');

462:
463: --zpb_aw.execute ('CALL MD.VIEW.CMD.CLEANUP');
464: if (l_pers is not null) then
465: if (zpb_aw.interpbool('shw aw(attached '''||l_aw||''')')) then
466: zpb_aw.execute ('aw aliaslist '||l_aw||' unalias PERSONAL');
467: end if;
468: if (zpb_aw.interpbool('shw aw(attached '''||l_pers||''')')) then
469: zpb_aw.execute ('aw aliaslist '||l_pers||' alias PERSONAL');
470: end if;

Line 468: if (zpb_aw.interpbool('shw aw(attached '''||l_pers||''')')) then

464: if (l_pers is not null) then
465: if (zpb_aw.interpbool('shw aw(attached '''||l_aw||''')')) then
466: zpb_aw.execute ('aw aliaslist '||l_aw||' unalias PERSONAL');
467: end if;
468: if (zpb_aw.interpbool('shw aw(attached '''||l_pers||''')')) then
469: zpb_aw.execute ('aw aliaslist '||l_pers||' alias PERSONAL');
470: end if;
471: zpb_aw_status.RESET_PERSONAL_ALIAS_FLAG();
472: end if;

Line 469: zpb_aw.execute ('aw aliaslist '||l_pers||' alias PERSONAL');

465: if (zpb_aw.interpbool('shw aw(attached '''||l_aw||''')')) then
466: zpb_aw.execute ('aw aliaslist '||l_aw||' unalias PERSONAL');
467: end if;
468: if (zpb_aw.interpbool('shw aw(attached '''||l_pers||''')')) then
469: zpb_aw.execute ('aw aliaslist '||l_pers||' alias PERSONAL');
470: end if;
471: zpb_aw_status.RESET_PERSONAL_ALIAS_FLAG();
472: end if;
473:

Line 471: zpb_aw_status.RESET_PERSONAL_ALIAS_FLAG();

467: end if;
468: if (zpb_aw.interpbool('shw aw(attached '''||l_pers||''')')) then
469: zpb_aw.execute ('aw aliaslist '||l_pers||' alias PERSONAL');
470: end if;
471: zpb_aw_status.RESET_PERSONAL_ALIAS_FLAG();
472: end if;
473:
474: return l_count;
475:

Line 482: if (zpb_aw.interpbool('shw aw(attached '''||l_aw||''')')) then

478: -- Must cleanup and reset PERSONAL alias in case of crash
479: --
480: when others then
481: if (l_pers is not null) then
482: if (zpb_aw.interpbool('shw aw(attached '''||l_aw||''')')) then
483: zpb_aw.execute ('aw aliaslist '||l_aw||' unalias PERSONAL');
484: end if;
485: if (zpb_aw.interpbool('shw aw(attached '''||l_pers||''')')) then
486: zpb_aw.execute ('aw aliaslist '||l_pers||' alias PERSONAL');

Line 483: zpb_aw.execute ('aw aliaslist '||l_aw||' unalias PERSONAL');

479: --
480: when others then
481: if (l_pers is not null) then
482: if (zpb_aw.interpbool('shw aw(attached '''||l_aw||''')')) then
483: zpb_aw.execute ('aw aliaslist '||l_aw||' unalias PERSONAL');
484: end if;
485: if (zpb_aw.interpbool('shw aw(attached '''||l_pers||''')')) then
486: zpb_aw.execute ('aw aliaslist '||l_pers||' alias PERSONAL');
487: end if;

Line 485: if (zpb_aw.interpbool('shw aw(attached '''||l_pers||''')')) then

481: if (l_pers is not null) then
482: if (zpb_aw.interpbool('shw aw(attached '''||l_aw||''')')) then
483: zpb_aw.execute ('aw aliaslist '||l_aw||' unalias PERSONAL');
484: end if;
485: if (zpb_aw.interpbool('shw aw(attached '''||l_pers||''')')) then
486: zpb_aw.execute ('aw aliaslist '||l_pers||' alias PERSONAL');
487: end if;
488: zpb_aw_status.RESET_PERSONAL_ALIAS_FLAG();
489: end if;

Line 486: zpb_aw.execute ('aw aliaslist '||l_pers||' alias PERSONAL');

482: if (zpb_aw.interpbool('shw aw(attached '''||l_aw||''')')) then
483: zpb_aw.execute ('aw aliaslist '||l_aw||' unalias PERSONAL');
484: end if;
485: if (zpb_aw.interpbool('shw aw(attached '''||l_pers||''')')) then
486: zpb_aw.execute ('aw aliaslist '||l_pers||' alias PERSONAL');
487: end if;
488: zpb_aw_status.RESET_PERSONAL_ALIAS_FLAG();
489: end if;
490:

Line 488: zpb_aw_status.RESET_PERSONAL_ALIAS_FLAG();

484: end if;
485: if (zpb_aw.interpbool('shw aw(attached '''||l_pers||''')')) then
486: zpb_aw.execute ('aw aliaslist '||l_pers||' alias PERSONAL');
487: end if;
488: zpb_aw_status.RESET_PERSONAL_ALIAS_FLAG();
489: end if;
490:
491: ZPB_LOG.LOG_PLSQL_EXCEPTION('zpb_aw_status', 'get_status');
492: RAISE;

Line 491: ZPB_LOG.LOG_PLSQL_EXCEPTION('zpb_aw_status', 'get_status');

487: end if;
488: zpb_aw_status.RESET_PERSONAL_ALIAS_FLAG();
489: end if;
490:
491: ZPB_LOG.LOG_PLSQL_EXCEPTION('zpb_aw_status', 'get_status');
492: RAISE;
493: return -1;
494:
495: end GET_STATUS_COUNT;

Line 518: END ZPB_AW_STATUS;

514: end GET_PERSONAL_ALIAS_FLAG;
515:
516:
517:
518: END ZPB_AW_STATUS;