APPS.XNP_WSGL SQL Statements

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

Line: 106

      select product, version, status
      from   product_component_version
      where  upper(product) like '%ORACLE%SERVER%'
      or     upper(product) like '%PL/SQL%'
      order  by product;

Line: 1519

      I_QUERY := 'SELECT count(*)' ||
                 substr(P_SQL, I_FROM_POS);

Line: 1568

      I_SQL := 'SELECT LOOKUP_CODE, MEANING, LOOKUP_CODE ABBR
      		FROM FND_LOOKUPS
      		WHERE  LOOKUP_TYPE = ''' || P_DOMAIN ||
      		''' ORDER BY ';

Line: 1781

            p_onselect in boolean default false) return varchar2 is
      L_RET_VALUE varchar2(20000) := null;

Line: 1786

      if (P_CTL_STYLE = CTL_UPDATABLE or P_CTL_STYLE = CTL_INSERTABLE) then
         if p_onclick then
            l_events := l_events || ' onClick="'||P_DVREC.ColAlias||'_OnClick(this)"';

Line: 1799

         if p_onselect then
            l_events := l_events || ' onSelect="'||P_DVREC.ColAlias||'_OnSelect(this)"';

Line: 1815

         if (P_CTL_STYLE = CTL_UPDATABLE or P_CTL_STYLE = CTL_INSERTABLE) then
            L_RET_VALUE := htf.formText('P_'||P_DVREC.ColAlias,
                                         to_char(P_DVREC.DispWidth),
                                         to_char(P_DVREC.MaxWidth),
                                         replace(L_DISPLAY_VAL,'"','"'),

Line: 1828

            L_RET_VALUE := htf.formSelectOpen('P_'||P_DVREC.ColAlias,
                                              nsize=>to_char(P_DVREC.DispHeight),
                                              cattributes=>'MULTIPLE '||l_events);

Line: 1832

            L_RET_VALUE := htf.formSelectOpen('P_'||P_DVREC.ColAlias,
                                              nsize=>to_char(P_DVREC.DispHeight),
                                              cattributes=>l_events);

Line: 1836

         if (P_CTL_STYLE = CTL_UPDATABLE or P_CTL_STYLE = CTL_INSERTABLE) and P_DVREC.ColOptional then
            L_RET_VALUE := L_RET_VALUE || htf.formSelectOption(' ');

Line: 1840

            L_RET_VALUE := L_RET_VALUE || htf.formSelectOption(' ', 'SELECTED');

Line: 1849

               L_RET_VALUE := L_RET_VALUE || htf.formSelectOption(L_DISPLAY_VAL, 'SELECTED',
                                             'VALUE="'||P_DVREC.Vals(I_LOOP)||'"');

Line: 1852

               L_RET_VALUE := L_RET_VALUE || htf.formSelectOption(L_DISPLAY_VAL, NULL,
                                             'VALUE="'||P_DVREC.Vals(I_LOOP)||'"');

Line: 1857

            L_RET_VALUE := L_RET_VALUE || htf.formSelectOption(MsgGetText(1,XNP_WSGLM.CAP001_UNKNOWN));

Line: 1859

         L_RET_VALUE := L_RET_VALUE || htf.formSelectClose;

Line: 1877

                  (P_CTL_STYLE = CTL_INSERTABLE) and (I_LOOP = 1))
               ) then
               L_RET_VALUE := L_RET_VALUE ||
                               htf.formRadio('P_'||P_DVREC.ColAlias,
                                             P_DVREC.Vals(I_LOOP),
                                             'CHECKED',
                                              cattributes=>l_events);

Line: 1906

            if P_CURR_VAL is null and (P_CTL_STYLE = CTL_UPDATABLE or P_CTL_STYLE = CTL_INSERTABLE) then
               L_RET_VALUE := L_RET_VALUE ||
                               htf.formRadio('P_'||P_DVREC.ColAlias,
                                             null,
                                             'CHECKED',
                                             cattributes=>l_events);

Line: 1912

            elsif (P_CTL_STYLE = CTL_UPDATABLE or P_CTL_STYLE = CTL_INSERTABLE) then
               L_RET_VALUE := L_RET_VALUE ||
                               htf.formRadio('P_'||P_DVREC.ColAlias,
                                             null,
                                             cattributes=>l_events);

Line: 1962

                          p_onselect in boolean default false) return varchar2 is
   l_name   varchar2(30) := 'P_'||p_alias;

Line: 1980

   if p_onselect then
      l_events := l_events || ' onSelect="'||p_alias||'_OnSelect(this)"';

Line: 2018

         p_onselect in boolean) return varchar2 is
   l_name1   varchar2(30) := 'P_'||p_alias;

Line: 2035

   if p_onselect then
      l_events := l_events || ' onSelect="'||p_alias||'_OnSelect(this)"';

Line: 2067

                                p_onselect in boolean) return varchar2 is
   l_events  varchar2(1000) := 'onChange="'||substr(p_name, 3)||'_OnChange(this)"';

Line: 2079

   if p_onselect then
      l_events := l_events || ' onSelect="'||substr(p_name, 3)||'_OnSelect(this)"';