create or replace package odwasrch is -- arrays to use as target for BULK COLLECT TYPE t_iridTab IS TABLE OF number(38); TYPE t_ividTab IS TABLE OF number(38); TYPE t_typeTab IS TABLE OF number(38); TYPE t_nameTab IS TABLE OF varchar2(900); TYPE t_vlabelTab IS TABLE OF varchar2(50); TYPE t_wbasketTab IS TABLE OF varchar2(1); TYPE t_dateChangedTab IS TABLE OF date; g_iridTab t_iridTab:= null; g_ividTab t_ividTab:= null; g_typeTab t_typeTab:= null; g_nameTab t_nameTab:= null; g_vlabelTab t_vlabelTab:= null; g_wbasketTab t_wbasketTab:= null; g_dateChangedTab t_dateChangedTab:= null; function get_Last_search_query return varchar2 ; -- 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 -- value: name, date_changed, vlabel , p_show_sql_only in boolean default false , p_enforce_acc_privs in boolean default true ); 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' ); 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' ); 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' ); -- 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 ); end; -- odwasrch /