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_DIMENSION_GROUPS_PVT dependencies on BSC_SYS_DIM_LEVELS_BY_GROUP

Line 34: | 29-OCT-2003 mahrao bug#3209967 Added a column to bsc_sys_dim_levels_by_group |

30: | 17-JUL-03 mahrao Modified Translate_dimesnsion_group procedure |
31: | as part of forward porting of ALL enhancement to BSC 5.1 |
32: | Modified Retrieve_Dim_Group procedure |
33: | as part of forward porting of ALL enhancement to BSC 5.1 |
34: | 29-OCT-2003 mahrao bug#3209967 Added a column to bsc_sys_dim_levels_by_group |
35: | 17-NOV-2003 PAJOHRI Bug #3232366 |
36: | 17-NOV-2003 ADRAO Bug #3236356 - Removed comments which has Validate_Value() |
37: | 30-Jul-04 rpenneru Modified for enhancemen#3748519 |
38: | 13-Oct-04 rpenneru Modified for bug#3945655 |

Line 508: from BSC_SYS_DIM_LEVELS_BY_GROUP

504: -- If there are no more dimensions assigned to this group then the group
505: -- can be deleted.
506: select count(dim_group_id)
507: into l_count
508: from BSC_SYS_DIM_LEVELS_BY_GROUP
509: where dim_group_id = l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id;
510: if l_count = 0 then
511: delete from BSC_SYS_DIM_GROUPS_TL
512: where dim_group_id = l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id;

Line 676: from BSC_SYS_DIM_LEVELS_BY_GROUP

672:
673: -- Determine if dimension is already part of the dimension group.
674: select count(*)
675: into l_count
676: from BSC_SYS_DIM_LEVELS_BY_GROUP
677: where dim_group_id = l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id
678: and dim_level_id = l_Dim_Grp_Rec.Bsc_Level_Id;
679:
680: -- If the dimension does not belong to the group yet assign it.

Line 688: from BSC_SYS_DIM_LEVELS_BY_GROUP

684: -- This is used for the index for the dimension being added.
685: IF (l_Dim_Grp_Rec.Bsc_Dim_Level_Index IS NULL) THEN
686: select NVL((MAX(dim_level_index) + 1), 0)
687: into l_Dim_Grp_Rec.Bsc_Dim_Level_Index
688: from BSC_SYS_DIM_LEVELS_BY_GROUP
689: where dim_group_id = l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id;
690: END IF;
691:
692: g_db_object := 'BSC_SYS_DIM_LEVELS_BY_GROUP';

Line 692: g_db_object := 'BSC_SYS_DIM_LEVELS_BY_GROUP';

688: from BSC_SYS_DIM_LEVELS_BY_GROUP
689: where dim_group_id = l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id;
690: END IF;
691:
692: g_db_object := 'BSC_SYS_DIM_LEVELS_BY_GROUP';
693:
694: -- Insert pertaining values into table bsc_sys_dim_levels_by_group.
695: --Reminder: Hard coded values, need to get the source.
696: insert into BSC_SYS_DIM_LEVELS_BY_GROUP( dim_group_id

Line 694: -- Insert pertaining values into table bsc_sys_dim_levels_by_group.

690: END IF;
691:
692: g_db_object := 'BSC_SYS_DIM_LEVELS_BY_GROUP';
693:
694: -- Insert pertaining values into table bsc_sys_dim_levels_by_group.
695: --Reminder: Hard coded values, need to get the source.
696: insert into BSC_SYS_DIM_LEVELS_BY_GROUP( dim_group_id
697: ,dim_level_id
698: ,dim_level_index

Line 696: insert into BSC_SYS_DIM_LEVELS_BY_GROUP( dim_group_id

692: g_db_object := 'BSC_SYS_DIM_LEVELS_BY_GROUP';
693:
694: -- Insert pertaining values into table bsc_sys_dim_levels_by_group.
695: --Reminder: Hard coded values, need to get the source.
696: insert into BSC_SYS_DIM_LEVELS_BY_GROUP( dim_group_id
697: ,dim_level_id
698: ,dim_level_index
699: ,total_flag
700: ,comparison_flag

Line 797: -- is not populated, for ALL enhancement, query on BSC_SYS_DIM_LEVELS_BY_GROUP

793: -- Code added for ALL start here
794: -- PMF passes dimension level short name and dimension short name.
795: -- dim_level_id is found from bsc_sys_dim_levels_tl table.
796: -- As SHORT_NAME column that's being added to bsc_sys_dim_groups_tl table
797: -- is not populated, for ALL enhancement, query on BSC_SYS_DIM_LEVELS_BY_GROUP
798: -- is based only on dim_level_id.
799: -- This is required for PMF ALL enhancement (phase1).
800: SELECT DISTINCT dim_level_index
801: ,total_flag

Line 820: FROM BSC_SYS_DIM_LEVELS_BY_GROUP

816: ,x_Dim_Grp_Rec.Bsc_Group_Level_Default_Type
817: ,x_Dim_Grp_Rec.Bsc_Group_Level_Parent_In_Tot
818: ,x_Dim_Grp_Rec.Bsc_Group_Level_No_Items
819: ,x_Dim_Grp_Rec.Bsc_Group_Level_Where_Clause
820: FROM BSC_SYS_DIM_LEVELS_BY_GROUP
821: WHERE dim_group_id = p_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id
822: AND dim_level_id = p_Dim_Grp_Rec.Bsc_Level_Id;
823: if (p_commit = FND_API.G_TRUE) then
824: commit;

Line 990: update BSC_SYS_DIM_LEVELS_BY_GROUP

986: --if p_Dim_Grp_Rec.Bsc_Group_Level_Where_Clause is not null then
987: l_Dim_Grp_Rec.Bsc_Group_Level_Where_Clause := p_Dim_Grp_Rec.Bsc_Group_Level_Where_Clause;
988: --end if;
989:
990: update BSC_SYS_DIM_LEVELS_BY_GROUP
991: set dim_level_index = l_Dim_Grp_Rec.Bsc_Dim_Level_Index
992: ,total_flag = l_Dim_Grp_Rec.Bsc_Group_Level_Total_Flag
993: ,comparison_flag = l_Dim_Grp_Rec.Bsc_Group_Level_Comp_Flag
994: ,filter_column = l_Dim_Grp_Rec.Bsc_Group_Level_Filter_Col

Line 1143: delete from BSC_SYS_DIM_LEVELS_BY_GROUP

1139: FND_MSG_PUB.ADD;
1140: RAISE FND_API.G_EXC_ERROR;
1141: end if;
1142:
1143: delete from BSC_SYS_DIM_LEVELS_BY_GROUP
1144: where dim_group_id = l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id
1145: and dim_level_id = l_Dim_Grp_Rec.Bsc_Level_Id;
1146: else
1147: delete from BSC_SYS_DIM_LEVELS_BY_GROUP

Line 1147: delete from BSC_SYS_DIM_LEVELS_BY_GROUP

1143: delete from BSC_SYS_DIM_LEVELS_BY_GROUP
1144: where dim_group_id = l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id
1145: and dim_level_id = l_Dim_Grp_Rec.Bsc_Level_Id;
1146: else
1147: delete from BSC_SYS_DIM_LEVELS_BY_GROUP
1148: where dim_group_id = l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id;
1149: end if;
1150: if (p_commit = FND_API.G_TRUE) then
1151: commit;