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_PUB dependencies on BSC_SYS_DIM_LEVELS_B

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

40: | Modified exception handling section of as |
41: | ret_dimgrpid_fr_shname part of forward port of |
42: | ALL enhancement to BSC 5.1 |
43: | 22-JUL-2003 arhegde bug#3050270 Added dim_properties_default_values and calls|
44: | 29-OCT-2003 mahrao bug#3209967 Added a column to bsc_sys_dim_levels_by_group|
45: | 14-NOV-2003 mahrao x_dim_level_where_clause is removed from prcoedure |
46: | Retrieve_Sys_Dim_Lvls_Grp_Wrap as PMF 4.0.7 shouldn't |
47: | pick up any dependency on 5.1.1 |
48: | 07-JAN-2004 rpenneru bug#3459443 Modified for getting where clause from |

Line 588: l_filter_column bsc_sys_dim_levels_by_group.filter_column%TYPE;

584: ) is
585: l_dim_level_index NUMBER;
586: l_total_flag NUMBER;
587: l_comparison_flag NUMBER;
588: l_filter_column bsc_sys_dim_levels_by_group.filter_column%TYPE;
589: l_filter_value NUMBER;
590: l_default_value bsc_sys_dim_levels_by_group.default_value%TYPE;
591: l_default_type NUMBER;
592: l_parent_in_total NUMBER;

Line 590: l_default_value bsc_sys_dim_levels_by_group.default_value%TYPE;

586: l_total_flag NUMBER;
587: l_comparison_flag NUMBER;
588: l_filter_column bsc_sys_dim_levels_by_group.filter_column%TYPE;
589: l_filter_value NUMBER;
590: l_default_value bsc_sys_dim_levels_by_group.default_value%TYPE;
591: l_default_type NUMBER;
592: l_parent_in_total NUMBER;
593: l_no_items NUMBER;
594: l_total_disp_name bsc_sys_dim_levels_vl.total_disp_name%TYPE;

Line 869: * Returns the properties set in bsc_sys_dim_levels_by_group such as

865:
866: --===================================================================
867: /*
868: * This is called from PMF - DimLevelUtil.java
869: * Returns the properties set in bsc_sys_dim_levels_by_group such as
870: * 'All' property. If no data is present in the tables, then it returns
871: * default values set at the record level
872: */
873:

Line 1105: -- Dimension level short name in bsc_sys_dim_levels_b should be same as dimension

1101: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_ALL_ID');
1102: FND_MSG_PUB.ADD;
1103: RAISE FND_API.G_EXC_ERROR;
1104: END IF;
1105: -- Dimension level short name in bsc_sys_dim_levels_b should be same as dimension
1106: -- level short name in bis_levels.
1107: SELECT dim_level_id
1108: INTO l_dim_level_id
1109: FROM bsc_sys_dim_levels_b

Line 1109: FROM bsc_sys_dim_levels_b

1105: -- Dimension level short name in bsc_sys_dim_levels_b should be same as dimension
1106: -- level short name in bis_levels.
1107: SELECT dim_level_id
1108: INTO l_dim_level_id
1109: FROM bsc_sys_dim_levels_b
1110: WHERE short_name = p_dim_level_shortname;
1111:
1112: -- Passing dim_group_id is mandatory for calling the below procedure. As,
1113: -- dimension short name is not populated as of now in bsc_sys_dim_groups_tl

Line 1114: -- dim_group_id will be retrieved from the bsc_sys_dim_levels_by_group table.

1110: WHERE short_name = p_dim_level_shortname;
1111:
1112: -- Passing dim_group_id is mandatory for calling the below procedure. As,
1113: -- dimension short name is not populated as of now in bsc_sys_dim_groups_tl
1114: -- dim_group_id will be retrieved from the bsc_sys_dim_levels_by_group table.
1115: -- This shouldn't create any problem as dim_level_id is unique in
1116: -- bsc_sys_dim_levels_by_group table for levels imported from PMF to BSC.
1117:
1118: SELECT dim_group_id

Line 1116: -- bsc_sys_dim_levels_by_group table for levels imported from PMF to BSC.

1112: -- Passing dim_group_id is mandatory for calling the below procedure. As,
1113: -- dimension short name is not populated as of now in bsc_sys_dim_groups_tl
1114: -- dim_group_id will be retrieved from the bsc_sys_dim_levels_by_group table.
1115: -- This shouldn't create any problem as dim_level_id is unique in
1116: -- bsc_sys_dim_levels_by_group table for levels imported from PMF to BSC.
1117:
1118: SELECT dim_group_id
1119: INTO l_dim_group_id
1120: FROM bsc_sys_dim_groups_vl

Line 1473: FROM bsc_sys_dim_levels_b

1469: l_Bsc_Dim_Group_Rec := p_Dim_Grp_Rec;
1470:
1471: SELECT dim_level_id
1472: INTO l_Bsc_Dim_Group_Rec.Bsc_Level_Id
1473: FROM bsc_sys_dim_levels_b
1474: WHERE short_name = p_Bsc_Pmf_Dim_Rec.Dimension_Level_Short_Name;
1475:
1476: SELECT count(a.dim_level_id)
1477: INTO l_rel_count

Line 1479: bsc_sys_dim_levels_b a

1475:
1476: SELECT count(a.dim_level_id)
1477: INTO l_rel_count
1478: FROM
1479: bsc_sys_dim_levels_b a
1480: , bsc_sys_dim_groups_vl b
1481: , bsc_sys_dim_levels_by_group c
1482: WHERE
1483: a.short_name = p_Bsc_Pmf_Dim_Rec.Dimension_Level_Short_Name

Line 1481: , bsc_sys_dim_levels_by_group c

1477: INTO l_rel_count
1478: FROM
1479: bsc_sys_dim_levels_b a
1480: , bsc_sys_dim_groups_vl b
1481: , bsc_sys_dim_levels_by_group c
1482: WHERE
1483: a.short_name = p_Bsc_Pmf_Dim_Rec.Dimension_Level_Short_Name
1484: and b.short_name = l_Bsc_Dim_Group_Rec.Bsc_Dim_Level_Group_Short_Name
1485: and a.dim_level_id = c.dim_level_id