DBA Data[Home] [Help]

APPS.QA_FLEX_UTIL dependencies on QA_PLAN_CHARS

Line 556: -- To maintain a cache for the qa_plan_chars table.

552: --
553:
554: PROCEDURE qpc_fetch(x_plan_id number, x_char_id number) IS
555: --
556: -- To maintain a cache for the qa_plan_chars table.
557: --
558: CURSOR c IS
559: SELECT result_column_name, values_exist_flag
560: FROM qa_plan_chars

Line 560: FROM qa_plan_chars

556: -- To maintain a cache for the qa_plan_chars table.
557: --
558: CURSOR c IS
559: SELECT result_column_name, values_exist_flag
560: FROM qa_plan_chars
561: WHERE plan_id = x_plan_id AND
562: char_id = x_char_id;
563: BEGIN
564: --

Line 591: -- Return the result_column_name from qa_plan_chars given a plan_id

587:
588: FUNCTION qpc_result_column_name(x_plan_id number, x_char_id number)
589: RETURN varchar2 IS
590: --
591: -- Return the result_column_name from qa_plan_chars given a plan_id
592: -- and a char_id. Return null if not found.
593: -- bso
594: --
595: BEGIN

Line 604: -- Return qpc_values_exist_flag (an integer) from qa_plan_chars given a

600:
601: FUNCTION qpc_values_exist_flag(x_plan_id number, x_char_id number)
602: RETURN number IS
603: --
604: -- Return qpc_values_exist_flag (an integer) from qa_plan_chars given a
605: -- plan_id and a char_id. Return null if not found.
606: -- bso
607: --
608: BEGIN