DBA Data[Home] [Help]

APPS.HXT_DML dependencies on HXT_TIMECARDS_F

Line 57: FROM hxt_timecards_f

53: p_object_version_number OUT NOCOPY NUMBER
54: ) IS
55:
56: CURSOR c2 IS SELECT rowid
57: FROM hxt_timecards_f
58: WHERE effective_start_date = p_effective_start_date
59: AND effective_end_date = p_effective_end_date
60: AND id = p_id;
61: begin

Line 64: insert into HXT_TIMECARDS_F(

60: AND id = p_id;
61: begin
62: p_object_version_number := 1;
63:
64: insert into HXT_TIMECARDS_F(
65: id,
66: for_person_id,
67: time_period_id,
68: auto_gen_flag,

Line 629: update HXT_TIMECARDS_F

625: begin
626:
627: p_object_version_number := p_object_version_number + 1;
628:
629: update HXT_TIMECARDS_F
630: set
631: for_person_id = p_for_person_id,
632: time_period_id = p_time_period_id,
633: auto_gen_flag = p_auto_gen_flag,

Line 942: delete from HXT_TIMECARDS_F

938:
939:
940: procedure delete_HXT_TIMECARDS(p_rowid VARCHAR2) is
941: begin
942: delete from HXT_TIMECARDS_F
943: where rowid=chartorowid(p_rowid);
944: end delete_HXT_TIMECARDS;
945:
946: procedure delete_HXT_SUM_HOURS_WORKED(p_rowid VARCHAR2) is

Line 964: from hxt_timecards_f

960: vnull number;
961: begin
962: if p_rowid is not null then
963: select FOR_PERSON_ID into vnull
964: from hxt_timecards_f
965: where rowid = p_rowid
966: for update of hxt_timecards_f.FOR_PERSON_ID nowait;
967:
968: end if;

Line 966: for update of hxt_timecards_f.FOR_PERSON_ID nowait;

962: if p_rowid is not null then
963: select FOR_PERSON_ID into vnull
964: from hxt_timecards_f
965: where rowid = p_rowid
966: for update of hxt_timecards_f.FOR_PERSON_ID nowait;
967:
968: end if;
969: end lock_HXT_TIMECARDS;
970: