APPS.QA_TXN_GRP dependencies on QLTDATE

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

452: RETURN '''' || qa_core_pkg.dequote(value) || '''';
453:
454: ELSIF datatype = 2 THEN -- number
455: IF column_name LIKE 'CHARACTER%' THEN -- multiradix
456: RETURN '''' || qltdate.number_user_to_canon(value) || '''';
457: ELSE -- real number
458: RETURN qltdate.number_user_to_canon(value);
459: END IF;
460:

Line 458: RETURN qltdate.number_user_to_canon(value);

454: ELSIF datatype = 2 THEN -- number
455: IF column_name LIKE 'CHARACTER%' THEN -- multiradix
456: RETURN '''' || qltdate.number_user_to_canon(value) || '''';
457: ELSE -- real number
458: RETURN qltdate.number_user_to_canon(value);
459: END IF;
460:
461: ELSIF datatype = 3 THEN -- date
462: IF column_name LIKE 'CHARACTER%' THEN -- flexdate

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

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

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

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