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

Line 20: zpb_aw_status.get_status(p_dataAw,p_first_query);

16: l_equal integer;
17: begin
18: l_dataAwQual := p_dataAw ||'!';
19: -- call the first query
20: zpb_aw_status.get_status(p_dataAw,p_first_query);
21: -- get the valuseset name
22: l_vs := '&' || 'obj(prp ''LASTQUERYVS'' '||''''||l_dataAwQual||p_line_dim ||''')';
23: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,'valueset name:' ||l_vs);
24: -- initialize

Line 25: zpb_aw.execute('push oknullstatus '||l_dataAwQual ||p_line_dim);

21: -- get the valuseset name
22: l_vs := '&' || 'obj(prp ''LASTQUERYVS'' '||''''||l_dataAwQual||p_line_dim ||''')';
23: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,'valueset name:' ||l_vs);
24: -- initialize
25: zpb_aw.execute('push oknullstatus '||l_dataAwQual ||p_line_dim);
26: zpb_aw.execute('oknullstatus=y');
27: if (not zpb_aw.interpbool('shw exists(''l_temp_vs'')')) then
28: zpb_aw.execute(' dfn l_temp_vs valueset '||l_dataAwQual ||p_line_dim|| ' aw ' ||p_dataAw);
29: end if;

Line 26: zpb_aw.execute('oknullstatus=y');

22: l_vs := '&' || 'obj(prp ''LASTQUERYVS'' '||''''||l_dataAwQual||p_line_dim ||''')';
23: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,'valueset name:' ||l_vs);
24: -- initialize
25: zpb_aw.execute('push oknullstatus '||l_dataAwQual ||p_line_dim);
26: zpb_aw.execute('oknullstatus=y');
27: if (not zpb_aw.interpbool('shw exists(''l_temp_vs'')')) then
28: zpb_aw.execute(' dfn l_temp_vs valueset '||l_dataAwQual ||p_line_dim|| ' aw ' ||p_dataAw);
29: end if;
30:

Line 27: if (not zpb_aw.interpbool('shw exists(''l_temp_vs'')')) then

23: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,'valueset name:' ||l_vs);
24: -- initialize
25: zpb_aw.execute('push oknullstatus '||l_dataAwQual ||p_line_dim);
26: zpb_aw.execute('oknullstatus=y');
27: if (not zpb_aw.interpbool('shw exists(''l_temp_vs'')')) then
28: zpb_aw.execute(' dfn l_temp_vs valueset '||l_dataAwQual ||p_line_dim|| ' aw ' ||p_dataAw);
29: end if;
30:
31: -- lmt the first valueset to the first query

Line 28: zpb_aw.execute(' dfn l_temp_vs valueset '||l_dataAwQual ||p_line_dim|| ' aw ' ||p_dataAw);

24: -- initialize
25: zpb_aw.execute('push oknullstatus '||l_dataAwQual ||p_line_dim);
26: zpb_aw.execute('oknullstatus=y');
27: if (not zpb_aw.interpbool('shw exists(''l_temp_vs'')')) then
28: zpb_aw.execute(' dfn l_temp_vs valueset '||l_dataAwQual ||p_line_dim|| ' aw ' ||p_dataAw);
29: end if;
30:
31: -- lmt the first valueset to the first query
32: zpb_aw.execute('lmt '|| l_dataAwQual ||'l_temp_vs to '|| l_vs );

Line 32: zpb_aw.execute('lmt '|| l_dataAwQual ||'l_temp_vs to '|| l_vs );

28: zpb_aw.execute(' dfn l_temp_vs valueset '||l_dataAwQual ||p_line_dim|| ' aw ' ||p_dataAw);
29: end if;
30:
31: -- lmt the first valueset to the first query
32: zpb_aw.execute('lmt '|| l_dataAwQual ||'l_temp_vs to '|| l_vs );
33:
34: -- generate the valuseset for the second query
35: zpb_aw_status.get_status(p_dataAw,p_second_query);
36: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr w 40 values('||l_dataAwQual ||'l_temp_vs)'),1,254));

Line 35: zpb_aw_status.get_status(p_dataAw,p_second_query);

31: -- lmt the first valueset to the first query
32: zpb_aw.execute('lmt '|| l_dataAwQual ||'l_temp_vs to '|| l_vs );
33:
34: -- generate the valuseset for the second query
35: zpb_aw_status.get_status(p_dataAw,p_second_query);
36: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr w 40 values('||l_dataAwQual ||'l_temp_vs)'),1,254));
37: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr w 40 values('||l_vs||')'),1,254));
38:
39: -- check if the two valusesets are identical

Line 36: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr w 40 values('||l_dataAwQual ||'l_temp_vs)'),1,254));

32: zpb_aw.execute('lmt '|| l_dataAwQual ||'l_temp_vs to '|| l_vs );
33:
34: -- generate the valuseset for the second query
35: zpb_aw_status.get_status(p_dataAw,p_second_query);
36: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr w 40 values('||l_dataAwQual ||'l_temp_vs)'),1,254));
37: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr w 40 values('||l_vs||')'),1,254));
38:
39: -- check if the two valusesets are identical
40: l_first_superset := zpb_aw.interpbool('shw inlist(values('||l_dataAwQual||'l_temp_vs)'|| ' values('||l_vs||'))');

