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_KPI_ANALYSIS_OPTIONS_B

Line 27: l_AO1_Parent_Id bsc_kpi_analysis_options_b.parent_option_id%TYPE := 0;

23: l_AnaOpt0_Default bsc_kpi_analysis_groups.default_value%TYPE := 0;
24: l_AnaOpt1_Default bsc_kpi_analysis_groups.default_value%TYPE := 0;
25: l_AnaOpt2_Default bsc_kpi_analysis_groups.default_value%TYPE := 0;
26:
27: l_AO1_Parent_Id bsc_kpi_analysis_options_b.parent_option_id%TYPE := 0;
28: l_AO1_GrandParent_Id bsc_kpi_analysis_options_b.grandparent_option_id%TYPE := 0;
29: l_AO2_Parent_Id bsc_kpi_analysis_options_b.parent_option_id%TYPE := 0;
30: l_AO2_GrandParent_Id bsc_kpi_analysis_options_b.grandparent_option_id%TYPE := 0;
31: l_Max_Group_Id NUMBER := 0;

Line 28: l_AO1_GrandParent_Id bsc_kpi_analysis_options_b.grandparent_option_id%TYPE := 0;

24: l_AnaOpt1_Default bsc_kpi_analysis_groups.default_value%TYPE := 0;
25: l_AnaOpt2_Default bsc_kpi_analysis_groups.default_value%TYPE := 0;
26:
27: l_AO1_Parent_Id bsc_kpi_analysis_options_b.parent_option_id%TYPE := 0;
28: l_AO1_GrandParent_Id bsc_kpi_analysis_options_b.grandparent_option_id%TYPE := 0;
29: l_AO2_Parent_Id bsc_kpi_analysis_options_b.parent_option_id%TYPE := 0;
30: l_AO2_GrandParent_Id bsc_kpi_analysis_options_b.grandparent_option_id%TYPE := 0;
31: l_Max_Group_Id NUMBER := 0;
32: l_Parent_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE;

Line 29: l_AO2_Parent_Id bsc_kpi_analysis_options_b.parent_option_id%TYPE := 0;

25: l_AnaOpt2_Default bsc_kpi_analysis_groups.default_value%TYPE := 0;
26:
27: l_AO1_Parent_Id bsc_kpi_analysis_options_b.parent_option_id%TYPE := 0;
28: l_AO1_GrandParent_Id bsc_kpi_analysis_options_b.grandparent_option_id%TYPE := 0;
29: l_AO2_Parent_Id bsc_kpi_analysis_options_b.parent_option_id%TYPE := 0;
30: l_AO2_GrandParent_Id bsc_kpi_analysis_options_b.grandparent_option_id%TYPE := 0;
31: l_Max_Group_Id NUMBER := 0;
32: l_Parent_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE;
33: l_GrandParent_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE;

Line 30: l_AO2_GrandParent_Id bsc_kpi_analysis_options_b.grandparent_option_id%TYPE := 0;

26:
27: l_AO1_Parent_Id bsc_kpi_analysis_options_b.parent_option_id%TYPE := 0;
28: l_AO1_GrandParent_Id bsc_kpi_analysis_options_b.grandparent_option_id%TYPE := 0;
29: l_AO2_Parent_Id bsc_kpi_analysis_options_b.parent_option_id%TYPE := 0;
30: l_AO2_GrandParent_Id bsc_kpi_analysis_options_b.grandparent_option_id%TYPE := 0;
31: l_Max_Group_Id NUMBER := 0;
32: l_Parent_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE;
33: l_GrandParent_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE;
34:

Line 97: UPDATE bsc_kpi_analysis_options_b

93: ,x_GrandParent_Group_Id => l_GrandParent_Group_Id
94: );
95: END IF;
96:
97: UPDATE bsc_kpi_analysis_options_b
98: SET
99: user_level0 = 2
100: ,user_level1 = 2
101: WHERE indicator = p_Indicator;

Line 103: UPDATE bsc_kpi_analysis_options_b

99: user_level0 = 2
100: ,user_level1 = 2
101: WHERE indicator = p_Indicator;
102:
103: UPDATE bsc_kpi_analysis_options_b
104: SET
105: user_level0 = 1
106: ,user_level1 = 1
107: WHERE

Line 116: UPDATE bsc_kpi_analysis_options_b

112:
113:
114: IF p_cascade_shared THEN
115: FOR cd in c_shared_objs LOOP
116: UPDATE bsc_kpi_analysis_options_b
117: SET
118: user_level0 = 2
119: ,user_level1 = 2
120: WHERE indicator = cd.Indicator;

Line 122: UPDATE bsc_kpi_analysis_options_b

118: user_level0 = 2
119: ,user_level1 = 2
120: WHERE indicator = cd.Indicator;
121:
122: UPDATE bsc_kpi_analysis_options_b
123: SET
124: user_level0 = 1
125: ,user_level1 = 1
126: WHERE

Line 243: l_Temp_Ana_Grp_Id bsc_kpi_analysis_options_b.analysis_group_id%TYPE;

239:
240: l_Dependency01 bsc_kpi_analysis_groups.dependency_flag%TYPE := 0;
241: l_Dependency12 bsc_kpi_analysis_groups.dependency_flag%TYPE := 0;
242:
243: l_Temp_Ana_Grp_Id bsc_kpi_analysis_options_b.analysis_group_id%TYPE;
244: l_Temp_Ana_Option_Id bsc_kpi_analysis_options_b.option_id%TYPE;
245:
246: BEGIN
247:

Line 244: l_Temp_Ana_Option_Id bsc_kpi_analysis_options_b.option_id%TYPE;

240: l_Dependency01 bsc_kpi_analysis_groups.dependency_flag%TYPE := 0;
241: l_Dependency12 bsc_kpi_analysis_groups.dependency_flag%TYPE := 0;
242:
243: l_Temp_Ana_Grp_Id bsc_kpi_analysis_options_b.analysis_group_id%TYPE;
244: l_Temp_Ana_Option_Id bsc_kpi_analysis_options_b.option_id%TYPE;
245:
246: BEGIN
247:
248: SAVEPOINT Update_Default_Flag_Val_PVT;

Line 971: l_DimSet_Id bsc_kpi_analysis_options_b.dim_set_id%TYPE := 0;

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;
974:
975: l_config_type bsc_kpis_b.config_type%TYPE;

Line 978: l_old_DimSet_id bsc_kpi_analysis_options_b.dim_set_id%TYPE;

974:
975: l_config_type bsc_kpis_b.config_type%TYPE;
976: l_indicator_type bsc_kpis_b.indicator_type%TYPE;
977:
978: l_old_DimSet_id bsc_kpi_analysis_options_b.dim_set_id%TYPE;
979: l_old_data_set_id bsc_kpi_analysis_measures_b.dataset_id%TYPE;
980:
981: l_temp_Parent_Id NUMBER := NULL;
982: l_temp_GrandParent_Id NUMBER := NULL;

Line 1007: bsc_kpi_analysis_options_b

1003: c_old_dim_set_id IS
1004: SELECT
1005: dim_set_id
1006: FROM
1007: bsc_kpi_analysis_options_b
1008: WHERE analysis_group_id = p_Analysis_Group_Id
1009: AND option_id = p_Option_Id
1010: AND parent_option_id = p_Parent_Option_Id
1011: AND grandparent_option_id = p_GrandParent_Option_Id;

Line 1412: bsc_kpi_analysis_options_b

1408: CURSOR c_Ana_Opt_Count IS
1409: SELECT
1410: COUNT(1)
1411: FROM
1412: bsc_kpi_analysis_options_b
1413: WHERE indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id AND
1414: analysis_group_id = p_Anal_Opt_Rec.Bsc_Analysis_Group_Id;
1415:
1416: CURSOR c_Child_Options IS

Line 1420: bsc_kpi_analysis_options_b

1416: CURSOR c_Child_Options IS
1417: SELECT
1418: option_id
1419: FROM
1420: bsc_kpi_analysis_options_b
1421: WHERE
1422: indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id AND
1423: analysis_group_id = 1 AND
1424: parent_option_id = l_Anal_Opt_Rec.Bsc_Analysis_Option_Id;

Line 1446: l_sql := 'DELETE FROM bsc_kpi_analysis_options_b ' || l_criteria;

