DBA Data[Home] [Help]

APPS.ZPB_ACVAL_PVT dependencies on ZPB_AW_STATUS

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

537: l_equal integer;
538: begin
539: l_dataAwQual := p_dataAw ||'!';
540: -- call the first query
541: zpb_aw_status.get_status(p_dataAw,p_first_query);
542: -- get the valuseset name
543: l_vs := '&' || 'joinchars('''||l_dataAwQual||''' obj(prp ''LASTQUERYVS'' '||''''
544: ||l_dataAwQual||p_line_dim ||'''))';
545: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,'valueset name:' ||l_vs);

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

555: zpb_aw.execute('lmt '|| l_dataAwQual ||'l_temp_vs to '
556: || l_vs );
557:
558: -- generate the valuseset for the second query
559: zpb_aw_status.get_status(p_dataAw,p_second_query);
560:
561:
562: 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));
563: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr w 40 values('||l_vs||')'),1,254));

Line 740: zpb_aw_status.get_status(l_dataAw,l_query_name);

736: close query_identifier;
737:
738: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,'query is :' ||l_query_name);
739:
740: zpb_aw_status.get_status(l_dataAw,l_query_name);
741:
742: if zpb_aw.interpbool('shw inlist(values(SV.LN.DIM) values('||
743: l_vs||'))') then
744: if zpb_aw.interpbool('shw inlist(values('|| l_vs||') values(SV.LN.DIM))') then

Line 855: zpb_aw_status.get_status(l_dataAw,l_query_name);

851: l_query_name := l_query_path ||'/' || l_query_name;
852: -- l_query_name := 'System Private/Controller/AC11736/MODEL_QUERY_5894';
853:
854: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,'query is :' ||l_query_name);
855: zpb_aw_status.get_status(l_dataAw,l_query_name);
856:
857: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr values('||l_vs||')'),1,254) );
858:
859: zpb_aw.execute(' lmt SV.LN.DIM keep filterlines(values(sv.ln.dim) if inlist(values('||l_vs||') value) then na else value)');

Line 991: zpb_aw_status.get_status(l_dataAw,l_query_name);

987: if l_selection_type <> 'ALL_LINE_ITEMS_SELECTION_TYPE' then
988: l_query_name := l_query_path ||'/' || l_query_name;
989:
990: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,'query is :' ||l_query_name);
991: zpb_aw_status.get_status(l_dataAw,l_query_name);
992:
993: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr values('||l_vs||')'),1,254) );
994: if not zpb_aw.interpbool('shw inlist(values(SV.LN.DIM) values('||
995: l_vs||'))') then

Line 1134: zpb_aw_status.get_status(l_dataAw,l_query_name);

1130: l_query_name := l_query_path ||'/' || l_query_name;
1131: -- l_query_name := 'System Private/Controller/AC11736/MODEL_QUERY_5894';
1132:
1133: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,'query is :' ||l_query_name);
1134: zpb_aw_status.get_status(l_dataAw,l_query_name);
1135:
1136: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr values('||l_vs||')'),1,254) );
1137: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr values(SV.LN.DIM)'),1,254) );
1138: zpb_aw.execute('lmt '|| l_vs || ' keep values(SV.LN.DIM)');

Line 2145: zpb_aw_status.get_status(l_dataAw,l_query_name);

2141: l_query_name := l_query_path ||'/' || l_query_name;
2142: -- l_query_name := 'System Private/Controller/AC11736/MODEL_QUERY_5894';
2143:
2144: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,'query is :' ||l_query_name);
2145: zpb_aw_status.get_status(l_dataAw,l_query_name);
2146:
2147: --zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr values('||l_vs||')'),1,254) );
2148:
2149: zpb_aw.execute(' lmt SV.LN.DIM keep filterlines(values(sv.ln.dim) if inlist(values('||l_vs||') value) then na else value)');