DBA Data[Home] [Help]

APPS.AR_OBALREV_PKG dependencies on FND_DATE

Line 156: gd_date_to1:=fnd_date.canonical_to_date(P_AS_OF_DATE);

152: ----build where clause for gc_trx_date_where
153: --****************************************************************************
154:
155: --gd_date_to :=TO_DATE(TO_CHAR(TO_DATE(P_AS_OF_DATE,'YYYY/MM/DD HH24:MI:SS'),'DD-MON-YYYY'));
156: gd_date_to1:=fnd_date.canonical_to_date(P_AS_OF_DATE);
157: gc_trx_date_where := 'ara.gl_date<='||''''||gd_date_to1||'''';
158: gc_trx_date_where1 := 'RCTA.trx_date<='||''''||gd_date_to1||'''';
159: gd_date_to := ''''||gd_date_to1||'''';
160: --****************************************************************************

Line 198: fnd_message.SET_TOKEN('P_AS_OF_DATE',fnd_date.date_to_chardate(gd_date_to1, calendar_aware=> FND_DATE.calendar_aware_alt));

194: fnd_message.SET_name('AR', 'AR_EXCHANGE_RATE');
195: fnd_message.SET_TOKEN('P_EXCHANGE_RATE_TYPE',P_EXCHANGE_RATE_TYPE);
196: fnd_message.SET_TOKEN('CURRENCY',P_CURRENCY);
197: --Int'l Calendar Project
198: fnd_message.SET_TOKEN('P_AS_OF_DATE',fnd_date.date_to_chardate(gd_date_to1, calendar_aware=> FND_DATE.calendar_aware_alt));
199: lc_exchange_rate_type := FND_MESSAGE.GET;
200: FND_FILE.PUT_LINE(FND_FILE.LOG,lc_exchange_rate_type);
201: raise_application_error (-20101,lc_exchange_rate_type);
202: ln_exch_rate:=NULL;