APPS.AS_GAR_LEADS_PUB dependencies on AS_TERRITORY_ACCESSES

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

1213: /*-------------------------------------------------------------------------+
1214: | PROGRAM LOGIC
1215: |
1216: | Re-Initialize variables and null out if necessary.
1217: | Almost the same as accesses, except the insertion is into as_territory_accesses
1218: | and there is no involvement of role.
1219: |
1220: +-------------------------------------------------------------------------*/
1221: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_START);

Line 1257: INSERT INTO AS_TERRITORY_ACCESSES

1253: END IF;
1254: BEGIN
1255: 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);
1256: FORALL i IN l_first .. l_last
1257: INSERT INTO AS_TERRITORY_ACCESSES
1258: ( access_id,
1259: territory_id,
1260: user_territory_id,
1261: last_update_date,

Line 1296: FROM AS_TERRITORY_ACCESSES AST

1292: AND A.delete_flag IS NULL
1293: AND A.lead_id is NULL
1294: AND NOT EXISTS
1295: (SELECT 'X'
1296: FROM AS_TERRITORY_ACCESSES AST
1297: WHERE AST.access_id = A.access_id
1298: AND AST.territory_id = l_terr_id(i))
1299: ) V
1300: );

Line 1308: INSERT INTO AS_TERRITORY_ACCESSES

1304: WHEN DUP_VAL_ON_INDEX THEN
1305: 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);
1306: FOR i IN l_first .. l_last LOOP
1307: BEGIN
1308: INSERT INTO AS_TERRITORY_ACCESSES
1309: ( access_id,
1310: territory_id,
1311: user_territory_id,
1312: last_update_date,

Line 1347: FROM AS_TERRITORY_ACCESSES AST

1343: AND A.lead_id is NULL
1344: AND A.delete_flag IS NULL
1345: AND NOT EXISTS
1346: (SELECT 'X'
1347: FROM AS_TERRITORY_ACCESSES AST
1348: WHERE AST.access_id = A.access_id
1349: AND AST.territory_id = l_terr_id(i))
1350: ) V
1351: );