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

Line 69: FROM BSC_KPIS_B

65:
66: --get shared indicators
67: CURSOR c_kpi_ids IS
68: SELECT indicator
69: FROM BSC_KPIS_B
70: WHERE Source_Indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id
71: AND Prototype_Flag <> 2;
72: begin
73: FND_MSG_PUB.Initialize;

Line 138: from BSC_KPIS_B

134:
135: -- Verify that this is not a Shared KPI.
136: select share_flag
137: into l_share_flag
138: from BSC_KPIS_B
139: where indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id;
140:
141: if l_share_flag = 2 then
142: FND_MESSAGE.SET_NAME('BSC','BSC_SHARED_KPI');

Line 406: FROM BSC_KPIS_B

402:
403: --get shared indicators
404: CURSOR c_kpi_ids IS
405: SELECT indicator
406: FROM BSC_KPIS_B
407: WHERE Source_Indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id
408: AND Prototype_Flag <> 2;
409: BEGIN
410: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1061: , p_Kpi_id IN BSC_KPIS_B.indicator%TYPE

1057: /************************************************************************************
1058: ************************************************************************************/
1059: PROCEDURE Delete_Ana_Opt_Mult_Groups
1060: ( p_commit IN VARCHAR2:=FND_API.G_FALSE
1061: , p_Kpi_id IN BSC_KPIS_B.indicator%TYPE
1062: , p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type
1063: , p_max_group_count IN NUMBER
1064: , p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
1065: , p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

Line 1127: , p_Kpi_Id IN BSC_KPIS_B.indicator%TYPE

1123:
1124: PROCEDURE Synch_Kpi_Anal_Group
1125: (
1126: p_commit IN VARCHAR2:=FND_API.G_FALSE
1127: , p_Kpi_Id IN BSC_KPIS_B.indicator%TYPE
1128: , p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type
1129: , x_return_status OUT NOCOPY VARCHAR2
1130: , x_msg_count OUT NOCOPY NUMBER
1131: , x_msg_data OUT NOCOPY VARCHAR2

Line 1214: l_Kpi_Short_Name BSC_KPIS_B.SHORT_NAME%TYPE;

1210: , x_return_status OUT NOCOPY VARCHAR2
1211: , x_msg_count OUT NOCOPY NUMBER
1212: , x_msg_data OUT NOCOPY VARCHAR2
1213: ) IS
1214: l_Kpi_Short_Name BSC_KPIS_B.SHORT_NAME%TYPE;
1215: l_Kpi_Name BSC_KPIS_VL.NAME%TYPE;
1216: l_Dataseries_Name BSC_KPI_ANALYSIS_MEASURES_VL.NAME%TYPE;
1217:
1218: CURSOR c_Objective_Name_Details IS

Line 1384: FROM BSC_KPIS_B

1380:
1381: --get shared indicators
1382: CURSOR c_kpi_ids IS
1383: SELECT indicator
1384: FROM BSC_KPIS_B
1385: WHERE Source_Indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id
1386: AND Prototype_Flag <> 2;
1387:
1388: CURSOR c_Series_color IS

Line 1417: FROM BSC_KPIS_B

1413: --- Check Objective Id
1414: if p_Anal_Opt_Rec.Bsc_Kpi_Id is not null then
1415: SELECT COUNT(0)
1416: INTO l_count
1417: FROM BSC_KPIS_B
1418: WHERE INDICATOR = p_Anal_Opt_Rec.Bsc_Kpi_Id;
1419: if l_count = 0 then
1420: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
1421: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);

Line 1435: from BSC_KPIS_B

1431:
1432: -- Verify that this is not a Shared KPI.
1433: select share_flag
1434: into l_share_flag
1435: from BSC_KPIS_B
1436: where indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id;
1437:
1438: if l_share_flag = 2 then
1439: FND_MESSAGE.SET_NAME('BSC','BSC_SHARED_KPI');

Line 1666: FROM BSC_KPIS_B

1662:
1663: --get shared indicators
1664: CURSOR c_kpi_ids IS
1665: SELECT indicator
1666: FROM BSC_KPIS_B
1667: WHERE Source_Indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id
1668: AND Prototype_Flag <> 2;
1669: BEGIN
1670: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1677: FROM BSC_KPIS_B

1673: --- Check Objective Id
1674: if p_Anal_Opt_Rec.Bsc_Kpi_Id is not null then
1675: SELECT COUNT(0)
1676: INTO l_count
1677: FROM BSC_KPIS_B
1678: WHERE INDICATOR = p_Anal_Opt_Rec.Bsc_Kpi_Id;
1679: if l_count = 0 then
1680: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
1681: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);

Line 1695: from BSC_KPIS_B

1691:
1692: -- Verify that this is not a Shared KPI.
1693: select share_flag
1694: into l_share_flag
1695: from BSC_KPIS_B
1696: where indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id;
1697:
1698: if l_share_flag = 2 then
1699: FND_MESSAGE.SET_NAME('BSC','BSC_SHARED_KPI');

Line 1802: FROM BSC_KPIS_B

1798:
1799: --get shared indicators
1800: CURSOR c_kpi_ids IS
1801: SELECT indicator
1802: FROM BSC_KPIS_B
1803: WHERE Source_Indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id
1804: AND Prototype_Flag <> 2;
1805:
1806:

Line 1818: FROM BSC_KPIS_B

1814: --- Check Objective Id
1815: if p_Anal_Opt_Rec.Bsc_Kpi_Id is not null then
1816: SELECT COUNT(0)
1817: INTO l_count
1818: FROM BSC_KPIS_B
1819: WHERE INDICATOR = p_Anal_Opt_Rec.Bsc_Kpi_Id;
1820: if l_count = 0 then
1821: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
1822: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);

Line 1836: from BSC_KPIS_B

1832:
1833: -- Verify that this is not a Shared KPI.
1834: select share_flag
1835: into l_share_flag
1836: from BSC_KPIS_B
1837: where indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id;
1838:
1839: if l_share_flag = 2 then
1840: FND_MESSAGE.SET_NAME('BSC','BSC_SHARED_KPI');

Line 2037: FROM BSC_KPIS_B

2033: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
2034: --get shared indicators
2035: CURSOR c_kpi_ids IS
2036: SELECT indicator
2037: FROM BSC_KPIS_B
2038: WHERE Source_Indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id
2039: AND Prototype_Flag <> 2;
2040:
2041: BEGIN

Line 2148: l_Objective_Short_Name BSC_KPIS_B.SHORT_NAME%TYPE;

2144: l_attribute_code VARCHAR2(100);
2145: l_count NUMBER;
2146:
2147: l_Measure_Short_Name BIS_INDICATORS.SHORT_NAME%TYPE;
2148: l_Objective_Short_Name BSC_KPIS_B.SHORT_NAME%TYPE;
2149: l_Measure_Source BSC_SYS_DATASETS_B.SOURCE%TYPE;
2150:
2151: l_Comparison_Source BIS_INDICATORS.COMPARISON_SOURCE%TYPE;
2152: l_Compare_Attribute_Code AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE;

Line 2325: p_obj_id IN BSC_KPIS_B.indicator%TYPE

2321: /**********************************************************/
2322:
2323: FUNCTION Get_Num_Analysis_options
2324: (
2325: p_obj_id IN BSC_KPIS_B.indicator%TYPE
2326: , p_anal_grp_Id IN BSC_KPI_ANALYSIS_GROUPS.analysis_group_id%TYPE
2327: )RETURN NUMBER IS
2328: l_count NUMBER;
2329: BEGIN

Line 2354: , p_obj_id IN BSC_KPIS_B.indicator%TYPE

2350:
2351: FUNCTION Get_Analysis_Group_Id
2352: (
2353: p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
2354: , p_obj_id IN BSC_KPIS_B.indicator%TYPE
2355: ) RETURN NUMBER IS
2356:
2357: l_Anal_Opt_Tbl BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type;
2358: l_Anal_Grp_Id NUMBER;

Line 2480: , p_obj_id IN BSC_KPIS_B.indicator%TYPE

2476: /**********************************************************/
2477: PROCEDURE Set_Default_Analysis_Option
2478: (
2479: p_commit IN VARCHAR
2480: , p_obj_id IN BSC_KPIS_B.indicator%TYPE
2481: , p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
2482: , p_Anal_Grp_Id IN BSC_KPIS_B.ind_group_id%TYPE
2483: , x_return_status OUT NOCOPY VARCHAR2
2484: , x_msg_count OUT NOCOPY NUMBER

Line 2482: , p_Anal_Grp_Id IN BSC_KPIS_B.ind_group_id%TYPE

2478: (
2479: p_commit IN VARCHAR
2480: , p_obj_id IN BSC_KPIS_B.indicator%TYPE
2481: , p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
2482: , p_Anal_Grp_Id IN BSC_KPIS_B.ind_group_id%TYPE
2483: , x_return_status OUT NOCOPY VARCHAR2
2484: , x_msg_count OUT NOCOPY NUMBER
2485: , x_msg_data OUT NOCOPY VARCHAR2
2486: )IS