APPS.QA_SS_PARENT_CHILD_PKG dependencies on QA_TXN_GRP

Line 6: p_search_array IN qa_txn_grp.ElementsArray)

2: /* $Header: qapcssb.pls 120.4 2010/10/11 10:24:28 pdube noship $ */
3:
4: FUNCTION check_for_elements (
5: p_plan_id IN NUMBER,
6: p_search_array IN qa_txn_grp.ElementsArray)
7: RETURN VARCHAR2
8:
9: IS
10: x_char_id NUMBER;

Line 35: p_search_array IN qa_txn_grp.ElementsArray)

31: --for plans with matching results. As an invariant, numbers, dates and
32: --datetimes are passed in the canonical form/server timezone. This conversion
33: --is handled by the client CO before passing the criteria to the PL/SQL.
34: FUNCTION check_for_results (p_plan_id IN NUMBER,
35: p_search_array IN qa_txn_grp.ElementsArray)
36: RETURN VARCHAR2
37: IS
38: l_select_clause VARCHAR2(10) := 'SELECT 1';
39: l_from_clause VARCHAR2(20) := ' FROM QA_RESULTS_V';

Line 155: p_search_array IN qa_txn_grp.ElementsArray)

151: --Rewrote it, as with check_for_results, to consider data types. The
152: --same invariants apply here: numbers, dates and datetimes are passed
153: --in the canonical form/server timezone.
154: FUNCTION get_where_clause (p_plan_id IN NUMBER,
155: p_search_array IN qa_txn_grp.ElementsArray)
156: RETURN VARCHAR2
157: IS
158: -- Bug 9773013 FP to 9492520.Added condition for status.pdube
159: -- l_where_clause VARCHAR2(4000) := ' WHERE plan_id = '||p_plan_id;

Line 889: search_array IN qa_txn_grp.ElementsArray)

885:
886:
887: FUNCTION is_plan_applicable (
888: p_plan_id IN NUMBER,
889: search_array IN qa_txn_grp.ElementsArray)
890: RETURN VARCHAR2
891: IS
892: security_profile NUMBER;
893: allow VARCHAR2(1) := 'T';

Line 941: search_array qa_txn_grp.ElementsArray;

937: p_search_str2 IN VARCHAR2 default null, --future use
938: p_search_str3 IN VARCHAR2 default null) --future use
939: RETURN VARCHAR2
940: IS
941: search_array qa_txn_grp.ElementsArray;
942: SelectFromClause VARCHAR2(20000);
943: WhereClause VARCHAR2(20000);
944: BEGIN
945: --p_search_str is of form 10=XYZ@19=Ssaf@87=fsfsf

Line 963: search_array := qa_txn_grp.result_to_array(p_search_str);

959: || ' AND collection_id = '||p_collection_id
960: || ' AND occurrence = ' || p_occurrence;
961: else
962:
963: search_array := qa_txn_grp.result_to_array(p_search_str);
964:
965: WhereClause := get_where_clause(p_plan_id, search_array);
966: end if; --for direct link embedding in if clause
967:

Line 1059: l_search_array qa_txn_grp.ElementsArray;

1055: l_plan_ids VARCHAR2(2000) := '';
1056: l_plan_seen BOOLEAN := false;
1057: l_plan_separator VARCHAR2(1) := ',';
1058: l_applicable VARCHAR2(1);
1059: l_search_array qa_txn_grp.ElementsArray;
1060:
1061: cursor l_plans_cursor IS
1062: select distinct qpr.parent_plan_id
1063: from qa_pc_plan_relationship qpr, qa_plans qp

Line 1073: l_search_array := qa_txn_grp.result_to_array(p_search_str);

1069: RETURN '';
1070: END IF;
1071:
1072: --parse the search criteria into an array
1073: l_search_array := qa_txn_grp.result_to_array(p_search_str);
1074:
1075: --loop over possible parent plans, checking each one
1076: FOR l_plan_rec IN l_plans_cursor LOOP
1077: l_applicable := is_plan_applicable(l_plan_rec.parent_plan_id,