APPS.AS_TAP_PURGE_PUB dependencies on AS_ACCESSES_ALL_ALL

Line 19: from AS_ACCESSES_ALL_ALL acc

15: rowid,access_id
16: from AS_TERRITORY_ACCESSES
17: where not exists
18: (select 1
19: from AS_ACCESSES_ALL_ALL acc
20: where AS_TERRITORY_ACCESSES.access_id = acc.access_id)
21: union
22: SELECT /*+ INDEX_FFS(AS_TERRITORY_ACCESSES AS_TERRITORY_ACCESSES_U1)
23: parallel_index(AS_TERRITORY_ACCESSES,AS_TERRITORY_ACCESSES_U1,5)

Line 142: from AS_ACCESSES_ALL_ALL ABC

138: -- Spawn parallel working ASTPON
139: --
140: -- Prepare for parallel processing
141: select /*+ INDEX_FFS(ABC AS_ACCESSES_U2)*/ count(*) into l_count
142: from AS_ACCESSES_ALL_ALL ABC
143: where delete_flag='Y';
144:
145: l_MinNumParallelProc :=
146: nvl(TO_NUMBER(fnd_profile.value('AS_TERR_MIN_NUM_PARALLEL_PROC')),100);

Line 248: SELECT /*+ PARALLEL_INDEX(AS_ACCESSES_ALL_ALL,5) INDEX_FFS(AS_ACCESSES_ALL_ALL AS_ACCESSES_U2)*/

244: LAST_UPDATED_BY,
245: CREATION_DATE,
246: CREATED_BY,
247: LAST_UPDATE_LOGIN)
248: SELECT /*+ PARALLEL_INDEX(AS_ACCESSES_ALL_ALL,5) INDEX_FFS(AS_ACCESSES_ALL_ALL AS_ACCESSES_U2)*/
249: ROWID,NTILE('||l_ActualWorker||') OVER(ORDER BY ROWID) as workerid, sysdate,
250: :1,
251: sysdate,
252: :2,

Line 254: FROM AS_ACCESSES_ALL_ALL where delete_flag = ''Y''';

250: :1,
251: sysdate,
252: :2,
253: :3
254: FROM AS_ACCESSES_ALL_ALL where delete_flag = ''Y''';
255:
256: EXECUTE IMMEDIATE stmt using NVL(to_number(fnd_profile.value('USER_ID')),0),NVL(to_number(fnd_profile.value('USER_ID')),0),
257: NVL(to_number(fnd_profile.value('CONC_LOGIN_ID')),0);
258: X_ActualWorkersUsed := l_ActualWorker;

Line 339: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || l_pkg_name || '---DELETE FROM AS_ACCESSES_ALL_ALL::START');

335: l_limit_flag := TRUE;
336: END IF;
337:
338: -- Delete from tables
339: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || l_pkg_name || '---DELETE FROM AS_ACCESSES_ALL_ALL::START');
340:
341: IF l_acc_rec.access_id.count > 0 THEN
342: l_flag := TRUE;
343: l_first := l_acc_rec.access_id.first;

Line 356: DELETE FROM AS_ACCESSES_ALL_ALL

352: l_acc_rec.access_id.first || '-'
353: || l_acc_rec.access_id.last);
354:
355: FORALL i in l_first..l_last
356: DELETE FROM AS_ACCESSES_ALL_ALL
357: WHERE rowid = l_acc_rec.access_id(i)
358: RETURNING access_id BULK COLLECT INTO l_acc_rec1.access_id;
359: COMMIT;
360: