select  1  as edit_cmd,
       row_number() over (order by t.doc_reg_date) as npp,
       t.doc_id,
       t.doc_in_out_num,
       t.doc_reg_date,
       t.doc_from,
       t.doc_body,
       t.doc_to,
       t.doc_app_date,
       t.doc_state
  from document t 
 where (t.doc_in_out_num = :P1_SRC_TXT_DOC_IN_OUT_NUM or :P1_SRC_TXT_DOC_IN_OUT_NUM is null)
   and (t.doc_reg_date between nvl(to_date(:P1_SRC_DT_REG_DATE_BEGIN, 'DD.MM.YYYY'), to_date('01.01.1990', 'DD.MM.YYYY')) 
                           and nvl(to_date(:P1_SRC_DT_REG_DATE_END, 'DD.MM.YYYY'), to_date('01.01.2199', 'DD.MM.YYYY')))
   and (t.doc_state = :P1_SRC_DDL_DOC_STATE or :P1_SRC_DDL_DOC_STATE is null)
   and (t.doc_from = :P1_SRC_TXT_DOC_FROM or :P1_SRC_TXT_DOC_FROM is null)
   and (t.doc_to = :P1_SRC_TXT_DOC_TO or :P1_SRC_TXT_DOC_TO is null)
   and (t.doc_app_date is null or t.doc_app_date between nvl(to_date(:P1_SRC_DT_REG_APP_DATE_BEGIN, 'DD.MM.YYYY'), to_date('01.01.1990', 'DD.MM.YYYY')) 
                           and nvl(to_date(:P1_SRC_DT_REG_APP_DATE_END, 'DD.MM.YYYY'), to_date('01.01.2199', 'DD.MM.YYYY')))

function search_document(){
   gReport.search('SEARCH');   
   hide_doc_search_dialog();
}