APPS.BSC_DIMENSION_SETS_PVT dependencies on BSC_KPI_DIM_GROUPS

Line 67: from BSC_KPI_DIM_GROUPS

63: x_return_status := FND_API.G_RET_STS_SUCCESS;
64: -- Verify value to be inserted does not exist.
65: select count(*)
66: into l_count
67: from BSC_KPI_DIM_GROUPS
68: where indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
69: and dim_set_id = p_Dim_Set_Rec.Bsc_Dim_Set_Id
70: and dim_group_id = p_Dim_Set_Rec.Bsc_Dim_Level_Group_Id;
71:

Line 74: g_db_object := 'BSC_KPI_DIM_GROUPS';

70: and dim_group_id = p_Dim_Set_Rec.Bsc_Dim_Level_Group_Id;
71:
72: if l_count = 0 then
73:
74: g_db_object := 'BSC_KPI_DIM_GROUPS';
75:
76: -- Insert pertaining values into table bsc_kpi_dim_groups.
77: -- Reminder: Index value is hard coded.
78: insert into BSC_KPI_DIM_GROUPS( indicator

Line 76: -- Insert pertaining values into table bsc_kpi_dim_groups.

72: if l_count = 0 then
73:
74: g_db_object := 'BSC_KPI_DIM_GROUPS';
75:
76: -- Insert pertaining values into table bsc_kpi_dim_groups.
77: -- Reminder: Index value is hard coded.
78: insert into BSC_KPI_DIM_GROUPS( indicator
79: ,dim_set_id
80: ,dim_group_id

Line 78: insert into BSC_KPI_DIM_GROUPS( indicator

74: g_db_object := 'BSC_KPI_DIM_GROUPS';
75:
76: -- Insert pertaining values into table bsc_kpi_dim_groups.
77: -- Reminder: Index value is hard coded.
78: insert into BSC_KPI_DIM_GROUPS( indicator
79: ,dim_set_id
80: ,dim_group_id
81: ,dim_group_index)
82: values( p_Dim_Set_Rec.Bsc_Kpi_Id

Line 157: from BSC_KPI_DIM_GROUPS

153: select dim_set_id
154: ,dim_group_index
155: into x_Dim_Set_Rec.Bsc_Dim_Set_Id
156: ,x_Dim_Set_Rec.Bsc_Dim_Level_Group_Index
157: from BSC_KPI_DIM_GROUPS
158: where indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
159: and dim_group_id = p_Dim_Set_Rec.Bsc_Dim_Level_Group_Id
160: and dim_set_id = NVL(p_Dim_Set_Rec.Bsc_Dim_Set_Id, 0);
161: if (p_commit = FND_API.G_TRUE) then

Line 283: update BSC_KPI_DIM_GROUPS

279: if p_Dim_Set_Rec.Bsc_Dim_Level_Group_Index is not null then
280: l_Dim_Set_Rec.Bsc_Dim_Level_Group_Index := p_Dim_Set_Rec.Bsc_Dim_Level_Group_Index;
281: end if;
282:
283: update BSC_KPI_DIM_GROUPS
284: set dim_group_index = l_Dim_Set_Rec.Bsc_Dim_Level_Group_Index
285: where indicator = l_Dim_Set_Rec.Bsc_Kpi_Id
286: and dim_group_id = l_Dim_Set_Rec.Bsc_Dim_Level_Group_Id
287: and dim_set_id = l_Dim_Set_Rec.Bsc_Dim_Set_Id;

Line 389: delete from BSC_KPI_DIM_GROUPS

385: FND_MSG_PUB.ADD;
386: RAISE FND_API.G_EXC_ERROR;
387: end if;
388:
389: delete from BSC_KPI_DIM_GROUPS
390: where indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
391: and dim_set_id = p_Dim_Set_Rec.Bsc_Dim_Set_Id
392: and dim_group_id = p_Dim_Set_Rec.Bsc_Dim_Level_Group_Id;
393:

Line 824: from BSC_KPI_DIM_GROUPS

820: x_return_status := FND_API.G_RET_STS_SUCCESS;
821: -- If there are no groups assigned to this dimension set then delete it.
822: select count(dim_group_id)
823: into l_count
824: from BSC_KPI_DIM_GROUPS
825: where indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
826: and dim_set_id = p_Dim_Set_Rec.Bsc_Dim_Set_Id;
827:
828: if l_count = 0 then