APPS.BIX_DM_SESSIONINFO_SUMMARY_PKG dependencies on DUAL

Line 306: INTO l_temp FROM DUAL;

302: SELECT TO_CHAR(l_begin_date,'YYYY/MM/DD')||
303: LPAD(TO_CHAR(l_begin_date,'HH24:'),3,'0') ||
304: DECODE(SIGN(TO_NUMBER(TO_CHAR(l_begin_date,'MI'))-29),
305: 0,'00',1,'30',-1,'00')
306: INTO l_temp FROM DUAL;
307:
308: l_period_start := TO_DATE(l_temp,'YYYY/MM/DDHH24:MI');
309: l_row_counter := 0;
310: WHILE ( l_period_start < l_end_date )

Line 373: INTO l_temp FROM DUAL;

369: SELECT TO_CHAR(l_begin_date,'YYYY/MM/DD')||
370: LPAD(TO_CHAR(l_begin_date,'HH24:'),3,'0') ||
371: DECODE(SIGN(TO_NUMBER(TO_CHAR(l_begin_date,'MI'))-29),
372: 0,'00',1,'30',-1,'00')
373: INTO l_temp FROM DUAL;
374:
375: l_period_start := TO_DATE(l_temp,'YYYY/MM/DDHH24:MI');
376: l_row_counter := 0;
377: WHILE ( l_period_start < l_end_date )

Line 499: INTO l_temp FROM DUAL;

495: SELECT TO_CHAR(l_begin_date,'YYYY/MM/DD')||
496: LPAD(TO_CHAR(l_begin_date,'HH24:'),3,'0')||
497: DECODE(SIGN(TO_NUMBER(TO_CHAR(l_begin_date,'MI'))-29),
498: 0,'00',1,'30',-1,'00')
499: INTO l_temp FROM DUAL;
500:
501: l_period_start := TO_DATE(l_temp,'YYYY/MM/DDHH24:MI');
502: l_row_counter := 0;
503: WHILE ( l_period_start < l_end_date )

Line 622: INTO l_temp FROM DUAL;

618: SELECT TO_CHAR(l_begin_date,'YYYY/MM/DD')||
619: LPAD(TO_CHAR(l_begin_date,'HH24:'),3,'0') ||
620: DECODE(SIGN(TO_NUMBER(TO_CHAR(l_begin_date,'MI'))-29),
621: 0,'00',1,'30',-1,'00')
622: INTO l_temp FROM DUAL;
623:
624: l_period_start := TO_DATE(l_temp,'YYYY/MM/DDHH24:MI');
625: l_row_counter := 0;
626: WHILE ( l_period_start < l_end_date )

Line 953: FROM DUAL;

949: LPAD(TO_CHAR(g_collect_start_date,'HH24:'),3,'0')||
950: DECODE(SIGN(TO_NUMBER(TO_CHAR(g_collect_start_date,'MI'))-29),
951: 0,'00:00',1,'30:00',-1,'00:00'), 'YYYY/MM/DDHH24:MI:SS')
952: INTO g_rounded_collect_start_date
953: FROM DUAL;
954:
955: /* Round the collection end date to nearest higher time bucket.
956: eg: if time is between 10:00 and 10:29 round it to 10:29:59
957: */

Line 964: FROM DUAL;

960: LPAD(TO_CHAR(g_collect_end_date,'HH24:'),3,'0')||
961: DECODE(SIGN(TO_NUMBER(TO_CHAR(g_collect_end_date,'MI'))-29),
962: 0,'29:59',1,'59:59',-1,'29:59'), 'YYYY/MM/DDHH24:MI:SS')
963: INTO g_rounded_collect_end_date
964: FROM DUAL;
965:
966: g_message := 'Collection Period : '||
967: to_char(g_rounded_collect_start_date,'DD-MON-YYYY HH24:MI:SS') || ' to '
968: || to_char(g_rounded_collect_end_date, 'DD-MON-YYYY HH24:MI:SS');