DBA Data[Home] [Help]

APPS.QP_PREQ_GRP dependencies on DBMS_UTILITY

Line 41250: l_pricing_start_time := dbms_utility.get_time;

41246: IF (G_PUBLIC_API_CALL_FLAG = G_NO) THEN
41247: Set_QP_Debug;
41248: END IF;
41249:
41250: l_pricing_start_time := dbms_utility.get_time;
41251:
41252: IF G_QP_DEBUG_PROFILE_VALUE = G_ENGINE_TIME_TRACE_ON THEN --3085171
41253: --added to note redo generation
41254: begin

Line 42901: l_begin_time := dbms_utility.get_time;

42897: ELSE --Java Engine installed
42898: -----------------START: Specific to Java Engine------------------------
42899: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
42900: engine_debug('Before calling QP_JAVA_ENGINE.request_price..');
42901: l_begin_time := dbms_utility.get_time;
42902: END IF;
42903:
42904: l_request_id := QP_Price_Request_Context.GET_REQUEST_ID;
42905: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN

Line 42920: l_end_time := dbms_utility.get_time;

42916: --l_status_text:= 'QP_JAVA_ENGINE.request_price:'||l_status_text;
42917: RAISE E_ROUTINE_ERRORS;
42918: END IF;
42919: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
42920: l_end_time := dbms_utility.get_time;
42921: engine_debug('Elapsed time for calling QP_JAVA_ENGINE: '||(l_end_time - l_begin_time)/100);
42922: END IF;
42923: --------------END: Specific to Java Engine------------------
42924: END IF; -- DONE PL/SQL and JAVA ENGINE CALL SWITCH by yangli

Line 42953: --l_pricing_end_time := dbms_utility.get_time;

42949: --===========END: Populate_Output() needed by both Java Engine and PL/SQL engine=======
42950:
42951: --l_pricing_end_time := sysdate;
42952:
42953: --l_pricing_end_time := dbms_utility.get_time;
42954:
42955:
42956: --l_time_difference := (l_pricing_end_time - l_pricing_start_time)/100 ;
42957:

Line 42978: g_total_time := g_total_time + (dbms_utility.get_time - l_pricing_start_time)/100;

42974: --hw
42975: -- change session time and session redo
42976: g_start_time := g_total_time;
42977: g_start_redo := g_total_redo;
42978: g_total_time := g_total_time + (dbms_utility.get_time - l_pricing_start_time)/100;
42979: g_total_redo := g_total_redo + (l_pricing_end_redo - l_pricing_start_redo);
42980:
42981: --Changes for bug2961617
42982: /*