DBA Data[Home] [Help]

APPS.QP_PREQ_PUB dependencies on DBMS_UTILITY

Line 13239: l_pricing_start_time := dbms_utility.get_time;

13235: qp_debug_util.setCurrentEvent(p_control_rec.PRICING_EVENT);
13236: --QP_PREQ_GRP.G_CURR_PRICE_EVENT := p_control_rec.PRICING_EVENT;
13237:
13238: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
13239: l_pricing_start_time := dbms_utility.get_time;
13240:
13241: /* 4865787: error out if there are no lines to be priced */
13242: IF nvl(p_control_rec.temp_table_insert_flag, G_YES) = G_NO
13243: THEN

Line 13272: -- l_pricing_start_time := dbms_utility.get_time;

13268: ----------------------------------------------------
13269: --setting time
13270: ----------------------------------------------------
13271: IF G_QP_DEBUG = G_ENGINE_TIME_TRACE_ON THEN --3085171
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

Line 14426: l_pricing_end_time := dbms_utility.get_time;

14422:
14423: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
14424: X_RETURN_STATUS_TEXT := l_routine ||' SUCCESS';
14425:
14426: l_pricing_end_time := dbms_utility.get_time;
14427:
14428: IF G_QP_DEBUG = G_ENGINE_TIME_TRACE_ON THEN --3085171
14429: --added to note redo log
14430: BEGIN