APPS.ICX_ADMIN_UTILS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 36

l_update_proc		varchar2(240);

Line: 37

l_delete_proc		varchar2(240);

Line: 85

l_update_proc := l_parameters(6);

Line: 87

l_delete_proc := l_parameters(7);

Line: 121

        select  QUERY_SET
        into    l_query_size
        from    ICX_PARAMETERS;

Line: 202

	    l_procedure_call := l_update_proc||'('||icx_call.encrypt2(l_X)||')';

Line: 216

            fnd_message.set_name('ICX', 'ICX_DELETE');

Line: 217

            htp.p('function delete_function(delete_name, X) {
                if (confirm("'||icx_util.replace_quotes(fnd_message.get)||' "+delete_name+"?"))      {
                     parent.location="'||l_delete_proc||'?X=" + X
                }
            }');

Line: 300

		    htp.tableData(htf.anchor(l_update_proc||'?X='||icx_call.encrypt2(l_X||'*]'),l_values_table(l_link_value_id),'','onMouseOver="return true"'));

Line: 319

            htp.tableData(htf.anchor('javascript:delete_function('''||icx_util.replace_onMouseOver_quotes(l_values_table(l_link_value_id))||''','''||icx_call.encrypt2(l_X)||''')',
		htf.img('/OA_MEDIA/'||l_language_code||'/FNDIDELR.gif','CENTER','','','border=no width=17 height=16'),'','onMouseOver="return true"'));

Line: 339

        select substr(l_message,12,512) into l_err_mesg from dual;

Line: 360

procedure selectList(   p_left_region_appl_id   in number,
                        p_left_region_code      in varchar2,
                        p_left_where            in varchar2     default null,
                        p_right_region_appl_id  in number,
                        p_right_region_code     in varchar2,
                        p_right_where           in varchar2     default null,
                        p_hidden_name           in varchar2     default null,
                        p_hidden_value          in varchar2     default null,
                        p_modify_url            in varchar2,
                        p_primary_key_size      in number) is

l_responsibility_id number := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);

Line: 430

        htp.formSelectOpen('left_list','',10,'MULTIPLE');

Line: 448

        htp.formSelectClose;

Line: 456

        htp.formSelectOpen('right_list','',10,'MULTIPLE');

Line: 476

        htp.formSelectClose;

Line: 484

end selectList;