set define '^'

Rem
Rem    MODIFIED   (MM/DD/YYYY)
Rem    hfarrell   03/19/2009 - Created patch file for bug (8349919)


declare
    p  varchar2(32767) := null;
    s  varchar2(32767) := null;
    h  varchar2(32767) := null;
    t  varchar2(32767) := null;
begin
    wwv_flow_security.g_security_group_id := 10;
    
    p:=p||'begin'||chr(10)||
''||chr(10)||
'    update '||chr(10)||
'        WWV_FLOW_MODEL_PAGE_REGIONS'||chr(10)||
'    set '||chr(10)||
'        LINK_COLUMN = :P47_LINK_COLUMN,'||chr(10)||
'        LINK_TEXT = :P47_LINK_TEXT,'||chr(10)||
'        PARENT_LINK_FROM_COLUMN1 = :P47_PARENT_LINK_FROM_COLUMN1,'||chr(10)||
'        LINK_TO_COLUMN1 = :P47_LINK_TO_COLUMN1'||chr(10)||
'    where '||chr(10)||
'        MODEL_PAGE_ID = :P47_ID'||chr(10)||
'    and '||chr(10)||
'        SECURITY_GROUP_ID = :flow_security_group_id;'||chr(10)||
''||chr(10)||
'end;';

    update wwv_flow_step_processing
    set    process_sql_clob = p
    where  flow_id between 4400 and 4409 
    and    flow_step_id >= 47
    and    flow_step_id < 47 + 1
    and    id >= 150169618317371848
    and    id < 150169618317371848 + 1;


    s:=s||'begin'||chr(10)||
    ''||chr(10)||
'update WWV_FLOW_MODEL_PAGE_REGIONS'||chr(10)||
'    set PARENT_LINK_FROM_COLUMN2 = :P47_PARENT_LINK_FROM_COLUMN2,'||chr(10)||
'    LINK_TO_COLUMN2 = :P47_LINK_TO_COLUMN2'||chr(10)||
'    where MODEL_PAGE_ID = :P47_ID'||chr(10)||
'    and SECURITY_GROUP_ID = :flow_security_group_id;'||chr(10)||
''||chr(10)||
'end;';

    update wwv_flow_step_processing
    set    process_sql_clob = s
    where  flow_id between 4400 and 4409 
    and    flow_step_id >= 47
    and    flow_step_id < 47 + 1
    and    id >= 150170604942377470
    and    id < 150170604942377470 + 1;



    h:=h||'begin'||chr(10)||
''||chr(10)||
'    update '||chr(10)||
'        WWV_FLOW_MODEL_PAGE_REGIONS'||chr(10)||
'    set '||chr(10)||
'        LINK_COLUMN = :P11_LINK_COLUMN,'||chr(10)||
'        LINK_TEXT = :P11_LINK_TEXT,'||chr(10)||
'        PARENT_LINK_FROM_COLUMN1 = :P11_PARENT_LINK_FROM_COLUMN1,'||chr(10)||
'        LINK_TO_COLUMN1 = :P11_LINK_TO_COLUMN1'||chr(10)||
'    where '||chr(10)||
'        MODEL_PAGE_ID = :P11_ID'||chr(10)||
'    and '||chr(10)||
'        SECURITY_GROUP_ID = :flow_security_group_id;'||chr(10)||
''||chr(10)||
'end;';

    update wwv_flow_step_processing
    set    process_sql_clob = h,
           process_when = 'P11_PARENT_PAGE_ID'
    where  flow_id between 4400 and 4409 
    and    flow_step_id >= 11
    and    flow_step_id < 11 + 1
    and    id >= 150171726759383753
    and    id < 150171726759383753 + 1;


    t:=t||'begin'||chr(10)||
    ''||chr(10)||
'update WWV_FLOW_MODEL_PAGE_REGIONS'||chr(10)||
'    set PARENT_LINK_FROM_COLUMN2 = :P11_PARENT_LINK_FROM_COLUMN2,'||chr(10)||
'    LINK_TO_COLUMN2 = :P11_LINK_TO_COLUMN2'||chr(10)||
'    where MODEL_PAGE_ID = :P11_ID'||chr(10)||
'    and SECURITY_GROUP_ID = :flow_security_group_id;'||chr(10)||
''||chr(10)||
'end;';

    update wwv_flow_step_processing
    set    process_sql_clob = t,
           process_type = 'PLSQL',
           process_error_message = null,
           process_when = 'if (:P11_PARENT_LINK_FROM_COLUMN2 IS NOT NULL) and (:P11_LINK_TO_COLUMN IS NOT NULL) and (:P11_PARENT_PAGE_ID IS NOT NULL)',
           process_success_message = null
    where  flow_id between 4400 and 4409 
    and    flow_step_id >= 11
    and    flow_step_id < 11 + 1
    and    id >= 150172305766387130
    and    id < 150172305766387130 + 1;


    commit;

end;
/