49: function Sub_TitleFormula return VARCHAR2 is
50: begin
51: --Bug11799279
52: IF P_INV_DATE_LOW IS NOT NULL THEN
53: RP_SUB_TITLE1 := fnd_date.date_to_chardate(P_INV_DATE_LOW, calendar_aware=> FND_DATE.calendar_aware_alt)||
54: ' - '||
55: fnd_date.date_to_chardate(P_INV_DATE_HIGH, calendar_aware=> FND_DATE.calendar_aware_alt);
56: END IF;
57: IF P_DUE_DATE_LOW IS NOT NULL THEN
51: --Bug11799279
52: IF P_INV_DATE_LOW IS NOT NULL THEN
53: RP_SUB_TITLE1 := fnd_date.date_to_chardate(P_INV_DATE_LOW, calendar_aware=> FND_DATE.calendar_aware_alt)||
54: ' - '||
55: fnd_date.date_to_chardate(P_INV_DATE_HIGH, calendar_aware=> FND_DATE.calendar_aware_alt);
56: END IF;
57: IF P_DUE_DATE_LOW IS NOT NULL THEN
58: RP_SUB_TITLE2 := fnd_date.date_to_chardate(P_DUE_DATE_LOW, calendar_aware=> FND_DATE.calendar_aware_alt)||
59: ' - '||
54: ' - '||
55: fnd_date.date_to_chardate(P_INV_DATE_HIGH, calendar_aware=> FND_DATE.calendar_aware_alt);
56: END IF;
57: IF P_DUE_DATE_LOW IS NOT NULL THEN
58: RP_SUB_TITLE2 := fnd_date.date_to_chardate(P_DUE_DATE_LOW, calendar_aware=> FND_DATE.calendar_aware_alt)||
59: ' - '||
60: fnd_date.date_to_chardate(P_DUE_DATE_HIGH, calendar_aware=> FND_DATE.calendar_aware_alt);
61: END IF;
62:
56: END IF;
57: IF P_DUE_DATE_LOW IS NOT NULL THEN
58: RP_SUB_TITLE2 := fnd_date.date_to_chardate(P_DUE_DATE_LOW, calendar_aware=> FND_DATE.calendar_aware_alt)||
59: ' - '||
60: fnd_date.date_to_chardate(P_DUE_DATE_HIGH, calendar_aware=> FND_DATE.calendar_aware_alt);
61: END IF;
62:
63: RETURN NULL; end;
64:
242:
243: function CF_report_dateFormula return Char is
244: begin
245: --Bug11799279
246: return(fnd_date.date_to_chardt(SYSDATE, calendar_aware=> FND_DATE.calendar_aware_alt));
247: end;
248:
249: --Functions to refer Oracle report placeholders--
250: