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_PERSONAL_AW dependencies on ZPB_ECM

Line 35: l_global_ecm zpb_ecm.global_ecm;

31: -- IN: p_user - The user ID
32: -------------------------------------------------------------------------------
33: procedure ANNOTATION_CREATE(p_user in varchar2)
34: is
35: l_global_ecm zpb_ecm.global_ecm;
36: l_annot_ecm zpb_ecm.annot_ecm;
37: l_annEntry varchar2(16);
38: l_annCells varchar2(16);
39: l_annLookup varchar2(16);

Line 36: l_annot_ecm zpb_ecm.annot_ecm;

32: -------------------------------------------------------------------------------
33: procedure ANNOTATION_CREATE(p_user in varchar2)
34: is
35: l_global_ecm zpb_ecm.global_ecm;
36: l_annot_ecm zpb_ecm.annot_ecm;
37: l_annEntry varchar2(16);
38: l_annCells varchar2(16);
39: l_annLookup varchar2(16);
40: l_dims varchar2(500);

Line 49: l_global_ecm := zpb_ecm.get_global_ecm(g_sharedAW);

45: 'Creating personal metadata for '||p_user);
46:
47: l_persAw := g_olapSchema||'.'||g_personalAW;
48: zpb_aw.execute ('call pa.attach.shared ('''||p_user||''')');
49: l_global_ecm := zpb_ecm.get_global_ecm(g_sharedAW);
50:
51: zpb_aw.execute ('aw attach '||g_olapSchema||'.'||g_annotAW||' ro');
52:
53: l_annot_ecm := zpb_ecm.get_annotation_ecm(g_sharedAW);

Line 53: l_annot_ecm := zpb_ecm.get_annotation_ecm(g_sharedAW);

49: l_global_ecm := zpb_ecm.get_global_ecm(g_sharedAW);
50:
51: zpb_aw.execute ('aw attach '||g_olapSchema||'.'||g_annotAW||' ro');
52:
53: l_annot_ecm := zpb_ecm.get_annotation_ecm(g_sharedAW);
54: zpb_aw.execute ('aw detach '||g_olapSchema||'.'||g_sharedAW);
55: zpb_aw.execute('lmt '||l_global_ecm.AnnEntryDim||' remove all');
56:
57: zpb_aw.execute ('aw attach '||g_olapSchema||'.'||g_annotAW||' ro');

Line 84: l_ecm zpb_ecm.global_ecm;

80: is
81: l_ignore boolean;
82: l_vIgnore varchar2(1) := 'S';
83: l_aw varchar2(30);
84: l_ecm zpb_ecm.global_ecm;
85: l_valid boolean := false;
86: l_exists boolean := true;
87: l_retStat varchar2(1);
88: l_msgCnt number;

Line 190: l_ecm := zpb_ecm.get_global_ecm (g_sharedAW);

186: '!DMENTRY''');
187: zpb_aw.execute ('DM.PRS.MEASDIM = '''||g_olapSchema||'.'||g_personalAW||
188: '!MEASURE''');
189:
190: l_ecm := zpb_ecm.get_global_ecm (g_sharedAW);
191: l_aw := g_olapSchema||'.'||g_sharedAW;
192:
193: METADATA_CREATE (p_user);
194:

Line 199: l_ecm := zpb_ecm.get_global_ecm (g_personalAW);

195: zpb_aw.execute ('aw detach '||g_olapSchema||'.'||g_personalAW);
196: ANNOTATION_CREATE (p_user);
197:
198: -- Set up the Perosnal DM objects
199: l_ecm := zpb_ecm.get_global_ecm (g_personalAW);
200: l_aw := g_olapSchema||'.'||g_personalAW;
201:
202: --
203: -- Convert SHARED formulas to point to Personal Aw

Line 559: l_ecm zpb_ecm.global_ecm;

555: l_obj varchar2(60);
556: l_val varchar2(4000);
557: i number;
558: j number;
559: l_ecm zpb_ecm.global_ecm;
560: begin
561: get_aws(p_user);
562:
563: if (zpb_aw.interpbool('shw aw(attached '''||g_olapSchema||'.'||

Line 581: l_ecm := zpb_ecm.get_global_ecm(g_personalAW);

577: zpb_aw.execute ('call pa.attach.personal('''||p_user||''' '''||
578: g_attach_mode||''')');
579:
580: if (p_noScope = 'Y') then
581: l_ecm := zpb_ecm.get_global_ecm(g_personalAW);
582: l_dims := zpb_aw.interp ('shw CM.GETDATADIMS');
583: i := 1;
584: loop
585: j := instr (l_dims, ' ', i);

Line 747: l_global_ecm zpb_ecm.global_ecm;

743: l_value varchar2(30);
744: i number;
745: j number;
746: l_objList dbms_aw.eif_objlist_t;
747: l_global_ecm zpb_ecm.global_ecm;
748: l_dim_data zpb_ecm.dimension_data;
749: l_dim_ecm zpb_ecm.dimension_ecm;
750: l_dim_line_ecm zpb_ecm.dimension_line_ecm;
751: l_dim_time_ecm zpb_ecm.dimension_time_ecm;

Line 748: l_dim_data zpb_ecm.dimension_data;

744: i number;
745: j number;
746: l_objList dbms_aw.eif_objlist_t;
747: l_global_ecm zpb_ecm.global_ecm;
748: l_dim_data zpb_ecm.dimension_data;
749: l_dim_ecm zpb_ecm.dimension_ecm;
750: l_dim_line_ecm zpb_ecm.dimension_line_ecm;
751: l_dim_time_ecm zpb_ecm.dimension_time_ecm;
752: l_global_attr_ecm zpb_ecm.global_attr_ecm;

Line 749: l_dim_ecm zpb_ecm.dimension_ecm;

745: j number;
746: l_objList dbms_aw.eif_objlist_t;
747: l_global_ecm zpb_ecm.global_ecm;
748: l_dim_data zpb_ecm.dimension_data;
749: l_dim_ecm zpb_ecm.dimension_ecm;
750: l_dim_line_ecm zpb_ecm.dimension_line_ecm;
751: l_dim_time_ecm zpb_ecm.dimension_time_ecm;
752: l_global_attr_ecm zpb_ecm.global_attr_ecm;
753: l_aggr_ecm zpb_ecm.aggr_ecm;

Line 750: l_dim_line_ecm zpb_ecm.dimension_line_ecm;

746: l_objList dbms_aw.eif_objlist_t;
747: l_global_ecm zpb_ecm.global_ecm;
748: l_dim_data zpb_ecm.dimension_data;
749: l_dim_ecm zpb_ecm.dimension_ecm;
750: l_dim_line_ecm zpb_ecm.dimension_line_ecm;
751: l_dim_time_ecm zpb_ecm.dimension_time_ecm;
752: l_global_attr_ecm zpb_ecm.global_attr_ecm;
753: l_aggr_ecm zpb_ecm.aggr_ecm;
754: l_alloc_ecm zpb_ecm.alloc_ecm;

Line 751: l_dim_time_ecm zpb_ecm.dimension_time_ecm;

747: l_global_ecm zpb_ecm.global_ecm;
748: l_dim_data zpb_ecm.dimension_data;
749: l_dim_ecm zpb_ecm.dimension_ecm;
750: l_dim_line_ecm zpb_ecm.dimension_line_ecm;
751: l_dim_time_ecm zpb_ecm.dimension_time_ecm;
752: l_global_attr_ecm zpb_ecm.global_attr_ecm;
753: l_aggr_ecm zpb_ecm.aggr_ecm;
754: l_alloc_ecm zpb_ecm.alloc_ecm;
755: l_annot_ecm zpb_ecm.annot_ecm;

Line 752: l_global_attr_ecm zpb_ecm.global_attr_ecm;

748: l_dim_data zpb_ecm.dimension_data;
749: l_dim_ecm zpb_ecm.dimension_ecm;
750: l_dim_line_ecm zpb_ecm.dimension_line_ecm;
751: l_dim_time_ecm zpb_ecm.dimension_time_ecm;
752: l_global_attr_ecm zpb_ecm.global_attr_ecm;
753: l_aggr_ecm zpb_ecm.aggr_ecm;
754: l_alloc_ecm zpb_ecm.alloc_ecm;
755: l_annot_ecm zpb_ecm.annot_ecm;
756: l_attr_ecm zpb_ecm.attr_ecm;

Line 753: l_aggr_ecm zpb_ecm.aggr_ecm;

749: l_dim_ecm zpb_ecm.dimension_ecm;
750: l_dim_line_ecm zpb_ecm.dimension_line_ecm;
751: l_dim_time_ecm zpb_ecm.dimension_time_ecm;
752: l_global_attr_ecm zpb_ecm.global_attr_ecm;
753: l_aggr_ecm zpb_ecm.aggr_ecm;
754: l_alloc_ecm zpb_ecm.alloc_ecm;
755: l_annot_ecm zpb_ecm.annot_ecm;
756: l_attr_ecm zpb_ecm.attr_ecm;
757: l_line_type_ecm zpb_ecm.line_type_ecm;

Line 754: l_alloc_ecm zpb_ecm.alloc_ecm;

750: l_dim_line_ecm zpb_ecm.dimension_line_ecm;
751: l_dim_time_ecm zpb_ecm.dimension_time_ecm;
752: l_global_attr_ecm zpb_ecm.global_attr_ecm;
753: l_aggr_ecm zpb_ecm.aggr_ecm;
754: l_alloc_ecm zpb_ecm.alloc_ecm;
755: l_annot_ecm zpb_ecm.annot_ecm;
756: l_attr_ecm zpb_ecm.attr_ecm;
757: l_line_type_ecm zpb_ecm.line_type_ecm;
758:

Line 755: l_annot_ecm zpb_ecm.annot_ecm;

751: l_dim_time_ecm zpb_ecm.dimension_time_ecm;
752: l_global_attr_ecm zpb_ecm.global_attr_ecm;
753: l_aggr_ecm zpb_ecm.aggr_ecm;
754: l_alloc_ecm zpb_ecm.alloc_ecm;
755: l_annot_ecm zpb_ecm.annot_ecm;
756: l_attr_ecm zpb_ecm.attr_ecm;
757: l_line_type_ecm zpb_ecm.line_type_ecm;
758:
759: begin

Line 756: l_attr_ecm zpb_ecm.attr_ecm;

752: l_global_attr_ecm zpb_ecm.global_attr_ecm;
753: l_aggr_ecm zpb_ecm.aggr_ecm;
754: l_alloc_ecm zpb_ecm.alloc_ecm;
755: l_annot_ecm zpb_ecm.annot_ecm;
756: l_attr_ecm zpb_ecm.attr_ecm;
757: l_line_type_ecm zpb_ecm.line_type_ecm;
758:
759: begin
760: zpb_log.write('zpb_personal_aw.metadata_create.begin',

Line 757: l_line_type_ecm zpb_ecm.line_type_ecm;

753: l_aggr_ecm zpb_ecm.aggr_ecm;
754: l_alloc_ecm zpb_ecm.alloc_ecm;
755: l_annot_ecm zpb_ecm.annot_ecm;
756: l_attr_ecm zpb_ecm.attr_ecm;
757: l_line_type_ecm zpb_ecm.line_type_ecm;
758:
759: begin
760: zpb_log.write('zpb_personal_aw.metadata_create.begin',
761: 'Creating personal metadata for '||p_user);

Line 766: l_global_ecm := zpb_ecm.get_global_ecm(g_sharedAW);

762:
763: get_aws(p_user);
764: zpb_aw.execute ('call pa.attach.shared ('''||p_user||''')');
765:
766: l_global_ecm := zpb_ecm.get_global_ecm(g_sharedAW);
767:
768: --
769: -- GLOBAL METADATA:
770: --

Line 773: l_annot_ecm := zpb_ecm.get_annotation_ecm(g_sharedAW);

769: -- GLOBAL METADATA:
770: --
771:
772: zpb_aw.execute ('aw attach '||g_olapSchema||'.'||g_annotAW||' ro');
773: l_annot_ecm := zpb_ecm.get_annotation_ecm(g_sharedAW);
774: zpb_aw.execute ('aw detach '||g_olapSchema||'.'||g_annotAW);
775:
776: zpb_aw.execute ('oknullstatus=yes');
777: zpb_aw.execute ('lmt '||l_global_ecm.ShapeEntryDim||' remove all');

Line 800: l_dim_ecm := zpb_ecm.get_dimension_ecm (l_ecmDim, g_sharedAW);

796: else
797: l_ecmDim := substr (l_dims, i, j-i);
798: i := j+1;
799: end if;
800: l_dim_ecm := zpb_ecm.get_dimension_ecm (l_ecmDim, g_sharedAW);
801: l_dim_data := zpb_ecm.get_dimension_data (l_ecmDim, g_sharedAW);
802:
803: --
804: -- Limit the levels/hierarchies down to what the user has access to

Line 801: l_dim_data := zpb_ecm.get_dimension_data (l_ecmDim, g_sharedAW);

797: l_ecmDim := substr (l_dims, i, j-i);
798: i := j+1;
799: end if;
800: l_dim_ecm := zpb_ecm.get_dimension_ecm (l_ecmDim, g_sharedAW);
801: l_dim_data := zpb_ecm.get_dimension_data (l_ecmDim, g_sharedAW);
802:
803: --
804: -- Limit the levels/hierarchies down to what the user has access to
805: --

Line 841: l_global_attr_ecm := zpb_ecm.get_global_attr_ecm(g_sharedAW);

837: end if;
838: exit when j=0;
839: end loop;
840:
841: l_global_attr_ecm := zpb_ecm.get_global_attr_ecm(g_sharedAW);
842:
843: zpb_aw.execute('lmt '||l_global_ecm.AttrDim||' to '||
844: l_global_ecm.AttrDimScpFrm||' eq ''N''');
845: zpb_aw.execute('lmt '||l_global_ecm.DimDim||' to all');

Line 923: l_dim_data zpb_ecm.dimension_data;

919: l_dims varchar2(500);
920: l_ecmDim varchar2(30);
921: i number;
922: j number;
923: l_dim_data zpb_ecm.dimension_data;
924: begin
925: zpb_aw.execute('call SC.SET.PERS.SCP('''||p_user||''' '''||
926: g_olapSchema||'.'||g_sharedAW||''' '''||g_olapSchema||'.'||
927: g_personalAW||''')');

Line 987: l_ecm zpb_ecm.global_ecm;

983: l_trace varchar2(90);
984: l_rw_mode VARCHAR2(1);
985: l_ro VARCHAR2(1);
986:
987: l_ecm zpb_ecm.global_ecm;
988:
989: cursor del_wrksh is
990: select distinct TEMPLATE_ID, AC_INSTANCE_ID
991: from ZPB_DC_OBJECTS

Line 1069: l_ecm := zpb_ecm.get_global_ecm (g_personalAW);

1065: --
1066: l_comm := DBMS_AW.EVAL_TEXT ('DB.UPGRADE ('''||g_olapSchema||'.'||
1067: g_personalAW||''' ''PERSONAL'' NA '''||l_ro||''')');
1068:
1069: l_ecm := zpb_ecm.get_global_ecm (g_personalAW);
1070: l_aw := g_olapSchema||'.'||g_personalAW;
1071:
1072: --
1073: -- Update the AW with changes from the shared:

Line 1198: l_dim_ecm zpb_ecm.dimension_ecm;

1194: j NUMBER;
1195: hi NUMBER;
1196: hj NUMBER;
1197:
1198: l_dim_ecm zpb_ecm.dimension_ecm;
1199: l_dim_data zpb_ecm.dimension_data;
1200: begin
1201: zpb_log.write('zpb_personal_aw.views_update.begin',
1202: 'Updating metadata views for dims: '||p_dims);

Line 1199: l_dim_data zpb_ecm.dimension_data;

1195: hi NUMBER;
1196: hj NUMBER;
1197:
1198: l_dim_ecm zpb_ecm.dimension_ecm;
1199: l_dim_data zpb_ecm.dimension_data;
1200: begin
1201: zpb_log.write('zpb_personal_aw.views_update.begin',
1202: 'Updating metadata views for dims: '||p_dims);
1203:

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

1230: else
1231: l_ecmDim := substr (l_dims, i, j-i);
1232: i := j+1;
1233: end if;
1234: l_dim_ecm := zpb_ecm.get_dimension_ecm(l_ecmDim, p_aw);
1235:
1236: --
1237: -- If a personal level exists on the dimension...
1238: --

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

1239: if (to_number(ZPB_AW.INTERP('shw statlen(lmt('||l_aw||
1240: l_dim_ecm.LevelDim||' to '||l_aw||
1241: l_dim_ecm.LevelPersVar||'))')) > 0) then
1242: hi := 1;
1243: l_dim_data := zpb_ecm.get_dimension_data(l_ecmDim, p_aw);
1244: l_hiers := ZPB_AW.INTERP('shw CM.GETDIMVALUES('''||l_aw||
1245: l_dim_ecm.HierDim||''')');
1246: loop
1247: hj := instr (l_hiers, ' ', hi);