APPS.BSC_DIMENSION_SETS_PVT dependencies on BSC_KPI_DIM_LEVEL_PROPERTIES

Line 908: from BSC_KPI_DIM_LEVEL_PROPERTIES

904: -- combination have been set.
905: IF (p_Dim_Set_Rec.Bsc_Level_Id IS NOT NULL) THEN
906: select count(*)
907: into l_count
908: from BSC_KPI_DIM_LEVEL_PROPERTIES
909: where indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
910: and dim_set_id = p_Dim_Set_Rec.Bsc_Dim_Set_Id
911: and dim_level_id = p_Dim_Set_Rec.Bsc_Level_Id;
912:

Line 916: g_db_object := 'BSC_KPI_DIM_LEVEL_PROPERTIES';

912:
913: -- If properties have not been set then go ahead and set them, else raise an error.
914: if l_count = 0 then
915:
916: g_db_object := 'BSC_KPI_DIM_LEVEL_PROPERTIES';
917:
918: -- Insert pertaining values into table bsc_kpi_dim_level_properties.
919: -- Reminder: Some values are hard coded, need to get the source.
920: insert into BSC_KPI_DIM_LEVEL_PROPERTIES( indicator

Line 918: -- Insert pertaining values into table bsc_kpi_dim_level_properties.

914: if l_count = 0 then
915:
916: g_db_object := 'BSC_KPI_DIM_LEVEL_PROPERTIES';
917:
918: -- Insert pertaining values into table bsc_kpi_dim_level_properties.
919: -- Reminder: Some values are hard coded, need to get the source.
920: insert into BSC_KPI_DIM_LEVEL_PROPERTIES( indicator
921: ,dim_set_id
922: ,dim_level_id

Line 920: insert into BSC_KPI_DIM_LEVEL_PROPERTIES( indicator

916: g_db_object := 'BSC_KPI_DIM_LEVEL_PROPERTIES';
917:
918: -- Insert pertaining values into table bsc_kpi_dim_level_properties.
919: -- Reminder: Some values are hard coded, need to get the source.
920: insert into BSC_KPI_DIM_LEVEL_PROPERTIES( indicator
921: ,dim_set_id
922: ,dim_level_id
923: ,position
924: ,total0

Line 1034: from BSC_KPI_DIM_LEVEL_PROPERTIES

1030: ,x_Dim_Set_Rec.Bsc_Dset_User_Level1
1031: ,x_Dim_Set_Rec.Bsc_Dset_User_Level1_Default
1032: ,x_Dim_Set_Rec.Bsc_Dset_User_Level2
1033: ,x_Dim_Set_Rec.Bsc_Dset_User_Level2_Default
1034: from BSC_KPI_DIM_LEVEL_PROPERTIES
1035: where indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
1036: and dim_set_id = p_Dim_Set_Rec.Bsc_Dim_Set_Id
1037: and dim_level_id = p_Dim_Set_Rec.Bsc_Level_Id;
1038:

Line 1196: update BSC_KPI_DIM_LEVEL_PROPERTIES

1192: if p_Dim_Set_Rec.Bsc_Dset_User_Level2_Default is not null then
1193: l_Dim_Set_Rec.Bsc_Dset_User_Level2_Default := p_Dim_Set_Rec.Bsc_Dset_User_Level2_Default;
1194: end if;
1195:
1196: update BSC_KPI_DIM_LEVEL_PROPERTIES
1197: set position = l_Dim_Set_Rec.Bsc_Dset_Position
1198: ,total0 = l_Dim_Set_Rec.Bsc_Dset_Total0
1199: ,level_display = l_Dim_Set_Rec.Bsc_Dset_Level_Display
1200: ,default_key_value = l_Dim_Set_Rec.Bsc_Dset_Default_Key_Value

Line 1306: delete from BSC_KPI_DIM_LEVEL_PROPERTIES

1302: RAISE FND_API.G_EXC_ERROR;
1303: end if;
1304:
1305:
1306: delete from BSC_KPI_DIM_LEVEL_PROPERTIES
1307: where indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
1308: and dim_set_id = p_Dim_Set_Rec.Bsc_Dim_Set_Id
1309: and dim_level_id = p_Dim_Set_Rec.Bsc_Level_Id;
1310: