Cacher is the code snippet organizer for pro developers

begin
for c1 in (select workspace_id from apex_workspaces where workspace = 'MIGRATIONFACTORY') 
loop
        apex_util.set_security_group_id( c1.workspace_id );
end loop;

-- Now, seed the translation repository
 apex_lang.seed_translations(
        p_application_id => 1200,
        p_language => 'fr-ch' );
		
 apex_lang.seed_translations(
        p_application_id => 1200,
        p_language => 'it-ch' );		
end;

-- APEX Repository aktualisieren für RECON
declare
 c_release constant varchar2(20) := '171207';
begin

for c1 in (select de, fr, it from transl_repos where release = c_release)
loop
update APEX_050000.wwv_flow_translatable_text$ set TRANSLATE_TO_TEXT = c1.fr
where TO_CHAR(SUBSTR(TRANSLATE_FROM_TEXT, 1, 4000)) = c1.de
and translated_flow_id = 1201;
end loop;


for c2 in (select de, fr, it from transl_repos where release = c_release)
loop
update APEX_050000.wwv_flow_translatable_text$ set TRANSLATE_TO_TEXT = c2.it
where TO_CHAR(SUBSTR(TRANSLATE_FROM_TEXT, 1, 4000)) = c2.de
and translated_flow_id = 1202;
end loop;

commit;
end;


begin
for c1 in (select workspace_id from apex_workspaces where workspace = 'MIGRATIONFACTORY') 
loop
        apex_util.set_security_group_id( c1.workspace_id );
end loop;

apex_lang.publish_application(
        p_application_id => 1200,
        p_language => 'fr-ch' );		

apex_lang.publish_application(
        p_application_id => 1200,
        p_language => 'it-ch' );		
end;