DBA Data[Home] [Help]

APPS.JTF_IH_BULK dependencies on DBMS_UTILITY

Line 187: t2_beg := DBMS_UTILITY.GET_TIME;

183: G_STATS_ENABLED := TRUE;
184: END IF;*/
185:
186: --IF (g_stats_enabled) THEN
187: t2_beg := DBMS_UTILITY.GET_TIME;
188: --END IF;
189:
190: -- get server tz value, it is required to transform the start and end date
191: -- time values from gmt. default to GMT if server time zone is not set.

Line 221: SELECT DBMS_UTILITY.get_time INTO G_CONC_REQUEST_ID FROM dual;

217: -- All the FND_GLOBAL values are -1 if this program is run in command line
218: -- mode. Some of the values are important for recovery and such, so they are
219: -- being taken care of.
220: IF (G_CONC_REQUEST_ID = -1) THEN
221: SELECT DBMS_UTILITY.get_time INTO G_CONC_REQUEST_ID FROM dual;
222: END IF;
223:
224: IF (G_CONC_PROGRAM_ID = -1) THEN
225: G_CONC_PROGRAM_ID := G_CONC_REQUEST_ID;

Line 287: t1_beg := DBMS_UTILITY.GET_TIME;

283: payload => bulk_obj,
284: msgid => l_msg_id);
285:
286: IF (g_stats_enabled) THEN
287: t1_beg := DBMS_UTILITY.GET_TIME;
288: END IF;
289:
290: -- Turns out, at least during testing, that the clob can be empty
291: IF (DBMS_LOB.GETLENGTH(bulk_obj.bulkInteractionRequest) > 0) THEN

Line 377: t1_end := DBMS_UTILITY.GET_TIME;

373: END IF;
374:
375: END IF;
376:
377: t1_end := DBMS_UTILITY.GET_TIME;
378:
379: -- processing times - one record, maximum, minimum and cumulative
380: l_time_onerec := (t1_end-t1_beg)*10;
381:

Line 480: t2_end := DBMS_UTILITY.GET_TIME;

476: COMMIT;
477: END IF;
478:
479:
480: t2_end := DBMS_UTILITY.GET_TIME;
481:
482: --Logging Detail Level
483: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
484: l_fnd_log_msg := 'Cumulative counts - ' ||

Line 728: t1_beg := DBMS_UTILITY.GET_TIME;

724: END;
725: END;
726:
727: --IF (g_stats_enabled) THEN
728: t1_beg := DBMS_UTILITY.GET_TIME;
729: --END IF;
730:
731:
732: --IF (g_stats_enabled) THEN

Line 733: t1_end := DBMS_UTILITY.GET_TIME;

729: --END IF;
730:
731:
732: --IF (g_stats_enabled) THEN
733: t1_end := DBMS_UTILITY.GET_TIME;
734: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Parse returned.');
735: l_parse_time := ((t1_end-t1_beg)*10);
736:
737: g_hrt_beat := 1.6;

Line 816: t1_beg := DBMS_UTILITY.GET_TIME;

812:
813: g_hrt_beat := 3.41;
814:
815: IF (g_stats_enabled) THEN
816: t1_beg := DBMS_UTILITY.GET_TIME;
817: END IF;
818:
819: g_hrt_beat := 3.42;
820:

Line 1027: t1_end := DBMS_UTILITY.GET_TIME;

1023: -- increment number of interactions processed
1024: l_num_int_done := l_num_int_done+1;
1025:
1026: --IF (g_stats_enabled) THEN
1027: t1_end := DBMS_UTILITY.GET_TIME;
1028:
1029: l_int_proc_time := (t1_end - t1_beg)*10;
1030:
1031: -- this is being done here so that interactions without errors are the