DBA Data[Home] [Help]

APPS.AS_GAR_QOT_PUB dependencies on AS_TERRITORY_ACCESSES

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

1298: /*-------------------------------------------------------------------------+
1299: | PROGRAM LOGIC
1300: |
1301: | Re-Initialize variables and null out if necessary.
1302: | Almost the same as accesses, except the insertion is into as_territory_accesses
1303: | and there is no involvement of role.
1304: |
1305: +-------------------------------------------------------------------------*/
1306: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_START);

Line 1387: INSERT INTO AS_TERRITORY_ACCESSES

1383: WHEN DUP_VAL_ON_INDEX THEN
1384: 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);
1385: FOR i IN l_first .. l_last LOOP
1386: BEGIN
1387: INSERT INTO AS_TERRITORY_ACCESSES
1388: ( access_id,
1389: territory_id,
1390: user_territory_id,
1391: last_update_date,