Line 37: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr w 40 values('||l_vs||')'),1,254));

33:
34: -- generate the valuseset for the second query
35: zpb_aw_status.get_status(p_dataAw,p_second_query);
36: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr w 40 values('||l_dataAwQual ||'l_temp_vs)'),1,254));
37: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr w 40 values('||l_vs||')'),1,254));
38:
39: -- check if the two valusesets are identical
40: l_first_superset := zpb_aw.interpbool('shw inlist(values('||l_dataAwQual||'l_temp_vs)'|| ' values('||l_vs||'))');
41: l_second_superset := zpb_aw.interpbool('shw inlist(values('||l_dataAwQual||l_vs||')'|| ' values(l_temp_vs))');

Line 40: l_first_superset := zpb_aw.interpbool('shw inlist(values('||l_dataAwQual||'l_temp_vs)'|| ' values('||l_vs||'))');

36: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr w 40 values('||l_dataAwQual ||'l_temp_vs)'),1,254));
37: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr w 40 values('||l_vs||')'),1,254));
38:
39: -- check if the two valusesets are identical
40: l_first_superset := zpb_aw.interpbool('shw inlist(values('||l_dataAwQual||'l_temp_vs)'|| ' values('||l_vs||'))');
41: l_second_superset := zpb_aw.interpbool('shw inlist(values('||l_dataAwQual||l_vs||')'|| ' values(l_temp_vs))');
42:
43: if l_first_superset then
44: if l_second_superset then

Line 41: l_second_superset := zpb_aw.interpbool('shw inlist(values('||l_dataAwQual||l_vs||')'|| ' values(l_temp_vs))');

37: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr w 40 values('||l_vs||')'),1,254));
38:
39: -- check if the two valusesets are identical
40: l_first_superset := zpb_aw.interpbool('shw inlist(values('||l_dataAwQual||'l_temp_vs)'|| ' values('||l_vs||'))');
41: l_second_superset := zpb_aw.interpbool('shw inlist(values('||l_dataAwQual||l_vs||')'|| ' values(l_temp_vs))');
42:
43: if l_first_superset then
44: if l_second_superset then
45: l_equal := 0;

Line 77: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw;

73: l_temp_vs varchar2(100);
74: l_line_dim zpb_cycle_model_dimensions.dimension_name%type;
75:
76: begin
77: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw;
78: l_dataAwQual := l_dataAw ||'!';
79: zpb_aw.execute('aw attach '|| l_dataAw || ' first ');
80: zpb_aw.execute('aw attach '|| zpb_aw.get_schema||'.'||zpb_aw.get_code_aw(fnd_global.user_id) || ' ro');
81:

Line 79: zpb_aw.execute('aw attach '|| l_dataAw || ' first ');

75:
76: begin
77: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw;
78: l_dataAwQual := l_dataAw ||'!';
79: zpb_aw.execute('aw attach '|| l_dataAw || ' first ');
80: zpb_aw.execute('aw attach '|| zpb_aw.get_schema||'.'||zpb_aw.get_code_aw(fnd_global.user_id) || ' ro');
81:
82: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,'Dimension:' ||l_dataAwQual|| p_dim_name);
83:

Line 80: zpb_aw.execute('aw attach '|| zpb_aw.get_schema||'.'||zpb_aw.get_code_aw(fnd_global.user_id) || ' ro');

76: begin
77: l_dataAw := zpb_aw.get_schema||'.'||zpb_aw.get_shared_aw;
78: l_dataAwQual := l_dataAw ||'!';
79: zpb_aw.execute('aw attach '|| l_dataAw || ' first ');
80: zpb_aw.execute('aw attach '|| zpb_aw.get_schema||'.'||zpb_aw.get_code_aw(fnd_global.user_id) || ' ro');
81:
82: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,'Dimension:' ||l_dataAwQual|| p_dim_name);
83:
84: x_equal := compare_queries(l_dataAw,p_first_query,p_second_query,p_dim_name);

Line 86: zpb_aw.execute('delete l_temp_vs aw ' ||l_dataAw);

82: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,'Dimension:' ||l_dataAwQual|| p_dim_name);
83:
84: x_equal := compare_queries(l_dataAw,p_first_query,p_second_query,p_dim_name);
85: -- cleanup and return
86: zpb_aw.execute('delete l_temp_vs aw ' ||l_dataAw);
87: zpb_aw.execute('pop oknullstatus '||l_dataAwQual ||p_dim_name);
88: zpb_aw.execute('aw detach '|| l_dataAw );
89: zpb_aw.execute('aw detach '|| zpb_aw.get_schema||'.'||zpb_aw.get_code_aw(fnd_global.user_id) );
90:

Line 87: zpb_aw.execute('pop oknullstatus '||l_dataAwQual ||p_dim_name);

