APPS.BSC_BIS_DIM_OBJ_PUB dependencies on BSC_DB_TABLES_COLS

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 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