APPS.HXT_AEI dependencies on HXT_ADD_ELEM_INFO_F

Line 58: from hxt_add_elem_info_f

54: p_exclude_from_explosion VARCHAR2 /* Bug: 4489952 */
55: ) is
56:
57: cursor c2 is select rowid
58: from hxt_add_elem_info_f
59: where effective_start_date = p_effective_start_date
60: and effective_end_date = p_effective_end_date
61: and id = p_id;
62:

Line 65: insert into HXT_ADD_ELEM_INFO_F(

61: and id = p_id;
62:
63: begin
64:
65: insert into HXT_ADD_ELEM_INFO_F(
66: id,
67: effective_start_date,
68: effective_end_date,
69: element_type_id,

Line 231: update HXT_ADD_ELEM_INFO_F

227: ) is
228:
229: begin
230:
231: update HXT_ADD_ELEM_INFO_F
232: set
233: effective_start_date = p_effective_start_date,
234: effective_end_date = p_effective_end_date,
235: element_type_id = p_element_type_id,

Line 288: delete from HXT_ADD_ELEM_INFO_F

284:
285:
286: procedure delete_HXT_ADD_ELEM_INFO(p_rowid VARCHAR2) is
287: begin
288: delete from HXT_ADD_ELEM_INFO_F
289: where rowid = chartorowid(p_rowid);
290: end delete_HXT_ADD_ELEM_INFO;
291:
292: procedure lock_HXT_ADD_ELEM_INFO(p_rowid VARCHAR2) is

Line 297: from hxt_add_elem_info_f

293: vnull number;
294: begin
295: if p_rowid is not null then
296: select ELEMENT_TYPE_ID into vnull
297: from hxt_add_elem_info_f
298: where rowid = p_rowid
299: for update of hxt_add_elem_info_f.ELEMENT_TYPE_ID nowait;
300:
301: end if;

Line 299: for update of hxt_add_elem_info_f.ELEMENT_TYPE_ID nowait;

295: if p_rowid is not null then
296: select ELEMENT_TYPE_ID into vnull
297: from hxt_add_elem_info_f
298: where rowid = p_rowid
299: for update of hxt_add_elem_info_f.ELEMENT_TYPE_ID nowait;
300:
301: end if;
302: end lock_HXT_ADD_ELEM_INFO;
303: