APPS.QA_CORE_PKG dependencies on QA_PLANS

Line 112: from qa_plans

108:
109: BEGIN
110:
111: select plan_id into ID
112: from qa_plans
113: where Name = PLAN_NAME;
114:
115: return ID;
116:

Line 133: /* Bug 3754667. We would use the cache implementation in qa_plans_api

129: PLAN_NAME VARCHAR2(240);
130:
131: BEGIN
132:
133: /* Bug 3754667. We would use the cache implementation in qa_plans_api
134: rather than fetching plan_name from DB each time. kabalakr
135:
136: select name into PLAN_NAME
137: from qa_plans

Line 137: from qa_plans

133: /* Bug 3754667. We would use the cache implementation in qa_plans_api
134: rather than fetching plan_name from DB each time. kabalakr
135:
136: select name into PLAN_NAME
137: from qa_plans
138: where plan_id = GIVEN_PLAN_ID;
139: */
140:
141: PLAN_NAME := qa_plans_api.plan_name(GIVEN_PLAN_ID);

Line 141: PLAN_NAME := qa_plans_api.plan_name(GIVEN_PLAN_ID);

137: from qa_plans
138: where plan_id = GIVEN_PLAN_ID;
139: */
140:
141: PLAN_NAME := qa_plans_api.plan_name(GIVEN_PLAN_ID);
142:
143: return PLAN_NAME;
144:
145: EXCEPTION when others then