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;
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
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;
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: --