APPS.BIX_DM_EMAIL_SUMMARY_PKG dependencies on DUAL

Line 675: INTO l_begin_bucket_date FROM DUAL;

671: SELECT TO_DATE(TO_CHAR(q_measures.start_date_time ,'YYYY/MM/DD')||
672: LPAD(TO_CHAR(q_measures.start_date_time ,'HH24:'),3,'0')||
673: DECODE(SIGN(TO_NUMBER(TO_CHAR(q_measures.start_date_time ,'MI'))-29),
674: 0,'00',1,'30',-1,'00'),'YYYY/MM/DDHH24:MI')
675: INTO l_begin_bucket_date FROM DUAL;
676: ELSE
677: l_begin_bucket_date := g_rounded_collect_start_date;
678: END IF;
679:

Line 687: INTO l_end_bucket_date FROM DUAL;

683: SELECT TO_DATE(TO_CHAR(q_measures.end_date_time ,'YYYY/MM/DD')||
684: LPAD(TO_CHAR(q_measures.end_date_time ,'HH24:'),3,'0')||
685: DECODE(SIGN(TO_NUMBER(TO_CHAR(q_measures.end_date_time ,'MI'))-29),
686: 0,'00',1,'30',-1,'00'),'YYYY/MM/DDHH24:MI')
687: INTO l_end_bucket_date FROM DUAL;
688: ELSE
689: l_end_bucket_date := g_rounded_collect_end_date - (( 29 * 60 + 59 )/(24*60*60));
690: END IF;
691:

Line 966: INTO l_begin_bucket_date FROM DUAL;

962: SELECT TO_DATE(TO_CHAR(o_measures.start_date_time ,'YYYY/MM/DD')||
963: LPAD(TO_CHAR(o_measures.start_date_time ,'HH24:'),3,'0')||
964: DECODE(SIGN(TO_NUMBER(TO_CHAR(o_measures.start_date_time ,'MI'))-29),
965: 0,'00',1,'30',-1,'00'),'YYYY/MM/DDHH24:MI')
966: INTO l_begin_bucket_date FROM DUAL;
967: ELSE
968: l_begin_bucket_date := g_rounded_collect_start_date;
969: END IF;
970:

Line 1021: INTO l_end_bucket_date FROM DUAL;

1017: SELECT TO_DATE(TO_CHAR(l_next_seg_start_date ,'YYYY/MM/DD')||
1018: LPAD(TO_CHAR(l_next_seg_start_date ,'HH24:'),3,'0')||
1019: DECODE(SIGN(TO_NUMBER(TO_CHAR(l_next_seg_start_date ,'MI'))-29),
1020: 0,'00',1,'30',-1,'00'),'YYYY/MM/DDHH24:MI')
1021: INTO l_end_bucket_date FROM DUAL;
1022: ELSE
1023: l_end_bucket_date := g_rounded_collect_end_date - (( 29 * 60 + 59 )/(24*60*60));
1024: END IF;
1025:

Line 1538: FROM DUAL;

1534: LPAD(TO_CHAR(g_collect_start_date,'HH24:'),3,'0')||
1535: DECODE(SIGN(TO_NUMBER(TO_CHAR(g_collect_start_date,'MI'))-29),0,'00:00',1,'30:00',-1,'00:00'),
1536: 'YYYY/MM/DDHH24:MI:SS')
1537: INTO g_rounded_collect_start_date
1538: FROM DUAL;
1539:
1540: /*
1541: Round the Collection end date to nearest higher time bucket.
1542: ex: if time is between 10:00 and 10:29 round it to 10:29:59

Line 1551: FROM DUAL;

1547: LPAD(TO_CHAR(g_collect_end_date,'HH24:'),3,'0')||
1548: DECODE(SIGN(TO_NUMBER(TO_CHAR(g_collect_end_date,'MI'))-29),0,'29:59',1,'59:59',-1,'29:59'),
1549: 'YYYY/MM/DDHH24:MI:SS')
1550: INTO g_rounded_collect_end_date
1551: FROM DUAL;
1552:
1553:
1554: /*
1555: dbms_output.put_line('Collection End Date: ' ||

Line 1695: FROM DUAL;

1691: LPAD(TO_CHAR(g_collect_start_date,'HH24:'),3,'0')||
1692: DECODE(SIGN(TO_NUMBER(TO_CHAR(g_collect_start_date,'MI'))-29),0,'00:00',1,'30:00',-1,'00:00'),
1693: 'YYYY/MM/DDHH24:MI:SS')
1694: INTO g_rounded_collect_start_date
1695: FROM DUAL;
1696:
1697: /*
1698: Round the Collection end date to nearest higher time bucket.
1699: ex: if time is between 10:00 and 10:29 round it to 10:29:59

Line 1708: FROM DUAL;

1704: LPAD(TO_CHAR(g_collect_end_date,'HH24:'),3,'0')||
1705: DECODE(SIGN(TO_NUMBER(TO_CHAR(g_collect_end_date,'MI'))-29),0,'29:59',1,'59:59',-1,'29:59'),
1706: 'YYYY/MM/DDHH24:MI:SS')
1707: INTO g_rounded_collect_end_date
1708: FROM DUAL;
1709:
1710: /*
1711: dbms_output.put_line('Collection End Date: ' ||
1712: to_char(g_rounded_collect_end_date,'YYYY/MM/DD HH24:MI:SS'));