CREATE OR REPLACE PACKAGE wb_rt_transaction_handler AS

DOMAIN         NUMBER:= 1;
FD_UK          NUMBER:= 2;
FK             NUMBER:= 4;
REDUNDANT      NUMBER:= 8;
BUSINESSRULE   NUMBER:= 16;
PATTERN        NUMBER:= 32;

--PROCEDURE addPartition(tblID IN NUMBER,tableName IN VARCHAR2);
--PROCEDURE dropPartition(tblID IN NUMBER,tableName IN VARCHAR2);
PROCEDURE addPartition(tblID IN NUMBER,mask IN NUMBER,type IN NUMBER);
PROCEDURE dropPartition(tblID IN NUMBER,mask IN NUMBER,type IN NUMBER);
PROCEDURE doRollback(prfID IN NUMBER,type IN NUMBER);
PROCEDURE doRollbackSetup(prfID IN NUMBER,type IN NUMBER);
PROCEDURE doRollback(prfID IN NUMBER,tblID IN NUMBER,mask IN NUMBER,
  type IN NUMBER);
PROCEDURE doRollbackSetup(prfID IN NUMBER,tblID IN NUMBER,mask IN NUMBER,
  type IN NUMBER);
PROCEDURE configureReprofile(fkreprofile IN NUMBER);
FUNCTION doProfileType(mask IN NUMBER,type IN NUMBER) RETURN BOOLEAN;
PROCEDURE dropPartitions;

END wb_rt_transaction_handler;
/