eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EDW_GL_ACCT_M_T SQL Statements

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

Line: 11


g_rows_updated        number;

Line: 13


g_rows_inserted       number;

Line: 83


     l_select_stmt        varchar2(500);

Line: 84


     l_rows_selected      integer;

Line: 89


     l_select_stmt:= 'select count(*) from '|| g_vbh_temp_table_name||'
                      where child=:m1
                      and child in (
                           SELECT  child
                           FROM '||g_vbh_temp_table_name||'
                           where child is not null
                           START WITH parent =:m2
                           CONNECT BY parent=PRIOR child)';

Line: 98


     DBMS_SQL.parse(l_cursor_id,l_select_stmt,DBMS_SQL.V7);

Line: 102


     l_rows_selected:=DBMS_SQL.execute(l_cursor_id);

Line: 144


       select t1.value||'-'||t2.set_of_books_id||'-'||t2.instance,
              t1.type
       from edw_segment_classes t1, edw_set_of_books t2
       where t1.edw_set_of_books_id = t2.edw_set_of_books_id
       and (t1.segment_name,t2.chart_of_accounts_id,lower(t2.instance)) in
           (select segment_name,structure_num,lower(instance_code)
            FROM   EDW_FLEX_SEG_MAPPINGS_V
            WHERE  DIMENSION_SHORT_NAME=g_dimension_name);

Line: 203


           g_acct_type_root1.delete(l_outer_loop_counter);

Line: 217


procedure update_temp_table(p_acct_name in varchar2,
                            p_acct_type in varchar2) is
    l_CursorID             INTEGER;

Line: 220


    l_UpdateStmt           VARCHAR2(500);

Line: 221


    l_RowsUpdated        integer;

Line: 225


    l_UpdateStmt :=
      'UPDATE '||g_vbh_temp_table_name||'
       SET child_type= :b_acct_type
       WHERE child =:b_acct_name';

Line: 229


    DBMS_SQL.PARSE(l_CursorID,l_UpdateStmt,DBMS_SQL.V7);

Line: 233


    l_RowsUpdated := DBMS_SQL.EXECUTE(l_CursorID);

Line: 236


    l_UpdateStmt :=
       'UPDATE '|| g_vbh_temp_table_name||'
       SET parent_type= :b_acct_type
       WHERE parent =:b_acct_name';

Line: 241


    DBMS_SQL.PARSE(l_CursorID,l_UpdateStmt,DBMS_SQL.V7);

Line: 245


    l_RowsUpdated:= DBMS_SQL.EXECUTE(l_CursorID);

Line: 254


END update_temp_table;

Line: 256


procedure update_class is
     l_loop_counter   integer :=0;

Line: 269


         update_temp_table(g_acct_type_root2(l_loop_counter).name,
                           g_acct_type_root2(l_loop_counter).type);

Line: 276


         'select child from '|| g_vbh_temp_table_name||
         '  START WITH parent = :s
         connect by parent=PRIOR child'
         using g_acct_type_root2(l_loop_counter).name;

Line: 284


         update_temp_table(l_vbh_acct_name,
                           g_acct_type_root2(l_loop_counter).type);

Line: 300


      l_rows_deleted    integer:=0;

Line: 301


      l_delete_stmt     varchar2(50);

Line: 377


procedure insert_default_value(
   p_pk             IN edw_gl_acct1_m.l1_name%TYPE,
   p_pk_key         IN edw_gl_acct1_m.l1_pk_key%TYPE,
   p_name           IN edw_gl_acct1_m.l1_name%TYPE,
   p_desc           IN edw_gl_acct1_m.l1_description%TYPE)  as
l_cursor_id integer;

Line: 383


l_insert_stmt varchar2(5000);

Line: 384


l_rows_inserted integer :=0;

Line: 388


  l_insert_stmt:='INSERT INTO '|| g_dimension_name||'(L1_pk ,l1_pk_key,l1_name,l1_description
  ,l1_type,type_pk,type_name,all_name,all_pk,
  H102_pk ,H103_pk ,H104_pk ,H105_pk ,H106_pk ,H107_pk ,H108_pk ,
  H102_name ,H103_name ,H104_name ,H105_name ,H106_name ,H107_name ,H108_name ,
  H102_type ,H103_type ,H104_type ,H105_type ,H106_type ,H107_type ,H108_type ,
  H109_pk ,H110_pk ,H111_pk ,H112_pk ,H113_pk ,H114_pk ,H115_pk ,
  H109_name ,H110_name ,H111_name ,H112_name ,H113_name ,H114_name ,H115_name ,
  H109_type ,H110_type ,H111_type ,H112_type ,H113_type ,H114_type ,H115_type ,
  H202_pk ,H203_pk ,H204_pk ,H205_pk ,H206_pk ,H207_pk ,H208_pk ,
  H202_name ,H203_name ,H204_name ,H205_name ,H206_name ,H207_name ,H208_name ,
  H202_type ,H203_type ,H204_type ,H205_type ,H206_type ,H207_type ,H208_type ,
  H209_pk ,H210_pk ,H211_pk ,H212_pk ,H213_pk ,H214_pk ,H215_pk ,
  H209_name ,H210_name ,H211_name ,H212_name ,H213_name ,H214_name ,H215_name ,
  H209_type ,H210_type ,H211_type ,H212_type ,H213_type ,H214_type ,H215_type ,
  H302_pk ,H303_pk ,H304_pk ,H305_pk ,H306_pk ,H307_pk ,H308_pk ,
  H302_name ,H303_name ,H304_name ,H305_name ,H306_name ,H307_name ,H308_name ,
  H302_type ,H303_type ,H304_type ,H305_type ,H306_type ,H307_type ,H308_type ,
  H309_pk ,H310_pk ,H311_pk ,H312_pk ,H313_pk ,H314_pk ,H315_pk ,
  H309_name ,H310_name ,H311_name ,H312_name ,H313_name ,H314_name ,H315_name ,
  H309_type ,H310_type ,H311_type ,H312_type ,H313_type ,H314_type ,H315_type ,
  H402_pk ,H403_pk ,H404_pk ,H405_pk ,H406_pk ,H407_pk ,H408_pk ,
  H402_name ,H403_name ,H404_name ,H405_name ,H406_name ,H407_name ,H408_name ,
  H402_type ,H403_type ,H404_type ,H405_type ,H406_type ,H407_type ,H408_type ,
  H409_pk ,H410_pk ,H411_pk ,H412_pk ,H413_pk ,H414_pk ,H415_pk ,
  H409_name ,H410_name ,H411_name ,H412_name ,H413_name ,H414_name ,H415_name ,
  H409_type ,H410_type ,H411_type ,H412_type ,H413_type ,H414_type ,H415_type ,creation_date,LAST_UPDATE_DATE)
 values (:b_pk, :b_pk_key,:b_name,:b_desc, '''|| g_na_edw||''', '''|| g_na_edw||''', '''|| g_na_edw||''',
 '''|| g_na_edw||''', ''NA_EDW'',
 ''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',
 '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',
 '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',
 ''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',
 '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',
 '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',
 ''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',
 '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',
 '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',
 ''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',
 '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',
 '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',
 ''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',
 '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',
 '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',
 ''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',
 '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',
 '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',
 ''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',
 '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',
 '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',
 ''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',
 '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',
 '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',sysdate,sysdate)';

Line: 441


  DBMS_SQL.parse(l_cursor_id,l_insert_stmt,DBMS_SQL.V7);

Line: 446


  l_rows_inserted :=DBMS_SQL.EXECUTE(l_cursor_id);

Line: 451


      'When inserting the default value into '|| g_dimension_name
      ||' '||sqlcode ||' : '||sqlerrm);

Line: 454


end insert_default_value;

Line: 457


procedure insert_non_active_values
as
l_rows_inserted integer :=0;

Line: 465


   l_value_stmt:= 'INSERT INTO '|| g_dimension_name ||
   '( L1_pk ,l1_pk_key,l1_name,l1_description' ||
   '  ,l1_type,type_pk,type_name,all_name,all_pk,' ||
   '  H102_pk ,H103_pk ,H104_pk ,H105_pk ,H106_pk ,H107_pk ,H108_pk ,' ||
   '  H102_name ,H103_name ,H104_name ,H105_name ,H106_name ,H107_name ,H108_name ,' ||
   '  H102_type ,H103_type ,H104_type ,H105_type ,H106_type ,H107_type ,H108_type ,' ||
   '  H109_pk ,H110_pk ,H111_pk ,H112_pk ,H113_pk ,H114_pk ,H115_pk ,' ||
   '  H109_name ,H110_name ,H111_name ,H112_name ,H113_name ,H114_name ,H115_name ,' ||
   '  H109_type ,H110_type ,H111_type ,H112_type ,H113_type ,H114_type ,H115_type ,' ||
   '  H202_pk ,H203_pk ,H204_pk ,H205_pk ,H206_pk ,H207_pk ,H208_pk ,' ||
   '  H202_name ,H203_name ,H204_name ,H205_name ,H206_name ,H207_name ,H208_name ,' ||
   '  H202_type ,H203_type ,H204_type ,H205_type ,H206_type ,H207_type ,H208_type ,' ||
   '  H209_pk ,H210_pk ,H211_pk ,H212_pk ,H213_pk ,H214_pk ,H215_pk ,' ||
   '  H209_name ,H210_name ,H211_name ,H212_name ,H213_name ,H214_name ,H215_name ,' ||
   '  H209_type ,H210_type ,H211_type ,H212_type ,H213_type ,H214_type ,H215_type ,' ||
   '  H302_pk ,H303_pk ,H304_pk ,H305_pk ,H306_pk ,H307_pk ,H308_pk ,' ||
   '  H302_name ,H303_name ,H304_name ,H305_name ,H306_name ,H307_name ,H308_name ,' ||
   '  H302_type ,H303_type ,H304_type ,H305_type ,H306_type ,H307_type ,H308_type ,' ||
   '  H309_pk ,H310_pk ,H311_pk ,H312_pk ,H313_pk ,H314_pk ,H315_pk ,' ||
   '  H309_name ,H310_name ,H311_name ,H312_name ,H313_name ,H314_name ,H315_name ,' ||
   '  H309_type ,H310_type ,H311_type ,H312_type ,H313_type ,H314_type ,H315_type ,' ||
   '  H402_pk ,H403_pk ,H404_pk ,H405_pk ,H406_pk ,H407_pk ,H408_pk ,' ||
   '  H402_name ,H403_name ,H404_name ,H405_name ,H406_name ,H407_name ,H408_name ,' ||
   '  H402_type ,H403_type ,H404_type ,H405_type ,H406_type ,H407_type ,H408_type ,' ||
   '  H409_pk ,H410_pk ,H411_pk ,H412_pk ,H413_pk ,H414_pk ,H415_pk ,' ||
   '  H409_name ,H410_name ,H411_name ,H412_name ,H413_name ,H414_name ,H415_name ,' ||
   '  H409_type ,H410_type ,H411_type ,H412_type ,H413_type ,H414_type ,H415_type ,' ||
   '  creation_date, last_update_date) ' ||
   ' select a.l1_pk,a.l1_pk_key,a.l1_name,a.l1_description , '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',''NA_EDW'',
   ''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',
   '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',
   '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',
   ''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',
   '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',
   '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',
   ''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',
   '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',
   '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',
   ''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',
   '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',
   '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',
   ''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',
   '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',
   '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',
   ''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',
   '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',
   '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',
   ''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',
   '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',
   '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',
   ''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',
   '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',
   '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',sysdate,sysdate ' ||
   ' from '|| g_global_temp_table||' a where not exists ('||
   ' select b.l1_pk from '|| g_dimension_name||' b where a.l1_pk=b.l1_pk )';

