APPS.IEU_UWQM_WORK_SOURCES_PKG dependencies on IEU_UWQM_WORK_SOURCES_B

Line 21: cursor C is select ROWID from IEU_UWQM_WORK_SOURCES_B

17: p_application_id number,
18: p_active_flag varchar2 DEFAULT NULL
19:
20: ) is
21: cursor C is select ROWID from IEU_UWQM_WORK_SOURCES_B
22: where WS_ID = p_ws_id;
23:
24: -- l_ws_id number;
25:

Line 28: -- select IEU_UWQM_WORK_SOURCES_B_S1.NEXTVAL into l_ws_id from sys.dual;

24: -- l_ws_id number;
25:
26: begin
27:
28: -- select IEU_UWQM_WORK_SOURCES_B_S1.NEXTVAL into l_ws_id from sys.dual;
29:
30: insert into IEU_UWQM_WORK_SOURCES_B(
31: ws_id,
32: ws_type,

Line 30: insert into IEU_UWQM_WORK_SOURCES_B(

26: begin
27:
28: -- select IEU_UWQM_WORK_SOURCES_B_S1.NEXTVAL into l_ws_id from sys.dual;
29:
30: insert into IEU_UWQM_WORK_SOURCES_B(
31: ws_id,
32: ws_type,
33: distribute_to,
34: distribute_from,

Line 128: from ieu_uwqm_work_sources_b

124: ) is
125: cursor c is
126: select object_version_number, ws_type, distribute_to, distribute_from,
127: distribution_function, not_valid_flag, object_code, ws_enable_profile_option, application_id
128: from ieu_uwqm_work_sources_b
129: where ws_id = p_ws_id
130: for update of ws_id nowait;
131: recinfo c%rowtype;
132:

Line 205: from ieu_uwqm_work_sources_b

201: begin
202: begin
203: select active_flag
204: into l_active_flag
205: from ieu_uwqm_work_sources_b
206: where ws_id = p_ws_id;
207: exception
208: when others then
209: l_active_flag := null;

Line 222: from ieu_uwqm_work_sources_b

218: if p_active_flag is null then
219: begin
220: select active_flag
221: into l_active_flag
222: from ieu_uwqm_work_sources_b
223: where ws_id = p_ws_id;
224: exception when others then null;
225: end;
226: elsif p_active_flag is not null then

Line 231: update IEU_UWQM_WORK_SOURCES_B set

227: l_active_flag := p_active_flag;
228: end if;
229: *********************/
230:
231: update IEU_UWQM_WORK_SOURCES_B set
232: object_version_number = object_version_number+1,
233: ws_type = p_ws_type,
234: distribute_to = p_distribute_to,
235: distribute_from = p_distribute_from,

Line 280: delete from ieu_uwqm_work_sources_b

276: if (sql%notfound) then
277: raise no_data_found;
278: end if;
279:
280: delete from ieu_uwqm_work_sources_b
281: where ws_id = p_ws_id;
282:
283: if (sql%notfound) then
284: raise no_data_found;

Line 296: from ieu_uwqm_work_sources_b b

292: begin
293: delete from IEU_UWQM_WORK_SOURCES_TL t
294: where not exists
295: (select null
296: from ieu_uwqm_work_sources_b b
297: where b.ws_id = t.ws_id);
298:
299: update ieu_uwqm_work_sources_tl t
300: set (ws_name, ws_description)