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_OLAP_VIEWS_PKG dependencies on ZPB_METADATA_NAMES

Line 55: l_col := zpb_metadata_names.get_attribute_column (p_dim, l_attr);

51: i := j+1;
52: end if;
53:
54: l_attr_ecm := zpb_ecm.get_attr_ecm(l_attr, l_global_attr, p_aw);
55: l_col := zpb_metadata_names.get_attribute_column (p_dim, l_attr);
56:
57: p_statement := p_statement||l_col||' varchar2(160),';
58: p_cols := p_cols||l_col||',';
59: p_modelCmd := p_modelCmd||l_col||',';

Line 84: l_dimCol varchar2(32) :=zpb_metadata_names.get_dimension_column(p_dimID);

80: procedure BUILD_BEGIN_MAP (p_statement in out NOCOPY varchar2,
81: p_cols in out NOCOPY varchar2,
82: p_dimID in varchar2)
83: is
84: l_dimCol varchar2(32) :=zpb_metadata_names.get_dimension_column(p_dimID);
85: begin
86: p_statement := 'OBJECT ('||l_dimCol||' varchar2(60), ';
87: p_cols := l_dimCol||',';
88:

Line 126: l_shortCol := zpb_metadata_names.get_dim_short_name_column(p_dim);

122: begin
123: l_aw := zpb_aw.get_schema||'.'||p_aw||'!';
124: l_dim_data := zpb_ecm.get_dimension_data(p_dim, p_aw);
125: l_dim := l_dim_data.ExpObj;
126: l_shortCol := zpb_metadata_names.get_dim_short_name_column(p_dim);
127: l_longCol := zpb_metadata_names.get_dim_long_name_column(p_dim);
128: l_codeCol := zpb_metadata_names.get_dim_code_column(p_dim);
129:
130: p_statement := p_statement||l_longCol||' varchar2(255)';

Line 127: l_longCol := zpb_metadata_names.get_dim_long_name_column(p_dim);

123: l_aw := zpb_aw.get_schema||'.'||p_aw||'!';
124: l_dim_data := zpb_ecm.get_dimension_data(p_dim, p_aw);
125: l_dim := l_dim_data.ExpObj;
126: l_shortCol := zpb_metadata_names.get_dim_short_name_column(p_dim);
127: l_longCol := zpb_metadata_names.get_dim_long_name_column(p_dim);
128: l_codeCol := zpb_metadata_names.get_dim_code_column(p_dim);
129:
130: p_statement := p_statement||l_longCol||' varchar2(255)';
131: p_cols := p_cols||l_longCol;

Line 128: l_codeCol := zpb_metadata_names.get_dim_code_column(p_dim);

124: l_dim_data := zpb_ecm.get_dimension_data(p_dim, p_aw);
125: l_dim := l_dim_data.ExpObj;
126: l_shortCol := zpb_metadata_names.get_dim_short_name_column(p_dim);
127: l_longCol := zpb_metadata_names.get_dim_long_name_column(p_dim);
128: l_codeCol := zpb_metadata_names.get_dim_code_column(p_dim);
129:
130: p_statement := p_statement||l_longCol||' varchar2(255)';
131: p_cols := p_cols||l_longCol;
132: p_modelCmd := p_modelCmd||l_longCol;

Line 143: l_enddateCol := zpb_metadata_names.get_dim_enddate_column(p_dim);

139: p_cols := p_cols||','||l_codeCol;
140: p_modelCmd := p_modelCmd||','||l_codeCol;
141:
142: if (l_dim_data.Type = 'TIME') then
143: l_enddateCol := zpb_metadata_names.get_dim_enddate_column(p_dim);
144: l_timespanCol := zpb_metadata_names.get_dim_timespan_column(p_dim);
145: l_calendarCol := zpb_metadata_names.get_dim_calendar_column(p_dim);
146: p_statement := p_statement||', '||l_enddateCol||' date, '||
147: l_timespanCol||' number, '||l_calendarCol||' number';

Line 144: l_timespanCol := zpb_metadata_names.get_dim_timespan_column(p_dim);

140: p_modelCmd := p_modelCmd||','||l_codeCol;
141:
142: if (l_dim_data.Type = 'TIME') then
143: l_enddateCol := zpb_metadata_names.get_dim_enddate_column(p_dim);
144: l_timespanCol := zpb_metadata_names.get_dim_timespan_column(p_dim);
145: l_calendarCol := zpb_metadata_names.get_dim_calendar_column(p_dim);
146: p_statement := p_statement||', '||l_enddateCol||' date, '||
147: l_timespanCol||' number, '||l_calendarCol||' number';
148: p_cols := p_cols||','||l_enddateCol||','||l_timespanCol||','||

Line 145: l_calendarCol := zpb_metadata_names.get_dim_calendar_column(p_dim);

141:
142: if (l_dim_data.Type = 'TIME') then
143: l_enddateCol := zpb_metadata_names.get_dim_enddate_column(p_dim);
144: l_timespanCol := zpb_metadata_names.get_dim_timespan_column(p_dim);
145: l_calendarCol := zpb_metadata_names.get_dim_calendar_column(p_dim);
146: p_statement := p_statement||', '||l_enddateCol||' date, '||
147: l_timespanCol||' number, '||l_calendarCol||' number';
148: p_cols := p_cols||','||l_enddateCol||','||l_timespanCol||','||
149: l_calendarCol;

Line 155: l_lnaggTmCol := zpb_metadata_names.get_dim_aggtime_column(p_dim);

151: l_calendarCol;
152: end if;
153:
154: if (l_dim_data.Type = 'LINE') then
155: l_lnaggTmCol := zpb_metadata_names.get_dim_aggtime_column(p_dim);
156: l_lnaggOtCol := zpb_metadata_names.get_dim_aggother_column(p_dim);
157: p_statement := p_statement||', '||l_lnaggTmCol||' varchar2(150), ' ||
158: l_lnaggOtCol || ' varchar2(150)';
159: p_cols := p_cols||','||l_lnaggTmCol|| ','||l_lnaggOtCol;

Line 156: l_lnaggOtCol := zpb_metadata_names.get_dim_aggother_column(p_dim);

152: end if;
153:
154: if (l_dim_data.Type = 'LINE') then
155: l_lnaggTmCol := zpb_metadata_names.get_dim_aggtime_column(p_dim);
156: l_lnaggOtCol := zpb_metadata_names.get_dim_aggother_column(p_dim);
157: p_statement := p_statement||', '||l_lnaggTmCol||' varchar2(150), ' ||
158: l_lnaggOtCol || ' varchar2(150)';
159: p_cols := p_cols||','||l_lnaggTmCol|| ','||l_lnaggOtCol;
160: p_modelCmd := p_modelCmd||','||l_lnaggTmCol|| ','||l_lnaggOtCol;

Line 188: l_dimTable varchar2(200) := zpb_metadata_names.get_view_table(p_dimView);

184: p_cols in varchar2,
185: p_modelCmd in varchar2 default null,
186: p_olapCmd in varchar2 default null)
187: is
188: l_dimTable varchar2(200) := zpb_metadata_names.get_view_table(p_dimView);
189: l_dimObj varchar2(200) :=zpb_metadata_names.get_view_object(p_dimView);
190: l_version PRODUCT_COMPONENT_VERSION.VERSION%type;
191: l_aw varchar2(30);
192: l_schemaName varchar2(32);

Line 189: l_dimObj varchar2(200) :=zpb_metadata_names.get_view_object(p_dimView);

185: p_modelCmd in varchar2 default null,
186: p_olapCmd in varchar2 default null)
187: is
188: l_dimTable varchar2(200) := zpb_metadata_names.get_view_table(p_dimView);
189: l_dimObj varchar2(200) :=zpb_metadata_names.get_view_object(p_dimView);
190: l_version PRODUCT_COMPONENT_VERSION.VERSION%type;
191: l_aw varchar2(30);
192: l_schemaName varchar2(32);
193: l_model varchar2(16000);

Line 268: zpb_metadata_names.get_view_table(p_view);

264: null;
265: end;
266: begin
267: execute immediate 'drop type '||
268: zpb_metadata_names.get_view_table(p_view);
269: exception when others then
270: null;
271: end;
272: begin

Line 274: zpb_metadata_names.get_view_object(p_view);

270: null;
271: end;
272: begin
273: execute immediate 'drop type '||
274: zpb_metadata_names.get_view_object(p_view);
275: exception when others then
276: null;
277: end;
278:

Line 374: l_membCol := zpb_metadata_names.get_dimension_column(l_attr);

370: l_attr := substr (l_attrs, i, j-i);
371: i := j+1;
372: end if;
373:
374: l_membCol := zpb_metadata_names.get_dimension_column(l_attr);
375: l_longCol := zpb_metadata_names.get_dim_long_name_column(l_attr);
376: l_shortCol := zpb_metadata_names.get_dim_short_name_column(l_attr);
377: l_gidCol := zpb_metadata_names.get_dim_gid_column(l_attr);
378: l_pgidCol := zpb_metadata_names.get_dim_pgid_column(l_attr);

Line 375: l_longCol := zpb_metadata_names.get_dim_long_name_column(l_attr);

371: i := j+1;
372: end if;
373:
374: l_membCol := zpb_metadata_names.get_dimension_column(l_attr);
375: l_longCol := zpb_metadata_names.get_dim_long_name_column(l_attr);
376: l_shortCol := zpb_metadata_names.get_dim_short_name_column(l_attr);
377: l_gidCol := zpb_metadata_names.get_dim_gid_column(l_attr);
378: l_pgidCol := zpb_metadata_names.get_dim_pgid_column(l_attr);
379: l_parentCol := zpb_metadata_names.get_dim_parent_column(l_attr);

Line 376: l_shortCol := zpb_metadata_names.get_dim_short_name_column(l_attr);

372: end if;
373:
374: l_membCol := zpb_metadata_names.get_dimension_column(l_attr);
375: l_longCol := zpb_metadata_names.get_dim_long_name_column(l_attr);
376: l_shortCol := zpb_metadata_names.get_dim_short_name_column(l_attr);
377: l_gidCol := zpb_metadata_names.get_dim_gid_column(l_attr);
378: l_pgidCol := zpb_metadata_names.get_dim_pgid_column(l_attr);
379: l_parentCol := zpb_metadata_names.get_dim_parent_column(l_attr);
380:

Line 377: l_gidCol := zpb_metadata_names.get_dim_gid_column(l_attr);

373:
374: l_membCol := zpb_metadata_names.get_dimension_column(l_attr);
375: l_longCol := zpb_metadata_names.get_dim_long_name_column(l_attr);
376: l_shortCol := zpb_metadata_names.get_dim_short_name_column(l_attr);
377: l_gidCol := zpb_metadata_names.get_dim_gid_column(l_attr);
378: l_pgidCol := zpb_metadata_names.get_dim_pgid_column(l_attr);
379: l_parentCol := zpb_metadata_names.get_dim_parent_column(l_attr);
380:
381: --

Line 378: l_pgidCol := zpb_metadata_names.get_dim_pgid_column(l_attr);

374: l_membCol := zpb_metadata_names.get_dimension_column(l_attr);
375: l_longCol := zpb_metadata_names.get_dim_long_name_column(l_attr);
376: l_shortCol := zpb_metadata_names.get_dim_short_name_column(l_attr);
377: l_gidCol := zpb_metadata_names.get_dim_gid_column(l_attr);
378: l_pgidCol := zpb_metadata_names.get_dim_pgid_column(l_attr);
379: l_parentCol := zpb_metadata_names.get_dim_parent_column(l_attr);
380:
381: --
382: -- Create a "null" hierarchy. This will be the view used if the

Line 379: l_parentCol := zpb_metadata_names.get_dim_parent_column(l_attr);

375: l_longCol := zpb_metadata_names.get_dim_long_name_column(l_attr);
376: l_shortCol := zpb_metadata_names.get_dim_short_name_column(l_attr);
377: l_gidCol := zpb_metadata_names.get_dim_gid_column(l_attr);
378: l_pgidCol := zpb_metadata_names.get_dim_pgid_column(l_attr);
379: l_parentCol := zpb_metadata_names.get_dim_parent_column(l_attr);
380:
381: --
382: -- Create a "null" hierarchy. This will be the view used if the
383: -- dimension has no hierarchy, as well as the view used by Java tier

Line 386: l_attrView := zpb_metadata_names.get_dimension_view

382: -- Create a "null" hierarchy. This will be the view used if the
383: -- dimension has no hierarchy, as well as the view used by Java tier
384: -- for labels of dimension members:
385: --
386: l_attrView := zpb_metadata_names.get_dimension_view
387: (p_aw, p_type, l_attr);
388: DROP_VIEW (l_attrView);
389:
390: l_attrObj :=

Line 398: l_levelCol := zpb_metadata_names.get_level_column(l_attr, 0);

394: ' '''||l_attr||'''))');
395:
396: BUILD_BEGIN_MAP (l_statement, l_cols, l_attr);
397:
398: l_levelCol := zpb_metadata_names.get_level_column(l_attr, 0);
399: l_statement := l_statement||l_parentCol||' varchar2(16),'||
400: l_gidCol||' number(10), '||l_pgidCol||' number(10), '||
401: l_levelCol||' varchar2(60), '||l_longCol||' varchar2(200), '||
402: l_shortCol||' varchar2(200))';

Line 524: l_dimCol := zpb_metadata_names.get_dimension_column(l_dim);

520:
521: l_dim_data := zpb_ecm.get_dimension_data(l_dim, p_aw);
522: l_dim_ecm := zpb_ecm.get_dimension_ecm(l_dim, p_aw);
523:
524: l_dimCol := zpb_metadata_names.get_dimension_column(l_dim);
525: l_count := l_count + 1;
526:
527: l_statement := l_statement||l_dimCol||' VARCHAR2(32)';
528: l_cols := l_cols||l_dimCol||',';

Line 551: l_gidCol := zpb_metadata_names.get_dim_gid_column(l_dim,l_hier);

547: l_hier := substr (l_hiers, hi, hj-hi);
548: hi := hj+1;
549: end if;
550:
551: l_gidCol := zpb_metadata_names.get_dim_gid_column(l_dim,l_hier);
552: l_statement := l_statement||', '||l_gidCol||' NUMBER';
553: l_cols := l_cols||l_gidCol||',';
554:
555: l_lmap := l_lmap||'HIERARCHY '|| l_mapQual ||l_dim_ecm.ParentRel||

Line 564: l_gidCol := zpb_metadata_names.get_dim_gid_column;

560: exit when hj=0;
561: l_lmap := l_lmap||'\n';
562: end loop;
563: elsif (l_gid = false) then
564: l_gidCol := zpb_metadata_names.get_dim_gid_column;
565: l_statement := l_statement||', '||l_gidCol||' NUMBER';
566: l_cols := l_cols||'0 '||l_gidCol||',';
567: l_gid := true;
568: l_count := l_count + 1;

Line 737: l_gidCol := zpb_metadata_names.get_dim_gid_column(l_ecmDim);

733:
734: l_dim_data := zpb_ecm.get_dimension_data(l_ecmDim, p_aw);
735: l_dim_ecm := zpb_ecm.get_dimension_ecm(l_ecmDim, p_aw);
736:
737: l_gidCol := zpb_metadata_names.get_dim_gid_column(l_ecmDim);
738: l_pgidCol := zpb_metadata_names.get_dim_pgid_column(l_ecmDim);
739: l_parentCol := zpb_metadata_names.get_dim_parent_column(l_ecmDim);
740: l_orderCol := zpb_metadata_names.get_dim_order_column(l_ecmDim);
741:

Line 738: l_pgidCol := zpb_metadata_names.get_dim_pgid_column(l_ecmDim);

734: l_dim_data := zpb_ecm.get_dimension_data(l_ecmDim, p_aw);
735: l_dim_ecm := zpb_ecm.get_dimension_ecm(l_ecmDim, p_aw);
736:
737: l_gidCol := zpb_metadata_names.get_dim_gid_column(l_ecmDim);
738: l_pgidCol := zpb_metadata_names.get_dim_pgid_column(l_ecmDim);
739: l_parentCol := zpb_metadata_names.get_dim_parent_column(l_ecmDim);
740: l_orderCol := zpb_metadata_names.get_dim_order_column(l_ecmDim);
741:
742: if (ZPB_AW.INTERP('shw obj(dimmax '''||l_aw||l_dim_ecm.HierDim||''')')

Line 739: l_parentCol := zpb_metadata_names.get_dim_parent_column(l_ecmDim);

735: l_dim_ecm := zpb_ecm.get_dimension_ecm(l_ecmDim, p_aw);
736:
737: l_gidCol := zpb_metadata_names.get_dim_gid_column(l_ecmDim);
738: l_pgidCol := zpb_metadata_names.get_dim_pgid_column(l_ecmDim);
739: l_parentCol := zpb_metadata_names.get_dim_parent_column(l_ecmDim);
740: l_orderCol := zpb_metadata_names.get_dim_order_column(l_ecmDim);
741:
742: if (ZPB_AW.INTERP('shw obj(dimmax '''||l_aw||l_dim_ecm.HierDim||''')')
743: <> '0') then

Line 740: l_orderCol := zpb_metadata_names.get_dim_order_column(l_ecmDim);

736:
737: l_gidCol := zpb_metadata_names.get_dim_gid_column(l_ecmDim);
738: l_pgidCol := zpb_metadata_names.get_dim_pgid_column(l_ecmDim);
739: l_parentCol := zpb_metadata_names.get_dim_parent_column(l_ecmDim);
740: l_orderCol := zpb_metadata_names.get_dim_order_column(l_ecmDim);
741:
742: if (ZPB_AW.INTERP('shw obj(dimmax '''||l_aw||l_dim_ecm.HierDim||''')')
743: <> '0') then
744:

Line 778: zpb_metadata_names.get_dimension_column(l_ecmDim)||', '||

774: l_cols := l_cols||l_parentCol||','||l_gidCol||','||
775: l_pgidCol||','||l_orderCol||',';
776:
777: l_modelCmd := ' MODEL DIMENSION BY ('||
778: zpb_metadata_names.get_dimension_column(l_ecmDim)||', '||
779: l_gidCol||') MEASURES ('||l_parentCol||', '||
780: l_orderCol||', '||l_pgidCol||',';
781:
782: --

Line 817: l_levelCol := zpb_metadata_names.get_level_column(l_ecmDim,

813: l_aw||l_dim_data.ExpObj||') text 0 no no)'));
814:
815: if (instr (l_hierLevels, ' '||l_level||' ') > 0 and
816: l_length > 0) then
817: l_levelCol := zpb_metadata_names.get_level_column(l_ecmDim,
818: l_level);
819: l_statement := l_statement||l_levelCol||' varchar2(32), ';
820: l_cols := l_cols||l_levelCol||',';
821: l_modelCmd := l_modelCmd||l_levelCol||',';

Line 832: l_dimView := zpb_metadata_names.get_dimension_view (p_aw,

828: l_modelCmd);
829: BUILD_END_MAP (p_aw, l_ecmDim, l_statement, l_cols, l_modelCmd);
830:
831: if (p_type = 'SHARED') then
832: l_dimView := zpb_metadata_names.get_dimension_view (p_aw,
833: 'SHARED',
834: l_ecmDim,
835: l_hier);
836: DROP_VIEW (l_dimView);

Line 845: l_dimView := zpb_metadata_names.get_dimension_view (p_aw,

841: call_ddl (l_dimView, 'EXPRESS', l_statement, l_lmap, l_cols,
842: l_modelCmd, 'AW ATTACH SHARED');
843: end if;
844:
845: l_dimView := zpb_metadata_names.get_dimension_view (p_aw,
846: 'PERSONAL',
847: l_ecmDim,
848: l_hier);
849: DROP_VIEW (l_dimView);

Line 871: l_levelCol := zpb_metadata_names.get_level_column(l_ecmDim, 0);

867: -- for labels of dimension members:
868: --
869: BUILD_BEGIN_MAP (l_statement, l_cols, l_ecmDim);
870:
871: l_levelCol := zpb_metadata_names.get_level_column(l_ecmDim, 0);
872: l_levelrelCol := zpb_metadata_names.get_levelrel_column(l_ecmDim);
873:
874: l_statement := l_statement||l_parentCol||' number(10),'||
875: l_gidCol||' number(10), '||l_pgidCol||' number(10), '||

Line 872: l_levelrelCol := zpb_metadata_names.get_levelrel_column(l_ecmDim);

868: --
869: BUILD_BEGIN_MAP (l_statement, l_cols, l_ecmDim);
870:
871: l_levelCol := zpb_metadata_names.get_level_column(l_ecmDim, 0);
872: l_levelrelCol := zpb_metadata_names.get_levelrel_column(l_ecmDim);
873:
874: l_statement := l_statement||l_parentCol||' number(10),'||
875: l_gidCol||' number(10), '||l_pgidCol||' number(10), '||
876: l_levelCol||' varchar2(32), '||l_levelRelCol||' varchar2(16), ';

Line 888: zpb_metadata_names.get_dimension_column(l_ecmDim)||', '||

884: l_cols := l_cols||'NULL '||l_levelRelCol||',';
885: end if;
886:
887: l_modelCmd := ' MODEL DIMENSION BY ('||
888: zpb_metadata_names.get_dimension_column(l_ecmDim)||', '||
889: l_gidCol||') MEASURES ('||l_parentCol||', '||
890: l_levelCol||','||l_levelRelCol||', '||l_pgidCol||',';
891:
892: BUILD_ATTRIBUTE_MAP(p_aw, l_ecmDim, l_statement, l_cols, l_modelCmd);

Line 897: l_dimView := zpb_metadata_names.get_dimension_view

893:
894: BUILD_END_MAP (p_aw, l_ecmDim, l_statement, l_cols, l_modelCmd);
895:
896: if (p_type = 'SHARED') then
897: l_dimView := zpb_metadata_names.get_dimension_view
898: (p_aw, 'SHARED', l_ecmDim);
899: DROP_VIEW (l_dimView);
900:
901: l_lmap := '''&('||l_aw||l_dim_ecm.LimitMapVar||')''';

Line 906: l_dimView := zpb_metadata_names.get_dimension_view

902: call_ddl (l_dimView, 'EXPRESS', l_statement, l_lmap, l_cols,
903: l_modelCmd, 'AW ATTACH SHARED');
904: end if;
905:
906: l_dimView := zpb_metadata_names.get_dimension_view
907: (p_aw, 'PERSONAL',l_ecmDim);
908: DROP_VIEW (l_dimView);
909:
910: l_lmap := '''&(PERSONAL!'||l_dim_ecm.LimitMapVar||')''';

Line 996: l_measCol := zpb_metadata_names.get_full_scope_column;

992: end if;
993:
994: if (l_measure = 'SECFULLSCPVW.F') then
995: l_measName := 'SECFULLSCPVW.F';
996: l_measCol := zpb_metadata_names.get_full_scope_column;
997: l_measType := 'VARCHAR2(1)';
998: elsif (l_measure = 'OWNERMAP') then
999: l_measName := 'SECOWNMAP2.F';
1000: l_measCol := zpb_metadata_names.get_ownermap_column;

Line 1000: l_measCol := zpb_metadata_names.get_ownermap_column;

996: l_measCol := zpb_metadata_names.get_full_scope_column;
997: l_measType := 'VARCHAR2(1)';
998: elsif (l_measure = 'OWNERMAP') then
999: l_measName := 'SECOWNMAP2.F';
1000: l_measCol := zpb_metadata_names.get_ownermap_column;
1001: l_measType := 'VARCHAR2(8)';
1002: else
1003: ZPB_LOG.WRITE ('zpb_olap_view_pkg.create_security_views',
1004: 'Invalid measure type: '||l_measure);

Line 1035: l_dimCol := zpb_metadata_names.get_dimension_column(l_ecmDim);

1031: l_dim_ecm := zpb_ecm.get_dimension_ecm (l_ecmDim, p_aw);
1032: --
1033: -- Create the obj type:
1034: --
1035: l_dimCol := zpb_metadata_names.get_dimension_column(l_ecmDim);
1036: l_measState := l_measState||l_dimCol||' VARCHAR2(32)';
1037:
1038: l_measProc := l_measProc||'
1039: DIMENSION '||l_dimCol||' FROM '||l_dim_data.ExpObj||' ';

Line 1061: l_gidCol := zpb_metadata_names.get_dim_gid_column(l_ecmDim,

1057: l_hier := substr (l_hiers, hi, hj-hi);
1058: hi := hj+1;
1059: end if;
1060:
1061: l_gidCol := zpb_metadata_names.get_dim_gid_column(l_ecmDim,
1062: l_hier);
1063: l_measState := l_measState||', '||l_gidCol||' NUMBER';
1064: l_cols := l_cols||l_gidCol||',';
1065:

Line 1074: l_gidCol := zpb_metadata_names.get_dim_gid_column;

1070: l_measProc := l_measProc||'
1071: ';
1072: end loop;
1073: elsif (l_gid = false) then
1074: l_gidCol := zpb_metadata_names.get_dim_gid_column;
1075: l_measState := l_measState||', '||l_gidCol||' NUMBER';
1076: l_cols := l_cols||'0 '||l_gidCol||',';
1077: l_gid := true;
1078: end if;

Line 1154: l_scopeView := zpb_metadata_names.get_scope_status_view(p_dataAw);

1150:
1151: --
1152: -- Build Security Scoping Status table
1153: --
1154: l_scopeView := zpb_metadata_names.get_scope_status_view(p_dataAw);
1155: DROP_VIEW (l_scopeView);
1156:
1157: l_statement := 'OBJECT ('||
1158: 'SECENTITY VARCHAR2(10),'||

Line 1173: l_dataExcView := zpb_metadata_names.get_data_exception_view(p_dataAw);

1169:
1170: --
1171: -- Data Exception views
1172: --
1173: l_dataExcView := zpb_metadata_names.get_data_exception_view(p_dataAw);
1174: DROP_VIEW (l_dataExcView);
1175:
1176: l_statement := 'OBJECT (QDR VARCHAR2(1000),
1177: DATA_VALUE NUMBER,

Line 1197: l_dataExcView := zpb_metadata_names.get_exception_check_tbl(p_dataAw);

1193:
1194: --
1195: -- Generic view used for exception check SQL definitions
1196: --
1197: l_dataExcView := zpb_metadata_names.get_exception_check_tbl(p_dataAw);
1198:
1199: begin
1200: execute immediate 'drop synonym '||l_dataExcView;
1201: execute immediate 'drop table '||zpb_aw.get_schema||'.'||l_dataExcView;

Line 1222: l_col := zpb_metadata_names.get_dimension_column(l_ecmDim);

1218: end if;
1219:
1220: l_dim_ecm := zpb_ecm.get_dimension_ecm (l_ecmDim, p_dataAw);
1221:
1222: l_col := zpb_metadata_names.get_dimension_column(l_ecmDim);
1223: l_statement := l_statement||l_col||' VARCHAR2(32), ';
1224: l_cols := l_cols||l_col||', ';
1225:
1226: zpb_aw.execute ('lmt '||l_aw||l_dim_ecm.HierDim||' to all');

Line 1239: l_col := zpb_metadata_names.get_dim_gid_column(l_ecmDim, l_hier);

1235: l_hier := substr (l_hiers, hi, hj-hi);
1236: hi := hj+1;
1237: end if;
1238:
1239: l_col := zpb_metadata_names.get_dim_gid_column(l_ecmDim, l_hier);
1240: l_statement := l_statement||l_col||' NUMBER, ';
1241: l_cols := l_cols||l_col||', ';
1242:
1243: exit when hj=0;

Line 1251: l_col := zpb_metadata_names.get_dim_gid_column;

1247:
1248: --
1249: -- Add the null hierarchy GID column for good measure. May not be needed:
1250: --
1251: l_col := zpb_metadata_names.get_dim_gid_column;
1252: l_statement := l_statement||l_col||' NUMBER, ';
1253: l_cols := l_cols||'0 '||l_col||', ';
1254:
1255: l_col := zpb_metadata_names.get_exception_column;

Line 1255: l_col := zpb_metadata_names.get_exception_column;

1251: l_col := zpb_metadata_names.get_dim_gid_column;
1252: l_statement := l_statement||l_col||' NUMBER, ';
1253: l_cols := l_cols||'0 '||l_col||', ';
1254:
1255: l_col := zpb_metadata_names.get_exception_column;
1256: l_statement := l_statement||l_col||' NUMBER)';
1257: l_cols := l_cols||l_col;
1258:
1259: execute immediate l_statement;

Line 1276: l_view := zpb_metadata_names.get_to_currency_view(p_dataAw);

1272: WITH ATTRIBUTE MEMBER_CODE FROM TO.CURRENCY.SNAME
1273: ATTRIBUTE MEMBER_NAME FROM TO.CURRENCY.MNAME
1274: ATTRIBUTE MEMBER_DESC FROM TO.CURRENCY.NAME''';
1275:
1276: l_view := zpb_metadata_names.get_to_currency_view(p_dataAw);
1277: drop_view (l_view);
1278: call_ddl (l_view, zpb_aw.get_schema||'.'||p_dataAw, l_statement, l_proc, '*');
1279:
1280: l_statement := 'OBJECT(MEMBER_ID VARCHAR2(30), MEMBER_CODE VARCHAR2(15),'