1442: l_criteria := l_criteria || ' AND grandparent_option_id = '|| l_Anal_Opt_Rec.Bsc_Grandparent_Option_Id;
1443: END IF;
1444: END IF;
1445:
1446: l_sql := 'DELETE FROM bsc_kpi_analysis_options_b ' || l_criteria;
1447: BSC_APPS.Execute_Immediate(l_sql);
1448:
1449: l_sql := 'DELETE FROM bsc_kpi_analysis_options_tl ' || l_criteria;
1450: BSC_APPS.Execute_Immediate(l_sql);

Line 1568: l_sql := 'SELECT COUNT(1) FROM bsc_kpi_analysis_options_b WHERE indicator = ' || l_Anal_Opt_Rec.Bsc_Kpi_Id ;

1564:
1565: l_Anal_Opt_Rec := p_Anal_Opt_Rec;
1566:
1567:
1568: l_sql := 'SELECT COUNT(1) FROM bsc_kpi_analysis_options_b WHERE indicator = ' || l_Anal_Opt_Rec.Bsc_Kpi_Id ;
1569: l_sql := l_sql || ' AND analysis_group_id = ' || l_Anal_Opt_Rec.Bsc_Analysis_Group_Id;
1570:
1571: IF p_Parent_Group_Id <> -1 THEN
1572: l_sql := l_sql || ' AND parent_option_id = '|| l_Anal_Opt_Rec.Bsc_Parent_Option_Id;

Line 1660: l_option_id bsc_kpi_analysis_options_b.option_id%TYPE;

1656: l_criteria_parent VARCHAR2(2000);
1657:
1658: l_cur_index NUMBER := 0;
1659: l_max_groups NUMBER := 0;
1660: l_option_id bsc_kpi_analysis_options_b.option_id%TYPE;
1661: l_options_sql VARCHAR2(2000);
1662: l_sql VARCHAR2(2000);
1663:
1664: TYPE CursorType IS REF CURSOR;

Line 1687: l_options_sql := 'SELECT option_id FROM bsc_kpi_analysis_options_b ';

1683: l_criteria_options := l_criteria_options || ' AND grandparent_option_id='|| p_Anal_Opt_Rec.Bsc_Grandparent_Option_Id;
1684: END IF;
1685: END IF;
1686:
1687: l_options_sql := 'SELECT option_id FROM bsc_kpi_analysis_options_b ';
1688: l_options_sql := l_options_sql || l_criteria_options || ' ORDER BY option_id';
1689:
1690: OPEN c_option FOR l_options_sql;
1691: LOOP

Line 1717: l_sql := 'UPDATE bsc_kpi_analysis_options_b SET option_id='|| l_cur_index;

1713: l_sql := 'UPDATE bsc_kpi_subtitles_tl SET analysis_option'|| p_Anal_Opt_Rec.Bsc_Analysis_Group_Id || '=' || l_cur_index;
1714: l_sql := l_sql || l_criteria_measures;
1715: BSC_APPS.Execute_Immediate(l_sql);
1716:
1717: l_sql := 'UPDATE bsc_kpi_analysis_options_b SET option_id='|| l_cur_index;
1718: l_sql := l_sql || l_criteria_options || ' AND option_id = ' || l_option_id;
1719: BSC_APPS.Execute_Immediate(l_sql);
1720:
1721: l_sql := 'UPDATE bsc_kpi_analysis_options_tl SET option_id='|| l_cur_index;

Line 1734: l_sql := 'UPDATE bsc_kpi_analysis_options_b SET parent_option_id = '|| l_cur_index ;

1730:
1731: l_criteria_parent := ' WHERE indicator = '|| p_Anal_Opt_Rec.Bsc_Kpi_Id;
1732: l_criteria_parent := l_criteria_parent || ' AND analysis_group_id = ' || (p_Anal_Opt_Rec.Bsc_Analysis_Group_Id + 1) ||' AND parent_option_id = ' || l_option_id;
1733:
1734: l_sql := 'UPDATE bsc_kpi_analysis_options_b SET parent_option_id = '|| l_cur_index ;
1735: l_sql := l_sql || l_criteria_parent;
1736: BSC_APPS.Execute_Immediate(l_sql);
1737:
1738: l_sql := 'UPDATE bsc_kpi_analysis_options_tl SET parent_option_id = '|| l_cur_index ;

Line 1749: l_sql := 'UPDATE bsc_kpi_analysis_options_b SET grandparent_option_id = '|| l_cur_index ;

1745:
1746: l_criteria_parent := ' WHERE indicator = '|| p_Anal_Opt_Rec.Bsc_Kpi_Id;
1747: l_criteria_parent := l_criteria_parent || ' AND analysis_group_id = ' || (p_Anal_Opt_Rec.Bsc_Analysis_Group_Id + 1) ||' AND grandparent_option_id = ' || l_option_id;
1748:
1749: l_sql := 'UPDATE bsc_kpi_analysis_options_b SET grandparent_option_id = '|| l_cur_index ;
1750: l_sql := l_sql || l_criteria_parent;
1751: BSC_APPS.Execute_Immediate(l_sql);
1752:
1753: l_sql := 'UPDATE bsc_kpi_analysis_options_tl SET grandparent_option_id = '|| l_cur_index ;

Line 1796: bsc_kpi_analysis_options_b

1792:
1793: CURSOR c_ana_opt_cnt(p_Analysis_Group_Id NUMBER) IS
1794: SELECT MAX(option_id)
1795: FROM
1796: bsc_kpi_analysis_options_b
1797: WHERE
1798: indicator = p_Indicator AND
1799: analysis_group_id = p_Analysis_Group_Id;
1800:

Line 1902: l_Parent_Id bsc_kpi_analysis_options_b.parent_option_id%TYPE := 0;

1898:
1899: l_Dependency01 bsc_kpi_analysis_groups.dependency_flag%TYPE := -1;
1900: l_Dependency12 bsc_kpi_analysis_groups.dependency_flag%TYPE := -1;
1901:
1902: l_Parent_Id bsc_kpi_analysis_options_b.parent_option_id%TYPE := 0;
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:

Line 1903: l_GrandParent_Id bsc_kpi_analysis_options_b.grandparent_option_id%TYPE := 0;

1899: l_Dependency01 bsc_kpi_analysis_groups.dependency_flag%TYPE := -1;
1900: l_Dependency12 bsc_kpi_analysis_groups.dependency_flag%TYPE := -1;
1901:
1902: l_Parent_Id bsc_kpi_analysis_options_b.parent_option_id%TYPE := 0;
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;

Line 2213: bsc_kpi_analysis_options_b

2209: CURSOR c_Num_Options(p_Group_Id NUMBER) IS
2210: SELECT
2211: COUNT(1)
2212: FROM
2213: bsc_kpi_analysis_options_b
2214: WHERE
2215: indicator = p_Indicator AND
2216: analysis_group_id = p_Group_Id;
2217:

Line 2348: bsc_kpi_analysis_options_b kpi_opt

2344: FROM
2345: bsc_kpis_b kpi,
2346: bsc_kpi_dim_groups kpi_dim,
2347: bsc_sys_dim_groups_vl sys_dim,
2348: bsc_kpi_analysis_options_b kpi_opt
2349: WHERE
2350: kpi.indicator = p_Indicator AND
2351: kpi.short_name IS NULL AND
2352: kpi_dim.indicator = kpi.indicator AND

Line 2762: l_ana_option_id bsc_kpi_analysis_options_b.option_id%TYPE;

2758: TYPE ana_opt_type IS REF CURSOR;
2759: c_ana_opt_type ana_opt_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:

Line 2783: l_sql := 'SELECT option_id FROM bsc_kpi_analysis_options_b WHERE indicator = :1 ';

2779: SAVEPOINT Generate_Ana_Meas_Combs_PVT;
2780: x_return_status := FND_API.G_RET_STS_SUCCESS;
2781:
2782:
2783: l_sql := 'SELECT option_id FROM bsc_kpi_analysis_options_b WHERE indicator = :1 ';
2784:
2785: IF p_Analysis_Option0 = -1 THEN -- Permute with Group0 Analysis Options
2786:
2787: l_sql := l_sql || ' AND analysis_group_id = 0';

Line 3142: l_Parent_Option_Id bsc_kpi_analysis_options_b.parent_option_id%TYPE;

3138: ) IS
3139:
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;

Line 3143: l_GrandParent_Option_Id bsc_kpi_analysis_options_b.grandparent_option_id%TYPE;

3139:
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';

Line 3453: l_Parent_Id bsc_kpi_analysis_options_b.parent_option_id%TYPE := 0;

3449: l_kpi_full_name VARCHAR2(1024) := NULL;
3450: l_NumOptions NUMBER := 0;
3451: l_criteria VARCHAR2(2000);
3452: l_sql VARCHAR2(2000);
3453: l_Parent_Id bsc_kpi_analysis_options_b.parent_option_id%TYPE := 0;
3454: l_GrandParent_Id bsc_kpi_analysis_options_b.grandparent_option_id%TYPE := 0;
3455: l_Parent_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE := 0;
3456: l_GrandParent_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE := 0;
3457:

Line 3454: l_GrandParent_Id bsc_kpi_analysis_options_b.grandparent_option_id%TYPE := 0;

3450: l_NumOptions NUMBER := 0;
3451: l_criteria VARCHAR2(2000);
3452: l_sql VARCHAR2(2000);
3453: l_Parent_Id bsc_kpi_analysis_options_b.parent_option_id%TYPE := 0;
3454: l_GrandParent_Id bsc_kpi_analysis_options_b.grandparent_option_id%TYPE := 0;
3455: l_Parent_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE := 0;
3456: l_GrandParent_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE := 0;
3457:
3458: CURSOR c_Grp_Cnt(p_Ana_Grp NUMBER) IS

Line 3525: l_sql := 'SELECT COUNT(1) FROM bsc_kpi_analysis_options_b WHERE indicator = ' || p_Indicator ;

3521: ,x_Parent_Group_Id => l_Parent_Group_Id
3522: ,x_GrandParent_Group_Id => l_GrandParent_Group_Id
3523: );
3524:
3525: l_sql := 'SELECT COUNT(1) FROM bsc_kpi_analysis_options_b WHERE indicator = ' || p_Indicator ;
3526: l_sql := l_sql || ' AND analysis_group_id = ' || p_Analysis_Group_Id;
3527:
3528: IF l_Parent_Group_Id <> -1 THEN
3529: l_sql := l_sql || ' AND parent_option_id = '|| l_Parent_Id;

Line 3607: l_Parent_Id bsc_kpi_analysis_options_b.parent_option_id%TYPE := 0;

3603: ,x_Option_Id OUT NOCOPY NUMBER
3604: ) IS
3605: l_Dependency01 bsc_kpi_analysis_groups.dependency_flag%TYPE;
3606: l_Dependency12 bsc_kpi_analysis_groups.dependency_flag%TYPE;
3607: l_Parent_Id bsc_kpi_analysis_options_b.parent_option_id%TYPE := 0;
3608: l_GrandParent_Id bsc_kpi_analysis_options_b.grandparent_option_id%TYPE := 0;
3609: l_Next_Option_Id bsc_kpi_analysis_options_b.option_id%TYPE := NULL;
3610: l_Parent_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE := 0;
3611: l_GrandParent_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE := 0;

Line 3608: l_GrandParent_Id bsc_kpi_analysis_options_b.grandparent_option_id%TYPE := 0;

3604: ) IS
3605: l_Dependency01 bsc_kpi_analysis_groups.dependency_flag%TYPE;
3606: l_Dependency12 bsc_kpi_analysis_groups.dependency_flag%TYPE;
3607: l_Parent_Id bsc_kpi_analysis_options_b.parent_option_id%TYPE := 0;
3608: l_GrandParent_Id bsc_kpi_analysis_options_b.grandparent_option_id%TYPE := 0;
3609: l_Next_Option_Id bsc_kpi_analysis_options_b.option_id%TYPE := NULL;
3610: l_Parent_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE := 0;
3611: l_GrandParent_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE := 0;
3612:

Line 3609: l_Next_Option_Id bsc_kpi_analysis_options_b.option_id%TYPE := NULL;

3605: l_Dependency01 bsc_kpi_analysis_groups.dependency_flag%TYPE;
3606: l_Dependency12 bsc_kpi_analysis_groups.dependency_flag%TYPE;
3607: l_Parent_Id bsc_kpi_analysis_options_b.parent_option_id%TYPE := 0;
3608: l_GrandParent_Id bsc_kpi_analysis_options_b.grandparent_option_id%TYPE := 0;
3609: l_Next_Option_Id bsc_kpi_analysis_options_b.option_id%TYPE := NULL;
3610: l_Parent_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE := 0;
3611: l_GrandParent_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE := 0;
3612:
3613: CURSOR c_Next_Opt_Id(p_Parent NUMBER, p_GrandParent NUMBER) IS

