DBA Data[Home] [Help]

APPS.JTF_ICXSES dependencies on ICX_SESSION_ATTRIBUTES

Line 16: delete from icx_session_attributes where session_id = sessionid and name= delNameTab(i);

12: -- remove the delete list.
13: if delNameTab is not null and delNameTab.count > 0 then
14: begin
15: forall i in delNameTab.first .. delNameTab.last
16: delete from icx_session_attributes where session_id = sessionid and name= delNameTab(i);
17: commit;
18: exception
19: when others then
20: rollback;

Line 28: delete from icx_session_attributes where session_id = sessionid and name= nametab(i);

24: -- remove the update list.
25: if nametab is not null and nametab.count > 0 then
26: begin
27: forall i in nametab.first .. nametab.last
28: delete from icx_session_attributes where session_id = sessionid and name= nametab(i);
29: commit;
30: exception
31: when others then
32: rollback;

Line 41: insert into icx_session_attributes (session_id, name, value) values(sessionid, nametab(i), valtab(i));

37: --dbms_output.put_line('something2....');
38: if nametab is not null and nametab.count > 0 then
39: begin
40: forall i in nametab.first .. nametab.last
41: insert into icx_session_attributes (session_id, name, value) values(sessionid, nametab(i), valtab(i));
42: commit;
43: exception
44: when others then
45: rollback;