[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select 'Y' into x_session_id from icx_sessions
where session_id = l_session_id;
security_group_id => icx_sec.g_security_group_id);--mputman hosted update
SELECT user_id
INTO t_user_id
FROM fnd_user
WHERE user_name=upper(c_user_name);
insert into icx_failures
(user_name,password,failure_code,failure_date,
created_by, creation_date, last_updated_by,
last_update_date, last_update_login)
values
(l_remote_addr,-1,
'ICX_ACCT_EXPIRED',sysdate,
nvl(u.user_id,-1), sysdate, nvl(u.user_id,-1),
sysdate, u.user_id);
select *
into u
from fnd_user
where user_name = UPPER(c_user_name);
IF b_hosted THEN --mputman hosted update
fnd_global.apps_initialize(user_id => t_user_id,
resp_id => -1,
resp_appl_id => -1,
security_group_id => icx_sec.g_security_group_id);--mputman added 2092330
select 'Y'
into l_expired
from FND_USER
where USER_NAME = UPPER(c_user_name)
and (PASSWORD_DATE is NULL or
(PASSWORD_LIFESPAN_ACCESSES is not NULL and
nvl(PASSWORD_ACCESSES_LEFT, 0) < 1) or
(PASSWORD_LIFESPAN_DAYS is not NULL and
SYSDATE >= PASSWORD_DATE + PASSWORD_LIFESPAN_DAYS));
select *
into u
from fnd_user
where user_name = UPPER(c_user_name);
select *
into u
from fnd_user
where user_name = UPPER(c_user_name)
and WEB_PASSWORD is not null;
insert into icx_failures
(user_name,password,failure_code,failure_date,
created_by, creation_date, last_updated_by,
last_update_date, last_update_login)
values
(c_user_name,-1,
'ICX_ACCT_EXPIRED',sysdate,
nvl(u.user_id,-1), sysdate, nvl(u.user_id,-1),
sysdate, u.user_id);
insert into icx_failures
(user_name,password,failure_code,failure_date,
created_by, creation_date, last_updated_by,
last_update_date, last_update_login)
values
(c_user_name,v_encrypted_psswd,'ICX_SIGNIN_INVALID',sysdate,
'-1', sysdate, '-1', sysdate, '-1');
select fnd_message.get into c_error_msg1 from dual;
insert into icx_failures
(user_name,password,failure_code,failure_date,
created_by, creation_date, last_updated_by,
last_update_date, last_update_login)
values
('-1','-1','ICX_NAVIGATOR',sysdate,
'-1', sysdate, '-1', sysdate, '-1');
select UTF8_DATE_LANGUAGE
from FND_LANGUAGES
where NLS_LANGUAGE = lang;
select LOCAL_DATE_LANGUAGE
from FND_LANGUAGES
where NLS_LANGUAGE = lang;
select node_id into l_node_id from fnd_nodes
where lower(webhost) = l_server_host;
select node_id into l_node_id from fnd_nodes
where lower(node_name) = l_server_host;
select node_id into l_node_id from fnd_nodes
where server_id = l_server_id;
select count(*) into l_count_resp_f
from FND_SECURITY_GROUPS_VL fsg,
fnd_responsibility_vl a,
FND_USER_RESP_GROUPS b,
FND_APPLICATION fa
where b.user_id = p_user_id
and b.start_date <= sysdate
and (b.end_date is null or b.end_date > sysdate)
and b.RESPONSIBILITY_id = a.responsibility_id
and b.RESPONSIBILITY_application_id = a.application_id
and a.application_id = fa.application_id
and a.version in ('4')
and a.start_date <= sysdate
and (a.end_date is null or a.end_date > sysdate)
and b.SECURITY_GROUP_ID = fsg.SECURITY_GROUP_ID;
select count(*) into l_count_resp_o
from FND_SECURITY_GROUPS_VL fsg,
fnd_responsibility_vl a,
FND_USER_RESP_GROUPS b,
FND_APPLICATION fa
where b.user_id = p_user_id
and b.start_date <= sysdate
and (b.end_date is null or b.end_date > sysdate)
and b.RESPONSIBILITY_id = a.responsibility_id
and b.RESPONSIBILITY_application_id = a.application_id
and a.application_id = fa.application_id
and a.version in ('W')
and a.start_date <= sysdate
and (a.end_date is null or a.end_date > sysdate)
and b.SECURITY_GROUP_ID = fsg.SECURITY_GROUP_ID;
SELECT user_id
INTO l_guest_user_id
FROM fnd_user
WHERE user_name = l_guest_username;
insert into icx_sessions (
session_id,
user_id,
org_id,
security_group_id,
mode_code,
nls_language,
language_code,
pseudo_flag,
limit_time,
limit_connects,
counter,
first_connect,
last_connect,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
date_format_mask,
nls_numeric_characters,
nls_date_language,
nls_sort,
nls_territory,
disabled_flag,
node_id,
login_id,
MAC_KEY,
ENC_KEY,
XSID,
TIME_OUT,
GUEST,
DISTRIBUTED)
values (
p_session_id,
p_user_id,
l_org_id,
icx_sec.g_security_group_id,
c_mode_code,
l_language,
l_language_code,
p_pseudo_flag,
l_limit_time,
l_limit_connects,
0,
sysdate,
sysdate,
p_user_id,
sysdate,
p_user_id,
sysdate,
p_user_id,
l_date_format,
l_numeric_characters,
l_date_language,
l_nls_sort,
l_nls_territory,
'N',
l_node_id,
g_p_loginID,
fnd_crypto.RandomBytes(20),
fnd_crypto.RandomBytes(32),
l_XSID,
l_timeout,
l_guest,
l_dist);
select server_id into l_server_id from fnd_nodes
where server_id = p_server_id;
icx_sec.g_security_group_id := c_sec_grp_id; --mputman hosted update
insert into icx_transactions (
TRANSACTION_ID,
SESSION_ID,
RESPONSIBILITY_APPLICATION_ID,
RESPONSIBILITY_ID,
SECURITY_GROUP_ID,
MENU_ID,
FUNCTION_ID,
FUNCTION_TYPE,
PAGE_ID,
LAST_CONNECT,
DISABLED_FLAG,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE)
values (
icx_transactions_s.nextval,
p_session_id,
p_resp_appl_id,
p_responsibility_id,
p_security_group_id,
p_menu_id,
p_function_id,
p_function_type,
p_page_id,
sysdate,
'N',
icx_sec.g_user_id,
sysdate,
icx_sec.g_user_id,
sysdate)
returning transaction_id into l_transaction_id;
select node_id into l_node_id from fnd_nodes
where lower(webhost) = l_server_host;
select node_id into l_node_id from fnd_nodes
where lower(node_name) = (l_server_host);
select node_id into l_node_id from fnd_nodes
where server_id = l_server_id;
update ICX_TRANSACTIONS
set DISABLED_FLAG = 'Y'
where TRANSACTION_ID = p_transaction_id;
insert into icx_failures
(user_name,password,failure_code,failure_date,
created_by, creation_date, last_updated_by,
last_update_date, last_update_login)
values
('-1','-1','ICX_DATA_INCORRECT',sysdate,
'-1', sysdate, '-1', sysdate, '-1');
p_update_context in varchar2)
return BOOLEAN is
l_session_id number;
select HOME_URL,
WEBMASTER_EMAIL,
QUERY_SET,
MAX_ROWS,
SESSION_COOKIE_DOMAIN, --mputman added 1574527
SESSION_COOKIE_NAME, --mputman added 1574527
WINDOW_COOKIE_NAME
into icx_sec.g_home_url,
icx_sec.g_webmaster_email,
icx_sec.g_query_set,
icx_sec.g_max_rows,
icx_sec.g_session_cookie_domain, --mputman added 1574527
icx_sec.g_session_cookie_name, --mputman added 1574527
icx_sec.g_window_cookie_name
from ICX_PARAMETERS;
select RESPONSIBILITY_ID, MENU_ID, ENTRY_SEQUENCE
into l_responsibility_id, l_menu_id, l_entry_sequence
from ICX_PAGE_PLUGS
where PLUG_ID = p_plug_id;
select FUNCTION_ID
into l_function_id
from FND_FORM_FUNCTIONS
where FUNCTION_ID = l_entry_sequence
and FUNCTION_NAME = 'ICX_NAVIGATE_PLUG';
select ipe.RESPONSIBILITY_APPLICATION_ID,
ipe.SECURITY_GROUP_ID,
ipe.RESPONSIBILITY_ID,
fff.FUNCTION_ID
into l_resp_appl_id,
l_security_group_id,
l_responsibility_id,
l_function_id
from FND_FORM_FUNCTIONS fff,
FND_MENU_ENTRIES fme,
ICX_PAGE_PLUGS ipe
where ipe.PLUG_ID = p_plug_id
and fme.MENU_ID = ipe.MENU_ID
and fme.ENTRY_SEQUENCE = ipe.ENTRY_SEQUENCE
and fme.function_id = fff.function_id;
c_update => FALSE);
if l_validate and p_update_context = 'Y'
then
l_org_id := '';
select multi_org_flag
into l_multi_org_flag
from fnd_product_groups
where rownum < 2;
update ICX_SESSIONS
set RESPONSIBILITY_APPLICATION_ID = l_resp_appl_id,
RESPONSIBILITY_ID = l_responsibility_id,
SECURITY_GROUP_ID = l_security_group_id,
ORG_ID = l_org_id,
FUNCTION_ID = l_function_id,
LAST_CONNECT = sysdate,
COUNTER = COUNTER +1
where SESSION_ID = l_session_id;
end if; -- p_update_context = 'Y'
select NLS_LANGUAGE,
LANGUAGE_CODE, DATE_FORMAT_MASK,
NLS_NUMERIC_CHARACTERS, NLS_DATE_LANGUAGE,
NLS_SORT, NLS_TERRITORY,
USER_ID,
RESPONSIBILITY_APPLICATION_ID,
SECURITY_GROUP_ID,
RESPONSIBILITY_ID
into
icx_sec.g_language,
icx_sec.g_language_code, icx_sec.g_date_format,
icx_sec.g_numeric_characters, icx_sec.g_date_language,
icx_sec.g_nls_sort, icx_sec.g_nls_territory,
icx_sec.g_user_id,
icx_sec.g_resp_appl_id,
icx_sec.g_security_group_id,
icx_sec.g_responsibility_id
from ICX_SESSIONS
where SESSION_ID = p_session_id;
select parameter, value
from v$nls_parameters
where parameter in ('NLS_LANGUAGE','NLS_DATE_LANGUAGE','NLS_SORT',
'NLS_TERRITORY','NLS_DATE_FORMAT',
'NLS_NUMERIC_CHARACTERS')
order by parameter;
select node_id into c_node_id from icx_sessions
where user_id = p_user_id and session_id = g_session_id;
c_update in boolean,
c_responsibility_id in number,
c_function_id in number,
c_resp_appl_id in number,
c_security_group_id in number,
c_validate_mode_on in varchar2,
c_transaction_id in number)
return BOOLEAN
is
c_user_name
varchar2(30);
select NLS_LANGUAGE, LANGUAGE_CODE, DATE_FORMAT_MASK,
NLS_NUMERIC_CHARACTERS, NLS_DATE_LANGUAGE,
NLS_SORT, NLS_TERRITORY,
LIMIT_CONNECTS, LIMIT_TIME,
FIRST_CONNECT, COUNTER,
nvl(DISABLED_FLAG,'N'), nvl(PSEUDO_FLAG,'N'),
USER_ID,
nvl(c_resp_appl_id,RESPONSIBILITY_APPLICATION_ID),
nvl(c_security_group_id,SECURITY_GROUP_ID),
nvl(c_responsibility_id,RESPONSIBILITY_ID),
nvl(c_function_id,FUNCTION_ID),
FUNCTION_TYPE,
MENU_ID,
PAGE_ID,
ORG_ID, MODE_CODE, LAST_CONNECT,
login_id --mputman added 2020952
into icx_sec.g_language, icx_sec.g_language_code, icx_sec.g_date_format,
icx_sec.g_numeric_characters, icx_sec.g_date_language,
icx_sec.g_nls_sort,icx_sec.g_nls_territory,
n_limit_connects, n_limit_time,
d_first_connect_time,n_counter,
c_disabled_flag, c_pseudo_session,
icx_sec.g_user_id,
icx_sec.g_resp_appl_id,
icx_sec.g_security_group_id,
icx_sec.g_responsibility_id,
icx_sec.g_function_id,
icx_sec.g_function_type,
icx_sec.g_menu_id,
icx_sec.g_page_id,
c_org_id, icx_sec.g_mode_code,
l_last_connect,
icx_sec.g_login_id --mputman added 2020952
from ICX_SESSIONS
where SESSION_ID = icx_sec.g_session_id;
select TRANSACTION_ID,
nvl(c_resp_appl_id,RESPONSIBILITY_APPLICATION_ID),
nvl(c_responsibility_id,RESPONSIBILITY_ID),
nvl(c_security_group_id,SECURITY_GROUP_ID),
MENU_ID,
nvl(c_function_id,FUNCTION_ID),
FUNCTION_TYPE,
PAGE_ID
into icx_sec.g_transaction_id,
icx_sec.g_resp_appl_id,
icx_sec.g_responsibility_id,
icx_sec.g_security_group_id,
icx_sec.g_menu_id,
icx_sec.g_function_id,
icx_sec.g_function_type,
icx_sec.g_page_id
from ICX_TRANSACTIONS
where TRANSACTION_ID = c_transaction_id
and SESSION_ID = icx_sec.g_session_id
and DISABLED_FLAG <> 'Y'; --reordered select for bug #2389169 mputman
select language_code
into icx_sec.g_language_code
from fnd_languages
where nls_language = icx_sec.g_language;
select multi_org_flag
into l_multi_org_flag
from fnd_product_groups
where rownum < 2;
if c_update
then
update icx_sessions
set last_connect = sysdate,
counter = counter + 1
where session_id = icx_sec.g_session_id;
update icx_sessions
set disabled_flag = 'Y'
where session_id = g_session_id;
SELECT user_name
INTO c_user_name
FROM fnd_user
WHERE user_id=g_user_id;
SELECT user_id
INTO l_user_id
FROM fnd_user
WHERE user_name = l_anon_name;
SELECT user_id
INTO l_user_id
FROM fnd_user
WHERE user_name = l_anon_name;
select substr(c_error_msg,12,512) into c_display_error from dual;
update icx_sessions
set disabled_flag = 'Y'
where session_id = g_session_id;
update icx_sessions
set disabled_flag = 'Y'
where session_id = g_session_id;
c_update in boolean,
c_responsibility_id in number,
c_function_id in number,
c_resp_appl_id in number,
c_security_group_id in number,
c_validate_mode_on in varchar2,
c_encrypted_transaction_id in varchar2,
session_id out NOCOPY number,
transaction_id out NOCOPY number,
user_id out NOCOPY number,
responsibility_id out NOCOPY number,
resp_appl_id out NOCOPY number,
security_group_id out NOCOPY number,
language_code out NOCOPY varchar2,
nls_language out NOCOPY varchar2,
date_format_mask out NOCOPY varchar2,
nls_date_language out NOCOPY varchar2,
nls_numeric_characters out NOCOPY varchar2,
nls_sort out NOCOPY varchar2,
nls_territory out NOCOPY varchar2)
return BOOLEAN is
l_result boolean;
c_update => c_update,
c_responsibility_id => c_responsibility_id,
c_function_id => c_function_id,
c_resp_appl_id => c_resp_appl_id,
c_security_group_id => c_security_group_id,
c_validate_mode_on => c_validate_mode_on,
c_transaction_id => l_transaction_id);
update icx_sessions
set last_connect = sysdate
where session_id = p_session_id;
update icx_sessions
set last_connect = sysdate
where session_id = p_session_id;
select LIMIT_CONNECTS, LIMIT_TIME,
FIRST_CONNECT, COUNTER,
nvl(DISABLED_FLAG,'N'),
LAST_CONNECT, user_id,
nvl(p_resp_id,RESPONSIBILITY_ID),
nvl(p_app_resp_id,RESPONSIBILITY_APPLICATION_ID)
into n_limit_connects, n_limit_time,
d_first_connect_time,n_counter,
c_disabled_flag,
l_last_connect, l_user_id,
l_resp_id, l_app_resp_id
from ICX_SESSIONS
where SESSION_ID = p_session_id;
c_update in boolean,
c_validate_mode_on in varchar2)
return BOOLEAN is
v_cookie_session owa_cookie.cookie;
c_update => c_update,
c_validate_mode_on => c_validate_mode_on));
update icx_sessions
set disabled_flag = 'Y'
where session_id = n_session_id;
update icx_sessions
set disabled_flag = 'Y'
where session_id = n_session_id;
update icx_sessions
set disabled_flag = 'Y'
where session_id = l_session_id;
update icx_sessions
set disabled_flag = 'Y'
where session_id = l_session_id
and user_id = c_user_id;
update icx_sessions
set disabled_flag = 'Y'
where session_id = n_session_id;
select icx_audit_s.nextval
into c_audit_id
from sys.dual;
Insert into icx_audit
(audit_id,session_id,
SERVER_NAME,SERVER_PORT,SCRIPT_NAME,
PATH_INFO,connect_date,
created_by, creation_date, last_updated_by, last_update_date)
values
(c_audit_id,c_session_id,c_server_name,c_server_port,c_script_name,
c_path_info, sysdate,
1, sysdate, 1, sysdate);
select varchar2_value
from ak_web_user_sec_attr_values
where attribute_code = upper(p_attri_code)
and web_user_id = l_user_id;
select a.user_id
into l_user_id
from icx_sessions a
where session_id = n_session_id;
select date_value
from ak_web_user_sec_attr_values
where attribute_code = upper(p_attri_code)
and web_user_id = l_user_id;
select a.user_id
into l_user_id
from icx_sessions a
where session_id = n_session_id;
select date_format_mask
into v_date_format
from icx_sessions
where session_id = n_session_id;
select number_value
from ak_web_user_sec_attr_values
where attribute_code = upper(p_attri_code)
and web_user_id = l_user_id;
select a.user_id
into l_user_id
from icx_sessions a
where session_id = n_session_id;
select a.user_id
into n_user_id
from icx_sessions a
where a.session_id = n_session_id;
select CUSTOMER_ID, SUPPLIER_ID, EMPLOYEE_ID
into n_customer_contact_id, n_vendor_contact_id, n_internal_contact_id
from fnd_user
where user_id = n_user_id;
update icx_sessions
set org_id = n_org_id
where session_id = n_session_id;
select session_id
into l_session_id
from icx_sessions
where session_id = n_session_id;
select b.USER_NAME
into n_id
from icx_sessions a,
fnd_user b
where b.user_id = a.user_id
and a.session_id = n_session_id;
select mode_code
into n_id
from icx_sessions
where session_id = n_session_id;
select LANGUAGE_CODE
into n_id
from FND_LANGUAGES
where INSTALLED_FLAG = 'B';
select value
into n_id
from v$nls_parameters
where parameter = 'NLS_DATE_FORMAT';
n_id:=getNLS_PARAMETER('NLS_DATE_FORMAT'); -- replaces above select mputman 1574527
select a.responsibility_name
from
--FND_SECURITY_GROUPS_VL fsg, -- mputman per 2018060
fnd_responsibility_vl a,
FND_USER_RESP_GROUPS b
where b.user_id = c_user_id
and b.start_date <= sysdate
and (b.end_date is null or b.end_date > sysdate)
and b.RESPONSIBILITY_id = a.responsibility_id
and b.RESPONSIBILITY_application_id = a.application_id
and a.application_id = NVL(c_application_id, a.application_id)
and a.version in ('W','4')
and a.start_date <= sysdate
and (a.end_date is null or a.end_date > sysdate)
--and b.SECURITY_GROUP_ID = fsg.SECURITY_GROUP_ID -- mputman per 2018060
order by responsibility_name;
delete ICX_SESSION_ATTRIBUTES
where SESSION_ID = l_session_id
and NAME = l_name;
insert into ICX_SESSION_ATTRIBUTES
(SESSION_ID,NAME,VALUE)
values
(l_session_id,l_name,p_value);
select VALUE
into l_value
from ICX_SESSION_ATTRIBUTES
where SESSION_ID = l_session_id
and NAME = l_name;
delete ICX_SESSION_ATTRIBUTES
where SESSION_ID = l_session_id
and NAME = l_name;
select HOME_URL,
WEBMASTER_EMAIL,
QUERY_SET,
MAX_ROWS,
SESSION_COOKIE_DOMAIN, --mputman added 1574527
SESSION_COOKIE_NAME, --mputman added 1574527
WINDOW_COOKIE_NAME
into icx_sec.g_home_url,
icx_sec.g_webmaster_email,
icx_sec.g_query_set,
icx_sec.g_max_rows,
icx_sec.g_session_cookie_domain, --mputman added 1574527
icx_sec.g_session_cookie_name, --mputman added 1574527
icx_sec.g_window_cookie_name
from ICX_PARAMETERS;
select HOME_URL,
WEBMASTER_EMAIL,
QUERY_SET,
MAX_ROWS,
SESSION_COOKIE_DOMAIN, --mputman added 1574527
SESSION_COOKIE_NAME, --mputman added 1574527
WINDOW_COOKIE_NAME
into icx_sec.g_home_url,
icx_sec.g_webmaster_email,
icx_sec.g_query_set,
icx_sec.g_max_rows,
icx_sec.g_session_cookie_domain, --mputman added 1574527
icx_sec.g_session_cookie_name, --mputman added 1574527
icx_sec.g_window_cookie_name
from ICX_PARAMETERS;
select SESSION_COOKIE_NAME
into l_session_cookie_name
from ICX_PARAMETERS;
select SESSION_COOKIE_DOMAIN
into l_session_cookie_domain
from ICX_PARAMETERS;
select FUNCTION_ID
into l_function_id
from FND_FORM_FUNCTIONS
where FUNCTION_NAME = p_function_name;
procedure updateSessionContext( p_function_name varchar2,
p_function_id number,
p_application_id number,
p_responsibility_id number,
p_security_group_id number,
p_session_id number,
p_transaction_id number)
is
l_session_id number;
select FUNCTION_ID, TYPE
into l_function_id, l_function_type
from FND_FORM_FUNCTIONS
where FUNCTION_NAME = p_function_name;
select FUNCTION_ID, TYPE
into l_function_id, l_function_type
from FND_FORM_FUNCTIONS
where FUNCTION_ID = p_function_id;
select multi_org_flag
into l_multi_org_flag
from fnd_product_groups
where rownum < 2;
update ICX_SESSIONS
set RESPONSIBILITY_APPLICATION_ID = p_application_id,
RESPONSIBILITY_ID = p_responsibility_id,
SECURITY_GROUP_ID = p_security_group_id,
ORG_ID = l_org_id,
FUNCTION_ID = l_function_id,
FUNCTION_TYPE = l_function_type
where SESSION_ID = l_session_id;
update ICX_TRANSACTIONS
set RESPONSIBILITY_APPLICATION_ID = p_application_id,
RESPONSIBILITY_ID = p_responsibility_id,
SECURITY_GROUP_ID = p_security_group_id,
FUNCTION_ID = l_function_id,
FUNCTION_TYPE = l_function_type
where SESSION_ID = l_session_id
and TRANSACTION_ID = p_transaction_id;
end updateSessionContext;
select web_host_name,web_agent_name,web_html_call,web_encrypt_parameters
into l_web_host_name,l_web_agent_name,l_web_html_call,l_web_encrypt_parameters
from fnd_form_functions
where FUNCTION_NAME = p_function_code
and WEB_SECURED = 'Y';
select upper(value)
into requested_val
from v$nls_parameters
where parameter = p_param;
UPDATE icx_sessions
SET
NLS_LANGUAGE=p_language,
DATE_FORMAT_MASK=p_date_format_mask,
LANGUAGE_CODE=p_language_code,
NLS_DATE_LANGUAGE=p_date_language,
NLS_NUMERIC_CHARACTERS=p_numeric_characters,
NLS_SORT=p_sort,
NLS_TERRITORY=p_territory
WHERE session_id=p_session_id;
select 'Y'
into l_expired
from FND_USER
where USER_NAME = UPPER(i_1)
and (PASSWORD_DATE is NULL or
(PASSWORD_LIFESPAN_ACCESSES is not NULL and
nvl(PASSWORD_ACCESSES_LEFT, 0) < 1) or
(PASSWORD_LIFESPAN_DAYS is not NULL and
SYSDATE >= PASSWORD_DATE + PASSWORD_LIFESPAN_DAYS));
select *
into u
from fnd_user
where user_name = UPPER(i_1);
UPDATE icx_sessions
SET
disabled_flag='N',
last_connect=SYSDATE,
counter=0,
first_connect=SYSDATE,
xsid=l_new_xsid
WHERE
session_id=l_session_id;
insert into icx_failures
(user_name,password,failure_code,failure_date,
created_by, creation_date, last_updated_by,
last_update_date, last_update_login)
values
(i_1,-1,
'ICX_ACCT_EXPIRED',sysdate,
nvl(u.user_id,-1), sysdate, nvl(u.user_id,-1),
sysdate, u.user_id);
insert into icx_failures
(user_name,password,failure_code,failure_date,
created_by, creation_date, last_updated_by,
last_update_date, last_update_login)
values
(i_1,v_encrypted_psswd,'ICX_SIGNIN_INVALID',sysdate,
'-1', sysdate, '-1', sysdate, '-1');
SELECT user_name
INTO l_user_name
FROM fnd_user
WHERE user_id=l_user_id;
SELECT substrb(parameters,(instrb(parameters,'=',1)+1))
INTO l_except_ids
FROM wf_event_subscriptions
WHERE guid=p_guid;
UPDATE icx_sessions
SET disabled_flag='Y'
WHERE user_id = l_user_id
AND session_id <> l_session_id
AND mode_code = '115P';
select fnd_logins_s.nextval
into l_login_id
from sys.dual;
UPDATE icx_sessions
SET disabled_flag='Y'
WHERE
(((SYSDATE-first_connect)*24*60)> threshold);
SELECT user_id
INTO l_anon_user_id
FROM fnd_user
WHERE user_name = l_anon_name;
select count(*)
INTO n_hits
from FND_FORM_FUNCTIONS a,
fnd_menu_entries_vl b,
fnd_responsibility_vl c,
fnd_user_resp_groups d,
fnd_security_groups_vl e
where d.user_id = l_anon_user_id
AND a.function_id = p_func_id
and b.function_id = a.function_id
and d.responsibility_application_id = c.application_id
and b.MENU_ID = c.MENU_ID
and c.responsibility_id = d.responsibility_id
and type in ('WWW','WWK','JSP','SERVLET', 'INTEROPJSP')
and d.start_date <= sysdate
and (d.end_date is null or d.end_date > sysdate)
and d.SECURITY_GROUP_ID = e.SECURITY_GROUP_ID
and prompt is not null
and nvl(a.function_id,-1) not IN
(select ACTION_ID
from FND_RESP_FUNCTIONS
where RESPONSIBILITY_ID = c.responsibility_id
and APPLICATION_ID = d.responsibility_application_id)
and nvl(SUB_MENU_ID,-1) not IN -- submenu exclusions 2029055
(select ACTION_ID
from FND_RESP_FUNCTIONS
where RESPONSIBILITY_ID = c.responsibility_id
and APPLICATION_ID = d.responsibility_application_id);
select UTF8_DATE_LANGUAGE
from FND_LANGUAGES
where NLS_LANGUAGE = lang;
select LOCAL_DATE_LANGUAGE
from FND_LANGUAGES
where NLS_LANGUAGE = lang;
select upper(value)
into l_language
from v$nls_parameters
where parameter = 'NLS_LANGUAGE';
*/ -- removed select 1574527 mputman
l_language:=getNLS_PARAMETER('NLS_LANGUAGE'); -- replaces above select mputman 1574527
select language_code
into l_language_code
from fnd_languages
where nls_language = l_language;
select upper(value)
into l_nls_sort
from v$nls_parameters
where parameter = 'NLS_SORT';
l_nls_sort:=getNLS_PARAMETER('NLS_SORT'); -- replaces above select mputman 1574527
select upper(value)
into l_date_format
from v$nls_parameters
where parameter = 'NLS_DATE_FORMAT';
l_date_format:=getNLS_PARAMETER('NLS_DATE_FORMAT'); -- replaces above select mputman 1574527
select upper(value)
into l_numeric_characters
from v$nls_parameters
where parameter = 'NLS_NUMERIC_CHARACTERS';
l_numeric_characters:=getNLS_PARAMETER('NLS_NUMERIC_CHARACTERS'); -- replaces above select mputman 1574527
select upper(value)
into l_nls_territory
from v$nls_parameters
where parameter = 'NLS_TERRITORY';
l_nls_territory:=getNLS_PARAMETER('NLS_TERRITORY'); -- replaces above select mputman 1574527
select multi_org_flag
into l_multi_org_flag
from fnd_product_groups
where rownum < 2;