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 169: 'HXT_TIMECARDS_F');

165: (timecard_id,
166: timecard_type)
167: VALUES
168: (p_id,
169: 'HXT_TIMECARDS_F');
170:
171: open c2;
172: fetch c2 into p_rowid;
173: close c2;

Line 638: update HXT_TIMECARDS_F

634: begin
635:
636: p_object_version_number := p_object_version_number + 1;
637:
638: update HXT_TIMECARDS_F
639: set
640: for_person_id = p_for_person_id,
641: time_period_id = p_time_period_id,
642: auto_gen_flag = p_auto_gen_flag,

Line 951: delete from HXT_TIMECARDS_F

947:
948:
949: procedure delete_HXT_TIMECARDS(p_rowid VARCHAR2) is
950: begin
951: delete from HXT_TIMECARDS_F
952: where rowid=chartorowid(p_rowid);
953: end delete_HXT_TIMECARDS;
954:
955: procedure delete_HXT_SUM_HOURS_WORKED(p_rowid VARCHAR2) is

Line 973: from hxt_timecards_f

969: vnull number;
970: begin
971: if p_rowid is not null then
972: select FOR_PERSON_ID into vnull
973: from hxt_timecards_f
974: where rowid = p_rowid
975: for update of hxt_timecards_f.FOR_PERSON_ID nowait;
976:
977: end if;

Line 975: for update of hxt_timecards_f.FOR_PERSON_ID nowait;

971: if p_rowid is not null then
972: select FOR_PERSON_ID into vnull
973: from hxt_timecards_f
974: where rowid = p_rowid
975: for update of hxt_timecards_f.FOR_PERSON_ID nowait;
976:
977: end if;
978: end lock_HXT_TIMECARDS;
979: