APPS.QA_JRAD_PKG dependencies on QA_PLANS

Line 806: l_plan_name qa_plans.name%TYPE;

802: p_plan_id IN NUMBER) RETURN JDR_DOCBUILDER.ELEMENT IS
803:
804: l_region_style VARCHAR2(30);
805: l_row_id VARCHAR2(30);
806: l_plan_name qa_plans.name%TYPE;
807: topLevel JDR_DOCBUILDER.ELEMENT := NULL;
808:
809: l_prompt VARCHAR2(30);
810:

Line 812: SELECT NAME from qa_plans

808:
809: l_prompt VARCHAR2(30);
810:
811: CURSOR c IS
812: SELECT NAME from qa_plans
813: WHERE plan_id = p_plan_id;
814:
815: BEGIN
816:

Line 2092: FROM QA_PLANS

2088: -- bso Sun Nov 6 16:52:53 PST 2005
2089: --
2090: CURSOR jrad_doc_ver_cur IS
2091: SELECT jrad_doc_ver
2092: FROM QA_PLANS
2093: WHERE PLAN_ID = p_plan_id;
2094:
2095: BEGIN
2096:

Line 2228: UPDATE QA_PLANS

2224: --in that call check for isp and make appropriate map calls
2225: END IF;
2226:
2227: IF (p_jrad_doc_ver IS NULL) THEN
2228: UPDATE QA_PLANS
2229: SET JRAD_DOC_VER = l_jrad_doc_ver
2230: WHERE PLAN_ID = p_plan_id;
2231: ELSE
2232: NULL; --dont update here...calling procedure will update

Line 2274: FROM qa_plans

2270: -- bso Sun Nov 6 17:34:31 PST 2005
2271: --
2272: SELECT jrad_upgrade_ver
2273: INTO l_jrad_upgrade_ver
2274: FROM qa_plans
2275: WHERE plan_id = p_plan_id
2276: FOR UPDATE;
2277:
2278: SELECT jrad_upgrade_ver

Line 2280: FROM qa_plans

2276: FOR UPDATE;
2277:
2278: SELECT jrad_upgrade_ver
2279: INTO l_seed_ver
2280: FROM qa_plans
2281: WHERE plan_id = qa_ss_const.JRAD_UPGRADE_PLAN;
2282:
2283: IF l_jrad_upgrade_ver IS NULL OR
2284: l_jrad_upgrade_ver < l_seed_ver THEN

Line 2296: FROM qa_plans

2292: -- jrad_doc_ver number, now re-check Jrad Doc Ver
2293: --
2294: SELECT jrad_doc_ver
2295: INTO l_jrad_doc_ver
2296: FROM qa_plans
2297: WHERE plan_id = p_plan_id;
2298:
2299: IF l_jrad_doc_ver IS NULL THEN
2300: map_plan(p_plan_id);