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_GROUPS

Line 23: l_AnaOpt0_Default bsc_kpi_analysis_groups.default_value%TYPE := 0;

19: ,x_msg_count OUT NOCOPY NUMBER
20: ,x_msg_data OUT NOCOPY VARCHAR2
21: )IS
22:
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;

Line 24: l_AnaOpt1_Default bsc_kpi_analysis_groups.default_value%TYPE := 0;

20: ,x_msg_data OUT NOCOPY VARCHAR2
21: )IS
22:
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;

Line 25: l_AnaOpt2_Default bsc_kpi_analysis_groups.default_value%TYPE := 0;

21: )IS
22:
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;

Line 32: l_Parent_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE;

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:
35:
36: CURSOR c_shared_objs IS

Line 33: l_GrandParent_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE;

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:
35:
36: CURSOR c_shared_objs IS
37: SELECT

Line 65: bsc_kpi_analysis_groups

61: MAX(analysis_group_id)
62: INTO
63: l_Max_Group_Id
64: FROM
65: bsc_kpi_analysis_groups
66: WHERE
67: indicator = p_Indicator;
68:
69: IF l_Max_Group_Id >= 1 THEN

Line 154: -- This API sets the change_dim_set flag of bsc_kpi_analysis_groups

150: /************************************************************************************
151: -- API name : Update_Change_DimSet
152: -- Type : Private
153: -- Function :
154: -- This API sets the change_dim_set flag of bsc_kpi_analysis_groups
155: -- If the current analysis group has this flag set to 1 , the flag corresponding
156: -- to other analysis groups will be reset to 0
157: -- change_dim_set decides , from which group the dimension set should be
158: -- picked up in the current analysis_option combination

Line 178: bsc_kpi_analysis_groups

174: x_return_status := FND_API.G_RET_STS_SUCCESS;
175: FND_MSG_PUB.Initialize;
176:
177: UPDATE
178: bsc_kpi_analysis_groups
179: SET
180: change_dim_set = p_Change_Dim_Set
181: WHERE
182: indicator = p_Indicator AND

Line 187: bsc_kpi_analysis_groups

183: analysis_group_id = p_Analysis_Group_Id;
184:
185: IF p_Change_Dim_Set = 1 THEN
186: UPDATE
187: bsc_kpi_analysis_groups
188: SET
189: change_dim_set = 0
190: WHERE
191: indicator = p_Indicator AND

Line 215: -- Updates the bsc_kpi_analysis_groups with the current option id

211: /************************************************************************************
212: -- API name : Update_Default_Flag_Val
213: -- Type : Private
214: -- Function :
215: -- Updates the bsc_kpi_analysis_groups with the current option id
216: -- Also Cascade the dependent default value of the related groups i.e
217: -- (bsc_kpi_analysis_groups dependency_flag = 1)
218: -- 1. When child is set as the default make its parent as the default for
219: -- the parent analysis group

Line 217: -- (bsc_kpi_analysis_groups dependency_flag = 1)

213: -- Type : Private
214: -- Function :
215: -- Updates the bsc_kpi_analysis_groups with the current option id
216: -- Also Cascade the dependent default value of the related groups i.e
217: -- (bsc_kpi_analysis_groups dependency_flag = 1)
218: -- 1. When child is set as the default make its parent as the default for
219: -- the parent analysis group
220: -- 2. When parent is set as the default, reset the default in child group to 0
221:

Line 236: bsc_kpi_analysis_groups

232: CURSOR c_dependency_flag(p_ana_grp_id NUMBER) IS
233: SELECT
234: dependency_flag
235: FROM
236: bsc_kpi_analysis_groups
237: WHERE indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id
238: AND analysis_group_id = p_ana_grp_id;
239:
240: l_Dependency01 bsc_kpi_analysis_groups.dependency_flag%TYPE := 0;

Line 240: l_Dependency01 bsc_kpi_analysis_groups.dependency_flag%TYPE := 0;

236: bsc_kpi_analysis_groups
237: WHERE indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id
238: AND analysis_group_id = p_ana_grp_id;
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;

Line 241: l_Dependency12 bsc_kpi_analysis_groups.dependency_flag%TYPE := 0;

237: WHERE indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id
238: AND analysis_group_id = p_ana_grp_id;
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:

Line 254: bsc_kpi_analysis_groups

250: FND_MSG_PUB.Initialize;
251:
252: --Only if the default value is modified
253: UPDATE
254: bsc_kpi_analysis_groups
255: SET
256: default_value = p_Anal_Opt_Rec.Bsc_Analysis_Option_Id
257: WHERE
258: indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id AND

Line 284: bsc_kpi_analysis_groups

280: l_Temp_Ana_Option_Id := p_Anal_Opt_Rec.Bsc_Grandparent_Option_Id;--l_GrandParent_Opt_Id;
281: END CASE;
282:
283: UPDATE
284: bsc_kpi_analysis_groups
285: SET
286: default_value = l_Temp_Ana_Option_Id
287: WHERE
288: indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id AND

Line 306: bsc_kpi_analysis_groups

302: l_Temp_Ana_Option_Id := p_Anal_Opt_Rec.Bsc_Parent_Option_Id;
303: END CASE;
304:
305: UPDATE
306: bsc_kpi_analysis_groups
307: SET
308: default_value = l_Temp_Ana_Option_Id
309: WHERE
310: indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id AND

Line 345: l_AO0_Default bsc_kpi_analysis_groups.default_value%TYPE;

341: ,x_msg_data OUT NOCOPY VARCHAR2
342: ) IS
343:
344: l_YTD_Value bsc_kpi_calculations.default_Value%TYPE;
345: l_AO0_Default bsc_kpi_analysis_groups.default_value%TYPE;
346: l_AO1_Default bsc_kpi_analysis_groups.default_value%TYPE;
347: l_AO2_Default bsc_kpi_analysis_groups.default_value%TYPE;
348: l_Count NUMBER := 0;
349: CURSOR c_YTD_Value IS

Line 346: l_AO1_Default bsc_kpi_analysis_groups.default_value%TYPE;

342: ) IS
343:
344: l_YTD_Value bsc_kpi_calculations.default_Value%TYPE;
345: l_AO0_Default bsc_kpi_analysis_groups.default_value%TYPE;
346: l_AO1_Default bsc_kpi_analysis_groups.default_value%TYPE;
347: l_AO2_Default bsc_kpi_analysis_groups.default_value%TYPE;
348: l_Count NUMBER := 0;
349: CURSOR c_YTD_Value IS
350: SELECT

Line 347: l_AO2_Default bsc_kpi_analysis_groups.default_value%TYPE;

343:
344: l_YTD_Value bsc_kpi_calculations.default_Value%TYPE;
345: l_AO0_Default bsc_kpi_analysis_groups.default_value%TYPE;
346: l_AO1_Default bsc_kpi_analysis_groups.default_value%TYPE;
347: l_AO2_Default bsc_kpi_analysis_groups.default_value%TYPE;
348: l_Count NUMBER := 0;
349: CURSOR c_YTD_Value IS
350: SELECT
351: default_value

Line 454: l_Old_Default_Value bsc_kpi_analysis_groups.default_value%TYPE;

450: ,x_msg_data OUT NOCOPY VARCHAR2
451: )IS
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;

Line 463: bsc_kpi_analysis_groups

459: CURSOR c_Old_Default_Value IS
460: SELECT
461: default_value
462: FROM
463: bsc_kpi_analysis_groups
464: WHERE indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id
465: AND analysis_group_id = p_Anal_Opt_Rec.Bsc_Analysis_Group_Id;
466:
467: CURSOR c_Default_Series_Id (p_AO0 NUMBER, p_AO1 NUMBER, p_AO2 NUMBER) IS

Line 671: l_ana_drill bsc_kpi_analysis_groups.change_dim_set%TYPE := 0;

667: FUNCTION Is_Analysis_Drill (
668: p_Indicator IN NUMBER
669: ,p_Analysis_Group_Id IN NUMBER
670: ) RETURN VARCHAR2 IS
671: l_ana_drill bsc_kpi_analysis_groups.change_dim_set%TYPE := 0;
672: CURSOR c_Ana_Drill IS
673: SELECT
674: NVL(change_dim_set,0)
675: FROM

Line 676: bsc_kpi_analysis_groups

672: CURSOR c_Ana_Drill IS
673: SELECT
674: NVL(change_dim_set,0)
675: FROM
676: bsc_kpi_analysis_groups
677: WHERE
678: indicator = p_Indicator AND
679: analysis_group_id = p_Analysis_Group_Id;
680: BEGIN

Line 707: l_Default_Option_Id bsc_kpi_analysis_groups.default_value%TYPE := 0;

703: p_Indicator IN NUMBER
704: ,p_Analysis_Group_Id IN NUMBER
705: ) RETURN NUMBER
706: IS
707: l_Default_Option_Id bsc_kpi_analysis_groups.default_value%TYPE := 0;
708: CURSOR c_Default_Option IS
709: SELECT
710: default_value
711: FROM

Line 712: bsc_kpi_analysis_groups

708: CURSOR c_Default_Option IS
709: SELECT
710: default_value
711: FROM
712: bsc_kpi_analysis_groups
713: WHERE
714: indicator = p_Indicator AND
715: analysis_group_id = p_Analysis_Group_Id ;
716: BEGIN

Line 769: l_Dependency01 bsc_kpi_analysis_groups.dependency_flag%TYPE := 0;

765: ,x_Parent_Group_Id OUT NOCOPY NUMBER
766: ,x_GrandParent_Group_Id OUT NOCOPY NUMBER
767: ) IS
768:
769: l_Dependency01 bsc_kpi_analysis_groups.dependency_flag%TYPE := 0;
770: l_Dependency12 bsc_kpi_analysis_groups.dependency_flag%TYPE := 0;
771:
772: CURSOR c_dependency_flag(p_group_id NUMBER) IS
773: SELECT

Line 770: l_Dependency12 bsc_kpi_analysis_groups.dependency_flag%TYPE := 0;

766: ,x_GrandParent_Group_Id OUT NOCOPY NUMBER
767: ) IS
768:
769: l_Dependency01 bsc_kpi_analysis_groups.dependency_flag%TYPE := 0;
770: l_Dependency12 bsc_kpi_analysis_groups.dependency_flag%TYPE := 0;
771:
772: CURSOR c_dependency_flag(p_group_id NUMBER) IS
773: SELECT
774: ag.dependency_flag

Line 776: bsc_kpi_analysis_groups ag

772: CURSOR c_dependency_flag(p_group_id NUMBER) IS
773: SELECT
774: ag.dependency_flag
775: FROM
776: bsc_kpi_analysis_groups ag
777: WHERe
778: ag.indicator = p_Indicator AND
779: ag.analysis_group_id = p_group_id;
780:

Line 983: l_Parent_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE := 0;

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;
983: l_Parent_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE := 0;
984: l_GrandParent_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE := 0;
985:
986: l_olddim_Dataset_map BSC_KPI_SERIES_PUB.Bsc_Dim_Dataset_Table;
987: l_newdim_Dataset_map BSC_KPI_SERIES_PUB.Bsc_Dim_Dataset_Table;

Line 984: l_GrandParent_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE := 0;

980:
981: l_temp_Parent_Id NUMBER := NULL;
982: l_temp_GrandParent_Id NUMBER := NULL;
983: l_Parent_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE := 0;
984: l_GrandParent_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE := 0;
985:
986: l_olddim_Dataset_map BSC_KPI_SERIES_PUB.Bsc_Dim_Dataset_Table;
987: l_newdim_Dataset_map BSC_KPI_SERIES_PUB.Bsc_Dim_Dataset_Table;
988: isStructureChange BOOLEAN := FALSE;

Line 1400: l_Next_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE;

1396: ) IS
1397: l_Ana_Opt_Count NUMBER := 0;
1398: l_DeleteChildren BOOLEAN := FALSE;
1399: l_Deletegrandchildren BOOLEAN := FALSE;
1400: l_Next_Group_Id bsc_kpi_analysis_groups.analysis_group_id%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:

Line 1401: l_Grandchild_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE;

1397: l_Ana_Opt_Count NUMBER := 0;
1398: l_DeleteChildren BOOLEAN := FALSE;
1399: l_Deletegrandchildren BOOLEAN := FALSE;
1400: l_Next_Group_Id bsc_kpi_analysis_groups.analysis_group_id%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;

Line 1671: bsc_kpi_analysis_groups

1667: CURSOR c_Max_Groups IS
1668: SELECT
1669: MAX(analysis_group_id)
1670: FROM
1671: bsc_kpi_analysis_groups
1672: WHERE
1673: indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id;
1674:
1675: BEGIN

Line 1804: bsc_kpi_analysis_groups

1800:
1801: CURSOR c_max_grp_id IS
1802: SELECT max(analysis_group_id)
1803: FROM
1804: bsc_kpi_analysis_groups
1805: WHERE
1806: indicator = p_Indicator;
1807:
1808: BEGIN

Line 1830: bsc_kpi_analysis_groups

1826: l_Count := l_Count + 1;
1827: END IF;
1828:
1829: UPDATE
1830: bsc_kpi_analysis_groups
1831: SET
1832: num_of_options = l_Count
1833: WHERE
1834: indicator = p_Indicator

Line 1866: bsc_kpi_analysis_groups

1862: CURSOR c_Is_Dependent IS
1863: SELECT
1864: dependency_flag
1865: FROM
1866: bsc_kpi_analysis_groups
1867: WHERE
1868: indicator = p_Indicator AND
1869: analysis_group_id = p_Analysis_Group_Id;
1870:

Line 1871: l_Dependent bsc_kpi_analysis_groups.dependency_flag%TYPE := 0;

1867: WHERE
1868: indicator = p_Indicator AND
1869: analysis_group_id = p_Analysis_Group_Id;
1870:
1871: l_Dependent bsc_kpi_analysis_groups.dependency_flag%TYPE := 0;
1872: BEGIN
1873:
1874: OPEN c_Is_Dependent;
1875: FETCH c_Is_Dependent INTO l_Dependent;

Line 1899: l_Dependency01 bsc_kpi_analysis_groups.dependency_flag%TYPE := -1;

1895: ,x_msg_count OUT NOCOPY NUMBER
1896: ,x_msg_data OUT NOCOPY VARCHAR2
1897: ) IS
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;

Line 1900: l_Dependency12 bsc_kpi_analysis_groups.dependency_flag%TYPE := -1;

1896: ,x_msg_data OUT NOCOPY VARCHAR2
1897: ) IS
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;

Line 1904: l_Parent_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE := 0;

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;
1908:

Line 1905: l_GrandParent_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE := 0;

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;
1908:
1909: l_commit VARCHAR2(2) := FND_API.G_FALSE;

Line 2092: l_new_Default bsc_kpi_analysis_groups.default_value%TYPE := 0;

2088: ,x_msg_data OUT NOCOPY VARCHAR2
2089: ) IS
2090:
2091: l_Reset_Child_Defaults BOOLEAN := FALSE;
2092: l_new_Default bsc_kpi_analysis_groups.default_value%TYPE := 0;
2093: l_Dependency01 bsc_kpi_analysis_groups.dependency_flag%TYPE := -1;
2094: l_Dependency12 bsc_kpi_analysis_groups.dependency_flag%TYPE := -1;
2095:
2096: BEGIN

Line 2093: l_Dependency01 bsc_kpi_analysis_groups.dependency_flag%TYPE := -1;

2089: ) IS
2090:
2091: l_Reset_Child_Defaults BOOLEAN := FALSE;
2092: l_new_Default bsc_kpi_analysis_groups.default_value%TYPE := 0;
2093: l_Dependency01 bsc_kpi_analysis_groups.dependency_flag%TYPE := -1;
2094: l_Dependency12 bsc_kpi_analysis_groups.dependency_flag%TYPE := -1;
2095:
2096: BEGIN
2097: SAVEPOINT Reset_Group_Defaults_PVT;

Line 2094: l_Dependency12 bsc_kpi_analysis_groups.dependency_flag%TYPE := -1;

2090:
2091: l_Reset_Child_Defaults BOOLEAN := FALSE;
2092: l_new_Default bsc_kpi_analysis_groups.default_value%TYPE := 0;
2093: l_Dependency01 bsc_kpi_analysis_groups.dependency_flag%TYPE := -1;
2094: l_Dependency12 bsc_kpi_analysis_groups.dependency_flag%TYPE := -1;
2095:
2096: BEGIN
2097: SAVEPOINT Reset_Group_Defaults_PVT;
2098: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2117: bsc_kpi_analysis_groups

2113: l_new_Default := 0;
2114: END IF;
2115: END IF;
2116: UPDATE
2117: bsc_kpi_analysis_groups
2118: SET
2119: default_value = l_new_Default
2120: WHERE
2121: indicator = p_Indicator

Line 2128: bsc_kpi_analysis_groups

2124: CASE p_Analysis_Group_Id
2125: WHEN 0 THEN
2126: IF l_Dependency01 = 1 THEN
2127: UPDATE
2128: bsc_kpi_analysis_groups
2129: SET
2130: default_value = 0
2131: WHERE
2132: indicator = p_Indicator

Line 2137: bsc_kpi_analysis_groups

2133: AND analysis_Group_Id = 1;
2134: END IF;
2135: IF l_Dependency12 = 1 THEN
2136: UPDATE
2137: bsc_kpi_analysis_groups
2138: SET
2139: default_value = 0
2140: WHERE
2141: indicator = p_Indicator

Line 2147: bsc_kpi_analysis_groups

2143: END IF;
2144: WHEN 1 THEN
2145: IF l_Dependency12 = 1 THEN
2146: UPDATE
2147: bsc_kpi_analysis_groups
2148: SET
2149: default_value = 0
2150: WHERE
2151: indicator = p_Indicator

Line 2195: l_Dependency01 bsc_kpi_analysis_groups.dependency_flag%TYPE := -1;

2191: l_Max_Groups NUMBER := 0;
2192: l_Cur_Group NUMBER := 0;
2193: l_Num_Of_Options NUMBER := 0;
2194:
2195: l_Dependency01 bsc_kpi_analysis_groups.dependency_flag%TYPE := -1;
2196: l_Dependency12 bsc_kpi_analysis_groups.dependency_flag%TYPE := -1;
2197:
2198: l_Is_Dependent BOOLEAN := FALSE;
2199: l_Change_Dim_Set bsc_kpi_analysis_groups.change_dim_set%TYPE := 0;

Line 2196: l_Dependency12 bsc_kpi_analysis_groups.dependency_flag%TYPE := -1;

2192: l_Cur_Group NUMBER := 0;
2193: l_Num_Of_Options NUMBER := 0;
2194:
2195: l_Dependency01 bsc_kpi_analysis_groups.dependency_flag%TYPE := -1;
2196: l_Dependency12 bsc_kpi_analysis_groups.dependency_flag%TYPE := -1;
2197:
2198: l_Is_Dependent BOOLEAN := FALSE;
2199: l_Change_Dim_Set bsc_kpi_analysis_groups.change_dim_set%TYPE := 0;
2200:

Line 2199: l_Change_Dim_Set bsc_kpi_analysis_groups.change_dim_set%TYPE := 0;

2195: l_Dependency01 bsc_kpi_analysis_groups.dependency_flag%TYPE := -1;
2196: l_Dependency12 bsc_kpi_analysis_groups.dependency_flag%TYPE := -1;
2197:
2198: l_Is_Dependent BOOLEAN := FALSE;
2199: l_Change_Dim_Set bsc_kpi_analysis_groups.change_dim_set%TYPE := 0;
2200:
2201: CURSOR c_Max_Groups IS
2202: SELECT
2203: MAX(analysis_group_id)

Line 2205: bsc_kpi_analysis_groups

2201: CURSOR c_Max_Groups IS
2202: SELECT
2203: MAX(analysis_group_id)
2204: FROM
2205: bsc_kpi_analysis_groups
2206: WHERE
2207: indicator = p_Indicator;
2208:
2209: CURSOR c_Num_Options(p_Group_Id NUMBER) IS

Line 2244: bsc_kpi_analysis_groups

2240: change_dim_set
2241: INTO
2242: l_Change_Dim_Set
2243: FROM
2244: bsc_kpi_analysis_groups
2245: WHERE
2246: indicator = p_Indicator AND
2247: analysis_group_id = l_Cur_Group;
2248:

Line 2250: bsc_kpi_analysis_groups

2246: indicator = p_Indicator AND
2247: analysis_group_id = l_Cur_Group;
2248:
2249: DELETE FROM
2250: bsc_kpi_analysis_groups
2251: WHERE
2252: indicator = p_Indicator AND
2253: analysis_group_id = l_Cur_Group;
2254:

Line 2257: bsc_kpi_analysis_groups

2253: analysis_group_id = l_Cur_Group;
2254:
2255: IF l_Change_Dim_Set = 1 THEN
2256: UPDATE
2257: bsc_kpi_analysis_groups
2258: SET
2259: change_dim_set = 1
2260: WHERE
2261: indicator = p_Indicator AND

Line 2322: l_new_Default bsc_kpi_analysis_groups.default_value%TYPE := 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;
2324: l_olddim_set_ids FND_TABLE_OF_NUMBER;
2325: l_newdim_set_ids FND_TABLE_OF_NUMBER;
2326: l_Removed_Dim_Set_Ids FND_TABLE_OF_NUMBER;

Line 2700: INSERT INTO bsc_kpi_analysis_groups (

2696: SAVEPOINT Create_Analysis_Group_PVT;
2697: x_return_status := FND_API.G_RET_STS_SUCCESS;
2698: FND_MSG_PUB.Initialize;
2699:
2700: INSERT INTO bsc_kpi_analysis_groups (
2701: indicator,
2702: analysis_group_id,
2703: num_of_options,
2704: dependency_flag,

Line 3000: l_Dependency_01 bsc_kpi_analysis_groups.dependency_flag%TYPE := -1;

2996: l_Analysis_Opt0 bsc_kpi_analysis_measures_b.Analysis_Option0%TYPE := 0;
2997: l_Analysis_Opt1 bsc_kpi_analysis_measures_b.Analysis_Option1%TYPE := 0;
2998: l_Analysis_Opt2 bsc_kpi_analysis_measures_b.Analysis_Option2%TYPE := 0;
2999:
3000: l_Dependency_01 bsc_kpi_analysis_groups.dependency_flag%TYPE := -1;
3001: l_Dependency_12 bsc_kpi_analysis_groups.dependency_flag%TYPE := -1;
3002: l_commit VARCHAR2(2) := FND_API.G_FALSE;
3003:
3004: CURSOR c_dep_flag(p_Ana_Grp_Id VARCHAR2) IS

Line 3001: l_Dependency_12 bsc_kpi_analysis_groups.dependency_flag%TYPE := -1;

2997: l_Analysis_Opt1 bsc_kpi_analysis_measures_b.Analysis_Option1%TYPE := 0;
2998: l_Analysis_Opt2 bsc_kpi_analysis_measures_b.Analysis_Option2%TYPE := 0;
2999:
3000: l_Dependency_01 bsc_kpi_analysis_groups.dependency_flag%TYPE := -1;
3001: l_Dependency_12 bsc_kpi_analysis_groups.dependency_flag%TYPE := -1;
3002: l_commit VARCHAR2(2) := FND_API.G_FALSE;
3003:
3004: CURSOR c_dep_flag(p_Ana_Grp_Id VARCHAR2) IS
3005: SELECT dependency_flag

Line 3007: bsc_kpi_analysis_groups

3003:
3004: CURSOR c_dep_flag(p_Ana_Grp_Id VARCHAR2) IS
3005: SELECT dependency_flag
3006: FROM
3007: bsc_kpi_analysis_groups
3008: WHERE
3009: indicator = p_Indicator AND
3010: analysis_group_id = p_Ana_Grp_Id;
3011:

Line 3141: l_Parent_Analysis_Id bsc_kpi_analysis_groups.parent_analysis_id%TYPE := 0;

3137: ,x_msg_data OUT NOCOPY VARCHAR2
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;

Line 3151: l_Parent_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE := 0;

3147: l_Measure_Source bsc_sys_datasets_vl.source%TYPE := 'BSC';
3148:
3149: l_temp_Parent_Id NUMBER := NULL;
3150: l_temp_GrandParent_Id NUMBER := NULL;
3151: l_Parent_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE := 0;
3152: l_GrandParent_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE := 0;
3153: l_olddim_Dataset_map BSC_KPI_SERIES_PUB.Bsc_Dim_Dataset_Table;
3154: CURSOR c_shared_objs IS
3155: SELECT

Line 3152: l_GrandParent_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE := 0;

3148:
3149: l_temp_Parent_Id NUMBER := NULL;
3150: l_temp_GrandParent_Id NUMBER := NULL;
3151: l_Parent_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE := 0;
3152: l_GrandParent_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE := 0;
3153: l_olddim_Dataset_map BSC_KPI_SERIES_PUB.Bsc_Dim_Dataset_Table;
3154: CURSOR c_shared_objs IS
3155: SELECT
3156: indicator

Line 3213: FROM bsc_kpi_analysis_groups

3209:
3210: /* Check Lock on Indicator */
3211: IF p_Analysis_Group_Id IS NOT NULL THEN
3212: SELECT COUNT(1) INTO l_Count
3213: FROM bsc_kpi_analysis_groups
3214: WHERE indicator = p_Indicator AND
3215: analysis_group_id = p_Analysis_Group_Id;
3216:
3217: IF l_Count = 0 THEN

Line 3440: l_Dependency01 bsc_kpi_analysis_groups.dependency_flag%TYPE := -1;

3436:
3437: l_Grp_Count NUMBER := 0;
3438: l_Next_Grp_Count NUMBER := 0;
3439: l_Total_Groups NUMBER := 0;
3440: l_Dependency01 bsc_kpi_analysis_groups.dependency_flag%TYPE := -1;
3441: l_Dependency12 bsc_kpi_analysis_groups.dependency_flag%TYPE := -1;
3442: l_IsDependent BOOLEAN := FALSE;
3443:
3444: TYPE c_ref_cursor IS REF CURSOR;

Line 3441: l_Dependency12 bsc_kpi_analysis_groups.dependency_flag%TYPE := -1;

3437: l_Grp_Count NUMBER := 0;
3438: l_Next_Grp_Count NUMBER := 0;
3439: l_Total_Groups NUMBER := 0;
3440: l_Dependency01 bsc_kpi_analysis_groups.dependency_flag%TYPE := -1;
3441: l_Dependency12 bsc_kpi_analysis_groups.dependency_flag%TYPE := -1;
3442: l_IsDependent BOOLEAN := FALSE;
3443:
3444: TYPE c_ref_cursor IS REF CURSOR;
3445: c_Weighted_Kpi c_ref_cursor;

Line 3455: l_Parent_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE := 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
3459: SELECT

Line 3456: l_GrandParent_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE := 0;

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
3459: SELECT
3460: num_of_options

Line 3462: bsc_kpi_analysis_groups

3458: CURSOR c_Grp_Cnt(p_Ana_Grp NUMBER) IS
3459: SELECT
3460: num_of_options
3461: FROM
3462: bsc_kpi_analysis_groups
3463: WHERE
3464: indicator = p_Indicator AND
3465: Analysis_Group_Id = p_Ana_Grp;
3466:

Line 3471: bsc_kpi_analysis_groups

3467: CURSOR c_Num_Groups IS
3468: SELECT
3469: MAX(analysis_group_id)
3470: FROM
3471: bsc_kpi_analysis_groups
3472: WHERE
3473: indicator = p_Indicator;
3474: BEGIN
3475:

Line 3605: l_Dependency01 bsc_kpi_analysis_groups.dependency_flag%TYPE;

3601: ,p_Parent_Option_Id IN NUMBER
3602: ,p_Grandparent_Option_Id IN NUMBER
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;

Line 3606: l_Dependency12 bsc_kpi_analysis_groups.dependency_flag%TYPE;

3602: ,p_Grandparent_Option_Id IN NUMBER
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;

Line 3610: l_Parent_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE := 0;

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
3614: SELECT

Line 3611: l_GrandParent_Group_Id bsc_kpi_analysis_groups.analysis_group_id%TYPE := 0;

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
3614: SELECT
3615: MAX(option_id) AS MAX

Line 3784: l_AO0_Default bsc_kpi_analysis_groups.default_value%TYPE;

3780: ************************************************************************************/
3781: FUNCTION Check_Series_Default_Plan (
3782: p_Indicator IN NUMBER
3783: ) RETURN VARCHAR2 IS
3784: l_AO0_Default bsc_kpi_analysis_groups.default_value%TYPE;
3785: l_AO1_Default bsc_kpi_analysis_groups.default_value%TYPE;
3786: l_AO2_Default bsc_kpi_analysis_groups.default_value%TYPE;
3787: CURSOR c_Series_Default_Plan(p_AO0 NUMBER, p_AO1 NUMBER, p_AO2 NUMBER) IS
3788: SELECT

Line 3785: l_AO1_Default bsc_kpi_analysis_groups.default_value%TYPE;

3781: FUNCTION Check_Series_Default_Plan (
3782: p_Indicator IN NUMBER
3783: ) RETURN VARCHAR2 IS
3784: l_AO0_Default bsc_kpi_analysis_groups.default_value%TYPE;
3785: l_AO1_Default bsc_kpi_analysis_groups.default_value%TYPE;
3786: l_AO2_Default bsc_kpi_analysis_groups.default_value%TYPE;
3787: CURSOR c_Series_Default_Plan(p_AO0 NUMBER, p_AO1 NUMBER, p_AO2 NUMBER) IS
3788: SELECT
3789: COUNT(1)

Line 3786: l_AO2_Default bsc_kpi_analysis_groups.default_value%TYPE;

3782: p_Indicator IN NUMBER
3783: ) RETURN VARCHAR2 IS
3784: l_AO0_Default bsc_kpi_analysis_groups.default_value%TYPE;
3785: l_AO1_Default bsc_kpi_analysis_groups.default_value%TYPE;
3786: l_AO2_Default bsc_kpi_analysis_groups.default_value%TYPE;
3787: CURSOR c_Series_Default_Plan(p_AO0 NUMBER, p_AO1 NUMBER, p_AO2 NUMBER) IS
3788: SELECT
3789: COUNT(1)
3790: FROM

Line 3917: l_Dependency01 bsc_kpi_analysis_groups.dependency_flag%TYPE := 0;

3913: ) RETURN VARCHAR2
3914: IS
3915: l_Name bsc_kpi_analysis_options_vl.Name%TYPE;
3916: l_Count NUMBER := 0;
3917: l_Dependency01 bsc_kpi_analysis_groups.dependency_flag%TYPE := 0;
3918: l_Dependency12 bsc_kpi_analysis_groups.dependency_flag%TYPE := 0;
3919: l_option_id NUMBER := 0;
3920: l_parent_id NUMBER := 0;
3921: l_grandparent_id NUMBER := 0;

Line 3918: l_Dependency12 bsc_kpi_analysis_groups.dependency_flag%TYPE := 0;

3914: IS
3915: l_Name bsc_kpi_analysis_options_vl.Name%TYPE;
3916: l_Count NUMBER := 0;
3917: l_Dependency01 bsc_kpi_analysis_groups.dependency_flag%TYPE := 0;
3918: l_Dependency12 bsc_kpi_analysis_groups.dependency_flag%TYPE := 0;
3919: l_option_id NUMBER := 0;
3920: l_parent_id NUMBER := 0;
3921: l_grandparent_id NUMBER := 0;
3922:

Line 3927: bsc_kpi_analysis_groups ag

3923: CURSOR c_dependency_flag(p_group_id NUMBER) IS
3924: SELECT
3925: ag.dependency_flag
3926: FROM
3927: bsc_kpi_analysis_groups ag
3928: WHERe
3929: ag.indicator = p_Indicator AND
3930: ag.analysis_group_id = p_group_id;
3931:

Line 3997: l_Dependency01 bsc_kpi_analysis_groups.dependency_flag%TYPE := 0;

3993: p_Group_Id NUMBER
3994: ) RETURN VARCHAR2
3995: IS
3996: l_Count NUMBER := 0;
3997: l_Dependency01 bsc_kpi_analysis_groups.dependency_flag%TYPE := 0;
3998: l_Dependency12 bsc_kpi_analysis_groups.dependency_flag%TYPE := 0;
3999: l_option_id NUMBER := 0;
4000: l_parent_id NUMBER := 0;
4001: l_grandparent_id NUMBER := 0;

Line 3998: l_Dependency12 bsc_kpi_analysis_groups.dependency_flag%TYPE := 0;

3994: ) RETURN VARCHAR2
3995: IS
3996: l_Count NUMBER := 0;
3997: l_Dependency01 bsc_kpi_analysis_groups.dependency_flag%TYPE := 0;
3998: l_Dependency12 bsc_kpi_analysis_groups.dependency_flag%TYPE := 0;
3999: l_option_id NUMBER := 0;
4000: l_parent_id NUMBER := 0;
4001: l_grandparent_id NUMBER := 0;
4002:

Line 4007: bsc_kpi_analysis_groups ag

4003: CURSOR c_dependency_flag(p_group_id NUMBER) IS
4004: SELECT
4005: ag.dependency_flag
4006: FROM
4007: bsc_kpi_analysis_groups ag
4008: WHERe
4009: ag.indicator = p_Indicator AND
4010: ag.analysis_group_id = p_group_id;
4011: