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 BIS_DIMENSION_LEVEL_PUB

Line 1: PACKAGE BODY BIS_DIMENSION_LEVEL_PUB AS

1: PACKAGE BODY BIS_DIMENSION_LEVEL_PUB AS
2: /* $Header: BISPDMLB.pls 120.6 2006/09/29 14:28:50 ppandey ship $ */
3: /*
4: REM +=======================================================================+
5: REM | Copyright (c) 1998 Oracle Corporation, Redwood Shores, CA, USA |

Line 62: G_PKG_NAME CONSTANT VARCHAR2(30):='BIS_DIMENSION_LEVEL_PUB';

58: REM | also get updated |
59: REM +=======================================================================+
60: */
61: --
62: G_PKG_NAME CONSTANT VARCHAR2(30):='BIS_DIMENSION_LEVEL_PUB';
63: --
64: PROCEDURE load_dim_levels_in_group(
65: p_commit IN VARCHAR2 := FND_API.G_FALSE
66: ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type

Line 89: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type

85:
86: Procedure Load_Dimension_Level_Wrapper
87: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
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

Line 106: BIS_DIMENSION_LEVEL_PUB.Load_Dimension_Level

102: l_msg_count NUMBER;
103: l_msg_data VARCHAR2(4000);
104: BEGIN
105:
106: BIS_DIMENSION_LEVEL_PUB.Load_Dimension_Level
107: ( p_api_version => 1.0
108: , p_commit => FND_API.G_FALSE
109: , p_Dimension_Level_Rec => p_Dimension_Level_Rec
110: , p_owner => p_Owner

Line 123: BIS_DIMENSION_LEVEL_PUB.Load_Dimension_Level

119: END IF;
120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
121: END IF;
122:
123: BIS_DIMENSION_LEVEL_PUB.Load_Dimension_Level
124: ( p_Commit => FND_API.G_FALSE
125: , p_Dim_Grp_Rec => p_Dim_Grp_Rec
126: , p_Bsc_Pmf_Dim_Rec => p_Bsc_Pmf_Dim_Rec
127: , p_Bsc_Dim_Level_Rec => p_Bsc_Dim_Level_Rec

Line 169: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type

165:
166: Procedure Translate_Dim_Level_Wrapper
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

Line 184: BIS_DIMENSION_LEVEL_PUB.Translate_dimension_level

180: l_msg_count NUMBER;
181: l_msg_data VARCHAR2(4000);
182: BEGIN
183:
184: BIS_DIMENSION_LEVEL_PUB.Translate_dimension_level
185: ( p_api_version => 1.0
186: , p_commit => FND_API.G_FALSE
187: , p_Dimension_Level_Rec => p_Dimension_Level_Rec
188: , p_owner => p_Owner

Line 244: , x_Dimension_Level_Tbl OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Tbl_Type

240:
241: Procedure Retrieve_Dimension_Levels
242: ( p_api_version IN NUMBER
243: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
244: , x_Dimension_Level_Tbl OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Tbl_Type
245: , x_return_status OUT NOCOPY VARCHAR2
246: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
247: )
248: IS

Line 307: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type

303: END Retrieve_Dimension_Levels;
304: --
305: Procedure Retrieve_Dimension_Level
306: ( p_api_version IN NUMBER
307: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
308: , x_Dimension_Level_Rec IN OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
309: , x_return_status OUT NOCOPY VARCHAR2
310: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
311: )

Line 308: , x_Dimension_Level_Rec IN OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type

304: --
305: Procedure Retrieve_Dimension_Level
306: ( p_api_version IN NUMBER
307: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
308: , x_Dimension_Level_Rec IN OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
309: , x_return_status OUT NOCOPY VARCHAR2
310: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
311: )
312: IS

Line 313: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;

309: , x_return_status OUT NOCOPY VARCHAR2
310: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
311: )
312: IS
313: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
314: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
315: BEGIN
316:
317: BIS_DIMENSION_LEVEL_PVT.Value_ID_Conversion

Line 373: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type

369: Procedure Translate_Dimension_Level
370: ( p_api_version IN NUMBER
371: , p_commit IN VARCHAR2 := FND_API.G_FALSE
372: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
373: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
374: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
375: , x_return_status OUT NOCOPY VARCHAR2
376: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
377: )

Line 379: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;

375: , x_return_status OUT NOCOPY VARCHAR2
376: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
377: )
378: IS
379: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
380: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
381: BEGIN
382:
383: BIS_DIMENSION_LEVEL_PVT.Value_ID_Conversion

Line 440: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type

436: Procedure Load_Dimension_Level
437: ( p_api_version IN NUMBER
438: , p_commit IN VARCHAR2 := FND_API.G_FALSE
439: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
440: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
441: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
442: , x_return_status OUT NOCOPY VARCHAR2
443: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
444: , p_force_mode IN BOOLEAN := FALSE

Line 447: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;

443: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
444: , p_force_mode IN BOOLEAN := FALSE
445: )
446: IS
447: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
448: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
449: l_return_status VARCHAR2(10);
450: l_return_msg VARCHAR2(32000);
451: l_count NUMBER;

Line 561: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type

557: PROCEDURE Create_Dimension_Level
558: ( p_api_version IN NUMBER
559: , p_commit IN VARCHAR2 := FND_API.G_FALSE
560: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
561: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
562: , x_return_status OUT NOCOPY VARCHAR2
563: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
564: )
565: IS

Line 601: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type

597: PROCEDURE Update_Dimension_Level
598: ( p_api_version IN NUMBER
599: , p_commit IN VARCHAR2 := FND_API.G_FALSE
600: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
601: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
602: , x_return_status OUT NOCOPY VARCHAR2
603: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
604: )
605: IS

Line 641: , p_Dimension_Level_Rec IN BIS_Dimension_Level_PUB.Dimension_Level_Rec_Type

637: PROCEDURE Delete_Dimension_Level
638: (
639: p_commit IN VARCHAR2 := FND_API.G_FALSE
640: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
641: , p_Dimension_Level_Rec IN BIS_Dimension_Level_PUB.Dimension_Level_Rec_Type
642: , x_return_status OUT NOCOPY VARCHAR2
643: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
644: ) IS
645: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 1023: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type

1019: PROCEDURE Trans_DimObj_By_Given_Lang
1020: (
1021: p_commit IN VARCHAR2 := FND_API.G_FALSE
1022: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1023: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
1024: , x_return_status OUT NOCOPY VARCHAR2
1025: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1026: ) IS
1027: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 1160: l_Dimension_Level_Rec_In BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;

1156: , x_msg_count OUT NOCOPY VARCHAR2
1157: , x_msg_data OUT NOCOPY VARCHAR2
1158: )
1159: IS
1160: l_Dimension_Level_Rec_In BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
1161: l_Dimension_Level_Rec_Out BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
1162: l_return_status VARCHAR2(10);
1163: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1164: l_count NUMBER;

Line 1161: l_Dimension_Level_Rec_Out BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;

1157: , x_msg_data OUT NOCOPY VARCHAR2
1158: )
1159: IS
1160: l_Dimension_Level_Rec_In BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
1161: l_Dimension_Level_Rec_Out BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
1162: l_return_status VARCHAR2(10);
1163: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1164: l_count NUMBER;
1165: BEGIN

Line 1172: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level

1168: x_return_status := FND_API.G_RET_STS_SUCCESS;
1169:
1170: l_Dimension_Level_Rec_In.dimension_level_short_name := p_dim_level_short_name;
1171:
1172: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level
1173: ( p_api_version => 1.0
1174: , p_Dimension_Level_Rec => l_Dimension_Level_Rec_In
1175: , x_Dimension_Level_Rec => l_Dimension_Level_Rec_Out
1176: , x_return_status => l_return_status

Line 1259: x_msg_data := x_msg_data||' -> BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level_Wrap ';

1255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1256: WHEN OTHERS THEN
1257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1258: IF (x_msg_data IS NOT NULL) THEN
1259: x_msg_data := x_msg_data||' -> BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level_Wrap ';
1260: ELSE
1261: x_msg_data := SQLERRM||' at BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level_Wrap ';
1262: END IF;
1263: END Retrieve_Dimension_Level_Wrap;

Line 1261: x_msg_data := SQLERRM||' at BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level_Wrap ';

1257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1258: IF (x_msg_data IS NOT NULL) THEN
1259: x_msg_data := x_msg_data||' -> BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level_Wrap ';
1260: ELSE
1261: x_msg_data := SQLERRM||' at BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level_Wrap ';
1262: END IF;
1263: END Retrieve_Dimension_Level_Wrap;
1264: --
1265: --=============================================================================

Line 1333: l_Dimension_Level_Rec BIS_Dimension_Level_PUB.Dimension_Level_Rec_Type;

1329: x_return_status OUT nocopy VARCHAR2,
1330: x_Msg_Count OUT NOCOPY NUMBER,
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:

Line 1334: x_Dimension_Level_Rec BIS_Dimension_Level_PUB.Dimension_Level_Rec_Type;

1330: x_Msg_Count OUT NOCOPY NUMBER,
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

Line 1417: END BIS_DIMENSION_LEVEL_PUB;

1413: END IF;
1414: END Update_Dim_Obj_Obsolete_Flag;
1415:
1416:
1417: END BIS_DIMENSION_LEVEL_PUB;