Line 1287: l_view := zpb_metadata_names.get_exch_rates_view(p_dataAw);

1283: WITH ATTRIBUTE MEMBER_CODE FROM RATES.SNAME
1284: ATTRIBUTE MEMBER_NAME FROM RATES.MNAME
1285: ATTRIBUTE MEMBER_DESC FROM RATES.NAME''';
1286:
1287: l_view := zpb_metadata_names.get_exch_rates_view(p_dataAw);
1288: drop_view (l_view);
1289: call_ddl (l_view, zpb_aw.get_schema||'.'||p_dataAw, l_statement, l_proc, '*');
1290:
1291: l_statement := 'OBJECT(MEMBER_ID VARCHAR2(30), MEMBER_CODE VARCHAR2(100),'

Line 1298: l_view := zpb_metadata_names.get_exch_scenario_view(p_dataAw);

1294: WITH ATTRIBUTE MEMBER_CODE FROM SCENARIO.SNAME
1295: ATTRIBUTE MEMBER_NAME FROM SCENARIO.MNAME
1296: ATTRIBUTE MEMBER_DESC FROM SCENARIO.NAME''';
1297:
1298: l_view := zpb_metadata_names.get_exch_scenario_view(p_dataAw);
1299: drop_view (l_view);
1300: call_ddl (l_view, zpb_aw.get_schema||'.'||p_dataAw, l_statement, l_proc, '*');
1301: end if;
1302:

Line 1567: DROP_VIEW (ZPB_METADATA_NAMES.GET_DIMENSION_VIEW

1563: p_dim in varchar2,
1564: p_hierarchy in varchar2)
1565: is
1566: begin
1567: DROP_VIEW (ZPB_METADATA_NAMES.GET_DIMENSION_VIEW
1568: (p_aw, p_type, p_dim, p_hierarchy));
1569: end REMOVE_DIMENSION_VIEW;
1570: -------------------------------------------------------------------------------
1571: -- REMOVE_BUSAREA_VIEWS