set define '^'

Rem
Rem    MODIFIED   (MM/DD/YYYY)
Rem    hfarrell   03/12/2009 - Created patch file for bug (8338787)
Rem    jkallman   04/10/2009 - Correct "set define"


declare
    ph varchar2(32767) := null;
    h  varchar2(32767) := null;
begin
    wwv_flow_security.g_security_group_id := 10;
    
    ph:=ph||'<script language="javascript">'||chr(10)||
'   function copy_custom() {'||chr(10)||
'      $s(''P77_CUSTOM_QUERY'',$v(''P77_ORIGINAL_QUERY''));'||chr(10)||
'   }'||chr(10)||
''||chr(10)||
'   function copy_enhanced() {'||chr(10)||
'      $s(''P77_CUSTOM_QUERY'',$v(''P77_ENHANCED_QUERY''));'||chr(10)||
'   }'||chr(10)||
'</script>';

    update wwv_flow_steps 
    set    html_page_header = ph, 
           html_page_onload = null,
           first_item = 'AUTO_FIRST_ITEM'
    where  flow_id between 4400 and 4409 
    and    name = 'Block Details'
    and    id >= 77
    and    id < 77 + 1;


    h := h||'</pre>'||chr(10)||
'   <a href="javascript:copy_enhanced();"  class="htmldbPageEditButtons">'||chr(10)||
'   <img src="#IMAGE_PREFIX#htmldb/icons/copy_small.gif"/></a>';

    update wwv_flow_step_items
    set    pre_element_text = '<pre class="code_text">',
           post_element_text = h,
           read_only_when_type = 'ALWAYS'
    where  flow_id between 4400 and 4409
    and id >= 71623520929952255
    and id < 71623520929952255 + 1; 


    commit;

end;
/  

set define '^'