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

Line 84: , p_Parent_Dim_ID BSC_SYS_DIM_LEVEL_RELS.parent_dim_level_id%TYPE

80: TYPE One_To_N_Org_Table_Type IS TABLE OF One_To_N_Original_Type INDEX BY BINARY_INTEGER;
81: --==============================================================
82: TYPE M_To_N_Original_Type IS Record
83: ( p_Dim_Obj_ID BSC_SYS_DIM_LEVELS_B.dim_level_id%TYPE
84: , p_Parent_Dim_ID BSC_SYS_DIM_LEVEL_RELS.parent_dim_level_id%TYPE
85: , p_Refresh_Flag BOOLEAN
86: );
87: --==============================================================
88: TYPE M_To_N_Org_Table_Type IS TABLE OF M_To_N_Original_Type INDEX BY BINARY_INTEGER;

Line 92: , p_Parent_Dim_Id BSC_SYS_DIM_LEVEL_RELS.parent_dim_level_id%TYPE

88: TYPE M_To_N_Org_Table_Type IS TABLE OF M_To_N_Original_Type INDEX BY BINARY_INTEGER;
89: --==============================================================
90: TYPE Relation_Original_Type IS Record
91: ( p_Dim_Obj_ID BSC_SYS_DIM_LEVELS_B.dim_level_id%TYPE
92: , p_Parent_Dim_Id BSC_SYS_DIM_LEVEL_RELS.parent_dim_level_id%TYPE
93: , p_Relation_Type BSC_SYS_DIM_LEVEL_RELS.relation_type%TYPE
94: , p_Refresh_Flag BOOLEAN
95: , p_Refresh_No NUMBER
96: );

Line 93: , p_Relation_Type BSC_SYS_DIM_LEVEL_RELS.relation_type%TYPE

89: --==============================================================
90: TYPE Relation_Original_Type IS Record
91: ( p_Dim_Obj_ID BSC_SYS_DIM_LEVELS_B.dim_level_id%TYPE
92: , p_Parent_Dim_Id BSC_SYS_DIM_LEVEL_RELS.parent_dim_level_id%TYPE
93: , p_Relation_Type BSC_SYS_DIM_LEVEL_RELS.relation_type%TYPE
94: , p_Refresh_Flag BOOLEAN
95: , p_Refresh_No NUMBER
96: );
97:

Line 214: FROM BSC_SYS_DIM_LEVEL_RELS

210: CURSOR c_keep_original_rels IS
211: SELECT Dim_Level_Id
212: , Parent_Dim_Level_Id
213: , Relation_Type
214: FROM BSC_SYS_DIM_LEVEL_RELS
215: WHERE (Parent_Dim_Level_Id = p_dim_obj_id
216: AND Relation_Type <> 2 )
217: OR Dim_Level_Id = p_dim_obj_id
218: ORDER BY Dim_Level_Id;

Line 304: FROM BSC_SYS_DIM_LEVEL_RELS

300: CURSOR c_relations IS
301: SELECT Dim_Level_Id
302: , Parent_Dim_Level_Id
303: , Relation_Type
304: FROM BSC_SYS_DIM_LEVEL_RELS
305: WHERE Parent_Dim_Level_Id = p_dim_obj_id
306: OR Dim_Level_Id = p_dim_obj_id
307: ORDER BY Dim_Level_Id;
308:

Line 451: , p_par_dim_obj_id IN BSC_SYS_DIM_LEVEL_RELS.parent_dim_level_id%TYPE

447:
448: PROCEDURE Validate_Filtered_Tabs
449: (
450: p_dim_obj_id IN BSC_SYS_DIM_LEVELS_B.dim_level_id%TYPE
451: , p_par_dim_obj_id IN BSC_SYS_DIM_LEVEL_RELS.parent_dim_level_id%TYPE
452: , x_return_status OUT NOCOPY VARCHAR2
453: , x_msg_count OUT NOCOPY NUMBER
454: , x_msg_data OUT NOCOPY VARCHAR2
455: )IS

Line 1239: FROM BSC_SYS_DIM_LEVEL_RELS

1235: , relation_type
1236: , relation_col
1237: , data_source_type
1238: , data_source
1239: FROM BSC_SYS_DIM_LEVEL_RELS
1240: WHERE dim_level_id = p_dim_obj_id;
1241:
1242: CURSOR c_childs_ids IS
1243: SELECT dim_level_id

Line 1248: FROM BSC_SYS_DIM_LEVEL_RELS

1244: , relation_type
1245: , relation_col
1246: , data_source_type
1247: , data_source
1248: FROM BSC_SYS_DIM_LEVEL_RELS
1249: WHERE parent_dim_level_id = p_dim_obj_id
1250: AND relation_type = 1;
1251: BEGIN
1252: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIM_REL_PUB.Assign_Dim_Obj_Rels Procedure');

Line 1425: 1. BSC_SYS_DIM_LEVEL_RELS

1421: *********************************************************************************/
1422: /*
1423: This procedure allow user to assign dimension object relationships whose records
1424: will be inserted into the following table.
1425: 1. BSC_SYS_DIM_LEVEL_RELS
1426: The procedure will remove all the older relationships before assigning new
1427: relationships.
1428:
1429: Validations:

Line 1507: FROM BSC_SYS_DIM_LEVEL_RELS

1503: CURSOR c_par_dim_ids IS
1504: SELECT parent_dim_level_id
1505: , relation_type
1506: , dim_level_id
1507: FROM BSC_SYS_DIM_LEVEL_RELS
1508: WHERE dim_level_id = l_dim_obj_id;
1509:
1510: CURSOR c_child_ids IS
1511: SELECT dim_level_id

Line 1512: FROM BSC_SYS_DIM_LEVEL_RELS

1508: WHERE dim_level_id = l_dim_obj_id;
1509:
1510: CURSOR c_child_ids IS
1511: SELECT dim_level_id
1512: FROM BSC_SYS_DIM_LEVEL_RELS
1513: WHERE parent_dim_level_id = p_dim_obj_id
1514: AND relation_type <> 2;
1515:
1516:

Line 1531: FROM BSC_SYS_DIM_LEVEL_RELS

1527: AND INSTR(l_Refresh_Kpi_Ids, ','||b.dim_level_id||',') > 0;
1528:
1529: CURSOR c_new_relations IS
1530: SELECT DISTINCT Dim_Level_Id
1531: FROM BSC_SYS_DIM_LEVEL_RELS
1532: WHERE (Parent_Dim_Level_Id = p_dim_obj_id
1533: OR Dim_Level_Id = p_dim_obj_id);
1534:
1535: -- added cursor for Bug #3395161

Line 1538: FROM BSC_SYS_DIM_LEVEL_RELS

1534:
1535: -- added cursor for Bug #3395161
1536: CURSOR c_db_child_type IS
1537: SELECT Relation_Type
1538: FROM BSC_SYS_DIM_LEVEL_RELS
1539: WHERE dim_level_id = l_bsc_dim_obj_rec.Bsc_Level_Id
1540: AND parent_dim_level_id = l_bsc_dim_obj_rec.Bsc_Parent_Level_Id;
1541:
1542: l_one_N_flag BOOLEAN;

Line 1783: DELETE FROM BSC_SYS_DIM_LEVEL_RELS

1779: --delete all the existing parents and childs first
1780: --IN future replace the delete SQL to call the existing APIs
1781: --to delete
1782: --DBMS_OUTPUT.PUT_LINE('BEFOR DELETE QUERY');
1783: DELETE FROM BSC_SYS_DIM_LEVEL_RELS
1784: WHERE dim_level_id = p_dim_obj_id
1785: OR parent_dim_level_id = p_dim_obj_id;
1786: l_child_ids := TRIM(p_child_ids);
1787: l_child_rel_type := TRIM(p_child_rel_type);

Line 1855: FROM BSC_SYS_DIM_LEVEL_RELS

1851: RAISE FND_API.G_EXC_ERROR;
1852: --DBMS_OUTPUT.PUT_LINE('ERROR FOR DELETE QUERY');
1853: END IF;
1854: SELECT COUNT(*) INTO l_count
1855: FROM BSC_SYS_DIM_LEVEL_RELS
1856: WHERE dim_level_id = l_bsc_dim_obj_rec.Bsc_Level_Id
1857: AND parent_dim_level_id = l_bsc_dim_obj_rec.bsc_parent_level_id;
1858: IF (l_count = 0) THEN
1859: IF (l_bsc_dim_obj_rec.bsc_relation_type = 1) THEN

Line 1876: FROM BSC_SYS_DIM_LEVEL_RELS

1872: --DBMS_OUTPUT.PUT_LINE('ERROR FOR DELETE QUERY');
1873: END IF;
1874: ELSE
1875: SELECT COUNT(*) INTO l_count
1876: FROM BSC_SYS_DIM_LEVEL_RELS
1877: WHERE dim_level_id = l_bsc_dim_obj_rec.bsc_parent_level_id
1878: AND parent_dim_level_id = l_bsc_dim_obj_rec.Bsc_Level_Id;
1879: IF (l_count <> 0) THEN
1880: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_RELATIONSHIPS');

Line 2037: FROM BSC_SYS_DIM_LEVEL_RELS

2033: --DBMS_OUTPUT.PUT_LINE('PARENT IDS EXE ERROR');
2034: END IF;
2035: ELSE
2036: SELECT COUNT(*) INTO l_count
2037: FROM BSC_SYS_DIM_LEVEL_RELS
2038: WHERE dim_level_id = l_bsc_dim_obj_rec.Bsc_Parent_Level_Id
2039: AND parent_dim_level_id = l_bsc_dim_obj_rec.Bsc_Level_Id;
2040: IF (l_count <> 0) THEN
2041: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_RELATIONSHIPS');

Line 2292: FROM BSC_SYS_DIM_LEVEL_RELS A

2288: IF ((p_is_not_config) AND (l_source = 'BSC')) THEN
2289: FOR i IN 0..(l_One_N_Table.COUNT-1) LOOP
2290: IF (l_One_N_Table(i).p_refresh_flag) THEN
2291: SELECT COUNT(A.Parent_Dim_Level_Id) INTO l_Count
2292: FROM BSC_SYS_DIM_LEVEL_RELS A
2293: WHERE A.Dim_Level_Id = l_One_N_Table(i).p_dim_obj_id
2294: AND A.Relation_Type = 1;
2295: IF (l_Count > MAX_PARENTS_RELS_1_N) THEN
2296: FND_MESSAGE.SET_NAME('BSC','BSC_MAX_DIM_OBJ_RELS');

Line 2557: FROM BSC_SYS_DIM_LEVEL_RELS

2553: , relation_type
2554: , relation_col
2555: , data_source_type
2556: , data_source
2557: FROM BSC_SYS_DIM_LEVEL_RELS
2558: WHERE dim_level_id = p_dim_obj_id;
2559:
2560: CURSOR c_childs_ids IS
2561: SELECT dim_level_id

Line 2566: FROM BSC_SYS_DIM_LEVEL_RELS

2562: , relation_type
2563: , relation_col
2564: , data_source_type
2565: , data_source
2566: FROM BSC_SYS_DIM_LEVEL_RELS
2567: WHERE parent_dim_level_id = p_dim_obj_id
2568: AND relation_type = 1;
2569: BEGIN
2570: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIM_REL_PUB.UnAssign_Dim_Obj_Rels Procedure');

Line 2740: FROM BSC_SYS_DIM_LEVEL_RELS r

2736: l_name BSC_SYS_DIM_LEVELS_TL.NAME%TYPE;
2737:
2738: CURSOR c_parent_dim_level_name IS
2739: SELECT l.name name
2740: FROM BSC_SYS_DIM_LEVEL_RELS r
2741: , BSC_SYS_DIM_LEVELS_VL l
2742: WHERE r.dim_level_id = p_dim_obj_id
2743: AND r.parent_dim_level_id = l.dim_level_id;
2744: BEGIN

Line 2781: FROM BSC_SYS_DIM_LEVEL_RELS r

2777: l_name BSC_SYS_DIM_LEVELS_TL.NAME%TYPE;
2778:
2779: CURSOR c_child_dim_level_name IS
2780: SELECT l.name name
2781: FROM BSC_SYS_DIM_LEVEL_RELS r
2782: , BSC_SYS_DIM_LEVELS_VL l
2783: WHERE r.parent_dim_level_id = p_dim_obj_id
2784: AND r.dim_level_id = l.dim_level_id;
2785: BEGIN

Line 2822: FROM BSC_SYS_DIM_LEVEL_RELS r

2818: l_child_dim_ids VARCHAR2(32000);
2819:
2820: CURSOR c_child_dim_level_ids IS
2821: SELECT r.DIM_LEVEL_ID
2822: FROM BSC_SYS_DIM_LEVEL_RELS r
2823: WHERE r.parent_dim_level_id = p_dim_obj_id;
2824: BEGIN
2825: FOR cd IN c_child_dim_level_ids LOOP
2826: IF (l_child_dim_ids IS NULL) THEN

Line 2960: FROM BSC_SYS_DIM_LEVEL_RELS A

2956: CURSOR c_parents_Ids IS
2957: SELECT A.Parent_Dim_Level_Id
2958: , B.Level_Pk_Col
2959: , B.Level_Table_Name
2960: FROM BSC_SYS_DIM_LEVEL_RELS A
2961: , BSC_SYS_DIM_LEVELS_B B
2962: WHERE A.Dim_Level_Id = p_dim_obj_id
2963: AND B.Dim_Level_Id = A.Parent_Dim_Level_Id
2964: AND A.Relation_Type = 1;

Line 3341: FROM BSC_SYS_DIM_LEVEL_RELS

3337: RAISE FND_API.G_EXC_ERROR;
3338: END IF;
3339: END IF;
3340: SELECT COUNT(*) INTO l_count
3341: FROM BSC_SYS_DIM_LEVEL_RELS
3342: WHERE dim_level_id = p_dim_obj_id
3343: AND parent_dim_level_id = p_parent_id
3344: AND relation_type = 2;
3345: --DBMS_OUTPUT.PUT_LINE('After');

Line 3695: FROM BSC_SYS_DIM_LEVEL_RELS

3691: CURSOR c_Par_Dim_Ids IS
3692: SELECT Parent_Dim_Level_Id
3693: , Relation_Type
3694: , Dim_Level_Id
3695: FROM BSC_SYS_DIM_LEVEL_RELS
3696: WHERE dim_level_id = p_dim_obj_id;
3697:
3698: CURSOR c_Child_Ids IS
3699: SELECT Dim_Level_Id

Line 3700: FROM BSC_SYS_DIM_LEVEL_RELS

3696: WHERE dim_level_id = p_dim_obj_id;
3697:
3698: CURSOR c_Child_Ids IS
3699: SELECT Dim_Level_Id
3700: FROM BSC_SYS_DIM_LEVEL_RELS
3701: WHERE parent_dim_level_id = p_dim_obj_id;
3702:
3703:
3704: CURSOR c_kpi_dim_set IS