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_KPIS_B

Line 145: p_indicator IN BSC_KPIS_B.indicator%TYPE

141: ************************************************************************************/
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

Line 261: l_Indic_Type BSC_KPIS_B.Indicator_Type%TYPE;

257: /*****************************************************************/
258: FUNCTION get_KPI_Type
259: ( p_Kpi_ID IN NUMBER
260: ) RETURN NUMBER IS
261: l_Indic_Type BSC_KPIS_B.Indicator_Type%TYPE;
262: BEGIN
263: SELECT Indicator_Type
264: INTO l_Indic_Type
265: FROM BSC_KPIS_B

Line 265: FROM BSC_KPIS_B

261: l_Indic_Type BSC_KPIS_B.Indicator_Type%TYPE;
262: BEGIN
263: SELECT Indicator_Type
264: INTO l_Indic_Type
265: FROM BSC_KPIS_B
266: WHERE Indicator = p_Kpi_ID;
267:
268: RETURN l_Indic_Type;
269: END get_KPI_Type;

Line 403: FROM BSC_KPIS_B

399: l_bsc_dimset_rec BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;
400:
401: CURSOR c_kpi_ids IS
402: SELECT indicator
403: FROM BSC_KPIS_B
404: WHERE Source_Indicator = p_kpi_id
405: AND Prototype_Flag <> 2;
406: BEGIN
407: --dbms_output.PUT_LINE('Entered inside BSC_BIS_KPI_MEAS_PUB.Create_Default_Kpi_Dim_Object procedure');

Line 512: FROM BSC_KPIS_B

508: l_bsc_dimset_rec BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;
509:
510: CURSOR c_kpi_ids IS
511: SELECT indicator
512: FROM BSC_KPIS_B
513: WHERE Source_Indicator = p_kpi_id
514: AND Prototype_Flag <> 2;
515: BEGIN
516: --dbms_output.PUT_LINE('Entered inside BSC_BIS_KPI_MEAS_PUB.Delete_Default_Kpi_Dim_Object procedure');

Line 640: FROM BSC_KPIS_B

636:
637: --get shared indicators also
638: CURSOR c_kpi_ids IS
639: SELECT indicator
640: FROM BSC_KPIS_B
641: WHERE Source_Indicator = p_kpi_id
642: AND Prototype_Flag <> 2;
643: BEGIN
644: SAVEPOINT OrderBSCDimsInDSetPMD;

Line 1536: FROM BSC_KPIS_B

1532: l_kpi_name VARCHAR2(32000);
1533:
1534: CURSOR c_kpi_ids IS
1535: SELECT indicator
1536: FROM BSC_KPIS_B
1537: WHERE Source_Indicator = p_kpi_id
1538: AND Prototype_Flag <> 2;
1539: BEGIN
1540: FND_MSG_PUB.Initialize;

Line 1551: FROM BSC_KPIS_B

1547: FND_MSG_PUB.ADD;
1548: RAISE FND_API.G_EXC_ERROR;
1549: END IF;
1550: SELECT COUNT(*) INTO l_count
1551: FROM BSC_KPIS_B
1552: WHERE indicator = p_kpi_id;
1553: IF (l_count = 0) THEN
1554: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
1555: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);

Line 1565: FROM BSC_KPIS_B

1561: --dbms_output.PUT_LINE('l_bsc_dimset_rec.Bsc_Kpi_Id <'||l_bsc_dimset_rec.Bsc_Kpi_Id||'>');
1562: -- Verify that this is not a Shared KPI.
1563: SELECT share_flag
1564: INTO l_count
1565: FROM BSC_KPIS_B
1566: WHERE indicator = l_bsc_dimset_rec.Bsc_Kpi_Id ;
1567: IF (l_count = 2) THEN
1568: FND_MESSAGE.SET_NAME('BSC','BSC_SHARED_KPI');
1569: --FND_MESSAGE.SET_TOKEN('BSC_KPI', l_bsc_dimset_rec.Bsc_Kpi_Id);

Line 2126: FROM BSC_KPIS_B

2122:
2123:
2124: CURSOR c_kpi_ids IS
2125: SELECT indicator
2126: FROM BSC_KPIS_B
2127: WHERE Source_Indicator = p_kpi_id
2128: AND Prototype_Flag <> 2;
2129: BEGIN
2130: SAVEPOINT UpdateBSCDimSetPMD;

Line 2151: FROM BSC_KPIS_B

2147: --dbms_output.PUT_LINE('l_bsc_dimset_rec.Bsc_Kpi_Id <'||l_bsc_dimset_rec.Bsc_Kpi_Id||'>');
2148: -- Verify that this is not a Shared KPI.
2149: SELECT share_flag
2150: INTO l_count
2151: FROM BSC_KPIS_B
2152: WHERE indicator = l_bsc_dimset_rec.Bsc_Kpi_Id ;
2153: IF (l_count = 2) THEN
2154: FND_MESSAGE.SET_NAME('BSC','BSC_SHARED_KPI');
2155: --FND_MESSAGE.SET_TOKEN('BSC_KPI', l_bsc_dimset_rec.Bsc_Kpi_Id);

Line 2336: l_kpi_sname BSC_KPIS_B.SHORT_NAME%TYPE;

2332: )
2333: RETURN BOOLEAN IS
2334:
2335: l_count NUMBER;
2336: l_kpi_sname BSC_KPIS_B.SHORT_NAME%TYPE;
2337:
2338: CURSOR c_ind_type IS
2339: SELECT short_name
2340: FROM bsc_kpis_b

Line 2340: FROM bsc_kpis_b

2336: l_kpi_sname BSC_KPIS_B.SHORT_NAME%TYPE;
2337:
2338: CURSOR c_ind_type IS
2339: SELECT short_name
2340: FROM bsc_kpis_b
2341: WHERE indicator = p_Indicator;
2342:
2343: BEGIN
2344:

Line 2359: Short name in BSC_KPIS_B should be null for Objectives created in Objective Designer, This

2355: CLOSE c_ind_type;
2356: END IF;
2357:
2358: /*
2359: Short name in BSC_KPIS_B should be null for Objectives created in Objective Designer, This
2360: filters Objectives for AG report.
2361: */
2362: OPEN c_ind_type;
2363: FETCH c_ind_type INTO l_kpi_sname;

Line 2397: FROM BSC_KPIS_B

2393: l_count NUMBER := 0;
2394:
2395: CURSOR c_kpi_ids IS
2396: SELECT indicator
2397: FROM BSC_KPIS_B
2398: WHERE Source_Indicator = p_kpi_id
2399: AND Prototype_Flag <> 2;
2400: BEGIN
2401: SAVEPOINT DeleteBSCDimSetPMD;

Line 2427: FROM BSC_KPIS_B

2423: --dbms_output.PUT_LINE('l_bsc_dimset_rec.Bsc_Kpi_Id <'||l_bsc_dimset_rec.Bsc_Kpi_Id||'>');
2424: -- Verify that this is not a Shared KPI.
2425: SELECT share_flag
2426: INTO l_count
2427: FROM BSC_KPIS_B
2428: WHERE indicator = l_bsc_dimset_rec.Bsc_Kpi_Id ;
2429: IF (l_count = 2) THEN
2430: FND_MESSAGE.SET_NAME('BSC','BSC_SHARED_KPI');
2431: --FND_MESSAGE.SET_TOKEN('BSC_KPI', l_bsc_dimset_rec.Bsc_Kpi_Id);

Line 2589: FROM BSC_KPIS_B

2585: l_key_item NUMBER;
2586:
2587: CURSOR c_kpi_ids IS
2588: SELECT indicator
2589: FROM BSC_KPIS_B
2590: WHERE Source_Indicator = p_kpi_id
2591: AND Prototype_Flag <> 2;
2592:
2593: CURSOR c_Dim_Levels IS

Line 2641: FROM BSC_KPIS_B

2637: --dbms_output.PUT_LINE('l_bsc_dimset_rec.Bsc_Kpi_Id <'||l_bsc_dimset_rec.Bsc_Kpi_Id||'>');
2638: -- Verify that this is not a Shared KPI.
2639: SELECT share_flag
2640: INTO l_count
2641: FROM BSC_KPIS_B
2642: WHERE indicator = l_bsc_dimset_rec.Bsc_Kpi_Id ;
2643: IF (l_count <> 2) THEN
2644: --BSC_KPI_DIM_LEVELS_B.indicator
2645: l_bsc_dimset_rec.Bsc_Dim_Set_Id := p_dim_set_id; --number

Line 3136: FROM BSC_KPIS_B

3132: l_kpi_flag_change BOOLEAN := FALSE;
3133:
3134: CURSOR c_kpi_ids IS
3135: SELECT indicator
3136: FROM BSC_KPIS_B
3137: WHERE Source_Indicator = p_kpi_id
3138: AND Prototype_Flag <> 2;
3139:
3140: CURSOR c_dim_index IS

Line 3171: FROM BSC_KPIS_B

3167:
3168: -- Verify that this is not a Shared KPI.
3169: SELECT share_flag
3170: INTO l_count
3171: FROM BSC_KPIS_B
3172: WHERE indicator = l_bsc_dimset_rec.Bsc_Kpi_Id;
3173: IF (l_count = 2) THEN
3174: FND_MESSAGE.SET_NAME('BSC','BSC_SHARED_KPI');
3175: FND_MSG_PUB.ADD;

Line 3663: FROM BSC_KPIS_B

3659: l_count NUMBER := 0;
3660:
3661: CURSOR c_kpi_ids IS
3662: SELECT indicator
3663: FROM BSC_KPIS_B
3664: WHERE Source_Indicator = p_kpi_id
3665: AND Prototype_Flag <> 2;
3666: BEGIN
3667: SAVEPOINT AssBSCDSetPMD;

Line 4128: FROM BSC_KPIS_B

4124: AND ROWNUM < 2;
4125:
4126: CURSOR c_kpi_ids IS
4127: SELECT indicator
4128: FROM BSC_KPIS_B
4129: WHERE Source_Indicator = p_kpi_id
4130: AND Prototype_Flag <> 2;
4131:
4132: CURSOR C_OPTIONZERO_SOURCE IS

Line 4224: FROM BSC_KPIS_B

4220: FND_MSG_PUB.ADD;
4221: RAISE FND_API.G_EXC_ERROR;
4222: END IF;
4223: SELECT COUNT(*) INTO l_count
4224: FROM BSC_KPIS_B
4225: WHERE indicator = l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id;
4226: IF (l_count = 0) THEN
4227: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
4228: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);

Line 4234: FROM BSC_KPIS_B

4230: RAISE FND_API.G_EXC_ERROR;
4231: END IF;
4232: -- Verify that this is not a Shared KPI.
4233: SELECT share_flag INTO l_count
4234: FROM BSC_KPIS_B
4235: WHERE indicator = l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id ;
4236: IF (l_count = 2) THEN
4237: FND_MESSAGE.SET_NAME('BSC','BSC_SHARED_KPI');
4238: --FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id);

Line 4595: FROM bsc_kpis_b

4591: --Added for bug# 4099118
4592:
4593: SELECT indicator_type,config_type
4594: INTO l_indic_type, l_config_type
4595: FROM bsc_kpis_b
4596: WHERE indicator = l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id;
4597: /* MultiBar indicator can have more number of series
4598: but if the first analysis option is PMF Measure then there is no point of
4599: have more than one series under the same analysis option

Line 4999: l_sname BSC_KPIS_B.SHORT_NAME%TYPE;

4995: l_datasource BSC_SYS_DATASETS_B.Source%TYPE;
4996: l_meaning VARCHAR(60);
4997: l_DimObj_ViewBy_Tbl BSC_BIS_KPI_MEAS_PUB.DimObj_Viewby_Tbl_Type;
4998: l_measure_short_name BSC_SYS_MEASURES.Short_Name%TYPE;
4999: l_sname BSC_KPIS_B.SHORT_NAME%TYPE;
5000:
5001: CURSOR c_data_source IS
5002: SELECT Source
5003: FROM BSC_SYS_DATASETS_B

Line 5008: FROM BSC_KPIS_B

5004: WHERE Dataset_Id = p_data_set_id;
5005:
5006: CURSOR c_kpi_ids IS
5007: SELECT indicator
5008: FROM BSC_KPIS_B
5009: WHERE Source_Indicator = p_kpi_id
5010: AND Prototype_Flag <> 2;
5011:
5012: l_default_level_set BOOLEAN := FALSE;

Line 5072: FROM BSC_KPIS_B

5068: FND_MSG_PUB.ADD;
5069: RAISE FND_API.G_EXC_ERROR;
5070: END IF;
5071: SELECT COUNT(*) INTO l_count
5072: FROM BSC_KPIS_B
5073: WHERE indicator = l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id;
5074: IF (l_count = 0) THEN
5075: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
5076: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);

Line 5082: FROM BSC_KPIS_B

5078: RAISE FND_API.G_EXC_ERROR;
5079: END IF;
5080: -- Verify that this is not a Shared KPI.
5081: SELECT share_flag INTO l_count
5082: FROM BSC_KPIS_B
5083: WHERE indicator = l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id ;
5084: IF (l_count = 2) THEN
5085: FND_MESSAGE.SET_NAME('BSC','BSC_SHARED_KPI');
5086: FND_MSG_PUB.ADD;

Line 5257: FROM BSC_KPIS_B

5253: END IF;
5254:
5255: SELECT short_name
5256: INTO l_sname
5257: FROM BSC_KPIS_B
5258: WHERE INDICATOR = p_kpi_id ;
5259:
5260: IF ((l_datasource = 'BSC') OR (l_sname IS NOT NULL)) THEN
5261: BSC_DESIGNER_PVT.ActionFlag_Change(p_kpi_id, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);

Line 5397: FROM BSC_KPIS_B

5393: RAISE FND_API.G_EXC_ERROR;
5394: END IF;
5395:
5396: SELECT COUNT(*) INTO l_count
5397: FROM BSC_KPIS_B
5398: WHERE indicator = l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id;
5399: IF (l_count = 0) THEN
5400: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
5401: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);

Line 5419: FROM BSC_KPIS_B

5415: RAISE FND_API.G_EXC_ERROR;
5416: END IF;
5417: -- Verify that this is not a Shared KPI.
5418: SELECT share_flag INTO l_count
5419: FROM BSC_KPIS_B
5420: WHERE indicator = l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id ;
5421: IF (l_count = 2) THEN
5422: FND_MESSAGE.SET_NAME('BSC','BSC_SHARED_KPI');
5423: --FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id);

Line 5775: l_obj_prototype_flag BSC_KPIS_B.prototype_flag%TYPE;

5771: l_anal_grp_id NUMBER;
5772: l_Anal_Num_Tbl BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type;
5773: l_Old_Anal_Num_Tbl BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type;
5774:
5775: l_obj_prototype_flag BSC_KPIS_B.prototype_flag%TYPE;
5776: l_color_rollup_type BSC_KPIS_B.color_rollup_type%TYPE;
5777: l_def_kpi_measure_id BSC_KPI_ANALYSIS_MEASURES_VL.kpi_measure_id%TYPE;
5778: l_kpi_measure_id BSC_KPI_ANALYSIS_MEASURES_VL.kpi_measure_id%TYPE;
5779:

Line 5776: l_color_rollup_type BSC_KPIS_B.color_rollup_type%TYPE;

5772: l_Anal_Num_Tbl BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type;
5773: l_Old_Anal_Num_Tbl BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type;
5774:
5775: l_obj_prototype_flag BSC_KPIS_B.prototype_flag%TYPE;
5776: l_color_rollup_type BSC_KPIS_B.color_rollup_type%TYPE;
5777: l_def_kpi_measure_id BSC_KPI_ANALYSIS_MEASURES_VL.kpi_measure_id%TYPE;
5778: l_kpi_measure_id BSC_KPI_ANALYSIS_MEASURES_VL.kpi_measure_id%TYPE;
5779:
5780:

Line 5783: FROM BSC_KPIS_B

5779:
5780:
5781: CURSOR c_kpi_ids IS
5782: SELECT indicator
5783: FROM BSC_KPIS_B
5784: WHERE Source_Indicator = p_kpi_id
5785: AND Prototype_Flag <> 2;
5786:
5787: CURSOR c_dft_anal_ids IS

Line 5809: FROM BSC_KPIS_B

5805: FND_MSG_PUB.ADD;
5806: RAISE FND_API.G_EXC_ERROR;
5807: END IF;
5808: SELECT COUNT(*) INTO l_count
5809: FROM BSC_KPIS_B
5810: WHERE indicator = p_kpi_id;
5811: IF (l_count = 0) THEN
5812: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
5813: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);

Line 5820: FROM bsc_kpis_b

5816: END IF;
5817: -- Verify that this is not a Shared KPI.
5818: SELECT share_flag
5819: INTO l_count
5820: FROM bsc_kpis_b
5821: WHERE indicator = p_kpi_id ;
5822: IF (l_count = 2) THEN
5823: FND_MESSAGE.SET_NAME('BSC','BSC_SHARED_KPI');
5824: --FND_MESSAGE.SET_TOKEN('BSC_KPI', p_kpi_id);

Line 5931: FROM bsc_db_color_ao_defaults_v dd, bsc_kpi_analysis_measures_vl km, bsc_kpis_b bk

5927: AND indicator = p_kpi_id;
5928:
5929: SELECT bk.color_rollup_type, km.kpi_measure_id, bk.prototype_flag
5930: INTO l_color_rollup_type, l_def_kpi_measure_id, l_obj_prototype_flag
5931: FROM bsc_db_color_ao_defaults_v dd, bsc_kpi_analysis_measures_vl km, bsc_kpis_b bk
5932: WHERE km.indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id AND
5933: bk.indicator = km.indicator AND
5934: km.indicator = dd.indicator AND
5935: dd.a0_default = km.analysis_option0 AND

Line 6250: p_Kpi_Id IN BSC_KPIS_B.indicator%TYPE

6246: added by Ravi
6247: /**********************************************************************/
6248: FUNCTION get_anal_opt_comb_message
6249: (
6250: p_Kpi_Id IN BSC_KPIS_B.indicator%TYPE
6251: , p_Option_0 IN NUMBER
6252: , p_Option_1 IN NUMBER
6253: , p_Option_2 IN NUMBER
6254: , p_Sid IN NUMBER

Line 6326: FROM BSC_KPIS_B

6322: l_count NUMBER;
6323:
6324: CURSOR c_kpi_ids IS
6325: SELECT indicator
6326: FROM BSC_KPIS_B
6327: WHERE Source_Indicator = p_kpi_id
6328: AND Prototype_Flag <> 2;
6329:
6330: CURSOR c_dim_group_id IS

Line 6662: FROM BSC_KPIS_B

6658: l_count NUMBER;
6659:
6660: CURSOR c_kpi_ids IS
6661: SELECT indicator
6662: FROM BSC_KPIS_B
6663: WHERE Source_Indicator = p_kpi_id
6664: AND Prototype_Flag <> 2;
6665:
6666: CURSOR c_dim_group_id IS

Line 7391: l_sname BSC_KPIS_B.SHORT_NAME%TYPE;

7387: ) RETURN NUMBER IS
7388:
7389: l_count NUMBER;
7390: l_new_count NUMBER;
7391: l_sname BSC_KPIS_B.SHORT_NAME%TYPE;
7392:
7393: BEGIN
7394:
7395: SELECT short_name

Line 7397: FROM BSC_KPIS_B

7393: BEGIN
7394:
7395: SELECT short_name
7396: INTO l_sname
7397: FROM BSC_KPIS_B
7398: WHERE INDICATOR = p_kpi_id;
7399:
7400: IF (l_sname IS NOT NULL) THEN
7401:

Line 7448: l_ind_type BSC_KPIS_B.indicator_type%TYPE;

7444: l_Bsc_Dim_Set_Rec_Type BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;
7445: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
7446: l_count NUMBER;
7447: l_Default_Delete BOOLEAN := FALSE;
7448: l_ind_type BSC_KPIS_B.indicator_type%TYPE;
7449: l_max_group_count NUMBER;
7450: l_new_count NUMBER;
7451: l_series_count NUMBER;
7452: l_tab_id NUMBER;

Line 7454: l_kpi_id BSC_KPIS_B.indicator%TYPE;

7450: l_new_count NUMBER;
7451: l_series_count NUMBER;
7452: l_tab_id NUMBER;
7453: l_series_delete BOOLEAN;
7454: l_kpi_id BSC_KPIS_B.indicator%TYPE;
7455:
7456: CURSOR c_kpi_anal_group IS
7457: SELECT Analysis_Group_Id
7458: , Num_Of_Options

Line 7466: FROM BSC_KPIS_B

7462: ORDER BY Analysis_Group_Id;
7463:
7464: CURSOR c_kpi_ids IS
7465: SELECT indicator
7466: FROM BSC_KPIS_B
7467: WHERE Source_Indicator = p_kpi_id
7468: AND Prototype_Flag <> 2;
7469:
7470: BEGIN

Line 7513: FROM BSC_KPIS_B

7509: RAISE FND_API.G_EXC_ERROR;
7510: END IF;
7511:
7512: SELECT COUNT(*) INTO l_count
7513: FROM BSC_KPIS_B
7514: WHERE indicator = l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id;
7515: IF (l_count = 0) THEN
7516: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
7517: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);

Line 7535: FROM BSC_KPIS_B

7531: RAISE FND_API.G_EXC_ERROR;
7532: END IF;
7533:
7534: SELECT share_flag INTO l_count
7535: FROM BSC_KPIS_B
7536: WHERE indicator = l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id;
7537: IF (l_count = 2) THEN
7538: FND_MESSAGE.SET_NAME('BSC','BSC_SHARED_KPI');
7539: FND_MSG_PUB.ADD;

Line 8138: FROM bsc_kpis_b

8134: )
8135: IS
8136: CURSOR c_shared_obj(p_indicator NUMBER) IS
8137: SELECT indicator
8138: FROM bsc_kpis_b
8139: WHERE source_indicator = p_indicator
8140: AND share_flag = 2
8141: AND prototype_flag <> 2;
8142: