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 2171: update as_accesses_all

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

Line 2178: update as_accesses_all

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

Line 2187: from as_accesses_all

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

Line 2250: UPDATE AS_ACCESSES_ALL

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

Line 2259: update as_accesses_all

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