APPS.ZPB_UTIL_PVT dependencies on FND_GLOBAL

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 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 312: l_modelEquation := l_modelEquation || ' - '||fnd_global.newline()||

308: indx := 1;
309: loop
310: i := dbms_lob.instr(l_modelEquationres, ')', indx+3800);
311: if (i > 0) then
312: l_modelEquation := l_modelEquation || ' - '||fnd_global.newline()||
313: ''''||dbms_lob.substr(l_modelEquationres,i-indx+1,indx)||'''';
314: indx := i+1;
315: else
316: l_modelEquation := l_modelEquation || ' - '||fnd_global.newline()||

Line 316: l_modelEquation := l_modelEquation || ' - '||fnd_global.newline()||

312: l_modelEquation := l_modelEquation || ' - '||fnd_global.newline()||
313: ''''||dbms_lob.substr(l_modelEquationres,i-indx+1,indx)||'''';
314: indx := i+1;
315: else
316: l_modelEquation := l_modelEquation || ' - '||fnd_global.newline()||
317: ''''||dbms_lob.substr(l_modelEquationres,4000,indx)||'''';
318: exit;
319: end if;
320: end loop;

Line 344: offset := dbms_lob.instr(l_calcParamres, fnd_global.newline());

340: '\'||dbms_lob.substr(lob_loc => l_calcParamres, offset => offset);
341: offset := dbms_lob.instr(l_calcParamres, '''', offset+2);
342: end loop;
343:
344: offset := dbms_lob.instr(l_calcParamres, fnd_global.newline());
345: while (offset <> 0)
346: loop
347: if (dbms_lob.substr(l_calcParamres, offset-1, 1) <> '-')
348: then

Line 352: offset := dbms_lob.instr(l_calcParamres, fnd_global.newline(), offset+2);

348: then
349: l_calcParamres := dbms_lob.substr(l_calcParamres, offset-1, 1)||
350: '-'||dbms_lob.substr(lob_loc => l_calcParamres, offset => offset);
351: end if;
352: offset := dbms_lob.instr(l_calcParamres, fnd_global.newline(), offset+2);
353: end loop;
354:
355:
356: l_calcParam :=

Line 362: l_calcParam := l_calcParam || ' - '||fnd_global.newline()||

358: indx := 1;
359: loop
360: i := dbms_lob.instr(l_calcParamres, ')', indx+3800);
361: if (i > 0) then
362: l_calcParam := l_calcParam || ' - '||fnd_global.newline()||
363: ''''||dbms_lob.substr(l_calcParamres,i-indx+1,indx)||'''';
364: indx := i+1;
365: else
366: l_calcParam := l_calcParam || ' - '||fnd_global.newline()||

Line 366: l_calcParam := l_calcParam || ' - '||fnd_global.newline()||

362: l_calcParam := l_calcParam || ' - '||fnd_global.newline()||
363: ''''||dbms_lob.substr(l_calcParamres,i-indx+1,indx)||'''';
364: indx := i+1;
365: else
366: l_calcParam := l_calcParam || ' - '||fnd_global.newline()||
367: ''''||dbms_lob.substr(l_calcParamres,4000,indx)||'''';
368: exit;
369: end if;
370: end loop;