[Home] [Help]
PACKAGE BODY: APPS.PV_ENTITY_ATTRS_PKG
Source
1 package body PV_ENTITY_ATTRS_PKG as
2 /* $Header: pvxteatb.pls 120.2 2005/08/23 01:43:22 appldev ship $ */
3 procedure INSERT_ROW(
4 px_entity_attr_id IN OUT NOCOPY NUMBER,
5 px_object_version_number IN OUT NOCOPY NUMBER,
6 p_batch_sql_text IN VARCHAR2,
7 p_refresh_frequency IN NUMBER,
8 p_refresh_frequency_uom IN VARCHAR2,
9 p_last_refresh_date IN DATE,
10 p_display_external_value_flag IN VARCHAR2,
11 p_lov_string IN VARCHAR2,
12 p_enabled_flag IN VARCHAR2,
13 p_display_flag IN VARCHAR2,
14 p_locator_flag IN VARCHAR2,
15 p_entity_type IN VARCHAR2,
16 p_require_validation_flag IN VARCHAR2,
17 p_external_update_text IN VARCHAR2,
18 p_attribute_id IN NUMBER,
19 p_entity IN VARCHAR2,
20 p_sql_text IN VARCHAR2,
21 p_attr_data_type IN VARCHAR2,
22 p_creation_date IN DATE,
23 p_created_by IN NUMBER,
24 p_last_update_date IN DATE,
25 p_last_updated_by IN NUMBER,
26 p_last_update_login IN NUMBER)
27 IS
28
29 BEGIN
30 insert into PV_ENTITY_ATTRS (
31 entity_attr_id,
32 batch_sql_text,
33 refresh_frequency,
34 refresh_frequency_uom,
35 last_refresh_date,
36 display_external_value_flag,
37 lov_string,
38 enabled_flag,
39 display_flag,
40 locator_flag,
41 entity_type,
42 require_validation_flag,
43 external_update_text,
44 object_version_number,
45 attribute_id,
46 entity,
47 sql_text,
48 attr_data_type,
49 creation_date,
50 created_by,
51 last_update_date,
52 last_updated_by,
53 last_update_login
54 ) VALUES (
55 DECODE ( px_entity_attr_id,FND_API.g_miss_num,NULL,px_entity_attr_id),
56 DECODE ( p_batch_sql_text,FND_API.g_miss_char,NULL,p_batch_sql_text ),
57 DECODE ( p_refresh_frequency,FND_API.g_miss_char,NULL,p_refresh_frequency ),
58 DECODE ( p_refresh_frequency_uom,FND_API.g_miss_char,NULL,p_refresh_frequency_uom ),
59 DECODE ( p_last_refresh_date,FND_API.g_miss_date,NULL,p_last_refresh_date ),
60 DECODE ( p_display_external_value_flag,FND_API.g_miss_char,NULL,p_display_external_value_flag ),
61 DECODE ( p_lov_string,FND_API.g_miss_char,NULL,p_lov_string ),
62 DECODE ( p_enabled_flag,FND_API.g_miss_char,NULL,p_enabled_flag ),
63 DECODE ( p_display_flag,FND_API.g_miss_char,NULL,p_display_flag ),
64 DECODE ( p_locator_flag,FND_API.g_miss_char,NULL,p_locator_flag ),
65 DECODE ( p_entity_type,FND_API.g_miss_char,NULL,p_entity_type ),
66 DECODE ( p_require_validation_flag,FND_API.g_miss_char,NULL,p_require_validation_flag ),
67 DECODE ( p_external_update_text,FND_API.g_miss_char,NULL,p_external_update_text ),
68 DECODE ( px_object_version_number,FND_API.g_miss_num,NULL,px_object_version_number ),
69 DECODE ( p_attribute_id,FND_API.g_miss_num,NULL,p_attribute_id ),
70 DECODE ( p_entity,FND_API.g_miss_char,NULL,p_entity ),
71 DECODE ( p_sql_text,FND_API.g_miss_char,NULL,p_sql_text ),
72 DECODE ( p_attr_data_type,FND_API.g_miss_char,NULL,p_attr_data_type ),
73 DECODE ( p_creation_date,FND_API.g_miss_date,NULL,p_creation_date ),
74 DECODE ( p_created_by,FND_API.g_miss_num,NULL,p_created_by ),
75 DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date ),
76 DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by ),
77 DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login));
78
79
80
81 end INSERT_ROW;
82
83 procedure LOCK_ROW (
84 p_entity_attr_id IN NUMBER,
85 p_batch_sql_text IN VARCHAR2,
86 p_refresh_frequency IN NUMBER,
87 p_refresh_frequency_uom IN VARCHAR2,
88 p_last_refresh_date IN DATE,
89 p_display_external_value_flag IN VARCHAR2,
90 p_lov_string IN VARCHAR2,
91 p_enabled_flag IN VARCHAR2,
92 p_display_flag IN VARCHAR2,
93 p_locator_flag IN VARCHAR2,
94 p_entity_type IN VARCHAR2,
95 p_require_validation_flag IN VARCHAR2,
96 p_external_update_text IN VARCHAR2,
97 p_object_version_number IN NUMBER,
98 p_attribute_id IN NUMBER,
99 p_entity IN VARCHAR2,
100 p_sql_text IN VARCHAR2,
101 p_attr_data_type IN VARCHAR2
102 ) IS
103 cursor c is select
104 BATCH_SQL_TEXT,
105 REFRESH_FREQUENCY,
106 REFRESH_FREQUENCY_UOM,
107 LAST_REFRESH_DATE,
108 DISPLAY_EXTERNAL_VALUE_FLAG,
109 LOV_STRING,
110 ENABLED_FLAG,
111 DISPLAY_FLAG,
112 LOCATOR_FLAG,
113 ENTITY_TYPE,
114 REQUIRE_VALIDATION_FLAG,
115 EXTERNAL_UPDATE_TEXT,
116 OBJECT_VERSION_NUMBER,
117 ATTRIBUTE_ID,
118 ENTITY,
119 SQL_TEXT,
120 ATTR_DATA_TYPE
121 from PV_ENTITY_ATTRS
122 where ENTITY_ATTR_ID = p_ENTITY_ATTR_ID
123 for update of ENTITY_ATTR_ID nowait;
124 recinfo c%rowtype;
125
126
127 begin
128 open c;
129 fetch c into recinfo;
130 if (c%notfound) then
131 close c;
132 fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
133 app_exception.raise_exception;
134 end if;
135 close c;
136 if ( ((recinfo.BATCH_SQL_TEXT = p_BATCH_SQL_TEXT)
137 OR ((recinfo.BATCH_SQL_TEXT is null) AND (p_BATCH_SQL_TEXT is null)))
138 AND ((recinfo.REFRESH_FREQUENCY = p_REFRESH_FREQUENCY)
139 OR ((recinfo.REFRESH_FREQUENCY is null) AND (p_REFRESH_FREQUENCY is null)))
140 AND ((recinfo.REFRESH_FREQUENCY_UOM = p_REFRESH_FREQUENCY_UOM)
141 OR ((recinfo.REFRESH_FREQUENCY_UOM is null) AND (p_REFRESH_FREQUENCY_UOM is null)))
142 AND ((recinfo.LAST_REFRESH_DATE = p_LAST_REFRESH_DATE)
143 OR ((recinfo.LAST_REFRESH_DATE is null) AND (p_LAST_REFRESH_DATE is null)))
144 AND ((recinfo.DISPLAY_EXTERNAL_VALUE_FLAG = p_DISPLAY_EXTERNAL_VALUE_FLAG)
145 OR ((recinfo.DISPLAY_EXTERNAL_VALUE_FLAG is null) AND (p_DISPLAY_EXTERNAL_VALUE_FLAG is null)))
146 AND ((recinfo.LOV_STRING = p_LOV_STRING)
147 OR ((recinfo.LOV_STRING is null) AND (p_LOV_STRING is null)))
148 AND (recinfo.ENABLED_FLAG = p_ENABLED_FLAG)
149 AND (recinfo.DISPLAY_FLAG = p_DISPLAY_FLAG)
150 AND ((recinfo.LOCATOR_FLAG = p_LOCATOR_FLAG)
151 OR ((recinfo.LOCATOR_FLAG is null) AND (p_LOCATOR_FLAG is null)))
152 AND ((recinfo.ENTITY_TYPE = p_ENTITY_TYPE)
153 OR ((recinfo.ENTITY_TYPE is null) AND (p_ENTITY_TYPE is null)))
154 AND ((recinfo.REQUIRE_VALIDATION_FLAG = p_REQUIRE_VALIDATION_FLAG)
155 OR ((recinfo.REQUIRE_VALIDATION_FLAG is null) AND (p_REQUIRE_VALIDATION_FLAG is null)))
156 AND ((recinfo.EXTERNAL_UPDATE_TEXT = p_EXTERNAL_UPDATE_TEXT)
157 OR ((recinfo.EXTERNAL_UPDATE_TEXT is null) AND (p_EXTERNAL_UPDATE_TEXT is null)))
158 AND (recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER)
159 AND (recinfo.ATTRIBUTE_ID = p_ATTRIBUTE_ID)
160 AND (recinfo.ENTITY = p_ENTITY)
161 AND ((recinfo.SQL_TEXT = p_SQL_TEXT)
162 OR ((recinfo.SQL_TEXT is null) AND (p_SQL_TEXT is null)))
163 AND ((recinfo.ATTR_DATA_TYPE = p_ATTR_DATA_TYPE)
164 OR ((recinfo.ATTR_DATA_TYPE is null) AND (p_ATTR_DATA_TYPE is null)))
165 ) then
166 null;
167 else
168 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
169 app_exception.raise_exception;
170 end if;
171
172 return;
173 end LOCK_ROW;
174
175 procedure UPDATE_ROW (
176 p_entity_attr_id IN NUMBER,
177 p_batch_sql_text IN VARCHAR2,
178 p_refresh_frequency IN NUMBER,
179 p_refresh_frequency_uom IN VARCHAR2,
180 p_last_refresh_date IN DATE,
181 p_display_external_value_flag IN VARCHAR2,
182 p_lov_string IN VARCHAR2,
183 p_enabled_flag IN VARCHAR2,
184 p_display_flag IN VARCHAR2,
185 p_locator_flag IN VARCHAR2,
186 p_entity_type IN VARCHAR2,
187 p_require_validation_flag IN VARCHAR2,
188 p_external_update_text IN VARCHAR2,
189 p_object_version_number IN NUMBER,
190 p_attribute_id IN NUMBER,
191 p_entity IN VARCHAR2,
192 p_sql_text IN VARCHAR2,
193 p_attr_data_type IN VARCHAR2,
194 p_last_update_date IN DATE,
195 p_last_updated_by IN NUMBER,
196 p_last_update_login IN NUMBER
197 ) IS
198 begin
199 update PV_ENTITY_ATTRS set
200 batch_sql_text = DECODE ( p_batch_sql_text,FND_API.g_miss_char,NULL,p_batch_sql_text ),
201 refresh_frequency = DECODE ( p_refresh_frequency,FND_API.g_miss_char,NULL,p_refresh_frequency ),
202 refresh_frequency_uom = DECODE ( p_refresh_frequency_uom,FND_API.g_miss_char,NULL,p_refresh_frequency_uom ),
203 last_refresh_date = DECODE ( p_last_refresh_date,FND_API.g_miss_date,NULL,p_last_refresh_date ),
204 display_external_value_flag = DECODE ( p_display_external_value_flag,FND_API.g_miss_char,NULL,p_display_external_value_flag ),
205 lov_string = DECODE ( p_lov_string,FND_API.g_miss_char,NULL,p_lov_string ),
206 enabled_flag = DECODE ( p_enabled_flag,FND_API.g_miss_char,NULL,p_enabled_flag ),
207 display_flag = DECODE ( p_display_flag,FND_API.g_miss_char,NULL,p_display_flag ),
208 locator_flag = DECODE ( p_locator_flag,FND_API.g_miss_char,NULL,p_locator_flag ),
209 entity_type = DECODE ( p_entity_type,FND_API.g_miss_char,NULL,p_entity_type ),
210 require_validation_flag = DECODE ( p_require_validation_flag,FND_API.g_miss_char,NULL,p_require_validation_flag ),
211 external_update_text = DECODE ( p_external_update_text,FND_API.g_miss_char,NULL,p_external_update_text ),
212 object_version_number = DECODE ( p_object_version_number,FND_API.g_miss_num,NULL,p_object_version_number+1 ),
213 attribute_id = DECODE ( p_attribute_id,FND_API.g_miss_num,NULL,p_attribute_id ),
214 entity = DECODE ( p_entity,FND_API.g_miss_char,NULL,p_entity ),
215 sql_text = DECODE ( p_sql_text,FND_API.g_miss_char,NULL,p_sql_text ),
216 attr_data_type = DECODE ( p_attr_data_type,FND_API.g_miss_char,NULL,p_attr_data_type ),
217 last_update_date = DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date ),
218 last_updated_by = DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by ),
219 last_update_login = DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login)
220 WHERE entity_attr_id = p_entity_attr_id;
221
222 IF (SQL%NOTFOUND) THEN
223 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
224 END IF;
225
226 end UPDATE_ROW;
227
228 procedure UPDATE_SEED_ROW (
229 p_entity_attr_id IN NUMBER,
230 p_batch_sql_text IN VARCHAR2,
231 p_refresh_frequency IN NUMBER,
232 p_refresh_frequency_uom IN VARCHAR2,
233 p_last_refresh_date IN DATE,
234 p_display_external_value_flag IN VARCHAR2,
235 p_lov_string IN VARCHAR2,
236 p_enabled_flag IN VARCHAR2,
237 p_display_flag IN VARCHAR2,
238 p_locator_flag IN VARCHAR2,
239 p_entity_type IN VARCHAR2,
240 p_require_validation_flag IN VARCHAR2,
241 p_external_update_text IN VARCHAR2,
242 p_object_version_number IN NUMBER,
243 p_attribute_id IN NUMBER,
244 p_entity IN VARCHAR2,
245 p_sql_text IN VARCHAR2,
246 p_attr_data_type IN VARCHAR2,
247 p_last_update_date IN DATE,
248 p_last_updated_by IN NUMBER,
249 p_last_update_login IN NUMBER
250 )
251 IS
252 cursor c_updated_by is
253 select last_updated_by
254 from pv_entity_attrs
255 WHERE entity_attr_id = p_entity_attr_id;
256
257 l_last_updated_by number;
258
259 BEGIN
260 for x in c_updated_by
261 loop
262 l_last_updated_by := x.last_updated_by;
263 end loop;
264
265 -- Checking if some body updated seeded attribute codes other than SEED,
266 -- If other users updated it, We will not updated enabled_flag and description.
267 -- Else we will update enabled_flag and description
268
269 IF ( l_last_updated_by = 1) THEN
270 UPDATE_ROW (
271 p_entity_attr_id => p_entity_attr_id,
272 p_batch_sql_text => p_batch_sql_text,
273 p_refresh_frequency => p_refresh_frequency,
274 p_refresh_frequency_uom => p_refresh_frequency_uom,
275 p_last_refresh_date => p_last_refresh_date,
276 p_display_external_value_flag => p_display_external_value_flag ,
277 p_lov_string => p_lov_string,
278 p_enabled_flag => p_enabled_flag,
279 p_display_flag => p_display_flag,
280 p_locator_flag => p_locator_flag,
281 p_entity_type => p_entity_type,
282 p_require_validation_flag => p_require_validation_flag,
283 p_external_update_text => p_external_update_text,
284 p_object_version_number => p_object_version_number,
285 p_attribute_id => p_attribute_id,
286 p_entity => p_entity,
287 p_sql_text => p_sql_text,
288 p_attr_data_type => p_attr_data_type,
289 p_last_update_date => p_last_update_date,
290 p_last_updated_by => p_last_updated_by,
291 p_last_update_login => p_last_update_login);
292 ELSE
293 SEED_UPDATE_ROW (
294 p_entity_attr_id => p_entity_attr_id,
295 p_object_version_number => p_object_version_number,
296 p_attribute_id => p_attribute_id,
297 p_entity => p_entity,
298 p_sql_text => p_sql_text,
299 p_attr_data_type => p_attr_data_type,
300 p_lov_string => p_lov_string,
301 p_entity_type => p_entity_type,
302 p_enabled_flag => p_enabled_flag,
303 p_display_flag => p_display_flag,
304 p_external_update_text => p_external_update_text,
305 p_batch_sql_text => p_batch_sql_text,
306 p_display_external_value_flag => p_display_external_value_flag,
307 p_last_update_date => p_last_update_date,
308 p_last_updated_by => p_last_updated_by,
309 p_last_update_login => p_last_update_login);
310 END IF;
311
312 END;
313 procedure SEED_UPDATE_ROW (
314 p_entity_attr_id IN NUMBER,
315 p_object_version_number IN NUMBER,
316 p_attribute_id IN NUMBER,
317 p_entity IN VARCHAR2,
318 p_sql_text IN VARCHAR2,
319 p_attr_data_type IN VARCHAR2,
320 p_lov_string IN VARCHAR2,
321 p_entity_type IN VARCHAR2,
322 p_enabled_flag IN VARCHAR2,
323 p_display_flag IN VARCHAR2,
324 p_external_update_text IN VARCHAR2,
325 p_batch_sql_text IN VARCHAR2,
326 p_display_external_value_flag IN VARCHAR2,
327 p_last_update_date IN DATE,
328 p_last_updated_by IN NUMBER,
329 p_last_update_login IN NUMBER
330 )
331 IS
332 BEGIN
333 update PV_ENTITY_ATTRS set
334 attribute_id = DECODE ( p_attribute_id,FND_API.g_miss_num,NULL,p_attribute_id ),
335 entity = DECODE ( p_entity,FND_API.g_miss_char,NULL,p_entity ),
336 sql_text = DECODE ( p_sql_text,FND_API.g_miss_char,NULL,p_sql_text ),
337 attr_data_type = DECODE ( p_attr_data_type,FND_API.g_miss_char,NULL,p_attr_data_type ),
338 lov_string = DECODE ( p_lov_string,FND_API.g_miss_char,NULL,p_lov_string ),
339 entity_type = DECODE ( p_entity_type,FND_API.g_miss_char,NULL,p_entity_type ),
340 enabled_flag = DECODE ( p_enabled_flag,FND_API.g_miss_char,NULL,p_enabled_flag ),
341 display_flag = DECODE ( p_display_flag,FND_API.g_miss_char,NULL,p_display_flag ),
342 external_update_text = DECODE ( p_external_update_text,FND_API.g_miss_char,NULL,p_external_update_text ),
343 batch_sql_text = DECODE ( p_batch_sql_text,FND_API.g_miss_char,NULL,p_batch_sql_text ),
344 display_external_value_flag = DECODE ( p_display_external_value_flag,FND_API.g_miss_char,NULL,p_display_external_value_flag ),
345 object_version_number = DECODE ( p_object_version_number,FND_API.g_miss_num,NULL,p_object_version_number+1 ),
346 last_update_date = DECODE ( p_last_update_date,FND_API.g_miss_date,NULL,p_last_update_date ),
347 last_updated_by = DECODE ( p_last_updated_by,FND_API.g_miss_num,NULL,p_last_updated_by ),
348 last_update_login = DECODE ( p_last_update_login,FND_API.g_miss_num,NULL,p_last_update_login)
349 WHERE entity_attr_id = p_entity_attr_id;
350
351 IF (SQL%NOTFOUND) THEN
352 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
353 END IF;
354
355 END seed_update_row;
356
357 procedure LOAD_ROW (
358 p_upload_mode IN VARCHAR2,
359 p_entity_attr_id IN NUMBER,
360 p_object_version_number IN NUMBER,
361 p_attribute_id IN NUMBER,
362 p_entity IN VARCHAR2,
363 p_sql_text IN VARCHAR2,
364 p_attr_data_type IN VARCHAR2,
365 p_lov_string IN VARCHAR2,
366 p_locator_flag IN VARCHAR2,
367 p_entity_type IN VARCHAR2,
368 p_enabled_flag IN VARCHAR2,
369 p_display_flag IN VARCHAR2,
370 p_require_validation_flag IN VARCHAR2,
371 p_external_update_text IN VARCHAR2,
372 p_batch_sql_text IN VARCHAR2,
373 p_display_external_value_flag IN VARCHAR2,
374 p_refresh_frequency IN NUMBER,
375 p_refresh_frequency_uom IN VARCHAR2,
376 p_last_refresh_date IN DATE,
377 p_owner IN VARCHAR2
378 )
379 IS
380 l_user_id number := 0;
381 l_obj_verno number;
382 l_dummy_char varchar2(1);
383 l_row_id varchar2(100);
384 l_entity_attr_id number := p_entity_attr_id;
385
386 cursor c_obj_verno is
387 select object_version_number
388 from pv_entity_attrs
389 where entity_attr_id = p_entity_attr_id;
390
391 cursor c_chk_attrib_exists is
392 select 'x'
393 from pv_entity_attrs
394 where entity_attr_id = p_entity_attr_id;
395
396 BEGIN
397 if p_OWNER = 'SEED' then
398 l_user_id := 1;
399 else
400 l_user_id := 0;
401 end if;
402 IF p_upload_mode = 'NLS' THEN
403 NULL;
404 ELSE
405 open c_chk_attrib_exists;
406 fetch c_chk_attrib_exists into l_dummy_char;
407 if c_chk_attrib_exists%notfound
408 then
409 close c_chk_attrib_exists;
410 l_obj_verno := 1;
411
412 INSERT_ROW(
413 px_entity_attr_id => l_entity_attr_id,
414 px_object_version_number => l_obj_verno,
415 p_batch_sql_text => p_batch_sql_text,
416 p_refresh_frequency => p_refresh_frequency,
417 p_refresh_frequency_uom => p_refresh_frequency_uom,
418 p_last_refresh_date => p_last_refresh_date,
419 p_display_external_value_flag => p_display_external_value_flag,
420 p_lov_string => p_lov_string,
421 p_enabled_flag => p_enabled_flag,
422 p_display_flag => p_display_flag,
423 p_locator_flag => p_locator_flag,
424 p_entity_type => p_entity_type,
425 p_require_validation_flag => p_require_validation_flag,
426 p_external_update_text => p_external_update_text,
427 p_attribute_id => p_attribute_id,
428 p_entity => p_entity,
429 p_sql_text => p_sql_text,
430 p_attr_data_type => p_attr_data_type,
431 p_creation_date => sysdate,
432 p_created_by => l_user_id,
433 p_last_update_date => sysdate,
434 p_last_updated_by => l_user_id,
435 p_last_update_login => 0);
436
437 else
438 close c_chk_attrib_exists;
439 open c_obj_verno;
440 fetch c_obj_verno into l_obj_verno;
441 close c_obj_verno;
442
443 UPDATE_SEED_ROW(
444 p_entity_attr_id => l_entity_attr_id,
445 p_object_version_number => p_object_version_number,
446 p_batch_sql_text => p_batch_sql_text,
447 p_refresh_frequency => p_refresh_frequency,
448 p_refresh_frequency_uom => p_refresh_frequency_uom,
449 p_last_refresh_date => p_last_refresh_date,
450 p_display_external_value_flag => p_display_external_value_flag,
451 p_lov_string => p_lov_string,
452 p_enabled_flag => p_enabled_flag,
453 p_display_flag => p_display_flag,
454 p_locator_flag => p_locator_flag,
455 p_entity_type => p_entity_type,
456 p_require_validation_flag => p_require_validation_flag,
457 p_external_update_text => p_external_update_text,
458 p_attribute_id => p_attribute_id,
459 p_entity => p_entity,
460 p_sql_text => p_sql_text,
461 p_attr_data_type => p_attr_data_type,
462 p_last_update_date => sysdate,
463 p_last_updated_by => l_user_id,
464 p_last_update_login => 0);
465
466 END IF;
467 END IF;
468 END LOAD_ROW;
469
470 procedure DELETE_ROW (
471 p_entity_attr_id IN NUMBER
472 )
473 IS
474 begin
475
476 delete from PV_ENTITY_ATTRS
477 where ENTITY_ATTR_ID = p_ENTITY_ATTR_ID;
478
479 IF (SQL%NOTFOUND) THEN
480 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
481 END IF;
482 end DELETE_ROW;
483
484
485
486 end PV_ENTITY_ATTRS_PKG;