APPS.ZPB_AW dependencies on DBMS_AW

Line 12: -- Function to call dbms_aw.execute

8:
9: -------------------------------------------------------------------------------
10: -- EXECUTE
11: --
12: -- Function to call dbms_aw.execute
13: --
14: -- IN: p_cmd (varchar2) - The AW command to execute
15: --
16: -------------------------------------------------------------------------------

Line 24: dbms_aw.execute(p_cmd);

20: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
21: zpb_log.write_statement ('zpb_aw.execute',
22: 'Executing AW Statement: '||p_cmd);
23: end if;
24: dbms_aw.execute(p_cmd);
25: end execute;
26:
27: -------------------------------------------------------------------------------
28: -- INTERP <-- DEPRECATED - Use EVAL_TEXT or EVAL_NUMBER instead -->

Line 46: l_return := dbms_lob.substr(dbms_aw.interp (p_cmd), 4000);

42: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
43: zpb_log.write_statement ('zpb_aw.interp',
44: 'Interpreting AW Statement: '||p_cmd);
45:
46: l_return := dbms_lob.substr(dbms_aw.interp (p_cmd), 4000);
47:
48: zpb_log.write_statement ('zpb_aw.interp',
49: 'AW Statement returned: '||l_return);
50: return l_return;

Line 52: return dbms_lob.substr(dbms_aw.interp (p_cmd), 4000);

48: zpb_log.write_statement ('zpb_aw.interp',
49: 'AW Statement returned: '||l_return);
50: return l_return;
51: else
52: return dbms_lob.substr(dbms_aw.interp (p_cmd), 4000);
53: end if;
54: end INTERP;
55:
56: -------------------------------------------------------------------------------

Line 75: if (dbms_aw.eval_number('if nafill('||substr(p_cmd, 5)||

71: zpb_log.write_statement ('zpb_aw.interpbool',
72: 'Interpreting AW Statement: '||p_cmd);
73: end if;
74:
75: if (dbms_aw.eval_number('if nafill('||substr(p_cmd, 5)||
76: ', no) then 1 else 0') = 1) then
77: l_return := true;
78: else
79: l_return := false;

Line 112: l_return := dbms_lob.substr(dbms_aw.eval_text(p_cmd), 4000);

108: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
109: zpb_log.write_statement ('zpb_aw.eval_text',
110: 'Interpreting AW Statement: '||p_cmd);
111:
112: l_return := dbms_lob.substr(dbms_aw.eval_text(p_cmd), 4000);
113:
114: zpb_log.write_statement ('zpb_aw.eval_text',
115: 'AW Statement returned: '||l_return);
116: return l_return;

Line 118: return dbms_lob.substr(dbms_aw.eval_text(p_cmd), 4000);

114: zpb_log.write_statement ('zpb_aw.eval_text',
115: 'AW Statement returned: '||l_return);
116: return l_return;
117: else
118: return dbms_lob.substr(dbms_aw.eval_text(p_cmd), 4000);
119: end if;
120: end EVAL_TEXT;
121:
122: -------------------------------------------------------------------------------

Line 140: l_return := dbms_aw.eval_number(p_cmd);

136: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
137: zpb_log.write_statement ('zpb_aw.eval_text',
138: 'Interpreting AW Statement: '||p_cmd);
139:
140: l_return := dbms_aw.eval_number(p_cmd);
141:
142: zpb_log.write_statement ('zpb_aw.eval_text',
143: 'AW Statement returned: '||l_return);
144: return l_return;

Line 146: return dbms_aw.eval_number(p_cmd);

142: zpb_log.write_statement ('zpb_aw.eval_text',
143: 'AW Statement returned: '||l_return);
144: return l_return;
145: else
146: return dbms_aw.eval_number(p_cmd);
147: end if;
148: end EVAL_NUMBER;
149: ------------------------------------------------------------------------------
150: -- DETACH_ALL

Line 714: DBMS_AW.SHUTDOWN;

710: DETACH_ALL;
711:
712: ZPB_SECURITY_CONTEXT.INITCONTEXT(null, null, null, null, null);
713:
714: DBMS_AW.SHUTDOWN;
715:
716: ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME||'.'||l_api_name||'.end',
717: 'OLAP workspace has been cleaned');
718: