APPS.AS_TAP_PURGE_PUB dependencies on AS_TAP_PURGE_WORKING

Line 213: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || l_pkg_name || 'TRUNCATE TABLE AS_TAP_PURGE_WORKING');

209: BEGIN
210:
211: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || l_pkg_name || AS_GAR.G_START);
212:
213: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || l_pkg_name || 'TRUNCATE TABLE AS_TAP_PURGE_WORKING');
214:
215: l_schema_return := FND_INSTALLATION.get_app_info('AS', l_fnd_status, l_industry, l_oracle_schema);
216:
217: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_oracle_schema||'.AS_TAP_PURGE_WORKING';

Line 217: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_oracle_schema||'.AS_TAP_PURGE_WORKING';

213: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || l_pkg_name || 'TRUNCATE TABLE AS_TAP_PURGE_WORKING');
214:
215: l_schema_return := FND_INSTALLATION.get_app_info('AS', l_fnd_status, l_industry, l_oracle_schema);
216:
217: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_oracle_schema||'.AS_TAP_PURGE_WORKING';
218:
219: --
220: -- Populate the working table
221: --

Line 235: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || l_pkg_name || 'Inseting into AS_TAP_PURGE_WORKING');

231: l_ActualWorker := CEIL(P_Count/l_WorkerLoad);
232: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || l_pkg_name || 'ActualWorker: '||l_ActualWorker);
233:
234:
235: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || l_pkg_name || 'Inseting into AS_TAP_PURGE_WORKING');
236:
237: commit;
238: EXECUTE IMMEDIATE 'alter session enable parallel dml';
239:

Line 240: stmt := 'INSERT /*+ append parallel(i) */ INTO as_tap_purge_working i

236:
237: commit;
238: EXECUTE IMMEDIATE 'alter session enable parallel dml';
239:
240: stmt := 'INSERT /*+ append parallel(i) */ INTO as_tap_purge_working i
241: (ROW_ID,
242: WORKER_ID,
243: LAST_UPDATE_DATE,
244: LAST_UPDATED_BY,

Line 275: from as_tap_purge_working

271: p_worker_id IN NUMBER )
272: IS
273: CURSOR c_get_del_access (c_worker_id number) IS
274: select row_id
275: from as_tap_purge_working
276: where worker_id = c_worker_id;
277:
278: TYPE ACC_NUM_TYPE IS TABLE OF rowid;
279: TYPE ACC_REC_TYPE IS RECORD ( access_id ACC_NUM_TYPE);