[Home] [Help]
44: BEGIN
45:
46: SELECT sysdate
47: INTO l_sysdate
48: FROM dual;
49:
50: IF (p_time_id = 1) THEN
51: p_from_date := trunc(l_sysdate,'IW');
52: p_to_date := l_sysdate;
278: END IF;
279: l_date_format := l_date_format||' HH24:MI:SS';
280: SELECT to_char(sysdate,l_date_format)
281: INTO l_max_date
282: FROM dual;
283: RETURN FND_MESSAGE.GET_STRING('BIX','BIX_DM_REFRESH_MSG') || ' '|| l_max_date;
284: EXCEPTION
285: WHEN OTHERS THEN
286: RETURN NULL;
350: l_session_id NUMBER;
351: BEGIN
352: SELECT icx_sec.g_session_id
353: INTO l_session_id
354: FROM dual;
355:
356: return l_session_id;
357: EXCEPTION
358: WHEN OTHERS THEN
439: AND trunc(p_date) between start_date and end_date;
440:
441: SELECT sysdate
442: INTO p_period_end_date
443: FROM dual;
444:
445: EXCEPTION
446: WHEN NO_DATA_FOUND THEN
447: p_period_start_date := to_date('01/01/1900','dd/mm/yyyy');
475: END IF;
476:
477: SELECT sysdate
478: INTO l_sysdate
479: FROM dual;
480:
481: /*
482: ** Commented out ; will be required once we start implementing "Save as default"
483: IF (INSTR(p_period_ind,':') > 0) THEN
741: THEN
742: l_period_type := 'DAY';
743: SELECT to_date(p_end_date, p_date_format) - p_numperiods
744: INTO l_start_date
745: from dual;
746: --ELSIF upper(p_period) = 'WEEK'
747: ELSIF p_period = '1'
748: THEN
749: l_period_type := 'WEEK';
748: THEN
749: l_period_type := 'WEEK';
750: SELECT trunc(to_date(p_end_date,p_date_format),'IW') - (p_numperiods*7)
751: INTO l_start_date
752: FROM dual;
753: ELSIF ( p_period = '2'
754: OR p_period = '3'
755: OR p_period = '4'
756: )
846: THEN
847: SELECT 'Week of '
848: || to_char(trunc(to_date(p_end_date,p_date_format),'IW'),'DD-MON')
849: INTO l_group_by
850: FROM dual;
851: ELSIF upper(p_period) = 'MONTH'
852: THEN
853: SELECT to_char(start_date,'MON') ||'-'|| period_year
854: INTO l_group_by