[Home] [Help]
762: x_return_status OUT NOCOPY VARCHAR2) IS
763: BEGIN
764: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_START);
765: /*------------------------------------------------------------------------------+
766: | we are deleting all rows for the entity from as_territory_accesses prior to
767: | inserting into it because the logic for removing only certain terr_id/access_id
768: | combinations is very complex and could be slow..
769: +-------------------------------------------------------------------------------*/
770: x_return_status := FND_API.G_RET_STS_SUCCESS;
767: | inserting into it because the logic for removing only certain terr_id/access_id
768: | combinations is very complex and could be slow..
769: +-------------------------------------------------------------------------------*/
770: x_return_status := FND_API.G_RET_STS_SUCCESS;
771: DELETE FROM AS_TERRITORY_ACCESSES TACC
772: WHERE TACC.access_id IN
773: (SELECT ACC.access_id
774: FROM AS_ACCESSES_ALL ACC
775: WHERE lead_id = G_LEAD_ID);
775: WHERE lead_id = G_LEAD_ID);
776: IF p_WinningTerrMember_tbl.resource_id.COUNT > 0 THEN
777: FOR l_index IN p_WinningTerrMember_tbl.resource_id.FIRST..p_WinningTerrMember_tbl.resource_id.LAST LOOP
778: IF p_WinningTerrMember_tbl.resource_type(l_index) = 'RS_EMPLOYEE' THEN
779: INSERT INTO AS_TERRITORY_ACCESSES
780: ( access_id,
781: territory_id,
782: user_territory_id,
783: last_update_date,
798: WHERE ACC.lead_id = G_LEAD_ID
799: AND ACC.salesforce_id = p_WinningTerrMember_tbl.resource_id(l_index)
800: AND ACC.sales_group_id = p_WinningTerrMember_tbl.group_id(l_index)
801: AND NOT EXISTS ( SELECT 'Y'
802: FROM AS_TERRITORY_ACCESSES
803: WHERE ACCESS_ID = ACC.access_id
804: AND TERRITORY_ID = p_WinningTerrMember_tbl.terr_id(l_index)) ;
805: END IF;
806: END LOOP;