   p_process_type=> 'PLSQL',
   p_process_name=> 'SetAllQuiet',
   p_process_sql_clob => p,
-  p_process_error_message=> 'Failed to set modules to Debug mode.',
+  p_process_error_message=> 'Failed to set &P9_OWNER. modules to Quiet mode.',
   p_error_display_location=> 'INLINE_IN_NOTIFICATION',
   p_process_when_button_id=>3520316226535807 + wwv_flow_api.g_id_offset,
   p_only_for_changed_rows=> 'Y',
-  p_process_success_message=> 'All Modules are now in Quiet mode.  No Processes will start.',
+  p_process_success_message=> 'All &P9_OWNER. Modules are now in Quiet mode.  No Processes will start.',
   p_process_is_stateful_y_n=>'N',
   p_process_comment=>'');
 end;

  p_process_type=> 'PLSQL',
  p_process_name=> 'SetAllDebug',
  p_process_sql_clob => p,
  p_process_error_message=> 'Failed to set modules to Debug mode.',
  p_error_display_location=> 'INLINE_IN_NOTIFICATION',
  p_process_when_button_id=>3520722937547217 + wwv_flow_api.g_id_offset,
  p_only_for_changed_rows=> 'Y',
  p_process_success_message=> 'All Modules are now in Debug mode. Open Process settings are unchanged.',
  p_process_is_stateful_y_n=>'N',
  p_process_comment=>'');
end;

end;
/

declare
    h varchar2(32767) := null;
begin
wwv_flow_api.create_page_item(
  p_id=>3589424059123700 + wwv_flow_api.g_id_offset,
  p_flow_id=> wwv_flow.g_flow_id,
  p_flow_step_id=> 9,
  p_name=>'P9_OWNER',
  p_data_type=> 'VARCHAR',
  p_is_required=> false,
  p_accept_processing=> 'REPLACE_EXISTING',
  p_item_sequence=> 2,
  p_item_plug_id => 17797158749021547+wwv_flow_api.g_id_offset,
  p_use_cache_before_default=> 'YES',
  p_item_default_type=> 'STATIC_TEXT_WITH_SUBSTITUTIONS',
  p_prompt=>'Owner',
  p_source=>'select min(owner) from ms_module where owner <> ''LOGGER''',
  p_source_type=> 'QUERY',
  p_display_as=> 'NATIVE_SELECT_LIST',
  p_lov=> 'select DISTINCT initcap(OWNER) display, OWNER value'||unistr('\000a')||
'from MS_MODULE'||unistr('\000a')||
'',
  p_lov_display_null=> 'NO',
  p_lov_translated=> 'N',
  p_cSize=> 30,
  p_cMaxlength=> 4000,
  p_cHeight=> 1,
  p_new_grid=> false,
  p_begin_on_new_line=> 'YES',
  p_begin_on_new_field=> 'YES',
  p_colspan=> null,
  p_rowspan=> null,
  p_grid_column=> null,
  p_label_alignment=> 'RIGHT',
  p_field_alignment=> 'LEFT-CENTER',
  p_field_template=> 17759655087931450+wwv_flow_api.g_id_offset,
  p_is_persistent=> 'Y',
  p_lov_display_extra=>'NO',
  p_protection_level => 'N',
  p_escape_on_http_output => 'Y',
  p_attribute_01 => 'SUBMIT',
  p_attribute_03 => 'N',
  p_show_quick_picks=>'N',
  p_item_comment => '');
 
 
end;
/

 
begin
 
