APPS.HXT_HWWS dependencies on HXT_WEEKLY_WORK_SCHEDULES

Line 21: from HXT_WEEKLY_WORK_SCHEDULES

17: p_last_update_login NUMBER
18: ) is
19:
20: cursor c2 is select rowid
21: from HXT_WEEKLY_WORK_SCHEDULES
22: where id = p_id;
23:
24: begin
25:

Line 26: insert into HXT_WEEKLY_WORK_SCHEDULES(

22: where id = p_id;
23:
24: begin
25:
26: insert into HXT_WEEKLY_WORK_SCHEDULES(
27: id,
28: name,
29: business_group_id,
30: start_day,

Line 80: update HXT_WEEKLY_WORK_SCHEDULES

76: ) is
77:
78: begin
79:
80: update HXT_WEEKLY_WORK_SCHEDULES
81: set
82: name = p_name,
83: business_group_id = p_business_group_id,
84: start_day = p_start_day,

Line 100: delete from HXT_WEEKLY_WORK_SCHEDULES

96:
97:
98: procedure delete_HXT_WEEKLY_WORK_SCHEDUL(p_rowid VARCHAR2) is
99: begin
100: delete from HXT_WEEKLY_WORK_SCHEDULES
101: where rowid = chartorowid(p_rowid);
102: end delete_HXT_WEEKLY_WORK_SCHEDUL;
103:
104: procedure lock_HXT_WEEKLY_WORK_SCHEDULES(p_rowid VARCHAR2) is

Line 104: procedure lock_HXT_WEEKLY_WORK_SCHEDULES(p_rowid VARCHAR2) is

100: delete from HXT_WEEKLY_WORK_SCHEDULES
101: where rowid = chartorowid(p_rowid);
102: end delete_HXT_WEEKLY_WORK_SCHEDUL;
103:
104: procedure lock_HXT_WEEKLY_WORK_SCHEDULES(p_rowid VARCHAR2) is
105: vnull number;
106: begin
107: if p_rowid is not null then
108: select ID into vnull

Line 109: from HXT_WEEKLY_WORK_SCHEDULES

105: vnull number;
106: begin
107: if p_rowid is not null then
108: select ID into vnull
109: from HXT_WEEKLY_WORK_SCHEDULES
110: where rowid = p_rowid
111: for update of HXT_WEEKLY_WORK_SCHEDULES.ID nowait;
112:
113: end if;

Line 111: for update of HXT_WEEKLY_WORK_SCHEDULES.ID nowait;

107: if p_rowid is not null then
108: select ID into vnull
109: from HXT_WEEKLY_WORK_SCHEDULES
110: where rowid = p_rowid
111: for update of HXT_WEEKLY_WORK_SCHEDULES.ID nowait;
112:
113: end if;
114: end lock_HXT_WEEKLY_WORK_SCHEDULES;
115:

Line 114: end lock_HXT_WEEKLY_WORK_SCHEDULES;

110: where rowid = p_rowid
111: for update of HXT_WEEKLY_WORK_SCHEDULES.ID nowait;
112:
113: end if;
114: end lock_HXT_WEEKLY_WORK_SCHEDULES;
115:
116: end HXT_HWWS;