APPS.HXT_DML dependencies on HXT_SUM_HOURS_WORKED_F

Line 248: from hxt_sum_hours_worked_f

244: p_ZIP_CODE VARCHAR2 DEFAULT NULL
245: ) is
246:
247: cursor c2 is select rowid
248: from hxt_sum_hours_worked_f
249: where effective_start_date = p_effective_start_date
250: and effective_end_date = p_effective_end_date
251: and id = p_id;
252:

Line 257: insert into HXT_SUM_HOURS_WORKED_F(

253: begin
254:
255: p_object_version_number := 1;
256:
257: insert into HXT_SUM_HOURS_WORKED_F(
258: id,
259: -- group_id, --HXT11i1
260: tim_id,
261: date_worked,

Line 764: update HXT_SUM_HOURS_WORKED_F

760: begin
761:
762: p_object_version_number := p_object_version_number + 1;
763:
764: update HXT_SUM_HOURS_WORKED_F
765: set
766: -- group_id = p_group_id, --HXT11i1
767: date_worked = p_date_worked,
768: assignment_id = p_assignment_id,

Line 948: delete from HXT_SUM_HOURS_WORKED_F

944: end delete_HXT_TIMECARDS;
945:
946: procedure delete_HXT_SUM_HOURS_WORKED(p_rowid VARCHAR2) is
947: begin
948: delete from HXT_SUM_HOURS_WORKED_F
949: where rowid=chartorowid(p_rowid);
950: end delete_HXT_SUM_HOURS_WORKED;
951:
952: procedure delete_HXT_DET_HOURS_WORKED(p_rowid VARCHAR2) is

Line 976: from hxt_sum_hours_worked_f

972: vnull number;
973: begin
974: if p_rowid is not null then
975: select ASSIGNMENT_ID into vnull
976: from hxt_sum_hours_worked_f
977: where rowid = p_rowid
978: for update of hxt_sum_hours_worked_f.ASSIGNMENT_ID nowait;
979:
980: end if;

Line 978: for update of hxt_sum_hours_worked_f.ASSIGNMENT_ID nowait;

974: if p_rowid is not null then
975: select ASSIGNMENT_ID into vnull
976: from hxt_sum_hours_worked_f
977: where rowid = p_rowid
978: for update of hxt_sum_hours_worked_f.ASSIGNMENT_ID nowait;
979:
980: end if;
981: end lock_HXT_SUM_HOURS_WORKED;
982: