[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select user_id into l_user_id from icx_sessions
where session_id = icx_sec.g_session_id;
select substr(c_error_message,12,512) into err_mesg from dual;
select substr(c_error_message,12,512) into err_mesg from dual;
update ICX_SESSIONS
set HOME_URL = l_home_url
where SESSION_ID = n_session_id;
update ICX_SESSIONS
set HOME_URL = l_home_url
where SESSION_ID = n_session_id;
update ICX_SESSIONS
set HOME_URL = l_home_url,
MODE_CODE = 'SLAVE'
where SESSION_ID = n_session_id;
select function_id
into l_function_id
from fnd_form_functions
where function_name = i_3;
select substr(c_error_message,12,512) into err_mesg from dual;
select MENU_ID
into l_menu_id
from ICX_SESSIONS
where SESSION_ID = l_session_id;
select substr(c_error_message,12,512) into err_mesg from dual;
select substr(c_error_message,12,512) into err_mesg from dual;
updateWebUser(i_1,i_2,i_3,i_4,i_5,i_6,i_7,i_8,i_9,i_10,i_11,i_12);
select substr(c_error_message,12,512) into err_mesg from dual;
select user_id
into l_user_id
from icx_sessions
where session_id = n_session_id;
select upper(value)
into l_language
from v$nls_parameters
where parameter = 'NLS_LANGUAGE';
l_language:=icx_sec.getNLS_PARAMETER('NLS_LANGUAGE'); -- replaces above select mputman 1574527
select upper(value)
into l_date_format
from v$nls_parameters
where parameter = 'NLS_DATE_FORMAT';
l_date_format:=icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT'); -- replaces above select mputman 1574527
select substr(c_error_message,12,512) into err_mesg from dual;
select user_id
into l_user_id
from icx_sessions
where session_id = n_session_id;
select upper(value)
into l_language
from v$nls_parameters
where parameter = 'NLS_LANGUAGE';
l_language:=icx_sec.getNLS_PARAMETER('NLS_LANGUAGE'); -- replaces above select mputman 1574527
select upper(value)
into l_date_format
from v$nls_parameters
where parameter = 'NLS_DATE_FORMAT';
l_date_format:=icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT'); -- replaces above select mputman 1574527
select fff.function_id
into l_function_id
from fnd_form_functions fff
where fff.function_name = i_3;
update icx_sessions
set responsibility_id = NULL,
function_id = l_function_id
where session_id = n_session_id;
SELECT user_id
into l_user_id
from fnd_user
where user_name = upper(c_user_name);
SELECT 'LDAP'
INTO l_auth_mode
FROM fnd_user
WHERE l_user_id = icx_sec.g_user_id
AND upper(encrypted_user_password)='EXTERNAL';
select ICX_TEXT_S.Nextval into seq from dual;
SELECT home_url
INTO l_home_url
FROM icx_parameters;
SELECT nls_language
INTO l_nls_lang
FROM icx_sessions
WHERE session_id=l_session_id;
SELECT home_url
INTO l_home_url
FROM icx_parameters;
select b.language_code
into c_language_code
from fnd_languages b,
icx_sessions a
where a.session_id = c_session_id
and b.nls_language = a.nls_language;
select LANGUAGE_CODE
into c_language_code
from FND_LANGUAGES
where INSTALLED_FLAG = 'B';
select fr.menu_id, furg.responsibility_id,
furg.security_group_id, furg.responsibility_application_id
from fnd_responsibility fr,
fnd_user_resp_groups furg,
fnd_user fu
where fu.USER_ID = p_user_id
and fu.START_DATE <= sysdate
and (fu.END_DATE is null or fu.END_DATE > sysdate)
and furg.USER_ID = fu.USER_ID
and furg.START_DATE <= sysdate
and (furg.END_DATE is null or furg.END_DATE > sysdate)
and furg.RESPONSIBILITY_APPLICATION_ID = fr.APPLICATION_ID
and furg.RESPONSIBILITY_ID = fr.RESPONSIBILITY_ID
and fr.VERSION = 'W'
and fr.START_DATE <= sysdate
and (fr.END_DATE is null or fr.END_DATE > sysdate);
select function_id
from fnd_form_functions
where function_name = p_function_name;
select USER_ID
into l_user_id
from FND_USER
where USER_NAME = l_username;
icx_sec.updateSessionContext(p_function_name => l_function_name,
p_function_id => l_function_id,
p_application_id => l_resp_appl_id,
p_responsibility_id => l_responsibility_id,
p_security_group_id => l_security_group_id,
p_session_id => l_session_id,
p_transaction_id => l_transaction_id);
select USER_ID
into l_user_id
from FND_USER
where USER_NAME = l_username;
select b.RESPONSIBILITY_APPLICATION_ID,
b.SECURITY_GROUP_ID,
a.responsibility_id,
a.responsibility_name,
a.description,
a.web_host_name,
a.web_agent_name,
a.version,
a.menu_id
from fnd_responsibility_vl a,
FND_USER_RESP_GROUPS b
where b.user_id = c_user_id
and a.responsibility_id = b.responsibility_id
and a.application_id = b.RESPONSIBILITY_application_id
and a.version = 'W'
and a.start_date <= sysdate
and (a.end_date is null or a.end_date > sysdate)
and b.start_date <= sysdate
and (b.end_date is null or b.end_date > sysdate)
order by responsibility_name;
select b.menu_id,
b.entry_sequence,
b.sub_menu_id,
b.function_id,
c.web_html_call,
b.prompt,
b.description,
c.web_icon
from fnd_form_functions c,
fnd_menu_entries_vl b
where b.menu_id = c_menu_id
and c.function_id(+) = b.function_id
and nvl(c.type,'WWW') in ('WWW','WWK', 'SERVLET','JSP', 'INTEROPJSP')
order by b.entry_sequence;
select nls_language,date_format_mask
into l_language,l_date_format
from icx_sessions
where session_id = n_session_id;
select b.language_code
into c_language_code
from fnd_languages b,
icx_sessions a
where a.session_id = n_session_id
and b.nls_language = a.nls_language;
select a.description, a.user_name, a.user_id
into c_known_as, c_user_name, c_user_id
from fnd_user a,
icx_sessions b
where b.session_id = n_session_id
and b.user_id = a.user_id;
select count(1)
into l_count
from fnd_menu_entries
where menu_id = c_menu_id
and function_id is not null
and sub_menu_id is not null;
select function_id
into l_function_id
from fnd_menu_entries
where menu_id = c_menu_id
and function_id is not null
and sub_menu_id is not null;
select substr(c_error_msg,12,512) into c_display_error from dual;
select a.menu_id,
a.entry_sequence,
a.sub_menu_id,
a.function_id,
b.web_html_call,
a.prompt,
a.description,
b.web_icon
from fnd_form_functions b,
fnd_menu_entries_vl a
where a.menu_id = l_menu_id
and a.function_id = b.function_id(+)
order by a.entry_sequence;
select RESPONSIBILITY_NAME, DESCRIPTION
into l_menu_name, l_menu_description
from fnd_responsibility_vl
where RESPONSIBILITY_ID = l_responsibility_id;
select PROMPT, DESCRIPTION
into l_menu_name, l_menu_description
from fnd_menu_entries_vl
where MENU_ID = l_menuItems(i-1).menuId
and SUB_MENU_ID = l_menuItems(i).menuId;
select substr(c_error_msg,12,512) into c_display_error from dual;
delete from icx_text where text_id=E;commit; --mputman added 1545083
select TYPE
into l_function_type
from FND_FORM_FUNCTIONS
where FUNCTION_ID = l_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 = 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,
FUNCTION_TYPE = l_function_type,
MENU_ID = l_menu_id
where SESSION_ID = l_session_id;
c_update => FALSE);
SELECT 'exists'
FROM FND_ENABLED_PLSQL
WHERE PLSQL_TYPE = 'PROCEDURE'
AND PLSQL_NAME = p_name
AND ENABLED = 'Y';
SELECT 'exists'
FROM FND_ENABLED_PLSQL
WHERE (PLSQL_TYPE = 'PACKAGE' AND PLSQL_NAME = p_pack
OR PLSQL_TYPE = 'PACKAGE.PROCEDURE' AND PLSQL_NAME = p_proc)
AND ENABLED = 'Y';
select * into f
from fnd_form_functions
where function_id = c_function_id;
select responsibility_id, RESPONSIBILITY_APPLICATION_ID
into l_responsibility_id, l_resp_appl_id
from icx_sessions
where session_id = n_session_id;
select web_host_name, web_agent_name
into l_resp_web_host, l_resp_web_agent
from fnd_responsibility
where responsibility_id = nvl(p_responsibility_id,l_responsibility_id) -- Bug 2726022
and application_id = nvl(p_resp_appl_id,l_resp_appl_id); -- Bug 2160456
select a.responsibility_id,a.responsibility_name,
web_HOST_NAME,web_AGENT_NAME
from fnd_responsibility_vl a,
FND_USER_RESP_GROUPS b,
icx_sessions c
where n_session_id = c.session_id
and c.user_id = b.user_id
and a.version = 'W'
and a.start_date <= sysdate
and (a.end_date is null or a.end_date > sysdate)
and b.start_date <= sysdate
and (b.end_date is null or b.end_date > sysdate)
order by responsibility_name;
select user_function_name,description,
web_HOST_NAME,web_AGENT_NAME,web_HTML_CALL,
PARAMETERS
from fnd_form_functions_vl c,
fnd_resp_functions a
where c_responsibility_id = a.responsibility_id
and a.action_id = c.function_id
order by user_function_name;
SELECT LANGUAGE_CODE,
NLS_LANGUAGE,
DESCRIPTION,
ISO_LANGUAGE,
ISO_TERRITORY
FROM FND_LANGUAGES_VL
WHERE INSTALLED_FLAG in ('I', 'B')
ORDER BY DESCRIPTION;
select NAME, TEXT
from WF_RESOURCES
where TYPE = 'WFTKN'
and NAME LIKE 'WFPREF_MAILP%'
and LANGUAGE = userenv('LANG')
ORDER BY NAME;
SELECT node_id, node_name
FROM fnd_dm_nodes
ORDER BY node_name;
select t.territory_short_name territory_name,
t.nls_territory
from fnd_territories_vl t,
v$nls_valid_values v
where t.nls_territory = v.value
and v.parameter = 'TERRITORY'
order by t.territory_short_name;
SELECT '(GMT ' ||
rtrim(tz_offset(timezone_code),chr(0))
|| ') ' || name DISPLAYED_NAME
, upgrade_tz_id PROFILE_VALUE
FROM FND_TIMEZONES_VL
WHERE enabled_flag = 'Y'
ORDER BY gmt_offset, name;
select * into u
from fnd_user
where user_id = icx_sec.g_user_id;
SELECT 'LDAP'
INTO l_auth_mode
FROM fnd_user
WHERE user_id = icx_sec.g_user_id
AND upper(encrypted_user_password)='EXTERNAL';
SELECT '(GMT ' ||
rtrim(tz_offset(timezone_code),chr(0))
|| ') ' || name DISPLAYED_NAME
INTO
l_timezone_code
FROM FND_TIMEZONES_VL
WHERE enabled_flag = 'Y'
AND upgrade_tz_id=l_timezone;
htp.p('
'" SELECTED> ' || prec.description );
htp.p('');
htp.p('
'" SELECTED> ' || tz.DISPLAYED_NAME );
htp.p('');
htp.p('
'" SELECTED> ' || l_enc_lookup_meanings(i) );
htp.p('');
htp.formSelectOpen('i_3');
htp.formSelectOption(to_char(to_date('31/12/2000','DD/MM/RRRR'),l_lookup_codes(i)),'SELECTED','VALUE="'||l_lookup_codes(i)||'"');
htp.formSelectOption(to_char(to_date('31/12/2000','DD/MM/RRRR'),l_lookup_codes(i)),'','VALUE="'||l_lookup_codes(i)||'"');
htp.formSelectClose;
htp.p('
htp.p('
htp.p('
'" SELECTED> ' || l_numeric_lookup_meanings(i) );
htp.p('');
htp.p('
htp.p('
htp.p('');
htp.p('
htp.p('
htp.p('');
htp.p('
'" SELECTED> ' || v_node_name(counter));
htp.p('');
htp.p('
'" SELECTED> ' || dm.node_name);
htp.p('');
htp.p('function update_user(){
var l_alert = false;');
P_HyperTextCall => 'javascript:update_user()',
P_LanguageCode => c_language_code,
P_JavaScriptFlag => FALSE);
procedure updateWebUser(c_KNOWN_AS in VARCHAR2,
c_LANGUAGE in VARCHAR2,
c_DATE_FORMAT in VARCHAR2,
c_PASSWORD1 in VARCHAR2,
c_PASSWORD2 in VARCHAR2,
c_PASSWORD3 in VARCHAR2,
c_MAILPREF in VARCHAR2,
c_DMPREF in VARCHAR2,
c_NUMERIC_CHARACTERS in VARCHAR2,
c_TERRITORY in VARCHAR2,
c_TIMEZONE IN VARCHAR2,
c_ENCODING IN VARCHAR2) is
l_server_name varchar2(80);
l_password_updated boolean;
l_password_updated := TRUE;
fnd_message.set_name('FND','SQL-NO INSERT');
FND_USER_PVT.Update_User(p_api_version_number => 1.0,
p_init_msg_list => 'T',
p_commit => 'T',
p_host_port => l_server_name||':'||l_server_port,
p_old_password => c_PASSWORD1,
p_new_password => c_PASSWORD2,
p_last_updated_by => l_user_id,
p_last_update_date => sysdate,
p_user_id => l_user_id,
p_return_status => l_return_status,
p_msg_count => l_msg_count,
p_msg_data => l_msg_data);
l_password_updated := FALSE;
end if; -- update password
l_password_updated := FALSE;
if not l_password_updated
then
c_error_msg := fnd_message.get; -- get the password update error placed on the stack by fnd_user_pvt
end if; -- not l_password_updated
l_password_updated := FALSE;
if l_password_updated
then
FND_USER_PVT.Update_User(p_api_version_number => 1.0,
p_init_msg_list => 'T',
p_commit => 'T',
p_language => c_LANGUAGE,
p_date_format_mask => l_date_format,
p_territory => c_TERRITORY,
p_numeric_characters => c_NUMERIC_CHARACTERS,
p_known_as => c_KNOWN_AS,
p_last_updated_by => l_user_id,
p_last_update_date => sysdate,
p_user_id => l_user_id,
p_return_status => l_return_status,
p_msg_count => l_msg_count,
p_msg_data => l_msg_data);
select nls_language
into p_lang_change
from fnd_languages
where language_code = (SELECT language_code
FROM icx_sessions
WHERE session_id = n_session_id);
select language_code
into c_language_code
from fnd_languages
where nls_language = c_LANGUAGE;
update icx_sessions
set nls_language = c_LANGUAGE,
language_code = c_language_code,
date_format_mask = l_date_format,
nls_territory = c_TERRITORY,
nls_numeric_characters = c_NUMERIC_CHARACTERS,
nls_date_language = z_date_lang,
nls_sort = z_sort
where session_id = n_session_id;
updateNewPassword(i_1,i_2,i_3,i_4);
updateNewFndPassword(i_1,i_2,i_3,i_4,c_mode_code,c_url);
procedure updateNewFndPassword(c_USERNAME in VARCHAR2,
c_PASSWORD1 in VARCHAR2,
c_PASSWORD2 in VARCHAR2,
c_PASSWORD3 in VARCHAR2,
p_mode_code in varchar2,
c_url in varchar2) is
l_user_id number;
l_password_updated boolean;
l_password_updated := TRUE;
l_password_updated := FALSE;
l_password_updated := FALSE;
if not l_password_updated
then
c_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
end if; -- not l_password_updated
procedure updateNewPassword(c_USERNAME in VARCHAR2,
c_PASSWORD1 in VARCHAR2,
c_PASSWORD2 in VARCHAR2,
c_PASSWORD3 in VARCHAR2) is
l_user_id number;
l_password_updated boolean;
l_password_updated := TRUE;
select user_id,web_password
into l_user_id,l_web_password
from fnd_user
where user_name = l_username;
l_password_updated := FALSE;
l_password_updated := FALSE;
if not l_password_updated
then
c_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
end if; -- not l_password_updated
isolate the commit to just the ticket insert */
function FormsLF_prep(c_string varchar2,
c_session_id NUMBER)
return varchar2 is
PRAGMA AUTONOMOUS_TRANSACTION;
select b.language_code, b.nls_language
into c_language_code, c_nls_language
from fnd_languages b
where b.language_code = c_upper_lang;
select LANGUAGE_CODE, nls_language
into c_language_code, c_nls_language
from FND_LANGUAGES
where INSTALLED_FLAG = 'B';
}'); --mputman hosted update
htp.formHidden('c_sec_grp_id',''); --mputman hosted update
htp.tableRowOpen; -- SITE --mputman hosted update
select nls_language
into l_language
from fnd_languages_vl
where LANGUAGE_CODE = l_language_code;
SELECT user_id
INTO l_user_id
FROM fnd_user
WHERE user_name = upper(i_1);
SELECT user_id INTO l_org_id FROM icx_sessions WHERE session_id=l_session_id;
UPDATE icx_sessions
SET user_id = l_user_id,
first_connect = SYSDATE,
last_connect = SYSDATE,
counter =1,
nls_language = l_language,
language_code = l_language_code,
date_format_mask = l_date_format,
nls_date_language = l_date_language,
nls_numeric_characters = l_numeric_characters,
nls_sort = l_nls_sort,
nls_territory = l_nls_territory,
limit_time = l_limit_time,
limit_connects = l_limit_connects,
RESPONSIBILITY_APPLICATION_ID = l_resp_appl_id,
RESPONSIBILITY_ID = l_responsibility_id,
SECURITY_GROUP_ID = l_security_group_id,
FUNCTION_ID = l_function_id,
org_id = l_org_id,
xsid = l_new_xsid
WHERE session_id = l_session_id;
}'); --mputman hosted update
htp.tableRowOpen; -- SITE --mputman hosted update