DBA Data[Home] [Help]

APPS.RCV_RECEIPT_CONFIRMATION dependencies on FND_DATE

Line 194: trx_date_from := FND_DATE.date_to_canonical(to_date(p_trx_date_from, 'YYYY/MM/DD HH24:MI:SS'));

190: END IF;
191:
192:
193: IF p_trx_date_from IS NOT NULL AND p_trx_date_to IS NULL THEN
194: trx_date_from := FND_DATE.date_to_canonical(to_date(p_trx_date_from, 'YYYY/MM/DD HH24:MI:SS'));
195: l_trx_date_from := to_Date(trx_date_from, 'YYYY/MM/DD HH24:MI:SS');
196: l_trx_date_to := SYSDATE;
197: END IF;
198:

Line 200: trx_date_to := FND_DATE.date_to_canonical(to_date(p_trx_date_to, 'YYYY/MM/DD HH24:MI:SS'));

196: l_trx_date_to := SYSDATE;
197: END IF;
198:
199: IF p_trx_date_from IS NULL AND p_trx_date_to IS NOT NULL THEN
200: trx_date_to := FND_DATE.date_to_canonical(to_date(p_trx_date_to, 'YYYY/MM/DD HH24:MI:SS'));
201: l_trx_date_from := null;
202: l_trx_date_to := to_Date(trx_date_to, 'YYYY/MM/DD HH24:MI:SS');
203: END IF;
204:

Line 206: trx_date_from := FND_DATE.date_to_canonical(to_date(p_trx_date_from, 'YYYY/MM/DD HH24:MI:SS'));

202: l_trx_date_to := to_Date(trx_date_to, 'YYYY/MM/DD HH24:MI:SS');
203: END IF;
204:
205: IF p_trx_date_from IS NOT NULL AND p_trx_date_to IS NOT NULL THEN
206: trx_date_from := FND_DATE.date_to_canonical(to_date(p_trx_date_from, 'YYYY/MM/DD HH24:MI:SS'));
207: trx_date_to := FND_DATE.date_to_canonical(to_date(p_trx_date_to, 'YYYY/MM/DD HH24:MI:SS'));
208: l_trx_date_from := to_Date(trx_date_from, 'YYYY/MM/DD HH24:MI:SS');
209: l_trx_date_to := to_Date(trx_date_to, 'YYYY/MM/DD HH24:MI:SS');
210: END IF;

Line 207: trx_date_to := FND_DATE.date_to_canonical(to_date(p_trx_date_to, 'YYYY/MM/DD HH24:MI:SS'));

203: END IF;
204:
205: IF p_trx_date_from IS NOT NULL AND p_trx_date_to IS NOT NULL THEN
206: trx_date_from := FND_DATE.date_to_canonical(to_date(p_trx_date_from, 'YYYY/MM/DD HH24:MI:SS'));
207: trx_date_to := FND_DATE.date_to_canonical(to_date(p_trx_date_to, 'YYYY/MM/DD HH24:MI:SS'));
208: l_trx_date_from := to_Date(trx_date_from, 'YYYY/MM/DD HH24:MI:SS');
209: l_trx_date_to := to_Date(trx_date_to, 'YYYY/MM/DD HH24:MI:SS');
210: END IF;
211: