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_ECM

Line 20: l_attr_ecm zpb_ecm.attr_ecm;

16: p_statement in out NOCOPY varchar2,
17: p_cols in out NOCOPY varchar2,
18: p_modelCmd in out NOCOPY varchar2)
19: is
20: l_attr_ecm zpb_ecm.attr_ecm;
21: l_attrs varchar2(1000);
22: l_attr varchar2(32);
23: l_col varchar2(64);
24: l_aw varchar2(60);

Line 27: l_global_ecm zpb_ecm.global_ecm;

23: l_col varchar2(64);
24: l_aw varchar2(60);
25: i number;
26: j number;
27: l_global_ecm zpb_ecm.global_ecm;
28: l_global_attr zpb_ecm.global_attr_ecm;
29: begin
30: l_global_ecm := zpb_ecm.get_global_ecm(p_aw);
31: l_global_attr := zpb_ecm.get_global_attr_ecm (p_aw);

Line 28: l_global_attr zpb_ecm.global_attr_ecm;

24: l_aw varchar2(60);
25: i number;
26: j number;
27: l_global_ecm zpb_ecm.global_ecm;
28: l_global_attr zpb_ecm.global_attr_ecm;
29: begin
30: l_global_ecm := zpb_ecm.get_global_ecm(p_aw);
31: l_global_attr := zpb_ecm.get_global_attr_ecm (p_aw);
32: l_aw := zpb_aw.get_schema||'.'||p_aw||'!';

Line 30: l_global_ecm := zpb_ecm.get_global_ecm(p_aw);

26: j number;
27: l_global_ecm zpb_ecm.global_ecm;
28: l_global_attr zpb_ecm.global_attr_ecm;
29: begin
30: l_global_ecm := zpb_ecm.get_global_ecm(p_aw);
31: l_global_attr := zpb_ecm.get_global_attr_ecm (p_aw);
32: l_aw := zpb_aw.get_schema||'.'||p_aw||'!';
33:
34: zpb_aw.execute('push oknullstatus '||l_aw||l_global_ecm.AttrDim);

Line 31: l_global_attr := zpb_ecm.get_global_attr_ecm (p_aw);

27: l_global_ecm zpb_ecm.global_ecm;
28: l_global_attr zpb_ecm.global_attr_ecm;
29: begin
30: l_global_ecm := zpb_ecm.get_global_ecm(p_aw);
31: l_global_attr := zpb_ecm.get_global_attr_ecm (p_aw);
32: l_aw := zpb_aw.get_schema||'.'||p_aw||'!';
33:
34: zpb_aw.execute('push oknullstatus '||l_aw||l_global_ecm.AttrDim);
35: zpb_aw.execute('oknullstatus = yes');

Line 54: l_attr_ecm := zpb_ecm.get_attr_ecm(l_attr, l_global_attr, p_aw);

50: l_attr := substr (l_attrs, i, j-i);
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||',';

Line 121: l_dim_data zpb_ecm.dimension_data;

117: l_timespanCol varchar2(32);
118: l_calendarCol varchar2(32);
119: l_aw varchar2(30);
120: l_count number;
121: l_dim_data zpb_ecm.dimension_data;
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;

Line 124: l_dim_data := zpb_ecm.get_dimension_data(p_dim, p_aw);

120: l_count number;
121: l_dim_data zpb_ecm.dimension_data;
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);

Line 343: l_global_ecm zpb_ecm.global_ecm;

339: l_shortCol varchar2(30);
340: l_longCol varchar2(30);
341: l_membCol varchar2(30);
342:
343: l_global_ecm zpb_ecm.global_ecm;
344: l_attr_ecm zpb_ecm.global_attr_ecm;
345:
346: begin
347: zpb_log.write ('zpb_olap_views_pkg.create_attribute_views.begin',

Line 344: l_attr_ecm zpb_ecm.global_attr_ecm;

340: l_longCol varchar2(30);
341: l_membCol varchar2(30);
342:
343: l_global_ecm zpb_ecm.global_ecm;
344: l_attr_ecm zpb_ecm.global_attr_ecm;
345:
346: begin
347: zpb_log.write ('zpb_olap_views_pkg.create_attribute_views.begin',
348: 'Begin create_attribute_views');

Line 350: l_global_ecm := zpb_ecm.get_global_ecm(p_aw);

346: begin
347: zpb_log.write ('zpb_olap_views_pkg.create_attribute_views.begin',
348: 'Begin create_attribute_views');
349: l_aw := zpb_aw.get_schema||'.'||p_aw||'!';
350: l_global_ecm := zpb_ecm.get_global_ecm(p_aw);
351: l_attr_ecm := zpb_ecm.get_global_attr_ecm(p_aw);
352:
353: if (p_attributes is null) then
354: zpb_aw.execute ('lmt '||l_aw||l_global_ecm.AttrDim||' to all');

Line 351: l_attr_ecm := zpb_ecm.get_global_attr_ecm(p_aw);

347: zpb_log.write ('zpb_olap_views_pkg.create_attribute_views.begin',
348: 'Begin create_attribute_views');
349: l_aw := zpb_aw.get_schema||'.'||p_aw||'!';
350: l_global_ecm := zpb_ecm.get_global_ecm(p_aw);
351: l_attr_ecm := zpb_ecm.get_global_attr_ecm(p_aw);
352:
353: if (p_attributes is null) then
354: zpb_aw.execute ('lmt '||l_aw||l_global_ecm.AttrDim||' to all');
355: l_attrs := ZPB_AW.INTERP ('shw CM.GETDIMVALUES('''||l_aw||

Line 471: l_glbl_ecm zpb_ecm.global_ecm;

467: l_preCmd varchar2(1000);
468: l_statement varchar2(32767);
469: l_cols varchar2(32767);
470: l_lmap varchar2(32000);
471: l_glbl_ecm zpb_ecm.global_ecm;
472: l_dim_data zpb_ecm.dimension_data;
473: l_dim_ecm zpb_ecm.dimension_ecm;
474: l_relView varchar2(30);
475: l_mapQual varchar2(30);

Line 472: l_dim_data zpb_ecm.dimension_data;

468: l_statement varchar2(32767);
469: l_cols varchar2(32767);
470: l_lmap varchar2(32000);
471: l_glbl_ecm zpb_ecm.global_ecm;
472: l_dim_data zpb_ecm.dimension_data;
473: l_dim_ecm zpb_ecm.dimension_ecm;
474: l_relView varchar2(30);
475: l_mapQual varchar2(30);
476: l_frmcpr varchar2(16);

Line 473: l_dim_ecm zpb_ecm.dimension_ecm;

469: l_cols varchar2(32767);
470: l_lmap varchar2(32000);
471: l_glbl_ecm zpb_ecm.global_ecm;
472: l_dim_data zpb_ecm.dimension_data;
473: l_dim_ecm zpb_ecm.dimension_ecm;
474: l_relView varchar2(30);
475: l_mapQual varchar2(30);
476: l_frmcpr varchar2(16);
477:

Line 486: l_glbl_ecm := zpb_ecm.get_global_ecm(p_aw);

482: l_count := 0;
483: l_gid := false;
484: l_statement := 'OBJECT(';
485: l_aw := p_aw||'!';
486: l_glbl_ecm := zpb_ecm.get_global_ecm(p_aw);
487:
488: -- need to do this to avoid a GCC hard-coded schema warning
489: l_frmcpr := 'FRM';
490: l_frmcpr := l_frmcpr || '.';

Line 521: l_dim_data := zpb_ecm.get_dimension_data(l_dim, p_aw);

517: l_dim := substr (p_dims, i, j-i);
518: i := j+1;
519: end if;
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;

Line 522: l_dim_ecm := zpb_ecm.get_dimension_ecm(l_dim, p_aw);

518: i := j+1;
519: end if;
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:

Line 699: l_global_ecm zpb_ecm.global_ecm;

695: l_levelCol varchar2(32);
696: l_levelRelCol varchar2(32);
697: l_orderCol varchar2(32);
698:
699: l_global_ecm zpb_ecm.global_ecm;
700: l_dim_ecm zpb_ecm.dimension_ecm;
701: l_dim_data zpb_ecm.dimension_data;
702:
703: begin

Line 700: l_dim_ecm zpb_ecm.dimension_ecm;

696: l_levelRelCol varchar2(32);
697: l_orderCol varchar2(32);
698:
699: l_global_ecm zpb_ecm.global_ecm;
700: l_dim_ecm zpb_ecm.dimension_ecm;
701: l_dim_data zpb_ecm.dimension_data;
702:
703: begin
704: zpb_log.write ('zpb_olap_views_pkg.create_dimension_views.begin',

Line 701: l_dim_data zpb_ecm.dimension_data;

697: l_orderCol varchar2(32);
698:
699: l_global_ecm zpb_ecm.global_ecm;
700: l_dim_ecm zpb_ecm.dimension_ecm;
701: l_dim_data zpb_ecm.dimension_data;
702:
703: begin
704: zpb_log.write ('zpb_olap_views_pkg.create_dimension_views.begin',
705: 'Begin create_dimension_views');

Line 707: l_global_ecm := zpb_ecm.get_global_ecm(p_aw);

703: begin
704: zpb_log.write ('zpb_olap_views_pkg.create_dimension_views.begin',
705: 'Begin create_dimension_views');
706: l_aw := zpb_aw.get_schema||'.'||p_aw||'!';
707: l_global_ecm := zpb_ecm.get_global_ecm(p_aw);
708:
709: if (p_dimension is null) then
710: ZPB_AW.EXECUTE ('lmt '||l_aw||l_global_ecm.DimDim||' to '||l_aw||
711: l_global_ecm.IsDataDimVar ||' eq YES');

Line 734: l_dim_data := zpb_ecm.get_dimension_data(l_ecmDim, p_aw);

730: l_ecmDim := substr (l_dims, i, j-i);
731: i := j+1;
732: end if;
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);

Line 735: l_dim_ecm := zpb_ecm.get_dimension_ecm(l_ecmDim, p_aw);

731: i := j+1;
732: end if;
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);

Line 969: l_dim_ecm zpb_ecm.dimension_ecm;

965: l_instType varchar2(30);
966: l_type varchar2(30);
967: l_preCmd varchar2(4000);
968:
969: l_dim_ecm zpb_ecm.dimension_ecm;
970: l_dim_data zpb_ecm.dimension_data;
971:
972: begin
973:

Line 970: l_dim_data zpb_ecm.dimension_data;

966: l_type varchar2(30);
967: l_preCmd varchar2(4000);
968:
969: l_dim_ecm zpb_ecm.dimension_ecm;
970: l_dim_data zpb_ecm.dimension_data;
971:
972: begin
973:
974: zpb_log.write ('zpb_olap_views_pkg.create_security_views.begin',

Line 1030: l_dim_data := zpb_ecm.get_dimension_data (l_ecmDim, p_aw);

1026: l_ecmDim := substr (p_dims, i, j-i);
1027: i := j+1;
1028: end if;
1029:
1030: l_dim_data := zpb_ecm.get_dimension_data (l_ecmDim, p_aw);
1031: l_dim_ecm := zpb_ecm.get_dimension_ecm (l_ecmDim, p_aw);
1032: --
1033: -- Create the obj type:
1034: --

Line 1031: l_dim_ecm := zpb_ecm.get_dimension_ecm (l_ecmDim, p_aw);

1027: i := j+1;
1028: end if;
1029:
1030: l_dim_data := zpb_ecm.get_dimension_data (l_ecmDim, p_aw);
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);

Line 1140: l_global_ecm zpb_ecm.global_ecm;

1136: hj number;
1137: l_count number;
1138: l_statement varchar2(16000);
1139: l_proc varchar2(16000);
1140: l_global_ecm zpb_ecm.global_ecm;
1141: l_dim_ecm zpb_ecm.dimension_ecm;
1142: l_dim_data zpb_ecm.dimension_data;
1143: begin
1144: zpb_log.write ('zpb_olap_view_pkg.create_view_structures.begin',

Line 1141: l_dim_ecm zpb_ecm.dimension_ecm;

1137: l_count number;
1138: l_statement varchar2(16000);
1139: l_proc varchar2(16000);
1140: l_global_ecm zpb_ecm.global_ecm;
1141: l_dim_ecm zpb_ecm.dimension_ecm;
1142: l_dim_data zpb_ecm.dimension_data;
1143: begin
1144: zpb_log.write ('zpb_olap_view_pkg.create_view_structures.begin',
1145: 'Building AW metadata views');

Line 1142: l_dim_data zpb_ecm.dimension_data;

1138: l_statement varchar2(16000);
1139: l_proc varchar2(16000);
1140: l_global_ecm zpb_ecm.global_ecm;
1141: l_dim_ecm zpb_ecm.dimension_ecm;
1142: l_dim_data zpb_ecm.dimension_data;
1143: begin
1144: zpb_log.write ('zpb_olap_view_pkg.create_view_structures.begin',
1145: 'Building AW metadata views');
1146:

Line 1147: l_global_ecm := zpb_ecm.get_global_ecm (p_dataAw);

1143: begin
1144: zpb_log.write ('zpb_olap_view_pkg.create_view_structures.begin',
1145: 'Building AW metadata views');
1146:
1147: l_global_ecm := zpb_ecm.get_global_ecm (p_dataAw);
1148: l_schema := zpb_aw.get_schema;
1149: l_aw := l_schema||'.'||p_dataAw||'!';
1150:
1151: --

Line 1220: l_dim_ecm := zpb_ecm.get_dimension_ecm (l_ecmDim, p_dataAw);

1216: l_ecmDim := substr (l_dims, i, j-i);
1217: i := j+1;
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||', ';