CREATE OR REPLACE PACKAGE NSLIJHS_DBA AS -------------------------------- -- Source Code File : nslijhs_dba.pks -- * located in Batch SQL area -- * make changes to source file and NOT directly in the DBs !! -- -- PACKAGE DEFINITION -- -- Package : NSLIJHS_DBA -- Purpose : Container for custom Oracle procs in PSoft DBs -- -- History -- 8/1/2003 - Initial Entry, Process Purge code entered -- 8/11/2003 - Added this header and embedded comments -- 8/11/2003 - Added conversion function for Sterling -- 11/20/2003 - Changed to hard-code purged tables -- 11/20/2003 - Function to purge zz_cdm_delete for each rec -- -- Contents -- * add a header below for each group of procs -- * group by functional use -- -------------------------------- -- -- Process Purging Procedures -- * created for use with the process purging program -- * these are invoked by the unix script via SQL*Plus -- -- zz_populate_report_purge : purge initialization -- zz_cleanup_report_purge_tables : normal purge -- zz_cleanup_zzcdmdelete_table : remove row from zz_cdm_delete -- zz_cleanup_orhpaned_prcs : orphan process purge -- zz_long_to_char : chop long comments for use with AppEngine -- zz_tokenizer :Takes in A string, Starting value, and seperator PROCEDURE zz_populate_report_purge; PROCEDURE zz_cleanup_report_purge_table(v_prcsinstance in varchar2); PROCEDURE zz_cleanup_zzcdmdelete_table(v_prcsinstance in varchar2); PROCEDURE zz_analyze_prcs_tables; PROCEDURE zz_cleanup_orphaned_prcs; FUNCTION determine_nvs_expiration(v_prcsinstance in number, v_contentid in number) RETURN number; FUNCTION ZZ_LONG_TO_CHAR( rcn varchar2,oprid varchar2, cid varchar2) RETURN varchar; PROCEDURE zz_tokenizer ( iStart IN NUMBER, sPattern in VARCHAR2, sBuffer in VARCHAR2, sResult OUT VARCHAR2,iNextPos OUT NUMBER); -- -- End Package Definition -- -------------------------------- END NSLIJHS_DBA; /