109: IF p_qualifier_attr_context = 'MODLIST' THEN
110: IF p_qualifier_attr = 'QUALIFIER_ATTRIBUTE4' THEN
111: begin
112: SELECT name into item_id
113: FROM QP_LIST_HEADERS_TL
114: WHERE list_header_id=p_qualifier_attr_val and language='US';
115: RETURN item_id;--Conversion to code in case of pricelist.
116: EXCEPTION WHEN OTHERS THEN
117: RETURN NULL;
140: IF p_qualifier_attr_context = 'MODLIST' THEN
141: IF p_qualifier_attr = 'QUALIFIER_ATTRIBUTE4' THEN
142: begin
143: SELECT list_header_id into item_id
144: FROM QP_LIST_HEADERS_TL
145: WHERE name=p_qualifier_attr_val and rownum=1;
146: RETURN item_id;--Conversion to value in case of pricelist.
147: EXCEPTION WHEN OTHERS THEN
148: RETURN NULL;
273: AND B.LANGUAGE = RA.LANGUAGE(+)
274: AND B.VERSIONNO IS NULL
275: AND
276: NOT EXISTS (SELECT 1
277: FROM QP_LIST_HEADERS_TL TL3
278: WHERE B.NAME = TL3.NAME
279: AND TL3.VERSION_NO IS NULL);
280:
281: CURSOR qp_modifier_list_line_CUR (mListHeaderId Number) IS