APPS.HXT_AAI dependencies on HXT_ADD_ASSIGN_INFO_F

Line 54: from hxt_add_assign_info_f

50: p_attribute30 VARCHAR2
51: ) is
52:
53: cursor c2 is select rowid
54: from hxt_add_assign_info_f
55: where effective_start_date = p_effective_start_date
56: and effective_end_date = p_effective_end_date
57: and id = p_id;
58:

Line 61: insert into HXT_ADD_ASSIGN_INFO_F(

57: and id = p_id;
58:
59: begin
60:
61: insert into HXT_ADD_ASSIGN_INFO_F(
62: id,
63: effective_start_date,
64: effective_end_date,
65: assignment_id,

Line 213: update HXT_ADD_ASSIGN_INFO_F

209: ) is
210:
211: begin
212:
213: update HXT_ADD_ASSIGN_INFO_F
214: set
215: effective_start_date = p_effective_start_date,
216: effective_end_date = p_effective_end_date,
217: assignment_id = p_assignment_id,

Line 266: delete from HXT_ADD_ASSIGN_INFO_F

262:
263:
264: procedure delete_HXT_ADD_ASSIGN_INFO(p_rowid VARCHAR2) is
265: begin
266: delete from HXT_ADD_ASSIGN_INFO_F
267: where rowid = chartorowid(p_rowid);
268: end delete_HXT_ADD_ASSIGN_INFO;
269:
270: procedure lock_HXT_ADD_ASSIGN_INFO(p_rowid VARCHAR2) is

Line 275: from hxt_add_assign_info_f

271: vnull number;
272: begin
273: if p_rowid is not null then
274: select ASSIGNMENT_ID into vnull
275: from hxt_add_assign_info_f
276: where rowid = p_rowid
277: for update of hxt_add_assign_info_f.ASSIGNMENT_ID nowait;
278:
279: end if;

Line 277: for update of hxt_add_assign_info_f.ASSIGNMENT_ID nowait;

273: if p_rowid is not null then
274: select ASSIGNMENT_ID into vnull
275: from hxt_add_assign_info_f
276: where rowid = p_rowid
277: for update of hxt_add_assign_info_f.ASSIGNMENT_ID nowait;
278:
279: end if;
280: end lock_HXT_ADD_ASSIGN_INFO;
281: