APPS.GMA_PURGE_UTILITIES dependencies on SY_PURG_MST

Line 5: PROCEDURE logprint(p_purge_id sy_purg_mst.purge_id%TYPE,p_text VARCHAR2);

1: PACKAGE BODY GMA_PURGE_UTILITIES AS
2: /* $Header: GMAPRGUB.pls 115.9 2003/10/27 07:48:22 kmoizudd ship $ */
3:
4: -- output text in dated format to log
5: PROCEDURE logprint(p_purge_id sy_purg_mst.purge_id%TYPE,p_text VARCHAR2);
6:
7: /***/
8:
9: PROCEDURE logprint(p_purge_id sy_purg_mst.purge_id%TYPE,p_text VARCHAR2) IS

Line 9: PROCEDURE logprint(p_purge_id sy_purg_mst.purge_id%TYPE,p_text VARCHAR2) IS

5: PROCEDURE logprint(p_purge_id sy_purg_mst.purge_id%TYPE,p_text VARCHAR2);
6:
7: /***/
8:
9: PROCEDURE logprint(p_purge_id sy_purg_mst.purge_id%TYPE,p_text VARCHAR2) IS
10:
11: BEGIN
12:
13: -- Log the message to the DB

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

45: END logprint;
46:
47: /***********************************************************/
48:
49: PROCEDURE printdebug(p_purge_id sy_purg_mst.purge_id%TYPE,
50: p_text sy_purg_def.sqlstatement%TYPE,
51: p_debug_flag BOOLEAN) IS
52: -- print a line of stars before output, show length of string
53: BEGIN

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

72: END;
73:
74: /***********************************************************/
75:
76: PROCEDURE printlong(p_purge_id sy_purg_mst.purge_id%TYPE,
77: p_text sy_purg_def.sqlstatement%TYPE) IS
78: -- prints long text string broken at 80 columns
79:
80: l_counter INTEGER;

Line 114: PROCEDURE debugtime(p_purge_id sy_purg_mst.purge_id%TYPE,

110: END printlong;
111:
112: /***********************************************************/
113:
114: PROCEDURE debugtime(p_purge_id sy_purg_mst.purge_id%TYPE,
115: p_debug_flag BOOLEAN) IS
116: -- prints timestamp if debug flag is TRUE
117:
118: BEGIN

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

135: END debugtime;
136:
137: /***********************************************************/
138:
139: FUNCTION makearcname(p_purge_id sy_purg_mst.purge_id%TYPE,
140: p_sourcetable user_tables.table_name%TYPE)
141: RETURN user_tables.table_name%TYPE
142: IS
143:

Line 173: PROCEDURE printline(p_purge_id sy_purg_mst.purge_id%TYPE) IS

169: END makearcname;
170:
171: /***********************************************************/
172:
173: PROCEDURE printline(p_purge_id sy_purg_mst.purge_id%TYPE) IS
174: BEGIN
175: GMA_PURGE_UTILITIES.logprint(p_purge_id,
176: '****************************************' ||
177: '****************************************');