
-------------------------------------------------------------
prompt RM irid population triggers
--
-- Only needed when migrating configuration meta data into
-- core schema, to populate extra irid column
-------------------------------------------------------------

create or replace trigger rm$element_type_exts_irid
 before insert on i$rm$element_type_extensions
 for each row
 begin
  if :new.irid is null then
    :new.irid := jr_util.get_new_irid;
  end if;
 end rm$element_type_exts_irid;
/

create or replace trigger rm$nls_data_type_values_irid
 before insert on i$rm$nls_data_type_values
 for each row
 begin
  if :new.irid is null then
    :new.irid := jr_util.get_new_irid;
  end if;
 end rm$nls_data_type_values_irid;
/

create or replace trigger rm$nls_element_types_irid
 before insert on i$rm$nls_element_types
 for each row
 begin
  if :new.irid is null then
    :new.irid := jr_util.get_new_irid;
  end if;
 end rm$nls_element_types_irid;
/

create or replace trigger rm$nls_languages_irid
 before insert on i$rm$nls_languages
 for each row
 begin
  if :new.irid is null then
    :new.irid := jr_util.get_new_irid;
  end if;
 end rm$nls_languages_irid;
/

create or replace trigger rm$nls_messages_irid
 before insert on i$rm$nls_messages
 for each row
 begin
  if :new.irid is null then
    :new.irid := jr_util.get_new_irid;
  end if;
 end rm$nls_messages_irid;
/

create or replace trigger rm$nls_message_groups_irid
 before insert on i$rm$nls_message_groups
 for each row
 begin
  if :new.irid is null then
    :new.irid := jr_util.get_new_irid;
  end if;
 end rm$nls_message_groups_irid;
/

create or replace trigger rm$nls_properties_irid
 before insert on i$rm$nls_properties
 for each row
 begin
  if :new.irid is null then
    :new.irid := jr_util.get_new_irid;
  end if;
 end rm$nls_properties_irid;
/

create or replace trigger rm$nls_text_types_irid
 before insert on i$rm$nls_text_types
 for each row
 begin
  if :new.irid is null then
    :new.irid := jr_util.get_new_irid;
  end if;
 end rm$nls_text_types_irid;
/

create or replace trigger rm$nls_utilities_irid
 before insert on i$rm$nls_utilities
 for each row
 begin
  if :new.irid is null then
    :new.irid := jr_util.get_new_irid;
  end if;
 end rm$nls_utilities_irid;
/

create or replace trigger rm$property_extensions_irid
 before insert on i$rm$property_extensions
 for each row
 begin
  if :new.irid is null then
    :new.irid := jr_util.get_new_irid;
  end if;
 end rm$property_extensions_irid;
/

create or replace trigger rm$property_ranges_irid
 before insert on i$rm$property_ranges
 for each row
 begin
  if :new.irid is null then
    :new.irid := jr_util.get_new_irid;
  end if;
 end rm$property_ranges_irid;
/

create or replace trigger rm$text_types_irid
 before insert on i$rm$text_types
 for each row
 begin
  if :new.irid is null then
    :new.irid := jr_util.get_new_irid;
  end if;
 end rm$text_types_irid;
/

create or replace trigger rm$text_usages_irid
 before insert on i$rm$text_usages
 for each row
 begin
  if :new.irid is null then
    :new.irid := jr_util.get_new_irid;
  end if;
 end rm$text_usages_irid;
/














