APPS.AS_GAR_OPPTYS_PUB dependencies on AS_TERRITORY_ACCESSES

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

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

Line 1252: INSERT INTO AS_TERRITORY_ACCESSES

1248: END IF;
1249: BEGIN
1250: 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);
1251: FORALL i IN l_first .. l_last
1252: INSERT INTO AS_TERRITORY_ACCESSES
1253: ( access_id,
1254: territory_id,
1255: user_territory_id,
1256: last_update_date,

Line 1291: FROM AS_TERRITORY_ACCESSES AST

1287: AND A.delete_flag IS NULL
1288: AND A.lead_id is NOT NULL
1289: AND NOT EXISTS
1290: (SELECT 'X'
1291: FROM AS_TERRITORY_ACCESSES AST
1292: WHERE AST.access_id = A.access_id
1293: AND AST.territory_id = l_terr_id(i))
1294: ) V
1295: );

Line 1303: INSERT INTO AS_TERRITORY_ACCESSES

1299: WHEN DUP_VAL_ON_INDEX THEN
1300: 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);
1301: FOR i IN l_first .. l_last LOOP
1302: BEGIN
1303: INSERT INTO AS_TERRITORY_ACCESSES
1304: ( access_id,
1305: territory_id,
1306: user_territory_id,
1307: last_update_date,

Line 1342: FROM AS_TERRITORY_ACCESSES AST

1338: AND A.lead_id is NOT NULL
1339: AND A.delete_flag IS NULL
1340: AND NOT EXISTS
1341: (SELECT 'X'
1342: FROM AS_TERRITORY_ACCESSES AST
1343: WHERE AST.access_id = A.access_id
1344: AND AST.territory_id = l_terr_id(i))
1345: ) V
1346: );