APPS.ICX_JAVASCRIPT SQL Statements

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

Line: 31

    htp.p( '  idx = fromList.selectedIndex;' );

Line: 55

    htp.p('    if (fromList.options[i].selected) {');

Line: 67

                            fromList.options[i].selected = false;

Line: 69

                            toList.options[toList.selectedIndex].selected = false;

Line: 76

    htp.p('             // removes from fromList and unselects item in toList');

Line: 78

    htp.p('             toList.options[toList.selectedIndex].selected = false;');

Line: 84

    htp.p('  deleteBlankRowIfNotEmpty(fromList);');

Line: 85

    htp.p('  deleteBlankRowIfNotEmpty(toList);');

Line: 115

   htp.p('               toList.options[indexofitem].selected = false; ');

Line: 134

   htp.p('           deleteBlankRowIfNotEmpty(toList);');

Line: 135

   htp.p('           unSelectAll(toList);');

Line: 143

  procedure delete_list_element is
  begin
    htp.p( 'function deleteListElement(fromList)' );

Line: 147

    htp.p( '  idx = fromList.selectedIndex;' );

Line: 157

  end delete_list_element;

Line: 159

  procedure select_all is
  begin
    htp.p( 'function selectAll(fromList)' );

Line: 164

    htp.p( '    fromList.options[i].selected = true;' );

Line: 167

  end select_all;

Line: 169

  procedure unselect_all is
  begin
    htp.p( 'function unSelectAll(fromList)' );

Line: 174

    htp.p( '    fromList.options[i].selected = false;' );

Line: 177

  end unselect_all;

Line: 202

  procedure delete_from_list is
  begin
        htp.p( 'function deleteFromList(theValue, fromList)' );

Line: 213

  end delete_from_list;

Line: 231

         {    // go through the list and get all selected items
              for ( i = 0; i <= toList.length-1; i++)

Line: 233

              { // if the item is selected then swap it
                if (toList.options[i].selected)
                {   // check if it is not the first item
                    if (i != 0)
                    {
                        swap(toList.options[i], toList.options[i - 1]);

Line: 239

                        toList.options[i - 1].selected = true;

Line: 240

                        toList.options[i].selected = false;

Line: 251

         {    // get the first item selected which needs to move to top
              iSelected = toList.selectedIndex;

Line: 253

              if (iSelected == 0)
                 return;

Line: 256

              for ( iMoveTop = 1; iMoveTop <= iSelected; iMoveTop++)

Line: 264

         {    // go through the list and get all selected items
              for ( i = toList.length-1; i >= 0; i--)

Line: 266

              { // if the item is selected then swap it
                if (toList.options[i].selected)
                {   // check if it is not the first item
                    if (i != toList.length-1)
                    {
                        swap(toList.options[i], toList.options[i + 1]);

Line: 272

                        toList.options[i + 1].selected = true;

Line: 273

                        toList.options[i].selected = false;

Line: 284

         {    // get the last item selected which needs to move to bottom
              for ( i = 0; i <= toList.length-1; i++)

Line: 286

              { // if the item is selected then swap it
                if (toList.options[i].selected)
                    iSelected = i;

Line: 290

              if (iSelected == toList.length-1)
                 return;

Line: 292

              iSelected = toList.length - 1 - iSelected;

Line: 294

              for ( iMoveDown = 1; iMoveDown <= iSelected; iMoveDown++)

Line: 300

    procedure delete_blank_row is
  begin
    htp.p('function deleteBlankRowIfNotEmpty(toList)');

Line: 317

  end delete_blank_row;