APPS.QA_SS_PARENT_CHILD_PKG dependencies on QA_CORE_PKG

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

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

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

73: l_res_col_name := 'qa_flex_util.item(organization_id, item_id)';
74: END IF;
75:
76: --store value and init right side of condition to the bind var
77: l_bind_vars(l_bind_var_count) := qa_core_pkg.dequote(p_search_array(l_char_id).value);
78: l_bind_var_name := ':'||l_bind_var_count;
79:
80: --depending on the plan char's properties we need to add modifiers to
81: --handle the different datatypes

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

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

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

178: l_res_col_name := 'qa_flex_util.item(organization_id, item_id)';
179: END IF;
180:
181: --initialize the res_col_value to a dequoted string of our input
182: l_res_col_value := ''''||qa_core_pkg.dequote(p_search_array(l_char_id).value)||'''';
183:
184: --depending on the plan char's properties we need to add modifiers to
185: --handle the different datatypes
186: l_data_type := qa_chars_api.datatype(l_char_id);