APPS.AS_GAR_ACCOUNTS_PUB dependencies on AS_TERRITORY_ACCESSES

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

1327: /*-------------------------------------------------------------------------+
1328: | PROGRAM LOGIC
1329: |
1330: | Re-Initialize variables and null out if necessary.
1331: | Almost the same as accesses, except the insertion is into as_territory_accesses
1332: | and there is no involvement of role.
1333: |
1334: +-------------------------------------------------------------------------*/
1335: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_START);

Line 1371: INSERT INTO AS_TERRITORY_ACCESSES

1367: END IF;
1368: BEGIN
1369: 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);
1370: FORALL i IN l_first .. l_last
1371: INSERT INTO AS_TERRITORY_ACCESSES
1372: ( access_id,
1373: territory_id,
1374: user_territory_id,
1375: last_update_date,

Line 1410: FROM AS_TERRITORY_ACCESSES AST

1406: AND A.sales_lead_id IS NULL
1407: AND A.lead_id IS NULL
1408: AND NOT EXISTS
1409: (SELECT 'X'
1410: FROM AS_TERRITORY_ACCESSES AST
1411: WHERE AST.access_id = A.access_id
1412: AND AST.territory_id = l_terr_id(i))
1413: ) V
1414: );

Line 1422: INSERT INTO AS_TERRITORY_ACCESSES

1418: WHEN DUP_VAL_ON_INDEX THEN
1419: 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);
1420: FOR i IN l_first .. l_last LOOP
1421: BEGIN
1422: INSERT INTO AS_TERRITORY_ACCESSES
1423: ( access_id,
1424: territory_id,
1425: user_territory_id,
1426: last_update_date,

Line 1461: FROM AS_TERRITORY_ACCESSES AST

1457: AND A.sales_lead_id is NULL
1458: AND A.lead_id is NULL
1459: AND NOT EXISTS
1460: (SELECT 'X'
1461: FROM AS_TERRITORY_ACCESSES AST
1462: WHERE AST.access_id = A.access_id
1463: AND AST.territory_id = l_terr_id(i))
1464: ) V
1465: );

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

2073: /*-------------------------------------------------------------------------+
2074: | PROGRAM LOGIC
2075: |
2076: | Re-Initialize variables and null out if necessary.
2077: | Almost the same as accesses, except the insertion is into as_territory_accesses
2078: | and there is no involvement of role.
2079: |
2080: +-------------------------------------------------------------------------*/
2081: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || 'PRM::' || AS_GAR.G_START);

Line 2117: INSERT INTO AS_TERRITORY_ACCESSES

2113: END IF;
2114: BEGIN
2115: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || 'PRM::' || AS_GAR.G_BULK_INS || AS_GAR.G_N_ROWS_PROCESSED ||l_first||' - '||l_last);
2116: FORALL i IN l_first .. l_last
2117: INSERT INTO AS_TERRITORY_ACCESSES
2118: ( access_id,
2119: territory_id,
2120: user_territory_id,
2121: last_update_date,

Line 2157: FROM AS_TERRITORY_ACCESSES AST

2153: AND A.sales_lead_id is NULL
2154: AND A.lead_id is NULL
2155: AND NOT EXISTS
2156: (SELECT 'X'
2157: FROM AS_TERRITORY_ACCESSES AST
2158: WHERE AST.access_id = A.access_id
2159: AND AST.territory_id = l_terr_id(i))
2160: ) V
2161: );

Line 2169: INSERT INTO AS_TERRITORY_ACCESSES

2165: WHEN DUP_VAL_ON_INDEX THEN
2166: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || 'PRM::' || AS_GAR.G_IND_INS || AS_GAR.G_N_ROWS_PROCESSED ||l_first||' - '||l_last);
2167: FOR i IN l_first .. l_last LOOP
2168: BEGIN
2169: INSERT INTO AS_TERRITORY_ACCESSES
2170: ( access_id,
2171: territory_id,
2172: user_territory_id,
2173: last_update_date,

Line 2209: FROM AS_TERRITORY_ACCESSES AST

2205: AND A.sales_lead_id is NULL
2206: AND A.lead_id is NULL
2207: AND NOT EXISTS
2208: (SELECT 'X'
2209: FROM AS_TERRITORY_ACCESSES AST
2210: WHERE AST.access_id = A.access_id
2211: AND AST.territory_id = l_terr_id(i))
2212: ) V
2213: );