create or replace package body odwasrch
is

/*****************************************************************************************
Purpose         Search the Repository and present results in result Frame
                Allow navigation from result frame to:
                - VHV
                - Report
                - Browser
                - ?

Usage

Remarks

Revision history
When        Who                                Construct
  Revision  What
------------------------------------------------------------------------------------------
$revision_history$
10-Sep-2003   Kannan Parthasarathy
              - B2881790: Fixed GIF file name.
03-Feb-2003   Kannan Parthasarathy
              - B2822755: Fix improper tooltip.
25-Jan-2003   Kannan Parthasarathy
              - B2727189: Escape double quotes in JavaScript.
10-Dec-2002   Kannan Parthasarathy
              -B2701841 : Fixed.
28-nov-2002   Kannan Parthasarathy
              - B2688895 Fixed Javascript errors.
14-nov-2002   Kannan Parthasarathy
              - Fixed OAC p1 violations.
24-sep-2002   Kannan Parthasarathy
              - References to CDM are hidden from general users
31-jul-2001   Lucas Jellema
  3.13        - include join with RM_REPOSITORIES to resolve NLS Issue (bug 1911520) in queries with RM$NLS_ELEMENT_TYPES
27-jul-2001   Lucas Jellema
  3.12        - building up the Advanced tab page takes way too long, because of the long list of element type+global name domain names
              - support for file downloading using the download servlet
              changes in:
              * procedure js_dynamic_content

30-mar-2001   Lucas Jellema
  3.11        - support Query Library
              - support search on Dependency Data
01-mar-2001   Lucas Jellema
  3.10        - list UE element types
28-feb-2001   Lucas Jellema
  3.9         - for a search for EMP% under Ton, no proper results are shown: instead a lot of JavaScript is displayed, without the opening <SCRIPT> tag
23-feb-2001   Lucas Jellema
  3.8         Solve issue 200 [odwa project/200%] - Wastebasket Exclude/Include
08-feb-2001   Lucas Jellema
  3.7         - reset of multi select lists should set select for option 0 to true
08-feb-2001   Lucas Jellema
  3.6         - add Reset button + code
07-feb-2001   Lucas Jellema
  3.5         - join with SDW_ACCESS_RIGHTS to establish privileges rather than JR_ACC_RIGHTS.has_access
              - search itself searches without this join but subsequently applies a filter on the search results (function visible)
02-feb-2001   Lucas Jellema
  3.4
02-feb-2001   Peter Ebell
  1.22        - Made reference to /odwa_images/ dependent on preference table.
02-feb-2001   Lucas Jellema
  3.3         - add parameter p_enforce_acc_privs (default true) to runSearch
01-feb-2001   Lucas Jellema
  3.2         - search should abide by access privileges (ISSUE 174 [odwa project/174%]
31-jan-2001   Lucas Jellema
  3.1         solved: Issue 31 - some layout issues in IE ([odwa_project/031 - (ALL) MISC INTERNET EXPLRER ISSUES]
30-jan-2001   Lucas Jellema
  3.0         solve issue 125: In the search results, the wrong path
                                   is shown when the object name includes a slash (/).
                                   In that case it shows the first part of the object
                                   name up to the last slash as if it were a subfolder
                                   of the owning folder.
              Solved in procedure RunQuery: Take the path of the owning container.
30-jan-2001   Lucas Jellema
  2.9         - issue 117: allow case insensitive search: add parameter qCaseSensitive to all public procedures
29-jan-2001   Peter Ebell
  1.16        - Added javascript to prevent opening of new window for file downloads
19-jan-2001   Lucas Jellema
  2.7         Add ShowSQL Window Use the Self Service Style Tab Sheets to switch between Search Modes
08-jan-2001   Peter Ebell
  1.14        - Used javascript in ResultFrame to dynamically build list. This reduces bandwidth. Use the Self Service Style Tab Sheets to switch between Search Modes
02-jan-2001   Lucas Jellema
  2.5         Fix: if check state has not been specified, the query looks for WQA
               and e.state in ('WQA' )
              Further research into: when is VA.date_changed and VA.changed_by set? FGor QMS_TRANSACTIONS, the VEV states: checked in by Sandra but changed_by is LAURI. Use the Self Service Style Tab Sheets to switch between Search Modes
02-jan-2001   Lucas Jellema
  2.4         Changed: resultFrame, queryFrame, runSearch
              - Layout should be improved (use full width of page, make sure no buttons/items fall off the screen)
              - Checkbox for 'only tip versions' on first page
              - use correct dates to search for Checked In/Check Out before/after; note root
              versions!! Make distinction between check out and check in date; possibly support
              search for 'length of check out period'
              - add a check box: show only root version to the Version tab sheet
               Use the Self Service Style Tab Sheets to switch between Search Modes
22-dec-2000   Lucas Jellema
  2.3         Make use of ODWA_FOL.go for all element type links Use the Self Service Style Tab Sheets to switch between Search Modes
08-dec-2000   Lucas Jellema
  2.1         Display friendlier message when no results are found
              Align SEARCH link left in Cell
              Include Object Browser in Menu Bar
              Improve layout with Self Service style Tab bars Use the Self Service Style Tab Sheets to switch between Search Modes
18-sep-2000   Lucas Jellema
  2.0         Show version label for Checked Out Elements (solve bug 4)
18-sep-2000   Lucas Jellema
  1.9         Solve bug 7: When search on specifc version label, the query statement looks for ov.vlabel instead of e.vlabel.
18-sep-2000   Lucas Jellema
  1.8         ResultFrame: Use cdwp.report_link instead of call to odwabrow.
              Also: order by Date Modified: default is Descending (solves bug 3)
18-sep-2000   Lucas Jellema
  1.7         Solve bug 8: In the Search tool, on the 'Version' tab there is the possibility to search for object that were Checked In/Out by a specific User. The associated pop-list shows the user 'PUBLIC'. This is not a real user, and PUBLIC cannot Check In/Out objects.
              The same holds true on the 'Audit' tab or the fields 'Created by' and 'Changed by'.
15-sep-2000   Lucas Jellema
  1.6         Add Notes columns for FUN.short_definition, MOD.short_tile etc.; additional description for elements listed
11-sep-2000   Lucas Jellema
  1.5         Support for: file contains, mlt contains
              support for extra where-clause
              invokation of Info Window from ResultFrame
28-aug-2000   Lucas Jellema
  1.1         Search criteria added:
              * only tip version
              * branch
              * vlabel
              * checknotes contain
              * configuration_id
              Order By supported
              Return Date_Changed in g_dateChangeTab
              Return query in g_last_search_cursor
21-aug-2000   Lucas Jellema
  1.0         Initial Creation
              To be added:
              * stored search result in database table to allow easy sorting on all properties
                (name, type, path, version label, date modified, user modified, ASC and DESC)
              * display of more attributes
              * link to ODWA reports (not just VHV)
              * additional search criteria:
                 - BRANCH
                - Version Label
                - LATEST on BRANCH
               - Check Notes containing (e.g. bug number!)
               - File or (MLT) Text  Containing
               - advanced: Element_Type.property =,<,>,like
              -  advanced: has SAC .....
              -  advanced: part of Configuration...,, used in Workarea

11-aug-2000   Lucas Jellema
  1.0         Initial Creation
*****************************************************************************************/

--
-- private constants
--
REVISION_LABEL        constant varchar2(30) := '$x.y:: 3.13           $';
PACKAGE_NAME          constant varchar2(30) := 'ODWASRCH';

g_last_search_cursor  varchar2(30000);

function get_Last_search_query
return varchar2
is
begin
  return g_last_search_cursor;
end; -- get_last_search_query

