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.

[Home] [Help]

APPS.BSC_KPI_SERIES_PUB dependencies on BSC_KPI_SERIES_COLORS

Line 515: -- 2. Populates the series color properties into bsc_kpi_series_colors

511: -- API name : Create_Analysis_Measure_UI
512: -- Type : Public
513: -- Procedure :
514: -- 1. Creates an analysis measure entry in bsc_kpi_analysis_measures table
515: -- 2. Populates the series color properties into bsc_kpi_series_colors
516: -- 3. Also sets the color enable/disable properties
517: ************************************************************************************/
518: PROCEDURE Create_Analysis_Measure_UI(
519: p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 616: --Populate bsc_kpi_series_colors table

612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
613: END IF;
614:
615:
616: --Populate bsc_kpi_series_colors table
617: IF p_Color_Values IS NOT NULL THEN
618: --Populate bsc_kpi_series_colors table
619: Populate_Kpi_Series_Colors (
620: p_commit => FND_API.G_FALSE

Line 618: --Populate bsc_kpi_series_colors table

614:
615:
616: --Populate bsc_kpi_series_colors table
617: IF p_Color_Values IS NOT NULL THEN
618: --Populate bsc_kpi_series_colors table
619: Populate_Kpi_Series_Colors (
620: p_commit => FND_API.G_FALSE
621: ,p_Anal_Opt_Rec => l_Anal_Opt_Rec
622: ,p_Color_Values => p_Color_Values

Line 662: --Populate bsc_kpi_series_colors table

658: );
659: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
661: END IF;
662: --Populate bsc_kpi_series_colors table
663: IF p_Color_Values IS NOT NULL THEN
664: --Populate bsc_kpi_series_colors table
665: Populate_Kpi_Series_Colors (
666: p_commit => FND_API.G_FALSE

Line 664: --Populate bsc_kpi_series_colors table

660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
661: END IF;
662: --Populate bsc_kpi_series_colors table
663: IF p_Color_Values IS NOT NULL THEN
664: --Populate bsc_kpi_series_colors table
665: Populate_Kpi_Series_Colors (
666: p_commit => FND_API.G_FALSE
667: ,p_Anal_Opt_Rec => l_Anal_Opt_Rec
668: ,p_Color_Values => p_Color_Values

Line 922: --Populate bsc_kpi_series_colors table

918: END IF;
919:
920:
921: IF p_Color_Values IS NOT NULL THEN
922: --Populate bsc_kpi_series_colors table
923: Populate_Kpi_Series_Colors (
924: p_commit => FND_API.G_FALSE
925: ,p_Anal_Opt_Rec => l_Anal_Opt_Rec
926: ,p_Color_Values => p_Color_Values

Line 950: --Populate bsc_kpi_series_colors table

946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
947: END IF;
948:
949: IF p_Color_Values IS NOT NULL THEN
950: --Populate bsc_kpi_series_colors table
951: Populate_Kpi_Series_Colors (
952: p_commit => FND_API.G_FALSE
953: ,p_Anal_Opt_Rec => l_Anal_Opt_Rec
954: ,p_Color_Values => p_Color_Values

Line 1267: -- Deletes the old entries from bsc_kpi_series_colors and creates new entries using

1263: /************************************************************************************
1264: -- API name : Populate_Kpi_Series_Colors
1265: -- Type : Private
1266: -- Function:
1267: -- Deletes the old entries from bsc_kpi_series_colors and creates new entries using
1268: -- p_Color_Values
1269: ************************************************************************************/
1270:
1271: PROCEDURE Populate_Kpi_Series_Colors(

Line 1280: l_bm_id bsc_kpi_series_colors.bm_id%TYPE;

1276: ,x_msg_count OUT NOCOPY NUMBER
1277: ,x_msg_data OUT NOCOPY VARCHAR2
1278: ) IS
1279: i NUMBER;
1280: l_bm_id bsc_kpi_series_colors.bm_id%TYPE;
1281: l_bm_color bsc_kpi_series_colors.color%TYPE;
1282: BEGIN
1283:
1284: SAVEPOINT Pop_Kpi_Series_PUB;

Line 1281: l_bm_color bsc_kpi_series_colors.color%TYPE;

1277: ,x_msg_data OUT NOCOPY VARCHAR2
1278: ) IS
1279: i NUMBER;
1280: l_bm_id bsc_kpi_series_colors.bm_id%TYPE;
1281: l_bm_color bsc_kpi_series_colors.color%TYPE;
1282: BEGIN
1283:
1284: SAVEPOINT Pop_Kpi_Series_PUB;
1285: FND_MSG_PUB.Initialize;

Line 1288: DELETE FROM bsc_kpi_series_colors

1284: SAVEPOINT Pop_Kpi_Series_PUB;
1285: FND_MSG_PUB.Initialize;
1286: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
1287:
1288: DELETE FROM bsc_kpi_series_colors
1289: WHERE indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id AND
1290: analysis_option0 = p_Anal_Opt_Rec.Bsc_Option_Group0 AND
1291: analysis_option1 = p_Anal_Opt_Rec.Bsc_Option_Group1 AND
1292: analysis_option2 = p_Anal_Opt_Rec.Bsc_Option_Group2 AND

Line 1299: INSERT INTO bsc_kpi_series_colors (indicator

1295: WHILE (i 1296: l_bm_id := p_Color_Values(i);
1297: l_bm_color := p_Color_Values(i + 1);
1298:
1299: INSERT INTO bsc_kpi_series_colors (indicator
1300: ,analysis_option0
1301: ,analysis_option1
1302: ,analysis_option2
1303: ,series_id

Line 1367: -- Deletes the entries from bsc_kpi_series_colors

1363: /************************************************************************************
1364: -- API name : Delete_Kpi_Series_Colors
1365: -- Type : Private
1366: -- Function:
1367: -- Deletes the entries from bsc_kpi_series_colors
1368: ************************************************************************************/
1369:
1370: PROCEDURE Delete_Kpi_Series_Colors(
1371: p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 1383: DELETE FROM bsc_kpi_series_colors

1379: SAVEPOINT Delete_Kpi_SeriesColor_PUB;
1380: FND_MSG_PUB.Initialize;
1381: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
1382:
1383: DELETE FROM bsc_kpi_series_colors
1384: WHERE indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id AND
1385: analysis_option0 = p_Anal_Opt_Rec.Bsc_Option_Group0 AND
1386: analysis_option1 = p_Anal_Opt_Rec.Bsc_Option_Group1 AND
1387: analysis_option2 = p_Anal_Opt_Rec.Bsc_Option_Group2 AND