DBA Data[Home] [Help]

APPS.BSC_BIS_KPI_CRUD_PUB dependencies on BSC_KPI_CALCULATIONS

Line 6120: -- Call the private API to update BSC_KPI_CALCULATIONS.DEFAULT_VALUE, USER_LEVEL0, USER_LEVEL1

6116: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level0 := BSC_BIS_KPI_CRUD_PUB.C_ENABLE_CALC_U0;
6117: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_User_Level1 := BSC_BIS_KPI_CRUD_PUB.C_ENABLE_CALC_U1;
6118: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Default_Value := p_Default_Checked;
6119:
6120: -- Call the private API to update BSC_KPI_CALCULATIONS.DEFAULT_VALUE, USER_LEVEL0, USER_LEVEL1
6121: BSC_KPI_PVT.Update_Kpi_Calculations(
6122: p_commit => p_commit
6123: ,p_Bsc_Kpi_Entity_Rec => l_Bsc_Kpi_Entity_Rec
6124: ,x_Return_Status => x_Return_Status

Line 6624: ,BSC_KPI_CALCULATIONS KC

6620:
6621: CURSOR c_Obj_Names IS
6622: SELECT (KV.INDICATOR || ' - ' || KV.NAME) XTDOBJECTIVE
6623: FROM BSC_KPIS_VL KV
6624: ,BSC_KPI_CALCULATIONS KC
6625: WHERE KC.INDICATOR = KV.INDICATOR
6626: AND KC.CALCULATION_ID = BSC_BIS_KPI_CRUD_PUB.C_CALC_XTD
6627: AND KC.USER_LEVEL0 = BSC_BIS_KPI_CRUD_PUB.C_ENABLE_CALC_U0
6628: AND KC.USER_LEVEL1 = BSC_BIS_KPI_CRUD_PUB.C_ENABLE_CALC_U1