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

Line 1: PACKAGE BODY BIS_DIMENSION_PUB AS

1: PACKAGE BODY BIS_DIMENSION_PUB AS
2: /* $Header: BISPDIMB.pls 120.2 2006/01/06 03:22:23 akoduri noship $ */
3: /*
4: REM +=======================================================================+
5: REM | Copyright (c) 1998 Oracle Corporation, Redwood Shores, CA, USA |

Line 45: G_PKG_NAME CONSTANT VARCHAR2(30):='BIS_DIMENSION_PUB';

41: REM | 06-Jan-06 akoduri Enh#4739401 - Hide Dimensions/Dim Objects |
42: REM +=======================================================================+
43: */
44: --
45: G_PKG_NAME CONSTANT VARCHAR2(30):='BIS_DIMENSION_PUB';
46:
47:
48: --
49: --

Line 53: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type

49: --
50: Procedure Load_Dimension_Wrapper
51: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
52: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
53: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
54: , p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
55: , p_Owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
56: , p_force_mode IN BOOLEAN := FALSE
57: , x_return_status OUT NOCOPY VARCHAR2

Line 86: BIS_DIMENSION_PUB.Load_dimension

82: );
83: RAISE FND_API.G_EXC_ERROR;
84: END IF;
85:
86: BIS_DIMENSION_PUB.Load_dimension
87: ( p_api_version => 1.0
88: , p_commit => FND_API.G_FALSE
89: , p_Dimension_Rec => p_Dimension_Rec
90: , p_owner => p_Owner

Line 103: BIS_DIMENSION_PUB.Load_Dimension_Group

99: END IF;
100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
101: END IF;
102:
103: BIS_DIMENSION_PUB.Load_Dimension_Group
104: ( p_Commit => FND_API.G_FALSE
105: , p_dim_grp_rec => p_Dim_Grp_Rec
106: , x_return_status => l_return_status
107: , x_msg_count => l_msg_count

Line 147: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type

143:
144: Procedure Translate_Dimension_Wrapper
145: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
146: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
147: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
148: , p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
149: , p_Owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
150: , x_return_status OUT NOCOPY VARCHAR2
151: , x_msg_count OUT NOCOPY NUMBER

Line 161: BIS_DIMENSION_PUB.Translate_dimension

157: l_msg_count NUMBER;
158: l_msg_data VARCHAR2(4000);
159: BEGIN
160:
161: BIS_DIMENSION_PUB.Translate_dimension
162: ( p_api_version => 1.0
163: , p_commit => FND_API.G_FALSE
164: , p_Dimension_Rec => p_Dimension_Rec
165: , p_owner => p_Owner

Line 219: , x_Dimension_Tbl OUT NOCOPY BIS_DIMENSION_PUB.Dimension_Tbl_Type

215: --
216:
217: Procedure Retrieve_Dimensions
218: ( p_api_version IN NUMBER
219: , x_Dimension_Tbl OUT NOCOPY BIS_DIMENSION_PUB.Dimension_Tbl_Type
220: , x_return_status OUT NOCOPY VARCHAR2
221: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
222: )
223: IS

Line 255: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type

251: END Retrieve_Dimensions;
252: --
253: Procedure Retrieve_Dimension
254: ( p_api_version IN NUMBER
255: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
256: , x_Dimension_Rec OUT NOCOPY BIS_DIMENSION_PUB.Dimension_Rec_Type
257: , x_return_status OUT NOCOPY VARCHAR2
258: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
259: )

Line 256: , x_Dimension_Rec OUT NOCOPY BIS_DIMENSION_PUB.Dimension_Rec_Type

252: --
253: Procedure Retrieve_Dimension
254: ( p_api_version IN NUMBER
255: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
256: , x_Dimension_Rec OUT NOCOPY BIS_DIMENSION_PUB.Dimension_Rec_Type
257: , x_return_status OUT NOCOPY VARCHAR2
258: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
259: )
260: IS

Line 261: l_Dimension_Rec BIS_DIMENSION_PUB.Dimension_Rec_Type;

257: , x_return_status OUT NOCOPY VARCHAR2
258: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
259: )
260: IS
261: l_Dimension_Rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
262: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
263: BEGIN
264:
265: BIS_DIMENSION_PVT.Value_ID_Conversion

Line 322: , x_dimension_rec OUT NOCOPY BIS_DIMENSION_PUB.Dimension_Rec_Type

318: -- I wish I had enumerated types :-(
319: Procedure Retrieve_Required_Dimension
320: ( p_api_version IN NUMBER
321: , p_num IN NUMBER
322: , x_dimension_rec OUT NOCOPY BIS_DIMENSION_PUB.Dimension_Rec_Type
323: , x_return_status OUT NOCOPY VARCHAR2
324: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
325: )
326: IS

Line 327: l_Dimension_Rec BIS_DIMENSION_PUB.Dimension_Rec_Type;

323: , x_return_status OUT NOCOPY VARCHAR2
324: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
325: )
326: IS
327: l_Dimension_Rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
328: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
329: BEGIN
330: if (p_num = 1) then
331: l_Dimension_Rec.dimension_short_name := 'ORGANIZATION';

Line 344: BIS_DIMENSION_PUB.Retrieve_Dimension

340: );
341: RAISE FND_API.G_EXC_ERROR;
342: end if;
343:
344: BIS_DIMENSION_PUB.Retrieve_Dimension
345: ( p_api_version => 1.0
346: , p_Dimension_Rec => l_Dimension_Rec
347: , x_Dimension_Rec => x_Dimension_Rec
348: , x_return_status => x_return_status

Line 378: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type

374: Procedure Translate_Dimension
375: ( p_api_version IN NUMBER
376: , p_commit IN VARCHAR2 := FND_API.G_FALSE
377: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
378: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
379: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
380: , x_return_status OUT NOCOPY VARCHAR2
381: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
382: )

Line 384: l_Dimension_Rec BIS_DIMENSION_PUB.Dimension_Rec_Type;

380: , x_return_status OUT NOCOPY VARCHAR2
381: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
382: )
383: IS
384: l_Dimension_Rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
385: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
386: l_return_status VARCHAR2(10);
387: l_return_msg VARCHAR2(32000);
388:

Line 450: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type

446: Procedure Load_Dimension
447: ( p_api_version IN NUMBER
448: , p_commit IN VARCHAR2 := FND_API.G_FALSE
449: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
450: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
451: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
452: , x_return_status OUT NOCOPY VARCHAR2
453: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
454: , p_force_mode IN BOOLEAN := FALSE

Line 457: l_Dimension_Rec BIS_DIMENSION_PUB.Dimension_Rec_Type;

453: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
454: , p_force_mode IN BOOLEAN := FALSE
455: )
456: IS
457: l_Dimension_Rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
458: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
459: l_return_status VARCHAR2(10);
460: l_return_msg VARCHAR2(32000);
461: l_count NUMBER;

Line 553: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type

549: PROCEDURE Update_Dimension
550: ( p_api_version IN NUMBER
551: , p_commit IN VARCHAR2 := FND_API.G_FALSE
552: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
553: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
554: , x_return_status OUT NOCOPY VARCHAR2
555: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
556: )
557: IS

Line 593: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type

589: PROCEDURE Delete_Dimension
590: (
591: p_commit IN VARCHAR2 := FND_API.G_FALSE
592: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
593: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
594: , x_return_status OUT NOCOPY VARCHAR2
595: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
596: )
597: IS

Line 630: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type

626: (
627: p_api_version IN NUMBER
628: , p_commit IN VARCHAR2 := FND_API.G_FALSE
629: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
630: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
631: , x_return_status OUT NOCOPY VARCHAR2
632: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
633: )
634: IS

Line 731: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type

727: PROCEDURE Translate_Dim_By_Given_Lang
728: (
729: p_commit IN VARCHAR2 := FND_API.G_FALSE
730: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
731: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
732: , x_return_status OUT NOCOPY VARCHAR2
733: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
734: ) IS
735: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 773: l_dim_rec BIS_DIMENSION_PUB.Dimension_Rec_Type;

769: x_return_status OUT nocopy VARCHAR2,
770: x_Msg_Count OUT NOCOPY NUMBER,
771: x_msg_data OUT nocopy VARCHAR2
772: ) IS
773: l_dim_rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
774: x_dim_rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
775: l_dim_obj_sht_name BSC_SYS_DIM_LEVELS_B.SHORT_NAME%TYPE;
776: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
777:

Line 774: x_dim_rec BIS_DIMENSION_PUB.Dimension_Rec_Type;

770: x_Msg_Count OUT NOCOPY NUMBER,
771: x_msg_data OUT nocopy VARCHAR2
772: ) IS
773: l_dim_rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
774: x_dim_rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
775: l_dim_obj_sht_name BSC_SYS_DIM_LEVELS_B.SHORT_NAME%TYPE;
776: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
777:
778: CURSOR cr_dim_obj IS

Line 863: x_msg_data := x_msg_data||' -> BIS_DIMENSION_PUB.Update_Dimension_Obsolete_Flag ';

859: WHEN OTHERS THEN
860: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
861: ROLLBACK TO DimObsoleteUpdate;
862: IF (x_msg_data IS NOT NULL) THEN
863: x_msg_data := x_msg_data||' -> BIS_DIMENSION_PUB.Update_Dimension_Obsolete_Flag ';
864: ELSE
865: x_msg_data := SQLERRM||' at BIS_DIMENSION_PUB.Update_Dimension_Obsolete_Flag ';
866: END IF;
867: END Update_Dimension_Obsolete_Flag;

Line 865: x_msg_data := SQLERRM||' at BIS_DIMENSION_PUB.Update_Dimension_Obsolete_Flag ';

861: ROLLBACK TO DimObsoleteUpdate;
862: IF (x_msg_data IS NOT NULL) THEN
863: x_msg_data := x_msg_data||' -> BIS_DIMENSION_PUB.Update_Dimension_Obsolete_Flag ';
864: ELSE
865: x_msg_data := SQLERRM||' at BIS_DIMENSION_PUB.Update_Dimension_Obsolete_Flag ';
866: END IF;
867: END Update_Dimension_Obsolete_Flag;
868:
869: --=============================================================================

Line 870: END BIS_DIMENSION_PUB;

866: END IF;
867: END Update_Dimension_Obsolete_Flag;
868:
869: --=============================================================================
870: END BIS_DIMENSION_PUB;