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_UPDATE_DIM dependencies on BSC_IM_UTILS

Line 122: if bsc_im_utils.g_debug then

118: IF NOT BSC_APPS.Table_Exists(l_table_name) THEN
119: l_sql := 'CREATE TABLE '||l_table_name||' ('||l_lst_cols_desc||')'||
120: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.summary_table_tbs_type)||
121: ' '||BSC_APPS.bsc_storage_clause;
122: if bsc_im_utils.g_debug then
123: write_to_log_file_n(l_sql);
124: end if;
125: BSC_APPS.Do_DDL(l_sql, AD_DDL.CREATE_TABLE, l_table_name);
126: END IF;

Line 144: if bsc_im_utils.g_debug then

140: -- PK does not exists
141: l_constraint_name := substr(l_table_name,1,29)||'P';
142: l_sql := 'ALTER TABLE '||l_table_name||
143: ' ADD CONSTRAINT '||l_constraint_name||' PRIMARY KEY(USER_CODE) RELY ENABLE NOVALIDATE';
144: if bsc_im_utils.g_debug then
145: write_to_log_file_n(l_sql);
146: end if;
147: BSC_APPS.Do_DDL(l_sql, AD_DDL.ALTER_TABLE, l_table_name);
148: END IF;

Line 154: IF BSC_IM_UTILS.get_db_version = '9i' THEN

150: -- Create mv log
151: l_sql := 'CREATE MATERIALIZED VIEW LOG ON '||l_table_owner||'.'||l_table_name||
152: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.summary_table_tbs_type)||
153: ' '||BSC_APPS.bsc_storage_clause||' WITH';
154: IF BSC_IM_UTILS.get_db_version = '9i' THEN
155: l_sql := l_sql||' SEQUENCE,';
156: END IF;
157: l_sql := l_sql||' PRIMARY KEY, ROWID(CODE';
158: IF l_num_parent_columns > 0 THEN

Line 163: if bsc_im_utils.g_debug then

159: l_sql := l_sql||','||BSC_UPDATE_UTIL.Make_Lst_From_Array_Varchar2(l_parent_columns, l_num_parent_columns);
160: END IF;
161: l_sql := l_sql||')';
162: l_sql := l_sql||' INCLUDING NEW VALUES';
163: if bsc_im_utils.g_debug then
164: write_to_log_file_n(l_sql);
165: end if;
166: EXECUTE IMMEDIATE l_sql;
167: END IF;

Line 175: if bsc_im_utils.g_debug then

171: l_sql := 'CREATE UNIQUE INDEX '||l_index_name||
172: ' ON '||l_table_name||' (USER_CODE)'||
173: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.summary_index_tbs_type)||
174: ' '||BSC_APPS.bsc_storage_clause;
175: if bsc_im_utils.g_debug then
176: write_to_log_file_n(l_sql);
177: end if;
178: begin
179: BSC_APPS.Do_DDL(l_sql, AD_DDL.CREATE_INDEX, l_index_name);

Line 201: if bsc_im_utils.g_debug then

197: IF NOT BSC_APPS.Table_Exists(l_table_name) THEN
198: l_sql := 'CREATE TABLE '||l_table_name||' ('||l_lst_cols_desc||')'||
199: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.summary_table_tbs_type)||
200: ' '||BSC_APPS.bsc_storage_clause;
201: if bsc_im_utils.g_debug then
202: write_to_log_file_n(l_sql);
203: end if;
204: BSC_APPS.Do_DDL(l_sql, AD_DDL.CREATE_TABLE, l_table_name);
205: END IF;

Line 213: if bsc_im_utils.g_debug then

209: l_sql := 'CREATE INDEX '||l_index_name||
210: ' ON '||l_table_name||' ('||g_dbi_dim_data(l_i).parent_col||')'||
211: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.summary_index_tbs_type)||
212: ' '||BSC_APPS.bsc_storage_clause;
213: if bsc_im_utils.g_debug then
214: write_to_log_file_n(l_sql);
215: end if;
216: begin
217: BSC_APPS.Do_DDL(l_sql, AD_DDL.CREATE_INDEX, l_index_name);

