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_DIM_OBJ_PUB dependencies on BSC_SYS_DIM_LEVELS_TL

Line 833: 4. BSC_SYS_DIM_LEVELS_TL

829: will be inserted into the following tables.
830: 1 BIS_LEVELS.
831: 2. BIS_LEVELS_TL
832: 3. BSC_SYS_DIM_LEVELS_B
833: 4. BSC_SYS_DIM_LEVELS_TL
834:
835: Key
836: p_dim_obj_short_name
837:

Line 1344: l_bsc_dim_obj_rec.Bsc_Dim_Comp_Disp_Name := p_comparison_item_text;--BSC_SYS_DIM_LEVELS_TL.comp_disp_name

1340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1341: END IF;
1342:
1343: --CALL BSC API
1344: l_bsc_dim_obj_rec.Bsc_Dim_Comp_Disp_Name := p_comparison_item_text;--BSC_SYS_DIM_LEVELS_TL.comp_disp_name
1345: l_bsc_dim_obj_rec.Bsc_Dim_Level_Long_Name := p_display_name;--BSC_SYS_DIM_LEVELS_TL.name
1346: IF (p_description IS NULL) THEN
1347: l_bsc_dim_obj_rec.Bsc_Dim_Level_Help := p_display_name;
1348: ELSE

Line 1345: l_bsc_dim_obj_rec.Bsc_Dim_Level_Long_Name := p_display_name;--BSC_SYS_DIM_LEVELS_TL.name

1341: END IF;
1342:
1343: --CALL BSC API
1344: l_bsc_dim_obj_rec.Bsc_Dim_Comp_Disp_Name := p_comparison_item_text;--BSC_SYS_DIM_LEVELS_TL.comp_disp_name
1345: l_bsc_dim_obj_rec.Bsc_Dim_Level_Long_Name := p_display_name;--BSC_SYS_DIM_LEVELS_TL.name
1346: IF (p_description IS NULL) THEN
1347: l_bsc_dim_obj_rec.Bsc_Dim_Level_Help := p_display_name;
1348: ELSE
1349: l_bsc_dim_obj_rec.Bsc_Dim_Level_Help := p_description;--BSC_SYS_DIM_LEVELS_TL.help

Line 1349: l_bsc_dim_obj_rec.Bsc_Dim_Level_Help := p_description;--BSC_SYS_DIM_LEVELS_TL.help

1345: l_bsc_dim_obj_rec.Bsc_Dim_Level_Long_Name := p_display_name;--BSC_SYS_DIM_LEVELS_TL.name
1346: IF (p_description IS NULL) THEN
1347: l_bsc_dim_obj_rec.Bsc_Dim_Level_Help := p_display_name;
1348: ELSE
1349: l_bsc_dim_obj_rec.Bsc_Dim_Level_Help := p_description;--BSC_SYS_DIM_LEVELS_TL.help
1350: END IF;
1351: l_bsc_dim_obj_rec.Bsc_Dim_Tot_Disp_Name := p_all_item_text;--BSC_SYS_DIM_LEVELS_TL.total_disp_name
1352: l_bsc_dim_obj_rec.Bsc_Language := NULL;--BSC_SYS_DIM_LEVELS_TL.language
1353: l_bsc_dim_obj_rec.Bsc_Level_Column_Name := NULL;

Line 1351: l_bsc_dim_obj_rec.Bsc_Dim_Tot_Disp_Name := p_all_item_text;--BSC_SYS_DIM_LEVELS_TL.total_disp_name

1347: l_bsc_dim_obj_rec.Bsc_Dim_Level_Help := p_display_name;
1348: ELSE
1349: l_bsc_dim_obj_rec.Bsc_Dim_Level_Help := p_description;--BSC_SYS_DIM_LEVELS_TL.help
1350: END IF;
1351: l_bsc_dim_obj_rec.Bsc_Dim_Tot_Disp_Name := p_all_item_text;--BSC_SYS_DIM_LEVELS_TL.total_disp_name
1352: l_bsc_dim_obj_rec.Bsc_Language := NULL;--BSC_SYS_DIM_LEVELS_TL.language
1353: l_bsc_dim_obj_rec.Bsc_Level_Column_Name := NULL;
1354: l_bsc_dim_obj_rec.Bsc_Level_Column_Type := NULL;
1355: l_bsc_dim_obj_rec.Bsc_Level_Comp_Order_By := p_comparison_order;--BSC_SYS_DIM_LEVELS_B.comp_order_by

Line 1352: l_bsc_dim_obj_rec.Bsc_Language := NULL;--BSC_SYS_DIM_LEVELS_TL.language

1348: ELSE
1349: l_bsc_dim_obj_rec.Bsc_Dim_Level_Help := p_description;--BSC_SYS_DIM_LEVELS_TL.help
1350: END IF;
1351: l_bsc_dim_obj_rec.Bsc_Dim_Tot_Disp_Name := p_all_item_text;--BSC_SYS_DIM_LEVELS_TL.total_disp_name
1352: l_bsc_dim_obj_rec.Bsc_Language := NULL;--BSC_SYS_DIM_LEVELS_TL.language
1353: l_bsc_dim_obj_rec.Bsc_Level_Column_Name := NULL;
1354: l_bsc_dim_obj_rec.Bsc_Level_Column_Type := NULL;
1355: l_bsc_dim_obj_rec.Bsc_Level_Comp_Order_By := p_comparison_order;--BSC_SYS_DIM_LEVELS_B.comp_order_by
1356: l_bsc_dim_obj_rec.Bsc_Level_Custom_Group := 0;--BSC_SYS_DIM_LEVELS_B.custom_group

Line 2003: 4. BSC_SYS_DIM_LEVELS_TL

1999: be reflected into the following metadata: -
2000: 1 BIS_LEVELS.
2001: 2. BIS_LEVELS_TL
2002: 3. BSC_SYS_DIM_LEVELS_B
2003: 4. BSC_SYS_DIM_LEVELS_TL
2004:
2005: Key:
2006: 'p_dim_obj_short_name'
2007:

Line 3196: 4. BSC_SYS_DIM_LEVELS_TL

3192: deleted from the following metadata: -
3193: 1 BIS_LEVELS.
3194: 2. BIS_LEVELS_TL
3195: 3. BSC_SYS_DIM_LEVELS_B
3196: 4. BSC_SYS_DIM_LEVELS_TL
3197:
3198: Validations:
3199: 1. dimension must not be associated with any group.
3200: */

Line 3447: l_name BSC_SYS_DIM_LEVELS_TL.Name%TYPE;

3443: , x_msg_count OUT NOCOPY NUMBER
3444: , x_msg_data OUT NOCOPY VARCHAR2
3445: ) IS
3446: l_bsc_dim_id BSC_SYS_DIM_LEVELS_B.dim_level_id%TYPE;
3447: l_name BSC_SYS_DIM_LEVELS_TL.Name%TYPE;
3448: l_count NUMBER;
3449: l_edw_flag BSC_SYS_DIM_LEVELS_B.Edw_Flag%TYPE;
3450:
3451: l_dim_Group_id BSC_SYS_DIM_GROUPS_TL.Dim_Group_Id%TYPE;