APPS.JTF_ICXSES SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 4

procedure updateSessionInfo(sessionid in number, nametab in jtf_varchar2_table_100, valtab in jtf_varchar2_table_2000, delNameTab in jtf_varchar2_Table_100 ) is
PRAGMA AUTONOMOUS_TRANSACTION;

Line: 16

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

Line: 24

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

Line: 33

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

Line: 42

end updateSessionInfo;