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_ANALYSIS_OPTION_PVT

Line 49: G_PKG_NAME CONSTANT varchar2(30) := 'BSC_ANALYSIS_OPTION_PVT';

45: | VB to Html |
46: +======================================================================================+
47: */
48:
49: G_PKG_NAME CONSTANT varchar2(30) := 'BSC_ANALYSIS_OPTION_PVT';
50:
51: --: This procedure is used to create an analysis option. This is the entry point
52: --: for the Analysis Option API.
53: --: This procedure is part of the Analysis Option API.

Line 127: BSC_ANALYSIS_OPTION_PVT.Create_Analysis_Options( p_commit

123:
124: -- If this is a new KPI then call private version right away with defaults passed.
125: -- If it is not a new KPI then do everything else.
126: if l_Anal_Opt_Rec.Bsc_New_Kpi = 'Y' then
127: BSC_ANALYSIS_OPTION_PVT.Create_Analysis_Options( p_commit
128: ,l_Anal_Opt_Rec
129: ,x_return_status
130: ,x_msg_count
131: ,x_msg_data);

Line 179: BSC_ANALYSIS_OPTION_PVT.Create_Analysis_Options( p_commit

175: l_Anal_Opt_Rec.Bsc_Measure_Help := l_Anal_Opt_Rec.Bsc_Measure_Long_Name;
176: end if;
177:
178: -- Call private version of procedure.
179: BSC_ANALYSIS_OPTION_PVT.Create_Analysis_Options( p_commit
180: ,l_Anal_Opt_Rec
181: ,x_return_status
182: ,x_msg_count
183: ,x_msg_data);

Line 200: BSC_ANALYSIS_OPTION_PVT.Create_Analysis_Options( p_commit

196: END IF;
197: -- repeat the steps for shared indicators also
198: FOR cd IN c_kpi_ids LOOP
199: l_Anal_Opt_Rec.Bsc_Kpi_Id := cd.Indicator;
200: BSC_ANALYSIS_OPTION_PVT.Create_Analysis_Options( p_commit
201: ,l_Anal_Opt_Rec
202: ,x_return_status
203: ,x_msg_count
204: ,x_msg_data);

Line 335: BSC_ANALYSIS_OPTION_PVT.Retrieve_Analysis_Options( p_commit

331: ,x_msg_data OUT NOCOPY varchar2
332: ) is
333: begin
334: x_return_status := FND_API.G_RET_STS_SUCCESS;
335: BSC_ANALYSIS_OPTION_PVT.Retrieve_Analysis_Options( p_commit
336: ,p_Anal_Opt_Rec
337: ,x_Anal_Opt_Rec
338: ,p_data_source
339: ,x_return_status

Line 414: BSC_ANALYSIS_OPTION_PVT.Update_Analysis_Options( p_commit

410: x_return_status := FND_API.G_RET_STS_SUCCESS;
411:
412: l_Anal_Opt_Rec := p_Anal_Opt_Rec;
413:
414: BSC_ANALYSIS_OPTION_PVT.Update_Analysis_Options( p_commit
415: ,p_Anal_Opt_Rec
416: ,p_data_source
417: ,x_return_status
418: ,x_msg_count

Line 432: BSC_ANALYSIS_OPTION_PVT.Update_Analysis_Options( p_commit

428: END IF;
429: -- if there are any shared KPIs update those also.
430: FOR cd IN c_kpi_ids LOOP
431: l_Anal_Opt_Rec.Bsc_Kpi_Id := cd.Indicator;
432: BSC_ANALYSIS_OPTION_PVT.Update_Analysis_Options( p_commit
433: ,l_Anal_Opt_Rec
434: ,p_data_source
435: ,x_return_status
436: ,x_msg_count

Line 566: BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Options( p_commit

562: ) is
563:
564: begin
565: x_return_status := FND_API.G_RET_STS_SUCCESS;
566: BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Options( p_commit
567: ,p_Anal_Opt_Rec
568: ,x_return_status
569: ,x_msg_count
570: ,x_msg_data);

Line 648: BSC_ANALYSIS_OPTION_PVT.Cascade_Series_Default_Value (

644: IF l_Anal_Opt_Rec.Bsc_Measure_Prototype_Flag IS NULL THEN
645: l_Anal_Opt_Rec.Bsc_Measure_Prototype_Flag := BSC_DESIGNER_PVT.C_COLOR_CHANGE;
646: END IF;
647:
648: BSC_ANALYSIS_OPTION_PVT.Cascade_Series_Default_Value (
649: p_Commit => l_commit
650: , p_Api_Mode => BSC_ANALYSIS_OPTION_PVT.C_API_CREATE
651: , p_Kpi_Id => l_Anal_Opt_Rec.Bsc_Kpi_Id
652: , p_Option0 => NVL(l_Anal_Opt_Rec.Bsc_Option_Group0, 0)

Line 650: , p_Api_Mode => BSC_ANALYSIS_OPTION_PVT.C_API_CREATE

646: END IF;
647:
648: BSC_ANALYSIS_OPTION_PVT.Cascade_Series_Default_Value (
649: p_Commit => l_commit
650: , p_Api_Mode => BSC_ANALYSIS_OPTION_PVT.C_API_CREATE
651: , p_Kpi_Id => l_Anal_Opt_Rec.Bsc_Kpi_Id
652: , p_Option0 => NVL(l_Anal_Opt_Rec.Bsc_Option_Group0, 0)
653: , p_Option1 => NVL(l_Anal_Opt_Rec.Bsc_Option_Group1, 0)
654: , p_Option2 => NVL(l_Anal_Opt_Rec.Bsc_Option_Group2, 0)

Line 667: BSC_ANALYSIS_OPTION_PVT.Create_Analysis_Measures( l_commit

663: l_Anal_Opt_Rec.Bsc_Dataset_Default_Value := l_Default_Value;
664:
665:
666: -- Call private version of the procedure.
667: BSC_ANALYSIS_OPTION_PVT.Create_Analysis_Measures( l_commit
668: ,l_Anal_Opt_Rec
669: ,x_return_status
670: ,x_msg_count
671: ,x_msg_data);

Line 763: BSC_ANALYSIS_OPTION_PVT.Retrieve_Analysis_Measures( p_commit

759: ) is
760:
761: begin
762: x_return_status := FND_API.G_RET_STS_SUCCESS;
763: BSC_ANALYSIS_OPTION_PVT.Retrieve_Analysis_Measures( p_commit
764: ,p_Anal_Opt_Rec
765: ,x_Anal_Opt_Rec
766: ,x_return_status
767: ,x_msg_count

Line 828: BSC_ANALYSIS_OPTION_PVT.Cascade_Series_Default_Value (

824: x_return_status := FND_API.G_RET_STS_SUCCESS;
825:
826: l_Anal_Opt_Rec := p_Anal_Opt_Rec;
827:
828: BSC_ANALYSIS_OPTION_PVT.Cascade_Series_Default_Value (
829: p_Commit => p_Commit
830: , p_Api_Mode => BSC_ANALYSIS_OPTION_PVT.C_API_UPDATE
831: , p_Kpi_Id => l_Anal_Opt_Rec.Bsc_Kpi_Id
832: , p_Option0 => NVL(l_Anal_Opt_Rec.Bsc_Option_Group0, 0)

Line 830: , p_Api_Mode => BSC_ANALYSIS_OPTION_PVT.C_API_UPDATE

826: l_Anal_Opt_Rec := p_Anal_Opt_Rec;
827:
828: BSC_ANALYSIS_OPTION_PVT.Cascade_Series_Default_Value (
829: p_Commit => p_Commit
830: , p_Api_Mode => BSC_ANALYSIS_OPTION_PVT.C_API_UPDATE
831: , p_Kpi_Id => l_Anal_Opt_Rec.Bsc_Kpi_Id
832: , p_Option0 => NVL(l_Anal_Opt_Rec.Bsc_Option_Group0, 0)
833: , p_Option1 => NVL(l_Anal_Opt_Rec.Bsc_Option_Group1, 0)
834: , p_Option2 => NVL(l_Anal_Opt_Rec.Bsc_Option_Group2, 0)

Line 846: BSC_ANALYSIS_OPTION_PVT.Update_Analysis_Measures( p_commit

842:
843: l_Anal_Opt_Rec.Bsc_Dataset_Default_Value := l_Default_Value;
844:
845:
846: BSC_ANALYSIS_OPTION_PVT.Update_Analysis_Measures( p_commit
847: ,l_Anal_Opt_Rec
848: ,x_return_status
849: ,x_msg_count
850: ,x_msg_data);

Line 975: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Cascade_Deletion_Color_Props ';

971: WHEN OTHERS THEN
972: ROLLBACK TO Create_Analayis_OptionObjPUB;
973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
974: IF (x_msg_data IS NOT NULL) THEN
975: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Cascade_Deletion_Color_Props ';
976: ELSE
977: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Cascade_Deletion_Color_Props ';
978: END IF;
979: END Cascade_Deletion_Color_Props;

Line 977: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Cascade_Deletion_Color_Props ';

973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
974: IF (x_msg_data IS NOT NULL) THEN
975: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Cascade_Deletion_Color_Props ';
976: ELSE
977: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Cascade_Deletion_Color_Props ';
978: END IF;
979: END Cascade_Deletion_Color_Props;
980:
981: /************************************************************************************

Line 996: BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Measures( p_commit

992:
993: x_return_status := FND_API.G_RET_STS_SUCCESS;
994:
995:
996: BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Measures( p_commit
997: ,p_Anal_Opt_Rec
998: ,x_return_status
999: ,x_msg_count
1000: ,x_msg_data);

Line 1072: BSC_ANALYSIS_OPTION_PVT.Delete_Ana_Opt_Mult_Groups

1068: , x_msg_data OUT NOCOPY VARCHAR2
1069: )IS
1070: BEGIN
1071: x_return_status := FND_API.G_RET_STS_SUCCESS;
1072: BSC_ANALYSIS_OPTION_PVT.Delete_Ana_Opt_Mult_Groups
1073: ( p_commit => FND_API.G_FALSE
1074: , p_Kpi_id => p_Kpi_id
1075: , p_Anal_Opt_Tbl => p_Anal_Opt_Tbl
1076: , p_max_group_count => p_max_group_count

Line 1136: BSC_ANALYSIS_OPTION_PVT.Synch_Kpi_Anal_Group

1132: )IS
1133: BEGIN
1134:
1135: x_return_status := FND_API.G_RET_STS_SUCCESS;
1136: BSC_ANALYSIS_OPTION_PVT.Synch_Kpi_Anal_Group
1137: ( p_commit => FND_API.G_FALSE
1138: , p_Kpi_Id => p_Kpi_Id
1139: , p_Anal_Opt_Tbl => p_Anal_Opt_Tbl
1140: , x_return_status => x_return_status

Line 1193: BSC_ANALYSIS_OPTION_PVT.store_anal_opt_grp_count

1189: , x_Anal_Opt_Tbl IN OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type
1190: ) IS
1191: BEGIN
1192:
1193: BSC_ANALYSIS_OPTION_PVT.store_anal_opt_grp_count
1194: (
1195: p_kpi_id => p_kpi_id
1196: , x_Anal_Opt_Tbl => x_Anal_Opt_Tbl
1197: );

Line 1252: BSC_ANALYSIS_OPTION_PVT.Validate_Custom_Measure

1248: END IF;
1249: END IF;
1250: END LOOP;
1251:
1252: BSC_ANALYSIS_OPTION_PVT.Validate_Custom_Measure
1253: ( p_Kpi_id => p_Kpi_id
1254: , p_option0 => p_option0
1255: , p_option1 => p_option1
1256: , p_option2 => p_option2

Line 1313: BSC_ANALYSIS_OPTION_PVT.delete_extra_series(

1309: BEGIN
1310: x_return_status := FND_API.G_RET_STS_SUCCESS;
1311: FND_MSG_PUB.Initialize;
1312:
1313: BSC_ANALYSIS_OPTION_PVT.delete_extra_series(
1314: p_Bsc_Anal_Opt_Rec => p_Bsc_Anal_Opt_Rec
1315: , x_return_status => x_return_status
1316: , x_msg_count => x_msg_count
1317: , x_msg_data => x_msg_data

Line 1867: BSC_ANALYSIS_OPTION_PVT.delete_Data_Series(

1863: AND analysis_option1 = p_Anal_Opt_Rec.Bsc_Option_Group1
1864: AND analysis_option2 = p_Anal_Opt_Rec.Bsc_Option_Group2;
1865:
1866: -- delete the dataseries metadata
1867: BSC_ANALYSIS_OPTION_PVT.delete_Data_Series(
1868: p_commit => FND_API.G_FALSE
1869: ,p_Anal_Opt_Rec => l_Anal_Opt_Rec
1870: ,x_return_status => x_return_status
1871: ,x_msg_count => x_msg_count

Line 1892: BSC_ANALYSIS_OPTION_PVT.delete_Data_Series(

1888: -- repeat the steps for shared indicators also
1889:
1890: FOR cd IN c_kpi_ids LOOP
1891: l_Anal_Opt_Rec.Bsc_Kpi_Id := cd.Indicator;
1892: BSC_ANALYSIS_OPTION_PVT.delete_Data_Series(
1893: p_commit => FND_API.G_FALSE
1894: ,p_Anal_Opt_Rec => l_Anal_Opt_Rec
1895: ,x_return_status => x_return_status
1896: ,x_msg_count => x_msg_count

Line 2049: BSC_ANALYSIS_OPTION_PVT.Swap_Data_Series_Id(

2045: x_return_status := FND_API.G_RET_STS_SUCCESS;
2046:
2047: l_Anal_Opt_Rec := p_Anal_Opt_Rec;
2048: -- Swaping
2049: BSC_ANALYSIS_OPTION_PVT.Swap_Data_Series_Id(
2050: p_commit => FND_API.G_FALSE
2051: ,p_Anal_Opt_Rec => l_Anal_Opt_Rec
2052: ,x_return_status => x_return_status
2053: ,x_msg_count => x_msg_count

Line 2059: BSC_ANALYSIS_OPTION_PVT.Swap_Data_Series_Id(

2055: );
2056: -- Cascading Swaping
2057: FOR cd IN c_kpi_ids LOOP
2058: l_Anal_Opt_Rec.Bsc_Kpi_Id := cd.Indicator;
2059: BSC_ANALYSIS_OPTION_PVT.Swap_Data_Series_Id(
2060: p_commit => FND_API.G_FALSE
2061: ,p_Anal_Opt_Rec => l_Anal_Opt_Rec
2062: ,x_return_status => x_return_status
2063: ,x_msg_count => x_msg_count

Line 2373: IF(BSC_ANALYSIS_OPTION_PVT.Validate_If_single_Anal_Opt(l_Anal_Opt_Tbl)) THEN

2369:
2370: IF(l_max_group_count>1) THEN
2371: BSC_BIS_KPI_MEAS_PUB.store_kpi_anal_group(p_obj_id, l_Anal_Opt_Tbl);
2372:
2373: IF(BSC_ANALYSIS_OPTION_PVT.Validate_If_single_Anal_Opt(l_Anal_Opt_Tbl)) THEN
2374: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP0;
2375: RETURN l_Anal_Grp_Id;
2376: END IF;
2377:

Line 2378: BSC_ANALYSIS_OPTION_PVT.Initialize_Anal_Opt_Tbl

2374: l_Anal_Grp_Id := BSC_ANALYSIS_OPTION_PUB.c_ANALYSIS_GROUP0;
2375: RETURN l_Anal_Grp_Id;
2376: END IF;
2377:
2378: BSC_ANALYSIS_OPTION_PVT.Initialize_Anal_Opt_Tbl
2379: (
2380: p_Kpi_id => p_obj_id
2381: , p_Anal_Opt_Tbl => l_Anal_Opt_Tbl
2382: , p_max_group_count => l_max_group_count

Line 2488: BSC_ANALYSIS_OPTION_PVT.Set_Default_Analysis_Option

2484: , x_msg_count OUT NOCOPY NUMBER
2485: , x_msg_data OUT NOCOPY VARCHAR2
2486: )IS
2487: BEGIN
2488: BSC_ANALYSIS_OPTION_PVT.Set_Default_Analysis_Option
2489: (
2490: p_commit => p_commit
2491: , p_obj_id => p_obj_id
2492: , p_Anal_Opt_Comb_Tbl => p_Anal_Opt_Comb_Tbl