Line 2422: l_owner:=bsc_im_utils.get_table_owner('ENI_DENORM_HIERARCHIES');

2418: g_dbi_dim_data(l_i).parent4_col := NULL;
2419: g_dbi_dim_data(l_i).parent5_col := NULL;
2420:
2421: l_i := l_i + 1;
2422: l_owner:=bsc_im_utils.get_table_owner('ENI_DENORM_HIERARCHIES');
2423: g_dbi_dim_data(l_i).short_name := 'ENI_ITEM_VBH_CAT';
2424: g_dbi_dim_data(l_i).table_name := 'BSC_D_ENI_ITEM_VBH_CAT_T';
2425: g_dbi_dim_data(l_i).from_clause := l_owner||'.eni_denorm_hierarchies';
2426: g_dbi_dim_data(l_i).where_clause := ' where imm_child_id=child_id and imm_child_id=parent_id ';

Line 2671: l_owner:=bsc_im_utils.get_table_owner('ENI_OLTP_ITEM_STAR');

2667: g_dbi_dim_data(l_i).parent4_col := NULL;
2668: g_dbi_dim_data(l_i).parent5_col := NULL;
2669:
2670: l_i := l_i + 1;
2671: l_owner:=bsc_im_utils.get_table_owner('ENI_OLTP_ITEM_STAR');
2672: g_dbi_dim_data(l_i).short_name := 'ENI_ITEM_ORG';
2673: g_dbi_dim_data(l_i).table_name := 'BSC_D_ENI_ITEM_ORG_T';
2674: g_dbi_dim_data(l_i).from_clause := l_owner||'.ENI_OLTP_ITEM_STAR';
2675: g_dbi_dim_data(l_i).where_clause := NULL;

Line 4066: if bsc_im_utils.g_debug then

4062: l_sql := 'INSERT /*+ parallel(BSC_TMP_DBI_DIM) */'||
4063: ' INTO BSC_TMP_DBI_DIM ('||l_lst_select_tmp||')'||
4064: ' SELECT /*+ parallel('||l_source_object_alias||') */ DISTINCT '||l_lst_select_src||
4065: ' FROM '||l_source_object;
4066: if bsc_im_utils.g_debug then
4067: write_to_log_file_n(l_sql);
4068: end if;
4069: BSC_UPDATE_UTIL.Execute_Immediate(l_sql);
4070: COMMIT;

Line 4077: if bsc_im_utils.g_debug then

4073: l_sql := 'INSERT /*+ parallel(BSC_TMP_DBI_DIM_ADD) */'||
4074: ' INTO BSC_TMP_DBI_DIM_ADD (USER_CODE)'||
4075: ' SELECT USER_CODE'||
4076: ' FROM BSC_TMP_DBI_DIM MINUS select USER_CODE from '||l_dbi_dim_data.table_name;
4077: if bsc_im_utils.g_debug then
4078: write_to_log_file_n(l_sql);
4079: end if;
4080: BSC_UPDATE_UTIL.Execute_Immediate(l_sql);
4081: COMMIT;

Line 4088: if bsc_im_utils.g_debug then

4084: l_sql := 'INSERT /*+ parallel(BSC_TMP_DBI_DIM_DEL) */'||
4085: ' INTO BSC_TMP_DBI_DIM_DEL (USER_CODE)'||
4086: ' SELECT USER_CODE'||
4087: ' FROM '||l_dbi_dim_data.table_name||' MINUS select USER_CODE from BSC_TMP_DBI_DIM';
4088: if bsc_im_utils.g_debug then
4089: write_to_log_file_n(l_sql);
4090: end if;
4091: BSC_UPDATE_UTIL.Execute_Immediate(l_sql);
4092: COMMIT;

Line 4101: if bsc_im_utils.g_debug then

