DBA Data[Home] [Help]

APPS.QA_TXN_GRP dependencies on FND_DATE

Line 464: to_date(value, fnd_date.name_in_dt_mask)) || '''';

460:
461: ELSIF datatype = 3 THEN -- date
462: IF column_name LIKE 'CHARACTER%' THEN -- flexdate
463: RETURN '''' || qltdate.date_to_canon(
464: to_date(value, fnd_date.name_in_dt_mask)) || '''';
465: ELSE -- real date
466: RETURN 'to_date(''' || value || ''', ''' ||
467: fnd_date.name_in_dt_mask || ''')';
468: END IF;

Line 467: fnd_date.name_in_dt_mask || ''')';

463: RETURN '''' || qltdate.date_to_canon(
464: to_date(value, fnd_date.name_in_dt_mask)) || '''';
465: ELSE -- real date
466: RETURN 'to_date(''' || value || ''', ''' ||
467: fnd_date.name_in_dt_mask || ''')';
468: END IF;
469:
470: -- Bug 5335509. SHKALYAN 15-Jun-2006
471: -- Need to insert the value 'Automatic' for Sequences while

Line 483: fnd_date.name_in_dt_mask)) || '''';

479:
480: ELSIF datatype = 6 THEN -- datetime
481: IF column_name LIKE 'CHARACTER%' THEN -- flexdate
482: RETURN '''' || qltdate.date_to_canon_dt(to_date(value,
483: fnd_date.name_in_dt_mask)) || '''';
484: ELSE -- real date
485: RETURN 'to_date (''' || value || ''', ''' ||fnd_date.name_in_dt_mask || ''')';
486: END IF;
487: END IF;

Line 485: RETURN 'to_date (''' || value || ''', ''' ||fnd_date.name_in_dt_mask || ''')';

481: IF column_name LIKE 'CHARACTER%' THEN -- flexdate
482: RETURN '''' || qltdate.date_to_canon_dt(to_date(value,
483: fnd_date.name_in_dt_mask)) || '''';
484: ELSE -- real date
485: RETURN 'to_date (''' || value || ''', ''' ||fnd_date.name_in_dt_mask || ''')';
486: END IF;
487: END IF;
488:
489: --