APPS.AS_GAR_LEADS_PUB dependencies on AS_TERRITORY_ACCESSES

Line 1258: | Almost the same as accesses, except the insertion is into as_territory_accesses

1254: /*-------------------------------------------------------------------------+
1255: | PROGRAM LOGIC
1256: |
1257: | Re-Initialize variables and null out if necessary.
1258: | Almost the same as accesses, except the insertion is into as_territory_accesses
1259: | and there is no involvement of role.
1260: |
1261: +-------------------------------------------------------------------------*/
1262: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_START);

Line 1298: INSERT INTO AS_TERRITORY_ACCESSES

1294: END IF;
1295: BEGIN
1296: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_BULK_INS || AS_GAR.G_N_ROWS_PROCESSED ||l_first||' - '||l_last);
1297: FORALL i IN l_first .. l_last
1298: INSERT INTO AS_TERRITORY_ACCESSES
1299: ( access_id,
1300: territory_id,
1301: user_territory_id,
1302: last_update_date,

Line 1337: FROM AS_TERRITORY_ACCESSES AST

1333: AND A.delete_flag IS NULL
1334: AND A.lead_id is NULL
1335: AND NOT EXISTS
1336: (SELECT 'X'
1337: FROM AS_TERRITORY_ACCESSES AST
1338: WHERE AST.access_id = A.access_id
1339: AND AST.territory_id = l_terr_id(i))
1340: ) V
1341: );

Line 1349: INSERT INTO AS_TERRITORY_ACCESSES

1345: WHEN DUP_VAL_ON_INDEX THEN
1346: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_IND_INS || AS_GAR.G_N_ROWS_PROCESSED ||l_first||' - '||l_last);
1347: FOR i IN l_first .. l_last LOOP
1348: BEGIN
1349: INSERT INTO AS_TERRITORY_ACCESSES
1350: ( access_id,
1351: territory_id,
1352: user_territory_id,
1353: last_update_date,

Line 1388: FROM AS_TERRITORY_ACCESSES AST

1384: AND A.lead_id is NULL
1385: AND A.delete_flag IS NULL
1386: AND NOT EXISTS
1387: (SELECT 'X'
1388: FROM AS_TERRITORY_ACCESSES AST
1389: WHERE AST.access_id = A.access_id
1390: AND AST.territory_id = l_terr_id(i))
1391: ) V
1392: );