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.2 2005/12/19 04:00:27 srhariha 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 153: p_search_array IN qa_txn_grp.ElementsArray)

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

Line 885: search_array IN qa_txn_grp.ElementsArray)

881:
882:
883: FUNCTION is_plan_applicable (
884: p_plan_id IN NUMBER,
885: search_array IN qa_txn_grp.ElementsArray)
886: RETURN VARCHAR2
887: IS
888: security_profile NUMBER;
889: allow VARCHAR2(1) := 'T';

Line 937: search_array qa_txn_grp.ElementsArray;

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

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

953: || ' AND collection_id = '||p_collection_id
954: || ' AND occurrence = ' || p_occurrence;
955: else
956:
957: search_array := qa_txn_grp.result_to_array(p_search_str);
958:
959: WhereClause := get_where_clause(p_plan_id, search_array);
960: end if; --for direct link embedding in if clause
961:

Line 1048: l_search_array qa_txn_grp.ElementsArray;

1044: l_plan_ids VARCHAR2(2000) := '';
1045: l_plan_seen BOOLEAN := false;
1046: l_plan_separator VARCHAR2(1) := ',';
1047: l_applicable VARCHAR2(1);
1048: l_search_array qa_txn_grp.ElementsArray;
1049:
1050: cursor l_plans_cursor IS
1051: select distinct qpr.parent_plan_id
1052: from qa_pc_plan_relationship qpr, qa_plans qp

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

1058: RETURN '';
1059: END IF;
1060:
1061: --parse the search criteria into an array
1062: l_search_array := qa_txn_grp.result_to_array(p_search_str);
1063:
1064: --loop over possible parent plans, checking each one
1065: FOR l_plan_rec IN l_plans_cursor LOOP
1066: l_applicable := is_plan_applicable(l_plan_rec.parent_plan_id,