DBA Data[Home] [Help]

APPS.WFE_HTML_UTIL SQL Statements

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

Line: 34

  include_select boolean,
  include_delete boolean,
  detail_index   pls_integer  default 0,
  edit_index     pls_integer  default 0,
  title_start    pls_integer  default 0,
  level          number       default null
)
is
  i pls_integer;
Line: 75

      if (i=title_start and include_select) then
        htp.tableHeader(cvalue=>''||
              wf_core.translate('SELECT')||'',
              calign=>'Center',
              cattributes=>'ID="' || wf_core.translate('SELECT') || '"');
Line: 111

            if (include_select) then
              htp.tableHeader(cvalue=>''||
                    wf_core.translate('SELECT')||'',
                    calign=>'Center',
                    cattributes=>'id="' || wf_core.translate('SELECT') ||'"');
Line: 175

    if (include_delete) then
      htp.tableHeader(cvalue=>''||
            wf_core.translate('DELETE')||'',
            calign=>'Center',
            cattributes=>'id="' || wf_core.translate('DELETE') ||'"');
Line: 238

  func_delete varchar2(4000);
Line: 241

  include_select boolean := FALSE;
Line: 242

  include_delete boolean := FALSE;
Line: 278

          func_delete := headerTab(i).value;
Line: 312

      if (dataTab(i).selectable) then
        include_select := TRUE;
Line: 316

        include_delete := TRUE;
Line: 319

      exit when (include_select and include_delete and include_detail);
Line: 342

        if (include_select) then
          spanTab(k).span := spanTab(k).span + 1;
Line: 370

        if (include_delete) then
          spanTab(i).span := spanTab(i).span + 1;
Line: 426

      include_select, include_delete,
      detail_index, edit_index,
      title_start, show_level);
Line: 438

          include_select, include_delete,
          detail_index, edit_index,
          title_start, dataTab(i).level);
Line: 455

          if (include_select) then
            if (dataTab(i).selectable) then
              htp.tableData(htf.formCheckbox(cname=>'h_guids',
                                             cvalue=>dataTab(i).guid,
                            cattributes=>'id="i_select'||i||'"'),
                            'CENTER',cattributes=>'id=""');
Line: 703

          if (include_delete) then
            if (dataTab(i).deletable) then
              htp.tableData(htf.anchor2(
                    curl=>'javascript:confirm_url('''||
                          wf_core.translate('WFE_OK_DELETE')||''','''||
                          wfa_html.base_url||'/'||func_delete||
                          rawtohex(dataTab(i).guid)||''')',
                    ctext=>'' || wf_core.translate('DELETE') || ''),
                   'CENTER', cattributes=>'valign="MIDDLE" id=""');
Line: 717

          end if;  -- include_delete
Line: 837

  hTab(i).value := 'wf_event_html.DeleteEvent?h_guid=';
Line: 893

  dTab(i).selectable := FALSE;
Line: 901

  dTab(i).selectable := FALSE;
Line: 914

  dTab(i).selectable := FALSE;
Line: 924

  dTab(i).selectable := FALSE;