5150: IF x_access_profile_rec.opp_access_profile_value IS NULL OR
5151: x_access_profile_rec.opp_access_profile_value = FND_API.G_MISS_CHAR
5152: THEN
5153: x_access_profile_rec.opp_access_profile_value
5154: := FND_PROFILE.Value('AS_OPP_ACCESS');
5155: END IF;
5156:
5157: IF x_access_profile_rec.lead_access_profile_value IS NULL OR
5158: x_access_profile_rec.lead_access_profile_value = FND_API.G_MISS_CHAR
5157: IF x_access_profile_rec.lead_access_profile_value IS NULL OR
5158: x_access_profile_rec.lead_access_profile_value = FND_API.G_MISS_CHAR
5159: THEN
5160: x_access_profile_rec.lead_access_profile_value
5161: := FND_PROFILE.Value('AS_LEAD_ACCESS');
5162: END IF;
5163:
5164: IF x_access_profile_rec.cust_access_profile_value IS NULL OR
5165: x_access_profile_rec.cust_access_profile_value = FND_API.G_MISS_CHAR
5164: IF x_access_profile_rec.cust_access_profile_value IS NULL OR
5165: x_access_profile_rec.cust_access_profile_value = FND_API.G_MISS_CHAR
5166: THEN
5167: x_access_profile_rec.cust_access_profile_value
5168: := FND_PROFILE.Value('AS_CUST_ACCESS');
5169: END IF;
5170:
5171: IF x_access_profile_rec.mgr_update_profile_value IS NULL OR
5172: x_access_profile_rec.mgr_update_profile_value = FND_API.G_MISS_CHAR
5171: IF x_access_profile_rec.mgr_update_profile_value IS NULL OR
5172: x_access_profile_rec.mgr_update_profile_value = FND_API.G_MISS_CHAR
5173: THEN
5174: x_access_profile_rec.mgr_update_profile_value
5175: := FND_PROFILE.Value('AS_MGR_UPDATE');
5176: END IF;
5177:
5178: IF x_access_profile_rec.admin_update_profile_value IS NULL OR
5179: x_access_profile_rec.admin_update_profile_value = FND_API.G_MISS_CHAR
5178: IF x_access_profile_rec.admin_update_profile_value IS NULL OR
5179: x_access_profile_rec.admin_update_profile_value = FND_API.G_MISS_CHAR
5180: THEN
5181: x_access_profile_rec.admin_update_profile_value
5182: := FND_PROFILE.Value('AS_ADMIN_UPDATE');
5183: END IF;
5184:
5185: END Get_Access_Profiles;
5186:
5203: ELSE
5204: NULL;
5205: END IF;
5206: END LOOP;
5207: RETURN FND_PROFILE.Value(p_profile_name);
5208: END;
5209:
5210: End AS_OPPORTUNITY_PUB;