procedure js_showSql
is
begin
  htp.p('<SCRIPT>');
  htp.p('
  function showSql()
  {
      window2=open
            (  ''''
            , ''showSqlWindow''
            , ''toolbar=no,scrollbars=yes,location=no,directories=no''
             +'',status=no,menubar=no,resizable=yes''
            );
    document.queryForm.p_run_mode.value = "showSql";
    document.queryForm.target = "showSqlWindow";
    document.queryForm.submit();
    window2.moveTo(180,160);
    window2.innerHeight=640;
    window2.innerWidth=650;
    window2.focus();
    document.queryForm.p_run_mode.value = "search";
    document.queryForm.target = "";
  }

  function targetCheck()
  {
    alert("on submit "+
    document.queryForm.p_run_mode.value
    + ";"
    +document.queryForm.target
    );
    document.queryForm.p_run_mode.value = "search";
    document.queryForm.target = "";
  }
  ');
  htp.p('');
  htp.p('</SCRIPT>
  <NOSCRIPT>'|| Rob_msg.getmsg(rob_msg.ACC005_NOSCRIPT,'','','','')||'</NOSCRIPT>');
end; -- js_showSql


procedure js_saveQuery
is
begin
  htp.p('<SCRIPT>');
  htp.p('
  function saveQuery()
  {
      window2=open
            (  ''''
            , ''saveQueryWindow''
            , ''toolbar=no,scrollbars=yes,location=no,directories=no''
             +'',status=no,menubar=no,resizable=yes''
            );
    top.resultFrame.document.queryForm.p_run_mode.value = "saveQuery";
    top.resultFrame.document.queryForm.target = "saveQueryWindow";
    top.resultFrame.document.queryForm.submit();
    window2.moveTo(180,160);
    window2.innerHeight=440;
    window2.innerWidth=650;
    window2.focus();
    top.resultFrame.document.queryForm.p_run_mode.value = "search";
    top.resultFrame.document.queryForm.target = "";
  }

  ');
  htp.p('');
  htp.p('</SCRIPT>
     <NOSCRIPT>'|| Rob_msg.getmsg(rob_msg.ACC005_NOSCRIPT,'','','','')||'</NOSCRIPT>');
end; -- js_saveQuery

procedure js_openLibrary
is
begin
  htp.p('<SCRIPT>');
  htp.p('
  function openLibrary()
  {
      windowOL=open
            (  ''odwaslib.openLibrary?p_session_id='
            ||to_char(odwactxt.get_session_id)
            ||''''
            ||',''queryLibraryWindow''
            , ''toolbar=no,scrollbars=yes,location=no,directories=no''
             +'',status=no,menubar=no,resizable=yes''
            );
    windowOL.moveTo(50,60);
    windowOL.innerHeight=640;
    windowOL.innerWidth=750;
    windowOL.focus();
  }

  ');
  htp.p('');
  htp.p('</SCRIPT>
   <NOSCRIPT>'|| Rob_msg.getmsg(rob_msg.ACC005_NOSCRIPT,'','','','')||'</NOSCRIPT>');
end; -- js_openLibrary




procedure queryFrame
( p_session_id    in   number
, p_mode          in   varchar2  default 'BASIC' -- values: BASIC, ADVANCED ( ??AUDIT, VERSION)
, qName              in   varchar2 default null  -- BASIC
, qCaseSensitive     in   varchar2 default null
, qWorkareaIrid      in   varchar2 default null
, qTipVersionsOnly   in   varchar2 default null
, qFolderIrid        in   varchar2 default null
, qFolderIvid        in   varchar2 default null
, qIncludeNested     in   varchar2 default null
, qElementType       in   varchar2 default null
, qIvid              in   varchar2 default null  -- ADVANCED
, qIrid              in   varchar2 default null
, qTxtType           in   varchar2 default null
, qTxtContains       in   varchar2 default null
, qFileContains      in   varchar2 default null
, qDepType           in   varchar2 default null
, qGlobalName        in   varchar2 default null
, qGlobalNameType    in   varchar2 default null
, qUsedByIvid        in   varchar2 default null
, qCheckState        in   varchar2 default null  -- VERSION
, qRootVersionsOnly  in   varchar2 default null
, qVersionLabel      in   varchar2 default null
, qBranchIrid        in   varchar2 default null
, qCfgIvid in   varchar2 default null
, qCheckNotesContain in   varchar2 default null
, qCheckOutUser      in   varchar2 default null
, qCheckedOutAfter   in   varchar2 default null
, qCheckedOutBefore  in   varchar2 default null
, qCheckInUser       in   varchar2 default null
, qCheckedInAfter    in   varchar2 default null
, qCheckedInBefore   in   varchar2 default null
, qCreatedBy         in   varchar2 default null  -- AUDIT
, qCreatedAfter      in   varchar2 default null
, qCreatedBefore     in   varchar2 default null
, qChangedBy         in   varchar2 default null
, qChangedAfter      in   varchar2 default null
, qChangedBefore     in   varchar2 default null
, qWastebasket in   varchar2 default null
, qWhere             in   varchar2 default null
, qQueryId           in   varchar2 default null
, p_run_mode         in   varchar2 default 'search'  -- search, show, saveQuery, execute
)
is
  l_first   boolean;
  l_menu_bar varchar2(4000);
  l_cdm_used varchar2(1);

    cursor c_wa
    is
    select wa.irid
    ,      wa.OWNER
    ,      wa.NAME
    ,      wa.KIND
    ,      wa.DESCRIPTION
    from   sdd_workareas wa
    order
    by     wa.name
    ;
    cursor c_usr
    is
    select usr.username
    ,      usr.full_user_name
    from   sdw_users usr
    where  usr.username <> 'PUBLIC' -- 1.7  PUBLIC is not a real user
    and    usr.user_type = 1  -- 2.4  exclude Roles
    UNION
    select 'USER' username
    ,      'USER' full_user_name
    from   dual
    order
    by     full_user_name
    ;
    cursor c_ete
    is
     select net.nls_name        name
     ,      et.id               irid
     ,      et.ivid
     from   ci_element_types     cet
     ,      rm_element_types     et
     ,      rm$nls_element_types net
     ,      rm_repositories      rep
     where cet.short_name = et.short_name
     and   net.etid       = et.irid
     and   supertype in ('SHR', 'NSHR')
     and   et.product = 'CI'
     and   et.abstract = 'N'
     and   net.nls_language = rep.nls_language --3.13
     and   exists (
                select null
                from   ck_product_elements pe
                where  pe.element_name = et.name
                and    pe.product_code = 'DESIGN'
                )
     and et.irid not in (5052, 5055)  -- filter out the element types that cannot truly serve as PAC
                                            -- Specific MCO and LOV
     union -- User Extended Types
     select net.nls_name        name
     ,      et.id               irid
     ,      et.ivid
     from   rm_element_types     et
     ,      rm$nls_element_types net
     ,      rm_repositories      rep
     where net.etid       = et.irid
     and   et.product = 'CI'
     and   et.abstract = 'N'
     and   net.nls_language = rep.nls_language --3.13
     and et.user_extension = 'YYY'
    order
    by    1
    ;
    cursor c_brh
    is
    select brh.name
    ,      brh.branch_id irid
    from   i$sdd_branches brh
    order
    by     brh.name
    ;

    cursor c_gnt
    is
     select distinct
            net.nls_name        type_name
     ,      et.id               type_irid
     from   ci_element_types     cet
     ,      rm_element_types     et
     ,      rm$nls_element_types net
     ,      sdd_global_names gne
     ,      rm_repositories      rep
     where  net.etid       = et.irid
     and    gne.type_id = et.irid
     and   net.nls_language = rep.nls_language --3.13
     UNION
     select distinct
            initcap(gnd.name)     type_name
     ,      gnd.irid     type_irid
     from   sdd_global_name_domains gnd
     ,      sdd_global_names gne
     where  gne.domain_irid = gnd.irid
     order
     by     type_name
     ;



procedure js_transferQueryForm
( p_mode in varchar2 default 'BASIC'
) is
begin
  -- every field in the queryForm in queryFrame should be transfered to queryForm in resultFrame
  htp.p(' <SCRIPT LANGUAGE="JavaScript"><!--

  function goto_tab( tabMode)
  {
    document.queryForm.p_mode.value = tabMode;
    transferQueryForm();
    document.queryForm.submit();
  }

  function transferQueryForm()
  {
    var srcForm = document.queryForm;
    var trgForm = top.resultFrame.document.queryForm;

    // BASIC
    '
    ||cdwpbase.ifThenElse
        ( qName is not null or p_mode ='BASIC'
        , ' trgForm.qName.value         = srcForm.qName.value;'
        )
    ||cdwpbase.ifThenElse
      ( p_mode = 'BASIC'
      ,'     if (srcForm.qCaseSensitive.checked)
                 trgForm.qCaseSensitive.value    = "YES";
             else
                 trgForm.qCaseSensitive.value    = "";
       '
      , cdwpbase.ifThenElse
        ( qCaseSensitive is not null or p_mode ='BASIC'
        , '     trgForm.qCaseSensitive.value   = srcForm.qCaseSensitive.value;'
        )
      )
    ||' trgForm.qWorkareaIrid.value =  '
    ||cdwpbase.ifThenElse
      ( p_mode = 'BASIC'
      ,' srcForm.qWorkareaIrid.options[srcForm.qWorkareaIrid.selectedIndex].value; '
      , cdwpbase.ifThenElse
        ( qWorkareaIrid is not null or p_mode ='BASIC'
        , ' srcForm.qWorkareaIrid.value;'
        , '"";'
        )
      )
    ||cdwpbase.ifThenElse
        ( qFolderIrid is not null or p_mode ='BASIC'
        , ' trgForm.qFolderIrid.value   = srcForm.qFolderIrid.value; '
        )
    ||cdwpbase.ifThenElse
        ( qFolderIvid is not null or p_mode ='BASIC'
        , ' trgForm.qFolderIvid.value   = srcForm.qFolderIvid.value; '
        )
    ||cdwpbase.ifThenElse
      ( p_mode = 'BASIC'
      ,'     if (srcForm.qIncludeNested.checked)
                 trgForm.qIncludeNested.value    = "YES";
             else
                 trgForm.qIncludeNested.value    = "";
       '
      , cdwpbase.ifThenElse
        ( qIncludeNested is not null or p_mode ='BASIC'
        , '     trgForm.qIncludeNested.value   = srcForm.qIncludeNested.value;'
        )
      )
    ||'

    trgForm.qElementType.value  = '
    ||cdwpbase.ifThenElse
      ( p_mode = 'BASIC'
      ,' srcForm.qElementType.options[srcForm.qElementType.selectedIndex].value; '
      , cdwpbase.ifThenElse
        ( qElementType is not null or p_mode ='BASIC'
        , ' srcForm.qElementType.value;'
        , ' "";'
        )
      )
    ||cdwpbase.ifThenElse
      ( p_mode = 'BASIC'
      ,'     if (srcForm.qTipVersionsOnly.checked == true)
                {
                 trgForm.qTipVersionsOnly.value    = "YES";
                }
             else
                 trgForm.qTipVersionsOnly.value    = "";
       '
      ,'     trgForm.qTipVersionsOnly.value         = srcForm.qTipVersionsOnly.value;
          '
      )
    ||'
    // ADVANCED
        '
    ||cdwpbase.ifThenElse
      ( qIrid is not null or p_mode = 'ADVANCED'
      ,'     trgForm.qIrid.value         = srcForm.qIrid.value;'
      )
    ||cdwpbase.ifThenElse
      ( qIvid is not null or p_mode = 'ADVANCED'
      ,'     trgForm.qIvid.value         = srcForm.qIvid.value;'
      )
    ||cdwpbase.ifThenElse
      ( qWhere is not null or p_mode = 'ADVANCED'
      ,'     trgForm.qWhere.value         = srcForm.qWhere.value;'
      )
    ||cdwpbase.ifThenElse
      ( qTxtContains is not null or p_mode = 'ADVANCED'
      ,'     trgForm.qTxtContains.value         = srcForm.qTxtContains.value;'
      )
    ||cdwpbase.ifThenElse
      ( qFileContains is not null or p_mode = 'ADVANCED'
      ,'     trgForm.qFileContains.value         = srcForm.qFileContains.value;'
      )
    ||cdwpbase.ifThenElse
      ( qGlobalName is not null or p_mode = 'ADVANCED'
      ,'     trgForm.qGlobalName.value         = srcForm.qGlobalName.value;'
      )
    ||cdwpbase.ifThenElse
      ( qUsedByIvid is not null or p_mode = 'ADVANCED'
      ,'     trgForm.qUsedByIvid.value         = srcForm.qUsedByIvid.value;'
      )
    ||'  trgForm.qDepType.value         =   '
    ||cdwpbase.ifThenElse
      ( p_mode = 'ADVANCED'
      ,' srcForm.qDepType.options[srcForm.qDepType.selectedIndex].value; '
      ,' srcForm.qDepType.value; '
      )
    ||'  trgForm.qGlobalNameType.value         =   '
    ||cdwpbase.ifThenElse
      ( false --p_mode = 'ADVANCED'
      ,' srcForm.qGlobalNameType.options[srcForm.qGlobalNameType.selectedIndex].value; '
      ,' srcForm.qGlobalNameType.value; '
      )
  ||'
    // VERSION
    '
    ||'  trgForm.qCheckState.value         =   '
    ||cdwpbase.ifThenElse
      ( p_mode = 'VERSION'
      ,' srcForm.qCheckState.options[srcForm.qCheckState.selectedIndex].value; '
      ,' srcForm.qCheckState.value; '
      )
    ||cdwpbase.ifThenElse
      ( qVersionLabel is not null or p_mode = 'VERSION'
      ,'     trgForm.qVersionLabel.value         = srcForm.qVersionLabel.value;'
      )
    ||'
       trgForm.qCheckOutUser.value         = '
    ||cdwpbase.ifThenElse
      ( p_mode = 'VERSION'
      ,' srcForm.qCheckOutUser.options[srcForm.qCheckOutUser.selectedIndex].value; '
      , cdwpbase.ifThenElse
        ( qCheckOutUser is not null
        , ' srcForm.qCheckOutUser.value;'
        , ' "";'
        )
      )
    ||'
       trgForm.qCheckInUser.value         = '
    ||cdwpbase.ifThenElse
      ( p_mode = 'VERSION'
      ,' srcForm.qCheckInUser.options[srcForm.qCheckInUser.selectedIndex].value; '
      , cdwpbase.ifThenElse
        ( qCheckInUser is not null
        , ' srcForm.qCheckInUser.value;'
        , ' "";'
        )
      )
    ||cdwpbase.ifThenElse
      ( qCheckNotesContain is not null or p_mode = 'VERSION'
      ,'     trgForm.qCheckNotesContain.value         = srcForm.qCheckNotesContain.value;'
      )
    ||'   trgForm.qBranchIrid.value         = '
    ||cdwpbase.ifThenElse
      ( p_mode = 'VERSION'
      ,' srcForm.qBranchIrid.options[srcForm.qBranchIrid.selectedIndex].value; '
      , cdwpbase.ifThenElse
        ( qBranchIrid is not null
        , ' srcForm.qBranchIrid.value;'
        , ' "";'
        )
      )
    ||'   trgForm.qCfgIvid.value         = '
    ||cdwpbase.ifThenElse
      ( p_mode = 'VERSION'
      ,' srcForm.qCfgIvid.value; '
      , cdwpbase.ifThenElse
        ( qCfgIvid is not null
        , ' srcForm.qCfgIvid.value;'
        , ' "";'
        )
      )
    ||cdwpbase.ifThenElse
      ( p_mode = 'VERSION'
      ,'     if (srcForm.qRootVersionsOnly.checked == true)
                {
                 trgForm.qRootVersionsOnly.value    = "YES";
                }
             else
                 trgForm.qRootVersionsOnly.value    = "";
       '
      ,cdwpbase.ifThenElse
        ( qRootVersionsOnly is not null
        , '     trgForm.qRootVersionsOnly.value         = srcForm.qRootVersionsOnly.value;
          '
        )
      )
    ||cdwpbase.ifThenElse
      ( qCheckedOutBefore is not null or p_mode = 'VERSION'
      ,'     trgForm.qCheckedOutBefore.value         = srcForm.qCheckedOutBefore.value;'
      )
    ||cdwpbase.ifThenElse
      ( qCheckedOutAfter is not null or p_mode = 'VERSION'
      ,'     trgForm.qCheckedOutAfter.value         = srcForm.qCheckedOutAfter.value;'
      )
    ||cdwpbase.ifThenElse
      ( qCheckedInBefore is not null or p_mode = 'VERSION'
      ,'     trgForm.qCheckedInBefore.value         = srcForm.qCheckedInBefore.value;'
      )
    ||cdwpbase.ifThenElse
      ( qCheckedInAfter is not null or p_mode = 'VERSION'
      ,'     trgForm.qCheckedInAfter.value         = srcForm.qCheckedInAfter.value;'
      )
    ||'
    // AUDIT
    trgForm.qCreatedBy.value         = '
    ||cdwpbase.ifThenElse
      ( p_mode = 'AUDIT'
      ,' srcForm.qCreatedBy.options[srcForm.qCreatedBy.selectedIndex].value; '
      ,  cdwpbase.ifThenElse
         ( qCreatedBy is not null
         ,' srcForm.qCreatedBy.value;'
         , ' "";'
         )
      )
    ||'
    trgForm.qChangedBy.value         = '
    ||cdwpbase.ifThenElse
      ( p_mode = 'AUDIT'
      ,' srcForm.qChangedBy.options[srcForm.qChangedBy.selectedIndex].value; '
      ,  cdwpbase.ifThenElse
        ( qChangedBy is not null
        , ' srcForm.qChangedBy.value;'
        , ' "";'
        )
      )
    ||cdwpbase.ifThenElse
      ( qCreatedBefore is not null or p_mode = 'AUDIT'
      ,' trgForm.qCreatedBefore.value         = srcForm.qCreatedBefore.value;'
      )
    ||cdwpbase.ifThenElse
      ( qCreatedAfter is not null or p_mode = 'AUDIT'
      ,' trgForm.qCreatedAfter.value          = srcForm.qCreatedAfter.value;'
      )
    ||cdwpbase.ifThenElse
      ( qChangedBefore is not null or p_mode = 'AUDIT'
      ,' trgForm.qChangedBefore.value         = srcForm.qChangedBefore.value;'
      )
    ||cdwpbase.ifThenElse
      ( qChangedAfter is not null or p_mode = 'AUDIT'
      ,' trgForm.qChangedAfter.value          = srcForm.qChangedAfter.value;'
      )
    ||' trgForm.qWastebasket.value         = '
    ||cdwpbase.ifThenElse
      ( p_mode = 'AUDIT'
      ,' srcForm.qWastebasket.options[srcForm.qWastebasket.selectedIndex].value; '
      , ' srcForm.qWastebasket.value;'
      )
    ||'  } //transferQueryForm

  function resetQueryForm()
  {
    var srcForm = document.queryForm;

    // BASIC
    '
    ||cdwpbase.ifThenElse
        ( qName is not null or p_mode ='BASIC'
        , ' srcForm.qName.value="";
        '
        )
    ||cdwpbase.ifThenElse
      ( p_mode = 'BASIC'
      ,' srcForm.qCaseSensitive.checked = false;
         srcForm.qCaseSensitive.value = "";
         '
      , cdwpbase.ifThenElse
        ( qCaseSensitive is not null
        , 'srcForm.qCaseSensitive.value="";
        '
        )
      )
    ||cdwpbase.ifThenElse
      ( p_mode = 'BASIC'
      ,' srcForm.qWorkareaIrid.options[srcForm.qWorkareaIrid.selectedIndex].selected=false;
         srcForm.qWorkareaIrid.options[0].selected=true;
         '
      , cdwpbase.ifThenElse
        ( qWorkareaIrid is not null
        , ' srcForm.qWorkareaIrid.value="";
        '
        )
      )
    ||cdwpbase.ifThenElse
        ( qFolderIrid is not null or p_mode ='BASIC'
        , ' srcForm.qFolderIrid.value="";
        '
        )
    ||cdwpbase.ifThenElse
        ( qFolderIvid is not null or p_mode ='BASIC'
        , ' srcForm.qFolderIvid.value="";
        '
        )
    ||cdwpbase.ifThenElse
      ( p_mode = 'BASIC'
      ,' srcForm.qIncludeNested.checked=false;
         srcForm.qIncludeNested.value="";
         '
      , cdwpbase.ifThenElse
        ( qIncludeNested is not null or p_mode ='BASIC'
        , '     srcForm.qIncludeNested.value="";
        '
        )
      )
    ||cdwpbase.ifThenElse
      ( p_mode = 'BASIC'
      ,' srcForm.qTipVersionsOnly.checked=true;
         srcForm.qTipVersionsOnly.value="YES";
         '
      , cdwpbase.ifThenElse
        ( qIncludeNested is not null or p_mode ='BASIC'
        , '     srcForm.qTipVersionsOnly.value="YES";
        '
        )
      )
    ||cdwpbase.ifThenElse
      ( p_mode = 'BASIC'
      ,' srcForm.qElementType.options[srcForm.qElementType.selectedIndex].selected=false;
         srcForm.qElementType.options[0].selected=true;
         '
      )
    ||'
    // ADVANCED
    '
    ||cdwpbase.ifThenElse
      ( qIrid is not null or p_mode = 'ADVANCED'
      ,'     srcForm.qIrid.value="";
      '
      )
    ||cdwpbase.ifThenElse
      ( qIvid is not null or p_mode = 'ADVANCED'
      ,'         srcForm.qIvid.value="";
      '
      )
    ||cdwpbase.ifThenElse
      ( qWhere is not null or p_mode = 'ADVANCED'
      ,'         srcForm.qWhere.value="";
      '
      )
    ||cdwpbase.ifThenElse
      ( qTxtContains is not null or p_mode = 'ADVANCED'
      ,'         srcForm.qTxtContains.value="";
      '
      )
    ||cdwpbase.ifThenElse
      ( qFileContains is not null or p_mode = 'ADVANCED'
      ,'         srcForm.qFileContains.value="";
      '
      )
    ||cdwpbase.ifThenElse
      ( qGlobalName is not null or p_mode = 'ADVANCED'
      ,'         srcForm.qGlobalName.value="";
      '
      )
    ||cdwpbase.ifThenElse
      ( qUsedByIvid is not null or p_mode = 'ADVANCED'
      ,'         srcForm.qUsedByIvid.value="";
      '
      )
    ||cdwpbase.ifThenElse
      ( p_mode = 'ADVANCED'
      ,' srcForm.qDepType.options[srcForm.qDepType.selectedIndex].selected=false;
         srcForm.qDepType.options[0].selected=true;
      '
      , ' srcForm.qDepType.value="";
              '
      )
    ||cdwpbase.ifThenElse
      ( false --p_mode = 'ADVANCED'
      ,' srcForm.qGlobalNameType.options[srcForm.qGlobalNameType.selectedIndex].selected=false;
         srcForm.qGlobalNameType.options[0].selected=true;
      '
      , ' srcForm.qGlobalNameType.value="";
              '
      )
    ||'
    // VERSION
    '
    ||cdwpbase.ifThenElse
      ( p_mode = 'VERSION'
      ,' srcForm.qCheckState.options[srcForm.qCheckState.selectedIndex].selected = false;
         srcForm.qCheckState.options[0].selected = true;
       '
      ,' srcForm.qCheckState.value="I,O,N";
      '
      )
    ||cdwpbase.ifThenElse
      ( qVersionLabel is not null or p_mode = 'VERSION'
      ,'     srcForm.qVersionLabel.value="";
      '
      )
    ||cdwpbase.ifThenElse
      ( p_mode = 'VERSION'
      ,' srcForm.qCheckOutUser.options[srcForm.qCheckOutUser.selectedIndex].selected=false;
         srcForm.qCheckOutUser.options[0].selected=true;
       '
      , cdwpbase.ifThenElse
        ( qCheckOutUser is not null
        , ' srcForm.qCheckOutUser.value="";
        '
        )
      )
    ||cdwpbase.ifThenElse
      ( p_mode = 'VERSION'
      ,' srcForm.qCheckInUser.options[srcForm.qCheckInUser.selectedIndex].selected=false;
         srcForm.qCheckInUser.options[0].selected=true;
       '
      , cdwpbase.ifThenElse
        ( qCheckInUser is not null
        , ' srcForm.qCheckInUser.value="";
        '
        )
      )
    ||cdwpbase.ifThenElse
      ( qCheckNotesContain is not null or p_mode = 'VERSION'
      ,'     srcForm.qCheckNotesContain.value="";
      '
      )
    ||cdwpbase.ifThenElse
      ( p_mode = 'VERSION'
      ,' srcForm.qBranchIrid.options[srcForm.qBranchIrid.selectedIndex].selected=false;
         srcForm.qBranchIrid.options[0].selected=true;
      '
      , cdwpbase.ifThenElse
        ( qBranchIrid is not null
        , ' srcForm.qBranchIrid.value="";
        '
        )
      )
    ||cdwpbase.ifThenElse
      ( p_mode = 'VERSION'
      ,' srcForm.qCfgIvid.value="";
      '
      , cdwpbase.ifThenElse
        ( qCfgIvid is not null
        , ' srcForm.qCfgIvid.value="";
        '
        )
      )
    ||cdwpbase.ifThenElse
      ( p_mode = 'VERSION'
      ,'     srcForm.qRootVersionsOnly.checked = false;
             srcForm.qRootVersionsOnly.value    = "";
       '
      ,cdwpbase.ifThenElse
        ( qRootVersionsOnly is not null
        , '     srcForm.qRootVersionsOnly.value="";
          '
        )
      )
    ||cdwpbase.ifThenElse
      ( qCheckedOutBefore is not null or p_mode = 'VERSION'
      ,'srcForm.qCheckedOutBefore.value="";
      '
      )
    ||cdwpbase.ifThenElse
      ( qCheckedOutAfter is not null or p_mode = 'VERSION'
      ,'     srcForm.qCheckedOutAfter.value="";
      '
      )
    ||cdwpbase.ifThenElse
      ( qCheckedInBefore is not null or p_mode = 'VERSION'
      ,'     srcForm.qCheckedInBefore.value="";
      '
      )
    ||cdwpbase.ifThenElse
      ( qCheckedInAfter is not null or p_mode = 'VERSION'
      ,'  srcForm.qCheckedInAfter.value="";
      '
      )
    ||'    // AUDIT
    '||
    cdwpbase.ifThenElse
      (   p_mode = 'AUDIT'
      ,' srcForm.qCreatedBy.options[srcForm.qCreatedBy.selectedIndex].selected=false;
         srcForm.qCreatedBy.options[0].selected=true;
      '
      ,cdwpbase.ifThenElse
       ( qCreatedBy  is not null
       , ' srcForm.qCreatedBy.value= "";
         '
       )
      )
    ||cdwpbase.ifThenElse
      ( p_mode = 'AUDIT'
      ,' srcForm.qChangedBy.options[srcForm.qChangedBy.selectedIndex].selected =false;
         srcForm.qChangedBy.options[0].selected =true;
      '
      ,cdwpbase.ifThenElse
       ( qChangedBy  is not null
       , ' srcForm.qChangedBy.value= "";
         '
       )
      )
    ||cdwpbase.ifThenElse
      ( qCreatedBefore is not null or p_mode = 'AUDIT'
      ,' srcForm.qCreatedBefore.value="";
      '
      )
    ||cdwpbase.ifThenElse
      (  qCreatedAfter  is not null or p_mode = 'AUDIT'
      ,' srcForm.qCreatedAfter.value ="";
      '
      )
    ||cdwpbase.ifThenElse
      (  qChangedBefore is not null or p_mode = 'AUDIT'
      , 'srcForm.qChangedBefore.value="";
      '
      )
    ||cdwpbase.ifThenElse
      ( qChangedAfter is not null or p_mode = 'AUDIT'
      , 'srcForm.qChangedAfter.value="";
      '
      )
    ||cdwpbase.ifThenElse
      ( p_mode = 'AUDIT'
      ,' srcForm.qWastebasket.options[srcForm.qWastebasket.selectedIndex].selected=false;
         srcForm.qWastebasket.options[0].selected=true;
      '
      , cdwpbase.ifThenElse
        ( qWastebasket is not null
       , ' srcForm.qWastebasket.value="Y,N";
         '
       )
      )
    ||'  } //resetQueryForm
  ');

  htp.p
  ('
    //--></SCRIPT> 
    <NOSCRIPT>'|| Rob_msg.getmsg(rob_msg.ACC005_NOSCRIPT,'','','','')||'</NOSCRIPT>');

end; -- js_transferQueryForm

procedure write_tabbar_image_map
is
begin
   -- BASIC
   htp.p
   ( '<map name="tabbarMap"> '
   ||'<area shape="rect" '
   ||'alt="'||Rob_msg.GetMsg(Rob_msg.CAP257_ODWASRCH_BASIC,'','','','')||'"'
   ||' coords="23, 5, 91, 27"'
   || ' href="javascript:goto_tab(''BASIC'')"'
   ||'>'
   );
   -- ADVANCED
   htp.p
   ( '<area shape="rect" '
   ||'alt="'||Rob_msg.GetMsg(Rob_msg.CAP258_ODWASRCH_ADV,'','','','')||'"'
   ||' coords="92, 5, 192, 27"'
   || ' href="javascript:goto_tab(''ADVANCED'')"'
   ||'>'
   );
   -- VERSION
   htp.p
   ( '<area shape="rect" '
   ||'alt="'||Rob_msg.GetMsg(Rob_msg.CAP259_ODWASRCH_VERSION,'','','','')||'"'
   ||' coords="193, 5, 275, 27"'
   || ' href="javascript:goto_tab(''VERSION'')"'
   ||'>'
   );
   -- AUDIT
   htp.p
   ( '<area shape="rect" '
   ||'alt="'||Rob_msg.GetMsg(Rob_msg.CAP260_ODWASRCH_AUDIT,'','','','')||'"'
   ||' coords="193, 5, 339, 27"'
   || ' href="javascript:goto_tab(''AUDIT'')"'
   ||'>'
   ||'</map> '
   );
end; --write_tabbar_image_map


begin
  l_cdm_used := odwapref.get_value('use_cdm');
  -- if an existing Query is indicated, call the procedure loadQueryCriteria that will
  -- retrieve the query criteria for this predefined query can call queryFrame again
  -- with proper values for all query parameters (and NULL for qQueryId)
  if qQueryId is not null
  then
    odwaslib.loadQueryCriteria
    ( p_session_id => p_session_id
    , p_qlb_id => to_number(qQueryId)
    );
  else
    -- create session when necessary, refresh session cache, set workarea context
    -- from here on reference to odwactxt.get_... functions for any context value
    odwactxt.update_context
    ( p_session_id    => p_session_id
    , p_package_name  => PACKAGE_NAME
    , p_procedure_name=> 'queryFrame'
    , p_workarea_irid => to_number( qWorkareaIrid)
    , p_cfg_ivid      => to_number( qCfgIvid)
    , p_folder_irid   => to_number( qFolderIrid)
    , p_pac_irid      => null
    , p_pac_ivid      => null
    );

    htp.htmlOpen;
    htp.headOpen;
    cdwp.write_about(package_name, revision_label);
    js_transferQueryForm( p_mode => p_mode );
    odwarobs.js_invoke_robs
    ( p_type_id          =>  4845 -- 4844 = FOLDER, 4845 is supertype
    , p_form_name        => 'queryForm'
    , p_ivid_field       => 'qFolderIvid'
    , p_irid_field       => 'qFolderIrid'
    , p_workarea_irid    => to_number(qWorkareaIrid)
    , p_cfg_ivid         => to_number(qCfgIvid)
    , p_folder_ivid      => to_number(qFolderIvid)
    , p_function_name    => 'invokeRobsFolderIrid'
    , p_wa_field         => 'qWorkareaIrid'
    , p_cfg_field        => 'qCfgIvid'
    );
    odwarobs.js_invoke_robs
    ( p_type_id          =>  384781276385787681422765648005056569 -- Configuration
    , p_form_name        => 'queryForm'
    , p_ivid_field       => 'qCfgIvid'
    , p_irid_field       =>  ''
    , p_function_name    => 'invokeRobsCfgIvid'
    );
    odwarobs.js_invoke_robs
    ( p_type_id          =>  null -- any type
    , p_form_name        => 'queryForm'
    , p_ivid_field       => 'qUsedByIvid'
    , p_irid_field       =>  ''
    , p_function_name    => 'invokeRobsUsedByIvid'
    );
    odwahelp.js_invoke_help;
    js_saveQuery;
    js_openLibrary;
    js_showSql;
    cdwp.include_report_styles;
    htp.headClose;
    --
    -- body
    --
    htp.bodyOpen
    ( Cattributes => cdwpbase.ifThenElse
                     ( p_run_mode ='execute'
                     , 'onLoad="transferQueryForm();'
                     ||'top.resultFrame.document.queryForm.submit()"'
                     )
    );
    write_tabbar_image_map;

    cdwp.tool_tab_header
    ( p_tool => 'search'
    , p_tabimage => 'tab_'||lower(p_mode)||'.jpg'
    , p_mapname  => '#tabbarMap'
    );

    -- open table with the Search Input fields
    cdwp.tableOpen
    ( p_parameters => 'ALIGN="LEFT" BORDER=0 CELLSPACING=4 ACOLS=4 WIDTH="100%" SUMMARY=""'
    );
      htp.formopen
      ( curl         => 'odwasrch.queryFrame'
      , cmethod      => 'GET'
      , cattributes  => 'NAME="queryForm" '
      , ctarget      => ''
      );
      htp.p
      ( ' <INPUT TYPE="hidden" NAME="p_session_id" '
      ||' VALUE="'||to_char(p_session_id)||'">'
      );
      htp.p
      ( ' <INPUT TYPE="hidden" NAME="p_mode" '
      ||' VALUE="'||p_mode||'">'
      );
      htp.p
      ( ' <INPUT TYPE="hidden" NAME="qQueryId" '
      ||' VALUE="'||qQueryId||'">'
      );
      if p_mode='BASIC'
      then
          -- NAME
          cdwp.tableRowOpen;
          -- cdwp.TableDataHeading(p_Heading => 'Name',p_Attributes => 'WIDTH=80');
           htp.tableData
           ( '<LABEL for=qName>'||Rob_msg.Getmsg(Rob_msg.CAP019_CDWP_NAME,'','','','')||' </LABEL>'
           ,'RIGHT'
           , cattributes=> ' VALIGN="TOP" class="t2"'
           );
          htp.p('<TD ALIGN="LEFT" ACOLSPAN=4>');
          htp.formText
          ( cname       => 'qName'
          , cvalue      => qName
          , csize       => 30
          , cmaxlength  => 500
          , cattributes => 'id=qName'
          );
          htp.p(odwahelp.help_url( p_him_id => 51));
          htp.p('<LABEL for=qCaseSensitive> '||Rob_msg.GetMsg(Rob_msg.CAP261_ODWASRCH_CASESENS,'','','','')||'</LABEL>');
          htp.formCheckBox
          ( CNAME        => 'qCaseSensitive'
          , CVALUE       => 'YES'
          , CCHECKED     => cdwpbase.ifThenElse( qCaseSensitive is not null, 'YES')
          , CATTRIBUTES  => 'id=qCaseSensitive'
          );
          htp.p(odwahelp.help_url( p_him_id => 69));
          htp.p('</TD>');

          -- Element Type
          htp.tableData
           (cdwp.add_images('{doc.gif}')
          ||'<b><LABEL for=qElementType>'||Rob_msg.Getmsg(Rob_msg.CAP217_ODWAROBS_ELTYPE,'','','','')||' </LABEL></b> '
           ,'RIGHT'
           , cattributes=> 'VALIGN="TOP" class="t2"'
           );
          htp.p('<TD ALIGN=LEFT ACOLSPAN=4>');
          htp.formselectopen
          ( cname   => 'qElementType'
          , cprompt => ''
          , cattributes => 'id=qElementType'
          );
          htp.p
          ( '<OPTION VALUE=""'
           ||cdwpbase.ifThenElse
             ( qElementType is null
             , 'SELECTED=Y'
             )
           ||'>'
           ||Rob_msg.GetMsg(Rob_msg.CAP217_ODWAROBS_ELTYPE ,'','','','')
           );
          for r_ete in c_ete loop
            htp.p( '<OPTION VALUE="'||to_char(r_ete.irid)||'"'
               ||cdwpbase.ifThenElse
                 ( r_ete.irid = to_number(qElementType)
                 , 'SELECTED=Y'
                 )
               ||'>'
               ||r_ete.name
               );
            -- Do not display CDM specific objects to general users.
            if (r_ete.irid = 5024 and lower(l_cdm_used) = 'y')-- 'BUSINESS FUNCTION'
            then
                -- add Business Rule                    -5024 (+5024 FUN)
                htp.p
                ( '<OPTION VALUE="-5024"'
                ||cdwpbase.ifThenElse
                  ( -5024 = to_number(qElementType)
                  , 'SELECTED=Y'
                  )
                ||'>'
                ||'Business Rule (Function)'
                );
                -- add Business Rule Design Definition  -4907 (+4907 PLM)
                htp.p
                ( '<OPTION VALUE="-4907"'
                ||cdwpbase.ifThenElse
                  ( -4907 = to_number(qElementType)
                  , 'SELECTED=Y'
                  )
                ||'>'
                ||'Business Rule Design Definition'
                );
            end if; -- r_ete.irid = 5024 -- 'BUSINESS FUNCTION'
          end loop; -- r_ete
          htp.formselectclose;
          htp.p(odwahelp.help_url( p_him_id => 52));
          htp.p('</TD>');
          cdwp.tableRowClose;

          -- WORKAREA
          cdwp.tableRowOpen;
          cdwp.TableDataHeading
          ( cdwp.add_images('{workarea.gif}')
          ||'<LABEL for=qWorkareaIrid> '||Rob_msg.GetMsg(Rob_msg.CAP077_ODWACHCK_WA,'','','','')||'</LABEL>'
          );
          htp.p('<TD ALIGN=LEFT ACOLSPAN=4>');
          htp.formselectopen
          ( cname   => 'qWorkareaIrid'
          , cprompt => ''
          , cattributes => 'id=qWorkareaIrid'
          );
          htp.p
          ( '<OPTION VALUE=""'
           ||cdwpbase.ifThenElse
             ( qWorkareaIrid is null
             , 'SELECTED=Y'
             )
           ||'>'
           ||Rob_msg.GetMsg(Rob_msg.CAP077_ODWACHCK_WA,'','','','')
           );
          for r_wa in c_wa loop
            htp.p( '<OPTION VALUE="'||to_char(r_wa.irid)||'"'
               ||cdwpbase.ifThenElse
                 ( r_wa.irid = to_number(qWorkareaIrid)
                 , 'SELECTED=Y'
                 )
               ||'>'
               ||r_wa.name
               );
          end loop; -- r_wa
          htp.formselectclose;
          htp.p(odwahelp.help_url( p_him_id => 56));
          htp.p('</TD>');

          -- ONLY TIP ON BRANCHES
          htp.tableData
           (cdwp.add_images('{vhv.gif}')
          ||'<LABEL for=qTipVersionsOnly> '||Rob_msg.GetMsg(Rob_msg.CAP262_ODWASRCH_TIPVER,'','','','')
          ||'</LABEL>'
           ,'RIGHT'
           , cattributes=> 'VALIGN="TOP" class="t2"'
           );
          htp.p('<TD>');
          htp.formCheckBox
          ( CNAME        => 'qTipVersionsOnly'
          , CVALUE       => 'YES'
          , CCHECKED     => cdwpbase.ifThenElse( qTipVersionsOnly is not null, 'YES')
          , CATTRIBUTES  => 'id = qTipVersionsOnly'
          );
          htp.p(odwahelp.help_url( p_him_id => 55));
          htp.p('</TD>');
  --        cdwp.tableRowClose;

          cdwp.tableRowClose;

          -- FOLDER
          cdwp.tableRowOpen;
          cdwp.TableDataHeading
          ( cdwp.add_images('{folder.gif}')
          ||Rob_msg.GetMsg(Rob_msg.CAP263_ODWASRCH_OWNINGFOL,'','','','')
          );
          htp.p('<TD ACOLSPAN=2>');
          htp.p
          (' <TABLE BORDER=1 BGCOLOR="#FFFFFF"><TR><TD>'
          ||jr_name.GET_PATH
            ( EL_ID => nvl( qFolderIvid, qFolderIrid)
            , EL_TYPE=> 4845 -- 4844 = FOLDER, 4845 is supertype
            , FORMAT => 'NAME'
            )
          ||cdwpbase.ifThenElse
            ( qFolderIvid is not null
            , ' ('||odwavrsn.get_version_label( p_ivid => to_number(qFolderIvid))||')'
            )
          ||cdwpbase.ifThenElse
            ( qFolderIvid is null
            , cdwpbase.nbsp(20)
            , cdwpbase.nbsp(4)
            )
          ||' <TD BGCOLOR="#FFFFFF"> '
          ||' <A href="javascript:invokeRobsFolderIrid()">'
          ||cdwp.add_images( '{browse_round.gif}')
          ||'</A>'
          ||odwahelp.help_url( p_him_id => 54)
          ||'</TD>'
          ||'</TR></TABLE>'
          );
          htp.p('</TD>');
          htp.tableData
           (cdwp.add_images('{AllFolders.gif}')
          ||'<LABEL for=qIncludeNested> '|| Rob_msg.GetMsg(Rob_msg.CAP264_ODWASRCH_INCLNEST,'','','','')
          ||'</LABEL>'
           ,'RIGHT'
           , cattributes=> 'VALIGN="TOP" class="t2"'
           );
          htp.p('<TD>');
          htp.formCheckBox
          ( CNAME        => 'qIncludeNested'
          , CVALUE       => 'YES'
          , CCHECKED     => cdwpbase.ifThenElse( qIncludeNested is not null, 'YES')
          , CATTRIBUTES  => 'id=qIncludeNested'
          );
          htp.p(odwahelp.help_url( p_him_id => 57));
          htp.p('</TD>');
          cdwp.tableRowClose;

      else
        htp.p
        ( cdwpbase.ifThenElse
          ( qname is not null
          , ' <INPUT TYPE="hidden" NAME="qName" '
          ||' VALUE="'||qName||'">'
          )
        ||' <INPUT TYPE="hidden" NAME="qCaseSensitive" '
        ||' VALUE="'||qCaseSensitive||'">'
        ||cdwpbase.ifThenElse
          ( qWorkareaIrid is not null
          , ' <INPUT TYPE="hidden" NAME="qWorkareaIrid" '
          ||' VALUE="'||qWorkareaIrid||'">'
          )
        ||cdwpbase.ifThenElse
          ( qElementType is not null
          , ' <INPUT TYPE="hidden" NAME="qElementType" '
          ||' VALUE="'||qElementType||'">'
          )
        ||cdwpbase.ifThenElse
          ( qIncludeNested is not null
          , ' <INPUT TYPE="hidden" NAME="qIncludeNested" '
          ||' VALUE="'||qIncludeNested||'">'
          )
        ||' <INPUT TYPE="hidden" NAME="qTipVersionsOnly" '
        ||' VALUE="'||qTipVersionsOnly||'">'
        );
      end if; -- p_mode='BASIC'
      htp.p
      ( ' <INPUT TYPE="hidden" NAME="qFolderIrid" '
      ||' VALUE="'||qFolderIrid||'">'
      );
      htp.p
      ( ' <INPUT TYPE="hidden" NAME="qFolderIvid" '
      ||' VALUE="'||qFolderIvid||'">'
      );

      if p_mode='ADVANCED'
      then
          cdwp.tableRowOpen;
          cdwp.TableDataHeading('<LABEL for=qWhere>'||Rob_msg.GetMsg(Rob_msg.CAP265_ODWASRCH_ADDLCLAUSE,'','','','')||'</LABEL>');
          htp.p('<TD ALIGN=LEFT COLSPAN=4>');
          htp.formText
          ( cname       => 'qWhere'
          , cvalue      => qWhere
          , csize       => 80
          , cmaxlength  => 2000
          , cattributes => 'id=qWhere'
          );
          htp.p(odwahelp.help_url( p_him_id => 63));
          htp.p('</TD>');
          cdwp.tableRowClose;
          cdwp.tableRowOpen;
          cdwp.TableDataHeading('<LABEL for=qIrid> Irid</LABEL>');
          htp.p('<TD ALIGN=LEFT COLSPAN=1>');
          htp.formText
          ( cname       => 'qIrid'
          , cvalue      => qIrid
          , csize       => 25
          , cmaxlength  => 45
          , cattributes => 'id=qIrid'
          );
          htp.p(odwahelp.help_url( p_him_id => 61));
          htp.p('</TD>');
          cdwp.TableDataHeading
          ( cdwp.add_images('{dependancy_manager.gif}')
          ||'<LABEL for=qDepType>'||Rob_msg.GetMsg(Rob_msg.CAP266_ODWASRCH_DEPTYPE ,'','','','')||'</LABEL>'
          );
  /*
          htp.p('<TD ALIGN=LEFT COLSPAN=2>');
          htp.formText
          ( cname       => 'qDepType'
          , cvalue      => qDepType
          , csize       => 25
          , cmaxlength  => 200
          );
          htp.p(odwahelp.help_url( p_him_id => 950));
          htp.p('</TD>');
*/
          htp.p('<TD ALIGN=LEFT ACOLSPAN=4>');
          htp.formselectopen
          ( cname   => 'qDepType'
          , cprompt => ''
          , cattributes => 'qDepType'
          );
          htp.p
          ( '<OPTION VALUE=""'
          ||'>'||Rob_msg.GetMsg(Rob_msg.CAP266_ODWASRCH_DEPTYPE ,'','','','')
          );
          htp.p
          ( '<OPTION VALUE="P"'
          ||cdwpbase.ifThenElse( qDepType = 'P', 'SELECTED=Y')
          ||'>'||Rob_msg.GetMsg(Rob_msg.CAP267_ODWASRCH_PROV,'','','','')
          );
          htp.p
          ( '<OPTION VALUE="U"'
          ||cdwpbase.ifThenElse( qDepType = 'U', 'SELECTED=Y')
          ||'>'||Rob_msg.GetMsg(Rob_msg.CAP066_ODWA_USES,'','','','')
          );
          htp.formselectclose;
          htp.p(odwahelp.help_url( p_him_id => 86));
          htp.p('</TD>');


          cdwp.tableRowClose;
          cdwp.tableRowOpen;
          cdwp.TableDataHeading('Ivid');
          htp.p('<TD ALIGN=LEFT COLSPAN=1>');
          htp.formText
          ( cname       => 'qIvid'
          , cvalue      => qIvid
          , csize       => 25
          , cmaxlength  => 45
          );
          htp.p(odwahelp.help_url( p_him_id => 62));
          htp.p('</TD>');
          cdwp.TableDataHeading
          ( cdwp.add_images('{global_name_domain.gif}')
          ||'<LABEL for=qGlobalNameType>'||Rob_msg.GetMsg(Rob_msg.CAP270_ODWASRCH_GNAMEDOM,'','','','')||'</LABEL>'
          );
          htp.p('<TD ALIGN=LEFT COLSPAN=2>');
          htp.formText
          ( cname       => 'qGlobalNameType'
          , cvalue      => qGlobalNameType
          , csize       => 25
          , cmaxlength  => 45
          ,cattributes  => 'id=qGlobalNameType'
          );
/*
          htp.formselectopen
          ( cname   => 'qGlobalNameType'
          , cprompt => ''
          );
          htp.p
          ( '<OPTION VALUE=""'
           ||cdwpbase.ifThenElse
             ( qGlobalNameType is null
             , 'SELECTED=Y'
             )
           ||'>'
           ||'Type of Element'
           );
          for r_gnt in c_gnt loop
            htp.p( '<OPTION VALUE="'||to_char(r_gnt.type_irid)||'"'
               ||cdwpbase.ifThenElse
                 ( r_gnt.type_irid = to_number(qGlobalNameType)
                 , 'SELECTED=Y'
                 )
               ||'>'
               ||r_gnt.type_name
               );
          end loop; -- r_gnt
          htp.formselectclose;
*/
          htp.p('</TD>');
          cdwp.tableRowClose;
          cdwp.tableRowOpen;
          cdwp.TableDataHeading('<LABEL for=qTxtContains>'||Rob_msg.GetMsg(Rob_msg.CAP269_ODWASRCH_MLTCONT,'','','','')||'</LABEL>');
          htp.p('<TD ALIGN=LEFT COLSPAN=1>');
          htp.formText
          ( cname       => 'qTxtContains'
          , cvalue      => qTxtContains
          , csize       => 25
          , cmaxlength  => 1000
          , cattributes => 'id=qTxtContains'
          );
          htp.p(odwahelp.help_url( p_him_id => 64));
          htp.p('</TD>');
          cdwp.TableDataHeading
          ( cdwp.add_images('{global_name.gif}')
          ||Rob_msg.GetMsg('<LABEL for=qGlobalName>'||Rob_msg.CAP268_ODWASRCH_GNAME,'','','','')||'</LABEL>');
          htp.p('<TD ALIGN=LEFT COLSPAN=2>');
          htp.formText
          ( cname       => 'qGlobalName'
          , cvalue      => qGlobalName
          , csize       => 25
          , cmaxlength  => 200
          , cattributes => 'id=qGlobalName'
          );
          htp.p(odwahelp.help_url( p_him_id => 950));
          htp.p('</TD>');
          cdwp.tableRowClose;
          cdwp.tableRowOpen;
          cdwp.TableDataHeading('<LABEL for=qFileContains>'||Rob_msg.GetMsg(Rob_msg.CAP271_ODWASRCH_FILCONT,'','','','')||'</LABEL>');
          htp.p('<TD ALIGN=LEFT COLSPAN=1>');
          htp.formText
          ( cname       => 'qFileContains'
          , cvalue      => qFileContains
          , csize       => 25
          , cmaxlength  => 1000
          , cattributes => 'id=qFileContains'
          );
          htp.p(odwahelp.help_url( p_him_id => 65));
          htp.p('</TD>');
          cdwp.TableDataHeading
          ( cdwp.add_images('{usedby.gif}')
          ||Rob_msg.GetMsg(Rob_msg.CAP067_ODWA_USEDBY,'','','',''));
          htp.p('<TD ACOLSPAN=2>');
          if nvl(qUsedByIvid,'x') <> 'x'
          then
            htp.p
            (' <TABLE BORDER=1 BGCOLOR="#FFFFFF"><TR><TD>'
            ||jr_name.GET_PATH
              ( EL_ID => to_number(qUsedByIvid)
              , EL_TYPE=> cdwpbase.get_ivid_type_id(p_ivid => to_number(qUsedByIvid))
              , FORMAT => 'NAME'
              )
            ||' ('||odwavrsn.get_version_label( p_ivid => to_number(qUsedByIvid))||')'
            ||cdwpbase.nbsp(4)
            );
          else
            htp.p
            (' <TABLE BORDER=1 BGCOLOR="#FFFFFF"><TR><TD>'
            ||cdwpbase.nbsp(20)
           );
          end if;
          htp.p(' <TD BGCOLOR="#FFFFFF"> '
          ||' <A href="javascript:invokeRobsUsedByIvid()">'
          ||cdwp.add_images( '{browse_round.gif}')
          ||'</A>'
          ||odwahelp.help_url( p_him_id => 54)
          ||'</TD>'
          ||'</TR></TABLE>'
          );
          htp.p('</TD>');
          htp.p(' <INPUT TYPE="hidden" NAME="qUsedByIvid" '
          ||' VALUE="'||qUsedByIvid||'">'
          );

          cdwp.tableRowClose;
      else
        htp.p
        ( cdwpbase.ifThenElse
          ( qIvid is not null
          , ' <INPUT TYPE="hidden" NAME="qIvid" '
          ||' VALUE="'||qIvid||'">'
          )
        ||cdwpbase.ifThenElse
          ( qIrid is not null
          , ' <INPUT TYPE="hidden" NAME="qIrid" '
          ||' VALUE="'||qIrid||'">'
          )
        ||cdwpbase.ifThenElse
          ( qWhere is not null
          , ' <INPUT TYPE="hidden" NAME="qWhere" '
          ||' VALUE="'||qWhere||'">'
          )
        ||cdwpbase.ifThenElse
          ( qTxtContains is not null
          , ' <INPUT TYPE="hidden" NAME="qTxtContains" '
          ||' VALUE="'||qTxtContains||'">'
          )
        ||cdwpbase.ifThenElse
          ( qFileContains is not null
          , ' <INPUT TYPE="hidden" NAME="qFileContains" '
          ||' VALUE="'||qFileContains||'">'
          )
        ||' <INPUT TYPE="hidden" NAME="qDepType" '
          ||' VALUE="'||qDepType||'">'
        ||cdwpbase.ifThenElse
          ( qGlobalName is not null
          , ' <INPUT TYPE="hidden" NAME="qGlobalName" '
          ||' VALUE="'||qGlobalName||'">'
          )
        ||' <INPUT TYPE="hidden" NAME="qGlobalNameType" '
          ||' VALUE="'||qGlobalNameType||'">'
        ||cdwpbase.ifThenElse
          ( qUsedByIvid is not null
          , ' <INPUT TYPE="hidden" NAME="qUsedByIvid" '
          ||' VALUE="'||qUsedByIvid||'">'
          )
        );
      end if; -- p_mode='ADVANCED'

      if p_mode='VERSION'
      then
          -- Check State
          cdwp.tableRowOpen;
          cdwp.TableDataHeading
          ( cdwp.add_images( '{checkout.gif}{checkin.gif}')
          ||'<LABEl for=qCheckState>'||Rob_msg.GetMsg(Rob_msg.CAP136_ODWAPROP_CHKSTATE ,'','','','')||'</LABEL>'
          );

          htp.p('<TD ALIGN=LEFT ACOLSPAN=4>');
          htp.formselectopen
          ( cname   => 'qCheckState'
          , cprompt => ''
          ,cattributes => 'id=qCheckState'
          );
          htp.p
          ( '<OPTION VALUE="I,O,N"'
          ||cdwpbase.ifThenElse( nvl(qCheckState,'I,O,N') = 'I,O,N', 'SELECTED=Y')
          ||'>'||Rob_msg.GetMsg(Rob_msg.CAP272_ODWASRCH_ANY,'','','','')
          );
          htp.p
          ( '<OPTION VALUE="O,N"'
          ||cdwpbase.ifThenElse( qCheckState = 'O,N', 'SELECTED=Y')
          ||'>'||Rob_msg.GetMsg(Rob_msg.CAP273_ODWASRCH_UVNCO ,'','','','')
          );
          htp.p
          ( '<OPTION VALUE="O"'
          ||cdwpbase.ifThenElse( qCheckState = 'O', 'SELECTED=Y')
          ||'>'||Rob_msg.GetMsg(Rob_msg.CAP087_ODWACHKI_CO ,'','','','')
          );
          htp.p
          ( '<OPTION VALUE="N"'
          ||cdwpbase.ifThenElse( qCheckState = 'N', 'SELECTED=Y')
          ||'>'||Rob_msg.GetMsg(Rob_msg.CAP274_ODWASRCH_UNV,'','','','')
          );
          htp.p
          ( '<OPTION VALUE="I"'
          ||cdwpbase.ifThenElse( qCheckState = 'I', 'SELECTED=Y')
          ||'>'||Rob_msg.GetMsg(Rob_msg.DSP331_ODWARPRTS_CIN ,'','','','')
          );
          htp.formselectclose;
          htp.p(odwahelp.help_url( p_him_id => 86));
          htp.p('</TD>');

          -- Version Label
          htp.tableData
           ( cdwp.add_images('')
          ||'<LABEL for=qVersionLabel>'||Rob_msg.GetMsg(Rob_msg.CAP093_ODWACHKI_VERLBL,'','','','')||'</LABEL>'
           ,'RIGHT'
           , cattributes=> 'VALIGN="TOP" class="t2"'
           );
          htp.p('<TD ALIGN=LEFT ACOLSPAN=4>');
          htp.formtext
          ( cname   => 'qVersionLabel'
          , cvalue  => qVersionLabel
          , csize      => 10
          , cmaxlength => 40
          , cattributes => 'id=qVersionLabel'
          );
          htp.p(odwahelp.help_url( p_him_id => 81));
          htp.p('</TD>');

          -- Check Notes
          htp.tableData
           ( cdwp.add_images('')
          ||'<LABEL for=qCheckNotesContain>'||Rob_msg.GetMsg(Rob_msg.CAP275_ODWASRCH_CNHAS,'','','','')||'</LABEL>'
           ,'RIGHT'
           , cattributes=> 'VALIGN="TOP" class="t2"'
           );
          htp.p('<TD ALIGN=LEFT ACOLSPAN=4>');
          htp.formtext
          ( cname   => 'qCheckNotesContain'
          , cvalue  => qCheckNotesContain
          , csize      => 20
          , cmaxlength => 100
          , cattributes => 'id=qCheckNotesContain'
          );
          htp.p(odwahelp.help_url( p_him_id => 82));
          htp.p('</TD>');
          cdwp.tableRowClose;
          -- BRANCH
          cdwp.tableRowOpen;
          cdwp.TableDataHeading
          ( cdwp.add_images('{branch.gif}')
          ||'<LABEL for=qBranchIrid>'||Rob_msg.GetMsg(Rob_msg.CAP276_ODWASRCH_ONFROM,'','','','')||'</LABEL>'
          );
          htp.p('<TD ALIGN=LEFT COLSPAN=1>');
          htp.formselectopen
          ( cname   => 'qBranchIrid'
          , cprompt => ''
          , cattributes =>'id=qBranchIrid'
          );
          htp.p
          ( '<OPTION VALUE=""'
           ||cdwpbase.ifThenElse
             ( qBranchIrid is null
             , 'SELECTED=Y'
             )
           ||'>'
           ||Rob_msg.GetMsg(Rob_msg.CAP277_ODWASRCH_BRLABEL,'','','','')
           );
          for r_brh in c_brh loop
            htp.p( '<OPTION VALUE="'||to_char(r_brh.irid)||'"'
               ||cdwpbase.ifThenElse
                 ( r_brh.irid = qBranchIrid
                 , 'SELECTED=Y'
                 )
               ||'>'
               ||r_brh.name
               );
          end loop; -- r_brh
          htp.formselectclose;
          htp.p(odwahelp.help_url( p_him_id => 83));

          htp.p('</TD>');
          -- ONLY ROOT of ON BRANCHES
          htp.p('<TD COLSPAN=1><b>'
          ||'<LABEL for=qRootVersionsOnly>'||Rob_msg.GetMsg(Rob_msg.CAP278_ODWASRCH_ROOTVER,'','','','')||'</LABEL></b>');
          htp.formCheckBox
          ( CNAME        => 'qRootVersionsOnly'
          , CVALUE       => 'YES'
          , CCHECKED     => cdwpbase.ifThenElse( qRootVersionsOnly is not null, 'YES')
          , CATTRIBUTES  => 'id=qRootVersionsOnly'
          );
          htp.p(odwahelp.help_url( p_him_id => 84));
          htp.p('</TD>');

          -- Configuration

          htp.tableData
           (cdwp.add_images('{configuration.gif}')
          ||Rob_msg.GetMsg(Rob_msg.CAP279_ODWASRCH_INCONF,'','','','')
           ,'RIGHT'
           , cattributes=> 'VALIGN="TOP" class="t2"'
           );
          htp.p('<TD COLSPAN=2>');
          htp.p
          (' <TABLE BORDER=1 BGCOLOR="#FFFFFF"><TR><TD>'
          ||cdwpbase.get_cfg_name
            ( p_cfg_ivid => qCfgIvid
            , p_FORMAT   => 'VLABEL'
            )
          ||cdwpbase.ifThenElse
            ( qCfgIvid is null
            , cdwpbase.nbsp(20)
            , cdwpbase.nbsp(4)
            )
          ||' <A href="javascript:invokeRobsCfgIvid()">'
          ||cdwp.add_images( '{browse_round.gif}')
          ||'</A>'
          ||odwahelp.help_url( p_him_id => 85)
          ||'</TD></TR></TABLE>'
          );
          htp.p('</TD>');

          cdwp.tableRowClose;


          -- Check Out User
          cdwp.tableRowOpen;
          cdwp.TableDataHeading
          ( cdwp.add_images('{checkout.gif}{user.gif}')
          ||'<LABEL for=qCheckOutUser>'||Rob_msg.GetMsg(Rob_msg.CAP280_ODWASRCH_COBY,'','','','')||'</LABEL>'
          );
          htp.p('<TD ALIGN=LEFT>');
          htp.formselectopen
          ( cname   => 'qCheckOutUser'
          , cprompt => ''
          , cattributes => 'id=qCheckOutUser'
          );
          htp.p
          ( '<OPTION VALUE=""'
           ||cdwpbase.ifThenElse
             ( qCheckOutUser is null
             , 'SELECTED=Y'
             )
           ||'>'
           ||Rob_msg.GetMsg(Rob_msg.CAP281_ODWASRCH_ANYREPUSR,'','','','')
           );
          for r_usr in c_usr loop
            htp.p( '<OPTION VALUE="'||r_usr.username||'"'
               ||cdwpbase.ifThenElse
                 ( r_usr.username = qCheckOutUser
                 , 'SELECTED=Y'
                 )
               ||'>'
               ||r_usr.full_user_name
               );
          end loop; -- r_usr
          htp.formselectclose;
          htp.p(odwahelp.help_url( p_him_id => 86));
          htp.p('</TD>');
          -- CheckInUser
          cdwp.TableDataHeading
          ( cdwp.add_images('{checkin.gif}{user.gif}')
          ||'<LABEL for=qCheckInUser>'||Rob_msg.GetMsg(Rob_msg.CAP282_ODWASRCH_CINBY,'','','','')||'</LABEL>'
          );
          htp.p('<TD ALIGN=LEFT COLSPAN=3>');
          htp.formselectopen
          ( cname   => 'qCheckInUser'
          , cprompt => ''
          , cattributes =>'id=qCheckInUser'
          );
          htp.p
          ( '<OPTION VALUE=""'
           ||cdwpbase.ifThenElse
             ( qCheckInUser is null
             , 'SELECTED=Y'
             )
           ||'>'
           ||Rob_msg.GetMsg(Rob_msg.CAP281_ODWASRCH_ANYREPUSR,'','','','')
           );
          for r_usr in c_usr loop
            htp.p( '<OPTION VALUE="'||r_usr.username||'"'
               ||cdwpbase.ifThenElse
                 ( r_usr.username = qCheckInUser
                 , 'SELECTED=Y'
                 )
               ||'>'
               ||r_usr.full_user_name
               );
          end loop; -- r_usr
          htp.formselectclose;
          htp.p(odwahelp.help_url( p_him_id => 87));
          htp.p('</TD>');
          cdwp.tableRowClose;




          -- Checked Out After/Before
          cdwp.tableRowOpen;
          cdwp.TableDataHeading
          ( cdwp.add_images( '{checkout.gif}')
          ||'<LABEL for=qCheckedOutAfter>'||Rob_msg.GetMsg(Rob_msg.CAP283_ODWASRCH_COAFTER,'','','','')||'</LABEL>'
          );
          htp.p('<TD ALIGN=LEFT COLSPAN=2>');
          htp.formtext
          ( cname   => 'qCheckedOutAfter'
          , cvalue  => qCheckedOutAfter
          , csize      => 20
          , cmaxlength => 25
          , cattributes => 'id=qCheckedOutAfter'
          );
          htp.p( '<font face="Arial Narrow"><font size=-1>DD-MON-YYYY [HH24[:MI]]</font></font>');
          htp.p(odwahelp.help_url( p_him_id => 88));
          htp.p('</TD>');
          cdwp.TableDataHeading
          ( cdwp.add_images( '{checkout.gif}')
          ||'<LABEL for=qCheckedOutBefore>'||Rob_msg.GetMsg(Rob_msg.CAP284_ODWASRCH_COBEFORE,'','','','')||'</LABEL>'
          );
          htp.p('<TD ALIGN=LEFT COLSPAN=2>');
          htp.formtext
          ( cname   => 'qCheckedOutBefore'
          , cvalue  => qCheckedOutBefore
          , csize      => 20
          , cmaxlength => 25
          , cattributes =>'id=qCheckedOutBefore'
          );
          htp.p(odwahelp.help_url( p_him_id => 89));
          htp.p('</TD>');
          cdwp.tableRowClose;
          -- Checked In After/Before
          cdwp.tableRowOpen;
          cdwp.TableDataHeading
          ( cdwp.add_images( '{checkin.gif}')
          ||'<LABEL for=qCheckedInAfter>'||Rob_msg.GetMsg(Rob_msg.CAP285_ODWASRCH_CIAFTER,'','','','')||'</LABEL>'
          );
          htp.p('<TD ALIGN=LEFT COLSPAN=2>');
          htp.formtext
          ( cname   => 'qCheckedInAfter'
          , cvalue  => qCheckedInAfter
          , csize      => 20
          , cmaxlength => 25
          , cattributes => 'id=qCheckedInAfter'
          );
          htp.p( '<font face="Arial Narrow"><font size=-1>DD-MON-YYYY [HH24[:MI]]</font></font>');
          htp.p(odwahelp.help_url( p_him_id => 90));
          htp.p('</TD>');
          cdwp.TableDataHeading
          ( cdwp.add_images( '{checkin.gif}')
          ||'<LABEL for=qCheckedInBefore>'||Rob_msg.GetMsg(Rob_msg.CAP286_ODWASRCH_CIBEFORE,'','','','')||'</LABEL>'
          );
          htp.p('<TD ALIGN=LEFT COLSPAN=2>');
          htp.formtext
          ( cname   => 'qCheckedInBefore'
          , cvalue  => qCheckedInBefore
          , csize      => 20
          , cmaxlength => 25
          , cattributes=>'id=qCheckedInBefore'
          );
          htp.p(odwahelp.help_url( p_him_id => 91));

          htp.p('</TD>');
          cdwp.tableRowClose;



      else
        htp.p
        (  ' <INPUT TYPE="hidden" NAME="qCheckState" '
          ||' VALUE="'||qCheckState||'">'
        ||cdwpbase.ifThenElse
          ( qVersionLabel is not null
          , ' <INPUT TYPE="hidden" NAME="qVersionLabel" '
          ||' VALUE="'||qVersionLabel||'">'
          )
        ||cdwpbase.ifThenElse
          ( qCheckInUser is not null
          , ' <INPUT TYPE="hidden" NAME="qCheckInUser" '
          ||' VALUE="'||qCheckInUser||'">'
          )
        ||cdwpbase.ifThenElse
          ( qCheckOutUser is not null
          , ' <INPUT TYPE="hidden" NAME="qCheckOutUser" '
          ||' VALUE="'||qCheckOutUser||'">'
          )
        ||cdwpbase.ifThenElse
          ( qCheckNotesContain is not null
          , ' <INPUT TYPE="hidden" NAME="qCheckNotesContain" '
          ||' VALUE="'||qCheckNotesContain||'">'
          )
        ||cdwpbase.ifThenElse
          ( qBranchIrid is not null
          , ' <INPUT TYPE="hidden" NAME="qBranchIrid" '
          ||' VALUE="'||qBranchIrid||'">'
          )
        ||cdwpbase.ifThenElse
          ( qRootVersionsOnly is not null
          , ' <INPUT TYPE="hidden" NAME="qRootVersionsOnly" '
          ||' VALUE="'||qRootVersionsOnly||'">'
          )
        ||cdwpbase.ifThenElse
          ( qCheckedOutBefore is not null
          , ' <INPUT TYPE="hidden" NAME="qCheckedOutBefore" '
          ||' VALUE="'||qCheckedOutBefore||'">'
          )
        ||cdwpbase.ifThenElse
          ( qCheckedOutAfter is not null
          , ' <INPUT TYPE="hidden" NAME="qCheckedOutAfter" '
          ||' VALUE="'||qCheckedOutAfter||'">'
          )
        ||cdwpbase.ifThenElse
          ( qCheckedInBefore is not null
          , ' <INPUT TYPE="hidden" NAME="qCheckedInBefore" '
          ||' VALUE="'||qCheckedInBefore||'">'
          )
        ||cdwpbase.ifThenElse
          ( qCheckedInAfter is not null
          , ' <INPUT TYPE="hidden" NAME="qCheckedInAfter" '
          ||' VALUE="'||qCheckedInAfter||'">'
          )
        );
      end if; -- p_mode='VERSION'
      htp.p( ' <INPUT TYPE="hidden" NAME="qCfgIvid" '
          ||' VALUE="'||qCfgIvid||'">'
          );


      if p_mode='AUDIT'
      then
          -- CreatedAfter/Before
          cdwp.tableRowOpen;
          cdwp.TableDataHeading
          ( '<LABEL for=qCreatedAfter>'||Rob_msg.Getmsg(Rob_msg.CAP316_ODWASRCH_CRAFTER,'','','','')||'</LABEL>'
          );
          htp.p('<TD ALIGN=LEFT COLSPAN=2>');
          htp.formtext
          ( cname      => 'qCreatedAfter'
          , cvalue     => qCreatedAfter
          , csize      => 20
          , cmaxlength => 25
          , cattributes=> 'id=qCreatedAfter'
          );
          htp.p( '<font face="Arial Narrow"><font size=-1>DD-MON-YYYY [HH24[:MI]]</font></font>');
          htp.p(odwahelp.help_url( p_him_id => 71));
          htp.p('</TD>');
          cdwp.TableDataHeading
          ( '<LABEL for=qCreatedBefore>'||Rob_msg.GetMsg(Rob_msg.CAP287_ODWASRCH_CRBEFORE,'','','','')||'</LABEL>'
          );
          htp.p('<TD ALIGN=LEFT COLSPAN=2>');
          htp.formtext
          ( cname   => 'qCreatedBefore'
          , cvalue  => qCreatedBefore
          , csize      => 20
          , cmaxlength => 25
          , cattributes=>'qCreatedBefore'
          );
          htp.p( '<font face="Arial Narrow"><font size=-1>DD-MON-YYYY [HH24[:MI]]</font></font>');
          htp.p(odwahelp.help_url( p_him_id => 72));
          htp.p('</TD>');
          cdwp.tableRowClose;
          -- CreatedBy
          cdwp.tableRowOpen;
          cdwp.TableDataHeading
          ( cdwp.add_images('{user.gif}')
          ||'<LABEL for=qCreatedBy>'||Rob_msg.GetMsg(Rob_msg.DSP249_ODWAINFO_CREATEDBY,'','','','')||'</LABEL>'
          );
          htp.p('<TD ALIGN=LEFT COLSPAN=4>');
          htp.formselectopen
          ( cname   => 'qCreatedBy'
          , cprompt => ''
          , cattributes => 'id=qCreatedBy'
          );
          htp.p
          ( '<OPTION VALUE=""'
           ||cdwpbase.ifThenElse
             ( qCreatedBy is null
             , 'SELECTED=Y'
             )
           ||'>'
           ||Rob_msg.GetMsg(Rob_msg.CAP281_ODWASRCH_ANYREPUSR,'','','','')
           );
          for r_usr in c_usr loop
            htp.p( '<OPTION VALUE="'||r_usr.username||'"'
               ||cdwpbase.ifThenElse
                 ( r_usr.username = qCreatedBy
                 , 'SELECTED=Y'
                 )
               ||'>'
               ||r_usr.full_user_name
               );
          end loop; -- r_usr
          htp.formselectclose;
          htp.p(odwahelp.help_url( p_him_id => 73));
          htp.p('</TD>');
          cdwp.tableRowClose;

          -- ChangedAfter/Before
          cdwp.tableRowOpen;
          cdwp.TableDataHeading
          ( '<LABEL for=qChangedAfter>'||Rob_msg.GetMsg(Rob_msg.CAP288_ODWASRCH_CHAFTER,'','','','')||'</LABEL>'
          );
          htp.p('<TD ALIGN=LEFT COLSPAN=2>');
          htp.formtext
          ( cname   => 'qChangedAfter'
          , cvalue  => qChangedAfter
          , csize      => 20
          , cmaxlength => 25
          , cattributes=>'id=qChangedAfter'
          );
          htp.p( '<font face="Arial Narrow"><font size=-1>DD-MON-YYYY [HH24[:MI]]</font></font>');
          htp.p(odwahelp.help_url( p_him_id => 74));
          htp.p('</TD>');
          cdwp.TableDataHeading
          ( '<LABEL for=qChangedBefore>'||Rob_msg.GetMsg(Rob_msg.CAP289_ODWASRCH_CHBEFORE,'','','','')||'</LABEL>'
          );
          htp.p('<TD ALIGN=LEFT COLSPAN=2>');
          htp.formtext
          ( cname   => 'qChangedBefore'
          , cvalue  => qChangedBefore
          , csize      => 20
          , cmaxlength => 25
          , cattributes=>'id=qChangedBefore'
          );
          htp.p( '<font face="Arial Narrow"><font size=-1>DD-MON-YYYY [HH24[:MI]]</font></font>');
          htp.p(odwahelp.help_url( p_him_id => 75));
          htp.p('</TD>');
          cdwp.tableRowClose;

          -- ChangedBy
          cdwp.tableRowOpen;
          cdwp.TableDataHeading
          ( cdwp.add_images('{user.gif}')
          ||'<LABEL for=qChangedBy>'||Rob_msg.GetMsg(Rob_msg.DSP250_ODWAINFO_MODBY,'','','','')||'</LABEL>'
          );
          htp.p('<TD ALIGN=LEFT COLSPAN=4>');
          htp.formselectopen
          ( cname   => 'qChangedBy'
          , cprompt => ''
          , cattributes => 'id=qChangedBy'
          );
          htp.p
          ( '<OPTION VALUE=""'
           ||cdwpbase.ifThenElse
             ( qChangedBy is null
             , 'SELECTED=Y'
             )
           ||'>'
           ||Rob_msg.GetMsg(Rob_msg.CAP281_ODWASRCH_ANYREPUSR,'','','','')
           );
          for r_usr in c_usr loop
            htp.p( '<OPTION VALUE="'||r_usr.username||'"'
               ||cdwpbase.ifThenElse
                 ( r_usr.username = qChangedBy
                 , 'SELECTED=Y'
                 )
               ||'>'
               ||r_usr.full_user_name
               );
          end loop; -- r_usr
          htp.formselectclose;
          htp.p(odwahelp.help_url( p_him_id => 76));
          htp.p('</TD>');
          cdwp.tableRowClose;
          -- Check State
          cdwp.tableRowOpen;
          cdwp.TableDataHeading
          ( cdwp.add_images( '{wastebasket.gif}')
          ||'<LABEL for=qWastebasket>'||Rob_msg.GetMsg(Rob_msg.CAP290_ODWASRCH_WBSTATE,'','','','')||'</LABEL>'
          );

          htp.p('<TD ALIGN=LEFT ACOLSPAN=4>');
          htp.formselectopen
          ( cname   => 'qWastebasket'
          , cprompt => ''
          , cattributes=>'id=qWastebasket'
          );
          htp.p
          ( '<OPTION VALUE="N"'
          ||cdwpbase.ifThenElse( nvl(qWastebasket,'N') = 'N', 'SELECTED=Y')
          ||'>'||Rob_msg.GetMsg(Rob_msg.CAP291_ODWASRCH_NOWBCONT,'','','','')
          );
          htp.p
          ( '<OPTION VALUE="Y"'
          ||cdwpbase.ifThenElse( qWastebasket = 'Y', 'SELECTED=Y')
          ||'>'||Rob_msg.GetMsg(Rob_msg.CAP292_ODWASRCH_ONLYWB,'','','','')
          );
          htp.formselectclose;
          htp.p(odwahelp.help_url( p_him_id => 77));
          htp.p('</TD>');
          cdwp.tablerowclose;
      else
        htp.p
        ( cdwpbase.ifThenElse
          ( qCreatedBy is not null
          , ' <INPUT TYPE="hidden" NAME="qCreatedBy" '
          ||' VALUE="'||qCreatedBy||'">'
          )
        ||cdwpbase.ifThenElse
          ( qCreatedBefore is not null
          , ' <INPUT TYPE="hidden" NAME="qCreatedBefore" '
          ||' VALUE="'||qCreatedBefore||'">'
          )
        ||cdwpbase.ifThenElse
          ( qCreatedAfter is not null
          , ' <INPUT TYPE="hidden" NAME="qCreatedAfter" '
          ||' VALUE="'||qCreatedAfter||'">'
          )
        ||cdwpbase.ifThenElse
          ( qChangedBy is not null
          , ' <INPUT TYPE="hidden" NAME="qChangedBy" '
          ||' VALUE="'||qChangedBy||'">'
          )
        ||cdwpbase.ifThenElse
          ( qChangedBefore is not null
          , ' <INPUT TYPE="hidden" NAME="qChangedBefore" '
          ||' VALUE="'||qChangedBefore||'">'
          )
        ||cdwpbase.ifThenElse
          ( qChangedAfter is not null
          , ' <INPUT TYPE="hidden" NAME="qChangedAfter" '
          ||' VALUE="'||qChangedAfter||'">'
          )
        ||' <INPUT TYPE="hidden" NAME="qWastebasket" '
          ||' VALUE="'||qWastebasket||'">'
       );
      end if; -- p_mode='AUDIT'
      htp.p( ' <INPUT TYPE="hidden" NAME="p_run_mode" '
          ||' VALUE="search">'
          );


      cdwp.tableRowOpen;
      cdwp.TableDataHeading('');
      htp.p
      (' <TD BGCOLOR="#FFFFFF" COLSPAN="4"><A href="javascript:transferQueryForm();'
      ||'top.resultFrame.document.queryForm.submit()'
      ||' ">'
      ||cdwp.add_images( '{search_round.gif}')
      ||'</A>'
      ||cdwpbase.nbsp(10)
      ||'<A href="javascript:resetQueryForm()'
      ||' ">'
      ||cdwp.add_images( '{reset_round.gif}')
      ||'</A>'
      ||cdwpbase.nbsp(10)
      ||'<A href="javascript:transferQueryForm();'
      ||'top.resultFrame.document.queryForm.p_run_mode.value=''saveQuery'';'
      ||'saveQuery()'
      ||' ">'
      ||cdwp.add_images( '{save_round.gif}', p_attributes => 'ALT="'||Rob_msg.GetMsg(Rob_msg.CAP236_ODWASLIB_SAVE ,'','','','')||'"')
      ||'</A>'
      ||cdwpbase.nbsp(10)
      ||'<A href="javascript:openLibrary()'
      ||' ">'
      ||cdwp.add_images( '{library_round.gif}', p_attributes => 'ALT="'||Rob_msg.GetMsg(Rob_msg.DSP352_ODWASRCH_USEQRY,'','','','')||'"')
      ||'</A>'
      ||'</TD>
      ');
      cdwp.tableRowClose;
      htp.formClose;

      cdwp.tableClose;


    htp.bodyClose;
    htp.htmlClose;
  end if; -- qQueryId is not null
end; -- queryFrame


procedure js_dynamic_content
( imagePath     in varchar2
, checkedImage  in varchar2
, wbasketImage  in varchar2

, launchProc    in varchar2

, verHistLabel  in varchar2
, verHistProc   in varchar2
, verHistImg    in varchar2

, browserLabel  in varchar2
, browserProc   in varchar2
, browserImg    in varchar2

, infoPopLabel  in varchar2
, infoPopProc   in varchar2
, infoPopImg    in varchar2
) is
begin
  htp.p('<SCRIPT>');
  htp.p('var types = new Array;');
  htp.p('var currentName = "";');
  htp.p('');
  htp.p('function AddType(id,icon,name) {');
  htp.p('  if (types[id] == null)');
  htp.p('    types[id]=new Array(icon,name);');
  htp.p('}');
  htp.p('');
  htp.p('function GetIcon(id) {');
  htp.p('  if (types[id] == null)');
  htp.p('    return "unknown.gif"');
  htp.p('  else');
  htp.p('    return types[id][0]');
  htp.p('}');
  htp.p('');
  htp.p('function GetTypeName(id) {');
  htp.p('  if (types[id] == null)');
  htp.p('    return "Unknown"');
  htp.p('  else');
  htp.p('    return types[id][1]');
  htp.p('}');
  htp.p('');
  htp.p('function IsFile(id) {');
  htp.p('  return (id == 4819);');
  htp.p('}');
  htp.p('');
  htp.p('function sel(ivid) {');
  htp.p('  parent.selected(ivid);');
  htp.p('}');
  htp.p('');
  htp.p('function BuildUrl(proc,ivid,image,alt,text,params) {');
  htp.p('  currentName = currentName.split(''"''); 
           currentName = currentName.join(''&quot;''); ');
  htp.p('  currentName = currentName.split(''\''''); 
           currentName = currentName.join(''\\\''''); ');
  htp.p('  url = "<A HREF=\"javascript:"+proc+"(''"+ivid+"''";');
  -- 3.12 next line is new to use download through servlet
  htp.p('  if (proc == "go") url += ", ''"+currentName+"''";');
  htp.p('  if (params != null) url+= ","+params;');
  htp.p('  url += ");\"><IMG src=\"'||imagePath||'"+image+"\" border=0 ALT=\""+alt+"\">";');
  htp.p('  if (text != null) url += text;');
  htp.p('  return url + "</A>";');
  htp.p('}');
  htp.p('');
  htp.p('function wi (name,typeid,ivid,version,path,state,wbasket,timestamp,notes) {');
  -- 3.12 next line is new to use download through servlet
  htp.p('  currentName = name;');
  htp.p('  document.write("<TR><TD>");');
  htp.p('  if (wbasket == "Y") document.write("<IMG src='|| imagePath || wbasketImage ||' BORDER=0 ALT=\"'
  || Rob_msg.Getmsg(rob_msg.DSP247_ODWAINFO_INWB,'','','','')
  ||'\">");');
  htp.p('  document.write("</TD><TD>");');
  htp.p('  if (state == "O") document.write("<IMG src='|| imagePath || checkedImage ||' BORDER=0 ALT=\"'
  || Rob_msg.Getmsg(rob_msg.CAP087_ODWACHKI_CO,'','','','')
  ||'\">");');
  htp.p('  document.write("</TD><TD>"+BuildUrl('''|| launchProc ||''',ivid,GetIcon(typeid), ''Show'',name, IsFile(typeid)?''true'':''false'')+"</TD>");');
  htp.p('  document.write("<TD>"+version+"</TD>");');
  htp.p('  document.write("<TD>"+BuildUrl('''|| verHistProc || ''',ivid,'''|| verHistImg ||''', '''|| verHistLabel ||'''));');
  htp.p('  document.write(BuildUrl('''|| browserProc || ''',ivid,'''|| browserImg ||''', '''|| browserLabel ||''')+"</TD>");');
  htp.p('  document.write("<TD>"+path+"</TD>");');
  htp.p('  document.write("<TD><B>"+GetTypeName(typeid)+"</B></TD>");');
  htp.p('  document.write("<TD CLASS=np>"+timestamp+"</TD>");');
  htp.p('  document.write("<TD>"+BuildUrl('''|| infoPopProc || ''',ivid,'''|| infoPopImg ||''', '''|| infoPopLabel ||''')+"</TD>");');
  htp.p('  document.write("<TD>"+notes+"</TD>");');
  htp.p('  document.write("</TR>");');
  htp.p('}');
  htp.p('');
  htp.p('</SCRIPT>
       <NOSCRIPT>'|| Rob_msg.getmsg(rob_msg.ACC005_NOSCRIPT,'','','','')||'</NOSCRIPT>');
end;


procedure showSql
( p_session_id    in   number
, qName              in   varchar2 default null  -- BASIC
, qCaseSensitive     in   varchar2 default null
, qWorkareaIrid      in   varchar2 default null
, qTipVersionsOnly   in   varchar2 default null
, qFolderIrid        in   varchar2 default null
, qFolderIvid        in   varchar2 default null
, qIncludeNested     in   varchar2 default null
, qElementType       in   varchar2 default null
, qIvid              in   varchar2 default null  -- ADVANCED
, qIrid              in   varchar2 default null
, qTxtType           in   varchar2 default null
, qTxtContains       in   varchar2 default null
, qFileContains      in   varchar2 default null
, qDepType           in   varchar2 default null
, qGlobalName        in   varchar2 default null
, qGlobalNameType    in   varchar2 default null
, qUsedByIvid        in   varchar2 default null
, qCheckState        in   varchar2 default null  -- VERSION
, qRootVersionsOnly  in   varchar2 default null
, qVersionLabel      in   varchar2 default null
, qBranchIrid        in   varchar2 default null
, qCfgIvid           in   varchar2 default null
, qCheckNotesContain in   varchar2 default null
, qCheckOutUser      in   varchar2 default null
, qCheckedOutAfter   in   varchar2 default null
, qCheckedOutBefore  in   varchar2 default null
, qCheckInUser       in   varchar2 default null
, qCheckedInAfter    in   varchar2 default null
, qCheckedInBefore   in   varchar2 default null
, qCheckedInAt       in   varchar2 default null
, qCreatedBy         in   varchar2 default null  -- AUDIT
, qCreatedAfter      in   varchar2 default null
, qCreatedBefore     in   varchar2 default null
, qChangedBy         in   varchar2 default null
, qChangedAfter      in   varchar2 default null
, qChangedBefore     in   varchar2 default null
, qWastebasket in   varchar2 default null
, qWhere             in   varchar2 default null
, qOrderBy           in   varchar2 default null
)
is
 l_query varchar2(20000);
 l_where varchar2(2000);
  l_element_type  varchar2(2000):= qElementType;
begin
  -- create session when necessary, refresh session cache, set workarea context
  -- from here on reference to odwactxt.get_... functions for any context value
  odwactxt.update_context
  ( p_session_id    => p_session_id
  , p_package_name  => PACKAGE_NAME
  , p_procedure_name=> 'showSql'
  , p_new_request => false
  );
        if qElementType = '-4907'  -- BRDD
        then
           l_where :=
           ' exists (select 1
                     from   cdi_text
                     where  txt_ref = ci.id
                     and    txt_type = ''CDINOT''
                     and    txt_text like ''%<TY>%''
                     and    parent_ivid = ci.ivid
                     ) ';
           l_element_type:='4907';
         end if;
         if qElementType = '-5024'  -- BR
         then
           l_where :=
           ' exists ( select ''x'' from dual where cdwp_chk_fun_is_business_rule
             ( ci.id
             , ci.function_label
             , ci.function_type ) = ''Y''
             )
             ';
           l_element_type:='5024';
        end if;
        if qElementType ='5024'   -- FUN
        then
           l_where :=
           ' exists ( select ''x'' from dual where cdwp_chk_fun_is_business_rule
             ( ci.id
             , ci.function_label
             , ci.function_type ) = ''N''
             )
             ';
        end if;
        -- compose l_where based on what was added complemented with
        -- the qWhere passed in
        if qWhere is not null
        then
          l_where:= l_where
          ||cdwpbase.ifThenElse
            ( l_where is not null
            , ' AND '||qWhere
            , qWhere
            )
          ;
        end if; -- qWhere is not null
    odwasrch.runSearch
    ( qName             => qName
    , qCaseSensitive    => qCaseSensitive
    , qWorkareaIrid     => cdwpbase.ifThenElse( qWorkareaIrid <> 'null', qWorkareaIrid)
    , qFolderIrid       => qFolderIrid
    , qFolderIvid       => qFolderIvid
    , qIncludeNested    => qIncludeNested
    , qElementType      => cdwpbase.ifThenElse( qElementType <> 'null', l_Element_Type)
    , qIvid             => qIvid
    , qIrid             => qIrid
    , qTxtType          => qTxtType
    , qTxtContains      => qTxtContains
    , qFileContains      => qFileContains
      , qDepType           => qDepType
      , qGlobalName        => qGlobalName
      , qGlobalNameType    => qGlobalNameType
      , qUsedByIvid        => qUsedByIvid
    , qCheckState       => qCheckState
    , qTipVersionsOnly  => qTipVersionsOnly
    , qRootVersionsOnly  => qRootVersionsOnly
    , qVersionLabel     => qVersionLabel
    , qBranchIrid       => qBranchIrid
    , qCfgIvid          => qCfgIvid
    , qCheckNotesContain=> qCheckNotesContain
    , qCheckOutUser        => qCheckOutUser
    , qCheckedOutAfter     => qCheckedOutAfter
    , qCheckedOutBefore    => qCheckedOutBefore
    , qCheckInUser        => qCheckInUser
    , qCheckedInAfter     => qCheckedInAfter
    , qCheckedInBefore    => qCheckedInBefore
    , qCreatedBy        => qCreatedBy
    , qCreatedAfter     => qCreatedAfter
    , qCreatedBefore    => qCreatedBefore
    , qChangedBy        => qChangedBy
    , qChangedAfter     => qChangedAfter
    , qChangedBefore    => qChangedBefore
    , qWastebasket => qWastebasket
    , qWhere            => l_Where
    , p_order_by        => qOrderBy
    , p_show_sql_only   => true
    );
    htp.htmlOpen;
    htp.headOpen;
    cdwp.write_about(package_name, revision_label);
    htp.title(Rob_msg.GetMsg(Rob_msg.DSP353_ODWASRCH_SRCHSQL ,'','','',''));
    htp.headClose;

    htp.bodyOpen
    ( cattributes=>'BGCOLOR="#FFFFFF" '
    );
      htp.formopen
      ( curl         => 'no url'
      , cmethod      => 'POST'
      , cattributes  => 'NAME="queryForm" '
      , ctarget      => ''
      );
      htp.p
      ( ' <INPUT TYPE="hidden" NAME="p_session_id" '
      ||' VALUE="'||to_char(p_session_id)||'">'
      );
      htp.p
      ( ' <INPUT TYPE="hidden" NAME="query" '
      ||' VALUE="'||l_query||'">'
      );
      htp.formClose;
    htp.p
    ( '<PRE>'
    ||htf.escape_sc
      ( odwasrch.get_last_search_query
      )
    ||'</PRE>'
    );
    htp.bodyClose;
    htp.htmlClose;
end; -- showSql






function visible
( p_irid in number
, p_type_id in number default null
, p_user in varchar2 default USER
) return boolean
is
  l_type_id number(38):= nvl( p_type_id, cdwpbase.get_type_id(p_el_id => p_irid));
  cursor c_el
         ( b_irid in number
         , b_user in varchar2
         ) is
    select 'x'
    from   dual
    where  exists
           ( select 'x'
             from   i$sdd_folder_members fmo
             ,      sdw_access_rights    acc
             where  fmo.member_object     = b_irid
             and    fmo.folder_reference  = acc.object_reference
             and    acc.grantee_reference in ( b_user ,'PUBLIC')
           )
   ;
  cursor c_fol
         ( b_irid in number
         , b_user in varchar2
         ) is
    select 'x'
    from   dual
    where  exists
           ( select 'x'
             from   sdw_access_rights    acc
             where  acc.object_reference = b_irid
             and    acc.grantee_reference in ( b_user,'PUBLIC')
           )
   ;
 l_test varchar2(1);
begin
     if l_type_id in (4844,4845,5009) -- FOL, CEL, APP
     then
       open c_fol( b_irid => p_irid, b_user => p_user);
       fetch c_fol
       into  l_test;
       close c_fol;
       return nvl(l_test,'y')='x';
     else
       open c_el( b_irid => p_irid, b_user => p_user);
       fetch c_el
       into  l_test;
       close c_el;
       return nvl(l_test,'y')='x';
    end if; -- l_type_id in (4844,4845,5009)
end; -- visible

function is_global_search_user
( p_user in varchar2 default USER
) return boolean
is
begin
   return instr
           ( ','||nvl(odwapref.get_value(p_preference_name => 'global_search_users'),'X')||','
           , ','||USER||','
           ) > 0
           ;
end; -- is_global_search_user


procedure resultFrame9
( p_session_id    in   number
, p_mode             in   varchar2  default 'BASIC' -- values: BASIC, ADVANCED ( ??AUDIT, VERSION)
, qName              in   varchar2 default null  -- BASIC
, qCaseSensitive     in   varchar2 default null
, qWorkareaIrid      in   varchar2 default null
, qTipVersionsOnly   in   varchar2 default null
, qFolderIrid        in   varchar2 default null
, qFolderIvid        in   varchar2 default null
, qIncludeNested     in   varchar2 default null
, qElementType       in   varchar2 default null
, qIvid              in   varchar2 default null  -- ADVANCED
, qIrid              in   varchar2 default null
, qTxtType           in   varchar2 default null
, qTxtContains       in   varchar2 default null
, qFileContains      in   varchar2 default null
, qDepType           in   varchar2 default null
, qGlobalName        in   varchar2 default null
, qGlobalNameType    in   varchar2 default null
, qUsedByIvid        in   varchar2 default null
, qCheckState        in   varchar2 default null  -- VERSION
, qRootVersionsOnly  in   varchar2 default null
, qVersionLabel      in   varchar2 default null
, qBranchIrid        in   varchar2 default null
, qCfgIvid           in   varchar2 default null
, qCheckNotesContain in   varchar2 default null
, qCheckOutUser      in   varchar2 default null
, qCheckedOutAfter   in   varchar2 default null
, qCheckedOutBefore  in   varchar2 default null
, qCheckInUser       in   varchar2 default null
, qCheckedInAfter    in   varchar2 default null
, qCheckedInBefore   in   varchar2 default null
, qCheckedInAt       in   varchar2 default null
, qCreatedBy         in   varchar2 default null  -- AUDIT
, qCreatedAfter      in   varchar2 default null
, qCreatedBefore     in   varchar2 default null
, qChangedBy         in   varchar2 default null
, qChangedAfter      in   varchar2 default null
, qChangedBefore     in   varchar2 default null
, qWastebasket in   varchar2 default null
, qWhere             in   varchar2 default null
, qOrderBy           in   varchar2 default null
, p_run_mode         in   varchar2 default 'search'
)
is
  l_first   boolean;
  l_path    varchar2(2000);
  l_where   varchar2(2000);
  l_element_type  varchar2(2000):= qElementType;
  l_start_time number(38):= dbms_utility.get_time;
  l_end_time   number(38);

  l_type    number;
  l_count_invisible number(10):=0;

  TYPE typelist IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;
  types           typelist;  -- array that stores 'regular' types, with id < 9999
  irreg_types     typelist;  -- sequence-based array with indecex > 10000 that stores NLS names
  irreg_max       number := 9999;

  function TypeAdded (p_type_id in number)
  return boolean
  is
  begin
    if types.exists(p_type_id) then
      return true;
    else
      types(p_type_id) := 'Y';
      return false;
    end if;
  end;

  function GetTypeIndex (p_nls_name in varchar2)
  return number
  is
    l_found_index  number := -1;
  begin
    for i in 10000 .. irreg_max loop
      if irreg_types(i) = p_nls_name then
        l_found_index := i;
      end if;
    end loop;
    if l_found_index < 0 then
      irreg_max := irreg_max + 1;
      irreg_types(irreg_max) := p_nls_name;
      l_found_index := irreg_max;
    end if;
    return l_found_index;
  end;


begin
  -- create session when necessary, refresh session cache, set workarea context
  -- from here on reference to odwactxt.get_... functions for any context value
  odwactxt.update_context
  ( p_session_id    => p_session_id
  , p_package_name  => PACKAGE_NAME
  , p_procedure_name=> 'resultFrame'
  , p_workarea_irid => to_number( qWorkareaIrid)
  , p_cfg_ivid      => to_number( qCfgIvid)
  , p_folder_irid   => to_number( qFolderIrid)
  , p_pac_irid      => null
  , p_pac_ivid      => null
  );
  if p_run_mode = 'showSql'
  then
    showSql
    ( p_session_id        => odwactxt.get_session_id
    , qName               => qName
    , qCaseSensitive      => qCaseSensitive
    , qWorkareaIrid       => cdwpbase.ifThenElse( qWorkareaIrid <> 'null', qWorkareaIrid)
    , qFolderIrid         => qFolderIrid
    , qFolderIvid         => qFolderIvid
    , qIncludeNested      => qIncludeNested
    , qElementType        => cdwpbase.ifThenElse( qElementType <> 'null', l_Element_Type)
    , qIvid               => qIvid
    , qIrid               => qIrid
    , qTxtType            => qTxtType
    , qTxtContains        => qTxtContains
    , qFileContains       => qFileContains
    , qDepType           => qDepType
    , qGlobalName        => qGlobalName
    , qGlobalNameType    => qGlobalNameType
    , qUsedByIvid        => qUsedByIvid
    , qCheckState         => qCheckState
    , qTipVersionsOnly    => qTipVersionsOnly
    , qRootVersionsOnly   => qRootVersionsOnly
    , qVersionLabel       => qVersionLabel
    , qBranchIrid         => qBranchIrid
    , qCfgIvid            => qCfgIvid
    , qCheckNotesContain  => qCheckNotesContain
    , qCheckOutUser       => qCheckOutUser
    , qCheckedOutAfter    => qCheckedOutAfter
    , qCheckedOutBefore   => qCheckedOutBefore
    , qCheckInUser        => qCheckInUser
    , qCheckedInAfter     => qCheckedInAfter
    , qCheckedInBefore    => qCheckedInBefore
    , qCreatedBy          => qCreatedBy
    , qCreatedAfter       => qCreatedAfter
    , qCreatedBefore      => qCreatedBefore
    , qChangedBy          => qChangedBy
    , qChangedAfter       => qChangedAfter
    , qChangedBefore      => qChangedBefore
    , qWastebasket        => qWastebasket
    , qWhere              => qWhere
    );
  elsif p_run_mode = 'saveQuery'
  then
    odwaslib.savequery
    ( p_session_id        => odwactxt.get_session_id
    , qName               => qName
    , qCaseSensitive      => qCaseSensitive
    , qWorkareaIrid       => cdwpbase.ifThenElse( qWorkareaIrid <> 'null', qWorkareaIrid)
    , qFolderIrid         => qFolderIrid
    , qFolderIvid         => qFolderIvid
    , qIncludeNested      => qIncludeNested
    , qElementType        => cdwpbase.ifThenElse( qElementType <> 'null', l_Element_Type)
    , qIvid               => qIvid
    , qIrid               => qIrid
    , qTxtType            => qTxtType
    , qTxtContains        => qTxtContains
    , qFileContains       => qFileContains
    , qDepType           => qDepType
    , qGlobalName        => qGlobalName
    , qGlobalNameType    => qGlobalNameType
    , qUsedByIvid        => qUsedByIvid
    , qCheckState         => qCheckState
    , qTipVersionsOnly    => qTipVersionsOnly
    , qRootVersionsOnly   => qRootVersionsOnly
    , qVersionLabel       => qVersionLabel
    , qBranchIrid         => qBranchIrid
    , qCfgIvid            => qCfgIvid
    , qCheckNotesContain  => qCheckNotesContain
    , qCheckOutUser       => qCheckOutUser
    , qCheckedOutAfter    => qCheckedOutAfter
    , qCheckedOutBefore   => qCheckedOutBefore
    , qCheckInUser        => qCheckInUser
    , qCheckedInAfter     => qCheckedInAfter
    , qCheckedInBefore    => qCheckedInBefore
    , qCreatedBy          => qCreatedBy
    , qCreatedAfter       => qCreatedAfter
    , qCreatedBefore      => qCreatedBefore
    , qChangedBy          => qChangedBy
    , qChangedAfter       => qChangedAfter
    , qChangedBefore      => qChangedBefore
    , qWastebasket        => qWastebasket
    , qWhere              => qWhere
    );

  else
    htp.htmlOpen;
    htp.headOpen;
    cdwp.write_about(package_name, revision_label);
    cdwp.include_report_styles;
    odwainfo.js_invoke_info;
    -- $revision 3.13$ JavaScript function to submit the download file request form
    cdwp_fil.js_download_file_request;
    odwabrow.js_invoke_browser;
    odwavrsn.js_invoke_vhv_ivid_only;
    odwa_fol.js_go(p_session_id => odwactxt.get_session_id,p_target => '_NEW');
    js_dynamic_content
    ( imagePath     => odwapref.get_value(p_preference_name => 'image_path')
    , checkedImage  => 'check_mark.gif'
    , wbasketImage  => 'wastebasket.gif'

    , launchProc    => cdwpbase.ifThenElse((p_run_mode='search'),'go','sel')

    , verHistLabel  => Rob_msg.GetMsg(Rob_msg.CAP220_ODWARPRT_VERHISVR ,'','','','')
    , verHistProc   => 'vhv'
    , verhistImg    => 'vhv.gif'

    , browserLabel  => Rob_msg.GetMsg(Rob_msg.DSP103_CDWP_OB ,'','','','')
    , browserProc   => 'browse'
    , browserImg    => 'browsemed.gif'

    , infoPopLabel  => Rob_msg.GetMsg(Rob_msg.CAP221_ODWARPRT_SHOWINFO ,'','','','')
    , infoPopProc   => 'popupInfo'
    , infoPopImg    => 'info.gif'
    );
    js_showSql;
    htp.headClose;
    --
    -- body
    --
    htp.bodyOpen
    ( cattributes=>'BGCOLOR="#FFFFFF" '
    );
       -- $revision 3.13$ include form to request file download; by using the form, we can
       -- cut down on the size of the file by downsizing the URL
       cdwp_fil.form_download_file_request;

      htp.formopen
      ( curl         => 'odwasrch.resultFrame9'
      , cmethod      => 'GET'
      , cattributes  => 'NAME="queryForm" '
      ||' onSubmit="targetCheck()"'
      , ctarget      => ''
      );
      htp.p
      ( ' <INPUT TYPE="hidden" NAME="p_session_id" '
      ||' VALUE="'||to_char(p_session_id)||'">'
      );
      -- BASIC
      htp.p
      ( ' <INPUT TYPE="hidden" NAME="qName" '
      ||' VALUE="'||cdwpbase.ifThenElse( qName = 'NEW_SEARCH_271269', '', qName)||'">'
      );
      htp.p
      ( ' <INPUT TYPE="hidden" NAME="qCaseSensitive" '
      ||' VALUE="'||qCaseSensitive||'">'
      );
      htp.p
      ( ' <INPUT TYPE="hidden" NAME="qWorkareaIrid" '
      ||' VALUE="'||qWorkareaIrid||'">'
      );
      htp.p
      ( ' <INPUT TYPE="hidden" NAME="qTipVersionsOnly" '
      ||' VALUE="'||qTipVersionsOnly||'">'
      );
      htp.p
      ( ' <INPUT TYPE="hidden" NAME="qFolderIrid" '
      ||' VALUE="'||qFolderIrid||'">'
      );
      htp.p
      ( ' <INPUT TYPE="hidden" NAME="qFolderIvid" '
      ||' VALUE="'||qFolderIvid||'">'
      );
      htp.p
      ( ' <INPUT TYPE="hidden" NAME="qIncludeNested" '
      ||' VALUE="'||qIncludeNested||'">'
      );
      htp.p
      ( ' <INPUT TYPE="hidden" NAME="qElementType" '
      ||' VALUE="'||qElementType||'">'
      );
      -- ADVANCED
      htp.p
      ( ' <INPUT TYPE="hidden" NAME="qIvid" '
      ||' VALUE="'||qIvid||'">'
      );
      htp.p
      ( ' <INPUT TYPE="hidden" NAME="qIrid" '
      ||' VALUE="'||qIrid||'">'
      );
      htp.p
      ( ' <INPUT TYPE="hidden" NAME="qWhere" '
      ||' VALUE="'||qWhere||'">'
      );
      htp.p
      ( ' <INPUT TYPE="hidden" NAME="qTxtContains" '
      ||' VALUE="'||qTxtContains||'">'
      );
      htp.p
      ( ' <INPUT TYPE="hidden" NAME="qFileContains" '
      ||' VALUE="'||qFileContains||'">'
      );
      htp.p
          ( ' <INPUT TYPE="hidden" NAME="qDepType" '
          ||' VALUE="'||qDepType||'">'
          );
      htp.p
          ( ' <INPUT TYPE="hidden" NAME="qGlobalName" '
          ||' VALUE="'||qGlobalName||'">'
          );
      htp.p
          ( ' <INPUT TYPE="hidden" NAME="qGlobalNameType" '
          ||' VALUE="'||qGlobalNameType||'">'
          );
      htp.p
          ( ' <INPUT TYPE="hidden" NAME="qUsedByIvid" '
          ||' VALUE="'||qUsedByIvid||'">'
          );
      -- VERSION
      htp.p
      ( ' <INPUT TYPE="hidden" NAME="qCheckState" '
      ||' VALUE="'||qCheckState||'">'
      );
      htp.p
      ( ' <INPUT TYPE="hidden" NAME="qVersionLabel" '
      ||' VALUE="'||qVersionLabel||'">'
      );
      htp.p
      ( ' <INPUT TYPE="hidden" NAME="qCheckOutUser" '
      ||' VALUE="'||qCheckOutUser||'">'
      );
      htp.p
      ( ' <INPUT TYPE="hidden" NAME="qCheckInUser" '
      ||' VALUE="'||qCheckInUser||'">'
      );
      htp.p
      ( ' <INPUT TYPE="hidden" NAME="qCheckNotesContain" '
      ||' VALUE="'||qCheckNotesContain||'">'
      );
      htp.p
      ( ' <INPUT TYPE="hidden" NAME="qBranchIrid" '
      ||' VALUE="'||qBranchIrid||'">'
      );
      htp.p
      ( ' <INPUT TYPE="hidden" NAME="qCfgIvid" '
      ||' VALUE="'||qCfgIvid||'">'
      );
      htp.p
      ( ' <INPUT TYPE="hidden" NAME="qRootVersionsOnly" '
      ||' VALUE="'||qRootVersionsOnly||'">'
      );
      htp.p
      ( ' <INPUT TYPE="hidden" NAME="qCheckedOutBefore" '
      ||' VALUE="'||qCheckedOutBefore||'">'
      );
      htp.p
      ( ' <INPUT TYPE="hidden" NAME="qCheckedOutAfter" '
      ||' VALUE="'||qCheckedOutAfter||'">'
      );
      htp.p
      ( ' <INPUT TYPE="hidden" NAME="qCheckedInBefore" '
      ||' VALUE="'||qCheckedInBefore||'">'
      );
      htp.p
      ( ' <INPUT TYPE="hidden" NAME="qCheckedInAfter" '
      ||' VALUE="'||qCheckedInAfter||'">'
      );
      -- AUDIT
      htp.p
      ( ' <INPUT TYPE="hidden" NAME="qCreatedBy" '
      ||' VALUE="'||qCreatedBy||'">'
      );
      htp.p
      ( ' <INPUT TYPE="hidden" NAME="qCreatedBefore" '
      ||' VALUE="'||qCreatedBefore||'">'
      );
      htp.p
      ( ' <INPUT TYPE="hidden" NAME="qCreatedAfter" '
      ||' VALUE="'||qCreatedAfter||'">'
      );
      htp.p
      ( ' <INPUT TYPE="hidden" NAME="qChangedBy" '
      ||' VALUE="'||qChangedBy||'">'
      );
      htp.p
      ( ' <INPUT TYPE="hidden" NAME="qChangedBefore" '
      ||' VALUE="'||qChangedBefore||'">'
      );
      htp.p
      ( ' <INPUT TYPE="hidden" NAME="qChangedAfter" '
      ||' VALUE="'||qChangedAfter||'">'
      );
      htp.p
      ( ' <INPUT TYPE="hidden" NAME="qWastebasket" '
      ||' VALUE="'||qWastebasket||'">'
      );
      -- Additional
      htp.p
      ( ' <INPUT TYPE="hidden" NAME="qOrderBy" '
      ||' VALUE="'||qOrderBy||'">'
      );
      htp.p( ' <INPUT TYPE="hidden" NAME="p_run_mode" '
          ||' VALUE="'||p_run_mode||'">'
          );
      htp.formClose;
        if qElementType = '-4907'  -- BRDD
        then
           l_where :=
           ' exists (select 1
                     from   cdi_text
                     where  txt_ref = ci.id
                     and    txt_type = ''CDINOT''
                     and    txt_text like ''%<TY>%''
                     and    parent_ivid = ci.ivid
                     ) ';
           l_element_type:='4907';
         end if;
         if qElementType = '-5024'  -- BR
         then
           l_where :=
           ' exists ( select ''x'' from dual where cdwp_chk_fun_is_business_rule
             ( ci.id
             , ci.function_label
             , ci.function_type ) = ''Y''
             )
             ';
           l_element_type:='5024';
        end if;
        if qElementType ='5024'   -- FUN
        then
           l_where :=
           ' exists ( select ''x'' from dual where cdwp_chk_fun_is_business_rule
             ( ci.id
             , ci.function_label
             , ci.function_type ) = ''N''
             )
             ';
        end if;
        -- compose l_where based on what was added complemented with
        -- the qWhere passed in
        if qWhere is not null
        then
          l_where:= l_where
          ||cdwpbase.ifThenElse
            ( l_where is not null
            , ' AND '||qWhere
            , qWhere
            )
          ;
        end if; -- qWhere is not null

    if nvl( qName, 'X') <> 'NEW_SEARCH_271269'
    then
      -- have the runSearch procedure gather search result in the g_<>Tab tables;
      -- then move forward to actually display the result
      runSearch
      ( qName             => qName
      , qCaseSensitive      => qCaseSensitive
      , qWorkareaIrid     => cdwpbase.ifThenElse( qWorkareaIrid <> 'null', qWorkareaIrid)
      , qFolderIrid       => qFolderIrid
      , qFolderIvid       => qFolderIvid
      , qIncludeNested    => qIncludeNested
      , qElementType      => cdwpbase.ifThenElse( qElementType <> 'null', l_Element_Type)
      , qIvid             => qIvid
      , qIrid             => qIrid
      , qTxtType          => qTxtType
      , qTxtContains      => qTxtContains
      , qFileContains      => qFileContains
      , qDepType           => qDepType
      , qGlobalName        => qGlobalName
      , qGlobalNameType    => qGlobalNameType
      , qUsedByIvid        => qUsedByIvid
      , qCheckState       => qCheckState
      , qTipVersionsOnly  => qTipVersionsOnly
      , qRootVersionsOnly  => qRootVersionsOnly
      , qVersionLabel     => qVersionLabel
      , qBranchIrid       => qBranchIrid
      , qCfgIvid=> qCfgIvid
      , qCheckNotesContain=> qCheckNotesContain
      , qCheckOutUser        => qCheckOutUser
      , qCheckedOutAfter     => qCheckedOutAfter
      , qCheckedOutBefore    => qCheckedOutBefore
      , qCheckInUser        => qCheckInUser
      , qCheckedInAfter     => qCheckedInAfter
      , qCheckedInBefore    => qCheckedInBefore
      , qCreatedBy        => qCreatedBy
      , qCreatedAfter     => qCreatedAfter
      , qCreatedBefore    => qCreatedBefore
      , qChangedBy        => qChangedBy
      , qChangedAfter     => qChangedAfter
      , qChangedBefore    => qChangedBefore
      , qWastebasket => qWastebasket
      , qWhere            => l_where
      , p_order_by        => qOrderBy
      , p_enforce_acc_privs => false
    );
    -- filter invisble objects??
    if g_ividTab.count > 0
       and
       g_ividTab(1) > 0
       and
       not is_global_search_user(USER)
    then
      for i in 1..g_ividTab.count loop
        if not visible( p_irid => odwasrch.g_iridTab(i), p_type_id => odwasrch.g_typeTab(i))
        then
           l_count_invisible:= l_count_invisible + 1;
           odwasrch.g_nameTab(i):='*******************';
           odwasrch.g_ividTab(i):=-4;
        end if;
      end loop;
    end if; -- g_ividTab.count > 0  and g_ividTab(1) > 0
    l_end_time := dbms_utility.get_time;
    cdwp.tableOpen;
    cdwp.tableRowOpen;
    cdwp.tableDataValue('');
    cdwp.tableDataValue('');
    cdwp.tableDataValue
    ( Rob_msg.GetMsg(Rob_msg.MSG191_ODWASRCH_STAT,odwavrsn.get_author_name( USER)||cdwpbase.nbsp(6),cdwpbase.ifThenElse( g_ividTab(1) > 0, to_char(g_ividTab.count - l_count_invisible), 'no')
                    ,cdwpbase.nbsp(1)||cdwpbase.ifThenElse( (l_end_time - l_start_time) <100, '0' )|| to_char( round((l_end_time - l_start_time)/10)/10),'')
    ||cdwpbase.nbsp(6)
    || '<A href="javascript:showSql()">'
    ||cdwp.add_images('{showsql_round.gif}', p_attributes => 'ALT="'||Rob_msg.GetMsg(Rob_msg.MSG192_ODWASRCH_SHOWSQL,'','','','')||'"')
    ||'</A>'
    ||' </b></font></font>'
    , p_colspan => 5
    );
    cdwp.tableRowClose;
    -- if some result was returned
    if g_ividTab.count - l_count_invisible > 0
       and
       (
         g_ividTab(1) > 0
         or
         g_ividTab(1) = -4
       )
    then
        cdwp.tableRowOpen;
        cdwp.tableDataValue(' '); -- wastebasket gif
        cdwp.tableDataValue(' '); -- check mark gif
        cdwp.tableDataValue
        ( '<font face="Arial Narrow"><font size=-1><b>'
        ||'<A HREF="javascript:document.queryForm.qOrderBy.value = ''name '
           ||cdwpbase.ifThenElse
             ( instr(lower(qOrderBy), 'asc') > 0
             , 'desc'
             , 'asc'
             )
           ||''';document.queryForm.submit();">'||Rob_msg.Getmsg(Rob_msg.CAP317_ODWASRCH_ELEMENT,'','','','')||'</A>'
        ||'</b></font></font>'
        );
        cdwp.tableDataValue('<font face="Arial Narrow"><font size=-1><b>'||Rob_msg.Getmsg(Rob_msg.CAP203_ODWAPROP_VER,'','','','')||'</b></font></font>');
        cdwp.tableDataValue(cdwpbase.nbsp(2));
  --      cdwp.tableDataValue('<font face="Arial Narrow"><font size=-1><b>Path</b></font></font>');
        cdwp.tableDataValue
        ( '<font face="Arial Narrow"><font size=-1><b>'
        ||'<A HREF="javascript:document.queryForm.qOrderBy.value = ''path '
           ||cdwpbase.ifThenElse
             ( instr(lower(qOrderBy), 'asc') > 0
             , 'desc'
             , 'asc'
             )
           ||''';document.queryForm.submit();">'||Rob_msg.Getmsg(Rob_msg.CAP061_ODWA_PATH,'','','','')||'</A>'
        ||'</b></font></font>'
        );
  --  P.Ebell -- Check op gElementType tijdelijk verwijderd, Lucas raadplegen
  --      if qElementType is null
  --      then
          cdwp.tableDataValue
          ('<font face="Arial Narrow"><font size=-1><b>'
        ||'<A HREF="javascript:document.queryForm.qOrderBy.value = ''type '
           ||cdwpbase.ifThenElse
             ( instr(lower(qOrderBy), 'asc') > 0
             , 'desc'
             , 'asc'
             )
           ||''';document.queryForm.submit();">'||Rob_msg.Getmsg(Rob_msg.CAP045_CDWP_TYPE,'','','','')||'</A>'
          ||' </b></font></font>'
          );
  --      end if;
  --      cdwp.tableDataValue('<font face="Arial Narrow"><font size=-1><b>Date Modified</b></font></font>');
        cdwp.tableDataValue
        ( '<font face="Arial Narrow"><font size=-1><b>'
        ||'<A HREF="javascript:document.queryForm.qOrderBy.value = ''touched '
           ||cdwpbase.ifThenElse
             ( instr(lower(qOrderBy), 'touched') > 0  -- if already ordered by touched, just swap the order
             , cdwpbase.ifThenElse
               ( instr(lower(qOrderBy), 'asc') > 0
               , 'desc'
               , 'asc'
               )
             , 'desc'   -- the default/first ordering on touched should be DESCENDING (most recently modified on top)
             )
           ||''';document.queryForm.submit();">'||Rob_msg.GetMsg(Rob_msg.CAP293_ODWASRCH_DTMOD,'','','','')||'</A>'
        ||'</b></font></font>'
        );


        cdwp.tableDataValue
        ('<font face="Arial Narrow"><font size=-1><b>'
        ||''
        ||' </b></font></font>'
        );
        cdwp.tableDataValue
        ('<font face="Arial Narrow"><font size=-1><b>'
        ||Rob_msg.GetMsg(Rob_msg.CAP0152_CDWP_NOTES,'','','','')
        );
        cdwp.tableRowClose;

      l_first:= true;
      for i in 1..g_ividTab.count loop
        if g_ividTab(i) <> -4 -- -4 means it is invisble
        then
          if l_first
          then
            htp.p('<SCRIPT>');
            htp.p('this.status="'||Rob_msg.GetMsg(Rob_msg.DSP329_ODWARPRTS_BLDG,'','','','')||'";');
            l_first:=false;
          end if;


          l_type := odwasrch.g_typeTab(i);
          -- l_type can be an ivid, in which case it cannot be used as an index in the
          -- TYPES array. Therefore we use a second list, with a sequence-generated index
          -- that stores the NLS type name of the object. This will allow us to translate an NLS
          -- type name to an index in the TYPES array.
          if l_type > 10000 then
            l_type := GetTypeIndex(cdwpbase.get_nls_type_name( p_type_id => l_type));
          end if;
          if not TypeAdded(l_type) then
            htp.p('AddType('||l_type||',"'||cdwpbase.get_icon(odwasrch.g_typeTab(i))||'","'||cdwpbase.get_nls_type_name( p_type_id => odwasrch.g_typeTab(i))||'");');
          end if;
          -- 3.0  cater for objects with a / in their name; take full path for owning folder
          l_path:= jr_name.get_path( id => jr_acc_rights.get_owning_container(obj_irid => odwasrch.g_iridTab(i)), format=> 'NAME');
          htp.p( 'wi("'||replace( odwasrch.g_nameTab(i), '"', '\"')||'","'
                       ||l_type||'","'
                       ||odwasrch.g_ividTab(i)||'","'
                       ||odwasrch.g_vlabelTab(i)||'","'
                       ||l_path||'","'
                       ||upper(substr(odwavrsn.get_check_status(p_ivid => odwasrch.g_ividTab(i)),9,1))||'","'
                       ||odwasrch.g_wbasketTab(i)||'","'
                       ||to_char( odwasrch.g_dateChangedTab(i), 'DD-mon-YYYY HH24:MI')||'","'
                       ||cdwpbase.get_clean_notes( p_ivid => odwasrch.g_ividTab(i), p_type_id => odwasrch.g_typeTab(i))
                       ||'");'
               );


         end if;  -- visible
      end loop;
      if odwasrch.g_ividTab.count- l_count_invisible > 0 then
        htp.p('this.status="";');
        htp.p('</SCRIPT>
            <NOSCRIPT>'|| Rob_msg.getmsg(rob_msg.ACC005_NOSCRIPT,'','','','')||'</NOSCRIPT>');
      end if;
  --    htp.p(' </font></font>');
    else
      if g_ividTab(1) = -3
      then
          htp.p
          ( '<font face="Arial Narrow"><font size=-1><b>'
          ||Rob_msg.GetMsg(Rob_msg.MSG187_ODWARPRTS_QRYNOTRUN,'','','','')
          ||'</b></font></font>'
          );
      elsif g_ividTab(1) = -2
      then
          htp.p
          ( '<font face="Arial Narrow"><font size=-1><b>'
          ||Rob_msg.GetMsg(Rob_msg.MSG188_ODWARPRTS_EXCEP,g_nameTab(1),'','','')
          ||'</b></font></font>'
          );
      end if;
    end if; -- g_ividTab(1) is not null

      htp.formopen
      ( curl         => 'odwasrch'
      , cmethod      => 'POST'
      , cattributes  => 'NAME="searchQuery" '
      , ctarget      => ''
      );
      htp.p
      ( ' <INPUT TYPE="hidden" NAME="query" '
      ||' VALUE="'||g_last_search_cursor||'">'
      );
      htp.formClose;
    end if; -- qName <> 'NEW_SEARCH_271269'
    cdwp.tableClose;
    htp.bodyClose;
    htp.htmlClose;
  end if; -- p_run_mode ='showSql'
end; -- resultFrame9

-- writes the function selected that should be called as link from the elements in the result
-- frame to return the selected values to the invoker
-- the p_js_selected may refer to the following variables:
-- ivid, workareaIrid, cfgIvid, folderIrid, typeId
-- an example:
-- p_js_selected => 'opener.location = "odwarobs.rob?p_type_id=4907"
--                    +"'||chr(38)||'p_form_name=dingesForm"
--                    +"'||chr(38)||'p_ivid_field=dingesIvid"
--                    +"'||chr(38)||'p_irid_field=dingesIrid"
--                    +"'||chr(38)||'p_cfg_ivid="+cfgIvid
--                    +"'||chr(38)||'p_workarea_irid="+workareaIrid
--                    +"'||chr(38)||'p_ivid="+ivid
--                    +"'||chr(38)||'p_search_type_id="+type_id
--                    ;

procedure js_selected
( p_js_selected in varchar2
, p_type_id     in number
) is
begin
  htp.p(' <SCRIPT LANGUAGE="JavaScript"><!--

  function selected( ivid)
  {
  workareaIrid = top.resultFrame.document.queryForm.qWorkareaIrid.value;
  cfgIvid      = top.resultFrame.document.queryForm.qCfgIvid.value;
  folderIrid   = top.resultFrame.document.queryForm.qFolderIrid.value;
  typeId       = top.resultFrame.document.queryForm.qElementType.value;

  '
  ||'opener.location = "odwarobs.rob?p_type_id='||to_char(p_type_id)||'"
                    +"'||chr(38)||'p_form_name='||cdwpbase.get_tag_value( p_js_selected, 'p_form_name')||'"
                    +"'||chr(38)||'p_ivid_field='||cdwpbase.get_tag_value( p_js_selected, 'p_ivid_field')||'"
                    +"'||chr(38)||'p_irid_field='||cdwpbase.get_tag_value( p_js_selected, 'p_irid_field')||'"
                    +"'||chr(38)||'p_cfg_ivid="+cfgIvid
                    +"'||chr(38)||'p_workarea_irid="+workareaIrid
                    +"'||chr(38)||'p_ivid="+ivid //.toString()
                    +"'||chr(38)||'p_search_type_id="+typeId
                    ;'
  ||'
  self.close();
  }

    //--></SCRIPT> <NOSCRIPT>'|| Rob_msg.getmsg(rob_msg.ACC005_NOSCRIPT,'','','','')||'</NOSCRIPT>'
  );
end; -- js_selected

procedure js_invoke_search
( p_session_id    in   number default null
, p_type_id       in   varchar2   default null
, p_wa_id         in   varchar2   default null
, p_cfg_id        in   varchar2   default null
, p_folder_ivid   in   varchar2   default null
, p_js_selected   in varchar2
, p_function_name in varchar2     default 'invokeSearch'
) is
begin
  htp.p(' <SCRIPT LANGUAGE="JavaScript"><!--

  function '||p_function_name||'()
  {
    window2=open
            ( ''odwasrch.rep_search?p_session_id='||to_char(p_session_id)
                        ||chr(38)||'p_run_mode=select'
                        ||chr(38)||'p_type_id='||p_type_id
                        ||chr(38)||'p_wa_id='||p_wa_id
                        ||chr(38)||'p_cfg_id='||p_cfg_id
                        ||chr(38)||'p_folder_ivid='||p_folder_ivid
                        ||chr(38)||'p_js_selected='||p_js_selected
            ||''''
            ||', ''searchWindow''
            , ''toolbar=no,scrollbars=yes,location=no,directories=no''
             +'',status=no,menubar=no,resizable=yes''
            );
    window2.moveTo(120,100);
    window2.innerHeight=500;
    window2.innerWidth=600;
    window2.focus();
  }
    //--></SCRIPT>
   <NOSCRIPT>'|| Rob_msg.getmsg(rob_msg.ACC005_NOSCRIPT,'','','','')||'</NOSCRIPT>');
end; -- js_invoke_search


-- main procedure
-- -------------------------------
-- |       queryFrame            |
-- |                             |
-- |                             |
-- |-----------------------------|
-- |                             |
-- |       resultFrame           |
-- |                             |
-- -------------------------------
--
--
procedure rep_search
( p_session_id    in   number default null
, p_run_mode      in   varchar2   default 'search' -- values: search, select
, p_type_id       in   number     default null
, p_wa_id         in   number     default null
, p_cfg_id        in   number     default null
, p_folder_ivid   in   number     default null
, p_js_selected   in   varchar2   default null -- the Javascript that should be executed when
                                               -- in select mode an element is selected
) is
begin
  -- create session when necessary, refresh session cache, set workarea context
  -- from here on reference to odwactxt.get_... functions for any context value
  odwactxt.update_context
  ( p_package_name  => PACKAGE_NAME
  , p_procedure_name=> 'rep_search'
  , p_folder_ivid   => p_folder_ivid
  , p_cfg_ivid      => p_cfg_id
  , p_workarea_irid => p_wa_id
  , p_pac_irid      => null
  , p_pac_ivid      => null
  );

  htp.htmlOpen;
  htp.headOpen;
  cdwp.write_about(package_name, revision_label);
  htp.title(Rob_msg.GetMsg(Rob_msg.DSP112_CDWP_REPSEARCH ,'','','',''));
  if p_run_mode ='select'
  then
    js_selected( p_js_selected => p_js_selected, p_type_id => p_type_id);
  end if;
  htp.headClose;
  htp.framesetopen
  ( crows       =>  '60%,40%'
  , cattributes => 'BORDER="1" TITLE="'||Rob_msg.getMsg(rob_msg.DSP112_CDWP_REPSEARCH,'','','','')
                   ||'" LONGDESC=odwahelp.rightSide?p_session_id=&p_him_id=402'
  );
  htp.frame
  ( csrc => 'odwasrch.queryFrame?p_session_id='
          ||to_char(odwactxt.get_session_id)
          ||chr(38)||'p_mode=BASIC'
          ||chr(38)||'qWorkareaIrid='||p_wa_id
          ||chr(38)||'qCfgIvid='||p_cfg_id
          ||chr(38)||'qFolderIrid='||to_char(cdwpbase.get_irid( p_ivid => p_folder_ivid))
          ||chr(38)||'qElementType='||to_char(p_type_id)
          ||chr(38)||'qTipVersionsOnly=YES'
          ||chr(38)||'p_run_mode='||p_run_mode
  , cname=> 'queryFrame'
  , cattributes => 'TITLE="'||Rob_msg.getMsg(rob_msg.DSP112_CDWP_REPSEARCH,'','','','')
                 ||'" LONGDESC=odwahelp.rightSide?p_session_id=&p_him_id=402'
  );
  htp.frame
  ( csrc => 'odwasrch.resultFrame9?p_session_id='
          ||to_char(odwactxt.get_session_id)
          ||chr(38)||'p_run_mode='||p_run_mode
          ||chr(38)||'qName=NEW_SEARCH_271269' -- to indicate no message needs to be shown
  , cname=> 'resultFrame'
  , cattributes => 'TITLE="'||Rob_msg.getMsg(rob_msg.DSP112_CDWP_REPSEARCH,'','','','')
                    ||'" LONGDESC=odwahelp.rightSide?p_session_id=&p_him_id=402'
  );

  htp.framesetclose;
  htp.bodyopen
  ( cattributes => 'BGCOLOR="#FFFFFF"'
  );
  htp.bodyClose;
  htp.htmlClose;
end; -- rep_search

-- procedure to be called with a number of search criteria that will collect results in the
-- odwasrch.g_<>Tab tables
procedure runSearch
( qName              in   varchar2 default null  -- BASIC
, qCaseSensitive     in   varchar2 default null
, qWorkareaIrid      in   number   default null
, qTipVersionsOnly   in   varchar2 default null
, qFolderIrid        in   varchar2 default null
, qFolderIvid        in   varchar2 default null
, qIncludeNested     in   varchar2 default null
, qElementType       in   varchar2 default null
, qIvid              in   number   default null  -- ADVANCED
, qIrid              in   number   default null
, qTxtType           in   varchar2 default null
, qTxtContains       in   varchar2 default null
, qFileContains      in   varchar2 default null
, qDepType           in   varchar2 default null
, qGlobalName        in   varchar2 default null
, qGlobalNameType    in   varchar2 default null
, qUsedByIvid        in   varchar2 default null
, qCheckState        in   varchar2 default null  -- VERSION
, qRootVersionsOnly  in   varchar2 default null
, qVersionLabel      in   varchar2 default null
, qBranchIrid        in   number   default null
, qCfgIrid           in   number   default null
, qCfgIvid           in   number   default null
, qCheckNotesContain in   varchar2 default null
, qCheckOutUser      in   varchar2 default null
, qCheckedOutAfter   in   varchar2 default null
, qCheckedOutBefore  in   varchar2 default null
, qCheckInUser       in   varchar2 default null
, qCheckedInAfter    in   varchar2 default null
, qCheckedInBefore   in   varchar2 default null
, qCreatedBy         in   varchar2 default null  -- AUDIT
, qCreatedAfter      in   varchar2 default null
, qCreatedBefore     in   varchar2 default null
, qChangedBy         in   varchar2 default null
, qChangedAfter      in   varchar2 default null
, qChangedBefore     in   varchar2 default null
, qWastebasket in   varchar2 default null
, qWhere             in   varchar2 default null
, p_order_by         in   varchar2 default null
, p_show_sql_only    in   boolean  default false
, p_enforce_acc_privs in boolean default true
) is
  l_cursor        varchar2(4000);
  l_ci_view_name  varchar2(200):= upper(cdwpbase.get_ci_view(p_type_id => qElementType));

  /*
  function evaluate_date
  ( p_date_string in varchar2
  ) return date
  is
  begin
     if p_date_string is not null
     then
       if length( p_date_string) > 12 --DD-MON-YYYY
       then -- assume DD-MON-YYYY HH24[:MI]
         if instr(p_date_string, ':') > 0 -- MI
         then
           return to_date( p_date_string, 'DD-MON-YYYY HH24:MI');
         else
           return to_date( p_date_string||':00', 'DD-MON-YYYY HH24:MI');
         end if;
       else
         return to_date( p_date_string, 'DD-MON-YYYY');
       end if;
   else
     return to_date(null);
   end if;
  end; -- evaluate_date
*/
  function date_condition
  ( p_date_string in varchar2
  ) return varchar2
  is
  begin
    if instr( upper(p_date_string), 'SYSDATE') > 0
    then
      return p_date_string;
    else
      return
      ' to_date('''
         ||p_date_string
         ||''' , '''
         ||cdwpbase.ifThenElse
           ( instr( p_date_string, ':') > 0
           , 'DD-MON-YYYY HH24:MI'
           , cdwpbase.ifThenElse
             ( length( p_date_string) > 12
             , 'DD-MON-YYYY HH24'
             , 'DD-MON-YYYY'
             )
           )
         ||''')'
         ;
    end if; -- contains SYSDATE
  end;

  -- this procedure adds the line passed in to l_cursor
  procedure add
  ( p_line in varchar2
  , p_exclude_in_sql_only in boolean default false -- should this line be excluded if we only show SQL?
  , p_nl   in boolean default true
  ) is
  begin
    if not
       ( p_show_sql_only
         and
         p_exclude_in_sql_only
       )
       and
       p_line is not null
    then
      l_cursor:= l_cursor
      ||p_line
      ||cdwpbase.ifThenElse
        ( p_nl
          and
          p_show_sql_only
        , CHR(13)||chr(10)
        );
    end if;
  end; -- add

begin
   jr_context.set_workarea( to_char(null));
   add('declare', true);
   add('  cursor c_ivid',true);
   add('  is',true);
   add('  SELECT DISTINCT');
   add('         e.irid');
   add('  ,      e.ivid');
   add('  ,      e.name');
   add('  ,      decode');
   add('         ( e.state');
   add('         , ''N'', ''-''');
   add('         , ''O'', odwavrsn.get_version_label( e.ivid)');
   add('         , e.vlabel');
   add('         ) ');
   add
   ( cdwpbase.ifThenElse
     ( qElementType is not null
      , '  ,      nvl( ci.date_changed, ci.date_created) '
      , '  ,      nvl( e.date_changed, e.date_created) '
      )
   );
   add('  ,      e.logical_type_id ');
   add('  ,      e.wastebasket ');
   add('  FROM   I$SDD_OBJECT_VERSIONS        e ');
   add('  ,      I$SDD_BRANCHES               be');
   add
   ( cdwpbase.ifThenElse
     ( qCheckOutUser is not null
       or
       qCheckedOutAfter is not null
       or
       qCheckedOutBefore is not null
       or
       qCheckInUser is not null
       or
       qCheckedInAfter is not null
       or
       qCheckedInBefore is not null
       or
       qCheckNotesContain is not null
     , '  ,      I$SDD_VERSION_ASSOCIATIONS   va'
     )
   );
   add
   ( cdwpbase.ifThenElse
     ( qTipVersionsOnly is not null
     , '  ,      I$SDD_VERSION_ASSOCIATIONS   vatip'
     )
   );
   add
   ( cdwpbase.ifThenElse
     ( qRootVersionsOnly is not null
     , '  ,      I$SDD_VERSION_ASSOCIATIONS   varoot'
     )
   );
   add
   ( cdwpbase.ifThenElse
     ( qCfgIvid is not null
     ,'  ,      I$SDD_CONFIGURATION_MEMBERS   cm '
     )
   );
   add
   ( cdwpbase.ifThenElse
     ( qWorkareaIrid is not null
     , '  ,      I$SDD_WA_CONTEXT             wac '
     )
   );
   add
   ( cdwpbase.ifThenElse
     ( qFolderIrid is not null
       or
       qFolderIvid is not null
     , cdwpbase.ifThenElse
       ( qIncludeNested is not null
       , ',      ( select distinct level xx, member_object, folder_reference, parent_ivid from i$sdd_folder_members connect by prior  member_object = folder_reference start with '
            ||cdwpbase.ifThenElse
              ( qFolderIvid is null
              , ' folder_reference = '||qFolderirid||') mem'
              , ' parent_ivid = '||qFolderivid||') mem'
              )
       , ', SDD_FOLDER_MEMBERS                  mem '
       )
     )
   );
   add
   ( cdwpbase.ifThenElse
     ( qElementType is not null
     , '  ,      '||l_ci_view_name||' ci '
     )
   );
   add
   ('  WHERE  e.branch_id = be.branch_id(+) ');
   -- 3.2  check whether the user can actually See the object, unless the user is listed in
   -- the ODWA preference global_search_users
   if  instr
       ( ','||nvl(odwapref.get_value(p_preference_name => 'global_search_users'),'X')||','
       , ','||USER||','
       ) = 0
       and
       p_enforce_acc_privs
   then
     add
     ('  AND    exists ( select ''x''
                         from   i$sdd_folder_members fmo
                         ,      sdw_access_rights    acc
                         where  fmo.member_object     = e.irid
                         and    fmo.folder_reference  = acc.object_reference
                         and    acc.grantee_reference in ( USER,''PUBLIC'')
                         UNION
                         select ''x''
                         from   sdw_access_rights    acc
                         where  e.irid                = acc.object_reference
                         and    acc.grantee_reference in ( USER,''PUBLIC'')
                       )'
     );
   end if;
   add
   ( cdwpbase.ifThenElse
     ( qBranchIrid is not null
     , '  AND    be.branch_id = '||qBranchIrid
     )
   );
   add
   ( cdwpbase.ifThenElse
     ( qWastebasket = 'N' -- Exclude Wastebasket
     , '  AND    e.wastebasket = ''N'''
     )
   );
  add
  ( cdwpbase.ifThenElse
     ( qWastebasket = 'Y' -- Only Wastebasket
     , '  AND    e.wastebasket = ''Y'''
     )
   );
   if qWorkareaIrid is not null
   then
     add( '  AND    wac.workarea_irid = '||qWorkareaIrid);
     add( '  AND    wac.object_ivid = E.ivid ');
   end if; -- qWorkareaIrid is not null
   add
   ( cdwpbase.ifThenElse
     ( qFolderIrid is not null
     , cdwpbase.ifThenElse
       ( qIncludeNested is not null
       , '  AND    mem.member_object = E.irid '
       , '  AND    mem.folder_reference = '||qFolderIrid
       ||'  AND    mem.member_object = E.irid '
       )
     )
   );
   add
   ( cdwpbase.ifThenElse
     ( qFolderIvid is not null
     , cdwpbase.ifThenElse
       ( qIncludeNested is not null
       , '  AND    mem.member_object = E.irid '
       , '  AND    mem.parent_ivid = '||qFolderIvid
       ||'  AND    mem.member_object = E.irid '
       )
     )
   );
   add
   ( cdwpbase.ifThenElse
     ( qElementType is not null
     , '  AND    e.ivid = ci.ivid '
     )
   );
   add
   ( cdwpbase.ifThenElse
     ( qIvid is not null
     , '  AND    e.ivid = '||qIvid
     )
   );
   add
   ( cdwpbase.ifThenElse
     ( qCfgIvid is not null
     , '  AND    cm.config_ivid = '||qCfgIvid
     ||'  AND    cm.object_ivid = e.ivid '
     )
   );
   add
   ( cdwpbase.ifThenElse
     ( nvl(qCheckState, 'I,O,N')  <> 'I,O,N' --2.5  if check state has not been set explicitly, it is not passed in
       and
       qCheckState <> 'null'
     , '  AND     e.state in (''WQA'' '
     ||cdwpbase.ifThenElse
       ( instr(qCheckState, 'N') > 0
       , ', ''N'''
       )
     ||cdwpbase.ifThenElse
       ( instr(qCheckState, 'I') > 0
       , ', ''I'''
       )
     ||cdwpbase.ifThenElse
       ( instr(qCheckState, 'O') > 0
       , ', ''O'''
       )
     ||')'
    )
   );
   add
   ( cdwpbase.ifThenElse
     ( qVersionLabel is not null
     , ' and e.vlabel '
     ||cdwpbase.ifThenElse
       ( ( instr( qVersionLabel , '%') + instr( qVersionLabel , '_')) > 0
       , 'like '
       , ' = '
       )
     ||''''||qVersionLabel||''''
     )
   );
   add
   ( cdwpbase.ifThenElse
     ( qCheckNotesContain is not null
     , ' and instr( va.notes, '
     ||''''||qCheckNotesContain||''''
     ||') > 0 '
     )
   );
   add
   ( cdwpbase.ifThenElse
     ( qCheckOutUser is not null
       or
       qCheckedOutAfter is not null
       or
       qCheckedOutBefore is not null
       or
       qCheckInUser is not null
       or
       qCheckedInAfter is not null
       or
       qCheckedInBefore is not null
       or
       qCheckNotesContain is not null
     , ' and va.to_ivid = e.ivid '
     ||' and va.edge_kind NOT IN (''M'',''T'')' -- no Merge and Tip associations
     )
   );
   if qTipVersionsOnly is not null
   then
     add('  AND    vatip.from_ivid(+) = e.ivid ');
     -- cater for unversioned
     add('  AND');
     add('         (   ');
     add('           ( vatip.to_ivid     = vatip.from_ivid ');
     add('             AND');
     add('             vatip.edge_kind   = ''T''');
     add('           )');
     add('         OR');
     add('           e.state = ''N''');
     add('         OR');
     add('           e.state = ''O''');
     add('         ) ');
   end if; -- qTipVersionsOnly is not null
   if qRootVersionsOnly is not null
   then
     add('  AND    varoot.from_ivid(+) = e.ivid ');
     -- cater for unversioned
     add('  AND');
     add('         (   ');
     add('           ( varoot.to_ivid     = varoot.from_ivid ');
     add('             AND');
     add('             varoot.edge_kind   = ''R''');
     add('           )');
     add('         OR');
     add('           e.state = ''N''');
     add('         ) ');
   end if; -- qRootVersionsOnly is not null
   -- Check Out Details
   add
   ( cdwpbase.ifThenElse
     ( qCheckOutUser is not null
     , '  AND    va.created_by = '
     ||cdwpbase.ifThenElse
       ( qCheckOutUser = 'USER'
       , qCheckOutUser
       ,''''||qCheckOutUser||''''
       )
     )
   );
   add
   ( cdwpbase.ifThenElse
     ( qCheckedOutAfter is not null
     , '  AND    va.date_created >= '
     ||date_condition( p_date_string => qCheckedOutAfter)
     )
   );
   add
   ( cdwpbase.ifThenElse
     ( qCheckedOutBefore is not null
     , '  AND    va.date_created <= '
     ||date_condition( p_date_string => qCheckedOutBefore)
     )
   -- Check In Details
   );
   add
   ( cdwpbase.ifThenElse
     ( qCheckInUser is not null
     , '  AND    decode
                 ( e.state
                 , ''N'' , va.created_by
                 , va.changed_by
                 ) = '
     ||cdwpbase.ifThenElse
       ( qCheckInUser = 'USER'
       , qCheckInUser
       ,''''||qCheckInUser||''''
       )
     )
   );
   add
   ( cdwpbase.ifThenElse
     ( qCheckedInAfter is not null
     , '  AND    decode
                 ( e.state
                 ,  ''N'', va.date_created
                 , va.date_changed
                 ) >= '
     ||date_condition( p_date_string => qCheckedInAfter)
     )
   );
   add
   ( cdwpbase.ifThenElse
     ( qCheckedInBefore is not null
     , '  AND    nvl( va.date_changed, va.date_created) <= '
          ||date_condition( p_date_string => qCheckedInBefore)
     )
   );
   add
   ( cdwpbase.ifThenElse
     ( qCreatedBy is not null
     , '  AND    e.created_by = '
     ||cdwpbase.ifThenElse
       ( qCreatedBy = 'USER'
       , qCreatedBy
       ,''''||qCreatedBy||''''
       )
     )
   );
   add
   ( cdwpbase.ifThenElse
     ( qCreatedAfter is not null
     , '  AND    e.date_created >= '
     ||date_condition( p_date_string => qCreatedAfter)
     )
   );
   add
   ( cdwpbase.ifThenElse
     ( qCreatedBefore is not null
     , '  AND    e.date_created <= '
     ||date_condition( p_date_string => qCreatedBefore)
     )
   );
   add
   ( cdwpbase.ifThenElse
     ( qChangedBy is not null
     , '  AND    nvl( e.changed_by, e.created_by)  = '
     ||cdwpbase.ifThenElse
       ( qChangedBy = 'USER'
       , qChangedBy
       ,''''||qChangedBy||''''
       )
     )
   );
   add
   ( cdwpbase.ifThenElse
     ( qChangedAfter is not null
     , '  AND    nvl( e.date_changed, e.date_created) >= '
     ||date_condition( p_date_string => qChangedAfter)
     )
   );
   add
   ( cdwpbase.ifThenElse
     ( qChangedBefore is not null
     , '  AND     nvl( e.date_changed, e.date_created) <= '
     ||date_condition( p_date_string => qChangedBefore)
     )
   );
   add
   ( cdwpbase.ifThenElse
     ( qIrid is not null
     , '  AND    e.irid = '||qIrid
     )
   );
   add
   ( cdwpbase.ifThenElse
     ( qWhere is not null
     , '  AND     '||qWhere
     )
   );
   add
   ( cdwpbase.ifThenElse
     ( qTxtContains is not null
     , '  AND     exists
                 ( select ''x''
                   from   cdi_text
                   where  parent_ivid = e.ivid
                   and    txt_ref     = e.irid
                   and    instr( txt_text, '''||qTxtContains||''') > 0
                 )
        '   -- do not search all Secondary Elements; or should we???
     )
   );
   add
   ( cdwpbase.ifThenElse
     ( qFileContains is not null
       and
       qElementType = 4819
     , '  AND     dbms_lob.instr
                  ( contents_blob
                  , utl_raw.cast_to_raw
                    ( '''||qFileContains||''')
                  , 1
                  ) > 0
                   '
     )
   );
   if qCaseSensitive ='YES'
   then
     add
     ( cdwpbase.ifThenElse
       ( qName is not null
       , '  AND    e.name '
       ||cdwpbase.ifThenElse
         ( ( instr( qName , '%') + instr( qName , '_') + instr( qName , '*') ) > 0 -- wildcards included??
         , 'like '
         , ' = '
         )
       ||''''||replace ( qName, '*','%')||''''  -- to support * wildcards as if it were %
       )
     );
   else
     add
     ( cdwpbase.ifThenElse
       ( qName is not null
       , '  AND    lower(e.name) '
       ||cdwpbase.ifThenElse
         ( ( instr( qName , '%') + instr( qName , '_') + instr( qName , '*') ) > 0 -- wildcards included??
         , 'like '
         , ' = '
         )
       ||''''||replace ( lower(qName), '*','%')||''''  -- to support * wildcards as if it were %
       )
     );

   end if;
   if qDepType is not null
   then
       -- check if there is any Global Name used by or provided by the versions
       add( '  AND    exists
              ( select ''x''
                from   sdd_dependencies d       -- Global Names provided or used by e.ivid
                '
                ||cdwpbase.ifThenElse
                  ( qGlobalNameType is not null or qGlobalName is not null
                  , ',     sdd_global_names gne '
                  )
                ||'
                where  e.ivid             = '
                ||cdwpbase.ifthenelse
                  ( qDepType = 'U'
                  , 'd.client_ivid
                  '
                  , 'd.supplier_ivid
                  '
                  )
                ||cdwpbase.ifThenElse
                  ( qGlobalNameType is not null or qGlobalName is not null
                  , '     and gne.ivid = '
                  ||cdwpbase.ifthenelse
                    ( qDepType = 'U'
                    , 'd.supplier_ivid
                    '
                    , 'd.client_ivid
                    '
                    )
                  ||cdwpbase.ifThenElse
                    ( qGlobalNameType is not null
                    ,' and      ( gne.type_id = '||qGlobalNameType||'
                                 or
                                 gne.domain_irid = '||qGlobalNameType||'
                               )
                      '
                    )
                  ||cdwpbase.ifThenElse
                    ( qGlobalName is not null
                    , cdwpbase.ifThenElse
                      ( instr( qGlobalName, '%') + instr( qGlobalName, '*') > 0
                      ,' and    gne.name like '''||replace(qGlobalName,'*','%')||'''
                      '
                      ,' and    gne.name = '''||qGlobalName||'''
                      '
                      )
                    )
                  )
               ||' UNION
                select ''x''
                from   sdd_dependencies d       -- Global Names provided or used by e.ivid
                '
                ||cdwpbase.ifThenElse
                  ( qGlobalNameType is not null or qGlobalName is not null
                  , ',     sdd_global_names gne '
                  )
                ||'
                where  e.ivid             = '
                ||cdwpbase.ifthenelse
                  ( qDepType = 'U'
                  , 'd.client_parent_ivid
                  '
                  , 'd.supplier_parent_ivid
                  '
                  )
                ||cdwpbase.ifThenElse
                  ( qGlobalNameType is not null or qGlobalName is not null
                  , '     and gne.ivid = '
                  ||cdwpbase.ifthenelse
                  ( qDepType = 'U'
                  , 'd.supplier_ivid
                  '
                  , 'd.client_ivid
                  '
                  )
                  ||cdwpbase.ifThenElse
                    ( qGlobalName is not null
                    , cdwpbase.ifThenElse
                      ( instr( qGlobalName, '%') + instr( qGlobalName, '*') > 0
                      ,' and    gne.name like '''||replace(qGlobalName,'*','%')||'''
                      '
                      ,' and    gne.name = '''||qGlobalName||'''
                      '
                      )
                    )
                  ||cdwpbase.ifThenElse
                    ( qGlobalNameType is not null
                    ,' and      ( gne.type_id = '||qGlobalNameType||'
                                 or
                                 gne.domain_irid = '||qGlobalNameType||'
                               )
                      '
                    )
                  )
               ||'
              )
          ');
   end if; -- qDepType is not null
   if qUsedByIvid is not null
   then
     add( '  AND    exists
            ( select ''x''
              from   sdd_dependencies d       -- Global Names provided by e.ivid
              ,      sdd_dependencies d2      -- Dependencies on Global Names provided by e.ivid
              where  e.ivid             = d.supplier_ivid
              and    d.client_ivid      = d2.supplier_ivid  -- Global Name = Supplier for Dependency
              and    (
                        d2.client_ivid     = '||qUsedByIvid||'
                        OR
                        d2.client_parent_ivid     = '||qUsedByIvid||'
                     )
              UNION
              select ''x''
              from   sdd_dependencies d       -- Global Names provided by e.ivid
              ,      sdd_dependencies d2      -- Dependencies on Global Names provided by e.ivid
              where  e.ivid             = d.supplier_parent_ivid
              and    d.client_ivid      = d2.supplier_ivid  -- Global Name = Supplier for Dependency
              and    (
                       d2.client_ivid     = '||qUsedByIvid||'
                       OR
                       d2.client_parent_ivid     = '||qUsedByIvid||'
                     )
           )
        ');
   end if; -- qUsedByIvid is not null

   add('  ORDER');
   if p_order_by is not null
   then
     add('  BY '
     ||cdwpbase.ifThenElse
       ( instr(lower(p_order_by), 'touched') > 0
       , cdwpbase.ifThenElse
         ( qElementType is not null
         , '    nvl( ci.date_changed, ci.date_created) '
         , '    nvl( e.date_changed, e.date_created) '
         )
       ||cdwpbase.ifThenElse
         ( instr(lower(p_order_by), 'asc') > 0
         , ' ASC'
         , ' DESC'
         )
       , cdwpbase.ifThenElse
         ( instr(lower(p_order_by), 'path') > 0
         , ' jr_name.get_path( e.ivid, ''NAME'', '''', 0) '
          ||cdwpbase.ifThenElse
            ( instr(lower(p_order_by), 'asc') > 0
            , ' ASC'
            , ' DESC'
            )
         , cdwpbase.ifThenElse
           ( instr(lower(p_order_by), 'type') > 0
           , ' cdwpbase.get_nls_type_name( e.logical_type_id) '
           ,'e.'||p_order_by
           )
         )
       )
     ||' , e.name '
     );
   else
     add('  BY     e.name');
     add('  ,      e.irid ');
   end if; -- p_order_by is not null
   add
   ( ';'
   ||' begin
        OPEN  c_ivid;
        FETCH c_ivid
        BULK COLLECT
        INTO  odwasrch.g_iridTab
        ,     odwasrch.g_ividTab
        ,     odwasrch.g_nameTab
        ,     odwasrch.g_vlabelTab
        ,     odwasrch.g_dateChangedTab
        ,     odwasrch.g_typeTab
        ,     odwasrch.g_wbasketTab
        ;
        close c_ivid;
      end;'
    , true
    )
    ;
   g_last_search_cursor:= l_cursor;
   if not p_show_sql_only
   then
     if qWastebasket ='Y'
     then
       jr_context.set_wastebasket;
     end if;
     execute immediate l_cursor;
     jr_context.unset_wastebasket;
     if g_ividTab.count = 0
     then
      g_ividTab  := t_ividTab( -1 );
      g_nameTab:= t_nameTab( substr( sqlerrm||l_cursor, 1, 400)
                           , substr( sqlerrm||l_cursor, 401, 400)
                           , substr( sqlerrm||l_cursor, 801, 400)
                           );
     end if; -- g_ividTab.count = 0
   end if; --not p_show_sql_only
exception
when others
then
    g_ividTab  := t_ividTab( -2 );
    g_iridTab  := t_iridTab( null);
    g_vlabelTab:= t_vlabelTab('1.0');
    g_nameTab:= t_nameTab( substr( sqlerrm||l_cursor, 1, 400)
                         , substr( sqlerrm||l_cursor, 401, 400)
                         , substr( sqlerrm||l_cursor, 801, 400)
                         );
   g_last_search_cursor:= l_cursor;
end; --runSearch


begin
   null;
end; -- odwasrch
/