1 PACKAGE BIS_DIMENSION_LEVEL_PVT AS
2 /* $Header: BISVDMLS.pls 120.1 2005/11/08 02:40:54 akoduri noship $ */
3 /*
4 REM +=======================================================================+
5 REM | Copyright (c) 1998 Oracle Corporation, Redwood Shores, CA, USA |
6 REM | All rights reserved. |
7 REM +=======================================================================+
8 REM | FILENAME |
9 REM | BISVDMLS.pls |
10 REM | |
11 REM | DESCRIPTION |
12 REM | Private API for managing dimension levels for the
13 REM | Key Performance Framework.
14 REM |
15 REM | This package should be maintaind by EDW once it gets integrated
16 REM | with BIS.
17 REM |
18 REM | NOTES |
19 REM | |
20 REM | 21-OCT-02 arhegde Added retrieve_mult_dim_levels |
21 REM | 23-FEB-2003 PAJOHRI , Added procedures DELETE_DIMENSION_LEVEL |
22 REM | 07-NOV-2005 akoduri Bug#4696105,Added overloaded API |
23 REM | get_customized_enabled |
24 REM +=======================================================================+
25 */
26 --
27 --
28 Procedure Retrieve_Dimension_Levels
29 ( p_api_version IN NUMBER
30 , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
31 , x_Dimension_Level_Tbl OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Tbl_Type
32 , x_return_status OUT NOCOPY VARCHAR2
33 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
34 );
35 --
36 Procedure Retrieve_Dimension_Level
37 ( p_api_version IN NUMBER
38 , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
39 , x_Dimension_Level_Rec IN OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
40 , x_return_status OUT NOCOPY VARCHAR2
41 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
42 );
43 --
44 PROCEDURE retrieve_mult_dim_levels(
45 p_api_version IN NUMBER
46 ,p_all_dim_levels_tbl IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Tbl_Type
47 ,x_all_dim_levels_tbl OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Tbl_Type
48 ,x_return_status OUT NOCOPY VARCHAR2
49 ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
50 );
51 --
52 PROCEDURE Create_Dimension_Level
53 ( p_api_version IN NUMBER
54 , p_commit IN VARCHAR2 := FND_API.G_FALSE
55 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
56 , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
57 , x_return_status OUT NOCOPY VARCHAR2
58 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
59 );
60 --
61 PROCEDURE Create_Dimension_Level
62 ( p_api_version IN NUMBER
63 , p_commit IN VARCHAR2 := FND_API.G_FALSE
64 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
65 , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
66 , p_owner IN VARCHAR2
67 , x_return_status OUT NOCOPY VARCHAR2
68 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
69 );
70 --
71 PROCEDURE Update_Dimension_Level
72 ( p_api_version IN NUMBER
73 , p_commit IN VARCHAR2 := FND_API.G_FALSE
74 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
75 , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
76 , x_return_status OUT NOCOPY VARCHAR2
77 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
78 );
79 --
80 PROCEDURE Update_Dimension_Level
81 ( p_api_version IN NUMBER
82 , p_commit IN VARCHAR2 := FND_API.G_FALSE
83 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
84 , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
85 , p_owner IN VARCHAR2
86 , x_return_status OUT NOCOPY VARCHAR2
87 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
88 );
89 --
90 Procedure Translate_Dimension_Level
91 ( p_api_version IN NUMBER
92 , p_commit IN VARCHAR2 := FND_API.G_FALSE
93 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
94 , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
95 , x_return_status OUT NOCOPY VARCHAR2
96 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
97 );
98 --
99 Procedure Translate_Dimension_Level
100 ( p_api_version IN NUMBER
101 , p_commit IN VARCHAR2 := FND_API.G_FALSE
102 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
103 , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
104 , p_owner IN VARCHAR2
105 , x_return_status OUT NOCOPY VARCHAR2
106 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
107 );
108 --
109 PROCEDURE Validate_Dimension_Level
110 ( p_api_version IN NUMBER
111 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
112 , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
113 , x_return_status OUT NOCOPY VARCHAR2
114 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
115 );
116 -- Value - ID conversion
117 PROCEDURE Value_ID_Conversion
118 ( p_api_version IN NUMBER
119 , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
120 , x_Dimension_Level_Rec OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
121 , x_return_status OUT NOCOPY VARCHAR2
122 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
123 );
124 --
125 PROCEDURE Value_ID_Conversion
126 ( p_api_version IN NUMBER
127 , p_Dimension_Level_Short_Name IN VARCHAR2
128 , p_Dimension_Level_Name IN VARCHAR2
129 , x_Dimension_Level_ID OUT NOCOPY NUMBER
130 , x_return_status OUT NOCOPY VARCHAR2
131 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
132 );
133 --
134 PROCEDURE Delete_Dimension_Level
135 (
136 p_commit IN VARCHAR2 := FND_API.G_FALSE
137 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
138 , p_Dimension_Level_Rec IN BIS_Dimension_Level_PUB.Dimension_Level_Rec_Type
139 , x_return_status OUT NOCOPY VARCHAR2
140 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
141 );
142 --
143
144 PROCEDURE Trans_DimObj_By_Given_Lang
145 (
146 p_commit IN VARCHAR2 := FND_API.G_FALSE
147 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
148 , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
149 , x_return_status OUT NOCOPY VARCHAR2
150 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
151 );
152
153 --
154 -- get customized values for name , description and enabled
155 FUNCTION get_customized_name( p_dim_level_id IN NUMBER) RETURN VARCHAR2;
156 FUNCTION get_customized_description( p_dim_level_id IN NUMBER) RETURN VARCHAR2;
157 FUNCTION get_customized_enabled( p_dim_level_id IN NUMBER) RETURN VARCHAR2;
158 FUNCTION get_customized_enabled( p_dim_level_sht_name IN VARCHAR2) RETURN VARCHAR2;
159
160 PROCEDURE validate_disabling (p_dim_level_id IN NUMBER);
161
162 END BIS_DIMENSION_LEVEL_PVT;