DBA Data[Home] [Help]

APPS.ICX_PAGE_WIDGET SQL Statements

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

Line: 35

   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);
Line: 49

      htp.formSelectOpen( 'p_leftselect', nsize => 8, cattributes=>'multiple');
Line: 54

         htp.formSelectOption( replace( rpad( p_leftnames(i), 32), ' ', '  ' ), cattributes => 'VALUE="'||p_leftids(i)||'"' );
Line: 56

         htp.formSelectOption( replace( p_leftnames(i), ' ', '  ' ), cattributes => 'VALUE="'||p_leftids(i)||'"' );
Line: 61

         htp.formSelectOption( nbsppad( null, 32 ), cattributes => 'VALUE=""' );
Line: 63

      htp.formSelectClose;
Line: 66

      select ATTRIBUTE_LABEL_LONG
      into   l_label
      from   AK_ATTRIBUTES_VL
      where  ATTRIBUTE_CODE = 'CSI_SHTL_MOVEALL';
Line: 71

      htp.tableData( '' ||
Line: 77

      htp.formSelectOpen('p_rightselect', nsize => 8, cattributes=>'multiple');
Line: 82

            htp.formSelectOption( replace( rpad( p_rightnames(i), 32), ' ', '  ' ), cattributes => 'VALUE="'||p_rightids(i)||'"' );
Line: 84

            htp.formSelectOption( replace( p_rightnames(i), ' ', '  ' ), cattributes => 'VALUE="'||p_rightids(i)||'"' );
Line: 88

         htp.formSelectOption( nbsppad( null, 32 ), cattributes => 'VALUE=""' );
Line: 90

      htp.formSelectClose;
Line: 93

      htp.formHidden( 'p_selectedlist', arraytocsv(p_rightids));
Line: 98

      select ATTRIBUTE_LABEL_LONG
      into   l_label
      from   AK_ATTRIBUTES_VL
      where  ATTRIBUTE_CODE = 'JTFB_ADMIN_TOP';
Line: 103

      htp.tableData( '' ||
Line: 111

      select ATTRIBUTE_LABEL_LONG
      into   l_label
      from   AK_ATTRIBUTES_VL
      where  ATTRIBUTE_CODE = 'CSI_SHTL_MOVE';
Line: 116

      htp.tableData( '' ||
Line: 121

      select ATTRIBUTE_LABEL_LONG
      into   l_label
      from   AK_ATTRIBUTES_VL
      where  ATTRIBUTE_CODE = 'BIS_UP';
Line: 126

      htp.tableData( '' ||
Line: 134

      select ATTRIBUTE_LABEL_LONG
      into   l_label
      from   AK_ATTRIBUTES_VL
      where  ATTRIBUTE_CODE = 'CSI_SHTL_REMOVE';
Line: 139

      htp.tableData( '' ||
Line: 144

      select ATTRIBUTE_LABEL_LONG
      into   l_label
      from   AK_ATTRIBUTES_VL
      where  ATTRIBUTE_CODE = 'BIS_DOWN';
Line: 149

      htp.tableData( '' ||
Line: 157

      select ATTRIBUTE_LABEL_LONG
      into   l_label
      from   AK_ATTRIBUTES_VL
      where  ATTRIBUTE_CODE = 'CSI_SHTL_REMOVEALL';
Line: 162

      htp.tableData( '' ||
Line: 167

      select ATTRIBUTE_LABEL_LONG
      into   l_label
      from   AK_ATTRIBUTES_VL
      where  ATTRIBUTE_CODE = 'JTFB_ADMIN_BOTTOM';
Line: 172

      htp.tableData( '' ||
Line: 179

        raise BUILDSELECTBOXES_EXCEPTION;
Line: 180

   end buildselectboxes;