APPS.WSH_DEBUG_SV dependencies on DBMS_UTILITY

Line 80: g_TimeStack(v_Position).Time := dbms_utility.get_time;

76: g_TimeStack(v_Position).Marker := x_Marker;
77: g_TimeStack(v_Position).TotalTime := 0;
78: g_TimeStack(v_Position).CallCount := 0;
79: END IF;
80: g_TimeStack(v_Position).Time := dbms_utility.get_time;
81: g_TimeStack(v_Position).CallCount := g_TimeStack(v_Position).CallCount + 1;
82: END IF;
83: EXCEPTION
84: WHEN OTHERS THEN

Line 100: ((( dbms_utility.get_time -

96: IF wsh_debug_interface.g_Debug THEN
97: FOR v_Count IN 1..g_TimeStack.COUNT LOOP
98: IF g_TimeStack(v_Count).Marker = x_Marker THEN
99: g_TimeStack(v_Count).TotalTime := g_TimeStack(v_Count).TotalTime +
100: ((( dbms_utility.get_time -
101: g_TimeStack(v_Count).Time)/100));
102: EXIT;
103: END IF;
104: END LOOP;

Line 121: RETURN(ROUND(((dbms_utility.get_time - g_TimeStack(v_Count).Time)/100),2)||' seconds');

117: BEGIN
118: IF wsh_debug_interface.g_Debug THEN
119: FOR v_Count IN 1..g_TimeStack.COUNT LOOP
120: IF g_TimeStack(v_Count).Marker = x_Marker THEN
121: RETURN(ROUND(((dbms_utility.get_time - g_TimeStack(v_Count).Time)/100),2)||' seconds');
122:
123: END IF;
124: END LOOP;
125: RETURN(NULL);

Line 1254: g_TimeStack(v_Position).Time := dbms_utility.get_time;

1250: g_TimeStack(v_Position).Marker := UPPER(x_Marker);
1251: g_TimeStack(v_Position).TotalTime := 0;
1252: g_TimeStack(v_Position).CallCount := 0;
1253: END IF;
1254: g_TimeStack(v_Position).Time := dbms_utility.get_time;
1255: g_TimeStack(v_Position).CallCount := g_TimeStack(v_Position).CallCount + 1
1256: ;
1257:
1258: END IF;

Line 1286: ((( dbms_utility.get_time -

1282: IF g_DebugAll OR level_defined(x_Level) THEN
1283: FOR v_Count IN 1..g_TimeStack.COUNT LOOP
1284: IF g_TimeStack(v_Count).Marker = UPPER(x_Marker) THEN
1285: g_TimeStack(v_Count).TotalTime := g_TimeStack(v_Count).TotalTime +
1286: ((( dbms_utility.get_time -
1287: g_TimeStack(v_Count).Time)/100));
1288: EXIT;
1289: END IF;
1290: END LOOP;

Line 1362: g_TimeStack(v_Position).Time := dbms_utility.get_time;

1358: g_TimeStack(v_Position).Marker := UPPER(x_Marker);
1359: g_TimeStack(v_Position).TotalTime := 0;
1360: g_TimeStack(v_Position).CallCount := 0;
1361: END IF;
1362: g_TimeStack(v_Position).Time := dbms_utility.get_time;
1363: v_Context := x_Context;
1364: IF v_Context IS NOT NULL THEN
1365: v_Context := ': '||v_Context;
1366: END IF;

Line 1406: g_TimeStack(v_Position).Time := dbms_utility.get_time;

1402: g_TimeStack(v_Position).Marker := UPPER(x_Marker);
1403: g_TimeStack(v_Position).TotalTime := 0;
1404: g_TimeStack(v_Position).CallCount := 0;
1405: END IF;
1406: g_TimeStack(v_Position).Time := dbms_utility.get_time;
1407: v_Context := x_Context;
1408: IF v_Context IS NOT NULL THEN
1409: v_Context := ': '||v_Context;
1410: END IF;

Line 1447: ((dbms_utility.get_time - g_TimeStack(v_Count).Time)/100) ||' seconds');

1443: ELSE
1444: v_Context := ': '||v_Context ||C_DELIMITER;
1445: END IF;
1446: write_output(make_space||'End Timing ('||UPPER(x_Marker)||')'|| v_Context ||
1447: ((dbms_utility.get_time - g_TimeStack(v_Count).Time)/100) ||' seconds');
1448:
1449: -- g_TimeStack.DELETE(v_Count);
1450: EXIT;
1451: END IF;

Line 1486: ((dbms_utility.get_time - g_TimeStack(v_Count).Time)/100)||' seconds');

1482: ELSE
1483: v_Context := ': '||v_Context ||C_DELIMITER;
1484: END IF;
1485: write_output(make_space||'End Timing ('||UPPER(x_Marker)||')'|| v_Context ||
1486: ((dbms_utility.get_time - g_TimeStack(v_Count).Time)/100)||' seconds');
1487:
1488: -- g_TimeStack.DELETE(v_Count);
1489: EXIT;
1490: END IF;