APPS.QA_SS_PARENT_CHILD_PKG dependencies on QA_CORE_PKG

Line 68: l_res_col_name := qa_core_pkg.get_result_column_name(l_char_id,

64: --it's called by the getters for the VQR VO sql.
65: l_char_id := p_search_array.FIRST;
66: WHILE l_char_id IS NOT NULL LOOP
67: --left side of where condition
68: l_res_col_name := qa_core_pkg.get_result_column_name(l_char_id,
69: p_plan_id);
70: IF (l_char_id = qa_ss_const.item) THEN
71: l_res_col_name := 'qa_flex_util.item(organization_id, item_id)';
72: END IF;

Line 75: l_bind_vars(l_bind_var_count) := qa_core_pkg.dequote(p_search_array(l_char_id).value);

71: l_res_col_name := 'qa_flex_util.item(organization_id, item_id)';
72: END IF;
73:
74: --store value and init right side of condition to the bind var
75: l_bind_vars(l_bind_var_count) := qa_core_pkg.dequote(p_search_array(l_char_id).value);
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

Line 171: l_res_col_name := qa_core_pkg.get_result_column_name(l_char_id,

167: --option since this where clause is passed to VQR VOs
168: l_char_id := p_search_array.FIRST;
169: WHILE l_char_id IS NOT NULL LOOP
170: --left side of where condition
171: l_res_col_name := qa_core_pkg.get_result_column_name(l_char_id,
172: p_plan_id);
173: IF (l_char_id = qa_ss_const.item) THEN
174: l_res_col_name := 'qa_flex_util.item(organization_id, item_id)';
175: END IF;

Line 178: l_res_col_value := ''''||qa_core_pkg.dequote(p_search_array(l_char_id).value)||'''';

174: l_res_col_name := 'qa_flex_util.item(organization_id, item_id)';
175: END IF;
176:
177: --initialize the res_col_value to a dequoted string of our input
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);