pac_regdateclass.sql

图书管理系统

-- Start of DDL Script for Package ORALDBA.OMPS_PAGE_REGDATACLASS
-- Generated 13-一月-2008 0:02:22 from ORALDBA@ORAL

CREATE OR REPLACE 
PACKAGE omps_page_regdataclass
  AS
  
TYPE ref_detail IS REF CURSOR;--
-- To modify this template, edit file PKGSPEC.TXT in TEMPLATE 
-- directory of SQL Navigator
--
-- Purpose: Briefly explain the functionality of the package
--
-- MODIFICATION HISTORY
-- Person      Date    Comments
-- ---------   ------  ------------------------------------------       
   -- Enter package declarations as shown below
TYPE t_table IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;

  PROCEDURE PROC_OMPS_ADDNULLDATECLASS(                              --新建日期规则类型
      i_rulecode                  IN   VARCHAR2,              --规则类型ID号
      i_rulename                  IN   VARCHAR2,
      i_describe                  IN   VARCHAR2,              --规则描述
      i_startdate                   IN   VARCHAR2,
      i_overdate                    IN   VARCHAR2,
      i_maker1                    IN   VARCHAR2,
      i_state1                        IN   VARCHAR2,
      i_remark1                      IN   VARCHAR2,
--      i_info                       IN   VARCHAR2,
      o_retCode                    OUT  VARCHAR2,
      o_err_msg                    OUT  VARCHAR2                 --错误信息
      );
  PROCEDURE PROC_OMPS_ADDUNREGDATECLASS1(                              --新建日期规则类型
      i_rulecode                  IN   VARCHAR2,              --规则类型ID号
      i_rulename                  IN   VARCHAR2,
      i_describe                  IN   VARCHAR2,              --规则描述
      i_startdate                   IN   VARCHAR2,
      i_overdate                    IN   VARCHAR2,
      i_maker1                    IN   VARCHAR2,
      i_state1                        IN   VARCHAR2,
      i_remark1                      IN   VARCHAR2,
      i_datestr                   IN   VARCHAR2,
--      i_info                       IN   VARCHAR2,
      o_retCode                    OUT  VARCHAR2,
      o_err_msg                    OUT  VARCHAR2                 --错误信息
      );

     PROCEDURE PROC_OMPS_UPDATEREGDATE1(                              --新建日期规则类型
       i_ruleid                  IN   VARCHAR2,              --规则类型ID号
      i_datestr1                   IN   VARCHAR2,
      i_datestr2                  IN   VARCHAR2,
      i_datestr3                   IN   VARCHAR2,
      i_startdate                 IN   VARCHAR2,
      i_overdate                  IN   VARCHAR2,
      i_remark1                      IN   VARCHAR2,
      i_maker1                     IN   VARCHAR2,
      i_state1                     IN   VARCHAR2,
--      i_info                       IN   VARCHAR2,
      o_retCode                    OUT  VARCHAR2,
      o_err_msg                    OUT  VARCHAR2
      );
    PROCEDURE PROC_OMPS_UPDATEREMARK1(                              --新建日期规则类型
      i_ruleid                  IN   VARCHAR2,              --规则类型ID号
      i_remark1                      IN   VARCHAR2,

--      i_info                       IN   VARCHAR2,
      o_retCode                    OUT  VARCHAR2,
      o_err_msg                    OUT  VARCHAR2
      );
   PROCEDURE PROC_OMPS_QUYREGDATECLASS1(
      i_maker1                    IN   VARCHAR2,
      i_state1                     IN   VARCHAR2,
   -- i_info                       IN   VARCHAR2,

      o_retCode                    OUT  VARCHAR2,
      o_err_msg                    OUT  VARCHAR2,
      o_rule_ref_detail            OUT  ref_detail
     );
	FUNCTION str2table(i_str VARCHAR2,
							 t     OUT t_table) RETURN VARCHAR2;
     
      PROCEDURE PROC_OMPS_DELUNREGDATERULE(
      i_ruleid                    IN   VARCHAR2,
   -- i_info                       IN   VARCHAR2,

      o_retCode                    OUT  VARCHAR2,
      o_err_msg                    OUT  VARCHAR2
     );
    PROCEDURE PROC_OMPS_QUYMAKER1(
      o_retCode                    OUT  VARCHAR2,
      o_err_msg                    OUT  VARCHAR2,
      o_maker_ref_detail            OUT  ref_detail
     );
     
     PROCEDURE PROC_OMPS_QUYMAKER2(
      o_retCode                    OUT  VARCHAR2,
      o_err_msg                    OUT  VARCHAR2,
      o_maker2_ref_detail            OUT  ref_detail
     );
     
      PROCEDURE PROC_OMPS_QUYMAKER3(
      o_retCode                    OUT  VARCHAR2,
      o_err_msg                    OUT  VARCHAR2,
      o_maker3_ref_detail            OUT  ref_detail
     );
     
       PROCEDURE PROC_OMPS_QUYMAKER4(
      o_retCode                    OUT  VARCHAR2,
      o_err_msg                    OUT  VARCHAR2,
      o_maker4_ref_detail            OUT  ref_detail
     );
   PROCEDURE PROC_OMPS_QUYDATECLASS1(
      i_rulename                   IN   VARCHAR2,
      i_rulecode                   IN   VARCHAR2,
      i_startdate                  IN   VARCHAR2,
      i_maker                      IN   VARCHAR2,
      i_state1                      IN   VARCHAR2,
   -- i_info                       IN   VARCHAR2,

      o_retCode                    OUT  VARCHAR2,
      o_err_msg                    OUT  VARCHAR2,
      o_dateclass_ref_detail            OUT  ref_detail
     );
     PROCEDURE PROC_OMPS_QUYDATECLASS2(
      i_rulename                   IN   VARCHAR2,
      i_rulecode                   IN   VARCHAR2,
      i_startdate                  IN   VARCHAR2,
      i_maker                      IN   VARCHAR2,
      i_state1                      IN   VARCHAR2,
   -- i_info                       IN   VARCHAR2,

      o_retCode                    OUT  VARCHAR2,
      o_err_msg                    OUT  VARCHAR2,
      o_dateclass_ref_detail            OUT  ref_detail
     );
     
     

      PROCEDURE PROC_OMPS_QUYDETAILDATECLASS1(
      i_ruleid                    IN   VARCHAR2,
      
   -- i_info                       IN   VARCHAR2,

      o_retCode                    OUT  VARCHAR2,
      o_err_msg                    OUT  VARCHAR2,
      o_dateclass_ref_detail3            OUT  ref_detail
     );
   PROCEDURE PROC_OMPS_QUYDETAILDATECLASS2(
      i_ruleid                    IN   VARCHAR2,

   -- i_info                       IN   VARCHAR2,

        o_retCode                    OUT  VARCHAR2,
        o_err_msg                    OUT  VARCHAR2,
        o_dateclass_ref_detail4            OUT  ref_detail,
        o_dateclass_ref_detail5            OUT  ref_detail,
        o_dateclass_ref_detail6            OUT  ref_detail
     );
     PROCEDURE PROC_OMPS_QUYDETAILDATECLASS3(
      i_ruleid                    IN   VARCHAR2,

   -- i_info                       IN   VARCHAR2,

        o_retCode                    OUT  VARCHAR2,
        o_err_msg                    OUT  VARCHAR2,
        o_dateclass_ref_detail4            OUT  ref_detail
       
     );
     
      PROCEDURE PROC_OMPS_DELDETAILDATE1(
      i_dateid                    IN   VARCHAR2,
      i_ruleid                    IN   VARCHAR2,
   -- i_info                       IN   VARCHAR2,

      o_retCode                    OUT  VARCHAR2,
      o_err_msg                    OUT  VARCHAR2
     );
     
  PROCEDURE PROC_OMPS_QUYCHECKDATECLASS1(
      i_rulename                   IN   VARCHAR2,
      i_rulecode                   IN   VARCHAR2,
      i_startdate                  IN   VARCHAR2,
      i_maker                      IN   VARCHAR2,
      i_state1                      IN   VARCHAR2,
      i_state2                      IN   VARCHAR2,
   -- i_info                       IN   VARCHAR2,

      o_retCode                    OUT  VARCHAR2,
      o_err_msg                    OUT  VARCHAR2,
      o_checkdateclass_ref_detail            OUT  ref_detail
     );
     
   
     
       PROCEDURE PROC_OMPS_WAITDELDETAILDATE(
      i_dateid                    IN   VARCHAR2,
      i_ruleid                    IN   VARCHAR2,
      i_maker1                    IN   VARCHAR2,
   -- i_info                       IN   VARCHAR2,

      o_retCode                    OUT  VARCHAR2,
      o_err_msg                    OUT  VARCHAR2
     );
     
      PROCEDURE PROC_OMPS_QRYWAITDATE(
      i_ruleid                    IN   VARCHAR2,
      i_date                      IN   VARCHAR2,
   -- i_info                       IN   VARCHAR2,

      o_retCode                    OUT  VARCHAR2,
      o_err_msg                    OUT  VARCHAR2
     );
     PROCEDURE PROC_OMPS_ADDWAITNEWDATE(
      i_ruleid                    IN   VARCHAR2,
      i_maker1                    IN   VARCHAR2,
      i_newdate                    IN   VARCHAR2,
      i_rulename                    IN   VARCHAR2,
      i_rulecode                    IN   VARCHAR2,
      i_state                    IN   VARCHAR2,
   -- i_info                       IN   VARCHAR2,

      o_retCode                    OUT  VARCHAR2,
      o_err_msg                    OUT  VARCHAR2
     );
    PROCEDURE PROC_OMPS_CHECKDETAILDATE1(
      i_ruleid                    IN   VARCHAR2,
      i_dateid                    IN   VARCHAR2,
      i_state1                   IN   VARCHAR2,
      i_maker1                   IN   VARCHAR2,
   -- i_info                       IN   VARCHAR2,

      o_retCode                    OUT  VARCHAR2,
      o_err_msg                    OUT  VARCHAR2
     );
      PROCEDURE PROC_OMPS_CHECKDATECLASS(
      i_ruleid                    IN   VARCHAR2,
      i_maker1                   IN   VARCHAR2,
   -- i_info                       IN   VARCHAR2,

      o_retCode                    OUT  VARCHAR2,
      o_err_msg                    OUT  VARCHAR2
     );

PROCEDURE PROC_OMPS_ADDUNREGQRYcode(
      i_rulecode                   IN   VARCHAR2,
   -- i_info                       IN   VARCHAR2,

      o_retCode                    OUT  VARCHAR2,
      o_err_msg                    OUT  VARCHAR2
     );

 PROCEDURE PROC_OMPS_ADDUNREGQRYDATECLASS(
      i_rulename                    IN   VARCHAR2,
   -- i_info                       IN   VARCHAR2,

      o_retCode                    OUT  VARCHAR2,
      o_err_msg                    OUT  VARCHAR2
     );
      PROCEDURE PROC_OMPS_DELQRYDATECLASS1(
      i_rulename                   IN   VARCHAR2,
      i_rulecode                   IN   VARCHAR2,
      i_startdate                  IN   VARCHAR2,
      i_maker                      IN   VARCHAR2,
      
   -- i_info                       IN   VARCHAR2,

      o_retCode                    OUT  VARCHAR2,
      o_err_msg                    OUT  VARCHAR2,
      o_dateclass_ref_detail            OUT  ref_detail
     );
     
      PROCEDURE PROC_OMPS_WAITDELDATE(
      i_ruleid                    IN   VARCHAR2,
      i_maker1                    IN   VARCHAR2,
   -- i_info                       IN   VARCHAR2,

      o_retCode                    OUT  VARCHAR2,
      o_err_msg                    OUT  VARCHAR2
     );
     
       PROCEDURE PROC_OMPS_DELDATECLASS1(
      i_ruleid                    IN   VARCHAR2,
   -- i_info                       IN   VARCHAR2,

      o_retCode                    OUT  VARCHAR2,
      o_err_msg                    OUT  VARCHAR2
     );
     
      PROCEDURE PROC_OMPS_DELDATECLASS2(
      i_ruleid                    IN   VARCHAR2,
       i_maker1                    IN   VARCHAR2,
   -- i_info                       IN   VARCHAR2,

      o_retCode                    OUT  VARCHAR2,
      o_err_msg                    OUT  VARCHAR2
     );
    
end;
/



-- End of DDL Script for Package ORALDBA.OMPS_PAGE_REGDATACLASS