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_GROUPS_TL

Line 408: l_Bsc_Group_ID BSC_SYS_DIM_GROUPS_TL.Dim_Group_ID%TYPE;

404: , x_msg_count OUT NOCOPY NUMBER
405: , x_msg_data OUT NOCOPY VARCHAR2
406: ) IS
407: l_Bsc_Dim_Obj_ID BSC_SYS_DIM_LEVELS_B.Dim_Level_ID%TYPE;
408: l_Bsc_Group_ID BSC_SYS_DIM_GROUPS_TL.Dim_Group_ID%TYPE;
409: l_Dim_Short_Name BIS_DIMENSIONS.Short_Name%TYPE;
410:
411: CURSOR c_Bis_Levels IS
412: SELECT B.Short_Name

Line 898: l_dim_Grp_name BSC_SYS_DIM_GROUPS_TL.short_name%TYPE;

894: -- Start Granular Locking added by Aditya
895: l_Dim_Tab BSC_BIS_LOCKS_PUB.t_numberTable;
896: l_dim_Grp_names VARCHAR2(32000);
897:
898: l_dim_Grp_name BSC_SYS_DIM_GROUPS_TL.short_name%TYPE;
899: l_index NUMBER := 0;
900: l_first_dim BOOLEAN := TRUE;
901: -- End Granular Locking added by Aditya
902: l_pmf_disp_name VARCHAR2(255); -- DispName

Line 1556: l_dim_name BSC_SYS_DIM_GROUPS_TL.short_name%TYPE;

1552: , x_msg_count OUT NOCOPY NUMBER
1553: , x_msg_data OUT NOCOPY VARCHAR2
1554: ) IS
1555: l_dim_short_names VARCHAR2(32000);
1556: l_dim_name BSC_SYS_DIM_GROUPS_TL.short_name%TYPE;
1557: l_dim_grp_id BSC_SYS_DIM_GROUPS_TL.Dim_Group_Id%TYPE;
1558:
1559: l_count NUMBER;
1560: BEGIN

Line 1557: l_dim_grp_id BSC_SYS_DIM_GROUPS_TL.Dim_Group_Id%TYPE;

1553: , x_msg_data OUT NOCOPY VARCHAR2
1554: ) IS
1555: l_dim_short_names VARCHAR2(32000);
1556: l_dim_name BSC_SYS_DIM_GROUPS_TL.short_name%TYPE;
1557: l_dim_grp_id BSC_SYS_DIM_GROUPS_TL.Dim_Group_Id%TYPE;
1558:
1559: l_count NUMBER;
1560: BEGIN
1561: FND_MSG_PUB.Initialize;

Line 1659: l_dim_name BSC_SYS_DIM_GROUPS_TL.short_name%TYPE;

1655: , x_msg_count OUT NOCOPY NUMBER
1656: , x_msg_data OUT NOCOPY VARCHAR2
1657: ) IS
1658: l_dim_short_names VARCHAR2(32000);
1659: l_dim_name BSC_SYS_DIM_GROUPS_TL.short_name%TYPE;
1660: BEGIN
1661: FND_MSG_PUB.Initialize;
1662: x_return_status := FND_API.G_RET_STS_SUCCESS;
1663: IF (p_dim_obj_short_name IS NULL) THEN

Line 1750: l_assign BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;

1746: , x_msg_count OUT NOCOPY NUMBER
1747: , x_msg_data OUT NOCOPY VARCHAR2
1748: ) IS
1749: l_assigns VARCHAR2(32000);
1750: l_assign BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;
1751: l_assign_dim VARCHAR2(32000);
1752: l_count NUMBER;
1753: BEGIN
1754: -- It is to find values from p_assign_dim_short_names which are not already assigned.

Line 1763: ,BSC_SYS_DIM_GROUPS_TL D

1759: SELECT COUNT(1)
1760: INTO l_count
1761: FROM BSC_SYS_DIM_LEVELS_BY_GROUP A
1762: ,BSC_SYS_DIM_LEVELS_B L
1763: ,BSC_SYS_DIM_GROUPS_TL D
1764: WHERE D.SHORT_NAME = l_assign
1765: AND L.SHORT_NAME = p_dim_obj_short_name
1766: AND L.DIM_LEVEL_ID = A.DIM_LEVEL_ID
1767: AND D.DIM_GROUP_ID = A.DIM_GROUP_ID;

Line 1815: l_unassign BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;

1811: , x_msg_data OUT NOCOPY VARCHAR2
1812: ) IS
1813: l_unassigns VARCHAR2(32000);
1814: l_assigns VARCHAR2(32000);
1815: l_unassign BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;
1816: l_assign BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;
1817:
1818: l_unassign_dims VARCHAR2(32000);
1819: l_temp VARCHAR2(32000);

Line 1816: l_assign BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;

1812: ) IS
1813: l_unassigns VARCHAR2(32000);
1814: l_assigns VARCHAR2(32000);
1815: l_unassign BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;
1816: l_assign BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;
1817:
1818: l_unassign_dims VARCHAR2(32000);
1819: l_temp VARCHAR2(32000);
1820: l_regions VARCHAR2(32000);

Line 2060: l_dim_Grp_name BSC_SYS_DIM_GROUPS_TL.short_name%TYPE;

2056: l_source_table VARCHAR(33);
2057: l_bsc_dim_id BSC_SYS_DIM_LEVELS_B.Dim_Level_Id%TYPE;
2058: l_level_table_name BIS_LEVELS.LEVEL_VALUES_VIEW_NAME%TYPE;
2059: l_dim_obj_name BSC_SYS_DIM_LEVELS_B.Short_Name%TYPE;
2060: l_dim_Grp_name BSC_SYS_DIM_GROUPS_TL.short_name%TYPE;
2061: l_application_id BIS_LEVELS.Application_Id%TYPE;
2062: l_bis_short_name BIS_LEVELS.Short_Name%TYPE;
2063: l_bis_name BIS_LEVELS_TL.Name%TYPE;
2064: l_flag BOOLEAN := FALSE;

Line 3451: l_dim_Group_id BSC_SYS_DIM_GROUPS_TL.Dim_Group_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;
3452: BEGIN
3453: FND_MSG_PUB.Initialize;
3454: x_return_status := FND_API.G_RET_STS_SUCCESS;
3455:

Line 3584: l_name BSC_SYS_DIM_GROUPS_TL.NAME%TYPE;

3580: p_dim_short_name IN VARCHAR2
3581: ) RETURN VARCHAR2
3582: IS
3583: l_dimObjects_names VARCHAR2(32000);
3584: l_name BSC_SYS_DIM_GROUPS_TL.NAME%TYPE;
3585:
3586: CURSOR c_dimension_obj_name IS
3587: SELECT A.name
3588: FROM BSC_SYS_DIM_LEVELS_VL A

Line 5519: l_dim_Grp_name BSC_SYS_DIM_GROUPS_TL.short_name%TYPE;

5515: l_Msg_Data VARCHAR2(32000);
5516: l_msg_count NUMBER;
5517:
5518: l_bsc_dim_obj_rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
5519: l_dim_Grp_name BSC_SYS_DIM_GROUPS_TL.short_name%TYPE;
5520: l_MTab_Tbl BSC_BIS_DIM_OBJ_PUB.KPI_Dim_Set_Table_Type;
5521:
5522: l_count NUMBER;
5523: l_strut_flag BOOLEAN := FALSE;