APPS.QA_TXN_GRP dependencies on QLTDATE

Line 491: RETURN '''' || qltdate.number_user_to_canon(value) || '''';

487: RETURN '''' || qa_core_pkg.dequote(value) || '''';
488:
489: ELSIF datatype = 2 THEN -- number
490: IF column_name LIKE 'CHARACTER%' THEN -- multiradix
491: RETURN '''' || qltdate.number_user_to_canon(value) || '''';
492: ELSE -- real number
493: RETURN qltdate.number_user_to_canon(value);
494: END IF;
495:

Line 493: RETURN qltdate.number_user_to_canon(value);

489: ELSIF datatype = 2 THEN -- number
490: IF column_name LIKE 'CHARACTER%' THEN -- multiradix
491: RETURN '''' || qltdate.number_user_to_canon(value) || '''';
492: ELSE -- real number
493: RETURN qltdate.number_user_to_canon(value);
494: END IF;
495:
496: ELSIF datatype = 3 THEN -- date
497: IF column_name LIKE 'CHARACTER%' THEN -- flexdate

Line 498: RETURN '''' || qltdate.date_to_canon(

494: END IF;
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 || ''')';

Line 517: RETURN '''' || qltdate.date_to_canon_dt(to_date(value,

513: -- Added datetime datatype
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;