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_UTIL_PVT dependencies on DBMS_LOB

Line 285: dbms_lob.CREATETEMPORARY(l_modelEquation, true);

281: l_modelEquationRes := opRec.model_equation ;
282: l_calcParamRes := opRec.CALC_PARAMETERS;
283:
284: if (ZPB_AW.INTERPBOOL('shw SV.DEF.VAR(SV.DEF.PROP.DIM ''EQUATION'') eq NA')) then
285: dbms_lob.CREATETEMPORARY(l_modelEquation, true);
286: --iterating through each clob to replace ' with \'
287:
288: offset := dbms_lob.instr(l_modelEquationres, '\');
289: while (offset <> 0)

Line 288: offset := dbms_lob.instr(l_modelEquationres, '\');

284: if (ZPB_AW.INTERPBOOL('shw SV.DEF.VAR(SV.DEF.PROP.DIM ''EQUATION'') eq NA')) then
285: dbms_lob.CREATETEMPORARY(l_modelEquation, true);
286: --iterating through each clob to replace ' with \'
287:
288: offset := dbms_lob.instr(l_modelEquationres, '\');
289: while (offset <> 0)
290: loop
291: l_modelEquationres := dbms_lob.substr(l_modelEquationres,offset-1,1)||
292: '\'||dbms_lob.substr(lob_loc => l_modelEquationres,

Line 291: l_modelEquationres := dbms_lob.substr(l_modelEquationres,offset-1,1)||

287:
288: offset := dbms_lob.instr(l_modelEquationres, '\');
289: while (offset <> 0)
290: loop
291: l_modelEquationres := dbms_lob.substr(l_modelEquationres,offset-1,1)||
292: '\'||dbms_lob.substr(lob_loc => l_modelEquationres,
293: offset => offset);
294: offset := dbms_lob.instr(l_modelEquationres, '\', offset+2);
295: end loop;

Line 292: '\'||dbms_lob.substr(lob_loc => l_modelEquationres,

288: offset := dbms_lob.instr(l_modelEquationres, '\');
289: while (offset <> 0)
290: loop
291: l_modelEquationres := dbms_lob.substr(l_modelEquationres,offset-1,1)||
292: '\'||dbms_lob.substr(lob_loc => l_modelEquationres,
293: offset => offset);
294: offset := dbms_lob.instr(l_modelEquationres, '\', offset+2);
295: end loop;
296: offset := dbms_lob.instr(l_modelEquationres, '''');

Line 294: offset := dbms_lob.instr(l_modelEquationres, '\', offset+2);

290: loop
291: l_modelEquationres := dbms_lob.substr(l_modelEquationres,offset-1,1)||
292: '\'||dbms_lob.substr(lob_loc => l_modelEquationres,
293: offset => offset);
294: offset := dbms_lob.instr(l_modelEquationres, '\', offset+2);
295: end loop;
296: offset := dbms_lob.instr(l_modelEquationres, '''');
297:
298: while (offset <> 0)

Line 296: offset := dbms_lob.instr(l_modelEquationres, '''');

292: '\'||dbms_lob.substr(lob_loc => l_modelEquationres,
293: offset => offset);
294: offset := dbms_lob.instr(l_modelEquationres, '\', offset+2);
295: end loop;
296: offset := dbms_lob.instr(l_modelEquationres, '''');
297:
298: while (offset <> 0)
299: loop
300: l_modelEquationres := dbms_lob.substr(l_modelEquationres,offset-1,1)||

Line 300: l_modelEquationres := dbms_lob.substr(l_modelEquationres,offset-1,1)||

296: offset := dbms_lob.instr(l_modelEquationres, '''');
297:
298: while (offset <> 0)
299: loop
300: l_modelEquationres := dbms_lob.substr(l_modelEquationres,offset-1,1)||
301: '\'||dbms_lob.substr(lob_loc => l_modelEquationres,
302: offset => offset);
303: offset := dbms_lob.instr(l_modelEquationres, '''', offset+2);
304: end loop;

Line 301: '\'||dbms_lob.substr(lob_loc => l_modelEquationres,

297:
298: while (offset <> 0)
299: loop
300: l_modelEquationres := dbms_lob.substr(l_modelEquationres,offset-1,1)||
301: '\'||dbms_lob.substr(lob_loc => l_modelEquationres,
302: offset => offset);
303: offset := dbms_lob.instr(l_modelEquationres, '''', offset+2);
304: end loop;
305:

Line 303: offset := dbms_lob.instr(l_modelEquationres, '''', offset+2);

299: loop
300: l_modelEquationres := dbms_lob.substr(l_modelEquationres,offset-1,1)||
301: '\'||dbms_lob.substr(lob_loc => l_modelEquationres,
302: offset => offset);
303: offset := dbms_lob.instr(l_modelEquationres, '''', offset+2);
304: end loop;
305:
306: l_modelEquation :=
307: 'SV.DEF.VAR(SV.DEF.PROP.DIM ''EQUATION'') = joinlines( ';

Line 310: i := dbms_lob.instr(l_modelEquationres, ')', indx+3800);

306: l_modelEquation :=
307: 'SV.DEF.VAR(SV.DEF.PROP.DIM ''EQUATION'') = joinlines( ';
308: indx := 1;
309: loop
310: i := dbms_lob.instr(l_modelEquationres, ')', indx+3800);
311: if (i > 0) then
312: l_modelEquation := l_modelEquation || ' - '||fnd_global.newline()||
313: ''''||dbms_lob.substr(l_modelEquationres,i-indx+1,indx)||'''';
314: indx := i+1;

Line 313: ''''||dbms_lob.substr(l_modelEquationres,i-indx+1,indx)||'''';

309: loop
310: i := dbms_lob.instr(l_modelEquationres, ')', indx+3800);
311: if (i > 0) then
312: l_modelEquation := l_modelEquation || ' - '||fnd_global.newline()||
313: ''''||dbms_lob.substr(l_modelEquationres,i-indx+1,indx)||'''';
314: indx := i+1;
315: else
316: l_modelEquation := l_modelEquation || ' - '||fnd_global.newline()||
317: ''''||dbms_lob.substr(l_modelEquationres,4000,indx)||'''';

Line 317: ''''||dbms_lob.substr(l_modelEquationres,4000,indx)||'''';

313: ''''||dbms_lob.substr(l_modelEquationres,i-indx+1,indx)||'''';
314: indx := i+1;
315: else
316: l_modelEquation := l_modelEquation || ' - '||fnd_global.newline()||
317: ''''||dbms_lob.substr(l_modelEquationres,4000,indx)||'''';
318: exit;
319: end if;
320: end loop;
321: l_modelEquation := l_modelEquation || ')';

Line 326: dbms_lob.CREATETEMPORARY(l_calcParam, true);

322: l_modelEquationres := DBMS_AW.INTERPCLOB(l_modelEquation);
323: end if;
324: if (ZPB_AW.INTERPBOOL('shw SV.DEF.VAR(SV.DEF.PROP.DIM ''CALC_PARAMS'') eq NA')) then
325: -- for calc_parameters column
326: dbms_lob.CREATETEMPORARY(l_calcParam, true);
327:
328: offset := dbms_lob.instr(l_calcParamRes, '\');
329: while (offset <> 0)
330: loop

Line 328: offset := dbms_lob.instr(l_calcParamRes, '\');

324: if (ZPB_AW.INTERPBOOL('shw SV.DEF.VAR(SV.DEF.PROP.DIM ''CALC_PARAMS'') eq NA')) then
325: -- for calc_parameters column
326: dbms_lob.CREATETEMPORARY(l_calcParam, true);
327:
328: offset := dbms_lob.instr(l_calcParamRes, '\');
329: while (offset <> 0)
330: loop
331: l_calcParamres := dbms_lob.substr(l_calcParamres, offset-1, 1)||
332: '\'||dbms_lob.substr(lob_loc => l_calcParamres, offset => offset);

Line 331: l_calcParamres := dbms_lob.substr(l_calcParamres, offset-1, 1)||

327:
328: offset := dbms_lob.instr(l_calcParamRes, '\');
329: while (offset <> 0)
330: loop
331: l_calcParamres := dbms_lob.substr(l_calcParamres, offset-1, 1)||
332: '\'||dbms_lob.substr(lob_loc => l_calcParamres, offset => offset);
333: offset := dbms_lob.instr(l_calcParamres, '\', offset+2);
334: end loop;
335: offset := dbms_lob.instr(l_calcParamres, '''');

Line 332: '\'||dbms_lob.substr(lob_loc => l_calcParamres, offset => offset);

328: offset := dbms_lob.instr(l_calcParamRes, '\');
329: while (offset <> 0)
330: loop
331: l_calcParamres := dbms_lob.substr(l_calcParamres, offset-1, 1)||
332: '\'||dbms_lob.substr(lob_loc => l_calcParamres, offset => offset);
333: offset := dbms_lob.instr(l_calcParamres, '\', offset+2);
334: end loop;
335: offset := dbms_lob.instr(l_calcParamres, '''');
336:

Line 333: offset := dbms_lob.instr(l_calcParamres, '\', offset+2);

329: while (offset <> 0)
330: loop
331: l_calcParamres := dbms_lob.substr(l_calcParamres, offset-1, 1)||
332: '\'||dbms_lob.substr(lob_loc => l_calcParamres, offset => offset);
333: offset := dbms_lob.instr(l_calcParamres, '\', offset+2);
334: end loop;
335: offset := dbms_lob.instr(l_calcParamres, '''');
336:
337: while (offset <> 0)

Line 335: offset := dbms_lob.instr(l_calcParamres, '''');

331: l_calcParamres := dbms_lob.substr(l_calcParamres, offset-1, 1)||
332: '\'||dbms_lob.substr(lob_loc => l_calcParamres, offset => offset);
333: offset := dbms_lob.instr(l_calcParamres, '\', offset+2);
334: end loop;
335: offset := dbms_lob.instr(l_calcParamres, '''');
336:
337: while (offset <> 0)
338: loop
339: l_calcParamres := dbms_lob.substr(l_calcParamres, offset-1, 1)||

Line 339: l_calcParamres := dbms_lob.substr(l_calcParamres, offset-1, 1)||

335: offset := dbms_lob.instr(l_calcParamres, '''');
336:
337: while (offset <> 0)
338: loop
339: l_calcParamres := dbms_lob.substr(l_calcParamres, offset-1, 1)||
340: '\'||dbms_lob.substr(lob_loc => l_calcParamres, offset => offset);
341: offset := dbms_lob.instr(l_calcParamres, '''', offset+2);
342: end loop;
343:

Line 340: '\'||dbms_lob.substr(lob_loc => l_calcParamres, offset => offset);

336:
337: while (offset <> 0)
338: loop
339: l_calcParamres := dbms_lob.substr(l_calcParamres, offset-1, 1)||
340: '\'||dbms_lob.substr(lob_loc => l_calcParamres, offset => offset);
341: offset := dbms_lob.instr(l_calcParamres, '''', offset+2);
342: end loop;
343:
344: offset := dbms_lob.instr(l_calcParamres, fnd_global.newline());

Line 341: offset := dbms_lob.instr(l_calcParamres, '''', offset+2);

337: while (offset <> 0)
338: loop
339: l_calcParamres := dbms_lob.substr(l_calcParamres, offset-1, 1)||
340: '\'||dbms_lob.substr(lob_loc => l_calcParamres, offset => offset);
341: offset := dbms_lob.instr(l_calcParamres, '''', offset+2);
342: end loop;
343:
344: offset := dbms_lob.instr(l_calcParamres, fnd_global.newline());
345: while (offset <> 0)

Line 344: offset := dbms_lob.instr(l_calcParamres, fnd_global.newline());

340: '\'||dbms_lob.substr(lob_loc => l_calcParamres, offset => offset);
341: offset := dbms_lob.instr(l_calcParamres, '''', offset+2);
342: end loop;
343:
344: offset := dbms_lob.instr(l_calcParamres, fnd_global.newline());
345: while (offset <> 0)
346: loop
347: if (dbms_lob.substr(l_calcParamres, offset-1, 1) <> '-')
348: then

Line 347: if (dbms_lob.substr(l_calcParamres, offset-1, 1) <> '-')

343:
344: offset := dbms_lob.instr(l_calcParamres, fnd_global.newline());
345: while (offset <> 0)
346: loop
347: if (dbms_lob.substr(l_calcParamres, offset-1, 1) <> '-')
348: then
349: l_calcParamres := dbms_lob.substr(l_calcParamres, offset-1, 1)||
350: '-'||dbms_lob.substr(lob_loc => l_calcParamres, offset => offset);
351: end if;

Line 349: l_calcParamres := dbms_lob.substr(l_calcParamres, offset-1, 1)||

345: while (offset <> 0)
346: loop
347: if (dbms_lob.substr(l_calcParamres, offset-1, 1) <> '-')
348: then
349: l_calcParamres := dbms_lob.substr(l_calcParamres, offset-1, 1)||
350: '-'||dbms_lob.substr(lob_loc => l_calcParamres, offset => offset);
351: end if;
352: offset := dbms_lob.instr(l_calcParamres, fnd_global.newline(), offset+2);
353: end loop;

Line 350: '-'||dbms_lob.substr(lob_loc => l_calcParamres, offset => offset);

346: loop
347: if (dbms_lob.substr(l_calcParamres, offset-1, 1) <> '-')
348: then
349: l_calcParamres := dbms_lob.substr(l_calcParamres, offset-1, 1)||
350: '-'||dbms_lob.substr(lob_loc => l_calcParamres, offset => offset);
351: end if;
352: offset := dbms_lob.instr(l_calcParamres, fnd_global.newline(), offset+2);
353: end loop;
354:

Line 352: offset := dbms_lob.instr(l_calcParamres, fnd_global.newline(), offset+2);

348: then
349: l_calcParamres := dbms_lob.substr(l_calcParamres, offset-1, 1)||
350: '-'||dbms_lob.substr(lob_loc => l_calcParamres, offset => offset);
351: end if;
352: offset := dbms_lob.instr(l_calcParamres, fnd_global.newline(), offset+2);
353: end loop;
354:
355:
356: l_calcParam :=

Line 360: i := dbms_lob.instr(l_calcParamres, ')', indx+3800);

356: l_calcParam :=
357: 'SV.DEF.VAR(SV.DEF.PROP.DIM ''CALC_PARAMS'') = joinlines( ';
358: indx := 1;
359: loop
360: i := dbms_lob.instr(l_calcParamres, ')', indx+3800);
361: if (i > 0) then
362: l_calcParam := l_calcParam || ' - '||fnd_global.newline()||
363: ''''||dbms_lob.substr(l_calcParamres,i-indx+1,indx)||'''';
364: indx := i+1;

Line 363: ''''||dbms_lob.substr(l_calcParamres,i-indx+1,indx)||'''';

359: loop
360: i := dbms_lob.instr(l_calcParamres, ')', indx+3800);
361: if (i > 0) then
362: l_calcParam := l_calcParam || ' - '||fnd_global.newline()||
363: ''''||dbms_lob.substr(l_calcParamres,i-indx+1,indx)||'''';
364: indx := i+1;
365: else
366: l_calcParam := l_calcParam || ' - '||fnd_global.newline()||
367: ''''||dbms_lob.substr(l_calcParamres,4000,indx)||'''';

Line 367: ''''||dbms_lob.substr(l_calcParamres,4000,indx)||'''';

363: ''''||dbms_lob.substr(l_calcParamres,i-indx+1,indx)||'''';
364: indx := i+1;
365: else
366: l_calcParam := l_calcParam || ' - '||fnd_global.newline()||
367: ''''||dbms_lob.substr(l_calcParamres,4000,indx)||'''';
368: exit;
369: end if;
370: end loop;
371: l_calcParam := l_calcParam || ')';