APPS.AS_TAP_PURGE_PUB dependencies on AS_TERRITORY_ACCESSES

Line 14: SELECT /*+ INDEX_FFS(AS_TERRITORY_ACCESSES AS_TERRITORY_ACCESSES_U1) parallel_index(AS_TERRITORY_ACCESSES,AS_TERRITORY_ACCESSES_U1,5) parallel(AS_ACCESSES_U1,5) */

10: p_debug_mode IN VARCHAR2,
11: p_trace_mode IN VARCHAR2
12: ) IS
13: CURSOR c_get_corrupt IS
14: SELECT /*+ INDEX_FFS(AS_TERRITORY_ACCESSES AS_TERRITORY_ACCESSES_U1) parallel_index(AS_TERRITORY_ACCESSES,AS_TERRITORY_ACCESSES_U1,5) parallel(AS_ACCESSES_U1,5) */
15: rowid,access_id
16: from AS_TERRITORY_ACCESSES
17: where not exists
18: (select 1

Line 16: from AS_TERRITORY_ACCESSES

12: ) IS
13: CURSOR c_get_corrupt IS
14: SELECT /*+ INDEX_FFS(AS_TERRITORY_ACCESSES AS_TERRITORY_ACCESSES_U1) parallel_index(AS_TERRITORY_ACCESSES,AS_TERRITORY_ACCESSES_U1,5) parallel(AS_ACCESSES_U1,5) */
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)

Line 20: where AS_TERRITORY_ACCESSES.access_id = acc.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)
24: parallel(AS_ACCESSES_U1,5) */

Line 22: SELECT /*+ INDEX_FFS(AS_TERRITORY_ACCESSES AS_TERRITORY_ACCESSES_U1)

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)
24: parallel(AS_ACCESSES_U1,5) */
25: rowid,access_id
26: from AS_TERRITORY_ACCESSES

Line 23: parallel_index(AS_TERRITORY_ACCESSES,AS_TERRITORY_ACCESSES_U1,5)

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)
24: parallel(AS_ACCESSES_U1,5) */
25: rowid,access_id
26: from AS_TERRITORY_ACCESSES
27: where not exists

Line 26: from AS_TERRITORY_ACCESSES

22: SELECT /*+ INDEX_FFS(AS_TERRITORY_ACCESSES AS_TERRITORY_ACCESSES_U1)
23: parallel_index(AS_TERRITORY_ACCESSES,AS_TERRITORY_ACCESSES_U1,5)
24: parallel(AS_ACCESSES_U1,5) */
25: rowid,access_id
26: from AS_TERRITORY_ACCESSES
27: where not exists
28: (select 1
29: from JTF_TERR_ALL terr
30: where AS_TERRITORY_ACCESSES.TERRITORY_ID = terr.TERR_ID

Line 30: where AS_TERRITORY_ACCESSES.TERRITORY_ID = terr.TERR_ID

26: from AS_TERRITORY_ACCESSES
27: where not exists
28: (select 1
29: from JTF_TERR_ALL terr
30: where AS_TERRITORY_ACCESSES.TERRITORY_ID = terr.TERR_ID
31: and sysdate between terr.start_date_active and
32: terr.end_date_active) ;
33:
34: TYPE TBL_ROWID_TYPE IS TABLE OF VARCHAR2(2000);

Line 108: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || l_prg_name || 'Deleting corrupted data in AS_TERRITORY_ACCESSES');

104: l_limit_flag := TRUE;
105: END IF;
106:
107: -- Delete from tables
108: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || l_prg_name || 'Deleting corrupted data in AS_TERRITORY_ACCESSES');
109: IF l_terracc_rec.access_id.count > 0 THEN
110: l_flag := TRUE;
111: l_first := l_terracc_rec.access_id.first;
112: l_last := l_first + G_NUM_REC;

Line 122: DELETE FROM AS_TERRITORY_ACCESSES

118: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || l_prg_name || 'Records to be deleted: ' ||
119: l_terracc_rec.access_id.first || '-'
120: || l_terracc_rec.access_id.last);
121: FORALL i in l_first..l_last
122: DELETE FROM AS_TERRITORY_ACCESSES
123: WHERE rowid = l_terracc_rec.tbl_rowid(i);
124: COMMIT;
125: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || l_prg_name|| 'Records deleted: ' || l_first ||'-'|| l_last);
126: l_first := l_last + 1;

Line 362: DELETE /*+ index(TERRACC AS_TERRITORY_ACCESSES_u1) */

358: RETURNING access_id BULK COLLECT INTO l_acc_rec1.access_id;
359: COMMIT;
360:
361: FORALL j in l_first..l_last
362: DELETE /*+ index(TERRACC AS_TERRITORY_ACCESSES_u1) */
363: FROM AS_TERRITORY_ACCESSES TERRACC
364: WHERE TERRACC.access_id = l_acc_rec1.access_id(j);
365: COMMIT;
366:

Line 363: FROM AS_TERRITORY_ACCESSES TERRACC

359: COMMIT;
360:
361: FORALL j in l_first..l_last
362: DELETE /*+ index(TERRACC AS_TERRITORY_ACCESSES_u1) */
363: FROM AS_TERRITORY_ACCESSES TERRACC
364: WHERE TERRACC.access_id = l_acc_rec1.access_id(j);
365: COMMIT;
366:
367: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || l_pkg_name ||