PKG_NKW_DNT.SPS
Source Package Specification
Dynamic Trigger - Pacote principal
create or replace package pkg_nkw_dnt
timestamp '2006-07-07:10:10:10'
is
------------------------------------------------------------------
-- 2006 DataPRO Developers - m@urelio
------------------------------------------------------------------
-- Version: 2.0.2
------------------------------------------------------------------
-- Collections, Records, Variables, Constants, Exceptions, Cursors
------------------------------------------------------------------
gt_data pkg_nkw_obj.gt_data%TYPE;
gt_old_data pkg_nkw_obj.gt_data%TYPE;
gt_new_data pkg_nkw_obj.gt_data%TYPE;
gr_dtgc nkw_dnt_dtgc%ROWTYPE;
gv_object pkg_nkw_env.gv_char%TYPE;
gv_action pkg_nkw_env.gv_char%TYPE;
ge_dnt exception;
gv_message pkg_nkw_env.gv_char%TYPE;
gr_session v$session%ROWTYPE;
gv_session pkg_nkw_env.gv_char%TYPE;
gv_label pkg_nkw_env.gv_char%TYPE;
------------------------------------------------------------------
-- INIT_DNT
------------------------------------------------------------------
procedure init_dnt(fv_object in pkg_nkw_env.gv_char%TYPE);
------------------------------------------------------------------
-- BIND_COLUMN
------------------------------------------------------------------
procedure bind_column(fv_column in pkg_nkw_env.gv_char%TYPE,
fv_old in date := null,
fv_new in date := null);
------------------------------------------------------------------
procedure bind_column(fv_column in pkg_nkw_env.gv_char%TYPE,
fv_old in number := null,
fv_new in number := null);
------------------------------------------------------------------
procedure bind_column(fv_column in pkg_nkw_env.gv_char%TYPE,
fv_old in pkg_nkw_env.gv_char%TYPE := null,
fv_new in pkg_nkw_env.gv_char%TYPE := null);
------------------------------------------------------------------
-- PARSE_ACTION
------------------------------------------------------------------
procedure parse_action;
------------------------------------------------------------------
-- SET_NEW
------------------------------------------------------------------
procedure set_new(fv_column in pkg_nkw_env.gv_char%TYPE,
fv_value out date);
procedure set_new(fv_column in pkg_nkw_env.gv_char%TYPE,
fv_value out number);
procedure set_new(fv_column in pkg_nkw_env.gv_char%TYPE,
fv_value out pkg_nkw_env.gv_char%TYPE);
end pkg_nkw_dnt;
|