882: where criteria_id = x_criteria_id;
883:
884: cursor char_names is
885: select name
886: from qa_chars
887: where char_id in (10, 11, 13, 26, 121, 122, 130)
888: order by char_id;
889:
890:
887: where char_id in (10, 11, 13, 26, 121, 122, 130)
888: order by char_id;
889:
890:
891: x_supplier qa_chars.name%type;
892: x_supplier_site qa_chars.name%type;
893: x_item qa_chars.name%type;
894: x_rev qa_chars.name%type;
895: x_cat qa_chars.name%type;
888: order by char_id;
889:
890:
891: x_supplier qa_chars.name%type;
892: x_supplier_site qa_chars.name%type;
893: x_item qa_chars.name%type;
894: x_rev qa_chars.name%type;
895: x_cat qa_chars.name%type;
896: x_project qa_chars.name%type;
889:
890:
891: x_supplier qa_chars.name%type;
892: x_supplier_site qa_chars.name%type;
893: x_item qa_chars.name%type;
894: x_rev qa_chars.name%type;
895: x_cat qa_chars.name%type;
896: x_project qa_chars.name%type;
897: x_task qa_chars.name%type;
890:
891: x_supplier qa_chars.name%type;
892: x_supplier_site qa_chars.name%type;
893: x_item qa_chars.name%type;
894: x_rev qa_chars.name%type;
895: x_cat qa_chars.name%type;
896: x_project qa_chars.name%type;
897: x_task qa_chars.name%type;
898:
891: x_supplier qa_chars.name%type;
892: x_supplier_site qa_chars.name%type;
893: x_item qa_chars.name%type;
894: x_rev qa_chars.name%type;
895: x_cat qa_chars.name%type;
896: x_project qa_chars.name%type;
897: x_task qa_chars.name%type;
898:
899: x_criteria_str varchar2(2000) := '';
892: x_supplier_site qa_chars.name%type;
893: x_item qa_chars.name%type;
894: x_rev qa_chars.name%type;
895: x_cat qa_chars.name%type;
896: x_project qa_chars.name%type;
897: x_task qa_chars.name%type;
898:
899: x_criteria_str varchar2(2000) := '';
900: x_vendor_name varchar2(240);
893: x_item qa_chars.name%type;
894: x_rev qa_chars.name%type;
895: x_cat qa_chars.name%type;
896: x_project qa_chars.name%type;
897: x_task qa_chars.name%type;
898:
899: x_criteria_str varchar2(2000) := '';
900: x_vendor_name varchar2(240);
901: x_vendor_site_code varchar2(100);