DBA Data[Home] [Help]

APPS.QP_PREQ_PUB dependencies on V$MYSTAT

Line 13276: FROM v$mystat, v$statname

13272: -- l_pricing_start_time := dbms_utility.get_time;
13273: --added to note redo generation
13274: BEGIN
13275: SELECT VALUE INTO l_pricing_start_redo
13276: FROM v$mystat, v$statname
13277: WHERE v$mystat.statistic# = v$statname.statistic#
13278: AND v$statname.name = 'redo size';
13279: EXCEPTION
13280: WHEN OTHERS THEN

Line 13277: WHERE v$mystat.statistic# = v$statname.statistic#

13273: --added to note redo generation
13274: BEGIN
13275: SELECT VALUE INTO l_pricing_start_redo
13276: FROM v$mystat, v$statname
13277: WHERE v$mystat.statistic# = v$statname.statistic#
13278: AND v$statname.name = 'redo size';
13279: EXCEPTION
13280: WHEN OTHERS THEN
13281: IF l_debug = FND_API.G_TRUE THEN

Line 14432: FROM v$mystat, v$statname

14428: IF G_QP_DEBUG = G_ENGINE_TIME_TRACE_ON THEN --3085171
14429: --added to note redo log
14430: BEGIN
14431: SELECT VALUE INTO l_pricing_end_redo
14432: FROM v$mystat, v$statname
14433: WHERE v$mystat.statistic# = v$statname.statistic#
14434: AND v$statname.name = 'redo size';
14435: EXCEPTION
14436: WHEN OTHERS THEN

Line 14433: WHERE v$mystat.statistic# = v$statname.statistic#

14429: --added to note redo log
14430: BEGIN
14431: SELECT VALUE INTO l_pricing_end_redo
14432: FROM v$mystat, v$statname
14433: WHERE v$mystat.statistic# = v$statname.statistic#
14434: AND v$statname.name = 'redo size';
14435: EXCEPTION
14436: WHEN OTHERS THEN
14437: IF l_debug = FND_API.G_TRUE THEN