APPS.ASG_PERF dependencies on DUAL

Line 131: select sysdate into l_begin_date from dual;

127: END IF;
128:
129: log('Download Init:');
130:
131: select sysdate into l_begin_date from dual;
132: log('Begin time: ' ||
133: to_char(l_begin_date, 'DD-MON-YYYY HH24:MI:SS'));
134: apps.asg_cons_qpkg.download_init(p_user_name, g_last_tran_id,
135: g_curr_tran_id, 'N');

Line 136: select sysdate into l_end_date from dual;

132: log('Begin time: ' ||
133: to_char(l_begin_date, 'DD-MON-YYYY HH24:MI:SS'));
134: apps.asg_cons_qpkg.download_init(p_user_name, g_last_tran_id,
135: g_curr_tran_id, 'N');
136: select sysdate into l_end_date from dual;
137: log('End time: ' ||
138: to_char(l_end_date, 'DD-MON-YYYY HH24:MI:SS'));
139:
140: g_elapsed_time_in_days := l_end_date-l_begin_date;

Line 156: select sysdate into l_begin_date from dual;

152: l_begin_date DATE;
153: l_end_date DATE;
154: l_query_string VARCHAR2 (512);
155: begin
156: select sysdate into l_begin_date from dual;
157: log('Begin time: ' ||
158: to_char(l_begin_date, 'DD-MON-YYYY HH24:MI:SS'));
159: l_query_string := 'SELECT count(*) ' ||
160: ' FROM mobileadmin.ctm$' ||p_pub_item ||

Line 166: select sysdate into l_end_date from dual;

162: ' tranid$$ > :2';
163:
164: EXECUTE IMMEDIATE l_query_string INTO g_num_rows
165: USING g_user_name, g_last_tran_id;
166: select sysdate into l_end_date from dual;
167: log('End time: ' ||
168: to_char(l_end_date, 'DD-MON-YYYY HH24:MI:SS'));
169: log('Num of rows: ' || g_num_rows);
170: g_elapsed_time_in_days := l_end_date-l_begin_date;

Line 220: select sysdate into l_begin_date from dual;

216: log('Download Init:');
217: --log('Last tranid: ' || g_last_tran_id ||
218: -- ' Current tranid: ' || g_curr_tran_id);
219:
220: select sysdate into l_begin_date from dual;
221: log('Begin time: ' ||
222: to_char(l_begin_date, 'DD-MON-YYYY HH24:MI:SS'));
223: apps.asg_cons_qpkg.download_init(p_user_name, g_last_tran_id,
224: g_curr_tran_id, 'N');

Line 225: select sysdate into l_end_date from dual;

221: log('Begin time: ' ||
222: to_char(l_begin_date, 'DD-MON-YYYY HH24:MI:SS'));
223: apps.asg_cons_qpkg.download_init(p_user_name, g_last_tran_id,
224: g_curr_tran_id, 'N');
225: select sysdate into l_end_date from dual;
226: log('End time: ' ||
227: to_char(l_end_date, 'DD-MON-YYYY HH24:MI:SS'));
228:
229: g_elapsed_time_in_days := l_end_date-l_begin_date;