Line: 522


   l_rows_inserted := sql%rowcount;

Line: 523


   VBHDEBUG('Number of non-active rows inserted : ' || l_rows_inserted);

Line: 526


     edw_log.put_line('Error:'|| 'When inserting non-active default value into '|| g_dimension_name ||' '||sqlcode ||' : '||sqlerrm);

Line: 527


     logTime('Error of non-active default values insertions to dimension star table', l_log_timestamp);

Line: 530


end insert_non_active_values;

Line: 532


procedure insert_default_values(
  p_seq_name  in varchar2
) as
l_defaultrows_inserted integer :=0;

Line: 542


              'INSERT INTO '|| g_dimension_name ||
   '( L1_pk ,l1_pk_key,l1_name,l1_description' ||
   '  ,l1_type,type_pk,type_name,all_name,all_pk,' ||
   '  H102_pk ,H103_pk ,H104_pk ,H105_pk ,H106_pk ,H107_pk ,H108_pk ,' ||
   '  H102_name ,H103_name ,H104_name ,H105_name ,H106_name ,H107_name ,H108_name ,' ||
   '  H102_type ,H103_type ,H104_type ,H105_type ,H106_type ,H107_type ,H108_type ,' ||
   '  H109_pk ,H110_pk ,H111_pk ,H112_pk ,H113_pk ,H114_pk ,H115_pk ,' ||
   '  H109_name ,H110_name ,H111_name ,H112_name ,H113_name ,H114_name ,H115_name ,' ||
   '  H109_type ,H110_type ,H111_type ,H112_type ,H113_type ,H114_type ,H115_type ,' ||
   '  H202_pk ,H203_pk ,H204_pk ,H205_pk ,H206_pk ,H207_pk ,H208_pk ,' ||
   '  H202_name ,H203_name ,H204_name ,H205_name ,H206_name ,H207_name ,H208_name ,' ||
   '  H202_type ,H203_type ,H204_type ,H205_type ,H206_type ,H207_type ,H208_type ,' ||
   '  H209_pk ,H210_pk ,H211_pk ,H212_pk ,H213_pk ,H214_pk ,H215_pk ,' ||
   '  H209_name ,H210_name ,H211_name ,H212_name ,H213_name ,H214_name ,H215_name ,' ||
   '  H209_type ,H210_type ,H211_type ,H212_type ,H213_type ,H214_type ,H215_type ,' ||
   '  H302_pk ,H303_pk ,H304_pk ,H305_pk ,H306_pk ,H307_pk ,H308_pk ,' ||
   '  H302_name ,H303_name ,H304_name ,H305_name ,H306_name ,H307_name ,H308_name ,' ||
   '  H302_type ,H303_type ,H304_type ,H305_type ,H306_type ,H307_type ,H308_type ,' ||
   '  H309_pk ,H310_pk ,H311_pk ,H312_pk ,H313_pk ,H314_pk ,H315_pk ,' ||
   '  H309_name ,H310_name ,H311_name ,H312_name ,H313_name ,H314_name ,H315_name ,' ||
   '  H309_type ,H310_type ,H311_type ,H312_type ,H313_type ,H314_type ,H315_type ,' ||
   '  H402_pk ,H403_pk ,H404_pk ,H405_pk ,H406_pk ,H407_pk ,H408_pk ,' ||
   '  H402_name ,H403_name ,H404_name ,H405_name ,H406_name ,H407_name ,H408_name ,' ||
   '  H402_type ,H403_type ,H404_type ,H405_type ,H406_type ,H407_type ,H408_type ,' ||
   '  H409_pk ,H410_pk ,H411_pk ,H412_pk ,H413_pk ,H414_pk ,H415_pk ,' ||
   '  H409_name ,H410_name ,H411_name ,H412_name ,H413_name ,H414_name ,H415_name ,' ||
   '  H409_type ,H410_type ,H411_type ,H412_type ,H413_type ,H414_type ,H415_type ,' ||
   '  creation_date, last_update_date) ' ||
   ' select dim.pk, decode(temp.l1_pk,null,'||p_seq_name||'.nextval ,temp.l1_pk_key), dim.name,dim.description,
   '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',''NA_EDW'',
 ''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',
   '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',
   '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',
 ''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',
   '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',
   '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',
 ''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',
   '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',
   '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',
 ''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',
   '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',
   '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',
 ''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',
   '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',
   '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',
 ''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',
   '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',
   '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',
 ''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',
   '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',
   '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',
 ''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',
   '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',
   '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',sysdate, sysdate'
                  ||' from '|| g_global_temp_table
                  ||' temp, (select distinct child pk,child_name name,child_desc description from '
                  || g_vbh_temp_table_name||' where child is not null union '
                  || ' select distinct parent pk,parent_name name,parent_desc description from '
                  || g_vbh_temp_table_name||') dim where temp.l1_pk(+)=dim.pk';

Line: 604


   l_defaultrows_inserted:= sql%rowcount;

Line: 605


   VBHDEBUG('Default rows inserted: ' || l_defaultrows_inserted);

Line: 608


    edw_log.put_line('Error:'|| 'When inserting active default value into '|| g_dimension_name ||' '||sqlcode ||' : '||sqlerrm);

Line: 609


     logTime('Error of active default values insertions to dimension star table', l_log_timestamp);

Line: 611


end insert_default_values;

Line: 614


procedure insert_pk_key_into_table as
	l_cursor_id integer;

Line: 616


	l_insert_stmt varchar2(3000);

Line: 617


	l_rows_inserted integer :=0;

Line: 619


	l_insert_stmt :='insert into '|| g_global_temp_table|| ' (l1_pk,l1_pk_key,l1_name,l1_description) ' ||
                    ' select l1_pk, l1_pk_key, l1_name, l1_description from '||g_dimension_name ||
                    ' a where not exists ' ||
                    ' (select b.l1_pk from ' || g_global_temp_table || ' b where a.l1_pk = b.l1_pk)';

Line: 623


    VBHDEBUG('Executing ' || l_insert_stmt);

Line: 625


	DBMS_SQL.parse(l_cursor_id,l_insert_stmt,DBMS_SQL.V7);

Line: 626


	l_rows_inserted :=DBMS_SQL.EXECUTE(l_cursor_id);

Line: 630


    VBHDEBUG('Inserted ' || l_rows_inserted || ' rows');

Line: 636


end insert_pk_key_into_table;

Line: 653


PROCEDURE update_dimension(
  p_CursorID        IN integer,
  p_hierachy_no     IN number,
  p_pk              IN edw_gl_acct1_m.l1_pk%TYPE,
  p_type            IN edw_gl_acct1_m.l1_type%TYPE,
  p_level2          IN edw_gl_acct1_m.l1_pk%TYPE,
  p_level2_name     IN edw_gl_acct1_m.l1_name%TYPE,
  p_level2_type     IN edw_gl_acct1_m.l1_type%TYPE,
  p_level2_desc     IN edw_gl_acct1_m.l1_description%TYPE,
  p_level3          IN edw_gl_acct1_m.l1_pk%TYPE,
  p_level3_name     IN edw_gl_acct1_m.l1_name%TYPE,
  p_level3_type     IN edw_gl_acct1_m.l1_type%TYPE,
  p_level3_desc     IN edw_gl_acct1_m.l1_description%TYPE,
  p_level4          IN edw_gl_acct1_m.l1_pk%TYPE,
  p_level4_name     IN edw_gl_acct1_m.l1_name%TYPE,
  p_level4_type     IN edw_gl_acct1_m.l1_type%TYPE,
  p_level4_desc     IN edw_gl_acct1_m.l1_description%TYPE,
  p_level5          IN edw_gl_acct1_m.l1_pk%TYPE,
  p_level5_name     IN edw_gl_acct1_m.l1_name%TYPE,
  p_level5_type     IN edw_gl_acct1_m.l1_type%TYPE,
  p_level5_desc     IN edw_gl_acct1_m.l1_description%TYPE,
  p_level6          IN edw_gl_acct1_m.l1_pk%TYPE,
  p_level6_name     IN edw_gl_acct1_m.l1_name%TYPE,
  p_level6_type     IN edw_gl_acct1_m.l1_type%TYPE,
  p_level6_desc     IN edw_gl_acct1_m.l1_description%TYPE,
  p_level7          IN edw_gl_acct1_m.l1_pk%TYPE,
  p_level7_name     IN edw_gl_acct1_m.l1_name%TYPE,
  p_level7_type     IN edw_gl_acct1_m.l1_type%TYPE,
  p_level7_desc     IN edw_gl_acct1_m.l1_description%TYPE,
  p_level8          IN edw_gl_acct1_m.l1_pk%TYPE,
  p_level8_name     IN edw_gl_acct1_m.l1_name%TYPE,
  p_level8_type     IN edw_gl_acct1_m.l1_type%TYPE,
  p_level8_desc     IN edw_gl_acct1_m.l1_description%TYPE,
  p_level9          IN edw_gl_acct1_m.l1_pk%TYPE,
  p_level9_name     IN edw_gl_acct1_m.l1_name%TYPE,
  p_level9_type     IN edw_gl_acct1_m.l1_type%TYPE,
  p_level9_desc     IN edw_gl_acct1_m.l1_description%TYPE,
  p_level10         IN edw_gl_acct1_m.l1_pk%TYPE,
  p_level10_name    IN edw_gl_acct1_m.l1_name%TYPE,
  p_level10_type    IN edw_gl_acct1_m.l1_type%TYPE,
  p_level10_desc    IN edw_gl_acct1_m.l1_description%TYPE,
  p_level11         IN edw_gl_acct1_m.l1_pk%TYPE,
  p_level11_name    IN edw_gl_acct1_m.l1_name%TYPE,
  p_level11_type    IN edw_gl_acct1_m.l1_type%TYPE,
  p_level11_desc    IN edw_gl_acct1_m.l1_description%TYPE,
  p_level12         IN edw_gl_acct1_m.l1_pk%TYPE,
  p_level12_name    IN edw_gl_acct1_m.l1_name%TYPE,
  p_level12_type    IN edw_gl_acct1_m.l1_type%TYPE,
  p_level12_desc    IN edw_gl_acct1_m.l1_description%TYPE,
  p_level13         IN edw_gl_acct1_m.l1_pk%TYPE,
  p_level13_name    IN edw_gl_acct1_m.l1_name%TYPE,
  p_level13_type    IN edw_gl_acct1_m.l1_type%TYPE,
  p_level13_desc    IN edw_gl_acct1_m.l1_description%TYPE,
  p_level14         IN edw_gl_acct1_m.l1_pk%TYPE,
  p_level14_name    IN edw_gl_acct1_m.l1_name%TYPE,
  p_level14_type    IN edw_gl_acct1_m.l1_type%TYPE,
  p_level14_desc    IN edw_gl_acct1_m.l1_description%TYPE,
  p_level15         IN edw_gl_acct1_m.l1_pk%TYPE,
  p_level15_name    IN edw_gl_acct1_m.l1_name%TYPE,
  p_level15_type    IN edw_gl_acct1_m.l1_type%TYPE,
  p_level15_desc    IN edw_gl_acct1_m.l1_description%TYPE,
  p_all_name        in edw_gl_acct1_m.all_name%TYPE,
  p_RowsUpdated     IN OUT NOCOPY INTEGER
 ) AS

l_CursorID             INTEGER;

Line: 719


l_UpdateStmt           VARCHAR2(4000);

Line: 796


    p_RowsUpdated := DBMS_SQL.EXECUTE(p_CursorID);

Line: 799


  IF p_RowsUpdated=0 THEN
    begin
       setTimer(l_error_timestamp);

Line: 803


       'SELECT h'||p_hierachy_no||'15_pk
         FROM '|| g_dimension_name||'
         WHERE l1_pk= :s' using p_pk;

Line: 848


  END IF;  --for p_RowsUpdated=0

Line: 856


END update_dimension;

Line: 859


l_select_stmt varchar2(300);

Line: 867


     l_select_stmt:= 'select l1_pk,l1_name from '||g_dimension_name||
                    ' where h115_pk = ''NA_EDW''  and h215_pk = ''NA_EDW''
                      and h315_pk = ''NA_EDW''  and h415_pk = ''NA_EDW''
                      order by l1_name';

Line: 871


     VBHDEBUG('Executing : ' || l_select_stmt);

Line: 873


     DBMS_SQL.parse(l_cursor_id,l_select_stmt,DBMS_SQL.V7);

Line: 902


    select *
    from edw_set_of_books
    where edw_set_of_books_id not in (
          select edw_set_of_books_id
          from edw_vbh_roots)
    and   edw_set_of_books_id not in (
          select edw_set_of_books_id
          from edw_equi_set_of_books)
    and   edw_set_of_books_id not in (
          select child_edw_set_of_books_id
          from edw_cons_set_of_books) ;

Line: 933


PROCEDURE CLOSE_UPDATE( p_CursorID IN OUT NOCOPY INTEGER) IS
BEGIN
    DBMS_SQL.CLOSE_CURSOR(p_CursorID);

Line: 936


    VBHDEBUG('Closed the update statement cursor');

Line: 941


FUNCTION PARSE_UPDATE(p_hierachy_no integer ) return  integer
IS
  l_CursorID    INTEGER;

Line: 944


  l_UpdateStmt   varchar2(4000);

Line: 947


    l_UpdateStmt :=
    'UPDATE '|| g_dimension_name||'
     SET LAST_UPDATE_DATE=sysdate,
         l1_type=:b_type,'
         ||' h'||p_hierachy_no||'02_pk=  :b_level2,'
         ||' h'||p_hierachy_no||'02_name=  :b_level2_name,'
         ||' h'||p_hierachy_no||'02_type=  :b_level2_type,'
         ||' h'||p_hierachy_no||'02_description =  :b_level2_desc,'
         ||' h'||p_hierachy_no||'03_pk=  :b_level3,'
         ||' h'||p_hierachy_no||'03_name=  :b_level3_name,'
         ||' h'||p_hierachy_no||'03_type=  :b_level3_type,'
         ||' h'||p_hierachy_no||'03_description =  :b_level3_desc,'
         ||' h'||p_hierachy_no||'04_pk=  :b_level4,'
         ||' h'||p_hierachy_no||'04_name=  :b_level4_name,'
         ||' h'||p_hierachy_no||'04_type=  :b_level4_type,'
         ||' h'||p_hierachy_no||'04_description =  :b_level4_desc,'
         ||' h'||p_hierachy_no||'05_pk=  :b_level5,'
         ||' h'||p_hierachy_no||'05_name=  :b_level5_name,'
         ||' h'||p_hierachy_no||'05_type=  :b_level5_type,'
         ||' h'||p_hierachy_no||'05_description =  :b_level5_desc,'
         ||' h'||p_hierachy_no||'06_pk=  :b_level6,'
         ||' h'||p_hierachy_no||'06_name=  :b_level6_name,'
         ||' h'||p_hierachy_no||'06_type=  :b_level6_type,'
         ||' h'||p_hierachy_no||'06_description =  :b_level6_desc,'
         ||' h'||p_hierachy_no||'07_pk=  :b_level7,'
         ||' h'||p_hierachy_no||'07_name=  :b_level7_name,'
         ||' h'||p_hierachy_no||'07_type=  :b_level7_type,'
         ||' h'||p_hierachy_no||'07_description =  :b_level7_desc,'
         ||' h'||p_hierachy_no||'08_pk=  :b_level8,'
         ||' h'||p_hierachy_no||'08_name=  :b_level8_name,'
         ||' h'||p_hierachy_no||'08_type=  :b_level8_type,'
         ||' h'||p_hierachy_no||'08_description =  :b_level8_desc,'
         ||' h'||p_hierachy_no||'09_pk=  :b_level9,'
         ||' h'||p_hierachy_no||'09_name=  :b_level9_name,'
         ||' h'||p_hierachy_no||'09_type=  :b_level9_type,'
         ||' h'||p_hierachy_no||'09_description =  :b_level9_desc,'
         ||' h'||p_hierachy_no||'10_pk=  :b_level10,'
         ||' h'||p_hierachy_no||'10_name=  :b_level10_name,'
         ||' h'||p_hierachy_no||'10_type=  :b_level10_type,'
         ||' h'||p_hierachy_no||'10_description=  :b_level10_desc,'
         ||' h'||p_hierachy_no||'11_pk=  :b_level11,'
         ||' h'||p_hierachy_no||'11_name=  :b_level11_name,'
         ||' h'||p_hierachy_no||'11_type=  :b_level11_type,'
         ||' h'||p_hierachy_no||'11_description=  :b_level11_desc,'
         ||' h'||p_hierachy_no||'12_pk=  :b_level12,'
         ||' h'||p_hierachy_no||'12_name=  :b_level12_name,'
         ||' h'||p_hierachy_no||'12_type=  :b_level12_type,'
         ||' h'||p_hierachy_no||'12_description=  :b_level12_desc,'
         ||' h'||p_hierachy_no||'13_pk=  :b_level13,'
         ||' h'||p_hierachy_no||'13_name=  :b_level13_name,'
         ||' h'||p_hierachy_no||'13_type=  :b_level13_type,'
         ||' h'||p_hierachy_no||'13_description=  :b_level13_desc,'
         ||' h'||p_hierachy_no||'14_pk=  :b_level14,'
         ||' h'||p_hierachy_no||'14_name=  :b_level14_name,'
         ||' h'||p_hierachy_no||'14_type=  :b_level14_type,'
         ||' h'||p_hierachy_no||'14_description=  :b_level14_desc,'
         ||' h'||p_hierachy_no||'15_pk=  :b_level15,'
         ||' h'||p_hierachy_no||'15_name=  :b_level15_name,'
         ||' h'||p_hierachy_no||'15_type=  :b_level15_type,'
         ||' h'||p_hierachy_no||'15_description=  :b_level15_desc,'
         ||' type_pk    =:b_type_pk,'
         ||' type_name    =:b_type_name,'
         ||' type_description =:b_type_desc,'
         ||' all_pk     =:b_all_pk,'
         ||' all_name     =:b_all_name,'
         ||' all_description  =:b_all_desc'
         ||' WHERE l1_pk= :b_primarykey AND  h'||p_hierachy_no||'02_pk = ''NA_EDW''';

Line: 1015


     DBMS_SQL.PARSE(l_CursorID,l_UpdateStmt,DBMS_SQL.V7);

Line: 1016


     VBHDEBUG('Parsed the update statement for hierarchy ' || p_hierachy_no );

Line: 1018


END PARSE_UPDATE;

Line: 1023


  SELECT p_root ||'-'||set_of_books_id||'-'||instance
  INTO l_root_value
  FROM edw_set_of_books
  WHERE edw_set_of_books_id = p_root_sob_id;

Line: 1050


  l_rowsUpdated  integer  := 0;

Line: 1058


      'select parent_name,parent_type,parent_desc
      from '|| g_vbh_temp_table_name||'
      WHERE parent=:s
      union all
      select child_name,child_type,child_desc
      from '|| g_vbh_temp_table_name||'
      WHERE child=:s ' using p_root_value,p_root_value;

