--
-- BBAN_IBAN_BIC  (Package) 
--
/**
* ONLY FOR BELGIAN BBAN, BIC AND IBAN !!!
*/
CREATE OR REPLACE package ACIS_COMMUN.bban_iban_bic as
/**
* Function returns '1' if the bban code is validated 
* @param p_bban                String of the code to validate (without '-')
* @return Returns a char '1' TRUE if the code is validated, else '0' is returned
*/
FUNCTION VALIDATE_BBAN
( p_bban IN VARCHAR2 ) return CHAR;
/**
* Function returns '1' if the iban code is validated 
* @param p_iban                String of the code to validate (without '-')
* @return Returns a char '1' TRUE if the code is validated, else '0' is returned
*/
FUNCTION VALIDATE_IBAN
( p_iban IN VARCHAR2 ) return CHAR;
/**
* Function returns '1' if the bic code is validated 
* @param p_bic                String of the code to validate (without '-')
* @return Returns a char '1' TRUE if the code is validated, else '0' is returned
*/
FUNCTION VALIDATE_BIC
( p_bic IN VARCHAR2 ) return CHAR;
/**
* Function returns the converted IBAN code from the belgian BBAN
* @param p_bban                String of the code to convert (without '-')
* @return Returns the converted code
*/
FUNCTION BBAN_TO_IBAN
( p_bban IN VARCHAR2 ) return VARCHAR2;
/**
* Function returns the converted BBAN code from the belgian IBAN
* @param p_iban                String of the code to convert (without '-')
* @return Returns the converted code
*/
FUNCTION IBAN_TO_BBAN
( p_iban IN VARCHAR2 ) return VARCHAR2;
/**
* Function returns the extracted BIC code from the belgian BBAN
* @param p_bban                String of the code to extract bic code (without '-')
* @return Returns the extracted code
*/
FUNCTION BIC_FROM_BBAN
( p_bban IN VARCHAR2 ) return VARCHAR2;
/**
* Function returns the extracted BIC code from the belgian IBAN
* @param p_iban                String of the code to extract bic code (without '-')
* @return Returns the extracted code
*/
FUNCTION BIC_FROM_IBAN
( p_iban IN VARCHAR2 ) return VARCHAR2;
/**
* Function returns the bank name from the belgian BBAN
* @param p_bban                String of the code to extract bank name (without '-')
* @return Returns the bank name
*/
FUNCTION NAME_FROM_BBAN
( p_bban IN VARCHAR2 ) return VARCHAR2;
/**
* Function returns the bank name from the belgian IBAN
* @param p_iban                String of the code to extract bank name (without '-')
* @return Returns the bank name
*/
FUNCTION NAME_FROM_IBAN
( p_iban IN VARCHAR2 ) return VARCHAR2;

end bban_iban_bic;
/