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 UTL_FILE

Line 487: file1 utl_file.file_type;

483: p_file_dir in varchar2,
484: p_file_name in varchar2)
485: is
486: var1 number;
487: file1 utl_file.file_type;
488: file2 utl_file.file_type;
489:
490: CURSOR c_dimensions is
491: select dvl.name,

Line 488: file2 utl_file.file_type;

484: p_file_name in varchar2)
485: is
486: var1 number;
487: file1 utl_file.file_type;
488: file2 utl_file.file_type;
489:
490: CURSOR c_dimensions is
491: select dvl.name,
492: dvl.is_owner_dim,

Line 648: file1 := utl_file.fopen(p_file_dir, p_file_name, 'w');

644:
645:
646: BEGIN
647:
648: file1 := utl_file.fopen(p_file_dir, p_file_name, 'w');
649:
650: UTL_FILE.PUT_LINE(file1, 'ALL DIMENSIONS REPORT');
651: UTL_FILE.PUT_LINE(file1, substr(L_COL_DIM_NAME || L_BLANK, 1, 30) || '-' ||
652: substr(L_COL_DIM_OWN || L_BLANK, 1, 10) || '-' ||

Line 650: UTL_FILE.PUT_LINE(file1, 'ALL DIMENSIONS REPORT');

646: BEGIN
647:
648: file1 := utl_file.fopen(p_file_dir, p_file_name, 'w');
649:
650: UTL_FILE.PUT_LINE(file1, 'ALL DIMENSIONS REPORT');
651: UTL_FILE.PUT_LINE(file1, substr(L_COL_DIM_NAME || L_BLANK, 1, 30) || '-' ||
652: substr(L_COL_DIM_OWN || L_BLANK, 1, 10) || '-' ||
653: substr(L_COL_DIM_PCWM || L_BLANK, 1, 30) || '-' ||
654: substr(L_COL_DIM_SCWM || L_BLANK, 1, 30) || '-' ||

Line 651: UTL_FILE.PUT_LINE(file1, substr(L_COL_DIM_NAME || L_BLANK, 1, 30) || '-' ||

647:
648: file1 := utl_file.fopen(p_file_dir, p_file_name, 'w');
649:
650: UTL_FILE.PUT_LINE(file1, 'ALL DIMENSIONS REPORT');
651: UTL_FILE.PUT_LINE(file1, substr(L_COL_DIM_NAME || L_BLANK, 1, 30) || '-' ||
652: substr(L_COL_DIM_OWN || L_BLANK, 1, 10) || '-' ||
653: substr(L_COL_DIM_PCWM || L_BLANK, 1, 30) || '-' ||
654: substr(L_COL_DIM_SCWM || L_BLANK, 1, 30) || '-' ||
655: substr(L_COL_DIM_AWNM || L_BLANK, 1, 20) || '-' ||

Line 658: UTL_FILE.PUT_LINE(file1, L_BREAK);

654: substr(L_COL_DIM_SCWM || L_BLANK, 1, 30) || '-' ||
655: substr(L_COL_DIM_AWNM || L_BLANK, 1, 20) || '-' ||
656: substr(L_COL_DIM_HRCN || L_BLANK, 1, 10) || '-' ||
657: substr(L_COL_DIM_EPBID || L_BLANK, 1 , 10));
658: UTL_FILE.PUT_LINE(file1, L_BREAK);
659:
660: for v_dim in c_dimensions loop
661: UTL_FILE.PUT_LINE(file1, substr(v_dim.name || L_BLANK, 1, 30) || ' ' ||
662: substr(v_dim.is_owner_dim || L_BLANK, 1, 10) || ' ' ||

Line 661: UTL_FILE.PUT_LINE(file1, substr(v_dim.name || L_BLANK, 1, 30) || ' ' ||

657: substr(L_COL_DIM_EPBID || L_BLANK, 1 , 10));
658: UTL_FILE.PUT_LINE(file1, L_BREAK);
659:
660: for v_dim in c_dimensions loop
661: UTL_FILE.PUT_LINE(file1, substr(v_dim.name || L_BLANK, 1, 30) || ' ' ||
662: substr(v_dim.is_owner_dim || L_BLANK, 1, 10) || ' ' ||
663: substr(v_dim.pers_cwm_name || L_BLANK, 1, 30) || ' ' ||
664: substr(v_dim.shar_cwm_name || L_BLANK, 1, 30) || ' ' ||
665: substr(v_dim.aw_name || L_BLANK, 1, 20) || ' ' ||

Line 670: UTL_FILE.PUT_LINE(file1, L_BLANK);

666: substr(v_dim.hier_cnt || L_BLANK, 1, 10) || ' ' ||
667: substr(v_dim.epb_id || L_BLANK, 1, 10));
668: end loop;
669:
670: UTL_FILE.PUT_LINE(file1, L_BLANK);
671: UTL_FILE.PUT_LINE(file1, L_BLANK);
672: -- hierarchies for each dim
673: for v_dim in c_dimensions loop
674: l_dim_id := v_dim.dimension_id;

Line 671: UTL_FILE.PUT_LINE(file1, L_BLANK);

667: substr(v_dim.epb_id || L_BLANK, 1, 10));
668: end loop;
669:
670: UTL_FILE.PUT_LINE(file1, L_BLANK);
671: UTL_FILE.PUT_LINE(file1, L_BLANK);
672: -- hierarchies for each dim
673: for v_dim in c_dimensions loop
674: l_dim_id := v_dim.dimension_id;
675: UTL_FILE.PUT_LINE(file1, 'DIMENSION REPORT FOR ' || v_dim.name);

Line 675: UTL_FILE.PUT_LINE(file1, 'DIMENSION REPORT FOR ' || v_dim.name);

671: UTL_FILE.PUT_LINE(file1, L_BLANK);
672: -- hierarchies for each dim
673: for v_dim in c_dimensions loop
674: l_dim_id := v_dim.dimension_id;
675: UTL_FILE.PUT_LINE(file1, 'DIMENSION REPORT FOR ' || v_dim.name);
676: UTL_FILE.PUT_LINE(file1, ' HIERARCHIES REPORT for dimension ' || v_dim.name);
677:
678: UTL_FILE.PUT_LINE(file1, substr(L_COL_HIER_NAME || L_BLANK, 1, 30) || '-' ||
679: substr(L_COL_HIER_TYPE || L_BLANK, 1, 20) || '-' ||

Line 676: UTL_FILE.PUT_LINE(file1, ' HIERARCHIES REPORT for dimension ' || v_dim.name);

672: -- hierarchies for each dim
673: for v_dim in c_dimensions loop
674: l_dim_id := v_dim.dimension_id;
675: UTL_FILE.PUT_LINE(file1, 'DIMENSION REPORT FOR ' || v_dim.name);
676: UTL_FILE.PUT_LINE(file1, ' HIERARCHIES REPORT for dimension ' || v_dim.name);
677:
678: UTL_FILE.PUT_LINE(file1, substr(L_COL_HIER_NAME || L_BLANK, 1, 30) || '-' ||
679: substr(L_COL_HIER_TYPE || L_BLANK, 1, 20) || '-' ||
680: substr(L_COL_HIER_EPB || L_BLANK, 1, 30) || '-' ||

Line 678: UTL_FILE.PUT_LINE(file1, substr(L_COL_HIER_NAME || L_BLANK, 1, 30) || '-' ||

674: l_dim_id := v_dim.dimension_id;
675: UTL_FILE.PUT_LINE(file1, 'DIMENSION REPORT FOR ' || v_dim.name);
676: UTL_FILE.PUT_LINE(file1, ' HIERARCHIES REPORT for dimension ' || v_dim.name);
677:
678: UTL_FILE.PUT_LINE(file1, substr(L_COL_HIER_NAME || L_BLANK, 1, 30) || '-' ||
679: substr(L_COL_HIER_TYPE || L_BLANK, 1, 20) || '-' ||
680: substr(L_COL_HIER_EPB || L_BLANK, 1, 30) || '-' ||
681: substr(L_COL_HIER_SHRT || L_BLANK, 1, 30) || '-' ||
682: substr(L_COL_HIER_PRST || L_BLANK, 1, 30));

Line 683: UTL_FILE.PUT_LINE(file1, L_BREAK);

679: substr(L_COL_HIER_TYPE || L_BLANK, 1, 20) || '-' ||
680: substr(L_COL_HIER_EPB || L_BLANK, 1, 30) || '-' ||
681: substr(L_COL_HIER_SHRT || L_BLANK, 1, 30) || '-' ||
682: substr(L_COL_HIER_PRST || L_BLANK, 1, 30));
683: UTL_FILE.PUT_LINE(file1, L_BREAK);
684:
685: for v_hier in c_hierarchies loop
686: UTL_FILE.PUT_LINE(file1, substr(v_hier.name || L_BLANK, 1, 30) || ' ' ||
687: substr(v_hier.hier_type || L_BLANK, 1, 20) || ' ' ||

Line 686: UTL_FILE.PUT_LINE(file1, substr(v_hier.name || L_BLANK, 1, 30) || ' ' ||

682: substr(L_COL_HIER_PRST || L_BLANK, 1, 30));
683: UTL_FILE.PUT_LINE(file1, L_BREAK);
684:
685: for v_hier in c_hierarchies loop
686: UTL_FILE.PUT_LINE(file1, substr(v_hier.name || L_BLANK, 1, 30) || ' ' ||
687: substr(v_hier.hier_type || L_BLANK, 1, 20) || ' ' ||
688: substr(v_hier.epb_id || L_BLANK, 1, 30) || ' ' ||
689: substr(v_hier.shar_table_name || L_BLANK, 1, 30) || ' ' ||
690: substr(v_hier.pers_table_name || L_BLANK, 1, 30));

Line 693: UTL_FILE.PUT_LINE(file1, L_BLANK);

689: substr(v_hier.shar_table_name || L_BLANK, 1, 30) || ' ' ||
690: substr(v_hier.pers_table_name || L_BLANK, 1, 30));
691: end loop;
692:
693: UTL_FILE.PUT_LINE(file1, L_BLANK);
694: UTL_FILE.PUT_LINE(file1, L_BLANK);
695: for v_hier in c_hierarchies loop
696: l_hier_id := v_hier.hierarchy_id;
697: UTL_FILE.PUT_LINE(file1, ' LEVELS REPORT for hierarchy ' || v_hier.name || ' of dimension ' || v_dim.name);

Line 694: UTL_FILE.PUT_LINE(file1, L_BLANK);

690: substr(v_hier.pers_table_name || L_BLANK, 1, 30));
691: end loop;
692:
693: UTL_FILE.PUT_LINE(file1, L_BLANK);
694: UTL_FILE.PUT_LINE(file1, L_BLANK);
695: for v_hier in c_hierarchies loop
696: l_hier_id := v_hier.hierarchy_id;
697: UTL_FILE.PUT_LINE(file1, ' LEVELS REPORT for hierarchy ' || v_hier.name || ' of dimension ' || v_dim.name);
698: UTL_FILE.PUT_LINE(file1, substr(L_COL_LEVL_NAME || L_BLANK, 1, 30) || '-' ||

Line 697: UTL_FILE.PUT_LINE(file1, ' LEVELS REPORT for hierarchy ' || v_hier.name || ' of dimension ' || v_dim.name);

693: UTL_FILE.PUT_LINE(file1, L_BLANK);
694: UTL_FILE.PUT_LINE(file1, L_BLANK);
695: for v_hier in c_hierarchies loop
696: l_hier_id := v_hier.hierarchy_id;
697: UTL_FILE.PUT_LINE(file1, ' LEVELS REPORT for hierarchy ' || v_hier.name || ' of dimension ' || v_dim.name);
698: UTL_FILE.PUT_LINE(file1, substr(L_COL_LEVL_NAME || L_BLANK, 1, 30) || '-' ||
699: substr(L_COL_LEVL_EPB || L_BLANK, 1, 30) || '-' ||
700: substr(L_COL_LEVL_SHRB || L_BLANK, 1, 30) || '-' ||
701: substr(L_COL_LEVL_PRSB || L_BLANK, 1, 30));

Line 698: UTL_FILE.PUT_LINE(file1, substr(L_COL_LEVL_NAME || L_BLANK, 1, 30) || '-' ||

694: UTL_FILE.PUT_LINE(file1, L_BLANK);
695: for v_hier in c_hierarchies loop
696: l_hier_id := v_hier.hierarchy_id;
697: UTL_FILE.PUT_LINE(file1, ' LEVELS REPORT for hierarchy ' || v_hier.name || ' of dimension ' || v_dim.name);
698: UTL_FILE.PUT_LINE(file1, substr(L_COL_LEVL_NAME || L_BLANK, 1, 30) || '-' ||
699: substr(L_COL_LEVL_EPB || L_BLANK, 1, 30) || '-' ||
700: substr(L_COL_LEVL_SHRB || L_BLANK, 1, 30) || '-' ||
701: substr(L_COL_LEVL_PRSB || L_BLANK, 1, 30));
702: UTL_FILE.PUT_LINE(file1, L_BREAK);

Line 702: UTL_FILE.PUT_LINE(file1, L_BREAK);

698: UTL_FILE.PUT_LINE(file1, substr(L_COL_LEVL_NAME || L_BLANK, 1, 30) || '-' ||
699: substr(L_COL_LEVL_EPB || L_BLANK, 1, 30) || '-' ||
700: substr(L_COL_LEVL_SHRB || L_BLANK, 1, 30) || '-' ||
701: substr(L_COL_LEVL_PRSB || L_BLANK, 1, 30));
702: UTL_FILE.PUT_LINE(file1, L_BREAK);
703:
704: for v_level in c_levels loop
705: UTL_FILE.PUT_LINE(file1,substr(v_level.name || L_BLANK, 1, 30) || ' ' ||
706: substr(v_level.epb_id || L_BLANK, 1, 30) || ' ' ||

Line 705: UTL_FILE.PUT_LINE(file1,substr(v_level.name || L_BLANK, 1, 30) || ' ' ||

701: substr(L_COL_LEVL_PRSB || L_BLANK, 1, 30));
702: UTL_FILE.PUT_LINE(file1, L_BREAK);
703:
704: for v_level in c_levels loop
705: UTL_FILE.PUT_LINE(file1,substr(v_level.name || L_BLANK, 1, 30) || ' ' ||
706: substr(v_level.epb_id || L_BLANK, 1, 30) || ' ' ||
707: substr(v_level.shar_cwm_name || L_BLANK, 1, 30) || ' ' ||
708: substr(v_level.pers_cwm_name || L_BLANK, 1, 30));
709: end loop;

Line 712: UTL_FILE.PUT_LINE(file1, L_BLANK);

708: substr(v_level.pers_cwm_name || L_BLANK, 1, 30));
709: end loop;
710: end loop;
711:
712: UTL_FILE.PUT_LINE(file1, L_BLANK);
713: UTL_FILE.PUT_LINE(file1, L_BLANK);
714: UTL_FILE.PUT_LINE(file1, ' ATTRIBUTES REPORT for dimension ' || v_dim.name);
715: UTL_FILE.PUT_LINE(file1, substr(L_COL_ATTR_NAME || L_BLANK, 1, 50) || '-' ||
716: -- substr(L_COL_ATTR_TYPE || L_BLANK, 1, 15) || '-' ||

Line 713: UTL_FILE.PUT_LINE(file1, L_BLANK);

709: end loop;
710: end loop;
711:
712: UTL_FILE.PUT_LINE(file1, L_BLANK);
713: UTL_FILE.PUT_LINE(file1, L_BLANK);
714: UTL_FILE.PUT_LINE(file1, ' ATTRIBUTES REPORT for dimension ' || v_dim.name);
715: UTL_FILE.PUT_LINE(file1, substr(L_COL_ATTR_NAME || L_BLANK, 1, 50) || '-' ||
716: -- substr(L_COL_ATTR_TYPE || L_BLANK, 1, 15) || '-' ||
717: substr(L_COL_ATTR_LABL || L_BLANK, 1, 15) || '-' ||

Line 714: UTL_FILE.PUT_LINE(file1, ' ATTRIBUTES REPORT for dimension ' || v_dim.name);

710: end loop;
711:
712: UTL_FILE.PUT_LINE(file1, L_BLANK);
713: UTL_FILE.PUT_LINE(file1, L_BLANK);
714: UTL_FILE.PUT_LINE(file1, ' ATTRIBUTES REPORT for dimension ' || v_dim.name);
715: UTL_FILE.PUT_LINE(file1, substr(L_COL_ATTR_NAME || L_BLANK, 1, 50) || '-' ||
716: -- substr(L_COL_ATTR_TYPE || L_BLANK, 1, 15) || '-' ||
717: substr(L_COL_ATTR_LABL || L_BLANK, 1, 15) || '-' ||
718: substr(L_COL_ATTR_CWMP || L_BLANK, 1, 30) || '-' ||

Line 715: UTL_FILE.PUT_LINE(file1, substr(L_COL_ATTR_NAME || L_BLANK, 1, 50) || '-' ||

711:
712: UTL_FILE.PUT_LINE(file1, L_BLANK);
713: UTL_FILE.PUT_LINE(file1, L_BLANK);
714: UTL_FILE.PUT_LINE(file1, ' ATTRIBUTES REPORT for dimension ' || v_dim.name);
715: UTL_FILE.PUT_LINE(file1, substr(L_COL_ATTR_NAME || L_BLANK, 1, 50) || '-' ||
716: -- substr(L_COL_ATTR_TYPE || L_BLANK, 1, 15) || '-' ||
717: substr(L_COL_ATTR_LABL || L_BLANK, 1, 15) || '-' ||
718: substr(L_COL_ATTR_CWMP || L_BLANK, 1, 30) || '-' ||
719: substr(L_COL_ATTR_RNGD || L_BLANK, 1, 30));

Line 720: UTL_FILE.PUT_LINE(file1, L_BREAK);

716: -- substr(L_COL_ATTR_TYPE || L_BLANK, 1, 15) || '-' ||
717: substr(L_COL_ATTR_LABL || L_BLANK, 1, 15) || '-' ||
718: substr(L_COL_ATTR_CWMP || L_BLANK, 1, 30) || '-' ||
719: substr(L_COL_ATTR_RNGD || L_BLANK, 1, 30));
720: UTL_FILE.PUT_LINE(file1, L_BREAK);
721:
722: for v_attr in c_attributes loop
723: UTL_FILE.PUT_LINE(file1, substr(v_attr.name || L_BLANK, 1, 50) || ' ' ||
724: -- substr(v_attr.type || L_BLANK, 1, 15) || ' ' ||

Line 723: UTL_FILE.PUT_LINE(file1, substr(v_attr.name || L_BLANK, 1, 50) || ' ' ||

719: substr(L_COL_ATTR_RNGD || L_BLANK, 1, 30));
720: UTL_FILE.PUT_LINE(file1, L_BREAK);
721:
722: for v_attr in c_attributes loop
723: UTL_FILE.PUT_LINE(file1, substr(v_attr.name || L_BLANK, 1, 50) || ' ' ||
724: -- substr(v_attr.type || L_BLANK, 1, 15) || ' ' ||
725: substr(v_attr.label || L_BLANK, 1, 15) || ' ' ||
726: substr(v_attr.pers_cwm_name || L_BLANK, 1, 30) || ' ' ||
727: substr(v_attr.aw_name || L_BLANK, 1, 30));

Line 730: UTL_FILE.PUT_LINE(file1, L_BLANK);

726: substr(v_attr.pers_cwm_name || L_BLANK, 1, 30) || ' ' ||
727: substr(v_attr.aw_name || L_BLANK, 1, 30));
728: end loop;
729:
730: UTL_FILE.PUT_LINE(file1, L_BLANK);
731: UTL_FILE.PUT_LINE(file1, L_BLANK);
732: end loop;
733:
734: UTL_FILE.PUT_LINE(file1, L_BLANK);

Line 731: UTL_FILE.PUT_LINE(file1, L_BLANK);

727: substr(v_attr.aw_name || L_BLANK, 1, 30));
728: end loop;
729:
730: UTL_FILE.PUT_LINE(file1, L_BLANK);
731: UTL_FILE.PUT_LINE(file1, L_BLANK);
732: end loop;
733:
734: UTL_FILE.PUT_LINE(file1, L_BLANK);
735: UTL_FILE.PUT_LINE(file1, L_BLANK);

Line 734: UTL_FILE.PUT_LINE(file1, L_BLANK);

730: UTL_FILE.PUT_LINE(file1, L_BLANK);
731: UTL_FILE.PUT_LINE(file1, L_BLANK);
732: end loop;
733:
734: UTL_FILE.PUT_LINE(file1, L_BLANK);
735: UTL_FILE.PUT_LINE(file1, L_BLANK);
736: UTL_FILE.PUT_LINE(file1, 'BP INSTANCES REPORT');
737: UTL_FILE.PUT_LINE(file1, substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||
738: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||

Line 735: UTL_FILE.PUT_LINE(file1, L_BLANK);

731: UTL_FILE.PUT_LINE(file1, L_BLANK);
732: end loop;
733:
734: UTL_FILE.PUT_LINE(file1, L_BLANK);
735: UTL_FILE.PUT_LINE(file1, L_BLANK);
736: UTL_FILE.PUT_LINE(file1, 'BP INSTANCES REPORT');
737: UTL_FILE.PUT_LINE(file1, substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||
738: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||
739: substr(L_COL_INST_VIEW || L_BLANK, 1, 30) || ' ' ||

Line 736: UTL_FILE.PUT_LINE(file1, 'BP INSTANCES REPORT');

732: end loop;
733:
734: UTL_FILE.PUT_LINE(file1, L_BLANK);
735: UTL_FILE.PUT_LINE(file1, L_BLANK);
736: UTL_FILE.PUT_LINE(file1, 'BP INSTANCES REPORT');
737: UTL_FILE.PUT_LINE(file1, substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||
738: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||
739: substr(L_COL_INST_VIEW || L_BLANK, 1, 30) || ' ' ||
740: substr(L_COL_INST_CCOL || L_BLANK, 1, 20) || ' ' ||

Line 737: UTL_FILE.PUT_LINE(file1, substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||

733:
734: UTL_FILE.PUT_LINE(file1, L_BLANK);
735: UTL_FILE.PUT_LINE(file1, L_BLANK);
736: UTL_FILE.PUT_LINE(file1, 'BP INSTANCES REPORT');
737: UTL_FILE.PUT_LINE(file1, substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||
738: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||
739: substr(L_COL_INST_VIEW || L_BLANK, 1, 30) || ' ' ||
740: substr(L_COL_INST_CCOL || L_BLANK, 1, 20) || ' ' ||
741: substr(L_COL_INST_DIMS || L_BLANK, 1, 30));

Line 742: UTL_FILE.PUT_LINE(file1, L_BREAK);

738: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||
739: substr(L_COL_INST_VIEW || L_BLANK, 1, 30) || ' ' ||
740: substr(L_COL_INST_CCOL || L_BLANK, 1, 20) || ' ' ||
741: substr(L_COL_INST_DIMS || L_BLANK, 1, 30));
742: UTL_FILE.PUT_LINE(file1, L_BREAK);
743:
744: l_meas_type := 'SHARED_VIEW_DATA';
745: for v_bp_inst in c_bp_instances loop
746: l_cube_id := v_bp_inst.cube_id;

Line 753: UTL_FILE.PUT_LINE(file1, substr(v_bp_inst.meas || L_BLANK, 1, 50) || ' ' ||

749: l_dimensionality := l_dimensionality || v_cube_dim.epb_id || ' ';
750: end loop;
751:
752:
753: UTL_FILE.PUT_LINE(file1, substr(v_bp_inst.meas || L_BLANK, 1, 50) || ' ' ||
754: substr(v_bp_inst.instance_id || L_BLANK, 1, 10) || ' ' ||
755: substr(v_bp_inst.cube || L_BLANK, 1, 30) || ' ' ||
756: substr(v_bp_inst.column_name || L_BLANK, 1, 20) || ' ' ||
757: substr(l_dimensionality || L_BLANK, 1, 30));

Line 760: UTL_FILE.PUT_LINE(file1, L_BLANK);

756: substr(v_bp_inst.column_name || L_BLANK, 1, 20) || ' ' ||
757: substr(l_dimensionality || L_BLANK, 1, 30));
758: end loop;
759:
760: UTL_FILE.PUT_LINE(file1, L_BLANK);
761: UTL_FILE.PUT_LINE(file1, L_BLANK);
762: UTL_FILE.PUT_LINE(file1, 'CONTROLLED CALCS REPORT');
763: UTL_FILE.PUT_LINE(file1, substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||
764: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||

Line 761: UTL_FILE.PUT_LINE(file1, L_BLANK);

757: substr(l_dimensionality || L_BLANK, 1, 30));
758: end loop;
759:
760: UTL_FILE.PUT_LINE(file1, L_BLANK);
761: UTL_FILE.PUT_LINE(file1, L_BLANK);
762: UTL_FILE.PUT_LINE(file1, 'CONTROLLED CALCS REPORT');
763: UTL_FILE.PUT_LINE(file1, substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||
764: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||
765: substr(L_COL_INST_VIEW || L_BLANK, 1, 30) || ' ' ||

Line 762: UTL_FILE.PUT_LINE(file1, 'CONTROLLED CALCS REPORT');

758: end loop;
759:
760: UTL_FILE.PUT_LINE(file1, L_BLANK);
761: UTL_FILE.PUT_LINE(file1, L_BLANK);
762: UTL_FILE.PUT_LINE(file1, 'CONTROLLED CALCS REPORT');
763: UTL_FILE.PUT_LINE(file1, substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||
764: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||
765: substr(L_COL_INST_VIEW || L_BLANK, 1, 30) || ' ' ||
766: substr(L_COL_INST_CCOL || L_BLANK, 1, 20) || ' ' ||

Line 763: UTL_FILE.PUT_LINE(file1, substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||

759:
760: UTL_FILE.PUT_LINE(file1, L_BLANK);
761: UTL_FILE.PUT_LINE(file1, L_BLANK);
762: UTL_FILE.PUT_LINE(file1, 'CONTROLLED CALCS REPORT');
763: UTL_FILE.PUT_LINE(file1, substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||
764: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||
765: substr(L_COL_INST_VIEW || L_BLANK, 1, 30) || ' ' ||
766: substr(L_COL_INST_CCOL || L_BLANK, 1, 20) || ' ' ||
767: substr(L_COL_INST_DIMS || L_BLANK, 1, 30));

Line 768: UTL_FILE.PUT_LINE(file1, L_BREAK);

764: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||
765: substr(L_COL_INST_VIEW || L_BLANK, 1, 30) || ' ' ||
766: substr(L_COL_INST_CCOL || L_BLANK, 1, 20) || ' ' ||
767: substr(L_COL_INST_DIMS || L_BLANK, 1, 30));
768: UTL_FILE.PUT_LINE(file1, L_BREAK);
769: l_meas_type := 'SHARED_VIEW_CALC';
770: for v_bp_inst in c_bp_instances loop
771: l_cube_id := v_bp_inst.cube_id;
772: l_dimensionality := '';

Line 778: UTL_FILE.PUT_LINE(file1, substr(v_bp_inst.meas || L_BLANK, 1, 50) || ' ' ||

774: l_dimensionality := l_dimensionality || v_cube_dim.epb_id || ' ';
775: end loop;
776:
777:
778: UTL_FILE.PUT_LINE(file1, substr(v_bp_inst.meas || L_BLANK, 1, 50) || ' ' ||
779: substr(v_bp_inst.instance_id || L_BLANK, 1, 10) || ' ' ||
780: substr(v_bp_inst.cube || L_BLANK, 1, 30) || ' ' ||
781: substr(v_bp_inst.column_name || L_BLANK, 1, 20) || ' ' ||
782: substr(l_dimensionality || L_BLANK, 1, 30));

Line 788: UTL_FILE.PUT_LINE(file1, L_BLANK);

784:
785: -- User Specific Reports
786: if p_user_id <> 0 then
787:
788: UTL_FILE.PUT_LINE(file1, L_BLANK);
789: UTL_FILE.PUT_LINE(file1, L_BLANK);
790: UTL_FILE.PUT_LINE(file1, 'ANALYST CALCS REPORT');
791: UTL_FILE.PUT_LINE(file1, substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||
792: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||

Line 789: UTL_FILE.PUT_LINE(file1, L_BLANK);

785: -- User Specific Reports
786: if p_user_id <> 0 then
787:
788: UTL_FILE.PUT_LINE(file1, L_BLANK);
789: UTL_FILE.PUT_LINE(file1, L_BLANK);
790: UTL_FILE.PUT_LINE(file1, 'ANALYST CALCS REPORT');
791: UTL_FILE.PUT_LINE(file1, substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||
792: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||
793: substr(L_COL_INST_VIEW || L_BLANK, 1, 30) || ' ' ||

Line 790: UTL_FILE.PUT_LINE(file1, 'ANALYST CALCS REPORT');

786: if p_user_id <> 0 then
787:
788: UTL_FILE.PUT_LINE(file1, L_BLANK);
789: UTL_FILE.PUT_LINE(file1, L_BLANK);
790: UTL_FILE.PUT_LINE(file1, 'ANALYST CALCS REPORT');
791: UTL_FILE.PUT_LINE(file1, substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||
792: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||
793: substr(L_COL_INST_VIEW || L_BLANK, 1, 30) || ' ' ||
794: substr(L_COL_INST_CCOL || L_BLANK, 1, 20) || ' ' ||

Line 791: UTL_FILE.PUT_LINE(file1, substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||

787:
788: UTL_FILE.PUT_LINE(file1, L_BLANK);
789: UTL_FILE.PUT_LINE(file1, L_BLANK);
790: UTL_FILE.PUT_LINE(file1, 'ANALYST CALCS REPORT');
791: UTL_FILE.PUT_LINE(file1, substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||
792: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||
793: substr(L_COL_INST_VIEW || L_BLANK, 1, 30) || ' ' ||
794: substr(L_COL_INST_CCOL || L_BLANK, 1, 20) || ' ' ||
795: substr(L_COL_INST_DIMS || L_BLANK, 1, 30));

Line 796: UTL_FILE.PUT_LINE(file1, L_BREAK);

792: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||
793: substr(L_COL_INST_VIEW || L_BLANK, 1, 30) || ' ' ||
794: substr(L_COL_INST_CCOL || L_BLANK, 1, 20) || ' ' ||
795: substr(L_COL_INST_DIMS || L_BLANK, 1, 30));
796: UTL_FILE.PUT_LINE(file1, L_BREAK);
797: l_meas_type := 'PERSONAL_CALC';
798: for v_prs_inst in c_prs_instances loop
799: l_cube_id := v_prs_inst.cube_id;
800: l_dimensionality := '';

Line 806: UTL_FILE.PUT_LINE(file1, substr(v_prs_inst.meas || L_BLANK, 1, 50) || ' ' ||

802: l_dimensionality := l_dimensionality || v_cube_dim.epb_id || ' ';
803: end loop;
804:
805:
806: UTL_FILE.PUT_LINE(file1, substr(v_prs_inst.meas || L_BLANK, 1, 50) || ' ' ||
807: substr(v_prs_inst.instance_id || L_BLANK, 1, 10) || ' ' ||
808: substr(v_prs_inst.cube || L_BLANK, 1, 30) || ' ' ||
809: substr(v_prs_inst.column_name || L_BLANK, 1, 20) || ' ' ||
810: substr(l_dimensionality || L_BLANK, 1, 30));

Line 813: UTL_FILE.PUT_LINE(file1, L_BLANK);

809: substr(v_prs_inst.column_name || L_BLANK, 1, 20) || ' ' ||
810: substr(l_dimensionality || L_BLANK, 1, 30));
811: end loop;
812:
813: UTL_FILE.PUT_LINE(file1, L_BLANK);
814: UTL_FILE.PUT_LINE(file1, L_BLANK);
815: UTL_FILE.PUT_LINE(file1, 'WORKSHEETS REPORT (only those worksheets that have been opened at least once will appear)');
816: UTL_FILE.PUT_LINE(file1, substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||
817: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||

Line 814: UTL_FILE.PUT_LINE(file1, L_BLANK);

810: substr(l_dimensionality || L_BLANK, 1, 30));
811: end loop;
812:
813: UTL_FILE.PUT_LINE(file1, L_BLANK);
814: UTL_FILE.PUT_LINE(file1, L_BLANK);
815: UTL_FILE.PUT_LINE(file1, 'WORKSHEETS REPORT (only those worksheets that have been opened at least once will appear)');
816: UTL_FILE.PUT_LINE(file1, substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||
817: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||
818: substr(L_COL_INST_VIEW || L_BLANK, 1, 30) || ' ' ||

Line 815: UTL_FILE.PUT_LINE(file1, 'WORKSHEETS REPORT (only those worksheets that have been opened at least once will appear)');

811: end loop;
812:
813: UTL_FILE.PUT_LINE(file1, L_BLANK);
814: UTL_FILE.PUT_LINE(file1, L_BLANK);
815: UTL_FILE.PUT_LINE(file1, 'WORKSHEETS REPORT (only those worksheets that have been opened at least once will appear)');
816: UTL_FILE.PUT_LINE(file1, substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||
817: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||
818: substr(L_COL_INST_VIEW || L_BLANK, 1, 30) || ' ' ||
819: substr(L_COL_INST_CCOL || L_BLANK, 1, 20) || ' ' ||

Line 816: UTL_FILE.PUT_LINE(file1, substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||

812:
813: UTL_FILE.PUT_LINE(file1, L_BLANK);
814: UTL_FILE.PUT_LINE(file1, L_BLANK);
815: UTL_FILE.PUT_LINE(file1, 'WORKSHEETS REPORT (only those worksheets that have been opened at least once will appear)');
816: UTL_FILE.PUT_LINE(file1, substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||
817: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||
818: substr(L_COL_INST_VIEW || L_BLANK, 1, 30) || ' ' ||
819: substr(L_COL_INST_CCOL || L_BLANK, 1, 20) || ' ' ||
820: substr(L_COL_INST_DIMS || L_BLANK, 1, 30));

Line 821: UTL_FILE.PUT_LINE(file1, L_BREAK);

817: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||
818: substr(L_COL_INST_VIEW || L_BLANK, 1, 30) || ' ' ||
819: substr(L_COL_INST_CCOL || L_BLANK, 1, 20) || ' ' ||
820: substr(L_COL_INST_DIMS || L_BLANK, 1, 30));
821: UTL_FILE.PUT_LINE(file1, L_BREAK);
822: l_meas_type := 'PERSONAL_DATA';
823: for v_prs_inst in c_prs_instances loop
824: l_cube_id := v_prs_inst.cube_id;
825: l_dimensionality := '';

Line 831: UTL_FILE.PUT_LINE(file1, substr(v_prs_inst.meas || L_BLANK, 1, 50) || ' ' ||

827: l_dimensionality := l_dimensionality || v_cube_dim.epb_id || ' ';
828: end loop;
829:
830:
831: UTL_FILE.PUT_LINE(file1, substr(v_prs_inst.meas || L_BLANK, 1, 50) || ' ' ||
832: substr(v_prs_inst.instance_id || L_BLANK, 1, 10) || ' ' ||
833: substr(v_prs_inst.cube || L_BLANK, 1, 30) || ' ' ||
834: substr(v_prs_inst.column_name || L_BLANK, 1, 20) || ' ' ||
835: substr(l_dimensionality || L_BLANK, 1, 30));

Line 838: UTL_FILE.PUT_LINE(file1, L_BLANK);

834: substr(v_prs_inst.column_name || L_BLANK, 1, 20) || ' ' ||
835: substr(l_dimensionality || L_BLANK, 1, 30));
836: end loop;
837:
838: UTL_FILE.PUT_LINE(file1, L_BLANK);
839: UTL_FILE.PUT_LINE(file1, L_BLANK);
840: UTL_FILE.PUT_LINE(file1, 'APPROVER WORKSHEETS REPORT (only those worksheets that have been opened at least once will appear)');
841: UTL_FILE.PUT_LINE(file1, substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||
842: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||

Line 839: UTL_FILE.PUT_LINE(file1, L_BLANK);

835: substr(l_dimensionality || L_BLANK, 1, 30));
836: end loop;
837:
838: UTL_FILE.PUT_LINE(file1, L_BLANK);
839: UTL_FILE.PUT_LINE(file1, L_BLANK);
840: UTL_FILE.PUT_LINE(file1, 'APPROVER WORKSHEETS REPORT (only those worksheets that have been opened at least once will appear)');
841: UTL_FILE.PUT_LINE(file1, substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||
842: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||
843: substr(L_COL_INST_VIEW || L_BLANK, 1, 30) || ' ' ||

Line 840: UTL_FILE.PUT_LINE(file1, 'APPROVER WORKSHEETS REPORT (only those worksheets that have been opened at least once will appear)');

836: end loop;
837:
838: UTL_FILE.PUT_LINE(file1, L_BLANK);
839: UTL_FILE.PUT_LINE(file1, L_BLANK);
840: UTL_FILE.PUT_LINE(file1, 'APPROVER WORKSHEETS REPORT (only those worksheets that have been opened at least once will appear)');
841: UTL_FILE.PUT_LINE(file1, substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||
842: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||
843: substr(L_COL_INST_VIEW || L_BLANK, 1, 30) || ' ' ||
844: substr(L_COL_INST_CCOL || L_BLANK, 1, 20) || ' ' ||

Line 841: UTL_FILE.PUT_LINE(file1, substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||

837:
838: UTL_FILE.PUT_LINE(file1, L_BLANK);
839: UTL_FILE.PUT_LINE(file1, L_BLANK);
840: UTL_FILE.PUT_LINE(file1, 'APPROVER WORKSHEETS REPORT (only those worksheets that have been opened at least once will appear)');
841: UTL_FILE.PUT_LINE(file1, substr(L_COL_INST_NAME || L_BLANK, 1, 50) || ' ' ||
842: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||
843: substr(L_COL_INST_VIEW || L_BLANK, 1, 30) || ' ' ||
844: substr(L_COL_INST_CCOL || L_BLANK, 1, 20) || ' ' ||
845: substr(L_COL_INST_DIMS || L_BLANK, 1, 30));

Line 846: UTL_FILE.PUT_LINE(file1, L_BREAK);

842: substr(L_COL_INST_ID || L_BLANK, 1, 10) || ' ' ||
843: substr(L_COL_INST_VIEW || L_BLANK, 1, 30) || ' ' ||
844: substr(L_COL_INST_CCOL || L_BLANK, 1, 20) || ' ' ||
845: substr(L_COL_INST_DIMS || L_BLANK, 1, 30));
846: UTL_FILE.PUT_LINE(file1, L_BREAK);
847: l_meas_type := 'APPROVER_DATA';
848: for v_prs_inst in c_prs_instances loop
849: l_cube_id := v_prs_inst.cube_id;
850: l_dimensionality := '';

Line 856: UTL_FILE.PUT_LINE(file1, substr(v_prs_inst.meas || L_BLANK, 1, 50) || ' ' ||

852: l_dimensionality := l_dimensionality || v_cube_dim.epb_id || ' ';
853: end loop;
854:
855:
856: UTL_FILE.PUT_LINE(file1, substr(v_prs_inst.meas || L_BLANK, 1, 50) || ' ' ||
857: substr(v_prs_inst.instance_id || L_BLANK, 1, 10) || ' ' ||
858: substr(v_prs_inst.cube || L_BLANK, 1, 30) || ' ' ||
859: substr(v_prs_inst.column_name || L_BLANK, 1, 20) || ' ' ||
860: substr(l_dimensionality || L_BLANK, 1, 30));

Line 866: UTL_FILE.FFLUSH (file1);

862:
863: end if;
864:
865:
866: UTL_FILE.FFLUSH (file1);
867: UTL_FILE.FCLOSE(file1);
868:
869: end MDFILE;
870:

Line 867: UTL_FILE.FCLOSE(file1);

863: end if;
864:
865:
866: UTL_FILE.FFLUSH (file1);
867: UTL_FILE.FCLOSE(file1);
868:
869: end MDFILE;
870:
871: procedure REBUILD_MD(p_business_area IN NUMBER)