Line: 1079


     update_dimension(
                  p_curid,
                  p_hieno,
                  g_vbh_level_table(15).value,
                  g_vbh_level_table(15).type,
                  g_vbh_level_table(15).value,
                  g_vbh_level_table(15).name,
                  g_vbh_level_table(15).type,
                  g_vbh_level_table(15).description,
                  g_vbh_level_table(15).value,
                  g_vbh_level_table(15).name,
                  g_vbh_level_table(15).type,
                  g_vbh_level_table(15).description,
                  g_vbh_level_table(15).value,
                  g_vbh_level_table(15).name,
                  g_vbh_level_table(15).type,
                  g_vbh_level_table(15).description,
                  g_vbh_level_table(15).value,
                  g_vbh_level_table(15).name,
                  g_vbh_level_table(15).type,
                  g_vbh_level_table(15).description,
                  g_vbh_level_table(15).value,
                  g_vbh_level_table(15).name,
                  g_vbh_level_table(15).type,
                  g_vbh_level_table(15).description,
                  g_vbh_level_table(15).value,
                  g_vbh_level_table(15).name,
                  g_vbh_level_table(15).type,
                  g_vbh_level_table(15).description,
                  g_vbh_level_table(15).value,
                  g_vbh_level_table(15).name,
                  g_vbh_level_table(15).type,
                  g_vbh_level_table(15).description,
                  g_vbh_level_table(15).value,
                  g_vbh_level_table(15).name,
                  g_vbh_level_table(15).type,
                  g_vbh_level_table(15).description,
                  g_vbh_level_table(15).value,
                  g_vbh_level_table(15).name,
                  g_vbh_level_table(15).type,
                  g_vbh_level_table(15).description,
                  g_vbh_level_table(15).value,
                  g_vbh_level_table(15).name,
                  g_vbh_level_table(15).type,
                  g_vbh_level_table(15).description,
                  g_vbh_level_table(15).value,
                  g_vbh_level_table(15).name,
                  g_vbh_level_table(15).type,
                  g_vbh_level_table(15).description,
                  g_vbh_level_table(15).value,
                  g_vbh_level_table(15).name,
                  g_vbh_level_table(15).type,
                  g_vbh_level_table(15).description,
                  g_vbh_level_table(15).value,
                  g_vbh_level_table(15).name,
                  g_vbh_level_table(15).type,
                  g_vbh_level_table(15).description,
                  g_vbh_level_table(15).value,
                  g_vbh_level_table(15).name,
                  g_vbh_level_table(15).type,
                  g_vbh_level_table(15).description,
                  'ALL' ,
                  l_rowsUpdated);

Line: 1143


  return l_rowsUpdated;

Line: 1166


  l_rowsUpdated    integer := 0;

Line: 1167


  l_updates_for_root  integer := 0;

Line: 1172


       'SELECT  parent,parent_name,parent_type,parent_desc,
                child,child_name,child_type,child_desc, level+1 total_level
        FROM '|| g_vbh_temp_table_name||'
        where child is not null
        START WITH parent =:s
        CONNECT BY parent=PRIOR child' using p_root_value;

Line: 1217


      update_dimension(
                  p_curid,
                  p_hie_no,
                  g_vbh_level_table(1).value,
                  g_vbh_level_table(1).type,
                  g_vbh_level_table(2).value,
                  g_vbh_level_table(2).name,
                  g_vbh_level_table(2).type,
                  g_vbh_level_table(2).description,
                  g_vbh_level_table(3).value,
                  g_vbh_level_table(3).name,
                  g_vbh_level_table(3).type,
                  g_vbh_level_table(3).description,
                  g_vbh_level_table(4).value,
                  g_vbh_level_table(4).name,
                  g_vbh_level_table(4).type,
                  g_vbh_level_table(4).description,
                  g_vbh_level_table(5).value,
                  g_vbh_level_table(5).name,
                  g_vbh_level_table(5).type,
                  g_vbh_level_table(5).description,
                  g_vbh_level_table(6).value,
                  g_vbh_level_table(6).name,
                  g_vbh_level_table(6).type,
                  g_vbh_level_table(6).description,
                  g_vbh_level_table(7).value,
                  g_vbh_level_table(7).name,
                  g_vbh_level_table(7).type,
                  g_vbh_level_table(7).description,
                  g_vbh_level_table(8).value,
                  g_vbh_level_table(8).name,
                  g_vbh_level_table(8).type,
                  g_vbh_level_table(8).description,
                  g_vbh_level_table(9).value,
                  g_vbh_level_table(9).name,
                  g_vbh_level_table(9).type,
                  g_vbh_level_table(9).description,
                  g_vbh_level_table(10).value,
                  g_vbh_level_table(10).name,
                  g_vbh_level_table(10).type,
                  g_vbh_level_table(10).description,
                  g_vbh_level_table(11).value,
                  g_vbh_level_table(11).name,
                  g_vbh_level_table(11).type,
                  g_vbh_level_table(11).description,
                  g_vbh_level_table(12).value,
                  g_vbh_level_table(12).name,
                  g_vbh_level_table(12).type,
                  g_vbh_level_table(12).description,
                  g_vbh_level_table(13).value,
                  g_vbh_level_table(13).name,
                  g_vbh_level_table(13).type,
                  g_vbh_level_table(13).description,
                  g_vbh_level_table(14).value,
                  g_vbh_level_table(14).name,
                  g_vbh_level_table(14).type,
                  g_vbh_level_table(14).description,
                  g_vbh_level_table(15).value,
                  g_vbh_level_table(15).name,
                  g_vbh_level_table(15).type,
                  g_vbh_level_table(15).description,
                  'ALL',
                  l_rowsUpdated);

Line: 1281


     l_updates_for_root := l_updates_for_root + l_rowsUpdated;

Line: 1286


     VBHDEBUG( l_updates_for_root || ' rows updated for root ' || p_root_value);

Line: 1287


     return l_updates_for_root;

Line: 1299


  l_rows_inserted      INTEGER :=0;

Line: 1302


  l_rowsUpdated        INTEGER;

Line: 1349


  l_updates_for_root      INTEGER;

Line: 1361


  g_rows_updated      := 0;

Line: 1363


  g_rows_inserted     := 0;

Line: 1376


  select dim_name into g_dimension_name
  from  edw_dimensions_md_v
  where dim_long_name = p_dimension_name;

Line: 1410


  select edw_load_s.nextval
  into l_progress_seq_id
  from dual;

Line: 1440


  insert_pk_key_into_table;

Line: 1441


  logTime('inserting keys to global temp', l_log_timestamp);

Line: 1448


  edw_owb_collection_util.INSERT_INTO_LOAD_PROGRESS(
  l_progress_seq_id,
  g_dimension_name,
  l_element_id,
  'Updating Account Type Information',
   sysdate,
   null,
   null,
   null,
   100,
   'I',
   l_element_id);

Line: 1462


   update_class;

Line: 1465


   edw_owb_collection_util.INSERT_INTO_LOAD_PROGRESS(
   l_progress_seq_id,
   g_dimension_name,
   l_element_id,
   null,
   null,
   sysdate,
   null,
   null,
   100,
   'U',
   l_element_id);

Line: 1478


   edw_owb_collection_util.INSERT_INTO_LOAD_PROGRESS(
   l_progress_seq_id,
   g_dimension_name,
   l_element_id,
   'Insert Lowest Level into Dimension Table',
   sysdate,
   null,
   null,
   null,
   110,
   'I',
   l_element_id);

Line: 1493


   insert_default_values(l_seq_name);

Line: 1494


   logTime('Inserting default values to dimension star table for active values', l_log_timestamp);

Line: 1498


   insert_default_value('NA_EDW',0,g_na_edw,g_na_edw);

Line: 1499


   logTime('Inserting default value for NA_EDW ', l_log_timestamp);

Line: 1503


   insert_default_value('NA_ERR',-1,g_na_err,g_na_err);

Line: 1504


   logTime('Inserting default value for NA_ERR ', l_log_timestamp);

Line: 1509


   insert_non_active_values;

Line: 1510


   logTime('Inserting default values into dimension star table for non-active nodes', l_log_timestamp);

Line: 1516


   edw_owb_collection_util.INSERT_INTO_LOAD_PROGRESS(
   l_progress_seq_id,
   g_dimension_name,
   l_element_id,
   null,
   null,
   sysdate,
   null,
   null,
   110,
   'U',
   l_element_id);

Line: 1531


     SELECT distinct e1.edw_set_of_books_id,e1.root_value1,e1.root_value2,
                                         e1.root_value3,e1.root_value4
     FROM edw_vbh_roots e1, edw_set_of_books e2
     WHERE e1.edw_set_of_books_id=e2.edw_set_of_books_id
          and e1.segment_name =(
            select segment_name
            FROM   EDW_FLEX_SEG_MAPPINGS_V
            WHERE  DIMENSION_SHORT_NAME=g_dimension_name
            and    structure_num=e2.chart_of_accounts_id
            and    lower(instance_code)=lower(e2.instance));

Line: 1554


       l_CursorID := PARSE_UPDATE(l_hierachy_no);

Line: 1557


       edw_owb_collection_util.INSERT_INTO_LOAD_PROGRESS(
         l_progress_seq_id,
         g_dimension_name,
         l_element_id,
         'Build Hierarchy '|| l_hierachy_no,
         sysdate,
         null,
         null,
         null,
         110+ l_hierachy_no,
         'I',
         l_element_id);

Line: 1573


         l_rowsUpdated := PROCESS_ROOT(l_root_value,l_hierachy_no, l_CursorID);

Line: 1574


         g_rows_updated:=g_rows_updated+l_rowsUpdated;

Line: 1576


         l_rowsUpdated := PROCESS_ROOT_HIR(l_root_value,l_hierachy_no, l_CursorID);

Line: 1577


         g_rows_updated:=g_rows_updated+l_rowsUpdated;

Line: 1580


         CLOSE_UPDATE(l_CursorID);

Line: 1588


       edw_owb_collection_util.INSERT_INTO_LOAD_PROGRESS(
         l_progress_seq_id,
         g_dimension_name,
         l_element_id,
         null,
         null,
         sysdate,
         null,
         null,
         110+ l_hierachy_no,
         'U',
         l_element_id);

Line: 1632


       g_rows_updated,
       g_rows_updated,
       null,
       null,
       null,
       'SUCCESS',
       'SUCCESS', l_progress_seq_id);

Line: 1659


      g_rows_updated,
      g_rows_updated,null,null,null,
      'WARNING',
      'WARNING', l_progress_seq_id);

Line: 1675


      g_rows_updated,
      g_rows_updated,null,null,null,
      'ERROR',
      'ERROR',l_progress_seq_id);

Line: 1682


 edw_log.put_line('Total number of rows updated: '||g_rows_updated );

Line: 1728


  SELECT oracle_username
  FROM fnd_oracle_userid WHERE oracle_id
  BETWEEN 900 AND 999 AND read_only_flag = 'U';

Line: 1763


  SELECT MVIEW_NAME FROM ALL_MVIEWS WHERE OWNER = p_schema_name
  AND MVIEW_NAME= p_mv_name;

Line: 1773


  select version into db_versn from v$instance;

Line: 1775


  select replace(substr(version,1,instr(version,'.',1,2)-1),'.') into db_versn from v$instance;

Line: 1777


  l_stmt:= 'select tablespace_name from all_tables where table_name='''||g_dimension_name||''' and owner='''||get_bis_schema_name||'''';

Line: 1803


          l_stmt_mvcrt := 'CREATE MATERIALIZED VIEW '|| l_mview_name||' TABLESPACE '||l_tspace_name || ' ENABLE QUERY REWRITE AS SELECT DISTINCT '|| 'H'||l_lvl_num||'_NAME'||' FROM '||g_dimension_name;