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.BSC_AW_UTILITY dependencies on BSC_APPS

Line 1033: BSC_APPS.Init_Bsc_Apps;

1029: flag boolean;
1030: Begin
1031: /*use BSC api to do the creation same way as loader */
1032: table_name:='bsc_aw_dim_delete';
1033: BSC_APPS.Init_Bsc_Apps;
1034: l_tablespace:=BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_table_tbs_type);
1035: l_idx_tablespace:=BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_index_tbs_type);
1036: table_columns.delete;
1037: table_columns(table_columns.count+1).column_name:='DIM_LEVEL';

Line 1034: l_tablespace:=BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_table_tbs_type);

1030: Begin
1031: /*use BSC api to do the creation same way as loader */
1032: table_name:='bsc_aw_dim_delete';
1033: BSC_APPS.Init_Bsc_Apps;
1034: l_tablespace:=BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_table_tbs_type);
1035: l_idx_tablespace:=BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_index_tbs_type);
1036: table_columns.delete;
1037: table_columns(table_columns.count+1).column_name:='DIM_LEVEL';
1038: table_columns(table_columns.count).data_type:='VARCHAR2';

Line 1035: l_idx_tablespace:=BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_index_tbs_type);

1031: /*use BSC api to do the creation same way as loader */
1032: table_name:='bsc_aw_dim_delete';
1033: BSC_APPS.Init_Bsc_Apps;
1034: l_tablespace:=BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_table_tbs_type);
1035: l_idx_tablespace:=BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_index_tbs_type);
1036: table_columns.delete;
1037: table_columns(table_columns.count+1).column_name:='DIM_LEVEL';
1038: table_columns(table_columns.count).data_type:='VARCHAR2';
1039: table_columns(table_columns.count).data_size:=300;

Line 1053: BSC_APPS.Do_DDL(stmt,AD_DDL.DROP_TABLE,table_name);

1049: if all_tables(1).TEMPORARY='Y' then
1050: /*this is old implementation. drop and recreate */
1051: log(table_name||' is Temp Table. Dropping to create as permanent');
1052: stmt:='drop table '||table_name;
1053: BSC_APPS.Do_DDL(stmt,AD_DDL.DROP_TABLE,table_name);
1054: flag:=true;
1055: end if;
1056: else
1057: flag:=true;