[Home] [Help]
PACKAGE: APPS.BIS_MEASURE_VALIDATE_PVT
Source
1 PACKAGE BIS_MEASURE_VALIDATE_PVT AS
2 /* $Header: BISVMEVS.pls 120.0 2005/06/01 17:13:26 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 | BISVTVLS.pls |
10 REM | MAHRAO 1850860 27/11/2001 |
11 REM | DESCRIPTION |
12 REM | Private API for validating items in the MEASUREs record
13 REM | NOTES |
14 REM | |
15 REM |
16 REM | 26-JUL-2002 rchandra Fixed for enh 2440739 |
17 REM | 12-NOV-03 smargand added the validation for the enable column |
18 REM | 22-APR-2005 akoduri Enhancement#3865711 -- Obsolete Seeded Objects |
19 REM | 03-MAY-2005 akoduri Enh #4268374 -- Weighted Average Measures |
20 REM +=======================================================================+
21 */
22 --
23 --
24 PROCEDURE Validate_Dimension1_ID
25 ( p_api_version IN NUMBER
26 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
27 , p_MEASURE_Rec IN BIS_MEASURE_PUB.MEASURE_Rec_Type
28 , x_return_status OUT NOCOPY VARCHAR2
29 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
30 );
31 --
32 PROCEDURE Validate_Dimension2_ID
33 ( p_api_version IN NUMBER
34 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
35 , p_MEASURE_Rec IN BIS_MEASURE_PUB.MEASURE_Rec_Type
36 , x_return_status OUT NOCOPY VARCHAR2
37 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
38 );
39 --
40 PROCEDURE Validate_Dimension3_ID
41 ( p_api_version IN NUMBER
42 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
43 , p_MEASURE_Rec IN BIS_MEASURE_PUB.MEASURE_Rec_Type
44 , x_return_status OUT NOCOPY VARCHAR2
45 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
46 );
47 --
48 PROCEDURE Validate_Dimension4_ID
49 ( p_api_version IN NUMBER
50 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
51 , p_MEASURE_Rec IN BIS_MEASURE_PUB.MEASURE_Rec_Type
52 , x_return_status OUT NOCOPY VARCHAR2
53 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
54 );
55 --
56 --
57 PROCEDURE Validate_Dimension5_ID
58 ( p_api_version IN NUMBER
59 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
60 , p_MEASURE_Rec IN BIS_MEASURE_PUB.MEASURE_Rec_Type
61 , x_return_status OUT NOCOPY VARCHAR2
62 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
63 );
64
65 --
66 PROCEDURE Validate_Dimension6_ID
67 ( p_api_version IN NUMBER
68 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
69 , p_MEASURE_Rec IN BIS_MEASURE_PUB.MEASURE_Rec_Type
70 , x_return_status OUT NOCOPY VARCHAR2
71 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
72 );
73 --
74 PROCEDURE Validate_Dimension7_ID
75 ( p_api_version IN NUMBER
76 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
77 , p_MEASURE_Rec IN BIS_MEASURE_PUB.MEASURE_Rec_Type
78 , x_return_status OUT NOCOPY VARCHAR2
79 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
80 );
81
82 --added this in the spec
83 PROCEDURE Validate_Dimension_Id
84 ( p_api_version IN NUMBER
85 , p_dimension_id IN NUMBER
86 , p_dimension_short_name IN VARCHAR2
87 , x_return_status OUT NOCOPY VARCHAR2
88 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
89 );
90 --
91 -- Fix for 1850860 starts here
92 PROCEDURE Val_Actual_Data_Sour_Type
93 ( p_api_version IN NUMBER
94 , p_actual_data_source_type IN VARCHAR2
95 , x_return_status OUT NOCOPY VARCHAR2
96 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
97 );
98 --
99 PROCEDURE Val_Actual_Data_Sour_Type_wrap
100 ( p_api_version IN NUMBER
101 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
102 , p_MEASURE_Rec IN BIS_MEASURE_PUB.MEASURE_Rec_Type
103 , x_return_status OUT NOCOPY VARCHAR2
104 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
105 );
106 --
107 PROCEDURE Val_Actual_Data_Sour
108 ( p_api_version IN NUMBER
109 , p_actual_data_source IN VARCHAR2
110 , x_return_status OUT NOCOPY VARCHAR2
111 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
112 );
113 --
114 PROCEDURE Val_Actual_Data_Sour_Wrap
115 ( p_api_version IN NUMBER
116 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
117 , p_MEASURE_Rec IN BIS_MEASURE_PUB.MEASURE_Rec_Type
118 , x_return_status OUT NOCOPY VARCHAR2
119 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
120 );
121 --
122 PROCEDURE Val_Func_Name
123 ( p_api_version IN NUMBER
124 , p_function_name IN VARCHAR2
125 , x_return_status OUT NOCOPY VARCHAR2
126 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
127 );
128 --
129 PROCEDURE Val_Func_Name_Wrap
130 ( p_api_version IN NUMBER
131 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
132 , p_MEASURE_Rec IN BIS_MEASURE_PUB.MEASURE_Rec_Type
133 , x_return_status OUT NOCOPY VARCHAR2
134 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
135 );
136 --
137 PROCEDURE Val_Comparison_Source
138 ( p_api_version IN NUMBER
139 , p_Comparison_Source IN VARCHAR2
140 , x_return_status OUT NOCOPY VARCHAR2
141 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
142 );
143 --
144 PROCEDURE Val_Comparison_Source_Wrap
145 ( p_api_version IN NUMBER
146 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
147 , p_MEASURE_Rec IN BIS_MEASURE_PUB.MEASURE_Rec_Type
148 , x_return_status OUT NOCOPY VARCHAR2
149 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
150 );
151 --
152 PROCEDURE Val_Incr_In_Measure
153 ( p_api_version IN NUMBER
154 , p_Increase_In_Measure IN VARCHAR2
155 , x_return_status OUT NOCOPY VARCHAR2
156 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
157 );
158 --
159 PROCEDURE Val_Incr_In_Measure_Wrap
160 ( p_api_version IN NUMBER
161 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
162 , p_MEASURE_Rec IN BIS_MEASURE_PUB.MEASURE_Rec_Type
163 , x_return_status OUT NOCOPY VARCHAR2
164 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
165 );
166 --
167 -- Fix for 1850860 ends here
168 --
169
170 -- 2440739
171 PROCEDURE Val_Enable_Link
172 ( p_api_version IN NUMBER
173 , p_Enable_Link IN VARCHAR2
174 , x_return_status OUT NOCOPY VARCHAR2
175 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
176 );
177 --
178 PROCEDURE Val_Enable_Link_Wrap
179 ( p_api_version IN NUMBER
180 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
181 , p_MEASURE_Rec IN BIS_MEASURE_PUB.MEASURE_Rec_Type
182 , x_return_status OUT NOCOPY VARCHAR2
183 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
184 );
185
186 -- 2440739
187
188 -- 3031053
189
190 PROCEDURE Val_Enabled
191 ( p_api_version IN NUMBER
192 , p_Enabled IN VARCHAR2
193 , x_return_status OUT NOCOPY VARCHAR2
194 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
195 );
196
197 PROCEDURE Val_Enabled_Wrap
198 ( p_api_version IN NUMBER
199 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
200 , p_MEASURE_Rec IN BIS_MEASURE_PUB.MEASURE_Rec_Type
201 , x_return_status OUT NOCOPY VARCHAR2
202 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
203 );
204 -- 3031053
205
206 PROCEDURE Val_Obsolete_Wrap --3865711
207 ( p_api_version IN NUMBER
208 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
209 , p_MEASURE_Rec IN BIS_MEASURE_PUB.MEASURE_Rec_Type
210 , x_return_status OUT NOCOPY VARCHAR2
211 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
212 );
213
214 PROCEDURE Val_Measure_Type_Wrap
215 ( p_api_version IN NUMBER
216 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
217 , p_MEASURE_Rec IN BIS_MEASURE_PUB.MEASURE_Rec_Type
218 , x_return_status OUT NOCOPY VARCHAR2
219 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
220 );
221
222
223 END BIS_MEASURE_VALIDATE_PVT;