APPS.BEN_DM_GEN_DOWNLOAD SQL Statements

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

Line: 61

    g_package_body.delete(l_index);

Line: 396

  l_cursor_select_cols   varchar2(32767);

Line: 397

  l_cursor_select_from   varchar2(32767);

Line: 398

  l_cursor_select_where  varchar2(32767);

Line: 413

  l_cursor_comment := indent || '--' || indent || '-- cursor to select the data from the ' ||
                      p_table_info.table_name || ' table to be migrated.'|| indent || '--';

Line: 416

  l_cursor_comment := format_comment(' cursor to select the data from the '
                      || p_table_info.table_name ,2 );

Line: 428

     l_cursor_select_cols :=  ' Select  distinct ' ||  p_table_info.table_alias || '.*' ;

Line: 430

     l_cursor_select_cols :=  ' Select ' ||  p_table_info.table_alias || '.*' ;

Line: 438

                              p_where_clause => l_cursor_select_where);

Line: 445

              l_cursor_select_cols  || indent ||
             /* l_cursor_select_from  || indent || */
               l_cursor_select_where || indent;

Line: 508

  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.HIERARCHY_TYPE = 'S'
  and  bdm.table_id = c_tbl_id
  and  bdm.parent_table_name = bdt.table_name
  ;

Line: 520

  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 a.entity_result_column_name
 ;

Line: 570

              '  l_rec_inserted_cnt             number := 0;' || indent ||

Line: 581

                 'l_rec_inserted_cnt := 0;' || indent(l_indent) || indent(l_indent) ||

Line: 632

                    '-- Insert the values into result entity table ' || indent(l_indent) ;

Line: 644

  l_proc_body  := l_proc_body|| 'l_rec_inserted_cnt := l_rec_inserted_cnt + 1 ; ' ;

Line: 652

  'p_rec_downloaded := l_rec_inserted_cnt;' ||  indent(l_indent)    ||

Line: 653

                       'ben_dm_utility.message(''INFO'','' Record  Inserterd  '' ||l_rec_inserted_cnt,5) ; '

Line: 733

  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
  ;