table_to_html_mail
CREATE OR REPLACE PACKAGE BODY DDSBASE.PKG_TABLE_TO_HTML AS -- week cursor for fetching row TYPE REFCUR IS REF CURSOR; v_job_module VARCHAR2(50) := 'REPORTS'; -- Job Module Name : v_pkgc VARCHAR2(50) := 'PKG_TABLE_TO_HTML'; -- PLSQL Package Name v_job_owner VARCHAR2(50) := 'DDSBASE'; -- Owner of the Job v_proc VARCHAR2(3000); -- Procedure Name c_delim VARCHAR2(10) := ' : '; -- Delimiter Used In Logging -- get the cursor id and concatenate fetched row as html row FUNCTION CONCATENATE_ROW (ICURNUM INTEGER) RETURN CLOB IS CLOBTEMP CLOB; CLOBDATA CL