1 PACKAGE BIS_DIMENSION_PVT AS
2 /* $Header: BISVDIMS.pls 120.0 2005/06/01 14:46:54 appldev 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 | BISVDIMS.pls |
10 REM | |
11 REM | DESCRIPTION |
12 REM | Private API for managing Dimensions and 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 | HISTORY |
21 REM | 05-DEC-98 irchen Creation
22 REM | 01-FEB-99 ansingha added required dimension api
23 REM | 04-JAN-03 mahrao Changed OUT parameter to IN OUT in Valu_Id_Conevrsion
24 REM | as fix for bug 2735908
25 REM | 23-FEB-2003 PAJOHRI , Added procedures DELETE_DIMENSION |
26 REM | 07-JUL-2003 arhegde bug#3028436 Added get_unique_dim_group_name() |
27 REM | 09-JUL-2003 arhegde bug#3028436 Moved logic to BSC API from here |
28 REM | Removed get_unique_dim_group_name() |
29 REM | 09-FEB-05 ankgoel Bug#4172055 Dimension name validations |
30 REM +=======================================================================+
31 */
32 --
33 --
34 Procedure Retrieve_Dimensions
35 ( p_api_version IN NUMBER
36 , x_Dimension_Tbl OUT NOCOPY BIS_DIMENSION_PUB.Dimension_Tbl_Type
37 , x_return_status OUT NOCOPY VARCHAR2
38 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
39 );
40 --
41 Procedure Retrieve_Dimension
42 ( p_api_version IN NUMBER
43 , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
44 , x_Dimension_Rec OUT NOCOPY BIS_DIMENSION_PUB.Dimension_Rec_Type
45 , x_return_status OUT NOCOPY VARCHAR2
46 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
47 );
48 --
49 Procedure Create_Dimension
50 ( p_api_version IN NUMBER
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 , x_return_status OUT NOCOPY VARCHAR2
55 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
56 );
57 --
58 Procedure Create_Dimension
59 ( p_api_version IN NUMBER
60 , p_commit IN VARCHAR2 := FND_API.G_FALSE
61 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
62 , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
63 , p_owner IN VARCHAR2
64 , x_return_status OUT NOCOPY VARCHAR2
65 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
66 );
67 --
68 Procedure Update_Dimension
69 ( p_api_version IN NUMBER
70 , p_commit IN VARCHAR2 := FND_API.G_FALSE
71 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
72 , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
73 , x_return_status OUT NOCOPY VARCHAR2
74 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
75 );
76 --
77 Procedure Update_Dimension
78 ( p_api_version IN NUMBER
79 , p_commit IN VARCHAR2 := FND_API.G_FALSE
80 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
81 , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
82 , p_owner IN VARCHAR2
83 , x_return_status OUT NOCOPY VARCHAR2
84 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
85 );
86 --
87 Procedure Translate_Dimension
88 ( p_api_version IN NUMBER
89 , p_commit IN VARCHAR2 := FND_API.G_FALSE
90 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
91 , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
92 , x_return_status OUT NOCOPY VARCHAR2
93 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
94 );
95 --
96 Procedure Translate_Dimension
97 ( p_api_version IN NUMBER
98 , p_commit IN VARCHAR2 := FND_API.G_FALSE
99 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
100 , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
101 , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
102 , x_return_status OUT NOCOPY VARCHAR2
103 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
104 );
105 --
106 -- Value - ID conversion
107 PROCEDURE Value_ID_Conversion
108 ( p_api_version IN NUMBER
109 , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
110 , x_Dimension_Rec IN OUT NOCOPY BIS_DIMENSION_PUB.Dimension_Rec_Type
111 , x_return_status OUT NOCOPY VARCHAR2
112 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
113 );
114 --
115 PROCEDURE Validate_Dimension
116 ( p_api_version IN NUMBER
117 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
118 , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
119 , x_return_status OUT NOCOPY VARCHAR2
120 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
121 );
122 --
123 PROCEDURE Value_ID_Conversion
124 ( p_api_version IN NUMBER
125 , p_Dimension_Short_Name IN VARCHAR2
126 , p_Dimension_Name IN VARCHAR2
127 , x_Dimension_ID OUT NOCOPY NUMBER
128 , x_return_status OUT NOCOPY VARCHAR2
129 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
130 );
131 --
132 /* modified from ansingha's function */
133 FUNCTION DuplicateDimension
134 ( p_dimension_rec BIS_DIMENSION_PUB.Dimension_Rec_Type
135 , p_dimensions_tbl BIS_DIMENSION_PUB.Dimension_Tbl_Type
136 ) return BOOLEAN;
137 --
138 -- removes the dimensions from p_all_dimension_table
139 -- which are in p_dimension_table
140 PROCEDURE RemoveDuplicates
141 ( p_dimension_table in BIS_DIMENSION_PUB.Dimension_tbl_type
142 , p_all_dimension_table in BIS_DIMENSION_PUB.Dimension_tbl_type
143 , x_all_dimension_table out NOCOPY BIS_DIMENSION_PUB.Dimension_tbl_type
144 );
145 --
146 PROCEDURE Delete_Dimension
147 (
148 p_commit IN VARCHAR2 := FND_API.G_FALSE
149 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
150 , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
151 , x_return_status OUT NOCOPY VARCHAR2
152 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
153 );
154 --
155
156 PROCEDURE Translate_Dim_By_Given_Lang
157 (
158 p_commit IN VARCHAR2 := FND_API.G_FALSE
159 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
160 , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
161 , x_return_status OUT NOCOPY VARCHAR2
162 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
163 );
164
165 --
166
167 PROCEDURE Validate_PMF_Unique_Name
168 ( p_Dimension_Short_Name IN VARCHAR2
169 , p_Dimension_Name IN VARCHAR2
170 , x_return_status OUT NOCOPY VARCHAR2
171 );
172
173 --
174
175
176 END BIS_DIMENSION_PVT;