APPS.QA_RESULTS_API dependencies on QA_SS_CONST

Line 286: IF return_results_array(i).actual_datatype = qa_ss_const.date_datatype THEN

282: ELSE
283: column_value := return_results_array(i).canonical_value;
284: END IF;
285:
286: IF return_results_array(i).actual_datatype = qa_ss_const.date_datatype THEN
287:
288: column_value := qltdate.canon_to_user(column_value);
289:
290: ELSE

Line 310: (qa_ss_const.date_datatype, qa_ss_const.datetime_datatype) THEN

306: -- replaced value string to get correct date format
307: -- value_string := value_string ||','||':X'||to_char(j)||' ';
308:
309: IF return_results_array(i).actual_datatype in
310: (qa_ss_const.date_datatype, qa_ss_const.datetime_datatype) THEN
311: value_string := value_string ||', fnd_date.canonical_to_date(:X' || j || ') ';
312: ELSE
313: value_string := value_string ||','||':X'||to_char(j)||' ';
314: END IF;

Line 351: IF return_results_array(i).actual_datatype = qa_ss_const.date_datatype THEN

347: -- redundant and incorrect
348: -- killing incorrect code
349: /*
350:
351: IF return_results_array(i).actual_datatype = qa_ss_const.date_datatype THEN
352: column_value := qltdate.canon_to_user(column_value);
353:
354: END IF;
355:

Line 361: IF return_results_array(i).actual_datatype = qa_ss_const.sequence_datatype THEN

357: -- Bug 5335509. SHKALYAN 15-Jun-2006
358: -- Need to insert the value 'Automatic' for Sequences while
359: -- posting results. Calling Sequence API function
360: -- so as to get the translated value for 'Automatic'
361: IF return_results_array(i).actual_datatype = qa_ss_const.sequence_datatype THEN
362: column_value := QA_SEQUENCE_API.get_sequence_default_value;
363: END IF;
364: --
365: -- bug 6933282

Line 371: = qa_ss_const.number_datatype THEN

367: -- either on the plan level or on the element level before saving
368: -- ntungare
369: --
370: IF qa_plan_element_api.get_element_datatype(return_results_array(i).element_id)
371: = qa_ss_const.number_datatype THEN
372: l_precision := nvl(qa_plan_element_api.decimal_precision(p_plan_id,
373: return_results_array(i).element_id),
374: qa_chars_api.decimal_precision(return_results_array(i).element_id));
375: column_value := round(qltdate.any_to_number(column_value),nvl(l_precision, 240));

Line 568: = qa_ss_const.number_datatype THEN

564: -- either on the plan level or on the element level before saving
565: -- ntungare
566: --
567: IF qa_plan_element_api.get_element_datatype(charctr)
568: = qa_ss_const.number_datatype THEN
569: l_precision := nvl(qa_plan_element_api.decimal_precision(p_plan_id,
570: charctr),
571: qa_chars_api.decimal_precision(charctr));
572: return_results_array(charctr).canonical_value :=

Line 654: (qa_ss_const.date_datatype, qa_ss_const.datetime_datatype) THEN

650: p_plan_id, i);
651:
652: -- bug 3178307. rkaza. 10/06/2003. Timezone support.
653: IF return_results_array(i).actual_datatype in
654: (qa_ss_const.date_datatype, qa_ss_const.datetime_datatype) THEN
655: value_string := value_string || ', ' || column_name || ' = ' || 'fnd_date.canonical_to_date(:X' || k || ') ';
656: ELSE
657: value_string := value_string || ', ' || column_name || ' = ' || ':X' || to_char(k) || ' ';
658: END IF;