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_PVT dependencies on BSC_KPI_ANALYSIS_GROUPS

Line 37: | to update BSC_KPI_ANALYSIS_GROUPS |

33: | and modified the procedures Delete_Analysis_Measures |
34: | Delete_Analysis_Options |
35: | 23-DEC-2003 ashankar Bug#3327016 |
36: | Modified the procedure Set_Default_Value |
37: | to update BSC_KPI_ANALYSIS_GROUPS |
38: | 14-JUN-2004 adrao Enh#3540302, added SHORT_NAME column to the Analysis |
39: | Options table. Tracked in Bug#3691035 |
40: | 02-jul-2004 rpenneru Modified for Enhancement#3532517 |
41: | 14-jul-2004 rpenneru Modified for bug#3746564 |

Line 265: FROM BSC_KPI_ANALYSIS_GROUPS

261: BEGIN
262: SAVEPOINT BSCSeefaulValPVT;
263: SELECT Dependency_Flag, Default_Value
264: INTO l_Dependency_Flag, l_Default_Value
265: FROM BSC_KPI_ANALYSIS_GROUPS
266: WHERE Indicator = p_Kpi_Id
267: AND Analysis_Group_Id = p_group_Id;
268:
269: IF (l_Dependency_Flag = 0) THEN -- for indenpendent

Line 293: UPDATE BSC_KPI_ANALYSIS_GROUPS

289: WHERE Indicator = p_Kpi_Id
290: AND Analysis_Group_Id = p_group_Id
291: AND Option_Id = l_next_option;
292:
293: UPDATE BSC_KPI_ANALYSIS_GROUPS
294: SET Default_Value = l_next_option
295: WHERE Indicator = p_Kpi_Id
296: AND Analysis_Group_Id = p_group_Id;
297: l_Default_Modified := TRUE;

Line 325: UPDATE BSC_KPI_ANALYSIS_GROUPS

321: WHERE Indicator = p_Kpi_Id
322: AND Analysis_Group_Id = p_group_Id
323: AND Option_Id = l_next_option;
324:
325: UPDATE BSC_KPI_ANALYSIS_GROUPS
326: SET Default_Value = l_next_option
327: WHERE Indicator = p_Kpi_Id
328: AND Analysis_Group_Id = p_group_Id;
329: l_Default_Modified := TRUE;

Line 356: UPDATE BSC_KPI_ANALYSIS_GROUPS

352: AND Analysis_Group_Id = p_group_Id
353: AND Option_Id = l_next_option
354: AND Parent_Option_Id = p_Parent_Option_Id;
355:
356: UPDATE BSC_KPI_ANALYSIS_GROUPS
357: SET Default_Value = l_next_option
358: WHERE Indicator = p_Kpi_Id
359: AND Analysis_Group_Id = p_group_Id;
360: l_Default_Modified := TRUE;

Line 388: UPDATE BSC_KPI_ANALYSIS_GROUPS

384: AND Option_Id = l_next_option
385: AND Parent_Option_Id = p_Parent_Option_Id
386: AND Grandparent_Option_Id = p_Grand_Parent_Option_Id;
387:
388: UPDATE BSC_KPI_ANALYSIS_GROUPS
389: SET Default_Value = l_next_option
390: WHERE Indicator = p_Kpi_Id
391: AND Analysis_Group_Id = p_group_Id;
392: l_Default_Modified := TRUE;

Line 416: UPDATE BSC_KPI_ANALYSIS_GROUPS

412: l_default_value := 0;
413: END IF;
414: END IF;
415:
416: UPDATE BSC_KPI_ANALYSIS_GROUPS
417: SET DEFAULT_VALUE = l_default_value
418: WHERE INDiCATOR = p_Kpi_Id
419: AND ANALYSIS_GROUP_ID = p_group_Id;
420: END IF;

Line 484: FROM BSC_KPI_ANALYSIS_GROUPS

480: ORDER BY GrandParent_Option_Id;
481:
482: CURSOR c_Dependency_Flag IS
483: SELECT Dependency_Flag
484: FROM BSC_KPI_ANALYSIS_GROUPS
485: WHERE Indicator = p_Kpi_Id
486: AND Analysis_Group_Id = DECODE(p_Group_Id, 0, 1, p_Group_Id);
487: BEGIN
488: --DBMS_OUTPUT.PUT_LINE('entered inside Swap_Option_Id '||p_Group_Id);

Line 874: -- Update table bsc_kpi_analysis_groups with the current number of options.

870: and T.parent_option_id = p_Anal_Opt_Rec.Bsc_Parent_Option_Id
871: and T.grandparent_option_id = p_Anal_Opt_Rec.Bsc_Grandparent_Option_Id
872: and T.LANGUAGE = L.LANGUAGE_CODE);
873:
874: -- Update table bsc_kpi_analysis_groups with the current number of options.
875: update BSC_KPI_ANALYSIS_GROUPS
876: set num_of_options = p_Anal_Opt_Rec.Bsc_Analysis_Option_Id + 1
877: where indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id;
878:

Line 875: update BSC_KPI_ANALYSIS_GROUPS

871: and T.grandparent_option_id = p_Anal_Opt_Rec.Bsc_Grandparent_Option_Id
872: and T.LANGUAGE = L.LANGUAGE_CODE);
873:
874: -- Update table bsc_kpi_analysis_groups with the current number of options.
875: update BSC_KPI_ANALYSIS_GROUPS
876: set num_of_options = p_Anal_Opt_Rec.Bsc_Analysis_Option_Id + 1
877: where indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id;
878:
879: if (p_commit = FND_API.G_TRUE) then

Line 1474: FROM BSC_KPI_ANALYSIS_GROUPS

1470:
1471: /*IF(l_Anal_Opt_Rec.Bsc_Analysis_Group_Id =0) THEN
1472: SELECT DEFAULT_VALUE
1473: INTO l_default_value
1474: FROM BSC_KPI_ANALYSIS_GROUPS
1475: WHERE INDICATOR = l_Anal_Opt_Rec.Bsc_Kpi_Id
1476: AND ANALYSIS_GROUP_ID = 0;
1477:
1478: IF (l_default_value = l_Anal_Opt_Rec.Bsc_Analysis_Option_Id) THEN

Line 1484: UPDATE BSC_KPI_ANALYSIS_GROUPS

1480: ELSIF(l_default_value>l_Anal_Opt_Rec.Bsc_Analysis_Option_Id) THEN
1481: l_default_value := l_default_value - 1 ;
1482: END IF;
1483:
1484: UPDATE BSC_KPI_ANALYSIS_GROUPS
1485: SET DEFAULT_VALUE = l_default_value
1486: WHERE INDiCATOR = l_Anal_Opt_Rec.Bsc_Kpi_Id
1487: AND ANALYSIS_GROUP_ID = 0;
1488: END IF;*/

Line 2237: FROM BSC_KPI_ANALYSIS_GROUPS

2233:
2234:
2235: CURSOR c_Grand_Parent_depend IS
2236: SELECT Dependency_Flag
2237: FROM BSC_KPI_ANALYSIS_GROUPS
2238: WHERE Indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id
2239: AND Analysis_Group_Id = 2;
2240:
2241: CURSOR c_Parent_depend IS

Line 2243: FROM BSC_KPI_ANALYSIS_GROUPS

2239: AND Analysis_Group_Id = 2;
2240:
2241: CURSOR c_Parent_depend IS
2242: SELECT Dependency_Flag
2243: FROM BSC_KPI_ANALYSIS_GROUPS
2244: WHERE Indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id
2245: AND Analysis_Group_Id = 1;
2246:
2247: l_Parent_Analysis NUMBER := 0;

Line 2451: FROM BSC_KPI_ANALYSIS_GROUPS

2447: FOR cd IN c_Parent_Option LOOP
2448: l_Delete_Flag := TRUE;
2449: IF (l_Parent_Dependent = -1) THEN
2450: SELECT Dependency_Flag INTO l_Parent_Dependent
2451: FROM BSC_KPI_ANALYSIS_GROUPS
2452: WHERE Indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id
2453: AND Analysis_Group_Id = 1;
2454:
2455: SELECT COUNT(*)

Line 2729: l_dependent BSC_KPI_ANALYSIS_GROUPS.dependency_flag%TYPE;

2725: l_group_count NUMBER;
2726: l_option_id BSC_KPI_ANALYSIS_OPTIONS_B.Option_Id%TYPE;
2727: l_parent_option_id BSC_KPI_ANALYSIS_OPTIONS_B.Parent_Option_Id%TYPE;
2728: l_grand_parent_option_id BSC_KPI_ANALYSIS_OPTIONS_B.Grandparent_Option_Id%TYPE;
2729: l_dependent BSC_KPI_ANALYSIS_GROUPS.dependency_flag%TYPE;
2730: l_no_child NUMBER;
2731: l_Anal_grp_Id BSC_KPI_ANALYSIS_OPTIONS_B.Analysis_Group_Id%TYPE;
2732:
2733:

Line 3138: DELETE FROM BSC_KPI_ANALYSIS_GROUPS

3134: l_new_group_count := l_Anal_Grp_Opt_Tbl.COUNT;
3135:
3136: WHILE (l_old_group_count <> l_new_group_count) LOOP
3137: EXIT WHEN (l_old_group_count < 0);
3138: DELETE FROM BSC_KPI_ANALYSIS_GROUPS
3139: WHERE Indicator = p_Kpi_Id
3140: AND Analysis_Group_Id = l_old_group_count - 1;
3141:
3142: l_Anal_Opt_Tbl.DELETE(l_old_group_count - 1);

Line 3158: UPDATE BSC_KPI_ANALYSIS_GROUPS

3154: FROM BSC_KPI_ANALYSIS_OPTIONS_B
3155: WHERE Indicator = p_Kpi_Id
3156: AND Analysis_Group_Id = l_group_count;
3157:
3158: UPDATE BSC_KPI_ANALYSIS_GROUPS
3159: SET Num_Of_Options = l_Num_Opt_Id
3160: WHERE Indicator = p_Kpi_Id
3161: AND Analysis_Group_Id = l_group_count;
3162: END IF;

Line 4227: l_default_value BSC_KPI_ANALYSIS_GROUPS.default_value%TYPE;

4223: , x_msg_count OUT NOCOPY NUMBER
4224: , x_msg_data OUT NOCOPY VARCHAR2
4225: )IS
4226: l_anal_grp_id BSC_KPIS_B.ind_group_id%TYPE;
4227: l_default_value BSC_KPI_ANALYSIS_GROUPS.default_value%TYPE;
4228: l_Anal_Opt_Comb_Tbl BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type;
4229: BEGIN
4230: SAVEPOINT SetDftAnalOption;
4231: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4240: UPDATE bsc_kpi_analysis_groups

4236: l_anal_grp_id := p_Anal_Grp_Id;
4237: l_default_value := l_Anal_Opt_Comb_Tbl(l_anal_grp_id);
4238:
4239:
4240: UPDATE bsc_kpi_analysis_groups
4241: SET default_value = BSC_ANALYSIS_OPTION_PUB.c_ANAL_SERIES_DISABLED
4242: WHERE indicator = p_obj_id;
4243:
4244: IF(l_anal_grp_id>=0)THEN

Line 4246: UPDATE bsc_kpi_analysis_groups

4242: WHERE indicator = p_obj_id;
4243:
4244: IF(l_anal_grp_id>=0)THEN
4245: WHILE (l_anal_grp_id>=0) LOOP
4246: UPDATE bsc_kpi_analysis_groups
4247: SET default_value = l_Anal_Opt_Comb_Tbl(l_anal_grp_id)
4248: WHERE indicator = p_obj_id
4249: AND analysis_group_id = l_anal_grp_id;
4250: