[Home] [Help]
91: l_date_format VARCHAR2(50);
92:
93: BEGIN
94:
95: l_date_format := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');
96: IF(l_date_format IS NULL) THEN
97: l_date_format := 'MM/DD/YYYY';
98: END IF;
99:
134: RETURN VARCHAR2 IS
135: l_max_date VARCHAR2(25);
136: l_date_format VARCHAR2(50);
137: BEGIN
138: l_date_format := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');
139: IF(l_date_format IS NULL) THEN
140: l_date_format := 'MM/DD/YYYY';
141: END IF;
142: l_date_format := l_date_format||' HH24:MI:SS';
154: RETURN VARCHAR2 IS
155: l_max_date VARCHAR2(20);
156: l_date_format VARCHAR2(50);
157: BEGIN
158: l_date_format := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');
159: IF(l_date_format IS NULL) THEN
160: l_date_format := 'MM/DD/YYYY';
161: END IF;
162: l_date_format := l_date_format||' HH24:MI:SS';
173: RETURN VARCHAR2 IS
174: l_date_format VARCHAR2(50);
175: l_max_date VARCHAR2(20);
176: BEGIN
177: l_date_format := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');
178: IF(l_date_format IS NULL) THEN
179: l_date_format := 'MM/DD/YYYY';
180: END IF;
181: l_date_format := l_date_format||' HH24:MI:SS';
195: l_date_format VARCHAR2(50);
196:
197: BEGIN
198:
199: l_date_format := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');
200: IF(l_date_format IS NULL) THEN
201: l_date_format := 'MM/DD/YYYY';
202: END IF;
203:
235: l_date_format VARCHAR2(50);
236:
237: BEGIN
238:
239: l_date_format := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');
240: IF(l_date_format IS NULL) THEN
241: l_date_format := 'MM/DD/YYYY';
242: END IF;
243:
271: RETURN VARCHAR2 IS
272: l_max_date VARCHAR2(20);
273: l_date_format VARCHAR2(50);
274: BEGIN
275: l_date_format := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');
276: IF(l_date_format IS NULL) THEN
277: l_date_format := 'MM/DD/YYYY';
278: END IF;
279: l_date_format := l_date_format||' HH24:MI:SS';
303: THEN
304: l_denom_rate := 1;
305: l_num_rate := 1;
306: ELSE
307: l_max_rollback_days := fnd_profile.value('BIX_DM_CURR_MAX_ROLL_DAYS');
308:
309: IF l_max_rollback_days is null
310: THEN
311: l_max_rollback_days := 0;
484: l_time_id := SUBSTR(p_period_ind, 1, INSTR(p_period_ind, ':') - 1);
485: l_nls_date_format := SUBSTR(p_period_ind, INSTR(p_period_ind, ':') + 1);
486: else
487: l_time_id := TO_NUMBER(p_period_ind);
488: l_nls_date_format := fnd_profile.value('ICX_DATE_FORMAT_MASK');
489: end if;
490: */
491:
492: l_nls_date_format := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');
488: l_nls_date_format := fnd_profile.value('ICX_DATE_FORMAT_MASK');
489: end if;
490: */
491:
492: l_nls_date_format := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');
493: l_time_id := TO_NUMBER(p_period_ind);
494: l_start_date := TO_DATE(p_start_date, l_nls_date_format);
495: l_end_date := TO_DATE(p_end_date, l_nls_date_format);
496:
505: ELSE
506: l_end_time := '23';
507: END IF;
508:
509: l_period_set_name := FND_PROFILE.VALUE('BIX_DM_REPORTING_CALENDAR');
510:
511: IF (l_time_id = 11) THEN
512: /* Period Indicator = 11 indicates that user has selected today as reporting period */
513: p_start_period := to_char(l_sysdate, 'dd/mm/yyyy') || ' 00:00:00';
592: THEN
593: l_denom_rate := 1;
594: l_num_rate := 1;
595: ELSE
596: l_max_rollback_days := fnd_profile.value('BIX_DM_CURR_MAX_ROLL_DAYS');
597:
598: IF l_max_rollback_days is null
599: THEN
600: l_max_rollback_days := 0;
622: l_max_date VARCHAR2(20);
623: l_date_format VARCHAR2(50);
624: BEGIN
625:
626: l_date_format := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');
627:
628: IF(l_date_format IS NULL) THEN
629: l_date_format := 'MM/DD/YYYY';
630: END IF;
646: l_max_date VARCHAR2(20);
647: l_date_format VARCHAR2(50);
648: BEGIN
649:
650: l_date_format := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');
651:
652: IF(l_date_format IS NULL) THEN
653: l_date_format := 'MM/DD/YYYY';
654: END IF;
670: l_max_date VARCHAR2(20);
671: l_date_format VARCHAR2(50);
672: BEGIN
673:
674: l_date_format := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');
675:
676: IF(l_date_format IS NULL) THEN
677: l_date_format := 'MM/DD/YYYY';
678: END IF;
694: l_max_date VARCHAR2(20);
695: l_date_format VARCHAR2(50);
696: BEGIN
697:
698: l_date_format := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');
699:
700: IF(l_date_format IS NULL) THEN
701: l_date_format := 'MM/DD/YYYY';
702: END IF;
733: *** Note: to get the start date of the current period pass in a
734: *** p_numperiods of 0
735: **/
736:
737: l_rpt_calendar:= FND_PROFILE.VALUE('BIX_DM_REPORTING_CALENDAR');
738:
739: --IF upper(p_period) = 'DAY'
740: IF p_period = '5'
741: THEN
836: *** Note: to get the start date of the current period pass in a
837: *** p_numperiods of 0
838: **/
839:
840: l_rpt_calendar:= FND_PROFILE.VALUE('BIX_DM_REPORTING_CALENDAR');
841:
842: IF upper(p_period) = 'DAY'
843: THEN
844: l_group_by := p_end_date;