4097: l_sql := 'INSERT /*+ parallel(BSC_AW_DIM_DELETE) */'||
4098: ' INTO BSC_AW_DIM_DELETE (DIM_LEVEL, DELETE_VALUE)'||
4099: ' SELECT :1, CODE'||
4100: ' FROM '||l_dbi_dim_data.table_name||' MINUS SELECT :2, CODE FROM BSC_TMP_DBI_DIM';
4101: if bsc_im_utils.g_debug then
4102: write_to_log_file_n(l_sql);
4103: end if;
4104: EXECUTE IMMEDIATE l_sql USING l_level_table_name, l_level_table_name;
4105: COMMIT;

Line 4124: if bsc_im_utils.g_debug then

4120: IF l_cond_eff_date IS NOT NULL THEN
4121: l_sql := l_sql||' AND '||l_cond_eff_date;
4122: END IF;
4123: l_sql := l_sql||' )';
4124: if bsc_im_utils.g_debug then
4125: write_to_log_file_n(l_sql);
4126: end if;
4127: BSC_UPDATE_UTIL.Execute_Immediate(l_sql);
4128: END IF;

Line 4136: if bsc_im_utils.g_debug then

4132: ' INTO '||l_dbi_dim_data.table_name||' ('||l_lst_select||')'||
4133: ' SELECT '||l_lst_select_tmp_t||
4134: ' FROM BSC_TMP_DBI_DIM T, BSC_TMP_DBI_DIM_ADD N'||
4135: ' WHERE T.USER_CODE = N.USER_CODE';
4136: if bsc_im_utils.g_debug then
4137: write_to_log_file_n(l_sql);
4138: end if;
4139: BSC_UPDATE_UTIL.Execute_Immediate(l_sql);
4140:

Line 4144: if bsc_im_utils.g_debug then

4140:
4141: -- Delete from DIM_TABLE
4142: l_sql := 'DELETE FROM '||l_dbi_dim_data.table_name||
4143: ' WHERE USER_CODE IN (SELECT USER_CODE FROM BSC_TMP_DBI_DIM_DEL)';
4144: if bsc_im_utils.g_debug then
4145: write_to_log_file_n(l_sql);
4146: end if;
4147: BSC_UPDATE_UTIL.Execute_Immediate(l_sql);
4148:

Line 4181: if bsc_im_utils.g_debug then

4177: ' FROM BSC_AW_DIM_DATA'||
4178: ' WHERE DIM_LEVEL = :1'||
4179: ' MINUS '||
4180: ' SELECT :2, TO_CHAR(CODE) FROM '||l_level_table_name;
4181: if bsc_im_utils.g_debug then
4182: write_to_log_file_n(l_sql);
4183: end if;
4184: EXECUTE IMMEDIATE l_sql USING l_level_table_name, l_level_table_name;
4185: COMMIT;

Line 5192: BSC_IM_UTILS.write_to_log_file(p_message);

5188: END WriteRemovedKeyItems;
5189:
5190: procedure write_to_log_file(p_message varchar2) is
5191: Begin
5192: BSC_IM_UTILS.write_to_log_file(p_message);
5193: Exception when others then
5194: BSC_IM_UTILS.g_status_message:=sqlerrm;
5195: null;
5196: End;

Line 5194: BSC_IM_UTILS.g_status_message:=sqlerrm;

5190: procedure write_to_log_file(p_message varchar2) is
5191: Begin
5192: BSC_IM_UTILS.write_to_log_file(p_message);
5193: Exception when others then
5194: BSC_IM_UTILS.g_status_message:=sqlerrm;
5195: null;
5196: End;
5197:
5198: procedure write_to_log_file_n(p_message varchar2) is

Line 5203: BSC_IM_UTILS.g_status_message:=sqlerrm;

5199: begin
5200: write_to_log_file(' ');
5201: write_to_log_file(p_message);
5202: Exception when others then
5203: BSC_IM_UTILS.g_status_message:=sqlerrm;
5204: null;
5205: end;
5206:
5207: