set define '^'
set verify off


Rem
Rem    MODIFIED   (MM/DD/YYYY)
Rem    pawolf      04/08/2009 - Created - patch file for bug (8415325)


declare
    s varchar2(32767);
begin
    wwv_flow_security.g_security_group_id := 10;

    s:=s||'select htf.anchor(''f?p=4000:4651:''||:flow_session||''::NO::F4000_P4651_ID:''||ID,'||chr(10)||
    '  ''<img src="#IMAGE_PREFIX#e2.gif" border="0" height="18" width="18" alt="&EDIT." title="&EDIT." />'') edit_link,'||chr(10)||
    '  plug_display_sequence, '||chr(10)||
    '  plug_display_column, '||chr(10)||
    '  plug_name,  '||chr(10)||
    '  nvl(plug_template,0) plug_template,'||chr(10)||
    'nvl(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(plug_source_';
    
    s:=s||'type,''0'',''''),''1'',''''),''2'',''''),''3'',''''),''4'',''''),''5'',''''),''6'',''''),''7'',''''),''8'',''''),''9'',''''),''M'',''MENU''),''LIST'') plug_source_type,'||chr(10)||
    '  (select count(*)'||chr(10)||
    '     from wwv_flow_step_items i'||chr(10)||
    '    where i.flow_id      = p.flow_id'||chr(10)||
    '      and i.flow_step_id = p.page_id'||chr(10)||
    '      and i.item_plug_id = p.id) item_count,'||chr(10)||
    '  (select count(*)'||chr(10)||
    '     from wwv_flow_step_buttons b'||chr(10)||
    '    where b.flow_id        = p.flow_id'||chr(10)||
    '      and b.flo';
    
    s:=s||'w_step_id   = p.page_id'||chr(10)||
    '      and b.button_plug_id = p.id) button_count,'||chr(10)||
    '  plug_display_point,'||chr(10)||
    '  id,'||chr(10)||
    '  decode(PLUG_DISPLAY_CONDITION_TYPE,null,null,''<img src="#IMAGE_PREFIX#check_small_black.gif" border="0" height="15" width="15" alt="">'') conditional,'||chr(10)||
    'last_updated_on'||chr(10)||
    ' from wwv_flow_page_plugs p'||chr(10)||
    'where flow_id = :FB_FLOW_ID'||chr(10)||
    '  and page_id = :FB_FLOW_PAGE_ID'||chr(10)||
    'order by plug_display_column, plug_display';
    
    s:=s||'_sequence';
    update wwv_flow_page_plugs
       set plug_source = s
     where id >= 418707548
       and id  < 418707548 + 1
       and flow_id between 4000 and 4009
       and page_id >= 4650
       and page_id  < 4650 + 1
    ;
    commit;
end;
/