APPS.QA_SS_PARENT_CHILD_PKG dependencies on QA_CHARS

Line 80: l_data_type := qa_chars_api.datatype(l_char_id);

76: l_bind_var_name := ':'||l_bind_var_count;
77:
78: --depending on the plan char's properties we need to add modifiers to
79: --handle the different datatypes
80: l_data_type := qa_chars_api.datatype(l_char_id);
81: IF l_data_type = 2 THEN
82: --number
83: l_precision := qa_chars_api.decimal_precision(l_char_id);
84: IF l_precision IS NOT NULL THEN

Line 83: l_precision := qa_chars_api.decimal_precision(l_char_id);

79: --handle the different datatypes
80: l_data_type := qa_chars_api.datatype(l_char_id);
81: IF l_data_type = 2 THEN
82: --number
83: l_precision := qa_chars_api.decimal_precision(l_char_id);
84: IF l_precision IS NOT NULL THEN
85: l_bind_var_name := 'round(nvl(qltdate.canon_to_number(' || l_bind_var_name || '), 0), '|| l_precision || ')';
86: ELSE
87: l_bind_var_name := 'nvl(qltdate.canon_to_number(' || l_bind_var_name || '), 0)';

Line 182: l_data_type := qa_chars_api.datatype(l_char_id);

178: l_res_col_value := ''''||qa_core_pkg.dequote(p_search_array(l_char_id).value)||'''';
179:
180: --depending on the plan char's properties we need to add modifiers to
181: --handle the different datatypes
182: l_data_type := qa_chars_api.datatype(l_char_id);
183: IF l_data_type = 2 THEN
184: --number
185: l_precision := qa_chars_api.decimal_precision(l_char_id);
186: IF l_precision IS NOT NULL THEN

Line 185: l_precision := qa_chars_api.decimal_precision(l_char_id);

181: --handle the different datatypes
182: l_data_type := qa_chars_api.datatype(l_char_id);
183: IF l_data_type = 2 THEN
184: --number
185: l_precision := qa_chars_api.decimal_precision(l_char_id);
186: IF l_precision IS NOT NULL THEN
187: l_res_col_value := 'round(nvl(qltdate.canon_to_number(' || l_res_col_value || '), 0), '|| l_precision || ')';
188: ELSE
189: l_res_col_value := 'nvl(qltdate.canon_to_number(' || l_res_col_value || '), 0)';

Line 542: FROM qa_chars

538: c_char_id NUMBER;
539:
540: CURSOR c(c_char_id NUMBER) IS
541: SELECT datatype
542: FROM qa_chars
543: WHERE char_id = c_char_id;
544:
545: BEGIN
546: