The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure buildselectboxes(
p_leftnames in icx_api_region.array, --- list of names of available providers:portlets
p_leftids in icx_api_region.array, --- list of ids of available provider:portletids
p_rightnames in icx_api_region.array, --- list of names of selected providers:portlets
p_rightids in icx_api_region.array, --- list of ids of selected providers:portletids:instanceids
p_pageid in number,
p_regionid in number
)
as
l_label varchar2(80);
htp.formSelectOpen( 'p_leftselect', nsize => 8, cattributes=>'multiple');
htp.formSelectOption( replace( rpad( p_leftnames(i), 32), ' ', ' ' ), cattributes => 'VALUE="'||p_leftids(i)||'"' );
htp.formSelectOption( replace( p_leftnames(i), ' ', ' ' ), cattributes => 'VALUE="'||p_leftids(i)||'"' );
htp.formSelectOption( nbsppad( null, 32 ), cattributes => 'VALUE=""' );
htp.formSelectClose;
select ATTRIBUTE_LABEL_LONG
into l_label
from AK_ATTRIBUTES_VL
where ATTRIBUTE_CODE = 'CSI_SHTL_MOVEALL';
htp.tableData( '' ||
htp.formSelectOpen('p_rightselect', nsize => 8, cattributes=>'multiple');
htp.formSelectOption( replace( rpad( p_rightnames(i), 32), ' ', ' ' ), cattributes => 'VALUE="'||p_rightids(i)||'"' );
htp.formSelectOption( replace( p_rightnames(i), ' ', ' ' ), cattributes => 'VALUE="'||p_rightids(i)||'"' );
htp.formSelectOption( nbsppad( null, 32 ), cattributes => 'VALUE=""' );
htp.formSelectClose;
htp.formHidden( 'p_selectedlist', arraytocsv(p_rightids));
select ATTRIBUTE_LABEL_LONG
into l_label
from AK_ATTRIBUTES_VL
where ATTRIBUTE_CODE = 'JTFB_ADMIN_TOP';
htp.tableData( '' ||
select ATTRIBUTE_LABEL_LONG
into l_label
from AK_ATTRIBUTES_VL
where ATTRIBUTE_CODE = 'CSI_SHTL_MOVE';
htp.tableData( '' ||
select ATTRIBUTE_LABEL_LONG
into l_label
from AK_ATTRIBUTES_VL
where ATTRIBUTE_CODE = 'BIS_UP';
htp.tableData( '' ||
select ATTRIBUTE_LABEL_LONG
into l_label
from AK_ATTRIBUTES_VL
where ATTRIBUTE_CODE = 'CSI_SHTL_REMOVE';
htp.tableData( '' ||
select ATTRIBUTE_LABEL_LONG
into l_label
from AK_ATTRIBUTES_VL
where ATTRIBUTE_CODE = 'BIS_DOWN';
htp.tableData( '' ||
select ATTRIBUTE_LABEL_LONG
into l_label
from AK_ATTRIBUTES_VL
where ATTRIBUTE_CODE = 'CSI_SHTL_REMOVEALL';
htp.tableData( '' ||
select ATTRIBUTE_LABEL_LONG
into l_label
from AK_ATTRIBUTES_VL
where ATTRIBUTE_CODE = 'JTFB_ADMIN_BOTTOM';
htp.tableData( '' ||
raise BUILDSELECTBOXES_EXCEPTION;
end buildselectboxes;