APPS.HXT_DML dependencies on HXT_SUM_HOURS_WORKED_F

Line 257: from hxt_sum_hours_worked_f

253: p_ZIP_CODE VARCHAR2 DEFAULT NULL
254: ) is
255:
256: cursor c2 is select rowid
257: from hxt_sum_hours_worked_f
258: where effective_start_date = p_effective_start_date
259: and effective_end_date = p_effective_end_date
260: and id = p_id;
261:

Line 266: insert into HXT_SUM_HOURS_WORKED_F(

262: begin
263:
264: p_object_version_number := 1;
265:
266: insert into HXT_SUM_HOURS_WORKED_F(
267: id,
268: -- group_id, --HXT11i1
269: tim_id,
270: date_worked,

Line 773: update HXT_SUM_HOURS_WORKED_F

769: begin
770:
771: p_object_version_number := p_object_version_number + 1;
772:
773: update HXT_SUM_HOURS_WORKED_F
774: set
775: -- group_id = p_group_id, --HXT11i1
776: date_worked = p_date_worked,
777: assignment_id = p_assignment_id,

Line 957: delete from HXT_SUM_HOURS_WORKED_F

953: end delete_HXT_TIMECARDS;
954:
955: procedure delete_HXT_SUM_HOURS_WORKED(p_rowid VARCHAR2) is
956: begin
957: delete from HXT_SUM_HOURS_WORKED_F
958: where rowid=chartorowid(p_rowid);
959: end delete_HXT_SUM_HOURS_WORKED;
960:
961: procedure delete_HXT_DET_HOURS_WORKED(p_rowid VARCHAR2) is

Line 985: from hxt_sum_hours_worked_f

981: vnull number;
982: begin
983: if p_rowid is not null then
984: select ASSIGNMENT_ID into vnull
985: from hxt_sum_hours_worked_f
986: where rowid = p_rowid
987: for update of hxt_sum_hours_worked_f.ASSIGNMENT_ID nowait;
988:
989: end if;

Line 987: for update of hxt_sum_hours_worked_f.ASSIGNMENT_ID nowait;

983: if p_rowid is not null then
984: select ASSIGNMENT_ID into vnull
985: from hxt_sum_hours_worked_f
986: where rowid = p_rowid
987: for update of hxt_sum_hours_worked_f.ASSIGNMENT_ID nowait;
988:
989: end if;
990: end lock_HXT_SUM_HOURS_WORKED;
991: