DBA Data[Home] [Help]

APPS.BEN_BATCH_UTILS dependencies on DBMS_UTILITY

Line 354: g_proc_info.start_time_numeric := dbms_utility.get_time;

350: Begin
351: hr_utility.set_location ('Entering '||l_proc,05);
352: g_proc_info := NULL;
353: g_proc_info.start_date := sysdate;
354: g_proc_info.start_time_numeric := dbms_utility.get_time;
355: g_proc_info.num_persons_selected := 0;
356: g_proc_info.num_persons_errored := 0;
357: g_proc_info.num_persons_unprocessed := 0;
358: g_proc_info.num_persons_processed_succ := 0;

Line 789: ,P_ELPSD_TM => to_char((dbms_utility.get_time -

785: ,P_STRT_DT => trunc(g_proc_info.start_date)
786: ,P_END_DT => trunc(sysdate)
787: ,P_STRT_TM => to_char(g_proc_info.start_date,'HH24:MI:SS')
788: ,P_END_TM => to_char(sysdate,'HH24:MI:SS')
789: ,P_ELPSD_TM => to_char((dbms_utility.get_time -
790: g_proc_info.start_time_numeric)/100)||' seconds'
791: ,P_PER_SLCTD => g_proc_info.num_persons_selected
792: ,P_PER_PROC => g_proc_info.num_persons_processed
793: ,P_PER_UNPROC => g_proc_info.num_persons_unprocessed