[Home] [Help]
1103: /*-------------------------------------------------------------------------+
1104: | PROGRAM LOGIC
1105: |
1106: | Re-Initialize variables and null out if necessary.
1107: | Almost the same as accesses, except the insertion is into prp_territory_accesses
1108: | and there is no involvement of role.
1109: |
1110: +-------------------------------------------------------------------------*/
1111: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_START);
1143: END IF;
1144: BEGIN
1145: 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);
1146: FORALL i IN l_first .. l_last
1147: INSERT INTO PRP_TERRITORY_ACCESSES
1148: ( proposal_access_id
1149: ,territory_id
1150: ,object_version_number
1151: ,created_by
1182: AND NVL(A.resource_group_id,-777)=NVL(l_resource_group_id(i),-777)
1183: AND A.resource_id=l_resource_id(i)
1184: AND NOT EXISTS
1185: (SELECT 'X'
1186: FROM PRP_TERRITORY_ACCESSES AST
1187: WHERE AST.proposal_access_id = A.proposal_access_id
1188: AND AST.territory_id = l_terr_id(i))
1189: ) V
1190: );
1194: WHEN DUP_VAL_ON_INDEX THEN
1195: 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);
1196: FOR i IN l_first .. l_last LOOP
1197: BEGIN
1198: INSERT INTO PRP_TERRITORY_ACCESSES
1199: ( proposal_access_id
1200: ,territory_id
1201: ,object_version_number
1202: ,created_by
1233: AND NVL(A.resource_group_id,-777)=NVL(l_resource_group_id(i),-777)
1234: AND A.resource_id=l_resource_id(i)
1235: AND NOT EXISTS
1236: (SELECT 'X'
1237: FROM PRP_TERRITORY_ACCESSES AST
1238: WHERE AST.proposal_access_id = A.proposal_access_id
1239: AND AST.territory_id = l_terr_id(i))
1240: ) V
1241: );