The following lines contain the word 'select', 'insert', 'update' or 'delete':
Line: 31
select HSECS into l_hsecs from V$TIMER;
Line: 45
select prompt,
description,
sub_menu_id,
entry_sequence
from fnd_menu_entries_vl
where menu_id = p_object.parent_menu_id
and sub_menu_id is not null
order by entry_sequence;
Line: 55
select b.prompt,
b.description,
b.function_id,
b.entry_sequence,
a.type
from fnd_form_functions a,
fnd_menu_entries_vl b
where b.menu_id = p_object.parent_menu_id
and a.function_id = b.function_id
and a.type = p_object.function_type
order by entry_sequence;
Line: 69
select count(*)
into l_count
from fnd_menu_entries
where menu_id = p_object.parent_menu_id
and sub_menu_id is not null;
Line: 164
var temp=parent.opener.parent.document.'||Z||'.C.selectedIndex;
Line: 170
var temp=parent.opener.parent.document.'||Z||'.C.selectedIndex;
Line: 237
select COLOR_SCHEME
into l_color_scheme
from ICX_PAGE_COLOR_SCHEME
where USER_ID = icx_sec.g_user_id;
Line: 265
l_selected number;
Line: 271
select nvl(REFRESH_RATE,0)
into l_selected
from ICX_PAGES
where USER_ID = icx_sec.g_user_id
and PAGE_ID = p_page_id;
Line: 278
htp.formSelectOpen('O');
Line: 280
if l_selected = l_lookup_codes(i)
then
htp.formSelectOption(l_lookup_meanings(i),'CHECKED','VALUE="'||l_lookup_codes(i)||'"');
select b.responsibility_application_id,
b.security_group_id,
a.responsibility_id,
a.responsibility_name,
a.menu_id,
c.entry_sequence,
c.prompt,
c.description,
d.function_id,
d.type
from fnd_form_functions d,
fnd_menu_entries_vl c,
fnd_responsibility_vl a,
FND_USER_RESP_GROUPS b
where b.user_id = icx_sec.g_user_id
and b.start_date <= sysdate
and (b.end_date is null or b.end_date > sysdate)
and b.RESPONSIBILITY_application_id = a.application_id
and b.responsibility_id = a.responsibility_id
and a.version = 'W'
and a.start_date <= sysdate
and (a.end_date is null or a.end_date > sysdate)
and a.menu_id = c.menu_id
and c.function_id = d.function_id
and d.type in ('WWL','WWLG')
and d.function_name <> 'ICX_NAVIGATE_PLUG'
order by prompt;
Line: 360
select b.responsibility_application_id,
b.security_group_id,
a.responsibility_id,
a.responsibility_name,
a.menu_id,
c.entry_sequence,
c.prompt,
c.description,
d.function_id,
d.type
from fnd_form_functions d,
fnd_menu_entries_vl c,
fnd_responsibility_vl a,
FND_USER_RESP_GROUPS b
where b.user_id = icx_sec.g_user_id
and b.start_date <= sysdate
and (b.end_date is null or b.end_date > sysdate)
and b.RESPONSIBILITY_application_id = a.application_id
and b.responsibility_id = a.responsibility_id
and a.version = 'W'
and a.start_date <= sysdate
and (a.end_date is null or a.end_date > sysdate)
and a.menu_id = c.menu_id
and c.function_id = d.function_id
and d.type in ('WWR','WWRG')
order by prompt;
Line: 388
select b.DISPLAY_SEQUENCE,b.PLUG_ID,b.RESPONSIBILITY_ID,
b.RESPONSIBILITY_APPLICATION_ID,b.SECURITY_GROUP_ID,
b.MENU_ID,b.ENTRY_SEQUENCE,nvl(b.DISPLAY_NAME,c.PROMPT) prompt,
c.DESCRIPTION
from fnd_responsibility e,
FND_USER_RESP_GROUPS d,
FND_FORM_FUNCTIONS a,
FND_MENU_ENTRIES_VL c,
ICX_PAGE_PLUGS b
where b.PAGE_ID = l_page_id
and b.MENU_ID = c.MENU_ID
and b.ENTRY_SEQUENCE = c.ENTRY_SEQUENCE
and c.FUNCTION_ID = a.FUNCTION_ID
and a.type in ('WWL','WWLG')
and b.RESPONSIBILITY_ID = d.RESPONSIBILITY_ID
and d.user_id = icx_sec.g_user_id
and d.start_date <= sysdate
and (d.end_date is null or d.end_date > sysdate)
and b.RESPONSIBILITY_ID = e.RESPONSIBILITY_ID
and e.start_date <= sysdate
and (e.end_date is null or e.end_date > sysdate)
union all
select b.DISPLAY_SEQUENCE,b.PLUG_ID,b.RESPONSIBILITY_ID,
b.RESPONSIBILITY_APPLICATION_ID,b.SECURITY_GROUP_ID,
b.MENU_ID,b.ENTRY_SEQUENCE,nvl(b.DISPLAY_NAME,a.USER_FUNCTION_NAME) prompt,
a.DESCRIPTION
from FND_FORM_FUNCTIONS_VL a,
ICX_PAGE_PLUGS b
where b.PAGE_ID = l_page_id
and b.MENU_ID = -1
and b.ENTRY_SEQUENCE = a.FUNCTION_ID
and a.type in ('WWL','WWLG')
order by 1;
Line: 423
select b.DISPLAY_SEQUENCE,b.PLUG_ID,b.RESPONSIBILITY_ID,
b.RESPONSIBILITY_APPLICATION_ID,b.SECURITY_GROUP_ID,
b.MENU_ID,b.ENTRY_SEQUENCE,nvl(b.DISPLAY_NAME,c.PROMPT) prompt,
c.DESCRIPTION
from fnd_responsibility e,
FND_USER_RESP_GROUPS d,
FND_FORM_FUNCTIONS a,
FND_MENU_ENTRIES_VL c,
ICX_PAGE_PLUGS b
where b.PAGE_ID = l_page_id
and b.MENU_ID = c.MENU_ID
and b.ENTRY_SEQUENCE = c.ENTRY_SEQUENCE
and c.FUNCTION_ID = a.FUNCTION_ID
and a.type in ('WWR','WWRG')
and b.RESPONSIBILITY_ID = d.RESPONSIBILITY_ID
and d.user_id = icx_sec.g_user_id
and d.start_date <= sysdate
and (d.end_date is null or d.end_date > sysdate)
and b.RESPONSIBILITY_ID = e.RESPONSIBILITY_ID
and e.start_date <= sysdate
and (e.end_date is null or e.end_date > sysdate)
order by b.DISPLAY_SEQUENCE;
Line: 460
select PAGE_ID
into l_page_id
from ICX_PAGES
where USER_ID = icx_sec.g_user_id;
procedure updateCustomization(X in varchar2,
Y in varchar2,
Z in pls_integer,
N in varchar2 default NULL,
O in pls_integer default 0) is
type integerTable is table of number index by binary_integer;
Line: 1031
select *
from ICX_PAGE_PLUGS
where PAGE_ID = l_page_id;
Line: 1080
select ICX_PAGE_PLUGS_S.nextval
into l_plug_id(l_index)
from sys.dual;
select WEB_HTML_CALL
into l_plsql_call
from FND_FORM_FUNCTIONS a,
FND_MENU_ENTRIES b
where b.MENU_ID = p.MENU_ID
and b.ENTRY_SEQUENCE = p.ENTRY_SEQUENCE
and a.FUNCTION_ID = b.FUNCTION_ID;