apex_lang.create_messageを出力する

apexir_generate_help_script.sql

declare
    l_names apex_t_varchar2;
begin
    l_names := apex_t_varchar2(
        'APEXIR_INTERACTIVE_REPORT_HELP'
       ,'APEXIR_HELP_01'
       ,'APEXIR_DATA_GRID_HELP'
       ,'APEXIR_HELP_WS_01'
       ,'APEXIR_SEARCH_BAR'
       ,'APEXIR_HELP_SEARCH_BAR'
       ,'APEXIR_HELP_SEARCH_BAR_FINDER'
       ,'APEXIR_HELP_SEARCH_BAR_TEXTBOX'
       ,'APEXIR_HELP_SEARCH_BAR_REPORTS'
       ,'APEXIR_HELP_SEARCH_BAR_VIEW'
       ,'APEXIR_HELP_SEARCH_BAR_ROWS'
       ,'APEXIR_HELP_SEARCH_BAR_ACTIONS_MENU'
       ,'APEXIR_HELP_SEARCH_BAR_WS_MANAGE'
       ,'APEXIR_ACTIONS_MENU'
       ,'APEXIR_HELP_ACTIONS_MENU'
       ,'APEXIR_HELP_WS_ACTIONS_MENU'
       ,'APEXIR_SELECT_COLUMNS'
       ,'APEXIR_HELP_SELECT_COLUMNS'
       ,'APEXIR_FILTER'
       ,'APEXIR_HELP_FILTER'
       ,'APEXIR_ROWS_PER_PAGE'
       ,'APEXIR_HELP_ROWS_PER_PAGE'
       ,'APEXIR_FORMAT'
       ,'APEXIR_HELP_FORMAT'
       ,'APEXIR_SORT'
       ,'APEXIR_HELP_SORT'
       ,'APEXIR_CONTROL_BREAK'
       ,'APEXIR_HELP_CONTROL_BREAK'
       ,'APEXIR_HELP_WS_CONTROL_BREAK'
       ,'APEXIR_HIGHLIGHT'
       ,'APEXIR_HELP_HIGHLIGHT'
       ,'APEXIR_COMPUTE'
       ,'APEXIR_HELP_COMPUTE'
       ,'APEXIR_AGGREGATE'
       ,'APEXIR_HELP_AGGREGATE'
       ,'APEXIR_CHART'
       ,'APEXIR_HELP_CHART'
       ,'APEXIR_GROUP_BY'
       ,'APEXIR_HELP_GROUP_BY'
       ,'APEXIR_PIVOT'
       ,'APEXIR_HELP_PIVOT'
       ,'APEXIR_FLASHBACK'
       ,'APEXIR_HELP_FLASHBACK'
       ,'APEXIR_SAVE_REPORT'
       ,'APEXIR_HELP_SAVE_REPORT'
       ,'APEXIR_HELP_WS_SAVE_REPORT'
       ,'APEXIR_RESET'
       ,'APEXIR_HELP_RESET'
       ,'APEXIR_DOWNLOAD'
       ,'APEXIR_HELP_DOWNLOAD'
       ,'APEXIR_HELP_WS_DOWNLOAD'
       ,'APEXIR_SUBSCRIPTION'
       ,'APEXIR_HELP_SUBSCRIPTION'
       ,'APEXIR_COLUMN_HEADING_MENU'
       ,'APEXIR_HELP_COLUMN_HEADING_MENU'
       ,'APEXIR_DETAIL_VIEW'
       ,'APEXIR_HELP_DETAIL_VIEW'
       ,'APEXIR_HELP_WS_ADD_EDIT'
       ,'APEXIR_HELP_WS_ADD_EDIT_ROW'
       ,'APEXIR_REPORT_SETTINGS'
       ,'APEXIR_HELP_REPORT_SETTINGS'
       ,'APEXIR_HELP_WS_REPORT_SETTINGS'
    );
    dbms_output.put_line('declare');
    dbms_output.put_line('  l_aid number := APP_ID;');
    dbms_output.put_line('  l_n varchar2(4000);');
    dbms_output.put_line('  l_l varchar2(80);');
    dbms_output.put_line('  l_m varchar2(4000);');
    dbms_output.put_line('  l_j boolean;');
    dbms_output.put_line('begin');
    for c in (
        select
            id
          , name
          , message_language
          , message_text
          , is_js_message
        from wwv_flow_messages$
        where name in (select column_value from table(l_names))
          and message_language = 'ja'
          and flow_id = 4479
    )
    loop
       dbms_output.put_line('l_n := q''~' || c.name || '~'';');
       dbms_output.put_line('l_l := q''~' || c.message_language || '~'';');
       dbms_output.put_line('l_m := q''~' || c.message_text || '~'';');
       if c.is_js_message = 'Y' then
           dbms_output.put_line('l_j := FALSE;');
       else
           dbms_output.put_line('l_j := TRUE;');
       end if;
       dbms_output.put_line('apex_lang.create_message(l_aid,l_n,l_l,l_m,l_j);');
    end loop;
    dbms_output.put_line('end;');
end; 
/