1 PACKAGE PV_Enty_Attr_Value_PVT AS
2 /* $Header: pvxveavs.pls 120.1 2005/11/11 15:28:06 amaram noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- PV_Enty_Attr_Value_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_val_rec_type IS RECORD
53 (
54 enty_attr_val_id NUMBER := FND_API.G_MISS_NUM
55 ,last_update_date DATE := FND_API.G_MISS_DATE
56 ,last_updated_by NUMBER := FND_API.G_MISS_NUM
57 ,creation_date DATE := FND_API.G_MISS_DATE
58 ,created_by NUMBER := FND_API.G_MISS_NUM
59 ,last_update_login NUMBER := FND_API.G_MISS_NUM
60 ,object_version_number NUMBER := FND_API.G_MISS_NUM
61 ,entity VARCHAR2(50) := FND_API.G_MISS_CHAR
62 ,attribute_id NUMBER := FND_API.G_MISS_NUM
63 ,party_id NUMBER := FND_API.G_MISS_NUM
64 ,attr_value VARCHAR2(2000) := FND_API.G_MISS_CHAR
65 ,score VARCHAR2(30) := FND_API.G_MISS_CHAR
66 ,enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
67 ,entity_id NUMBER := FND_API.G_MISS_NUM
68 -- security_group_id NUMBER := FND_API.G_MISS_NUM
69
70 ,version NUMBER := FND_API.G_MISS_NUM
71 ,latest_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
72 ,attr_value_extn VARCHAR2(4000) := FND_API.G_MISS_CHAR
73 ,validation_id NUMBER := FND_API.G_MISS_NUM
74
75 );
76
77 g_miss_enty_attr_val_rec enty_attr_val_rec_type;
78 TYPE enty_attr_value_tbl_type IS TABLE OF enty_attr_val_rec_type INDEX BY BINARY_INTEGER;
79 g_miss_enty_attr_value_tbl enty_attr_value_tbl_type;
80
81 -- ==============================================================================
82 -- Start of Comments
83 -- ==============================================================================
84 -- API Name
85 -- Create_Attr_Value
86 -- Type
87 -- Private
88 -- Pre-Req
89 --
90 -- Parameters
91 --
92 -- IN
93 -- p_api_version_number IN NUMBER Required
94 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
95 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
96 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
97 -- p_enty_attr_val_rec IN enty_attr_val_rec_type Required
98 --
99 -- OUT
100 -- x_return_status OUT VARCHAR2
101 -- x_msg_count OUT NUMBER
102 -- x_msg_data OUT VARCHAR2
103 -- Version : Current version 1.0
104 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
105 -- and basic operation, developer must manually add parameters and business logic as necessary.
106 --
107 -- End of Comments
108 -- ==============================================================================
109 --
110
111 PROCEDURE Create_Attr_Value(
112 p_api_version_number IN NUMBER
113 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
114 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
115 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
116
117 ,x_return_status OUT NOCOPY VARCHAR2
118 ,x_msg_count OUT NOCOPY NUMBER
119 ,x_msg_data OUT NOCOPY VARCHAR2
120
121 ,p_enty_attr_val_rec IN enty_attr_val_rec_type := g_miss_enty_attr_val_rec
122 ,x_enty_attr_val_id OUT NOCOPY NUMBER
123 );
124
125 -- ==============================================================================
126 -- Start of Comments
127 -- ==============================================================================
128 -- API Name
129 -- Update_Attr_Value
130 -- Type
131 -- Private
132 -- Pre-Req
133 --
134 -- Parameters
135 --
136 -- IN
137 -- p_api_version_number IN NUMBER Required
138 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
139 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
140 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
141 -- p_enty_attr_val_rec IN enty_attr_val_rec_type Required
142 --
143 -- OUT
144 -- x_return_status OUT VARCHAR2
145 -- x_msg_count OUT NUMBER
146 -- x_msg_data OUT VARCHAR2
147 -- Version : Current version 1.0
148 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
149 -- and basic operation, developer must manually add parameters and business logic as necessary.
150 --
151 -- End of Comments
152 -- ==============================================================================
153 --
154
155 PROCEDURE Update_Attr_Value(
156 p_api_version_number IN NUMBER
157 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
158 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
159 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
160
161 ,x_return_status OUT NOCOPY VARCHAR2
162 ,x_msg_count OUT NOCOPY NUMBER
163 ,x_msg_data OUT NOCOPY VARCHAR2
164
165 ,p_enty_attr_val_rec IN enty_attr_val_rec_type
166 ,x_object_version_number OUT NOCOPY NUMBER
167 );
168
169 -- ==============================================================================
170 -- Start of Comments
171 -- ==============================================================================
172 -- API Name
173 -- Delete_Attr_Value
174 -- Type
175 -- Private
176 -- Pre-Req
177 --
178 -- Parameters
179 --
180 -- IN
181 -- p_api_version_number IN NUMBER Required
182 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
183 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
184 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
185 -- p_ENTY_ATTR_VAL_ID IN NUMBER
186 -- p_object_version_number IN NUMBER Optional Default = NULL
187 --
188 -- OUT
189 -- x_return_status OUT VARCHAR2
190 -- x_msg_count OUT NUMBER
191 -- x_msg_data OUT VARCHAR2
192 -- Version : Current version 1.0
193 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
194 -- and basic operation, developer must manually add parameters and business logic as necessary.
195 --
196 -- End of Comments
197 -- ==============================================================================
198 --
199
200 PROCEDURE Delete_Attr_Value(
201 p_api_version_number IN NUMBER
202 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
203 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
204 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
205
206 ,x_return_status OUT NOCOPY VARCHAR2
207 ,x_msg_count OUT NOCOPY NUMBER
208 ,x_msg_data OUT NOCOPY VARCHAR2
209
210 ,p_enty_attr_val_id IN NUMBER
211 ,p_object_version_number IN NUMBER
212 );
213
214 -- ==============================================================================
215 -- Start of Comments
216 -- ==============================================================================
217 -- API Name
218 -- Lock_Attr_Value
219 -- Type
220 -- Private
221 -- Pre-Req
222 --
223 -- Parameters
224 --
225 -- IN
226 -- p_api_version_number IN NUMBER Required
227 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
228 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
229 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
230 -- p_enty_attr_val_rec IN enty_attr_val_rec_type Required
231 --
232 -- OUT
233 -- x_return_status OUT VARCHAR2
234 -- x_msg_count OUT NUMBER
235 -- x_msg_data OUT VARCHAR2
236 -- Version : Current version 1.0
237 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
238 -- and basic operation, developer must manually add parameters and business logic as necessary.
239 --
240 -- End of Comments
241 -- ==============================================================================
242 --
243
244 PROCEDURE Lock_Attr_Value(
245 p_api_version_number IN NUMBER
246 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
247
248 ,x_return_status OUT NOCOPY VARCHAR2
249 ,x_msg_count OUT NOCOPY NUMBER
250 ,x_msg_data OUT NOCOPY VARCHAR2
251
252 ,p_enty_attr_val_id IN NUMBER
253 ,p_object_version IN NUMBER
254 );
255
256 -- ===============================================================================
257 -- Start of Comments
258 -- ===============================================================================
259 --
260 -- validation procedures
261 --
262 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
263 -- For create: G_CREATE, for update: G_UPDATE
264 -- Note: 1. This is automated generated item level validation procedure.
265 -- The actual validation detail is needed to be added.
266 -- 2. We can also validate table instead of record. There will be an option for user to choose.
267 -- End of Comments
268 -- ===============================================================================
269
270 PROCEDURE Validate_attr_value(
271 p_api_version_number IN NUMBER
272 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
273 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
274 ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_UPDATE
275 ,p_enty_attr_val_rec IN enty_attr_val_rec_type
276
277 ,x_return_status OUT NOCOPY VARCHAR2
278 ,x_msg_count OUT NOCOPY NUMBER
279 ,x_msg_data OUT NOCOPY VARCHAR2
280 );
281
282 -- ===============================================================================
283 -- Start of Comments
284 -- ===============================================================================
285 --
286 -- validation procedures
287 --
288 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
289 -- For create: G_CREATE, for update: G_UPDATE
290 -- Note: 1. This is automated generated item level validation procedure.
291 -- The actual validation detail is needed to be added.
292 -- 2. Validate the unique keys, lookups here
293 -- End of Comments
294 -- ===============================================================================
295
296 PROCEDURE Check_attr_value_Items (
297 p_enty_attr_val_rec IN enty_attr_val_rec_type
298 ,p_validation_mode IN VARCHAR2
299
300 ,x_return_status OUT NOCOPY VARCHAR2
301 );
302
303 -- ===============================================================================
304 -- Start of Comments
305 -- ===============================================================================
306 --
307 -- Record level validation procedures
308 --
309 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
310 -- For create: G_CREATE, for update: G_UPDATE
311 -- Note: 1. This is automated generated item level validation procedure.
312 -- The actual validation detail is needed to be added.
313 -- 2. Developer can manually added inter-field level validation.
314 -- End of Comments
315 -- ===============================================================================
316
317 PROCEDURE Validate_attr_val_rec(
318 p_api_version_number IN NUMBER
319 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
320
321 ,x_return_status OUT NOCOPY VARCHAR2
322 ,x_msg_count OUT NOCOPY NUMBER
323 ,x_msg_data OUT NOCOPY VARCHAR2
324
325 ,p_enty_attr_val_rec IN enty_attr_val_rec_type
326 ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_UPDATE
327 );
328
329 END PV_Enty_Attr_Value_PVT;