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_METADATA_PKG dependencies on ZPB_AW

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

1863: -- personal-personal hierarchy table MD
1864: l_pp_hiert_start_time date;
1865:
1866: begin
1867: l_aw := zpb_aw.get_schema||'.'||p_aw||'!';
1868: l_global_ecm := zpb_ecm.get_global_ecm (p_aw);
1869: l_global_attr_ecm := zpb_ecm.get_global_attr_ecm(p_aw);
1870:
1871: l_langs :=zpb_aw.interp

Line 1871: l_langs :=zpb_aw.interp

1867: l_aw := zpb_aw.get_schema||'.'||p_aw||'!';
1868: l_global_ecm := zpb_ecm.get_global_ecm (p_aw);
1869: l_global_attr_ecm := zpb_ecm.get_global_attr_ecm(p_aw);
1870:
1871: l_langs :=zpb_aw.interp
1872: ('shw CM.GETDIMVALUES('''||l_aw||l_global_ecm.LangDim||''')');
1873:
1874: bus_area_id_num := sys_context('ZPB_CONTEXT', 'business_area_id');
1875:

Line 1876: zpb_aw.execute('push oknullstatus');

1872: ('shw CM.GETDIMVALUES('''||l_aw||l_global_ecm.LangDim||''')');
1873:
1874: bus_area_id_num := sys_context('ZPB_CONTEXT', 'business_area_id');
1875:
1876: zpb_aw.execute('push oknullstatus');
1877: zpb_aw.execute('oknullstatus = yes');
1878:
1879: -- dbms_output.put_line('Building dims: ' || p_dims);
1880:

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

1873:
1874: bus_area_id_num := sys_context('ZPB_CONTEXT', 'business_area_id');
1875:
1876: zpb_aw.execute('push oknullstatus');
1877: zpb_aw.execute('oknullstatus = yes');
1878:
1879: -- dbms_output.put_line('Building dims: ' || p_dims);
1880:
1881: -- Loop pver all dimensions

Line 1913: zpb_aw.execute('push '||l_aw||l_dim_data.ExpObj);

1909:
1910: l_dim_data := zpb_ecm.get_dimension_data (l_dim, p_aw);
1911: l_dim_ecm := zpb_ecm.get_dimension_ecm (l_dim, p_aw);
1912:
1913: zpb_aw.execute('push '||l_aw||l_dim_data.ExpObj);
1914:
1915: m_dimension_en.AWName := l_dim_data.ExpObj;
1916:
1917: -- Dimension Default Hierarchy

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

2077: -- HierDim can be valid with nothing in status, if scoping rules
2078: -- out all possible hierarchies for the user:
2079: --
2080: done := false;
2081: if (zpb_aw.interp('shw obj(dimmax '''||l_aw||l_dim_ecm.HierDim||
2082: ''')') <> '0') then
2083: hi := 1;
2084: l_hiers :=zpb_aw.interp
2085: ('shw CM.GETDIMVALUES('''||l_aw||l_dim_ecm.HierDim||''')');

Line 2084: l_hiers :=zpb_aw.interp

2080: done := false;
2081: if (zpb_aw.interp('shw obj(dimmax '''||l_aw||l_dim_ecm.HierDim||
2082: ''')') <> '0') then
2083: hi := 1;
2084: l_hiers :=zpb_aw.interp
2085: ('shw CM.GETDIMVALUES('''||l_aw||l_dim_ecm.HierDim||''')');
2086:
2087: zpb_aw.execute ('push '||l_aw||l_dim_ecm.LevelDim);
2088: zpb_aw.execute ('push '||l_aw||l_dim_ecm.HierDim);

Line 2087: zpb_aw.execute ('push '||l_aw||l_dim_ecm.LevelDim);

2083: hi := 1;
2084: l_hiers :=zpb_aw.interp
2085: ('shw CM.GETDIMVALUES('''||l_aw||l_dim_ecm.HierDim||''')');
2086:
2087: zpb_aw.execute ('push '||l_aw||l_dim_ecm.LevelDim);
2088: zpb_aw.execute ('push '||l_aw||l_dim_ecm.HierDim);
2089: loop -- LOOP OVER ALL HIERARCHIES
2090: hj := instr (l_hiers, ' ', hi);
2091: if (hj = 0) then

Line 2088: zpb_aw.execute ('push '||l_aw||l_dim_ecm.HierDim);

2084: l_hiers :=zpb_aw.interp
2085: ('shw CM.GETDIMVALUES('''||l_aw||l_dim_ecm.HierDim||''')');
2086:
2087: zpb_aw.execute ('push '||l_aw||l_dim_ecm.LevelDim);
2088: zpb_aw.execute ('push '||l_aw||l_dim_ecm.HierDim);
2089: loop -- LOOP OVER ALL HIERARCHIES
2090: hj := instr (l_hiers, ' ', hi);
2091: if (hj = 0) then
2092: l_hier := substr (l_hiers, hi);

Line 2100: zpb_aw.execute('lmt '||l_aw||l_dim_ecm.HierDim||' to '''||

2096: end if;
2097:
2098: -- dbms_output.put_line('Looping for hierarchy ' || l_hier);
2099:
2100: zpb_aw.execute('lmt '||l_aw||l_dim_ecm.HierDim||' to '''||
2101: l_hier||'''');
2102:
2103: zpb_aw.execute('lmt '||l_aw||l_dim_data.ExpObj||' to '||l_aw||
2104: l_dim_ecm.HOrderVS);

Line 2103: zpb_aw.execute('lmt '||l_aw||l_dim_data.ExpObj||' to '||l_aw||

2099:
2100: zpb_aw.execute('lmt '||l_aw||l_dim_ecm.HierDim||' to '''||
2101: l_hier||'''');
2102:
2103: zpb_aw.execute('lmt '||l_aw||l_dim_data.ExpObj||' to '||l_aw||
2104: l_dim_ecm.HOrderVS);
2105:
2106: if (zpb_aw.interp('shw convert(statlen('||l_aw||l_dim_data.ExpObj||
2107: ') text 0 no no)') <> 0) then

Line 2106: if (zpb_aw.interp('shw convert(statlen('||l_aw||l_dim_data.ExpObj||

2102:
2103: zpb_aw.execute('lmt '||l_aw||l_dim_data.ExpObj||' to '||l_aw||
2104: l_dim_ecm.HOrderVS);
2105:
2106: if (zpb_aw.interp('shw convert(statlen('||l_aw||l_dim_data.ExpObj||
2107: ') text 0 no no)') <> 0) then
2108:
2109: -- if this hierarchy has members, limit the level dimension to its levels
2110: -- and and sort it according to leveldepthvar

Line 2112: zpb_aw.execute('lmt '||l_aw||l_dim_ecm.HierDim||' to '''||

2108:
2109: -- if this hierarchy has members, limit the level dimension to its levels
2110: -- and and sort it according to leveldepthvar
2111:
2112: zpb_aw.execute('lmt '||l_aw||l_dim_ecm.HierDim||' to '''||
2113: l_hier||'''');
2114:
2115: zpb_aw.execute('lmt '||l_aw||l_dim_ecm.LevelDim||
2116: ' to &joinchars ('''||l_aw||''' obj(property '''

Line 2115: zpb_aw.execute('lmt '||l_aw||l_dim_ecm.LevelDim||

2111:
2112: zpb_aw.execute('lmt '||l_aw||l_dim_ecm.HierDim||' to '''||
2113: l_hier||'''');
2114:
2115: zpb_aw.execute('lmt '||l_aw||l_dim_ecm.LevelDim||
2116: ' to &joinchars ('''||l_aw||''' obj(property '''
2117: ||'HIERLEVELVS'' '''||l_dim_ecm.HierDim||'''))');
2118:
2119: zpb_aw.execute('sort '||l_aw||l_dim_ecm.levelDim||

Line 2119: zpb_aw.execute('sort '||l_aw||l_dim_ecm.levelDim||

2115: zpb_aw.execute('lmt '||l_aw||l_dim_ecm.LevelDim||
2116: ' to &joinchars ('''||l_aw||''' obj(property '''
2117: ||'HIERLEVELVS'' '''||l_dim_ecm.HierDim||'''))');
2118:
2119: zpb_aw.execute('sort '||l_aw||l_dim_ecm.levelDim||
2120: ' a &joinchars ('''||l_aw||''' obj(property '''
2121: ||'LEVELDEPTHVAR'' '''||l_dim_ecm.HierDim||'''))');
2122:
2123:

Line 2126: if (p_type='PERSONAL' and zpb_aw.interp('shw convert(statlen(limit(' || l_aw||l_dim_ecm.levelDim||

2122:
2123:
2124: -- if we are in personal mode and user has a personal level in this hierarchy, build
2125: -- metadata for the personal-personal hierarchy table (this table has the user's id in its name)
2126: if (p_type='PERSONAL' and zpb_aw.interp('shw convert(statlen(limit(' || l_aw||l_dim_ecm.levelDim||
2127: ' to &joinchars ('''||l_aw||''' obj(property '''
2128: ||'PERSONALVAR'' '''||l_dim_ecm.LevelDim||''')))) text 0 no no)') > 0) then
2129:
2130: l_persLvl := true;

Line 2144: m_hier_en.HierType := zpb_aw.interp ('shw '||l_dim_ecm.HierTypeRel);

2140:
2141: -- Hierarchy Entry
2142: m_hier_en.DimensionId := m_dimension_en.DimensionId;
2143: m_hier_en.EPBId := l_hier;
2144: m_hier_en.HierType := zpb_aw.interp ('shw '||l_dim_ecm.HierTypeRel);
2145:
2146: m_hier_en.PersCWMName := zpb_metadata_names.get_hierarchy_cwm2_name('PRS', l_dim, l_hier);
2147: m_hier_en.SharCWMName := zpb_metadata_names.get_hierarchy_cwm2_name(p_sharedAw, l_dim, l_hier);
2148:

Line 2219: zpb_aw.execute ('push '||l_aw||l_global_ecm.LangDim);

2215:
2216: -- Insert Hierarchy TL Entry
2217: htld_i := 1;
2218:
2219: zpb_aw.execute ('push '||l_aw||l_global_ecm.LangDim);
2220:
2221: loop -- LOOP OVER ALL LANGUAGES
2222:
2223: htld_j := instr (l_langs, ' ', htld_i);

Line 2231: zpb_aw.execute('lmt '||l_aw||l_global_ecm.LangDim||' to '''||l_lang||'''');

2227: l_lang := substr (l_langs, htld_i, htld_j-htld_i);
2228: htld_i := htld_j+1;
2229: end if;
2230:
2231: zpb_aw.execute('lmt '||l_aw||l_global_ecm.LangDim||' to '''||l_lang||'''');
2232:
2233: if (zpb_aw.interpbool('shw exists ('''||l_aw||l_dim_ecm.HierVersLdscVar||''')')) then
2234: m_hier_tl_en.Name := zpb_aw.interp('shw '||l_aw||l_dim_ecm.HierVersLdscVar);
2235: if (m_hier_tl_en.Name is null or m_hier_tl_en.Name = 'NA') then

Line 2233: if (zpb_aw.interpbool('shw exists ('''||l_aw||l_dim_ecm.HierVersLdscVar||''')')) then

2229: end if;
2230:
2231: zpb_aw.execute('lmt '||l_aw||l_global_ecm.LangDim||' to '''||l_lang||'''');
2232:
2233: if (zpb_aw.interpbool('shw exists ('''||l_aw||l_dim_ecm.HierVersLdscVar||''')')) then
2234: m_hier_tl_en.Name := zpb_aw.interp('shw '||l_aw||l_dim_ecm.HierVersLdscVar);
2235: if (m_hier_tl_en.Name is null or m_hier_tl_en.Name = 'NA') then
2236: m_hier_tl_en.Name := zpb_aw.interp('shw '||l_aw||l_dim_ecm.HierLdscVar);
2237: else

Line 2234: m_hier_tl_en.Name := zpb_aw.interp('shw '||l_aw||l_dim_ecm.HierVersLdscVar);

2230:
2231: zpb_aw.execute('lmt '||l_aw||l_global_ecm.LangDim||' to '''||l_lang||'''');
2232:
2233: if (zpb_aw.interpbool('shw exists ('''||l_aw||l_dim_ecm.HierVersLdscVar||''')')) then
2234: m_hier_tl_en.Name := zpb_aw.interp('shw '||l_aw||l_dim_ecm.HierVersLdscVar);
2235: if (m_hier_tl_en.Name is null or m_hier_tl_en.Name = 'NA') then
2236: m_hier_tl_en.Name := zpb_aw.interp('shw '||l_aw||l_dim_ecm.HierLdscVar);
2237: else
2238: m_hier_tl_en.Name := zpb_aw.interp('shw joinchars('||l_aw||l_dim_ecm.HierLdscVar||

Line 2236: m_hier_tl_en.Name := zpb_aw.interp('shw '||l_aw||l_dim_ecm.HierLdscVar);

2232:
2233: if (zpb_aw.interpbool('shw exists ('''||l_aw||l_dim_ecm.HierVersLdscVar||''')')) then
2234: m_hier_tl_en.Name := zpb_aw.interp('shw '||l_aw||l_dim_ecm.HierVersLdscVar);
2235: if (m_hier_tl_en.Name is null or m_hier_tl_en.Name = 'NA') then
2236: m_hier_tl_en.Name := zpb_aw.interp('shw '||l_aw||l_dim_ecm.HierLdscVar);
2237: else
2238: m_hier_tl_en.Name := zpb_aw.interp('shw joinchars('||l_aw||l_dim_ecm.HierLdscVar||
2239: ' '': '' '||l_dim_ecm.HierVersLdscVar||')');
2240: end if;

Line 2238: m_hier_tl_en.Name := zpb_aw.interp('shw joinchars('||l_aw||l_dim_ecm.HierLdscVar||

2234: m_hier_tl_en.Name := zpb_aw.interp('shw '||l_aw||l_dim_ecm.HierVersLdscVar);
2235: if (m_hier_tl_en.Name is null or m_hier_tl_en.Name = 'NA') then
2236: m_hier_tl_en.Name := zpb_aw.interp('shw '||l_aw||l_dim_ecm.HierLdscVar);
2237: else
2238: m_hier_tl_en.Name := zpb_aw.interp('shw joinchars('||l_aw||l_dim_ecm.HierLdscVar||
2239: ' '': '' '||l_dim_ecm.HierVersLdscVar||')');
2240: end if;
2241: else
2242: m_hier_tl_en.Name := zpb_aw.interp('shw '||l_aw||l_dim_ecm.HierLdscVar);

Line 2242: m_hier_tl_en.Name := zpb_aw.interp('shw '||l_aw||l_dim_ecm.HierLdscVar);

2238: m_hier_tl_en.Name := zpb_aw.interp('shw joinchars('||l_aw||l_dim_ecm.HierLdscVar||
2239: ' '': '' '||l_dim_ecm.HierVersLdscVar||')');
2240: end if;
2241: else
2242: m_hier_tl_en.Name := zpb_aw.interp('shw '||l_aw||l_dim_ecm.HierLdscVar);
2243: end if;
2244:
2245: m_hier_tl_en.LongName :=m_hier_tl_en.Name;
2246: m_hier_tl_en.PluralName :=m_hier_tl_en.Name;

Line 2255: zpb_aw.execute ('pop '||l_aw||l_global_ecm.LangDim);

2251:
2252: exit when htld_j = 0;
2253: end loop; -- End looping over Languages
2254:
2255: zpb_aw.execute ('pop '||l_aw||l_global_ecm.LangDim);
2256:
2257: -- Set Hierarchy Table Types
2258: m_hr_pers_table_en.tableType:='HIERARCHY';
2259: m_hr_shar_table_en.tableType:='HIERARCHY';

Line 2268: l_levels := zpb_aw.interp('shw CM.GETDIMVALUES('''||l_aw||

2264: --
2265: -- Get the Levels:
2266: --
2267: li := 1;
2268: l_levels := zpb_aw.interp('shw CM.GETDIMVALUES('''||l_aw||
2269: l_dim_ecm.LevelDim||''', YES)');
2270: -- initialize level order , used for parentage
2271: m_level_order := 0;
2272: loop -- Loop over all levels for hierarchy

Line 2285: zpb_aw.execute('lmt '||l_aw||l_dim_ecm.LevelDim||' to '''||

2281: -- dbms_output.put_line('Looping for level ' || l_level);
2282:
2283: m_level_order := m_level_order + 1;
2284:
2285: zpb_aw.execute('lmt '||l_aw||l_dim_ecm.LevelDim||' to '''||
2286: l_level||'''');
2287:
2288: --
2289: -- Check to see if any members are at this level:

Line 2291: zpb_aw.execute('lmt '||l_aw||l_dim_data.ExpObj||' to '||

2287:
2288: --
2289: -- Check to see if any members are at this level:
2290: --
2291: zpb_aw.execute('lmt '||l_aw||l_dim_data.ExpObj||' to '||
2292: l_aw||l_dim_ecm.HOrderVS);
2293:
2294: zpb_aw.execute ('lmt '||l_aw||l_dim_data.ExpObj||' keep '||
2295: l_aw||l_dim_ecm.LevelRel);

Line 2294: zpb_aw.execute ('lmt '||l_aw||l_dim_data.ExpObj||' keep '||

2290: --
2291: zpb_aw.execute('lmt '||l_aw||l_dim_data.ExpObj||' to '||
2292: l_aw||l_dim_ecm.HOrderVS);
2293:
2294: zpb_aw.execute ('lmt '||l_aw||l_dim_data.ExpObj||' keep '||
2295: l_aw||l_dim_ecm.LevelRel);
2296: l_length := to_number(zpb_aw.interp('shw convert(statlen ('||
2297: l_aw||l_dim_data.ExpObj||') text 0 no no)'));
2298: if (l_length > 0) then

Line 2296: l_length := to_number(zpb_aw.interp('shw convert(statlen ('||

2292: l_aw||l_dim_ecm.HOrderVS);
2293:
2294: zpb_aw.execute ('lmt '||l_aw||l_dim_data.ExpObj||' keep '||
2295: l_aw||l_dim_ecm.LevelRel);
2296: l_length := to_number(zpb_aw.interp('shw convert(statlen ('||
2297: l_aw||l_dim_data.ExpObj||') text 0 no no)'));
2298: if (l_length > 0) then
2299:
2300: -- initialize Level Entry

Line 2322: if (p_type = 'PERSONAL' and upper(zpb_aw.interp('shw '||

2318: m_hier_level_en.SharColId := insertColumnRecord(m_shar_column_en);
2319: m_hier_level_en.PersColId := insertColumnRecord(m_pers_column_en);
2320:
2321: -- Personal Level Check
2322: if (p_type = 'PERSONAL' and upper(zpb_aw.interp('shw '||
2323: l_aw||l_dim_ecm.LevelPersVar)) = 'YES') then
2324: l_persLvl := true;
2325: m_level_en.PersLevelFlag := 'Y';
2326: else

Line 2337: zpb_aw.execute ('push '||l_aw||l_global_ecm.LangDim);

2333:
2334: -- insert level TL entry
2335: m_level_tl_en.LevelId := m_level_id;
2336:
2337: zpb_aw.execute ('push '||l_aw||l_global_ecm.LangDim);
2338: htld_i := 1;
2339:
2340: loop -- LOOP OVER ALL LANGUAGES
2341: htld_j := instr (l_langs, ' ', htld_i);

Line 2349: zpb_aw.execute('lmt '||l_aw||l_global_ecm.LangDim||' to '''||

2345: l_lang := substr (l_langs, htld_i, htld_j-htld_i);
2346: htld_i := htld_j+1;
2347: end if;
2348:
2349: zpb_aw.execute('lmt '||l_aw||l_global_ecm.LangDim||' to '''||
2350: l_lang||'''');
2351:
2352: -- Initialize Level TL Entry
2353: m_level_tl_en.Name := zpb_aw.interp('shw '||l_aw||l_dim_ecm.LevelLdscVar);

Line 2353: m_level_tl_en.Name := zpb_aw.interp('shw '||l_aw||l_dim_ecm.LevelLdscVar);

2349: zpb_aw.execute('lmt '||l_aw||l_global_ecm.LangDim||' to '''||
2350: l_lang||'''');
2351:
2352: -- Initialize Level TL Entry
2353: m_level_tl_en.Name := zpb_aw.interp('shw '||l_aw||l_dim_ecm.LevelLdscVar);
2354: m_level_tl_en.PluralLongName := zpb_aw.interp('shw '||l_aw||l_dim_ecm.LevelPlLdscVar);
2355: m_level_tl_en.LongName := m_level_tl_en.Name;
2356: m_level_tl_en.PluralName := m_level_tl_en.PluralLongName;
2357: m_level_tl_en.Language := l_lang;

Line 2354: m_level_tl_en.PluralLongName := zpb_aw.interp('shw '||l_aw||l_dim_ecm.LevelPlLdscVar);

2350: l_lang||'''');
2351:
2352: -- Initialize Level TL Entry
2353: m_level_tl_en.Name := zpb_aw.interp('shw '||l_aw||l_dim_ecm.LevelLdscVar);
2354: m_level_tl_en.PluralLongName := zpb_aw.interp('shw '||l_aw||l_dim_ecm.LevelPlLdscVar);
2355: m_level_tl_en.LongName := m_level_tl_en.Name;
2356: m_level_tl_en.PluralName := m_level_tl_en.PluralLongName;
2357: m_level_tl_en.Language := l_lang;
2358: insertLevelTLRecord(m_level_tl_en);

Line 2363: zpb_aw.execute ('pop '||l_aw||l_global_ecm.LangDim);

2359:
2360: exit when htld_j = 0;
2361: end loop; -- End looping over Languages
2362:
2363: zpb_aw.execute ('pop '||l_aw||l_global_ecm.LangDim);
2364:
2365: m_hier_level_en.HierId := m_hierarchy_id;
2366: m_hier_level_en.LevelId := m_level_id;
2367:

Line 2445: zpb_aw.execute ('pop '||l_aw||l_dim_ecm.LevelDim);

2441:
2442: exit when hj = 0;
2443: end loop; -- End looping over Hierarchies
2444:
2445: zpb_aw.execute ('pop '||l_aw||l_dim_ecm.LevelDim);
2446: zpb_aw.execute ('pop '||l_aw||l_dim_ecm.HierDim);
2447:
2448: end if;
2449:

Line 2446: zpb_aw.execute ('pop '||l_aw||l_dim_ecm.HierDim);

2442: exit when hj = 0;
2443: end loop; -- End looping over Hierarchies
2444:
2445: zpb_aw.execute ('pop '||l_aw||l_dim_ecm.LevelDim);
2446: zpb_aw.execute ('pop '||l_aw||l_dim_ecm.HierDim);
2447:
2448: end if;
2449:
2450:

Line 2505: zpb_aw.execute ('push '||l_aw||l_global_ecm.LangDim);

2501: -- Insert Null Hierarchy TL Record
2502: m_hier_tl_en.HierarchyId := m_hierarchy_id;
2503:
2504:
2505: zpb_aw.execute ('push '||l_aw||l_global_ecm.LangDim);
2506: htld_i := 1;
2507:
2508: loop -- LOOP OVER ALL LANGUAGES
2509: htld_j := instr (l_langs, ' ', htld_i);

Line 2517: zpb_aw.execute('lmt '||l_aw||l_global_ecm.LangDim||' to '''||

2513: l_lang := substr (l_langs, htld_i, htld_j-htld_i);
2514: htld_i := htld_j+1;
2515: end if;
2516:
2517: zpb_aw.execute('lmt '||l_aw||l_global_ecm.LangDim||' to '''||
2518: l_lang||'''');
2519:
2520: m_hier_tl_en.Name := 'Null Hierarchy';
2521: m_hier_tl_en.LongName :=m_hier_tl_en.Name;

Line 2531: zpb_aw.execute ('pop '||l_aw||l_global_ecm.LangDim);

2527:
2528:
2529: exit when htld_j = 0;
2530: end loop; -- End looping over Languages
2531: zpb_aw.execute ('pop '||l_aw||l_global_ecm.LangDim);
2532:
2533: -- insert static hierarchy columns for null hierarchy
2534:
2535: m_hr_pers_col_memCol.TableId :=m_hier_en.PersTableId;

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

2597: m_hier_level_id := insertHierLevelRecord(m_hier_level_en);
2598: end if;
2599:
2600: -- DIMENSION ATTRIBUTES
2601: zpb_aw.execute('lmt '||l_aw||l_global_ecm.AttrDim||' to '||l_aw||
2602: l_global_attr_ecm.DomainDimRel||' eq lmt ('||l_aw||
2603: l_global_ecm.DimDim||' to '''||l_dim||''')');
2604:
2605: l_attrs := zpb_aw.interp ('shw CM.GETDIMVALUES('''||l_aw||

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

2601: zpb_aw.execute('lmt '||l_aw||l_global_ecm.AttrDim||' to '||l_aw||
2602: l_global_attr_ecm.DomainDimRel||' eq lmt ('||l_aw||
2603: l_global_ecm.DimDim||' to '''||l_dim||''')');
2604:
2605: l_attrs := zpb_aw.interp ('shw CM.GETDIMVALUES('''||l_aw||
2606: l_global_ecm.AttrDim||''' YES)');
2607:
2608: if (l_attrs <> 'NA') then
2609: ai := 1;

Line 2621: zpb_aw.execute ('lmt '||l_aw||l_global_ecm.AttrDim||' to '''|| l_attr||'''');

2617: end if;
2618:
2619: l_attr_ecm := zpb_ecm.get_attr_ecm(l_attr, l_global_attr_ecm, p_aw);
2620:
2621: zpb_aw.execute ('lmt '||l_aw||l_global_ecm.AttrDim||' to '''|| l_attr||'''');
2622:
2623: -- explicitly exclude timespan and non-displayable attributes
2624: if (instr (l_attr, 'TIMESPAN') = 0 and (zpb_aw.interpbool('shw exists(''' || l_aw || l_global_attr_ecm.AttrDisplayVar || ''')')
2625: and zpb_aw.interpbool('shw '||l_aw|| l_global_attr_ecm.AttrDisplayVar))) then

Line 2624: if (instr (l_attr, 'TIMESPAN') = 0 and (zpb_aw.interpbool('shw exists(''' || l_aw || l_global_attr_ecm.AttrDisplayVar || ''')')

2620:
2621: zpb_aw.execute ('lmt '||l_aw||l_global_ecm.AttrDim||' to '''|| l_attr||'''');
2622:
2623: -- explicitly exclude timespan and non-displayable attributes
2624: if (instr (l_attr, 'TIMESPAN') = 0 and (zpb_aw.interpbool('shw exists(''' || l_aw || l_global_attr_ecm.AttrDisplayVar || ''')')
2625: and zpb_aw.interpbool('shw '||l_aw|| l_global_attr_ecm.AttrDisplayVar))) then
2626:
2627: l_attrId :=zpb_aw.interp('shw '||l_aw||
2628: l_global_attr_ecm.RangeDimRel);

Line 2625: and zpb_aw.interpbool('shw '||l_aw|| l_global_attr_ecm.AttrDisplayVar))) then

2621: zpb_aw.execute ('lmt '||l_aw||l_global_ecm.AttrDim||' to '''|| l_attr||'''');
2622:
2623: -- explicitly exclude timespan and non-displayable attributes
2624: if (instr (l_attr, 'TIMESPAN') = 0 and (zpb_aw.interpbool('shw exists(''' || l_aw || l_global_attr_ecm.AttrDisplayVar || ''')')
2625: and zpb_aw.interpbool('shw '||l_aw|| l_global_attr_ecm.AttrDisplayVar))) then
2626:
2627: l_attrId :=zpb_aw.interp('shw '||l_aw||
2628: l_global_attr_ecm.RangeDimRel);
2629:

Line 2627: l_attrId :=zpb_aw.interp('shw '||l_aw||

2623: -- explicitly exclude timespan and non-displayable attributes
2624: if (instr (l_attr, 'TIMESPAN') = 0 and (zpb_aw.interpbool('shw exists(''' || l_aw || l_global_attr_ecm.AttrDisplayVar || ''')')
2625: and zpb_aw.interpbool('shw '||l_aw|| l_global_attr_ecm.AttrDisplayVar))) then
2626:
2627: l_attrId :=zpb_aw.interp('shw '||l_aw||
2628: l_global_attr_ecm.RangeDimRel);
2629:
2630: -- create attribute entry
2631: m_attr_en.DimensionId := m_dimension_en.DimensionId;

Line 2636: m_attr_en.Label := zpb_aw.interp('shw '||l_aw||'ATTRLABEL');

2632: m_attr_en.EPBId := l_attr;
2633: m_attr_en.Type :='DIMENSION_ATTRIBUTE';
2634: m_attr_en.PersCWMName := zpb_metadata_names.get_attribute_cwm2_name('PRS',l_dim,l_attr);
2635: m_attr_en.SharCWMName := l_attr;
2636: m_attr_en.Label := zpb_aw.interp('shw '||l_aw||'ATTRLABEL');
2637: m_attr_en.FEMAttrId := null;
2638:
2639: -- get the FEM attribute label from the namefragment
2640: -- if run into parsing problem, give up

Line 2642: l_attr_nameFrag := zpb_aw.interp('shw '||l_aw|| l_global_attr_ecm.NameFragVar);

2638:
2639: -- get the FEM attribute label from the namefragment
2640: -- if run into parsing problem, give up
2641: begin
2642: l_attr_nameFrag := zpb_aw.interp('shw '||l_aw|| l_global_attr_ecm.NameFragVar);
2643: m_attr_en.FEMAttrId := to_number(substr(l_attr_nameFrag, 2));
2644: exception
2645: when others then
2646: null;

Line 2851: zpb_aw.execute ('push '||l_aw||l_global_ecm.LangDim);

2847: -- Insert dimension language entries
2848:
2849: htld_i := 1;
2850:
2851: zpb_aw.execute ('push '||l_aw||l_global_ecm.LangDim);
2852:
2853: loop -- LOOP OVER ALL LANGUAGES
2854: htld_j := instr (l_langs, ' ', htld_i);
2855: if (htld_j = 0) then

Line 2862: zpb_aw.execute('lmt '||l_aw||l_global_ecm.LangDim||' to '''||

2858: l_lang := substr (l_langs, htld_i, htld_j-htld_i);
2859: htld_i := htld_j+1;
2860: end if;
2861:
2862: zpb_aw.execute('lmt '||l_aw||l_global_ecm.LangDim||' to '''||
2863: l_lang||'''');
2864:
2865: l_range_dim_data := zpb_ecm.get_dimension_data (m_attr_rangedim_en.EPBId, p_aw);
2866:

Line 2876: zpb_aw.execute ('pop '||l_aw||l_global_ecm.LangDim);

2872: insertDimensionsTLRecord(m_attr_rangedim_tl_en);
2873:
2874: exit when htld_j = 0;
2875: end loop; -- End looping over Languages
2876: zpb_aw.execute ('pop '||l_aw||l_global_ecm.LangDim);
2877:
2878: -- Insert Attribute Range Dimension Hierarchy Entry
2879: m_attr_rangehl_en.HierId := insertHierarchyRecord(m_attr_rangehier_en);
2880:

Line 2892: zpb_aw.execute ('push '||l_aw||l_global_ecm.LangDim);

2888: m_attr_tl_en.AttributeId := m_attr_table_col_en.attributeId;
2889:
2890: htld_i := 1;
2891:
2892: zpb_aw.execute ('push '||l_aw||l_global_ecm.LangDim);
2893:
2894: loop -- LOOP OVER ALL LANGUAGES
2895: htld_j := instr (l_langs, ' ', htld_i);
2896: if (htld_j = 0) then

Line 2903: zpb_aw.execute('lmt '||l_aw||l_global_ecm.LangDim||' to '''||

2899: l_lang := substr (l_langs, htld_i, htld_j-htld_i);
2900: htld_i := htld_j+1;
2901: end if;
2902:
2903: zpb_aw.execute('lmt '||l_aw||l_global_ecm.LangDim||' to '''||
2904: l_lang||'''');
2905:
2906: m_attr_tl_en.Name := zpb_aw.interp('shw '||l_aw||l_global_attr_ecm.LdscVar);
2907: m_attr_tl_en.LongName :=m_attr_tl_en.Name;

Line 2906: m_attr_tl_en.Name := zpb_aw.interp('shw '||l_aw||l_global_attr_ecm.LdscVar);

2902:
2903: zpb_aw.execute('lmt '||l_aw||l_global_ecm.LangDim||' to '''||
2904: l_lang||'''');
2905:
2906: m_attr_tl_en.Name := zpb_aw.interp('shw '||l_aw||l_global_attr_ecm.LdscVar);
2907: m_attr_tl_en.LongName :=m_attr_tl_en.Name;
2908: m_attr_tl_en.PluralName :=m_attr_tl_en.Name;
2909: m_attr_tl_en.PluralLongName :=m_attr_tl_en.Name;
2910: m_attr_tl_en.Language := l_lang;

Line 2916: zpb_aw.execute ('pop '||l_aw||l_global_ecm.LangDim);

2912: insertAttributesTLRecord(m_attr_tl_en);
2913:
2914: exit when htld_j = 0;
2915: end loop; -- End looping over Languages
2916: zpb_aw.execute ('pop '||l_aw||l_global_ecm.LangDim);
2917:
2918: -- pers table relation
2919: m_attr_table_col_en.tableId := m_dimension_en.PersTableId;
2920: m_attr_table_col_en.columnId := insertColumnRecord(m_pers_column_en);

Line 3157: zpb_aw.execute('pop '||l_aw||l_dim_data.ExpObj);

3153:
3154: m_attr_table_col_id := insertAttrTableColRecord(m_attr_table_col_en);
3155: end if; -- done special attributes for line dimension
3156:
3157: zpb_aw.execute('pop '||l_aw||l_dim_data.ExpObj);
3158:
3159: -- Insert Dimension Entry
3160: m_dummy_num := insertDimensionRecord(m_dimension_en, m_dimension_exists);
3161:

Line 3166: zpb_aw.execute ('push '||l_aw||l_global_ecm.LangDim);

3162: -- Insert dimension language entries
3163:
3164: htld_i := 1;
3165:
3166: zpb_aw.execute ('push '||l_aw||l_global_ecm.LangDim);
3167:
3168: loop -- LOOP OVER ALL LANGUAGES
3169: htld_j := instr (l_langs, ' ', htld_i);
3170: if (htld_j = 0) then

Line 3177: zpb_aw.execute('lmt '||l_aw||l_global_ecm.LangDim||' to '''||

3173: l_lang := substr (l_langs, htld_i, htld_j-htld_i);
3174: htld_i := htld_j+1;
3175: end if;
3176:
3177: zpb_aw.execute('lmt '||l_aw||l_global_ecm.LangDim||' to '''||
3178: l_lang||'''');
3179:
3180: l_dim_data := zpb_ecm.get_dimension_data (l_dim, p_aw);
3181: m_dimension_tl_en.Name := l_dim_data.Sdsc;

Line 3191: zpb_aw.execute ('pop '||l_aw||l_global_ecm.LangDim);

3187: insertDimensionsTLRecord(m_dimension_tl_en);
3188:
3189: exit when htld_j = 0;
3190: end loop; -- End looping over Languages
3191: zpb_aw.execute ('pop '||l_aw||l_global_ecm.LangDim);
3192:
3193: exit when j=0;
3194: end loop;
3195:

Line 3196: zpb_aw.execute('pop oknullstatus');

3192:
3193: exit when j=0;
3194: end loop;
3195:
3196: zpb_aw.execute('pop oknullstatus');
3197:
3198: end BUILD_DIMS;
3199:
3200: -------------------------------------------------------------------------------

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

3248: 'Creating metadata in ' || p_aw ||
3249: ' for cube ' || p_cubeView ||
3250: ' of type '|| p_cube_type);
3251: l_gid := false;
3252: l_aw := zpb_aw.get_schema||'.'||p_aw||'!';
3253:
3254: -- dbms_output.put_line('building cube ' || p_cubeView);
3255: -- dbms_output.put_line('with dims ' || p_dims);
3256:

Line 3329: if (zpb_aw.interp('shw obj(dimmax '''||l_aw||l_dim_ecm.HierDim||''')') <> '0')

3325: m_cube_dims_en.columnId := insertColumnRecord(m_column_en);
3326:
3327: m_relation_id := insertCubeDimsRecord(m_cube_dims_en);
3328:
3329: if (zpb_aw.interp('shw obj(dimmax '''||l_aw||l_dim_ecm.HierDim||''')') <> '0')
3330: then
3331: zpb_aw.execute ('lmt '||l_aw||l_dim_Ecm.HierDim||' to all');
3332: l_hiers := zpb_aw.interp ('shw CM.GETDIMVALUES('''||l_aw||
3333: l_dim_Ecm.HierDim||''' yes)');

Line 3331: zpb_aw.execute ('lmt '||l_aw||l_dim_Ecm.HierDim||' to all');

3327: m_relation_id := insertCubeDimsRecord(m_cube_dims_en);
3328:
3329: if (zpb_aw.interp('shw obj(dimmax '''||l_aw||l_dim_ecm.HierDim||''')') <> '0')
3330: then
3331: zpb_aw.execute ('lmt '||l_aw||l_dim_Ecm.HierDim||' to all');
3332: l_hiers := zpb_aw.interp ('shw CM.GETDIMVALUES('''||l_aw||
3333: l_dim_Ecm.HierDim||''' yes)');
3334: hi := 1;
3335: loop

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

3328:
3329: if (zpb_aw.interp('shw obj(dimmax '''||l_aw||l_dim_ecm.HierDim||''')') <> '0')
3330: then
3331: zpb_aw.execute ('lmt '||l_aw||l_dim_Ecm.HierDim||' to all');
3332: l_hiers := zpb_aw.interp ('shw CM.GETDIMVALUES('''||l_aw||
3333: l_dim_Ecm.HierDim||''' yes)');
3334: hi := 1;
3335: loop
3336: hj := instr (l_hiers, ' ', hi);

Line 3475: l_awQual := zpb_aw.get_schema||'.'||p_aw||'!';

3471: ' and approvee ' || p_approvee);
3472:
3473: bus_area_id_num := sys_context('ZPB_CONTEXT', 'business_area_id');
3474:
3475: l_awQual := zpb_aw.get_schema||'.'||p_aw||'!';
3476:
3477: l_global_ecm := zpb_ecm.get_global_ecm (p_aw);
3478:
3479: l_instType := zpb_aw.interp ('shw CM.GETINSTOBJECT('''||p_instance||

Line 3479: l_instType := zpb_aw.interp ('shw CM.GETINSTOBJECT('''||p_instance||

3475: l_awQual := zpb_aw.get_schema||'.'||p_aw||'!';
3476:
3477: l_global_ecm := zpb_ecm.get_global_ecm (p_aw);
3478:
3479: l_instType := zpb_aw.interp ('shw CM.GETINSTOBJECT('''||p_instance||
3480: ''' ''TYPE'')');
3481:
3482: -- If we are building md for personal shared measures, get the SHARED measure here. It will be
3483: -- renamed correctly (in accordance to PERSONAL measure naming in BUILD_MEASURE

Line 3508: l_meas := zpb_aw.interp ('shw CM.GETINSTOBJECT('''||p_instance||''' '''||

3504: if (p_template is not null) then
3505: l_objName := l_objName||''''||p_template||'''';
3506: end if;
3507:
3508: l_meas := zpb_aw.interp ('shw CM.GETINSTOBJECT('''||p_instance||''' '''||
3509: l_instType||' DATA '||l_objName||'''');
3510:
3511: if (l_meas = 'NA')
3512: then return;

Line 3517: l_shrdMeas := zpb_aw.interp('shw CM.GETINSTOBJECT ('''||p_instance||

3513: end if;
3514:
3515: if (p_type = 'SHARED_VIEW') then
3516: l_measAw := 'SHARED!';
3517: l_shrdMeas := zpb_aw.interp('shw CM.GETINSTOBJECT ('''||p_instance||
3518: ''' '''||l_shrdInstType||' DATA OBJECT ID'')');
3519: else
3520: l_measAW := l_awQual;
3521: l_shrdMeas := l_meas;

Line 3528: zpb_aw.execute ('push '||l_measAw||'MEASURE;'||

3524: if (l_shrdMeas = 'NA')
3525: then return;
3526: end if;
3527:
3528: zpb_aw.execute ('push '||l_measAw||'MEASURE;'||
3529: ' lmt '||l_measAw||'MEASURE to '''||l_shrdMeas||'''');
3530:
3531: l_cube := zpb_aw.interp('shw '||l_measAw||l_global_ecm.MeasViewRel);
3532:

Line 3531: l_cube := zpb_aw.interp('shw '||l_measAw||l_global_ecm.MeasViewRel);

3527:
3528: zpb_aw.execute ('push '||l_measAw||'MEASURE;'||
3529: ' lmt '||l_measAw||'MEASURE to '''||l_shrdMeas||'''');
3530:
3531: l_cube := zpb_aw.interp('shw '||l_measAw||l_global_ecm.MeasViewRel);
3532:
3533: -- Append _PRS to personal cube names
3534: if p_type = 'SHARED_VIEW' then
3535: l_cube := l_cube || '_PRS';

Line 3538: l_column := zpb_aw.interp('shw '||l_measAw||l_global_ecm.MeasColVar);

3534: if p_type = 'SHARED_VIEW' then
3535: l_cube := l_cube || '_PRS';
3536: end if;
3537:
3538: l_column := zpb_aw.interp('shw '||l_measAw||l_global_ecm.MeasColVar);
3539:
3540: select count(*)
3541: into l_count
3542: from zpb_cubes

Line 3547: l_dims := zpb_aw.interp

3543: where name = l_cube and
3544: bus_area_id = bus_area_id_num;
3545:
3546: if (l_count = 0) then
3547: l_dims := zpb_aw.interp
3548: ('shw joinchars(joincols(lmt ('||l_awQual||l_global_ecm.DimDim||
3549: ' to '||l_awQual||l_global_ecm.MeasDimVar||' ('||l_awQual||
3550: 'MEASURE '''||l_meas||''') eq yes) '' ''))');
3551: l_dims := substr(l_dims, 1, length(l_dims)-1);

Line 3555: if (zpb_aw.interpbool ('shw isValue('||l_awQual||'MEASURE '''||

3551: l_dims := substr(l_dims, 1, length(l_dims)-1);
3552: BUILD_CUBE (p_aw, l_cube, l_dims);
3553: end if;
3554:
3555: if (zpb_aw.interpbool ('shw isValue('||l_awQual||'MEASURE '''||
3556: l_meas||''')')) then
3557: BUILD_MEASURE(p_aw, p_instance, l_meas, l_cube, l_column,
3558: p_template, p_approvee);
3559: end if;

Line 3561: l_meas := zpb_aw.interp ('shw CM.GETINSTOBJECT('''||p_instance||''' '''||

3557: BUILD_MEASURE(p_aw, p_instance, l_meas, l_cube, l_column,
3558: p_template, p_approvee);
3559: end if;
3560:
3561: l_meas := zpb_aw.interp ('shw CM.GETINSTOBJECT('''||p_instance||''' '''||
3562: l_instType||' ANNOTATION '||l_objName||'''');
3563:
3564: if (p_type = 'SHARED_VIEW') then
3565: l_measAw := 'SHARED!';

Line 3566: l_shrdMeas := zpb_aw.interp('shw CM.GETINSTOBJECT ('''||p_instance||

3562: l_instType||' ANNOTATION '||l_objName||'''');
3563:
3564: if (p_type = 'SHARED_VIEW') then
3565: l_measAw := 'SHARED!';
3566: l_shrdMeas := zpb_aw.interp('shw CM.GETINSTOBJECT ('''||p_instance||
3567: ''' '''||l_shrdInstType||' ANNOTATION OBJECT ID'')');
3568: else
3569: l_measAW := l_awQual;
3570: l_shrdMeas := l_meas;

Line 3573: if (zpb_aw.interpbool ('shw isValue('||l_awQual||'MEASURE '''||

3569: l_measAW := l_awQual;
3570: l_shrdMeas := l_meas;
3571: end if;
3572:
3573: if (zpb_aw.interpbool ('shw isValue('||l_awQual||'MEASURE '''||
3574: l_meas||''')')) then
3575: zpb_aw.execute ('lmt '||l_measAw||'MEASURE to '''||l_shrdMeas||'''');
3576: l_cube := zpb_aw.interp('shw '||l_measAw||l_global_ecm.MeasViewRel);
3577:

Line 3575: zpb_aw.execute ('lmt '||l_measAw||'MEASURE to '''||l_shrdMeas||'''');

3571: end if;
3572:
3573: if (zpb_aw.interpbool ('shw isValue('||l_awQual||'MEASURE '''||
3574: l_meas||''')')) then
3575: zpb_aw.execute ('lmt '||l_measAw||'MEASURE to '''||l_shrdMeas||'''');
3576: l_cube := zpb_aw.interp('shw '||l_measAw||l_global_ecm.MeasViewRel);
3577:
3578: -- Append _PRS to personal cube names
3579: if p_type = 'SHARED_VIEW' then

Line 3576: l_cube := zpb_aw.interp('shw '||l_measAw||l_global_ecm.MeasViewRel);

3572:
3573: if (zpb_aw.interpbool ('shw isValue('||l_awQual||'MEASURE '''||
3574: l_meas||''')')) then
3575: zpb_aw.execute ('lmt '||l_measAw||'MEASURE to '''||l_shrdMeas||'''');
3576: l_cube := zpb_aw.interp('shw '||l_measAw||l_global_ecm.MeasViewRel);
3577:
3578: -- Append _PRS to personal cube names
3579: if p_type = 'SHARED_VIEW' then
3580: l_cube := l_cube || '_PRS';

Line 3583: l_column := zpb_aw.interp('shw '||l_measAw||l_global_ecm.MeasColVar);

3579: if p_type = 'SHARED_VIEW' then
3580: l_cube := l_cube || '_PRS';
3581: end if;
3582:
3583: l_column := zpb_aw.interp('shw '||l_measAw||l_global_ecm.MeasColVar);
3584: BUILD_MEASURE(p_aw, p_instance, l_meas, l_cube, l_column,
3585: p_template, p_approvee);
3586: end if;
3587:

Line 3588: l_meas := zpb_aw.interp ('shw CM.GETINSTOBJECT('''||p_instance||''' '''||

3584: BUILD_MEASURE(p_aw, p_instance, l_meas, l_cube, l_column,
3585: p_template, p_approvee);
3586: end if;
3587:
3588: l_meas := zpb_aw.interp ('shw CM.GETINSTOBJECT('''||p_instance||''' '''||
3589: l_instType||' FORMAT '||l_objName||'''');
3590: if (p_type = 'SHARED_VIEW') then
3591: l_measAw := 'SHARED!';
3592: l_shrdMeas := zpb_aw.interp('shw CM.GETINSTOBJECT ('''||p_instance||

Line 3592: l_shrdMeas := zpb_aw.interp('shw CM.GETINSTOBJECT ('''||p_instance||

3588: l_meas := zpb_aw.interp ('shw CM.GETINSTOBJECT('''||p_instance||''' '''||
3589: l_instType||' FORMAT '||l_objName||'''');
3590: if (p_type = 'SHARED_VIEW') then
3591: l_measAw := 'SHARED!';
3592: l_shrdMeas := zpb_aw.interp('shw CM.GETINSTOBJECT ('''||p_instance||
3593: ''' '''||l_shrdInstType||' FORMAT OBJECT ID'')');
3594: else
3595: l_measAW := l_awQual;
3596: l_shrdMeas := l_meas;

Line 3599: if (zpb_aw.interpbool ('shw isValue('||l_awQual||'MEASURE '''||

3595: l_measAW := l_awQual;
3596: l_shrdMeas := l_meas;
3597: end if;
3598:
3599: if (zpb_aw.interpbool ('shw isValue('||l_awQual||'MEASURE '''||
3600: l_meas||''')')) then
3601: zpb_aw.execute ('lmt '||l_measAw||'MEASURE to '''||l_shrdMeas||'''');
3602: l_cube := zpb_aw.interp('shw '||l_measAw||l_global_ecm.MeasViewRel);
3603:

Line 3601: zpb_aw.execute ('lmt '||l_measAw||'MEASURE to '''||l_shrdMeas||'''');

3597: end if;
3598:
3599: if (zpb_aw.interpbool ('shw isValue('||l_awQual||'MEASURE '''||
3600: l_meas||''')')) then
3601: zpb_aw.execute ('lmt '||l_measAw||'MEASURE to '''||l_shrdMeas||'''');
3602: l_cube := zpb_aw.interp('shw '||l_measAw||l_global_ecm.MeasViewRel);
3603:
3604: -- Append _PRS to personal cube names
3605: if p_type = 'SHARED_VIEW' then

Line 3602: l_cube := zpb_aw.interp('shw '||l_measAw||l_global_ecm.MeasViewRel);

3598:
3599: if (zpb_aw.interpbool ('shw isValue('||l_awQual||'MEASURE '''||
3600: l_meas||''')')) then
3601: zpb_aw.execute ('lmt '||l_measAw||'MEASURE to '''||l_shrdMeas||'''');
3602: l_cube := zpb_aw.interp('shw '||l_measAw||l_global_ecm.MeasViewRel);
3603:
3604: -- Append _PRS to personal cube names
3605: if p_type = 'SHARED_VIEW' then
3606: l_cube := l_cube || '_PRS';

Line 3609: l_column := zpb_aw.interp('shw '||l_measAw||l_global_ecm.MeasColVar);

3605: if p_type = 'SHARED_VIEW' then
3606: l_cube := l_cube || '_PRS';
3607: end if;
3608:
3609: l_column := zpb_aw.interp('shw '||l_measAw||l_global_ecm.MeasColVar);
3610: BUILD_MEASURE(p_aw, p_instance, l_meas, l_cube, l_column,
3611: p_template, p_approvee);
3612: end if;
3613:

Line 3616: l_meas := zpb_aw.interp ('shw CM.GETINSTOBJECT('''||p_instance||''' '''||

3612: end if;
3613:
3614:
3615: if (p_type = 'PERSONAL') then
3616: l_meas := zpb_aw.interp ('shw CM.GETINSTOBJECT('''||p_instance||''' '''||
3617: l_instType||' TARGET '||l_objName||'''');
3618:
3619: if (zpb_aw.interpbool ('shw isValue('||l_awQual||'MEASURE '''||
3620: l_meas||''')')) then

Line 3619: if (zpb_aw.interpbool ('shw isValue('||l_awQual||'MEASURE '''||

3615: if (p_type = 'PERSONAL') then
3616: l_meas := zpb_aw.interp ('shw CM.GETINSTOBJECT('''||p_instance||''' '''||
3617: l_instType||' TARGET '||l_objName||'''');
3618:
3619: if (zpb_aw.interpbool ('shw isValue('||l_awQual||'MEASURE '''||
3620: l_meas||''')')) then
3621: zpb_aw.execute ('lmt '||l_awQual||'MEASURE to '''||l_meas||'''');
3622: l_cube := zpb_aw.interp('shw '||l_awQual||l_global_ecm.MeasViewRel);
3623: l_column := zpb_aw.interp('shw '||l_measAw||l_global_ecm.MeasColVar);

Line 3621: zpb_aw.execute ('lmt '||l_awQual||'MEASURE to '''||l_meas||'''');

3617: l_instType||' TARGET '||l_objName||'''');
3618:
3619: if (zpb_aw.interpbool ('shw isValue('||l_awQual||'MEASURE '''||
3620: l_meas||''')')) then
3621: zpb_aw.execute ('lmt '||l_awQual||'MEASURE to '''||l_meas||'''');
3622: l_cube := zpb_aw.interp('shw '||l_awQual||l_global_ecm.MeasViewRel);
3623: l_column := zpb_aw.interp('shw '||l_measAw||l_global_ecm.MeasColVar);
3624: BUILD_MEASURE(p_aw, p_instance, l_meas, l_cube, l_column,
3625: p_template, p_approvee);

Line 3622: l_cube := zpb_aw.interp('shw '||l_awQual||l_global_ecm.MeasViewRel);

3618:
3619: if (zpb_aw.interpbool ('shw isValue('||l_awQual||'MEASURE '''||
3620: l_meas||''')')) then
3621: zpb_aw.execute ('lmt '||l_awQual||'MEASURE to '''||l_meas||'''');
3622: l_cube := zpb_aw.interp('shw '||l_awQual||l_global_ecm.MeasViewRel);
3623: l_column := zpb_aw.interp('shw '||l_measAw||l_global_ecm.MeasColVar);
3624: BUILD_MEASURE(p_aw, p_instance, l_meas, l_cube, l_column,
3625: p_template, p_approvee);
3626: end if;

Line 3623: l_column := zpb_aw.interp('shw '||l_measAw||l_global_ecm.MeasColVar);

3619: if (zpb_aw.interpbool ('shw isValue('||l_awQual||'MEASURE '''||
3620: l_meas||''')')) then
3621: zpb_aw.execute ('lmt '||l_awQual||'MEASURE to '''||l_meas||'''');
3622: l_cube := zpb_aw.interp('shw '||l_awQual||l_global_ecm.MeasViewRel);
3623: l_column := zpb_aw.interp('shw '||l_measAw||l_global_ecm.MeasColVar);
3624: BUILD_MEASURE(p_aw, p_instance, l_meas, l_cube, l_column,
3625: p_template, p_approvee);
3626: end if;
3627:

Line 3628: l_meas := zpb_aw.interp ('shw CM.GETINSTOBJECT('''||p_instance||''' '''||

3624: BUILD_MEASURE(p_aw, p_instance, l_meas, l_cube, l_column,
3625: p_template, p_approvee);
3626: end if;
3627:
3628: l_meas := zpb_aw.interp ('shw CM.GETINSTOBJECT('''||p_instance||''' '''||
3629: l_instType||' TARGET TYPE '||l_objName||'''');
3630:
3631: if (zpb_aw.interpbool ('shw isValue('||l_awQual||'MEASURE '''||
3632: l_meas||''')')) then

Line 3631: if (zpb_aw.interpbool ('shw isValue('||l_awQual||'MEASURE '''||

3627:
3628: l_meas := zpb_aw.interp ('shw CM.GETINSTOBJECT('''||p_instance||''' '''||
3629: l_instType||' TARGET TYPE '||l_objName||'''');
3630:
3631: if (zpb_aw.interpbool ('shw isValue('||l_awQual||'MEASURE '''||
3632: l_meas||''')')) then
3633: zpb_aw.execute ('lmt '||l_awQual||'MEASURE to '''||l_meas||'''');
3634: l_cube := zpb_aw.interp('shw '||l_awQual||l_global_ecm.MeasViewRel);
3635:

Line 3633: zpb_aw.execute ('lmt '||l_awQual||'MEASURE to '''||l_meas||'''');

3629: l_instType||' TARGET TYPE '||l_objName||'''');
3630:
3631: if (zpb_aw.interpbool ('shw isValue('||l_awQual||'MEASURE '''||
3632: l_meas||''')')) then
3633: zpb_aw.execute ('lmt '||l_awQual||'MEASURE to '''||l_meas||'''');
3634: l_cube := zpb_aw.interp('shw '||l_awQual||l_global_ecm.MeasViewRel);
3635:
3636: l_column := zpb_aw.interp('shw '||l_awQual||l_global_ecm.MeasColVar);
3637: BUILD_MEASURE(p_aw, p_instance, l_meas, l_cube, l_column,

Line 3634: l_cube := zpb_aw.interp('shw '||l_awQual||l_global_ecm.MeasViewRel);

3630:
3631: if (zpb_aw.interpbool ('shw isValue('||l_awQual||'MEASURE '''||
3632: l_meas||''')')) then
3633: zpb_aw.execute ('lmt '||l_awQual||'MEASURE to '''||l_meas||'''');
3634: l_cube := zpb_aw.interp('shw '||l_awQual||l_global_ecm.MeasViewRel);
3635:
3636: l_column := zpb_aw.interp('shw '||l_awQual||l_global_ecm.MeasColVar);
3637: BUILD_MEASURE(p_aw, p_instance, l_meas, l_cube, l_column,
3638: p_template, p_approvee);

Line 3636: l_column := zpb_aw.interp('shw '||l_awQual||l_global_ecm.MeasColVar);

3632: l_meas||''')')) then
3633: zpb_aw.execute ('lmt '||l_awQual||'MEASURE to '''||l_meas||'''');
3634: l_cube := zpb_aw.interp('shw '||l_awQual||l_global_ecm.MeasViewRel);
3635:
3636: l_column := zpb_aw.interp('shw '||l_awQual||l_global_ecm.MeasColVar);
3637: BUILD_MEASURE(p_aw, p_instance, l_meas, l_cube, l_column,
3638: p_template, p_approvee);
3639: end if;
3640:

Line 3641: l_meas := zpb_aw.interp ('shw CM.GETINSTOBJECT('''||p_instance||''' '''||

3637: BUILD_MEASURE(p_aw, p_instance, l_meas, l_cube, l_column,
3638: p_template, p_approvee);
3639: end if;
3640:
3641: l_meas := zpb_aw.interp ('shw CM.GETINSTOBJECT('''||p_instance||''' '''||
3642: l_instType||' INPUT LEVEL OBJECT ID''');
3643:
3644: if (zpb_aw.interpbool ('shw isValue('||l_awQual||'MEASURE '''||
3645: l_meas||''')')) then

Line 3644: if (zpb_aw.interpbool ('shw isValue('||l_awQual||'MEASURE '''||

3640:
3641: l_meas := zpb_aw.interp ('shw CM.GETINSTOBJECT('''||p_instance||''' '''||
3642: l_instType||' INPUT LEVEL OBJECT ID''');
3643:
3644: if (zpb_aw.interpbool ('shw isValue('||l_awQual||'MEASURE '''||
3645: l_meas||''')')) then
3646:
3647: zpb_aw.execute ('lmt '||l_measAw||'MEASURE to '''||l_meas||'''');
3648:

Line 3647: zpb_aw.execute ('lmt '||l_measAw||'MEASURE to '''||l_meas||'''');

3643:
3644: if (zpb_aw.interpbool ('shw isValue('||l_awQual||'MEASURE '''||
3645: l_meas||''')')) then
3646:
3647: zpb_aw.execute ('lmt '||l_measAw||'MEASURE to '''||l_meas||'''');
3648:
3649: l_cube := zpb_aw.interp('shw '||l_measAw||l_global_ecm.MeasViewRel);
3650:
3651: -- expose MD for cube if has not been done so yet

Line 3649: l_cube := zpb_aw.interp('shw '||l_measAw||l_global_ecm.MeasViewRel);

3645: l_meas||''')')) then
3646:
3647: zpb_aw.execute ('lmt '||l_measAw||'MEASURE to '''||l_meas||'''');
3648:
3649: l_cube := zpb_aw.interp('shw '||l_measAw||l_global_ecm.MeasViewRel);
3650:
3651: -- expose MD for cube if has not been done so yet
3652: select count(*)
3653: into l_count

Line 3659: l_dims := zpb_aw.interp

3655: where name = l_cube and
3656: bus_area_id = bus_area_id_num;
3657:
3658: if (l_count = 0) then
3659: l_dims := zpb_aw.interp
3660: ('shw joinchars(joincols(lmt ('||l_awQual||l_global_ecm.DimDim||
3661: ' to '||l_awQual||l_global_ecm.MeasDimVar||' ('||l_awQual||
3662: 'MEASURE '''||l_meas||''') eq yes) '' ''))');
3663: l_dims := substr(l_dims, 1, length(l_dims)-1);

Line 3667: l_column := zpb_aw.interp('shw '||l_awQual||l_global_ecm.MeasColVar);

3663: l_dims := substr(l_dims, 1, length(l_dims)-1);
3664: BUILD_CUBE (p_aw, l_cube, l_dims);
3665: end if;
3666:
3667: l_column := zpb_aw.interp('shw '||l_awQual||l_global_ecm.MeasColVar);
3668: BUILD_MEASURE(p_aw, p_instance, l_meas, l_cube, l_column,
3669: p_template, p_approvee);
3670:
3671: end if; -- input level MD

Line 3674: l_meas := zpb_aw.interp ('shw CM.GETINSTOBJECT('''||p_instance||''' '''||

3670:
3671: end if; -- input level MD
3672:
3673: -- expose write security of appropriate currency type
3674: l_meas := zpb_aw.interp ('shw CM.GETINSTOBJECT('''||p_instance||''' '''||
3675: l_instType||' WRITE SECURITY '||l_objName||'''');
3676:
3677: if (zpb_aw.interpbool ('shw isValue('||l_awQual||'MEASURE '''||
3678: l_meas||''')')) then

Line 3677: if (zpb_aw.interpbool ('shw isValue('||l_awQual||'MEASURE '''||

3673: -- expose write security of appropriate currency type
3674: l_meas := zpb_aw.interp ('shw CM.GETINSTOBJECT('''||p_instance||''' '''||
3675: l_instType||' WRITE SECURITY '||l_objName||'''');
3676:
3677: if (zpb_aw.interpbool ('shw isValue('||l_awQual||'MEASURE '''||
3678: l_meas||''')')) then
3679:
3680: zpb_aw.execute ('lmt '||l_measAw||'MEASURE to '''||l_meas||'''');
3681: -- if MD for write security of this currency type for this instance has already been

Line 3680: zpb_aw.execute ('lmt '||l_measAw||'MEASURE to '''||l_meas||'''');

3676:
3677: if (zpb_aw.interpbool ('shw isValue('||l_awQual||'MEASURE '''||
3678: l_meas||''')')) then
3679:
3680: zpb_aw.execute ('lmt '||l_measAw||'MEASURE to '''||l_meas||'''');
3681: -- if MD for write security of this currency type for this instance has already been
3682: -- created, no need to update now
3683: if(instr(l_meas, 'PEWSEC')) > 0 then
3684: l_write_sec_type := 'PERSONAL_ENTERED_WRITE_SECURITY';

Line 3689: l_cube := zpb_aw.interp('shw '||l_measAw||l_global_ecm.MeasViewRel);

3685: else
3686: l_write_sec_type := 'PERSONAL_WRITE_SECURITY';
3687: end if;
3688:
3689: l_cube := zpb_aw.interp('shw '||l_measAw||l_global_ecm.MeasViewRel);
3690:
3691: -- expose MD for cube if it has not been done so yet
3692: select count(*)
3693: into l_count

Line 3700: l_dims := zpb_aw.interp

3696: bus_area_id = bus_area_id_num;
3697:
3698: if (l_count = 0) then
3699:
3700: l_dims := zpb_aw.interp
3701: ('shw joinchars(joincols(lmt ('||l_awQual||l_global_ecm.DimDim||
3702: ' to '||l_awQual||l_global_ecm.MeasDimVar||' ('||l_awQual||
3703: 'MEASURE '''||l_meas||''') eq yes) '' ''))');
3704: l_dims := substr(l_dims, 1, length(l_dims)-1);

Line 3708: l_column := zpb_aw.interp('shw '||l_measAw||l_global_ecm.MeasColVar);

3704: l_dims := substr(l_dims, 1, length(l_dims)-1);
3705: BUILD_CUBE (p_aw, l_cube, l_dims);
3706: end if;
3707:
3708: l_column := zpb_aw.interp('shw '||l_measAw||l_global_ecm.MeasColVar);
3709: BUILD_MEASURE(p_aw, p_instance, l_meas, l_cube, l_column,
3710: p_template, p_approvee);
3711:
3712: end if; -- write sec block

Line 3718: zpb_aw.execute('push oknullstatus');

3714:
3715: -- expose translated and entered MD
3716: if p_type = 'SHARED' or p_type = 'SHARED_VIEW' then
3717:
3718: zpb_aw.execute('push oknullstatus');
3719: zpb_aw.execute('oknullstatus = yes');
3720:
3721: zpb_aw.execute ('lmt '||l_awQual||'MEASURE to findchars(' || l_awQual || 'MEASURE '''|| p_instance || ''') gt 0');
3722: zpb_aw.execute ('lmt '||l_awQual||'MEASURE keep findchars(' || l_awQual || 'MEASURE ''.E.'') gt 0');

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

3715: -- expose translated and entered MD
3716: if p_type = 'SHARED' or p_type = 'SHARED_VIEW' then
3717:
3718: zpb_aw.execute('push oknullstatus');
3719: zpb_aw.execute('oknullstatus = yes');
3720:
3721: zpb_aw.execute ('lmt '||l_awQual||'MEASURE to findchars(' || l_awQual || 'MEASURE '''|| p_instance || ''') gt 0');
3722: zpb_aw.execute ('lmt '||l_awQual||'MEASURE keep findchars(' || l_awQual || 'MEASURE ''.E.'') gt 0');
3723:

Line 3721: zpb_aw.execute ('lmt '||l_awQual||'MEASURE to findchars(' || l_awQual || 'MEASURE '''|| p_instance || ''') gt 0');

3717:
3718: zpb_aw.execute('push oknullstatus');
3719: zpb_aw.execute('oknullstatus = yes');
3720:
3721: zpb_aw.execute ('lmt '||l_awQual||'MEASURE to findchars(' || l_awQual || 'MEASURE '''|| p_instance || ''') gt 0');
3722: zpb_aw.execute ('lmt '||l_awQual||'MEASURE keep findchars(' || l_awQual || 'MEASURE ''.E.'') gt 0');
3723:
3724: l_measAW := l_awQual;
3725:

Line 3722: zpb_aw.execute ('lmt '||l_awQual||'MEASURE keep findchars(' || l_awQual || 'MEASURE ''.E.'') gt 0');

3718: zpb_aw.execute('push oknullstatus');
3719: zpb_aw.execute('oknullstatus = yes');
3720:
3721: zpb_aw.execute ('lmt '||l_awQual||'MEASURE to findchars(' || l_awQual || 'MEASURE '''|| p_instance || ''') gt 0');
3722: zpb_aw.execute ('lmt '||l_awQual||'MEASURE keep findchars(' || l_awQual || 'MEASURE ''.E.'') gt 0');
3723:
3724: l_measAW := l_awQual;
3725:
3726: if (zpb_aw.interp('shw convert(statlen('||l_awQual||'MEASURE'||

Line 3726: if (zpb_aw.interp('shw convert(statlen('||l_awQual||'MEASURE'||

3722: zpb_aw.execute ('lmt '||l_awQual||'MEASURE keep findchars(' || l_awQual || 'MEASURE ''.E.'') gt 0');
3723:
3724: l_measAW := l_awQual;
3725:
3726: if (zpb_aw.interp('shw convert(statlen('||l_awQual||'MEASURE'||
3727: ') text 0 no no)') <> 0) then
3728:
3729: hi := 1;
3730: l_curMeasures :=zpb_aw.interp

Line 3730: l_curMeasures :=zpb_aw.interp

3726: if (zpb_aw.interp('shw convert(statlen('||l_awQual||'MEASURE'||
3727: ') text 0 no no)') <> 0) then
3728:
3729: hi := 1;
3730: l_curMeasures :=zpb_aw.interp
3731: ('shw CM.GETDIMVALUES('''||l_awQual||'MEASURE'||''', ''YES'')');
3732:
3733: loop -- LOOP OVER ALL ENTERED MEASURES
3734: hj := instr (l_curMeasures, ' ', hi);

Line 3742: zpb_aw.execute ('lmt '||l_awQual||'MEASURE to '''||l_curMeas||'''');

3738: l_curMeas := substr (l_curMeasures, hi, hj-hi);
3739: hi := hj+1;
3740: end if;
3741:
3742: zpb_aw.execute ('lmt '||l_awQual||'MEASURE to '''||l_curMeas||'''');
3743: l_cube := zpb_aw.interp('shw '||l_awQual||l_global_ecm.MeasViewRel);
3744:
3745: -- Append _PRS to personal cube names
3746: if p_type = 'SHARED_VIEW' then

Line 3743: l_cube := zpb_aw.interp('shw '||l_awQual||l_global_ecm.MeasViewRel);

3739: hi := hj+1;
3740: end if;
3741:
3742: zpb_aw.execute ('lmt '||l_awQual||'MEASURE to '''||l_curMeas||'''');
3743: l_cube := zpb_aw.interp('shw '||l_awQual||l_global_ecm.MeasViewRel);
3744:
3745: -- Append _PRS to personal cube names
3746: if p_type = 'SHARED_VIEW' then
3747: l_cube := l_cube || '_PRS';

Line 3759: l_dims := zpb_aw.interp

3755: where name = l_cube and
3756: bus_area_id = bus_area_id_num;
3757:
3758: if (l_count = 0) then
3759: l_dims := zpb_aw.interp
3760: ('shw joinchars(joincols(lmt ('||l_awQual||l_global_ecm.DimDim||
3761: ' to '||l_awQual||l_global_ecm.MeasDimVar||' ('||l_awQual||
3762: 'MEASURE '''||l_curMeas||''') eq yes) '' ''))');
3763: l_dims := substr(l_dims, 1, length(l_dims)-1);

Line 3767: l_column := zpb_aw.interp('shw '||l_measAw||l_global_ecm.MeasColVar);

3763: l_dims := substr(l_dims, 1, length(l_dims)-1);
3764: BUILD_CUBE (p_aw, l_cube, l_dims);
3765: end if;
3766:
3767: l_column := zpb_aw.interp('shw '||l_measAw||l_global_ecm.MeasColVar);
3768:
3769: -- l_curRel := zpb_aw.interp('shw &joinchars('''||l_awQual||
3770: -- ''' obj(property ''MEASCURRENCYREL'' ''MEASURE''))');
3771:

Line 3769: -- l_curRel := zpb_aw.interp('shw &joinchars('''||l_awQual||

3765: end if;
3766:
3767: l_column := zpb_aw.interp('shw '||l_measAw||l_global_ecm.MeasColVar);
3768:
3769: -- l_curRel := zpb_aw.interp('shw &joinchars('''||l_awQual||
3770: -- ''' obj(property ''MEASCURRENCYREL'' ''MEASURE''))');
3771:
3772: l_curRel := zpb_aw.interp('shw '||l_awQual||'MEASCURRENCY');
3773:

Line 3772: l_curRel := zpb_aw.interp('shw '||l_awQual||'MEASCURRENCY');

3768:
3769: -- l_curRel := zpb_aw.interp('shw &joinchars('''||l_awQual||
3770: -- ''' obj(property ''MEASCURRENCYREL'' ''MEASURE''))');
3771:
3772: l_curRel := zpb_aw.interp('shw '||l_awQual||'MEASCURRENCY');
3773:
3774: BUILD_MEASURE(p_aw, p_instance, l_curMeas, l_cube, l_column,
3775: p_template, p_approvee, l_curRel);
3776:

Line 3785: zpb_aw.execute ('lmt '||l_awQual||'MEASURE to findchars(' || l_awQual || 'MEASURE '''|| p_instance || ''') gt 0');

3781:
3782: end if; -- if measure dim has any members
3783:
3784:
3785: zpb_aw.execute ('lmt '||l_awQual||'MEASURE to findchars(' || l_awQual || 'MEASURE '''|| p_instance || ''') gt 0');
3786: zpb_aw.execute ('lmt '||l_awQual||'MEASURE keep findchars(' || l_awQual || 'MEASURE ''.T.'') gt 0');
3787:
3788: if (zpb_aw.interp('shw convert(statlen('||l_awQual||'MEASURE'||
3789: ') text 0 no no)') <> 0) then

Line 3786: zpb_aw.execute ('lmt '||l_awQual||'MEASURE keep findchars(' || l_awQual || 'MEASURE ''.T.'') gt 0');

3782: end if; -- if measure dim has any members
3783:
3784:
3785: zpb_aw.execute ('lmt '||l_awQual||'MEASURE to findchars(' || l_awQual || 'MEASURE '''|| p_instance || ''') gt 0');
3786: zpb_aw.execute ('lmt '||l_awQual||'MEASURE keep findchars(' || l_awQual || 'MEASURE ''.T.'') gt 0');
3787:
3788: if (zpb_aw.interp('shw convert(statlen('||l_awQual||'MEASURE'||
3789: ') text 0 no no)') <> 0) then
3790:

Line 3788: if (zpb_aw.interp('shw convert(statlen('||l_awQual||'MEASURE'||

3784:
3785: zpb_aw.execute ('lmt '||l_awQual||'MEASURE to findchars(' || l_awQual || 'MEASURE '''|| p_instance || ''') gt 0');
3786: zpb_aw.execute ('lmt '||l_awQual||'MEASURE keep findchars(' || l_awQual || 'MEASURE ''.T.'') gt 0');
3787:
3788: if (zpb_aw.interp('shw convert(statlen('||l_awQual||'MEASURE'||
3789: ') text 0 no no)') <> 0) then
3790:
3791: hi := 1;
3792: l_curMeasures :=zpb_aw.interp

Line 3792: l_curMeasures :=zpb_aw.interp

3788: if (zpb_aw.interp('shw convert(statlen('||l_awQual||'MEASURE'||
3789: ') text 0 no no)') <> 0) then
3790:
3791: hi := 1;
3792: l_curMeasures :=zpb_aw.interp
3793: ('shw CM.GETDIMVALUES('''||l_awQual||'MEASURE'||''', ''YES'')');
3794: -- dbms_output.put_line('l_curMeasures: ' || l_curMeasures);
3795:
3796: loop -- LOOP OVER ALL CURRENCY TRANSLATED MEASURES

Line 3805: zpb_aw.execute ('lmt '||l_awQual||'MEASURE to '''||l_curMeas||'''');

3801: l_curMeas := substr (l_curMeasures, hi, hj-hi);
3802: hi := hj+1;
3803: end if;
3804:
3805: zpb_aw.execute ('lmt '||l_awQual||'MEASURE to '''||l_curMeas||'''');
3806:
3807: --dbms_output.put_line('l_curMeas: ' || l_curMeas);
3808:
3809: l_cube := zpb_aw.interp('shw '||l_awQual||l_global_ecm.MeasViewRel);

Line 3809: l_cube := zpb_aw.interp('shw '||l_awQual||l_global_ecm.MeasViewRel);

3805: zpb_aw.execute ('lmt '||l_awQual||'MEASURE to '''||l_curMeas||'''');
3806:
3807: --dbms_output.put_line('l_curMeas: ' || l_curMeas);
3808:
3809: l_cube := zpb_aw.interp('shw '||l_awQual||l_global_ecm.MeasViewRel);
3810:
3811: -- Append _PRS to personal cube names
3812: if p_type = 'SHARED_VIEW' then
3813: l_cube := l_cube || '_PRS';

Line 3829: l_dims := zpb_aw.interp

3825:
3826: --dbms_output.put_line('l_count: ' || l_count);
3827:
3828: if (l_count = 0) then
3829: l_dims := zpb_aw.interp
3830: ('shw joinchars(joincols(lmt ('||l_awQual||l_global_ecm.DimDim||
3831: ' to '||l_awQual||l_global_ecm.MeasDimVar||' ('||l_awQual||
3832: 'MEASURE '''||l_curMeas||''') eq yes) '' ''))');
3833: l_dims := substr(l_dims, 1, length(l_dims)-1);

Line 3837: l_column := zpb_aw.interp('shw '||l_measAw||l_global_ecm.MeasColVar);

3833: l_dims := substr(l_dims, 1, length(l_dims)-1);
3834: BUILD_CUBE (p_aw, l_cube, l_dims);
3835: end if;
3836:
3837: l_column := zpb_aw.interp('shw '||l_measAw||l_global_ecm.MeasColVar);
3838:
3839: -- l_curRel := zpb_aw.interp('shw &joinchars('''||l_awQual||
3840: -- ''' obj(property ''MEASCURRENCYREL'' ''MEASURE''))');
3841:

Line 3839: -- l_curRel := zpb_aw.interp('shw &joinchars('''||l_awQual||

3835: end if;
3836:
3837: l_column := zpb_aw.interp('shw '||l_measAw||l_global_ecm.MeasColVar);
3838:
3839: -- l_curRel := zpb_aw.interp('shw &joinchars('''||l_awQual||
3840: -- ''' obj(property ''MEASCURRENCYREL'' ''MEASURE''))');
3841:
3842: l_curRel := zpb_aw.interp('shw '||l_awQual||'MEASCURRENCY');
3843:

Line 3842: l_curRel := zpb_aw.interp('shw '||l_awQual||'MEASCURRENCY');

3838:
3839: -- l_curRel := zpb_aw.interp('shw &joinchars('''||l_awQual||
3840: -- ''' obj(property ''MEASCURRENCYREL'' ''MEASURE''))');
3841:
3842: l_curRel := zpb_aw.interp('shw '||l_awQual||'MEASCURRENCY');
3843:
3844: BUILD_MEASURE(p_aw, p_instance, l_curMeas, l_cube, l_column,
3845: p_template, p_approvee, l_curRel);
3846:

Line 3854: zpb_aw.execute('pop oknullstatus');

3850: end loop; -- End looping over CURRENCY TRANSLATED MEASURES
3851:
3852: end if; -- if measure dim has any members
3853:
3854: zpb_aw.execute('pop oknullstatus');
3855:
3856: end if; -- shared or shared view for currency building
3857: zpb_aw.execute ('pop '||l_measAw||'MEASURE');
3858:

Line 3857: zpb_aw.execute ('pop '||l_measAw||'MEASURE');

3853:
3854: zpb_aw.execute('pop oknullstatus');
3855:
3856: end if; -- shared or shared view for currency building
3857: zpb_aw.execute ('pop '||l_measAw||'MEASURE');
3858:
3859: zpb_log.write('zpb_metadata_pkg.build_instance.end',
3860: 'succesfull completion');
3861:

Line 3935: l_schema := zpb_aw.get_schema||'.';

3931: ' and template ' || p_template ||
3932: ' and approvee ' || p_approvee);
3933:
3934:
3935: l_schema := zpb_aw.get_schema||'.';
3936: l_awQual := l_schema||p_aw||'!';
3937:
3938: bus_area_id_num := sys_context('ZPB_CONTEXT', 'business_area_id');
3939:

Line 3941: zpb_aw.execute ('push '||l_awQual||'MEASURE');

3937:
3938: bus_area_id_num := sys_context('ZPB_CONTEXT', 'business_area_id');
3939:
3940: l_global_ecm := zpb_ecm.get_global_ecm(p_aw);
3941: zpb_aw.execute ('push '||l_awQual||'MEASURE');
3942: zpb_aw.execute ('lmt '||l_awQual||'MEASURE to '''||p_meas||'''');
3943:
3944: l_measType := zpb_aw.interp('shw '||l_awQual||l_global_ecm.MeasTypeRel);
3945:

Line 3942: zpb_aw.execute ('lmt '||l_awQual||'MEASURE to '''||p_meas||'''');

3938: bus_area_id_num := sys_context('ZPB_CONTEXT', 'business_area_id');
3939:
3940: l_global_ecm := zpb_ecm.get_global_ecm(p_aw);
3941: zpb_aw.execute ('push '||l_awQual||'MEASURE');
3942: zpb_aw.execute ('lmt '||l_awQual||'MEASURE to '''||p_meas||'''');
3943:
3944: l_measType := zpb_aw.interp('shw '||l_awQual||l_global_ecm.MeasTypeRel);
3945:
3946:

Line 3944: l_measType := zpb_aw.interp('shw '||l_awQual||l_global_ecm.MeasTypeRel);

3940: l_global_ecm := zpb_ecm.get_global_ecm(p_aw);
3941: zpb_aw.execute ('push '||l_awQual||'MEASURE');
3942: zpb_aw.execute ('lmt '||l_awQual||'MEASURE to '''||p_meas||'''');
3943:
3944: l_measType := zpb_aw.interp('shw '||l_awQual||l_global_ecm.MeasTypeRel);
3945:
3946:
3947: -- update for personal measure MD
3948:

Line 3957: l_measFrm := zpb_aw.interp('shw '||l_awQual||l_global_ecm.MeasExpObjVar);

3953: l_measType := m_string1 || 'VIEW_' || m_string2 ;
3954: -- dbms_output.put_line('l_measType after :' || l_measType);
3955: end if;
3956:
3957: l_measFrm := zpb_aw.interp('shw '||l_awQual||l_global_ecm.MeasExpObjVar);
3958:
3959: -- dbms_output.put_line('l_measFrm before :' || l_measFrm);
3960: -- AWName FRM.FM8713 -> FRM.SHFM8713
3961: if instr (p_cube, '_PRS') > 0 then

Line 3983: l_measName := zpb_aw.interp('shw &joinchars('''||l_awQual||

3979: end if;
3980: -- dbms_output.put_line('l_measFrm after :' || l_measFrm);
3981: end if;
3982:
3983: l_measName := zpb_aw.interp('shw &joinchars('''||l_awQual||
3984: ''' obj(property ''LDSCVAR'' ''MEASURE''))');
3985:
3986: m_meas_en.name := l_measName;
3987: m_meas_en.AWName := l_measFrm;

Line 4015: m_meas_en.CurrInstFlag := upper(zpb_aw.interp('shw '||l_awQual||l_global_ecm.IsCurrInstVar)); */

4011: m_meas_en.Type := l_measType;
4012: m_meas_en.InstanceId := p_instance;
4013:
4014: /* Bug#5766644, commented and replaced for if-else-if logic
4015: m_meas_en.CurrInstFlag := upper(zpb_aw.interp('shw '||l_awQual||l_global_ecm.IsCurrInstVar)); */
4016: if zpb_aw.interpbool ('shw '||l_awQual||l_global_ecm.IsCurrInstVar) then
4017: m_meas_en.CurrInstFlag := 'YES';
4018: else
4019: m_meas_en.CurrInstFlag := 'NO';

Line 4016: if zpb_aw.interpbool ('shw '||l_awQual||l_global_ecm.IsCurrInstVar) then

4012: m_meas_en.InstanceId := p_instance;
4013:
4014: /* Bug#5766644, commented and replaced for if-else-if logic
4015: m_meas_en.CurrInstFlag := upper(zpb_aw.interp('shw '||l_awQual||l_global_ecm.IsCurrInstVar)); */
4016: if zpb_aw.interpbool ('shw '||l_awQual||l_global_ecm.IsCurrInstVar) then
4017: m_meas_en.CurrInstFlag := 'YES';
4018: else
4019: m_meas_en.CurrInstFlag := 'NO';
4020: end if;

Line 4126: if (zpb_aw.interp('shw statlen(limit(SHARED!' || l_global_ecm.DimDim ||

4122: m_meas_en.CurrencyType := 'NA';
4123:
4124: -- if clause will be true if this is a currency-enabled business area
4125: -- only need to expose these currency fields for shared AWs (open-sql access)
4126: if (zpb_aw.interp('shw statlen(limit(SHARED!' || l_global_ecm.DimDim ||
4127: ' to SHARED!' || l_global_ecm.DimTypeRel ||
4128: ' eq ''FROM_CURRENCY''))') <> 0 and instr(p_cube, 'ZPBDATA') > 0) then
4129:
4130: m_meas_en.CurrencyType := zpb_aw.interp ('shw shared!instance.currency.type (shared!instance ''' || p_instance || ''')');

Line 4130: m_meas_en.CurrencyType := zpb_aw.interp ('shw shared!instance.currency.type (shared!instance ''' || p_instance || ''')');

4126: if (zpb_aw.interp('shw statlen(limit(SHARED!' || l_global_ecm.DimDim ||
4127: ' to SHARED!' || l_global_ecm.DimTypeRel ||
4128: ' eq ''FROM_CURRENCY''))') <> 0 and instr(p_cube, 'ZPBDATA') > 0) then
4129:
4130: m_meas_en.CurrencyType := zpb_aw.interp ('shw shared!instance.currency.type (shared!instance ''' || p_instance || ''')');
4131:
4132: -- only set selected currency field if the currency type is SPECIFIED
4133: if m_meas_en.CurrencyType = 'SPECIFIED' then
4134: m_meas_en.SelectedCur := zpb_aw.interp ('shw shared!instance.currency (shared!instance ''' || p_instance || ''')');

Line 4134: m_meas_en.SelectedCur := zpb_aw.interp ('shw shared!instance.currency (shared!instance ''' || p_instance || ''')');

4130: m_meas_en.CurrencyType := zpb_aw.interp ('shw shared!instance.currency.type (shared!instance ''' || p_instance || ''')');
4131:
4132: -- only set selected currency field if the currency type is SPECIFIED
4133: if m_meas_en.CurrencyType = 'SPECIFIED' then
4134: m_meas_en.SelectedCur := zpb_aw.interp ('shw shared!instance.currency (shared!instance ''' || p_instance || ''')');
4135: end if;
4136: end if;
4137:
4138: m_meas_en.CPRMeasure :='NO';

Line 4140: if(l_type='PERSONAL' and zpb_aw.interpbool('shw exists(''' || l_awQual || 'CPRFLAG.DM'')')) then

4136: end if;
4137:
4138: m_meas_en.CPRMeasure :='NO';
4139: -- set cpr measure flag if it is available
4140: if(l_type='PERSONAL' and zpb_aw.interpbool('shw exists(''' || l_awQual || 'CPRFLAG.DM'')')) then
4141: if zpb_aw.interpbool('shw '||l_awQual||'CPRFLAG.DM') then
4142: m_meas_en.CPRMeasure :='YES';
4143: end if;
4144: end if;

Line 4141: if zpb_aw.interpbool('shw '||l_awQual||'CPRFLAG.DM') then

4137:
4138: m_meas_en.CPRMeasure :='NO';
4139: -- set cpr measure flag if it is available
4140: if(l_type='PERSONAL' and zpb_aw.interpbool('shw exists(''' || l_awQual || 'CPRFLAG.DM'')')) then
4141: if zpb_aw.interpbool('shw '||l_awQual||'CPRFLAG.DM') then
4142: m_meas_en.CPRMeasure :='YES';
4143: end if;
4144: end if;
4145:

Line 4156: zpb_aw.execute ('pop '||l_awQual||'MEASURE');

4152:
4153: end if;
4154:
4155:
4156: zpb_aw.execute ('pop '||l_awQual||'MEASURE');
4157:
4158: zpb_log.write('zpb_metadata.build_measure.end',
4159: 'succesfull completion');
4160:

Line 4239: zpb_aw.execute ('aw attach '||zpb_aw.get_schema||'.'||p_aw||' first');

4235: bus_area_id_num := sys_context('ZPB_CONTEXT', 'business_area_id');
4236:
4237: select sysdate into m_start_time from dual;
4238:
4239: zpb_aw.execute ('aw attach '||zpb_aw.get_schema||'.'||p_aw||' first');
4240:
4241: l_gid := false;
4242: l_aw := zpb_aw.get_schema||'.'||p_aw||'!';
4243: l_global_ecm := zpb_ecm.get_global_ecm(p_aw);

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

4238:
4239: zpb_aw.execute ('aw attach '||zpb_aw.get_schema||'.'||p_aw||' first');
4240:
4241: l_gid := false;
4242: l_aw := zpb_aw.get_schema||'.'||p_aw||'!';
4243: l_global_ecm := zpb_ecm.get_global_ecm(p_aw);
4244:
4245: zpb_aw.execute('push oknullstatus '||l_global_ecm.AttrDim);
4246: zpb_aw.execute('oknullstatus = yes');

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

4241: l_gid := false;
4242: l_aw := zpb_aw.get_schema||'.'||p_aw||'!';
4243: l_global_ecm := zpb_ecm.get_global_ecm(p_aw);
4244:
4245: zpb_aw.execute('push oknullstatus '||l_global_ecm.AttrDim);
4246: zpb_aw.execute('oknullstatus = yes');
4247:
4248: if p_onlySec='N' then
4249:

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

4242: l_aw := zpb_aw.get_schema||'.'||p_aw||'!';
4243: l_global_ecm := zpb_ecm.get_global_ecm(p_aw);
4244:
4245: zpb_aw.execute('push oknullstatus '||l_global_ecm.AttrDim);
4246: zpb_aw.execute('oknullstatus = yes');
4247:
4248: if p_onlySec='N' then
4249:
4250: l_dims := zpb_aw.interp ('shw CM.GETDATADIMS');

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

4246: zpb_aw.execute('oknullstatus = yes');
4247:
4248: if p_onlySec='N' then
4249:
4250: l_dims := zpb_aw.interp ('shw CM.GETDATADIMS');
4251:
4252: BUILD_DIMS (p_aw, p_sharedAW, p_type, l_dims);
4253:
4254: l_instances := zpb_aw.interp('shw CM.GETDIMVALUES('''||l_aw||'INSTANCE'')');

Line 4254: l_instances := zpb_aw.interp('shw CM.GETDIMVALUES('''||l_aw||'INSTANCE'')');

4250: l_dims := zpb_aw.interp ('shw CM.GETDATADIMS');
4251:
4252: BUILD_DIMS (p_aw, p_sharedAW, p_type, l_dims);
4253:
4254: l_instances := zpb_aw.interp('shw CM.GETDIMVALUES('''||l_aw||'INSTANCE'')');
4255: if (p_doMeas = 'Y' and l_instances <> 'NA') then
4256: if(p_type = 'SHARED') then
4257: delete_shared_cubes(p_sharedAW);
4258: end if;

Line 4273: l_value := zpb_aw.interp ('shw CM.GETINSTOBJECT('''||l_instance||

4269: if (p_type = 'SHARED') then
4270: BUILD_INSTANCE (p_aw, l_instance, 'SHARED');
4271: BUILD_INSTANCE (p_aw, l_instance, 'SHARED_VIEW');
4272: else
4273: l_value := zpb_aw.interp ('shw CM.GETINSTOBJECT('''||l_instance||
4274: ''' ''TYPE'')');
4275: if (l_value = 'ANALYST_CALC') then
4276: BUILD_INSTANCE (p_aw, l_instance, 'PERSONAL');
4277: else

Line 4279: zpb_aw.execute ('lmt '||l_aw||'MEASURE to findchars('||l_aw||

4275: if (l_value = 'ANALYST_CALC') then
4276: BUILD_INSTANCE (p_aw, l_instance, 'PERSONAL');
4277: else
4278: --BUILD_INSTANCE (p_aw, l_instance, 'SHARED_VIEW');
4279: zpb_aw.execute ('lmt '||l_aw||'MEASURE to findchars('||l_aw||
4280: 'MEASURE ''DF'||l_instance||'.'') eq 1');
4281: l_measures := zpb_aw.interp ('shw CM.GETDIMVALUES ('''||l_aw||
4282: 'MEASURE'' yes)');
4283: if (l_measures <> 'NA') then

Line 4281: l_measures := zpb_aw.interp ('shw CM.GETDIMVALUES ('''||l_aw||

4277: else
4278: --BUILD_INSTANCE (p_aw, l_instance, 'SHARED_VIEW');
4279: zpb_aw.execute ('lmt '||l_aw||'MEASURE to findchars('||l_aw||
4280: 'MEASURE ''DF'||l_instance||'.'') eq 1');
4281: l_measures := zpb_aw.interp ('shw CM.GETDIMVALUES ('''||l_aw||
4282: 'MEASURE'' yes)');
4283: if (l_measures <> 'NA') then
4284: hi := 1;
4285: loop

Line 4300: zpb_aw.execute ('lmt '||l_aw||'MEASURE to findchars('||l_aw||

4296: exit when hj=0;
4297: end loop;
4298: end if;
4299:
4300: zpb_aw.execute ('lmt '||l_aw||'MEASURE to findchars('||l_aw||
4301: 'MEASURE ''APPDF'||l_instance||'.'') eq 1');
4302: l_measures := zpb_aw.interp ('shw CM.GETDIMVALUES ('''||l_aw||
4303: 'MEASURE'' yes)');
4304: if (l_measures <> 'NA') then

Line 4302: l_measures := zpb_aw.interp ('shw CM.GETDIMVALUES ('''||l_aw||

4298: end if;
4299:
4300: zpb_aw.execute ('lmt '||l_aw||'MEASURE to findchars('||l_aw||
4301: 'MEASURE ''APPDF'||l_instance||'.'') eq 1');
4302: l_measures := zpb_aw.interp ('shw CM.GETDIMVALUES ('''||l_aw||
4303: 'MEASURE'' yes)');
4304: if (l_measures <> 'NA') then
4305: hi := 1;
4306: loop

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

4336: if (p_type = 'SHARED') then
4337: --
4338: -- Generate the dimension up front, since they are the same for all meas
4339: --
4340: l_dims := zpb_aw.interp ('shw CM.GETDATADIMS');
4341:
4342: BUILD_CUBE(p_aw, zpb_metadata_names.get_security_view(p_aw), l_dims, 'SEC_CUBE');
4343:
4344:

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

4400:
4401: --
4402: -- Redo OWNERMAP:
4403: --
4404: zpb_aw.execute ('oknullstatus=yes');
4405: zpb_aw.execute ('lmt '||l_aw||l_global_ecm.DimDim||' to '||
4406: l_aw||l_global_ecm.IsOwnerDim||' eq yes');
4407: l_dims := zpb_aw.interp ('shw joinchars(joincols(values('||
4408: l_aw||l_global_ecm.DimDim||') '' ''))');

Line 4405: zpb_aw.execute ('lmt '||l_aw||l_global_ecm.DimDim||' to '||

4401: --
4402: -- Redo OWNERMAP:
4403: --
4404: zpb_aw.execute ('oknullstatus=yes');
4405: zpb_aw.execute ('lmt '||l_aw||l_global_ecm.DimDim||' to '||
4406: l_aw||l_global_ecm.IsOwnerDim||' eq yes');
4407: l_dims := zpb_aw.interp ('shw joinchars(joincols(values('||
4408: l_aw||l_global_ecm.DimDim||') '' ''))');
4409: if (l_dims <> 'NA' and l_dims <> ' ') then

Line 4407: l_dims := zpb_aw.interp ('shw joinchars(joincols(values('||

4403: --
4404: zpb_aw.execute ('oknullstatus=yes');
4405: zpb_aw.execute ('lmt '||l_aw||l_global_ecm.DimDim||' to '||
4406: l_aw||l_global_ecm.IsOwnerDim||' eq yes');
4407: l_dims := zpb_aw.interp ('shw joinchars(joincols(values('||
4408: l_aw||l_global_ecm.DimDim||') '' ''))');
4409: if (l_dims <> 'NA' and l_dims <> ' ') then
4410: l_dims := substr (l_dims, 1, length(l_dims) - 1);
4411: BUILD_OWNERMAP_MEASURE (p_aw, l_dims);

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

4656: m_column_id_num := insertColumnRecord(m_column_en);
4657:
4658: end if;
4659:
4660: zpb_aw.execute('pop oknullstatus '||l_global_ecm.AttrDim);
4661:
4662: zpb_log.write('zpb_metadata_pkg.build.end',
4663: 'Created metadata map for '||p_aw);
4664:

Line 4751: ZPB_AW.INITIALIZE_USER (P_API_VERSION => 1.0,

4747: -- called at definition time - need to initialize connection as running on
4748: -- AM connection
4749: if p_fake_flag then
4750:
4751: ZPB_AW.INITIALIZE_USER (P_API_VERSION => 1.0,
4752: P_INIT_MSG_LIST => FND_API.G_FALSE,
4753: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
4754: X_RETURN_STATUS => RETCODE,
4755: X_MSG_COUNT => l_msg_count,

Line 4784: l_aw := zpb_aw.get_schema||'.'||p_persAw||'!';

4780: end if;
4781:
4782:
4783: l_global_ecm := zpb_ecm.get_global_ecm (p_persAw);
4784: l_aw := zpb_aw.get_schema||'.'||p_persAw||'!';
4785: l_gid := false;
4786:
4787:
4788: select CURRENT_INSTANCE_ID

Line 4805: zpb_aw.execute('call SC.EXCEPCPRMOD(''' || p_instance || ''')');

4801: -- make sure middle-tier cube points to view of actual processing instance for
4802: -- status-sql generation
4803: if p_fake_flag = false then
4804: -- update FRM.CPR formula
4805: zpb_aw.execute('call SC.EXCEPCPRMOD(''' || p_instance || ''')');
4806:
4807: l_cpr_meas_cube := zpb_aw.interp ('shw ' || l_aw || 'measviewrel (' || l_aw || 'measure ''' || l_frmcpr || ''')');
4808: l_cpr_meas_cube := l_cpr_meas_cube || '_PRS';
4809:

Line 4807: l_cpr_meas_cube := zpb_aw.interp ('shw ' || l_aw || 'measviewrel (' || l_aw || 'measure ''' || l_frmcpr || ''')');

4803: if p_fake_flag = false then
4804: -- update FRM.CPR formula
4805: zpb_aw.execute('call SC.EXCEPCPRMOD(''' || p_instance || ''')');
4806:
4807: l_cpr_meas_cube := zpb_aw.interp ('shw ' || l_aw || 'measviewrel (' || l_aw || 'measure ''' || l_frmcpr || ''')');
4808: l_cpr_meas_cube := l_cpr_meas_cube || '_PRS';
4809:
4810: -- cube table
4811: select table_name into m_table_en.TableName

Line 4837: l_dim := zpb_aw.interp ('shw lmt('||l_aw||l_global_ecm.DimDim||' to '||

4833: -- initialize column entry for cube table
4834: m_column_en.TableId :=m_cube_en.TableId;
4835:
4836: for each in dims loop
4837: l_dim := zpb_aw.interp ('shw lmt('||l_aw||l_global_ecm.DimDim||' to '||
4838: l_aw||l_global_ecm.ExpObjVar||' eq '''||
4839: each.DIMENSION_NAME||''')');
4840:
4841: -- set dimension id for cube-dims relation

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

4854: m_relation_id := insertCubeDimsRecord(m_cube_dims_en);
4855:
4856: l_dim_ecm := zpb_ecm.get_dimension_ecm(l_dim, p_sharedAw);
4857:
4858: if (zpb_aw.interp('shw obj(dimmax '''||l_aw||l_dim_ecm.HierDim||
4859: ''')') <> '0') then
4860: zpb_aw.execute ('lmt '||l_aw||l_dim_Ecm.HierDim||' to all');
4861: l_hiers := zpb_aw.interp ('shw CM.GETDIMVALUES('''||l_aw||
4862: l_dim_Ecm.HierDim||''' yes)');

Line 4860: zpb_aw.execute ('lmt '||l_aw||l_dim_Ecm.HierDim||' to all');

4856: l_dim_ecm := zpb_ecm.get_dimension_ecm(l_dim, p_sharedAw);
4857:
4858: if (zpb_aw.interp('shw obj(dimmax '''||l_aw||l_dim_ecm.HierDim||
4859: ''')') <> '0') then
4860: zpb_aw.execute ('lmt '||l_aw||l_dim_Ecm.HierDim||' to all');
4861: l_hiers := zpb_aw.interp ('shw CM.GETDIMVALUES('''||l_aw||
4862: l_dim_Ecm.HierDim||''' yes)');
4863: hi := 1;
4864: loop

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

4857:
4858: if (zpb_aw.interp('shw obj(dimmax '''||l_aw||l_dim_ecm.HierDim||
4859: ''')') <> '0') then
4860: zpb_aw.execute ('lmt '||l_aw||l_dim_Ecm.HierDim||' to all');
4861: l_hiers := zpb_aw.interp ('shw CM.GETDIMVALUES('''||l_aw||
4862: l_dim_Ecm.HierDim||''' yes)');
4863: hi := 1;
4864: loop
4865: hj := instr (l_hiers, ' ', hi);

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

4993: null;
4994: end;
4995:
4996: l_gid := false;
4997: l_aw := zpb_aw.get_schema||'.'||p_aw||'!';
4998: i := 1;
4999:
5000: -- initialize cube entry
5001: m_cube_en.Name := zpb_metadata_names.get_ownermap_cwm2_cube(p_aw);

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

5041: m_cube_dims_en.ColumnId := insertColumnRecord(m_column_en);
5042:
5043: m_relation_id := insertCubeDimsRecord(m_cube_dims_en);
5044:
5045: if (zpb_aw.interp('shw obj(dimmax '''||l_aw||l_dim_ecm.HierDim||''')')
5046: <> '0') then
5047: zpb_aw.execute ('lmt '||l_aw||l_dim_Ecm.HierDim||' to all');
5048: l_hiers := zpb_aw.interp ('shw CM.GETDIMVALUES('''||l_aw||
5049: l_dim_Ecm.HierDim||''' yes)');

Line 5047: zpb_aw.execute ('lmt '||l_aw||l_dim_Ecm.HierDim||' to all');

5043: m_relation_id := insertCubeDimsRecord(m_cube_dims_en);
5044:
5045: if (zpb_aw.interp('shw obj(dimmax '''||l_aw||l_dim_ecm.HierDim||''')')
5046: <> '0') then
5047: zpb_aw.execute ('lmt '||l_aw||l_dim_Ecm.HierDim||' to all');
5048: l_hiers := zpb_aw.interp ('shw CM.GETDIMVALUES('''||l_aw||
5049: l_dim_Ecm.HierDim||''' yes)');
5050: hi := 1;
5051: loop

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

5044:
5045: if (zpb_aw.interp('shw obj(dimmax '''||l_aw||l_dim_ecm.HierDim||''')')
5046: <> '0') then
5047: zpb_aw.execute ('lmt '||l_aw||l_dim_Ecm.HierDim||' to all');
5048: l_hiers := zpb_aw.interp ('shw CM.GETDIMVALUES('''||l_aw||
5049: l_dim_Ecm.HierDim||''' yes)');
5050: hi := 1;
5051: loop
5052: hj := instr (l_hiers, ' ', hi);

Line 5149: l_instType := zpb_aw.interp ('shw CM.GETINSTOBJECT('''||p_instance||

5145: -- right now, only delete MD for personal measures, as SHARED_VIEW
5146: -- MD is shared between all users
5147: if(instr(p_type, 'PERSONAL') > 0 or instr(p_type, 'APPROVER') > 0) then
5148:
5149: l_instType := zpb_aw.interp ('shw CM.GETINSTOBJECT('''||p_instance||
5150: ''' ''TYPE'')');
5151: if (instr (l_instType, 'CALC') > 0) then
5152: l_instType := p_type||' CALC';
5153: else

Line 5167: l_meas := zpb_aw.interp ('shw CM.GETINSTOBJECT('''||p_instance||''' '''||

5163: if (p_template is not null) then
5164: l_objName := l_objName||''''||p_template||'''';
5165: end if;
5166:
5167: l_meas := zpb_aw.interp ('shw CM.GETINSTOBJECT('''||p_instance||''' '''||
5168: l_instType||' DATA '||l_objName||'''');
5169:
5170: delete from zpb_measures
5171: where measure_id in

Line 5177: l_meas := zpb_aw.interp ('shw CM.GETINSTOBJECT('''||p_instance||''' '''||

5173: where zpb_measures.cube_id = zpb_cubes.cube_id and
5174: zpb_cubes.name like '%'||p_aw||'/_%' escape '/' and
5175: zpb_measures.epb_id= l_meas);
5176:
5177: l_meas := zpb_aw.interp ('shw CM.GETINSTOBJECT('''||p_instance||''' '''||
5178: l_instType||' ANNOTATION '||l_objName||'''');
5179:
5180: delete from zpb_measures
5181: where measure_id in

Line 5187: l_meas := zpb_aw.interp ('shw CM.GETINSTOBJECT('''||p_instance||''' '''||

5183: where zpb_measures.cube_id = zpb_cubes.cube_id and
5184: zpb_cubes.name like '%'||p_aw||'/_%' escape '/' and
5185: zpb_measures.epb_id= l_meas);
5186:
5187: l_meas := zpb_aw.interp ('shw CM.GETINSTOBJECT('''||p_instance||''' '''||
5188: l_instType||' FORMAT '||l_objName||'''');
5189: delete from zpb_measures
5190: where measure_id in
5191: (select measure_id from zpb_measures, zpb_cubes

Line 5197: l_instance := to_number(zpb_aw.interp('shw CM.GETPHYSICALINSTANCE('''||

5193: zpb_cubes.name like '%'||p_aw||'/_%' escape '/' and
5194: zpb_measures.epb_id= l_meas);
5195:
5196: if (p_type = 'PERSONAL') then
5197: l_instance := to_number(zpb_aw.interp('shw CM.GETPHYSICALINSTANCE('''||
5198: p_instance||''')'));
5199: select count(*)
5200: into l_count
5201: from ZPB_MEASURES

Line 5216: l_meas := zpb_aw.interp ('shw CM.GETINSTOBJECT('''||p_instance||''' '''||

5212: l_dltWriteSec := true;
5213: end if;
5214:
5215: if (l_dltWriteSec) then
5216: l_meas := zpb_aw.interp ('shw CM.GETINSTOBJECT('''||p_instance||''' '''||
5217: l_instType||' WRITE SECURITY '||l_objName||'''');
5218: delete from zpb_measures
5219: where measure_id in
5220: (select measure_id from zpb_measures, zpb_cubes

Line 5227: l_meas := zpb_aw.interp ('shw CM.GETINSTOBJECT('''||p_instance||''' '''||

5223: zpb_measures.epb_id= l_meas);
5224: end if;
5225:
5226: if (p_type = 'PERSONAL' or p_type = 'SHARED') then
5227: l_meas := zpb_aw.interp ('shw CM.GETINSTOBJECT('''||p_instance||''' '''||
5228: l_instType||' TARGET '||l_objName||'''');
5229: delete from zpb_measures
5230: where measure_id in
5231: (select measure_id from zpb_measures, zpb_cubes

Line 5236: l_meas := zpb_aw.interp ('shw CM.GETINSTOBJECT('''||p_instance||''' '''||

5232: where zpb_measures.cube_id = zpb_cubes.cube_id and
5233: zpb_cubes.name like '%'||p_aw||'/_%' escape '/' and
5234: zpb_measures.epb_id= l_meas);
5235:
5236: l_meas := zpb_aw.interp ('shw CM.GETINSTOBJECT('''||p_instance||''' '''||
5237: l_instType||' TARGET TYPE '||l_objName||'''');
5238: delete from zpb_measures
5239: where measure_id in
5240: (select measure_id from zpb_measures, zpb_cubes

Line 5246: l_meas := zpb_aw.interp ('shw CM.GETINSTOBJECT('''||p_instance||''' '''||

5242: zpb_cubes.name like '%'||p_aw||'/_%' escape '/' and
5243: zpb_measures.epb_id= l_meas);
5244:
5245: if (l_dltWriteSec) then
5246: l_meas := zpb_aw.interp ('shw CM.GETINSTOBJECT('''||p_instance||''' '''||
5247: l_instType||' INPUT LEVEL OBJECT ID''');
5248: delete from zpb_measures
5249: where measure_id in
5250: (select measure_id from zpb_measures, zpb_cubes

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

5465: dims.dimension_id = attr.range_dim_id and
5466: dims.dimension_id = attr2.dimension_id;
5467:
5468: begin
5469: l_aw := zpb_aw.get_schema||'.'||p_aw||'!';
5470: l_global_ecm := zpb_ecm.get_global_ecm (p_aw);
5471: l_global_attr_ecm := zpb_ecm.get_global_attr_ecm(p_aw);
5472:
5473: -- save start time. At the end we will remove all scoping entries that were

Line 5481: zpb_aw.execute('push oknullstatus');

5477: l_user_id := to_number(sys_context('ZPB_CONTEXT', 'shadow_id'));
5478:
5479: bus_area_id_num := sys_context('ZPB_CONTEXT', 'business_area_id');
5480:
5481: zpb_aw.execute('push oknullstatus');
5482: zpb_aw.execute('oknullstatus = yes');
5483:
5484: -- Loop over all dimensions
5485: i := 1;

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

5478:
5479: bus_area_id_num := sys_context('ZPB_CONTEXT', 'business_area_id');
5480:
5481: zpb_aw.execute('push oknullstatus');
5482: zpb_aw.execute('oknullstatus = yes');
5483:
5484: -- Loop over all dimensions
5485: i := 1;
5486: loop

Line 5528: zpb_aw.execute('push '||l_aw||l_dim_data.ExpObj);

5524: select count(hierarchy_id) into l_nullHierCnt
5525: from zpb_hierarchies
5526: where dimension_id=l_dimension_id and hier_type='NULL';
5527:
5528: zpb_aw.execute('push '||l_aw||l_dim_data.ExpObj);
5529:
5530: if (zpb_aw.interp('shw obj(dimmax '''||l_aw||l_dim_ecm.HierDim||
5531: ''')') <> '0') then
5532: hi := 1;

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

5526: where dimension_id=l_dimension_id and hier_type='NULL';
5527:
5528: zpb_aw.execute('push '||l_aw||l_dim_data.ExpObj);
5529:
5530: if (zpb_aw.interp('shw obj(dimmax '''||l_aw||l_dim_ecm.HierDim||
5531: ''')') <> '0') then
5532: hi := 1;
5533: l_hiers :=zpb_aw.interp
5534: ('shw CM.GETDIMVALUES('''||l_aw||l_dim_ecm.HierDim||''')');

Line 5533: l_hiers :=zpb_aw.interp

5529:
5530: if (zpb_aw.interp('shw obj(dimmax '''||l_aw||l_dim_ecm.HierDim||
5531: ''')') <> '0') then
5532: hi := 1;
5533: l_hiers :=zpb_aw.interp
5534: ('shw CM.GETDIMVALUES('''||l_aw||l_dim_ecm.HierDim||''')');
5535:
5536: zpb_aw.execute ('push '||l_aw||l_dim_ecm.LevelDim);
5537: zpb_aw.execute ('push '||l_aw||l_dim_ecm.HierDim);

Line 5536: zpb_aw.execute ('push '||l_aw||l_dim_ecm.LevelDim);

5532: hi := 1;
5533: l_hiers :=zpb_aw.interp
5534: ('shw CM.GETDIMVALUES('''||l_aw||l_dim_ecm.HierDim||''')');
5535:
5536: zpb_aw.execute ('push '||l_aw||l_dim_ecm.LevelDim);
5537: zpb_aw.execute ('push '||l_aw||l_dim_ecm.HierDim);
5538: loop -- LOOP OVER ALL HIERARCHIES
5539: hj := instr (l_hiers, ' ', hi);
5540: if (hj = 0) then

Line 5537: zpb_aw.execute ('push '||l_aw||l_dim_ecm.HierDim);

5533: l_hiers :=zpb_aw.interp
5534: ('shw CM.GETDIMVALUES('''||l_aw||l_dim_ecm.HierDim||''')');
5535:
5536: zpb_aw.execute ('push '||l_aw||l_dim_ecm.LevelDim);
5537: zpb_aw.execute ('push '||l_aw||l_dim_ecm.HierDim);
5538: loop -- LOOP OVER ALL HIERARCHIES
5539: hj := instr (l_hiers, ' ', hi);
5540: if (hj = 0) then
5541: l_hier := substr (l_hiers, hi);

Line 5549: zpb_aw.execute('lmt '||l_aw||l_dim_ecm.HierDim||' to '''||

5545: end if;
5546:
5547: l_persLvl:=false;
5548:
5549: zpb_aw.execute('lmt '||l_aw||l_dim_ecm.HierDim||' to '''||
5550: l_hier||'''');
5551: -- dbms_output.put_line('looking at hierarchy ' || l_hier);
5552:
5553: zpb_aw.execute('lmt '||l_aw||l_dim_data.ExpObj||' to '||l_aw||

Line 5553: zpb_aw.execute('lmt '||l_aw||l_dim_data.ExpObj||' to '||l_aw||

5549: zpb_aw.execute('lmt '||l_aw||l_dim_ecm.HierDim||' to '''||
5550: l_hier||'''');
5551: -- dbms_output.put_line('looking at hierarchy ' || l_hier);
5552:
5553: zpb_aw.execute('lmt '||l_aw||l_dim_data.ExpObj||' to '||l_aw||
5554: l_dim_ecm.HOrderVS);
5555: if (zpb_aw.interp('shw convert(statlen('||l_aw||l_dim_data.ExpObj||
5556: ') text 0 no no)') <> 0) then
5557:

Line 5555: if (zpb_aw.interp('shw convert(statlen('||l_aw||l_dim_data.ExpObj||

5551: -- dbms_output.put_line('looking at hierarchy ' || l_hier);
5552:
5553: zpb_aw.execute('lmt '||l_aw||l_dim_data.ExpObj||' to '||l_aw||
5554: l_dim_ecm.HOrderVS);
5555: if (zpb_aw.interp('shw convert(statlen('||l_aw||l_dim_data.ExpObj||
5556: ') text 0 no no)') <> 0) then
5557:
5558: l_accessToAHier:=true;
5559:

Line 5572: zpb_aw.execute('lmt '||l_aw||l_dim_ecm.LevelDim||

5568: pers_cwm_name = l_hier_perscwm;
5569:
5570: l_dummy_num := insertHierScopeRecord(l_hier_scope_en);
5571:
5572: zpb_aw.execute('lmt '||l_aw||l_dim_ecm.LevelDim||
5573: ' to &joinchars ('''||l_aw||''' obj(property '''
5574: ||'HIERLEVELVS'' '''||l_dim_ecm.HierDim||'''))');
5575: zpb_aw.execute('sort '||l_aw||l_dim_ecm.levelDim||
5576: ' a &joinchars ('''||l_aw||''' obj(property '''

Line 5575: zpb_aw.execute('sort '||l_aw||l_dim_ecm.levelDim||

5571:
5572: zpb_aw.execute('lmt '||l_aw||l_dim_ecm.LevelDim||
5573: ' to &joinchars ('''||l_aw||''' obj(property '''
5574: ||'HIERLEVELVS'' '''||l_dim_ecm.HierDim||'''))');
5575: zpb_aw.execute('sort '||l_aw||l_dim_ecm.levelDim||
5576: ' a &joinchars ('''||l_aw||''' obj(property '''
5577: ||'LEVELDEPTHVAR'' '''||l_dim_ecm.HierDim||'''))');
5578:
5579: --

Line 5583: l_levels := zpb_aw.interp('shw CM.GETDIMVALUES('''||l_aw||

5579: --
5580: -- Get the Levels:
5581: --
5582: li := 1;
5583: l_levels := zpb_aw.interp('shw CM.GETDIMVALUES('''||l_aw||
5584: l_dim_ecm.LevelDim||''', YES)');
5585:
5586: loop -- Loop over all levels for hierarchy
5587: lj := instr (l_levels, ' ', li);

Line 5595: zpb_aw.execute('lmt '||l_aw||l_dim_ecm.LevelDim||' to '''||

5591: l_level := substr (l_levels, li, lj-li);
5592: li := lj+1;
5593: end if;
5594:
5595: zpb_aw.execute('lmt '||l_aw||l_dim_ecm.LevelDim||' to '''||
5596: l_level||'''');
5597:
5598: -- dbms_output.put_line('Looking at level: ' || l_level);
5599:

Line 5603: zpb_aw.execute('lmt '||l_aw||l_dim_data.ExpObj||' to '||

5599:
5600: --
5601: -- Check to see if any members are at this level:
5602: --
5603: zpb_aw.execute('lmt '||l_aw||l_dim_data.ExpObj||' to '||
5604: l_aw||l_dim_ecm.HOrderVS);
5605:
5606: zpb_aw.execute ('lmt '||l_aw||l_dim_data.ExpObj||' keep '||
5607: l_aw||l_dim_ecm.LevelRel);

Line 5606: zpb_aw.execute ('lmt '||l_aw||l_dim_data.ExpObj||' keep '||

5602: --
5603: zpb_aw.execute('lmt '||l_aw||l_dim_data.ExpObj||' to '||
5604: l_aw||l_dim_ecm.HOrderVS);
5605:
5606: zpb_aw.execute ('lmt '||l_aw||l_dim_data.ExpObj||' keep '||
5607: l_aw||l_dim_ecm.LevelRel);
5608: l_length := to_number(zpb_aw.interp('shw convert(statlen ('||
5609: l_aw||l_dim_data.ExpObj||') text 0 no no)'));
5610: if (l_length > 0) then

Line 5608: l_length := to_number(zpb_aw.interp('shw convert(statlen ('||

5604: l_aw||l_dim_ecm.HOrderVS);
5605:
5606: zpb_aw.execute ('lmt '||l_aw||l_dim_data.ExpObj||' keep '||
5607: l_aw||l_dim_ecm.LevelRel);
5608: l_length := to_number(zpb_aw.interp('shw convert(statlen ('||
5609: l_aw||l_dim_data.ExpObj||') text 0 no no)'));
5610: if (l_length > 0) then
5611:
5612: -- dbms_output.put_line('Level has members');

Line 5634: if zpb_aw.interpbool('shw '|| l_aw||l_dim_ecm.LevelPersVar) then

5630: l_hl_scope_en.PersColId := insertColumnRecord(l_pers_column_en);
5631:
5632: -- dbms_output.put_line('About to check personal');
5633: -- Personal Level Check
5634: if zpb_aw.interpbool('shw '|| l_aw||l_dim_ecm.LevelPersVar) then
5635: -- dbms_output.put_line('Pers Level');
5636: -- personal level, need to create MD for the level itself and for the personal personal hierarchy table
5637: l_persLvl :=true;
5638:

Line 5683: zpb_aw.execute ('pop '||l_aw||l_dim_ecm.LevelDim);

5679:
5680: exit when hj = 0;
5681: end loop; -- End looping over Hierarchies
5682:
5683: zpb_aw.execute ('pop '||l_aw||l_dim_ecm.LevelDim);
5684: zpb_aw.execute ('pop '||l_aw||l_dim_ecm.HierDim);
5685:
5686: end if;
5687:

Line 5684: zpb_aw.execute ('pop '||l_aw||l_dim_ecm.HierDim);

5680: exit when hj = 0;
5681: end loop; -- End looping over Hierarchies
5682:
5683: zpb_aw.execute ('pop '||l_aw||l_dim_ecm.LevelDim);
5684: zpb_aw.execute ('pop '||l_aw||l_dim_ecm.HierDim);
5685:
5686: end if;
5687:
5688: -- create scope entry for null hierarchy when one exists

Line 5690: zpb_aw.execute('lmt '||l_aw||l_dim_data.ExpObj||' to all');

5686: end if;
5687:
5688: -- create scope entry for null hierarchy when one exists
5689: if l_nullHierCnt=1 then
5690: zpb_aw.execute('lmt '||l_aw||l_dim_data.ExpObj||' to all');
5691: if (zpb_aw.interp('shw convert(statlen('||l_aw||l_dim_data.ExpObj||
5692: ') text 0 no no)') <> 0) then
5693:
5694: select hierarchy_id, pers_table_id

Line 5691: if (zpb_aw.interp('shw convert(statlen('||l_aw||l_dim_data.ExpObj||

5687:
5688: -- create scope entry for null hierarchy when one exists
5689: if l_nullHierCnt=1 then
5690: zpb_aw.execute('lmt '||l_aw||l_dim_data.ExpObj||' to all');
5691: if (zpb_aw.interp('shw convert(statlen('||l_aw||l_dim_data.ExpObj||
5692: ') text 0 no no)') <> 0) then
5693:
5694: select hierarchy_id, pers_table_id
5695: into l_hier_scope_en.HierarchyId, l_hier_scope_en.PersTableId

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

5744: l_dummy_num := insertHierlevelScopeRecord(l_hl_scope_en);
5745: end loop;
5746:
5747: -- DIMENSION ATTRIBUTES
5748: zpb_aw.execute('lmt '||l_aw||l_global_ecm.AttrDim||' to '||l_aw||
5749: l_global_attr_ecm.DomainDimRel||' eq lmt ('||l_aw||
5750: l_global_ecm.DimDim||' to '''||l_dim||''')');
5751:
5752: l_attrs := zpb_aw.interp ('shw CM.GETDIMVALUES('''||l_aw||

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

5748: zpb_aw.execute('lmt '||l_aw||l_global_ecm.AttrDim||' to '||l_aw||
5749: l_global_attr_ecm.DomainDimRel||' eq lmt ('||l_aw||
5750: l_global_ecm.DimDim||' to '''||l_dim||''')');
5751:
5752: l_attrs := zpb_aw.interp ('shw CM.GETDIMVALUES('''||l_aw||
5753: l_global_ecm.AttrDim||''' YES)');
5754:
5755: if (l_attrs <> 'NA') then
5756: ai := 1;

Line 5766: zpb_aw.execute ('lmt '||l_aw||l_global_ecm.AttrDim||' to '''|| l_attr||'''');

5762: l_attr := substr (l_attrs, ai, aj-ai);
5763: ai := aj+1;
5764: end if;
5765:
5766: zpb_aw.execute ('lmt '||l_aw||l_global_ecm.AttrDim||' to '''|| l_attr||'''');
5767: -- explicitly exclude timespan and non displayed attrs
5768: if (instr (l_attr, 'TIMESPAN') = 0 and (zpb_aw.interpbool('shw exists(''' || l_aw || l_global_attr_ecm.AttrDisplayVar || ''')')
5769: and zpb_aw.interpbool('shw '||l_aw|| l_global_attr_ecm.AttrDisplayVar))) then
5770:

Line 5768: if (instr (l_attr, 'TIMESPAN') = 0 and (zpb_aw.interpbool('shw exists(''' || l_aw || l_global_attr_ecm.AttrDisplayVar || ''')')

5764: end if;
5765:
5766: zpb_aw.execute ('lmt '||l_aw||l_global_ecm.AttrDim||' to '''|| l_attr||'''');
5767: -- explicitly exclude timespan and non displayed attrs
5768: if (instr (l_attr, 'TIMESPAN') = 0 and (zpb_aw.interpbool('shw exists(''' || l_aw || l_global_attr_ecm.AttrDisplayVar || ''')')
5769: and zpb_aw.interpbool('shw '||l_aw|| l_global_attr_ecm.AttrDisplayVar))) then
5770:
5771: l_attr_perscwm := zpb_metadata_names.get_attribute_cwm2_name('PRS',l_dim,l_attr);
5772:

Line 5769: and zpb_aw.interpbool('shw '||l_aw|| l_global_attr_ecm.AttrDisplayVar))) then

5765:
5766: zpb_aw.execute ('lmt '||l_aw||l_global_ecm.AttrDim||' to '''|| l_attr||'''');
5767: -- explicitly exclude timespan and non displayed attrs
5768: if (instr (l_attr, 'TIMESPAN') = 0 and (zpb_aw.interpbool('shw exists(''' || l_aw || l_global_attr_ecm.AttrDisplayVar || ''')')
5769: and zpb_aw.interpbool('shw '||l_aw|| l_global_attr_ecm.AttrDisplayVar))) then
5770:
5771: l_attr_perscwm := zpb_metadata_names.get_attribute_cwm2_name('PRS',l_dim,l_attr);
5772:
5773: select attribute_id into l_attr_scope_en.AttributeId

Line 5838: zpb_aw.execute('pop oknullstatus');

5834:
5835: exit when j=0;
5836: end loop;
5837:
5838: zpb_aw.execute('pop oknullstatus');
5839:
5840: EXCEPTION
5841: WHEN OTHERS THEN
5842: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));