APPS.HXT_DML dependencies on HXT_DET_HOURS_WORKED_F

Line 463: from hxt_det_hours_worked_f

459: p_ZIP_CODE VARCHAR2 DEFAULT NULL
460: ) is
461:
462: cursor c2 is select rowid
463: from hxt_det_hours_worked_f
464: where effective_start_date = p_effective_start_date
465: and effective_end_date = p_effective_end_date
466: and id = p_id;
467:

Line 472: insert into HXT_DET_HOURS_WORKED_F(

468: begin
469:
470: p_object_version_number := 1;
471:
472: insert into HXT_DET_HOURS_WORKED_F(
473: id,
474: parent_id,
475: tim_id,
476: date_worked,

Line 893: UPDATE hxt_det_hours_worked_f

889: BEGIN
890:
891: p_object_version_number := p_object_version_number + 1;
892:
893: UPDATE hxt_det_hours_worked_f
894: SET
895: date_worked = p_date_worked,
896: assignment_id = p_assignment_id,
897: hours = p_hours,

Line 954: delete from HXT_DET_HOURS_WORKED_F

950: end delete_HXT_SUM_HOURS_WORKED;
951:
952: procedure delete_HXT_DET_HOURS_WORKED(p_rowid VARCHAR2) is
953: begin
954: delete from HXT_DET_HOURS_WORKED_F
955: where rowid=chartorowid(p_rowid);
956: end delete_HXT_DET_HOURS_WORKED;
957:
958:

Line 988: from hxt_det_hours_worked_f

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

Line 990: for update of hxt_det_hours_worked_f.ASSIGNMENT_ID nowait;

986: if p_rowid is not null then
987: select ASSIGNMENT_ID into vnull
988: from hxt_det_hours_worked_f
989: where rowid = p_rowid
990: for update of hxt_det_hours_worked_f.ASSIGNMENT_ID nowait;
991:
992: end if;
993: end lock_HXT_DET_HOURS_WORKED;
994: