178: l_concat_prod_fam varchar2(200) := '';
179:
180: cursor c1(l_product_abbr varchar2) is
181: select product_name
182: from ad_pm_prod_family_map appfm, ad_pm_product_info appi
183: where appfm.product_family_abbreviation = appi.product_abbreviation
184: and appfm.product_abbreviation = l_product_abbr;
185:
186: begin
201: l_concat_prod_fam varchar2(200) := '';
202:
203: cursor c1(l_product_abbr varchar2) is
204: select product_family_abbreviation
205: from ad_pm_prod_family_map appfm
206: where appfm.product_abbreviation = l_product_abbr;
207:
208: begin
209: