APPS.QA_JRAD_PKG dependencies on QA_PLANS

Line 836: l_plan_name qa_plans.name%TYPE;

832: p_plan_id IN NUMBER) RETURN JDR_DOCBUILDER.ELEMENT IS
833:
834: l_region_style VARCHAR2(30);
835: l_row_id VARCHAR2(30);
836: l_plan_name qa_plans.name%TYPE;
837: topLevel JDR_DOCBUILDER.ELEMENT := NULL;
838:
839: l_prompt VARCHAR2(30);
840:

Line 842: SELECT NAME from qa_plans

838:
839: l_prompt VARCHAR2(30);
840:
841: CURSOR c IS
842: SELECT NAME from qa_plans
843: WHERE plan_id = p_plan_id;
844:
845: BEGIN
846:

Line 2196: FROM QA_PLANS

2192: -- bso Sun Nov 6 16:52:53 PST 2005
2193: --
2194: CURSOR jrad_doc_ver_cur IS
2195: SELECT jrad_doc_ver
2196: FROM QA_PLANS
2197: WHERE PLAN_ID = p_plan_id;
2198:
2199: BEGIN
2200:

Line 2332: UPDATE QA_PLANS

2328: --in that call check for isp and make appropriate map calls
2329: END IF;
2330:
2331: IF (p_jrad_doc_ver IS NULL) THEN
2332: UPDATE QA_PLANS
2333: SET JRAD_DOC_VER = l_jrad_doc_ver
2334: WHERE PLAN_ID = p_plan_id;
2335: ELSE
2336: NULL; --dont update here...calling procedure will update

Line 2378: FROM qa_plans

2374: -- bso Sun Nov 6 17:34:31 PST 2005
2375: --
2376: SELECT jrad_upgrade_ver
2377: INTO l_jrad_upgrade_ver
2378: FROM qa_plans
2379: WHERE plan_id = p_plan_id
2380: FOR UPDATE;
2381:
2382: SELECT jrad_upgrade_ver

Line 2384: FROM qa_plans

2380: FOR UPDATE;
2381:
2382: SELECT jrad_upgrade_ver
2383: INTO l_seed_ver
2384: FROM qa_plans
2385: WHERE plan_id = qa_ss_const.JRAD_UPGRADE_PLAN;
2386:
2387: IF l_jrad_upgrade_ver IS NULL OR
2388: l_jrad_upgrade_ver < l_seed_ver THEN

Line 2400: FROM qa_plans

2396: -- jrad_doc_ver number, now re-check Jrad Doc Ver
2397: --
2398: SELECT jrad_doc_ver
2399: INTO l_jrad_doc_ver
2400: FROM qa_plans
2401: WHERE plan_id = p_plan_id;
2402:
2403: IF l_jrad_doc_ver IS NULL THEN
2404: map_plan(p_plan_id);