DBA Data[Home] [Help]

APPS.ZPB_UTIL_PVT dependencies on ZPB_AW_STATUS

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