APPS.AS_RTTAP_OPPTY dependencies on AS_ACCESSES_ALL

Line 266: -- Reset AS_ACCESSES_ALL.open_flag added for bug 5592395

262: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO || AS_GAR.G_RETURN_STATUS || l_return_status);
263:
264: END IF;
265:
266: -- Reset AS_ACCESSES_ALL.open_flag added for bug 5592395
267:
268: UPDATE AS_ACCESSES_ALL acc
269: SET object_version_number = nvl(object_version_number,0) + 1, acc.OPEN_FLAG = 'Y'
270: WHERE acc.LEAD_ID = p_lead_id

Line 268: UPDATE AS_ACCESSES_ALL acc

264: END IF;
265:
266: -- Reset AS_ACCESSES_ALL.open_flag added for bug 5592395
267:
268: UPDATE AS_ACCESSES_ALL acc
269: SET object_version_number = nvl(object_version_number,0) + 1, acc.OPEN_FLAG = 'Y'
270: WHERE acc.LEAD_ID = p_lead_id
271: AND EXISTS
272: (select 1

Line 280: UPDATE AS_ACCESSES_ALL acc

276: and st.status_code = ld.status
277: and ld.lead_id = p_lead_id )
278: AND nvl(acc.OPEN_FLAG, 'N') <> 'Y';
279:
280: UPDATE AS_ACCESSES_ALL acc
281: SET object_version_number = nvl(object_version_number,0) + 1, acc.OPEN_FLAG = 'N'
282: WHERE acc.LEAD_ID = p_lead_id
283: AND NOT EXISTS
284: (select 1

Line 662: UPDATE AS_ACCESSES_ALL_ALL ACC

658: IF p_WinningTerrMember_tbl.resource_id.COUNT > 0 THEN
659: FOR l_index IN p_WinningTerrMember_tbl.resource_id.FIRST..p_WinningTerrMember_tbl.resource_id.LAST LOOP
660: AS_GAR.LOG(G_ENTITY || G_LEAD_ID || '::' || 'RESOURCE/GROUP::' || p_WinningTerrMember_tbl.resource_id(l_index) || '/' || p_WinningTerrMember_tbl.group_id(l_index));
661: IF p_WinningTerrMember_tbl.resource_type(l_index) = 'RS_EMPLOYEE' THEN
662: UPDATE AS_ACCESSES_ALL_ALL ACC
663: SET object_version_number = nvl(object_version_number,0) + 1,
664: ACC.last_update_date = SYSDATE,
665: ACC.last_updated_by = FND_GLOBAL.USER_ID,
666: ACC.last_update_login = FND_GLOBAL.USER_ID,

Line 698: INSERT INTO AS_ACCESSES_ALL

694: FOR l_index IN p_WinningTerrMember_tbl.resource_id.FIRST..p_WinningTerrMember_tbl.resource_id.LAST LOOP
695: IF p_WinningTerrMember_tbl.resource_type(l_index) = 'RS_EMPLOYEE' AND p_WinningTerrMember_tbl.group_id(l_index) IS NOT NULL THEN
696: AS_GAR.LOG(G_ENTITY || G_LEAD_ID || '::' || 'BEFORE INSERT INTO AS_ACCESSED_ALL RESOURCE/GROUP::' || p_WinningTerrMember_tbl.resource_id(l_index)
697: || '/' || p_WinningTerrMember_tbl.group_id(l_index));
698: INSERT INTO AS_ACCESSES_ALL
699: (access_id ,
700: last_update_date ,
701: last_updated_by,
702: creation_date ,

Line 742: ( SELECT NULL FROM AS_ACCESSES_ALL ACC

738: FROM AS_LEADS_ALL LDS, AS_STATUSES_B ST
739: WHERE LDS.status = ST.status_code
740: AND LDS.lead_id = G_LEAD_ID
741: AND NOT EXISTS
742: ( SELECT NULL FROM AS_ACCESSES_ALL ACC
743: WHERE ACC.lead_id = LDS.lead_id
744: AND ACC.salesforce_id = p_WinningTerrMember_tbl.resource_id(l_index)
745: AND ACC.sales_group_id = p_WinningTerrMember_tbl.group_id(l_index) );
746: END IF;

Line 774: FROM AS_ACCESSES_ALL ACC

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);
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

Line 797: FROM AS_ACCESSES_ALL ACC

793: FND_GLOBAL.USER_ID,
794: SYSDATE,
795: FND_GLOBAL.USER_ID,
796: FND_GLOBAL.USER_ID
797: FROM AS_ACCESSES_ALL ACC
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'

Line 826: DELETE FROM AS_ACCESSES_ALL ACC

822:
823: BEGIN
824: x_return_status := FND_API.G_RET_STS_SUCCESS;
825: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_START);
826: DELETE FROM AS_ACCESSES_ALL ACC
827: WHERE lead_id = G_LEAD_ID
828: AND NVL(freeze_flag, 'N') <> 'Y'
829: AND SALESFORCE_ID||SALES_GROUP_ID NOT IN (
830: SELECT RESTAB.RES||GRPTAB.GRP FROM

Line 860: FROM AS_ACCESSES_ALL AAA

856: x_return_status OUT NOCOPY VARCHAR2) IS
857:
858: CURSOR oppty_owner_rt IS
859: SELECT MAX(AAA.access_id) access_id -- /*+ index(aaa as_accesses_n3) */
860: FROM AS_ACCESSES_ALL AAA
861: WHERE AAA.lead_id = G_LEAD_ID
862: AND NVL(AAA.CREATED_BY_TAP_FLAG,'N') = 'Y' ;
863:
864: CURSOR is_owner_set IS

Line 866: FROM AS_ACCESSES_ALL

862: AND NVL(AAA.CREATED_BY_TAP_FLAG,'N') = 'Y' ;
863:
864: CURSOR is_owner_set IS
865: SELECT 'X'
866: FROM AS_ACCESSES_ALL
867: WHERE lead_id = G_LEAD_ID
868: AND owner_flag = 'Y';
869:
870:

Line 907: UPDATE AS_ACCESSES_ALL AAA

903: SCD.owner_salesforce_id = NULL,
904: SCD.owner_sales_group_id = NULL
905: WHERE SCD.lead_id = G_LEAD_ID ;
906: ELSE
907: UPDATE AS_ACCESSES_ALL AAA
908: SET AAA.owner_flag = 'Y',
909: AAA.object_version_number = nvl(AAA.object_version_number,0) + 1,
910: AAA.last_update_date = SYSDATE,
911: AAA.last_updated_by = FND_GLOBAL.USER_ID,