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: end;
18: end if;
19:
20: -- remove the update list.

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

20: -- remove the update list.
21: if nametab is not null and nametab.count > 0 then
22: begin
23: forall i in nametab.first .. nametab.last
24: delete from icx_session_attributes where session_id = sessionid and name= nametab(i);
25: end;
26: end if;
27:
28: -- insert the update list.

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

29: --dbms_output.put_line('something2....');
30: if nametab is not null and nametab.count > 0 then
31: begin
32: forall i in nametab.first .. nametab.last
33: insert into icx_session_attributes (session_id, name, value) values(sessionid, nametab(i), valtab(i));
34: end;
35: end if;
36:
37: commit;