83:
84: x_equal := compare_queries(l_dataAw,p_first_query,p_second_query,p_dim_name);
85: -- cleanup and return
86: zpb_aw.execute('delete l_temp_vs aw ' ||l_dataAw);
87: zpb_aw.execute('pop oknullstatus '||l_dataAwQual ||p_dim_name);
88: zpb_aw.execute('aw detach '|| l_dataAw );
89: zpb_aw.execute('aw detach '|| zpb_aw.get_schema||'.'||zpb_aw.get_code_aw(fnd_global.user_id) );
90:
91: exception

Line 88: zpb_aw.execute('aw detach '|| l_dataAw );

84: x_equal := compare_queries(l_dataAw,p_first_query,p_second_query,p_dim_name);
85: -- cleanup and return
86: zpb_aw.execute('delete l_temp_vs aw ' ||l_dataAw);
87: zpb_aw.execute('pop oknullstatus '||l_dataAwQual ||p_dim_name);
88: zpb_aw.execute('aw detach '|| l_dataAw );
89: zpb_aw.execute('aw detach '|| zpb_aw.get_schema||'.'||zpb_aw.get_code_aw(fnd_global.user_id) );
90:
91: exception
92: when others then

Line 89: zpb_aw.execute('aw detach '|| zpb_aw.get_schema||'.'||zpb_aw.get_code_aw(fnd_global.user_id) );

85: -- cleanup and return
86: zpb_aw.execute('delete l_temp_vs aw ' ||l_dataAw);
87: zpb_aw.execute('pop oknullstatus '||l_dataAwQual ||p_dim_name);
88: zpb_aw.execute('aw detach '|| l_dataAw );
89: zpb_aw.execute('aw detach '|| zpb_aw.get_schema||'.'||zpb_aw.get_code_aw(fnd_global.user_id) );
90:
91: exception
92: when others then
93: x_equal := 0;

Line 277: ZPB_AW.execute('push SV.LN.DIM');

273: opRec zpb_solve_member_defs%ROWTYPE;
274: i number;
275: indx number;
276: begin
277: ZPB_AW.execute('push SV.LN.DIM');
278:
279: for opRec in records_cur loop
280: ZPB_AW.EXECUTE('lmt SV.LN.DIM to '''||opRec.Member||'''');
281: l_modelEquationRes := opRec.model_equation ;

Line 280: ZPB_AW.EXECUTE('lmt SV.LN.DIM to '''||opRec.Member||'''');

276: begin
277: ZPB_AW.execute('push SV.LN.DIM');
278:
279: for opRec in records_cur loop
280: ZPB_AW.EXECUTE('lmt SV.LN.DIM to '''||opRec.Member||'''');
281: l_modelEquationRes := opRec.model_equation ;
282: l_calcParamRes := opRec.CALC_PARAMETERS;
283:
284: if (ZPB_AW.INTERPBOOL('shw SV.DEF.VAR(SV.DEF.PROP.DIM ''EQUATION'') eq NA')) then

Line 284: if (ZPB_AW.INTERPBOOL('shw SV.DEF.VAR(SV.DEF.PROP.DIM ''EQUATION'') eq NA')) then

280: ZPB_AW.EXECUTE('lmt SV.LN.DIM to '''||opRec.Member||'''');
281: l_modelEquationRes := opRec.model_equation ;
282: l_calcParamRes := opRec.CALC_PARAMETERS;
283:
284: if (ZPB_AW.INTERPBOOL('shw SV.DEF.VAR(SV.DEF.PROP.DIM ''EQUATION'') eq NA')) then
285: dbms_lob.CREATETEMPORARY(l_modelEquation, true);
286: --iterating through each clob to replace ' with \'
287:
288: offset := dbms_lob.instr(l_modelEquationres, '\');

Line 324: if (ZPB_AW.INTERPBOOL('shw SV.DEF.VAR(SV.DEF.PROP.DIM ''CALC_PARAMS'') eq NA')) then

320: end loop;
321: l_modelEquation := l_modelEquation || ')';
322: l_modelEquationres := DBMS_AW.INTERPCLOB(l_modelEquation);
323: end if;
324: if (ZPB_AW.INTERPBOOL('shw SV.DEF.VAR(SV.DEF.PROP.DIM ''CALC_PARAMS'') eq NA')) then
325: -- for calc_parameters column
326: dbms_lob.CREATETEMPORARY(l_calcParam, true);
327:
328: offset := dbms_lob.instr(l_calcParamRes, '\');

Line 375: zpb_aw.execute('pop SV.LN.DIM ');

371: l_calcParam := l_calcParam || ')';
372: l_calcParamres := DBMS_AW.INTERPCLOB(l_calcParam);
373: end if;
374: end loop;
375: zpb_aw.execute('pop SV.LN.DIM ');
376: end populate_SVDEFVAR ;
377:
378: -- This procedure modified the olap page pool size session parameter
379: -- setting_id corresponds to ZPB profile parameters. If the corresponding profile