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_OBJ_ANALYSIS_OPTIONS_PUB dependencies on BSC_ANALYSIS_OPTION_PUB

Line 226: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

222: ************************************************************************************/
223:
224: PROCEDURE Update_Default_Flag_Value(
225: p_commit IN VARCHAR2 := FND_API.G_FALSE
226: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
227: ,x_return_status OUT NOCOPY VARCHAR2
228: ,x_msg_count OUT NOCOPY NUMBER
229: ,x_msg_data OUT NOCOPY VARCHAR2
230: ) IS

Line 446: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

442: -- kpi based
443: ************************************************************************************/
444: PROCEDURE Check_Default_Props(
445: p_commit IN VARCHAR2 := FND_API.G_FALSE
446: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
447: ,p_cascade_shared BOOLEAN := FALSE
448: ,x_return_status OUT NOCOPY VARCHAR2
449: ,x_msg_count OUT NOCOPY NUMBER
450: ,x_msg_data OUT NOCOPY VARCHAR2

Line 456: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;

452:
453:
454: l_Old_Default_Value bsc_kpi_analysis_groups.default_value%TYPE;
455: l_commit VARCHAR2(1) := FND_API.G_FALSE;
456: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
457: l_Series_Id bsc_kpi_analysis_measures_b.series_id%TYPE := 0;
458: l_Budget_Flag bsc_kpi_analysis_measures_b.budget_flag%TYPE := 1;
459: CURSOR c_Old_Default_Value IS
460: SELECT

Line 969: l_Bsc_AnaOpt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;

965: l_AO1 bsc_kpi_analysis_measures_b.analysis_option1%TYPE;
966: l_AO2 bsc_kpi_analysis_measures_b.analysis_option2%TYPE;
967:
968: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
969: l_Bsc_AnaOpt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
970: l_Count NUMBER := 0;
971: l_DimSet_Id bsc_kpi_analysis_options_b.dim_set_id%TYPE := 0;
972: l_Measure_Source bsc_sys_datasets_vl.source%TYPE;
973: l_commit VARCHAR2(2) := FND_API.G_FALSE;

Line 1389: ,p_Anal_Opt_Rec IN Bsc_Analysis_Option_Pub.Bsc_Option_Rec_Type

1385: ************************************************************************************/
1386:
1387: PROCEDURE Delete_Mind_Options(
1388: p_commit IN VARCHAR2 := FND_API.G_FALSE
1389: ,p_Anal_Opt_Rec IN Bsc_Analysis_Option_Pub.Bsc_Option_Rec_Type
1390: ,p_Dependency01 IN NUMBER
1391: ,p_Dependency12 IN NUMBER
1392: ,p_Initial_Group_Id IN NUMBER
1393: ,x_return_status OUT NOCOPY VARCHAR2

Line 1405: l_Anal_Opt_Rec Bsc_Analysis_Option_Pub.Bsc_Option_Rec_Type;

1401: l_Grandchild_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE;
1402: l_criteria VARCHAR2(2000);
1403: l_sql VARCHAR2(2000);
1404:
1405: l_Anal_Opt_Rec Bsc_Analysis_Option_Pub.Bsc_Option_Rec_Type;
1406: l_Par_Opt_Rec Bsc_Analysis_Option_Pub.Bsc_Option_Rec_Type;
1407: l_commit VARCHAR2(2) := FND_API.G_FALSE;
1408: CURSOR c_Ana_Opt_Count IS
1409: SELECT

Line 1406: l_Par_Opt_Rec Bsc_Analysis_Option_Pub.Bsc_Option_Rec_Type;

1402: l_criteria VARCHAR2(2000);
1403: l_sql VARCHAR2(2000);
1404:
1405: l_Anal_Opt_Rec Bsc_Analysis_Option_Pub.Bsc_Option_Rec_Type;
1406: l_Par_Opt_Rec Bsc_Analysis_Option_Pub.Bsc_Option_Rec_Type;
1407: l_commit VARCHAR2(2) := FND_API.G_FALSE;
1408: CURSOR c_Ana_Opt_Count IS
1409: SELECT
1410: COUNT(1)

Line 1543: ,p_Anal_Opt_Rec IN Bsc_Analysis_Option_Pub.Bsc_Option_Rec_Type

1539:
1540:
1541: PROCEDURE Delete_Mind_Data(
1542: p_commit IN VARCHAR2 := FND_API.G_FALSE
1543: ,p_Anal_Opt_Rec IN Bsc_Analysis_Option_Pub.Bsc_Option_Rec_Type
1544: ,p_Parent_Group_Id IN NUMBER
1545: ,p_Grandparent_Group_Id IN NUMBER
1546: ,x_return_status OUT NOCOPY VARCHAR2
1547: ,x_msg_count OUT NOCOPY NUMBER

Line 1556: l_Anal_Opt_Rec Bsc_Analysis_Option_Pub.Bsc_Option_Rec_Type;

1552: c_NumOptions cursor_type;
1553: l_NumOptions NUMBER := 0;
1554: l_criteria VARCHAR2(2000);
1555: l_sql VARCHAR2(2000);
1556: l_Anal_Opt_Rec Bsc_Analysis_Option_Pub.Bsc_Option_Rec_Type;
1557: l_commit VARCHAR2(2) := FND_API.G_FALSE;
1558: --l_Initial_Kpi_Meas FND_TABLE_OF_NUMBER;
1559: BEGIN
1560:

Line 1605: BSC_ANALYSIS_OPTION_PUB.Cascade_Deletion_Color_Props (

1601:
1602: l_sql := 'DELETE FROM bsc_kpi_analysis_measures_tl ' || l_criteria;
1603: BSC_APPS.Execute_Immediate(l_sql);
1604:
1605: BSC_ANALYSIS_OPTION_PUB.Cascade_Deletion_Color_Props (
1606: p_commit => p_commit
1607: ,p_Anal_Opt_Rec => p_Anal_Opt_Rec
1608: ,x_return_status => x_return_status
1609: ,x_msg_count => x_msg_count

Line 1646: ,p_Anal_Opt_Rec IN Bsc_Analysis_Option_Pub.Bsc_Option_Rec_Type

1642:
1643:
1644: PROCEDURE Renumerate_Options(
1645: p_commit IN VARCHAR2 := FND_API.G_FALSE
1646: ,p_Anal_Opt_Rec IN Bsc_Analysis_Option_Pub.Bsc_Option_Rec_Type
1647: ,p_Parent_Group_Id IN NUMBER
1648: ,p_Grandparent_Group_Id IN NUMBER
1649: ,x_return_status OUT NOCOPY VARCHAR2
1650: ,x_msg_count OUT NOCOPY NUMBER

Line 1892: ,p_Anal_Opt_Rec IN Bsc_Analysis_Option_Pub.Bsc_Option_Rec_Type

1888:
1889:
1890: PROCEDURE Delete_Analysis_Option_Wrap (
1891: p_commit IN VARCHAR2 := FND_API.G_FALSE
1892: ,p_Anal_Opt_Rec IN Bsc_Analysis_Option_Pub.Bsc_Option_Rec_Type
1893: ,p_cascade_shared BOOLEAN := FALSE
1894: ,x_return_status OUT NOCOPY VARCHAR2
1895: ,x_msg_count OUT NOCOPY NUMBER
1896: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1907: l_Bsc_Anal_Opt_Rec Bsc_Analysis_Option_Pub.Bsc_Option_Rec_Type;

1903: l_GrandParent_Id bsc_kpi_analysis_options_b.grandparent_option_id%TYPE := 0;
1904: l_Parent_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE := 0;
1905: l_GrandParent_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE := 0;
1906:
1907: l_Bsc_Anal_Opt_Rec Bsc_Analysis_Option_Pub.Bsc_Option_Rec_Type;
1908:
1909: l_commit VARCHAR2(2) := FND_API.G_FALSE;
1910:
1911: CURSOR c_shared_objs IS

Line 2319: l_Bsc_AnaOpt_Rec Bsc_Analysis_Option_Pub.Bsc_Option_Rec_Type;

2315: ) IS
2316: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
2317: l_Count NUMBER := 0;
2318:
2319: l_Bsc_AnaOpt_Rec Bsc_Analysis_Option_Pub.Bsc_Option_Rec_Type;
2320: l_Initial_Options NUMBER := 0;
2321: l_Reset_Child_Defaults BOOLEAN := FALSE;
2322: l_new_Default bsc_kpi_analysis_groups.default_value%TYPE := 0;
2323: l_commit VARCHAR2(2) := FND_API.G_FALSE;

Line 2421: l_Initial_Options := BSC_ANALYSIS_OPTION_PUB.Get_Num_Analysis_options(p_Indicator,p_Analysis_Group_Id);

2417: OPEN c_imported_dims;
2418: FETCH c_imported_dims BULK COLLECT INTO l_olddim_set_ids;
2419: CLOSE c_imported_dims;
2420:
2421: l_Initial_Options := BSC_ANALYSIS_OPTION_PUB.Get_Num_Analysis_options(p_Indicator,p_Analysis_Group_Id);
2422:
2423: Delete_Analysis_Option_Wrap (
2424: p_commit => p_commit
2425: ,p_Anal_Opt_Rec => l_Bsc_AnaOpt_Rec

Line 2764: l_Anal_Opt_Rec Bsc_Analysis_Option_Pub.Bsc_Option_Rec_Type;

2760: l_Count NUMBER := 0;
2761: l_Sql VARCHAR2(2000);
2762: l_ana_option_id bsc_kpi_analysis_options_b.option_id%TYPE;
2763: l_commit VARCHAR2(2) := FND_API.G_FALSE;
2764: l_Anal_Opt_Rec Bsc_Analysis_Option_Pub.Bsc_Option_Rec_Type;
2765: l_Generated_Row_Count NUMBER := 0;
2766:
2767: CURSOR c_Exists_Ana_Opt IS
2768: SELECT

Line 2936: Bsc_Analysis_Option_Pub.Create_Analysis_Measures(

2932: l_Anal_Opt_Rec.Bsc_Measure_Long_Name := fnd_message.get_string('BSC','BSC_NEW_SERIES') || ' 0';
2933: l_Anal_Opt_Rec.Bsc_Measure_Help := fnd_message.get_string('BSC','BSC_NEW_SERIES') || ' 0';
2934: l_Anal_Opt_Rec.Bsc_Measure_Prototype_Flag := 7;
2935:
2936: Bsc_Analysis_Option_Pub.Create_Analysis_Measures(
2937: p_commit => l_commit
2938: ,p_Anal_Opt_Rec => l_Anal_Opt_Rec
2939: ,x_return_status => x_return_status
2940: ,x_msg_count => x_msg_count

Line 3144: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;

3140: l_Count NUMBER := 0;
3141: l_Parent_Analysis_Id bsc_kpi_analysis_groups.parent_analysis_id%TYPE := 0;
3142: l_Parent_Option_Id bsc_kpi_analysis_options_b.parent_option_id%TYPE;
3143: l_GrandParent_Option_Id bsc_kpi_analysis_options_b.grandparent_option_id%TYPE;
3144: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
3145: l_Create_Group BOOLEAN := FALSE;
3146: l_commit VARCHAR2(2) := FND_API.G_FALSE;
3147: l_Measure_Source bsc_sys_datasets_vl.source%TYPE := 'BSC';
3148: