DBA Data[Home] [Help]

APPS.MSD_TRANSLATE_TIME_DATA dependencies on FND_DATE

Line 528: fnd_date.string_to_date('01-JAN-'||to_char(p_from_date+v_num_of_days,'YYYY'),

524: p_calendar_code,
525: v_seq,
526: to_char(p_from_date+v_num_of_days,'YYYY','nls_date_language = AMERICAN'),
527: to_char(p_from_date+v_num_of_days,'YYYY','nls_date_language = AMERICAN'),
528: fnd_date.string_to_date('01-JAN-'||to_char(p_from_date+v_num_of_days,'YYYY'),
529: 'DD-MON-YYYY'),
530: fnd_date.string_to_date('31-DEC-'||to_char(p_from_date+v_num_of_days,'YYYY'),
531: 'DD-MON-YYYY'),
532: decode(to_char(p_from_date+v_num_of_days,'MM','nls_date_language = AMERICAN'),

Line 530: fnd_date.string_to_date('31-DEC-'||to_char(p_from_date+v_num_of_days,'YYYY'),

526: to_char(p_from_date+v_num_of_days,'YYYY','nls_date_language = AMERICAN'),
527: to_char(p_from_date+v_num_of_days,'YYYY','nls_date_language = AMERICAN'),
528: fnd_date.string_to_date('01-JAN-'||to_char(p_from_date+v_num_of_days,'YYYY'),
529: 'DD-MON-YYYY'),
530: fnd_date.string_to_date('31-DEC-'||to_char(p_from_date+v_num_of_days,'YYYY'),
531: 'DD-MON-YYYY'),
532: decode(to_char(p_from_date+v_num_of_days,'MM','nls_date_language = AMERICAN'),
533: '01', 'Qtr 1',
534: '02', 'Qtr 1',

Line 558: fnd_date.string_to_date(decode(to_char(p_from_date+v_num_of_days,'MM','nls_date_language = AMERICAN'),

554: '09', 'Qtr 3',
555: '10', 'Qtr 4',
556: '11', 'Qtr 4',
557: '12', 'Qtr 4') || ' ' || to_char(p_from_date+v_num_of_days,'YYYY','nls_date_language = AMERICAN'),
558: fnd_date.string_to_date(decode(to_char(p_from_date+v_num_of_days,'MM','nls_date_language = AMERICAN'),
559: '01', '01-JAN-',
560: '02', '01-JAN-',
561: '03', '01-JAN-',
562: '04', '01-APR-',

Line 572: fnd_date.string_to_date(decode(to_char(p_from_date+v_num_of_days,'MM','nls_date_language = AMERICAN'),

568: '10', '01-OCT-',
569: '11', '01-OCT-',
570: '12', '01-OCT-')||to_char(p_from_date+v_num_of_days,'YYYY','nls_date_language = AMERICAN'),
571: 'DD-MON-YYYY'),
572: fnd_date.string_to_date(decode(to_char(p_from_date+v_num_of_days,'MM','nls_date_language = AMERICAN'),
573: '01', '31-MAR-',
574: '02', '31-MAR-',
575: '03', '31-MAR-',
576: '04', '30-JUN-',

Line 590: fnd_date.string_to_date(decode(to_char(p_from_date+v_num_of_days,'MM','nls_date_language = AMERICAN'),

586: to_char(p_from_date+v_num_of_days,'MON','nls_date_language = AMERICAN')||' '||
587: to_char(p_from_date+v_num_of_days,'YYYY','nls_date_language = AMERICAN'),
588: to_char(p_from_date+v_num_of_days,'MON','nls_date_language = AMERICAN')||' '||
589: to_char(p_from_date+v_num_of_days,'YYYY','nls_date_language = AMERICAN'),
590: fnd_date.string_to_date(decode(to_char(p_from_date+v_num_of_days,'MM','nls_date_language = AMERICAN'),
591: '01', '01-JAN-',
592: '02', '01-FEB-',
593: '03', '01-MAR-',
594: '04', '01-APR-',

Line 604: fnd_date.string_to_date(decode(to_char(p_from_date+v_num_of_days,'MM','nls_date_language = AMERICAN'),

600: '10', '01-OCT-',
601: '11', '01-NOV-',
602: '12', '01-DEC-')||to_char(p_from_date+v_num_of_days,'YYYY','nls_date_language = AMERICAN'),
603: 'DD-MON-YYYY'),
604: fnd_date.string_to_date(decode(to_char(p_from_date+v_num_of_days,'MM','nls_date_language = AMERICAN'),
605: '01', '31-JAN-',
606: '02', decode(mod(to_number(
607: to_char(p_from_date+v_num_of_days,'YYYY','nls_date_language = AMERICAN')),4),
608: 0, '29-FEB-',