DBA Data[Home] [Help]

APPS.OKL_LLA_UTIL_PVT dependencies on FND_DATE

Line 401: p_date_out := FND_DATE.date_to_canonical(TO_DATE(p_date_out,p_date_mask));

397: p_date_out VARCHAR2(15) := p_date_char;
398:
399: BEGIN
400: IF(LENGTH(RTRIM(p_date_out)) > 0) THEN
401: p_date_out := FND_DATE.date_to_canonical(TO_DATE(p_date_out,p_date_mask));
402: END IF;
403: RETURN p_date_out;
404: EXCEPTION
405: WHEN OTHERS THEN

Line 424: p_date_out := FND_DATE.date_to_canonical(p_date);

420: --p_canonical_date := to_char(to_date(p_date_char,G_DISPLAY_MASK), g_canonical_mask);
421: IF(LENGTH(RTRIM(p_date_out)) > 0) THEN
422: p_date := TO_DATE(p_date_out,G_DISPLAY_MASK);
423: -- p_date_out := to_char(p_date,g_canonical_mask);
424: p_date_out := FND_DATE.date_to_canonical(p_date);
425: END IF;
426: RETURN p_date_out;
427: EXCEPTION
428: WHEN OTHERS THEN

Line 465: -- p_date_out := to_char(FND_DATE.canonical_to_date(p_date_out), p_date_mask);

461:
462: BEGIN
463: IF(LENGTH(RTRIM(p_date_char)) > 0) THEN
464: -- p_date_out := to_char(to_date(p_date_out,g_canonical_mask), p_date_mask);
465: -- p_date_out := to_char(FND_DATE.canonical_to_date(p_date_out), p_date_mask);
466:
467: --l_date := FND_DATE.canonical_to_date('2003/02/10');
468: --l_date_out := to_char(l_date,'DD-MON-YYYY');
469: l_date := FND_DATE.canonical_to_date(p_date_char);

Line 467: --l_date := FND_DATE.canonical_to_date('2003/02/10');

463: IF(LENGTH(RTRIM(p_date_char)) > 0) THEN
464: -- p_date_out := to_char(to_date(p_date_out,g_canonical_mask), p_date_mask);
465: -- p_date_out := to_char(FND_DATE.canonical_to_date(p_date_out), p_date_mask);
466:
467: --l_date := FND_DATE.canonical_to_date('2003/02/10');
468: --l_date_out := to_char(l_date,'DD-MON-YYYY');
469: l_date := FND_DATE.canonical_to_date(p_date_char);
470: l_date_out := TO_CHAR(l_date,p_date_mask);
471: END IF;

Line 469: l_date := FND_DATE.canonical_to_date(p_date_char);

465: -- p_date_out := to_char(FND_DATE.canonical_to_date(p_date_out), p_date_mask);
466:
467: --l_date := FND_DATE.canonical_to_date('2003/02/10');
468: --l_date_out := to_char(l_date,'DD-MON-YYYY');
469: l_date := FND_DATE.canonical_to_date(p_date_char);
470: l_date_out := TO_CHAR(l_date,p_date_mask);
471: END IF;
472: RETURN l_date_out;
473: EXCEPTION