DBA Data[Home] [Help]

APPS.GMA_PURGE_COPY dependencies on GMA_PURGE_UTILITIES

Line 52: GMA_PURGE_UTILITIES.printlong(p_purge_id,

48:
49: -- deal with the tables, starting with the most detail and moving towards
50: -- the document master table
51:
52: GMA_PURGE_UTILITIES.printlong(p_purge_id,
53: 'Starting copy... ' ||
54: GMA_PURGE_UTILITIES.chartime);
55:
56: -- do each table

Line 54: GMA_PURGE_UTILITIES.chartime);

50: -- the document master table
51:
52: GMA_PURGE_UTILITIES.printlong(p_purge_id,
53: 'Starting copy... ' ||
54: GMA_PURGE_UTILITIES.chartime);
55:
56: -- do each table
57: FOR l_arctableno IN REVERSE 0 .. p_tablecount LOOP
58:

Line 60: l_arctablename := GMA_PURGE_UTILITIES.makearcname(p_purge_id,

56: -- do each table
57: FOR l_arctableno IN REVERSE 0 .. p_tablecount LOOP
58:
59: l_sourcetable := p_tablename_tab(l_arctableno);
60: l_arctablename := GMA_PURGE_UTILITIES.makearcname(p_purge_id,
61: p_tablename_tab(l_arctableno));
62:
63: -- create and open cursor for detail table rowids
64: -- Made by Khaja

Line 81: GMA_PURGE_UTILITIES.printdebug(p_purge_id,l_sqlstatement,p_debug_flag);

77: '0' ||
78: '''' ||
79: ')';
80:
81: GMA_PURGE_UTILITIES.printdebug(p_purge_id,l_sqlstatement,p_debug_flag);
82:
83: DBMS_SQL.PARSE(l_detailcursor,l_sqlstatement,DBMS_SQL.NATIVE);
84: DBMS_SQL.DEFINE_COLUMN_ROWID(l_detailcursor,1,l_detailrowid);
85: l_return := DBMS_SQL.EXECUTE(l_detailcursor);

Line 211: GMA_PURGE_UTILITIES.printlong(p_purge_id,

207:
208: EXCEPTION
209:
210: WHEN OTHERS THEN
211: GMA_PURGE_UTILITIES.printlong(p_purge_id,
212: 'Problem raised in GMA_PURGE_COPY.archiveengine.');
213: GMA_PURGE_UTILITIES.printlong(p_purge_id,
214: 'Unhandled EXCEPTION - ' || sqlerrm);
215: RAISE;

Line 213: GMA_PURGE_UTILITIES.printlong(p_purge_id,

209:
210: WHEN OTHERS THEN
211: GMA_PURGE_UTILITIES.printlong(p_purge_id,
212: 'Problem raised in GMA_PURGE_COPY.archiveengine.');
213: GMA_PURGE_UTILITIES.printlong(p_purge_id,
214: 'Unhandled EXCEPTION - ' || sqlerrm);
215: RAISE;
216:
217: END archiveengine;

Line 233: GMA_PURGE_UTILITIES.printlong(p_purge_id,

229:
230: EXCEPTION
231:
232: WHEN OTHERS THEN
233: GMA_PURGE_UTILITIES.printlong(p_purge_id,
234: 'Problem raised in GMA_PURGE_COPY.docommit.');
235: GMA_PURGE_UTILITIES.printlong(p_purge_id,
236: 'Unhandled EXCEPTION - ' || sqlerrm);
237: RAISE;

Line 235: GMA_PURGE_UTILITIES.printlong(p_purge_id,

231:
232: WHEN OTHERS THEN
233: GMA_PURGE_UTILITIES.printlong(p_purge_id,
234: 'Problem raised in GMA_PURGE_COPY.docommit.');
235: GMA_PURGE_UTILITIES.printlong(p_purge_id,
236: 'Unhandled EXCEPTION - ' || sqlerrm);
237: RAISE;
238:
239: END docommit;