DBA Data[Home] [Help]

APPS.IEU_UWQ_FORM_ROUTE SQL Statements

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

Line: 62

                if l_type is null or l_type <> 'IEU_UPDATE_ENABLED' then

                   if (length(l_action_param3) is null) then
                      l_action_param3:= l_action_param3||l_name||'=['||l_value||']';
Line: 81

                if l_type = 'IEU_UPDATE_ENABLED' then                /* Store all the update enabled
types to table of records */
                   p_ieu_media_data1(i).param_name := l_name;
Line: 91

           /* maximum length of workitemid, occtmediaitemid and all non-update enbaled types */

           max_length := length(l_action_param1) + length(l_action_param2) +
length(l_action_param3);
Line: 103

                  if l_type = 'IEU_UPDATE_ENABLED' then

                      if max_length < 1950 then

                        if (length(l_action_param4) is null) then
                           l_action_param4:= l_action_param4||l_name||'=['||l_value||']';
Line: 119

                  end if; /* IEU_UPDATE_ENABLED */