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_BIS_DIM_OBJ_PUB dependencies on BSC_DB_TABLES

Line 4437: --insert into BSC_DB_TABLES_RELS & BSC_DB_TABLES

4433: ' AND T.LANGUAGE = L.LANGUAGE_CODE) ';
4434:
4435: EXECUTE IMMEDIATE l_sql_stmt USING i_project;
4436: END LOOP;
4437: --insert into BSC_DB_TABLES_RELS & BSC_DB_TABLES
4438:
4439: INSERT INTO BSC_DB_TABLES_RELS
4440: (Table_Name, Source_Table_Name, Relation_Type)
4441: VALUES (l_master_table, l_input_table, 0);

Line 4439: INSERT INTO BSC_DB_TABLES_RELS

4435: EXECUTE IMMEDIATE l_sql_stmt USING i_project;
4436: END LOOP;
4437: --insert into BSC_DB_TABLES_RELS & BSC_DB_TABLES
4438:
4439: INSERT INTO BSC_DB_TABLES_RELS
4440: (Table_Name, Source_Table_Name, Relation_Type)
4441: VALUES (l_master_table, l_input_table, 0);
4442:
4443: INSERT INTO BSC_DB_TABLES

Line 4443: INSERT INTO BSC_DB_TABLES

4439: INSERT INTO BSC_DB_TABLES_RELS
4440: (Table_Name, Source_Table_Name, Relation_Type)
4441: VALUES (l_master_table, l_input_table, 0);
4442:
4443: INSERT INTO BSC_DB_TABLES
4444: (Table_Name, Table_Type, Periodicity_Id,
4445: Source_Data_Type, Source_File_Name)
4446: VALUES (l_input_table, 2, 0, 0, NULL);
4447: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4554: FROM BSC_DB_TABLES_COLS COL

4550:
4551: CURSOR c_db_tables IS
4552: SELECT DISTINCT TAB.Table_Name AS TABLE_NAME
4553: , NVL(COL.Source_Column, COL.Column_Name) AS COLUMN_NAME
4554: FROM BSC_DB_TABLES_COLS COL
4555: , BSC_DB_TABLES TAB
4556: WHERE TAB.Table_Name = COL.Table_Name
4557: AND TAB.Table_Type = 0
4558: AND (UPPER(COL.Column_Name)) = UPPER(p_Dim_Level_Rec.Bsc_Pk_Col);

Line 4555: , BSC_DB_TABLES TAB

4551: CURSOR c_db_tables IS
4552: SELECT DISTINCT TAB.Table_Name AS TABLE_NAME
4553: , NVL(COL.Source_Column, COL.Column_Name) AS COLUMN_NAME
4554: FROM BSC_DB_TABLES_COLS COL
4555: , BSC_DB_TABLES TAB
4556: WHERE TAB.Table_Name = COL.Table_Name
4557: AND TAB.Table_Type = 0
4558: AND (UPPER(COL.Column_Name)) = UPPER(p_Dim_Level_Rec.Bsc_Pk_Col);
4559:

Line 4653: --check if Level_Pk_Col is differnt, is so update table BSC_DB_TABLES_COLS

4649: FND_MESSAGE.SET_NAME('BSC','BSC_DB_ERROR');
4650: FND_MSG_PUB.ADD;
4651: RAISE FND_API.G_EXC_ERROR;
4652: ELSE
4653: --check if Level_Pk_Col is differnt, is so update table BSC_DB_TABLES_COLS
4654: IF(UPPER(p_Dim_Level_Rec.Bsc_Pk_Col) <> UPPER(p_Dim_Level_Rec_Old.Bsc_Pk_Col)) THEN
4655: UPDATE BSC_DB_TABLES_COLS
4656: SET Source_Column = p_Dim_Level_Rec_Old.Bsc_Pk_Col
4657: WHERE UPPER(Column_Name) = UPPER(p_Dim_Level_Rec_Old.Bsc_Pk_Col)

Line 4655: UPDATE BSC_DB_TABLES_COLS

4651: RAISE FND_API.G_EXC_ERROR;
4652: ELSE
4653: --check if Level_Pk_Col is differnt, is so update table BSC_DB_TABLES_COLS
4654: IF(UPPER(p_Dim_Level_Rec.Bsc_Pk_Col) <> UPPER(p_Dim_Level_Rec_Old.Bsc_Pk_Col)) THEN
4655: UPDATE BSC_DB_TABLES_COLS
4656: SET Source_Column = p_Dim_Level_Rec_Old.Bsc_Pk_Col
4657: WHERE UPPER(Column_Name) = UPPER(p_Dim_Level_Rec_Old.Bsc_Pk_Col)
4658: AND Source_Column IS NULL;
4659:

Line 4660: UPDATE BSC_DB_TABLES_COLS

4656: SET Source_Column = p_Dim_Level_Rec_Old.Bsc_Pk_Col
4657: WHERE UPPER(Column_Name) = UPPER(p_Dim_Level_Rec_Old.Bsc_Pk_Col)
4658: AND Source_Column IS NULL;
4659:
4660: UPDATE BSC_DB_TABLES_COLS
4661: SET Column_Name = p_Dim_Level_Rec.Bsc_Pk_Col
4662: WHERE UPPER(Column_Name) = UPPER(p_Dim_Level_Rec_Old.Bsc_Pk_Col);
4663: END IF;
4664: --check if user-code size and disp-key size are different

Line 4747: --update BSC_DB_TABLES_RELS

4743: END LOOP;
4744: l_sql_stmt := 'DROP TABLE '||p_Dim_Level_Rec_Old.Bsc_Level_Name;
4745:
4746: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.drop_table, p_Dim_Level_Rec_Old.Bsc_Level_Name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4747: --update BSC_DB_TABLES_RELS
4748: UPDATE BSC_DB_TABLES_RELS
4749: SET Table_Name = l_master_table
4750: WHERE Source_Table_Name = l_input_table;
4751: END IF;

Line 4748: UPDATE BSC_DB_TABLES_RELS

4744: l_sql_stmt := 'DROP TABLE '||p_Dim_Level_Rec_Old.Bsc_Level_Name;
4745:
4746: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.drop_table, p_Dim_Level_Rec_Old.Bsc_Level_Name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4747: --update BSC_DB_TABLES_RELS
4748: UPDATE BSC_DB_TABLES_RELS
4749: SET Table_Name = l_master_table
4750: WHERE Source_Table_Name = l_input_table;
4751: END IF;
4752: IF (l_Create_View) THEN

Line 4954: --update BSC_DB_TABLES_RELS

4950: l_sql_stmt := 'DROP TABLE '||l_old_mas_name;
4951: -- -----
4952: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.drop_table, l_old_mas_name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4953:
4954: --update BSC_DB_TABLES_RELS
4955: UPDATE BSC_DB_TABLES_RELS
4956: SET Table_Name = l_master_table
4957: WHERE Source_Table_Name = l_input_table;
4958: END IF;

Line 4955: UPDATE BSC_DB_TABLES_RELS

4951: -- -----
4952: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.drop_table, l_old_mas_name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4953:
4954: --update BSC_DB_TABLES_RELS
4955: UPDATE BSC_DB_TABLES_RELS
4956: SET Table_Name = l_master_table
4957: WHERE Source_Table_Name = l_input_table;
4958: END IF;
4959: --if level_pk_col is different than change the names of table columns