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_AW

Line 32: l_aw := zpb_aw.get_schema||'.'||p_aw||'!';

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');
36: zpb_aw.execute('lmt '||l_aw||l_global_ecm.AttrDim||' to '||

Line 34: zpb_aw.execute('push oknullstatus '||l_aw||l_global_ecm.AttrDim);

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');
36: zpb_aw.execute('lmt '||l_aw||l_global_ecm.AttrDim||' to '||
37: l_aw||l_global_attr.DomainDimRel||' eq lmt ('||
38: l_aw||l_global_ecm.DimDim||' to '''||p_dim||''')');

Line 35: zpb_aw.execute('oknullstatus = yes');

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');
36: zpb_aw.execute('lmt '||l_aw||l_global_ecm.AttrDim||' to '||
37: l_aw||l_global_attr.DomainDimRel||' eq lmt ('||
38: l_aw||l_global_ecm.DimDim||' to '''||p_dim||''')');
39:

Line 36: zpb_aw.execute('lmt '||l_aw||l_global_ecm.AttrDim||' to '||

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');
36: zpb_aw.execute('lmt '||l_aw||l_global_ecm.AttrDim||' to '||
37: l_aw||l_global_attr.DomainDimRel||' eq lmt ('||
38: l_aw||l_global_ecm.DimDim||' to '''||p_dim||''')');
39:
40: l_attrs := zpb_aw.interp ('shw CM.GETDIMVALUES('''||l_aw||

Line 40: l_attrs := zpb_aw.interp ('shw CM.GETDIMVALUES('''||l_aw||

36: zpb_aw.execute('lmt '||l_aw||l_global_ecm.AttrDim||' to '||
37: l_aw||l_global_attr.DomainDimRel||' eq lmt ('||
38: l_aw||l_global_ecm.DimDim||' to '''||p_dim||''')');
39:
40: l_attrs := zpb_aw.interp ('shw CM.GETDIMVALUES('''||l_aw||
41: l_global_ecm.AttrDim||''' YES)');
42:
43: if (l_attrs <> 'NA') then
44: i := 1;

Line 65: zpb_aw.execute('pop oknullstatus '||l_global_ecm.AttrDim);

61: exit when j = 0;
62: end loop;
63: end if;
64:
65: zpb_aw.execute('pop oknullstatus '||l_global_ecm.AttrDim);
66: end BUILD_ATTRIBUTE_MAP;
67:
68: -------------------------------------------------------------------------------
69: -- BUILD_BEGIN_MAP

Line 123: l_aw := zpb_aw.get_schema||'.'||p_aw||'!';

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;
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);

Line 201: l_aw := zpb_aw.get_schema||'.'||p_aw;

197: zpb_log.write ('zpb_olap_views_pkg.call_ddl.begin',
198: 'Creating '||p_dimView||' structures');
199:
200: if (p_aw <> 'PERSONAL' and p_aw <> 'EXPRESS' and instr(p_aw, '.') = 0) then
201: l_aw := zpb_aw.get_schema||'.'||p_aw;
202: else
203: l_aw := p_aw;
204: end if;
205:

Line 349: l_aw := zpb_aw.get_schema||'.'||p_aw||'!';

345:
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

Line 354: zpb_aw.execute ('lmt '||l_aw||l_global_ecm.AttrDim||' to all');

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||
356: l_global_ecm.AttrDim||''' yes)');
357: else
358: l_attrs := p_attributes;

Line 355: l_attrs := ZPB_AW.INTERP ('shw CM.GETDIMVALUES('''||l_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||
356: l_global_ecm.AttrDim||''' yes)');
357: else
358: l_attrs := p_attributes;
359: end if;

Line 391: zpb_aw.interp ('shw '||l_aw||l_global_ecm.ExpObjVar||' ('||

387: (p_aw, p_type, l_attr);
388: DROP_VIEW (l_attrView);
389:
390: l_attrObj :=
391: zpb_aw.interp ('shw '||l_aw||l_global_ecm.ExpObjVar||' ('||
392: l_aw||l_global_ecm.DimDim||' '||
393: l_aw||l_attr_ecm.RangeDimRel||' ('||l_global_ecm.AttrDim||
394: ' '''||l_attr||'''))');
395:

Line 409: zpb_aw.interp ('shw obj(property ''LDSCVAR'' '''||l_attrObj||''')')||'

405: l_pgidCol||','||l_levelCol||','||l_longCol||','||l_shortCol;
406:
407: l_proc := 'DIMENSION '||l_membCol||' FROM '||l_attrObj||'
408: WITH ATTRIBUTE '||l_shortCol||' FROM '||
409: zpb_aw.interp ('shw obj(property ''LDSCVAR'' '''||l_attrObj||''')')||'
410: ATTRIBUTE '||l_longCol||' FROM '||
411: zpb_aw.interp ('shw obj(property ''LDSCVAR'' '''||l_attrObj||''')')||'
412: ATTRIBUTE '||l_levelCol||' FROM '||l_attrObj;
413: l_proc := ''''||l_proc||'''';

Line 411: zpb_aw.interp ('shw obj(property ''LDSCVAR'' '''||l_attrObj||''')')||'

407: l_proc := 'DIMENSION '||l_membCol||' FROM '||l_attrObj||'
408: WITH ATTRIBUTE '||l_shortCol||' FROM '||
409: zpb_aw.interp ('shw obj(property ''LDSCVAR'' '''||l_attrObj||''')')||'
410: ATTRIBUTE '||l_longCol||' FROM '||
411: zpb_aw.interp ('shw obj(property ''LDSCVAR'' '''||l_attrObj||''')')||'
412: ATTRIBUTE '||l_levelCol||' FROM '||l_attrObj;
413: l_proc := ''''||l_proc||'''';
414:
415: if (p_type = 'PERSONAL') then

Line 505: if (ZPB_AW.INTERPBOOL ('shw SC.FIRSTVIEW(''' || p_view || ''')')) then

501: -- processing run measures
502: l_cubes_of_shape :=0;
503:
504: if(p_awType<>'PERSONAL') then
505: if (ZPB_AW.INTERPBOOL ('shw SC.FIRSTVIEW(''' || p_view || ''')')) then
506: l_cubes_of_shape :=1;
507: else
508: l_cubes_of_shape :=2;
509: end if;

Line 535: if (zpb_aw.interp('shw obj(dimmax '''||l_aw||l_dim_ecm.HierDim||''')')

531: l_dim_data.ExpObj;
532:
533: l_preCmd := l_preCmd||' \\\'''||l_dim_data.ExpObj||'\\\''';
534:
535: if (zpb_aw.interp('shw obj(dimmax '''||l_aw||l_dim_ecm.HierDim||''')')
536: <> '0') then
537: l_lmap := l_lmap ||'\nWITH ';
538: zpb_aw.execute ('lmt '||l_aw||l_dim_ecm.HierDim||' to all');
539: l_hiers := zpb_aw.interp ('shw CM.GETDIMVALUES ('''||l_aw||

Line 538: zpb_aw.execute ('lmt '||l_aw||l_dim_ecm.HierDim||' to all');

534:
535: if (zpb_aw.interp('shw obj(dimmax '''||l_aw||l_dim_ecm.HierDim||''')')
536: <> '0') then
537: l_lmap := l_lmap ||'\nWITH ';
538: zpb_aw.execute ('lmt '||l_aw||l_dim_ecm.HierDim||' to all');
539: l_hiers := zpb_aw.interp ('shw CM.GETDIMVALUES ('''||l_aw||
540: l_dim_ecm.HierDim||''' YES)');
541: hi := 1;
542: loop

Line 539: l_hiers := zpb_aw.interp ('shw CM.GETDIMVALUES ('''||l_aw||

535: if (zpb_aw.interp('shw obj(dimmax '''||l_aw||l_dim_ecm.HierDim||''')')
536: <> '0') then
537: l_lmap := l_lmap ||'\nWITH ';
538: zpb_aw.execute ('lmt '||l_aw||l_dim_ecm.HierDim||' to all');
539: l_hiers := zpb_aw.interp ('shw CM.GETDIMVALUES ('''||l_aw||
540: l_dim_ecm.HierDim||''' YES)');
541: hi := 1;
542: loop
543: hj := instr (l_hiers, ' ', hi);

Line 621: ZPB_AW.EXECUTE (p_lmap||' = '''||l_lmap||'''');

617: -- do not update limit map and col count var when creating personal cube views
618: -- as no personal is attached at the time
619: if p_mode <> 'PERSONAL_JUST_CREATE' then
620:
621: ZPB_AW.EXECUTE (p_lmap||' = '''||l_lmap||'''');
622:
623: --
624: -- Set up the column count information
625: --

Line 626: ZPB_AW.EXECUTE (p_colVar||' = '||l_count);

622:
623: --
624: -- Set up the column count information
625: --
626: ZPB_AW.EXECUTE (p_colVar||' = '||l_count);
627:
628: end if;
629:
630: -- do not drop and re-create the view if this is called for the sole reason

Line 706: l_aw := zpb_aw.get_schema||'.'||p_aw||'!';

702:
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||

Line 710: ZPB_AW.EXECUTE ('lmt '||l_aw||l_global_ecm.DimDim||' to '||l_aw||

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');
712: l_dims := ZPB_AW.INTERP ('shw CM.GETDIMVALUES('''||l_aw||
713: l_global_ecm.DimDim||''' yes)');
714: else

Line 712: l_dims := ZPB_AW.INTERP ('shw CM.GETDIMVALUES('''||l_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');
712: l_dims := ZPB_AW.INTERP ('shw CM.GETDIMVALUES('''||l_aw||
713: l_global_ecm.DimDim||''' yes)');
714: else
715: l_dims := p_dimension;
716: end if;

Line 718: ZPB_AW.EXECUTE ('push oknullstatus');

714: else
715: l_dims := p_dimension;
716: end if;
717:
718: ZPB_AW.EXECUTE ('push oknullstatus');
719: ZPB_AW.EXECUTE ('oknullstatus = yes');
720:
721: --
722: -- Get the dimensions and loop over them:

Line 719: ZPB_AW.EXECUTE ('oknullstatus = yes');

715: l_dims := p_dimension;
716: end if;
717:
718: ZPB_AW.EXECUTE ('push oknullstatus');
719: ZPB_AW.EXECUTE ('oknullstatus = yes');
720:
721: --
722: -- Get the dimensions and loop over them:
723: --

Line 742: if (ZPB_AW.INTERP('shw obj(dimmax '''||l_aw||l_dim_ecm.HierDim||''')')

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:
745: hi := 1;
746: if (p_hierarchy is null) then

Line 747: l_hiers := ZPB_AW.INTERP('shw CM.GETDIMVALUES('''||l_aw||

743: <> '0') then
744:
745: hi := 1;
746: if (p_hierarchy is null) then
747: l_hiers := ZPB_AW.INTERP('shw CM.GETDIMVALUES('''||l_aw||
748: l_dim_ecm.HierDim||''')');
749: else
750: l_hiers := p_hierarchy;
751: end if;

Line 753: ZPB_AW.EXECUTE ('push '||l_aw||l_dim_ecm.LevelDim||' '||l_aw||

749: else
750: l_hiers := p_hierarchy;
751: end if;
752:
753: ZPB_AW.EXECUTE ('push '||l_aw||l_dim_ecm.LevelDim||' '||l_aw||
754: l_dim_ecm.HierDim||' '||l_aw||l_dim_data.ExpObj);
755:
756: loop
757: hj := instr (l_hiers, ' ', hi);

Line 767: ZPB_AW.EXECUTE('lmt '||l_aw||l_dim_ecm.HierDim||' to '''||

763: end if;
764:
765: BUILD_BEGIN_MAP (l_statement, l_cols, l_ecmDim);
766:
767: ZPB_AW.EXECUTE('lmt '||l_aw||l_dim_ecm.HierDim||' to '''||
768: l_hier||'''');
769:
770: l_statement := l_statement||l_parentCol||' varchar2(32),'||
771: l_gidCol||' number(10), '||l_pgidCol||' number(10), '||

Line 785: ZPB_AW.EXECUTE('lmt '||l_aw||l_dim_ecm.LevelDim||

781:
782: --
783: -- Get the Levels:
784: --
785: ZPB_AW.EXECUTE('lmt '||l_aw||l_dim_ecm.LevelDim||
786: ' to '||l_aw||l_dim_ecm.HierLevelVS);
787: ZPB_AW.EXECUTE('sort '||l_aw||l_dim_ecm.LevelDim||
788: ' a '||l_aw||l_dim_ecm.LevelDepthVar);
789: l_hierLevels := ' '||ZPB_AW.INTERP('shw CM.GETDIMVALUES('''||l_aw||

Line 787: ZPB_AW.EXECUTE('sort '||l_aw||l_dim_ecm.LevelDim||

783: -- Get the Levels:
784: --
785: ZPB_AW.EXECUTE('lmt '||l_aw||l_dim_ecm.LevelDim||
786: ' to '||l_aw||l_dim_ecm.HierLevelVS);
787: ZPB_AW.EXECUTE('sort '||l_aw||l_dim_ecm.LevelDim||
788: ' a '||l_aw||l_dim_ecm.LevelDepthVar);
789: l_hierLevels := ' '||ZPB_AW.INTERP('shw CM.GETDIMVALUES('''||l_aw||
790: l_dim_ecm.LevelDim||''', YES)')||' ';
791:

Line 789: l_hierLevels := ' '||ZPB_AW.INTERP('shw CM.GETDIMVALUES('''||l_aw||

785: ZPB_AW.EXECUTE('lmt '||l_aw||l_dim_ecm.LevelDim||
786: ' to '||l_aw||l_dim_ecm.HierLevelVS);
787: ZPB_AW.EXECUTE('sort '||l_aw||l_dim_ecm.LevelDim||
788: ' a '||l_aw||l_dim_ecm.LevelDepthVar);
789: l_hierLevels := ' '||ZPB_AW.INTERP('shw CM.GETDIMVALUES('''||l_aw||
790: l_dim_ecm.LevelDim||''', YES)')||' ';
791:
792: ZPB_AW.EXECUTE('lmt '||l_aw||l_dim_ecm.LevelDim||' to all');
793: ZPB_AW.EXECUTE('sort '||l_aw||l_dim_ecm.LevelDim||

Line 792: ZPB_AW.EXECUTE('lmt '||l_aw||l_dim_ecm.LevelDim||' to all');

788: ' a '||l_aw||l_dim_ecm.LevelDepthVar);
789: l_hierLevels := ' '||ZPB_AW.INTERP('shw CM.GETDIMVALUES('''||l_aw||
790: l_dim_ecm.LevelDim||''', YES)')||' ';
791:
792: ZPB_AW.EXECUTE('lmt '||l_aw||l_dim_ecm.LevelDim||' to all');
793: ZPB_AW.EXECUTE('sort '||l_aw||l_dim_ecm.LevelDim||
794: ' a '||l_aw||l_dim_ecm.LevelDepthVar);
795: l_levels := ZPB_AW.INTERP ('shw CM.GETDIMVALUES('''||l_aw||
796: l_dim_ecm.LevelDim||''', YES)');

Line 793: ZPB_AW.EXECUTE('sort '||l_aw||l_dim_ecm.LevelDim||

789: l_hierLevels := ' '||ZPB_AW.INTERP('shw CM.GETDIMVALUES('''||l_aw||
790: l_dim_ecm.LevelDim||''', YES)')||' ';
791:
792: ZPB_AW.EXECUTE('lmt '||l_aw||l_dim_ecm.LevelDim||' to all');
793: ZPB_AW.EXECUTE('sort '||l_aw||l_dim_ecm.LevelDim||
794: ' a '||l_aw||l_dim_ecm.LevelDepthVar);
795: l_levels := ZPB_AW.INTERP ('shw CM.GETDIMVALUES('''||l_aw||
796: l_dim_ecm.LevelDim||''', YES)');
797:

Line 795: l_levels := ZPB_AW.INTERP ('shw CM.GETDIMVALUES('''||l_aw||

791:
792: ZPB_AW.EXECUTE('lmt '||l_aw||l_dim_ecm.LevelDim||' to all');
793: ZPB_AW.EXECUTE('sort '||l_aw||l_dim_ecm.LevelDim||
794: ' a '||l_aw||l_dim_ecm.LevelDepthVar);
795: l_levels := ZPB_AW.INTERP ('shw CM.GETDIMVALUES('''||l_aw||
796: l_dim_ecm.LevelDim||''', YES)');
797:
798: li := 1;
799: loop

Line 807: ZPB_AW.EXECUTE ('lmt '||l_aw||l_dim_data.ExpObj||' to '||

803: else
804: l_level := substr (l_levels, li, lj-li);
805: li := lj+1;
806: end if;
807: ZPB_AW.EXECUTE ('lmt '||l_aw||l_dim_data.ExpObj||' to '||
808: l_aw||l_dim_ecm.HOrderVS);
809: ZPB_AW.EXECUTE ('lmt '||l_aw||l_dim_data.ExpObj||' keep '||
810: l_aw||l_dim_ecm.LevelRel||' '''||l_level||
811: '''');

Line 809: ZPB_AW.EXECUTE ('lmt '||l_aw||l_dim_data.ExpObj||' keep '||

805: li := lj+1;
806: end if;
807: ZPB_AW.EXECUTE ('lmt '||l_aw||l_dim_data.ExpObj||' to '||
808: l_aw||l_dim_ecm.HOrderVS);
809: ZPB_AW.EXECUTE ('lmt '||l_aw||l_dim_data.ExpObj||' keep '||
810: l_aw||l_dim_ecm.LevelRel||' '''||l_level||
811: '''');
812: l_length := to_number(ZPB_AW.INTERP('shw convert (statlen ('||
813: l_aw||l_dim_data.ExpObj||') text 0 no no)'));

Line 812: l_length := to_number(ZPB_AW.INTERP('shw convert (statlen ('||

808: l_aw||l_dim_ecm.HOrderVS);
809: ZPB_AW.EXECUTE ('lmt '||l_aw||l_dim_data.ExpObj||' keep '||
810: l_aw||l_dim_ecm.LevelRel||' '''||l_level||
811: '''');
812: l_length := to_number(ZPB_AW.INTERP('shw convert (statlen ('||
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

Line 859: ZPB_AW.EXECUTE ('pop '||l_aw||l_dim_ecm.LevelDim||' '||l_aw||

855:
856: exit when hj = 0;
857: end loop;
858:
859: ZPB_AW.EXECUTE ('pop '||l_aw||l_dim_ecm.LevelDim||' '||l_aw||
860: l_dim_ecm.HierDim||' '||l_aw||l_dim_data.ExpObj);
861:
862: end if;
863:

Line 880: if (ZPB_AW.INTERP('shw obj(dimmax '''||l_aw||l_dim_ecm.HierDim||''')')

876: l_levelCol||' varchar2(32), '||l_levelRelCol||' varchar2(16), ';
877:
878: l_cols := l_cols||' NULL '||l_parentCol||',0 '||l_gidCol||',NULL '||
879: l_pgidCol||','||l_levelCol||',';
880: if (ZPB_AW.INTERP('shw obj(dimmax '''||l_aw||l_dim_ecm.HierDim||''')')
881: <> '0') then
882: l_cols := l_cols||l_levelRelCol||',';
883: else
884: l_cols := l_cols||'NULL '||l_levelRelCol||',';

Line 922: ZPB_AW.EXECUTE ('call DB.BUILD.LMAP ('''||zpb_aw.get_schema||'.'||

918: CREATE_ATTRIBUTE_VIEWS (p_aw, 'SHARED');
919: CREATE_ATTRIBUTE_VIEWS (p_aw, 'PERSONAL');
920: end if;
921:
922: ZPB_AW.EXECUTE ('call DB.BUILD.LMAP ('''||zpb_aw.get_schema||'.'||
923: p_aw||''')');
924: ZPB_AW.EXECUTE ('pop oknullstatus');
925:
926: zpb_log.write ('zpb_olap_views_pkg.create_dimension_views.end',

Line 924: ZPB_AW.EXECUTE ('pop oknullstatus');

920: end if;
921:
922: ZPB_AW.EXECUTE ('call DB.BUILD.LMAP ('''||zpb_aw.get_schema||'.'||
923: p_aw||''')');
924: ZPB_AW.EXECUTE ('pop oknullstatus');
925:
926: zpb_log.write ('zpb_olap_views_pkg.create_dimension_views.end',
927: 'End create_dimension_views');
928:

Line 978: l_aw := zpb_aw.get_schema||'.'||p_aw||'!';

974: zpb_log.write ('zpb_olap_views_pkg.create_security_views.begin',
975: 'Building '||p_measures||' for view '||p_measView||
976: ' with dims ('||p_dims||')');
977:
978: l_aw := zpb_aw.get_schema||'.'||p_aw||'!';
979:
980: l_measState := 'OBJECT (';
981:
982: l_objName := 'OBJECT NAME'' NA NA NA';

Line 1044: if (zpb_aw.interp('shw obj(dimmax '''||l_aw||l_dim_ecm.HierDim||''')')

1040:
1041: l_preCmd := l_preCmd||' \'''''||l_dim_data.ExpObj||'\''''';
1042: l_cols := l_cols||l_dimCol||',';
1043:
1044: if (zpb_aw.interp('shw obj(dimmax '''||l_aw||l_dim_ecm.HierDim||''')')
1045: <> '0') then
1046: l_measProc := l_measProc||'
1047: WITH ';
1048: zpb_aw.execute ('lmt '||l_aw||l_dim_ecm.HierDim||' to all');

Line 1048: zpb_aw.execute ('lmt '||l_aw||l_dim_ecm.HierDim||' to all');

1044: if (zpb_aw.interp('shw obj(dimmax '''||l_aw||l_dim_ecm.HierDim||''')')
1045: <> '0') then
1046: l_measProc := l_measProc||'
1047: WITH ';
1048: zpb_aw.execute ('lmt '||l_aw||l_dim_ecm.HierDim||' to all');
1049: l_hiers := zpb_aw.interp ('shw CM.GETDIMVALUES ('''||l_aw||
1050: l_dim_ecm.HierDim||''' YES)');
1051: hi := 1;
1052: loop

Line 1049: l_hiers := zpb_aw.interp ('shw CM.GETDIMVALUES ('''||l_aw||

1045: <> '0') then
1046: l_measProc := l_measProc||'
1047: WITH ';
1048: zpb_aw.execute ('lmt '||l_aw||l_dim_ecm.HierDim||' to all');
1049: l_hiers := zpb_aw.interp ('shw CM.GETDIMVALUES ('''||l_aw||
1050: l_dim_ecm.HierDim||''' YES)');
1051: hi := 1;
1052: loop
1053: hj := instr (l_hiers, ' ', hi);

Line 1089: zpb_aw.get_schema||'.'||p_aw||'\'''')''''

1085:
1086: l_measState := l_measState||') ';
1087: l_measProc := l_measProc||'
1088: PREDMLCMD ''''call MD.LMT.DIMS(joinlines('||l_preCmd||'), \'''''||
1089: zpb_aw.get_schema||'.'||p_aw||'\'''')''''
1090: POSTDMLCMD ''''call MD.LMT.DIMS.POST(joinlines('||l_preCmd||'), \'''''||
1091: zpb_aw.get_schema||'.'||p_aw||'\'''')''''';
1092:
1093: --

Line 1091: zpb_aw.get_schema||'.'||p_aw||'\'''')''''';

1087: l_measProc := l_measProc||'
1088: PREDMLCMD ''''call MD.LMT.DIMS(joinlines('||l_preCmd||'), \'''''||
1089: zpb_aw.get_schema||'.'||p_aw||'\'''')''''
1090: POSTDMLCMD ''''call MD.LMT.DIMS.POST(joinlines('||l_preCmd||'), \'''''||
1091: zpb_aw.get_schema||'.'||p_aw||'\'''')''''';
1092:
1093: --
1094: -- Remove trailing comma:
1095: --

Line 1148: l_schema := zpb_aw.get_schema;

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: --
1152: -- Build Security Scoping Status table

Line 1201: execute immediate 'drop table '||zpb_aw.get_schema||'.'||l_dataExcView;

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;
1202: exception
1203: when others then
1204: null;
1205: end;

Line 1207: l_statement := 'create table '||zpb_aw.get_schema||'.'||l_dataExcView||'(';

1203: when others then
1204: null;
1205: end;
1206:
1207: l_statement := 'create table '||zpb_aw.get_schema||'.'||l_dataExcView||'(';
1208: l_dims := zpb_aw.interp ('shw CM.GETDATADIMS');
1209:
1210: i := 1;
1211: loop

Line 1208: l_dims := zpb_aw.interp ('shw CM.GETDATADIMS');

1204: null;
1205: end;
1206:
1207: l_statement := 'create table '||zpb_aw.get_schema||'.'||l_dataExcView||'(';
1208: l_dims := zpb_aw.interp ('shw CM.GETDATADIMS');
1209:
1210: i := 1;
1211: loop
1212: j := instr (l_dims, ' ', i);

Line 1226: zpb_aw.execute ('lmt '||l_aw||l_dim_ecm.HierDim||' to all');

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');
1227: l_hiers := zpb_aw.interp ('shw CM.GETDIMVALUES ('''||l_aw||
1228: l_dim_ecm.HierDim||''' YES)');
1229: hi := 1;
1230: loop

Line 1227: l_hiers := zpb_aw.interp ('shw CM.GETDIMVALUES ('''||l_aw||

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');
1227: l_hiers := zpb_aw.interp ('shw CM.GETDIMVALUES ('''||l_aw||
1228: l_dim_ecm.HierDim||''' YES)');
1229: hi := 1;
1230: loop
1231: hj := instr (l_hiers, ' ', hi);

Line 1262: zpb_aw.get_schema||'.'||l_dataExcView;

1258:
1259: execute immediate l_statement;
1260:
1261: execute immediate 'create synonym '||l_dataExcView||' for '||
1262: zpb_aw.get_schema||'.'||l_dataExcView;
1263:
1264: --
1265: -- Create the 4 currency view tables:
1266: --

Line 1267: if (zpb_aw.interp ('shw lmt('||l_aw||l_global_ecm.DimDim||' to '||l_aw||

1263:
1264: --
1265: -- Create the 4 currency view tables:
1266: --
1267: if (zpb_aw.interp ('shw lmt('||l_aw||l_global_ecm.DimDim||' to '||l_aw||
1268: l_global_ecm.DimTypeRel||' eq ''FROM_CURRENCY'')')<>'NA') then
1269: l_statement := 'OBJECT(MEMBER_ID VARCHAR2(30), MEMBER_CODE VARCHAR2(15),'
1270: ||'MEMBER_NAME VARCHAR2(80), MEMBER_DESC VARCHAR2(240))';
1271: l_proc := '''DIMENSION MEMBER_ID FROM TO.CURRENCY

Line 1278: call_ddl (l_view, zpb_aw.get_schema||'.'||p_dataAw, l_statement, l_proc, '*');

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),'
1281: ||'MEMBER_NAME VARCHAR2(80), MEMBER_DESC VARCHAR2(240))';
1282: l_proc := '''DIMENSION MEMBER_ID FROM RATES

Line 1289: call_ddl (l_view, zpb_aw.get_schema||'.'||p_dataAw, l_statement, l_proc, '*');

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),'
1292: ||'MEMBER_NAME VARCHAR2(100), MEMBER_DESC VARCHAR2(240))';
1293: l_proc := '''DIMENSION MEMBER_ID FROM SCENARIO

Line 1300: call_ddl (l_view, zpb_aw.get_schema||'.'||p_dataAw, l_statement, l_proc, '*');

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:
1303: zpb_log.write ('zpb_olap_view_pkg.create_view_structures.end',
1304: 'Done building AW metadata views');

Line 1338: l_personal_alias_flag := ZPB_AW_STATUS.GET_PERSONAL_ALIAS_FLAG();

1334: -- First, initialize the session. Concurrent req's have already been
1335: -- initialized at least for the shared AW
1336: -- and ZPB_CURRENT_USER_V is not valid for them:
1337: --
1338: l_personal_alias_flag := ZPB_AW_STATUS.GET_PERSONAL_ALIAS_FLAG();
1339: if (not (FND_GLOBAL.CONC_REQUEST_ID > 0)) then
1340:
1341: -- if zpb_current_user_v is not initialized and we get no data here,
1342: -- we must be in an open-sql session - only shared AW used and it is

Line 1357: ZPB_AW.INTERPBOOL ('shw aw(attached ''SHARED'')')) then

1353: -- Check to see if shared attached, and its the right shared/bus area:
1354: --
1355: l_reattach := false;
1356: if (p_type = 'SHARED' and
1357: ZPB_AW.INTERPBOOL ('shw aw(attached ''SHARED'')')) then
1358: if (ZPB_AW.INTERPBOOL ('shw exists(''SHARED!AW.ATTACH.TIME'')')) then
1359: l_buff := ZPB_AW.INTERP('shw SHARED!AW.ATTACH.TIME');
1360: --
1361: -- Comment out until we resolve bug# 4887248

Line 1358: if (ZPB_AW.INTERPBOOL ('shw exists(''SHARED!AW.ATTACH.TIME'')')) then

1354: --
1355: l_reattach := false;
1356: if (p_type = 'SHARED' and
1357: ZPB_AW.INTERPBOOL ('shw aw(attached ''SHARED'')')) then
1358: if (ZPB_AW.INTERPBOOL ('shw exists(''SHARED!AW.ATTACH.TIME'')')) then
1359: l_buff := ZPB_AW.INTERP('shw SHARED!AW.ATTACH.TIME');
1360: --
1361: -- Comment out until we resolve bug# 4887248
1362: --

Line 1359: l_buff := ZPB_AW.INTERP('shw SHARED!AW.ATTACH.TIME');

1355: l_reattach := false;
1356: if (p_type = 'SHARED' and
1357: ZPB_AW.INTERPBOOL ('shw aw(attached ''SHARED'')')) then
1358: if (ZPB_AW.INTERPBOOL ('shw exists(''SHARED!AW.ATTACH.TIME'')')) then
1359: l_buff := ZPB_AW.INTERP('shw SHARED!AW.ATTACH.TIME');
1360: --
1361: -- Comment out until we resolve bug# 4887248
1362: --
1363: /*

Line 1386: not ZPB_AW.INTERPBOOL ('shw aw(attached ''SHARED'')'))) then

1382: if (l_reattach or
1383: sys_context('ZPB_CONTEXT', 'business_area_id') is null or
1384: sys_context('ZPB_CONTEXT', 'business_area_id') <> l_ba_id or
1385: (p_type = 'SHARED' and
1386: not ZPB_AW.INTERPBOOL ('shw aw(attached ''SHARED'')'))) then
1387:
1388: ZPB_AW.INITIALIZE (p_api_version => 1.0,
1389: x_return_status => l_ret_stat,
1390: x_msg_count => l_msg_cnt,

Line 1388: ZPB_AW.INITIALIZE (p_api_version => 1.0,

1384: sys_context('ZPB_CONTEXT', 'business_area_id') <> l_ba_id or
1385: (p_type = 'SHARED' and
1386: not ZPB_AW.INTERPBOOL ('shw aw(attached ''SHARED'')'))) then
1387:
1388: ZPB_AW.INITIALIZE (p_api_version => 1.0,
1389: x_return_status => l_ret_stat,
1390: x_msg_count => l_msg_cnt,
1391: x_msg_data => l_buff,
1392: p_business_area_id => l_ba_id,

Line 1402: select ZPB_AW.GET_SCHEMA||'.'||PERSONAL_AW

1398: fnd_global.user_id);
1399: end if;
1400:
1401: if (upper(p_type) = 'PERSONAL') then
1402: select ZPB_AW.GET_SCHEMA||'.'||PERSONAL_AW
1403: into l_persAw
1404: from ZPB_USERS
1405: where BUSINESS_AREA_ID = l_ba_id
1406: and USER_ID = l_shadow;

Line 1411: if (l_personal_alias_flag <> 'Y' and not ZPB_AW.INTERPBOOL

1407:
1408: --
1409: -- Check to see if personal attached, and it is the right personal
1410: --
1411: if (l_personal_alias_flag <> 'Y' and not ZPB_AW.INTERPBOOL
1412: ('shw aw(attached ''PERSONAL'') and aw(attached '''||l_persAw||
1413: ''') and aw(name ''PERSONAL'') eq aw(name '''||l_persAw||''')'))
1414: then
1415: ZPB_AW.INITIALIZE_USER (p_api_version => 1.0,

Line 1415: ZPB_AW.INITIALIZE_USER (p_api_version => 1.0,

1411: if (l_personal_alias_flag <> 'Y' and not ZPB_AW.INTERPBOOL
1412: ('shw aw(attached ''PERSONAL'') and aw(attached '''||l_persAw||
1413: ''') and aw(name ''PERSONAL'') eq aw(name '''||l_persAw||''')'))
1414: then
1415: ZPB_AW.INITIALIZE_USER (p_api_version => 1.0,
1416: x_return_status => l_ret_stat,
1417: x_msg_count => l_msg_cnt,
1418: x_msg_data => l_buff,
1419: p_user => l_shadow,

Line 1426: return zpb_aw.interp

1422: end if;
1423: end if;
1424:
1425: if (p_hier is null) then
1426: return zpb_aw.interp
1427: ('shw &joinchars('''||p_type||'!'' obj(property ''LIMITMAPVAR'' '''||
1428: p_dim||'''))');
1429: else
1430: l_buff := p_type||'!'||zpb_aw.interp('shw obj(property ''HIERDIM'' '''||

Line 1430: l_buff := p_type||'!'||zpb_aw.interp('shw obj(property ''HIERDIM'' '''||

1426: return zpb_aw.interp
1427: ('shw &joinchars('''||p_type||'!'' obj(property ''LIMITMAPVAR'' '''||
1428: p_dim||'''))');
1429: else
1430: l_buff := p_type||'!'||zpb_aw.interp('shw obj(property ''HIERDIM'' '''||
1431: p_dim||''')');
1432: return zpb_aw.interp
1433: ('shw &joinchars('''||p_type||'!'' obj(property ''LIMITMAPVAR'' '''||
1434: l_buff||''')) ('||l_buff||' '''||p_hier||''')');

Line 1432: return zpb_aw.interp

1428: p_dim||'''))');
1429: else
1430: l_buff := p_type||'!'||zpb_aw.interp('shw obj(property ''HIERDIM'' '''||
1431: p_dim||''')');
1432: return zpb_aw.interp
1433: ('shw &joinchars('''||p_type||'!'' obj(property ''LIMITMAPVAR'' '''||
1434: l_buff||''')) ('||l_buff||' '''||p_hier||''')');
1435: end if;
1436: end GET_LIMITMAP;

Line 1474: l_code_aw := ZPB_AW.GET_SCHEMA||'.'||ZPB_AW.GET_CODE_AW( l_shadow ) ;

1470: null;
1471: end;
1472:
1473: -- check if code aw is attached
1474: l_code_aw := ZPB_AW.GET_SCHEMA||'.'||ZPB_AW.GET_CODE_AW( l_shadow ) ;
1475: l_code_aw_attach := false;
1476: if NOT ZPB_AW.INTERPBOOL ('shw aw(attached '''|| l_code_aw ||''')') then
1477: l_code_aw_attach := true;
1478: end if;

Line 1476: if NOT ZPB_AW.INTERPBOOL ('shw aw(attached '''|| l_code_aw ||''')') then

1472:
1473: -- check if code aw is attached
1474: l_code_aw := ZPB_AW.GET_SCHEMA||'.'||ZPB_AW.GET_CODE_AW( l_shadow ) ;
1475: l_code_aw_attach := false;
1476: if NOT ZPB_AW.INTERPBOOL ('shw aw(attached '''|| l_code_aw ||''')') then
1477: l_code_aw_attach := true;
1478: end if;
1479:
1480:

Line 1486: ZPB_AW.INTERPBOOL ('shw aw(attached ''SHARED'')')) then

1482: -- Check to see if shared attached, and its the right shared/bus area:
1483: --
1484: l_reattach := false;
1485: if (p_type = 'SHARED' and
1486: ZPB_AW.INTERPBOOL ('shw aw(attached ''SHARED'')')) then
1487: if (ZPB_AW.INTERPBOOL ('shw exists(''SHARED!AW.ATTACH.TIME'')')) then
1488: l_buff := ZPB_AW.INTERP('shw SHARED!AW.ATTACH.TIME');
1489: --
1490: -- Comment out until we resolve bug# 4887248

Line 1487: if (ZPB_AW.INTERPBOOL ('shw exists(''SHARED!AW.ATTACH.TIME'')')) then

1483: --
1484: l_reattach := false;
1485: if (p_type = 'SHARED' and
1486: ZPB_AW.INTERPBOOL ('shw aw(attached ''SHARED'')')) then
1487: if (ZPB_AW.INTERPBOOL ('shw exists(''SHARED!AW.ATTACH.TIME'')')) then
1488: l_buff := ZPB_AW.INTERP('shw SHARED!AW.ATTACH.TIME');
1489: --
1490: -- Comment out until we resolve bug# 4887248
1491: --

Line 1488: l_buff := ZPB_AW.INTERP('shw SHARED!AW.ATTACH.TIME');

1484: l_reattach := false;
1485: if (p_type = 'SHARED' and
1486: ZPB_AW.INTERPBOOL ('shw aw(attached ''SHARED'')')) then
1487: if (ZPB_AW.INTERPBOOL ('shw exists(''SHARED!AW.ATTACH.TIME'')')) then
1488: l_buff := ZPB_AW.INTERP('shw SHARED!AW.ATTACH.TIME');
1489: --
1490: -- Comment out until we resolve bug# 4887248
1491: --
1492: /*

Line 1511: not ZPB_AW.INTERPBOOL ('shw aw(attached ''SHARED'')'))) then

1507: sys_context('ZPB_CONTEXT', 'business_area_id') is null or
1508: sys_context('ZPB_CONTEXT', 'business_area_id') <> l_ba_id or
1509: l_code_aw_attach or
1510: (p_type = 'SHARED' and
1511: not ZPB_AW.INTERPBOOL ('shw aw(attached ''SHARED'')'))) then
1512:
1513: ZPB_AW.INITIALIZE (p_api_version => 1.0,
1514: x_return_status => l_ret_stat,
1515: x_msg_count => l_msg_cnt,

Line 1513: ZPB_AW.INITIALIZE (p_api_version => 1.0,

1509: l_code_aw_attach or
1510: (p_type = 'SHARED' and
1511: not ZPB_AW.INTERPBOOL ('shw aw(attached ''SHARED'')'))) then
1512:
1513: ZPB_AW.INITIALIZE (p_api_version => 1.0,
1514: x_return_status => l_ret_stat,
1515: x_msg_count => l_msg_cnt,
1516: x_msg_data => l_buff,
1517: p_business_area_id => l_ba_id,

Line 1522: select ZPB_AW.GET_SCHEMA||'.'||PERSONAL_AW

1518: p_shadow_id => l_shadow);
1519: end if;
1520:
1521: if (upper(p_type) = 'PERSONAL') then
1522: select ZPB_AW.GET_SCHEMA||'.'||PERSONAL_AW
1523: into l_persAw
1524: from ZPB_USERS
1525: where BUSINESS_AREA_ID = l_ba_id
1526: and USER_ID = l_shadow;

Line 1531: l_personal_alias_flag := ZPB_AW_STATUS.GET_PERSONAL_ALIAS_FLAG();

1527:
1528: --
1529: -- Check to see if personal attached, and it is the right personal
1530: --
1531: l_personal_alias_flag := ZPB_AW_STATUS.GET_PERSONAL_ALIAS_FLAG();
1532: if (l_personal_alias_flag <> 'Y' and not ZPB_AW.INTERPBOOL
1533: ('shw aw(attached ''PERSONAL'') and aw(attached '''||l_persAw||
1534: ''') and aw(name ''PERSONAL'') eq aw(name '''||l_persAw||''')'))
1535: then

Line 1532: if (l_personal_alias_flag <> 'Y' and not ZPB_AW.INTERPBOOL

1528: --
1529: -- Check to see if personal attached, and it is the right personal
1530: --
1531: l_personal_alias_flag := ZPB_AW_STATUS.GET_PERSONAL_ALIAS_FLAG();
1532: if (l_personal_alias_flag <> 'Y' and not ZPB_AW.INTERPBOOL
1533: ('shw aw(attached ''PERSONAL'') and aw(attached '''||l_persAw||
1534: ''') and aw(name ''PERSONAL'') eq aw(name '''||l_persAw||''')'))
1535: then
1536: ZPB_AW.INITIALIZE_USER (p_api_version => 1.0,

Line 1536: ZPB_AW.INITIALIZE_USER (p_api_version => 1.0,

1532: if (l_personal_alias_flag <> 'Y' and not ZPB_AW.INTERPBOOL
1533: ('shw aw(attached ''PERSONAL'') and aw(attached '''||l_persAw||
1534: ''') and aw(name ''PERSONAL'') eq aw(name '''||l_persAw||''')'))
1535: then
1536: ZPB_AW.INITIALIZE_USER (p_api_version => 1.0,
1537: x_return_status => l_ret_stat,
1538: x_msg_count => l_msg_cnt,
1539: x_msg_data => l_buff,
1540: p_user => l_shadow,

Line 1630: l_aw := zpb_aw.get_personal_aw(p_user, p_business_area);

1626: from user_views
1627: where view_name like l_aw||'\_%' escape '\';
1628:
1629: begin
1630: l_aw := zpb_aw.get_personal_aw(p_user, p_business_area);
1631:
1632: for each in user_views loop
1633: drop_view(each.view_name);
1634: end loop;