APPS.ICX_DEFINE_PAGES SQL Statements

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

Line: 52

    l_message       varchar2(240) := 'Please select a Page';

Line: 67

   select ip.page_id, ipt.page_name, ip.page_type
     from icx_pages ip,
	  icx_pages_tl ipt
    where ip.user_id = l_user_id
      and ipt.language = userenv('LANG')
      and ip.page_id = ipt.page_id
      and ip.page_type in ('USER', 'SEED')
   order by PAGE_TYPE DESC, SEQUENCE_NUMBER;

Line: 88

      select MAX(page_name)
        into l_page_name
        from icx_pages_tl
       where page_id = p_page_id
         and language = userenv('LANG');

Line: 96

    if (p_mode = 'DELETE') then

       l_title := wf_core.translate('ICX_CONFIRMTITLE');

Line: 128

    htp.p('function selectTo() {
        alert("'||l_message||'");

Line: 147

    htp.p ('function applyDelete(url){

          top.opener.parent.location = url;

Line: 171

    elsif (p_mode = 'DELETE') then

       l_function_syntax := 'javascript:applyDelete('''||'icx_define_pages.savepage?p_mode=DELETE&p_page_id='||p_page_id||''')';

Line: 237

      htp.p('');

Line: 244

              htp.formSelectOption(cvalue => wf_core.translate('ICX_PREDEFINED'),
                                   cattributes => 'VALUE="'||to_char(rec.page_id)||'"');

Line: 251

           htp.formSelectOption(cvalue => rec.page_name,
                                cattributes => 'VALUE="'||to_char(rec.page_id)||'"');

Line: 256

       htp.formSelectClose;

Line: 265

    if (p_mode IN ('RENAME', 'DELETE')) then

       htp.tableRowOpen;

Line: 367

        update icx_pages
        set    SEQUENCE_NUMBER	= l_position
        where  user_id = l_user_id
        and    page_id = TO_NUMBER(l_page_id);

Line: 437

  elsif (p_mode = 'DELETE') then

     -- Set the new page name
     oracleconfigure.deletepage (p_page_id   => p_page_id);

Line: 481

   select ip.page_id, ipt.page_name
     from icx_pages ip,
	  icx_pages_tl ipt
    where ip.user_id = l_user_id
      and ipt.language = userenv('LANG')
      and ip.page_id = ipt.page_id
      and ip.page_type = 'USER'
   order by ip.sequence_number;

Line: 529

    l_message := wf_core.translate('SELECT_PAGE');

Line: 533

    htp.p('function selectTo() {
        alert("'||l_message||'")
        }');

Line: 547

    htp.p('function deleteBlankRowIfNotEmpty(toList)
           {
              var idx = -1;

Line: 564

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

Line: 566

              { // 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: 572

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

Line: 573

                        toList.options[i].selected = false;

Line: 580

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

Line: 582

               { // 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: 588

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

Line: 589

                         toList.options[i].selected = false;

Line: 596

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

Line: 598

                 if (iSelected == 0)
                    return;

Line: 601

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

Line: 606

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

Line: 608

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

Line: 612

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

Line: 614

                 iSelected = toList.length - 1 - iSelected;

Line: 616

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

Line: 621

        var temp=document.PageList.C.selectedIndex;

Line: 623

          selectTo();

Line: 632

     htp.p ('function Delete() {
        var temp=document.PageList.C.selectedIndex;

Line: 635

          selectTo();

Line: 639

                '/icx_define_pages.DispPageDialog?p_mode=DELETE&p_page_id="+ valuestring,
                "EditRegion", "statusbar=Y,resizable,width=575,height=300");

Line: 651

        var temp=document.PageList.C.selectedIndex;

Line: 653

          selectTo();

Line: 671

        document.updatePageList.pages.value = "";

Line: 675

             document.updatePageList.pages.value = document.updatePageList.pages.value + ":" + document.PageList.C.options[i].value;

Line: 677

	document.updatePageList.submit();

Line: 701

    htp.p('');

        htp.formSelectOption(cvalue => rec.page_name,
                             cattributes => 'VALUE="'||to_char(rec.page_id)||'"');

    htp.formSelectClose;

    htp.formOpen('icx_define_pages.OrderPages','POST','','','NAME="updatePageList"');

   l_actions(6).name := 'DeletePage';

   l_actions(6).text := wf_core.translate('DELETE');

   l_actions(6).action := 'top.main.Delete()';  -- put your own commands here