The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE insert_session_row
(p_effective_date in date)
IS
--
l_proc VARCHAR2 (72) := g_package || 'insert_session_row';
END insert_session_row;
PROCEDURE insert_session_row
(p_effective_date in varchar2)
IS
--
l_date date;
l_proc VARCHAR2 (72) := g_package || 'insert_session_row';
END insert_session_row;
delete from fnd_sessions
where session_id = userenv('sessionid');
select fpi.status
from fnd_product_installations fpi
where fpi.application_id = p_application_id;
,p_icx_update in boolean default true -- 10/15/97 Changed
,p_icx_commit in boolean default false) IS -- 10/15/97 Changed
--
l_web_username varchar2(80) default null;
,p_icx_update => p_icx_update -- 10/15/97 Changed
,p_icx_commit => p_icx_commit); -- 10/15/97 Changed
,p_icx_update in boolean default true -- 10/15/97 Changed
,p_icx_commit in boolean default false) IS -- 10/15/97 Changed
--
l_web_user_id number;
IF NOT(icx_sec.validateSession(c_update => p_icx_update --10/15/97 Chg
,c_commit => p_icx_commit)) then --10/15/97 Chg
RAISE g_fatal_error;