--
-- Created by aegrumet@alum.mit.edu on 2002-06-24.
-- 
-- This is a temporary workaround to ensure that
-- fs_contents_portlets get renamed properly.
--

create or replace trigger fs_cont_port_fldr_rnme_tr
after update on cr_folders
for each row
begin

  for row in (select m.element_id
              from portal_element_map m,
              portal_element_parameters p
	      where p.key = 'folder_id'
                and p.value = :new.folder_id
                and m.element_id = p.element_id
                and m.name = 'fs_contents_portlet') loop

    update portal_element_map
    set pretty_name = :new.label
    where element_id = row.element_id;

  end loop;


end fs_cont_port_fldr_rnme_tr;
/
show errors