APPS.BSC_DIMENSION_LEVELS_PVT dependencies on BSC_SYS_DIM_LEVEL_COLS

Line 1017: g_db_object := 'BSC_SYS_DIM_LEVEL_COLS';

1013: FND_MSG_PUB.ADD;
1014: RAISE FND_API.G_EXC_ERROR;
1015: end if;
1016:
1017: g_db_object := 'BSC_SYS_DIM_LEVEL_COLS';
1018:
1019: -- Insert pertaining values into table bsc_sys_dim_level_cols.
1020: insert into BSC_SYS_DIM_LEVEL_COLS( dim_level_id
1021: ,column_name

Line 1019: -- Insert pertaining values into table bsc_sys_dim_level_cols.

1015: end if;
1016:
1017: g_db_object := 'BSC_SYS_DIM_LEVEL_COLS';
1018:
1019: -- Insert pertaining values into table bsc_sys_dim_level_cols.
1020: insert into BSC_SYS_DIM_LEVEL_COLS( dim_level_id
1021: ,column_name
1022: ,column_type)
1023: values( p_Dim_Level_Rec.Bsc_Level_Id

Line 1020: insert into BSC_SYS_DIM_LEVEL_COLS( dim_level_id

1016:
1017: g_db_object := 'BSC_SYS_DIM_LEVEL_COLS';
1018:
1019: -- Insert pertaining values into table bsc_sys_dim_level_cols.
1020: insert into BSC_SYS_DIM_LEVEL_COLS( dim_level_id
1021: ,column_name
1022: ,column_type)
1023: values( p_Dim_Level_Rec.Bsc_Level_Id
1024: ,p_Dim_Level_Rec.Bsc_Level_Column_Name

Line 1098: from BSC_SYS_DIM_LEVEL_COLS

1094: g_db_object := 'Retrieve_Bsc_Sys_Dim_Lvl_Cols';
1095:
1096: select distinct column_name
1097: into x_Dim_Level_Rec.Bsc_Level_Column_Name
1098: from BSC_SYS_DIM_LEVEL_COLS
1099: where dim_level_id = p_Dim_Level_Rec.Bsc_Level_Id
1100: and column_type = p_Dim_Level_Rec.Bsc_Level_Column_Type;
1101:
1102: if (p_commit = FND_API.G_TRUE) then

Line 1191: update BSC_SYS_DIM_LEVEL_COLS

1187:
1188: -- In this case there is only one column that may be updated, therefore there is no
1189: -- retrieval of previous values.
1190:
1191: update BSC_SYS_DIM_LEVEL_COLS
1192: set column_name = l_Dim_Level_Rec.Bsc_Level_Column_Name
1193: where dim_level_id = l_Dim_Level_Rec.Bsc_Level_Id
1194: and column_type = l_Dim_Level_Rec.Bsc_Level_Column_Type;
1195:

Line 1261: delete from BSC_SYS_DIM_LEVEL_COLS

1257:
1258: begin
1259: x_return_status := FND_API.G_RET_STS_SUCCESS;
1260: SAVEPOINT DeleteBSCSysDimLevColsPVT;
1261: delete from BSC_SYS_DIM_LEVEL_COLS
1262: where dim_level_id = p_Dim_Level_Rec.Bsc_Level_Id;
1263:
1264: if (p_commit = FND_API.G_TRUE) then
1265: commit;