APPS.HXT_DML dependencies on HXT_DET_HOURS_WORKED_F

Line 472: from hxt_det_hours_worked_f

468: p_ZIP_CODE VARCHAR2 DEFAULT NULL
469: ) is
470:
471: cursor c2 is select rowid
472: from hxt_det_hours_worked_f
473: where effective_start_date = p_effective_start_date
474: and effective_end_date = p_effective_end_date
475: and id = p_id;
476:

Line 481: insert into HXT_DET_HOURS_WORKED_F(

477: begin
478:
479: p_object_version_number := 1;
480:
481: insert into HXT_DET_HOURS_WORKED_F(
482: id,
483: parent_id,
484: tim_id,
485: date_worked,

Line 902: UPDATE hxt_det_hours_worked_f

898: BEGIN
899:
900: p_object_version_number := p_object_version_number + 1;
901:
902: UPDATE hxt_det_hours_worked_f
903: SET
904: date_worked = p_date_worked,
905: assignment_id = p_assignment_id,
906: hours = p_hours,

Line 963: delete from HXT_DET_HOURS_WORKED_F

959: end delete_HXT_SUM_HOURS_WORKED;
960:
961: procedure delete_HXT_DET_HOURS_WORKED(p_rowid VARCHAR2) is
962: begin
963: delete from HXT_DET_HOURS_WORKED_F
964: where rowid=chartorowid(p_rowid);
965: end delete_HXT_DET_HOURS_WORKED;
966:
967:

Line 997: from hxt_det_hours_worked_f

993: vnull number;
994: begin
995: if p_rowid is not null then
996: select ASSIGNMENT_ID into vnull
997: from hxt_det_hours_worked_f
998: where rowid = p_rowid
999: for update of hxt_det_hours_worked_f.ASSIGNMENT_ID nowait;
1000:
1001: end if;

Line 999: for update of hxt_det_hours_worked_f.ASSIGNMENT_ID nowait;

995: if p_rowid is not null then
996: select ASSIGNMENT_ID into vnull
997: from hxt_det_hours_worked_f
998: where rowid = p_rowid
999: for update of hxt_det_hours_worked_f.ASSIGNMENT_ID nowait;
1000:
1001: end if;
1002: end lock_HXT_DET_HOURS_WORKED;
1003: