APPS.BSC_METADATA SQL Statements

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

Line: 118

    l_dimensions.delete;

Line: 150

for now, we will call bsc_update_dim.Get_Dbi_Dim_Data

called only for NON REC dim
DBI dim are single level dim. we should modify this api to handle multi level dim
*/
procedure get_dim_data_source(
p_level_list dbms_sql.varchar2_table,
p_level_pk_col out nocopy dbms_sql.varchar2_table,
p_data_source out nocopy varchar2,
p_inc_data_source out nocopy varchar2
) is
--
l_level_short_name varchar2(100);

Line: 163

l_data_source BSC_UPDATE_DIM.t_dbi_dim_data;

Line: 168

    bsc_update_dim.Get_Dbi_Dim_Data(l_level_short_name,l_data_source);

Line: 177

        p_data_source:='(select '||l_code||' from '||l_data_source.table_name||')';

Line: 178

        p_inc_data_source:='(select '||l_code||' from '||l_data_source.table_name||')';

Line: 180

        p_data_source:='(select distinct '||l_code||' from '||l_data_source.from_clause||' '||l_data_source.where_clause||')';

Line: 181

        p_inc_data_source:='(select distinct '||l_code||' from '||l_data_source.from_clause||' '||l_data_source.where_clause||')';

Line: 209

l_data_source BSC_UPDATE_DIM.t_dbi_dim_data;

Line: 214

  bsc_update_dim.Get_Dbi_Dim_Data(l_level_short_name,l_data_source);

Line: 219

    p_denorm_data_source:='(select '||p_child_col||','||p_parent_col||' from '||l_data_source.denorm_table||')';

Line: 220

    p_denorm_change_data_source:='select child_value '||p_child_col||', parent_value '||p_parent_col||' from bsc_aw_rec_dim_hier_change ';

Line: 813

  return BSC_DBGEN_METADATA_READER.get_last_update_date_for_fact(p_kpi);