APPS.PV_ENTITY_ATTRS_PKG dependencies on PV_ENTITY_ATTRS

Line 1: package body PV_ENTITY_ATTRS_PKG as

1: package body PV_ENTITY_ATTRS_PKG as
2: /* $Header: pvxteatb.pls 120.3 2011/03/25 21:33:03 hekkiral ship $ */
3: procedure INSERT_ROW(
4: px_entity_attr_id IN OUT NOCOPY NUMBER,
5: px_object_version_number IN OUT NOCOPY NUMBER,

Line 30: insert into PV_ENTITY_ATTRS (

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,

Line 121: from PV_ENTITY_ATTRS

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:

Line 199: update PV_ENTITY_ATTRS set

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 ),

Line 254: from pv_entity_attrs

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:

Line 333: update PV_ENTITY_ATTRS set

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 ),

Line 388: from pv_entity_attrs

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'

Line 393: 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:

Line 474: delete from PV_ENTITY_ATTRS

470: )
471: IS
472: begin
473:
474: delete from PV_ENTITY_ATTRS
475: where ENTITY_ATTR_ID = p_ENTITY_ATTR_ID;
476:
477: IF (SQL%NOTFOUND) THEN
478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 484: end PV_ENTITY_ATTRS_PKG;

480: end DELETE_ROW;
481:
482:
483:
484: end PV_ENTITY_ATTRS_PKG;