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_CMM.SPS
Source Package Specification
Comentários em objetos.
create or replace package pkg_nkw_cmm
timestamp '2006-07-07:10:10:10'
is
   ------------------------------------------------------------------
   -- 2006 DataPRO Developers - m@urelio
   ------------------------------------------------------------------
   -- Version: 2.0.2
   ------------------------------------------------------------------
   -- Collections, Records, Variables, Constants, Exceptions, Cursors
   ------------------------------------------------------------------
   type rec_tabs is record (object_name   user_objects.object_name%TYPE,
			    comments	  pkg_nkw_env.gv_char%TYPE);
   type tab_tabs is table of rec_tabs index by binary_integer;
   gt_tabs  tab_tabs;
   type rec_cols is record (object_name   user_objects.object_name%TYPE,
			    column_name   user_tab_columns.column_name%TYPE,
			    comments	  pkg_nkw_env.gv_char%TYPE);
   type tab_cols is table of rec_cols index by binary_integer;
   gt_cols  tab_cols;
   --------------------------------------------------------------------
   -- SET_COMMENTS
   --------------------------------------------------------------------
   procedure set_comments(ft_tabs in gt_tabs%TYPE);
   --------------------------------------------------------------------
   procedure set_comments(ft_cols in gt_cols%TYPE);
   --------------------------------------------------------------------
   procedure set_comments(fv_object   in pkg_nkw_env.gv_char%TYPE,
			  fv_comments in pkg_nkw_env.gv_char%TYPE);
   --------------------------------------------------------------------
   procedure set_comments(fv_object   in pkg_nkw_env.gv_char%TYPE,
			  fv_column   in pkg_nkw_env.gv_char%TYPE,
			  fv_comments in pkg_nkw_env.gv_char%TYPE);
   --------------------------------------------------------------------
   -- GET_TAB_CMM
   --------------------------------------------------------------------
   procedure get_tab_cmm;
   --------------------------------------------------------------------
   -- GET_COL_CMM
   --------------------------------------------------------------------
   procedure get_col_cmm;
   --------------------------------------------------------------------
   -- POP_COMMENTS
   --------------------------------------------------------------------
   procedure pop_comments(fv_object in pkg_nkw_env.gv_char%TYPE := null);
end pkg_nkw_cmm;
© 2017 DataPRO Developers