APPS.BSC_KPI_PVT dependencies on BSC_TABS_B

Line 4580: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_TABS_B'

4576: -- Check that valid id was entered.
4577: if l_Bsc_Kpi_Entity_Rec.Bsc_Tab_Id is not null then
4578: --DBMS_OUTPUT.PUT_LINE(' BSC_KPI_PVT.Create_Kpi_In_Tab - Flag 2');
4579:
4580: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_TABS_B'
4581: ,'tab_id'
4582: ,l_Bsc_Kpi_Entity_Rec.Bsc_Tab_Id);
4583: --DBMS_OUTPUT.PUT_LINE(' BSC_KPI_PVT.Create_Kpi_In_Tab - Flag 3');
4584:

Line 5152: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_TABS_B'

5148: -- Check that valid tab id was entered.
5149: if p_Bsc_Kpi_Entity_Rec.Bsc_Tab_Id is not null then
5150: --DBMS_OUTPUT.PUT_LINE(' BSC_KPI_PVT.Create_Master_Kpi Flag 2');
5151:
5152: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_TABS_B'
5153: ,'tab_id'
5154: ,p_Bsc_Kpi_Entity_Rec.Bsc_Tab_Id);
5155: --DBMS_OUTPUT.PUT_LINE(' BSC_KPI_PVT.Create_Master_Kpi Flag 3');
5156:

Line 5597: l_cnt := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_TABS_B'

5593: x_return_status := FND_API.G_RET_STS_SUCCESS;
5594: SAVEPOINT BscKpiPvt_MoveTab;
5595: -- Check that valid id was entered.
5596: if p_tab_id is not null then
5597: l_cnt := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_TABS_B'
5598: ,'tab_id'
5599: ,p_tab_id);
5600: if l_cnt = 0 then
5601: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_TAB_ID');

Line 5614: ' from BSC_TABS_B ' ||

5610: RAISE FND_API.G_EXC_ERROR;
5611: end if;
5612:
5613: l_sql := 'select distinct tab_id, tab_index ' ||
5614: ' from BSC_TABS_B ' ||
5615: ' where tab_index >= :1' ||
5616: ' and tab_id != :2' ||
5617: ' order by tab_index asc';
5618:

Line 5630: update BSC_TABS_B

5626: end loop;
5627: close dc_value;
5628:
5629: for i in 1..l_Bsc_Kpi_Entity_Tbl.count loop
5630: update BSC_TABS_B
5631: set tab_index = l_Bsc_Kpi_Entity_Tbl(i).Bsc_Tab_Index + 1
5632: where tab_id = l_Bsc_Kpi_Entity_Tbl(i).Bsc_Tab_Id;
5633: end loop;
5634: