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_BIS_KPI_MEAS_PUB dependencies on BSC_SYS_DIM_GROUPS_TL

Line 98: ( p_dim_group_id BSC_SYS_DIM_GROUPS_TL.Dim_Group_Id%TYPE

94: TIME_COMP_TYPE CONSTANT VARCHAR2(100) := 'TIME_COMPARISON_TYPE';
95:
96: /*********************************************************************************/
97: TYPE Dim_Index_Type IS Record
98: ( p_dim_group_id BSC_SYS_DIM_GROUPS_TL.Dim_Group_Id%TYPE
99: , p_dim_short_name BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE
100: , p_dim_old_index BSC_KPI_DIM_GROUPS.Dim_Group_Index%TYPE
101: );
102: TYPE Dim_Index_Table_Type IS TABLE OF Dim_Index_Type INDEX BY BINARY_INTEGER;

Line 99: , p_dim_short_name BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE

95:
96: /*********************************************************************************/
97: TYPE Dim_Index_Type IS Record
98: ( p_dim_group_id BSC_SYS_DIM_GROUPS_TL.Dim_Group_Id%TYPE
99: , p_dim_short_name BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE
100: , p_dim_old_index BSC_KPI_DIM_GROUPS.Dim_Group_Index%TYPE
101: );
102: TYPE Dim_Index_Table_Type IS TABLE OF Dim_Index_Type INDEX BY BINARY_INTEGER;
103:

Line 621: l_assign BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;

617: l_MTab_New_Count NUMBER;
618: l_flag BOOLEAN;
619: l_refresh BOOLEAN := FALSE;
620: l_assigns VARCHAR2(32000);
621: l_assign BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;
622: l_MTab_DimInx_Old BSC_BIS_KPI_MEAS_PUB.Dim_Index_Table_Type;
623: l_MTab_DimInx_New BSC_BIS_KPI_MEAS_PUB.Dim_Index_Table_Type;
624: l_bsc_dimset_rec BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;
625:

Line 1157: l_dimension_id BSC_SYS_DIM_GROUPS_TL.Dim_Group_Id%TYPE;

1153: , x_return_status OUT NOCOPY VARCHAR2
1154: , x_msg_count OUT NOCOPY NUMBER
1155: , x_msg_data OUT NOCOPY VARCHAR2
1156: ) IS
1157: l_dimension_id BSC_SYS_DIM_GROUPS_TL.Dim_Group_Id%TYPE;
1158: l_flag BOOLEAN;
1159: l_temp_var VARCHAR2(32000);
1160:
1161: CURSOR c_dim_set_ind IS

Line 1226: --now delete the dimension from system level, ie from BSC_SYS_DIM_GROUPS_TL table

1222: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1223: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Update_KPI_Analysis_Options Failed: at BSC_BIS_KPI_MEAS_PUB.Unassign_Dims_From_Dim_Set');
1224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1225: END IF;
1226: --now delete the dimension from system level, ie from BSC_SYS_DIM_GROUPS_TL table
1227: BSC_BIS_DIMENSION_PUB.Delete_Dimension
1228: ( p_commit => FND_API.G_FALSE
1229: , p_dim_short_name => l_temp_var
1230: , x_return_status => x_return_status

Line 2580: l_dim_short_name BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;

2576: l_bsc_dimset_rec BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;
2577: l_index NUMBER := 0;
2578: l_count NUMBER := 0;
2579: l_dim_short_names VARCHAR2(32000);
2580: l_dim_short_name BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;
2581: l_temp_var VARCHAR2(32000);
2582: l_kpi_flag_change BOOLEAN := FALSE;
2583: l_level_table_names BSC_EDIT_VLIST;
2584: l_key_item_values FND_TABLE_OF_NUMBER;

Line 2915: l_unassign BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;

2911: , x_msg_data OUT NOCOPY VARCHAR2
2912: )IS
2913: l_unassigns VARCHAR2(32000);
2914: l_assigns VARCHAR2(32000);
2915: l_unassign BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;
2916: l_assign BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;
2917:
2918: l_unassign_dim_objs VARCHAR2(32000);
2919: l_temp VARCHAR2(32000);

Line 2916: l_assign BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;

2912: )IS
2913: l_unassigns VARCHAR2(32000);
2914: l_assigns VARCHAR2(32000);
2915: l_unassign BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;
2916: l_assign BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;
2917:
2918: l_unassign_dim_objs VARCHAR2(32000);
2919: l_temp VARCHAR2(32000);
2920:

Line 3131: l_dim_short_name BSC_SYS_DIM_GROUPS_TL.short_name%TYPE;

3127: )IS
3128: l_bsc_dimset_rec BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;
3129: l_count NUMBER := 0;
3130: l_dim_short_names VARCHAR2(32000);
3131: l_dim_short_name BSC_SYS_DIM_GROUPS_TL.short_name%TYPE;
3132: l_kpi_flag_change BOOLEAN := FALSE;
3133:
3134: CURSOR c_kpi_ids IS
3135: SELECT indicator

Line 3442: l_dim_short_name BSC_SYS_DIM_GROUPS_TL.short_name%TYPE;

3438: l_bsc_dimset_rec BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;
3439: l_index NUMBER := 0;
3440: l_count NUMBER;
3441: l_dim_short_names VARCHAR2(32000);
3442: l_dim_short_name BSC_SYS_DIM_GROUPS_TL.short_name%TYPE;
3443: BEGIN
3444: --dbms_output.PUT_LINE('Entered inside BSC_BIS_KPI_MEAS_PUB.Create_Dim_Grp_Lev_In_Dset procedure');
3445: FND_MSG_PUB.Initialize;
3446: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4081: l_dim_short_name BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE := 'DGRP_';

4077: ) IS
4078: l_Bsc_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
4079: l_bsc_dimset_rec BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;
4080: l_measure_short_name BSC_SYS_MEASURES.Short_Name%TYPE;
4081: l_dim_short_name BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE := 'DGRP_';
4082: l_temp_var VARCHAR2(32000);
4083: l_count NUMBER;
4084: l_alias VARCHAR2(4);
4085:

Line 6937: l_dimension BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;

6933: ) RETURN VARCHAR2 IS
6934: l_Msg_Data VARCHAR2(32000);
6935: l_msg_count NUMBER;
6936:
6937: l_dimension BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;
6938: l_Dimension_Old_Name BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;
6939:
6940: l_old_dimensions VARCHAR2(8000) := NULL;
6941: l_temp_dimensions VARCHAR2(8000);

Line 6938: l_Dimension_Old_Name BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;

6934: l_Msg_Data VARCHAR2(32000);
6935: l_msg_count NUMBER;
6936:
6937: l_dimension BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;
6938: l_Dimension_Old_Name BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;
6939:
6940: l_old_dimensions VARCHAR2(8000) := NULL;
6941: l_temp_dimensions VARCHAR2(8000);
6942: l_temp_var VARCHAR2(8000);

Line 6950: l_unassign BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;

6946: l_flag BOOLEAN;
6947: l_Dim_Short_Names VARCHAR2(32000);
6948: l_unassigns VARCHAR2(32000);
6949: l_assigns VARCHAR2(32000);
6950: l_unassign BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;
6951: l_assign BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;
6952: l_unassign_dim_objs VARCHAR2(32000);
6953:
6954:

Line 6951: l_assign BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;

6947: l_Dim_Short_Names VARCHAR2(32000);
6948: l_unassigns VARCHAR2(32000);
6949: l_assigns VARCHAR2(32000);
6950: l_unassign BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;
6951: l_assign BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;
6952: l_unassign_dim_objs VARCHAR2(32000);
6953:
6954:
6955: CURSOR c_Old_Dimensions IS