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_ANALYSIS_OPTION_PVT dependencies on BSC_KPIS_B

Line 130: ( p_Kpi_id IN NUMBER--BSC_KPIS_B.indicator%TYPE

126: Name :- get_number_of_child
127: This fucntion will return the number of child for the parent.
128: /**************************************************************************/
129: FUNCTION get_number_of_child
130: ( p_Kpi_id IN NUMBER--BSC_KPIS_B.indicator%TYPE
131: , p_group_count IN NUMBER
132: , p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type
133: , p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
134: )RETURN NUMBER IS

Line 169: ( p_Kpi_id IN BSC_KPIS_B.indicator%TYPE

165: END get_number_of_child;
166:
167: /*******************************************************************************/
168: FUNCTION get_parent_level_id
169: ( p_Kpi_id IN BSC_KPIS_B.indicator%TYPE
170: , p_Group_id IN BSC_KPI_ANALYSIS_OPTIONS_B.Analysis_Group_Id%TYPE
171: , p_Option_id IN BSC_KPI_ANALYSIS_OPTIONS_B.Option_Id%TYPE
172: ) RETURN NUMBER IS
173: l_parent_option BSC_KPI_ANALYSIS_OPTIONS_B.Parent_Option_Id%TYPE;

Line 187: ( p_Kpi_id IN BSC_KPIS_B.indicator%TYPE

183: END get_parent_level_id;
184:
185: /*******************************************************************************/
186: FUNCTION is_custom_kpi
187: ( p_Kpi_id IN BSC_KPIS_B.indicator%TYPE
188: , p_Kpi_Name OUT NOCOPY BSC_KPIS_VL.NAME%TYPE
189: ) RETURN BOOLEAN IS
190: l_Kpi_ShortName VARCHAR2(50);
191: l_Kpi_Name BSC_KPIS_VL.NAME%TYPE;

Line 792: /*l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

788: x_return_status := FND_API.G_RET_STS_SUCCESS;
789: SAVEPOINT CreateBSCAnaOptPVT;
790: -- Check that valid Kpi id was entered.
791: if p_Anal_Opt_Rec.Bsc_Kpi_Id is not null then
792: /*l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
793: ,'indicator'
794: ,p_Anal_Opt_Rec.Bsc_Kpi_Id);*/
795: SELECT COUNT(0)
796: INTO l_count

Line 797: FROM BSC_KPIS_B

793: ,'indicator'
794: ,p_Anal_Opt_Rec.Bsc_Kpi_Id);*/
795: SELECT COUNT(0)
796: INTO l_count
797: FROM BSC_KPIS_B
798: WHERE INDICATOR = p_Anal_Opt_Rec.Bsc_Kpi_Id;
799:
800: if l_count = 0 then
801: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 1094: /*l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

1090: x_return_status := FND_API.G_RET_STS_SUCCESS;
1091: SAVEPOINT UpdateBSCAnaOptPVT;
1092: -- Check that valid Kpi id was entered.
1093: if p_Anal_Opt_Rec.Bsc_Kpi_Id is not null then
1094: /*l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
1095: ,'indicator'
1096: ,p_Anal_Opt_Rec.Bsc_Kpi_Id);*/
1097: SELECT COUNT(0)
1098: INTO l_count

Line 1099: FROM BSC_KPIS_B

1095: ,'indicator'
1096: ,p_Anal_Opt_Rec.Bsc_Kpi_Id);*/
1097: SELECT COUNT(0)
1098: INTO l_count
1099: FROM BSC_KPIS_B
1100: WHERE INDICATOR = p_Anal_Opt_Rec.Bsc_Kpi_Id;
1101:
1102: if l_count = 0 then
1103: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 1324: FROM BSC_KPIS_B

1320: l_Kpi_Name BSC_KPIS_VL.NAME%TYPE;
1321:
1322: CURSOR c_kpi_ids IS
1323: SELECT indicator
1324: FROM BSC_KPIS_B
1325: WHERE Source_Indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id
1326: AND Prototype_Flag <> BSC_KPI_PUB.Delete_Kpi_Flag;
1327: BEGIN
1328: FND_MSG_PUB.Initialize;

Line 1334: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B', 'indicator', p_Anal_Opt_Rec.Bsc_Kpi_Id);

1330: SAVEPOINT DeleteBSCAnaOptPVT;
1331: l_Anal_Opt_Rec := p_Anal_Opt_Rec;
1332: -- Check that valid Kpi id was entered.
1333: IF (p_Anal_Opt_Rec.Bsc_Kpi_Id IS NOT NULL) THEN
1334: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B', 'indicator', p_Anal_Opt_Rec.Bsc_Kpi_Id);
1335: IF l_count = 0 THEN
1336: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
1337: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);
1338: FND_MSG_PUB.ADD;

Line 1632: /*l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

1628: x_return_status := FND_API.G_RET_STS_SUCCESS;
1629: SAVEPOINT CreateBSCAnaMeasPVT;
1630: -- Check that valid Kpi id was entered.
1631: if p_Anal_Opt_Rec.Bsc_Kpi_Id is not null then
1632: /*l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
1633: ,'indicator'
1634: ,p_Anal_Opt_Rec.Bsc_Kpi_Id);*/
1635: SELECT COUNT(0)
1636: INTO l_count

Line 1637: FROM BSC_KPIS_B

1633: ,'indicator'
1634: ,p_Anal_Opt_Rec.Bsc_Kpi_Id);*/
1635: SELECT COUNT(0)
1636: INTO l_count
1637: FROM BSC_KPIS_B
1638: WHERE INDICATOR = p_Anal_Opt_Rec.Bsc_Kpi_Id;
1639: if l_count = 0 then
1640: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
1641: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);

Line 1925: l_sname BSC_KPIS_B.SHORT_NAME%TYPE;

1921: ) is
1922: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
1923: l_count number;
1924: l_source BSC_SYS_DATASETS_B.SOURCE%TYPE;
1925: l_sname BSC_KPIS_B.SHORT_NAME%TYPE;
1926: l_kpi_measure_id BSC_KPI_ANALYSIS_MEASURES_B.KPI_MEASURE_ID%TYPE;
1927: l_dataset_color_change BOOLEAN := FALSE;
1928: l_old_color_method bsc_sys_datasets_b.color_method%TYPE;
1929: l_new_color_method bsc_sys_datasets_b.color_method%TYPE;

Line 1936: /*l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

1932: x_return_status := FND_API.G_RET_STS_SUCCESS;
1933: SAVEPOINT UpdateBSCAnaMeasPVT;
1934: -- Check that valid Kpi id was entered.
1935: if p_Anal_Opt_Rec.Bsc_Kpi_Id is not null then
1936: /*l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
1937: ,'indicator'
1938: ,p_Anal_Opt_Rec.Bsc_Kpi_Id); */
1939: SELECT COUNT(0)
1940: INTO l_count

Line 1941: FROM BSC_KPIS_B

1937: ,'indicator'
1938: ,p_Anal_Opt_Rec.Bsc_Kpi_Id); */
1939: SELECT COUNT(0)
1940: INTO l_count
1941: FROM BSC_KPIS_B
1942: WHERE INDICATOR = p_Anal_Opt_Rec.Bsc_Kpi_Id;
1943: if l_count = 0 then
1944: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
1945: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);

Line 2009: FROM BSC_KPIS_B

2005: WHERE dataset_id = p_Anal_Opt_Rec.Bsc_Dataset_Id;
2006:
2007: SELECT SHORT_NAME
2008: INTO l_sname
2009: FROM BSC_KPIS_B
2010: WHERE INDICATOR = l_Anal_Opt_Rec.Bsc_Kpi_Id;
2011:
2012: IF (p_Anal_Opt_Rec.Bsc_Change_Action_Flag = FND_API.G_TRUE AND ((l_source = 'BSC') OR (l_sname IS NOT NULL) )) THEN
2013: BSC_DESIGNER_PVT.ActionFlag_Change( l_Anal_Opt_Rec.Bsc_Kpi_Id ,

Line 2263: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B', 'indicator', p_Anal_Opt_Rec.Bsc_Kpi_Id);

2259: SAVEPOINT DeleteBSCAnaMeasPVT;
2260: x_return_status := FND_API.G_RET_STS_SUCCESS;
2261: -- Check that valid Kpi id was entered.
2262: IF (p_Anal_Opt_Rec.Bsc_Kpi_Id IS NOT NULL) THEN
2263: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B', 'indicator', p_Anal_Opt_Rec.Bsc_Kpi_Id);
2264: IF (l_count = 0) THEN
2265: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
2266: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);
2267: FND_MSG_PUB.ADD;

Line 2623: FROM BSC_KPIS_B A

2619: --get shared indicators
2620: CURSOR c_kpi_ids IS
2621: SELECT DISTINCT A.Indicator
2622: , B.User_Level1
2623: FROM BSC_KPIS_B A
2624: , BSC_KPI_ANALYSIS_OPTIONS_B B
2625: WHERE Source_Indicator = p_kpi_id
2626: AND A.Indicator = B.Indicator
2627: AND B.analysis_group_id = p_anal_group_id

Line 2636: FROM BSC_KPIS_B

2632: x_return_status := FND_API.G_RET_STS_SUCCESS;
2633: -- First check if it is a Shared Kpi. If it is then no deletion.
2634: SELECT DISTINCT(Share_Flag)
2635: INTO l_value
2636: FROM BSC_KPIS_B
2637: WHERE indicator = p_kpi_id;
2638: IF (l_value = 2) then
2639: RETURN 'S';-- it is a shared kpi
2640: END IF;

Line 2655: FROM BSC_KPIS_B

2651: -- Now find out NOCOPY if the indicator has any shared indicators, if not then deletion
2652: -- may proceed.
2653: SELECT COUNT(indicator)
2654: INTO l_value
2655: FROM BSC_KPIS_B
2656: WHERE source_indicator = p_kpi_id
2657: AND Prototype_Flag <> BSC_KPI_PUB.Delete_Kpi_Flag;
2658: IF (l_value = 0) then
2659: RETURN 'Y';

Line 2719: p_Kpi_id IN BSC_KPIS_B.indicator%TYPE

2715:
2716: /**************************************************************************/
2717: PROCEDURE Initialize_Anal_Opt_Tbl
2718: (
2719: p_Kpi_id IN BSC_KPIS_B.indicator%TYPE
2720: , p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type
2721: , p_max_group_count IN NUMBER
2722: , p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
2723: , p_Anal_Det_Opt_Tbl IN OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Det_Tbl_Type

Line 2893: , p_Kpi_id IN BSC_KPIS_B.indicator%TYPE

2889: ************************************************************************************/
2890:
2891: PROCEDURE Delete_Ana_Opt_Mult_Groups
2892: ( p_commit IN VARCHAR2:=FND_API.G_FALSE
2893: , p_Kpi_id IN BSC_KPIS_B.indicator%TYPE
2894: , p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type
2895: , p_max_group_count IN NUMBER
2896: , p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
2897: , p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

Line 3109: , p_Kpi_Id IN BSC_KPIS_B.indicator%TYPE

3105: /*****************************************************************************************/
3106:
3107: PROCEDURE Synch_Kpi_Anal_Group
3108: ( p_commit IN VARCHAR2:=FND_API.G_FALSE
3109: , p_Kpi_Id IN BSC_KPIS_B.indicator%TYPE
3110: , p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type
3111: , x_return_status OUT NOCOPY VARCHAR2
3112: , x_msg_count OUT NOCOPY NUMBER
3113: , x_msg_data OUT NOCOPY VARCHAR2

Line 3359: CURSOR c_KpiName(p_kpi_id BSC_KPIS_B.INDICATOR%TYPE) IS

3355: AND a.Analysis_Option1 <> p_option1
3356: AND a.Analysis_Option2 <> p_option2
3357: AND a.SERIES_ID <> p_series_id;
3358:
3359: CURSOR c_KpiName(p_kpi_id BSC_KPIS_B.INDICATOR%TYPE) IS
3360: SELECT name
3361: FROM BSC_KPIS_VL
3362: WHERE indicator = p_kpi_id;
3363:

Line 3945: FROM BSC_KPIS_B K

3941: , x_Msg_Data OUT NOCOPY VARCHAR2
3942: ) IS
3943: CURSOR c_Shared_Objectives IS
3944: SELECT K.INDICATOR
3945: FROM BSC_KPIS_B K
3946: WHERE K.SOURCE_INDICATOR = p_Kpi_Id
3947: AND K.PROTOTYPE_FLAG <> BSC_KPI_PUB.DELETE_KPI_FLAG;
3948:
3949:

Line 4100: l_Short_Name BSC_KPIS_B.SHORT_NAME%TYPE;

4096: FUNCTION Get_Next_Associated_Obj_SN (
4097: p_Dataset_Id IN NUMBER
4098: ) RETURN VARCHAR2 IS
4099: l_Dataset_Id NUMBER;
4100: l_Short_Name BSC_KPIS_B.SHORT_NAME%TYPE;
4101:
4102: CURSOR c_Objectives IS
4103: SELECT
4104: K.SHORT_NAME

Line 4106: BSC_KPIS_B K,

4102: CURSOR c_Objectives IS
4103: SELECT
4104: K.SHORT_NAME
4105: FROM
4106: BSC_KPIS_B K,
4107: BSC_KPI_ANALYSIS_MEASURES_B M
4108: WHERE
4109: K.INDICATOR = M.INDICATOR
4110: AND M.DATASET_ID = p_Dataset_Id

Line 4219: , p_obj_id IN BSC_KPIS_B.indicator%TYPE

4215: /**********************************************************/
4216: PROCEDURE Set_Default_Analysis_Option
4217: (
4218: p_commit IN VARCHAR2
4219: , p_obj_id IN BSC_KPIS_B.indicator%TYPE
4220: , p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
4221: , p_Anal_Grp_Id IN BSC_KPIS_B.ind_group_id%TYPE
4222: , x_return_status OUT NOCOPY VARCHAR2
4223: , x_msg_count OUT NOCOPY NUMBER

Line 4221: , p_Anal_Grp_Id IN BSC_KPIS_B.ind_group_id%TYPE

4217: (
4218: p_commit IN VARCHAR2
4219: , p_obj_id IN BSC_KPIS_B.indicator%TYPE
4220: , p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
4221: , p_Anal_Grp_Id IN BSC_KPIS_B.ind_group_id%TYPE
4222: , x_return_status OUT NOCOPY VARCHAR2
4223: , x_msg_count OUT NOCOPY NUMBER
4224: , x_msg_data OUT NOCOPY VARCHAR2
4225: )IS

Line 4226: l_anal_grp_id BSC_KPIS_B.ind_group_id%TYPE;

4222: , x_return_status OUT NOCOPY VARCHAR2
4223: , x_msg_count OUT NOCOPY NUMBER
4224: , x_msg_data OUT NOCOPY VARCHAR2
4225: )IS
4226: l_anal_grp_id BSC_KPIS_B.ind_group_id%TYPE;
4227: l_default_value BSC_KPI_ANALYSIS_GROUPS.default_value%TYPE;
4228: l_Anal_Opt_Comb_Tbl BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type;
4229: BEGIN
4230: SAVEPOINT SetDftAnalOption;