APPS.AK_RUN_FLOW_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 9

  select 1
  from   all_objects ao, ak_regions ar
  where  ao.object_name = ar.database_object_name
  and    ar.region_application_id = x_region_application_id
  and    ar.region_code = x_region_code
  and    ao.object_type in ('TABLE', 'VIEW');

Line: 186

      insert into ak_object_values_temp (
        TRACE_NUM,
        REGION_APPLICATION_ID,
        REGION_CODE,
        DISPLAY_VALUE,
        KEY_VALUE1,
        KEY_VALUE2,
        KEY_VALUE3,
        KEY_VALUE4,
        KEY_VALUE5,
        KEY_VALUE6,
        KEY_VALUE7,
        KEY_VALUE8,
        KEY_VALUE9,
        KEY_VALUE10
      ) values (
        X_TRACE_NUM,
        X_REGION_APPLICATION_ID,
        X_REGION_CODE,
        l_display_value,
        l_results_table(l_index).key1,
        l_results_table(l_index).key2,
        l_results_table(l_index).key3,
        l_results_table(l_index).key4,
        l_results_table(l_index).key5,
        l_results_table(l_index).key6,
        l_results_table(l_index).key7,
        l_results_table(l_index).key8,
        l_results_table(l_index).key9,
        l_results_table(l_index).key10
      );