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_DEBUG dependencies on DBMS_OUTPUT

Line 50: dbms_output.put_line ('Error Buffer: '||substr (msgData, 1, 240));

46: FND_API.G_VALID_LEVEL_FULL,
47: retcode, msgCnt, msgData,
48: to_char(p_user), FND_API.G_FALSE);
49:
50: dbms_output.put_line ('Error Buffer: '||substr (msgData, 1, 240));
51: dbms_output.put_line ('Error Buffer: '||substr (msgData, 240, 240));
52: dbms_output.put_line ('Retcode: '||retcode);
53:
54: end STARTUP;

Line 51: dbms_output.put_line ('Error Buffer: '||substr (msgData, 240, 240));

47: retcode, msgCnt, msgData,
48: to_char(p_user), FND_API.G_FALSE);
49:
50: dbms_output.put_line ('Error Buffer: '||substr (msgData, 1, 240));
51: dbms_output.put_line ('Error Buffer: '||substr (msgData, 240, 240));
52: dbms_output.put_line ('Retcode: '||retcode);
53:
54: end STARTUP;
55:

Line 52: dbms_output.put_line ('Retcode: '||retcode);

48: to_char(p_user), FND_API.G_FALSE);
49:
50: dbms_output.put_line ('Error Buffer: '||substr (msgData, 1, 240));
51: dbms_output.put_line ('Error Buffer: '||substr (msgData, 240, 240));
52: dbms_output.put_line ('Retcode: '||retcode);
53:
54: end STARTUP;
55:
56: procedure STARTUPRO(p_user IN NUMBER,

Line 74: dbms_output.put_line ('Error Buffer: '||substr (msgData, 1, 240));

70: FND_API.G_VALID_LEVEL_FULL,
71: retcode, msgCnt, msgData,
72: to_char(p_user), FND_API.G_TRUE);
73:
74: dbms_output.put_line ('Error Buffer: '||substr (msgData, 1, 240));
75: dbms_output.put_line ('Error Buffer: '||substr (msgData, 240, 240));
76: dbms_output.put_line ('Retcode: '||retcode);
77: end STARTUPRO;
78:

Line 75: dbms_output.put_line ('Error Buffer: '||substr (msgData, 240, 240));

71: retcode, msgCnt, msgData,
72: to_char(p_user), FND_API.G_TRUE);
73:
74: dbms_output.put_line ('Error Buffer: '||substr (msgData, 1, 240));
75: dbms_output.put_line ('Error Buffer: '||substr (msgData, 240, 240));
76: dbms_output.put_line ('Retcode: '||retcode);
77: end STARTUPRO;
78:
79: --

Line 76: dbms_output.put_line ('Retcode: '||retcode);

72: to_char(p_user), FND_API.G_TRUE);
73:
74: dbms_output.put_line ('Error Buffer: '||substr (msgData, 1, 240));
75: dbms_output.put_line ('Error Buffer: '||substr (msgData, 240, 240));
76: dbms_output.put_line ('Retcode: '||retcode);
77: end STARTUPRO;
78:
79: --
80: -- Same as calling Refresh on a BA, run from the backend

Line 90: dbms_output.put_line ('Retcode: '||retcode);

86: retcode varchar2(4000);
87: begin
88: fnd_global.apps_initialize(p_user, 24138, 210);
89: zpb_build_metadata.build_metadata (errbuf, retcode, p_business_area);
90: dbms_output.put_line ('Retcode: '||retcode);
91: dbms_output.put_line ('ErrBuf: '||errbuf);
92: end REFRESH_BA;
93:
94: -- prints metadata info for user and ba to the screen

Line 91: dbms_output.put_line ('ErrBuf: '||errbuf);

87: begin
88: fnd_global.apps_initialize(p_user, 24138, 210);
89: zpb_build_metadata.build_metadata (errbuf, retcode, p_business_area);
90: dbms_output.put_line ('Retcode: '||retcode);
91: dbms_output.put_line ('ErrBuf: '||errbuf);
92: end REFRESH_BA;
93:
94: -- prints metadata info for user and ba to the screen
95: -- initialize the session with, prior to calling:

Line 264: dbms_output.put_line( 'ALL DIMENSIONS REPORT');

