DBA Data[Home] [Help]

APPS.GMA_PURGE_UTILITIES dependencies on SY_PURG_MST

Line 5: PROCEDURE printlong(p_purge_id sy_purg_mst.purge_id%TYPE,

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,

Line 9: FUNCTION makearcname(p_purge_id sy_purg_mst.purge_id%TYPE,

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

Line 14: PROCEDURE printline(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,

Line 17: PROCEDURE printdebug(p_purge_id sy_purg_mst.purge_id%TYPE,

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

Line 22: PROCEDURE debugtime(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;