APPS.ZPB_AW_STATUS dependencies on ZPB_AW_STATUS

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 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 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 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 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 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 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 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 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;