APPS.BSC_DIMENSION_SETS_PUB dependencies on BSC_KPI_DIM_GROUPS

Line 138: -- if group_id is null, than don't insert into BSC_KPI_DIM_GROUPS

134: --NOTE: wrapper needs to be written to determine what next dim set is.
135:
136: -- Call private version of the procedure.
137: -- PAJOHRI added if condition.
138: -- if group_id is null, than don't insert into BSC_KPI_DIM_GROUPS
139: IF ((l_Dim_Set_Rec.Bsc_Dim_Level_Group_Id IS NOT NULL) AND
140: (BSC_DIMENSION_SETS_PUB.Is_Valid_Dimension(l_Dim_Set_Rec.Bsc_Dim_Level_Group_Id))) THEN
141: BSC_DIMENSION_SETS_PVT.Create_Dim_Group_In_Dset( p_commit
142: ,l_Dim_Set_Rec

Line 149: FROM BSC_KPI_DIM_GROUPS KPI_GROUP

145: ,x_msg_data);
146: SELECT MAX(NUM) INTO l_count
147: FROM (SELECT COUNT(SYS_DIM_LEL.Dim_Group_Id) NUM
148: , SYS_DIM_LEL.Dim_Level_Id
149: FROM BSC_KPI_DIM_GROUPS KPI_GROUP
150: , BSC_SYS_DIM_LEVELS_BY_GROUP SYS_DIM_LEL
151: WHERE KPI_GROUP.Dim_Group_Id = SYS_DIM_LEL.Dim_Group_Id
152: AND KPI_GROUP.Indicator = l_Dim_Set_Rec.Bsc_Kpi_Id
153: AND KPI_GROUP.Dim_Set_Id = l_Dim_Set_Rec.Bsc_Dim_Set_Id

Line 175: -- if group_id is null, than don't insert into BSC_KPI_DIM_GROUPS, as there

171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
172: END IF;
173:
174: -- PAJOHRI added if condition.
175: -- if group_id is null, than don't insert into BSC_KPI_DIM_GROUPS, as there
176: -- will be not bsc_level_ids
177: IF (l_Dim_Set_Rec.Bsc_Dim_Level_Group_Id IS NOT NULL) THEN
178: Create_Dim_Level_Properties( p_commit
179: ,l_Dim_Set_Rec

Line 417: FROM BSC_KPI_DIM_GROUPS KPI_GROUP

413:
414: SELECT MAX(NUM) INTO l_count
415: FROM (SELECT COUNT(SYS_DIM_LEL.Dim_Group_Id) NUM
416: , SYS_DIM_LEL.Dim_Level_Id
417: FROM BSC_KPI_DIM_GROUPS KPI_GROUP
418: , BSC_SYS_DIM_LEVELS_BY_GROUP SYS_DIM_LEL
419: WHERE KPI_GROUP.Dim_Group_Id = SYS_DIM_LEL.Dim_Group_Id
420: AND KPI_GROUP.Indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
421: AND KPI_GROUP.Dim_Set_Id = p_Dim_Set_Rec.Bsc_Dim_Set_Id

Line 575: FROM BSC_KPI_DIM_GROUPS

571: l_level_id NUMBER;
572:
573: CURSOR c_group_id IS
574: SELECT dim_group_id
575: FROM BSC_KPI_DIM_GROUPS
576: WHERE indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
577: AND dim_set_id = p_Dim_Set_Rec.Bsc_Dim_Set_Id;
578:
579: CURSOR c_dim_level_id IS

Line 588: -- if group_id is null, than don't delete from BSC_KPI_DIM_GROUPS

584: -- Assign all passed values to local record.
585: x_return_status := FND_API.G_RET_STS_SUCCESS;
586: l_Dim_Set_Rec := p_Dim_Set_Rec;
587: -- PAJOHRI added if condition.
588: -- if group_id is null, than don't delete from BSC_KPI_DIM_GROUPS
589: IF (l_Dim_Set_Rec.Bsc_Dim_Level_Group_Id IS NULL) THEN
590: FOR cd IN c_group_id LOOP
591: l_group_id := cd.dim_group_id;
592: l_Dim_Set_Rec.Bsc_Dim_Level_Group_Id := l_group_id;

Line 594: BSC_DIMENSION_SETS_PVT.Delete_Dim_Group_In_Dset( p_commit --BSC_KPI_DIM_GROUPS

590: FOR cd IN c_group_id LOOP
591: l_group_id := cd.dim_group_id;
592: l_Dim_Set_Rec.Bsc_Dim_Level_Group_Id := l_group_id;
593:
594: BSC_DIMENSION_SETS_PVT.Delete_Dim_Group_In_Dset( p_commit --BSC_KPI_DIM_GROUPS
595: ,l_Dim_Set_Rec
596: ,x_return_status
597: ,x_msg_count
598: ,x_msg_data);

Line 623: BSC_DIMENSION_SETS_PVT.Delete_Dim_Group_In_Dset( p_commit --BSC_KPI_DIM_GROUPS

619: END LOOP;
620: END LOOP;
621: ELSE
622: l_group_id := l_Dim_Set_Rec.Bsc_Dim_Level_Group_Id;
623: BSC_DIMENSION_SETS_PVT.Delete_Dim_Group_In_Dset( p_commit --BSC_KPI_DIM_GROUPS
624: ,l_Dim_Set_Rec
625: ,x_return_status
626: ,x_msg_count
627: ,x_msg_data);