DBA Data[Home] [Help]

APPS.QA_TXN_GRP dependencies on FND_DATE

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

495:
496: ELSIF datatype = 3 THEN -- date
497: IF column_name LIKE 'CHARACTER%' THEN -- flexdate
498: RETURN '''' || qltdate.date_to_canon(
499: to_date(value, fnd_date.name_in_dt_mask)) || '''';
500: ELSE -- real date
501: RETURN 'to_date(''' || value || ''', ''' ||
502: fnd_date.name_in_dt_mask || ''')';
503: END IF;

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

498: RETURN '''' || qltdate.date_to_canon(
499: to_date(value, fnd_date.name_in_dt_mask)) || '''';
500: ELSE -- real date
501: RETURN 'to_date(''' || value || ''', ''' ||
502: fnd_date.name_in_dt_mask || ''')';
503: END IF;
504:
505: -- Bug 5335509. SHKALYAN 15-Jun-2006
506: -- Need to insert the value 'Automatic' for Sequences while

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

514:
515: ELSIF datatype = 6 THEN -- datetime
516: IF column_name LIKE 'CHARACTER%' THEN -- flexdate
517: RETURN '''' || qltdate.date_to_canon_dt(to_date(value,
518: fnd_date.name_in_dt_mask)) || '''';
519: ELSE -- real date
520: RETURN 'to_date (''' || value || ''', ''' ||fnd_date.name_in_dt_mask || ''')';
521: END IF;
522: END IF;

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

516: IF column_name LIKE 'CHARACTER%' THEN -- flexdate
517: RETURN '''' || qltdate.date_to_canon_dt(to_date(value,
518: fnd_date.name_in_dt_mask)) || '''';
519: ELSE -- real date
520: RETURN 'to_date (''' || value || ''', ''' ||fnd_date.name_in_dt_mask || ''')';
521: END IF;
522: END IF;
523:
524: --