DBA Data[Home] [Help]

APPS.GMA_PURGE_COPY dependencies on GMA_PURGE_COPY

Line 1: PACKAGE BODY GMA_PURGE_COPY AS

1: PACKAGE BODY GMA_PURGE_COPY AS
2: /* $Header: GMAPRGCB.pls 120.2.12010000.2 2008/11/11 20:55:18 srpuri ship $ */
3:
4: g_copycursor INTEGER;
5:

Line 145: GMA_PURGE_COPY.docommit(p_purge_id,l_transcount);

141:
142: -- check to see if we need to do commit
143: l_transcount := l_transcount + 1;
144: IF (l_transcount >= p_commitfrequency) THEN
145: GMA_PURGE_COPY.docommit(p_purge_id,l_transcount);
146: END IF;
147:
148: END LOOP; -- detail rows
149:

Line 176: GMA_PURGE_COPY.docommit(p_purge_id,l_transcount);

172:
173: -- check to see if we need to do commit
174: l_transcount := l_transcount + 1;
175: IF (l_transcount >= p_commitfrequency) THEN
176: GMA_PURGE_COPY.docommit(p_purge_id,l_transcount);
177: END IF;
178:
179: END LOOP; -- detail rows
180:

Line 184: GMA_PURGE_COPY.docommit(p_purge_id,l_transcount);

180:
181: END IF;
182:
183: -- logical unit of work commit
184: GMA_PURGE_COPY.docommit(p_purge_id,l_transcount);
185:
186: END LOOP; -- table loop
187:
188: -- close 'em up, turn off the lights

Line 212: 'Problem raised in GMA_PURGE_COPY.archiveengine.');

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;
216:

Line 234: 'Problem raised in GMA_PURGE_COPY.docommit.');

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;
238:

Line 241: END GMA_PURGE_COPY;

237: RAISE;
238:
239: END docommit;
240:
241: END GMA_PURGE_COPY;