260:
261:
262: BEGIN
263:
264: dbms_output.put_line( 'ALL DIMENSIONS REPORT');
265: dbms_output.put_line( substr(L_COL_DIM_NAME || L_BLANK, 1, 30) || '-' ||
266: substr(L_COL_DIM_OWN || L_BLANK, 1, 10) || '-' ||
267: substr(L_COL_DIM_PCWM || L_BLANK, 1, 30) || '-' ||
268: substr(L_COL_DIM_SCWM || L_BLANK, 1, 30) || '-' ||

Line 265: dbms_output.put_line( substr(L_COL_DIM_NAME || L_BLANK, 1, 30) || '-' ||

261:
262: BEGIN
263:
264: dbms_output.put_line( 'ALL DIMENSIONS REPORT');
265: dbms_output.put_line( substr(L_COL_DIM_NAME || L_BLANK, 1, 30) || '-' ||
266: substr(L_COL_DIM_OWN || L_BLANK, 1, 10) || '-' ||
267: substr(L_COL_DIM_PCWM || L_BLANK, 1, 30) || '-' ||
268: substr(L_COL_DIM_SCWM || L_BLANK, 1, 30) || '-' ||
269: substr(L_COL_DIM_AWNM || L_BLANK, 1, 20) || '-' ||

Line 272: dbms_output.put_line( L_BREAK);

268: substr(L_COL_DIM_SCWM || L_BLANK, 1, 30) || '-' ||
269: substr(L_COL_DIM_AWNM || L_BLANK, 1, 20) || '-' ||
270: substr(L_COL_DIM_HRCN || L_BLANK, 1, 10) || '-' ||
271: substr(L_COL_DIM_EPBID || L_BLANK, 1 , 10));
272: dbms_output.put_line( L_BREAK);
273:
274: for v_dim in c_dimensions loop
275: dbms_output.put_line( substr(v_dim.name || L_BLANK, 1, 30) || ' ' ||
276: substr(v_dim.is_owner_dim || L_BLANK, 1, 10) || ' ' ||

Line 275: dbms_output.put_line( substr(v_dim.name || L_BLANK, 1, 30) || ' ' ||

271: substr(L_COL_DIM_EPBID || L_BLANK, 1 , 10));
272: dbms_output.put_line( L_BREAK);
273:
274: for v_dim in c_dimensions loop
275: dbms_output.put_line( substr(v_dim.name || L_BLANK, 1, 30) || ' ' ||
276: substr(v_dim.is_owner_dim || L_BLANK, 1, 10) || ' ' ||
277: substr(v_dim.pers_cwm_name || L_BLANK, 1, 30) || ' ' ||
278: substr(v_dim.shar_cwm_name || L_BLANK, 1, 30) || ' ' ||
279: substr(v_dim.aw_name || L_BLANK, 1, 20) || ' ' ||

Line 284: dbms_output.put_line( L_BLANK);

280: substr(v_dim.hier_cnt || L_BLANK, 1, 10) || ' ' ||
281: substr(v_dim.epb_id || L_BLANK, 1, 10));
282: end loop;
283:
284: dbms_output.put_line( L_BLANK);
285: dbms_output.put_line( L_BLANK);
286: -- hierarchies for each dim
287: for v_dim in c_dimensions loop
288: l_dim_id := v_dim.dimension_id;

Line 285: dbms_output.put_line( L_BLANK);

281: substr(v_dim.epb_id || L_BLANK, 1, 10));
282: end loop;
283:
284: dbms_output.put_line( L_BLANK);
285: dbms_output.put_line( L_BLANK);
286: -- hierarchies for each dim
287: for v_dim in c_dimensions loop
288: l_dim_id := v_dim.dimension_id;
289: dbms_output.put_line( 'DIMENSION REPORT FOR ' || v_dim.name);

Line 289: dbms_output.put_line( 'DIMENSION REPORT FOR ' || v_dim.name);

285: dbms_output.put_line( L_BLANK);
286: -- hierarchies for each dim
287: for v_dim in c_dimensions loop
288: l_dim_id := v_dim.dimension_id;
289: dbms_output.put_line( 'DIMENSION REPORT FOR ' || v_dim.name);
290: dbms_output.put_line( ' HIERARCHIES REPORT for dimension ' || v_dim.name);
291:
292: dbms_output.put_line( substr(L_COL_HIER_NAME || L_BLANK, 1, 30) || '-' ||
293: substr(L_COL_HIER_TYPE || L_BLANK, 1, 20) || '-' ||

Line 290: dbms_output.put_line( ' HIERARCHIES REPORT for dimension ' || v_dim.name);

286: -- hierarchies for each dim
287: for v_dim in c_dimensions loop
288: l_dim_id := v_dim.dimension_id;
289: dbms_output.put_line( 'DIMENSION REPORT FOR ' || v_dim.name);
290: dbms_output.put_line( ' HIERARCHIES REPORT for dimension ' || v_dim.name);
291:
292: dbms_output.put_line( substr(L_COL_HIER_NAME || L_BLANK, 1, 30) || '-' ||
293: substr(L_COL_HIER_TYPE || L_BLANK, 1, 20) || '-' ||
294: substr(L_COL_HIER_EPB || L_BLANK, 1, 30) || '-' ||

Line 292: dbms_output.put_line( substr(L_COL_HIER_NAME || L_BLANK, 1, 30) || '-' ||

288: l_dim_id := v_dim.dimension_id;
289: dbms_output.put_line( 'DIMENSION REPORT FOR ' || v_dim.name);
290: dbms_output.put_line( ' HIERARCHIES REPORT for dimension ' || v_dim.name);
291:
292: dbms_output.put_line( substr(L_COL_HIER_NAME || L_BLANK, 1, 30) || '-' ||
293: substr(L_COL_HIER_TYPE || L_BLANK, 1, 20) || '-' ||
294: substr(L_COL_HIER_EPB || L_BLANK, 1, 30) || '-' ||
295: substr(L_COL_HIER_SHRT || L_BLANK, 1, 30) || '-' ||
296: substr(L_COL_HIER_PRST || L_BLANK, 1, 30));

Line 297: dbms_output.put_line( L_BREAK);

293: substr(L_COL_HIER_TYPE || L_BLANK, 1, 20) || '-' ||
294: substr(L_COL_HIER_EPB || L_BLANK, 1, 30) || '-' ||
295: substr(L_COL_HIER_SHRT || L_BLANK, 1, 30) || '-' ||
296: substr(L_COL_HIER_PRST || L_BLANK, 1, 30));
297: dbms_output.put_line( L_BREAK);
298:
299: for v_hier in c_hierarchies loop
300: dbms_output.put_line( substr(v_hier.name || L_BLANK, 1, 30) || ' ' ||
301: substr(v_hier.hier_type || L_BLANK, 1, 20) || ' ' ||

Line 300: dbms_output.put_line( substr(v_hier.name || L_BLANK, 1, 30) || ' ' ||

296: substr(L_COL_HIER_PRST || L_BLANK, 1, 30));
297: dbms_output.put_line( L_BREAK);
298:
299: for v_hier in c_hierarchies loop
300: dbms_output.put_line( substr(v_hier.name || L_BLANK, 1, 30) || ' ' ||
301: substr(v_hier.hier_type || L_BLANK, 1, 20) || ' ' ||
302: substr(v_hier.epb_id || L_BLANK, 1, 30) || ' ' ||
303: substr(v_hier.shar_table_name || L_BLANK, 1, 30) || ' ' ||
304: substr(v_hier.pers_table_name || L_BLANK, 1, 30));

Line 307: dbms_output.put_line( L_BLANK);

303: substr(v_hier.shar_table_name || L_BLANK, 1, 30) || ' ' ||
304: substr(v_hier.pers_table_name || L_BLANK, 1, 30));
305: end loop;
306:
307: dbms_output.put_line( L_BLANK);
308: dbms_output.put_line( L_BLANK);
309: for v_hier in c_hierarchies loop
310: l_hier_id := v_hier.hierarchy_id;
311: dbms_output.put_line( ' LEVELS REPORT for hierarchy ' || v_hier.name || ' of dimension ' || v_dim.name);

Line 308: dbms_output.put_line( L_BLANK);

304: substr(v_hier.pers_table_name || L_BLANK, 1, 30));
305: end loop;
306:
307: dbms_output.put_line( L_BLANK);
308: dbms_output.put_line( L_BLANK);
309: for v_hier in c_hierarchies loop
310: l_hier_id := v_hier.hierarchy_id;
311: dbms_output.put_line( ' LEVELS REPORT for hierarchy ' || v_hier.name || ' of dimension ' || v_dim.name);
312: dbms_output.put_line( substr(L_COL_LEVL_NAME || L_BLANK, 1, 30) || '-' ||

Line 311: dbms_output.put_line( ' LEVELS REPORT for hierarchy ' || v_hier.name || ' of dimension ' || v_dim.name);

307: dbms_output.put_line( L_BLANK);
308: dbms_output.put_line( L_BLANK);
309: for v_hier in c_hierarchies loop
310: l_hier_id := v_hier.hierarchy_id;
311: dbms_output.put_line( ' LEVELS REPORT for hierarchy ' || v_hier.name || ' of dimension ' || v_dim.name);
312: dbms_output.put_line( substr(L_COL_LEVL_NAME || L_BLANK, 1, 30) || '-' ||
313: substr(L_COL_LEVL_EPB || L_BLANK, 1, 30) || '-' ||
314: substr(L_COL_LEVL_SHRB || L_BLANK, 1, 30) || '-' ||
315: substr(L_COL_LEVL_PRSB || L_BLANK, 1, 30));

Line 312: dbms_output.put_line( substr(L_COL_LEVL_NAME || L_BLANK, 1, 30) || '-' ||

308: dbms_output.put_line( L_BLANK);
309: for v_hier in c_hierarchies loop
310: l_hier_id := v_hier.hierarchy_id;
311: dbms_output.put_line( ' LEVELS REPORT for hierarchy ' || v_hier.name || ' of dimension ' || v_dim.name);
312: dbms_output.put_line( substr(L_COL_LEVL_NAME || L_BLANK, 1, 30) || '-' ||
313: substr(L_COL_LEVL_EPB || L_BLANK, 1, 30) || '-' ||
314: substr(L_COL_LEVL_SHRB || L_BLANK, 1, 30) || '-' ||
315: substr(L_COL_LEVL_PRSB || L_BLANK, 1, 30));
316: dbms_output.put_line( L_BREAK);

Line 316: dbms_output.put_line( L_BREAK);

312: dbms_output.put_line( substr(L_COL_LEVL_NAME || L_BLANK, 1, 30) || '-' ||
313: substr(L_COL_LEVL_EPB || L_BLANK, 1, 30) || '-' ||
314: substr(L_COL_LEVL_SHRB || L_BLANK, 1, 30) || '-' ||
315: substr(L_COL_LEVL_PRSB || L_BLANK, 1, 30));
316: dbms_output.put_line( L_BREAK);
317:
318: for v_level in c_levels loop
319: dbms_output.put_line(substr(v_level.name || L_BLANK, 1, 30) || ' ' ||
320: substr(v_level.epb_id || L_BLANK, 1, 30) || ' ' ||

Line 319: dbms_output.put_line(substr(v_level.name || L_BLANK, 1, 30) || ' ' ||

315: substr(L_COL_LEVL_PRSB || L_BLANK, 1, 30));
316: dbms_output.put_line( L_BREAK);
317:
318: for v_level in c_levels loop
319: dbms_output.put_line(substr(v_level.name || L_BLANK, 1, 30) || ' ' ||
320: substr(v_level.epb_id || L_BLANK, 1, 30) || ' ' ||
321: substr(v_level.shar_cwm_name || L_BLANK, 1, 30) || ' ' ||
322: substr(v_level.pers_cwm_name || L_BLANK, 1, 30));
323: end loop;

Line 326: dbms_output.put_line( L_BLANK);

322: substr(v_level.pers_cwm_name || L_BLANK, 1, 30));
323: end loop;
324: end loop;
325:
326: dbms_output.put_line( L_BLANK);
327: dbms_output.put_line( L_BLANK);
328: dbms_output.put_line( ' ATTRIBUTES REPORT for dimension ' || v_dim.name);
329: dbms_output.put_line( substr(L_COL_ATTR_NAME || L_BLANK, 1, 50) || '-' ||
330: -- substr(L_COL_ATTR_TYPE || L_BLANK, 1, 15) || '-' ||

Line 327: dbms_output.put_line( L_BLANK);

323: end loop;
324: end loop;
325:
326: dbms_output.put_line( L_BLANK);
327: dbms_output.put_line( L_BLANK);
328: dbms_output.put_line( ' ATTRIBUTES REPORT for dimension ' || v_dim.name);
329: dbms_output.put_line( substr(L_COL_ATTR_NAME || L_BLANK, 1, 50) || '-' ||
330: -- substr(L_COL_ATTR_TYPE || L_BLANK, 1, 15) || '-' ||
331: substr(L_COL_ATTR_LABL || L_BLANK, 1, 15) || '-' ||

Line 328: dbms_output.put_line( ' ATTRIBUTES REPORT for dimension ' || v_dim.name);

324: end loop;
325:
326: dbms_output.put_line( L_BLANK);
327: dbms_output.put_line( L_BLANK);
328: dbms_output.put_line( ' ATTRIBUTES REPORT for dimension ' || v_dim.name);
329: dbms_output.put_line( substr(L_COL_ATTR_NAME || L_BLANK, 1, 50) || '-' ||
330: -- substr(L_COL_ATTR_TYPE || L_BLANK, 1, 15) || '-' ||
331: substr(L_COL_ATTR_LABL || L_BLANK, 1, 15) || '-' ||
332: substr(L_COL_ATTR_CWMP || L_BLANK, 1, 30) || '-' ||

Line 329: dbms_output.put_line( substr(L_COL_ATTR_NAME || L_BLANK, 1, 50) || '-' ||

325:
326: dbms_output.put_line( L_BLANK);
327: dbms_output.put_line( L_BLANK);
328: dbms_output.put_line( ' ATTRIBUTES REPORT for dimension ' || v_dim.name);
329: dbms_output.put_line( substr(L_COL_ATTR_NAME || L_BLANK, 1, 50) || '-' ||
330: -- substr(L_COL_ATTR_TYPE || L_BLANK, 1, 15) || '-' ||
331: substr(L_COL_ATTR_LABL || L_BLANK, 1, 15) || '-' ||
332: substr(L_COL_ATTR_CWMP || L_BLANK, 1, 30) || '-' ||
333: substr(L_COL_ATTR_RNGD || L_BLANK, 1, 30));

Line 334: dbms_output.put_line( L_BREAK);

330: -- substr(L_COL_ATTR_TYPE || L_BLANK, 1, 15) || '-' ||
331: substr(L_COL_ATTR_LABL || L_BLANK, 1, 15) || '-' ||
332: substr(L_COL_ATTR_CWMP || L_BLANK, 1, 30) || '-' ||
333: substr(L_COL_ATTR_RNGD || L_BLANK, 1, 30));
334: dbms_output.put_line( L_BREAK);
335:
336: for v_attr in c_attributes loop
337: dbms_output.put_line( substr(v_attr.name || L_BLANK, 1, 50) || ' ' ||
338: -- substr(v_attr.type || L_BLANK, 1, 15) || ' ' ||

Line 337: dbms_output.put_line( substr(v_attr.name || L_BLANK, 1, 50) || ' ' ||

333: substr(L_COL_ATTR_RNGD || L_BLANK, 1, 30));
334: dbms_output.put_line( L_BREAK);
335:
336: for v_attr in c_attributes loop
337: dbms_output.put_line( substr(v_attr.name || L_BLANK, 1, 50) || ' ' ||
338: -- substr(v_attr.type || L_BLANK, 1, 15) || ' ' ||
339: substr(v_attr.label || L_BLANK, 1, 15) || ' ' ||
340: substr(v_attr.pers_cwm_name || L_BLANK, 1, 30) || ' ' ||
341: substr(v_attr.aw_name || L_BLANK, 1, 30));

Line 344: dbms_output.put_line( L_BLANK);

340: substr(v_attr.pers_cwm_name || L_BLANK, 1, 30) || ' ' ||
341: substr(v_attr.aw_name || L_BLANK, 1, 30));
342: end loop;
343:
344: dbms_output.put_line( L_BLANK);
345: dbms_output.put_line( L_BLANK);
346: end loop;
347:
348: dbms_output.put_line( L_BLANK);

Line 345: dbms_output.put_line( L_BLANK);

341: substr(v_attr.aw_name || L_BLANK, 1, 30));
342: end loop;
343:
344: dbms_output.put_line( L_BLANK);
345: dbms_output.put_line( L_BLANK);
346: end loop;
347:
348: dbms_output.put_line( L_BLANK);
349: dbms_output.put_line( L_BLANK);

Line 348: dbms_output.put_line( L_BLANK);

344: dbms_output.put_line( L_BLANK);
345: dbms_output.put_line( L_BLANK);
346: end loop;
347:
348: dbms_output.put_line( L_BLANK);
349: dbms_output.put_line( L_BLANK);
350: dbms_output.put_line( 'BP INSTANCES REPORT');
351: dbms_output.put_line( substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||
352: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||

Line 349: dbms_output.put_line( L_BLANK);

345: dbms_output.put_line( L_BLANK);
346: end loop;
347:
348: dbms_output.put_line( L_BLANK);
349: dbms_output.put_line( L_BLANK);
350: dbms_output.put_line( 'BP INSTANCES REPORT');
351: dbms_output.put_line( substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||
352: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||
353: substr(L_COL_INST_VIEW || L_BLANK, 1, 30) || ' ' ||

Line 350: dbms_output.put_line( 'BP INSTANCES REPORT');

346: end loop;
347:
348: dbms_output.put_line( L_BLANK);
349: dbms_output.put_line( L_BLANK);
350: dbms_output.put_line( 'BP INSTANCES REPORT');
351: dbms_output.put_line( substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||
352: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||
353: substr(L_COL_INST_VIEW || L_BLANK, 1, 30) || ' ' ||
354: substr(L_COL_INST_CCOL || L_BLANK, 1, 20) || ' ' ||

Line 351: dbms_output.put_line( substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||

347:
348: dbms_output.put_line( L_BLANK);
349: dbms_output.put_line( L_BLANK);
350: dbms_output.put_line( 'BP INSTANCES REPORT');
351: dbms_output.put_line( substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||
352: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||
353: substr(L_COL_INST_VIEW || L_BLANK, 1, 30) || ' ' ||
354: substr(L_COL_INST_CCOL || L_BLANK, 1, 20) || ' ' ||
355: substr(L_COL_INST_DIMS || L_BLANK, 1, 30));

Line 356: dbms_output.put_line( L_BREAK);

352: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||
353: substr(L_COL_INST_VIEW || L_BLANK, 1, 30) || ' ' ||
354: substr(L_COL_INST_CCOL || L_BLANK, 1, 20) || ' ' ||
355: substr(L_COL_INST_DIMS || L_BLANK, 1, 30));
356: dbms_output.put_line( L_BREAK);
357:
358: l_meas_type := 'SHARED_VIEW_DATA';
359: for v_bp_inst in c_bp_instances loop
360: l_cube_id := v_bp_inst.cube_id;

Line 367: dbms_output.put_line( substr(v_bp_inst.meas || L_BLANK, 1, 50) || ' ' ||

363: l_dimensionality := l_dimensionality || v_cube_dim.epb_id || ' ';
364: end loop;
365:
366:
367: dbms_output.put_line( substr(v_bp_inst.meas || L_BLANK, 1, 50) || ' ' ||
368: substr(v_bp_inst.instance_id || L_BLANK, 1, 10) || ' ' ||
369: substr(v_bp_inst.cube || L_BLANK, 1, 30) || ' ' ||
370: substr(v_bp_inst.column_name || L_BLANK, 1, 20) || ' ' ||
371: substr(l_dimensionality || L_BLANK, 1, 30));

Line 374: dbms_output.put_line( L_BLANK);

370: substr(v_bp_inst.column_name || L_BLANK, 1, 20) || ' ' ||
371: substr(l_dimensionality || L_BLANK, 1, 30));
372: end loop;
373:
374: dbms_output.put_line( L_BLANK);
375: dbms_output.put_line( L_BLANK);
376: dbms_output.put_line( 'CONTROLLED CALCS REPORT');
377: dbms_output.put_line( substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||
378: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||

Line 375: dbms_output.put_line( L_BLANK);

371: substr(l_dimensionality || L_BLANK, 1, 30));
372: end loop;
373:
374: dbms_output.put_line( L_BLANK);
375: dbms_output.put_line( L_BLANK);
376: dbms_output.put_line( 'CONTROLLED CALCS REPORT');
377: dbms_output.put_line( substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||
378: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||
379: substr(L_COL_INST_VIEW || L_BLANK, 1, 30) || ' ' ||

Line 376: dbms_output.put_line( 'CONTROLLED CALCS REPORT');

372: end loop;
373:
374: dbms_output.put_line( L_BLANK);
375: dbms_output.put_line( L_BLANK);
376: dbms_output.put_line( 'CONTROLLED CALCS REPORT');
377: dbms_output.put_line( substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||
378: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||
379: substr(L_COL_INST_VIEW || L_BLANK, 1, 30) || ' ' ||
380: substr(L_COL_INST_CCOL || L_BLANK, 1, 20) || ' ' ||

Line 377: dbms_output.put_line( substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||

373:
374: dbms_output.put_line( L_BLANK);
375: dbms_output.put_line( L_BLANK);
376: dbms_output.put_line( 'CONTROLLED CALCS REPORT');
377: dbms_output.put_line( substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||
378: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||
379: substr(L_COL_INST_VIEW || L_BLANK, 1, 30) || ' ' ||
380: substr(L_COL_INST_CCOL || L_BLANK, 1, 20) || ' ' ||
381: substr(L_COL_INST_DIMS || L_BLANK, 1, 30));

Line 382: dbms_output.put_line( L_BREAK);

378: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||
379: substr(L_COL_INST_VIEW || L_BLANK, 1, 30) || ' ' ||
380: substr(L_COL_INST_CCOL || L_BLANK, 1, 20) || ' ' ||
381: substr(L_COL_INST_DIMS || L_BLANK, 1, 30));
382: dbms_output.put_line( L_BREAK);
383: l_meas_type := 'SHARED_VIEW_CALC';
384: for v_bp_inst in c_bp_instances loop
385: l_cube_id := v_bp_inst.cube_id;
386: l_dimensionality := '';

Line 392: dbms_output.put_line( substr(v_bp_inst.meas || L_BLANK, 1, 50) || ' ' ||

388: l_dimensionality := l_dimensionality || v_cube_dim.epb_id || ' ';
389: end loop;
390:
391:
392: dbms_output.put_line( substr(v_bp_inst.meas || L_BLANK, 1, 50) || ' ' ||
393: substr(v_bp_inst.instance_id || L_BLANK, 1, 10) || ' ' ||
394: substr(v_bp_inst.cube || L_BLANK, 1, 30) || ' ' ||
395: substr(v_bp_inst.column_name || L_BLANK, 1, 20) || ' ' ||
396: substr(l_dimensionality || L_BLANK, 1, 30));

Line 402: dbms_output.put_line( L_BLANK);

398:
399: -- User Specific Reports
400: if p_user_id <> 0 then
401:
402: dbms_output.put_line( L_BLANK);
403: dbms_output.put_line( L_BLANK);
404: dbms_output.put_line( 'ANALYST CALCS REPORT');
405: dbms_output.put_line( substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||
406: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||

Line 403: dbms_output.put_line( L_BLANK);

399: -- User Specific Reports
400: if p_user_id <> 0 then
401:
402: dbms_output.put_line( L_BLANK);
403: dbms_output.put_line( L_BLANK);
404: dbms_output.put_line( 'ANALYST CALCS REPORT');
405: dbms_output.put_line( substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||
406: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||
407: substr(L_COL_INST_VIEW || L_BLANK, 1, 30) || ' ' ||

Line 404: dbms_output.put_line( 'ANALYST CALCS REPORT');

400: if p_user_id <> 0 then
401:
402: dbms_output.put_line( L_BLANK);
403: dbms_output.put_line( L_BLANK);
404: dbms_output.put_line( 'ANALYST CALCS REPORT');
405: dbms_output.put_line( substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||
406: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||
407: substr(L_COL_INST_VIEW || L_BLANK, 1, 30) || ' ' ||
408: substr(L_COL_INST_CCOL || L_BLANK, 1, 20) || ' ' ||

Line 405: dbms_output.put_line( substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||

401:
402: dbms_output.put_line( L_BLANK);
403: dbms_output.put_line( L_BLANK);
404: dbms_output.put_line( 'ANALYST CALCS REPORT');
405: dbms_output.put_line( substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||
406: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||
407: substr(L_COL_INST_VIEW || L_BLANK, 1, 30) || ' ' ||
408: substr(L_COL_INST_CCOL || L_BLANK, 1, 20) || ' ' ||
409: substr(L_COL_INST_DIMS || L_BLANK, 1, 30));

Line 410: dbms_output.put_line( L_BREAK);

406: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||
407: substr(L_COL_INST_VIEW || L_BLANK, 1, 30) || ' ' ||
408: substr(L_COL_INST_CCOL || L_BLANK, 1, 20) || ' ' ||
409: substr(L_COL_INST_DIMS || L_BLANK, 1, 30));
410: dbms_output.put_line( L_BREAK);
411: l_meas_type := 'PERSONAL_CALC';
412: for v_prs_inst in c_prs_instances loop
413: l_cube_id := v_prs_inst.cube_id;
414: l_dimensionality := '';

Line 420: dbms_output.put_line( substr(v_prs_inst.meas || L_BLANK, 1, 50) || ' ' ||

416: l_dimensionality := l_dimensionality || v_cube_dim.epb_id || ' ';
417: end loop;
418:
419:
420: dbms_output.put_line( substr(v_prs_inst.meas || L_BLANK, 1, 50) || ' ' ||
421: substr(v_prs_inst.instance_id || L_BLANK, 1, 10) || ' ' ||
422: substr(v_prs_inst.cube || L_BLANK, 1, 30) || ' ' ||
423: substr(v_prs_inst.column_name || L_BLANK, 1, 20) || ' ' ||
424: substr(l_dimensionality || L_BLANK, 1, 30));

Line 427: dbms_output.put_line( L_BLANK);

423: substr(v_prs_inst.column_name || L_BLANK, 1, 20) || ' ' ||
424: substr(l_dimensionality || L_BLANK, 1, 30));
425: end loop;
426:
427: dbms_output.put_line( L_BLANK);
428: dbms_output.put_line( L_BLANK);
429: dbms_output.put_line( 'WORKSHEETS REPORT (only those worksheets that have been opened at least once will appear)');
430: dbms_output.put_line( substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||
431: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||

Line 428: dbms_output.put_line( L_BLANK);

424: substr(l_dimensionality || L_BLANK, 1, 30));
425: end loop;
426:
427: dbms_output.put_line( L_BLANK);
428: dbms_output.put_line( L_BLANK);
429: dbms_output.put_line( 'WORKSHEETS REPORT (only those worksheets that have been opened at least once will appear)');
430: dbms_output.put_line( substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||
431: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||
432: substr(L_COL_INST_VIEW || L_BLANK, 1, 30) || ' ' ||

Line 429: dbms_output.put_line( 'WORKSHEETS REPORT (only those worksheets that have been opened at least once will appear)');

425: end loop;
426:
427: dbms_output.put_line( L_BLANK);
428: dbms_output.put_line( L_BLANK);
429: dbms_output.put_line( 'WORKSHEETS REPORT (only those worksheets that have been opened at least once will appear)');
430: dbms_output.put_line( substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||
431: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||
432: substr(L_COL_INST_VIEW || L_BLANK, 1, 30) || ' ' ||
433: substr(L_COL_INST_CCOL || L_BLANK, 1, 20) || ' ' ||

Line 430: dbms_output.put_line( substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||

426:
427: dbms_output.put_line( L_BLANK);
428: dbms_output.put_line( L_BLANK);
429: dbms_output.put_line( 'WORKSHEETS REPORT (only those worksheets that have been opened at least once will appear)');
430: dbms_output.put_line( substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||
431: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||
432: substr(L_COL_INST_VIEW || L_BLANK, 1, 30) || ' ' ||
433: substr(L_COL_INST_CCOL || L_BLANK, 1, 20) || ' ' ||
434: substr(L_COL_INST_DIMS || L_BLANK, 1, 30));

Line 435: dbms_output.put_line( L_BREAK);

431: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||
432: substr(L_COL_INST_VIEW || L_BLANK, 1, 30) || ' ' ||
433: substr(L_COL_INST_CCOL || L_BLANK, 1, 20) || ' ' ||
434: substr(L_COL_INST_DIMS || L_BLANK, 1, 30));
435: dbms_output.put_line( L_BREAK);
436: l_meas_type := 'PERSONAL_DATA';
437: for v_prs_inst in c_prs_instances loop
438: l_cube_id := v_prs_inst.cube_id;
439: l_dimensionality := '';

Line 445: dbms_output.put_line( substr(v_prs_inst.meas || L_BLANK, 1, 50) || ' ' ||

441: l_dimensionality := l_dimensionality || v_cube_dim.epb_id || ' ';
442: end loop;
443:
444:
445: dbms_output.put_line( substr(v_prs_inst.meas || L_BLANK, 1, 50) || ' ' ||
446: substr(v_prs_inst.instance_id || L_BLANK, 1, 10) || ' ' ||
447: substr(v_prs_inst.cube || L_BLANK, 1, 30) || ' ' ||
448: substr(v_prs_inst.column_name || L_BLANK, 1, 20) || ' ' ||
449: substr(l_dimensionality || L_BLANK, 1, 30));

Line 452: dbms_output.put_line( L_BLANK);

448: substr(v_prs_inst.column_name || L_BLANK, 1, 20) || ' ' ||
449: substr(l_dimensionality || L_BLANK, 1, 30));
450: end loop;
451:
452: dbms_output.put_line( L_BLANK);
453: dbms_output.put_line( L_BLANK);
454: dbms_output.put_line( 'APPROVER WORKSHEETS REPORT (only those worksheets that have been opened at least once will appear)');
455: dbms_output.put_line( substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||
456: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||

Line 453: dbms_output.put_line( L_BLANK);

449: substr(l_dimensionality || L_BLANK, 1, 30));
450: end loop;
451:
452: dbms_output.put_line( L_BLANK);
453: dbms_output.put_line( L_BLANK);
454: dbms_output.put_line( 'APPROVER WORKSHEETS REPORT (only those worksheets that have been opened at least once will appear)');
455: dbms_output.put_line( substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||
456: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||
457: substr(L_COL_INST_VIEW || L_BLANK, 1, 30) || ' ' ||

Line 454: dbms_output.put_line( 'APPROVER WORKSHEETS REPORT (only those worksheets that have been opened at least once will appear)');

450: end loop;
451:
452: dbms_output.put_line( L_BLANK);
453: dbms_output.put_line( L_BLANK);
454: dbms_output.put_line( 'APPROVER WORKSHEETS REPORT (only those worksheets that have been opened at least once will appear)');
455: dbms_output.put_line( substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||
456: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||
457: substr(L_COL_INST_VIEW || L_BLANK, 1, 30) || ' ' ||
458: substr(L_COL_INST_CCOL || L_BLANK, 1, 20) || ' ' ||

Line 455: dbms_output.put_line( substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||

451:
452: dbms_output.put_line( L_BLANK);
453: dbms_output.put_line( L_BLANK);
454: dbms_output.put_line( 'APPROVER WORKSHEETS REPORT (only those worksheets that have been opened at least once will appear)');
455: dbms_output.put_line( substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||
456: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||
457: substr(L_COL_INST_VIEW || L_BLANK, 1, 30) || ' ' ||
458: substr(L_COL_INST_CCOL || L_BLANK, 1, 20) || ' ' ||
459: substr(L_COL_INST_DIMS || L_BLANK, 1, 30));

Line 460: dbms_output.put_line( L_BREAK);

456: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||
457: substr(L_COL_INST_VIEW || L_BLANK, 1, 30) || ' ' ||
458: substr(L_COL_INST_CCOL || L_BLANK, 1, 20) || ' ' ||
459: substr(L_COL_INST_DIMS || L_BLANK, 1, 30));
460: dbms_output.put_line( L_BREAK);
461: l_meas_type := 'APPROVER_DATA';
462: for v_prs_inst in c_prs_instances loop
463: l_cube_id := v_prs_inst.cube_id;
464: l_dimensionality := '';

Line 470: dbms_output.put_line( substr(v_prs_inst.meas || L_BLANK, 1, 50) || ' ' ||

466: l_dimensionality := l_dimensionality || v_cube_dim.epb_id || ' ';
467: end loop;
468:
469:
470: dbms_output.put_line( substr(v_prs_inst.meas || L_BLANK, 1, 50) || ' ' ||
471: substr(v_prs_inst.instance_id || L_BLANK, 1, 10) || ' ' ||
472: substr(v_prs_inst.cube || L_BLANK, 1, 30) || ' ' ||
473: substr(v_prs_inst.column_name || L_BLANK, 1, 20) || ' ' ||
474: substr(l_dimensionality || L_BLANK, 1, 30));