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_APPS

Line 87: BSC_APPS.Init_Bsc_Apps;

83: IF g_dbi_dim_tables_set THEN
84: RETURN TRUE;
85: END IF;
86:
87: BSC_APPS.Init_Bsc_Apps;
88: Init_Dbi_Dim_Data;
89:
90: l_table_owner := UPPER(BSC_APPS.bsc_apps_schema);
91:

Line 90: l_table_owner := UPPER(BSC_APPS.bsc_apps_schema);

86:
87: BSC_APPS.Init_Bsc_Apps;
88: Init_Dbi_Dim_Data;
89:
90: l_table_owner := UPPER(BSC_APPS.bsc_apps_schema);
91:
92: FOR l_i IN 1..g_dbi_dim_data.COUNT LOOP
93: l_table_name := g_dbi_dim_data(l_i).table_name;
94: l_short_name := g_dbi_dim_data(l_i).short_name;

Line 118: IF NOT BSC_APPS.Table_Exists(l_table_name) THEN

114: --if not BSC_UPDATE_UTIL.Drop_Table(l_table_name) then
115: --null;
116: --end if;
117: -- Create the table, if it does not exists
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

Line 120: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.summary_table_tbs_type)||

116: --end if;
117: -- Create the table, if it does not exists
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;

Line 121: ' '||BSC_APPS.bsc_storage_clause;

117: -- Create the table, if it does not exists
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);

Line 125: BSC_APPS.Do_DDL(l_sql, AD_DDL.CREATE_TABLE, l_table_name);

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;
127:
128: -- Create the mv log
129: SELECT COUNT(1) INTO l_count

Line 147: BSC_APPS.Do_DDL(l_sql, AD_DDL.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;
149:
150: -- Create mv log
151: l_sql := 'CREATE MATERIALIZED VIEW LOG ON '||l_table_owner||'.'||l_table_name||

Line 152: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.summary_table_tbs_type)||

148: END IF;
149:
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;

Line 153: ' '||BSC_APPS.bsc_storage_clause||' WITH';

149:
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';

Line 170: IF NOT BSC_APPS.Index_Exists(l_index_name) THEN

166: EXECUTE IMMEDIATE l_sql;
167: END IF;
168: -- Create the Unique Index
169: l_index_name := substr(l_table_name,1,29)||'U';
170: IF NOT BSC_APPS.Index_Exists(l_index_name) 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;

Line 173: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.summary_index_tbs_type)||

169: l_index_name := substr(l_table_name,1,29)||'U';
170: IF NOT BSC_APPS.Index_Exists(l_index_name) 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;

Line 174: ' '||BSC_APPS.bsc_storage_clause;

170: IF NOT BSC_APPS.Index_Exists(l_index_name) 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

Line 179: BSC_APPS.Do_DDL(l_sql, AD_DDL.CREATE_INDEX, l_index_name);

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);
180: exception
181: when l_col_already_indexed then
182: null;
183: end;

Line 197: IF NOT BSC_APPS.Table_Exists(l_table_name) THEN

193: IF l_date_tracked_dim = 'YES' THEN
194: l_lst_cols_desc := l_lst_cols_desc||', EFFECTIVE_START_DATE DATE, EFFECTIVE_END_DATE DATE';
195: END IF;
196:
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

Line 199: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.summary_table_tbs_type)||

195: END IF;
196:
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;

Line 200: ' '||BSC_APPS.bsc_storage_clause;

196:
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);

Line 204: BSC_APPS.Do_DDL(l_sql, AD_DDL.CREATE_TABLE, l_table_name);

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;
206: -- Create the Index
207: l_index_name := substr(l_table_name,1,29)||'N';
208: IF NOT BSC_APPS.Index_Exists(l_index_name) THEN

Line 208: IF NOT BSC_APPS.Index_Exists(l_index_name) THEN

204: BSC_APPS.Do_DDL(l_sql, AD_DDL.CREATE_TABLE, l_table_name);
205: END IF;
206: -- Create the Index
207: l_index_name := substr(l_table_name,1,29)||'N';
208: IF NOT BSC_APPS.Index_Exists(l_index_name) 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;

Line 211: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.summary_index_tbs_type)||

207: l_index_name := substr(l_table_name,1,29)||'N';
208: IF NOT BSC_APPS.Index_Exists(l_index_name) 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;

Line 212: ' '||BSC_APPS.bsc_storage_clause;

208: IF NOT BSC_APPS.Index_Exists(l_index_name) 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

Line 217: BSC_APPS.Do_DDL(l_sql, AD_DDL.CREATE_INDEX, l_index_name);

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);
218: exception
219: when l_col_already_indexed then
220: null;
221: end;

Line 250: h_tablespace := BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_table_tbs_type);

246: h_tablespace VARCHAR2(80);
247: h_idx_tablespace VARCHAR2(80);
248:
249: BEGIN
250: h_tablespace := BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_table_tbs_type);
251: h_idx_tablespace := BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_index_tbs_type);
252:
253: -- BSC_AW_DIM_DELETE
254: h_table_name := 'BSC_AW_DIM_DELETE';

Line 251: h_idx_tablespace := BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_index_tbs_type);

247: h_idx_tablespace VARCHAR2(80);
248:
249: BEGIN
250: h_tablespace := BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_table_tbs_type);
251: h_idx_tablespace := BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_index_tbs_type);
252:
253: -- BSC_AW_DIM_DELETE
254: h_table_name := 'BSC_AW_DIM_DELETE';
255: h_table_columns.delete;

Line 382: h_tablespace := BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_table_tbs_type);

378: h_tablespace VARCHAR2(80);
379: h_idx_tablespace VARCHAR2(80);
380:
381: BEGIN
382: h_tablespace := BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_table_tbs_type);
383: h_idx_tablespace := BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_index_tbs_type);
384:
385: -- BSC_TMP_DBI_DIM
386: h_table_name := 'BSC_TMP_DBI_DIM';

Line 383: h_idx_tablespace := BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_index_tbs_type);

379: h_idx_tablespace VARCHAR2(80);
380:
381: BEGIN
382: h_tablespace := BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_table_tbs_type);
383: h_idx_tablespace := BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_index_tbs_type);
384:
385: -- BSC_TMP_DBI_DIM
386: h_table_name := 'BSC_TMP_DBI_DIM';
387: h_table_columns.delete;

Line 590: h_condition := BSC_APPS.Get_New_Big_In_Cond_Number(1, h_level_pk_col);

586: -- because the affected indicators will be re-calculated later.
587: -- It is necessary to delete only from base tables.
588: -- This logic is valid for both architectures.
589:
590: h_condition := BSC_APPS.Get_New_Big_In_Cond_Number(1, h_level_pk_col);
591: FOR h_i IN 1..x_num_deleted_codes LOOP
592: BSC_APPS.Add_Value_Big_In_Cond(1, x_deleted_codes(h_i));
593: END LOOP;
594:

Line 592: BSC_APPS.Add_Value_Big_In_Cond(1, x_deleted_codes(h_i));

588: -- This logic is valid for both architectures.
589:
590: h_condition := BSC_APPS.Get_New_Big_In_Cond_Number(1, h_level_pk_col);
591: FOR h_i IN 1..x_num_deleted_codes LOOP
592: BSC_APPS.Add_Value_Big_In_Cond(1, x_deleted_codes(h_i));
593: END LOOP;
594:
595: IF NOT Delete_Key_Values_In_Tables(h_level_pk_col, h_condition) THEN
596: RAISE e_unexpected_error;

Line 604: h_condition := BSC_APPS.Get_New_Big_In_Cond_Number(1, h_level_pk_col);

600: --OPEN c_child_mn FOR c_child_mn_sql USING h_dim_level_id, 2;
601: OPEN c_child_mn(h_dim_level_id, 2);
602: FETCH c_child_mn INTO h_mn_dim_table, h_mn_level_pk_col;
603: WHILE c_child_mn%FOUND LOOP
604: h_condition := BSC_APPS.Get_New_Big_In_Cond_Number(1, h_level_pk_col);
605: FOR h_i IN 1..x_num_deleted_codes LOOP
606: BSC_APPS.Add_Value_Big_In_Cond(1, x_deleted_codes(h_i));
607: END LOOP;
608:

Line 606: BSC_APPS.Add_Value_Big_In_Cond(1, x_deleted_codes(h_i));

602: FETCH c_child_mn INTO h_mn_dim_table, h_mn_level_pk_col;
603: WHILE c_child_mn%FOUND LOOP
604: h_condition := BSC_APPS.Get_New_Big_In_Cond_Number(1, h_level_pk_col);
605: FOR h_i IN 1..x_num_deleted_codes LOOP
606: BSC_APPS.Add_Value_Big_In_Cond(1, x_deleted_codes(h_i));
607: END LOOP;
608:
609: h_sql := 'SELECT '||h_level_pk_col||', '||h_mn_level_pk_col||
610: ' FROM '||h_mn_dim_table||

Line 648: h_condition := BSC_APPS.Get_New_Big_In_Cond_Number(1, h_level_pk_col);

644: --OPEN c_child FOR c_child_sql USING h_dim_level_id, 1;
645: OPEN c_child(h_dim_level_id, 1);
646: FETCH c_child INTO h_child_dim_table;
647: WHILE c_child%FOUND LOOP
648: h_condition := BSC_APPS.Get_New_Big_In_Cond_Number(1, h_level_pk_col);
649: FOR h_i IN 1..x_num_deleted_codes LOOP
650: BSC_APPS.Add_Value_Big_In_Cond(1, x_deleted_codes(h_i));
651: END LOOP;
652:

Line 650: BSC_APPS.Add_Value_Big_In_Cond(1, x_deleted_codes(h_i));

646: FETCH c_child INTO h_child_dim_table;
647: WHILE c_child%FOUND LOOP
648: h_condition := BSC_APPS.Get_New_Big_In_Cond_Number(1, h_level_pk_col);
649: FOR h_i IN 1..x_num_deleted_codes LOOP
650: BSC_APPS.Add_Value_Big_In_Cond(1, x_deleted_codes(h_i));
651: END LOOP;
652:
653: h_sql := 'SELECT DISTINCT CODE FROM '||h_child_dim_table||
654: ' WHERE '||h_condition;

Line 691: h_condition := BSC_APPS.Get_New_Big_In_Cond_Number (1, 'CODE');

687: END LOOP;
688: CLOSE c_child;
689:
690: -- Delete records from the dimension table
691: h_condition := BSC_APPS.Get_New_Big_In_Cond_Number (1, 'CODE');
692: FOR h_i IN 1..x_num_deleted_codes LOOP
693: BSC_APPS.Add_Value_Big_In_Cond(1, x_deleted_codes(h_i));
694:
695: -- AW_INTEGRATION: Need to insert the deleted codes into BSC_AW_DIM_DELETE table

Line 693: BSC_APPS.Add_Value_Big_In_Cond(1, x_deleted_codes(h_i));

689:
690: -- Delete records from the dimension table
691: h_condition := BSC_APPS.Get_New_Big_In_Cond_Number (1, 'CODE');
692: FOR h_i IN 1..x_num_deleted_codes LOOP
693: BSC_APPS.Add_Value_Big_In_Cond(1, x_deleted_codes(h_i));
694:
695: -- AW_INTEGRATION: Need to insert the deleted codes into BSC_AW_DIM_DELETE table
696: IF Dimension_Used_In_AW_Kpi(x_dim_table) THEN
697: Insert_AW_Delete_Value(x_dim_table, x_deleted_codes(h_i));

Line 769: h_condition := BSC_APPS.Get_New_Big_In_Cond_Varchar2(1, x_key_column1||'||''-''||'||x_key_column2);

