DBA Data[Home] [Help]

APPS.QA_RESULTS_WF_PKG dependencies on QA_PLANS

Line 161: l_template_plan_id QA_PLANS.TEMPLATE_PLAN_ID%TYPE;

157:
158: IS
159: url_string VARCHAR2(1000);
160: l_plan_id VARCHAR2(1000);
161: l_template_plan_id QA_PLANS.TEMPLATE_PLAN_ID%TYPE;
162: l_collection_id NUMBER;
163: l_occurrence NUMBER;
164: extension VARCHAR2(5);
165: search_clause VARCHAR2(1000);

Line 175: from qa_plans

171: PCTXT_HGRID_SEARCH_CLAUSE VARCHAR2(250) := PCTXT_VAR_PREFIX || 'HgridSearchClauseStr';
172: PCTXT_HGRID_SEARCH_VARS VARCHAR2(250) := PCTXT_VAR_PREFIX || 'HgridSearchVarsStr';
173: cursor c(p_plan_id VARCHAR2) is
174: select template_plan_id
175: from qa_plans
176: where plan_id = p_plan_id;
177:
178:
179: BEGIN