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

Line 131: l_Dim_Level_Rec.Bsc_Level_Id := BSC_DIMENSION_LEVELS_PVT.Get_Next_Value( 'BSC_SYS_DIM_LEVELS_B'

127:
128:
129: --Get the next id for this level.
130: IF ( l_Dim_Level_Rec.Bsc_Level_Id IS NULL) THEN
131: l_Dim_Level_Rec.Bsc_Level_Id := BSC_DIMENSION_LEVELS_PVT.Get_Next_Value( 'BSC_SYS_DIM_LEVELS_B'
132: ,'DIM_LEVEL_ID');
133: END IF;
134:
135: IF(p_create_tables) THEN

Line 136: BSC_DIMENSION_LEVELS_PVT.Create_Dim_Level( p_commit

132: ,'DIM_LEVEL_ID');
133: END IF;
134:
135: IF(p_create_tables) THEN
136: BSC_DIMENSION_LEVELS_PVT.Create_Dim_Level( p_commit
137: ,l_Dim_Level_Rec
138: ,x_return_status
139: ,x_msg_count
140: ,x_msg_data);

Line 399: BSC_DIMENSION_LEVELS_PVT.Delete_Dim_Level

395: ) is
396:
397: begin
398: x_return_status := FND_API.G_RET_STS_SUCCESS;
399: BSC_DIMENSION_LEVELS_PVT.Delete_Dim_Level
400: (
401: p_commit => p_commit
402: , p_Dim_Level_Rec => p_Dim_Level_Rec
403: , x_return_status => x_return_status

Line 480: BSC_DIMENSION_LEVELS_PVT.Create_Bsc_Dim_Levels_Md( p_commit

476:
477: l_Dim_Level_Rec.Bsc_Last_Update_Date := NVL(p_Dim_Level_Rec.Bsc_Last_Update_Date, SYSDATE);
478:
479: -- Call the private package.procedure.
480: BSC_DIMENSION_LEVELS_PVT.Create_Bsc_Dim_Levels_Md( p_commit
481: ,l_Dim_Level_Rec
482: ,x_return_status
483: ,x_msg_count
484: ,x_msg_data);

Line 572: BSC_DIMENSION_LEVELS_PVT.Retrieve_Bsc_Dim_Levels_Md( p_commit

568: ) is
569:
570: begin
571: x_return_status := FND_API.G_RET_STS_SUCCESS;
572: BSC_DIMENSION_LEVELS_PVT.Retrieve_Bsc_Dim_Levels_Md( p_commit
573: ,p_Dim_Level_Rec
574: ,x_Dim_Level_Rec
575: ,x_return_status
576: ,x_msg_count

Line 648: BSC_DIMENSION_LEVELS_PVT.Update_Bsc_Dim_Levels_Md( p_commit

644: l_Dim_Level_Rec := p_Dim_Level_Rec;
645: l_Dim_Level_Rec.Bsc_Last_Update_Date := NVL(p_Dim_Level_Rec.Bsc_Last_Update_Date, SYSDATE);
646: -- If language values are null assign 'US'.
647:
648: BSC_DIMENSION_LEVELS_PVT.Update_Bsc_Dim_Levels_Md( p_commit
649: ,l_Dim_Level_Rec
650: ,x_return_status
651: ,x_msg_count
652: ,x_msg_data);

Line 717: BSC_DIMENSION_LEVELS_PVT.Delete_Bsc_Dim_Levels_Md( p_commit

713:
714: begin
715: x_return_status := FND_API.G_RET_STS_SUCCESS;
716: -- Call the private package.procedure.
717: BSC_DIMENSION_LEVELS_PVT.Delete_Bsc_Dim_Levels_Md( p_commit
718: ,p_Dim_Level_Rec
719: ,x_return_status
720: ,x_msg_count
721: ,x_msg_data);

Line 789: BSC_DIMENSION_LEVELS_PVT.Create_Bsc_Sys_Dim_Lvl_Cols( p_commit

785:
786: begin
787: x_return_status := FND_API.G_RET_STS_SUCCESS;
788: -- Call the private package.procedure.
789: BSC_DIMENSION_LEVELS_PVT.Create_Bsc_Sys_Dim_Lvl_Cols( p_commit
790: ,p_Dim_Level_Rec
791: ,x_return_status
792: ,x_msg_count
793: ,x_msg_data);

Line 848: BSC_DIMENSION_LEVELS_PVT.Retrieve_Bsc_Sys_Dim_Lvl_Cols( p_commit

844: ) is
845:
846: begin
847: x_return_status := FND_API.G_RET_STS_SUCCESS;
848: BSC_DIMENSION_LEVELS_PVT.Retrieve_Bsc_Sys_Dim_Lvl_Cols( p_commit
849: ,p_Dim_Level_Rec
850: ,x_Dim_Level_Rec
851: ,x_return_status
852: ,x_msg_count

Line 907: BSC_DIMENSION_LEVELS_PVT.Update_Bsc_Sys_Dim_Lvl_Cols( p_commit

903: ) is
904:
905: begin
906: x_return_status := FND_API.G_RET_STS_SUCCESS;
907: BSC_DIMENSION_LEVELS_PVT.Update_Bsc_Sys_Dim_Lvl_Cols( p_commit
908: ,p_Dim_Level_Rec
909: ,x_return_status
910: ,x_msg_count
911: ,x_msg_data);

Line 968: BSC_DIMENSION_LEVELS_PVT.Delete_Bsc_Sys_Dim_Lvl_Cols( p_commit

964: -- Procedure to Delete data on Dimension Level column information.
965: begin
966: x_return_status := FND_API.G_RET_STS_SUCCESS;
967: -- Call the private package.procedure.
968: BSC_DIMENSION_LEVELS_PVT.Delete_Bsc_Sys_Dim_Lvl_Cols( p_commit
969: ,p_Dim_Level_Rec
970: ,x_return_status
971: ,x_msg_count
972: ,x_msg_data);

Line 1044: v_Dim_Level_Rec.Bsc_Level_Id := BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Id(v_Dim_Level_Rec.Bsc_Level_Short_Name);

1040: v_Dim_Level_Rec := p_Dim_Level_Rec;
1041:
1042: -- if the child is a PMF Level Check for Import the Level --
1043: if p_Dim_Level_Rec.Bsc_Source <> 'BSC' then
1044: v_Dim_Level_Rec.Bsc_Level_Id := BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Id(v_Dim_Level_Rec.Bsc_Level_Short_Name);
1045: if v_Dim_Level_Rec.Bsc_Level_Id is null then
1046: v_Bsc_Pmf_Dim_Rec.Dimension_Level_Short_Name := v_Dim_Level_Rec.Bsc_Level_Short_Name;
1047: BSC_PMF_UI_API_PUB.Import_PMF_Dim_Level(p_commit ,v_Bsc_Pmf_Dim_Rec
1048: ,x_return_status ,x_msg_count ,x_msg_data );

Line 1049: v_Dim_Level_Rec.Bsc_Level_Id := BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Id(v_Dim_Level_Rec.Bsc_Level_Short_Name);

1045: if v_Dim_Level_Rec.Bsc_Level_Id is null then
1046: v_Bsc_Pmf_Dim_Rec.Dimension_Level_Short_Name := v_Dim_Level_Rec.Bsc_Level_Short_Name;
1047: BSC_PMF_UI_API_PUB.Import_PMF_Dim_Level(p_commit ,v_Bsc_Pmf_Dim_Rec
1048: ,x_return_status ,x_msg_count ,x_msg_data );
1049: v_Dim_Level_Rec.Bsc_Level_Id := BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Id(v_Dim_Level_Rec.Bsc_Level_Short_Name);
1050: end if;
1051: end if;
1052:
1053: -- if the parent is a PMF Level Check for Import it --

Line 1055: v_Dim_Level_Rec.Bsc_Parent_Level_Id := BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Id(v_Dim_Level_Rec.Bsc_Parent_Level_Short_Name);

1051: end if;
1052:
1053: -- if the parent is a PMF Level Check for Import it --
1054: if p_Dim_Level_Rec.Bsc_Parent_Level_Source <> 'BSC' then
1055: v_Dim_Level_Rec.Bsc_Parent_Level_Id := BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Id(v_Dim_Level_Rec.Bsc_Parent_Level_Short_Name);
1056: if v_Dim_Level_Rec.Bsc_Parent_Level_Id is null then
1057: v_Bsc_Pmf_Dim_Rec.Dimension_Level_Short_Name := v_Dim_Level_Rec.Bsc_Parent_Level_Short_Name;
1058: BSC_PMF_UI_API_PUB.Import_PMF_Dim_Level(p_commit ,v_Bsc_Pmf_Dim_Rec
1059: ,x_return_status ,x_msg_count ,x_msg_data );

Line 1060: v_Dim_Level_Rec.Bsc_Parent_Level_Id := BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Id(v_Dim_Level_Rec.Bsc_Parent_Level_Short_Name);

1056: if v_Dim_Level_Rec.Bsc_Parent_Level_Id is null then
1057: v_Bsc_Pmf_Dim_Rec.Dimension_Level_Short_Name := v_Dim_Level_Rec.Bsc_Parent_Level_Short_Name;
1058: BSC_PMF_UI_API_PUB.Import_PMF_Dim_Level(p_commit ,v_Bsc_Pmf_Dim_Rec
1059: ,x_return_status ,x_msg_count ,x_msg_data );
1060: v_Dim_Level_Rec.Bsc_Parent_Level_Id := BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Id(v_Dim_Level_Rec.Bsc_Parent_Level_Short_Name);
1061: end if;
1062: end if;
1063:
1064: -- Insert the relationship Metadata --

Line 1067: BSC_DIMENSION_LEVELS_PVT.Create_Dim_Level_Relation(p_commit, v_Dim_Level_Rec

1063:
1064: -- Insert the relationship Metadata --
1065: if Is_Valid_Relationship(p_commit, v_Dim_Level_Rec
1066: ,x_return_status, x_msg_count, x_msg_data) then
1067: BSC_DIMENSION_LEVELS_PVT.Create_Dim_Level_Relation(p_commit, v_Dim_Level_Rec
1068: ,x_return_status, x_msg_count, x_msg_data);
1069: -- Recreate Dimension Level View --
1070: if p_Dim_Level_Rec.Bsc_Source <> 'BSC' then
1071: BSC_DIMENSION_LEVELS_PVT.Create_BSC_Dim_Level_View (p_commit, v_Dim_Level_Rec

Line 1071: BSC_DIMENSION_LEVELS_PVT.Create_BSC_Dim_Level_View (p_commit, v_Dim_Level_Rec

1067: BSC_DIMENSION_LEVELS_PVT.Create_Dim_Level_Relation(p_commit, v_Dim_Level_Rec
1068: ,x_return_status, x_msg_count, x_msg_data);
1069: -- Recreate Dimension Level View --
1070: if p_Dim_Level_Rec.Bsc_Source <> 'BSC' then
1071: BSC_DIMENSION_LEVELS_PVT.Create_BSC_Dim_Level_View (p_commit, v_Dim_Level_Rec
1072: ,x_return_status, x_msg_count, x_msg_data);
1073: end if;
1074:
1075: end if;

Line 1140: v_Dim_Level_Rec.Bsc_Level_Id := BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Id(v_Dim_Level_Rec.Bsc_Level_Short_Name);

1136: -- Check Bsc_Level_Id if the child is a PMF --
1137: IF (v_Dim_Level_Rec.Bsc_Level_Id IS NULL) THEN
1138: if v_Dim_Level_Rec.Bsc_Source <> 'BSC' then
1139: if v_Dim_Level_Rec.Bsc_Level_Id is null then
1140: v_Dim_Level_Rec.Bsc_Level_Id := BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Id(v_Dim_Level_Rec.Bsc_Level_Short_Name);
1141: end if;
1142: end if;
1143: END IF;
1144:

Line 1149: v_Dim_Level_Rec.Bsc_Parent_Level_Id := BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Id(v_Dim_Level_Rec.Bsc_Parent_Level_Short_Name);

1145: -- Check Bsc_Level_Id if the parent is a PMF --
1146: IF (v_Dim_Level_Rec.Bsc_Parent_Level_Id IS NULL) THEN
1147: if v_Dim_Level_Rec.Bsc_Parent_Level_Source <> 'BSC' then
1148: if v_Dim_Level_Rec.Bsc_Parent_Level_Id is null then
1149: v_Dim_Level_Rec.Bsc_Parent_Level_Id := BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Id(v_Dim_Level_Rec.Bsc_Parent_Level_Short_Name);
1150: end if;
1151: end if;
1152: END IF;
1153:

Line 1155: BSC_DIMENSION_LEVELS_PVT.Delete_Dim_Level_Relation(p_commit, v_Dim_Level_Rec

1151: end if;
1152: END IF;
1153:
1154: -- Delete the relationship Metadata --
1155: BSC_DIMENSION_LEVELS_PVT.Delete_Dim_Level_Relation(p_commit, v_Dim_Level_Rec
1156: ,x_return_status, x_msg_count, x_msg_data);
1157:
1158: -- Recreate Level View for BSC --
1159: if v_Dim_Level_Rec.Bsc_Source <> 'BSC' then

Line 1160: BSC_DIMENSION_LEVELS_PVT.Create_BSC_Dim_Level_View (p_commit, v_Dim_Level_Rec,

1156: ,x_return_status, x_msg_count, x_msg_data);
1157:
1158: -- Recreate Level View for BSC --
1159: if v_Dim_Level_Rec.Bsc_Source <> 'BSC' then
1160: BSC_DIMENSION_LEVELS_PVT.Create_BSC_Dim_Level_View (p_commit, v_Dim_Level_Rec,
1161: x_return_status, x_msg_count, x_msg_data);
1162: end if;
1163:
1164: --DBMS_OUTPUT.PUT_LINE('End Delete_Dim_Level_Relation ' );

Line 1222: v_Temp := BSC_DIMENSION_LEVELS_PVT.Evaluate_Circular_Relationship

1218:
1219: BEGIN
1220: x_return_status := FND_API.G_RET_STS_SUCCESS;
1221: FND_MSG_PUB.Initialize;
1222: v_Temp := BSC_DIMENSION_LEVELS_PVT.Evaluate_Circular_Relationship
1223: ( p_Dim_Level_Rec.Bsc_Level_Id
1224: ,p_Dim_Level_Rec.Bsc_Parent_Level_Id
1225: ,p_Dim_Level_Rec.Bsc_Relation_Type
1226: ,true

Line 1235: FND_MESSAGE.SET_TOKEN('LEVEL_CHILD', BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Name(p_Dim_Level_Rec.Bsc_Level_Id) );

1231: );
1232: if v_Temp = false then
1233: if x_return_status = 'SAME' then
1234: FND_MESSAGE.SET_NAME('BSC','BSC_SAME_DIM_LEVEL_REL');
1235: FND_MESSAGE.SET_TOKEN('LEVEL_CHILD', BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Name(p_Dim_Level_Rec.Bsc_Level_Id) );
1236: FND_MSG_PUB.ADD;
1237: RAISE FND_API.G_EXC_ERROR;
1238: else
1239: FND_MESSAGE.SET_NAME('BSC','BSC_CIRCULAR_DIM_LEVEL_REL');

Line 1240: FND_MESSAGE.SET_TOKEN('LEVEL_CHILD', BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Name(p_Dim_Level_Rec.Bsc_Level_Id) );

1236: FND_MSG_PUB.ADD;
1237: RAISE FND_API.G_EXC_ERROR;
1238: else
1239: FND_MESSAGE.SET_NAME('BSC','BSC_CIRCULAR_DIM_LEVEL_REL');
1240: FND_MESSAGE.SET_TOKEN('LEVEL_CHILD', BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Name(p_Dim_Level_Rec.Bsc_Level_Id) );
1241: FND_MESSAGE.SET_TOKEN('LEVEL_PARENT', BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Name(p_Dim_Level_Rec.Bsc_Parent_Level_Id));
1242: FND_MSG_PUB.ADD;
1243: --FND_MESSAGE.SET_NAME('BSC','BSC_EXISTING_DEPENDENCIES');
1244: --FND_MESSAGE.SET_TOKEN('DEPENDENCY', SUBSTR(v_msg, 1, 220)) ;

Line 1241: FND_MESSAGE.SET_TOKEN('LEVEL_PARENT', BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Name(p_Dim_Level_Rec.Bsc_Parent_Level_Id));

1237: RAISE FND_API.G_EXC_ERROR;
1238: else
1239: FND_MESSAGE.SET_NAME('BSC','BSC_CIRCULAR_DIM_LEVEL_REL');
1240: FND_MESSAGE.SET_TOKEN('LEVEL_CHILD', BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Name(p_Dim_Level_Rec.Bsc_Level_Id) );
1241: FND_MESSAGE.SET_TOKEN('LEVEL_PARENT', BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Name(p_Dim_Level_Rec.Bsc_Parent_Level_Id));
1242: FND_MSG_PUB.ADD;
1243: --FND_MESSAGE.SET_NAME('BSC','BSC_EXISTING_DEPENDENCIES');
1244: --FND_MESSAGE.SET_TOKEN('DEPENDENCY', SUBSTR(v_msg, 1, 220)) ;
1245: --FND_MSG_PUB.ADD;

Line 1604: BSC_DIMENSION_LEVELS_PVT.Retrieve_Relationship

1600: , x_msg_data OUT NOCOPY VARCHAR2
1601: ) IS
1602: BEGIN
1603: x_return_status := FND_API.G_RET_STS_SUCCESS;
1604: BSC_DIMENSION_LEVELS_PVT.Retrieve_Relationship
1605: (
1606: p_Dim_Level_Rec => p_Dim_Level_Rec
1607: , x_Dim_Level_Rec => x_Dim_Level_Rec
1608: , x_return_status => x_return_status

Line 1663: BSC_DIMENSION_LEVELS_PVT.Delete_Dim_Level

1659: , x_msg_data OUT NOCOPY VARCHAR2
1660: ) IS
1661: BEGIN
1662: x_return_status := FND_API.G_RET_STS_SUCCESS;
1663: BSC_DIMENSION_LEVELS_PVT.Delete_Dim_Level
1664: (
1665: p_commit => FND_API.G_FALSE
1666: ,p_Dim_Level_Rec => p_Dim_Level_Rec
1667: ,x_return_status => x_return_status

Line 1721: BSC_DIMENSION_LEVELS_PVT.Translate_Dimension_Level

1717: )
1718: IS
1719: BEGIN
1720: x_return_status := FND_API.G_RET_STS_SUCCESS;
1721: BSC_DIMENSION_LEVELS_PVT.Translate_Dimension_Level
1722: ( p_commit => p_Commit
1723: ,p_Bsc_Pmf_Dim_Rec => p_Bsc_Pmf_Dim_Rec
1724: ,p_Bsc_Dim_Level_Rec => p_Bsc_Dim_Level_Rec
1725: ,x_return_status => x_return_status

Line 1873: BSC_DIMENSION_LEVELS_PVT.Trans_DimObj_By_Given_Lang

1869: IS
1870:
1871: BEGIN
1872:
1873: BSC_DIMENSION_LEVELS_PVT.Trans_DimObj_By_Given_Lang
1874: (
1875: p_commit => FND_API.G_FALSE
1876: , p_dim_level_rec => p_dim_level_rec
1877: , x_return_status => x_return_status