eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_BIS_KPI_MEAS_PUB dependencies on BSC_KPI_DIM_SETS_VL

Line 146: , p_dim_set_id IN BSC_KPI_DIM_SETS_VL.dim_set_id%TYPE

142:
143: PROCEDURE Set_Key_Item_Value
144: (
145: p_indicator IN BSC_KPIS_B.indicator%TYPE
146: , p_dim_set_id IN BSC_KPI_DIM_SETS_VL.dim_set_id%TYPE
147: , p_level_table_name IN BSC_SYS_DIM_LEVELS_VL.level_table_name%TYPE
148: , p_key_value IN BSC_KPI_DIM_LEVEL_PROPERTIES.default_key_value%TYPE
149: , x_return_status OUT NOCOPY VARCHAR2
150: , x_msg_count OUT NOCOPY NUMBER

Line 1595: FROM BSC_KPI_DIM_SETS_VL

1591: --dbms_output.PUT_LINE('l_bsc_dimset_rec.Bsc_Action <'||l_bsc_dimset_rec.Bsc_Action||'>');
1592:
1593: SELECT NVL(MAX(dim_set_id) + 1, 0)
1594: INTO l_bsc_dimset_rec.bsc_dim_set_id
1595: FROM BSC_KPI_DIM_SETS_VL
1596: WHERE indicator = l_bsc_dimset_rec.bsc_kpi_id;
1597: --dbms_output.PUT_LINE('l_bsc_dimset_rec.bsc_dim_set_id <'||l_bsc_dimset_rec.bsc_dim_set_id||'>');
1598:
1599: -- START Granular Locking

Line 1671: FROM BSC_KPI_DIM_SETS_VL

1667: END IF;
1668:
1669: SELECT NVL(MAX(dim_set_id) + 1, 0)
1670: INTO l_bsc_dimset_rec.bsc_dim_set_id
1671: FROM BSC_KPI_DIM_SETS_VL
1672: WHERE indicator = l_bsc_dimset_rec.bsc_kpi_id;
1673: BSC_DIMENSION_SETS_PUB.Create_Bsc_Kpi_Dim_Sets_Tl--INSERT INTO BSC_KPI_DIM_SETS_TL
1674: ( p_commit => FND_API.G_FALSE
1675: , p_Dim_Set_Rec => l_bsc_dimset_rec

Line 2008: FROM BSC_KPI_DIM_SETS_VL

2004: RAISE FND_API.G_EXC_ERROR;
2005: END IF;
2006: SELECT COUNT(DIM_SET_ID)
2007: INTO l_count
2008: FROM BSC_KPI_DIM_SETS_VL
2009: WHERE DIM_SET_ID = p_dim_set_id AND INDICATOR = p_kpi_id;
2010:
2011: IF (l_count = 0) THEN
2012: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');

Line 2165: FROM BSC_KPI_DIM_SETS_VL

2161: l_bsc_dimset_rec.Bsc_Dim_Set_Name := p_display_name;
2162: --dbms_output.PUT_LINE('l_bsc_dimset_rec.Bsc_Dim_Set_Name <'||l_bsc_dimset_rec.Bsc_Dim_Set_Name||'>');
2163:
2164: SELECT COUNT(*) INTO l_count
2165: FROM BSC_KPI_DIM_SETS_VL
2166: WHERE indicator = l_bsc_dimset_rec.Bsc_Kpi_Id
2167: AND dim_set_id = l_bsc_dimset_rec.Bsc_Dim_Set_Id;
2168: IF (l_count = 0) THEN
2169: FND_MESSAGE.SET_NAME('BSC', 'BSC_INCORRECT_KPI_DIMSET');

Line 2220: SELECT COUNT(*) INTO l_count FROM BSC_KPI_DIM_SETS_VL

2216: --for shared inidicators repeat the steps above
2217: FOR cd IN c_kpi_ids LOOP
2218: l_bsc_dimset_rec.Bsc_Kpi_Id := cd.indicator;
2219: --dbms_output.PUT_LINE('Within Shared Indicator Loop KPI_ID is <'||l_bsc_dimset_rec.Bsc_Kpi_Id||'>');
2220: SELECT COUNT(*) INTO l_count FROM BSC_KPI_DIM_SETS_VL
2221: WHERE indicator = l_bsc_dimset_rec.Bsc_Kpi_Id
2222: AND dim_set_id = l_bsc_dimset_rec.Bsc_Dim_Set_Id;
2223: IF (l_count = 0) THEN
2224: FND_MESSAGE.SET_NAME('BSC', 'BSC_INCORRECT_KPI_DIMSET');

Line 2436: FROM BSC_KPI_DIM_SETS_VL

2432: FND_MSG_PUB.ADD;
2433: RAISE FND_API.G_EXC_ERROR;
2434: END IF;
2435: SELECT COUNT(*) INTO l_count
2436: FROM BSC_KPI_DIM_SETS_VL
2437: WHERE indicator = l_bsc_dimset_rec.Bsc_Kpi_Id;
2438: IF (l_count = 1) THEN
2439: FND_MESSAGE.SET_NAME('BSC','BSC_D_KPI_AT_LEAST_1_DS');
2440: FND_MSG_PUB.ADD;

Line 2652: SELECT COUNT(*) INTO l_count FROM BSC_KPI_DIM_SETS_VL

2648: l_bsc_dimset_rec.Bsc_New_Dset := 'N'; --varchar2(45)
2649: --dbms_output.PUT_LINE('l_bsc_dimset_rec.Bsc_New_Dset <'||l_bsc_dimset_rec.Bsc_New_Dset||'>');
2650: l_bsc_dimset_rec.Bsc_Action := 'RESET';
2651: --dbms_output.PUT_LINE('l_bsc_dimset_rec.Bsc_Action <'||l_bsc_dimset_rec.Bsc_Action||'>');
2652: SELECT COUNT(*) INTO l_count FROM BSC_KPI_DIM_SETS_VL
2653: WHERE indicator = l_bsc_dimset_rec.Bsc_Kpi_Id
2654: AND dim_set_id = l_bsc_dimset_rec.Bsc_Dim_Set_Id;
2655: IF (l_count = 0) THEN
2656: FND_MESSAGE.SET_NAME('BSC', 'BSC_INCORRECT_KPI_DIMSET');

Line 2751: SELECT COUNT(*) INTO l_count FROM BSC_KPI_DIM_SETS_VL

2747: --repeat the steps above for all the shared indicators
2748: FOR cd IN c_kpi_ids LOOP
2749: l_bsc_dimset_rec.Bsc_Kpi_Id := cd.indicator;
2750: --dbms_output.PUT_LINE('Within Shared Indicator Loop KPI_ID is <'||l_bsc_dimset_rec.Bsc_Kpi_Id||'>');
2751: SELECT COUNT(*) INTO l_count FROM BSC_KPI_DIM_SETS_VL
2752: WHERE indicator = l_bsc_dimset_rec.Bsc_Kpi_Id
2753: AND dim_set_id = l_bsc_dimset_rec.Bsc_Dim_Set_Id;
2754: IF (l_count = 0) THEN
2755: FND_MESSAGE.SET_NAME('BSC', 'BSC_INCORRECT_KPI_DIMSET');

Line 3181: SELECT COUNT(*) INTO l_count FROM BSC_KPI_DIM_SETS_VL

3177: END IF;
3178: l_bsc_dimset_rec.Bsc_Dim_Set_Id := p_dim_set_id; --number
3179: --dbms_output.PUT_LINE('l_bsc_dimset_rec.Bsc_Dim_Set_Id <'||l_bsc_dimset_rec.Bsc_Dim_Set_Id||'>');
3180:
3181: SELECT COUNT(*) INTO l_count FROM BSC_KPI_DIM_SETS_VL
3182: WHERE indicator = l_bsc_dimset_rec.Bsc_Kpi_Id
3183: AND dim_set_id = l_bsc_dimset_rec.Bsc_Dim_Set_Id;
3184: IF (l_count = 0) THEN
3185: FND_MESSAGE.SET_NAME('BSC', 'BSC_INCORRECT_KPI_DIMSET');

Line 3713: SELECT COUNT(*) INTO l_count FROM BSC_KPI_DIM_SETS_VL

3709: AND Analysis_Group_Id = l_bsc_dimset_rec.Bsc_Analysis_Id
3710: AND Option_Id = l_bsc_dimset_rec.Bsc_Option_Id;
3711:
3712: IF (l_Count = 0) THEN
3713: SELECT COUNT(*) INTO l_count FROM BSC_KPI_DIM_SETS_VL
3714: WHERE indicator = l_bsc_dimset_rec.Bsc_Kpi_Id
3715: AND dim_set_id = l_bsc_dimset_rec.Bsc_Dim_Set_Id;
3716: IF (l_count = 0) THEN
3717: FND_MESSAGE.SET_NAME('BSC', 'BSC_INCORRECT_KPI_DIMSET');

Line 3741: SELECT COUNT(*) INTO l_count FROM BSC_KPI_DIM_SETS_VL

3737: --repeat the steps above for all the shared indicators
3738: FOR cd IN c_kpi_ids LOOP
3739: l_bsc_dimset_rec.Bsc_Kpi_Id := cd.indicator;
3740: --dbms_output.PUT_LINE('Within Shared Indicator Loop KPI_ID is <'||l_bsc_dimset_rec.Bsc_Kpi_Id||'>');
3741: SELECT COUNT(*) INTO l_count FROM BSC_KPI_DIM_SETS_VL
3742: WHERE indicator = l_bsc_dimset_rec.Bsc_Kpi_Id
3743: AND dim_set_id = l_bsc_dimset_rec.Bsc_Dim_Set_Id;
3744: IF (l_count = 0) THEN
3745: FND_MESSAGE.SET_NAME('BSC', 'BSC_INCORRECT_KPI_DIMSET');

Line 4465: FROM BSC_KPI_DIM_SETS_VL

4461: END IF;
4462: --get the dimension set Id which is created now
4463: SELECT NVL(MAX(dim_set_id) + 1, 0)
4464: INTO l_Bsc_Anal_Opt_Rec.Bsc_Dim_Set_Id
4465: FROM BSC_KPI_DIM_SETS_VL
4466: WHERE indicator = l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id;
4467: BSC_BIS_KPI_MEAS_PUB.Create_Dim_Set
4468: ( p_commit => FND_API.G_FALSE
4469: , p_kpi_id => l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id

Line 4483: FROM BSC_KPI_DIM_SETS_VL

4479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4480: END IF;
4481: ELSE
4482: SELECT COUNT(*) INTO l_count
4483: FROM BSC_KPI_DIM_SETS_VL
4484: WHERE indicator = l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id
4485: AND dim_set_id = l_Bsc_Anal_Opt_Rec.Bsc_Dim_Set_Id;
4486: IF (l_count = 0) THEN
4487: FND_MESSAGE.SET_NAME('BSC', 'BSC_INCORRECT_KPI_DIMSET');

Line 7219: FROM BSC_KPI_DIM_SETS_VL

7215: RAISE FND_API.G_EXC_ERROR;
7216: END IF;
7217:
7218: SELECT COUNT(DIM_SET_ID) INTO l_dim_set_count
7219: FROM BSC_KPI_DIM_SETS_VL
7220: WHERE INDICATOR = p_Kpi_ID;
7221: IF (l_dim_set_count > BSC_BIS_KPI_MEAS_PUB.CONFIG_LIMIT_DIMSET ) THEN
7222: --dbms_output.PUT_LINE('FIRST dimset IF LOOP' );
7223: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_IMPACT_KPI_SUMMARY_LVL');