PACKAGE: APPS.GMA_PURGE_UTILITIES

Source

1 PACKAGE GMA_PURGE_UTILITIES AUTHID CURRENT_USER AS
2 /* $Header: GMAPRGUS.pls 115.3 2002/05/15 17:05:51 pkm ship     $ */
3 
4    -- print a long variable to log
5   PROCEDURE printlong(p_purge_id sy_purg_mst.purge_id%TYPE,
6                       p_text sy_purg_def.sqlstatement%TYPE);
7 
8   -- construct tablename for target and temp tables
9   FUNCTION makearcname(p_purge_id sy_purg_mst.purge_id%TYPE,
10                        p_sourcetable user_tables.table_name%TYPE)
11                   RETURN user_tables.table_name%TYPE;
12 
13   -- print a line of stars to log
14   PROCEDURE printline(p_purge_id sy_purg_mst.purge_id%TYPE);
15 
16   -- print passed text if p_debug_flag is TRUE
17   PROCEDURE printdebug(p_purge_id   sy_purg_mst.purge_id%TYPE,
18                        p_text       sy_purg_def.sqlstatement%TYPE,
19                        p_debug_flag BOOLEAN);
20 
21   -- print timestamp if p_debug_flag is TRUE
22   PROCEDURE debugtime(p_purge_id   sy_purg_mst.purge_id%TYPE,
23                       p_debug_flag BOOLEAN);
24 
25   -- return character representation of HH24:MI:SS named date
26   FUNCTION chartime RETURN     VARCHAR2;
27 
28 END GMA_PURGE_UTILITIES;