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.BIS_DIMENSION_LEVEL_PUB dependencies on BSC_DIMENSION_LEVELS_PUB

Line 78: ,p_Bsc_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

74:
75: PROCEDURE load_dim_levels(
76: p_commit IN VARCHAR2 := FND_API.G_FALSE
77: ,p_bsc_pmf_dim_rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Rec_Type
78: ,p_Bsc_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
79: ,x_return_status OUT NOCOPY VARCHAR2
80: ,x_msg_count OUT NOCOPY NUMBER
81: ,x_msg_data OUT NOCOPY VARCHAR2
82: );

Line 92: , p_Bsc_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

88: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
89: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
90: , p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
91: , p_Bsc_Pmf_Dim_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Rec_Type
92: , p_Bsc_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
93: , p_Owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
94: , p_force_mode IN BOOLEAN := FALSE
95: , x_return_status OUT NOCOPY VARCHAR2
96: , x_msg_count OUT NOCOPY NUMBER

Line 171: , p_Bsc_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

167: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
168: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
169: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
170: , p_Bsc_Pmf_Dim_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Rec_Type
171: , p_Bsc_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
172: , p_Owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
173: , x_return_status OUT NOCOPY VARCHAR2
174: , x_msg_count OUT NOCOPY NUMBER
175: , x_msg_data OUT NOCOPY VARCHAR2

Line 200: BSC_DIMENSION_LEVELS_PUB.Translate_dimension_level

196: END IF;
197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
198: END IF;
199:
200: BSC_DIMENSION_LEVELS_PUB.Translate_dimension_level
201: ( p_commit => FND_API.G_FALSE
202: , p_Bsc_Pmf_Dim_Rec => p_Bsc_Pmf_Dim_Rec
203: , p_Bsc_Dim_Level_Rec => p_Bsc_Dim_Level_Rec
204: , x_return_status => l_return_status

Line 676: ,p_Bsc_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

672:
673: PROCEDURE load_dim_levels(
674: p_commit IN VARCHAR2 := FND_API.G_FALSE
675: ,p_bsc_pmf_dim_rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Rec_Type
676: ,p_Bsc_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
677: ,x_return_status OUT NOCOPY VARCHAR2
678: ,x_msg_count OUT NOCOPY NUMBER
679: ,x_msg_data OUT NOCOPY VARCHAR2
680: )

Line 683: l_Bsc_Dim_Rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;

679: ,x_msg_data OUT NOCOPY VARCHAR2
680: )
681: IS
682: l_Bsc_Pmf_Dim_Rec BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Rec_Type;
683: l_Bsc_Dim_Rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
684:
685: l_alternate_level_view VARCHAR2(80);
686: l_edw_sql VARCHAR2(1000);
687: l_dim_lvl_sql VARCHAR2(2000);

Line 753: BSC_DIMENSION_LEVELS_PUB.load_dimension_level(

749: -- This will either update/insert dimension levels
750:
751: l_Bsc_Dim_Rec.Bsc_Last_Update_Date := NVL(p_Bsc_Dim_Level_Rec.Bsc_Last_Update_Date, SYSDATE);
752:
753: BSC_DIMENSION_LEVELS_PUB.load_dimension_level(
754: p_commit => p_Commit
755: ,p_Dim_Level_Rec => l_Bsc_Dim_Rec
756: ,x_return_status => x_return_status
757: ,x_msg_count => x_msg_count

Line 860: ,p_Bsc_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

856: PROCEDURE Load_Dimension_Level (
857: p_Commit IN VARCHAR2 := FND_API.G_FALSE
858: ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
859: ,p_Bsc_Pmf_Dim_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Rec_Type
860: ,p_Bsc_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
861: ,x_return_status OUT NOCOPY VARCHAR2
862: ,x_msg_count OUT NOCOPY NUMBER
863: ,x_msg_data OUT NOCOPY VARCHAR2
864: ,p_force_mode IN BOOLEAN := FALSE

Line 1335: l_Bsc_Dim_Level_Rec_Type BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;

1331: x_msg_data OUT nocopy VARCHAR2
1332: ) IS
1333: l_Dimension_Level_Rec BIS_Dimension_Level_PUB.Dimension_Level_Rec_Type;
1334: x_Dimension_Level_Rec BIS_Dimension_Level_PUB.Dimension_Level_Rec_Type;
1335: l_Bsc_Dim_Level_Rec_Type BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
1336: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1337:
1338: BEGIN
1339: SAVEPOINT DimObjObsoleteUpdate;

Line 1377: BSC_DIMENSION_LEVELS_PUB.Update_Dim_Level

1373: FROM bsc_sys_dim_levels_vl
1374: WHERE short_name = p_dim_obj_short_name;
1375:
1376: IF(l_Bsc_Dim_Level_Rec_Type.Bsc_Level_Id IS NOT NULL) THEN
1377: BSC_DIMENSION_LEVELS_PUB.Update_Dim_Level
1378: ( p_commit => FND_API.G_FALSE
1379: , p_Dim_Level_Rec => l_Bsc_Dim_Level_Rec_Type
1380: , x_return_status => x_return_status
1381: , x_msg_count => x_msg_count