text: create or replace package body CR_IS_P
  
  as
  
  begin
  
      testdata_rulebuilder.rules('CR_IS_P').define_code := q'[begin
          if upper('##COLUMN_TYPE##') = 'BUILTIN' and (upper('##BUILTIN_TYPE##') = 'NUMITERATE' or upper('##BUILTIN_TYPE##') = 'EPOCHITERATE') then
              :rule_output := 'l_bltin_##COLUMN_NAME## number := case when rf_##COLUMN_NAME## is not null then rf_##COLUMN_NAME## else ##BUILTIN_STARTPOINT## end;';
          elsif upper('##COLUMN_TYPE##') = 'BUILTIN' and upper('##BUILTIN_TYPE##') = 'DATITERATE' then
              :rule_output := 'l_bltin_##COLUMN_NAME## date := case when rf_##COLUMN_NAME## is not null then rf_##COLUMN_NAME## else ##BUILTIN_STARTPOINT## end;';
          end if;
      end;]';
  
      testdata_rulebuilder.rules('CR_IS_P').logic_code := q'[begin
          if upper('##COLUMN_TYPE##') = 'GENERATED' then
              :rule_output := 'case when rf_##COLUMN_NAME## is not null then rf_##COLUMN_NAME## else ##GENERATOR## end';
          end if;
      end;]';
  
  end CR_IS_P;
  /