DBA Data[Home] [Help]

APPS.QA_SKIPLOT_RES_ENGINE dependencies on QA_PLAN_CHARS

Line 354: res_col qa_plan_chars.result_column_name%type;

350: function get_result_column(
351: p_plan_id in number) return varchar2 is
352:
353: col_ref qa_skiplot_utility.refCursorTyp;
354: res_col qa_plan_chars.result_column_name%type;
355:
356: begin
357: open col_ref for
358: 'select result_column_name

Line 359: from qa_plan_chars

355:
356: begin
357: open col_ref for
358: 'select result_column_name
359: from qa_plan_chars
360: where plan_id = :1 and
361: char_id = 8'
362: using p_plan_id;
363:

Line 413: result_column qa_plan_chars.result_column_name%type;

409: p_accepted_qty out NOCOPY number,
410: p_rejected_qty out NOCOPY number) return varchar2 is
411:
412: in_str varchar2(3000);
413: result_column qa_plan_chars.result_column_name%type;
414: sql_str varchar2(5000);
415: result varchar2(100);
416: insp_qty number;
417: accept_qty number;