drop package LQ
/
/*==============================================================*/
/* Database package: LQ */
/*==============================================================*/
create or replace package LQ as
type OUTLIST is REF CURSOR;
function GETVILLAGENAMEBYID (VILLAGEID In Number) return Varchar2;
function GETTOWNNAMEBYID (TOWNID In Number) return Varchar2;
function GETCOUNTYNAMEBYID (COUNTYID In Number) return Varchar2;
function GETVILLAGECODEBYID (VILLAGEID In Number) return Varchar2;
function GETTOWNCODEBYID (TOWNID In Number) return Varchar2;
function GETCOUNTYCODEBYID (COUNTYID In Number) return Varchar2;
procedure REPORT3VILLAGE (VILLAGEID IN NUMBER,BEGINDATE IN DATE,ENDDATE IN DATE,RETURN_LIST OUT outlist);
procedure REPORT3TOWN (TOWNID IN NUMBER,BEGINDATE in date,ENDDATE in date,RETURN_LIST OUT outlist);
procedure REPORT3COUNTY (COUNTYID IN NUMBER,BEGINDATE in date,ENDDATE in date,RETURN_LIST OUT outlist);
procedure REPORT3CITY (CITYID IN NUMBER,BEGINDATE in date,ENDDATE in date,RETURN_LIST OUT outlist);
procedure REPORT3PROVINCE (PROVINCEID IN NUMBER,BEGINDATE in date,ENDDATE in date,RETURN_LIST OUT outlist);
function GETTOTALNUMBERVILLAGE (VILLAGEID In Number,BEGINDATE In Date,ENDDATE In Date) return Number;
function GETGUOYOUNUMBERVILLAGE (VILLAGEID In Number,BEGINDATE In Date,ENDDATE In Date) return Number;
function GETNONGCUNNUMBERVILLAGE (VILLAGEID In Number,BEGINDATE In Date,ENDDATE In Date) return Number;
function GETGERENNUMBERVILLAGE (VILLAGEID In Number,BEGINDATE In Date,ENDDATE In Date) return Number;
function GETGONGYOUNUMBERVILLAGE (VILLAGEID In Number,BEGINDATE In Date,ENDDATE In Date) return Number;
function GETFEIGONGYOUNUMBERVILLAGE (VILLAGEID In Number,BEGINDATE In Date,ENDDATE In Date) return Number;
function GETQITANUMBERVILLAGE (VILLAGEID In Number,BEGINDATE In Date,ENDDATE In Date) return Number;
function GETTOTALNUMBERTOWN (VILLAGEID In Number,BEGINDATE In Date,ENDDATE In Date) return Number;
function GETGUOYOUNUMBERTOWN (VILLAGEID In Number,BEGINDATE In Date,ENDDATE In Date) return Number;
function GETNONGCUNNUMBERTOWN (VILLAGEID In Number,BEGINDATE In Date,ENDDATE In Date) return Number;
function GETGERENNUMBERTOWN (VILLAGEID In Number,BEGINDATE In Date,ENDDATE In Date) return Number;
function GETGONGYOUNUMBERTOWN (VILLAGEID In Number,BEGINDATE In Date,ENDDATE In Date) return Number;
function GETFEIGONGYOUNUMBERTOWN (VILLAGEID In Number,BEGINDATE In Date,ENDDATE In Date) return Number;
function GETQITANUMBERTOWN (VILLAGEID In Number,BEGINDATE In Date,ENDDATE In Date) return Number;
function GETTOTALNUMBERCOUNTY (VILLAGEID In Number,BEGINDATE In Date,ENDDATE In Date) return Number;
function GETGUOYOUNUMBERCOUNTY (VILLAGEID In Number,BEGINDATE In Date,ENDDATE In Date) return Number;
function GETNONGCUNNUMBERCOUNTY (VILLAGEID In Number,BEGINDATE In Date,ENDDATE In Date) return Number;
function GETGERENNUMBERCOUNTY (VILLAGEID In Number,BEGINDATE In Date,ENDDATE <