PKG_NKW_STD.SPS
Source Package Specification
Funções de usuários.
create or replace package pkg_nkw_std
timestamp '2006-07-07:10:10:10'
is
------------------------------------------------------------------
-- 2006 DataPRO Developers - m@urelio
------------------------------------------------------------------
-- Version: 2.0.2
------------------------------------------------------------------
-- Collections, Records, Variables, Constants, Exceptions, Cursors
------------------------------------------------------------------
------------------------------------------------------------------
-- ON_RANGE
------------------------------------------------------------------
function on_range(fv_date in date,
fv_low in date,
fv_high in date)
return integer;
pragma restrict_references(on_range, WNDS, WNPS);
function on_range(fv_number in number,
fv_low in number,
fv_high in number)
return integer;
pragma restrict_references(on_range, WNDS, WNPS);
function on_range(fv_string in varchar2,
fv_low in varchar2,
fv_high in varchar2)
return integer;
pragma restrict_references(on_range, WNDS, WNPS);
------------------------------------------------------------------
-- GET_MINUTES
------------------------------------------------------------------
function get_minutes(fv_minutes in number) return number;
pragma restrict_references(get_minutes, WNDS, WNPS);
------------------------------------------------------------------
-- GET_HOURS
------------------------------------------------------------------
function get_hours(fv_hours in number) return number;
pragma restrict_references(get_hours, WNDS, WNPS);
------------------------------------------------------------------
-- FMT_HOURS
------------------------------------------------------------------
function fmt_hours(fv_minutes in number) return varchar2;
pragma restrict_references(fmt_hours, WNDS, WNPS);
------------------------------------------------------------------
-- FMT_SUM_HOURS
------------------------------------------------------------------
function fmt_sum_hours(fv_minutes in number) return varchar2;
pragma restrict_references(fmt_sum_hours, WNDS, WNPS);
------------------------------------------------------------------
-- FMT_INPUT
------------------------------------------------------------------
function fmt_input(fv_minutes in number) return varchar2;
pragma restrict_references(fmt_input, WNDS, WNPS);
------------------------------------------------------------------
-- IS_TIME
------------------------------------------------------------------
function is_time(fv_time in number) return boolean;
pragma restrict_references(is_time, WNDS, WNPS);
------------------------------------------------------------------
-- IS_DATE
------------------------------------------------------------------
function is_date(fv_string in varchar2 := null,
fv_format in varchar2 := null) return boolean;
pragma restrict_references(is_date, WNDS, WNPS);
------------------------------------------------------------------
-- IS_NUMBER
------------------------------------------------------------------
function is_number(fv_string in varchar2 := null) return boolean;
pragma restrict_references(is_number, WNDS, WNPS);
------------------------------------------------------------------
-- IS_INTEGER
------------------------------------------------------------------
function is_integer(fv_string in varchar2 := null) return boolean;
pragma restrict_references(is_integer, WNDS, WNPS);
------------------------------------------------------------------
-- IS_UF
------------------------------------------------------------------
function is_uf(fv_uf in varchar2 := null) return boolean;
pragma restrict_references(is_uf, WNDS, WNPS);
------------------------------------------------------------------
-- IS_PASSWD
------------------------------------------------------------------
function is_passwd(fv_passwd in varchar2 := null) return boolean;
pragma restrict_references(is_passwd, WNDS, WNPS);
------------------------------------------------------------------
-- IS_CNPJ - Checa digitos verificadores do CNPJ
------------------------------------------------------------------
function is_cnpj(fv_cnpj in number) return boolean;
pragma restrict_references(is_cnpj, WNDS, WNPS);
------------------------------------------------------------------
-- IS_CPF - Checa digitos verificadores do CPF
------------------------------------------------------------------
function is_cpf(fv_cpf in number) return boolean;
pragma restrict_references(is_cpf, WNDS, WNPS);
------------------------------------------------------------------
-- IS_CGC
------------------------------------------------------------------
function is_cgc(fv_num in number, fv_pessoa in varchar2) return boolean;
pragma restrict_references(is_cgc, WNDS, WNPS);
------------------------------------------------------------------
-- TO_INTEGER
------------------------------------------------------------------
function to_integer(fv_string in varchar2) return number;
pragma restrict_references(to_integer, WNDS, WNPS);
------------------------------------------------------------------
-- TO_FEIRA
------------------------------------------------------------------
function to_feira(fv_date in date) return varchar2;
pragma restrict_references(to_feira, WNDS, WNPS);
------------------------------------------------------------------
-- CIAO
------------------------------------------------------------------
function ciao return varchar2;
pragma restrict_references(ciao, WNDS, WNPS);
------------------------------------------------------------------
-- PRENOM
------------------------------------------------------------------
function prenom(fv_name in varchar2) return varchar2;
pragma restrict_references(prenom, WNDS, WNPS);
------------------------------------------------------------------
-- FMT_CGC - Formata CNPJ e CPF
------------------------------------------------------------------
function fmt_cgc(fv_cgc in number, fv_pessoa in varchar2 := 'F')
return varchar2;
pragma restrict_references(fmt_cgc, WNDS, WNPS);
------------------------------------------------------------------
-- FMT_CNPJ - Formata CNPJ
------------------------------------------------------------------
function fmt_cnpj(fv_cnpj in number) return varchar2;
pragma restrict_references(fmt_cnpj, WNDS, WNPS);
------------------------------------------------------------------
-- FMT_CPF - Formata CPF
------------------------------------------------------------------
function fmt_cpf(fv_cpf in number) return varchar2;
pragma restrict_references(fmt_cpf, WNDS, WNPS);
------------------------------------------------------------------
-- FMT_CEP - Formata CEP
------------------------------------------------------------------
function fmt_cep(fv_cep in number) return varchar2;
pragma restrict_references(fmt_cep, WNDS, WNPS);
------------------------------------------------------------------
-- FMT_LIKE - Format a string to a like comparison
------------------------------------------------------------------
function fmt_like(fv_char in varchar2) return varchar2;
pragma restrict_references(fmt_like, WNDS, WNPS);
------------------------------------------------------------------
-- FMT_TEXT - Format a text for a nice retrieval...
------------------------------------------------------------------
function fmt_text(fv_text in varchar2) return varchar2;
pragma restrict_references(fmt_text, WNDS, WNPS);
------------------------------------------------------------------
-- FMT_CHAR - Format a varchar2 value for store
------------------------------------------------------------------
function fmt_char(fv_char in varchar2, fv_length in number := 32767)
return varchar2;
pragma restrict_references(fmt_char, WNDS, WNPS);
------------------------------------------------------------------
-- GET_SYSDATE - Gets the DataBase TimeStamp
------------------------------------------------------------------
function get_sysdate return date;
pragma restrict_references(get_sysdate, WNDS, WNPS);
------------------------------------------------------------------
-- SPLIT
------------------------------------------------------------------
function split(fv_string in varchar2,
fv_sep in varchar2,
fv_field in number)
return varchar2;
------------------------------------------------------------------
-- DEC2BIN
------------------------------------------------------------------
function dec2bin(fv_value in integer) return integer;
pragma restrict_references(dec2bin, WNDS, WNPS);
------------------------------------------------------------------
-- BIN2DEC
------------------------------------------------------------------
function bin2dec(fv_value in integer) return integer;
pragma restrict_references(bin2dec, WNDS, WNPS);
------------------------------------------------------------------
-- DEC2OCT
------------------------------------------------------------------
function dec2oct(fv_value in integer) return integer;
pragma restrict_references(dec2oct, WNDS, WNPS);
------------------------------------------------------------------
-- OCT2DEC
------------------------------------------------------------------
function oct2dec(fv_value in integer) return integer;
pragma restrict_references(oct2dec, WNDS, WNPS);
------------------------------------------------------------------
-- DEC2HEX
------------------------------------------------------------------
function dec2hex(fv_value in integer) return varchar2;
pragma restrict_references(dec2hex, WNDS, WNPS);
------------------------------------------------------------------
-- HEX2DEC
------------------------------------------------------------------
function hex2dec(fv_value in varchar2) return integer;
pragma restrict_references(hex2dec, WNDS, WNPS);
------------------------------------------------------------------
-- DEC2ASC
------------------------------------------------------------------
function dec2asc(fv_value in integer) return varchar2;
pragma restrict_references(dec2asc, WNDS, WNPS);
------------------------------------------------------------------
-- ASC2DEC
------------------------------------------------------------------
function asc2dec(fv_value in varchar2) return integer;
pragma restrict_references(asc2dec, WNDS, WNPS);
------------------------------------------------------------------
-- CREATE_DV
------------------------------------------------------------------
function create_dv(fv_int in integer)
return integer;
pragma restrict_references(create_dv, WNDS, WNPS);
------------------------------------------------------------------
-- CHECK_DV
------------------------------------------------------------------
function check_dv(fv_int in integer)
return boolean;
------------------------------------------------------------------
-- FMT_DV
------------------------------------------------------------------
function fmt_dv(fv_int in integer,
fv_digits in integer := 6)
return varchar2;
pragma restrict_references(fmt_dv, WNDS, WNPS);
end pkg_nkw_std;
|
