APPS.BEN_DM_GEN_UPLOAD SQL Statements

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

Line: 45

    g_package_body.delete(l_index);

Line: 162

  select a.column_name ,
         a.entity_result_column_name
  from   ben_dm_column_mappings a ,
         sys.all_tab_columns  b
  where  a.table_id = c_tbl_id
    and  a.column_name = b.column_name
    and  b.table_name = c_table_name
  order by b.column_id
  ;

Line: 199

  l_cursor :=  l_cursor || 'Select  ' ||   indent (l_indent) ;

Line: 242

      l_locals :=  l_locals || 'select TARGET_NATIONAL_IDENTIFIER ' || indent ;

Line: 256

      l_locals :=  l_locals || 'select SURROGATE_PK_COLUMN_NAME  ' || indent ;

Line: 295

procedure generate_insert_dml
(
  p_table_info       in     ben_dm_gen_download.t_ben_dm_table
)
is
  l_locals       varchar2(32767) := null;

Line: 314

  select bdt.table_alias
         ,bdm.column_name
         ,bdm.parent_table_name
         ,bdm.parent_column_name
         ,bdm.parent_id_column_name
  from  ben_dm_hierarchies bdm , ben_dm_tables bdt
  where bdm.table_id = c_tbl_id
  and  bdm.parent_table_name = bdt.table_name
  ;

Line: 326

  select 'x'
  from  ben_dm_hierarchies bdm , ben_dm_tables bdt
  where bdm.table_id = c_tbl_id
  and  bdm.parent_table_name = bdt.table_name
  and  bdm.hierarchy_type = 'H'
  ;

Line: 336

  select decode(col.data_type,'DATE','to_char(l_rslt.'||map.column_name||','||''''||'dd-mon-rrrr'||''''||')','l_rslt.'
         ||map.column_name) column_name ,
         map.entity_result_column_name
  from   ben_dm_column_mappings map,
         ben_dm_tables tab,
         sys.all_tab_columns col
  where  tab.table_id = c_tbl_id
    and  map.table_id = tab.table_id
    and  col.column_name = map.column_name
    and  col.table_name = tab.table_name
  order by col.column_id
  ;

Line: 350

  select bdh.hierarchy_type ,
        bdh.parent_table_name,
        bdh.parent_id_column_name
  from  ben_dm_hierarchies bdh
  where bdh.table_id    = p_table_info.table_id
   and  bdh.column_name= p_col_name
  ;

Line: 371

  l_proc           := g_package || 'generate_insert_dml' ;

Line: 431

       l_cursor := l_cursor ||  '-- update the  primiary key to  mapping table ' || indent(l_indent) ;

Line: 456

       l_cursor := l_cursor ||  '-- update the  prmiary key to  mapping table ' || indent(l_indent) ;

Line: 532

               l_cursor := l_cursor|| 'select  '||p_table_info.SEQUENCE_NAME ||'.NEXTVAL into  l_rslt.'|| l_pk_rec.column_name
                                    ||' from dual ;'|| indent(l_indent+9);

Line: 673

  l_cursor  := indent(l_indent) || ' -- Inserting the values into  source table ' ||  indent(l_indent) ;

Line: 703

end generate_insert_dml;

Line: 730

  select  TABLE_ID
         ,TABLE_NAME
         ,UPLOAD_TABLE_NAME
         ,TABLE_ALIAS
         ,DATETRACK
         ,DERIVE_SQL
         ,SURROGATE_PK_COLUMN_NAME
         ,SHORT_NAME
         ,LAST_GENERATED_DATE
         ,GENERATOR_VERSION
         ,SEQUENCE_NAME
         ,LAST_UPDATE_DATE
  from  ben_dm_tables
  where  table_alias = p_table_alias
  ;

Line: 850

    generate_insert_dml (p_table_info => l_tbl_rec  );