765: BEGIN
766:
767: h_column_type_p := 'P';
768:
769: h_condition := BSC_APPS.Get_New_Big_In_Cond_Varchar2(1, x_key_column1||'||''-''||'||x_key_column2);
770:
771: FOR h_i IN 1..x_num_deleted_codes LOOP
772: BSC_APPS.Add_Value_Big_In_Cond(1, x_deleted_codes1(h_i)||'-'||x_deleted_codes2(h_i));
773: END LOOP;

Line 772: BSC_APPS.Add_Value_Big_In_Cond(1, x_deleted_codes1(h_i)||'-'||x_deleted_codes2(h_i));

768:
769: h_condition := BSC_APPS.Get_New_Big_In_Cond_Varchar2(1, x_key_column1||'||''-''||'||x_key_column2);
770:
771: FOR h_i IN 1..x_num_deleted_codes LOOP
772: BSC_APPS.Add_Value_Big_In_Cond(1, x_deleted_codes1(h_i)||'-'||x_deleted_codes2(h_i));
773: END LOOP;
774:
775: -- Delete from system tables
776: -- BSC-MV Note: There is no need to delete data from summary tables

Line 995: l_where_level := BSC_APPS.Get_New_Big_In_Cond_Number(l_current_level, l_dbi_dim_data.parent_col_src);

991: ' AND ('||l_where_level||')';
992: OPEN l_cursor FOR l_sql;
993: END IF;
994:
995: l_where_level := BSC_APPS.Get_New_Big_In_Cond_Number(l_current_level, l_dbi_dim_data.parent_col_src);
996:
997: LOOP
998: FETCH l_cursor INTO l_id;
999: EXIT WHEN l_cursor%NOTFOUND;

Line 1000: BSC_APPS.Add_Value_Big_In_Cond(l_current_level, l_id);

996:
997: LOOP
998: FETCH l_cursor INTO l_id;
999: EXIT WHEN l_cursor%NOTFOUND;
1000: BSC_APPS.Add_Value_Big_In_Cond(l_current_level, l_id);
1001: l_num_ids_this_level := l_num_ids_this_level + 1;
1002: END LOOP;
1003: CLOSE l_cursor;
1004:

Line 1157: l_where_level := BSC_APPS.Get_New_Big_In_Cond_Number(l_current_level, l_dbi_dim_data.parent_col_src);

1153: ' WHERE '||l_src_condition||
1154: ' AND '||l_where_level;
1155: END IF;
1156: OPEN l_cursor FOR l_sql;
1157: l_where_level := BSC_APPS.Get_New_Big_In_Cond_Number(l_current_level, l_dbi_dim_data.parent_col_src);
1158: LOOP
1159: FETCH l_cursor INTO l_id;
1160: EXIT WHEN l_cursor%NOTFOUND;
1161: BSC_APPS.Add_Value_Big_In_Cond(l_current_level, l_id);

Line 1161: BSC_APPS.Add_Value_Big_In_Cond(l_current_level, l_id);

1157: l_where_level := BSC_APPS.Get_New_Big_In_Cond_Number(l_current_level, l_dbi_dim_data.parent_col_src);
1158: LOOP
1159: FETCH l_cursor INTO l_id;
1160: EXIT WHEN l_cursor%NOTFOUND;
1161: BSC_APPS.Add_Value_Big_In_Cond(l_current_level, l_id);
1162: l_num_ids_this_level := l_num_ids_this_level + 1;
1163: l_ids_this_level(l_num_ids_this_level) := l_id;
1164: END LOOP;
1165: CLOSE l_cursor;

Line 1463: l_where_level := BSC_APPS.Get_New_Big_In_Cond_Number(l_current_level, l_dbi_dim_data.parent_col_src);

1459: ' FROM '||l_dbi_dim_data.denorm_src_object||
1460: ' WHERE '||l_where_level;
1461: END IF;
1462: OPEN l_cursor FOR l_sql;
1463: l_where_level := BSC_APPS.Get_New_Big_In_Cond_Number(l_current_level, l_dbi_dim_data.parent_col_src);
1464: LOOP
1465: FETCH l_cursor INTO l_id;
1466: EXIT WHEN l_cursor%NOTFOUND;
1467: BSC_APPS.Add_Value_Big_In_Cond(l_current_level, l_id);

Line 1467: BSC_APPS.Add_Value_Big_In_Cond(l_current_level, l_id);

1463: l_where_level := BSC_APPS.Get_New_Big_In_Cond_Number(l_current_level, l_dbi_dim_data.parent_col_src);
1464: LOOP
1465: FETCH l_cursor INTO l_id;
1466: EXIT WHEN l_cursor%NOTFOUND;
1467: BSC_APPS.Add_Value_Big_In_Cond(l_current_level, l_id);
1468: l_num_ids_this_level := l_num_ids_this_level + 1;
1469: l_ids_this_level(l_num_ids_this_level) := l_id;
1470: END LOOP;
1471: CLOSE l_cursor;

Line 1875: h_where_indics := BSC_APPS.Get_New_Big_In_Cond_Number(1, 'indicator');

1871: h_sql := NULL;
1872: h_source := 'PMF';
1873: x_num_dbi_dimensions := 0;
1874:
1875: h_where_indics := BSC_APPS.Get_New_Big_In_Cond_Number(1, 'indicator');
1876: FOR h_i IN 1 .. x_num_indicators LOOP
1877: BSC_APPS.Add_Value_Big_In_Cond(1, x_indicators(h_i));
1878: END LOOP;
1879:

Line 1877: BSC_APPS.Add_Value_Big_In_Cond(1, x_indicators(h_i));

1873: x_num_dbi_dimensions := 0;
1874:
1875: h_where_indics := BSC_APPS.Get_New_Big_In_Cond_Number(1, 'indicator');
1876: FOR h_i IN 1 .. x_num_indicators LOOP
1877: BSC_APPS.Add_Value_Big_In_Cond(1, x_indicators(h_i));
1878: END LOOP;
1879:
1880: h_sql := 'SELECT DISTINCT level_shortname'||
1881: ' FROM bsc_kpi_dim_levels_vl'||

Line 3265: l_where_cond := BSC_APPS.Get_New_Big_In_Cond_Number(-999999, x_parent_col_src);

3261: IF x_num_ids = 0 THEN
3262: RETURN TRUE;
3263: END IF;
3264:
3265: l_where_cond := BSC_APPS.Get_New_Big_In_Cond_Number(-999999, x_parent_col_src);
3266: FOR l_i IN 1..x_num_ids LOOP
3267: BSC_APPS.Add_Value_Big_In_Cond(-999999, x_ids(l_i));
3268: END LOOP;
3269:

Line 3267: BSC_APPS.Add_Value_Big_In_Cond(-999999, x_ids(l_i));

3263: END IF;
3264:
3265: l_where_cond := BSC_APPS.Get_New_Big_In_Cond_Number(-999999, x_parent_col_src);
3266: FOR l_i IN 1..x_num_ids LOOP
3267: BSC_APPS.Add_Value_Big_In_Cond(-999999, x_ids(l_i));
3268: END LOOP;
3269:
3270: l_num_child_ids := 0;
3271: l_sql := 'SELECT DISTINCT '||x_child_col_src||

Line 3747: LAST_UPDATED_BY = BSC_APPS.fnd_global_user_id,

3743: -- Only if the table was modified.
3744: IF h_table_was_modified THEN
3745: UPDATE BSC_KPIS_B K
3746: SET PROTOTYPE_FLAG = 6,
3747: LAST_UPDATED_BY = BSC_APPS.fnd_global_user_id,
3748: LAST_UPDATE_DATE = SYSDATE
3749: WHERE INDICATOR IN (SELECT D.INDICATOR
3750: FROM BSC_KPI_DIM_LEVELS_B D
3751: WHERE K.INDICATOR = D.INDICATOR AND

Line 3966: IF BSC_APPS.Table_Exists(l_dbi_dim_data.table_name) THEN

3962: l_dim_for_mv_kpi := Dimension_Used_In_MV_Kpi(l_level_table_name);
3963:
3964: IF (l_dbi_dim_data.table_name IS NOT NULL) AND (l_dbi_dim_data.materialized='YES') THEN
3965: --Fix bug#3780702: If the table does not exist we do not do anything.
3966: IF BSC_APPS.Table_Exists(l_dbi_dim_data.table_name) THEN
3967: IF l_dbi_dim_data.source_object IS NULL THEN
3968: l_source_object := Get_Dbi_Dim_View_Name(x_dim_short_name);
3969: ELSE
3970: l_source_object := l_dbi_dim_data.source_object;

Line 4190: IF BSC_APPS.bsc_mv AND l_dim_for_mv_kpi THEN

4186: END IF;
4187:
4188: -- RECURSIVE_DIMS: Refresh the denorm table. We do this only in MV architecture and
4189: -- if the dimension is used by a MV indicator
4190: IF BSC_APPS.bsc_mv AND l_dim_for_mv_kpi THEN
4191: IF Is_Recursive_Dim(l_level_table_name) THEN
4192: l_denorm_table_name := BSC_DBGEN_METADATA_READER.get_denorm_dimension_table(x_dim_short_name);
4193: IF l_denorm_table_name IS NOT NULL THEN
4194: IF NOT Refresh_Denorm_Table(l_level_table_name, l_denorm_table_name) THEN

Line 4287: -- Initialize BSC/APPS global variables

4283: --LOCKING
4284: e_could_not_get_lock EXCEPTION;
4285:
4286: BEGIN
4287: -- Initialize BSC/APPS global variables
4288: BSC_APPS.Init_Bsc_Apps;
4289:
4290: -- Initialize the error message stack
4291: BSC_MESSAGE.Init('NO');

Line 4288: BSC_APPS.Init_Bsc_Apps;

4284: e_could_not_get_lock EXCEPTION;
4285:
4286: BEGIN
4287: -- Initialize BSC/APPS global variables
4288: BSC_APPS.Init_Bsc_Apps;
4289:
4290: -- Initialize the error message stack
4291: BSC_MESSAGE.Init('NO');
4292:

Line 4379: IF NOT BSC_APPS.Table_Exists(x_denorm_table_name) THEN

4375:
4376:
4377: BEGIN
4378:
4379: IF NOT BSC_APPS.Table_Exists(x_denorm_table_name) THEN
4380: -- Denorm table does not exists
4381: RETURN TRUE;
4382: END IF;
4383:

Line 4607: ') TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.other_table_tbs_type)||

4603: END IF;
4604:
4605: h_sql := 'CREATE TABLE BSC_TMP_DIMENSION ('||
4606: 'CODE NUMBER'||h_lst_relation_cols_desc||
4607: ') TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.other_table_tbs_type)||
4608: ' '||BSC_APPS.bsc_storage_clause;
4609: BSC_APPS.Do_DDL(h_sql, AD_DDL.CREATE_TABLE, 'BSC_TMP_DIMENSION');
4610:
4611: -- Insert records

Line 4608: ' '||BSC_APPS.bsc_storage_clause;

4604:
4605: h_sql := 'CREATE TABLE BSC_TMP_DIMENSION ('||
4606: 'CODE NUMBER'||h_lst_relation_cols_desc||
4607: ') TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.other_table_tbs_type)||
4608: ' '||BSC_APPS.bsc_storage_clause;
4609: BSC_APPS.Do_DDL(h_sql, AD_DDL.CREATE_TABLE, 'BSC_TMP_DIMENSION');
4610:
4611: -- Insert records
4612: h_sql := 'INSERT INTO BSC_TMP_DIMENSION (CODE'||h_lst_relation_cols||')'||

Line 4609: BSC_APPS.Do_DDL(h_sql, AD_DDL.CREATE_TABLE, 'BSC_TMP_DIMENSION');

4605: h_sql := 'CREATE TABLE BSC_TMP_DIMENSION ('||
4606: 'CODE NUMBER'||h_lst_relation_cols_desc||
4607: ') TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.other_table_tbs_type)||
4608: ' '||BSC_APPS.bsc_storage_clause;
4609: BSC_APPS.Do_DDL(h_sql, AD_DDL.CREATE_TABLE, 'BSC_TMP_DIMENSION');
4610:
4611: -- Insert records
4612: h_sql := 'INSERT INTO BSC_TMP_DIMENSION (CODE'||h_lst_relation_cols||')'||
4613: ' SELECT CODE'||h_lst_relation_cols||

Line 4621: BSC_APPS.other_index_tbs_type) THEN

4617: -- Create unique index
4618: IF NOT BSC_UPDATE_UTIL.Create_Unique_Index('BSC_TMP_DIMENSION',
4619: 'BSC_TMP_DIMENSION_U1',
4620: 'CODE',
4621: BSC_APPS.other_index_tbs_type) THEN
4622: RAISE e_unexpected_error;
4623: END IF;
4624:
4625: -- Refresh dimension table (materialized view)

Line 4626: DBMS_MVIEW.REFRESH(BSC_APPS.BSC_APPS_SCHEMA||'.'||x_dimension_table, 'AF', NULL, FALSE, FALSE, 0, 0, 0, TRUE);

4622: RAISE e_unexpected_error;
4623: END IF;
4624:
4625: -- Refresh dimension table (materialized view)
4626: DBMS_MVIEW.REFRESH(BSC_APPS.BSC_APPS_SCHEMA||'.'||x_dimension_table, 'AF', NULL, FALSE, FALSE, 0, 0, 0, TRUE);
4627:
4628: -- Get deleted records (records in BSC_TMP_DIMENSION that are not in x_dimension_table)
4629: h_num_deleted_records := Get_Deleted_Records(x_dimension_table, 'BSC_TMP_DIMENSION', h_deleted_records);
4630:

Line 4635: h_condition := BSC_APPS.Get_New_Big_In_Cond_Number(1, h_level_pk_col);

4631: IF h_num_deleted_records > 0 THEN
4632: -- Delete from all system tables rows for deleted values
4633:
4634: -- h_condition := BSC_UPDATE_UTIL.Make_Lst_Cond_Number(h_level_pk_col, h_deleted_records, h_num_deleted_records, 'OR');
4635: h_condition := BSC_APPS.Get_New_Big_In_Cond_Number(1, h_level_pk_col);
4636: FOR h_i IN 1..h_num_deleted_records LOOP
4637: BSC_APPS.Add_Value_Big_In_Cond(1, h_deleted_records(h_i));
4638: END LOOP;
4639:

Line 4637: BSC_APPS.Add_Value_Big_In_Cond(1, h_deleted_records(h_i));

4633:
4634: -- h_condition := BSC_UPDATE_UTIL.Make_Lst_Cond_Number(h_level_pk_col, h_deleted_records, h_num_deleted_records, 'OR');
4635: h_condition := BSC_APPS.Get_New_Big_In_Cond_Number(1, h_level_pk_col);
4636: FOR h_i IN 1..h_num_deleted_records LOOP
4637: BSC_APPS.Add_Value_Big_In_Cond(1, h_deleted_records(h_i));
4638: END LOOP;
4639:
4640: IF NOT Delete_Key_Values_In_Tables(h_level_pk_col, h_condition) THEN
4641: RAISE e_unexpected_error;

Line 4759: LAST_UPDATED_BY = BSC_APPS.fnd_global_user_id,

4755: FOR h_i IN 1..h_num_mod_dimensions LOOP
4756:
4757: UPDATE BSC_KPIS_B K
4758: SET PROTOTYPE_FLAG = 6,
4759: LAST_UPDATED_BY = BSC_APPS.fnd_global_user_id,
4760: LAST_UPDATE_DATE = SYSDATE
4761: WHERE INDICATOR IN (SELECT D.INDICATOR
4762: FROM BSC_KPI_DIM_LEVELS_B D
4763: WHERE K.INDICATOR = D.INDICATOR AND