1 PACKAGE PV_ENTY_ATTR_VALIDATIONS_PVT AUTHID CURRENT_USER AS
2 /* $Header: pvxvatvs.pls 115.1 2002/12/10 19:19:52 amaram ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- PV_ENTY_ATTR_VALIDATIONS_PVT
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15
16 -- Default number of records fetch per call
17 -- G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
18 -- ===================================================================
19 -- Start of Comments
20 -- -------------------------------------------------------
21 -- Record name
22 -- enty_attr_val_rec_type
23 -- -------------------------------------------------------
24 -- Parameters:
25 -- enty_attr_val_id
26 -- last_update_date
27 -- last_updated_by
28 -- creation_date
29 -- created_by
30 -- last_update_login
31 -- object_version_number
32 -- entity
33 -- attribute_id
34 -- party_id
35 -- attr_value
36 -- score
37 -- enabled_flag
38 -- entity_id
39 -- security_group_id
40 --
41 -- Required
42 --
43 -- Defaults
44 --
45 -- Note: This is automatic generated record definition, it includes all columns
46 -- defined in the table, developer must manually add or delete some of the attributes.
47 --
48 -- End of Comments
49
50 -- ===================================================================
51
52 TYPE enty_attr_validation_rec_type IS RECORD
53 (
54
55
56 validation_id NUMBER := FND_API.G_MISS_NUM
57 ,last_update_date DATE := FND_API.G_MISS_DATE
58 ,last_updated_by NUMBER := FND_API.G_MISS_NUM
59 ,creation_date DATE := FND_API.G_MISS_DATE
60 ,created_by NUMBER := FND_API.G_MISS_NUM
61 ,last_update_login NUMBER := FND_API.G_MISS_NUM
62 ,object_version_number NUMBER := FND_API.G_MISS_NUM
63 ,validation_date DATE := FND_API.G_MISS_DATE
64 ,validated_by_resource_id NUMBER := FND_API.G_MISS_NUM
65 ,validation_document_id NUMBER := FND_API.G_MISS_NUM
66 ,validation_note VARCHAR2(4000) := FND_API.G_MISS_CHAR
67
68 );
69
70 g_miss_enty_attr_vldtn_rec enty_attr_validation_rec_type;
71
72 -- ==============================================================================
73 -- Start of Comments
74 -- ==============================================================================
75 -- API Name
76 -- Create_Enty_Attr_Validation
77 -- Type
78 -- Private
79 -- Pre-Req
80 --
81 -- Parameters
82 --
83 -- IN
84 -- p_api_version_number IN NUMBER Required
85 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
86 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
87 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
88 -- p_enty_attr_validation_rec IN enty_attr_validation_rec_type Required
89 --
90 -- OUT
91 -- x_return_status OUT VARCHAR2
92 -- x_msg_count OUT NUMBER
93 -- x_msg_data OUT VARCHAR2
94 -- Version : Current version 1.0
95 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
96 -- and basic operation, developer must manually add parameters and business logic as necessary.
97 --
98 -- End of Comments
99 -- ==============================================================================
100 --
101
102 PROCEDURE Create_Enty_Attr_Validation(
103 p_api_version_number IN NUMBER
104 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
105 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
106 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
107
108 ,x_return_status OUT NOCOPY VARCHAR2
109 ,x_msg_count OUT NOCOPY NUMBER
110 ,x_msg_data OUT NOCOPY VARCHAR2
111
112 ,p_enty_attr_validation_rec IN enty_attr_validation_rec_type := g_miss_enty_attr_vldtn_rec
113 ,x_enty_attr_validation_id OUT NOCOPY NUMBER
114 );
115
116 -- ==============================================================================
117 -- Start of Comments
118 -- ==============================================================================
119 -- API Name
120 -- Update_Enty_Attr_Validation
121 -- Type
122 -- Private
123 -- Pre-Req
124 --
125 -- Parameters
126 --
127 -- IN
128 -- p_api_version_number IN NUMBER Required
129 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
130 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
131 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
132 -- p_enty_attr_val_rec IN enty_attr_val_rec_type Required
133 --
134 -- OUT
135 -- x_return_status OUT VARCHAR2
136 -- x_msg_count OUT NUMBER
137 -- x_msg_data OUT VARCHAR2
138 -- Version : Current version 1.0
139 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
140 -- and basic operation, developer must manually add parameters and business logic as necessary.
141 --
142 -- End of Comments
143 -- ==============================================================================
144 --
145
146 PROCEDURE Update_Enty_Attr_Validation(
147 p_api_version_number IN NUMBER
148 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
149 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
150 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
151
152 ,x_return_status OUT NOCOPY VARCHAR2
153 ,x_msg_count OUT NOCOPY NUMBER
154 ,x_msg_data OUT NOCOPY VARCHAR2
155
156 ,p_enty_attr_validation_rec IN enty_attr_validation_rec_type
157 ,x_object_version_number OUT NOCOPY NUMBER
158 );
159
160 -- ==============================================================================
161 -- Start of Comments
162 -- ==============================================================================
163 -- API Name
164 -- Delete_Enty_Attr_Validation
165 -- Type
166 -- Private
167 -- Pre-Req
168 --
169 -- Parameters
170 --
171 -- IN
172 -- p_api_version_number IN NUMBER Required
173 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
174 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
175 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
176 -- p_ENTY_ATTR_VAL_ID IN NUMBER
177 -- p_object_version_number IN NUMBER Optional Default = NULL
178 --
179 -- OUT
180 -- x_return_status OUT VARCHAR2
181 -- x_msg_count OUT NUMBER
182 -- x_msg_data OUT VARCHAR2
183 -- Version : Current version 1.0
184 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
185 -- and basic operation, developer must manually add parameters and business logic as necessary.
186 --
187 -- End of Comments
188 -- ==============================================================================
189 --
190
191 PROCEDURE Delete_Enty_Attr_Validation(
192 p_api_version_number IN NUMBER
193 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
194 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
195 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
196
197 ,x_return_status OUT NOCOPY VARCHAR2
198 ,x_msg_count OUT NOCOPY NUMBER
199 ,x_msg_data OUT NOCOPY VARCHAR2
200
201 ,p_enty_attr_validation_id IN NUMBER
202 ,p_object_version_number IN NUMBER
203 );
204
205 -- ==============================================================================
206 -- Start of Comments
207 -- ==============================================================================
208 -- API Name
209 -- Lock_Enty_Attr_Validation
210 -- Type
211 -- Private
212 -- Pre-Req
213 --
214 -- Parameters
215 --
216 -- IN
217 -- p_api_version_number IN NUMBER Required
218 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
219 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
220 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
221 -- p_enty_attr_val_rec IN enty_attr_val_rec_type Required
222 --
223 -- OUT
224 -- x_return_status OUT VARCHAR2
225 -- x_msg_count OUT NUMBER
226 -- x_msg_data OUT VARCHAR2
227 -- Version : Current version 1.0
228 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
229 -- and basic operation, developer must manually add parameters and business logic as necessary.
230 --
231 -- End of Comments
232 -- ==============================================================================
233 --
234
235 PROCEDURE Lock_Enty_Attr_Validation(
236 p_api_version_number IN NUMBER
237 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
238
239 ,x_return_status OUT NOCOPY VARCHAR2
240 ,x_msg_count OUT NOCOPY NUMBER
241 ,x_msg_data OUT NOCOPY VARCHAR2
242
243 ,p_enty_attr_validation_id IN NUMBER
244 ,p_object_version IN NUMBER
245 );
246
247 -- ===============================================================================
248 -- Start of Comments
249 -- ===============================================================================
250 --
251 -- validation procedures
252 --
253 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
254 -- For create: G_CREATE, for update: G_UPDATE
255 -- Note: 1. This is automated generated item level validation procedure.
256 -- The actual validation detail is needed to be added.
257 -- 2. We can also validate table instead of record. There will be an option for user to choose.
258 -- End of Comments
259 -- ===============================================================================
260
261 PROCEDURE Validate_Enty_Attr_Validation(
262 p_api_version_number IN NUMBER
263 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
264 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
265 ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_UPDATE
266 ,p_enty_attr_validation_rec IN enty_attr_validation_rec_type
267
268 ,x_return_status OUT NOCOPY VARCHAR2
269 ,x_msg_count OUT NOCOPY NUMBER
270 ,x_msg_data OUT NOCOPY VARCHAR2
271 );
272
273 -- ===============================================================================
274 -- Start of Comments
275 -- ===============================================================================
276 --
277 -- validation procedures
278 --
279 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
280 -- For create: G_CREATE, for update: G_UPDATE
281 -- Note: 1. This is automated generated item level validation procedure.
282 -- The actual validation detail is needed to be added.
283 -- 2. Validate the unique keys, lookups here
284 -- End of Comments
285 -- ===============================================================================
286
287 PROCEDURE Check_Enty_Attr_vldtn_Items (
288 p_enty_attr_validation_rec IN enty_attr_validation_rec_type
289 ,p_validation_mode IN VARCHAR2
290
291 ,x_return_status OUT NOCOPY VARCHAR2
292 );
293
294 -- ===============================================================================
295 -- Start of Comments
296 -- ===============================================================================
297 --
298 -- Record level validation procedures
299 --
300 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
301 -- For create: G_CREATE, for update: G_UPDATE
302 -- Note: 1. This is automated generated item level validation procedure.
303 -- The actual validation detail is needed to be added.
304 -- 2. Developer can manually added inter-field level validation.
305 -- End of Comments
306 -- ===============================================================================
307
308 PROCEDURE Validate_enty_attr_vldtn_rec(
309 p_api_version_number IN NUMBER
310 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
311
312 ,x_return_status OUT NOCOPY VARCHAR2
313 ,x_msg_count OUT NOCOPY NUMBER
314 ,x_msg_data OUT NOCOPY VARCHAR2
315
316 ,p_enty_attr_validation_rec IN enty_attr_validation_rec_type
317 ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_UPDATE
318 );
319
320 END PV_ENTY_ATTR_VALIDATIONS_PVT;