[Home] [Help]
PACKAGE BODY: APPS.PV_ENTY_ATTR_VALUES_PKG
Source
1 PACKAGE BODY PV_ENTY_ATTR_VALUES_PKG as
2 /* $Header: pvxteavb.pls 115.3 2002/12/10 19:41:57 amaram ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- PV_ENTY_ATTR_VALUES_PKG
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15
16 G_PKG_NAME CONSTANT VARCHAR2(30) := 'PV_ENTY_ATTR_VALUES_PKG';
17 G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvxteavb.pls';
18
19 ----------------------------------------------------------
20 ---- MEDIA ----
21 ----------------------------------------------------------
22
23 -- ========================================================
24 --
25 -- NAME
26 -- createInsertBody
27 --
28 -- PURPOSE
29 --
30 -- NOTES
31 --
32 -- HISTORY
33 --
34 -- ========================================================
35 PROCEDURE Insert_Row(
36 px_enty_attr_val_id IN OUT NOCOPY NUMBER
37 ,p_last_update_date DATE
38 ,p_last_updated_by NUMBER
39 ,p_creation_date DATE
40 ,p_created_by NUMBER
41 ,p_last_update_login NUMBER
42 ,px_object_version_number IN OUT NOCOPY NUMBER
43 ,p_entity VARCHAR2
44 ,p_attribute_id NUMBER
45 ,p_party_id NUMBER
46 ,p_attr_value VARCHAR2
47 ,p_score VARCHAR2
48 ,p_enabled_flag VARCHAR2
49 ,p_entity_id NUMBER
50 -- p_security_group_id NUMBER
51 ,p_version NUMBER
52 ,p_latest_flag VARCHAR2
53 ,p_attr_value_extn VARCHAR2
54 ,p_validation_id NUMBER
55 )
56
57 IS
58 x_rowid VARCHAR2(30);
59
60 BEGIN
61
62 px_object_version_number := 1;
63
64 INSERT INTO PV_ENTY_ATTR_VALUES(
65 enty_attr_val_id
66 ,last_update_date
67 ,last_updated_by
68 ,creation_date
69 ,created_by
70 ,last_update_login
71 ,object_version_number
72 ,entity
73 ,attribute_id
74 ,party_id
75 ,attr_value
76 ,score
77 ,enabled_flag
78 ,entity_id
79 -- security_group_id
80 ,version
81 ,latest_flag
82 ,attr_value_extn
83 ,validation_id
84 ) VALUES (
85 DECODE( px_enty_attr_val_id, FND_API.g_miss_num, NULL, px_enty_attr_val_id)
86 ,DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date)
87 ,DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by)
88 ,DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date)
89 ,DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by)
90 ,DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)
91 ,DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number)
92 ,DECODE( p_entity, FND_API.g_miss_char, NULL, p_entity)
93 ,DECODE( p_attribute_id, FND_API.g_miss_num, NULL, p_attribute_id)
94 ,DECODE( p_party_id, FND_API.g_miss_num, NULL, p_party_id)
95 ,DECODE( p_attr_value, FND_API.g_miss_char, NULL, p_attr_value)
96 ,DECODE( p_score, FND_API.g_miss_char, NULL, p_score)
97 ,DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag)
98 ,DECODE( p_entity_id, FND_API.g_miss_num, NULL, p_entity_id)
99 -- DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id)
100 ,DECODE( p_version, FND_API.g_miss_num, NULL, p_version)
101 ,DECODE( p_latest_flag, FND_API.g_miss_char, NULL, p_latest_flag)
102 ,DECODE( p_attr_value_extn, FND_API.g_miss_char, NULL, p_attr_value_extn)
103 ,DECODE( p_validation_id, FND_API.g_miss_num, NULL, p_validation_id)
104 );
105 END Insert_Row;
106
107
108 ----------------------------------------------------------
109 ---- MEDIA ----
110 ----------------------------------------------------------
111
112 -- ========================================================
113 --
114 -- NAME
115 -- createUpdateBody
116 --
117 -- PURPOSE
118 --
119 -- NOTES
120 --
121 -- HISTORY
122 --
123 -- ========================================================
124 PROCEDURE Update_Row(
125 p_enty_attr_val_id NUMBER
126 ,p_last_update_date DATE
127 ,p_last_updated_by NUMBER
128 -- p_creation_date DATE
129 -- p_created_by NUMBER
130 ,p_last_update_login NUMBER
131 ,p_object_version_number NUMBER
132 ,p_entity VARCHAR2
133 ,p_attribute_id NUMBER
134 ,p_party_id NUMBER
135 ,p_attr_value VARCHAR2
136 ,p_score VARCHAR2
137 ,p_enabled_flag VARCHAR2
138 ,p_entity_id NUMBER
139 -- p_security_group_id NUMBER
140 ,p_version NUMBER
141 ,p_latest_flag VARCHAR2
142 ,p_attr_value_extn VARCHAR2
143 ,p_validation_id NUMBER
144 )
145
146 IS
147
148 BEGIN
149 Update PV_ENTY_ATTR_VALUES
150 SET
151 enty_attr_val_id = DECODE( p_enty_attr_val_id, FND_API.g_miss_num, enty_attr_val_id, p_enty_attr_val_id)
152 ,last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date)
153 ,last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by)
154 -- creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date)
155 -- created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by)
156 ,last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login)
157 ,object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number
158 ,p_object_version_number+1)
159 ,entity = DECODE( p_entity, FND_API.g_miss_char, entity, p_entity)
160 ,attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id)
161 ,party_id = DECODE( p_party_id, FND_API.g_miss_num, party_id, p_party_id)
162 ,attr_value = DECODE( p_attr_value, FND_API.g_miss_char, attr_value, p_attr_value)
163 ,score = DECODE( p_score, FND_API.g_miss_char, score, p_score)
164 ,enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag)
165 ,entity_id = DECODE( p_entity_id, FND_API.g_miss_num, entity_id, p_entity_id)
166 -- security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)
167
168 ,version = DECODE( p_version, FND_API.g_miss_num, version, p_version)
169 ,latest_flag = DECODE( p_latest_flag, FND_API.g_miss_char, latest_flag, p_latest_flag)
170 ,attr_value_extn = DECODE( p_attr_value_extn, FND_API.g_miss_char, attr_value_extn, p_attr_value_extn)
171 ,validation_id = DECODE( p_validation_id, FND_API.g_miss_num, validation_id, p_validation_id)
172 WHERE ENTY_ATTR_VAL_ID = p_ENTY_ATTR_VAL_ID
173 AND object_version_number = p_object_version_number;
174
175 IF (SQL%NOTFOUND) THEN
176 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
177 END IF;
178 END Update_Row;
179
180
181 ----------------------------------------------------------
182 ---- MEDIA ----
183 ----------------------------------------------------------
184
185 -- ========================================================
186 --
187 -- NAME
188 -- createDeleteBody
189 --
190 -- PURPOSE
191 --
192 -- NOTES
193 --
194 -- HISTORY
195 --
196 -- ========================================================
197 PROCEDURE Delete_Row(
198 p_ENTY_ATTR_VAL_ID NUMBER)
199 IS
200 BEGIN
201 DELETE FROM PV_ENTY_ATTR_VALUES
202 WHERE ENTY_ATTR_VAL_ID = p_ENTY_ATTR_VAL_ID;
203 IF (SQL%NOTFOUND) THEN
204 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
205 END IF;
206 END Delete_Row ;
207
208
209 ----------------------------------------------------------
210 ---- MEDIA ----
211 ----------------------------------------------------------
212
213 -- ========================================================
214 --
215 -- NAME
216 -- createLockBody
217 --
218 -- PURPOSE
219 --
220 -- NOTES
221 --
222 -- HISTORY
223 --
224 -- ========================================================
225 PROCEDURE Lock_Row(
226 p_enty_attr_val_id NUMBER
227 ,p_last_update_date DATE
228 ,p_last_updated_by NUMBER
229 ,p_creation_date DATE
230 ,p_created_by NUMBER
231 ,p_last_update_login NUMBER
232 ,p_object_version_number NUMBER
233 ,p_entity VARCHAR2
234 ,p_attribute_id NUMBER
235 ,p_party_id NUMBER
236 ,p_attr_value VARCHAR2
237 ,p_score VARCHAR2
238 ,p_enabled_flag VARCHAR2
239 ,p_entity_id NUMBER
240 -- p_security_group_id NUMBER
241 ,p_version NUMBER
242 ,p_latest_flag VARCHAR2
243 ,p_attr_value_extn VARCHAR2
244 ,p_validation_id NUMBER
245 )
246
247 IS
248 CURSOR C IS
249 SELECT *
250 FROM PV_ENTY_ATTR_VALUES
251 WHERE ENTY_ATTR_VAL_ID = p_ENTY_ATTR_VAL_ID
252 FOR UPDATE of ENTY_ATTR_VAL_ID NOWAIT;
253 Recinfo C%ROWTYPE;
254
255 BEGIN
256 OPEN c;
257 FETCH c INTO Recinfo;
258 IF (c%NOTFOUND) THEN
259 CLOSE c;
260 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
261 APP_EXCEPTION.RAISE_EXCEPTION;
262 END IF;
263 CLOSE C;
264 IF (
265 ( Recinfo.enty_attr_val_id = p_enty_attr_val_id)
266 AND ( ( Recinfo.last_update_date = p_last_update_date)
267 OR ( ( Recinfo.last_update_date IS NULL )
268 AND ( p_last_update_date IS NULL )))
269 AND ( ( Recinfo.last_updated_by = p_last_updated_by)
270 OR ( ( Recinfo.last_updated_by IS NULL )
271 AND ( p_last_updated_by IS NULL )))
272 AND ( ( Recinfo.creation_date = p_creation_date)
273 OR ( ( Recinfo.creation_date IS NULL )
274 AND ( p_creation_date IS NULL )))
275 AND ( ( Recinfo.created_by = p_created_by)
276 OR ( ( Recinfo.created_by IS NULL )
277 AND ( p_created_by IS NULL )))
278 AND ( ( Recinfo.last_update_login = p_last_update_login)
279 OR ( ( Recinfo.last_update_login IS NULL )
280 AND ( p_last_update_login IS NULL )))
281 AND ( ( Recinfo.object_version_number = p_object_version_number)
282 OR ( ( Recinfo.object_version_number IS NULL )
283 AND ( p_object_version_number IS NULL )))
284 AND ( ( Recinfo.entity = p_entity)
285 OR ( ( Recinfo.entity IS NULL )
286 AND ( p_entity IS NULL )))
287 AND ( ( Recinfo.attribute_id = p_attribute_id)
288 OR ( ( Recinfo.attribute_id IS NULL )
289 AND ( p_attribute_id IS NULL )))
290 AND ( ( Recinfo.party_id = p_party_id)
291 OR ( ( Recinfo.party_id IS NULL )
292 AND ( p_party_id IS NULL )))
293 AND ( ( Recinfo.attr_value = p_attr_value)
294 OR ( ( Recinfo.attr_value IS NULL )
295 AND ( p_attr_value IS NULL )))
296 AND ( ( Recinfo.score = p_score)
297 OR ( ( Recinfo.score IS NULL )
298 AND ( p_score IS NULL )))
299 AND ( ( Recinfo.enabled_flag = p_enabled_flag)
300 OR ( ( Recinfo.enabled_flag IS NULL )
301 AND ( p_enabled_flag IS NULL )))
302 AND ( ( Recinfo.entity_id = p_entity_id)
303 OR ( ( Recinfo.entity_id IS NULL )
304 AND ( p_entity_id IS NULL )))
305
306 AND ( ( Recinfo.version = p_version)
307 OR ( ( Recinfo.version IS NULL )
308 AND ( p_version IS NULL )))
309 AND ( ( Recinfo.latest_flag = p_latest_flag)
310 OR ( ( Recinfo.latest_flag IS NULL )
311 AND ( p_latest_flag IS NULL )))
312 AND ( ( Recinfo.attr_value_extn = p_attr_value_extn)
313 OR ( ( Recinfo.attr_value_extn IS NULL )
314 AND ( p_attr_value_extn IS NULL )))
315 AND ( ( Recinfo.validation_id = p_validation_id)
316 OR ( ( Recinfo.validation_id IS NULL )
317 AND ( p_validation_id IS NULL )))
318
319
320
321
322
323 /*
324 AND ( ( Recinfo.security_group_id = p_security_group_id)
325 OR ( ( Recinfo.security_group_id IS NULL )
326 AND ( p_security_group_id IS NULL )))
327 */
328 ) THEN
329 RETURN;
330 ELSE
331 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
332 APP_EXCEPTION.RAISE_EXCEPTION;
333 END IF;
334 END Lock_Row;
335
336 END PV_ENTY_ATTR_VALUES_PKG;