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; / show errors