APPS.AS_OPP_HEADER_PVT dependencies on AS_ACCESSES_ALL

Line 608: from as_accesses_all

604: IS
605:
606: CURSOR c_acc IS
607: select lead_id, salesforce_id, sales_group_id
608: from as_accesses_all
609: where access_id = p_access_id;
610:
611: BEGIN
612: FOR acr IN c_acc LOOP

Line 614: UPDATE AS_ACCESSES_ALL

610:
611: BEGIN
612: FOR acr IN c_acc LOOP
613:
614: UPDATE AS_ACCESSES_ALL
615: SET object_version_number = nvl(object_version_number,0) + 1, OWNER_FLAG = 'Y'
616: WHERE ACCESS_ID = p_access_id;
617:
618: UPDATE AS_LEADS_ALL

Line 2172: update as_accesses_all

2168: (l_header_rec.owner_salesforce_id <> FND_API.G_MISS_NUM ) AND
2169: (l_header_rec.owner_sales_group_id IS NOT NULL) AND
2170: (l_header_rec.owner_sales_group_id <> FND_API.G_MISS_NUM )
2171: THEN
2172: update as_accesses_all
2173: set object_version_number = nvl(object_version_number,0) + 1, owner_flag = null,
2174: last_update_date = SYSDATE,
2175: last_updated_by = FND_GLOBAL.USER_ID,
2176: last_update_login = FND_GLOBAL.CONC_LOGIN_ID

Line 2179: update as_accesses_all

2175: last_updated_by = FND_GLOBAL.USER_ID,
2176: last_update_login = FND_GLOBAL.CONC_LOGIN_ID
2177: where lead_id = l_Header_rec.lead_id;
2178:
2179: update as_accesses_all
2180: set object_version_number = nvl(object_version_number,0) + 1, owner_flag = 'Y',
2181: freeze_flag = 'Y',
2182: team_leader_flag = 'Y', -- Fix for bug# 4196657
2183: last_update_date = SYSDATE,

Line 2188: from as_accesses_all

2184: last_updated_by = FND_GLOBAL.USER_ID,
2185: last_update_login = FND_GLOBAL.CONC_LOGIN_ID
2186: where access_id in
2187: ( select min(access_id)
2188: from as_accesses_all
2189: where lead_id = l_Header_rec.lead_id
2190: and sales_group_id = l_header_rec.owner_sales_group_id
2191: and salesforce_id = l_header_rec.owner_salesforce_id );
2192:

Line 2251: UPDATE AS_ACCESSES_ALL

2247: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2248: RAISE FND_API.G_EXC_ERROR;
2249: END IF;
2250:
2251: UPDATE AS_ACCESSES_ALL
2252: SET object_version_number = nvl(object_version_number,0) + 1, OWNER_FLAG = 'Y'
2253: WHERE access_id = l_access_id;
2254:
2255: END IF; -- NOTFOUND

Line 2260: update as_accesses_all

2256:
2257: ELSIF (l_header_rec.owner_salesforce_id IS NULL) AND
2258: (l_header_rec.owner_sales_group_id IS NULL) THEN
2259:
2260: update as_accesses_all
2261: set object_version_number = nvl(object_version_number,0) + 1, owner_flag = null,
2262: last_update_date = SYSDATE,
2263: last_updated_by = FND_GLOBAL.USER_ID,
2264: last_update_login = FND_GLOBAL.CONC_LOGIN_ID