APPS.QA_MQA_PLAN_ELEMENTS dependencies on QA_PLANS

Line 364: x_name qa_plans.name%TYPE;

360: FUNCTION get_plan_name(x_plan_id IN NUMBER) RETURN VARCHAR2 IS
361: --
362: -- Return a plan name given a plan ID.
363: --
364: x_name qa_plans.name%TYPE;
365: BEGIN
366: SELECT name INTO x_name
367: FROM qa_plans
368: WHERE plan_id = x_plan_id;

Line 367: FROM qa_plans

363: --
364: x_name qa_plans.name%TYPE;
365: BEGIN
366: SELECT name INTO x_name
367: FROM qa_plans
368: WHERE plan_id = x_plan_id;
369:
370: RETURN x_name;
371: END get_plan_name;

Line 380: x_type qa_plans.spec_assignment_type%TYPE;

376:
377: --
378: -- Return a spec type and spec type name given a plan ID.
379: --
380: x_type qa_plans.spec_assignment_type%TYPE;
381: x_type_name VARCHAR2(30);
382:
383: BEGIN
384: SELECT spec_assignment_type INTO x_type

Line 385: FROM qa_plans

381: x_type_name VARCHAR2(30);
382:
383: BEGIN
384: SELECT spec_assignment_type INTO x_type
385: FROM qa_plans
386: WHERE plan_id = p_plan_id;
387:
388: SELECT meaning into x_spec_type_name
389: FROM mfg_lookups