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_LEVELS_PVT dependencies on BSC_SYS_DIM_LEVEL_RELS

Line 931: DELETE FROM BSC_SYS_DIM_LEVEL_RELS

927: DELETE FROM BSC_SYS_DIM_LEVELS_BY_GROUP
928: WHERE dim_level_id = p_Dim_Level_Rec.Bsc_Level_Id;
929:
930: --delete dimension from relationships
931: DELETE FROM BSC_SYS_DIM_LEVEL_RELS
932: WHERE dim_level_id = p_Dim_Level_Rec.Bsc_Level_Id
933: OR parent_dim_level_id = p_Dim_Level_Rec.Bsc_Level_Id;
934: if (p_commit = FND_API.G_TRUE) then
935: commit;

Line 1833: INSERT INTO BSC_SYS_DIM_LEVEL_RELS (DIM_LEVEL_ID,

1829: -- DBMS_OUTPUT.PUT_LINE('p_Dim_Level_Rec.Bsc_Parent_Level_Id ' || p_Dim_Level_Rec.Bsc_Parent_Level_Id);
1830: -- DBMS_OUTPUT.PUT_LINE('p_Dim_Level_Rec.Bsc_Relation_Type ' || p_Dim_Level_Rec.Bsc_Relation_Type);
1831: -- DBMS_OUTPUT.PUT_LINE('l_temp_col ' || l_temp_col);
1832:
1833: INSERT INTO BSC_SYS_DIM_LEVEL_RELS (DIM_LEVEL_ID,
1834: RELATION_COL,
1835: PARENT_DIM_LEVEL_ID,
1836: RELATION_TYPE,
1837: DIRECT_RELATION,

Line 1859: INSERT INTO BSC_SYS_DIM_LEVEL_RELS (DIM_LEVEL_ID,

1855: With the Parent and the Child interchanged.
1856:
1857: */
1858:
1859: INSERT INTO BSC_SYS_DIM_LEVEL_RELS (DIM_LEVEL_ID,
1860: RELATION_COL,
1861: PARENT_DIM_LEVEL_ID,
1862: RELATION_TYPE,
1863: DIRECT_RELATION,

Line 1878: INSERT INTO BSC_SYS_DIM_LEVEL_RELS (DIM_LEVEL_ID,

1874:
1875: /* Allow the MxN Relationship only for BSC Type of Dimension Objects */
1876:
1877: IF (p_Dim_Level_Rec.Bsc_Source = 'BSC') THEN
1878: INSERT INTO BSC_SYS_DIM_LEVEL_RELS (DIM_LEVEL_ID,
1879: RELATION_COL,
1880: PARENT_DIM_LEVEL_ID,
1881: RELATION_TYPE,
1882: DIRECT_RELATION,

Line 1970: DELETE FROM BSC_SYS_DIM_LEVEL_RELS

1966: BEGIN
1967: x_return_status := FND_API.G_RET_STS_SUCCESS;
1968: SAVEPOINT DeleteBSCDimLevRelsPVT;
1969:
1970: DELETE FROM BSC_SYS_DIM_LEVEL_RELS
1971: WHERE DIM_LEVEL_ID = p_Dim_Level_Rec.Bsc_Level_Id
1972: AND PARENT_DIM_LEVEL_ID = p_Dim_Level_Rec.Bsc_Parent_Level_Id;
1973:
1974: EXCEPTION

Line 2037: FROM BSC_SYS_DIM_LEVEL_RELS

2033: ) RETURN BOOLEAN IS
2034:
2035: CURSOR c_grand_parents IS
2036: SELECT PARENT_DIM_LEVEL_ID
2037: FROM BSC_SYS_DIM_LEVEL_RELS
2038: WHERE DIM_LEVEL_ID = p_Parent_Dim_Level_Id
2039: AND RELATION_TYPE = 1;
2040:
2041: v_parent NUMBER;

Line 2246: FROM BSC_SYS_DIM_LEVEL_RELS LR, BSC_SYS_DIM_LEVELS_VL DL, BSC_SYS_DIM_LEVELS_VL PL

2242: , LR.RELATION_COL
2243: , LR.DATA_SOURCE_TYPE
2244: , LR.DATA_SOURCE
2245: , LR.RELATION_TYPE
2246: FROM BSC_SYS_DIM_LEVEL_RELS LR, BSC_SYS_DIM_LEVELS_VL DL, BSC_SYS_DIM_LEVELS_VL PL
2247: WHERE DL.dim_level_id = LR.dim_level_id
2248: AND PL.dim_level_id = LR.parent_dim_level_id
2249: AND LR.DIM_LEVEL_ID = p_Dim_Level_Rec.Bsc_Level_Id
2250: AND LR.PARENT_DIM_LEVEL_ID = p_Dim_Level_Rec.Bsc_Parent_Level_Id;

Line 2264: FROM BSC_SYS_DIM_LEVEL_RELS LR, BSC_SYS_DIM_LEVELS_VL DL, BSC_SYS_DIM_LEVELS_VL PL

2260: , LR.RELATION_COL
2261: , LR.DATA_SOURCE_TYPE
2262: , LR.DATA_SOURCE
2263: , LR.RELATION_TYPE
2264: FROM BSC_SYS_DIM_LEVEL_RELS LR, BSC_SYS_DIM_LEVELS_VL DL, BSC_SYS_DIM_LEVELS_VL PL
2265: WHERE DL.dim_level_id = LR.dim_level_id
2266: AND PL.dim_level_id = LR.parent_dim_level_id
2267: AND DL.SHORT_NAME = p_Dim_Level_Rec.Bsc_Level_Short_Name
2268: AND PL.SHORT_NAME = p_Dim_Level_Rec.Bsc_Parent_Level_Short_Name;