apexir_delete_help_message.sql

declare
    l_names apex_t_varchar2;
    l_aid number := APP_ID; -- APP_IDは変更する。
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'
    );
    for c in (
        select
        translation_entry_id
        from apex_application_translations
        where application_id = l_aid
          and language_code = 'ja'
          and translatable_message in (select column_value from table(l_names))
    )
    loop
        apex_lang.delete_message(
            p_id => c.translation_entry_id
        );
    end loop;
end;