Line 3617: bsc_kpi_analysis_options_b

3613: CURSOR c_Next_Opt_Id(p_Parent NUMBER, p_GrandParent NUMBER) IS
3614: SELECT
3615: MAX(option_id) AS MAX
3616: FROM
3617: bsc_kpi_analysis_options_b
3618: WHERE
3619: indicator = p_Indicator
3620: AND analysis_group_id = p_Analysis_Group_Id
3621: AND parent_option_id = p_Parent

Line 4144: l_DimSet_Id bsc_kpi_analysis_options_b.dim_set_id%TYPE := NULL;

4140: ,p_Analysis_Option2 IN NUMBER := 0
4141: ,p_Dim_Set_Group IN NUMBER := 0
4142: ) RETURN NUMBER IS
4143:
4144: l_DimSet_Id bsc_kpi_analysis_options_b.dim_set_id%TYPE := NULL;
4145: l_Option_Id bsc_kpi_analysis_options_b.option_id%TYPE := 0;
4146: l_Parent_Id bsc_kpi_analysis_options_b.option_id%TYPE := 0;
4147: l_GrandParent_Id bsc_kpi_analysis_options_b.option_id%TYPE := 0;
4148:

Line 4145: l_Option_Id bsc_kpi_analysis_options_b.option_id%TYPE := 0;

4141: ,p_Dim_Set_Group IN NUMBER := 0
4142: ) RETURN NUMBER IS
4143:
4144: l_DimSet_Id bsc_kpi_analysis_options_b.dim_set_id%TYPE := NULL;
4145: l_Option_Id bsc_kpi_analysis_options_b.option_id%TYPE := 0;
4146: l_Parent_Id bsc_kpi_analysis_options_b.option_id%TYPE := 0;
4147: l_GrandParent_Id bsc_kpi_analysis_options_b.option_id%TYPE := 0;
4148:
4149: CURSOR c_Dim_Set_ID(p_Analysis_Group_Id NUMBER,

Line 4146: l_Parent_Id bsc_kpi_analysis_options_b.option_id%TYPE := 0;

4142: ) RETURN NUMBER IS
4143:
4144: l_DimSet_Id bsc_kpi_analysis_options_b.dim_set_id%TYPE := NULL;
4145: l_Option_Id bsc_kpi_analysis_options_b.option_id%TYPE := 0;
4146: l_Parent_Id bsc_kpi_analysis_options_b.option_id%TYPE := 0;
4147: l_GrandParent_Id bsc_kpi_analysis_options_b.option_id%TYPE := 0;
4148:
4149: CURSOR c_Dim_Set_ID(p_Analysis_Group_Id NUMBER,
4150: p_Option_Id NUMBER, p_Parent_Id NUMBER, p_GrandParentId NUMBER) IS

Line 4147: l_GrandParent_Id bsc_kpi_analysis_options_b.option_id%TYPE := 0;

4143:
4144: l_DimSet_Id bsc_kpi_analysis_options_b.dim_set_id%TYPE := NULL;
4145: l_Option_Id bsc_kpi_analysis_options_b.option_id%TYPE := 0;
4146: l_Parent_Id bsc_kpi_analysis_options_b.option_id%TYPE := 0;
4147: l_GrandParent_Id bsc_kpi_analysis_options_b.option_id%TYPE := 0;
4148:
4149: CURSOR c_Dim_Set_ID(p_Analysis_Group_Id NUMBER,
4150: p_Option_Id NUMBER, p_Parent_Id NUMBER, p_GrandParentId NUMBER) IS
4151: SELECT

Line 4154: bsc_kpi_analysis_options_b

4150: p_Option_Id NUMBER, p_Parent_Id NUMBER, p_GrandParentId NUMBER) IS
4151: SELECT
4152: dim_set_id
4153: FROM
4154: bsc_kpi_analysis_options_b
4155: WHERE
4156: indicator = p_Indicator AND
4157: analysis_group_id = p_Analysis_Group_Id AND
4158: option_id = p_Option_Id AND