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.QPR_AW_INTERFACE_PVT dependencies on DBMS_AW

Line 15: dbms_aw.execute(execution_string);

11: end if;
12:
13: execution_string := 'aw attach '||p_aw_name||' '||p_attach_mode||';';
14: -- Attach specified AW in multi mode .
15: dbms_aw.execute(execution_string);
16:
17: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
18: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.ATTACH_AW', 'DML Program Attach succeeded' );
19: end if;

Line 47: dbms_aw.execute(execution_string);

43: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.DETACH_AW', 'Detach_aw procedure invoked' );
44: end if;
45: execution_string := 'aw detach '||p_aw_name||';';
46: -- Detached specified AW
47: dbms_aw.execute(execution_string);
48: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
49: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.DETACH_AW', 'DML Program DETACH succeeded' );
50: end if;
51: x_return_status := 'success';

Line 105: dbms_aw.execute(dimString || measString);

101: measString := measString || measTable(measCounter).measName ||' = '|| measTable(measCounter).measValue || ';' ;
102: end if;
103: measCounter := measCounter+1;
104: if(dimCheck <> false) then -- Check if dimension isn't null in which caseentire cube wud b set to above value.
105: dbms_aw.execute(dimString || measString);
106: end if;
107: if(measCounter > measTable.count) then
108: exit outer_loop;
109: end if;

Line 116: dbms_aw.execute('ALLSTAT;');

112: cell_id :=cell_id+1;
113: dimString := '';
114: dimCheck := false;
115: end loop outer_loop;
116: dbms_aw.execute('ALLSTAT;');
117: x_return_status := 'success';
118: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
119: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.WRITEBACK_AW', 'WRITEBACK_AW procedure succeeded' );
120: end if;

Line 151: dbms_aw.execute(cmdString);

147: cmdString := cmdString || 'limit '||modelExecScope(i).dimName ||' to '''||modelExecScope(i).dimValue||''';';
148: dimName := modelExecScope(i).dimName;
149: end if;
150: end loop;
151: dbms_aw.execute(cmdString);
152:
153: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
154: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.EXECUTEMODEL', 'Scope set for the execution of the model' );
155: end if;

Line 161: dbms_aw.execute(cmdString);

157:
158:
159: cmdString := '';
160: cmdString := modelMeasName || '= 0.0;';
161: dbms_aw.execute(cmdString);
162:
163:
164: dbms_aw.execute('naskip2 = yes');
165: dbms_aw.execute(modelName ||' '||modelMeasName);

Line 164: dbms_aw.execute('naskip2 = yes');

160: cmdString := modelMeasName || '= 0.0;';
161: dbms_aw.execute(cmdString);
162:
163:
164: dbms_aw.execute('naskip2 = yes');
165: dbms_aw.execute(modelName ||' '||modelMeasName);
166: dbms_aw.execute('naskip2 = no');
167:
168: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 165: dbms_aw.execute(modelName ||' '||modelMeasName);

161: dbms_aw.execute(cmdString);
162:
163:
164: dbms_aw.execute('naskip2 = yes');
165: dbms_aw.execute(modelName ||' '||modelMeasName);
166: dbms_aw.execute('naskip2 = no');
167:
168: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
169: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.EXECUTEMODEL', 'Model '||modelName ||' Executed successfully ');

Line 166: dbms_aw.execute('naskip2 = no');

162:
163:
164: dbms_aw.execute('naskip2 = yes');
165: dbms_aw.execute(modelName ||' '||modelMeasName);
166: dbms_aw.execute('naskip2 = no');
167:
168: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
169: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.EXECUTEMODEL', 'Model '||modelName ||' Executed successfully ');
170: end if;

Line 179: dbms_aw.execute(cmdString);

175: for i in 1..writeBackMeas.count loop
176: cmdString := cmdString || 'limit '||modelDimension ||' to '||''''||writeBackMeas(i).measPPACode||''''||' ;';
177: cmdString := cmdString ||writeBackMeas(i).measId ||' = ' ||modelMeasName||' ; ';
178: end loop;
179: dbms_aw.execute(cmdString);
180: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
181: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.EXECUTEMODEL', 'Measure Values written back after the execution of model');
182: end if;
183:

Line 185: dbms_aw.execute(cmdString);

181: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.EXECUTEMODEL', 'Measure Values written back after the execution of model');
182: end if;
183:
184: cmdString := 'ALLSTAT;';
185: dbms_aw.execute(cmdString);
186: x_return_status := 'success';
187: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
188: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.EXECUTEMODEL', 'ExecuteModel Procedure successful');
189: end if;

Line 227: dbms_aw.execute(cmdString);

223: measString := measString||','|| commitMeas(i).measid;
224: end if;
225: end loop;
226: cmdString := 'acquire '||measString||';';
227: dbms_aw.execute(cmdString);
228: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
229: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.COMMITDATA', 'Acquired the lock for the measures that are to be committed');
230: end if;
231:

Line 235: dbms_aw.execute(cmdString);

231:
232:
233:
234: cmdString := 'UPDATE;';
235: dbms_aw.execute(cmdString);
236:
237: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
238: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.COMMITDATA', 'Update of measures Successful');
239: end if;

Line 243: dbms_aw.execute(cmdString);

239: end if;
240:
241:
242: cmdString := 'COMMIT;';
243: dbms_aw.execute(cmdString);
244:
245: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
246: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.COMMITDATA', 'Commit measure values Successful');
247: end if;

Line 251: dbms_aw.execute(cmdString);

247: end if;
248:
249:
250: cmdString := 'Release '|| measString ||';';
251: dbms_aw.execute(cmdString);
252:
253: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
254: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'QPR_AW_INTERFACE_PVT.COMMITDATA', 'Released the lock acquired on the measures');
255: end if;

Line 311: dbms_aw.execute('acquire resync '||commitMeas(i).measid||' consistent with '||dimString);

307:
308:
309: if (acquire = 'YES') then
310: for i in 1..commitMeas.count loop
311: dbms_aw.execute('acquire resync '||commitMeas(i).measid||' consistent with '||dimString);
312: end loop;
313: else
314: dbms_aw.execute('update');
315: dbms_aw.execute('commit');

Line 314: dbms_aw.execute('update');

310: for i in 1..commitMeas.count loop
311: dbms_aw.execute('acquire resync '||commitMeas(i).measid||' consistent with '||dimString);
312: end loop;
313: else
314: dbms_aw.execute('update');
315: dbms_aw.execute('commit');
316: for i in 1..commitMeas.count loop
317: dbms_aw.execute('release '||commitMeas(i).measid);
318: end loop;

Line 315: dbms_aw.execute('commit');

311: dbms_aw.execute('acquire resync '||commitMeas(i).measid||' consistent with '||dimString);
312: end loop;
313: else
314: dbms_aw.execute('update');
315: dbms_aw.execute('commit');
316: for i in 1..commitMeas.count loop
317: dbms_aw.execute('release '||commitMeas(i).measid);
318: end loop;
319: end if;

Line 317: dbms_aw.execute('release '||commitMeas(i).measid);

313: else
314: dbms_aw.execute('update');
315: dbms_aw.execute('commit');
316: for i in 1..commitMeas.count loop
317: dbms_aw.execute('release '||commitMeas(i).measid);
318: end loop;
319: end if;
320:
321: x_return_status := 'success';