Introdução 

 SQL Scripts 

 Packages 
 pkg_nkw_exc 
 pkg_nkw_env 
 pkg_nkw_rpl 
 pkg_nkw_std 
 pkg_nkw_app 
 pkg_nkw_spm 
 pkg_nkw_hfs 
 pkg_nkw_sdv 
 pkg_nkw_sys 
 pkg_nkw_obj 
 pkg_nkw_grv 
 pkg_nkw_usr 
 pkg_nkw_cmm 
 pkg_nkw_hlp 
 pkg_nkw_dvp 
 pkg_nkw_dnt_std 
 pkg_nkw_dnt_dvies 
 pkg_nkw_dnt_ccvies 
 pkg_nkw_dnt_logies 
 pkg_nkw_dnt_eppc 
 pkg_nkw_dnt_eapb 
 pkg_nkw_dnt_drmies 
 pkg_nkw_dnt 
 pkg_nkw_drm 
 pkg_nkw_oim 
 pkg_nkw_aud 
 pkg_nkw_dpl 
 pkg_nkw_srw 

 Packages Body 

 Forms 6i 

 Reports 6i 

Linux  

 Downloads 
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;
© 2017 DataPRO Developers